<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>hey Dirk</p>
<p>thanks to your help, I could fix the issue that after installing
the new RoundCube version 1.3.7, users couldn't login (and new
users got a database error).</p>
<p>My problem was that I couldn't find the site's database in
phpMyAdmin (I could find it in mysql in a shell, but didn't know
the mysql commands to execute your suggested procedure). I
couldn't find it because that server had so many databases that
phpMyAdmin displayed them on <b>three pages</b> and I didn't
notice the little dropdown <span style="border:1px solid
gray;border-radius:4px;">1<tt>▴▾</tt></span><tt>></tt>≫ to
access the next page (this dropdown appears only on servers with
lots of databases).<br>
</p>
<p>After finding the correct database for the faulting site, it was
a piece of cake to fix the issue according to your instructions
below.</p>
<p>Thanks again 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>
<p> PS: for those who are interested in more details, see further
below.</p>
<blockquote type="cite"
cite="mid:d26c69a2-4b39-e9bd-6f40-538d65f52661@waveweb.ch">
<div class="moz-cite-prefix">On 11.10.18 15:37, Dirk Estenfeld
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:c1d5a8a804954b1698adb02481ef3407@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:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:purple;
	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
Meaulnes,<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"
lang="EN-GB">here is the way to correct it.<br>
Check the config/config.inc.php file in the roundcube
installation.<br>
Look for the line $config['db_dsnw'] =<br>
At the end of the line you will find the database name:
nwa_whatever<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"
lang="EN-GB">Now you login to Blueonyx backend as admin
and go to personal profile -> programs -> phpmyadmin
(use “open in new window” link)<br>
Open Tab databases in the top and click on the name of the
database you did find in config/config.inc.php<br>
Look for table users and klick structure.<br>
Click checkbox before alias and select edit under tables.<br>
Now set standard to NULL and save.<br>
That’s it. Now you can login 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"
lang="EN-GB">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"
lang="EN-GB">Dirk<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"><o:p> </o:p>---<br>
</span><br>
</p>
</div>
</div>
</blockquote>
</blockquote>
<p>If one has to fix this issue for several sites, one has to find
our in which databases the alias field has to be set to NULL. In a
shell:<br>
</p>
<pre style="font-size:80%;background-color:#eee;"># for i in `find /home/.sites/ -name config.inc.php` ; do echo -en "$i\t" ; grep -e "\$config\['db_dsnw'\]" $i ; done
/home/.sites/28/site1/web/roundcube.1.2.4/config/config.inc.php $config['db_dsnw'] = '<a class="moz-txt-link-abbreviated" href="mailto:mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij">mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij</a>';
/home/.sites/28/site1/web/roundcube.1.3.4/config/config.inc.php $config['db_dsnw'] = '<a class="moz-txt-link-abbreviated" href="mailto:mysql://nwa_bBGj30wcVIQu:Cq3gyZuOutGeegFd@127.0.0.1/nwa_YjeFtoceIsfN">mysql://nwa_bBGj30wcVIQu:Cq3gyZuOutGeegFd@127.0.0.1/nwa_YjeFtoceIsfN</a>';
/home/.sites/132/site21/web/roundcube/config/config.inc.php $config['db_dsnw'] = '<a class="moz-txt-link-abbreviated" href="mailto:mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij">mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij</a>';
/home/.sites/132/site12/web/roundcube/config/config.inc.php $config['db_dsnw'] = '<a class="moz-txt-link-abbreviated" href="mailto:mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij">mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij</a>';
/home/.sites/106/site15/web/roundcube/config/config.inc.php $config['db_dsnw'] = '<a class="moz-txt-link-abbreviated" href="mailto:mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij">mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij</a>';
/home/.sites/106/site3/web/roundcube/config/config.inc.php $config['db_dsnw'] = '<a class="moz-txt-link-abbreviated" href="mailto:mysql://nwa_2ECOMKARcX4p:NWBbiLxXsNEHbcdO@127.0.0.1/nwa_xUF15UKWqakQ">mysql://nwa_2ECOMKARcX4p:NWBbiLxXsNEHbcdO@127.0.0.1/nwa_xUF15UKWqakQ</a>';
/home/.sites/39/site17/web/roundcube/config/config.inc.php $config['db_dsnw'] = '<a class="moz-txt-link-abbreviated" href="mailto:mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij">mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij</a>';
/home/.sites/39/site9/web/roundcube/config/config.inc.php $config['db_dsnw'] = '<a class="moz-txt-link-abbreviated" href="mailto:mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij">mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij</a>';
/home/.sites/95/site29/web/roundcube/config/config.inc.php $config['db_dsnw'] = '<a class="moz-txt-link-abbreviated" href="mailto:mysql://nwa_fxYroFBHBjVa:meEVbYaRTgypGmEq@127.0.0.1/nwa_WXECNYqBlGyK">mysql://nwa_fxYroFBHBjVa:meEVbYaRTgypGmEq@127.0.0.1/nwa_WXECNYqBlGyK</a>';
/home/.sites/64/site14/web/roundcube/config/config.inc.php $config['db_dsnw'] = '<a class="moz-txt-link-abbreviated" href="mailto:mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij">mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij</a>';
/home/.sites/85/site23/web/roundcube/config/config.inc.php $config['db_dsnw'] = '<a class="moz-txt-link-abbreviated" href="mailto:mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij">mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij</a>';
/home/.sites/22/site13/web/roundcube/config/config.inc.php $config['db_dsnw'] = '<a class="moz-txt-link-abbreviated" href="mailto:mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij">mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij</a>';
/home/.sites/123/site19/web/roundcube/config/config.inc.php $config['db_dsnw'] = '<a class="moz-txt-link-abbreviated" href="mailto:mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij">mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij</a>';
/home/.sites/38/site25/web/roundcube/config/config.inc.php $config['db_dsnw'] = '<a class="moz-txt-link-abbreviated" href="mailto:mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij">mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij</a>';
/home/.sites/33/site5/web/roundcube/config/config.inc.php $config['db_dsnw'] = '<a class="moz-txt-link-abbreviated" href="mailto:mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij">mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij</a>';
/home/.sites/33/site22/web/roundcube/config/config.inc.php $config['db_dsnw'] = '<a class="moz-txt-link-abbreviated" href="mailto:mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij">mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij</a>';
/home/.sites/80/site20/web/roundcube/config/config.inc.php $config['db_dsnw'] = '<a class="moz-txt-link-abbreviated" href="mailto:mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij">mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij</a>';
/home/.sites/70/site4/web/roundcube/config/config.inc.php $config['db_dsnw'] = '<a class="moz-txt-link-abbreviated" href="mailto:mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij">mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij</a>';
/home/.sites/90/site11/web/roundcube/config/config.inc.php $config['db_dsnw'] = '<a class="moz-txt-link-abbreviated" href="mailto:mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij">mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij</a>';
/home/.sites/90/site26/web/roundcube/config/config.inc.php $config['db_dsnw'] = '<a class="moz-txt-link-abbreviated" href="mailto:mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij">mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij</a>';
/home/.sites/112/site7/web/roundcube/config/config.inc.php $config['db_dsnw'] = '<a class="moz-txt-link-abbreviated" href="mailto:mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij">mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij</a>';
/home/.sites/137/site24/web/roundcube/config/config.inc.php $config['db_dsnw'] = '<a class="moz-txt-link-abbreviated" href="mailto:mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij">mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij</a>';
/home/.sites/142/site27/web/roundcube/config/config.inc.php $config['db_dsnw'] = '<a class="moz-txt-link-abbreviated" href="mailto:mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij">mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij</a>';
/home/.sites/43/site28/web/roundcube/config/config.inc.php $config['db_dsnw'] = '<a class="moz-txt-link-abbreviated" href="mailto:mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij">mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij</a>';
/home/.sites/48/site10/web/roundcube/config/config.inc.php $config['db_dsnw'] = '<a class="moz-txt-link-abbreviated" href="mailto:mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij">mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij</a>';
/home/.sites/148/site6/web/roundcube/config/config.inc.php $config['db_dsnw'] = '<a class="moz-txt-link-abbreviated" href="mailto:mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij">mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij</a>';
/home/.sites/148/site16/web/roundcube/config/config.inc.php $config['db_dsnw'] = '<a class="moz-txt-link-abbreviated" href="mailto:mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij">mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij</a>';
/home/.sites/81/site18/web/roundcube/config/config.inc.php $config['db_dsnw'] = '<a class="moz-txt-link-abbreviated" href="mailto:mysql://nwa_ObTUrHairasb:C4omAA1tl4qeFRzT@127.0.0.1/nwa_O42mAeWqWhqv">mysql://nwa_ObTUrHairasb:C4omAA1tl4qeFRzT@127.0.0.1/nwa_O42mAeWqWhqv</a>';</pre>
<p>So one has now a list with the site number on the left and the
database name on the very right. To find out to which number your
faulty site has:</p>
<pre style="font-size:90%;background-color:#eee;"># : cd /home/sites/www.domain.tld ; pwd -P
/home/.sites/106/site3</pre>
<p>You lookup the line with the site's number in the list above and
know which is the corresponding database:</p>
<pre style="font-size:80%;background-color:#eee;">/home/.sites/<span style="background-color:#ff9;">106/site3</span>/web/roundcube/config/config.inc.php $config['db_dsnw'] = '<a class="moz-txt-link-abbreviated" href="mailto:mysql://nwa_2ECOMKARcX4p:NWBbiLxXsNEHbcdO@127.0.0.1/">mysql://nwa_2ECOMKARcX4p:NWBbiLxXsNEHbcdO@127.0.0.1/</a><span style="background-color:#ff9;">nwa_xUF15UKWqakQ</span>';</pre>
<p>で⊃ Meaulnes</p>
<br>
</body>
</html>