empty ispconfdb after install

Discussion in 'Installation/Configuration' started by bwrob, Dec 2, 2006.

  1. bwrob

    bwrob New Member

    Centos4.4.2 Mysql5.0.22 php5.1.6
    At the end of installation i get this message:
    Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /root/ispconfig/scripts/lib/config.inc.php on line 47
    Connected successfully to MySQL server Es ist schon eine Datenbank mit dem Namen ispconfdb vorhanden!
    But, database is empty.
    Can connect no prob. from shell using same settings to ispconfdb.
    Reloaded it using shell>mysql -uxxxx -pxxxx ispconfdb < db_ispconfig.sql. phpMyAdmin works fine with it.
    But, after login in it wont save server settings.
    Therefore I cannot set any server settings like email to Maildir etc.
    Any idea.
    Last edited: Dec 2, 2006
  2. bwrob

    bwrob New Member

    Got it working.
    Using phpMyadmin i inserted in isp_server table several fields
    using example from my other server and it is working.
  3. till

    till Super Moderator Staff Member ISPConfig Developer

    You might be getting problems later! I recommend that you reinstall ISPConfig if you want to use this system as production server. the error with the empty database only happens when you 1) created a database with the same name before you installed ISPConfig or 2) you used a mysql user that had not the same priveliges as the mysql root user.
  4. gvanlee

    gvanlee New Member

    Other reason for failure

    This problem of an empty database also occurs when the mysql root password contains a special character, like &.

    Logging into the server fails, probably because the password on the command line is not surrounded by quotes.

    Since the rest of the install went flawlessly, is there a way to manually create the database? Or do I really have to sit through another 30 mins of waiting? ;)
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    No, you can not create the database manually because the installer inserts values gathered during installation.

Share This Page