The mailing list for listmasters using Sympa

[address@concealed]

Hi,

Just trying to install sympa on a RedHat 8.0 server. I will use it with
LDAP population and LDAP auth, but for the moment, the installation process

 blocked at sympa.pl start.

Indeed i follow the install docs, and have all the pre-requisites :

Your version of perl is OK (5.008  >= 5.005)
Checking for REQUIRED modules:
------------------------------------------
perl module          from CPAN       STATUS
-----------          ---------       ------
CGI                  CGI            OK (2.97   >= 2.52)
DB_File              DB_FILE        OK (1.806  >= 1.75)
Digest::MD5          Digest-MD5     OK (2.20   >= 2.00)
File::Spec           File-Spec      OK (0.83   >= 0.8)
IO::Scalar           IO-stringy     OK (2.104  >= 1.0)
MIME::Base64         MIME-Base64    OK (2.12   >= 1.0)
MIME::Tools          MIME-tools     OK (5.411  >= 5.209)
Mail::Internet       MailTools      OK (1.58   >= 1.32)
DBD::mysql           Msql-Mysql-modulesOK (2.9002 >= 2.0407)
DBI                  DBI            OK (1.37   >= 1.06)
FCGI                 FCGI           OK (0.67   >= 0.48)
Net::LDAP            perl-ldap      OK (0.29   >= 0.10)
Net::SMTP            libnet         OK (2.24   >= 1.0)
--------------------------------------------------
[root@dslesympa sympa-3.4.4.1]# rpm -qa | grep mys
mysql-3.23.52-3
mysql-devel-3.23.52-3
mysql-server-3.23.52-3
#


After installation, i use the create_db.mysql script

# mysql < create_db.mysql
and then

mysql> grant all on sympa.* to sympa@localhost identified by 'sympapwd';

Query OK, 0 rows affected (0.00 sec)


mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)




-> in my etc/sympa.conf i have the parameters :

db_type mysql

db_name sympa

db_host localhost

db_user sympa

db_passwd       sympapwd



Finally, all seems well configured, but when i lauch sympa with
/etc/init.d/sympa or via # su - sympa -c "/home/sympa/bin/sympa.pl"
i get the errors :
----
starting Sympa subsystem:
Starting module sympa.pl: DBD::mysql::db do failed: Table 'user_table'
already exists at /applis/sympa-3.4.4.1/bin/List.pm line 6507.
DBD::mysql::db do failed: Table 'subscriber_table' already exists at
/applis/sympa-3.4.4.1/bin/List.pm line 6507.

Database sympa defined in sympa.conf has not the right structure or is
unreachable. If you don't use any database, comment db_xxx parameters in
sympa.conf

                                                           [FAILED]
Starting module archived.pl: DBD::mysql::db do failed: Table 'user_table'
already exists at /applis/sympa-3.4.4.1/bin/List.pm line 6507.

DBD::mysql::db do failed: Table 'subscriber_table' already exists at
/applis/sympa-3.4.4.1/bin/List.pm line 6507.
                                                           [  OK  ]
Starting module bounced.pl: DBD::mysql::db do failed: Table 'user_table'
already exists at /applis/sympa-3.4.4.1/bin/List.pm line 6507.
DBD::mysql::db do failed: Table 'subscriber_table' already exists at
/applis/sympa-3.4.4.1/bin/List.pm line 6507.
Sympa not setup to use DBI, unable to manage bounces

                                                           [FAILED]
Starting module task_manager.pl: DBD::mysql::db do failed: Table
'user_table' already exists at /applis/sympa-3.4.4.1/bin/List.pm line 6507.
DBD::mysql::db do failed: Table 'subscriber_table' already exists at
/applis/sympa-3.4.4.1/bin/List.pm line 6507.
                                                           [  OK  ]

---

In the syslog:
---
Jul  3 19:08:30 dslesympa load: Unable to open
/applis/sympa-3.4.4.1/etc/auth.conf: Illegal seek
Jul  3 19:08:30 dslesympa No bounces directory:
/applis/sympa-3.4.4.1/bounce
Jul  3 19:08:30 dslesympa sympa[27207]: Configuration file read, default
log level  0
Jul  3 19:08:30 dslesympa sympa[27207]: Could not create table user_table
in database sympa : Table 'user_table' already exists
Jul  3 19:08:31 dslesympa sympa[27207]: Could not create table
subscriber_table in database sympa : Table 'subscriber_table' already
exists
Jul  3 19:08:31 dslesympa sympa[27207]: Table user_table not found in
database sympa
Jul  3 19:08:31 dslesympa sympa[27207]: Database sympa defined in
sympa.conf has not the right structure or is unreachable. If you don't use
any database, comment db_xxx parameters in sympa.conf
Jul  3 19:08:31 dslesympa sympa[27207]: Exiting.
Jul  3 19:08:30 dslesympa sympa:  failed
Jul  3 19:08:31 dslesympa No bounces directory:
/applis/sympa-3.4.4.1/bounce
Jul  3 19:08:31 dslesympa load: Unable to open
/applis/sympa-3.4.4.1/etc/auth.conf: No such file or directory
Jul  3 19:08:31 dslesympa No bounces directory:
/applis/sympa-3.4.4.1/bounce
Jul  3 19:08:31 dslesympa Could not create table %s in database %s :
user_table
Jul  3 19:08:31 dslesympa Could not create table %s in database %s :
subscriber_table
Jul  3 19:08:31 dslesympa root: Table user_table not found in database
sympa
Jul  3 19:08:31 dslesympa sympa:  succeeded
Jul  3 19:08:31 dslesympa archived[27215]: Unsufficient access to
/applis/sympa-3.4.4.1/arc directory
Jul  3 19:08:31 dslesympa archived[27215]: archived 0.1 Started
Jul  3 19:08:32 dslesympa No bounces directory:
/applis/sympa-3.4.4.1/bounce
Jul  3 19:08:32 dslesympa load: Unable to open
/applis/sympa-3.4.4.1/etc/auth.conf: No such file or directory
Jul  3 19:08:32 dslesympa No bounces directory:
/applis/sympa-3.4.4.1/bounce
Jul  3 19:08:32 dslesympa Could not create table %s in database %s :
user_table
Jul  3 19:08:32 dslesympa Could not create table %s in database %s :
subscriber_table
Jul  3 19:08:32 dslesympa root: Table user_table not found in database
sympa
Jul  3 19:08:32 dslesympa sympa:  failed
Jul  3 19:08:32 dslesympa No bounces directory:
/applis/sympa-3.4.4.1/bounce
Jul  3 19:08:32 dslesympa load: Unable to open
/applis/sympa-3.4.4.1/etc/auth.conf: No such file or directory
Jul  3 19:08:32 dslesympa No bounces directory:
/applis/sympa-3.4.4.1/bounce
Jul  3 19:08:32 dslesympa Could not create table %s in database %s :
user_table
Jul  3 19:08:32 dslesympa Could not create table %s in database %s :
subscriber_table
Jul  3 19:08:32 dslesympa root: Table user_table not found in database
sympa
--

Any1 could help me... i really do not know where i have make a mistake.
Is the pb comming from the perl-DBI or perl-DBD-Mysql library ?



+--------------------------------------------------------------------------+
About the DEVOTEAM GROUP
                        
Devoteam is a leading European IT Consulting Group. We help our customers
build corporate results from innovative information technology solutions.
The group recorded 2002 turnover of 136 Meuros with 1700 employees in 7
european countries (Austria, Belgium, Denmark, France, Spain, Netherlands, 
UK).
Listed on Euronext Nouveau Marche since October 28, 1999 (Euroclear 7379)
Member of Euronext Paris index: Nexteconomy, IT CAC 50, SBF 250.
Web site : http://www.devoteam.com
+--------------------------------------------------------------------------+