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" <bluel...@waveweb.ch>
Date: 14.10.18, 10:47
To: blueonyx@mail.blueonyx.it
CC: "SolarSpeed M. Stauber" <mstau...@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
_______________________________________________
Blueonyx mailing list
Blueonyx@mail.blueonyx.it
http://mail.blueonyx.it/mailman/listinfo/blueonyx