[BlueOnyx:22433] Re: new RoundCube version

Thu Oct 11 03:48:15 -05 2018

thanks Dirk for the reply

On 09.10.18 18:00, Dirk Estenfeld wrote:
>
> Hello again,
> I did have a similar problem.
> I updated from roundcube 1.1.3 to 1.3.7 and afterwards a user login was not possible.
> I did chech the error log and did see:
>
> DB Error: [1364] Field 'alias' doesn't have a default value (SQL Query: INSERT INTO `users` (`created`, `last_login`, `username`, `mail_host`, `language`) VALUES (now(), now(), 'maxmuster', 'www.mysite.de', 'de_DE')) in /home/.sites/40/site68/web/webmail/program/lib/Roundcube/rcube_db.php on line 543 (POST /webmail/?_task=login&_action=login)
>
yes I did also check the roundcube/logs/errors and got a similar entry:

506# tail roundcube/logs/errors
...
[08-Oct-2018 14:32:12 +0200]: <345va73k> PHP Error: Failed to create new user in /home/.sites/106/site3/web/roundcube/program/lib/Roundcube/rcube_user.php on line 688 (POST /roundcube/?_task=login&_action=login)
[08-Oct-2018 14:32:12 +0200]: <345va73k> PHP Error: Failed to create a user record. Maybe aborted by a plugin? in /home/.sites/106/site3/web/roundcube/program/include/rcmail.php on line 652 (POST /roundcube/?_task=login&_action=login)
[08-Oct-2018 15:37:11 +0200]: <345va73k> DB Error: [1364] Field 'alias' doesn't have a default value (SQL Query: INSERT INTO `users` (`created`, `last_login`, `username`, `mail_host`, `language`) VALUES (now(), now(), 'arcgraph', 'www.arcgraphics.ch', 'en_US')) in /home/.sites/106/site3/web/roundcube/program/lib/Roundcube/rcube_db.php on line 543 (POST /roundcube/?_task=login&_action=login)[08-Oct-2018 15:37:11 +0200]: <345va73k> PHP Error: Failed to create new user in /home/.sites/106/site3/web/roundcube/program/lib/Roundcube/rcube_user.php on line 688 (POST /roundcube/?_task=login&_action=login)
[08-Oct-2018 15:37:11 +0200]: <345va73k> PHP Error: Failed to create a user record. Maybe aborted by a plugin? in /home/.sites/106/site3/web/roundcube/program/include/rcmail.php on line 652 (POST /roundcube/?_task=login&_action=login)
logs/errors lines 1-18/18 (END)
507#

> I did check the statement against the database and did find out that alias got a „not null“ flag (or had is and roundcube did change). However, I removed notnull flag from alias field in users table in the database for this roundcube instance and now I can login into roundcube again.
>
now this is where I got stuck. How did you do this? If I got to phpMyAdmin, I don't know which database RC this upgraded site is using.

The site's phpMyAdmin (at /phpmyadmin/site?group=site3) has only an «information_schema» database which has no alias field and two other empty databases.

The server's phpMyAdmin (at /phpmyadmin/server) has several «nwa_[a-zA-Z0-9]{12}» databases which seem to belong to all the site's RC installations, they have in the table «users» an «alias» field which has the default value «None». None of those nwa_ databases have a «not null» value in the alias field of the users table.

Since some of the sites are still using version 1.2.4 which is running fine, I don't dare to make any changes...

I asked Michael to look into it, hopefully he'll find a solution.

Thank you and best regards

_~_
'¿')
`-´ 	 Meaulnes Legler
  Zurich, Switzerland
+41\0 44 260 16 60

> Maybe you see a similar problem if you check your logs/errors file.
>
> Best regards,
>
> Dirk
>
> ---
>
> blackpoint GmbH – Friedberger Straße 106b – 61118 Bad Vilbel
>
>
> *Von:*Blueonyx <blueonyx-bounces at mail.blueonyx.it> *Im Auftrag von *Meaulnes Legler @ MailList
> *Gesendet:* Sonntag, 7. Oktober 2018 14:49
> *An:* BlueOnyx General Mailing List <blueonyx at mail.blueonyx.it>
> *Betreff:* [BlueOnyx:22429] Re: new RoundCube version
>
> Michael, thanks for the help.
>
> On 05.10.18 22:18, Michael Stauber wrote:
>
>         But now, nobody can log in anymore... it says « _/*!*\_ Login failed »
>
>         although the credentials are correct.
>
>     What version of PHP is that Vsite using? Newer versions of RoundCube
>
>     might have the need for a newer version of PHP as well.
>
> it had version 5.3.29 and I changed to version 7.1.22 in /vsite/vsiteWeb?group=site31 with PHP (DSO) + mod_ruid2.
>
> I changed the web ownership to the site's admin user in /vsite/fileOwner?group=site31.
>
> I enabled the «MariaDB user and database» in /vsite/vsiteWeb?group=site31.
>
> Still got the error.
>
>     There is something else to try: On a Vsite where it's not working simply
>
>     uninstall roundcube via the GUI and then reinstall. That'll purge the
>
>     MySQL database and will also rewrite the config file.
>
> I tried this, too, but it didn't help... The site had RC's version 1.2.4, I uninstalled it and installed version 1.3.7. Since it displays «DATABASE ERROR: CONNECTION FAILED! Unable to connect to the database!», I went to phpMyAdmin: the database exists with the name nwa_0GnFGYyH4IWq.
>
>     I recommend to try this, because older versions of roundcube might have
>
>     used different mechanisms to connect to MySQL. Like using "mysql"
>
>     instead of "mysqli".
>
>     An uninstall/reinstall of roundcube creates a new config file with the
>
>     proper (new) settings, so it might be worth a try.
>
> I uninstalled and reinstalled twice, didn't help.
>
> Mike Burger at the RoundCube mailing list replied:
>
> Have you run the <RCEMAILDIR>/bin/updatedb.sh script, yet?
>
> If I run this script, it says:
>
> 328# bin/updatedb.sh
> Error 500: Database schema directory not specified (--dir).
> 329#
>
> Since I didn't get an answer from Mike yet, I googled the params of updatedb.sh (the script itself is too complicated for me)-: and tried:
>
> 332# bin/updatedb.sh --package roundcube --dir=./SQL
> ERROR: SQLSTATE[HY000] [1044] Access denied for user 'nwa_jIWru3kKFolH'@'localhost' to database 'nwa_jxQMgeWjK5OK'Error 500: Error connecting to database: SQLSTATE[HY000] [1044] Access denied for user 'nwa_jIWru3kKFolH'@'localhost' to database      'nwa_jxQMgeWjK5OK'
> 333#
>
> hm. The databases names *don't* correspond to the ones in phpMyAdmin (nwa_0GnFGYyH4IWq). This seems to be the problem, I guess...
>
> How can I fix this?
>
> Thank you and best regards
>
>
>
> _______________________________________________
> Blueonyx mailing list
> Blueonyx at mail.blueonyx.it
> http://mail.blueonyx.it/mailman/listinfo/blueonyx

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.blueonyx.it/pipermail/blueonyx/attachments/20181011/a416d044/attachment.html>