Pandora FMS community forums

Full Version: Installation problems on Ubuntu 16.04
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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/ma...index.html 

2- I installed php5.6 according to 
https://askubuntu.com/questions/761713/h...untu-16-04 

3- I was given a mysql user with all priviledges by the senior sys admin:
Code:
mysql> SHOW GRANTS FOR pierrefrederick;
+------------------------------------------------------+
| Grants for [email protected]%                         |
+------------------------------------------------------+
| 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)
[attachment=1125]

6-At step 5, process stopped because : unable to create schema, unable to populate database, failure to establish privileges for user pandora
[attachment=1126]
[attachment=1128]



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-848...ight=16.04
https://pandorafms.com/forums/thread-833...ight=16.04

which 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
[attachment=1127]

Any help would be appreciated.

Regards
Hi frepie,

Can you edit this file?
Code:
/etc/mysql/my.cnf

Add this lines in the file:
Code:
[mysqld]
sql_mode=NO_ENGINE_SUBSTITUTION

Then restart mysqld service.
Code:
etc/init.d/MySQL restart

Best regards,

vic.
(10-05-2017, 08:01 AM)vic Wrote: [ -> ]Hi frepie,

Can you edit this file?
Code:
/etc/mysql/my.cnf

Add this lines in the file:
Code:
[mysqld]
sql_mode=NO_ENGINE_SUBSTITUTION

Then restart mysqld service.
Code:
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.
Hi frepie,

After modifying the file, have you reset the mysql server?
The error occurs when you modify the file of the server of mysql, mysql tries to start with the new configuration but as it detects that something is wrong it does not start it.

Best regards,

vic.