Hello!
I have followed these instructions setting up mail server, (http://serverfault.com/questions/575389/howto-setup-roundcube-password-plugin-with-sql-driver-and-mysql-encrypt-using-ra) but I get the following error:
DB Error in /srv/roundcube/program/lib/Roundcube/rcube_db.php (543): [1054] Unknown column 'id' in 'where clause' (SQL Query: UPDATE users SET crypt=ENCRYPT('password',CONCAT(_utf8'$5$',RIGHT(MD5(RAND()),8),_utf8'$')) WHERE id='
[email protected]' LIMIT 1)
If there's really 'id' column in your 'users' table, then you're probably connecting to the wrong database. See option 'password_db_dsn'.
And if there isn't 'id', what should be there?
I tried to replace 'id' with 'users' and it still showed "Unknown column 'users' "
From Roundcube point of view it can be anything.
What should one name it for roundcube not to get confused?
Currently MySQL has 14 tables:
cache
cache_index
cache_messages
cache_shared
cache_thread
contactgroupmembers
contactgroups
contacts
dictionary
identities
searches
session
system
users
Roundcube database does not contain any passwords. So, you're looking in the wrong place. I said about the wrong database, didn't I?
How can I make it point the right way?
users table has "user_id" but its unassigned integer.
thanks for your time
Why should I know? This depends on your mail server software/configuration. This has nothing to do with Roundcube - which is just an IMAP client, not users database.
Thanks. Have a nice day :)