Hi , I have tried to search similar issue on login failed on roundcube. But i cannot find any solution. Please help me. Based on another thread, i have got error from mail.log Jul 30 14:57:04 localhost dovecot: auth-worker(2536610): Error: sql([email protected]): User query failed: Connection was killed Jul 30 14:57:04 localhost dovecot: lda([email protected])<2748482><>: Error: auth-master: userdb lookup([email protected]): Auth USER lookup failed Jul 30 14:57:04 localhost dovecot: lda: Fatal: Internal error occurred. Refer to server log for more information. But i dont know how to fix this. Please help me
That's perfectly fine as the roundcube database is not used by roundcube for any logins. Roundcube authenticates itself via IMAP against the email account that you created in ISPConfig.
Hi Till, Would you like to provide me step by step how to solve it or any link/thread for fixing it ?
My signature has link to e-mail setup tutorial. Compare how you have set up your system. If you paste e-mail logs. please remove lines not relevant to the problem. The error messages are strange, I have no guesses on what is wrong. Follow https://www.howtoforge.com/community/threads/please-read-before-posting.58408/
All the db connection errors in your log point to a definite db related issue. You might try repairing all db tables, and rerun the ispconfig installer letting it reconfigure services, and ensure you don't have any outdated conf-custom templates. Beyond that will probably require more info, eg. what OS is this? What version of mariadb? What happened leading up to this problem? Is this a new install or one that has been running some time? What version of ISPConfig? What is in /etc/dovecot/dovecot-sql.conf (obfuscate your password, of course)?