Community
    • Categories
    • Recent
    • Popular
    • Users
    • Search
    • Register
    • Login

    Access Denied for idoit

    Scheduled Pinned Locked Moved Operating
    2 Posts 2 Posters 5.2k Views 1 Watching
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • rickstaplesR Offline
      rickstaples
      last edited by

      I am loading the demo install (have loaded twice) - The autoinstall completes successfully then forwards to idoit-root/index.php and I get this error:

      isys_exception_database : Access denied for user 'idoit'@'localhost' (using password: YES)

      idoit user is set as dba on the server.  I can query database from idoit server and from loacl workstation and I have full rights.

      I do not know where to look to find password in the idoit files but the databse server is fine with the user/pass

      Grants for idoit@%
      GRANT ALL PRIVILEGES ON . TO 'idoit'@'%' IDENTIFIED BY PASSWORD 'C3E77E59B58D282CF2021CD59752359091C4ED51' WITH GRANT OPTION
      GRANT ALL PRIVILEGES ON idoit_system.
      TO 'idoit'@'%'
      GRANT ALL PRIVILEGES ON idoit_data.* TO 'idoit'@'%'
      GRANT SELECT, INSERT, UPDATE, DELETE ON mysql.db TO 'idoit'@'%'
      GRANT SELECT, INSERT, UPDATE, DELETE ON mysql.proc TO 'idoit'@'%'
      GRANT SELECT, INSERT, UPDATE, DELETE ON mysql.event TO 'idoit'@'%'
      GRANT SELECT, INSERT, UPDATE, DELETE ON mysql.tables_priv TO 'idoit'@'%'
      GRANT SELECT, INSERT, UPDATE, DELETE ON mysql.columns_priv TO 'idoit'@'%'
      GRANT SELECT, INSERT, UPDATE, DELETE ON mysql.func TO 'idoit'@'%'
      GRANT SELECT, INSERT, UPDATE, DELETE ON mysql.user TO 'idoit'@'%'
      GRANT SELECT, INSERT, UPDATE, DELETE ON mysql.procs_priv TO 'idoit'@'%'
      GRANT SELECT, INSERT, UPDATE, DELETE ON mysql.host TO 'idoit'@'%'

      1 Reply Last reply Reply Quote 0
      • dsD Offline
        ds
        last edited by

        The databases are configured in src/config.inc.php and in the system database in table isys_mandator

        1 Reply Last reply Reply Quote 0
        • First post
          Last post