Pandora FMS Community

Installation problems on Ubuntu 16.04

frepie · 4 oct 2017, 21:20 · 4 mensajes · 99 visitas

  1. Inicio del debate

    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 (Link not available anymore)  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)

    [

    ](//pandorafms.com/community/media/forum/8707/21573=1125-Pandora-FMS-Installation-Wizard_03.png)

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

    [

    ](//pandorafms.com/community/media/forum/8707/21573=1126-Pandora-FMS-Installation-Wizard_04.png)

    [

    ](//pandorafms.com/community/media/forum/8707/21573=1128-Pandora-FMS-Installation-Wizard_05.png)

    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

    [

    ](//pandorafms.com/community/media/forum/8707/21573=1127-Pandora-FMS-Installation-Wizard_051.png)

    Any help would be appreciated. Regards

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

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

  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.

Entra en tu cuenta para publicar.