On 11/10/17 16:21, Ralph Ballier wrote: > > ----- Nachricht von Reindl Harald <h.rei...@thelounge.net > <mailto:h.rei...@thelounge.net>> --------- > Datum: Wed, 11 Oct 2017 12:21:34 +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 mailinglist <dbmail@dbmail.org > <mailto: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> <mailto:h.rei...@thelounge.net>> >>> <mailto:h.rei...@thelounge.net%3E%3E> --------- >>> Datum: Mon, 9 Oct 2017 15:02:53 +0200 >>> Von: Reindl Harald <h.rei...@thelounge.net >>> <mailto:h.rei...@thelounge.net> <mailto:h.rei...@thelounge.net>> >>> <mailto:h.rei...@thelounge.net%3E%3E> >>> Antwort an: DBMail mailinglist <dbmail@dbmail.org >>> <mailto:dbmail@dbmail.org> <mailto:dbmail@dbmail.org>> >>> <mailto:dbmail@dbmail.org%3E%3E> >>> Betreff: Re: [Dbmail] Installations problems with dbmail 3.2.3 >>> An: dbmail@dbmail.org <mailto:dbmail@dbmail.org> >>> <mailto:dbmail@dbmail.org> <mailto:dbmail@dbmail.org%3E> >>> >>>> 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") > MySQL error 1005 is an incorrect foreign key. In this case a duplicate key in dbmail_users.user_idnr.
You must fix all duplicate keys in dbmail_users (there might be more than one) before table dbmail_auto_replies can be created . > > > 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 -- Sandino Araico Sánchez http://sandino.net
_______________________________________________ DBmail mailing list DBmail@dbmail.org http://lists.nfg.nl/mailman/listinfo/dbmail
