[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

sarge + postfix + mysql



hi, i'm following this how to
http://workaround.org/articles/ispmail-sarge/
basically configuring postfix to read maps from mysql database.

but i'm having this error message
Aug 24 18:05:18 ns1 postfix/virtual[3015]: warning: connect to mysql server 127.0.0.1: Access denied for user 'postfix'@'localhost' (using password: YES)

but i have created 3 files like this


     mysql-virtual_domains.cf

user = provider_admin
password = xxx
dbname = provider
table = domains
select_field = 'virtual'
where_field = domain
hosts = 127.0.0.1


     mysql-virtual_forwardings.cf

user = provider_admin
password = xxx
dbname = provider
table = forwardings
select_field = destination
where_field = source
hosts = 127.0.0.1


     mysql-virtual_mailboxes.cf

user = provider_admin
password = xxx
dbname = provider
table = users
select_field = CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/')
where_field = email
hosts = 127.0.0.1

i dont know where postfix get the "postfix" user to log into mysql
any idea?
thanks in advance
manuel


--

ZONA LIBRE

www.zonalibre.com.uy | Paysandú 976
Teléfono 9012772     | Fax 9016377

E-mail: manuel@zonalibre.com.uy
MSN: manuel@zonalibre.com.uy

begin:vcard
fn:Juan Manuel Tato
n:;Juan Manuel Tato
org:Zona Libre Trad. Co.
adr;quoted-printable:;;Paysand=C3=BA 976;Montevideo;;11100;Uruguay
email;internet:manuel@zonalibre.com.uy
tel;work:9012772
tel;fax:9016377
url:http://www.zonalibre.com.uy
version:2.1
end:vcard


Reply to: