[BlueOnyx:22431] Re: new RoundCube version

[Dirk Estenfeld]

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)

 

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.

 

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.blueonyx.it/pipermail/blueonyx/attachments/20181009/671ad8cc/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 5526 bytes
Desc: not available
URL: <http://mail.blueonyx.it/pipermail/blueonyx/attachments/20181009/671ad8cc/attachment.p7s>