Roundcube from identity not populating for some user

[gkanks]

I converted several accounts using the cPanel Import tool and it all went pretty smoothly except for one or two annoying elements:

1. Some converted email accounts are not registering in the identities table when they first login to roundcube which results in the account not defaulting to that email address when trying to respond to or compose a new email in roundcube. The user exists int he users table but nothing in the identities table. Some users when they first login will add a record to the identity table and other it does not.

I have updated /var/www/html/roundcube/config/config.inc.php with:

$config['identities_level'] = 2;
$config['auto_create_user'] = true;
$config['default_host'] = 'localhost';

To try to force the identities to be created but alas that did not help.

I can manually insert the records into the identities table using SQL using data from the users table but that seems like a hack.

2. In cPanel you can pop into user email accounts without having to know the password. I assumed the pretty little "Sign into email" icon on the "Email Accounts: panel when logged in as the account user would do that but it just sits there and thinks for a minute before poping up the standard roundcube login page. Should this link function in a way that bypasses using the roundcube authentication page and if so what should I look at to resolve it?

Thank you all for the advising the newbie,

JP

 

[gkanks]

If no one has a better idea here's the SQL I was going to run add the missing records:

insert into identities (user_id, del, standard, name, email, signature, html_signature)
select user_id, 0, 1, '', username, NULL, 0) from users where user_id not in (select user_id from identities);

 

[Richard G]

Should this link function in a way that bypasses using the roundcube authentication page and if so what should I look at to resolve it?

I'm not sure if that is the one, but that "bypass login" function is not enabled by default anyway, you have to active it yourself.
You can read about it here, it's quite easy.

Webmail | Directadmin Docs

DirectAdmin Knowledge Base

docs.directadmin.com

There is a similar option for phpmyadmin if you're interested. Called One Click Login.

phpMyAdmin | Directadmin Docs

DirectAdmin Knowledge Base

docs.directadmin.com