Hi
according to Dr Google I'm not the first one to encounter this error
below.
SpamAssassin: invoked with 'spamd -D -q -u filter'
failed to load user (filter) scores from SQL database: SQL Error:
Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (13)
Thus, I cannot
Hi
Hello.
What output does the following statement produce:
show variables like 'have_innodb';
mysql show variables like 'have_innodb';
+---+---+
| Variable_name | Value |
+---+---+
| have_innodb | YES |
+---+---+
1 row in set (0.00
Hi
thanks for your help and your answers, it works now.
foreign key (ownerdomain) references domains(domain) on delete cascade
^^
was missing.
Philipp
-Original Message-
From: Philipp Snizek [mailto:[EMAIL PROTECTED]
Sent
Hi
I run a Postfix MTA attached to a mysql DB with various domains on it.
A domain consists of email addresses.
When I want to delete the domain the referenced email addresses should
be deleted, too. But that doesn't work and I don't know why.
here are the two tables domains and users:
CREATE
Foreign keys are only supported within InnoDB tables (on both
sides)..
so using a table 'users' like
create table users (
email varchar (80) primary key unique not null,
belongs_to integer not null references domains on delete cascade
);
without foreign keys could help?
I couldn't
not null,
belongs_to integer not null,
foreign key (belongs_to) references domains on delete cascade
) type=innodb;
Philipp
Rhino
- Original Message -
From: Philipp Snizek [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; Mysql List (E-mail)
mysql@lists.mysql.com
Sent: Tuesday, February 22
Hi
I must be blind. Please help a DB-Newbie. What's wrong here:
create table users (
email varchar (80) unique not null,
ownerdomain int not null,
foreign key (ownerdomain) references domains on delete cascade
) type=innodb;
MySQL sais: ERROR 1005: Can't create table