logs archiveIRC Archive / Freenode / #exim / 2010 / April / 22 / 1
gngkai
hi there
henk
hi
gngkai
using spamd with exim
busy server, so often I get: spam acl condition: error reading from spamd socket: Connection timed out
is there a way to raise the timeout used by exim to communicate with spamd?
Groenleer
Has anyone set exim up so that the logs are spawn to a MySQL database?
djce
gngkai: seems to be hard-wired at 2 minutes, AFAICT
gngkai
djce: thx
djce
But that sounds like plenty to me - probably indicates a problem to be solved elswhere, not by raising the timeout.
phx
Groenleer, i'm doing something similar. i'm logging rejects into a pgsql database
Groenleer, but logging best done into syslog imho
statistical logging is nice to have in something database, but that's different :)
Groenleer
phx: i am in the Netherlands (EU) and we have that stupid Data Retention Law
As a hosting provider with an emailserver we are forced to store loggings in an interexangable format. That means i need to be able to rearange columns as needed and when needed. (Most of the time when they request the logs).
         

phx
what's that?
brb smoke
Groenleer
The Data Retention Law forces us to store loggings for up to 18 months.
phx
yes
but the question is WHAT logs do you need to have
maybe you're better off with something syslog->sql relaying
or asking on the MLs for some kind of sql logging feature
Groenleer
the syslog (/var/log/syslog) is also used for different logs. However things are split to mail_log etc.
phx
you can do mail.*
it's like mail.* /var/log/maillog
or you can also filter for exim, !exim\n*.* /var/log/maillog
pittstains
I'm a Debian user with a question about the system mail name. (dpkg-reconfigure exim4-config says it's used to "qualify mail addresses without a domain name.") I've been playing with a few different values but can't seem to get the behavior I want. I'm using this server for outgoing mail only (email blasts via PHP-based software). If I set the system mail name to "localhost," I get local mail (results of cron jobs being what
phx
(results of cron jobs being what
was chopped there
pittstains
whoops, thanks... reposting
If I set the system mail name to "localhost," I get local mail (results of cron jobs being what I'm mainly interested here), but I get a lot of misconfigurations other places (e.g. Return-Path: <myuser@localhost>, envelope-from <myuser@localhost>, etc).
f I set the system mail name to mydomain.net, all of those misconfigurations seem to be resolved, but I lose local mail: cron jobs go to root@mydomain.net, www-data@mydomain.net, etc. Is there a way to get the best of both worlds?
phx, any thoughts about this?
or anyone else?
phx
got a bit of job to do, will read it afterwards
pittstains
thanks
phx
i'm not using debian. handle mail for root@mydomain.net
probably something is messed up
pittstains
arg, i guess that the easier fix... i'll also have to handle mail for www-data and sit down and think about anything else i need to handle. i was hoping to do solve this the "right" way if there is one, though
phx
by me, the "right" way by is to take the example config from the exim distribution, open the docs, and start writing it. and definitely not touch any of the debian stuff
pittstains
haha... well, i can take a hack at that. i presume debconf just takes the user input to write the configs for you... where is the proper exim config file stored?
I have a bunch of files that look like configs but I can't tell who's a debian file and who's a true blue exim file
henk
pittstains: depending on your answer, update-exim4.conf generates /var/lib/exim4/config.autogenerated from the files in /etc/exim4/conf.d/ or from /etc/exim4/exim4.conf.template
pittstains
henk: thanks. sigh, i hate it when orgs try to turn their programmer into a sysadmin as well... i don't have time to learn a whole new field!
henk
muahaahahahaha
it's the other way round here one could say
pittstains
you're a sysadmin turned programmer, eh? perhaps i should send you my sysadmin and you can send me your programming :-)
henk
'g'
no, it's not that bad...
phx
a sysadmin has to be able to handle basic programming. otherwise he's a failadmin
         

henk
i'm just supposed to be The Sysadmin Guru[tm] in that company i have the impression... one linux admin for every linux-based service imaginable...
phx
shell, c, c++, awk, perl are a must at least
henk
yup, basic scripting and at least understanding the more popular languages to a certain degree really helps.
pittstains
looking at the config file... yup, much too much for me to absorb in the short amount of time i've been given to do it...
i guess i'll just set the system name to mydomain.net and handle mail for root@mydomain.net and www-data@mydomain.net
henk
and email is not a topic you are 'good' at after a few days...
pittstains
exactly
i *hate* email
henk
pittstains: what about 'hostname' and 'hostname -f' output?
pittstains: does that correctly return the hostname and the fqdn respectively?
pittstains
henk: yes they do
hostname gives myhost
hostname -f give myhost.mydomain.net
henk
hm, i'm not sure i got the problem right... when you send a mail to 'root' the contents of /etc/mailname is appended?
pittstains
yeah, that's right
so instead of having cron reports send to root@localhost, they get sent off to root@mydomain.net
henk
yup, correct. why do you want to change that?
pittstains
i want local mail to stay local :-)
basically this box is a webserver with some PHP-based email apps installed
henk
pittstains: it will stay local...
pittstains
i don't want to set up real mailboxes here, nor do i want to receive mail here
henk
you don't need to imho
pittstains
incoming mail for mydomain.net is handled by a third party
not by the box i'm working on now
henk
why don't you tell cron to send the mails to 'root@localhost' instead of just 'root'
pittstains
...
how would i do that?
henk
ah, cron sends by default to just 'root'...
shouldn't exim know that @own-hostname can be handled by himself and not send the mails out to the third party?
pittstains
i get this kind of stuff in my mainlog: 2010-04-22 10:35:15 1O4E5b-0006Jt-DU ** root@mydomain.net R=dnslookup T=remote_smtp: SMTP error from remote mail server after RCPT TO:<root@mydomain.net>: host mx.fusemail.net [208.70.131.50]: 550 Email Address was not found. (ref 1)
fusemail is the third party that handles employees' email accounts
henk
pittstains: does exim know 'mydomain.net' is local to him?
pittstains
...
hmmmmmm
let me try running dpkg-reconfigure again
henk
phx: does that make sense? exim may qualify unqualified recipients and can handle the mail locally if he knows that he is responsible for the domain he is qualifying with? or will it still try to send it to the mx?
pittstains
i'm trying a new configuration but i can think of a case where there might be a problem
say i send mail to root@mydomain.net and exim realizes, "oh, that's me. i'll just deliver this locally.:
in that case, all is well
that's what i want
but if i send an email to executive.director@mydomain.net...
exim is probably going to try to deliver that locally as well
which would be bad
henk: should the system mail name be mydomain.net, or myhost.mydomain.net?
henk
pittstains: myhost.mydomain.net imho
just like hostname -f
pittstains
ahhhhhhhh
then that should work, right?
henk
yes, imho it should
pittstains
mail to root will go to root@myhost.mydomain.net, exim will say "that's me" and deliver it locally
mail to executive.director@mydomain.net will get to exim, exim will say, "not me" and pass it to the mx
henk
exactly :)
pittstains
all of this will be followed by my running a victory lap around the building
... and sending you a virtual cupcake
henk
hrhr, i'd love to see this: a programmer doing sports mwahaha
;)
pittstains
haha, i'm playing a baseball game tonight! wood bat league. first game. exicted!
henk
oh, cool :) good luck!
pittstains
thanks!
henk
i gotta go home... later
pittstains
henk: testing new configs now and feeling confident; thanks for your help!
henk
pittstains: you're welcome :)
pittstains
henk: just to follow up, victory was achieved
the server is behaving the way i expect it to
henk
pittstains: yay, cool!
pittstains
(Action) checks off "Learn Email administration" from his checklist. :-D
henk
lol, you aren't finished yet :-p
pittstains
Perhaps not, but my immediate problem is solved. I would like to understand this side of things better when my schedule allows it.
henk
;)
« prev next »