Thread: Mirror reports getting lost
Hi Marc, Dunno if you can shed some light on this - every night, a script runs on svr2 to check the mirrors and update their last sync timestamp in the mirrors database. A report generated by this script is sent to pgsql-slavestothewww@postgresql.org. Whilst I have occasionally received this, the vast majority of the time it simply vanishes - it doesn't even end up in the moderation queue. At one time I was getting errors because it was too big, but I've since tweaked the maximum size for that list. Any ideas? Could it be getting clobbered by your spam filters? /D
On Thu, 24 Feb 2005, Dave Page wrote: > Hi Marc, > > Dunno if you can shed some light on this - every night, a script runs on > svr2 to check the mirrors and update their last sync timestamp in the > mirrors database. A report generated by this script is sent to > pgsql-slavestothewww@postgresql.org. Whilst I have occasionally received > this, the vast majority of the time it simply vanishes - it doesn't even > end up in the moderation queue. At one time I was getting errors because > it was too big, but I've since tweaked the maximum size for that list. > > Any ideas? Could it be getting clobbered by your spam filters? Not by the spam filters, but maybe by the duplicate checking within Majordomo2 itself ... if nothing else, try adding a 'date' to the Subject line, which should get it to bypass even those ... ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664
> -----Original Message----- > From: Marc G. Fournier [mailto:scrappy@postgresql.org] > Sent: 24 February 2005 15:52 > To: Dave Page > Cc: pgsql-www@postgresql.org > Subject: Re: Mirror reports getting lost > > Not by the spam filters, but maybe by the duplicate checking within > Majordomo2 itself ... if nothing else, try adding a 'date' > to the Subject > line, which should get it to bypass even those ... OK - does it look at the time the dups are sent? I forgot to mention that when run from the command line it normally works. It fails from cron... Still, I've added the date to the subject, and run it again manually (which worked) - will see if it works tonight. Thanks, Dave.
> -----Original Message----- > From: pgsql-www-owner@postgresql.org > [mailto:pgsql-www-owner@postgresql.org] On Behalf Of Dave Page > Sent: 24 February 2005 16:31 > To: Marc G. Fournier > Cc: pgsql-www@postgresql.org > Subject: Re: [pgsql-www] Mirror reports getting lost > > > > Still, I've added the date to the subject, and run it again manually > (which worked) - will see if it works tonight. Nope, I don't see one from last night - did you Magnus? Not sure if this is a cron thing, or a timing/dup issue. Regards, Dave.
> > Still, I've added the date to the subject, and run it again > manually > > (which worked) - will see if it works tonight. > > Nope, I don't see one from last night - did you Magnus? Nope, nothing here. > Not sure if this is a cron thing, or a timing/dup issue. Does it write a log either to a file or to the database? If not, perhaps it should - then you could see if it's an actual cron issue, or if it's just the report that goes missing. //mha
On Fri, 25 Feb 2005, Dave Page wrote: > > >> -----Original Message----- >> From: pgsql-www-owner@postgresql.org >> [mailto:pgsql-www-owner@postgresql.org] On Behalf Of Dave Page >> Sent: 24 February 2005 16:31 >> To: Marc G. Fournier >> Cc: pgsql-www@postgresql.org >> Subject: Re: [pgsql-www] Mirror reports getting lost >> >> >> >> Still, I've added the date to the subject, and run it again manually >> (which worked) - will see if it works tonight. > > Nope, I don't see one from last night - did you Magnus? > > Not sure if this is a cron thing, or a timing/dup issue. Without knowing what the script looks like, just guesses here ... but, if it works from the command line and not cron, could it be a PATH issue? are you putting in absolute paths fro commands you are using, if any? My experience, for instsance, is that stuff in /usr/local/bin *won't* be found by a cron job, so I just got into the habit of making sure I use absolute paths everywhere .... The other question, kind of along the same lines as Magnus in his response ... why not have th emessage sent to both the list and you, so that you can confirm that the mail is even being sent? ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664
> -----Original Message----- > From: Magnus Hagander [mailto:mha@sollentuna.net] > Sent: 25 February 2005 12:34 > To: Dave Page; Marc G. Fournier > Cc: pgsql-www@postgresql.org > Subject: RE: [pgsql-www] Mirror reports getting lost > > Does it write a log either to a file or to the database? If > not, perhaps > it should - then you could see if it's an actual cron issue, > or if it's > just the report that goes missing. No, although it could quite easily. It's definitely running though, otherwise there would be no mirrors listed! /D
> -----Original Message----- > From: Marc G. Fournier [mailto:scrappy@postgresql.org] > Sent: 25 February 2005 14:46 > To: Dave Page > Cc: mha@sollentuna.net; pgsql-www@postgresql.org > Subject: RE: [pgsql-www] Mirror reports getting lost > > Without knowing what the script looks like, just guesses here > ... but, if > it works from the command line and not cron, could it be a > PATH issue? > are you putting in absolute paths fro commands you are using, > if any? My > experience, for instsance, is that stuff in /usr/local/bin *won't* be > found by a cron job, so I just got into the habit of making > sure I use > absolute paths everywhere .... It's all php code, so there are definitely no path issues. It's certainly running, otherwise the mirrors would have all expired. > The other question, kind of along the same lines as Magnus in > his response > ... why not have th emessage sent to both the list and you, > so that you > can confirm that the mail is even being sent? When I was testing it I directed it to me and it worked every time. I'll add a copy to me as well though. /D
On Fri, 25 Feb 2005, Dave Page wrote: > > >> -----Original Message----- >> From: Marc G. Fournier [mailto:scrappy@postgresql.org] >> Sent: 25 February 2005 14:46 >> To: Dave Page >> Cc: mha@sollentuna.net; pgsql-www@postgresql.org >> Subject: RE: [pgsql-www] Mirror reports getting lost >> >> Without knowing what the script looks like, just guesses here >> ... but, if >> it works from the command line and not cron, could it be a >> PATH issue? >> are you putting in absolute paths fro commands you are using, >> if any? My >> experience, for instsance, is that stuff in /usr/local/bin *won't* be >> found by a cron job, so I just got into the habit of making >> sure I use >> absolute paths everywhere .... > > It's all php code, so there are definitely no path issues. It's > certainly running, otherwise the mirrors would have all expired. > >> The other question, kind of along the same lines as Magnus in >> his response >> ... why not have th emessage sent to both the list and you, >> so that you >> can confirm that the mail is even being sent? > > When I was testing it I directed it to me and it worked every time. I'll > add a copy to me as well though. Any errors in the maillog itself? any indications that as far as the logs are concerned, the message *was* sent? ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664
> -----Original Message----- > From: Marc G. Fournier [mailto:scrappy@postgresql.org] > Sent: 25 February 2005 21:43 > To: Dave Page > Cc: mha@sollentuna.net; pgsql-www@postgresql.org > Subject: RE: [pgsql-www] Mirror reports getting lost > > Any errors in the maillog itself? any indications that as > far as the logs > are concerned, the message *was* sent? Nothing there that's obviously the message :-( /D
> -----Original Message----- > From: pgsql-www-owner@postgresql.org > [mailto:pgsql-www-owner@postgresql.org] On Behalf Of Dave Page > Sent: 25 February 2005 21:55 > To: Marc G. Fournier > Cc: mha@sollentuna.net; pgsql-www@postgresql.org > Subject: Re: [pgsql-www] Mirror reports getting lost > > > > > -----Original Message----- > > From: Marc G. Fournier [mailto:scrappy@postgresql.org] > > Sent: 25 February 2005 21:43 > > To: Dave Page > > Cc: mha@sollentuna.net; pgsql-www@postgresql.org > > Subject: RE: [pgsql-www] Mirror reports getting lost > > > > Any errors in the maillog itself? any indications that as > > far as the logs > > are concerned, the message *was* sent? > > Nothing there that's obviously the message :-( Today however - my copy arrived without any problems, however I didn't see it on the list. Svr2 has the following: Feb 26 03:20:03 svr2 postfix/pickup[21049]: 40F38F0B10: uid=0 from=<root> Feb 26 03:20:03 svr2 postfix/cleanup[21384]: 40F38F0B10: message-id=<20050226032003.40F38F0B10@svr2.postgresql.org> Feb 26 03:20:03 svr2 postfix/qmgr[369]: 40F38F0B10: from=<root@svr2.postgresql.org>, size=24329, nrcpt=3 (queue active) Feb 26 03:20:05 svr2 postfix/smtp[21379]: 40F38F0B10: to=<pgsql-slavestothewww@postgresql.org>, relay=svr1.postgresql.org[200.46.204.71], delay=2, status=sent (250 Ok: queued as EAB9A52D45) Feb 26 03:20:06 svr2 postfix/smtp[21399]: 40F38F0B10: to=<mha@sollentuna.net>, relay=mx-1.sollentuna.net[62.65.68.9], delay=3, status=sent (250 Ok: queued as 24EC61FD06A) Feb 26 03:20:06 svr2 postfix/smtp[21400]: 40F38F0B10: to=<dpage@vale-housing.co.uk>, relay=mailgate.vale-housing.co.uk[194.217.48.34], delay=3, status=sent (250 2.0.0 j1Q3MilQ013525 Message accepted for delivery) Feb 26 03:20:06 svr2 postfix/qmgr[369]: 40F38F0B10: removed Then on svr1: Feb 26 03:22:15 svr1 postfix/smtpd[49080]: EAB9A52D45: client=unknown[65.19.161.25] Feb 26 03:22:16 svr1 postfix/cleanup[50051]: EAB9A52D45: message-id=<20050226032003.40F38F0B10@svr2.postgresql.org> Feb 26 03:22:16 svr1 postfix/qmgr[18643]: EAB9A52D45: from=<root@svr2.postgresql.org>, size=24533, nrcpt=1 (queue active) Feb 26 03:22:19 svr1 postfix/smtp[49544]: EAB9A52D45: to=<pgsql-slavestothewww-postgresql.org@localhost.postgresql.org>, orig_to=<pgsql-slavestothewww@postgresql.org>, relay=av.hub.org[200.46.204.144], delay=4, status=sent (250 2.6.0 Ok, id=65935-07, from MTA: 250 Ok: queued as EE7EA56112) Feb 26 03:22:19 svr1 postfix/qmgr[18643]: EAB9A52D45: removed I have no access to av.hub.org, so can you check there please Marc? Regards, Dave.