The mailing list for listmasters using Sympa

[Dallas Wisehaupt <address@concealed>]

Apparently, all I need to solve my problems is to send an email to this
list. It ends up that no matter where you place the LD_LIBRARY_PATH
variable and its contents, the process is not happy unless the oracle
libraries are in ld.so.conf (or it's included directories) and ldconfig
is run. It will then work if you are running under sudo or not.

Hopefully this will help someone if they search the archives in the
future.

Dallas

On Wed, 3 Sep 2008, Dallas Wisehaupt wrote:

> 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