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 --- blackpoint GmbH – Friedberger Straße 106b – 61118 Bad Vilbel Von: Blueonyx <blueonyx-boun...@mail.blueonyx.it> Im Auftrag von Meaulnes Legler @ MailList Gesendet: Donnerstag, 11. Oktober 2018 10:48 An: blueonyx@mail.blueonyx.it Betreff: [BlueOnyx:22433] Re: new RoundCube version 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 <http://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 <http://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 <mailto:blueonyx-boun...@mail.blueonyx.it> <blueonyx-boun...@mail.blueonyx.it> Im Auftrag von Meaulnes Legler @ MailList Gesendet: Sonntag, 7. Oktober 2018 14:49 An: BlueOnyx General Mailing List <mailto:blueonyx@mail.blueonyx.it> <blueonyx@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@mail.blueonyx.it <mailto:Blueonyx@mail.blueonyx.it> http://mail.blueonyx.it/mailman/listinfo/blueonyx
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ Blueonyx mailing list Blueonyx@mail.blueonyx.it http://mail.blueonyx.it/mailman/listinfo/blueonyx
