- Development - lists.drupal.org

Bug#336719: marked as done (drupal: Users unable to log out)
by owner＠bugs.debian.org 11 Nov '05

11 Nov '05

Your message dated Thu, 10 Nov 2005 16:32:07 -0800 with message-id <E1EaMpr-0006fy-Uz(a)spohr.debian.org> and subject line Bug#336719: 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; 1 Nov 2005 04:09:02 +0000 >From ben(a)whenitsdone.com Mon Oct 31 20:09:02 2005 Return-path: <ben(a)whenitsdone.com> Received: from vscan02.westnet.com.au [203.10.1.132] by spohr.debian.org with esmtp (Exim 3.36 1 (Debian)) id 1EWnSH-00072E-00; Mon, 31 Oct 2005 20:09:01 -0800 Received: from localhost (localhost.localdomain [127.0.0.1]) by localhost (Postfix) with ESMTP id 9F71311ABE8; Tue, 1 Nov 2005 12:08:28 +0800 (WST) Received: from vscan02.westnet.com.au ([127.0.0.1]) by localhost (vscan02.westnet.com.au [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 02394-07; Tue, 1 Nov 2005 12:08:28 +0800 (WST) Received: from duron.workgroup (dsl-202-173-188-35.qld.westnet.com.au [202.173.188.35]) (using TLSv1 with cipher AES256-SHA (256/256 bits)) (No client certificate requested) by vscan02.westnet.com.au (Postfix) with ESMTP id 3A26211A8A4; Tue, 1 Nov 2005 12:08:27 +0800 (WST) Received: from ben by duron.workgroup with local (Exim 4.54) id 1EWnRi-0005Xj-Cl; Tue, 01 Nov 2005 14:08:26 +1000 Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: Ben Hay <ben(a)whenitsdone.com> To: Debian Bug Tracking System <submit(a)bugs.debian.org> Subject: drupal: Users unable to log out X-Mailer: reportbug 3.17 Date: Tue, 01 Nov 2005 14:08:26 +1000 X-Debbugs-Cc: Debian Security Team <team(a)security.debian.org> Message-Id: <E1EWnRi-0005Xj-Cl(a)duron.workgroup> Delivered-To: submit(a)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=-11.0 required=4.0 tests=BAYES_00,HAS_PACKAGE, X_DEBBUGS_CC autolearn=ham version=2.60-bugs.debian.org_2005_01_02 Package: drupal Version: 4.5.5-2 Severity: grave Tags: security Justification: user security hole Clicking "Log Out" appears to work, however user is still logged in. See http://drupal.org/node/29201 for discussion and solution. -- System Information: Debian Release: testing/unstable APT prefers testing APT policy: (990, 'testing') Architecture: i386 (i686) Shell: /bin/sh linked to /bin/bash Kernel: Linux 2.6.12-1-bs-k7 Locale: LANG=en_AU, LC_CTYPE=en_AU (charmap=ISO-8859-1) Versions of packages drupal depends on: ii apache2 2.0.54-5 next generation, scalable, extenda 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-tra 4.54-1 lightweight exim MTA (v4) daemon ii makepasswd 1.10-3 Generate and encrypt passwords ii mysql-client-4.1 [virtual-my 4.1.14-6 mysql database client binaries ii php4-cli 4:4.3.10-16 command-line interpreter for the p ii php4-mysql 4:4.3.10-16 MySQL module for php4 ii postgresql-client 7.5.11 front-end programs for PostgreSQL ii wwwconfig-common 0.0.44 Debian web auto configuration Versions of packages drupal recommends: pn apache <none> (no description available) ii libapache2-mod-php4 4:4.3.10-16 server-side, HTML-embedded scripti ii mysql-server 4.1.14-6 mysql database server (transitiona ii mysql-server-4.1 [mysql-serv 4.1.14-6 mysql database server binaries ii php4 4:4.3.10-16 server-side, HTML-embedded scripti ii postgresql 7.5.11 object-relational SQL database man -- debconf information: * drupal/remove_backups: true drupal/createuser_failed: * drupal/db_auto_update: false 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, apache2 drupal/upgradedb_failed: * drupal/dbname: drupal drupal/dbuser: drupal drupal/dbadmin: root drupal/initdb_failed: drupal/conffile_failed: --------------------------------------- Received: (at 336719-close) by bugs.debian.org; 11 Nov 2005 00:41:47 +0000 >From katie(a)ftp-master.debian.org Thu Nov 10 16:41:47 2005 Return-path: <katie(a)ftp-master.debian.org> Received: from katie by spohr.debian.org with local (Exim 4.50) id 1EaMpr-0006fy-Uz; Thu, 10 Nov 2005 16:32:07 -0800 From: Hilko Bengen <bengen(a)debian.org> To: 336719-close(a)bugs.debian.org X-Katie: $Revision: 1.56 $ Subject: Bug#336719: fixed in drupal 4.5.5-3 Message-Id: <E1EaMpr-0006fy-Uz(a)spohr.debian.org> Sender: Archive Administrator <katie(a)ftp-master.debian.org> Date: Thu, 10 Nov 2005 16:32:07 -0800 Delivered-To: 336719-close(a)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 336719(a)bugs.debian.org, and the maintainer will reopen the bug report if appropriate. Debian distribution maintenance software pp. Hilko Bengen <bengen(a)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(a)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(a)debian.org> Changed-By: Hilko Bengen <bengen(a)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-----

1 0

Bug#333459: marked as done (drupal: Drupal postgres fixes (including uid stuff))
by owner＠bugs.debian.org 11 Nov '05

11 Nov '05

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

1 0

Bug#312202: marked as done (drupal: uid default missing)
by owner＠bugs.debian.org 11 Nov '05

11 Nov '05

Your message dated Thu, 10 Nov 2005 16:32:07 -0800 with message-id <E1EaMpr-0006fw-UH(a)spohr.debian.org> and subject line Bug#319735: 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; 6 Jun 2005 08:56:59 +0000 >From mail(a)webthatworks.it Mon Jun 06 01:56:59 2005 Return-path: <mail(a)webthatworks.it> Received: from vsmtp14.tin.it [212.216.176.118] by spohr.debian.org with esmtp (Exim 3.35 1 (Debian)) id 1DfDPn-0001mT-00; Mon, 06 Jun 2005 01:56:59 -0700 Received: from caronte.webthatworks.it (82.56.87.219) by vsmtp14.tin.it (7.0.027) id 429D6F26001BE278 for submit(a)bugs.debian.org; Mon, 6 Jun 2005 10:56:27 +0200 Received: from stige.webthatworks.it (stige.webthatworks.it [192.168.1.5]) by caronte.webthatworks.it (Postfix) with ESMTP id 44C3A23049F for <submit(a)bugs.debian.org>; Mon, 6 Jun 2005 10:56:27 +0200 (CEST) Received: from stige.webthatworks.it (localhost [127.0.0.1]) by stige.webthatworks.it (Postfix) with SMTP id 20A12294053 for <submit(a)bugs.debian.org>; Mon, 6 Jun 2005 10:56:27 +0200 (CEST) Date: Mon, 6 Jun 2005 10:56:26 +0200 From: Ivan Sergio Borgonovo <mail(a)webthatworks.it> To: submit(a)bugs.debian.org Subject: drupal: uid default missing Message-Id: <20050606105626.66fcf905(a)stige.webthatworks.it> Organization: WebThatWorks.it X-Mailer: Sylpheed-Claws 0.9.12 (GTK+ 1.2.10; i686-suse-linux) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Delivered-To: submit(a)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-Status: No, hits=-6.5 required=4.0 tests=BAYES_10,HAS_PACKAGE autolearn=no version=2.60-bugs.debian.org_2005_01_02 X-Spam-Level: Package: drupal Version: 4.5.3-2 Sarge DB used pgsql After last drupal update: 1) I had to reconfigure the drupal:drupal db password manually alter user drupal with password '*********'; [1] 2) after fixing 1) I had problem with sql complaining Warning: pg_query(): Query failed: ERROR: null value in column "uid" violates not-null constraint in /usr/share/drupal/includes/database.pgsql.inc on line 104 Fatal error: ERROR: null value in column "uid" violates not-null constraint query: INSERT INTO sessions (sid, hostname, timestamp) values('69437a8e168e57547ae7ac57036ae951', '82.56.87.219', 1118046481) in /usr/share/drupal/includes/database.pgsql.inc on line 121 (probably) fixed with: alter table sessions alter column uid set default 0; problems seems to be in: ./scripts/debian-update.php: $ret[] = update_sql("CREATE TABLE sessions (uid int(10) unsigned NOT NULL, sid varchar(32) NOT NULL default '', hostname varchar(128) NOT NULL default '' .... [1] it may not be a bug... maybe I just pressed enter too fast during update and I noticed it was asking for a password... but for the postgres user, and I typed enter with no password... thanks -- Ivan Sergio Borgonovo http://www.webthatworks.it --------------------------------------- Received: (at 319735-close) by bugs.debian.org; 11 Nov 2005 00:41:40 +0000 >From katie(a)ftp-master.debian.org Thu Nov 10 16:41:40 2005 Return-path: <katie(a)ftp-master.debian.org> Received: from katie by spohr.debian.org with local (Exim 4.50) id 1EaMpr-0006fw-UH; Thu, 10 Nov 2005 16:32:07 -0800 From: Hilko Bengen <bengen(a)debian.org> To: 319735-close(a)bugs.debian.org X-Katie: $Revision: 1.56 $ Subject: Bug#319735: fixed in drupal 4.5.5-3 Message-Id: <E1EaMpr-0006fw-UH(a)spohr.debian.org> Sender: Archive Administrator <katie(a)ftp-master.debian.org> Date: Thu, 10 Nov 2005 16:32:07 -0800 Delivered-To: 319735-close(a)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 319735(a)bugs.debian.org, and the maintainer will reopen the bug report if appropriate. Debian distribution maintenance software pp. Hilko Bengen <bengen(a)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(a)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(a)debian.org> Changed-By: Hilko Bengen <bengen(a)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-----

1 0

Bug#312230: marked as done (Fw: drupal: uid default missing)
by owner＠bugs.debian.org 11 Nov '05

11 Nov '05

Your message dated Thu, 10 Nov 2005 16:32:07 -0800 with message-id <E1EaMpr-0006fw-UH(a)spohr.debian.org> and subject line Bug#319735: 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; 6 Jun 2005 13:02:58 +0000 >From ivan.s.b(a)gmail.com Mon Jun 06 06:02:57 2005 Return-path: <ivan.s.b(a)gmail.com> Received: from vsmtp14.tin.it [212.216.176.118] by spohr.debian.org with esmtp (Exim 3.35 1 (Debian)) id 1DfHFp-0004j8-00; Mon, 06 Jun 2005 06:02:57 -0700 Received: from caronte.webthatworks.it (82.56.87.219) by vsmtp14.tin.it (7.0.027) id 429D6F26001D65D9 for submit(a)bugs.debian.org; Mon, 6 Jun 2005 15:02:25 +0200 Received: from stige.webthatworks.it (stige.webthatworks.it [192.168.1.5]) by caronte.webthatworks.it (Postfix) with ESMTP id 33FA123049F for <submit(a)bugs.debian.org>; Mon, 6 Jun 2005 15:02:25 +0200 (CEST) Received: from stige.webthatworks.it (localhost [127.0.0.1]) by stige.webthatworks.it (Postfix) with SMTP id D9B6C294053 for <submit(a)bugs.debian.org>; Mon, 6 Jun 2005 15:02:24 +0200 (CEST) Date: Mon, 6 Jun 2005 15:02:24 +0200 From: Ivan Sergio Borgonovo <ivan.s.b(a)gmail.com> To: submit(a)bugs.debian.org Subject: Fw: drupal: uid default missing Message-Id: <20050606150224.141a7ddf(a)stige.webthatworks.it> Organization: WebThatWorks.it X-Mailer: Sylpheed-Claws 0.9.12 (GTK+ 1.2.10; i686-suse-linux) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Delivered-To: submit(a)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-Status: No, hits=-7.0 required=4.0 tests=BAYES_00,FW,HAS_PACKAGE autolearn=no version=2.60-bugs.debian.org_2005_01_02 X-Spam-Level: Package: drupal Version: 4.5.3-2 since: Unfortunately it's currently impossible to use the Debian mailing lists with a e-mail address that matches procmail's check for mail coming from a daemon. resending with different account. Sorry if duplicate ### Begin forwarded message: Date: Mon, 6 Jun 2005 10:56:26 +0200 From: Ivan Sergio Borgonovo <mail(a)webthatworks.it> To: submit(a)bugs.debian.org Subject: drupal: uid default missing Package: drupal Version: 4.5.3-2 Sarge DB used pgsql After last drupal update: 1) I had to reconfigure the drupal:drupal db password manually alter user drupal with password '*********'; [1] 2) after fixing 1) I had problem with sql complaining Warning: pg_query(): Query failed: ERROR: null value in column "uid" violates not-null constraint in /usr/share/drupal/includes/database.pgsql.inc on line 104 Fatal error: ERROR: null value in column "uid" violates not-null constraint query: INSERT INTO sessions (sid, hostname, timestamp) values('69437a8e168e57547ae7ac57036ae951', '82.56.87.219', 1118046481) in /usr/share/drupal/includes/database.pgsql.inc on line 121 (probably) fixed with: alter table sessions alter column uid set default 0; problems seems to be in: ./scripts/debian-update.php: $ret[] = update_sql("CREATE TABLE sessions (uid int(10) unsigned NOT NULL, sid varchar(32) NOT NULL default '', hostname varchar(128) NOT NULL default '' .... [1] it may not be a bug... maybe I just pressed enter too fast during update and I noticed it was asking for a password... but for the postgres user, and I typed enter with no password... thanks -- Ivan Sergio Borgonovo http://www.webthatworks.it ### end forwarded message: -- Ivan Sergio Borgonovo http://www.webthatworks.it --------------------------------------- Received: (at 319735-close) by bugs.debian.org; 11 Nov 2005 00:41:40 +0000 >From katie(a)ftp-master.debian.org Thu Nov 10 16:41:40 2005 Return-path: <katie(a)ftp-master.debian.org> Received: from katie by spohr.debian.org with local (Exim 4.50) id 1EaMpr-0006fw-UH; Thu, 10 Nov 2005 16:32:07 -0800 From: Hilko Bengen <bengen(a)debian.org> To: 319735-close(a)bugs.debian.org X-Katie: $Revision: 1.56 $ Subject: Bug#319735: fixed in drupal 4.5.5-3 Message-Id: <E1EaMpr-0006fw-UH(a)spohr.debian.org> Sender: Archive Administrator <katie(a)ftp-master.debian.org> Date: Thu, 10 Nov 2005 16:32:07 -0800 Delivered-To: 319735-close(a)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 319735(a)bugs.debian.org, and the maintainer will reopen the bug report if appropriate. Debian distribution maintenance software pp. Hilko Bengen <bengen(a)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(a)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(a)debian.org> Changed-By: Hilko Bengen <bengen(a)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-----

1 0

Bug#319735: marked as done (drupal: Problem with postgresql)
by owner＠bugs.debian.org 11 Nov '05

11 Nov '05

Your message dated Thu, 10 Nov 2005 16:32:07 -0800 with message-id <E1EaMpr-0006fw-UH(a)spohr.debian.org> and subject line Bug#319735: 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; 24 Jul 2005 12:25:35 +0000 >From mage(a)mordor.ath.cx Sun Jul 24 05:25:35 2005 Return-path: <mage(a)mordor.ath.cx> Received: from 81-188-71-21.adsl.easynet.be (mordor.ath.cx) [81.188.71.21] (postfix) by spohr.debian.org with esmtp (Exim 3.36 1 (Debian)) id 1DwfXz-0004Rj-00; Sun, 24 Jul 2005 05:25:35 -0700 Received: from localhost (localhost [127.0.0.1]) by mordor.ath.cx (Postfix) with ESMTP id 289E78DC019; Sun, 24 Jul 2005 14:28:30 +0200 (CEST) Received: from mordor.ath.cx ([127.0.0.1]) by localhost (mordor [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 00403-07; Sun, 24 Jul 2005 14:28:30 +0200 (CEST) Received: by mordor.ath.cx (Postfix, from userid 1000) id EE8138DC018; Sun, 24 Jul 2005 14:28:29 +0200 (CEST) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: Julien Cigar <mage(a)mordor.ath.cx> To: Debian Bug Tracking System <submit(a)bugs.debian.org> Subject: drupal: Problem with postgresql X-Mailer: reportbug 3.15 Date: Sun, 24 Jul 2005 14:28:29 +0200 Message-Id: <20050724122829.EE8138DC018(a)mordor.ath.cx> X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at mordor.ath.cx Delivered-To: submit(a)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 Package: drupal Version: 4.5.4-1 Severity: important Hello, I think there is a bug in the database script for postgresql. After installing drupal, I try to display the site (http://my.host.name/drupal) and I get the following error : Warning: pg_query(): Query failed: ERROR: null value in column "uid" violates not-null constraint in /usr/share/drupal/includes/database.pgsql.inc on line 104 Fatal error: ERROR: null value in column "uid" violates not-null constraint query: INSERT INTO sessions (sid, hostname, timestamp) values('5635f3f3dced1cc0cb1d9bafe77ce234', '192.168.0.10', 1122207318) in /usr/share/drupal/includes/database.pgsql.inc on line 121 I looked at the structure of the "sessions" table and the column uid is marked as not null. An "ALTER TABLE sessions ALTER COLUMN uid DROP NOT NULL;" seems to resolve the problem ... Thanks -- System Information: Debian Release: testing/unstable APT prefers testing APT policy: (500, 'testing') Architecture: i386 (i686) Shell: /bin/sh linked to /bin/bash Kernel: Linux 2.4.27 Locale: LANG=en_US, LC_CTYPE=en_US (charmap=ISO-8859-1) Versions of packages drupal depends on: ii apache2 2.0.54-4 next generation, scalable, extenda ii apache2-mpm-prefork [apach 2.0.54-4 traditional model for Apache2 ii debconf 1.4.52 Debian configuration management sy ii makepasswd 1.10-2 Generate and encrypt passwords ii php4-cli 4:4.3.10-15 command-line interpreter for the p ii php4-pgsql 3:4.3.10-5 PostgreSQL module for php4 ii postfix [mail-transport-ag 2.2.4-1 A high-performance mail transport ii postgresql-client 7.4.7-6sarge1 front-end programs for PostgreSQL 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.3.10-15 server-side, HTML-embedded scripti ii php4 4:4.3.10-15 server-side, HTML-embedded scripti ii postgresql 7.4.7-6sarge1 object-relational SQL database man -- debconf information excluded --------------------------------------- Received: (at 319735-close) by bugs.debian.org; 11 Nov 2005 00:41:40 +0000 >From katie(a)ftp-master.debian.org Thu Nov 10 16:41:40 2005 Return-path: <katie(a)ftp-master.debian.org> Received: from katie by spohr.debian.org with local (Exim 4.50) id 1EaMpr-0006fw-UH; Thu, 10 Nov 2005 16:32:07 -0800 From: Hilko Bengen <bengen(a)debian.org> To: 319735-close(a)bugs.debian.org X-Katie: $Revision: 1.56 $ Subject: Bug#319735: fixed in drupal 4.5.5-3 Message-Id: <E1EaMpr-0006fw-UH(a)spohr.debian.org> Sender: Archive Administrator <katie(a)ftp-master.debian.org> Date: Thu, 10 Nov 2005 16:32:07 -0800 Delivered-To: 319735-close(a)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 319735(a)bugs.debian.org, and the maintainer will reopen the bug report if appropriate. Debian distribution maintenance software pp. Hilko Bengen <bengen(a)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(a)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(a)debian.org> Changed-By: Hilko Bengen <bengen(a)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-----

1 0

Bug#319735: marked as done (drupal: Problem with postgresql)
by owner＠bugs.debian.org 11 Nov '05

11 Nov '05

Your message dated Thu, 10 Nov 2005 16:32:07 -0800 with message-id <E1EaMpr-0006ft-TX(a)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; 24 Jul 2005 12:25:35 +0000 >From mage(a)mordor.ath.cx Sun Jul 24 05:25:35 2005 Return-path: <mage(a)mordor.ath.cx> Received: from 81-188-71-21.adsl.easynet.be (mordor.ath.cx) [81.188.71.21] (postfix) by spohr.debian.org with esmtp (Exim 3.36 1 (Debian)) id 1DwfXz-0004Rj-00; Sun, 24 Jul 2005 05:25:35 -0700 Received: from localhost (localhost [127.0.0.1]) by mordor.ath.cx (Postfix) with ESMTP id 289E78DC019; Sun, 24 Jul 2005 14:28:30 +0200 (CEST) Received: from mordor.ath.cx ([127.0.0.1]) by localhost (mordor [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 00403-07; Sun, 24 Jul 2005 14:28:30 +0200 (CEST) Received: by mordor.ath.cx (Postfix, from userid 1000) id EE8138DC018; Sun, 24 Jul 2005 14:28:29 +0200 (CEST) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: Julien Cigar <mage(a)mordor.ath.cx> To: Debian Bug Tracking System <submit(a)bugs.debian.org> Subject: drupal: Problem with postgresql X-Mailer: reportbug 3.15 Date: Sun, 24 Jul 2005 14:28:29 +0200 Message-Id: <20050724122829.EE8138DC018(a)mordor.ath.cx> X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at mordor.ath.cx Delivered-To: submit(a)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 Package: drupal Version: 4.5.4-1 Severity: important Hello, I think there is a bug in the database script for postgresql. After installing drupal, I try to display the site (http://my.host.name/drupal) and I get the following error : Warning: pg_query(): Query failed: ERROR: null value in column "uid" violates not-null constraint in /usr/share/drupal/includes/database.pgsql.inc on line 104 Fatal error: ERROR: null value in column "uid" violates not-null constraint query: INSERT INTO sessions (sid, hostname, timestamp) values('5635f3f3dced1cc0cb1d9bafe77ce234', '192.168.0.10', 1122207318) in /usr/share/drupal/includes/database.pgsql.inc on line 121 I looked at the structure of the "sessions" table and the column uid is marked as not null. An "ALTER TABLE sessions ALTER COLUMN uid DROP NOT NULL;" seems to resolve the problem ... Thanks -- System Information: Debian Release: testing/unstable APT prefers testing APT policy: (500, 'testing') Architecture: i386 (i686) Shell: /bin/sh linked to /bin/bash Kernel: Linux 2.4.27 Locale: LANG=en_US, LC_CTYPE=en_US (charmap=ISO-8859-1) Versions of packages drupal depends on: ii apache2 2.0.54-4 next generation, scalable, extenda ii apache2-mpm-prefork [apach 2.0.54-4 traditional model for Apache2 ii debconf 1.4.52 Debian configuration management sy ii makepasswd 1.10-2 Generate and encrypt passwords ii php4-cli 4:4.3.10-15 command-line interpreter for the p ii php4-pgsql 3:4.3.10-5 PostgreSQL module for php4 ii postfix [mail-transport-ag 2.2.4-1 A high-performance mail transport ii postgresql-client 7.4.7-6sarge1 front-end programs for PostgreSQL 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.3.10-15 server-side, HTML-embedded scripti ii php4 4:4.3.10-15 server-side, HTML-embedded scripti ii postgresql 7.4.7-6sarge1 object-relational SQL database man -- debconf information excluded --------------------------------------- Received: (at 312230-close) by bugs.debian.org; 11 Nov 2005 00:41:41 +0000 >From katie(a)ftp-master.debian.org Thu Nov 10 16:41:41 2005 Return-path: <katie(a)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(a)debian.org> To: 312230-close(a)bugs.debian.org X-Katie: $Revision: 1.56 $ Subject: Bug#312230: fixed in drupal 4.5.5-3 Message-Id: <E1EaMpr-0006ft-TX(a)spohr.debian.org> Sender: Archive Administrator <katie(a)ftp-master.debian.org> Date: Thu, 10 Nov 2005 16:32:07 -0800 Delivered-To: 312230-close(a)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(a)bugs.debian.org, and the maintainer will reopen the bug report if appropriate. Debian distribution maintenance software pp. Hilko Bengen <bengen(a)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(a)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(a)debian.org> Changed-By: Hilko Bengen <bengen(a)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-----

1 0

Bug#333459: marked as done (drupal: Drupal postgres fixes (including uid stuff))
by owner＠bugs.debian.org 11 Nov '05

11 Nov '05

Your message dated Thu, 10 Nov 2005 16:32:07 -0800 with message-id <E1EaMpr-0006ft-TX(a)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(a)matt-land.com Tue Oct 11 17:43:45 2005 Return-path: <matt(a)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(a)matt-land.com> To: Debian Bug Tracking System <submit(a)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(a)matt-land.com> Delivered-To: submit(a)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(a)ftp-master.debian.org Thu Nov 10 16:41:41 2005 Return-path: <katie(a)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(a)debian.org> To: 312230-close(a)bugs.debian.org X-Katie: $Revision: 1.56 $ Subject: Bug#312230: fixed in drupal 4.5.5-3 Message-Id: <E1EaMpr-0006ft-TX(a)spohr.debian.org> Sender: Archive Administrator <katie(a)ftp-master.debian.org> Date: Thu, 10 Nov 2005 16:32:07 -0800 Delivered-To: 312230-close(a)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(a)bugs.debian.org, and the maintainer will reopen the bug report if appropriate. Debian distribution maintenance software pp. Hilko Bengen <bengen(a)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(a)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(a)debian.org> Changed-By: Hilko Bengen <bengen(a)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-----

1 0

Bug#312202: marked as done (drupal: uid default missing)
by owner＠bugs.debian.org 11 Nov '05

11 Nov '05

Your message dated Thu, 10 Nov 2005 16:32:07 -0800 with message-id <E1EaMpr-0006ft-TX(a)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; 6 Jun 2005 08:56:59 +0000 >From mail(a)webthatworks.it Mon Jun 06 01:56:59 2005 Return-path: <mail(a)webthatworks.it> Received: from vsmtp14.tin.it [212.216.176.118] by spohr.debian.org with esmtp (Exim 3.35 1 (Debian)) id 1DfDPn-0001mT-00; Mon, 06 Jun 2005 01:56:59 -0700 Received: from caronte.webthatworks.it (82.56.87.219) by vsmtp14.tin.it (7.0.027) id 429D6F26001BE278 for submit(a)bugs.debian.org; Mon, 6 Jun 2005 10:56:27 +0200 Received: from stige.webthatworks.it (stige.webthatworks.it [192.168.1.5]) by caronte.webthatworks.it (Postfix) with ESMTP id 44C3A23049F for <submit(a)bugs.debian.org>; Mon, 6 Jun 2005 10:56:27 +0200 (CEST) Received: from stige.webthatworks.it (localhost [127.0.0.1]) by stige.webthatworks.it (Postfix) with SMTP id 20A12294053 for <submit(a)bugs.debian.org>; Mon, 6 Jun 2005 10:56:27 +0200 (CEST) Date: Mon, 6 Jun 2005 10:56:26 +0200 From: Ivan Sergio Borgonovo <mail(a)webthatworks.it> To: submit(a)bugs.debian.org Subject: drupal: uid default missing Message-Id: <20050606105626.66fcf905(a)stige.webthatworks.it> Organization: WebThatWorks.it X-Mailer: Sylpheed-Claws 0.9.12 (GTK+ 1.2.10; i686-suse-linux) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Delivered-To: submit(a)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-Status: No, hits=-6.5 required=4.0 tests=BAYES_10,HAS_PACKAGE autolearn=no version=2.60-bugs.debian.org_2005_01_02 X-Spam-Level: Package: drupal Version: 4.5.3-2 Sarge DB used pgsql After last drupal update: 1) I had to reconfigure the drupal:drupal db password manually alter user drupal with password '*********'; [1] 2) after fixing 1) I had problem with sql complaining Warning: pg_query(): Query failed: ERROR: null value in column "uid" violates not-null constraint in /usr/share/drupal/includes/database.pgsql.inc on line 104 Fatal error: ERROR: null value in column "uid" violates not-null constraint query: INSERT INTO sessions (sid, hostname, timestamp) values('69437a8e168e57547ae7ac57036ae951', '82.56.87.219', 1118046481) in /usr/share/drupal/includes/database.pgsql.inc on line 121 (probably) fixed with: alter table sessions alter column uid set default 0; problems seems to be in: ./scripts/debian-update.php: $ret[] = update_sql("CREATE TABLE sessions (uid int(10) unsigned NOT NULL, sid varchar(32) NOT NULL default '', hostname varchar(128) NOT NULL default '' .... [1] it may not be a bug... maybe I just pressed enter too fast during update and I noticed it was asking for a password... but for the postgres user, and I typed enter with no password... thanks -- Ivan Sergio Borgonovo http://www.webthatworks.it --------------------------------------- Received: (at 312230-close) by bugs.debian.org; 11 Nov 2005 00:41:41 +0000 >From katie(a)ftp-master.debian.org Thu Nov 10 16:41:41 2005 Return-path: <katie(a)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(a)debian.org> To: 312230-close(a)bugs.debian.org X-Katie: $Revision: 1.56 $ Subject: Bug#312230: fixed in drupal 4.5.5-3 Message-Id: <E1EaMpr-0006ft-TX(a)spohr.debian.org> Sender: Archive Administrator <katie(a)ftp-master.debian.org> Date: Thu, 10 Nov 2005 16:32:07 -0800 Delivered-To: 312230-close(a)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(a)bugs.debian.org, and the maintainer will reopen the bug report if appropriate. Debian distribution maintenance software pp. Hilko Bengen <bengen(a)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(a)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(a)debian.org> Changed-By: Hilko Bengen <bengen(a)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-----

1 0

Bug#312230: marked as done (Fw: drupal: uid default missing)
by owner＠bugs.debian.org 11 Nov '05

11 Nov '05

Your message dated Thu, 10 Nov 2005 16:32:07 -0800 with message-id <E1EaMpr-0006ft-TX(a)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; 6 Jun 2005 13:02:58 +0000 >From ivan.s.b(a)gmail.com Mon Jun 06 06:02:57 2005 Return-path: <ivan.s.b(a)gmail.com> Received: from vsmtp14.tin.it [212.216.176.118] by spohr.debian.org with esmtp (Exim 3.35 1 (Debian)) id 1DfHFp-0004j8-00; Mon, 06 Jun 2005 06:02:57 -0700 Received: from caronte.webthatworks.it (82.56.87.219) by vsmtp14.tin.it (7.0.027) id 429D6F26001D65D9 for submit(a)bugs.debian.org; Mon, 6 Jun 2005 15:02:25 +0200 Received: from stige.webthatworks.it (stige.webthatworks.it [192.168.1.5]) by caronte.webthatworks.it (Postfix) with ESMTP id 33FA123049F for <submit(a)bugs.debian.org>; Mon, 6 Jun 2005 15:02:25 +0200 (CEST) Received: from stige.webthatworks.it (localhost [127.0.0.1]) by stige.webthatworks.it (Postfix) with SMTP id D9B6C294053 for <submit(a)bugs.debian.org>; Mon, 6 Jun 2005 15:02:24 +0200 (CEST) Date: Mon, 6 Jun 2005 15:02:24 +0200 From: Ivan Sergio Borgonovo <ivan.s.b(a)gmail.com> To: submit(a)bugs.debian.org Subject: Fw: drupal: uid default missing Message-Id: <20050606150224.141a7ddf(a)stige.webthatworks.it> Organization: WebThatWorks.it X-Mailer: Sylpheed-Claws 0.9.12 (GTK+ 1.2.10; i686-suse-linux) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Delivered-To: submit(a)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-Status: No, hits=-7.0 required=4.0 tests=BAYES_00,FW,HAS_PACKAGE autolearn=no version=2.60-bugs.debian.org_2005_01_02 X-Spam-Level: Package: drupal Version: 4.5.3-2 since: Unfortunately it's currently impossible to use the Debian mailing lists with a e-mail address that matches procmail's check for mail coming from a daemon. resending with different account. Sorry if duplicate ### Begin forwarded message: Date: Mon, 6 Jun 2005 10:56:26 +0200 From: Ivan Sergio Borgonovo <mail(a)webthatworks.it> To: submit(a)bugs.debian.org Subject: drupal: uid default missing Package: drupal Version: 4.5.3-2 Sarge DB used pgsql After last drupal update: 1) I had to reconfigure the drupal:drupal db password manually alter user drupal with password '*********'; [1] 2) after fixing 1) I had problem with sql complaining Warning: pg_query(): Query failed: ERROR: null value in column "uid" violates not-null constraint in /usr/share/drupal/includes/database.pgsql.inc on line 104 Fatal error: ERROR: null value in column "uid" violates not-null constraint query: INSERT INTO sessions (sid, hostname, timestamp) values('69437a8e168e57547ae7ac57036ae951', '82.56.87.219', 1118046481) in /usr/share/drupal/includes/database.pgsql.inc on line 121 (probably) fixed with: alter table sessions alter column uid set default 0; problems seems to be in: ./scripts/debian-update.php: $ret[] = update_sql("CREATE TABLE sessions (uid int(10) unsigned NOT NULL, sid varchar(32) NOT NULL default '', hostname varchar(128) NOT NULL default '' .... [1] it may not be a bug... maybe I just pressed enter too fast during update and I noticed it was asking for a password... but for the postgres user, and I typed enter with no password... thanks -- Ivan Sergio Borgonovo http://www.webthatworks.it ### end forwarded message: -- Ivan Sergio Borgonovo http://www.webthatworks.it --------------------------------------- Received: (at 312230-close) by bugs.debian.org; 11 Nov 2005 00:41:41 +0000 >From katie(a)ftp-master.debian.org Thu Nov 10 16:41:41 2005 Return-path: <katie(a)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(a)debian.org> To: 312230-close(a)bugs.debian.org X-Katie: $Revision: 1.56 $ Subject: Bug#312230: fixed in drupal 4.5.5-3 Message-Id: <E1EaMpr-0006ft-TX(a)spohr.debian.org> Sender: Archive Administrator <katie(a)ftp-master.debian.org> Date: Thu, 10 Nov 2005 16:32:07 -0800 Delivered-To: 312230-close(a)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(a)bugs.debian.org, and the maintainer will reopen the bug report if appropriate. Debian distribution maintenance software pp. Hilko Bengen <bengen(a)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(a)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(a)debian.org> Changed-By: Hilko Bengen <bengen(a)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-----

1 0

Bug#333459: marked as done (drupal: Drupal postgres fixes (including uid stuff))
by owner＠bugs.debian.org 11 Nov '05

11 Nov '05

Your message dated Thu, 10 Nov 2005 16:32:07 -0800 with message-id <E1EaMpr-0006fr-Sn(a)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(a)matt-land.com Tue Oct 11 17:43:45 2005 Return-path: <matt(a)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(a)matt-land.com> To: Debian Bug Tracking System <submit(a)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(a)matt-land.com> Delivered-To: submit(a)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(a)ftp-master.debian.org Thu Nov 10 16:41:46 2005 Return-path: <katie(a)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(a)debian.org> To: 312202-close(a)bugs.debian.org X-Katie: $Revision: 1.56 $ Subject: Bug#312202: fixed in drupal 4.5.5-3 Message-Id: <E1EaMpr-0006fr-Sn(a)spohr.debian.org> Sender: Archive Administrator <katie(a)ftp-master.debian.org> Date: Thu, 10 Nov 2005 16:32:07 -0800 Delivered-To: 312202-close(a)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(a)bugs.debian.org, and the maintainer will reopen the bug report if appropriate. Debian distribution maintenance software pp. Hilko Bengen <bengen(a)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(a)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(a)debian.org> Changed-By: Hilko Bengen <bengen(a)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-----

1 0