Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Installation problems on Ubuntu 16.04
#1
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)

.png   Pandora FMS - Installation Wizard_03.png (Size: 17.84 KB / Downloads: 12)

6-At step 5, process stopped because : unable to create schema, unable to populate database, failure to establish privileges for user pandora

.png   Pandora FMS - Installation Wizard_04.png (Size: 38.95 KB / Downloads: 16)

.png   Pandora FMS - Installation Wizard_05.png (Size: 62.23 KB / Downloads: 15)



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

.png   Pandora FMS - Installation Wizard_05(1).png (Size: 13.08 KB / Downloads: 4)

Any help would be appreciated.

Regards
 Reply
#2
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.
 Reply
#3
(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.
 Reply
#4
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.
 Reply


Users browsing this thread: 1 Guest(s)


(c) 2006-2018 Artica Soluciones Tecnológicas. Contents of this wiki are under Create Common Attribution v3 licence. | pandorafms.com | pandorafms.org

Theme © MyBB Themes