Mailing List Archive

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