Can't change password from webmail

[d1984]

Hello!

I have followed these instructions setting up mail server, 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='web@example.com' LIMIT 1)

[alec]

If there's really 'id' column in your 'users' table, then you're probably connecting to the wrong database. See option 'password_db_dsn'.

[d1984]

And if there isn't 'id', what should be there?

I tried to replace 'id' with 'users' and it still showed "Unknown column 'users' "

[alec]

From Roundcube point of view it can be anything.

[d1984]

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

[alec]

Roundcube database does not contain any passwords. So, you're looking in the wrong place. I said about the wrong database, didn't I?

[d1984]

How can I make it point the right way?

users table has "user_id" but its unassigned integer.

thanks for your time

[alec]

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.

[d1984]

Thanks. Have a nice day