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