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

[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

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

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

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

[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 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 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 that stuff is in the globalSettings table. Look for yourself and see what I’m talking about. select settingDesc from globalSettings;