Skip to Content
avatar image
Former Member

Data server

Hello

I would know if anybody know the encryption algorithm of password field in table XMII_SERVERPROP (root database of MII instance)

I would create a data server connection dynamically and I'm thinking to change the data of a temporary connection in this table on the fly.

Is this the right/only possible way or not?

Thank you a lot

Best regards.

Fabio

ps: I'm using MII 12.2 sp5

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 30, 2013 at 09:23 AM

    Hi Fabio,

    This is not a valid and good approach to follow.

    MII caches the data server details and only updates the cache when you update the details in the data server screen or if the server is restarted. That means the changes done in the DB Table will not trigger the cache updation.

    I tried this:

    I created a PCo Server and saved it. Now the entries for the server details got saved in the XMII_SERVERPROP table. Server is in Green state.

    Now I updated this PCo server details in the XMII_SERVERPROP table and now the status of the server should be red as I gave a wrong URL for the PCo server.

    But still the server was in green state though in the server details section of the data server screen it was reflecting the changes I had manually done in the data server details.

    Regards,

    Rutika

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Jeremy Good

      Hello

      My goal should be to write a fixed query and to change on the fly target database (server, instance name, username, password).

      My user will write these 4 parameters in a web interface and MII will have to run the quary on the specified SQL Server DB.

      I would prefer to not fix all the possible data servers in MII settings because it requires my support for each change.

      Thank you

      Regards

      Fabio

      PS: As Rutika said, table backdoor doesn't work properly 😭