Re: [Exim] Accepting mail for users in a MySQL database

Etusivu
Poista viesti
Vastaa
Lähettäjä: Dan Egli
Päiväys:  
Vastaanottaja: exim-users
Aihe: Re: [Exim] Accepting mail for users in a MySQL database
Dan Barry wrote:

> This is a multi-part message in MIME format.
> --
> [ Picked text/plain from multipart/alternative ]
> Hi, I'm trying to set up Exim to receive and send messages for users whom have their authentication information in a MySQL table. I found several sources for info on how to do this, but most is either for Exim 3.x or doesn't quite work right.
>
> I compiled Exim with LOOKUP_MYSQL=yes in Local/Makefile, so MySQL lookups are enabled.
>
> QPopper is installed and works. It saves successful POP logins to the relay_ip table for POP-before-SMTP authentication.
>
> Exim gives me no errors on startup. My configure file and mainlog are available at http://www.dajoob.com/configure and http://www.dajoob.com/mainlog
> The mainlog shows the errors from trying to send a message from Outlook Express and trying to send a message via the PHP mail() function.
>
> Any help would be appreciated.
> --
>
>
>
> --
>
> ## List details at http://www.exim.org/mailman/listinfo/exim-users Exim details at http://www.exim.org/ ##
>
>


Your problem is two fold:

MYSQL connection failed: Lost connection to MySQL server during query
That indicates a MySQL issue, perhaps a user ID / Password issue.

The 2nd is:
2004-07-18 14:33:56 1BmHQ4-00008i-7e <= DaJoob@??? H=(dan4)
[192.168.0.12] P=smtp S=1275 id=000001c46cee$0a248bc0$0c00a8c0@dan4
2004-07-18 14:33:56 1BmHQ4-00008i-7e User 0 set for local_delivery
transport is on the never_users list

that says that DaJoob@??? sent a message that is being delivered
to someone like root. NEVER deliver anything as root or To root! If you
expect to be able to read root mails, set up an alias in your aliases
file (i.e. /etc/aliases) like this:

root:    Dan



so that Dan gets all the root mail. By default exim will not do anything
as root. This is a saftey feature that I have come to appreciate.



PS. Fix your MX records please? You should have a DNS in your MX
records, not an IP.

i.e. good:

@             IN  MX     mail.dajoob.com
mail.dajoob.com.      IN  A       198.65.22.15


bad:

@            IN  MX     198.65.22.15




--
-- Dan