Your message dated Thu, 10 Nov 2005 16:32:07 -0800 with message-id <E1EaMpr-0006ft-TX@spohr.debian.org> and subject line Bug#312230: fixed in drupal 4.5.5-3 has caused the attached Bug 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 I am talking about this indicates a serious mail system misconfiguration somewhere. Please contact me immediately.) Debian bug tracking system administrator (administrator, Debian Bugs database) -------------------------------------- Received: (at submit) by bugs.debian.org; 12 Oct 2005 00:43:45 +0000
From matt@matt-land.com Tue Oct 11 17:43:45 2005 Return-path: <matt@matt-land.com> Received: from matt-land.com [69.90.72.83] (Debian-exim) by spohr.debian.org with esmtp (Exim 3.36 1 (Debian)) id 1EPUif-0007Sh-00; Tue, 11 Oct 2005 17:43:45 -0700 Received: from matthew by matt-land.com with local (Exim 4.54) id 1EPUic-00050E-LB; Tue, 11 Oct 2005 19:43:42 -0500 Content-Type: multipart/mixed; boundary="===============1960338997==" MIME-Version: 1.0 From: "Matthew A. Nicholson" <matt@matt-land.com> To: Debian Bug Tracking System <submit@bugs.debian.org> Subject: drupal: Drupal postgres fixes (including uid stuff) X-Mailer: reportbug 3.17 Date: Tue, 11 Oct 2005 19:43:42 -0500 Message-Id: <E1EPUic-00050E-LB@matt-land.com> Delivered-To: submit@bugs.debian.org X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02 (1.212-2003-09-23-exp) on spohr.debian.org X-Spam-Level: X-Spam-Status: No, hits=-8.0 required=4.0 tests=BAYES_00,HAS_PACKAGE autolearn=no version=2.60-bugs.debian.org_2005_01_02
This is a multi-part MIME message sent by reportbug. --===============1960338997== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline Package: drupal Version: 4.5.5-2 Severity: important Tags: patch The attached patch fixes a bug with the "if" postgresql function that prevents the fourms modules from operating correctly, it fixes the missing uid stuff defined in #312230 and #312202, and it fixes a bug that prevents user logging out found in session.inc. -- 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.31-1um Locale: LANG=en_US, LC_CTYPE=en_US (charmap=ISO-8859-1) Versions of packages drupal depends on: ii apache2-mpm-prefork [apache2] 2.0.54-5 traditional model for Apache2 ii debconf [debconf-2.0] 1.4.58 Debian configuration management sy ii exim4 4.54-1 metapackage to ease exim MTA (v4) ii exim4-daemon-light [mail-tran 4.54-1 lightweight exim MTA (v4) daemon ii makepasswd 1.10-3 Generate and encrypt passwords ii mysql-client 4.1.14-6 mysql database client (transitiona ii mysql-client-4.1 [virtual-mys 4.1.14-6 mysql database client binaries ii php4-cli 4:4.4.0-2 command-line interpreter for the p ii php4-mysql 4:4.4.0-2 MySQL module for php4 ii php4-pgsql 4:4.4.0-2 PostgreSQL module for php4 ii wwwconfig-common 0.0.43 Debian web auto configuration Versions of packages drupal recommends: pn apache <none> (no description available) ii libapache2-mod-php4 4:4.4.0-2 server-side, HTML-embedded scripti pn mysql-server | postgresql <none> (no description available) ii php4 4:4.4.0-2 server-side, HTML-embedded scripti -- debconf information: drupal/remove_backups: false drupal/createuser_failed: drupal/db_auto_update: true drupal/dropdb_failed: drupal/upgradedb_impossible: drupal/dbgeneration: false drupal/dbtype: MySQL drupal/database_doremove: false drupal/createdb_failed: drupal/dbserver: localhost drupal/webserver: apache drupal/upgradedb_failed: drupal/dbname: drupal drupal/dbuser: drupal drupal/dbadmin: root drupal/initdb_failed: drupal/conffile_failed: --===============1960338997== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="drupal_postgres.diff" diff -ruN drupal-4.5.5/database/database.pgsql drupal-4.5.5.new/database/database.pgsql --- drupal-4.5.5/database/database.pgsql 2005-10-11 19:31:28.000000000 -0500 +++ drupal-4.5.5.new/database/database.pgsql 2005-10-11 19:27:57.000000000 -0500 @@ -780,6 +780,17 @@ --- ALTER SEQUENCE menu_mid_seq RESTART 2; +--- +--- Enable pl/pgSQL (added due to Debian bug #242572) +--- Code taken from /usr/share/doc/postgresql/html/xplang.html +--- + +CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler AS + '$libdir/plpgsql' LANGUAGE C; + +CREATE TRUSTED PROCEDURAL LANGUAGE plpgsql + HANDLER plpgsql_call_handler; + --- --- Functions @@ -811,22 +822,7 @@ CREATE FUNCTION "if"(integer, text, text) RETURNS text AS ' BEGIN - IF $1 THEN - RETURN $2; - END IF; - IF NOT $1 THEN - RETURN $3; - END IF; + SELECT CASE WHEN $1 <> 0 THEN $2 ELSE $3 END; END; -' LANGUAGE 'plpgsql'; - ---- ---- Enable pl/pgSQL (added due to Debian bug #242572) ---- Code taken from /usr/share/doc/postgresql/html/xplang.html ---- - -CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler AS - '$libdir/plpgsql' LANGUAGE C; +' LANGUAGE 'sql'; -CREATE TRUSTED PROCEDURAL LANGUAGE plpgsql - HANDLER plpgsql_call_handler; Binary files drupal-4.5.5/database/.database.pgsql.swp and drupal-4.5.5.new/database/.database.pgsql.swp differ diff -ruN drupal-4.5.5/includes/session.inc drupal-4.5.5.new/includes/session.inc --- drupal-4.5.5/includes/session.inc 2005-08-14 19:05:38.000000000 -0500 +++ drupal-4.5.5.new/includes/session.inc 2005-10-11 19:30:59.000000000 -0500 @@ -26,7 +26,7 @@ if (!db_num_rows($result)) { $result = db_query("SELECT u.* FROM {users} u WHERE u.uid = 0"); - db_query("INSERT INTO {sessions} (sid, hostname, timestamp) values('%s', '%s', %d)", $key, $_SERVER["REMOTE_ADDR"], time()); + db_query("INSERT INTO {sessions} (uid, sid, hostname, timestamp) values(0, '%s', '%s', %d)", $key, $_SERVER["REMOTE_ADDR"], time()); } $user = db_fetch_object($result); @@ -51,7 +51,7 @@ } function sess_destroy($key) { - db_query("DELETE FROM {sessions} WHERE sid = '%d'", $key); + db_query("DELETE FROM {sessions} WHERE sid = '%s'", $key); } function sess_gc($lifetime) { --===============1960338997==-- --------------------------------------- Received: (at 312230-close) by bugs.debian.org; 11 Nov 2005 00:41:41 +0000
From katie@ftp-master.debian.org Thu Nov 10 16:41:41 2005 Return-path: <katie@ftp-master.debian.org> Received: from katie by spohr.debian.org with local (Exim 4.50) id 1EaMpr-0006ft-TX; Thu, 10 Nov 2005 16:32:07 -0800 From: Hilko Bengen <bengen@debian.org> To: 312230-close@bugs.debian.org X-Katie: $Revision: 1.56 $ Subject: Bug#312230: fixed in drupal 4.5.5-3 Message-Id: <E1EaMpr-0006ft-TX@spohr.debian.org> Sender: Archive Administrator <katie@ftp-master.debian.org> Date: Thu, 10 Nov 2005 16:32:07 -0800 Delivered-To: 312230-close@bugs.debian.org X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02 (1.212-2003-09-23-exp) on spohr.debian.org X-Spam-Level: X-Spam-Status: No, hits=-6.0 required=4.0 tests=BAYES_00,HAS_BUG_NUMBER autolearn=no version=2.60-bugs.debian.org_2005_01_02
Source: drupal Source-Version: 4.5.5-3 We believe that the bug you reported is fixed in the latest version of drupal, which is due to be installed in the Debian FTP archive: drupal_4.5.5-3.diff.gz to pool/main/d/drupal/drupal_4.5.5-3.diff.gz drupal_4.5.5-3.dsc to pool/main/d/drupal/drupal_4.5.5-3.dsc drupal_4.5.5-3_all.deb to pool/main/d/drupal/drupal_4.5.5-3_all.deb A summary of the changes between this version and the previous one is attached. Thank you for reporting the bug, which will now be closed. If you have further comments please address them to 312230@bugs.debian.org, and the maintainer will reopen the bug report if appropriate. Debian distribution maintenance software pp. Hilko Bengen <bengen@debian.org> (supplier of updated drupal package) (This message was generated automatically at their request; if you believe that there is a problem with it please contact the archive administrators by mailing ftpmaster@debian.org) -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Format: 1.7 Date: Fri, 11 Nov 2005 00:13:54 +0100 Source: drupal Binary: drupal Architecture: source all Version: 4.5.5-3 Distribution: unstable Urgency: low Maintainer: Hilko Bengen <bengen@debian.org> Changed-By: Hilko Bengen <bengen@debian.org> Description: drupal - fully-featured content management/discussion engine Closes: 312202 312230 319735 336719 Changes: drupal (4.5.5-3) unstable; urgency=low . * Pulled in includes/session.inc from upstream's 4.5 branch, updated database/database.pgsql. - Fixes "Users unable to log out" issue (Closes: #336719) - Fixes "uid default missing" issue (Closes: #312230, #312202, #319735) Files: 1e67c12d6f766f9ff2d930a5b4ebf4cb 609 web extra drupal_4.5.5-3.dsc 77dade82d81243815ebe99dc7c27037c 43990 web extra drupal_4.5.5-3.diff.gz ca260e977b91ebab1983894da4964108 483486 web extra drupal_4.5.5-3_all.deb -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2 (GNU/Linux) iD8DBQFDc9hZUCgnLz/SlGgRAkZsAKCPnUSHWcXF/lj6XwLI4bN5ol70bQCfSREH KOHYW3u/nMrMUOWjmM7NoZA= =DJMN -----END PGP SIGNATURE-----