The mailing list for listmasters using Sympa

[Dallas Wisehaupt <address@concealed>]

We are running our sympa instance with a mysql backend and are looking
to include membership for lists based on queries against Oracle tables
backing our ERP system. However, whenever I try to do a SQL include, it
fails with the error:
    Sep  3 09:19:01 devon wwsympa[23856]: No Database Driver installed for 
Oracle ; you should download and install DBD::Oracle from CPAN
    Sep  3 09:19:02 devon wwsympa[23856]: Inclusion include_sql_query failed 
in list test_sql_query

I initially was running sympa via sudo and suspected that the
environment variables were being cleared so that it couldn't find the
client software. So I adjusted so that apache was running as the sympa
user, but still go the same error.

Further searching showed a possible need to include the oracle environment
variables explicitly before the DBI load is done. So, I tested putting
them in the db_env segment, and even went so far as to include them
directly in List.pm in a BEGIN block. None of this has provided a
successful change in behavior.

Has anyone else seen this or found a solution?

Thanks.

Dallas
--
Dallas Wisehaupt                            Senior Systems Administrator
address@concealed               The University of Scranton