Package: sympa Version: 6.1.1~dfsg-2 When creating the initial database during the installation process gives an error on SQL.
In attach is a patch to the problem and the list of installed dependencies. I'm using Debian squeeze/sid, Kernel 2.6.32-5-amd64. Best regards, Luís Sousa
>From 5db5d051c2d2d8b71d319fca3b9e901fd0125925 Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Lu=C3=ADs=20Sousa?= <llso...@ualg.pt> Date: Tue, 23 Nov 2010 12:15:32 +0000 Subject: [PATCH] Fixed error creating mysql database --- src/etc/script/create_db.mysql | 6 +++--- 1 files changed, 3 insertions(+), 3 deletions(-) diff --git a/src/etc/script/create_db.mysql b/src/etc/script/create_db.mysql index 9c7323d..3a3a846 100644 --- a/src/etc/script/create_db.mysql +++ b/src/etc/script/create_db.mysql @@ -139,8 +139,8 @@ CREATE TABLE bulkmailer_table ( CREATE TABLE `bulkspool_table` ( - `messagekey_bulkspool` varchar(33) NOT NULL COMMENT 'An internal id of the message in order to join this table with bulkmailer_table' - `messageid_bulkspool` varchar(100) NOT NULL COMMENT 'The value of the `Message-ID` SMTP field for this message' + `messagekey_bulkspool` varchar(33) NOT NULL COMMENT 'An internal id of the message in order to join this table with bulkmailer_table', + `messageid_bulkspool` varchar(100) NOT NULL COMMENT 'The value of the `Message-ID` SMTP field for this message', `message_bulkspool` longtext COMMENT 'The message itself as a string. The database MUST be tuned in order to accept big data blog for storing messages with attachments', `lock_bulkspool` int(1) default NULL COMMENT 'lock used by parallele bulk demon ni order to prevent a message to be distribited twice', `dkim_privatekey_bulkspool` varchar(100) default NULL COMMENT 'The DKIM private key value.', @@ -149,7 +149,7 @@ CREATE TABLE `bulkspool_table` ( `dkim_d_bulkspool` varchar(50) default NULL COMMENT 'The DKIM signature "d=" tag', `dkim_header_list_bulkspool` varchar(500) default NULL COMMENT 'The list of header part of the signed datas', PRIMARY KEY (`messagekey_bulkspool`) -) +); CREATE TABLE conf_table ( -- 1.7.2.3
Desired=Unknown/Install/Remove/Purge/Hold | Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend |/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad) ||/ Name Version Description +++-===================================-===========================-========================================================================== ii adduser 3.112 add and remove users and groups ii apache2-mpm-prefork 2.2.16-4 Apache HTTP Server - traditional non-threaded model ii ca-certificates 20090814+nmu2 Common CA certificates ii dbconfig-common 1.8.46 common framework for packaging database applications ii debconf 1.5.36 Debian configuration management system ii doc-base 0.9.5 utilities to manage online documentation ii libapache2-mod-fastcgi 2.4.7~0910052141-1 Apache 2 FastCGI module for long-running CGI scripts ii libarchive-zip-perl 1.30-3 Perl module for manipulation of ZIP archives ii libc6 2.11.2-7 Embedded GNU C Library: Shared libraries ii libcgi-fast-perl 5.10.1-16 CGI::Fast Perl module ii libcrypt-ciphersaber-perl 0.61-4 Perl module implementing CipherSaber encryption ii libdbi-perl 1.612-1 Perl Database Interface (DBI) ii libfcgi-perl 0.71-1 helper module for FastCGI ii libfile-copy-recursive-perl 0.38-1 Perl extension for recursively copying files and directories ii libfile-nfslock-perl 1.20-2 perl module to do NFS (or not) locking ii libhtml-format-perl 2.04-2 format HTML syntax trees into text, PostScript or RTF ii libhtml-stripscripts-parser-perl 1.03-1 module to filter scripts out of HTML ii libhtml-tree-perl 3.23-2 Perl module to represent and create HTML syntax trees ii libintl-perl 1.20-1 Uniforum message translations system compatible i18n library ii libio-socket-ssl-perl 1.34-1 Perl module implementing object oriented interface to SSL sockets ii libio-stringy-perl 2.110-4 Perl modules for IO from scalars and arrays ii libmail-dkim-perl 0.38-1 cryptographically identify the sender of email - perl library ii libmailtools-perl 2.06-1 Manipulate email in perl programs ii libmime-charset-perl 1.008-1 Perl module for MIME character set information ii libmime-encwords-perl 1.012-1 Perl interface to deal with RFC 2047 encoded words ii libmime-lite-html-perl 1.23-1 Transform HTML page into MIME email ii libmime-tools-perl 5.428-1 Perl5 modules for MIME-compliant messages ii libmsgcat-perl 1.03-5 Locale::Msgcat perl module ii libnet-ldap-perl 1:0.4001-2 client interface to LDAP servers ii libnet-netmask-perl 1.9015-4 parse, manipulate and lookup IP network blocks ii libregexp-common-perl 2010010201-1 module with common regular expressions ii libsoap-lite-perl 0.712-2 Perl implementation of a SOAP client and server ii libtemplate-perl 2.22-0.1 template processing system written in perl ii libterm-progressbar-perl 2.09-6 Perl module to print a progress bar ii libxml-libxml-perl 1.70.ds-1 Perl interface to the libxml2 library ii logrotate 3.7.8-6 Log rotation utility ii lsb-base 3.2-23.1 Linux Standard Base 3.2 init script functionality ii mhonarc 2.6.16-1 Mail to HTML converter ii mysql-server-5.1 5.1.49-2 MySQL database server binaries and system database setup ii openssl 0.9.8o-3 Secure Socket Layer (SSL) binary and related cryptographic tools ii perl 5.10.1-16 Larry Wall's Practical Extraction and Report Language ii postfix 2.7.1-1 High-performance mail transport agent ii rsyslog 4.6.4-1 enhanced multi-threaded syslogd
