Skip to Content.
Sympa Menu

en - [sympa-users] sqlite problem

Subject: The mailing list for listmasters using Sympa

List archive

Chronological Thread  
  • From: Dax Kelson <address@concealed>
  • To: address@concealed
  • Subject: [sympa-users] sqlite problem
  • Date: Fri, 01 Sep 2006 14:47:40 -0600

I have a SUSE Enterprise Linux 10 box (AMD64) that I'm configuring as a
mail and mailling list server with Sympa.

2.6.16.21-0.15-smp x86_64
perl-5.8.8-14.2
perl-DBD-SQLite-1.11-14.2
sqlite-3.2.8-15.2

My config:

db_type SQLite
db_name /home/sympa/db/sympa

When I start sympa, it creates the db fine, but when I stop and then
restart it (using the sysv init script) I get the following:

========================================
/etc/init.d/sympa start
Starting Sympa subsystem:
Starting module sympa.pl: DBD::SQLite::db do failed: near "CHANGE":
syntax error(1) at dbdimp.c line 269 at /home/sympa/bin/List.pm line
10947.
Database /home/sympa/db/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
failure
Starting module archived.pl: success
Starting module bounced.pl: success
Starting module task_manager.pl: success
========================================

The ownership, permission are fine on the db and the parent directories:
ls -al /home/sympa/db/sympa
-rw-r--r-- 1 sympa sympa 16384 2006-08-31 14:00 /home/sympa/db/sympa

If I delete the file, then Sympa creates it new OK on startup. I just
can stop and start it.

Here is what strace shows:

5489 stat("/home/sympa/db", {st_mode=S_IFDIR|0755, st_size=72, ...}) = 0
5490 open("/home/sympa/db/sympa", O_RDWR|O_CREAT, 0644) = 4
5490 access("/home/sympa/db/sympa-journal", F_OK) = -1 ENOENT (No such file
or directory)
5490 access("/home/sympa/db/sympa-journal", F_OK) = -1 ENOENT (No such file
or directory)
5490 write(2, "Database /home/sympa/db/sympa de"..., 170) = 170
5495 open("/home/sympa/db/sympa", O_RDWR|O_CREAT, 0644) = 3
5500 open("/home/sympa/db/sympa", O_RDWR|O_CREAT, 0644) = 3
5504 open("/home/sympa/db/sympa", O_RDWR|O_CREAT, 0644) = 3

Help?
Dax Kelson




Archive powered by MHonArc 2.6.19+.

Top of Page