Re: Installations problems with dbmail 3.2.3

  ----- Nachricht von Reindl Harald <[email protected]> ---------
     Datum: Wed, 11 Oct 2017 12:21:34 +0200
       Von: Reindl Harald <[email protected]>
Antwort an: DBMail mailinglist <[email protected]>
   Betreff: Re: [Dbmail] Installations problems with dbmail 3.2.3
        An: DBMail mailinglist <[email protected]>

> Am 11.10.2017 um 12:14 schrieb Ralph Ballier:
>> ----- Nachricht von Reindl Harald <[email protected]  
>> <mailto:[email protected]>> ---------
>>      Datum: Mon, 9 Oct 2017 15:02:53 +0200
>>        Von: Reindl Harald <[email protected]  
>> <mailto:[email protected]>>
>> Antwort an: DBMail mailinglist <[email protected]  
>> <mailto:[email protected]>>
>>    Betreff: Re: [Dbmail] Installations problems with dbmail 3.2.3
>>         An: [email protected] <mailto:[email protected]>
>>
>>> 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
[email protected]
http://lists.nfg.nl/mailman/listinfo/dbmail