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