Hello,
I installed dbmail 3.2.3 under Ubuntu 16.04.3 after compiling the
sources. Everything was well during compilation and installation. As
an authdriver I have set sql. I have used the script for installation
the database tables. I use sockets (but using tcp/ip there is the same
problem (see below)).
Unfortunately, creating a user does not work.
If I use the example from the installation manual (or another example):
dbmail-users -a john -w secret -g 0 -m 25M -s
j...@dude.org,j...@dude.net,@net.com
I always get in /var/log/mysql/mysql.log the following messages:
------------------------------------------------------- BEGIN
mysql.log
-----------------------------------------------------------------------------------------
2017-10-09T09:04:51.880410Z 148 Connect dbmail@localhost on
dbmail using Socket
2017-10-09T09:04:51.880808Z 149 Connect dbmail@localhost on
dbmail using Socket
2017-10-09T09:04:51.881104Z 150 Connect dbmail@localhost on
dbmail using Socket
2017-10-09T09:04:51.881349Z 151 Connect dbmail@localhost on
dbmail using Socket
2017-10-09T09:04:51.881578Z 152 Connect dbmail@localhost on
dbmail using Socket
2017-10-09T09:04:51.882028Z 148 Prepare SELECT 1=1 FROM
dbmail_users LIMIT 1 OFFSET 0
2017-10-09T09:04:51.882295Z 148 Close stmt
2017-10-09T09:04:51.882379Z 148 Prepare SELECT 1=1 FROM
dbmail_mimeparts LIMIT 1 OFFSET 0
2017-10-09T09:04:51.882577Z 148 Close stmt
2017-10-09T09:04:51.882648Z 148 Prepare SELECT 1=1 FROM
dbmail_header LIMIT 1 OFFSET 0
2017-10-09T09:04:51.882816Z 148 Close stmt
2017-10-09T09:04:51.883040Z 149 Prepare SELECT 1=1 FROM
dbmail_upgrade_steps WHERE from_version = ? AND to_version = ?
2017-10-09T09:04:51.883343Z 149 Close stmt
2017-10-09T09:04:51.883508Z 149 Prepare SELECT 1=1 FROM
dbmail_upgrade_steps WHERE from_version = ? AND to_version = ?
2017-10-09T09:04:51.883713Z 149 Close stmt
2017-10-09T09:04:51.883835Z 149 Prepare SELECT 1=1 FROM
dbmail_upgrade_steps WHERE from_version = ? AND to_version = ?
2017-10-09T09:04:51.884076Z 149 Close stmt
2017-10-09T09:04:51.884224Z 149 Prepare SELECT 1=1 FROM
dbmail_upgrade_steps WHERE from_version = ? AND to_version = ?
2017-10-09T09:04:51.884505Z 149 Close stmt
2017-10-09T09:04:51.885030Z 148 Prepare SELECT user_idnr
FROM dbmail_users WHERE lower(userid) = lower(?)
2017-10-09T09:04:51.885249Z 148 Close stmt
2017-10-09T09:04:51.885449Z 148 Prepare SELECT user_idnr
FROM dbmail_users WHERE lower(userid) = lower(?)
2017-10-09T09:04:51.885675Z 148 Close stmt
2017-10-09T09:04:51.885755Z 148 Query START TRANSACTION
2017-10-09T09:04:51.885880Z 148 Prepare INSERT INTO
dbmail_users (userid,passwd,client_idnr,maxmail_size,encryption_type)
VALUES (?,?,?,?,?)
-------------------------------------------- END mysql.log
----------------------------------------------------------------------------------------------------------------------------------------------------
Nothing happens after the last line. The user is not created.
What can I do? What are the question marks?
Thanks
Ralph
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://lists.nfg.nl/mailman/listinfo/dbmail
