[BlueOnyx:27192] Re: Help for Roundcube "login failed"

[Michael Stauber]

Hi Chris,

> Have you recently migrated your BlueOnyx VSITE and now Roundcube logins 
> fail?   We have seen this several times, especially when migrating from 
> older (ie: 5209R or older) servers with older versions of Roundcube. A 
> login attempt with a correct username/password combination will produce 
> the yellow "login failed" box at the bottom right corner of the 
> Roundcube login screen.
> 
> We have noted in the Roundcube error log, a message like this is produced:
> DB Error: [1364] Field 'alias' doesn't have a default value (SQL Query: 
> INSERT INTO `users`
> 
> Removing the "alias" column from the database corrects the issue and 
> allows the user to login as expected.   This is better than blowing out 
> the database entirely and losing any saved configurations / contacts / 
> etc.

The most typical problem for being unable to login into phpMyAdmin is 
that the PHP version is to old or too new for the used RoundCube install.

But yeah: I had the exact same problem you describe recently as well. At 
one point or another in the life-cycle of RoundCube the DB schema has 
changed. The last time I had the issue it was just for two Vsites, so I 
checked the new DB schema and used phpMyAdmin to fix the schema in the 
two affected RoundCube databases.

Later on I found out that there was an easier way: The installed 
RoundCube wasn't the latest one anyway. And using the WebApp-Installer 
to perform an upgrade of the installed RoundCube would have solved the 
issue, too.


-- 
With best regards

Michael Stauber