----- Nachricht von Andrea Brancatelli <abrancate...@schema31.it> ---------
Datum: Thu, 12 Oct 2017 13:08:09 +0200
Von: Andrea Brancatelli <abrancate...@schema31.it>
Betreff: Re: [Dbmail] Installations problems with dbmail 3.2.3
An: DBMail mailinglist <dbmail@dbmail.org>
Cc: Ralph Ballier <ball...@mail.schule.de>
Dear Ralph.
I strongly suggest you to use dbmailt 3.2.x and not 3.1.x which is
a dead branch.
We've been using dbmail 3.2.x since almost two years hosting
thousands (as of now, 48962 exactly) mailboxes without a glitch on
MySQL 5.6.
I never used MariaDB but I prefer to stick on officially supported
software, especially with new MySQL's roadmap.
As for your problem with those tables, it's pretty strange you
have problem with the init SQL as I recall it to be pretty
straightforward...
Anyhow, that's the definition for those two tables:
CREATE TABLE `dbmail_auto_replies` (
`user_idnr` bigint(20) unsigned NOT NULL DEFAULT '0',
`start_date` datetime NOT NULL,
`stop_date` datetime NOT NULL,
`reply_body` mediumtext,
KEY `user_idnr_index` (`user_idnr`),
CONSTRAINT `dbmail_auto_replies_ibfk_1` FOREIGN KEY (`user_idnr`)
REFERENCES `dbmail_users` (`user_idnr`) ON DELETE CASCADE ON UPDATE
CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `dbmail_auto_notifications` (
`user_idnr` bigint(20) unsigned NOT NULL,
`notify_address` varchar(100) NOT NULL DEFAULT '',
KEY `user_idnr_index` (`user_idnr`),
CONSTRAINT `dbmail_auto_notifications_ibfk_1` FOREIGN KEY
(`user_idnr`) REFERENCES `dbmail_users` (`user_idnr`) ON DELETE
CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
---
ANDREA BRANCATELLI SCHEMA31 S.P.A.CHIEF TECHNOLOGY OFFICIER
Thanks. This works. It was a problem only with MariaSQL, not with
MySQL. MySQL has overlook the double keys. Or is that not an error?
Now I can insert a new user with "dbmail-users -a". That means: INSERT works.
I think, if you use dbmail 3.2.3 together with MySQL 5.7 (not 5.6) or
the newest MariaDB, dbmail deny every INSERT command. This was the
reason for my question in this mailing list.
Ralph
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://lists.nfg.nl/mailman/listinfo/dbmail
