[quote=“dramaley, post: 45325, member: 29347”]Thank you for the responses so far!
I was able to find where the database is created and might look into hacking it into working. But for now I’ll wait before taking any action, in case someone can help me understand the root cause and fix it more elegantly.
I’ll also attach the foginstall.log and Apache error_log to this post in case that is useful; I did notice some errors in the error_log that I don’t understand yet.
I checked in /var/www/html/fog/lib/fog/Config.class.php and found the root database password was correct. It does use some funny characters, but there are no single quotes in the password so it should be just fine. I can confirm that the database was actually created, with tables:
[root@fog-test fog]# mysql
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 28
Server version: 5.5.41-MariaDB MariaDB Server
Copyright 
2000, 2014, Oracle, MariaDB Corporation Ab and others.
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
MariaDB [(none)]> use fog;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
MariaDB [fog]> show tables;
±-----------------------+
| Tables_in_fog |
±-----------------------+
| aloLog |
| clientUpdates |
| dirCleaner |
| globalSettings |
| greenFog |
| groupMembers |
| groups |
| history |
| hostAutoLogOut |
| hostMAC |
| hostScreenSettings |
| hosts |
| imageTypes |
| images |
| imagingLog |
| inventory |
| keySequence |
| moduleStatusByHost |
| modules |
| multicastSessions |
| multicastSessionsAssoc |
| nfsFailures |
| nfsGroupMembers |
| nfsGroups |
| os |
| oui |
| pendingMACS |
| plugins |
| printerAssoc |
| printers |
| scheduledTasks |
| schemaVersion |
| snapinAssoc |
| snapinJobs |
| snapinTasks |
| snapins |
| supportedOS |
| taskLog |
| taskStates |
| taskTypes |
| tasks |
| userCleanup |
| userTracking |
| users |
| virus |
±-----------------------+
45 rows in set (0.00 sec)
MariaDB [fog]> select * from users;
Empty set (0.00 sec)
MariaDB [fog]>[/quote]
Hi Dramaley,
following this installation error, my database “fog” was not created, I looked in the file (Debian) /var/www/fog/lib/fog/Config.class.php and found that the user root password empty, during the installation of Fog I left it blank, in fact my mysql root user’s password was not empty.
this has fixed my problem on Debian 6.0.3, Debian 7.7, Debian 7.8.
I stay interested to know the solution in your case
Thanks to all.
HEL