The mailing list for listmasters using Sympa

[Ellie Cartman <address@concealed>]

Yep, DBD::Oracle is actually installed in every location specified in @inc and in the Oracle distribution's perl directory.
I had written a perl script to attach the database and issue a simple query as a test, all good, that works fine.
Chris Peck suggested that adding /etc/ld.so.conf.d/oracle.conf containing the path to the installed Oracle 12 lib. That has cleared up the systemd issue. Still have some weirdness with other elements in the sympa.service unit file, but I am making progress ;)

thanx,
-ellie


On 18-10-31 05:00 PM, Steve Shipway wrote:

Are you sure that you have installed DBD::Oracle in your site_perl path (probably under /usr/lib/perl5 or similar)?  Possibly, you installed it for an individual user or locally in a library location that is not visible to the Sympa process when started as a service.  In this case, running a test from the commandline would work, but the service would not.  Some installations from source will default to a local per-user location unless run as root and told to install in the site library.

Steve

On Tue, 2018-10-30 at 16:58 -0400, Ellie Cartman wrote:

Running Sympa 6.2.35b.1 on CentOS 7.5
...
Sympa::DatabaseDriver::Oracle::connect#78 > Sympa::Database::connect#130
A module for Sympa::DatabaseDriver::Oracle is not installed. You should
download and install DBD::Oracle
...
sympa_wizard.pl --check reports
DBD::Oracle                     OK (1.74   >= 1.02)

--
Steve Shipway | Senior Email Systems Administrator  Phone: +64 9 302 0515 Fax: +64 9 302 0518  Freephone: 0800 SMX SMX (769 769)  SMX Limited: Level 10, 19 Victoria Street West, Auckland, New Zealand  Web: http://smxemail.com 

This email has been filtered by SMX. For more information visit smxemail.com.