Community
    • Categories
    • Recent
    • Popular
    • Users
    • Search
    • Register
    • Login
    1. Home
    2. dkirsten
    3. Controversial
    Offline
    • Profile
    • Following 0
    • Followers 1
    • Topics 6
    • Posts 388
    • Groups 3

    Posts

    Recent Best Controversial
    • RE: Change i-doit database passwords

      Hi,

      what you have to do is the following (in this order!):

      • Go to the i-doit admin center and navigate to tenants. Write down the username for each tenant in the Mysql section. Change the password for each MySQL user in the admin center GUI.

      • Open a mysql client and change the MySQL password for the users that you just identified (matching the passwords you entered in the admin center). Don't forget to commit a 'flush privileges;' command.

      • Try to login to i-doit. If you can still login, go on and change the system user password.

      • Open the file /[idoit_webroot]/src/config.inc.php and look at the
                $g_db_system = array(
                …
                "user" => "xxx",
                "pass" => "yyy
                ...
        part. Change the password to a new password in the file and save it.

        • Open a mysql client and change the MySQL password for the user mentioned in the config.inc.php file. Don't forget to commit a 'flush privileges;' command.

        • Login to i-doit

        Additional expert hint: The tenant database passwords are set in the 'idoit_system' database in table 'isys_mandator'.

      posted in Operating
      dkirstenD
      dkirsten