Mailing List Archive

Hello exim-users,

I'm making Exim+MySQL system and I have a problem. This is configuration file:

##########################################################

MYSQL_AUTHSERVER=localhost
MYSQL_AUTHPORT=3306
MYSQL_AUTHDB=mail
MYSQL_AUTHTABLE=auth
MYSQL_AUTHUSER=exim
MYSQL_AUTHPASSWORD=exim_pass
MYSQL_USERNAMEFIELD=username
MYSQL_DOMAINFIELD=domain
MYSQL_ALIASFIELD=alias
MYSQL_ISALIASFIELD=is_alias
RELAY_TIMEOUT=5 MINUTE
MYSQL_ALIAS = SELECT MYSQL_ALIASFIELD FROM MYSQL_AUTHTABLE WHERE MYSQL_DOMAINFIELD LIKE '${quote_mysql:$domain}' AND MYSQL_USERNAMEFIELD LIKE '${quote_mysql:$local_part}' AND MYSQL_ISALIASFIELD='yes'
MYSQL_ALL_ALIAS = SELECT MYSQL_ALIASFIELD FROM MYSQL_AUTHTABLE WHERE MYSQL_DOMAINFIELD='${quote_mysql:$domain}' AND MYSQL_USERNAMEFIELD='@' AND MYSQL_ISALIASFIELD='yes'
MYSQL_USER = SELECT DISTINCT MYSQL_DOMAINFIELD FROM MYSQL_AUTHTABLE WHERE MYSQL_DOMAINFIELD LIKE '${quote_mysql:$domain}' AND MYSQL_USERNAMEFIELD LIKE '${quote_mysql:$local_part}' AND MYSQL_ISALIASFIELD='no'
MYSQL_DOMAIN = SELECT DISTINCT MYSQL_DOMAINFIELD FROM MYSQL_AUTHTABLE WHERE MYSQL_DOMAINFIELD='$key'
MYSQL_RELAY = SELECT ip FROM relay_ip WHERE ip="${sender_host_address}" AND DATE_SUB(NOW(), INTERVAL RELAY_TIMEOUT) < ts
mysql_servers = "MYSQL_AUTHSERVER::MYSQL_AUTHPORT/MYSQL_AUTHDB/MYSQL_AUTHUSER/MYSQL_AUTHPASSWORD"
LOCAL_DOMAINS = localhost
local_domains = LOCAL_DOMAINS:mysql;MYSQL_DOMAIN
forbid_domain_literals
never_users = root
host_accept_relay = localhost:mysql;MYSQL_RELAY
host_lookup = 0.0.0.0/0
receiver_verify
sender_verify
timeout_frozen_after = 7d
remote_smtp:
driver = smtp
virtual_delivery:
driver = appendfile
file = /usr/local/exim/var/spool/mail/${domain}/${local_part}
user = exim
group = mail
mode = 0660
virtual_local_user:
domains = ${lookup mysql {MYSQL_USER}{$value}}
driver = smartuser
transport = virtual_delivery
virtual_aliases:
driver = aliasfile
search_type = mysql
query = MYSQL_ALIAS
include_domain = true
virtual_all_alias:
driver = aliasfile
search_type = mysql
query = MYSQL_ALL_ALIAS
include_domain = true

lookuphost:
driver = lookuphost
transport = remote_smtp

* * F,2h,15m; G,16h,1h,1.5; F,4d,8h
###################################################

The databases that I made, have this structure:

>USE mail;

>CREATE TABLE auth
>(
> username (64) DEFAULT '' NOT NULL,
> domain varchar(64) DEFAULT '' NOT NULL,
> alias varchar(255) DEFAULT '' NOT NULL,
> is_alias enum('yes','no') DEFAULT 'no' NOT NULL,
> password varchar(32) DEFAULT '' NOT NULL,
> uid varchar(8) DEFAULT 'exim' NOT NULL,
> gid varchar(8) DEFAULT 'mail' NOT NULL );

>CREATE TABLE relay_ip
>(
> ip char(15) DEFAULT '' NOT NULL,
> ts datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
> KEY ip (ip) );

And a problem is when I finally run Exim and try to test it, I get this error message:

>220 Welcome to mail server of Mixanorganosi Pellas ! ESMTP Tue, 09 Jul 2002 12:08:23 +0300
>helo A
>250 mixanorganosi.gr Hello A
>mail from: a@a.gr
>250 <a@a.gr> is syntactically correct
>rcpt to: george@mixanorganosi.gr
(anyone address may be placed)
>451 temporary local failure; please try later
>221 mixanorganosi.gr closing connection

WHAT IS THIS AND HOW CAN I FIX IT ?


--
Best regards,
George mailto:george@mixanorganosi.gr