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
--
Kevin Coyner GnuPG key: 1024D/8CE11941 http://rustybear.com/publickey
Attachment:
signature.asc
Description: Digital signature