@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.