-
Installation problems on Ubuntu 16.04
Hi
I’ve been trying to install Pandora FMS on a ubuntu 16.04 server but it fails to complete.Here are the steps I followed:
1 – I successfully removed PHP7 according to
http://installion.co.uk/ubuntu/xenial/main/p/php7.0/uninstall/index.htmlÂ2- I installed php5.6 according toÂ
https://askubuntu.com/questions/761713/how-can-i-downgrade-from-php-7-to-php-5-6-on-ubuntu-16-04Â3- I was given a mysql user with all priviledges by the senior sys admin:
mysql> SHOW GRANTS FOR pierrefrederick; +------------------------------------------------------+ | Grants for pierrefrederick@% Â Â Â Â Â Â Â Â Â Â Â Â | +------------------------------------------------------+ | GRANT ALL PRIVILEGES ON *.* TO 'pierrefrederick'@'%' | +------------------------------------------------------+
4- I ran the php installer:http://remote_ip_address/pandora_console/install.php
5- All conditions are met at step 3 (all green dots)
6-At step 5, process stopped because : unable to create schema, unable to populate database, failure to establish privileges for user pandora
I searched in the forum and and found 2 posts of people that had problems installing on ubuntu 16.04:
https://pandorafms.com/forums/thread-8484.html?highlight=16.04
https://pandorafms.com/forums/thread-8336.html?highlight=16.04which describe modifications to the my.cnf file. I tried them both.
Now, after restarting mysqld, the situation has worsen: at step 5, I am unable to connect to the database
Any help would be appreciated.
Regards
-
3 Replies
-
-
Hi frepie,
Can you edit this file?
/etc/mysql/my.cnf
Add this lines in the file:
[mysqld] sql_mode=NO_ENGINE_SUBSTITUTION
Then restart mysqld service.
etc/init.d/MySQL restart
Best regards,
vic.
Thank you for your quick reply.
This is what I did ( last paragraph of my first post) and just after, I couldn’t connect to the database.
-
