First time install error (mysql)

[eduardo-corral]

Like it

Up

0

Down

Drop it

::

I got an error creating the database. I’m using root user (so it has all privileges).

Greetings, daviduco

In which OS are you installing Pandora FMS? Also, it would be extremely useful if you could tell us which version are you trying to install.

Which version of MySQL are you running?

Kind regards, 

Eduardo.

[daviduco]

Like it

Up

0

Down

Drop it

::

I got an error creating the database. I’m using root user (so it has all privileges).

Greetings, daviduco

In which OS are you installing Pandora FMS? Also, it would be extremely useful if you could tell us which version are you trying to install.

Which version of MySQL are you running?

Kind regards, 

Eduardo.

Hi!

OS version
SLES 12 SP3.

Pandora version
I followed this link.
https://wiki.pandorafms.com/index.php?title=Pandora:Documentation_en:Installing

#SLES 12 SP3
zypper ar -f http://firefly.artica.es/suse PandoraFMS_Official_Repo

MYSQL version
Server version: 10.0.35-MariaDB SLE 12 SP1 package

One more thing, i got this installing the packages (i broke this dependency):

Problem: nothing provides php-mysqlnd needed by pandorafms_console-7.0NG.732-1.noarch

[jose.almendros]

Like it

Up

0

Down

Drop it

::

I got an error creating the database. I’m using root user (so it has all privileges).

Greetings, daviduco

In which OS are you installing Pandora FMS? Also, it would be extremely useful if you could tell us which version are you trying to install.

Which version of MySQL are you running?

Kind regards, 

Eduardo.

Hi!
OS version
It’s SLES 12 SP3.
I followed this link.
https://wiki.pandorafms.com/index.php?title=Pandora:Documentation_en:Installing

#SLES 12 SP3
zypper ar -f http://firefly.artica.es/suse PandoraFMS_Official_Repo

MYSQL version
Server version: 10.0.35-MariaDB SLE 12 SP1 package

One more thing, i got this installing the packages (i broke this dependency):

Problem: nothing provides php-mysqlnd needed by pandorafms_console-7.0NG.732-1.noarch

Hello daviduco,

Check if in my.cnf file exists this line:

sql_mode=NO_ENGINE_SUBSTITUTION.STRICT_TRANS_TABLES

and edit it as follows:

sql_mode=”

Please, tell us if that was the problem.

Regards.

[daviduco]

Like it

Up

0

Down

Drop it

::

Great, that solved it, thanks so much =D