-
Notifications
You must be signed in to change notification settings - Fork 136
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Fresh install: Error Loading database schema #205
Comments
Hello. Pandora database scheme seems to be missing or failing. Have you made sure it is correctly configured?
If problems with the database persist, try installing Pandora with a local database and configure the external one later, as a workaround. |
Actually seems there's a DEFAULT '' on a TEXT field, which is unsupported by MySQL [1]
Going to try... [1] https://stackoverflow.com/questions/3466872/why-cant-a-text-column-have-a-default-value-in-mysql |
Default install went OK. How/Where's the config to change database? |
sql-mode="" |
That would be a workaround. They should fix the SQL statements instead. How/Where's the config to change database in pandoraFMS? |
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 |
Thanks. Updated my previous comment, 'cause it was misleading. How/Where's the config to change database in pandoraFMS? |
Im using a fresh machine running a clean install of mysql
a local one seems to work, but then I cannot find an option in pandorafms to change database (it's an enterprise-only feature?) |
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 |
Fresh install on a clean machine (db is on another host) fails:
Database installed in Ubuntu host.
Installer output:
Installer log:
Messing around with the web installer, it complains:
If there's something more I can provide, please let me know.
The text was updated successfully, but these errors were encountered: