The mailing list for listmasters using Sympa

[Dallas Wisehaupt <address@concealed>]

We are just starting to test Sympa at The University of Scranton. We
have done the basic install of version 5.2.3 and will be working off of
an Oracle database. We have established the database user and tables and
are ready for the first startup. All was looking good until we
encountered this error on startup:

Dec 12 17:06:02 devon Conf: :_load_auth(/home/sympa/bin/etc/auth.conf)
Dec 12 17:06:02 devon sympa[17848]: Configuration file read, default log 
level  4
Dec 12 17:06:02 devon sympa[17848]: No Database Driver installed for Oracle ; 
you should download and install DBD::Oracle from CPAN
Dec 12 17:06:02 devon sympa[17848]: Sympa not setup to use DBI

We do have the config set to use Oracle. Here is the excerpt of the
sympa.conf:

## Database type (mysql | Pg | Oracle | Sybase | SQLite)
## be carefull to the case
db_type Oracle

## Name of the database
## with SQLite, the name of the DB corresponds to the DB file
# was db_name sympa
db_name ORACLE_SID

## The host hosting your sympa database
db_host dbhost.scranton.edu

## Database user for connexion
db_user sympa

## Database password (associated to the db_user)
db_passwd   DBUSER_PASSWORD

It appears that the code is getting caught at line 1289 of List.pm:

1289     ## Check if DBD is installed
1290      unless (eval "require DBD::$Conf{'db_type'}") {
1291         do_log('err',"No Database Driver installed for $Conf{'db_type'} ; you 
should download and install DBD::$Conf{'db_type'} from CPAN");
1292         &send_notify_to_listmaster('missing_dbd', 
$Conf{'domain'},{'db_type' => $Conf{'db_type'}});
1293         return undef;
1294     }

So, it doesn't think that we have DBD::Oracle installed. However, we do,
and we can verify that is installed and we can connect to the database
as the sympa user. Here you will see the sympa user connecting to the
database with the proper SID, and with a bogus SID. The proper one
succeeds while the bogus fails on the SID:

"""
[sympa@devon ~]$ /usr/bin/perl
require DBI;
require DBD::Oracle;
my $dbsid = "ORACLE_SID";
my $dbhost = "dbhost.scranton.edu";
my $dbuser = "sympa";
my $dbpass = "DBUSER_PASSWORD";
my $dbh = DBI->connect("dbi:Oracle:sid=$dbsid;host=$dbhost", $dbuser, $dbpass) || die 
"Unale to connect to $dbname: $DBI::errstr\n";
(control-d)
[sympa@devon ~]$ /usr/bin/perl
require DBI;
require DBD::Oracle;
my $dbsid = "BOGUS_ORACLE_SID";
my $dbhost = "dbhost.scranton.edu";
my $dbuser = "sympa";
my $dbpass = "DBUSER_PASSWORD";
my $dbh = DBI->connect("dbi:Oracle:sid=$dbsid;host=$dbhost", $dbuser, $dbpass) || die 
"Unale to connect to $dbname: $DBI::errstr\n";
(control-d)
DBI connect('sid=BOGUS_ORACLE_SID;host=dbhost.scranton.edu','sympa',...) 
failed: ORA-12505: TNS:listener does not currently know of SID given in 
connect descriptor (DBD ERROR: OCIServerAttach) at - line 7
Unale to connect to : ORA-12505: TNS:listener does not currently know of SID 
given in connect descriptor (DBD ERROR: OCIServerAttach)
[sympa@devon ~]$
"""

Has anyone seen this behavior before? It seems odd that it would error
out on this perl module that is obviously available. I have even checked
to see if the scripts are using a different perl, but they are all
referencing /usr/bin/perl.

Thanks for any pointers.

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