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
_______________________________________________
Blueonyx mailing list
Blueonyx@mail.blueonyx.it
http://mail.blueonyx.it/mailman/listinfo/blueonyx
