After upgrade to trunk 7324, no settings available under FOG Configuration - FOG Settings

[Scott Adams]

I was having an issue with trunk 7320 where I could not change the kernel under TFTP Server in FOG Settings. I would change it and hit Save. It would say that settings were store successfully, but the kernel name never changed. In fact, any change I made to anything under FOG Settings did not change.

So, I upgraded to trunk 7324 and now I have no settings, with the exception of Active Directory. I have rebooted several times, restarted mysql service and apache2, but to no avail.

Any ideas?

I am on ubuntu 14.04

[Wayne Workman]

@Scott-B None of that stuff is in the globalSettings table. Look for yourself and see what I’m talking about. select settingDesc from globalSettings;

[Scott B]

@Wayne-Workman said in After upgrade to trunk 7324, no settings available under FOG Configuration - FOG Settings:

@Scott-B None of your inventory info is in the globalSettings description column.

Not FOG inventory, our inventory (my fault, wasnt very clear). We have additional information added in the description such as a PO number or purchase date.

[Wayne Workman]

@Scott-B None of your inventory info is in the globalSettings description column.

[Scott B]

@Wayne-Workman said in After upgrade to trunk 7324, no settings available under FOG Configuration - FOG Settings:

@Scott-B Ok I might have a fix for you…

First, do a config export so you can go back if you want.
Web Interface -> FOG Configuraton -> Configuration Save -> Export

next,
mysql
use fog
update globalSettings set settingDesc = '';

What this does is it throws out all the descriptions, which is where all those slashes are being stored. It’s being caused by single quotes in the descriptions, basically.

You won’t have descriptions anymore (until we can fix it) but it’s better than having broke fog settings right?

Also, alerting @Tom-Elliott to this.

Any way to do more of a search and destroy slashes in the description field? Some of our inventory info is in there and I cant have it missing.

[Wayne Workman]

@Scott-B Ok I might have a fix for you…

First, do a config export so you can go back if you want.
Web Interface -> FOG Configuraton -> Configuration Save -> Export

next,
mysql
use fog
update globalSettings set settingDesc = '';

What this does is it throws out all the descriptions, which is where all those slashes are being stored. It’s being caused by single quotes in the descriptions, basically.

You won’t have descriptions anymore (until we can fix it) but it’s better than having broke fog settings right?

Also, alerting @Tom-Elliott to this.

[Wayne Workman]

@Scott-B mkk so truncating the table and reinstalling definitely did not go well… Going to try truncating the table and then deleting /opt/fog/.fogsettings and then reinstalling. Standby please.

[Scott B]

@Wayne-Workman said in After upgrade to trunk 7324, no settings available under FOG Configuration - FOG Settings:

@Scott-B if you can hold on a minute, I’m snapshotting my fog server so i can try to see if I can git rid of all the crazy back slashes…

no problem.

[Wayne Workman]

@Scott-B if you can hold on a minute, I’m snapshotting my fog server so i can try to see if I can git rid of all the crazy back slashes…

[Scott B]

@Wayne-Workman said in After upgrade to trunk 7324, no settings available under FOG Configuration - FOG Settings:

@Scott-B remove the \G

select * from globalSettings;

Several pages of…

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

|	1	|	FOG_TFTP_HOST	|	theserversIP	TFTP Server
|	2	|	FOG_TFTP_FTP_USERNAME	|	theusersname	TFTP Server
|	3	|	FOG_TFTP_FTP_PASSWORD	|	theuserspassword	TFTP Server
|	5	|	FOG_TFTP_PXE_KERNEL_DIR	|	/var/www/html/fog/service/ipxe/	TFTP Server
|	6	|	FOG_TFTP_PXE_KERNEL	|	bzImage	TFTP Server
|	7	|	FOG_KERNEL_RAMDISK_SIZE	|	127000	TFTP Server
|	8	|	FOG_USE_SLOPPY_NAME_LOOKUPS	|	1	General Settings
|	9	|	FOG_MEMTEST_KERNEL	|	memtest.bin	General Settings
|	10	|	FOG_PXE_BOOT_IMAGE	|	init.xz	TFTP Server
|	11	|	FOG_PXE_IMAGE_DNSADDRESS	|	theprimarydnsserverIP	TFTP Server
|	17	|	FOG_NFS_BANDWIDTHPATH	|	/fog/status/bandwidth.php	NFS Server
|	18	|	FOG_UPLOADRESIZEPCT	|	12	General Settings
|	19	|	FOG_WEB_HOST	|	theserversIP	Web Server
|	20	|	FOG_WEB_ROOT	|	fog/	Web Server
|	24	|	FOG_SNAPINDIR	|	/opt/fog/snapins/	FOG Service - Snapins
|	25	|	FOG_QUEUESIZE	|	5	General Settings
|	26	|	FOG_CHECKIN_TIMEOUT	|	300	General Settings
|	27	|	FOG_USER_MINPASSLENGTH	|	1	User Management
|	28	|	FOG_USER_VALIDPASSCHARS	|	1234567890ABCDEFGHIJKLMNOPQRSTUVWZXYabcdefghijklmnopqrstuvwxyz_hB()^!	User Management
|	29	|	FOG_NFS_ETH_MONITOR	|	bond0	NFS Server
|	30	|	FOG_UDPCAST_INTERFACE	|	bond0	Multicast Settings
|	31	|	FOG_UDPCAST_STARTINGPORT	|	60328	Multicast Settings
|	32	|	FOG_MULTICAST_MAX_SESSIONS	|	64	Multicast Settings
|	34	|	FOG_REPORT_DIR	|	reports/	Web Server
|	35	|	FOG_THEME	|	default/fog.css	Web Server
|	36	|	FOG_UPLOADIGNOREPAGEHIBER	|	1	General Settings
|	37	|	FOG_SERVICE_DIRECTORYCLEANER_ENABLED	|	1	FOG Service - Directory Cleaner
|	38	|	FOG_USE_ANIMATION_EFFECTS	|	1	General Settings
|	39	|	FOG_SERVICE_USERCLEANUP_ENABLED	|		FOG Service - User Cleanup
|	40	|	FOG_SERVICE_GREENFOG_ENABLED	|	1	FOG Service - Green Fog
|	41	|	FOG_SERVICE_AUTOLOGOFF_ENABLED	|		FOG Service - Auto Log Off
|	42	|	FOG_SERVICE_DISPLAYMANAGER_ENABLED	|		FOG Service - Display Manager
|	43	|	FOG_SERVICE_DISPLAYMANAGER_X	|	1024	FOG Service - Display Manager
|	44	|	FOG_SERVICE_DISPLAYMANAGER_Y	|	768	FOG Service - Display Manager
|	45	|	FOG_SERVICE_DISPLAYMANAGER_R	|	60	FOG Service - Display Manager
|	46	|	FOG_SERVICE_AUTOLOGOFF_MIN	|	0	FOG Service - Auto Log Off
|	47	|	FOG_SERVICE_AUTOLOGOFF_BGIMAGE		

Then several pages of…

\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\

[Wayne Workman]

@Scott-B remove the \G

select * from globalSettings;

[Scott B]

@Wayne-Workman said in After upgrade to trunk 7324, no settings available under FOG Configuration - FOG Settings:

@Scott-B so… let’s dig in, shall we?

Mysql
use fog
select * from globalSettings\G;

Post the results of the last command, please. use a code box.

select * from globalSettings\G; gives me a syntax error.

[Wayne Workman]

This is a concerning row from my DB… goes on for about 5 pages.

Other concerning entries:

FOG_WEB_ROOT
FOG_USER_MINPASSLENGTH
FOG_SERVICE_AUTOLOGOFF_BGIMAGE
FOG_AD_DEFAULT_DOMAINNAME
FOG_AD_DEFAULT_OU
FOG_AD_DEFAULT_USER
FOG_AD_DEFAULT_PASSWORD
FOG_QUICKREG_PENDING_MAC_FILTER
FOG_ADVANCED_STATISTICS
FOG_EMAIL_ACTION
FOG_EMAIL_BINARY
FOG_USED_TASKS

[Wayne Workman]

@Scott-B so… let’s dig in, shall we?

Mysql
use fog
select * from globalSettings\G;

Post the results of the last command, please. use a code box.

[Scott B]

@Wayne-Workman said in After upgrade to trunk 7324, no settings available under FOG Configuration - FOG Settings:

Yeah, I’m still not affected on r7390… I’m using Fedora 21 with PHP 5.6.21

Ubuntu 14.04.4 LTS and PHP 5.6.20 here.

[Wayne Workman]

Yeah, I’m still not affected on r7390… I’m using Fedora 21 with PHP 5.6.21

[Wayne Workman]

Version 7386 is what I pulled this morning, and I’m not having the issue… I’ll snapshot and update again…

[Scott B]

@Tom-Elliott said in After upgrade to trunk 7324, no settings available under FOG Configuration - FOG Settings:

What version of FOG? 7324 is old now. I’m already up to 7390 and I cannot replicate the issue at all.

SVN 7390.

[Tom Elliott]

What version of FOG? 7324 is old now. I’m already up to 7390 and I cannot replicate the issue at all.

[Scott B]

@Scott-Adams said in After upgrade to trunk 7324, no settings available under FOG Configuration - FOG Settings:

@Tom-Elliott The upgrade to 7330 gives me all the options again under FOG Settings. YAY!

However, I am still having the issue where I cannot update any of the settings under FOG Settings using the Web UI. I can change other items with FOG Configuration (iPXE config, iPxe menu, etc). Just nothing under FOG Settings. In particular, I am trying to change the kernel I am using under the TFTP Server section. I make the changes, click save. I get the notification that the changes were stored successfully. However, none of the changes actually get made. Any thoughts?

I can confirm. Same here with SVN 7390.