The mailing list for listmasters using Sympa

[address@concealed (Niels Hansa)]

Hi!

I have the follow trouble... I installed/compiled Sympa and the deamons 
(sympa.pl, archived.pl and bounced.pl) are running ok. Subscribing to my 
testlist (mylist ;-) ) works ok... BUT interacting with Oracle DB doesnt 
work. Sympa can obviously comunicate with the DB and exchange information, 
but the formating seems to be wrong. When subsribing a new email adress the 
"Your Sympa environemt" Mail contains NO password for wwsympa or "^@" is 
the password... i assume that means empty...

The subscribers.db.dumb also looks weared... see for yourself:
--
subscribers.db.dump:

date 964527022
email ^@n^@i^@e^@l^@s^@.^@h^@a^@n^@s^@a^@@^@d^@e^@b^@i^@s^@.^@a^@t
gecos ^@N^@i^@e^@l^@s^@ ^@H^@a^@n^@s^@a

date 964527258
email ^@r^@o^@o^@t^@@^@l^@i^@s^@t^@s^@e^@r^@v^@.^@d^@e^@b^@i^@s^@.^@a^@t

date 964527364
email ^@n^@.^@h^@a^@n^@s^@a^@@^@m^@e^@m^@b^@e^@r^@s^@.^@d^@e^@b^@i^@s^@.^@a^@t
gecos ^@N^@i^@e^@l^@s^@ ^@H^@a^@n^@s^@a
--

I used the create_db.Oracle script for DB/Table creation, but i am runnig 
Oracle version 8.0.5, NOT 7.3.4.1!

--
create_db.Oracle:

## Oracle Database creation script
## Fabien Marquois <address@concealed>

/Bases/oracle/product/7.3.4.1/bin/sqlplus loginsystem/passwdoracle <<-!
 create user SYMPA identified by SYMPA default tablespace TABLESP
temporary tablespace TEMP;
 grant create session to SYMPA;
 grant create table to SYMPA;
 grant create synonym to SYMPA;
 grant create view to SYMPA;
 grant execute any procedure to SYMPA;
 grant select any table to SYMPA;
 grant select any sequence to SYMPA;
 grant resource to SYMPA;
!

/Bases/oracle/product/7.3.4.1/bin/sqlplus SYMPA/SYMPA <<-!
CREATE TABLE user_table (
        email_user              varchar2(100) NOT NULL,
        gecos_user              varchar2(150),
        password_user           varchar2(20),
        cookie_delay_user       number,
        lang_user               varchar2(10),
        CONSTRAINT ind_user PRIMARY KEY (email_user)
);
CREATE TABLE subscriber_table (
        list_subscriber         varchar2(50) NOT NULL,
        user_subscriber         varchar2(100) NOT NULL,
        date_subscriber         date NOT NULL,
        update_subscriber       date,
        visibility_subscriber   varchar2(20),
        reception_subscriber    varchar2(20),
        bounce_subscriber       varchar2 (30),
        CONSTRAINT ind_subscriber PRIMARY KEY 
(list_subscriber,user_subscriber)
);
--

Might Oracle be the problem or ist the DBI Modul buggy.. the 
check_perl_modules.pl shows this:

--
******* Check perl for SYMPA ********

Checking for PERL version:
-----------------------------
your version of perl is OK (5.00503  >= 5.00403)

Checking for REQUIRED modules:
------------------------------------------
perl module          from CPAN       STATUS
-----------          ---------       ------
Mail::Internet       MailTools      OK (1.32   >= 1.32)
MIME::Base64         MIME-Base64    OK (2.11   >= 1.0)
IO::Scalar           IO-stringy     OK (1.119  >= 1.0)
Locale::Msgcat       Msgcat         OK (1.01   >= 1.0)
DB_File              DB_FILE        OK (1.65   >= 1.0)
MIME::Tools          MIME-Tools     OK (5.304  >= 5.209)
MD5                  MD5            OK (2.01   >= 1.0)

Checking for OPTIONAL modules:
------------------------------------------
perl module          from CPAN       STATUS
-----------          ---------       ------
FCGI                 FCGI           OK (0.52   >= 0.48)
Net::LDAP            perl-ldap      OK (0.19   >= 0.10)
CGI::Fast            CGI            CGI::Fast doesn't return 1 (check it).
DBI                  DBI            OK (1.14   >= 1.06)
******* NOTE *******
You can retrive all theses modules from any CPAN server
(for example ftp://ftp.pasteur.fr/pub/computing/CPAN/CPAN.html)
--

pls help....

Niels