Installations problems with dbmail 3.2.3

Ralph Ballier <[email protected]> Mon, 09 Oct 2017 11:31:15 +0200
Newsgroups gmane.mail.imap.dbmail
Message-ID <20171009113115.Horde.FzOBlW2SATGkNcu7BN1DALN@horde.osz-lise-meitner.eu>
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  
[email protected],[email protected],@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
[email protected]
http://lists.nfg.nl/mailman/listinfo/dbmail