The mailing list for listmasters using Sympa

[Dirk Jahnke-Zumbusch <address@concealed>]

Hola, José,

> It works well connecting with sqlplus, but it fails when start Sympa:

Did the DBD::Oracle build succeed? It looks like your PERL does not
find that module in the first place:

> May 11 08:50:50 montenegro1 sympa[24596]: Configuration file read, 
> default log level  0
> May 11 08:50:50 montenegro1 sympa[24596]: No Database Driver installed 
> for Oracle ; you should download and install DBD::Oracle from CPAN
> May 11 08:50:50 montenegro1 sympa[24596]: Sympa not setup to use DBI

SYMPA does not work with tnsnames.ora. Just to make sure, your
Oracle connection works you should set

db_type Oracle
db_host 150.214.156.15
db_name ualdes
db_env -as you defined it- (you may leave out ORACLE_TERM)

As far as I remember
1) instanclient needs some extra attention compiling DBD::Oracle, check 
README.linux
2) I am quite sure instanclient cannot use tnsnames.ora at all; I use 
the full client, as it supports our RAC database (fail over etc.)

To use SYMPA with tnsnames.ora and Oracle full client, see
<http://sourcesup.cru.fr/tracker/index.php?func=detail&aid=1167&group_id=23&atid=170>
for the two minor modifications to SYMPA code in List.pm
All inclusions will still work. Setting the host to tnsnames.ora
and the db_name to an Oracle service turns on tnsnames.ora entries.

Best regards

--
Dirk Jahnke-Zumbusch              Deutsches Elektronen-Synchrotron DESY
IT Information Fabrics              Member of the Helmholtz Association
D-22603 Hamburg                        Notkestrasse 85  / 22607 Hamburg
T: +49-40-899.81760   F: +49-40-899.41760  address@concealed