• Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login
  • Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login

Database Update/Install Failed!

Scheduled Pinned Locked Moved
FOG Problems
5
14
6.1k
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.
  • O
    Oma Voss
    last edited by Jul 28, 2014, 4:27 PM

    Hi need2,
    rev. 2109 from trunk:
    [url]https://svn.code.sf.net/p/freeghost/code/trunk[/url]

    1 Reply Last reply Reply Quote 0
    • J
      Junkhacker Developer
      last edited by Jul 28, 2014, 4:37 PM

      he was asking what version you had installed before you upgraded to 2109

      signature:
      Junkhacker
      We are here to help you. If you are unresponsive to our questions, don't expect us to be responsive to yours.

      1 Reply Last reply Reply Quote 0
      • O
        Oma Voss
        last edited by Jul 28, 2014, 6:42 PM

        Hi Junkhacker,

        I do not know anymore.
        Maybe I should better remove the trunk by the system and install a stable version. How do I do that?

        Many greetings and thanks.

        1 Reply Last reply Reply Quote 0
        • J
          Junkhacker Developer
          last edited by Jul 28, 2014, 7:00 PM

          did you try tamatech’s suggestion and restart the mysql service?
          it looks like either the mysql service isn’t running, or perhaps the password is incorrect for mysql in the config file (fog/service/etc/config.php)

          signature:
          Junkhacker
          We are here to help you. If you are unresponsive to our questions, don't expect us to be responsive to yours.

          1 Reply Last reply Reply Quote 0
          • J
            Junkhacker Developer
            last edited by Jul 28, 2014, 7:03 PM

            correction [SIZE=13px][FONT=arial][COLOR=#262626]/var/www/fog/lib/fog/Config.class.php[/COLOR][/FONT][/SIZE]

            signature:
            Junkhacker
            We are here to help you. If you are unresponsive to our questions, don't expect us to be responsive to yours.

            1 Reply Last reply Reply Quote 0
            • O
              Oma Voss
              last edited by Jul 28, 2014, 7:59 PM

              guenter@FOG-Server:~$ service mysql restart
              stop: Unbekannter Auftrag: mysql
              start: Unbekannter Auftrag: mysql
              guenter@FOG-Server:~$

              1 Reply Last reply Reply Quote 0
              • O
                Oma Voss
                last edited by Jul 28, 2014, 8:02 PM

                [code]
                <?php
                /**

                • Class Name: Config
                • Initializes default settings.
                • Most notably the sql connection.
                  /
                  class Config
                  {
                  /
                  *
                  • Calls the required functions to define the settings.
                  • method db_settings()
                  • method svc_setting()
                  • method init_setting()
                    /
                    public function __construct()
                    {
                    self::db_settings();
                    self::svc_setting();
                    self::init_setting();
                    }
                    /
                    *
                  • db_settings()
                  • Defines the database settings for FOG
                  • @return void
                    /
                    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’, ‘51d86d’);
                    }
                    /
                    *
                  • svc_setting()
                  • Defines the service settings.
                  • (e.g. FOGMulticastManager,
                  •   FOGScheduler,
                    
                  •   FOGImageReplicator)
                    
                  • @return void
                    /
                    private static function svc_setting()
                    {
                    define( “UDPSENDERPATH”, “/usr/local/sbin/udp-sender” );
                    define( “MULTICASTLOGPATH”, “/opt/fog/log/multicast.log” );
                    define( “MULTICASTDEVICEOUTPUT”, “/dev/tty2” );
                    define( “MULTICASTSLEEPTIME”, 10 );
                    define( “MULTICASTINTERFACE”, “eth0” );
                    define( “UDPSENDER_MAXWAIT”, null );
                    define( “LOGMAXSIZE”, “1000000” );
                    define( “REPLICATORLOGPATH”, “/opt/fog/log/fogreplicator.log” );
                    define( “REPLICATORDEVICEOUTPUT”, “/dev/tty3” );
                    define( “REPLICATORSLEEPTIME”, 600 );
                    define( “REPLICATORIFCONFIG”, “/sbin/ifconfig” );
                    define( “SCHEDULERLOGPATH”, “/opt/fog/log/fogscheduler.log” );
                    define( “SCHEDULERDEVICEOUTPUT”, “/dev/tty4” );
                    define( “SCHEDULERSLEEPTIME”, 60 );
                    }
                    /
                    *
                  • init_setting()
                  • Initial values if fresh install are set here
                  • NOTE: These values are only used on initial
                  • installation to set the database values.
                  • If this is an upgrade, they do not change
                  • the values within the Database.
                  • Please use FOG Configuration->FOG Settings
                  • to change these values after everything is
                  • setup.
                  • @return void
                    */
                    private static function init_setting()
                    {
                    define(‘TFTP_HOST’, “192.168.115.20”);
                    define(‘TFTP_FTP_USERNAME’, “fog”);
                    define(‘TFTP_FTP_PASSWORD’, “password”);
                    define(‘TFTP_PXE_KERNEL_DIR’, ‘/var/www/fog/service/ipxe/’);
                    define(‘PXE_KERNEL’, ‘bzImage’);
                    define(‘PXE_KERNEL_RAMDISK’,127000);
                    define(‘USE_SLOPPY_NAME_LOOKUPS’,true);
                    define(‘MEMTEST_KERNEL’, ‘memtest.bin’);
                    define(‘PXE_IMAGE’, ‘init.xz’);
                    define(‘PXE_IMAGE_DNSADDRESS’, “192.168.115.5”);
                    define(‘STORAGE_HOST’, “192.168.115.20”);
                    define(‘STORAGE_FTP_USERNAME’, “fog”);
                    define(‘STORAGE_FTP_PASSWORD’, “password”);
                    define(‘STORAGE_DATADIR’, ‘/images/’);
                    define(‘STORAGE_DATADIR_UPLOAD’, ‘/images/dev/’);
                    define(‘STORAGE_BANDWIDTHPATH’, ‘/fog/status/bandwidth.php’);
                    define(‘UPLOADRESIZEPCT’,5);
                    define(‘WEB_HOST’, “192.168.115.20”);
                    define(‘WOL_HOST’, “192.168.115.20”);
                    define(‘WOL_PATH’, ‘/fog/wol/wol.php’);
                    define(‘WOL_INTERFACE’, “eth0”);
                    define(‘SNAPINDIR’, “/opt/fog/snapins/”);
                    define(‘QUEUESIZE’, ‘10’);
                    define(‘CHECKIN_TIMEOUT’,600);
                    define(‘USER_MINPASSLENGTH’,4);
                    define(‘USER_VALIDPASSCHARS’, ‘1234567890ABCDEFGHIJKLMNOPQRSTUVWZXYabcdefghijklmnopqrstuvwxyz_()^!#-’);
                    define(‘NFS_ETH_MONITOR’, “eth0”);
                    define(‘UDPCAST_INTERFACE’, “eth0”);
                    define(‘UDPCAST_STARTINGPORT’, 63100 ); // Must be an even number! recommended between 49152 to 65535
                    define(‘FOG_MULTICAST_MAX_SESSIONS’,64);
                    define(‘FOG_JPGRAPH_VERSION’, ‘2.3’);
                    define(‘FOG_REPORT_DIR’, ‘./reports/’);
                    define(‘FOG_UPLOADIGNOREPAGEHIBER’,true);
                    define(‘FOG_DONATE_MINING’, “0”);
                    }
                    }
                    [/code]
                1 Reply Last reply Reply Quote 0
                • J
                  Junkhacker Developer
                  last edited by Jul 28, 2014, 8:06 PM

                  is the value
                  ‘DATABASE_PASSWORD’, ‘51d86d’
                  correct?
                  if you did not set a password when you installed, try this
                  ‘DATABASE_PASSWORD’, ‘’

                  signature:
                  Junkhacker
                  We are here to help you. If you are unresponsive to our questions, don't expect us to be responsive to yours.

                  1 Reply Last reply Reply Quote 0
                  • O
                    Oma Voss
                    last edited by Aug 3, 2014, 5:06 PM

                    Hi Junkhacker,

                    it was unsuccessfully …

                    1 Reply Last reply Reply Quote 0
                    • T
                      Tom Elliott
                      last edited by Aug 3, 2014, 8:34 PM

                      [quote=“Oma Voss, post: 34671, member: 22725”]Hi Junkhacker,

                      it was unsuccessfully …[/quote]

                      Can you give more information than, it was unsuccessful? Perhaps some log information? Maybe your mysql log file? Maybe the apache error logs?

                      How does it fail, does it give any messages of any use?

                      Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                      Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                      Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

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

                      150

                      Online

                      12.0k

                      Users

                      17.3k

                      Topics

                      155.2k

                      Posts
                      Copyright © 2012-2024 FOG Project