Version 1.2.0 released!
-
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.
-
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.
-
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” -
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.
-
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!
-
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=“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))
-
[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,
-
[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 ‘’
-
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 ‘’ -
Can you try:
sudo service mysql restart, or simply a system reboot? Maybe firewall is blocking access to mysql from your systems? -
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
-
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] -
[quote=“BigDawg986, post: 34017, member: 75”]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.[/quote]
which option should I choose to get an image (from win/lin disc) resizable?
my settings:
Operating System: Other (99)
Image Type: Single Disk (Resizable) -(1)What i have to do, to clone from 250GB to 160GB (hd size) ?
Thanks and sorry about my inexperience
-
Choose either Linux or Windows OS type, not other.
-
When creating images in fog ui, these error appears on listing:
FOGFTP: Failed to connect. Host: 192.168.1.12, Error: Undefined variable: whereArrayHow can i fix ?
-
What do you get if you run:
[code]mysql -u root [ -p #only if you have a db password ] fog
select * from images where imageName=“<a name of your image here>” \G;[/code] -
Tom,
I did the delayed start of mysql as indicated on the rc.local file.
now the tftpd-hpa wont respond to requests unless I stop it manually and start it again.
I disabled tftpd-hpa by:
sudo update-rc.d tftpd-hpa disablethen tried doing the same for the tftpd-hpa on the /etc/rc.local file and added:
sleep 30 && start tftpd-hpa
but I still need to top and start tftpd-hpa manually by doing this:
sudo stop tftpd-hpa
sudo start tftpd-hpathen it works…
Any ideas???
-
I get the same error as Thiago:
These error appear in image listing:FOGFTP: Failed to connect. Host:xxxxxxxxxxxxx, Error: Undefined variable: whereArray
How can i fix ?
-
Hi Mr. Daniel Murga,
In my case, with a help from Tom Elliot, the firewall was the problem.
I am running a local firewall on fog machine and unblocking ports to my clients (20,21) solved my problem.
If you need more details, see: [url]http://www.fogproject.org/wiki/index.php?title=FOGUserGuide#Full_Listing_of_Ports_used_by_FOG_server_and_client[/url]
