Fresh install: Error Loading database schema about pandorafms HOT 9 OPEN

sql-mode=""

That would be a workaround. They should fix the SQL statements instead.

How/Where's the config to change database in pandoraFMS?

from pandorafms.

Hello.

Pandora database scheme seems to be missing or failing. Have you made sure it is correctly configured?
Please, take a look on these pandora wiki pages if you haven't before:

• https://pandorafms.com/manual/start?id=en/documentation/05_big_environments/08_optimization
• https://pandorafms.com/manual/start?id=en/documentation/02_installation/01_installing#installing_pandora_fms_with_a_external_database

If problems with the database persist, try installing Pandora with a local database and configure the external one later, as a workaround.

from pandorafms.

Pandora database scheme seems to be missing or failing. Have you made sure it is correctly configured?
It's a clean install, the issue might be on the .sql file being imported.

Actually seems there's a DEFAULT '' on a TEXT field, which is unsupported by MySQL [1]

If problems with the database persist, try installing Pandora with a local database and configure the external one later, as a workaround.

Going to try...

[1] https://stackoverflow.com/questions/3466872/why-cant-a-text-column-have-a-default-value-in-mysql

from pandorafms.

Default install went OK. How/Where's the config to change database?

from pandorafms.

sql-mode=""

from pandorafms.

sql-mode=""

That would be a workaround. They should fix the SQL statements instead.

How/Where's the config to change database?

you're right they should, but I'm not sure if they are working on it... meanwhile there's the disable sql-mode trick...

check https://raazkumar.com/tutorials/mysql/mysql-configuration-file/

if working with containers you can set it explicitely

https://stackoverflow.com/questions/48924667/changing-sql-mode-on-mariadb-image-with-docker-compose

from pandorafms.

Thanks. Updated my previous comment, 'cause it was misleading.

How/Where's the config to change database in pandoraFMS?

from pandorafms.

@tanimientras seems the same problem as the rocky installation, are you using an external database?

Im using a fresh machine running a clean install of mysql
mysql Ver 8.0.31-0ubuntu0.22.04.1 for Linux on x86_64 ((Ubuntu))

Is this database optimized for pandorafms? Could you try to deploy on a local database (default one) to check it?

a local one seems to work, but then I cannot find an option in pandorafms to change database (it's an enterprise-only feature?)

from pandorafms.

I can't install sql because it doesn't click next on the final account path it doesn't accept any file to install please help

from pandorafms.