Re: [Pmwh-users] Problems setting up SASL

[<in...@cs...>]

Taher Shihadeh wrote:
> Udo Mueller wrote:
> 
>>> However, after following the installation intructions I'm unable to 
>>> access the smtp service. Emails are sent OK from the localhost, but 
>>> don't work from other computers. SASL doesn't seem to work.
>>
>>
>> Does postfix get connection to mysql-server? Remember, postfix runs in 
>> chrooted environment.
> 
> 
> I'm confused about that. I suppose it doesn't. The host is set as 
> localhost at the .cf files, and the socket 
> /var/spool/postfix/var/run/mysqld/mysqld.sock is in it's jail. Postfix 
> doesn't present any error messages/logs when it's initiated, however the 
> mysql log doesn't show any accesses.

Was postfix be restartet after linking mysql's socket?
First you have to link mysql's socket and after that postfix has to be 
started!

> If I try configuring things to access MySQL through an IP host instead 
> of 'localhost' (and enable the UDP listener), I continuously get an 
> error as "Host 'borg.tajel.com' is not allowed to connect to this 
> MySQL". Which is a completely different problem (I dunno how to grant 
> access to other hosts editing the mysql.users table .... yet :)

In which table in database mysql is your user listed? In users (with all 
rights) or in users and db (with no rights in user and all rights in db)?

When in users, insert the following command:

insert into users ("borg.tajel.com","youruser","userspassword","Y",...,"Y")

If second then replace users in the query above with db.

Replace "..." with 10 "Y" to complete the query.

Try above.

Regards Udo