Posts made by Elias Santiago

george1421 managed to fix my setup. For some reason there were concurrent mysql daemons running. After closing all mysqld’s, we tried again and everything went perfectly with the installer. Thank you so much george1421 for your help!

When I setup this server, I setup the user ‘cit’ as the root user. Could that be it?

What FOG requires the root user password to be? I don’t mean the mysql password but the actual root USER password?

@george1421 I did run the ALTER user part.

I’m trying the mysql reset password, it should be the mysql password in the .fogsettings file or it should be ‘fog’ (since the line shows “mysqld -u root -p fog” ??

@george1421 I tried mysql -u root -p fog now and can’t login! This was after removing the “unattended-updates” from Ubuntu.

@george1421 something weird is going on. After I did the Ubuntu stuff you mentioned (removing the unattended-updates) I can’t login to mysql using the same line and password as before!

How do I fix that?

@george1421 said in Update FOG to 1.4.4 from 1.3.x and FOG can't load:

@elias-santiago just to confirm one more time. You know the password to log into mysql using mysql -u root -p fog right? If you can have your confirmed in your /opt/fog/.fogsettings file that snmysqluser='root' and snmysqlpass= the password you used to login to mysql and snmysqlhost='127.0.0.1'

There is something wrong here. The error says the .fogsettings file is wrong.

snmysqlhost = ‘localhost’

NOT ‘127.0.0.1’

@george1421 said in Update FOG to 1.4.4 from 1.3.x and FOG can't load:

@elias-santiago has the database password changed for some reason? Have you changed the root user mysql password?

If you look in the file /opt/fog/.fogsettings. There should be the mysql user ID and password listed there. See if you can use that to login to the mysql console with mysql -u root -p fog and when prompted use the mysql password listed in the .fogsettings file.

Since you are also running ubuntu you may want to review this post: https://forums.fogproject.org/topic/10006/ubuntu-is-fog-s-enemy

I already did what you recommended about Ubuntu.

@george1421 There seems to be some issue with mysql (never had it before), there is a line in the installer error log that says:

ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: YES)

How do I fix that? I know my way around servers and everything, but in Unix I’m still somewhat of a novice.

@george1421 I have never set the proxy setting, in what file do I find it?

The fog server connects directly to internet.

No matter how many times I retry the installer, everything seems to go smoothly until this line comes up: Database backup… failed.

@sebastian-roth Here is my apache2 error log. The 500 Server error just comes up as we try to access the server page on the browser. Before trying to update, everything was working fine!

[Tue Aug 15 11:58:39.186277 2017] [mpm_prefork:notice] [pid 2174] AH00163: Apache/2.4.27 (Ubuntu) OpenSSL/1.1.0f configured – resuming normal operations
[Tue Aug 15 11:58:39.186357 2017] [core:notice] [pid 2174] AH00094: Command line: ‘/usr/sbin/apache2’
[Tue Aug 15 11:58:41.413870 2017] [php7:error] [pid 2179] [client 10.10.1.5:52613] PHP Fatal error: Uncaught Error: Call to a member function lastInsertId() on boolean in /var/www/fog/lib/db/pdodb.class.php:443\nStack trace:\n#0 /var/www/fog/lib/fog/fogcontroller.class.php(527): PDODB->insertId()\n#1 /var/www/fog/lib/fog/hookmanager.class.php(59): FOGController->save()\n#2 /var/www/fog/lib/fog/reportmaker.class.php(75): HookManager->processEvent(‘REPORT_TYPES’, Array)\n#3 [internal function]: ReportMaker->__construct()\n#4 /var/www/fog/lib/fog/fogbase.class.php(457): ReflectionClass->newInstanceArgs(Array)\n#5 /var/www/fog/maintenance/backup_db.php(23): FOGBase::getClass(‘ReportMaker’)\n#6 {main}\n thrown in /var/www/fog/lib/db/pdodb.class.php on line 443
[Tue Aug 15 11:58:58.611333 2017] [php7:error] [pid 2177] [client 10.10.2.28:18047] PHP Fatal error: Uncaught Error: Call to a member function lastInsertId() on boolean in /var/www/fog/lib/db/pdodb.class.php:443\nStack trace:\n#0 /var/www/fog/lib/fog/fogcontroller.class.php(527): PDODB->insertId()\n#1 /var/www/fog/lib/fog/hookmanager.class.php(59): FOGController->save()\n#2 /var/www/fog/lib/fog/fogpagemanager.class.php(82): HookManager->processEvent(‘SEARCH_PAGES’, Array)\n#3 [internal function]: FOGPageManager->__construct()\n#4 /var/www/fog/lib/fog/fogbase.class.php(457): ReflectionClass->newInstanceArgs(Array)\n#5 /var/www/fog/management/index.php(23): FOGBase::getClass(‘FOGPageManager’)\n#6 {main}\n thrown in /var/www/fog/lib/db/pdodb.class.php on line 443
[Tue Aug 15 11:59:03.516960 2017] [php7:error] [pid 2178] [client 10.10.2.28:18051] PHP Fatal error: Uncaught Error: Call to a member function lastInsertId() on boolean in /var/www/fog/lib/db/pdodb.class.php:443\nStack trace:\n#0 /var/www/fog/lib/fog/fogcontroller.class.php(527): PDODB->insertId()\n#1 /var/www/fog/lib/fog/hookmanager.class.php(59): FOGController->save()\n#2 /var/www/fog/lib/fog/fogpagemanager.class.php(82): HookManager->processEvent(‘SEARCH_PAGES’, Array)\n#3 [internal function]: FOGPageManager->__construct()\n#4 /var/www/fog/lib/fog/fogbase.class.php(457): ReflectionClass->newInstanceArgs(Array)\n#5 /var/www/fog/management/index.php(23): FOGBase::getClass(‘FOGPageManager’)\n#6 {main}\n thrown in /var/www/fog/lib/db/pdodb.class.php on line 443
[Tue Aug 15 11:59:06.877776 2017] [php7:error] [pid 2192] [client 10.10.2.28:18055] PHP Fatal error: Uncaught Error: Call to a member function lastInsertId() on boolean in /var/www/fog/lib/db/pdodb.class.php:443\nStack trace:\n#0 /var/www/fog/lib/fog/fogcontroller.class.php(527): PDODB->insertId()\n#1 /var/www/fog/lib/fog/hookmanager.class.php(59): FOGController->save()\n#2 /var/www/fog/lib/fog/fogpagemanager.class.php(82): HookManager->processEvent(‘SEARCH_PAGES’, Array)\n#3 [internal function]: FOGPageManager->__construct()\n#4 /var/www/fog/lib/fog/fogbase.class.php(457): ReflectionClass->newInstanceArgs(Array)\n#5 /var/www/fog/management/index.php(23): FOGBase::getClass(‘FOGPageManager’)\n#6 {main}\n thrown in /var/www/fog/lib/db/pdodb.class.php on line 443

@george1421 No proxy. It does connect to the internet but it is an internal IP. Not accesible from outside the network.

@george1421 NO, database password (or any password) have been changed. I tried your command and I can login to the mysql database without problem.

@george1421 NO, database password (or any password) have been changed. I tried your command and I can login to the mysql database without problem. I will try the link you posted about Ubuntu and see if that’s it.

Server

• FOG Version: 1.4.4.4
• OS: Ubuntu

Description

When running the installer I got the “Database Backup… failed line”.

Tried to load FOG webpage (using Chrome) and I get HTTP ERROR 500.
I can access the filesystem and my images are there, how do I fix this or go back to the backup (made by the installer)???

What does the “Exit to Hard Drive Type” do/change?

Sorry for so much trouble!

I [SIZE=3][COLOR=#000000]went in and ran: [/COLOR][/SIZE]

[SIZE=3][COLOR=#000000]sudo passwd fog (reset fog user password)[/COLOR][/SIZE]

[SIZE=3][COLOR=#000000]then [/COLOR][/SIZE]

[FONT=Consolas][SIZE=3][COLOR=#000000]chown -R fog:root /var/www/fog/service/ipxe[/COLOR][/SIZE][/FONT]
[FONT=Consolas][COLOR=#000000][SIZE=3]chown -R fog:root /images[/SIZE][/COLOR][/FONT]

[FONT=Consolas][SIZE=3][COLOR=#000000]then on FOG interface: [/COLOR][/SIZE][/FONT]

[COLOR=#000000][SIZE=3][FONT=Consolas]Storage Management -> [FONT=Ubuntu]Management Username / Password to fog / (**fog user password - same as used on passwd line above)[/FONT][/FONT][/SIZE][/COLOR]
[COLOR=#000000][SIZE=3][FONT=Ubuntu]FOG - Configuration ->Settings -> [/FONT][/SIZE][/COLOR][FONT=Tahoma]FOG_TFTP_FTP_USERNAME and FOG_TFTP_FTP_PASSWORD. (same as user/pass as Storage Management )[/FONT]

[COLOR=#000000][SIZE=3][FONT=Tahoma]FINALLY SOLVED! [/FONT][/SIZE][/COLOR]

[COLOR=#000000][SIZE=3][FONT=Tahoma]I think my problems were that I had another user for logging to FOG web interface, and that user was also the one in the Storage [/FONT][/SIZE][/COLOR][FONT=Tahoma]and TFTP settings (not the fog user). [/FONT]

[COLOR=#000000][SIZE=3][FONT=Tahoma]Previously on 0.32b I had it that way and worked OK. After updating to FOG 1.1.0 I started having trouble with either uploading, [/FONT][/SIZE][/COLOR][FONT=Tahoma]kernel update, etc. [/FONT]
[FONT=Consolas][SIZE=3][COLOR=#000000]Does everything have to be with the “fog” user?[/COLOR][/SIZE] [/FONT]

Still can’t update the kernels thru the FOG interface.

I think I have a permissions issue in one or more folders.

I try to image a new computer (upload) and it starts imaging, everything ok until it finishes which shows:

• FOGFTP: Failed to rename file. Remote Path: /images/temp**** , Local Path: /images/dev/fb8c******, Error: ftp_rename(): Rename failed.

Ok I just double checked everything. I just noticed that on FOG 1.x.x under “Storage Management” you now have the “Management username” and “Management Password” over there. I noticed that upon FOG 1.1.0 install, it changed that information (fog and a really long password), I changed it to the user/password that I have always used with FOG, restarted the server. And now everything is OK with image uploading.

I also ran sudo apt-get update and sudo apt-get upgrade to update all the software in my installation. Apparently all those steps did the trick.

However, I still can’t update any kernels thru the FOG web interface. It downloads the kernel but stops at “[FONT=Ubuntu][COLOR=#555555]Download Completed! Moving [COLOR=#000000]file to TFTP server…” [/COLOR][/COLOR][/FONT]

Confirmed the bad RAM issue with a bootcd (Memtest86+).

On the FTP issue, I uploaded two images while I was on 1.0.1. Upon changing to 1.1.0, I just checked and I CAN’T!!! .
When I try I get the: “Can’t mount NFS volume!” When trying to upload.

I regularly use Filezilla to connect to the FOG server to transfer files. I normally connect to it via SFTP. After upgrading from 1.0.1 to 1.1.0 I can connect using SFTP, but NOT via FTP. vsftp is version 2.3.5.

What files do I have to check?