<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Hi Richard</p>
<p>I was abroad on a crappy Internet connection and saw your mail
only now. I had the same problem with RC<span style="font-size:
9.000000pt; font-family: 'LucidaGrande'"> after installing the
new version 1.3.7: users couldn't login and new users got a
database error. <br>
</span></p>
<p><span style="font-size: 9.000000pt; font-family: 'LucidaGrande'">The
problem seems to be a glitch in some of RC's databases, the
«alias» field is empty instead of carrying NULL. Dirk Estenfeld
sent me instructions for a fix, but I had difficulties finding
the belonging database. After finding the catch, it worked out
and users could log in again.</span></p>
<p><span style="font-size: 9.000000pt; font-family: 'LucidaGrande'">Either
read our exchanges in the maillist around </span>October 11,
2018 «<span style="font-size: 9.000000pt; font-family:
'LucidaGrande'"><i>[BlueOnyx:22441] Re: new RoundCube version»</i>
or read an extract below.</span></p>
Best regards<br>
<br>
<table cellspacing="0" cellpadding="0" border="0">
<tbody>
<tr>
<td rowspan="2" style="font-family:monospace;
font-size:85%;letter-spacing:-0.1em;" width="20"
valign="top">_~_<br>
'¿')<br>
`-´</td>
<td> Meaulnes Legler</td>
</tr>
<tr>
<td valign="top">
<p style="font-size:85%;"> Zurich, Switzerland</p>
</td>
</tr>
<tr>
<td colspan="2">
<p>+41¦0 44 260 16 60</p>
</td>
</tr>
</tbody>
</table>
<br>
<div class="moz-cite-prefix">On 25.02.19 23:14, Richard Barker
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:575098dd-706a-e608-2f16-7c0d9b97c49a@probass.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<p>We have a VPS 5209R that has roundcube installed and has 22
domain on with roundcube installed all roundcube logins work
except one vsite, access_logs show logged in errors_logs show no
errors message shows no error or issues.<br>
I have un-installed and re-installed roundcube on that vsite
multiple time and even removed the database and user for it and
still now able to login yet the 21 other sites work.<br>
What in the world am I not seeing?<br>
<em><strong>Richard C. Barker Sr. <br>
CEO & President <br>
1-813-873-8942 <br>
<span class="style1">ProBass Networks Inc. </span></strong></em><br>
<a href="http://www.probassnetworks.net" moz-do-not-send="true">www.probassnetworks.net</a>
<br>
<a href="http://www.probass.net" moz-do-not-send="true">www.probass.net</a>
</p>
</blockquote>
<br>
<hr width="90%">
<p> </p>
<div class="page" title="Page 1">
<div class="section" style="background-color: rgb(100.000000%,
100.000000%, 100.000000%)">
<div class="layoutArea">
<div class="column">
<p><span style="font-size: 9.000000pt; font-family:
'LucidaGrande'; font-weight: 700">Subject: </span><span
style="font-size: 9.000000pt; font-family:
'LucidaGrande'">Re: [BlueOnyx:22437] Re: new RoundCube
version - solved! </span><span style="font-size:
9.000000pt; font-family: 'LucidaGrande'; font-weight:
700">From: </span><span style="font-size: 9.000000pt;
font-family: 'LucidaGrande'">"Meaulnes Legler @
MailList" <a class="moz-txt-link-rfc2396E" href="mailto:bluelist@waveweb.ch"><bluelist@waveweb.ch></a><br>
</span><span style="font-size: 9.000000pt; font-family:
'LucidaGrande'; font-weight: 700">Date: </span><span
style="font-size: 9.000000pt; font-family:
'LucidaGrande'">14.10.18, 10:47<br>
</span><span style="font-size: 9.000000pt; font-family:
'LucidaGrande'; font-weight: 700">To: </span><span
style="font-size: 9.000000pt; font-family:
'LucidaGrande'"><a class="moz-txt-link-abbreviated" href="mailto:blueonyx@mail.blueonyx.it">blueonyx@mail.blueonyx.it</a> </span><span
style="font-size: 9.000000pt; font-family:
'LucidaGrande'; font-weight: 700"><br>
CC: </span><span style="font-size: 9.000000pt;
font-family: 'LucidaGrande'">"SolarSpeed M. Stauber"
<a class="moz-txt-link-rfc2396E" href="mailto:mstauber@solarspeed.net"><mstauber@solarspeed.net></a></span></p>
<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;"
width="20" valign="top"><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">
<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,</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</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.</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,</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</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>
</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>
</div>
</div>
</div>
</div>
</body>
</html>