• Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login
  • Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login

Version 1.2.0 released!

Scheduled Pinned Locked Moved
General
20
59
40.7k
Loading More Posts
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • J
    Josh Scoville
    last edited by Jul 30, 2014, 2:14 PM

    Hello all,

    What database is the new version of FOG using? I just set up a new server as I need to migrate off some old hardware. I did a fresh install and exported/imported my hosts. I copied over my image files and want to be able to export/import the image database info, but there is no option for this. So I thought I’d mysqldump the images table and import it into the 1.2 database on the new server.

    I may be totally going about this the wrong way and if so, please let me know, but my question is: how do I find the database name that 1.2 is using? When I go to mysql and do a “show databases”, I see no “fog” database like on the old server.

    Please advise as my old server was having problems saying it could not find the entire image file, so I thought I’d go ahead and migrate to the new one. We use FOG heavily for our school system.

    Thanks!

    1 Reply Last reply Reply Quote 0
    • T
      Tom Elliott
      last edited by Jul 30, 2014, 2:43 PM

      [quote=“Josh Scoville, post: 34427, member: 25343”]Hello all,

      What database is the new version of FOG using? I just set up a new server as I need to migrate off some old hardware. I did a fresh install and exported/imported my hosts. I copied over my image files and want to be able to export/import the image database info, but there is no option for this. So I thought I’d mysqldump the images table and import it into the 1.2 database on the new server.

      I may be totally going about this the wrong way and if so, please let me know, but my question is: how do I find the database name that 1.2 is using? When I go to mysql and do a “show databases”, I see no “fog” database like on the old server.

      Please advise as my old server was having problems saying it could not find the entire image file, so I thought I’d go ahead and migrate to the new one. We use FOG heavily for our school system.

      Thanks![/quote]

      It sounds to me like the FOG database never got created on your system. Did you not run through the Schema installer/updater?

      Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

      Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

      Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

      1 Reply Last reply Reply Quote 0
      • J
        Josh Scoville
        last edited by Jul 30, 2014, 2:59 PM

        I did run the schema update and I can log into the new server web gui and was even able to import hosts from a csv file, which did import and show up.

        1 Reply Last reply Reply Quote 0
        • T
          Tom Elliott
          last edited by Jul 30, 2014, 3:05 PM

          In /var/www/fog/lib/fog/Config.class.php under the db_settings method, there should be a line like:
          [code]define(‘DATABASE_NAME’, ‘fog’);[/code]

          This should be the name of the database per default. If you edited the file or this isn’t set correctly, it should, at the least tell what the new database name is being referenced.

          Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

          Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

          Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

          1 Reply Last reply Reply Quote 0
          • J
            Josh Scoville
            last edited by Jul 30, 2014, 3:13 PM

            That’s weird. It says fog in the name setting in the php file, but when I gype mysql > show databases; fog is not listed. I try a “use database” command, but it says access denied. Could it be hidden or something? It has to be there, obviously since the web interface is running?

            Am I even on the right track trying to import this image table? Or should I just recreate the names?

            1 Reply Last reply Reply Quote 0
            • T
              Tom Elliott
              last edited by Jul 30, 2014, 3:25 PM

              I’d recommend recreate the names. I don’t know why the db is reporting that it’s access is denied, but maybe the user you’re logged into mysql with isn’t allowed?

              Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

              Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

              Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

              1 Reply Last reply Reply Quote 0
              • J
                Josh Scoville
                last edited by Jul 30, 2014, 3:28 PM

                OK, this is weird. I thought I’d try creating a new image and see if I can get it to work. This time when I click the button to add the image, I get a schema update message, so I click the button to update.

                I get a tone of errors back inclucing the following:

                [CODE]Update/Install Failed!
                The following errors occured

                Update ID: 1 - 0

                Database Error:

                Database SQL:

                CREATE DATABASE fog

                Update ID: 1 - 1

                Database Error:

                Database SQL:

                CREATE TABLE fog.groupMembers (
                gmID int(11) NOT NULL auto_increment,
                gmHostID int(11) NOT NULL,
                gmGroupID int(11) NOT NULL,
                PRIMARY KEY (gmID),
                KEY new_index (gmHostID),
                KEY new_index1 (gmGroupID)
                ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC

                Update ID: 1 - 2

                Database Error:

                Database SQL:

                CREATE TABLE fog.groups (
                groupID int(11) NOT NULL auto_increment,
                groupName varchar(50) NOT NULL,
                groupDesc longtext NOT NULL,
                groupDateTime datetime NOT NULL,
                groupCreateBy varchar(50) NOT NULL,
                groupBuilding int(11) NOT NULL,
                PRIMARY KEY (groupID),
                KEY new_index (groupName)
                ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1

                Update ID: 1 - 3

                Database Error:

                Database SQL:

                CREATE TABLE fog.history (
                hID int(11) NOT NULL auto_increment,
                hText longtext NOT NULL,
                hUser varchar(200) NOT NULL,
                hTime datetime NOT NULL,
                hIP varchar(50) NOT NULL,
                PRIMARY KEY (hID)
                ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1

                Update ID: 1 - 4

                Database Error:

                Database SQL:

                CREATE TABLE fog.hosts (
                hostID int(11) NOT NULL auto_increment,
                hostName varchar(16) NOT NULL,
                hostDesc longtext NOT NULL,
                hostIP varchar(25) NOT NULL,
                hostImage int(11) NOT NULL,
                hostBuilding int(11) NOT NULL,
                hostCreateDate datetime NOT NULL,
                hostCreateBy varchar(50) NOT NULL,
                hostMAC varchar(20) NOT NULL,
                hostOS int(10) unsigned NOT NULL,
                PRIMARY KEY (hostID),
                KEY new_index (hostName),
                KEY new_index1 (hostIP),
                KEY new_index2 (hostMAC),
                KEY new_index3 (hostOS)
                ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1

                Update ID: 1 - 5

                Database Error:

                Database SQL:

                CREATE TABLE fog.images (
                imageID int(11) NOT NULL auto_increment,
                imageName varchar(40) NOT NULL,
                imageDesc longtext NOT NULL,
                imagePath longtext NOT NULL,
                imageDateTime datetime NOT NULL,
                imageCreateBy varchar(50) NOT NULL,
                imageBuilding int(11) NOT NULL,
                imageSize varchar(200) NOT NULL,
                PRIMARY KEY (imageID),
                KEY new_index (imageName),
                KEY new_index1 (imageBuilding)
                ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1

                Update ID: 1 - 6

                Database Error:

                Database SQL:

                CREATE TABLE fog.schemaVersion (
                vID int(11) NOT NULL auto_increment,
                vValue int(11) NOT NULL,
                PRIMARY KEY (vID)
                ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC

                Update ID: 1 - 7

                Database Error:

                Database SQL:

                CREATE TABLE fog.supportedOS (
                osID int(10) unsigned NOT NULL auto_increment,
                osName varchar(150) NOT NULL,
                osValue int(10) unsigned NOT NULL,
                PRIMARY KEY (osID),
                KEY new_index (osValue)
                ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1

                Update ID: 1 - 8

                Database Error:

                Database SQL:

                CREATE TABLE fog.tasks (
                taskID int(11) NOT NULL auto_increment,
                taskName varchar(250) NOT NULL,
                taskCreateTime datetime NOT NULL,
                taskCheckIn datetime NOT NULL,
                taskHostID int(11) NOT NULL,
                taskState int(11) NOT NULL,
                taskCreateBy varchar(200) NOT NULL,
                taskForce varchar(1) NOT NULL,
                taskScheduledStartTime datetime NOT NULL,
                taskType varchar(1) NOT NULL,
                taskPCT int(10) unsigned zerofill NOT NULL,
                PRIMARY KEY (taskID),
                KEY new_index (taskHostID),
                KEY new_index1 (taskCheckIn),
                KEY new_index2 (taskState),
                KEY new_index3 (taskForce),
                KEY new_index4 (taskType)
                ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1

                Update ID: 1 - 9

                Database Error:

                Database SQL:

                CREATE TABLE fog.users (
                uId int(11) NOT NULL auto_increment,
                uName varchar(40) NOT NULL,
                uPass varchar(50) NOT NULL,
                uCreateDate datetime NOT NULL,
                uCreateBy varchar(40) NOT NULL,
                PRIMARY KEY (uId),
                KEY new_index (uName),
                KEY new_index1 (uPass)
                ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1

                Update ID: 1 - 10

                Database Error:

                Database SQL:

                INSERT INTO fog.users VALUES (‘’,‘fog’, MD5(‘password’),‘0000-00-00 00:00:00’,‘’)

                Update ID: 1 - 11

                Database Error:

                Database SQL:

                INSERT INTO fog.supportedOS VALUES (‘’,‘Windows XP’, ‘1’)

                Update ID: 1 - 12

                Database Error:

                Database SQL:

                INSERT INTO fog.schemaVersion VALUES (‘’,‘1’)

                Update ID: 2 - 0

                Database Error:

                Database SQL:

                INSERT INTO fog.supportedOS VALUES (‘’,‘Windows Vista’, ‘2’)[/CODE]

                1 Reply Last reply Reply Quote 0
                • J
                  Jose Antonio Sanchez
                  last edited by Jul 30, 2014, 4:49 PM

                  I keep getting the “Database Schema Installer / Updater” message this all the time now with clean installs of FOG 1.2.0 (three different FOG Servers).

                  The server works, then I can create images at first, deploy them, then after a while, boom! nothing. All I get is the “Database Schema Installer / Updater” page.

                  Is there a fix for this? I left the MySQL password blank and tried the fixes other’s used as indicated on this thread. How can I avoid this? I can’t deploy images now…

                  Any help appreciated.

                  Thank you.

                  1 Reply Last reply Reply Quote 0
                  • T
                    Tom Elliott
                    last edited by Jul 30, 2014, 4:52 PM

                    Grrr, Read the forums.

                    Anyway,

                    Check the /opt/fog/.fogsettings specifically the snmysqlpass variable setting and make it B"" in the case of blank, or set it to that of the mysql root password you need.

                    Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                    Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                    Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                    1 Reply Last reply Reply Quote 0
                    • J
                      Jose Antonio Sanchez
                      last edited by Jul 30, 2014, 4:57 PM

                      Tom,

                      I already tried that. Still no luck… Something seems to be triggering an “update” for the schema.

                      .fogsettings file (bottom part only):

                      password=“”;
                      osid=“2”;
                      osname=“Debian”;
                      dodhcp=“n”;
                      bldhcp=“0”;
                      installtype=“N”;
                      snmysqluser=“”
                      snmysqlpass=“”;
                      snmysqlhost=“”;
                      installlang=“0”;
                      donate=“0”;
                      fogupdateloaded=“1”

                      1 Reply Last reply Reply Quote 0
                      • T
                        Tom Elliott
                        last edited by Jul 30, 2014, 5:00 PM

                        Does your database have a password?

                        You can test with:
                        [code]mysql -u root fog[/code]

                        If it gives you “USING PASSWORD: NO” but fails to connect, it’s likely you have a mysql root password set.

                        Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                        Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                        Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                        1 Reply Last reply Reply Quote 0
                        • J
                          Josh Scoville
                          last edited by Jul 30, 2014, 5:03 PM

                          Can anyone give any help on how to get existing image files to work with a new install (or at least point me to the right forum)? These are from a 0.32 server and it is going to be a lot of work to reimage/reupload them.

                          I have tried a new image, definition, but it does not see the size of the existing image file, even though they are named teh same. Also when I download it, it says “this is not a partclone image”

                          Thanks!

                          1 Reply Last reply Reply Quote 0
                          • J
                            Junkhacker Developer
                            last edited by Jul 30, 2014, 5:06 PM

                            enable the image format flag in gui, set the image format to partimage, make sure the permissions and ownership of the files is right, and stop asking questions in an announcement thread

                            signature:
                            Junkhacker
                            We are here to help you. If you are unresponsive to our questions, don't expect us to be responsive to yours.

                            1 Reply Last reply Reply Quote 0
                            • J
                              Jose Antonio Sanchez
                              last edited by Jul 30, 2014, 5:26 PM

                              [quote=“Tom Elliott, post: 34447, member: 7271”]Does your database have a password?

                              You can test with:
                              [code]mysql -u root fog[/code]

                              If it gives you “USING PASSWORD: NO” but fails to connect, it’s likely you have a mysql root password set.[/quote]

                              Tom,

                              It went right in… no password set, and it took me to the “mysql>” prompt (it also displays MySQL version info before that - 5.5.38-0ubuntu.14.04.1 (Ubuntu))

                              1 Reply Last reply Reply Quote 0
                              • J
                                Josh Scoville
                                last edited by Jul 30, 2014, 5:35 PM

                                [quote=“Junkhacker, post: 34451, member: 21583”]enable the image format flag in gui, set the image format to partimage, make sure the permissions and ownership of the files is right, and stop asking questions in an announcement thread[/quote]

                                Thanks for the info. That was invaluable and worked! Sorry for asking in an announcement thread, didn’t realize I was in one.

                                Thanks,

                                1 Reply Last reply Reply Quote 0
                                • T
                                  Tom Elliott
                                  last edited by Jul 30, 2014, 5:39 PM

                                  [quote=“Jose Antonio Sanchez, post: 34455, member: 25349”]Tom,

                                  It went right in… no password set, and it took me to the “mysql>” prompt (it also displays MySQL version info before that - 5.5.38-0ubuntu.14.04.1 (Ubuntu))[/quote]

                                  Then can you check the /var/www/fog/lib/fog/Config.class.php file specifically under the db_settings() method and make sure the DATABASE_HOST is localhost, DATABASE_NAME is fog, DATABASE_USERNAME is root, and DATABASE_PASSWORD is ‘’

                                  Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                                  Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                                  Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                                  1 Reply Last reply Reply Quote 0
                                  • J
                                    Jose Antonio Sanchez
                                    last edited by Jul 30, 2014, 5:46 PM

                                    Tom,

                                    Yes, confirmed, the settings are as follows on /var/www/fog/lib/fog/Config.class.php

                                    DATABASE_HOST ‘localhost’
                                    DATABASE_NAME ‘fog’
                                    DATABASE_USERNAME ‘root’
                                    DATABASE_PASSWORD ‘’

                                    1 Reply Last reply Reply Quote 0
                                    • T
                                      Tom Elliott
                                      last edited by Jul 30, 2014, 6:55 PM

                                      Can you try:
                                      sudo service mysql restart, or simply a system reboot? Maybe firewall is blocking access to mysql from your systems?

                                      Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                                      Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                                      Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                                      1 Reply Last reply Reply Quote 0
                                      • J
                                        Jose Antonio Sanchez
                                        last edited by Jul 30, 2014, 9:01 PM

                                        Tom,

                                        I restarted the server several times, and it seemed to load the web interface but then a minute after it was displaying the “Database Schema Installer / Updater” accompanied by the client PCs not able to load anything from TFTP… This is the same for the other two FOG Servers I installed from scratch on Ubuntu 14.04.

                                        Here are the steps I followed, in case they are of help:
                                        [LIST]
                                        []Installed Ubuntu 14.04 from flash drive with options:
                                        [LIST]
                                        [
                                        ]Download Updates during Install
                                        []Erased Hard drive (it was brand new but nothing else installed)
                                        [
                                        ]Restarted
                                        []Installed all Ubuntu updates (nothing else added or installed)
                                        [
                                        ]Restarted
                                        [/LIST]
                                        []Installed FOG 1.2.0 from TAR:
                                        [LIST]
                                        [
                                        ]Downloaded FOG 1.2.0
                                        []tar xvzf fog_1.2.0.tar.gz
                                        [
                                        ]sudo ./installfog.sh
                                        [LIST]
                                        []Followed prompts for Debian (Ubuntu install)
                                        [
                                        ]Normal Install
                                        []No DHCP
                                        [
                                        ]Selected appropriate Router Address
                                        []Entered DNS IP
                                        [
                                        ]Left MySQL password blank
                                        []Logged in to web interface to install Schema
                                        [
                                        ]Hit Enter to proceed
                                        [/LIST]
                                        [/LIST]
                                        [/LIST]
                                        After that I did:
                                        [LIST]
                                        []Quick registered host with Master Image
                                        [
                                        ]Capture image from first host (Image ID # 1)
                                        []Full hosts registration for 29 computers
                                        [LIST]
                                        [
                                        ]Selected Image ID 1 for all hosts
                                        [/LIST]
                                        []Created group for the 29 computers (computer lab)
                                        [
                                        ]Multicasted image to 29 clients
                                        []Shut down server (yesterday)
                                        [
                                        ]Turned on server today
                                        [*]Tried to multicast image again on the next day (we were testing imaging) and started to get the page for the schema update
                                        [/LIST]
                                        EDIT:

                                        • Created user to allow login via PXE Menu
                                        • Edited the PXE Menu to Timeout 5 seconds and Hide menu - Press F9 to login
                                        1 Reply Last reply Reply Quote 0
                                        • T
                                          Tom Elliott
                                          last edited by Jul 30, 2014, 9:24 PM

                                          Okay, so the issue, I believe, is because if ibdata.log.

                                          Try the steps at the top of this issue in my github?
                                          [url]https://github.com/mastacontrola/fogproject/issues/1[/url]

                                          Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                                          Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                                          Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                                          1 Reply Last reply Reply Quote 0
                                          • 1
                                          • 2
                                          • 3
                                          • 2 / 3
                                          2 / 3
                                          • First post
                                            35/59
                                            Last post

                                          155

                                          Online

                                          12.0k

                                          Users

                                          17.3k

                                          Topics

                                          155.2k

                                          Posts
                                          Copyright © 2012-2024 FOG Project