@Tom-Elliott said in Database Schema error after installation:

I’m lost. What question are you asking?

When I responded to it the message was asking for the login information.

As for phpmyadmin, I don’t know what is or isn’t on your system. You shouldn’t have to do anything special to work with phpmyadmin though. How did you install phpmyadmin? YOu might look into using the “source” information rather than the package as Ubuntu has a nasty habit of telling packages exactly what packages MUST be used for things. While this is normal and fine for most things, when it comes to phpMyAdmin, they have decided it MUST contain PHP version 5, but FOG installs PHP version 7.

Well… let’s say that in the first “blank” installation I’ve installed ubuntu server than using apt-get command I’ve installed, in order, apache2, mysql and php7.
Then I’ve installed phpmyadmin with the command sudo apt-get install phpmyadmin apache2-utils.
After that everything was working fine.

Then I’ve installed Fog 1.3.5.
The setup seemed to be ok but I’ve received an error when udpating the database.
This is the output:

Configuring services Setting up fog user…OK Setting up fog password…OK Stopping FOGMulticastManager.service Service…OK Stopping FOGImageReplicator.service Service…OK Stopping FOGSnapinReplicator.service Service…OK Stopping FOGScheduler.service Service…OK Stopping FOGPingHosts.service Service…OK Stopping FOGSnapinHash.service Service…OK Stopping FOGImageSize.service Service…OK Setting up and starting MySQL…OK Backing up user reports…Done Stopping web service…OK Setting up Apache and PHP files…OK Testing and removing symbolic links if found…OK Backing up old data…OK Copying new files to web folder…OK
find: /home//fog_web_1.3.5.BACKUP/management/other/: No such file or directory Creating config file…OK Downloading binaries needed…OK Unzipping the binaries…Done Copying binaries where needed…Done Enabling apache and fpm services on boot…OK Creating SSL CA…OK Creating SSL Private Key…OK Creating SSL Certificate…OK Creating auth pub key and cert…OK Resetting SSL Permissions…OK Setting up SSL FOG Server…OK Restarting Apache2 for fog vhost…OK Changing permissions on apache log files…OK Backing up database…OK Updating Database…Failed!

Then phpmyadmin was still working BUT pointing to http://ipaddress/fog I received the error i told you before: Database Schema Installer / Updater etc…

Using the command mysql -D fog I received a message about the database non existing.

I’ve solved the FOG problem with the mysql command ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘’;
So I’ve installed the database and FOG was up and running but phpmyadmin stopped working (???).

Then I’ve “resetted” the phpmyadmin installation with the command sudo dpkg-reconfigure phpmyadmin setting user:root password: password

After that phpmyadmin was ok BUT fog presented the warning messagge “Database Schema Installer/ Updater bla bla bla…”

Finally in the /var/www/html/fog/lib/fog/config.class.php I’ve set the parameter define(‘DATABASE_PASSWORD’, “password”);

Now FOG and phpmyadmin are working.

@captatim Would you mind telling us what the problem was and how you were able to fix it? Other users might find this information very helpful too. Thanks in advance!

Thanks for the quick response! The reply with the proper field data helped tremendously, at least after I updated to 1.3.5.

I had a few issues, particularly with the Group Search DN and the Search Scope option, but I got it to work by using my Base DN (dc=company,dc=local) and the Subtree and Below option. Not sure why it wouldn’t work when I narrowed the scope and chose Base and Subtree, but long story short it’s working now after upgrading to 1.3.5.

I also had a few binding issues but found that instead of using the full DN for the bind user I just used the username and it worked fine.

@K.Hays When booting into FOS this way we only need to ensure that the FOS kernel is updated to support new hardware.

So as the developers release new version of the FOS engine all you need to do is download these files and move them to the previously created usb flash drive into the boot folder replacing the existing files.

https://fogproject.org/inits/init.xz https://fogproject.org/inits/init_32.xz https://fogproject.org/kernels/bzImage https://fogproject.org/kernels/bzImage32

In regards to the usb network adapters. When you pxe boot uefi devices you MUST use network adapters recommended by the manufacturer to support pxe booting. When you usb boot into FOS you will have better luck with older USB 2.0 network adapters since those are most likely supported by the linux developers.

Alright, well I already addressed the “file not found” type problem in the RC’s thanks to this. So at least there’s that.

Moved into FOG Problems for now.

Moved as this should be much more prevalent than being reported currently. As stated, I’m not saying this isn’t a problem. Just saying it’s one that I cannot seem to replicate and it isn’t breaking any normal functionality.

@Junkhacker, it worked! Thanks!

Problem solved.It was an old image…

Could this be an IO error beyond 2 GB ?
That used to happen on older 32-bits systems, and is still something to care about with minGW.
I would not expect that from Ubuntu x64, but that conclusion may depend on the compiler used.

Did you check the rcs? I’m pretty sure this was addressed already.

Please install the latest rcs of which you’ll find this issue is already fixed.

@jpaul said in network printers not coming in when imaging with fog 1.2.0:

ill not populate even after all the forced group policy updates per machine . Has anyone found the the problem might be with fog imagining or is it just something wrong with our group policies,

@jpaul it sounds like an issue with your GPO. Is there also a reason why you just started using 1.2.0? It’s fairly outdated and doesn’t support newer operating systems (like Windows 10) very well.

@Tom-Elliott Its works! I’m with RC12 version with dev-branch. Thank you very much for your help.

Running Version 1.4.0-RC-12 SVN Revision: 6069

@Tom-Elliott @ftgjason Sorry missed notifying.

Tom You are the best.

I installed 1.3.5 and it is now working.

Thanks!!!

@Tom-Elliott Thanks Tom, I had the same problem and this fixed it for me!

I have solved my problem. The first problem (connection timeout) comes of the switch, I have change for a router and it works ! The second problem, I have reinstall Windows 10 and it works, I can capture my physical machine !

Thank you for all your help !

@george1421 we moved the conversation to IM since turn around time was much quicker.

We got dnsmasq setup with all of the configuration required to pxe boot in a home router environment. DNSMasq probably won’t be needed in a business envionment since a business will typically have a dedicated dhcp server where you can set dhcp options 66 {next-server] and 67 {boot-file}. In the case of the home routers, dnsmasq will provide these missing values.

At this time the OP is able to pxe boot the VM target computer and was in the process of registering the VM with FOG.

Marking topic solved.

@Tom-Elliott there were few corrupted files on windows and fixed them, and after those it worked fine

That solved it @Tom-Elliott thank you very much. Life saver!