Re: sarge + postfix + mysql

[Juan Manuel Tato <manuel@zonalibre.com.uy>]

kevin, thanks for your help, but is not working.....
i'd created as you told the provider_admin user, into mysql db, user
table...
but still the same problems
Aug 24 18:48:08 ns1 postfix/smtpd[3322]: connect from
localhost.localdomain[127.0.0.1]
Aug 24 18:48:40 ns1 postfix/smtpd[3322]: 0DA3465029B:
client=localhost.localdomain[127.0.0.1]
Aug 24 18:48:45 ns1 postfix/cleanup[3469]: 0DA3465029B:
message-id=<20050824214823.0DA3465029B@ns1.zonalibre.com.uy>
Aug 24 18:48:45 ns1 postfix/qmgr[2855]: 0DA3465029B: from=<ad@ad>,
size=354, nrcpt=1 (queue active)
Aug 24 18:48:45 ns1 postfix/virtual[3472]: warning: connect to mysql
server 127.0.0.1: Access denied for user 'postfix'@'localhost' (using
password: YES)
Aug 24 18:48:45 ns1 postfix/virtual[3472]: 0DA3465029B:
to=<user@virtual.test>, relay=virtual, delay=22, status=deferred
(virtual_mailbox_maps: lookup user@virtual.test: Success)
Aug 24 18:48:46 ns1 postfix/smtpd[3322]: disconnect from
localhost.localdomain[127.0.0.1]

thanks anyway
manuel

Kevin Coyner wrote:

> On Wed, Aug 24, 2005 at 06:10:57PM -0300, Juan Manuel Tato wrote......
>
>  
>
> > 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
> >    
>
>
> In your .cf files you've identified the user as "provider_admin".
>
> Have your created a user in your mysql db/user table called
> "provider_admin"?
>
> This is the main mysql db, not any of the provider db/tables you
> might have created.  This user (in your case 'provider_admin') does
> not need any priviledges in the user table.  You do that in the
> mysql/db table.
>
> So in this same db (mysql), you'll also need an entry in the db
> table.  You should make an entry where user=provider-admin,
> db=provider, and host=localhost.
>
> Recapping:
> ----------
>    Database:   mysql
>
>    Table:      user
>
>        create a new user 'provider_admin' with no priviledges
>
> ----------
>
>    Database:   mysql
>
>    Table:      db
>
>        create an entry for:
>
>            user=provider_admin
>            host=localhost
>            db=provider (i presume)
> ----------
>
> HTH,
>
> Kevin
>
>
>  


--

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