Svn upgrade failed.

irishfoguser · Jan 6, 2015, 3:11 PM

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.

Junkhacker · Jan 6, 2015, 5:59 PM

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

irishfoguser · Jan 7, 2015, 9:39 AM

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

irishfoguser · Jan 7, 2015, 10:27 AM

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]

Tom Elliott · Jan 7, 2015, 11:32 AM

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

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

irishfoguser · Jan 7, 2015, 3:59 PM

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.

Tom Elliott · Jan 7, 2015, 4:33 PM

You’re using MSSQL and not MySQL?

irishfoguser · Jan 7, 2015, 5:15 PM

[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?

Junkhacker · Jan 8, 2015, 2:09 PM

what OS are you running?

irishfoguser · Jan 8, 2015, 3:32 PM

debian

irishfoguser · Jan 9, 2015, 4:00 PM

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.

Wolfbane8653 · Jan 9, 2015, 4:10 PM

[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!

irishfoguser · Jan 9, 2015, 5:00 PM

[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]

password is cbefog
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]

[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.

Tom Elliott · Jan 9, 2015, 5:03 PM

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

Wolfbane8653 · Jan 9, 2015, 5:20 PM

You got your numbers mixed up.

is blank and is very important…run mysql -u root -p cbefog fog
Should be the terminal output
should be a browser screen shot
should be your dropbox link

Tom Elliott · Jan 9, 2015, 5:26 PM

Now that I have a better understanding of what possibly is happening.

How are you updating this?

Are you just going to the originally installed svn folder and re-running the installfog.sh file?

I ask this because the folder you downloaded when you first installed to SVN does not automatically update.

The process should be (lets assume your svn folder is currently located in the location /opt/fogsvn)
[code]sudo su -
cd /opt/fogsvn
svn up
cd bin
./installfog.sh[/code]

irishfoguser · Jan 15, 2015, 10:05 AM

been snowed under with other work, hope to get back to looking at this today.

ill relook at the questions list again.

irishfoguser · Jan 20, 2015, 11:57 AM

[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]

cbefog
NO, ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: NO)
log in dropbox link
log in dropxbox link
No everything works fine
see dropbox link
see dropbox link
[url]https://www.dropbox.com/sh/28lsxa5p6o9jq0q/AAC81thnbPn2MrF2xhxVFUsea?dl=0[/url]

Tom Elliott · Jan 20, 2015, 12:06 PM

The code to sign into mysql should be:

[code]mysql -u root -p’cpefog’ fog[/code]

It should bring you to a prompt that looks like:
[code]mysql>[/code]

If you get there, it means you’re logging into the Database fine.

For #5 (Are there any errors on your screen when trying to login to the database?), it still sounds, to me, like you’re not running the updater and are still at 2580. The SVN folder doesn’t automatically update to the latest or later revisions, you have to perform work.

For example, if your original SVN download folder was located in /opt/fog_trunk by running command:

[code]svn co https://svn.code.sf.net/p/freeghost/code/trunk /opt/fog_trunk[/code]

To update you would perform:
[code]cd /opt/fog_trunk
svn update
cd bin
sudo ./installfog.sh[/code]

This would then perform the upgrade. As you state you’re able to to login and no database schema is being presented to you, it sounds, to me, like you’re not actually updated. SVN does not update automatically for you.

irishfoguser · Jan 20, 2015, 12:26 PM

[quote=“Tom Elliott, post: 41001, member: 7271”]The code to sign into mysql should be:

[code]mysql -u root -p’cpefog’ fog[/code]

It should bring you to a prompt that looks like:
[code]mysql>[/code]

If you get there, it means you’re logging into the Database fine.

For #5 (Are there any errors on your screen when trying to login to the database?), it still sounds, to me, like you’re not running the updater and are still at 2580. The SVN folder doesn’t automatically update to the latest or later revisions, you have to perform work.

For example, if your original SVN download folder was located in /opt/fog_trunk by running command:

[code]svn co https://svn.code.sf.net/p/freeghost/code/trunk /opt/fog_trunk[/code]

To update you would perform:
[code]cd /opt/fog_trunk
svn update
cd bin
sudo ./installfog.sh[/code]

This would then perform the upgrade. As you state you’re able to to login and no database schema is being presented to you, it sounds, to me, like you’re not actually updated. SVN does not update automatically for you.[/quote]

sorry that command works fine i get the mssql prompt fine.

i been using this commands which i found on the wiki

cd ~
mkdir svn
cd svn
svn checkout [url]https://svn.code.sf.net/p/freeghost/code/trunk[/url]

[SIZE=4][B]Install It![/B][/SIZE]

cd ~/svn/trunk/bin
./installfog.sh

running your commands i get

root@MaynoothFogServer:~/svn/trunk/bin# cd ~/svn/trunk/bin
root@MaynoothFogServer:~/svn/trunk/bin# svn up
At revision 2914.
root@MaynoothFogServer:~/svn/trunk/bin#