A NOTE has been added to this issue. ====================================================================== http://www.dbmail.org/mantis/view.php?id=1078 ====================================================================== Reported By: px3 Assigned To: ====================================================================== Project: DBMail Issue ID: 1078 Category: Database layer Reproducibility: have not tried Severity: minor Priority: normal Status: new target: ====================================================================== Date Submitted: 16-May-16 12:39 CEST Last Modified: 16-May-16 13:08 CEST ====================================================================== Summary: DBMail stopped working after upgrading to mysql 5.7 Description: After upgrading mysql to 5.7.12 dbmail stopped working. Inserts into the database are no longer possible.
Using mysql and executing the same statements from the mysql-client, everything works fine. All other applications on the machine are runnning fine, expect dbmail. dbmail-util -a shows no errors. Even trying to create a new user with dbmail-users ends up in: May 16 12:42:51 rdsroot dbmail/user[29631]: Debug:[user] do_add(+65): Adding user px3 with password type crypt,0 bytes mailbox limit and clientid 0... May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db] db_con_get(+263): [0xe05ca0] connection from pool May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db] db_stmt_prepare(+419): [0xe05ca0] [SELECT user_idnr FROM dbmail_users WHERE lower(userid) = lower(?)] May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db] db_stmt_set_str(+427): [0xdf5810] 1:[px3] May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db] db_con_close(+291): [0xe05ca0] connection to pool May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db] db_con_get(+263): [0xe05ca0] connection from pool May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db] db_stmt_prepare(+419): [0xe05ca0] [SELECT user_idnr FROM dbmail_users WHERE lower(userid) = lower(?)] May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db] db_stmt_set_str(+427): [0xdf5aa0] 1:[px3] May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db] db_con_close(+291): [0xe05ca0] connection to pool May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db] db_con_get(+263): [0xe05ca0] connection from pool May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db] db_begin_transaction(+542): BEGIN May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db] db_stmt_prepare(+419): [0xe05ca0] [INSERT INTO dbmail_users (userid,passwd,client_idnr,maxmail_size,encryption_type) VALUES (?,?,?,?,?) ] May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db] db_stmt_set_str(+427): [0xdf5d10] 1:[px3] May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db] db_stmt_set_str(+427): [0xdf5d10] 2:[fE3UF87llocO6] May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db] db_stmt_set_u64(+439): [0xdf5d10] 3:[0] May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db] db_stmt_set_u64(+439): [0xdf5d10] 4:[0] May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db] db_stmt_set_str(+427): [0xdf5d10] 5:[crypt] And then nothing more happens. Mysql shows no errors in the logfiles. ====================================================================== ---------------------------------------------------------------------- (0003734) px3 (reporter) - 16-May-16 13:08 http://www.dbmail.org/mantis/view.php?id=1078#c3734 ---------------------------------------------------------------------- The severity is "block", but i can't change it :( Issue History Date Modified Username Field Change ====================================================================== 16-May-16 12:39 px3 New Issue 16-May-16 13:06 px3 Issue Monitored: px3 16-May-16 13:08 px3 Note Added: 0003734 ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev