After update to latest SVN 5678 Database Schema Installer / Updater Error



  • Database Schema Installer / Updater

    Database Schema Installer / Updater
    Your database connection appears to be invalid. FOG is unable to communicate with the database. There are many reasons why this could be the case. Please check your credentials in /var/www/html/fog/lib/fog/config.class.php. Also confirm that the database is indeed running. If credentials are correct, and the Database service is running, check to ensure your filesystem has enough space.

    (68GB free space, permission ok, database running)

    CentOS Linux release 7.2.1511
    0_1465973590675_error_log


  • Senior Developer

    @plegrand Posted to the other posting. Should be good in latest.



  • Hello
    same problem here upgraded from 7981 to 8120
    0_1466060042303_Sans titre.png

    I made the change into /var/www/html/fog/lib/fog/config.class.php without success
    what i have to do ?

    I dont know if it’s the same problem but just after “installfog.sh” i’ve got this error message :
    cat: /home/svn/trunk/bin/goodInterface.txt: Aucun fichier ou dossier de ce type

    thanks for your help


  • Senior Developer

    @billgatesuncle besides the workaround this should be fixed in latest.



  • @Quazz Thanks, this solved the problem completely.


  • Senior Developer

    @Quazz Possibly, yes. I’m trying to rework the way these things get specified. Currently in 4 million lines of code lol.


  • Moderator

    @Tom-Elliott I think the issue can be traced to /opt/fog/.fogsettings , so upgrades only I’d say.

    snmysqluser and snmysqlhost being empty values there didn’t use to cause issues, but I’m guessing they do now?



  • @Quazz it’s CORRECT.

    Thank you so much.


  • Senior Developer

    Does this ONLY occur on updates or fresh install?

    I cannot seem to replicate.


  • Moderator

    Problem is that in /var/www/html/fog/lib/fog/config.class.php host and user are not defined.

    Fill in localhost for host and root for user, save the file and it should work as expected.

    So change

     private static function db_settings() {
            define('DATABASE_TYPE','mysql'); // mysql or oracle
            define('DATABASE_HOST','');
            define('DATABASE_NAME','fog');
            define('DATABASE_USERNAME','');
            define('DATABASE_PASSWORD',"");
    

    to

     private static function db_settings() {
            define('DATABASE_TYPE','mysql'); // mysql or oracle
            define('DATABASE_HOST','localhost');
            define('DATABASE_NAME','fog');
            define('DATABASE_USERNAME','root');
            define('DATABASE_PASSWORD',"");
    

    Fill in password if you have one defined for your mysql of course.


  • Moderator

    Same here. After restarting the mysql service, I know get part of the upgrade scheme page, but no button for upgrade or anything. Refreshing the page twice leads to fog/management being forbidden.



  • SVN build 5676 Work problem begin with build 5677



  • Me too! I’ve decided to revert to 5674, fortunately it works!

    Debian 8.4
    Trunk 5674


Log in to reply
 

Looks like your connection to FOG Project was lost, please wait while we try to reconnect.