The mailing list for listmasters using Sympa

[Chris Hastie <address@concealed>]

Hi

I should start by confessing that I'm still using version 4.1!

I need to integrate a sympa list with another web application and wonder what
the best (aka least work) way to do this is.

I had hoped to simply include subscription details from the other apps user 
db,
which is MySQL. I also aimed to allow signing in to the other app to give
access to the sympa archives for the list. On the face of it, it all seemed
straightforward. Until I actually tried to do it.

I have the other app setting a 'sympauser' cookie with out to much difficulty 
(I
don't seem to be able to delete it on log out though - seems connected to 
sympa
and the other app being on different subdomains).

I planned to use an include2 and include_sql_query, which I have successfully
done elsewhere.

The first big problem is that users who are included don't seem to have access
to the archives. Indeed, wwwsympa complains they are not subscribed to
anything. Is this something that I can change with a scenario?

Second issue is that I need to be able to set the reception mode in the other
apps db, and have this seen by sympa. As far as I can see, the query returned
by include_sql_query must contain email addresses only. Is there any way to 
get
sympa to use a remote db to populate the reception_subscriber field in the
subscriber_table? I was hoping that by ensuring my query returned fields with
names sympa recongnised, it would use that data, but that doesn't appear to be
the case.

Any pointers?

Thanks

-- 
Chris Hastie