Skip to Content.
Sympa Menu

devel - Re: [sympa-dev] Sympa 2.7.3: Digest not working with SQL query

Subject: Developers of Sympa

List archive

Chronological Thread  
  • From: Richard Balint <address@concealed>
  • To: address@concealed
  • Subject: Re: [sympa-dev] Sympa 2.7.3: Digest not working with SQL query
  • Date: Thu, 14 Sep 2000 07:42:44 -0400 (EDT)

On Thu, 14 Sep 2000, Olivier Salaun wrote:

> Richard Balint wrote:
> >
> > I had a problem with our old 2.6.x sympa not digesting to a list where the
> > only recipients are in a "include_sql_query"
>
> You can't define reception mode (digest | nomail | summary) on included
> subscribers. We plan to do it on next release via the
> "default_user_options"
> param.

That is what I did...

default_user_options
reception digest

> > So, on a test machine, I finally upgraded to the latest and greatest,
> > 2.7.3. :)
> >
> > Things are a LITTLE better. It will now wait until the digest time and
> > then proceed to send each message individually. Blah! The whole point of
> > the digest is to make ONE e-mail, right? Not just save all the messages
> > for later. ;)
>
> Sorry, I don't understand what the problem is.
> When you define a "digest" parameter for a list, users may then set
> their
> reception mode to "digest", unless they are users are included from an
> external data source (which seems to be your situation).
> If the list has a "digest" mode, every message is kept in
> spool/digest/<listnamse>
> file and then sent, as a digest, when time has come.

Yes.. I saw all 4 messages in the spool/digest/list file.
Yet at the time it sent out the digest, it sent _4_ messages out to the
listmembers, not _1_.

> > At the University of Dayton, we have a few very LARGE lists pulling from a
> > SQL query... and sending to 10,000 users, 4-10 times a day is really
> > straining our server. Poor little dual PIII box! =grin=
>
> What is your MTA ? Postfix is supposed to be quite good.
> Did you tune the maxsmtp, avg and nrcpt params in sympa.conf.

Sendmail. I'll try tweaking those paramaters, but the problem is that
our Lotus Notes machine is accepting mail slowly (not MY fault. ;), and
when sending out to 6000+ people on that system, just backlogs EVERYTHING.
By minimizing the mailings, this problem should get much better. :)

-----
Richard Balint University of Dayton address@concealed
(937) 229-3888 ACTS/MNS Network Specialist

-----
We are lagging too far behind
In our desire to race ahead of ourselves
And everybody else in this phantom race.
Information kills the mind; Internet is the new Boob-Tube




Archive powered by MHonArc 2.6.19+.

Top of Page