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=<[EMAIL PROTECTED]>
Aug 24 18:48:45 ns1 postfix/qmgr[2855]: 0DA3465029B: from=<[EMAIL PROTECTED]>,
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=<[EMAIL PROTECTED]>, relay=virtual, delay=22, status=deferred
(virtual_mailbox_maps: lookup [EMAIL PROTECTED]: 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: [EMAIL PROTECTED]
MSN: [EMAIL PROTECTED]
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:[EMAIL PROTECTED]
tel;work:9012772
tel;fax:9016377
url:http://www.zonalibre.com.uy
version:2.1
end:vcard
