The mailing list for listmasters using Sympa

["Matt Wondra" <address@concealed>]

My query (exactly as it shows in the SQL Query box) is:

select email from wonz_test

wonz_test is a Pg table with two fields, a serial id column and a varchar(20) named email.

****=> \d wonz_test

                                  Table "public.wonz_test"
 Column |         Type          |                         Modifiers
--------+-----------------------+-----------------------------------------------------------

 id     | integer               | not null default nextval('public.wonz_test_id_seq'::text)

 email  | character varying(20) |
Indexes: wonz_test_pkey primary key btree (id)

****=> select * from wonz_test ;

 id |        email
----+----------------------

  7 | address@concealed
  5 | address@concealed
  6 | 
address@concealed
(3 rows)


My only real thoughts are that maybe there's whitespace issues from the data type? Though it doesn't look it from the select * statement.

Any more ideas?

-matt

On 9/12/06, Jerome Zittoun < address@concealed> wrote:

Hi Matt,

partial good news, indeed, but good news !!

Could you give us your SQL query ? Maybe there's the famous "syntax error" !
Otherwise an issue may occur if you didn't grant enough rights on your database or on your directory/files.

Hope it helps.
Regards
Jérôme
-----Original message-----
From: "Matt Wondra" address@concealed
Date: Tue, 12 Sep 2006 11:55:19 -0400
To: "Olivier Salaün - CRU" address@concealed
Subject: Re: [sympa-users] List management from external DB

> Hi, thanks for the thoughts.
>
> I tried Jerome's suggestion, making the list public, and though it doesn't
> make me moderate messages now, it still doesn't send them through.
>
> I think I'm using version 4.1.1 (that's what it says in
> /home/sympa/bin/Version.pm) - I'm not the server admin, so I don't know whe> n
> all this stuff was installed and I'm pretty new to Sympa.
>
> I checked the log file (/var/log/sympa) and saw an enormous amount of this:
>
> Sep 12 10:50:55 office sympa[358]: (no cache) Could not tie to DB_File
> /home/sympa/expl/milife_test2/subscribers.db
> Sep 12 10:50:55 office sympa[358]: Could not load subscribers for list
> milife_test2
>
> When a message goes through I get this:
> Sep 12 10:50:55 office sympa[358]: No subscriber for sending msg in list
> milife_test2
>
>
> So I'm confused since it says "Could not load subscribers" but I can see
> them on the list in the web interface. Maybe something under the hood is
> broken?
>
> -Matt
>
> On 9/12/06, Olivier Salaün - CRU &lt;olivier.salaun@cru.fr> wrote:
> >
> > Hi Matt,
> >
> > You did not mention what version of Sympa you're running ?
> > What do Sympa log files say when the message is rejected ?
> >
> > address@concealed wrote:
> > > [...]
> > > I've been playing with this for quite some time and can't figure out
> > what's wrong. I can get the list to update from the external people DB ev> ery
> > 60 seconds like I want it to, and that works fine. If I add an email to t> he
> > DB,
> > > then check Sympa, the email appears and the list looks like it should.
> > The only problem is that when someone on the auto-generated list sends an
> > email to the list, Sympa makes it get moderated (as if that person isn't > on
> > the list). Then, when the moderator allows it through, no one on the list
> > gets the email.
> > >
> > > My sending/reception settings look fine:
> > > send => "Private, moderated for nonsubscribers"
> > > reception => "mail"
> > > visibility => "noconceal"
> > >
> >
> >
>


--
Jérôme Zittoun
Erigne Informatique / DZ2
http://www.erigne.com