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



  • 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.040_1461695004537_FOGSettings.jpg


  • Moderator

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



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


  • Moderator

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



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


  • Moderator

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


  • Moderator

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


  • Moderator

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



  • @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…

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

  • Moderator

    @Scott-B remove the \G

    select * from globalSettings;



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


  • Moderator

    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

    0_1461862475814_upload-600215b3-9cc7-4d28-b31a-3b10861ed200


  • Moderator

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



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


  • Moderator

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


  • Moderator

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



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


  • Senior Developer

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



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


Log in to reply
 

Looks like your connection to FOG Project was lost, please wait while we try to reconnect.