<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;
color:black;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman",serif;
color:black;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Vorformatiert Zchn";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
tt
{mso-style-priority:99;
font-family:"Courier New";}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman",serif;
color:black;}
span.HTMLVorformatiertZchn
{mso-style-name:"HTML Vorformatiert Zchn";
mso-style-priority:99;
mso-style-link:"HTML Vorformatiert";
font-family:Consolas;
color:black;}
span.E-MailFormatvorlage22
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body bgcolor=white lang=DE link="#0563C1" vlink="#954F72"><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>Hello again,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>I did have a similar problem.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>I updated from roundcube 1.1.3 to 1.3.7 and afterwards a user login was not possible.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>I did chech the error log and did see:<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>DB Error: [1364] Field 'alias' doesn't have a default value (SQL Query: INSERT INTO `users` (`created`, `last_login`, `username`, `mail_host`, `language`) VALUES (now(), now(), 'maxmuster', 'www.mysite.de', 'de_DE')) in /home/.sites/40/site68/web/webmail/program/lib/Roundcube/rcube_db.php on line 543 (POST /webmail/?_task=login&_action=login)<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>I did check the statement against the database and did find out that alias got a „not null“ flag (or had is and roundcube did change). However, I removed notnull flag from alias field in users table in the database for this roundcube instance and now I can login into roundcube again.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>Maybe you see a similar problem if you check your logs/errors file.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>Best regards,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>Dirk<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><div><p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-size:8.0pt;font-family:"Arial",sans-serif;color:gray'>---<br><br>blackpoint GmbH – Friedberger Straße 106b – 61118 Bad Vilbel<br><br><br></span><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p></div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:windowtext'>Von:</span></b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:windowtext'> Blueonyx <blueonyx-bounces@mail.blueonyx.it> <b>Im Auftrag von </b>Meaulnes Legler @ MailList<br><b>Gesendet:</b> Sonntag, 7. Oktober 2018 14:49<br><b>An:</b> BlueOnyx General Mailing List <blueonyx@mail.blueonyx.it><br><b>Betreff:</b> [BlueOnyx:22429] Re: new RoundCube version<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p>Michael, thanks for the help.<o:p></o:p></p><p>On 05.10.18 22:18, Michael Stauber wrote:<o:p></o:p></p><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><pre>But now, nobody can log in anymore... it says « _/*!*\_ Login failed »<o:p></o:p></pre><pre>although the credentials are correct.<o:p></o:p></pre></blockquote><pre>What version of PHP is that Vsite using? Newer versions of RoundCube<o:p></o:p></pre><pre>might have the need for a newer version of PHP as well.<o:p></o:p></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.<o:p></o:p></p><p>I changed the web ownership to the site's admin user in /vsite/fileOwner?group=site31.<o:p></o:p></p><p>I enabled the «MariaDB user and database» in /vsite/vsiteWeb?group=site31.<o:p></o:p></p><p>Still got the error.<o:p></o:p></p><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><pre>There is something else to try: On a Vsite where it's not working simply<o:p></o:p></pre><pre>uninstall roundcube via the GUI and then reinstall. That'll purge the<o:p></o:p></pre><pre>MySQL database and will also rewrite the config file.<o:p></o:p></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><span style='font-size:10.0pt'>nwa_0GnFGYyH4IWq</span></tt>. <o:p></o:p></p><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><pre>I recommend to try this, because older versions of roundcube might have<o:p></o:p></pre><pre>used different mechanisms to connect to MySQL. Like using "mysql"<o:p></o:p></pre><pre>instead of "mysqli".<o:p></o:p></pre><pre>An uninstall/reinstall of roundcube creates a new config file with the<o:p></o:p></pre><pre>proper (new) settings, so it might be worth a try.<o:p></o:p></pre></blockquote><p>I uninstalled and reinstalled twice, didn't help. <o:p></o:p></p><p>Mike Burger at the RoundCube mailing list replied:<o:p></o:p></p><p><tt><span style='font-size:10.0pt'>Have you run the <RCEMAILDIR>/bin/updatedb.sh script, yet? </span></tt><o:p></o:p></p><p>If I run this script, it says:<o:p></o:p></p><pre style='background:#EEEEEE'>328# bin/updatedb.sh<o:p></o:p></pre><pre style='background:#EEEEEE'>Error 500: Database schema directory not specified (--dir).<o:p></o:p></pre><pre style='background:#EEEEEE'>329#<o:p></o:p></pre><p>Since I didn't get an answer from Mike yet, I googled the params of <tt><span style='font-size:10.0pt'>updatedb.sh</span></tt> (the script itself is too complicated for me)-: and tried:<o:p></o:p></p><pre style='background:#EEEEEE'>332# bin/updatedb.sh --package roundcube --dir=./SQL<o:p></o:p></pre><pre style='background:#EEEEEE'>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'<o:p></o:p></pre><pre style='background:#EEEEEE'>333#<o:p></o:p></pre><p>hm. The databases names <b>don't</b> correspond to the ones in phpMyAdmin (<tt><span style='font-size:10.0pt'>nwa_0GnFGYyH4IWq</span></tt>). This seems to be the problem, I guess...<o:p></o:p></p><p>How can I fix this?<o:p></o:p></p><p>Thank you and best regards<o:p></o:p></p></div></body></html>