The mailing list for listmasters using Sympa

[Olivier Salaün - CRU <address@concealed>]

Hi Dirk,

You did everything right except that the 'db_port' is not available in a 
include_sql_query parameter. You might be the first who asked for it...

I've just added the feature in our CVS tree ; it would be great if you 
could try applying the patch on your server. here is the patch :
http://sourcesup.cru.fr/cgi/viewcvs.cgi/sympa/src/List.pm?r1=1.585&r2=1.586&makepatch=1&diff_format=u

To apply the patch, save it to a file and then : cd sympa-xx/src;patch 
-p0 < /tmp/the_patch ; cd .. ; make ; make install

Let us know if any problem occurs.

address@concealed wrote:

> I am trying to include e-mail addresses dynamically from an SQL-query.
>
> Unfortunatly this does not work, so I am asking myself and you,
> what is wrong with my config?
>
> The part from .../expl/LISTNAME/config:
>
> user_data_source include2
>
> include_sql_query
> db_name the_oracle_sid
> name test1
> host the-oracle-server.desy.de
> passwd very_secret
> connect_options options
> db_type oracle
> db_port 1527
> user auser
> db_env ORACLE_HOME=/opt/products/oracle-client/9.2.0
> sql_query select email from t_emails
>
> Is "user_data_source include2" correct for SQL queries?
> (BTW: include did not work either)
>
> How can I specify the port of the TNS listener, as the
> database instance I try to connect does not listen on 1521?
> I configured db_port manually in the config file (like in sympa.conf) and
> archived.pl complains that this parameter is unknown to it.
> BTW: all other data is stored in the same Oracle instance and
> that works fine
>
> What is the meaning of "connection_options"? A search at
> www.sympa.org does not find any document describing
> this parameter.
>

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature