Pandora FMS community forums
Installation problems on Ubuntu 16.04 - Printable Version

+- Pandora FMS community forums (https://pandorafms.org/forum)
+-- Forum: Pandora FMS (https://pandorafms.org/forum/forum-3.html)
+--- Forum: Advanced troubleshooting and problems (https://pandorafms.org/forum/forum-11.html)
+--- Thread: Installation problems on Ubuntu 16.04 (/thread-8499.html)



Installation problems on Ubuntu 16.04 - frepie - 10-04-2017

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:
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-8484.html?highlight=16.04
https://pandorafms.com/forums/thread-8336.html?highlight=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


RE: Installation problems on Ubuntu 16.04 - vic - 10-05-2017

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.


RE: Installation problems on Ubuntu 16.04 - frepie - 10-05-2017

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


RE: Installation problems on Ubuntu 16.04 - vic - 10-05-2017

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.