[BlueOnyx:22441] Re: new RoundCube version - solved!
Meaulnes Legler @ MailList
bluelist at waveweb.ch
Sun Oct 14 03:47:46 -05 2018
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/20181014/e1e1749c/attachment.html>
More information about the Blueonyx
mailing list