Subject: slash fails to install: DBD::mysql::db do failed: Invalid default
value for 'sid' at /usr/bin/install-slashsite line 358.
Package: slash
Version: 2.2.6-7
Severity: grave
Justification: renders package unusable
*** Please type your report below this line ***
Trying to install slash on Sid fails, probably because of using a
default value for the story id not being acceptable anymore for the
MySQL, which was installed in version 5. (Slashcode 2.x was IIRC
developed for MySQL 4.x).
Attached is a typescript of the installation and configuration phase.
-- System Information:
Debian Release: testing/unstable
APT prefers unstable
APT policy: (500, 'unstable')
Architecture: i386 (i686)
Shell: /bin/sh linked to /bin/bash
Kernel: Linux 2.4.33.2-1-dphys-k8-smp-64gb
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)
Versions of packages slash depends on:
ii apache 1.3.34-4 versatile, high-performance HTTP s
ii apache-dev 1.3.34-4 development kit for the Apache web
ii libapache-dbilogger-perl 0.93-7 Tracks what's being transferred in
ii libapache-mod-perl 1.29.0.4-4 integration of perl with the Apach
ii libapache-request-perl 1.33-1 Generic Apache Request Library
ii libcompress-zlib-perl 1.42-1 Perl module for creation and manip
ii libdate-manip-perl 5.44-3 a perl library for manipulating da
ii libdbix-password-perl 1.8-8 Perl module for creating a global
pn libdigest-md5-perl <none> (no description available)
ii libemail-valid-perl 0.176-1 Check validity of Internet email a
ii libhtml-format-perl 2.04-1 Format HTML syntax trees
ii libhtml-parser-perl 3.55-1 A collection of modules that parse
ii libimage-size-perl 3.0-1 determine the size of images in se
ii libmail-sendmail-perl 0.79-4 Send email from a perl script
ii libmailtools-perl 1.74-0.1 Manipulate email in perl programs
ii libschedule-cron-perl 0.05-5 Simple but complete cron like sche
ii libtemplate-perl 2.14-1 template processing system written
ii liburi-perl 1.35-2 Manipulates and accesses URI strin
ii libwww-perl 5.805-1 WWW client/server library for Perl
ii libxml-parser-perl 2.34-4.2 Perl module for parsing XML files
ii libxml-rss-perl 1.05-1 Perl module for managing RSS (RDF
ii mysql-client-5.0 [mysql-clien 5.0.24a-7 mysql database client binaries
ii mysql-server 5.0.24a-9 mysql database server (current ver
ii mysql-server-5.0 [mysql-serve 5.0.24a-7 mysql database server binaries
ii perl [libmime-base64-perl] 5.8.8-6.1 Larry Wall's Practical Extraction
ii perl-base [perlapi-5.8.4] 5.8.8-6.1 The Pathologically Eclectic Rubbis
ii perl-modules [libnet-perl] 5.8.8-6.1 Core Perl modules
slash recommends no packages.
-- no debconf information
Script started on Sun Oct 8 19:04:25 2006
[1m1/0/0[m [31mSID: [EMAIL PROTECTED]:pts/ttyp0 19:04:25 [/home/abe/BSP]
#[m aptitude install slash
Reading package lists... 0%
Reading package lists... 0%
Reading package lists... 15%
Reading package lists... Done
Building dependency tree... 0%
Building dependency tree... 0%
Building dependency tree... 50%
Building dependency tree... 50%
Building dependency tree... Done
Reading extended state information... 0%
Reading extended state information... 0%
Reading extended state information
Initializing package states... 0%
Initializing package states... Done
Reading task descriptions... 0%
Reading task descriptions... Done
Building tag database... 0%
Building tag database... 7%
Building tag database... Done
The following NEW packages will be automatically installed:
apache libapache-dbi-perl libapache-dbilogger-perl libapache-mod-perl
libapache-request-perl libappconfig-perl
libcompress-zlib-perl libdate-manip-perl libdbd-mysql-perl libdbi-perl
libdbix-password-perl libdevel-symdump-perl
libdigest-hmac-perl libdigest-sha1-perl libemail-valid-perl libfont-afm-perl
libhtml-format-perl libmail-sendmail-perl
libmailtools-perl libmysqlclient15off libnet-daemon-perl libnet-dns-perl
libnet-domain-tld-perl libnet-ip-perl
libplrpc-perl libschedule-cron-perl libtemplate-perl libtime-modules-perl
libxml-parser-perl libxml-rss-perl
mysql-client-5.0 mysql-common mysql-server mysql-server-5.0
The following NEW packages will be installed:
apache libapache-dbi-perl libapache-dbilogger-perl libapache-mod-perl
libapache-request-perl libappconfig-perl
libcompress-zlib-perl libdate-manip-perl libdbd-mysql-perl libdbi-perl
libdbix-password-perl libdevel-symdump-perl
libdigest-hmac-perl libdigest-sha1-perl libemail-valid-perl libfont-afm-perl
libhtml-format-perl libmail-sendmail-perl
libmailtools-perl libmysqlclient15off libnet-daemon-perl libnet-dns-perl
libnet-domain-tld-perl libnet-ip-perl
libplrpc-perl libschedule-cron-perl libtemplate-perl libtime-modules-perl
libxml-parser-perl libxml-rss-perl
mysql-client-5.0 mysql-common mysql-server mysql-server-5.0 slash
0 packages upgraded, 35 newly installed, 0 to remove and 0 not upgraded.
Need to get 0B/38.5MB of archives. After unpacking 106MB will be used.
Do you want to continue? [Y/n/?] y
Writing extended state information... 0%
Writing extended state information... 1%
Writing extended state information... Done
Extracting templates from packages: 85%
Extracting templates from packages: 100%
Preconfiguring packages ...
Selecting previously deselected package apache.
(Reading database ... 52203 files and directories currently installed.)
Unpacking apache (from .../apache_1.3.34-4_i386.deb) ...
Selecting previously deselected package libdevel-symdump-perl.
Unpacking libdevel-symdump-perl (from .../libdevel-symdump-perl_2.03-3_all.deb)
...
Selecting previously deselected package libapache-mod-perl.
Unpacking libapache-mod-perl (from .../libapache-mod-perl_1.29.0.4-4_i386.deb)
...
Selecting previously deselected package libnet-daemon-perl.
Unpacking libnet-daemon-perl (from .../libnet-daemon-perl_0.38-1.1_all.deb) ...
Selecting previously deselected package libplrpc-perl.
Unpacking libplrpc-perl (from .../libplrpc-perl_0.2017-1.1_all.deb) ...
Selecting previously deselected package libdbi-perl.
Unpacking libdbi-perl (from .../libdbi-perl_1.52-1_i386.deb) ...
Selecting previously deselected package libapache-dbi-perl.
Unpacking libapache-dbi-perl (from .../libapache-dbi-perl_0.94-2_all.deb) ...
Selecting previously deselected package libapache-dbilogger-perl.
Unpacking libapache-dbilogger-perl (from
.../libapache-dbilogger-perl_0.93-7_all.deb) ...
Selecting previously deselected package libapache-request-perl.
Unpacking libapache-request-perl (from
.../libapache-request-perl_1.33-1_i386.deb) ...
Selecting previously deselected package libappconfig-perl.
Unpacking libappconfig-perl (from .../libappconfig-perl_1.56-2_all.deb) ...
Selecting previously deselected package libcompress-zlib-perl.
Unpacking libcompress-zlib-perl (from
.../libcompress-zlib-perl_1.42-1_i386.deb) ...
Selecting previously deselected package libdate-manip-perl.
Unpacking libdate-manip-perl (from .../libdate-manip-perl_5.44-3_all.deb) ...
Selecting previously deselected package mysql-common.
Unpacking mysql-common (from .../mysql-common_5.0.24a-9_all.deb) ...
Selecting previously deselected package libmysqlclient15off.
Unpacking libmysqlclient15off (from .../libmysqlclient15off_5.0.24a-7_i386.deb)
...
Selecting previously deselected package libdbd-mysql-perl.
Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_3.0007-1_i386.deb) ...
Selecting previously deselected package libdbix-password-perl.
Unpacking libdbix-password-perl (from .../libdbix-password-perl_1.8-8_all.deb)
...
Selecting previously deselected package libdigest-sha1-perl.
Unpacking libdigest-sha1-perl (from .../libdigest-sha1-perl_2.11-1_i386.deb) ...
Selecting previously deselected package libdigest-hmac-perl.
Unpacking libdigest-hmac-perl (from .../libdigest-hmac-perl_1.01-4_all.deb) ...
Selecting previously deselected package libmailtools-perl.
Unpacking libmailtools-perl (from .../libmailtools-perl_1.74-0.1_all.deb) ...
Selecting previously deselected package libnet-ip-perl.
Unpacking libnet-ip-perl (from .../libnet-ip-perl_1.25-1_all.deb) ...
Selecting previously deselected package libnet-dns-perl.
Unpacking libnet-dns-perl (from .../libnet-dns-perl_0.59-1_i386.deb) ...
Selecting previously deselected package libnet-domain-tld-perl.
Unpacking libnet-domain-tld-perl (from
.../libnet-domain-tld-perl_1.65-2_all.deb) ...
Selecting previously deselected package libemail-valid-perl.
Unpacking libemail-valid-perl (from .../libemail-valid-perl_0.176-1_all.deb) ...
Selecting previously deselected package libfont-afm-perl.
Unpacking libfont-afm-perl (from .../libfont-afm-perl_1.19-1_all.deb) ...
Selecting previously deselected package libhtml-format-perl.
Unpacking libhtml-format-perl (from .../libhtml-format-perl_2.04-1_all.deb) ...
Selecting previously deselected package libmail-sendmail-perl.
Unpacking libmail-sendmail-perl (from .../libmail-sendmail-perl_0.79-4_all.deb)
...
Selecting previously deselected package libtime-modules-perl.
Unpacking libtime-modules-perl (from
.../libtime-modules-perl_2003.1126-2_all.deb) ...
Selecting previously deselected package libschedule-cron-perl.
Unpacking libschedule-cron-perl (from .../libschedule-cron-perl_0.05-5_all.deb)
...
Selecting previously deselected package libtemplate-perl.
Unpacking libtemplate-perl (from .../libtemplate-perl_2.14-1_i386.deb) ...
Selecting previously deselected package libxml-parser-perl.
Unpacking libxml-parser-perl (from .../libxml-parser-perl_2.34-4.2_i386.deb) ...
Selecting previously deselected package libxml-rss-perl.
Unpacking libxml-rss-perl (from .../libxml-rss-perl_1.05-1_all.deb) ...
Selecting previously deselected package mysql-client-5.0.
Unpacking mysql-client-5.0 (from .../mysql-client-5.0_5.0.24a-7_i386.deb) ...
Selecting previously deselected package mysql-server-5.0.
Unpacking mysql-server-5.0 (from .../mysql-server-5.0_5.0.24a-7_i386.deb) ...
chage: the shadow password file is not present
Selecting previously deselected package mysql-server.
Unpacking mysql-server (from .../mysql-server_5.0.24a-9_all.deb) ...
Selecting previously deselected package slash.
Unpacking slash (from .../slash_2.2.6-7_i386.deb) ...
Setting up apache (1.3.34-4) ...
Creating config file /etc/apache/httpd.conf with new version
Creating config file /etc/apache/srm.conf with new version
Creating config file /etc/apache/access.conf with new version
Creating config file /etc/apache/modules.conf with new version
Starting apache 1.3 web server....
Setting up libdevel-symdump-perl (2.03-3) ...
Setting up libapache-mod-perl (1.29.0.4-4) ...
Replacing config file /etc/apache/modules.conf with new version
Setting up libnet-daemon-perl (0.38-1.1) ...
Setting up libplrpc-perl (0.2017-1.1) ...
Setting up libdbi-perl (1.52-1) ...
Setting up libapache-dbi-perl (0.94-2) ...
Setting up libapache-dbilogger-perl (0.93-7) ...
Setting up libapache-request-perl (1.33-1) ...
Setting up libappconfig-perl (1.56-2) ...
Setting up libcompress-zlib-perl (1.42-1) ...
Setting up libdate-manip-perl (5.44-3) ...
Setting up mysql-common (5.0.24a-9) ...
Setting up libmysqlclient15off (5.0.24a-7) ...
Setting up libdbd-mysql-perl (3.0007-1) ...
Setting up libdbix-password-perl (1.8-8) ...
Setting up libdigest-sha1-perl (2.11-1) ...
Setting up libdigest-hmac-perl (1.01-4) ...
Setting up libmailtools-perl (1.74-0.1) ...
Setting up libnet-ip-perl (1.25-1) ...
Setting up libnet-dns-perl (0.59-1) ...
Setting up libnet-domain-tld-perl (1.65-2) ...
Setting up libemail-valid-perl (0.176-1) ...
Setting up libfont-afm-perl (1.19-1) ...
Setting up libhtml-format-perl (2.04-1) ...
Setting up libmail-sendmail-perl (0.79-4) ...
Setting up libtime-modules-perl (2003.1126-2) ...
Setting up libschedule-cron-perl (0.05-5) ...
Setting up libtemplate-perl (2.14-1) ...
Setting up libxml-parser-perl (2.34-4.2) ...
Setting up libxml-rss-perl (1.05-1) ...
Setting up mysql-client-5.0 (5.0.24a-7) ...
Setting up mysql-server-5.0 (5.0.24a-7) ...
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..
Setting up mysql-server (5.0.24a-9) ...
Setting up slash (2.2.6-7) ...
Before running slash code, you'll have to create a web site
on your system. I can do it for you now. If you are upgrading
from a previous version of slash, you should answer 'no' to
the next question.
Do you want me to install a slash site on your system ? [y/N] y
In order for slash to function properly we need a mysql dedicated
database. You can create it by hand or let me do it for you now.
If you already have the database created you can safely answer 'no',
of course.
Shall I create a new database now ? [Y/n] y
How do you want the slash database of your site to be called ? slashbsp
What user should be used by slash to access database slashbsp ? [root] :
We need to create a virtual user of the Slash site.
This name is used internally by slash and needn't be
a real user of the system.
Please choose a name for the virtual user: slashbsp
Searching for Apache...(No changes are being made)
Apache found at /usr/sbin/apache.
/usr/sbin/apache says your conf file is at /etc/apache/httpd.conf
In order for the slash code to function properly, we must include
the directives of slash in your actual apache config file.
Do you want me to do it for you now ? [Y/n] y
Your original apache config file /etc/apache/httpd.conf as been saved
as /etc/apache/httpd.conf.slashbkp.
Don't forget to load mod_perl module in /etc/apache/httpd.conf !
What is hostname of your Slash site
(e.g., www.slashdot.org:80)? [snitch.ethz.ch]
What user would you like to run your Slash site as? [nobody]
What group would you like to run your Slash site under? [nogroup]
OK, I am planning on user snitch.ethz.ch as the unique name
for the Slash site. If this is not ok, you need to fill in
something else here. [snitch.ethz.ch]
Which theme do you want to use?
(*)1. slashcode "Slashcode.com theme"
Skipping theme select since you only have one theme!
Theme selected: slashcode
Please select which plugins you would like ('*' marks default).
(*) 1. Admin - "Admin Interface"
( ) 2. BunchaBlocks - This is a bunch of portald blocks you can add
( ) 3. CheesyPortal - CheesyPortal is a script to get an overall look at portal
boxes
( ) 4. ForumZilla - "ForumZilla support"
(*) 5. Hof - "High score stuff"
(*) 6. Journal - "Journal system for users"
(*) 7. Messages - "Messaging system"
(*) 8. PubKey - "Just allows a user's pubkey to be displayed"
(*) 9. Search - Slash Search is the default search engine for Slash.
Hit 'a' to select all, otherwise select comma separated numbers or 'q' to quit
a
Plugins selected: Admin BunchaBlocks CheesyPortal ForumZilla Hof Journal
Messages PubKey Search
Would you like to install all the files as symlinks
to the original? (If not, each file will be copied to
your Slash directories). [Y]
Would you like to enable your slash site to display user's
pages with /~username ? [Y]
Create a name for the site's admin account (8 characters
or less). [nobody] slashbsp
Create a password for the site's admin account. ('QUIT' exits):slashbsp
What is the email address of the account? [EMAIL PROTECTED] [EMAIL PROTECTED]
DBD::mysql::db do failed: Invalid default value for 'sid' at
/usr/bin/install-slashsite line 358.
The CREATE TABLE command below failed. This almost certainly means
the rest of the slashsite installation will fail, so we're aborting.
This is probably because your SQL user associated with your
DBIx::Password user 'slashbsp' lacks CREATE and/or DROP permissions.
Fix this, or whatever the problem is, and rerun install-slashsite.
Failed command: CREATE TABLE moderatorlog ( id int UNSIGNED NOT NULL
auto_increment, uid mediumint UNSIGNED NOT NULL, val tinyint
DEFAULT '0' NOT NULL, sid mediumint UNSIGNED DEFAULT '' NOT NULL, ts
datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, cid mediumint UNSIGNED NOT
NULL, cuid mediumint UNSIGNED NOT NULL, reason tinyint UNSIGNED
DEFAULT '0', active tinyint DEFAULT '1' NOT NULL, m2count mediumint
UNSIGNED DEFAULT '0' NOT NULL, PRIMARY KEY (id), KEY sid
(sid,cid), KEY sid_2 (sid,uid,cid), KEY cid (cid)) TYPE = myisam
dpkg: error processing slash (--configure):
subprocess post-installation script returned error exit status 255
Errors were encountered while processing:
slash
E: Sub-process /usr/bin/dpkg returned an error code (1)
A package failed to install. Trying to recover:
Setting up slash (2.2.6-7) ...
Before running slash code, you'll have to create a web site
on your system. I can do it for you now. If you are upgrading
from a previous version of slash, you should answer 'no' to
the next question.
Do you want me to install a slash site on your system ? [y/N] y dpkg: error
processing slash (--configure):
subprocess post-installation script killed by signal (Interrupt)
Errors were encountered while processing:
slash
[1m2/255/0[m [31mSID: [EMAIL PROTECTED]:pts/ttyp0 19:06:24 [/home/abe/BSP]
#[m
Script done on Sun Oct 8 19:06:29 2006
