Ubuntu 16.04 - Revision history

Wayne-workman.28155 at 14:40, 22 November 2016

2016-11-22T14:40:33Z

Wayne-workman.28155 at 14:38, 22 November 2016

2016-11-22T14:38:26Z

Tom-elliott.7271: /* Installation */

2016-08-09T22:27:15Z

‎Installation

SebastianRoth at 21:28, 18 May 2016

2016-05-18T21:28:32Z

SebastianRoth: /* MySQL 5.7 issue */

2016-05-01T16:14:35Z

‎MySQL 5.7 issue

SebastianRoth: /* MySQL password behavior */

2016-05-01T15:52:17Z

‎MySQL password behavior

SebastianRoth: /* Update / Dist-Upgrade */

2016-05-01T12:59:09Z

‎Update / Dist-Upgrade

SebastianRoth: /* GROUP BY */

2016-05-01T12:14:46Z

‎GROUP BY

SebastianRoth: /* incorrect datetime value */

2016-05-01T12:14:27Z

‎incorrect datetime value

SebastianRoth: /* invalid default value */

2016-05-01T12:14:11Z

‎invalid default value

← Older revision		Revision as of 14:40, 22 November 2016
Line 1:		Line 1:
		+	See also: [[Ubuntu 16.04 Server]]
		+

	'''USE AT YOUR OWN RISK: We are not responsible for any damage to yourself, hardware, or co-workers. Use at your own risk.'''		'''USE AT YOUR OWN RISK: We are not responsible for any damage to yourself, hardware, or co-workers. Use at your own risk.'''

← Older revision		Revision as of 14:38, 22 November 2016
Line 1:		Line 1:
−	~~<span style="background-color:Yellow;"><span style="color:RED">'''WARNING THIS VERSION OF LINUX, IT IS RELATIVITY NEW AND THERE ARE ISSUES!'''</span></span>~~

	'''USE AT YOUR OWN RISK: We are not responsible for any damage to yourself, hardware, or co-workers. Use at your own risk.'''		'''USE AT YOUR OWN RISK: We are not responsible for any damage to yourself, hardware, or co-workers. Use at your own risk.'''

@@ Line 94: / Line 94: @@
 = Installation =
 To get it up with PHP 7 you need to run the installer as follows:
   php_ver='7.0' php_verAdds='-7.0' ./installfog.sh -y

← Older revision		Revision as of 21:28, 18 May 2016
Line 92:		Line 92:
	= MySQL 5.7 issue =		= MySQL 5.7 issue =
	We have seen several issues with current FOG trunk on MySQL 5.7. Most of those problems should be fixed now. Please follow this [https://forums.fogproject.org/topic/7280/error-incorrect-integer-value-when-inserting-an-empty-string-into-int-field-in-mysql-5-7 forum post] for most recent information on this. As well please open a new thread in the forums and let us know if you still see problems.		We have seen several issues with current FOG trunk on MySQL 5.7. Most of those problems should be fixed now. Please follow this [https://forums.fogproject.org/topic/7280/error-incorrect-integer-value-when-inserting-an-empty-string-into-int-field-in-mysql-5-7 forum post] for most recent information on this. As well please open a new thread in the forums and let us know if you still see problems.
		+
		+	= Installation =
		+	To get it up with PHP 7 you need to run the installer as follows:
		+
		+	php_ver='7.0' php_verAdds='-7.0' ./installfog.sh -y

← Older revision		Revision as of 16:14, 1 May 2016
Line 91:		Line 91:

	= MySQL 5.7 issue =		= MySQL 5.7 issue =
−	We have ~~[https://forums~~.~~fogproject~~.~~org/topic/7284/sql-error-on-fresh-installation several]~~ [https://forums.fogproject.org/topic/7280/error-incorrect-integer-value-when-inserting-an-empty-string-into-int-field-in-mysql-5-7 ~~reports~~] ~~about the FOG web interface not being able to create new hosts or groups (error in the web gui: Host ID was not set, or unable to be created)~~. As well a ~~updating~~ the ~~schema will most probably fail~~ if you ~~try a fresh install.~~	+	We have seen several issues with current FOG trunk on MySQL 5.7. Most of those problems should be fixed now. Please follow this [https://forums.fogproject.org/topic/7280/error-incorrect-integer-value-when-inserting-an-empty-string-into-int-field-in-mysql-5-7 forum post] for most recent information on this. As well please open a new thread in the forums and let us know if you still see problems.
−
−	~~== String is not integer==~~
−	~~Database error:~~
−	~~Incorrect integer value: '' for column 'uId' at row 1~~
−
−	~~Database SQL:~~
−	~~INSERT INTO `fog`.`users` VALUES ('','fog', MD5('password'),'0000-00-00 00:00:00','')~~
−
−	~~Status: Should be fixed in [https://github.com/FOGProject/fogproject/commit/2612aceb4fbb44d3f53255a30b443e1d40972a12 git 2612aceb].~~
−
−	~~== Missing default value ==~~
−	~~Database error:~~
−	~~Field 'ngmKey' doesn't have a default value~~
−
−	~~Database SQL:~~
−	~~INSERT INTO `fog`.nfsGroupMembers (ngmMemberName, ngmMemberDescription, ngmIsMasterNode, ngmGroupID, ngmRootPath, ngmIsEnabled,~~
−	~~ngmHostname, ngmMaxClients, ngmUser, ngmPass) VALUES ('DefaultMember', 'Auto generated fog nfs group member', '1', '1', '/images/',~~
−	~~'1', 'x.x.x.x', '10', 'fog', '...')~~
−
−	~~Status: Should be fixed in [https://github.com/FOGProject/fogproject/commit/2612aceb4fbb44d3f53255a30b443e1d40972a12 git 2612aceb].~~
−
−	~~== GROUP BY ==~~
−	~~Database Error:~~
−	~~Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'fog.groupMembersTemp.gmID' which~~
−	~~is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by~~
−
−	~~Database SQL:~~
−	~~delete from `fog`.`groupMembers` where gmID in (select gmID from `fog`.`groupMembersTemp` group by gmHostID, gmGroupID having count(*) > 1)~~
−
−	~~Status: Fix proposed.~~
−
−	~~== ALTER IGNORE TABLE ==~~
−	~~Database Error:~~
−	~~You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for~~
−	~~the right syntax to use near 'IGNORE TABLE `fog`.`hostMAC` ADD UNIQUE INDEX `hmHostID` (`hmMAC`)' at line 1</code>~~
−
−	~~Database SQL:~~
−	~~ALTER IGNORE TABLE `fog`.`hostMAC` ADD UNIQUE INDEX `hmHostID` (`hmMAC`)~~
−
−	~~Status: Should be fixed in [https://github.com/FOGProject/fogproject/commit/2612aceb4fbb44d3f53255a30b443e1d40972a12 git 2612aceb].~~
−
−	~~== incorrect datetime value ==~~
−	~~Database Error:~~
−	~~Incorrect datetime value: '0000-00-00 00:00:00' for column 'uCreateDate' at row 1~~
−
−	~~Database SQL:~~
−	~~ALTER TABLE `fog`.`users` ADD COLUMN `uType` varchar(2) NOT NULL AFTER `uCreateBy`~~
−
−	~~Status: Fix proposed.~~
−
−	~~== INDEX missing ==~~
−	~~Database Error:~~
−	~~Can't DROP 'igaImageID'; check that column/key exists~~
−
−	~~Database SQL:~~
−	~~ALTER TABLE `fog`.`imageGroupAssoc` DROP INDEX `igaImageID`~~
−
−	~~Status: Fix proposed.~~
−
−	~~== invalid default value ==~~
−	~~Database Error:~~
−	~~Invalid default value for 'hostSecTime'~~
−
−	~~Database SQL:~~
−	~~ALTER TABLE `fog`.`hosts` ADD COLUMN `hostSecTime` TIMESTAMP NOT NULL~~
−
−	~~Status: Fix proposed~~.

@@ Line 56: / Line 56: @@
   mysql -u root
   ...
-  mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '';
+  mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY &#39;&#39;;
   mysql> quit

← Older revision		Revision as of 12:59, 1 May 2016
Line 46:		Line 46:

	As you can clearly see from the error (in my case) the mysql server still runnning was the old version 5.5.49 but the mysql_update tool trying to update the DB in the postinstall scripts was already the newer version. I got this solved by opening two terminals/consoles and shutting down the (old) mysql DB (sudo service mysql stop) while re-running the package installer (sudo apt-get -f install). Very ugly but worked for me.		As you can clearly see from the error (in my case) the mysql server still runnning was the old version 5.5.49 but the mysql_update tool trying to update the DB in the postinstall scripts was already the newer version. I got this solved by opening two terminals/consoles and shutting down the (old) mysql DB (sudo service mysql stop) while re-running the package installer (sudo apt-get -f install). Very ugly but worked for me.
−
−	While still untested another solution to this issue might be shutting down the old mysql DB '''before''' upgrading the system. Hopefully the installer would bring up the new DB before trying to run mysql_update (as this would fail with no DB instance being up!).

	An error might be caused by different issues. So please pay full attention on the error you see and check your error log which is the most valuable source of information in this case.		An error might be caused by different issues. So please pay full attention on the error you see and check your error log which is the most valuable source of information in this case.

@@ Line 123: / Line 123: @@
   delete from `fog`.`groupMembers` where gmID in (select gmID from `fog`.`groupMembersTemp` group by gmHostID, gmGroupID having count(*) > 1)
-Status: Working on it... Fix suggested in the forums.
+Status: Fix proposed.
 == ALTER IGNORE TABLE ==

@@ Line 142: / Line 142: @@
   ALTER TABLE `fog`.`users` ADD COLUMN `uType` varchar(2) NOT NULL AFTER `uCreateBy`
-Status: Working on it... easily fixable.
+Status: Fix proposed.
 == INDEX missing ==

← Older revision		Revision as of 12:14, 1 May 2016
Line 160:		Line 160:
	ALTER TABLE `fog`.`hosts` ADD COLUMN `hostSecTime` TIMESTAMP NOT NULL		ALTER TABLE `fog`.`hosts` ADD COLUMN `hostSecTime` TIMESTAMP NOT NULL

−	Status: ~~Working on it... easily fixable~~.	+	Status: Fix proposed.