Your message dated Wed, 17 Jun 2009 22:38:24 +0200
with message-id <[email protected]>
and subject line Problem fixed in 5.4.6-1
has caused the Debian Bug report #279404,
regarding sympa: Database problems with Pg; installation report
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
279404: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=279404
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: sympa
Version: 4.1.2-1
Severity: important
Tags: patch, sid
Hi! Thanks for the sympa upload! I think it was the right thing to do,
since the old version was really getting outdated. I haven't gotten it
running very easily though, but I hope I can provide some helpful
feedback. My system is mostly testing, but I grabbed sympa from sid to
test it.
I'm trying to get Sympa to work with a PostgreSQL database, and the
automatic configuration didn't really do it for me, so I went on to
look in the install-pg-db script.
First, I think the default config for PostgreSQL is
local all postgres ident sameuser
which means that I don't think supplying an admin password will help a
lot, but I could be wrong. I couldn't get the first section where it
creates a user by using a template1 db to work at least. I don't know
how to do this, since I also tried to su - postgres, supply an empty
password, and run the script from there, to no avail. Otherwise, I
would have thought doing it as the postgres user might be an idea.
So, I went on to create the tables by hand. I pasted in the database
schema by hand (it was a little painful too...), but when trying to
start sympa after that, it reported that some fields were
missing. Looking through List.pm (which looks imposing), there were a
hash with what looked to be fields, and I added two. Also, there
seemed to be a typo in that file. Please find attached a simple patch
to correct this. That's the main point of this bug report... :-)
I bumped into the cookie stuff reported by others too, but just
deleted the mentioned file, and after that, I can start Sympa without
errors! Yihaa! It would have been very cool if I could dump Mailman
soon.
Cheers,
Kjetil
-- System Information:
Debian Release: 3.1
APT prefers testing
APT policy: (990, 'testing')
Architecture: i386 (i686)
Kernel: Linux 2.6.8.2004-09-07.owl.1.oss
Locale: LANG=C, LC_CTYPE=C
Versions of packages sympa depends on:
ii adduser 3.59 Add and remove users and groups
ii debconf 1.4.30.8 Debian configuration management sy
ii exim [mail-transport-agent] 3.36-11 An MTA (Mail Transport Agent)
ii libc6 2.3.2.ds1-18 GNU C Library: Shared libraries an
ii libcgi-fast-perl 5.8.4-2.3 CGI::Fast Perl module
ii libcrypt-ciphersaber-perl 0.61-4 Perl module implementing CipherSab
ii libdbd-mysql-perl 2.9003-3 A Perl5 database interface to the
ii libdbi-perl 1.45-1 The Perl5 Database Interface by Ti
ii libfcgi-perl 0.67-1 FastCGI Perl module
ii libio-stringy-perl 2.109-2 Perl5 modules for IO from scalars
ii libmailtools-perl 1.62-1 Manipulate email in perl programs
ii libmd5-perl 2.03-1 backwards-compatible wrapper for D
ii libmime-perl 5.414-1 Perl5 modules for MIME-compliant m
ii libmsgcat-perl 1.03-3 Locale::Msgcat perl module
ii libnet-ldap-perl 0.3202-2 A Client interface to LDAP servers
ii mhonarc 2.6.10-1 Mail to HTML converter
ii perl [libmime-base64-perl] 5.8.4-2.3 Larry Wall's Practical Extraction
ii perl-suid 5.8.4-2.3 Runs setuid Perl scripts
ii sysklogd [system-log-daemon 1.4.1-15 System Logging Daemon
-- debconf information:
* sympa/listmaster: [email protected]
* wwsympa/webserver_restart: true
* sympa/db_options:
* sympa/db_configured: false
* sympa/db_askifpassneeded: false
* wwsympa/webserver_type: Apache
sympa/wwsympa_configured: true
* wwsympa/cookie_domain:
* sympa/language: English
sympa/db_removeonpurge: false
sympa/remove_spool: false
* sympa/hostname: owl.kjernsmo.net
* wwsympa/title: Mailing Lists Service
* sympa/db_hostname: localhost
* wwsympa/cookie_expire:
* sympa/use_db: true
* wwsympa/fastcgi: false
sympa/db_port:
* sympa/db_name: sympa
* sympa/db_type: PostgreSQL
* wwsympa/remove_spool: true
* sympa/use_wwsympa: true
* sympa/smime_support: false
===File ~/Desktop/install-pg-db.patch=======================
--- /usr/share/sympa/db/install-pg-db 2004-09-24 12:46:07.000000000 +0200
+++ install-pg-db 2004-11-02 20:48:48.000000000 +0100
@@ -53,7 +53,7 @@
eval {$dbh->do("CREATE DATABASE $database")};
# Create user sympa
-$dbh->do("DELETE FROM pg_shadow WHERE usename='sympa'");
+$dbh->do("DELETE FROM pg_shadow WHERE username='sympa'");
$dbh->do("CREATE USER sympa with password '".$userpass."' nocreateuser
nocreatedb");
@@ -73,6 +73,7 @@
"cookie_delay_user int4,".
"password_user varchar (40),".
"lang_user varchar (10),".
+ "attributes_user text,".
"CONSTRAINT ind_user PRIMARY KEY (email_user)".
")")};
@@ -88,7 +89,7 @@
"subscribed_subscriber bit(1),".
"included_subscriber bit(1),".
"include_sources_subscriber varchar(50),".
-
+ "bounce_score_subscriber smallint,".
"CONSTRAINT ind_subscriber PRIMARY KEY (list_subscriber,
user_subscriber)".
")")};
============================================================
--- End Message ---
--- Begin Message ---
-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160
Version: 5.4.6-1
The Postgres problem is believed fixed in above version, by replacing
the Debian-specific custom SQL scripts with use of dbconfig-common.
Kind regards,
- Jonas
- --
* Jonas Smedegaard - idealist og Internet-arkitekt
* Tlf.: +45 40843136 Website: http://dr.jones.dk/
[x] quote me freely [ ] ask before reusing [ ] keep private
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
iEYEAREDAAYFAko5VEAACgkQn7DbMsAkQLhklQCgkqfTw/443cnsDWcbZhARZvpC
2eoAniB9fFBUG2/HZVPKkFE6SHkDQOPs
=YfLL
-----END PGP SIGNATURE-----
--- End Message ---
