I have a Postfix/Dovecot (2.0.19) IMAP/SMTP setup using mysql (5.5.29) as the backend database (Ubuntu 12.04.2 server). I have Roundcube (0.7.1) up and running in general, but I can't quite get the password plugin working.
The plugin displays, and it detects whether I'm entering my old password correctly, but when that is correct, the result is "Could not save new password." There's nothing interesting in the roundcube logs, nor in the mail or system logs. I turned on general logging for mysql, and this is what floats through during the attempt (I replaced long random-ish strings of characters with 'XXX' and used color to separate the two connections):
130412 13:47:39 115 Connect roundcubeuser@localhost on
115 Init DB roundcubedb
115 Query SET NAMES utf8
115 Query PREPARE mdb2_statement_mysql_XXX FROM 'SELECT vars, ip, changed FROM session WHERE sess_id = ?'
115 Prepare SELECT vars, ip, changed FROM session WHERE sess_id = ?
115 Query SET @0 = 'XXX'
115 Query EXECUTE mdb2_statement_mysql_XXX USING @0
115 Query DEALLOCATE PREPARE mdb2_statement_mysql_XXX
115 Query PREPARE mdb2_statement_mysql_XXX FROM 'SELECT * FROM users WHERE user_id = ?'
115 Prepare SELECT * FROM users WHERE user_id = ?
115 Query SET @0 = '2'
115 Query EXECUTE mdb2_statement_mysql_XXX USING @0
115 Query DEALLOCATE PREPARE mdb2_statement_mysql_XXX
116 Connect mailuser@localhost on
116 Init DB maildb
116 Query SET NAMES utf8
115 Query PREPARE mdb2_statement_mysql_XXX FROM 'SELECT vars, ip, changed FROM session WHERE sess_id = ?'
115 Prepare SELECT vars, ip, changed FROM session WHERE sess_id = ?
115 Query SET @0 = 'XXX'
115 Query EXECUTE mdb2_statement_mysql_XXX USING @0
115 Query DEALLOCATE PREPARE mdb2_statement_mysql_XXX
115 Quit
116 Quit
So from what I can see, it's connecting to the mail database (that houses the users/passwords), but isn't actually doing anything with the connection? I'm kind of out of ideas on where to look for more logs... any thoughts?
