Re: sarge + postfix + mysql

On 8/26/05, Kevin Coyner <kevin@rustybear.com> wrote:

On Fri, Aug 26, 2005 at 02:03:41PM -0300, Juan Manuel Tato wrote......

> 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

Manuel - you still have something wrong with your user.  Look at
the line immediately above.  It says:

    "Access denied for user 'postfix'@'localhost'.

So when postfix/courier is doing a mysql database lookup, it is
presently doing so as user 'postfix'.  Yet you state that you've set
up everything to be user 'provider_admin'.

So check your entries in the mysql DB again in the user and db
tables.

Also, in /etc/postfix, you should have something similar to:

mysql-virtual_domains.cf
mysql-virtual_email2email.cf
mysql-virtual_forwardings.cf
mysql-virtual_lists_transport.cf
mysql-virtual_mailboxes.cf

Double check that each of these is correct.  For example, my
mysql-virtual_domains.cf file has:

user = vmail
password = xxxxxxx
dbname = provider
table = domains
select_field = transport
where_field = domain
hosts = 127.0.0.1

... and in my mysql db, in the user table, I have a user named
'vmail' that is only allowed to log in from localhost and has no
default priviledges.  In the mysql database, db table I have an
entry for User 'vmail', Host 'localhost' and Db 'provider'.  And
associated with this entry is where this user gets all the necessary
permissions for accessing the database 'provider'.

vmail is my equivalent of your 'provider_admin'.

You should be able to open up an xterm on the server and type the
following:

$ mysql -u provider_admin -p provider

... and be prompted for the password for provider_admin.  If you
cannot do this and gain command line entry to the provider database,
then you still do not have the mysql db entries right for your user.

If you can do this, then I suspect you have an error in your
mysql-virtual_xxxxx.cf files.

Kevin

--
Kevin Coyner  GnuPG key: 1024D/8CE11941  http://rustybear.com/publickey

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFDD3acqPceVIzhGUERAoolAJ0Qxuc3JidV+bQv+JHpPa9rnrtX7gCeJ/eE
PQ0ASKHEb8J3vjdiCKjiJrk=
=fjFM
-----END PGP SIGNATURE-----