Yup, the cascades are gone again. I'm attaching to the mail a mysqldump -d dbmail.
Nobody but me can access the tables. Now I'll first try to update mysql to an higher version (dunno which one in is the ports), then I'll try do drop actual constraints and reapply them. I should still have the script somewhere. I was thinking.... Hey, this is a mail server! Why cant it write a mail to me if there's any (real) problem like this one? :-) So that I don't have to rely on reading maillog. Also because maillog is HUGE with spamassassin, sendmail, clamav and everything else writing to it. -----Messaggio originale----- Da: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Per conto di Paul J Stevens Inviato: giovedì 31 maggio 2007 23.56 A: DBMail mailinglist Oggetto: Re: [Dbmail] Here we go again Andrea Brancatelli wrote: > No, it wasn't me. I had the problem less than 2 weeks ago. > > I'm not using any guy. Well, I'm using phpMyAdmin but haven't touched > the dbmail database since I rebuilt it 2 weeks ago. > Have you checked? Are the cascades gone again? > I have strong feelings about mysql itself. Rethink. Revoke permissions to change the tables from anyone using that table. Then if it happens again, you can curse your database engine. If someone can provide me with a solid well tested procedure for doing a mysql2pgsql for dbmail, I'd be happy to test it. Believe me, I've tried to do it. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
-- MySQL dump 10.12 -- -- Host: localhost Database: dbmail -- ------------------------------------------------------ -- Server version 5.1.15-beta /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `dbmail_acl` -- DROP TABLE IF EXISTS `dbmail_acl`; CREATE TABLE `dbmail_acl` ( `user_id` bigint(21) NOT NULL, `mailbox_id` bigint(21) NOT NULL, `lookup_flag` tinyint(1) NOT NULL DEFAULT '0', `read_flag` tinyint(1) NOT NULL DEFAULT '0', `seen_flag` tinyint(1) NOT NULL DEFAULT '0', `write_flag` tinyint(1) NOT NULL DEFAULT '0', `insert_flag` tinyint(1) NOT NULL DEFAULT '0', `post_flag` tinyint(1) NOT NULL DEFAULT '0', `create_flag` tinyint(1) NOT NULL DEFAULT '0', `delete_flag` tinyint(1) NOT NULL DEFAULT '0', `administer_flag` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`user_id`,`mailbox_id`), KEY `user_id_index` (`user_id`), KEY `mailbox_id_index` (`mailbox_id`), CONSTRAINT `dbmail_acl_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `dbmail_users` (`user_idnr`), CONSTRAINT `dbmail_acl_ibfk_2` FOREIGN KEY (`mailbox_id`) REFERENCES `dbmail_mailboxes` (`mailbox_idnr`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `dbmail_aliases` -- DROP TABLE IF EXISTS `dbmail_aliases`; CREATE TABLE `dbmail_aliases` ( `alias_idnr` bigint(21) NOT NULL AUTO_INCREMENT, `alias` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT '', `deliver_to` varchar(250) CHARACTER SET latin1 NOT NULL DEFAULT '', `client_idnr` bigint(21) NOT NULL DEFAULT '0', PRIMARY KEY (`alias_idnr`), KEY `alias_index` (`alias`), KEY `client_idnr_index` (`client_idnr`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `dbmail_auto_notifications` -- DROP TABLE IF EXISTS `dbmail_auto_notifications`; CREATE TABLE `dbmail_auto_notifications` ( `user_idnr` bigint(21) NOT NULL, `notify_address` varchar(100) CHARACTER SET latin1 NOT NULL, KEY `user_idnr_index` (`user_idnr`), CONSTRAINT `dbmail_auto_notifications_ibfk_1` FOREIGN KEY (`user_idnr`) REFERENCES `dbmail_users` (`user_idnr`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `dbmail_auto_replies` -- DROP TABLE IF EXISTS `dbmail_auto_replies`; CREATE TABLE `dbmail_auto_replies` ( `user_idnr` bigint(21) NOT NULL DEFAULT '0', `reply_body` mediumtext CHARACTER SET latin1, `start_date` datetime NOT NULL, `stop_date` datetime NOT NULL, KEY `user_idnr_index` (`user_idnr`), CONSTRAINT `dbmail_auto_replies_ibfk_1` FOREIGN KEY (`user_idnr`) REFERENCES `dbmail_users` (`user_idnr`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `dbmail_ccfield` -- DROP TABLE IF EXISTS `dbmail_ccfield`; CREATE TABLE `dbmail_ccfield` ( `physmessage_id` bigint(20) NOT NULL, `id` bigint(20) NOT NULL AUTO_INCREMENT, `ccname` varchar(100) NOT NULL DEFAULT '', `ccaddr` varchar(100) NOT NULL DEFAULT '', PRIMARY KEY (`id`), UNIQUE KEY `physmessage_id` (`physmessage_id`,`id`), CONSTRAINT `dbmail_ccfield_ibfk_1` FOREIGN KEY (`physmessage_id`) REFERENCES `dbmail_physmessage` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `dbmail_datefield` -- DROP TABLE IF EXISTS `dbmail_datefield`; CREATE TABLE `dbmail_datefield` ( `physmessage_id` bigint(20) NOT NULL, `id` bigint(20) NOT NULL AUTO_INCREMENT, `datefield` datetime NOT NULL DEFAULT '1970-01-01 00:00:00', PRIMARY KEY (`id`), UNIQUE KEY `physmessage_id` (`physmessage_id`,`datefield`), CONSTRAINT `dbmail_datefield_ibfk_1` FOREIGN KEY (`physmessage_id`) REFERENCES `dbmail_physmessage` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `dbmail_envelope` -- DROP TABLE IF EXISTS `dbmail_envelope`; CREATE TABLE `dbmail_envelope` ( `physmessage_id` bigint(20) NOT NULL, `id` bigint(20) NOT NULL AUTO_INCREMENT, `envelope` text NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `physmessage_id` (`physmessage_id`,`id`), CONSTRAINT `dbmail_envelope_ibfk_1` FOREIGN KEY (`physmessage_id`) REFERENCES `dbmail_physmessage` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `dbmail_fromfield` -- DROP TABLE IF EXISTS `dbmail_fromfield`; CREATE TABLE `dbmail_fromfield` ( `physmessage_id` bigint(20) NOT NULL, `id` bigint(20) NOT NULL AUTO_INCREMENT, `fromname` varchar(100) NOT NULL DEFAULT '', `fromaddr` varchar(100) NOT NULL DEFAULT '', PRIMARY KEY (`id`), UNIQUE KEY `physmessage_id` (`physmessage_id`,`id`), CONSTRAINT `dbmail_fromfield_ibfk_1` FOREIGN KEY (`physmessage_id`) REFERENCES `dbmail_physmessage` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `dbmail_headername` -- DROP TABLE IF EXISTS `dbmail_headername`; CREATE TABLE `dbmail_headername` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `headername` varchar(100) NOT NULL DEFAULT '', PRIMARY KEY (`id`), UNIQUE KEY `headername` (`headername`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `dbmail_headervalue` -- DROP TABLE IF EXISTS `dbmail_headervalue`; CREATE TABLE `dbmail_headervalue` ( `headername_id` bigint(20) NOT NULL, `physmessage_id` bigint(20) NOT NULL, `id` bigint(20) NOT NULL AUTO_INCREMENT, `headervalue` text NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `physmessage_id` (`physmessage_id`,`id`), UNIQUE KEY `physmessage_id_2` (`physmessage_id`,`headername_id`,`headervalue`(255)), KEY `headername_id` (`headername_id`), KEY `physmessage_id_3` (`physmessage_id`), CONSTRAINT `dbmail_headervalue_ibfk_1` FOREIGN KEY (`headername_id`) REFERENCES `dbmail_headername` (`id`), CONSTRAINT `dbmail_headervalue_ibfk_2` FOREIGN KEY (`physmessage_id`) REFERENCES `dbmail_physmessage` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `dbmail_mailboxes` -- DROP TABLE IF EXISTS `dbmail_mailboxes`; CREATE TABLE `dbmail_mailboxes` ( `mailbox_idnr` bigint(21) NOT NULL AUTO_INCREMENT, `owner_idnr` bigint(21) NOT NULL DEFAULT '0', `name` varchar(100) NOT NULL, `seen_flag` tinyint(1) NOT NULL DEFAULT '0', `answered_flag` tinyint(1) NOT NULL DEFAULT '0', `deleted_flag` tinyint(1) NOT NULL DEFAULT '0', `flagged_flag` tinyint(1) NOT NULL DEFAULT '0', `recent_flag` tinyint(1) NOT NULL DEFAULT '0', `draft_flag` tinyint(1) NOT NULL DEFAULT '0', `no_inferiors` tinyint(1) NOT NULL DEFAULT '0', `no_select` tinyint(1) NOT NULL DEFAULT '0', `permission` tinyint(1) DEFAULT '2', PRIMARY KEY (`mailbox_idnr`), UNIQUE KEY `owner_idnr_name_index` (`owner_idnr`,`name`), KEY `name_index` (`name`), KEY `owner_idnr_index` (`owner_idnr`), CONSTRAINT `dbmail_mailboxes_ibfk_1` FOREIGN KEY (`owner_idnr`) REFERENCES `dbmail_users` (`user_idnr`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `dbmail_messageblks` -- DROP TABLE IF EXISTS `dbmail_messageblks`; CREATE TABLE `dbmail_messageblks` ( `messageblk_idnr` bigint(21) NOT NULL AUTO_INCREMENT, `physmessage_id` bigint(21) NOT NULL DEFAULT '0', `messageblk` longblob NOT NULL, `blocksize` bigint(21) NOT NULL DEFAULT '0', `is_header` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`messageblk_idnr`), KEY `physmessage_id_index` (`physmessage_id`), KEY `physmessage_id_is_header_index` (`physmessage_id`,`is_header`), CONSTRAINT `dbmail_messageblks_ibfk_1` FOREIGN KEY (`physmessage_id`) REFERENCES `dbmail_physmessage` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `dbmail_messages` -- DROP TABLE IF EXISTS `dbmail_messages`; CREATE TABLE `dbmail_messages` ( `message_idnr` bigint(21) NOT NULL AUTO_INCREMENT, `mailbox_idnr` bigint(21) NOT NULL DEFAULT '0', `physmessage_id` bigint(21) NOT NULL DEFAULT '0', `seen_flag` tinyint(1) NOT NULL DEFAULT '0', `answered_flag` tinyint(1) NOT NULL DEFAULT '0', `deleted_flag` tinyint(1) NOT NULL DEFAULT '0', `flagged_flag` tinyint(1) NOT NULL DEFAULT '0', `recent_flag` tinyint(1) NOT NULL DEFAULT '0', `draft_flag` tinyint(1) NOT NULL DEFAULT '0', `unique_id` varchar(70) NOT NULL, `status` tinyint(3) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`message_idnr`), KEY `physmessage_id_index` (`physmessage_id`), KEY `mailbox_idnr_index` (`mailbox_idnr`), KEY `seen_flag_index` (`seen_flag`), KEY `unique_id_index` (`unique_id`), KEY `status_index` (`status`), CONSTRAINT `dbmail_messages_ibfk_1` FOREIGN KEY (`physmessage_id`) REFERENCES `dbmail_physmessage` (`id`), CONSTRAINT `dbmail_messages_ibfk_2` FOREIGN KEY (`mailbox_idnr`) REFERENCES `dbmail_mailboxes` (`mailbox_idnr`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `dbmail_pbsp` -- DROP TABLE IF EXISTS `dbmail_pbsp`; CREATE TABLE `dbmail_pbsp` ( `idnr` bigint(21) NOT NULL AUTO_INCREMENT, `since` datetime NOT NULL, `ipnumber` varchar(40) NOT NULL, PRIMARY KEY (`idnr`), UNIQUE KEY `ipnumber_index` (`ipnumber`), KEY `since_index` (`since`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `dbmail_physmessage` -- DROP TABLE IF EXISTS `dbmail_physmessage`; CREATE TABLE `dbmail_physmessage` ( `id` bigint(21) NOT NULL AUTO_INCREMENT, `messagesize` bigint(21) NOT NULL DEFAULT '0', `rfcsize` bigint(21) NOT NULL DEFAULT '0', `internal_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `dbmail_referencesfield` -- DROP TABLE IF EXISTS `dbmail_referencesfield`; CREATE TABLE `dbmail_referencesfield` ( `physmessage_id` bigint(20) NOT NULL, `id` bigint(20) NOT NULL AUTO_INCREMENT, `referencesfield` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`), UNIQUE KEY `physmessage_id` (`physmessage_id`,`referencesfield`), CONSTRAINT `dbmail_referencesfield_ibfk_1` FOREIGN KEY (`physmessage_id`) REFERENCES `dbmail_physmessage` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `dbmail_replycache` -- DROP TABLE IF EXISTS `dbmail_replycache`; CREATE TABLE `dbmail_replycache` ( `to_addr` varchar(100) NOT NULL DEFAULT '', `from_addr` varchar(100) NOT NULL DEFAULT '', `handle` varchar(100) NOT NULL DEFAULT '', `lastseen` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', UNIQUE KEY `replycache_1` (`to_addr`,`from_addr`,`handle`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `dbmail_replytofield` -- DROP TABLE IF EXISTS `dbmail_replytofield`; CREATE TABLE `dbmail_replytofield` ( `physmessage_id` bigint(20) NOT NULL, `id` bigint(20) NOT NULL AUTO_INCREMENT, `replytoname` varchar(100) NOT NULL DEFAULT '', `replytoaddr` varchar(100) NOT NULL DEFAULT '', PRIMARY KEY (`id`), UNIQUE KEY `physmessage_id` (`physmessage_id`,`id`), CONSTRAINT `dbmail_replytofield_ibfk_1` FOREIGN KEY (`physmessage_id`) REFERENCES `dbmail_physmessage` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `dbmail_sievescripts` -- DROP TABLE IF EXISTS `dbmail_sievescripts`; CREATE TABLE `dbmail_sievescripts` ( `owner_idnr` bigint(21) NOT NULL DEFAULT '0', `name` varchar(100) NOT NULL, `script` text, `active` tinyint(1) NOT NULL DEFAULT '0', KEY `name` (`name`), KEY `owner_idnr` (`owner_idnr`), KEY `owner_idnr_2` (`owner_idnr`,`name`), CONSTRAINT `dbmail_sievescripts_ibfk_1` FOREIGN KEY (`owner_idnr`) REFERENCES `dbmail_users` (`user_idnr`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `dbmail_subjectfield` -- DROP TABLE IF EXISTS `dbmail_subjectfield`; CREATE TABLE `dbmail_subjectfield` ( `physmessage_id` bigint(20) NOT NULL, `id` bigint(20) NOT NULL AUTO_INCREMENT, `subjectfield` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`), UNIQUE KEY `physmessage_id` (`physmessage_id`,`subjectfield`), CONSTRAINT `dbmail_subjectfield_ibfk_1` FOREIGN KEY (`physmessage_id`) REFERENCES `dbmail_physmessage` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `dbmail_subscription` -- DROP TABLE IF EXISTS `dbmail_subscription`; CREATE TABLE `dbmail_subscription` ( `user_id` bigint(21) NOT NULL DEFAULT '0', `mailbox_id` bigint(21) NOT NULL, PRIMARY KEY (`user_id`,`mailbox_id`), KEY `user_id_index` (`user_id`), KEY `mailbox_id_index` (`mailbox_id`), CONSTRAINT `dbmail_subscription_ibfk_1` FOREIGN KEY (`mailbox_id`) REFERENCES `dbmail_mailboxes` (`mailbox_idnr`), CONSTRAINT `dbmail_subscription_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `dbmail_users` (`user_idnr`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `dbmail_tofield` -- DROP TABLE IF EXISTS `dbmail_tofield`; CREATE TABLE `dbmail_tofield` ( `physmessage_id` bigint(20) NOT NULL, `id` bigint(20) NOT NULL AUTO_INCREMENT, `toname` varchar(100) NOT NULL DEFAULT '', `toaddr` varchar(100) NOT NULL DEFAULT '', PRIMARY KEY (`id`), UNIQUE KEY `physmessage_id` (`physmessage_id`,`id`), CONSTRAINT `dbmail_tofield_ibfk_1` FOREIGN KEY (`physmessage_id`) REFERENCES `dbmail_physmessage` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `dbmail_usermap` -- DROP TABLE IF EXISTS `dbmail_usermap`; CREATE TABLE `dbmail_usermap` ( `login` varchar(100) NOT NULL, `sock_allow` varchar(100) NOT NULL, `sock_deny` varchar(100) NOT NULL, `userid` varchar(100) NOT NULL, UNIQUE KEY `usermap_idx_1` (`login`,`sock_allow`,`userid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `dbmail_users` -- DROP TABLE IF EXISTS `dbmail_users`; CREATE TABLE `dbmail_users` ( `user_idnr` bigint(21) NOT NULL AUTO_INCREMENT, `userid` varchar(100) NOT NULL, `passwd` varchar(34) NOT NULL, `client_idnr` bigint(21) NOT NULL DEFAULT '0', `maxmail_size` bigint(21) NOT NULL DEFAULT '0', `curmail_size` bigint(21) NOT NULL DEFAULT '0', `encryption_type` varchar(20) NOT NULL, `last_login` datetime NOT NULL DEFAULT '1979-11-03 22:05:58', `maxsieve_size` bigint(20) NOT NULL DEFAULT '0', `cursieve_size` bigint(20) NOT NULL DEFAULT '0', PRIMARY KEY (`user_idnr`), UNIQUE KEY `userid_index` (`userid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40103 SET [EMAIL PROTECTED] */; /*!40101 SET [EMAIL PROTECTED] */; /*!40014 SET [EMAIL PROTECTED] */; /*!40014 SET [EMAIL PROTECTED] */; /*!40101 SET [EMAIL PROTECTED] */; /*!40101 SET [EMAIL PROTECTED] */; /*!40101 SET [EMAIL PROTECTED] */; /*!40111 SET [EMAIL PROTECTED] */; -- Dump completed on 2007-05-31 22:09:10
_______________________________________________ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
