ispconfig and mysql

Discussion in 'Installation/Configuration' started by sefokuma, May 30, 2007.

  1. sefokuma

    sefokuma New Member

    Hi, i´ve a ispconfig server running ok but i want use other sever for mysql server. When i try change the config (db_host) from localhost to new_mysql_server I recive an error and cant login, in the new server i have the same database copied and runs with the same permissions.

    I have could see that when i try restart ispconfig service this launch the next error, but the system starts.

    error:

    Code:
    Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /root/ispconfig/scripts/lib/config.inc.php on line 47
    No results found!ISPConfig system is now up and running!
    
    I have only edit the file /home/admispconfig/ispconfig/lib/config.inc.php, switching in the line 87 localhost to new_mysql_server.

    Thx, bye.
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    are you able to login in the ISPConfig interface?
     
  3. sefokuma

    sefokuma New Member

    Yes i have running ispconfig on port 81 with https ok, and load login.php but when i try to login with the user and password corrects i recive ERROR 101.

    Some idea?
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    Ok, in this case the login data to the mysql database is not correct or the database is empty or ISPConfig has no permissions to read the data.
     
  5. sefokuma

    sefokuma New Member

    OMG, mate i forgot a simple GRANT ALL. Sorry but this noob post lol.

    Thx
     

Share This Page