search

jarischaefer / docker-librenms

Docker image for LibreNMS
MIT License
117 stars 38 forks source link

Unhandled MySQL Error [42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'auth_type' in 'where clause' #94

Closed x-Felix closed 6 years ago

x-Felix commented 6 years ago

I upgrade docker librenms to 1.44 release and mariadb to the latest couple minutes ago. Then I tried to login admin portal and got the above error message.

Please suggest any way to fix this?

Seems like the API login is not impacted as I can still use mobile app to view the devices.

x-Felix commented 6 years ago

docker exec librenms setup_database fixed the issue.

And now, Github also has issues with its DB or cache? Content is not displaying sometimes. 404 and flapping data.

jarischaefer commented 6 years ago

For safety reasons, database updates need to be triggered manually. Please see @E-t-z 's answer. However, you could pass DAILY_ON_STARTUP=true to run daily.sh (which also upgrades the database) on every container start. Beware of concurrent execution though (it might not be safe in all setups, but single-container setups are ok).

And now, Github also has issues with its DB or cache? Content is not displaying sometimes. 404 and flapping data.

Indeed, I got the e-mails but could not open the issue.