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

    Svn upgrade failed.

    Scheduled Pinned Locked Moved
    FOG Problems
    4
    30
    8.3k
    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.
    • I
      irishfoguser
      last edited by

      i tried to upgrade to the latest svn from version 2580 to the latest svn version 2868 all seem to be going fine but when i tried to to the database schemea update when i click on the link , all i got was the login box for fog no update database option.

      I have tried editing my .fogsettings file and adding in localhost as my servername but no joy

      The server is not live yet but i was practically built and i hate to have to start from scratch,.

      I dont have any error logs in /var/log/mysql

      Any idea where to start debugging.
      My .fogsettings is below.

      [QUOTE]## Created by the FOG Installer

      Version: 1.3.0

      Install time: Mon 05 Jan 2015 14:38:27 GMT

      ipaddress=“192.168.2.1”;
      interface=“eth1”;
      routeraddress=“#option routers x.x.x.x;”;
      plainrouter=“”;
      dnsaddress=“#option domain-name-servers x.x.x.x; “;
      dnsbootimage=””;
      password=“4452cc”;
      osid=“2”;
      osname=“Debian”;
      dodhcp=“Y”;
      bldhcp=“1”;
      installtype=“N”;
      snmysqluser=“”
      snmysqlpass=“cbefog”;
      snmysqlhost=“localhost”;
      installlang=“0”;
      donate=“0”;
      storageLocation=“/images”;
      fogupdateloaded=“1”[/QUOTE]

      1 Reply Last reply Reply Quote 0
      • Tom ElliottT
        Tom Elliott
        last edited by

        My guess is the snmysqluser=“” should be snmysqluser=“root”

        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
        • I
          irishfoguser
          last edited by

          i changed that to root , no joy.

          apache is giving me this error.

          Mon Jan 05 15:46:00 2015] [error] [client 192.168.2.1] PHP Warning: mysqli::select_db(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 74, referer: [url]http://192.168.2.1/fog/management/index.php[/url]

          1 Reply Last reply Reply Quote 0
          • Tom ElliottT
            Tom Elliott
            last edited by

            Is MySQL server actually running?

            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
            • I
              irishfoguser
              last edited by

              yes , running this command shows no errors [SIZE=12px][FONT=Consolas][COLOR=#111111]mysqladmin -u root -p status[/COLOR][/FONT][/SIZE]

              [SIZE=12px][FONT=Consolas][COLOR=#111111]Whats the best way to start from scratch.

              Is it delete the database?[/COLOR][/FONT][/SIZE]

              [SIZE=12px][FONT=Consolas][COLOR=#111111]I only have to setup all the images again. only got about 13. [/COLOR][/FONT][/SIZE]

              1 Reply Last reply Reply Quote 0
              • W
                Wolfbane8653 Developer
                last edited by

                After changing the values in .fogsettings you will need to re-run the installer. This will re-push the settings that you have there. Just changing the values in .fogsettings will not affect anything.

                Please also post your install log. Located /var/log/foginstall.log

                1 Reply Last reply Reply Quote 0
                • I
                  irishfoguser
                  last edited by

                  The .fogsettings i am using now.

                  Created by the FOG Installer

                  Version: 1.3.0

                  Install time: Mon 05 Jan 2015 15:46:37 GMT

                  ipaddress=“192.168.2.1”;
                  interface=“eth1”;
                  routeraddress=“#option routers x.x.x.x;”;
                  plainrouter=“”;
                  dnsaddress=“#option domain-name-servers x.x.x.x; “;
                  dnsbootimage=””;
                  password=“4452cc”;
                  osid=“2”;
                  osname=“Debian”;
                  dodhcp=“Y”;
                  bldhcp=“1”;
                  installtype=“N”;
                  snmysqluser=“root”;
                  snmysqlpass=“cbefog”;
                  snmysqlhost=“localhost”; Should this be localhost or ip address
                  installlang=“0”;
                  donate=“0”;
                  storageLocation=“/images”;
                  fogupdateloaded=“1”;[/QUOTE]

                  my foginstall log
                  [CODE]Debian

                    ..#######:.    ..,#,..    .::##::.
                  

                  .:###### .:;####:…;#;…
                  …##… …##;,;##::::.##…
                  ,# …##…##:::## …::
                  ## .::###,##. . ##.::#.:######::.
                  …##:::###::…#. … .#…#. #…#:::.
                  …:####:… …##…##::## … #
                  # . …##:,;##;:::#: … ##…
                  .# . .:;####;::::.##:::;#:…
                  # …:;###…

                  ###########################################

                  FOG

                  Free Computer Imaging Solution

                  http://www.fogproject.org/

                  Developers:

                  Chuck Syperski

                  Jian Zhang

                  Peter Gilchrist

                  Tom Elliott

                  GNU GPL Version 3

                  ###########################################

                  Version: 1.3.0 Installer/Updater

                  • Found FOG Settings from previous install at: /opt/fog/.fogsettings
                  • Performing upgrade using these settings…

                  Starting Debian / Ubuntu / Kubuntu / Edubuntu Installtion.

                  #####################################################################

                  FOG now has everything it needs to setup your server, but please
                  understand that this script will overwrite any setting you may
                  have setup for services like DHCP, apache, pxe, tftp, and NFS.

                  It is not recommended that you install this on a production system
                  as this script modifies many of your system settings.

                  This script should be run by the root user on Redhat or with sudo on Ubuntu.

                  ** Notice ** Redhat users will need to disable SELinux and iptables in
                  order to use FOG
                  Please see our wiki for more information at http://www.fogproject.org/wiki

                  Here are the settings FOG will use:
                  Base Linux: Debian
                  Detected Linux Distribution: Debian
                  Installation Type: Normal Server
                  Server IP Address: 192.168.2.1
                  DHCP router Address:
                  DHCP DNS Address:
                  Interface: eth1
                  Using FOG DHCP: 1
                  Internationalization: 0
                  Image Storage Location: /images
                  Donate: 0

                  Are you sure you wish to continue (Y/N)
                  Installation Started…

                  Installing required packages, if this fails
                  make sure you have an active internet connection.

                  • Preparing apt-get

                  • Packages to be installed: apache2 php5 php5-json php5-gd php5-cli php5-mysql php5-curl mysql-server mysql-client isc-dhcp-server tftpd-hpa tftp-hpa nfs-kernel-server vsftpd net-tools wget xinetd sysv-rc-conf tar gzip build-essential cpp gcc g++ m4 htmldoc lftp openssh-server php-gettext

                  • Skipping package: apache2 (Already installed)

                  • Skipping package: php5 (Already installed)

                  • Skipping package: php5-common (Already installed)

                  • Skipping package: php5-gd (Already installed)

                  • Skipping package: php5-cli (Already installed)

                  • Skipping package: php5-mysql (Already installed)

                  • Skipping package: php5-curl (Already installed)

                  • Skipping package: mysql-server (Already installed)

                  • Skipping package: mysql-client (Already installed)

                  • Skipping package: isc-dhcp-server (Already installed)

                  • Skipping package: tftpd-hpa (Already installed)

                  • Skipping package: tftp-hpa (Already installed)

                  • Skipping package: nfs-kernel-server (Already installed)

                  • Skipping package: vsftpd (Already installed)

                  • Skipping package: net-tools (Already installed)

                  • Skipping package: wget (Already installed)

                  • Skipping package: xinetd (Already installed)

                  • Skipping package: sysv-rc-conf (Already installed)

                  • Skipping package: tar (Already installed)

                  • Skipping package: gzip (Already installed)

                  • Skipping package: build-essential (Already installed)

                  • Skipping package: cpp (Already installed)

                  • Skipping package: gcc (Already installed)

                  • Skipping package: g++ (Already installed)

                  • Skipping package: m4 (Already installed)

                  • Skipping package: htmldoc (Already installed)

                  • Skipping package: lftp (Already installed)

                  • Skipping package: openssh-server (Already installed)

                  • Skipping package: php-gettext (Already installed)

                  Confirming package installation.

                  • Checking package: apache2…OK
                  • Checking package: php5…OK
                  • Checking package: php5-json…OK
                  • Checking package: php5-gd…OK
                  • Checking package: php5-cli…OK
                  • Checking package: php5-mysql…OK
                  • Checking package: php5-curl…OK
                  • Checking package: mysql-server…OK
                  • Checking package: mysql-client…OK
                  • Checking package: isc-dhcp-server…OK
                  • Checking package: tftpd-hpa…OK
                  • Checking package: tftp-hpa…OK
                  • Checking package: nfs-kernel-server…OK
                  • Checking package: vsftpd…OK
                  • Checking package: net-tools…OK
                  • Checking package: wget…OK
                  • Checking package: xinetd…OK
                  • Checking package: sysv-rc-conf…OK
                  • Checking package: tar…OK
                  • Checking package: gzip…OK
                  • Checking package: build-essential…OK
                  • Checking package: cpp…OK
                  • Checking package: gcc…OK
                  • Checking package: g++…OK
                  • Checking package: m4…OK
                  • Checking package: htmldoc…OK
                  • Checking package: lftp…OK
                  • Checking package: openssh-server…OK
                  • Checking package: php-gettext…OK

                  Configuring services.

                  • Setting up and starting MySql…OK

                  • Backing up user reports…OK

                  • Setting up and starting Apache Web Server…OK

                  • Copying back any custom hook files.

                  • Copying back any custom report files.
                    You still need to install/update your database schema.
                    This can be done by opening a web browser and going to:

                    http://192.168.2.1/fog/management

                  Press [Enter] key when database is updated/installed.[/CODE]

                  On clicking the link i dont get the update database page just the normal fog login.

                  1 Reply Last reply Reply Quote 0
                  • JunkhackerJ
                    Junkhacker Developer
                    last edited by

                    depending on what version you upgraded from, your database may have already been up to date. it doesn’t change with every revision

                    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
                    • I
                      irishfoguser
                      last edited by

                      i am aware of that but the update doesnt seen to complete. it just stays stuck on 2580.

                      1 Reply Last reply Reply Quote 0
                      • I
                        irishfoguser
                        last edited by

                        can someone shed some light on this error which has appeared now

                        [CODE]150107 10:14:05 InnoDB: Starting shutdown…
                        150107 10:14:06 InnoDB: Shutdown completed; log sequence number 1720871
                        150107 10:14:06 [Note]
                        150107 10:14:06 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
                        150107 10:24:03 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
                        150107 10:24:03 [ERROR] Can’t read from messagefile ‘/usr/share/mysql/english/errmsg.sys’
                        150107 10:24:03 [Note] Plugin ‘FEDERATED’ is disabled.
                        150107 10:24:03 InnoDB: The InnoDB memory heap is disabled
                        150107 10:24:03 InnoDB: Mutexes and rw_locks use GCC atomic builtins
                        150107 10:24:03 InnoDB: Compressed tables use zlib 1.2.7
                        150107 10:24:03 InnoDB: Using Linux native AIO
                        150107 10:24:03 InnoDB: Initializing buffer pool, size = 128.0M
                        150107 10:24:03 InnoDB: Completed initialization of buffer pool
                        150107 10:24:03 InnoDB: highest supported file format is Barracuda.
                        150107 10:24:03 InnoDB: Waiting for the background threads to start
                        150107 10:24:04 InnoDB: 5.5.40 started; log sequence number 1720871
                        150107 10:24:04 [ERROR] /usr/sbin/mysqld: unknown option ‘–explicit_defaults_for_timestamp’
                        150107 10:24:04 [ERROR] Aborting[/CODE]

                        1 Reply Last reply Reply Quote 0
                        • Tom ElliottT
                          Tom Elliott
                          last edited by

                          No direct information, but this particular issue is something that’s kind of known about:

                          [url]https://github.com/FOGProject/fogproject/issues/1[/url]

                          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
                          • I
                            irishfoguser
                            last edited by

                            no joy.

                            oddly with the mssql not starting the database schema update page now appears when i log into fog.

                            pure madness about to start from scratch here to be honest.

                            1 Reply Last reply Reply Quote 0
                            • Tom ElliottT
                              Tom Elliott
                              last edited by

                              You’re using MSSQL and not MySQL?

                              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
                              • I
                                irishfoguser
                                last edited by

                                [quote=“Tom Elliott, post: 40534, member: 7271”]You’re using MSSQL and not MySQL?[/quote]

                                a typo on my behalf. I am used to windows world.:D

                                the mysql errors started after a system update.

                                what version of myssql does fog use, can i upgrade to 5.6?

                                1 Reply Last reply Reply Quote 0
                                • JunkhackerJ
                                  Junkhacker Developer
                                  last edited by

                                  what OS are you running?

                                  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
                                  • I
                                    irishfoguser
                                    last edited by

                                    debian

                                    1 Reply Last reply Reply Quote 0
                                    • I
                                      irishfoguser
                                      last edited by

                                      got the sql issue sroted now i am running 5.6 now on debian.

                                      but its still the same issue, The database update page doesnt appear.

                                      1 Reply Last reply Reply Quote 0
                                      • W
                                        Wolfbane8653 Developer
                                        last edited by

                                        [LIST=1]
                                        []When fog installed did you use a password for the database?
                                        [
                                        ]Can you login to the database using username root? --> mysql -u root fog
                                        []If yes to question 1, can you login to the database using --> mysql -u root -p <password you entered> fog
                                        [
                                        ]Do you have any errors in your mysql log?
                                        []Are there any errors on your screen when trying to login to the database?
                                        [
                                        ]What does show up when you go to your fog server URL? (picture required)
                                        [*]Can you give use your apache error log file? (file upload required)
                                        [/LIST]
                                        Pictures and/or video work wonders!

                                        1 Reply Last reply Reply Quote 0
                                        • I
                                          irishfoguser
                                          last edited by

                                          [quote=“Wolfbane8653, post: 40602, member: 3362”]
                                          [LIST=1]
                                          []When fog installed did you use a password for the database?
                                          [
                                          ]Can you login to the database using username root? --> mysql -u root fog
                                          []If yes to question 1, can you login to the database using --> mysql -u root -p <password you entered> fog
                                          [
                                          ]Do you have any errors in your mysql log?
                                          []Are there any errors on your screen when trying to login to the database?
                                          [
                                          ]What does show up when you go to your fog server URL? (picture required)
                                          [*]Can you give use your apache error log file? (file upload required)
                                          [/LIST]
                                          Pictures and/or video work wonders![/quote]

                                          1. password is cbefog
                                          2. No error. root@MaynoothFogServer:/home/cbe# mysql -u root fog
                                            ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: NO)

                                          [CODE]150109 15:59:14 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
                                          2015-01-09 15:59:14 16398 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000)

                                          2015-01-09 15:59:14 16398 [Warning] Buffered warning: Changed limits: table_cache: 431 (requested 2000)

                                          2015-01-09 15:59:14 16398 [Note] Plugin ‘FEDERATED’ is disabled.
                                          2015-01-09 15:59:14 16398 [Note] InnoDB: Using atomics to ref count buffer pool pages
                                          2015-01-09 15:59:14 16398 [Note] InnoDB: The InnoDB memory heap is disabled
                                          2015-01-09 15:59:14 16398 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
                                          2015-01-09 15:59:14 16398 [Note] InnoDB: Memory barrier is not used
                                          2015-01-09 15:59:14 16398 [Note] InnoDB: Compressed tables use zlib 1.2.7
                                          2015-01-09 15:59:14 16398 [Note] InnoDB: Using Linux native AIO
                                          2015-01-09 15:59:14 16398 [Note] InnoDB: Not using CPU crc32 instructions
                                          2015-01-09 15:59:14 16398 [Note] InnoDB: Initializing buffer pool, size = 128.0M
                                          2015-01-09 15:59:14 16398 [Note] InnoDB: Completed initialization of buffer pool
                                          2015-01-09 15:59:14 16398 [Note] InnoDB: Highest supported file format is Barracuda.
                                          2015-01-09 15:59:14 16398 [Note] InnoDB: 128 rollback segment(s) are active.
                                          2015-01-09 15:59:14 16398 [Note] InnoDB: Waiting for purge to start
                                          2015-01-09 15:59:14 16398 [Note] InnoDB: 5.6.22 started; log sequence number 1725047
                                          2015-01-09 15:59:14 16398 [Note] Server hostname (bind-address): ‘127.0.0.1’; port: 3306
                                          2015-01-09 15:59:14 16398 [Note] - ‘127.0.0.1’ resolves to ‘127.0.0.1’;
                                          2015-01-09 15:59:14 16398 [Note] Server socket created on IP: ‘127.0.0.1’.
                                          2015-01-09 15:59:14 16398 [ERROR] Column count of mysql.events_waits_current is wrong. Expected 19, found 16. Created with MySQL 50540, now running 50622. Please use mysql_upgrade to fix this error.
                                          2015-01-09 15:59:14 16398 [ERROR] Column count of mysql.events_waits_history is wrong. Expected 19, found 16. Created with MySQL 50540, now running 50622. Please use mysql_upgrade to fix this error.
                                          2015-01-09 15:59:14 16398 [ERROR] Column count of mysql.events_waits_history_long is wrong. Expected 19, found 16. Created with MySQL 50540, now running 50622. Please use mysql_upgrade to fix this error.
                                          2015-01-09 15:59:14 16398 [ERROR] Native table ‘performance_schema’.‘events_waits_summary_by_host_by_event_name’ has the wrong structure
                                          2015-01-09 15:59:14 16398 [ERROR] Incorrect definition of table performance_schema.events_waits_summary_by_thread_by_event_name: expected column ‘THREAD_ID’ at position 0 to have type bigint(20), found type int(11).
                                          2015-01-09 15:59:14 16398 [ERROR] Native table ‘performance_schema’.‘events_waits_summary_by_user_by_event_name’ has the wrong structure
                                          2015-01-09 15:59:14 16398 [ERROR] Native table ‘performance_schema’.‘events_waits_summary_by_account_by_event_name’ has the wrong structure
                                          2015-01-09 15:59:14 16398 [ERROR] Column count of mysql.file_summary_by_event_name is wrong. Expected 23, found 5. Created with MySQL 50540, now running 50622. Please use mysql_upgrade to fix this error.
                                          2015-01-09 15:59:14 16398 [ERROR] Column count of mysql.file_summary_by_instance is wrong. Expected 25, found 6. Created with MySQL 50540, now running 50622. Please use mysql_upgrade to fix this error.
                                          2015-01-09 15:59:14 16398 [ERROR] Native table ‘performance_schema’.‘host_cache’ has the wrong structure
                                          2015-01-09 15:59:14 16398 [ERROR] Incorrect definition of table performance_schema.mutex_instances: expected column ‘LOCKED_BY_THREAD_ID’ at position 2 to have type bigint(20), found type int(11).
                                          2015-01-09 15:59:14 16398 [ERROR] Native table ‘performance_schema’.‘objects_summary_global_by_type’ has the wrong structure
                                          2015-01-09 15:59:14 16398 [ERROR] Incorrect definition of table performance_schema.rwlock_instances: expected column ‘WRITE_LOCKED_BY_THREAD_ID’ at position 2 to have type bigint(20), found type int(11).
                                          2015-01-09 15:59:14 16398 [ERROR] Native table ‘performance_schema’.‘setup_actors’ has the wrong structure
                                          2015-01-09 15:59:14 16398 [ERROR] Native table ‘performance_schema’.‘setup_objects’ has the wrong structure
                                          2015-01-09 15:59:14 16398 [ERROR] Native table ‘performance_schema’.‘table_io_waits_summary_by_index_usage’ has the wrong structure
                                          2015-01-09 15:59:14 16398 [ERROR] Native table ‘performance_schema’.‘table_io_waits_summary_by_table’ has the wrong structure
                                          2015-01-09 15:59:14 16398 [ERROR] Native table ‘performance_schema’.‘table_lock_waits_summary_by_table’ has the wrong structure
                                          2015-01-09 15:59:14 16398 [ERROR] Column count of mysql.threads is wrong. Expected 14, found 3. Created with MySQL 50540, now running 50622. Please use mysql_upgrade to fix this error.
                                          2015-01-09 15:59:14 16398 [ERROR] Native table ‘performance_schema’.‘events_stages_current’ has the wrong structure
                                          2015-01-09 15:59:14 16398 [ERROR] Native table ‘performance_schema’.‘events_stages_history’ has the wrong structure
                                          2015-01-09 15:59:14 16398 [ERROR] Native table ‘performance_schema’.‘events_stages_history_long’ has the wrong structure
                                          2015-01-09 15:59:14 16398 [ERROR] Native table ‘performance_schema’.‘events_stages_summary_by_thread_by_event_name’ has the wrong structure
                                          2015-01-09 15:59:14 16398 [ERROR] Native table ‘performance_schema’.‘events_stages_summary_by_account_by_event_name’ has the wrong structure
                                          2015-01-09 15:59:14 16398 [ERROR] Native table ‘performance_schema’.‘events_stages_summary_by_user_by_event_name’ has the wrong structure
                                          2015-01-09 15:59:14 16398 [ERROR] Native table ‘performance_schema’.‘events_stages_summary_by_host_by_event_name’ has the wrong structure
                                          2015-01-09 15:59:14 16398 [ERROR] Native table ‘performance_schema’.‘events_stages_summary_global_by_event_name’ has the wrong structure
                                          2015-01-09 15:59:14 16398 [ERROR] Native table ‘performance_schema’.‘events_statements_current’ has the wrong structure
                                          2015-01-09 15:59:14 16398 [ERROR] Native table ‘performance_schema’.‘events_statements_history’ has the wrong structure
                                          2015-01-09 15:59:14 16398 [ERROR] Native table ‘performance_schema’.‘events_statements_history_long’ has the wrong structure
                                          2015-01-09 15:59:14 16398 [ERROR] Native table ‘performance_schema’.‘events_statements_summary_by_thread_by_event_name’ has the wrong structure
                                          2015-01-09 15:59:14 16398 [ERROR] Native table ‘performance_schema’.‘events_statements_summary_by_account_by_event_name’ has the wrong structure
                                          2015-01-09 15:59:14 16398 [ERROR] Native table ‘performance_schema’.‘events_statements_summary_by_user_by_event_name’ has the wrong structure
                                          2015-01-09 15:59:14 16398 [ERROR] Native table ‘performance_schema’.‘events_statements_summary_by_host_by_event_name’ has the wrong structure
                                          2015-01-09 15:59:14 16398 [ERROR] Native table ‘performance_schema’.‘events_statements_summary_global_by_event_name’ has the wrong structure
                                          2015-01-09 15:59:14 16398 [ERROR] Native table ‘performance_schema’.‘events_statements_summary_by_digest’ has the wrong structure
                                          2015-01-09 15:59:14 16398 [ERROR] Native table ‘performance_schema’.‘users’ has the wrong structure
                                          2015-01-09 15:59:14 16398 [ERROR] Native table ‘performance_schema’.‘accounts’ has the wrong structure
                                          2015-01-09 15:59:14 16398 [ERROR] Native table ‘performance_schema’.‘hosts’ has the wrong structure
                                          2015-01-09 15:59:14 16398 [ERROR] Native table ‘performance_schema’.‘socket_instances’ has the wrong structure
                                          2015-01-09 15:59:14 16398 [ERROR] Native table ‘performance_schema’.‘socket_summary_by_instance’ has the wrong structure
                                          2015-01-09 15:59:14 16398 [ERROR] Native table ‘performance_schema’.‘socket_summary_by_event_name’ has the wrong structure
                                          2015-01-09 15:59:14 16398 [ERROR] Native table ‘performance_schema’.‘session_connect_attrs’ has the wrong structure
                                          2015-01-09 15:59:14 16398 [ERROR] Native table ‘performance_schema’.‘session_account_connect_attrs’ has the wrong structure
                                          2015-01-09 15:59:14 16398 [Note] Event Scheduler: Loaded 0 events
                                          2015-01-09 15:59:14 16398 [Note] /usr/sbin/mysqld: ready for connections.
                                          Version: ‘5.6.22’ socket: ‘/var/run/mysqld/mysqld.sock’ port: 3306 MySQL Community Server (GPL)[/CODE]
                                          5. Image
                                          [IMG]http://i60.tinypic.com/2mg1bnd.png[/IMG]

                                          1. [url]https://www.dropbox.com/s/vgycit4pac2r0at/apacheerror.log?dl=0[/url]

                                          Thanks for the help.

                                          It appreas to be a mysql login error.

                                          I upgraded from 5.5 to 5.6 to see if i could solve the problem.

                                          1 Reply Last reply Reply Quote 0
                                          • Tom ElliottT
                                            Tom Elliott
                                            last edited by

                                            The fact that you’re presented with the login page tells me your mysql settings in /var/www/fog/lib/fog/Config.class.php are 100% correct.

                                            My feeling is that your password to login to the FOG GUI is not correct.

                                            Try:
                                            username: fog
                                            password: password

                                            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
                                            • 2
                                            • 1 / 2
                                            • First post
                                              Last post

                                            254

                                            Online

                                            12.0k

                                            Users

                                            17.3k

                                            Topics

                                            155.2k

                                            Posts
                                            Copyright © 2012-2024 FOG Project