[development] Bug#333459: marked as done (drupal: Drupal postgres fixes (including uid stuff))

Debian Bug Tracking System owner at bugs.debian.org
Fri Nov 11 00:48:11 UTC 2005


Your message dated Thu, 10 Nov 2005 16:32:07 -0800
with message-id <E1EaMpr-0006fr-Sn at spohr.debian.org>
and subject line Bug#312202: 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 at matt-land.com Tue Oct 11 17:43:45 2005
Return-path: <matt at 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 at matt-land.com>
To: Debian Bug Tracking System <submit at 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 at matt-land.com>
Delivered-To: submit at 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 312202-close) by bugs.debian.org; 11 Nov 2005 00:41:46 +0000
>From katie at ftp-master.debian.org Thu Nov 10 16:41:46 2005
Return-path: <katie at ftp-master.debian.org>
Received: from katie by spohr.debian.org with local (Exim 4.50)
	id 1EaMpr-0006fr-Sn; Thu, 10 Nov 2005 16:32:07 -0800
From: Hilko Bengen <bengen at debian.org>
To: 312202-close at bugs.debian.org
X-Katie: $Revision: 1.56 $
Subject: Bug#312202: fixed in drupal 4.5.5-3
Message-Id: <E1EaMpr-0006fr-Sn at spohr.debian.org>
Sender: Archive Administrator <katie at ftp-master.debian.org>
Date: Thu, 10 Nov 2005 16:32:07 -0800
Delivered-To: 312202-close at 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 312202 at bugs.debian.org,
and the maintainer will reopen the bug report if appropriate.

Debian distribution maintenance software
pp.
Hilko Bengen <bengen at 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 at 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 at debian.org>
Changed-By: Hilko Bengen <bengen at 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-----




More information about the development mailing list