Webmail internal server error, Failed to load password plugin config

[steelyx]

@sahsanu

mysql -uroot -e "GRANT ALL ON \roundcube`.* TO `roundcube`@`localhost` IDENTIFIED BY ‘HereThePassword’"`

Still internal error and I found this in roundcube error log:

[04-Jun-2024 12:44:32 +0200]: <htbsk62b> DB Error: [1146] Table 'roundcube.session' doesn't exist (SQL Query: SELECT `vars`, `ip`, `changed`, now() AS ts, CASE WHEN `changed` < now() - INTERVAL 600 SECOND THEN 1 ELSE 0 END AS expired FROM `session` WHERE `sess_id` = 'htbsk62bvt5301lumbs700piea') in /var/lib/roundcube/program/lib/Roundcube/rcube_db.php on line 577 (GET /)
[04-Jun-2024 12:44:32 +0200]: <htbsk62b> DB Error: [1146] Table 'roundcube.session' doesn't exist (SQL Query: INSERT INTO `session` (`sess_id`, `vars`, `ip`, `changed`) VALUES ('htbsk62bvt5301lumbs700piea', 'dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJuYl9OTyI7dGFza3xzOjU6ImxvZ2luIjtza2luX2NvbmZpZ3xhOjc6e3M6MTc6InN1cHBvcnRlZF9sYXlvdXRzIjthOjE6e2k6MDtzOjEwOiJ3aWRlc2NyZWVuIjt9czoyMjoianF1ZXJ5X3VpX2NvbG9yc190aGVtZSI7czo5OiJib290c3RyYXAiO3M6MTg6ImVtYmVkX2Nzc19sb2NhdGlvbiI7czoxNzoiL3N0eWxlcy9lbWJlZC5jc3MiO3M6MTk6ImVkaXRvcl9jc3NfbG9jYXRpb24iO3M6MTc6Ii9zdHlsZXMvZW1iZWQuY3NzIjtzOjE3OiJkYXJrX21vZGVfc3VwcG9ydCI7YjoxO3M6MjY6Im1lZGlhX2Jyb3dzZXJfY3NzX2xvY2F0aW9uIjtzOjQ6Im5vbmUiO3M6MjE6ImFkZGl0aW9uYWxfbG9nb190eXBlcyI7YTozOntpOjA7czo0OiJkYXJrIjtpOjE7czo1OiJzbWFsbCI7aToyO3M6MTA6InNtYWxsLWRhcmsiO319', '192.168.10.243', now())) in /var/lib/roundcube/program/lib/Roundcube/rcube_db.php on line 577 (GET /)

seems like my whole database is just broken and most likely, that is not only error with it I will find

[sahsanu]

Ok, let’s remove it completely and reinstall.

mysql -uroot -e 'DROP DATABASE IF EXISTS roundcube'
mysql -uroot -e "DROP USER \`roundcube\`@\`%\`"
mysql -uroot -e "DROP USER \`roundcube\`@\`localhost\`"
rm /var/lib/roundcube/index.php

Now install roundcube:

v-add-sys-roundcube

Change perms:

chown -R hestiamail:www-data /etc/roundcube/
find /etc/roundcube/ -type f -iname "*php" -exec chmod 640 {} \;
chown -R hestiamail:www-data /var/lib/roundcube/
chown -R hestiamail:www-data /var/log/roundcube/

Try to access webmail.

[steelyx]

@sahsanu

mysql -uroot -e 'DROP DATABASE IF EXISTS roundcube'

error dropping database:

[sahsanu]

ls -la /var/lib/mysql/roundcube
namei -mo /var/lib/mysql/roundcube

[steelyx]

@sahsanu

namei -mo /var/lib/mysql/roundcube

[sahsanu]

The perms are ok so that error is weird.

lsof -Pn +c0 -i:3306 -sTCP:LISTEN

If the user is mysql, then restart mariadb and try to drop the database again.

systemctl restart mariadb
mysql -uroot -e 'DROP DATABASE IF EXISTS roundcube'

[steelyx]

I restarted it and still the same error

here is the mariadb status if it is useful

[sahsanu]

Just in case, backup the contents of /var/lib/mysql/roundcube, remove the files manually and try to drop the db again.

tar zpcf /root/backup_mysql-roundcube.tar.gz /var/lib/mysql/roundcube
rm /var/lib/mysql/roundcube/*

Drop the db again.

[steelyx]

@sahsanu

chown -R hestiamail:www-data /var/log/roundcube/

Thanks for the help, it worked.

[sahsanu]

Great. But it is weird, first, that the user roundcube didn’t exist in your db and the second one, that mysql user couldn’t remove the files inside /var/lib/mysql/roundcube/.

Anyway, I’m glad it is solved now