SUSE



  • Has anyone been able to get FOG installed on openSUSE or SLE 11sp3? I have tried several times and keep getting stuck because the installer is looking for specific packages. One in particular is mysql-server so I install MySQL onto SLE 11sp3 but that still doesn’t work.

    Oh how I would love to get FOG installed. Any advice or assistance?


  • Senior Developer

    [quote=“Rick Urdahl, post: 39127, member: 27117”]I am getting an error when doing the install update SQL from the webpage.

    [CODE]Database Schema Installer / Updater
    Update/Install Failed!

    The following errors occured
    Update ID: 1 - 10

    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’,’’)
    Update ID: 1 - 11

    Database Error:

    Incorrect integer value: ‘’ for column ‘osID’ at row 1
    Database SQL:

    INSERT INTO fog.supportedOS VALUES (’’,‘Windows XP’, ‘1’)
    Update ID: 1 - 12

    Database Error:

    Incorrect integer value: ‘’ for column ‘vID’ at row 1
    Database SQL:

    INSERT INTO fog.schemaVersion VALUES (’’,‘1’)
    Update ID: 2 - 0

    Database Error:

    Incorrect integer value: ‘’ for column ‘osID’ at row 1
    Database SQL:

    INSERT INTO fog.supportedOS VALUES (’’,‘Windows Vista’, ‘2’)
    Update ID: 5 - 2

    Database Error:

    Incorrect integer value: ‘’ for column ‘osID’ at row 1
    Database SQL:

    INSERT INTO fog.supportedOS VALUES (’’,‘Other’, ‘99’)
    Update ID: 16 - 9

    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’, ‘192.168.1.176’, ‘10’, ‘fog’, ‘’)[/CODE]
    FOG Version: v1.2.0

    OS Version: openSUSE 13.1 (x86_64)

    Can you provide your installation details? Yes, below is the contents of /var/log/foginstall.log

    Have you checked your apache error logs? Can you provide information from these logs?
    /var/log/apache2/error_log
    [CODE][Sun Nov 16 17:04:00.162488 2014] [php5:error] [pid 10355] [client X.X.X.X:38018] PHP Warning: array_key_exists() expects parameter 2 to be array, null given in /srv/www/htdocs/fog/lib/db/MySQL.class.php on line 150, referer: http://X.X.X.X/fog/commons/schemaupdater/index.php?redir=1
    [/CODE]

    Debian based Location (normally)
    /var/log/apache2/error.log
    Redhat based Location (normally)
    /var/log/httpd/error_log

    Have you searched the forums for your issue yet? Yes, and they have been very helpful. I
    Have you checked the wiki yet? Yes, and they have been very helpful.
    Kernel Issues: [url]http://fogproject.org/wiki/index.php/FAQ[/url][/quote]

    You’ve ensured iptables and/or firewall and selinux is disabled?

    It sounds like it’s not passing info to the database (more like the database isn’t accessible.)



  • I am getting an error when doing the install update SQL from the webpage.

    [CODE]Database Schema Installer / Updater
    Update/Install Failed!

    The following errors occured
    Update ID: 1 - 10

    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’,’’)
    Update ID: 1 - 11

    Database Error:

    Incorrect integer value: ‘’ for column ‘osID’ at row 1
    Database SQL:

    INSERT INTO fog.supportedOS VALUES (’’,‘Windows XP’, ‘1’)
    Update ID: 1 - 12

    Database Error:

    Incorrect integer value: ‘’ for column ‘vID’ at row 1
    Database SQL:

    INSERT INTO fog.schemaVersion VALUES (’’,‘1’)
    Update ID: 2 - 0

    Database Error:

    Incorrect integer value: ‘’ for column ‘osID’ at row 1
    Database SQL:

    INSERT INTO fog.supportedOS VALUES (’’,‘Windows Vista’, ‘2’)
    Update ID: 5 - 2

    Database Error:

    Incorrect integer value: ‘’ for column ‘osID’ at row 1
    Database SQL:

    INSERT INTO fog.supportedOS VALUES (’’,‘Other’, ‘99’)
    Update ID: 16 - 9

    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’, ‘192.168.1.176’, ‘10’, ‘fog’, ‘’)[/CODE]
    FOG Version: v1.2.0

    OS Version: openSUSE 13.1 (x86_64)

    Can you provide your installation details? Yes, below is the contents of /var/log/foginstall.log

    Have you checked your apache error logs? Can you provide information from these logs?
    /var/log/apache2/error_log
    [CODE][Sun Nov 16 17:04:00.162488 2014] [php5:error] [pid 10355] [client X.X.X.X:38018] PHP Warning: array_key_exists() expects parameter 2 to be array, null given in /srv/www/htdocs/fog/lib/db/MySQL.class.php on line 150, referer: http://X.X.X.X/fog/commons/schemaupdater/index.php?redir=1
    [/CODE]

    Debian based Location (normally)
    /var/log/apache2/error.log
    Redhat based Location (normally)
    /var/log/httpd/error_log

    Have you searched the forums for your issue yet? Yes, and they have been very helpful. I
    Have you checked the wiki yet? Yes, and they have been very helpful.
    Kernel Issues: [url]http://fogproject.org/wiki/index.php/FAQ[/url]

    [url="/_imported_xf_attachments/1/1514_foginstall.zip?:"]foginstall.zip[/url]



  • Yes, the CentOS install is working just fine. I just was trying to leverage SLED since that is already deployed. However, I threw out another thread ([url]http://fogproject.org/forum/threads/central-fog-server-to-manager-100-remote-sites.9994/#post-22438[/url]) in the regular discussion pertaining to my use case. I was trying to figure out where or how the location patch worked or what needed to happen for that.
    I believe FOG is what I am looking for just not real clear if what I am trying to do is possible.
    Have one central FOG server and on each SLED machine within each District Office in the /tftpboot hold the image. When a client PXE’s they would get the image from the local SLED machine and not come all the way back to Corporate Office to get the image. Then once the notebook is re-imaged pull the BIOS asset ID and use that as the hostname and bind to an Active Directory Domain.


  • Senior Developer

    I’m willing to chime in here. CentOS probably install installing htmldoc, did you follow the wiki?

    You need to have rpmforge repo installed for somethings to install properly on CentOS.


  • Developer

    Right, that’s what I’m trying to help you nail down, those missing pieces and to get them jiving.

    Did your CentOS install go through well? Is it working?

    Because I agree with you, some fundamental pieces seem to be a little difficult to acquire. I’m still working on getting the apache stuff working, I was going to tackle php and things like that today to try to get the web interface working, if time allows :D



  • Just for Giggles to see how everything is suppose to work I stood up a CentOS VM and ran through the installer. Something is missing but I don’t know what on my SLED installation/installer because it doesn’t complete the full installation where you get the address to access the Web UI. It looks like some of the pieces get installed but not everything.


  • Developer

    I, unfortunately, had many things to do this weekend and the opportunity did not present itself.

    That being said, I will be on site with my virtual server tomorrow and I can plug away again :)

    I want to give your script a run and see how she fairs.



  • Installation Started…

    Installing required packages, if this fails
    make sure you have an active internet connection.

    • Skipping package: apache2 (Already Installed)
    • Skipping package: php5 (Already Installed)
    • Skipping package: php5-gd (Already Installed)
    • Skipping package: php5-gettext (Already Installed)
    • Skipping package: mysql (Already Installed)
    • Skipping package: mysql-client (Already Installed)
    • Skipping package: php5-mysql (Already Installed)
    • Skipping package: tftp (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: tar (Already Installed)
    • Skipping package: gzip (Already Installed)
    • Skipping package: make (Already Installed)
    • Skipping package: m4 (Already Installed)
    • Skipping package: gcc (Already Installed)
    • Skipping package: gcc-c++ (Already Installed)
    • Skipping package: htmldoc (Already Installed)
    • Skipping package: perl (Already Installed)
    • Skipping package: perl-Crypt-PasswdMD5 (Already Installed)
    • Skipping package: lftp (Already Installed)
    • Skipping package: clamav (Already Installed)

    Confirming package installation.

    • Checking package: apache2…OK
    • Checking package: php5…OK
    • Checking package: php5-gd…OK
    • Checking package: php5-gettext…OK
    • Checking package: mysql…OK
    • Checking package: mysql-client…OK
    • Checking package: php5-mysql…OK
    • Checking package: tftp…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: tar…OK
    • Checking package: gzip…OK
    • Checking package: make…OK
    • Checking package: m4…OK
    • Checking package: gcc…OK
    • Checking package: gcc-c++…OK
    • Checking package: htmldoc…OK
    • Checking package: perl…OK
    • Checking package: perl-Crypt-PasswdMD5…OK
    • Checking package: lftp…OK
    • Checking package: clamav…OK

    Configuring services.

    • Setting up fog user…Exists
    • Setting up and starting MySql…OK
    • Backing up user reports…OK
    • Setting up and starting Apache Web Serverchown: invalid group: `wwwrun:wwwrun’
      …OK
    • Restoring user reports…OK
    • Configuring Fresh Clamcp: cannot stat `/etc/sysconfig/freshclam’: No such file or directory
      …Failed!
    • Setting up storage…OK
    • Setting up and starting NFS Server…OK
    • Setting up and starting DHCP Server…Skipped
    • Setting up and starting TFTP and PXE Servers…OK
    • Setting up and starting VSFTP Server…OK
    • Setting up sudo settings…OK
    • Setting up FOG Snapins…OK
    • Setting up and building UDPCast…OK
    • Installing init scripts…OK
      FOGScheduler: unknown service
      …OK
    • Setting up FOG Services…OK
    • Starting FOG Multicast Management Server…OK
    • Starting FOG Image Replicator Server…OK
    • Starting FOG Task Scheduler Server…Failed!

    Not certain how important clamav is but the locations were /etc/init.d/freshclam and /usr/bin/freshclam. Not sure if I am still missing a package on that one.

    The Apache Web Server group should be wwwrun:www but I only found one place to place the webuser which is wwwrun.

    I open a browser and key in the IP address and then prompted for authentication. I tried what I put into the mysql stuff but still nada so I am going to read the docs again to make sure I didn’t miss anything on the setup stuff.

    I am attaching the files I modified for SUSE.

    [url="/_imported_xf_attachments/0/529_Fog.zip?:"]Fog.zip[/url][url="/_imported_xf_attachments/0/530_Fog.zip?:"]Fog.zip[/url]


  • Developer

    it’s okay if we beat our head against the wall long enough Tom normally solves it :p

    on a side note I finally got apache working again… time to break some more things :D maybe MYSQL is next :rolleyes:



  • I am going to try a couple other things and then can post my configs to help out with the installer script.


  • Developer

    LOL at this point we should start a separate script for installation on SUSE XD

    I will see what I can do about the Mysql stuff, I am still trying to get some services installed on my vm :/

    I will crack this open at home and give it a whirl, I will try to fully document the process, maybe we can help create an installer script for suse machines.



  • Well, I thought I had this going. I can’t seem to get the web UI up and running and I noticed there is no MySQL database that was created. Not sure what to do next.


  • Senior Developer

    Alright, I’ll probably be around more so tomorrow to help out where I can.



  • I reached the webpage I believe I am getting prompted for credentials. I am still having a slight issue with MySQL getting up and running so troubleshooting that at the moment. May call it a day and hit it again tomorrow.

    I’ll keep you all posted.


  • Senior Developer

    Does SUSE support the service command?

    I think you’d need to use /etc/init.d/<filename> restart for this to work on your particular system.



  • And yet a little further…

    • Setting up sudo settings…OK
    • Setting up FOG Snapins…OK
    • Setting up and building UDPCast…OK
    • Installing init scriptsFOGMulticastManager: unknown service
      FOGImageReplicator: unknown service
      FOGScheduler: unknown service
      …OK
    • Setting up FOG Services…OK
    • Starting FOG Multicast Management Server…Failed!


  • cat /etc/release /etc/issue
    LSB_VERSION="core-2.0-noarch:core-3.2-noarch:core-4.0-noarch:core-2.0-x86_64:core-3.2-x86_64:core-4.0-x86_64"
    cat: /etc/lsb-release.d: Is a directory
    SUSE Linux Enterprise Desktop 11 (x86_64)
    VERSION = 11
    PATCHLEVEL = 3
    SUSE Linux Enterprise Desktop 11 (x86_64)
    VERSION = 11
    PATCHLEVEL = 3

    Welcome to SUSE Linux Enterprise Desktop 11 SP3 (x86_64) - Kernel \r (\l).


  • Senior Developer

    Well, it sounds like you’ve figured out all the details of the files needed to be installed.

    What gets output when you run the command:
    [code]cat /etc/release /etc/issue[/code]



  • I would love all the help I can get right now. Chime away. :)


Log in to reply
 

401
Online

38937
Users

10696
Topics

101490
Posts

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