Database connection appears invalid on install

[dylan123]

Server

• FOG Version: 1.3.4
• OS: Ubuntu 14.04.5 LTS

Client

• Service Version:
• OS:

Description

I’ve been having a number of issues getting FOG to install, previously I wasn’t even able to get to the database schema installer / updater page on my client when I was using the latest LTS version of Ubuntu (16.04.1). I’ve since installed 14.04 LTS today to see if I could get any further which I suppose I have by one step but I’m still unable to get it to work.

During the install I get prompted to access the fog management database to update it however when I get to that section it says my connection appears to be invalid and I’m unsure what might be causing the issue.

On the first part of the install I’ve noticed the below which I’m not sure is out of place or normal?

Mainly with stopping the web services and the potential need to reinstall apache and php files.

The rest of the install appears to work fine, the web service starts up correctly at the end of the install and it doesn’t report any further errors until I get to the below part when I load the database management site -

• I’ve gone to the config.class.php file and it has the correct MYSQL database password that I set on install so that appears right.
• I’ve followed this thread https://forums.fogproject.org/topic/9344/your-database-connection-appears-to-be-invalid/11 and removed the packages line (no ver or veradds lines) and re-run the installer with no success.
• I’ve tried running this command ‘sudo netstat -tap | grep mysql’ to see if my database was running and the return I got was basically as suggested I should if it is running as per this link - https://help.ubuntu.com/lts/serverguide/mysql.html

Any suggestions on what I should try or anything I can provide on my side to help identify where it’s going wrong? I have next to no experience with Ubuntu so I don’t really know what to try.

Thanks

[craigcoulson]

I have the same issue - 1.3.4 svn6064 on Debian 8
Db was not created during install

[Sebastian Roth]

Can you please both upload your install logs?

[dylan123]

@Sebastian-Roth said in Database connection appears invalid on install:

Can you please both upload your install logs?

Where would I find my fog install logs? Since I’m running Ubuntu Server I’ve only got command line, I’ve poked around a little but I don’t think I’m really finding what you’re after.

[Tom Elliott]

@dylan123 Trying to hit you on chat.

[craigcoulson]

as requested

1_1486021926618_foginstall.log [0_1486021926618_fog_error_1.3.4.log]

(/uploads/files/1486021948219-fog_error_1.3.4.log)

[craigcoulson]

@craigcoulson 0_1486021959995_fog_error_1.3.4.log

[Sebastian Roth]

@craigcoulson I am pretty sure you have a different issue as your logs don’t have that same message posted by Dylan. Do you have the exact same database error message on the webinterface?

@dylan123 To me this sounds a bit like you did set a mysql password at some point and just forgot about it. Are you able to login to the database using the mysql command line tool?

[craigcoulson]

@Sebastian-Roth - it is - ill start a different thread tho as it doesnt look the same to you