[BlueOnyx:22750] Re: Roundcube issue : Dirk's fix
Meaulnes Legler @ MailList
bluelist at waveweb.ch
Fri Mar 1 09:40:46 -05 2019
Hi Richard
I was abroad on a crappy Internet connection and saw your mail only now. I had the same problem with RCafter installing the new version 1.3.7: users couldn't login and new users got a database error.
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.
Either read our exchanges in the maillist around October 11, 2018 «/[BlueOnyx:22441] Re: new RoundCube version»/ or read an extract below.
Best regards
_~_
'¿')
`-´ Meaulnes Legler
Zurich, Switzerland
+41¦0 44 260 16 60
On 25.02.19 23:14, Richard Barker wrote:
>
> 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.
> 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.
> What in the world am I not seeing?
> /*Richard C. Barker Sr.
> CEO & President
> 1-813-873-8942
> ProBass Networks Inc. */
> www.probassnetworks.net <http://www.probassnetworks.net>
> www.probass.net <http://www.probass.net>
>
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Subject: Re: [BlueOnyx:22437] Re: new RoundCube version - solved! From: "Meaulnes Legler @ MailList" <bluelist at waveweb.ch>
Date: 14.10.18, 10:47
To: blueonyx at mail.blueonyx.it
CC: "SolarSpeed M. Stauber" <mstauber at solarspeed.net>
hey Dirk
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).
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 *three pages* and I didn't notice the little dropdown 1▴▾>≫ to access the next page (this dropdown appears only on servers with lots of databases).
After finding the correct database for the faulting site, it was a piece of cake to fix the issue according to your instructions below.
Thanks again and best regards
_~_
'¿')
`-´ Meaulnes Legler
Zurich, Switzerland
+41\0 44 260 16 60
PS: for those who are interested in more details, see further below.
> On 11.10.18 15:37, Dirk Estenfeld wrote:
>>
>> Hello Meaulnes,
>>
>> here is the way to correct it.
>> Check the config/config.inc.php file in the roundcube installation.
>> Look for the line $config['db_dsnw'] =
>> At the end of the line you will find the database name: nwa_whatever
>>
>> Now you login to Blueonyx backend as admin and go to personal profile -> programs -> phpmyadmin (use “open in new window” link)
>> Open Tab databases in the top and click on the name of the database you did find in config/config.inc.php
>> Look for table users and klick structure.
>> Click checkbox before alias and select edit under tables.
>> Now set standard to NULL and save.
>> That’s it. Now you can login again.
>>
>> Best regards,
>>
>> Dirk
>>
>> ---
>>
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:
# 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'] = 'mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij';
/home/.sites/28/site1/web/roundcube.1.3.4/config/config.inc.php $config['db_dsnw'] = 'mysql://nwa_bBGj30wcVIQu:Cq3gyZuOutGeegFd@127.0.0.1/nwa_YjeFtoceIsfN';
/home/.sites/132/site21/web/roundcube/config/config.inc.php $config['db_dsnw'] = 'mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij';
/home/.sites/132/site12/web/roundcube/config/config.inc.php $config['db_dsnw'] = 'mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij';
/home/.sites/106/site15/web/roundcube/config/config.inc.php $config['db_dsnw'] = 'mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij';
/home/.sites/106/site3/web/roundcube/config/config.inc.php $config['db_dsnw'] = 'mysql://nwa_2ECOMKARcX4p:NWBbiLxXsNEHbcdO@127.0.0.1/nwa_xUF15UKWqakQ';
/home/.sites/39/site17/web/roundcube/config/config.inc.php $config['db_dsnw'] = 'mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij';
/home/.sites/39/site9/web/roundcube/config/config.inc.php $config['db_dsnw'] = 'mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij';
/home/.sites/95/site29/web/roundcube/config/config.inc.php $config['db_dsnw'] = 'mysql://nwa_fxYroFBHBjVa:meEVbYaRTgypGmEq@127.0.0.1/nwa_WXECNYqBlGyK';
/home/.sites/64/site14/web/roundcube/config/config.inc.php $config['db_dsnw'] = 'mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij';
/home/.sites/85/site23/web/roundcube/config/config.inc.php $config['db_dsnw'] = 'mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij';
/home/.sites/22/site13/web/roundcube/config/config.inc.php $config['db_dsnw'] = 'mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij';
/home/.sites/123/site19/web/roundcube/config/config.inc.php $config['db_dsnw'] = 'mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij';
/home/.sites/38/site25/web/roundcube/config/config.inc.php $config['db_dsnw'] = 'mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij';
/home/.sites/33/site5/web/roundcube/config/config.inc.php $config['db_dsnw'] = 'mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij';
/home/.sites/33/site22/web/roundcube/config/config.inc.php $config['db_dsnw'] = 'mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij';
/home/.sites/80/site20/web/roundcube/config/config.inc.php $config['db_dsnw'] = 'mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij';
/home/.sites/70/site4/web/roundcube/config/config.inc.php $config['db_dsnw'] = 'mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij';
/home/.sites/90/site11/web/roundcube/config/config.inc.php $config['db_dsnw'] = 'mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij';
/home/.sites/90/site26/web/roundcube/config/config.inc.php $config['db_dsnw'] = 'mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij';
/home/.sites/112/site7/web/roundcube/config/config.inc.php $config['db_dsnw'] = 'mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij';
/home/.sites/137/site24/web/roundcube/config/config.inc.php $config['db_dsnw'] = 'mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij';
/home/.sites/142/site27/web/roundcube/config/config.inc.php $config['db_dsnw'] = 'mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij';
/home/.sites/43/site28/web/roundcube/config/config.inc.php $config['db_dsnw'] = 'mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij';
/home/.sites/48/site10/web/roundcube/config/config.inc.php $config['db_dsnw'] = 'mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij';
/home/.sites/148/site6/web/roundcube/config/config.inc.php $config['db_dsnw'] = 'mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij';
/home/.sites/148/site16/web/roundcube/config/config.inc.php $config['db_dsnw'] = 'mysql://nwa_ULSKqxvfRb2j:zRTEnOLoRsbOq4yy@127.0.0.1/nwa_XMGovCPOISij';
/home/.sites/81/site18/web/roundcube/config/config.inc.php $config['db_dsnw'] = 'mysql://nwa_ObTUrHairasb:C4omAA1tl4qeFRzT@127.0.0.1/nwa_O42mAeWqWhqv';
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:
# : cd /home/sites/www.domain.tld ; pwd -P
/home/.sites/106/site3
You lookup the line with the site's number in the list above and know which is the corresponding database:
/home/.sites/106/site3/web/roundcube/config/config.inc.php $config['db_dsnw'] = 'mysql://nwa_2ECOMKARcX4p:NWBbiLxXsNEHbcdO@127.0.0.1/nwa_xUF15UKWqakQ';
で⊃ Meaulnes
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.blueonyx.it/pipermail/blueonyx/attachments/20190301/b0a46002/attachment.html>
More information about the Blueonyx
mailing list