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

    Version 1.2.0 released!

    Scheduled Pinned Locked Moved
    General
    20
    59
    40.6k
    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.
    • C
      chclark
      last edited by

      Thanks for the advise updated my fog server today

      1 Reply Last reply Reply Quote 0
      • BigDawg986B
        BigDawg986
        last edited by

        Please clarify, when this says now supports multiboot re-sizable imaging, do you mean multi-partition resizable?

        I am still on version .31 and have been hesitant to upgrade because I am the only tech in a 1,500 PC 3,000 user school and can’t risk the downtime.

        1 Reply Last reply Reply Quote 0
        • Jaymes DriverJ
          Jaymes Driver Developer
          last edited by

          [quote=“BigDawg986, post: 33945, member: 75”]Please clarify, when this says now supports multiboot re-sizable imaging, do you mean multi-partition resizable?

          I am still on version .31 and have been hesitant to upgrade because I am the only tech in a 1,500 PC 3,000 user school and can’t risk the downtime.[/quote]

          No when it says Multiboot I means Multiple Operating Systems on the hard drive, such as Windows and Linux on one machine but being able to choose the OS to boot to at each reboot.

          WARNING TO USERS: My comments are written completely devoid of emotion, do not mistake my concise to the point manner as a personal insult or attack.

          1 Reply Last reply Reply Quote 0
          • BigDawg986B
            BigDawg986
            last edited by

            [quote=“Jaymes Driver, post: 33964, member: 3582”]No when it says Multiboot I means Multiple Operating Systems on the hard drive, such as Windows and Linux on one machine but being able to choose the OS to boot to at each reboot.[/quote]

            Thanks, I should have figured as much but whenever I set up multiboots I always put each OS in a separate partition so that’s why I asked.

            1 Reply Last reply Reply Quote 0
            • Tom ElliottT
              Tom Elliott
              last edited by

              That should still work for you.

              Resizable was never “partition” dependent, just when it was initially implemented it was for XP which only had one partition on a default install.

              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

                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
                • Tom ElliottT
                  Tom Elliott
                  last edited by

                  [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

                    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
                    • Tom ElliottT
                      Tom Elliott
                      last edited by

                      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

                        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
                        • Tom ElliottT
                          Tom Elliott
                          last edited by

                          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

                            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

                              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
                              • Tom ElliottT
                                Tom Elliott
                                last edited by

                                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

                                  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
                                  • Tom ElliottT
                                    Tom Elliott
                                    last edited by

                                    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

                                      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
                                      • JunkhackerJ
                                        Junkhacker Developer
                                        last edited by

                                        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

                                          [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

                                            [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
                                            • 1
                                            • 2
                                            • 3
                                            • 2 / 3
                                            • First post
                                              Last post

                                            197

                                            Online

                                            12.0k

                                            Users

                                            17.3k

                                            Topics

                                            155.2k

                                            Posts
                                            Copyright © 2012-2024 FOG Project