----- Nachricht von Reindl Harald <h.rei...@thelounge.net> ---------
Datum: Wed, 11 Oct 2017 12:21:34 +0200
Von: Reindl Harald <h.rei...@thelounge.net>
Antwort an: DBMail mailinglist <dbmail@dbmail.org>
Betreff: Re: [Dbmail] Installations problems with dbmail 3.2.3
An: DBMail mailinglist <dbmail@dbmail.org>
Am 11.10.2017 um 12:14 schrieb Ralph Ballier:
----- Nachricht von Reindl Harald <h.rei...@thelounge.net
<mailto:h.rei...@thelounge.net>> ---------
Datum: Mon, 9 Oct 2017 15:02:53 +0200
Von: Reindl Harald <h.rei...@thelounge.net
<mailto:h.rei...@thelounge.net>>
Antwort an: DBMail mailinglist <dbmail@dbmail.org
<mailto:dbmail@dbmail.org>>
Betreff: Re: [Dbmail] Installations problems with dbmail 3.2.3
An: dbmail@dbmail.org <mailto:dbmail@dbmail.org>
Am 09.10.2017 um 11:31 schrieb Ralph Ballier:
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)).
can't say anything about 3.2.x because i hestiate to give it a
try as long this list and dbmail-upstream at all is that silent
Nothing happens after the last line. The user is not created.
What can I do? What are the question marks?
https://dev.mysql.com/doc/refman/5.7/en/sql-syntax-prepared-statements.html
_______________________________________________
Thanks for explanation. But what can I do to correct the error?
Do I have correctly understood: you advises to continue using
dbmail because it has no future?
i can't say anything except that we use the latest 3.1.17 snapshot
for years now with MariaDB 5.5, 10.0, 10.1 and now 10.2.9 and for
now i don't plan upgrade to 3.2
By the way, I tried it with MariaDB. Since the set-up of the tables
already fails because an index is double (?)
as said: i did not touch 3.2 and without proper naming the errors
nobody would be able to help you
_______________________________________________
Thanks for your answer.
I now use 3.1.17. There is the same error message while set up the
tables using "create_tables.mysql":
ERROR 1005 (HY000) at line 401: Can't create table
`dbmail`.`dbmail_auto_replies` (errno: 121 "Duplicate key on write or
update")
Line 401 of "create_tables.mysql" is this:
CREATE TABLE dbmail_auto_replies (
user_idnr bigint(20) UNSIGNED DEFAULT '0' NOT NULL,
start_date DATETIME NOT NULL,
stop_date DATETIME NOT NULL,
reply_body MEDIUMTEXT,
INDEX user_idnr_index (user_idnr),
FOREIGN KEY user_idnr_fk (user_idnr)
REFERENCES dbmail_users (user_idnr) ON DELETE
CASCADE ON UPDATE CASCADE
) ENGINE InnoDB DEFAULT CHARSET=utf8;
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://lists.nfg.nl/mailman/listinfo/dbmail
