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
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 PRO
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.
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 './postfix/users.frm'
(
email varchar (80) primary key unique 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
> 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 mak
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 TA
