[RCU] can't login after upgrade

[Vincent Van Houtte]

On 2018-10-08 16:01, Meaulnes Legler @ roundcube wrote:

> thanks Vincent for your answer
> 
> On 08.10.18 14:37, Vincent Van Houtte wrote:
> 
>> To your second question, you may want to look into Roundcube logging, 
>> f.e.
> 
> I got the following, but it doesn't help me on...
> 
> 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 don't know why this 'alias' field shows up here, I uninstalled and 
> reinstalled RG, the database seems okay after bin/updatedb.sh --package 
> roundcube --dir=./SQL and after bin/update.sh --package roundcube 
> --dir=./SQL, it wished me Have fun! :-(
> 
> Any clue?

These errors clearly say that the user 'arcgraph' does not exist, that 
RC wants to create the user by logging in (I don't believe this is 
default - an unknown user should just be rejected imho), and that the 
subsequent attempt to create that user fails.

There is also the mention of a plugin that may interfere here. Can you 
disable all plugins for the sake of testing?

HTH,
Vincent



> Thank you and best regards
> 
> _~_
> '¿')
> `-´          Meaulnes Legler
> 
> Zurich, Switzerland
> 
> +41\0 44 260 16 60
> 
> $config['per_user_logging'] = true;
> $config['log_session'] = true;
> $config['log_logins'] = true;
> $config['debug_level'] = 4;
> $config['sql_debug'] = true;
> $config['imap_debug'] = true;
> $config['imap_log_session'] = true;
> $config['ldap_debug'] = true;
> $config['smtp_log'] = true;
> $config['smtp_debug'] = true;
> 
> This may help you retrieve more specific error codes
> 
> Kr,
> Vincent
> 
> On 2018-10-08 14:06, Meaulnes Legler @ roundcube wrote:
> 
> dear RoundCubers
> 
> it's me again, I still cannot login after an update to version 1.3.7... 
> After googling the necessary bin/updatedb.sh params, I got:
> 
> 497# bin/update.sh --package roundcube --dir=./SQL
> What version are you upgrading from? Type '?' if you don't know.
> ?
> WARNING: Mimetype to file extension mapping doesn't work properly!
> Please check the 'mime_types' config option and run this script again.
> Executing database schema update.
> Updating database schema (2013011000)... [OK]
> Updating database schema (2013042700)... [OK]
> Updating database schema (2013052500)... [OK]
> Updating database schema (2013061000)... [OK]
> Updating database schema (2014042900)... [OK]
> Updating database schema (2015030800)... [OK]
> Updating database schema (2015111100)... [OK]
> Updating database schema (2016081200)... [OK]
> Updating database schema (2016100900)... [OK]
> Updating database schema (2016112200)... [OK]
> This instance of Roundcube is up-to-date.
> Have fun!
> 498#
> 
> I was all exited thinking it would work now, but it I didn't :-( Still 
> get the « /!\ Login failed » error with the correct credentials.
> 
> I uninstalled and reinstalled RC and went thru the same procedures -- 
> no success.
> 
> 2nd question: how can I get more specific error messages as just a 
> lapidary « /!\ Login failed » ?
> 
> Thank you and best regards
> 
> Meaulnes Legler
> Zurich, Switzerland
> 
> _______________________________________________
> Roundcube Users mailing list
> users at lists.roundcube.net
> http://lists.roundcube.net/mailman/listinfo/users
> 
> Vincent Van Houtte


Vincent Van Houtte