<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Michael, thanks for the help.</p>
<p> On 05.10.18 22:18, Michael Stauber wrote:<br>
</p>
<blockquote type="cite"
cite="mid:992da38b-f69f-32d7-546a-6d905e87af8e@blueonyx.it">
<blockquote type="cite">
<pre wrap="">But now, nobody can log in anymore... it says « _/*!*\_ Login failed »
although the credentials are correct.
</pre>
</blockquote>
<pre wrap="">What version of PHP is that Vsite using? Newer versions of RoundCube
might have the need for a newer version of PHP as well.</pre>
</blockquote>
<p>it had version 5.3.29 and I changed to version 7.1.22 in
/vsite/vsiteWeb?group=site31 with PHP (DSO) + mod_ruid2.</p>
<p>I changed the web ownership to the site's admin user in
/vsite/fileOwner?group=site31.</p>
<p>I enabled the «MariaDB user and database» in
/vsite/vsiteWeb?group=site31.<br>
</p>
<p>Still got the error.<br>
</p>
<blockquote type="cite"
cite="mid:992da38b-f69f-32d7-546a-6d905e87af8e@blueonyx.it">
<pre wrap="">There is something else to try: On a Vsite where it's not working simply
uninstall roundcube via the GUI and then reinstall. That'll purge the
MySQL database and will also rewrite the config file.</pre>
</blockquote>
<p>I tried this, too, but it didn't help... The site had RC's
version 1.2.4, I uninstalled it and installed version 1.3.7. Since
it displays «DATABASE ERROR: CONNECTION FAILED! Unable to connect
to the database!», I went to phpMyAdmin: the database exists with
the name <tt>nwa_0GnFGYyH4IWq</tt>. </p>
<blockquote type="cite"
cite="mid:992da38b-f69f-32d7-546a-6d905e87af8e@blueonyx.it">
<pre wrap="">I recommend to try this, because older versions of roundcube might have
used different mechanisms to connect to MySQL. Like using "mysql"
instead of "mysqli".
An uninstall/reinstall of roundcube creates a new config file with the
proper (new) settings, so it might be worth a try.</pre>
</blockquote>
<p>I uninstalled and reinstalled twice, didn't help. <br>
</p>
<p>Mike Burger at the RoundCube mailing list replied:</p>
<p><tt>Have you run the <RCEMAILDIR>/bin/updatedb.sh script,
yet? </tt><br>
</p>
<p>If I run this script, it says:</p>
<pre style="background-color:#eee;">328# bin/updatedb.sh
Error 500: Database schema directory not specified (--dir).
329#</pre>
<p>Since I didn't get an answer from Mike yet, I googled the params
of <tt>updatedb.sh</tt> (the script itself is too complicated for
me)-: and tried:<br>
</p>
<pre style="background-color:#eee;">332# bin/updatedb.sh --package roundcube --dir=./SQL
ERROR: SQLSTATE[HY000] [1044] Access denied for user 'nwa_jIWru3kKFolH'@'localhost' to database 'nwa_jxQMgeWjK5OK'Error 500: Error connecting to database: SQLSTATE[HY000] [1044] Access denied for user 'nwa_jIWru3kKFolH'@'localhost' to database 'nwa_jxQMgeWjK5OK'
333#</pre>
<p>hm. The databases names <b>don't</b> correspond to the ones in
phpMyAdmin (<tt>nwa_0GnFGYyH4IWq</tt>). This seems to be the
problem, I guess...</p>
<p>How can I fix this?</p>
<p>Thank you and best regards</p>
</body>
</html>