<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>thanks Dirk for the reply</p>
<font size="-1">On 09.10.18 18:00, Dirk Estenfeld wrote:</font><br>
<blockquote type="cite"
cite="mid:bfe2a368b25e48ef8680dc95e864ac24@blackpoint.de">
<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]-->
<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,<br>
<o:p> </o:p>I did have a similar problem.<br>
I updated from roundcube 1.1.3 to 1.3.7 and afterwards a
user login was not possible.<br>
I did chech the error log and did see:<o:p><br>
</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', '<a class="moz-txt-link-abbreviated"
href="http://www.mysite.de">www.mysite.de</a>', 'de_DE'))
in
/home/.sites/40/site68/web/webmail/program/lib/Roundcube/rcube_db.php
on line 543 (POST /webmail/?_task=login&_action=login)</span></p>
</div>
</blockquote>
<p>yes I did also check the <tt style="font-size:95%;">roundcube/logs/errors</tt>
and got a similar entry: </p>
<pre style="background-color:#eee;font-size:90%;">506# tail roundcube/logs/errors
...
[08-Oct-2018 14:32:12 +0200]: <345va73k> PHP Error: Failed to create new user in /home/.sites/106/site3/web/roundcube/program/lib/Roundcube/rcube_user.php on line 688 (POST /roundcube/?_task=login&_action=login)
[08-Oct-2018 14:32:12 +0200]: <345va73k> PHP Error: Failed to create a user record. Maybe aborted by a plugin? in /home/.sites/106/site3/web/roundcube/program/include/rcmail.php on line 652 (POST /roundcube/?_task=login&_action=login)
[08-Oct-2018 15:37:11 +0200]: <345va73k> 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(), 'arcgraph', '<a class="moz-txt-link-abbreviated" href="http://www.arcgraphics.ch">www.arcgraphics.ch</a>', 'en_US')) in /home/.sites/106/site3/web/roundcube/program/lib/Roundcube/rcube_db.php on line 543 (POST /roundcube/?_task=login&_action=login)[08-Oct-2018 15:37:11 +0200]: <345va73k> PHP Error: Failed to create new user in /home/.sites/106/site3/web/roundcube/program/lib/Roundcube/rcube_user.php on line 688 (POST /roundcube/?_task=login&_action=login)
[08-Oct-2018 15:37:11 +0200]: <345va73k> PHP Error: Failed to create a user record. Maybe aborted by a plugin? in /home/.sites/106/site3/web/roundcube/program/include/rcmail.php on line 652 (POST /roundcube/?_task=login&_action=login)
logs/errors lines 1-18/18 (END)
507#</pre>
<blockquote type="cite"
cite="mid:bfe2a368b25e48ef8680dc95e864ac24@blackpoint.de">
<div class="WordSection1">
<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.</span></p>
</div>
</blockquote>
<p>now this is where I got stuck. How did you do this? If I got to
phpMyAdmin, I don't know which database RC this upgraded site is
using. <br>
</p>
<p>The site's phpMyAdmin (at <tt>/phpmyadmin/site?group=site3</tt>)
has only an «<tt>information_schema</tt>» database which has no
alias field and two other empty databases.</p>
<p>The server's phpMyAdmin (at <tt>/phpmyadmin/server</tt>) has
several «<tt>nwa_[a-zA-Z0-9]{12}</tt>» databases which seem to
belong to all the site's RC installations, they have in the table
«<tt>users</tt>» an «<tt>alias</tt>» field which has the default
value «<tt>None</tt>». None of those <tt>nwa_</tt> databases have
a «<tt>not null</tt>» value in the <tt>alias</tt> field of the <tt>users</tt>
table.<br>
</p>
<p>Since some of the sites are still using version 1.2.4 which is
running fine, I don't dare to make any changes...</p>
<p>I asked Michael to look into it, hopefully he'll find a solution.</p>
<p>Thank you and best regards </p>
<table cellspacing="0" cellpadding="0" border="0">
<tbody>
<tr>
<td rowspan="2" style="font-family:monospace;" valign="top"
width="20"><small><tt>_~_<br>
'¿')<br>
`-´</tt></small></td>
<td> Meaulnes Legler</td>
</tr>
<tr>
<td valign="top"><small> Zurich, Switzerland</small></td>
</tr>
<tr>
<td colspan="2">+41\0 44 260 16 60</td>
</tr>
</tbody>
</table>
<br>
<p><br>
</p>
<blockquote type="cite"
cite="mid:bfe2a368b25e48ef8680dc95e864ac24@blackpoint.de">
<div class="WordSection1">
<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><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 <a class="moz-txt-link-rfc2396E"
href="mailto:blueonyx-bounces@mail.blueonyx.it"><blueonyx-bounces@mail.blueonyx.it></a>
<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 <a
class="moz-txt-link-rfc2396E"
href="mailto:blueonyx@mail.blueonyx.it"><blueonyx@mail.blueonyx.it></a><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>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Blueonyx mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Blueonyx@mail.blueonyx.it">Blueonyx@mail.blueonyx.it</a>
<a class="moz-txt-link-freetext" href="http://mail.blueonyx.it/mailman/listinfo/blueonyx">http://mail.blueonyx.it/mailman/listinfo/blueonyx</a>
</pre>
</blockquote>
<br>
</body>
</html>