From owner-freebsd-perl@FreeBSD.ORG Sun Mar 6 09:55:35 2005 Return-Path: Delivered-To: freebsd-perl@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id D644816A4CF; Sun, 6 Mar 2005 09:55:35 +0000 (GMT) Received: from black.imgsrc.co.jp (black.imgsrc.co.jp [210.226.20.147]) by mx1.FreeBSD.org (Postfix) with ESMTP id 2B1E243D3F; Sun, 6 Mar 2005 09:55:35 +0000 (GMT) (envelope-from kuriyama@imgsrc.co.jp) Received: from localhost (localhost [127.0.0.1]) by black.imgsrc.co.jp (Postfix) with ESMTP id 1711050C8B; Sun, 6 Mar 2005 18:55:34 +0900 (JST) Received: from black.imgsrc.co.jp (black.imgsrc.co.jp [IPv6:2001:218:422:2::9999]) by black.imgsrc.co.jp (Postfix) with ESMTP id 68C5E50CA5; Sun, 6 Mar 2005 18:55:32 +0900 (JST) Date: Sun, 06 Mar 2005 18:55:32 +0900 Message-ID: <7mzmxhnlnv.wl%kuriyama@imgsrc.co.jp> From: Jun Kuriyama To: Mathieu Arnold In-Reply-To: <64573D1015B24642D50F2493@[192.168.8.51]> References: <20050303195408.GA20131@localhost> <64573D1015B24642D50F2493@192.168.8.51> User-Agent: Wanderlust/2.12.0 (Your Wildest Dreams) SEMI/1.14.6 (Maruoka) FLIM/1.14.7 (=?ISO-8859-4?Q?Sanj=F2?=) APEL/10.6 Emacs/21.3 (i386--freebsd) MULE/5.0 (SAKAKI) MIME-Version: 1.0 (generated by SEMI 1.14.6 - "Maruoka") Content-Type: text/plain; charset=US-ASCII X-Virus-Scanned: by amavisd 0.1 cc: Bachelier Vincent cc: perl@FreeBSD.org Subject: Re: p5-DBD-Pg X-BeenThere: freebsd-perl@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: maintainer of a number of perl-related ports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 06 Mar 2005 09:55:36 -0000 At Fri, 04 Mar 2005 11:39:50 +0100, Mathieu Arnold wrote: > | Is it normal ? > | Perhaps downgrade is better ... > > Which perl version ? Can you give a sniplet of code which has the problem ? Okay, at least on my system (perl-5.8.6, postgresql-7.4.7), this patchi fixes the problem. Could you please testing and commit? # I'll submit this to development team. Index: Makefile =================================================================== RCS file: /home/ncvs/ports/databases/p5-DBD-Pg/Makefile,v retrieving revision 1.61 diff -u -r1.61 Makefile --- Makefile 2 Mar 2005 18:18:57 -0000 1.61 +++ Makefile 6 Mar 2005 09:53:08 -0000 @@ -7,6 +7,7 @@ PORTNAME= DBD-Pg PORTVERSION= 1.40 +PORTREVISION= 1 CATEGORIES= databases perl5 MASTER_SITES= ${MASTER_SITE_PERL_CPAN} MASTER_SITE_SUBDIR= DBD Index: files/patch-dbdimp.c =================================================================== RCS file: files/patch-dbdimp.c diff -N files/patch-dbdimp.c --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ files/patch-dbdimp.c 6 Mar 2005 09:35:26 -0000 @@ -0,0 +1,15 @@ +--- dbdimp.c.orig Sun Mar 6 18:34:58 2005 ++++ dbdimp.c Sun Mar 6 18:35:10 2005 +@@ -1662,7 +1662,11 @@ + /* Populate paramTypes */ + paramTypes = calloc(imp_sth->numphs, sizeof(*paramTypes)); + for (x=0,currph=imp_sth->ph; NULL != currph; currph=currph->nextph) { +- paramTypes[x++] = currph->bind_type->type_id; ++ if (BYTEAOID==currph->bind_type->type_id) { ++ paramTypes[x++] = currph->bind_type->type_id; ++ } else { ++ paramTypes[x++] = 0; ++ } + } + + if (dbis->debug >= 10) { -- Jun Kuriyama // IMG SRC, Inc. // FreeBSD Project From owner-freebsd-perl@FreeBSD.ORG Mon Mar 7 11:03:20 2005 Return-Path: Delivered-To: freebsd-perl@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 93AC316A4CE for ; Mon, 7 Mar 2005 11:03:20 +0000 (GMT) Received: from freefall.freebsd.org (freefall.freebsd.org [216.136.204.21]) by mx1.FreeBSD.org (Postfix) with ESMTP id 533CE43D2F for ; Mon, 7 Mar 2005 11:03:20 +0000 (GMT) (envelope-from owner-bugmaster@freebsd.org) Received: from freefall.freebsd.org (peter@localhost [127.0.0.1]) by freefall.freebsd.org (8.13.3/8.13.3) with ESMTP id j27B3KZc038838 for ; Mon, 7 Mar 2005 11:03:20 GMT (envelope-from owner-bugmaster@freebsd.org) Received: (from peter@localhost) by freefall.freebsd.org (8.13.3/8.13.1/Submit) id j27B3Jf5038832 for perl@freebsd.org; Mon, 7 Mar 2005 11:03:19 GMT (envelope-from owner-bugmaster@freebsd.org) Date: Mon, 7 Mar 2005 11:03:19 GMT Message-Id: <200503071103.j27B3Jf5038832@freefall.freebsd.org> X-Authentication-Warning: freefall.freebsd.org: peter set sender to owner-bugmaster@freebsd.org using -f From: FreeBSD bugmaster To: perl@FreeBSD.org Subject: Current problem reports assigned to you X-BeenThere: freebsd-perl@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: maintainer of a number of perl-related ports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 07 Mar 2005 11:03:20 -0000 Current FreeBSD problem reports Critical problems Serious problems S Submitted Tracker Resp. Description ------------------------------------------------------------------------------- o [2004/03/03] ports/63670 perl 'Unable to read from thread kernel pipe' o [2004/04/22] ports/65900 perl (non-maintainer) IGNORE p5-ExtUtils-MakeM 2 problems total. Non-critical problems S Submitted Tracker Resp. Description ------------------------------------------------------------------------------- f [2004/07/22] ports/69421 perl perl5-related distfiles are in common dis 1 problem total. From owner-freebsd-perl@FreeBSD.ORG Mon Mar 7 17:10:15 2005 Return-Path: Delivered-To: freebsd-perl@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 793E616A508 for ; Mon, 7 Mar 2005 17:10:15 +0000 (GMT) Received: from postfix4-2.free.fr (postfix4-2.free.fr [213.228.0.176]) by mx1.FreeBSD.org (Postfix) with ESMTP id AF87C43D5E for ; Mon, 7 Mar 2005 17:10:14 +0000 (GMT) (envelope-from vincent@localhost.free.fr) Received: from vincent (ferreol-1-82-66-171-150.fbx.proxad.net [82.66.171.150]) by postfix4-2.free.fr (Postfix) with ESMTP id 5B2752D5919; Mon, 7 Mar 2005 18:10:08 +0100 (CET) Received: by vincent (Postfix, from userid 1001) id D4A04C99A6; Mon, 7 Mar 2005 18:10:02 +0100 (CET) Date: Mon, 7 Mar 2005 18:10:02 +0100 From: Bachelier Vincent To: Jun Kuriyama Message-ID: <20050307171002.GA1483@localhost> References: <20050303195408.GA20131@localhost> <64573D1015B24642D50F2493@192.168.8.51> <7mzmxhnlnv.wl%kuriyama@imgsrc.co.jp> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <7mzmxhnlnv.wl%kuriyama@imgsrc.co.jp> User-Agent: Mutt/1.4.2.1i X-Operating-System: FreeBSD vincent 5.4-PRERELEASE FreeBSD 5.4-PRERELEASE cc: perl@FreeBSD.org Subject: Re: p5-DBD-Pg X-BeenThere: freebsd-perl@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: maintainer of a number of perl-related ports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 07 Mar 2005 17:10:15 -0000 I have retest it now, just insert and select ... all done without patch. .. I try to test it again tomorrow, and see if persist at my work I will report if I use your patch Thx for support ... Le Sun, Mar 06, 2005 at 06:55:32PM +0900, Jun Kuriyama a écrit: > Date: Sun, 06 Mar 2005 18:55:32 +0900 > From: Jun Kuriyama > To: Mathieu Arnold > Cc: Bachelier Vincent , perl@FreeBSD.org > Subject: Re: p5-DBD-Pg > User-Agent: Wanderlust/2.12.0 (Your Wildest Dreams) SEMI/1.14.6 (Maruoka) > FLIM/1.14.7 (Sanj?) APEL/10.6 Emacs/21.3 (i386--freebsd) > MULE/5.0 (SAKAKI) > > At Fri, 04 Mar 2005 11:39:50 +0100, > Mathieu Arnold wrote: > > | Is it normal ? > > | Perhaps downgrade is better ... > > > > Which perl version ? Can you give a sniplet of code which has the problem ? > > Okay, at least on my system (perl-5.8.6, postgresql-7.4.7), this > patchi fixes the problem. Could you please testing and commit? > > # I'll submit this to development team. > > > Index: Makefile > =================================================================== > RCS file: /home/ncvs/ports/databases/p5-DBD-Pg/Makefile,v > retrieving revision 1.61 > diff -u -r1.61 Makefile > --- Makefile 2 Mar 2005 18:18:57 -0000 1.61 > +++ Makefile 6 Mar 2005 09:53:08 -0000 > @@ -7,6 +7,7 @@ > > PORTNAME= DBD-Pg > PORTVERSION= 1.40 > +PORTREVISION= 1 > CATEGORIES= databases perl5 > MASTER_SITES= ${MASTER_SITE_PERL_CPAN} > MASTER_SITE_SUBDIR= DBD > Index: files/patch-dbdimp.c > =================================================================== > RCS file: files/patch-dbdimp.c > diff -N files/patch-dbdimp.c > --- /dev/null 1 Jan 1970 00:00:00 -0000 > +++ files/patch-dbdimp.c 6 Mar 2005 09:35:26 -0000 > @@ -0,0 +1,15 @@ > +--- dbdimp.c.orig Sun Mar 6 18:34:58 2005 > ++++ dbdimp.c Sun Mar 6 18:35:10 2005 > +@@ -1662,7 +1662,11 @@ > + /* Populate paramTypes */ > + paramTypes = calloc(imp_sth->numphs, sizeof(*paramTypes)); > + for (x=0,currph=imp_sth->ph; NULL != currph; currph=currph->nextph) { > +- paramTypes[x++] = currph->bind_type->type_id; > ++ if (BYTEAOID==currph->bind_type->type_id) { > ++ paramTypes[x++] = currph->bind_type->type_id; > ++ } else { > ++ paramTypes[x++] = 0; > ++ } > + } > + > + if (dbis->debug >= 10) { > > > -- > Jun Kuriyama // IMG SRC, Inc. > // FreeBSD Project -- Vincent Bachelier Language : Francais / English Societ(e/y) : Solintech - http://www.solintech.fr - Serveurs linux Blog : http://dieghostfbsd.blogspot.com Site perso : http://www.solintech.fr/freebsd/ - FreeBSD Donjon Citation (fortune): "I'd love to go out with you, but I've been scheduled for a karma transplant." From owner-freebsd-perl@FreeBSD.ORG Tue Mar 8 07:44:53 2005 Return-Path: Delivered-To: freebsd-perl@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 50D9216A4CE for ; Tue, 8 Mar 2005 07:44:53 +0000 (GMT) Received: from web25308.mail.ukl.yahoo.com (web25308.mail.ukl.yahoo.com [217.12.10.80]) by mx1.FreeBSD.org (Postfix) with SMTP id 8E85743D54 for ; Tue, 8 Mar 2005 07:44:52 +0000 (GMT) (envelope-from vincent_bachelier@yahoo.fr) Received: (qmail 90942 invoked by uid 60001); 8 Mar 2005 07:44:51 -0000 Message-ID: <20050308074451.90940.qmail@web25308.mail.ukl.yahoo.com> Received: from [81.56.233.219] by web25308.mail.ukl.yahoo.com via HTTP; Tue, 08 Mar 2005 08:44:51 CET Date: Tue, 8 Mar 2005 08:44:51 +0100 (CET) From: Vincent Bachelier To: perl@freebsd.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Subject: p5-DBD-Pg X-BeenThere: freebsd-perl@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: maintainer of a number of perl-related ports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 08 Mar 2005 07:44:53 -0000 Well, with patch I have the same problem: Index: Makefile =================================================================== RCS file: /home/ncvs/ports/databases/p5-DBD-Pg/Makefile,v retrieving revision 1.61 diff -u -r1.61 Makefile --- Makefile 2 Mar 2005 18:18:57 -0000 1.61 +++ Makefile 6 Mar 2005 09:53:08 -0000 @@ -7,6 +7,7 @@ PORTNAME= DBD-Pg PORTVERSION= 1.40 +PORTREVISION= 1 CATEGORIES= databases perl5 MASTER_SITES= ${MASTER_SITE_PERL_CPAN} MASTER_SITE_SUBDIR= DBD Index: files/patch-dbdimp.c =================================================================== RCS file: files/patch-dbdimp.c diff -N files/patch-dbdimp.c --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ files/patch-dbdimp.c 6 Mar 2005 09:35:26 -0000 @@ -0,0 +1,15 @@ +--- dbdimp.c.orig Sun Mar 6 18:34:58 2005 ++++ dbdimp.c Sun Mar 6 18:35:10 2005 +@@ -1662,7 +1662,11 @@ + /* Populate paramTypes */ + paramTypes = calloc(imp_sth->numphs, sizeof(*paramTypes)); + for (x=0,currph=imp_sth->ph; NULL != currph; currph=currph->nextph) { +- paramTypes[x++] = currph->bind_type->type_id; ++ if (BYTEAOID==currph->bind_type->type_id) { ++ paramTypes[x++] = currph->bind_type->type_id; ++ } else { ++ paramTypes[x++] = 0; ++ } + } + + if (dbis->debug >= 10) { Well, here the error message: DBD::Pg::st execute failed: ERREUR: syntax error sur ou près de «$1» at character 111 here the code: #!/usr/bin/perl -w use DBD::Pg; use Encode; if ($#ARGV < 3) { print "Il faut 4 arguments !\n"; exit 1; } my $jours = $ARGV[0]; my $activite = $ARGV[1]; my $pdf = $ARGV[2]; my $raison = $ARGV[3]; my $noexecute = undef; $noexecute = $ARGV[4] if defined($ARGV[4]); my $dbname = "HIDE"; my $host = "HIDE"; my $username = "HIDE"; my $password = "HIDE"; my $dbh = DBI->connect("dbi:Pg:dbname=$dbname; host=$host", "$username", "$password", {AutoCommit => 1}) or die ("Impossible de se connecter à la base !\n"); my $sth = $dbh->prepare("SELECT DISTINCT \"info_IDS\",societe,fax FROM fax_whitelist WHERE (date IS NULL OR date < (timenow() - interval ?)) AND (activite LIKE?) ") or die("Impossible de preparer les requetes !\n"); my $sth2 = $dbh->prepare("INSERT INTO actions_fax (\"info_IDS\",date,commentaire) VALUES (?,now(),?)"); $sth->execute("$jours days",encode("Latin1", $activite)); for (my $i=0; $i<$sth->rows; $i++) { my @result = $sth->fetchrow_array; my $commande="sendfax -i\"$raison\" -F\"Pour $result[1]|%c|Page %%P sur %%T\" -Plow -sa4 -n -N -T\"3\" -k\"now +72 hours\" -d\"$result[2]\" $pdf"; print $commande, "\n"; $sth2->execute($result[0],"Raison: $raison\nFax: $pdf") if not defined $noexecute; } Well, any idea ? It work fine with the version 1.32_1 Ok see ya Vincent Bachelier System: FreeBSD-5.3-RELEASE - AMD64 Découvrez le nouveau Yahoo! Mail : 250 Mo d'espace de stockage pour vos mails ! Créez votre Yahoo! Mail sur http://fr.mail.yahoo.com/ From owner-freebsd-perl@FreeBSD.ORG Tue Mar 8 10:41:59 2005 Return-Path: Delivered-To: freebsd-perl@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 1403B16A4CE for ; Tue, 8 Mar 2005 10:41:59 +0000 (GMT) Received: from plouf.absolight.net (plouf.absolight.net [193.30.224.136]) by mx1.FreeBSD.org (Postfix) with ESMTP id CB8FB43D41 for ; Tue, 8 Mar 2005 10:41:58 +0000 (GMT) (envelope-from mat@FreeBSD.org) Received: from pouet.in.mat.cc (pouet.in.mat.cc [193.30.224.122]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client did not present a certificate) by plouf.absolight.net (Postfix) with ESMTP id DF690A2400E; Tue, 8 Mar 2005 11:41:56 +0100 (CET) Date: Tue, 08 Mar 2005 11:41:51 +0100 From: Mathieu Arnold To: Vincent Bachelier , perl@freebsd.org Message-ID: <2CC5E3844B16ED89C0991035@[192.168.1.5]> In-Reply-To: <20050308074451.90940.qmail@web25308.mail.ukl.yahoo.com> References: <20050308074451.90940.qmail@web25308.mail.ukl.yahoo.com> X-Mailer: Mulberry/4.0.0a5 (Win32) MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Subject: Re: p5-DBD-Pg X-BeenThere: freebsd-perl@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: maintainer of a number of perl-related ports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 08 Mar 2005 10:41:59 -0000 +-Le 08/03/2005 08:44 +0100, Vincent Bachelier a dit : | Well, here the error message: | DBD::Pg::st execute failed: ERREUR: syntax error sur | ou pr=C3=A8s de =C2=AB$1=C2=BB at character 111 Well, the best you could do would be to enable logging on your postgresql server, and see what query exactly fails. Plus, you could tell us which postgresql version you have :-) --=20 Mathieu Arnold From owner-freebsd-perl@FreeBSD.ORG Tue Mar 8 12:39:27 2005 Return-Path: Delivered-To: freebsd-perl@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 3213516A4CE for ; Tue, 8 Mar 2005 12:39:27 +0000 (GMT) Received: from plouf.absolight.net (plouf.absolight.net [193.30.224.136]) by mx1.FreeBSD.org (Postfix) with ESMTP id 89B6443D41 for ; Tue, 8 Mar 2005 12:39:26 +0000 (GMT) (envelope-from mat@FreeBSD.org) Received: from pouet.in.mat.cc (pouet.in.mat.cc [193.30.224.122]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client did not present a certificate) by plouf.absolight.net (Postfix) with ESMTP id D583DA24056 for ; Tue, 8 Mar 2005 13:39:24 +0100 (CET) Received: from plouf.absolight.net ([unix socket]) by plouf.absolight.net (Cyrus v2.2.10) with LMTPA; Tue, 08 Mar 2005 13:32:05 +0100 X-Sieve: CMU Sieve 2.2 X-Original-To: m+freebsd@absolight.fr Received: from mx2.freebsd.org (mx2.freebsd.org [216.136.204.119]) by plouf.absolight.net (Postfix) with ESMTP id CCFABA24070 for ; Tue, 8 Mar 2005 13:32:01 +0100 (CET) Received: from hub.freebsd.org (hub.freebsd.org [216.136.204.18]) by mx2.freebsd.org (Postfix) with ESMTP id B74DD558FA for ; Tue, 8 Mar 2005 12:32:00 +0000 (GMT) (envelope-from vincent@localhost.free.fr) Received: by hub.freebsd.org (Postfix) id B3FC016A4CF; Tue, 8 Mar 2005 12:32:00 +0000 (GMT) Delivered-To: mat@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 8210E16A4CE for ; Tue, 8 Mar 2005 12:32:00 +0000 (GMT) Received: from postfix3-2.free.fr (postfix3-2.free.fr [213.228.0.169]) by mx1.FreeBSD.org (Postfix) with ESMTP id 349A843D31 for ; Tue, 8 Mar 2005 12:32:00 +0000 (GMT) (envelope-from vincent@localhost.free.fr) Received: from vincent (ferreol-1-82-66-171-150.fbx.proxad.net [82.66.171.150]) by postfix3-2.free.fr (Postfix) with ESMTP id 3181DC143 for ; Tue, 8 Mar 2005 13:31:59 +0100 (CET) Received: by vincent (Postfix, from userid 1001) id 50B34C99A6; Tue, 8 Mar 2005 13:31:57 +0100 (CET) Date: Tue, 8 Mar 2005 13:31:57 +0100 From: Vincent Bachelier To: Mathieu Arnold Message-ID: <20050308123157.GA975@localhost> References: <20050308074451.90940.qmail@web25308.mail.ukl.yahoo.com> <2CC5E3844B16ED89C0991035@[192.168.1.5]> In-Reply-To: <2CC5E3844B16ED89C0991035@[192.168.1.5]> User-Agent: Mutt/1.4.2.1i X-Operating-System: FreeBSD vincent 5.4-PRERELEASE FreeBSD 5.4-PRERELEASE X-Spam-Checker-Version: SpamAssassin 2.64-abso_2004101500 (2004-01-11) on plouf.absolight.net by root@absolight.fr X-Virus-Scanned: by amavisd-new at plouf.absolight.net X-Spam-Status: No, hits=-4.887 tagged_above=-10 required=5 tests=AWL, BAYES_00 X-Spam-Level: Resent-Date: Tue, 08 Mar 2005 13:39:20 +0100 Resent-From: Mathieu Arnold Resent-To: perl@freebsd.org Resent-Message-ID: X-Resent-Mailer: Mulberry/4.0.0a5 (Win32) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Content-Disposition: inline Subject: Re: p5-DBD-Pg X-BeenThere: freebsd-perl@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: maintainer of a number of perl-related ports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 08 Mar 2005 12:39:27 -0000 Well, the postgresql version is the one of Debian Sarge ... 7.4.7-2 The error occur under DBD::Pg::St ... I will try it on FreeBSD server locally Get more info soon ... Strange old version work well ... Le Tue, Mar 08, 2005 at 11:41:51AM +0100, Mathieu Arnold a écrit: > Date: Tue, 08 Mar 2005 11:41:51 +0100 > From: Mathieu Arnold > To: Vincent Bachelier , perl@freebsd.org > Subject: Re: p5-DBD-Pg > X-Mailer: Mulberry/4.0.0a5 (Win32) > > +-Le 08/03/2005 08:44 +0100, Vincent Bachelier a dit : > | Well, here the error message: > | DBD::Pg::st execute failed: ERREUR: syntax error sur > | ou près de «$1» at character 111 > > Well, the best you could do would be to enable logging on your postgresql > server, and see what query exactly fails. Plus, you could tell us which > postgresql version you have :-) > > -- > Mathieu Arnold -- Vincent Bachelier Language : Francais / English Societ(e/y) : Solintech - http://www.solintech.fr - Serveurs linux Blog : http://dieghostfbsd.blogspot.com Site perso : http://www.solintech.fr/freebsd/ - FreeBSD Donjon Citation (fortune): The last good thing written in C was Franz Schubert's Symphony No. 9. -- Werner Trobin From owner-freebsd-perl@FreeBSD.ORG Tue Mar 8 12:40:24 2005 Return-Path: Delivered-To: freebsd-perl@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 1C32416A4CE for ; Tue, 8 Mar 2005 12:40:24 +0000 (GMT) Received: from plouf.absolight.net (plouf.absolight.net [193.30.224.136]) by mx1.FreeBSD.org (Postfix) with ESMTP id CFFAC43D46 for ; Tue, 8 Mar 2005 12:40:23 +0000 (GMT) (envelope-from mat@FreeBSD.org) Received: from pouet.in.mat.cc (pouet.in.mat.cc [193.30.224.122]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client did not present a certificate) by plouf.absolight.net (Postfix) with ESMTP id 6C637A24065; Tue, 8 Mar 2005 13:40:21 +0100 (CET) Date: Tue, 08 Mar 2005 13:40:17 +0100 From: Mathieu Arnold To: Vincent Bachelier Message-ID: In-Reply-To: <20050308123157.GA975@localhost> References: <20050308074451.90940.qmail@web25308.mail.ukl.yahoo.com> <2CC5E3844B16ED89C0991035@[192.168.1.5]> <20050308123157.GA975@localhost> X-Mailer: Mulberry/4.0.0a5 (Win32) MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline cc: perl@FreeBSD.org Subject: Re: p5-DBD-Pg X-BeenThere: freebsd-perl@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: maintainer of a number of perl-related ports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 08 Mar 2005 12:40:24 -0000 +-Le 08/03/2005 13:31 +0100, Vincent Bachelier a dit : | Le Tue, Mar 08, 2005 at 11:41:51AM +0100, Mathieu Arnold a =C3=A9crit: |> From: Mathieu Arnold |> +-Le 08/03/2005 08:44 +0100, Vincent Bachelier a dit : |> | Well, here the error message: |> | DBD::Pg::st execute failed: ERREUR: syntax error sur |> | ou pr=C3=A8s de =C2=AB$1=C2=BB at character 111 |>=20 |> Well, the best you could do would be to enable logging on your = postgresql |> server, and see what query exactly fails. Plus, you could tell us which |> postgresql version you have :-) | Well, the postgresql version is the one of Debian Sarge ... 7.4.7-2 | The error occur under DBD::Pg::St ... | I will try it on FreeBSD server locally | Get more info soon ... | Strange old version work well ... As I said, enabling logging on your server will show the offending query = :-) --=20 Mathieu Arnold From owner-freebsd-perl@FreeBSD.ORG Tue Mar 8 13:46:07 2005 Return-Path: Delivered-To: freebsd-perl@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 4472616A4CE for ; Tue, 8 Mar 2005 13:46:07 +0000 (GMT) Received: from black.imgsrc.co.jp (black.imgsrc.co.jp [210.226.20.147]) by mx1.FreeBSD.org (Postfix) with ESMTP id 8441543D39 for ; Tue, 8 Mar 2005 13:46:06 +0000 (GMT) (envelope-from kuriyama@imgsrc.co.jp) Received: from localhost (localhost [127.0.0.1]) by black.imgsrc.co.jp (Postfix) with ESMTP id 4BD6F50CA5; Tue, 8 Mar 2005 22:46:05 +0900 (JST) Received: from black.imgsrc.co.jp (black.imgsrc.co.jp [IPv6:2001:218:422:2::9999]) by black.imgsrc.co.jp (Postfix) with ESMTP id A459650CB7; Tue, 8 Mar 2005 22:46:03 +0900 (JST) Date: Tue, 08 Mar 2005 22:46:03 +0900 Message-ID: <7moedumesk.wl%kuriyama@imgsrc.co.jp> From: Jun Kuriyama To: Vincent Bachelier In-Reply-To: <20050308123157.GA975@localhost> References: <20050308074451.90940.qmail@web25308.mail.ukl.yahoo.com> <2CC5E3844B16ED89C0991035@192.168.1.5> <20050308123157.GA975@localhost> User-Agent: Wanderlust/2.12.0 (Your Wildest Dreams) SEMI/1.14.6 (Maruoka) FLIM/1.14.7 (=?ISO-8859-4?Q?Sanj=F2?=) APEL/10.6 Emacs/21.3 (i386--freebsd) MULE/5.0 (SAKAKI) MIME-Version: 1.0 (generated by SEMI 1.14.6 - "Maruoka") Content-Type: text/plain; charset=US-ASCII X-Virus-Scanned: by amavisd 0.1 cc: perl@FreeBSD.org Subject: Re: p5-DBD-Pg X-BeenThere: freebsd-perl@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: maintainer of a number of perl-related ports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 08 Mar 2005 13:46:07 -0000 My patch was wrong. Original developers are working on this problem. Can you try with this? Index: Makefile =================================================================== RCS file: /home/ncvs/ports/databases/p5-DBD-Pg/Makefile,v retrieving revision 1.61 diff -u -r1.61 Makefile --- Makefile 2 Mar 2005 18:18:57 -0000 1.61 +++ Makefile 6 Mar 2005 13:27:57 -0000 @@ -7,6 +7,7 @@ PORTNAME= DBD-Pg PORTVERSION= 1.40 +PORTREVISION= 1 CATEGORIES= databases perl5 MASTER_SITES= ${MASTER_SITE_PERL_CPAN} MASTER_SITE_SUBDIR= DBD Index: files/patch-dbdimp.c =================================================================== RCS file: files/patch-dbdimp.c diff -N files/patch-dbdimp.c --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ files/patch-dbdimp.c 8 Mar 2005 13:42:45 -0000 @@ -0,0 +1,42 @@ +--- dbdimp.c.orig Tue Mar 8 22:41:12 2005 ++++ dbdimp.c Tue Mar 8 22:41:36 2005 +@@ -1,6 +1,6 @@ + /* + +- $Id: dbdimp.c,v 1.98 2005/01/29 18:53:52 turnstep Exp $ ++ $Id: dbdimp.c,v 1.99 2005/03/07 23:40:45 turnstep Exp $ + + Copyright (c) 2002-2005 PostgreSQL Global Development Group + Portions Copyright (c) 2002 Jeffrey W. Baker +@@ -793,7 +793,7 @@ + 2. The attribute "direct" is false + 3. We can handle server-side prepares + 4. The attribute "pg_server_prepare" is not 0 +- 5. The attribute "pg_prepare_now" is true ++ 5. The attribute "pg_prepare_now" is true and we are a PG8 or up compiled server + */ + if (imp_sth->is_dml && + !imp_sth->direct && +@@ -1517,7 +1517,9 @@ + execsize = imp_sth->totalsize; /* Total of all segments */ + + /* If using plain old PQexec, we need to quote each value ourselves */ +- if (imp_dbh->pg_protocol < 3) { ++ if (imp_dbh->pg_protocol < 3 || ++ (1 != imp_sth->server_prepare && ++ imp_sth->numbound != imp_sth->numphs)) { + for (currph=imp_sth->ph; NULL != currph; currph=currph->nextph) { + if (NULL == currph->value) { + Renew(currph->quoted, 5, char); /* freed in dbd_st_execute (and above) */ +@@ -1628,7 +1630,10 @@ + + /* PQexecParams */ + +- if (imp_dbh->pg_protocol >= 3 && imp_sth->numphs) { ++ if (imp_dbh->pg_protocol >= 3 && ++ imp_sth->numphs && ++ (1 == imp_sth->server_prepare || ++ imp_sth->numbound == imp_sth->numphs)) { + + if (dbis->debug >= 5) + PerlIO_printf(DBILOGFP, " dbdpg: using PQexecParams\n"); -- Jun Kuriyama // IMG SRC, Inc. // FreeBSD Project From owner-freebsd-perl@FreeBSD.ORG Wed Mar 9 07:50:48 2005 Return-Path: Delivered-To: freebsd-perl@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 0D8F516A4CE for ; Wed, 9 Mar 2005 07:50:48 +0000 (GMT) Received: from postfix3-1.free.fr (postfix3-1.free.fr [213.228.0.44]) by mx1.FreeBSD.org (Postfix) with ESMTP id 75A3B43D3F for ; Wed, 9 Mar 2005 07:50:47 +0000 (GMT) (envelope-from vincent@localhost.free.fr) Received: from vincent (ferreol-1-82-66-171-150.fbx.proxad.net [82.66.171.150]) by postfix3-1.free.fr (Postfix) with ESMTP id 3B5BD1734D2; Wed, 9 Mar 2005 08:50:44 +0100 (CET) Received: by vincent (Postfix, from userid 1001) id BC09FC99A6; Wed, 9 Mar 2005 08:50:39 +0100 (CET) Date: Wed, 9 Mar 2005 08:50:39 +0100 From: Vincent Bachelier To: Jun Kuriyama Message-ID: <20050309075039.GA73150@localhost> References: <20050308074451.90940.qmail@web25308.mail.ukl.yahoo.com> <2CC5E3844B16ED89C0991035@192.168.1.5> <20050308123157.GA975@localhost> <7moedumesk.wl%kuriyama@imgsrc.co.jp> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <7moedumesk.wl%kuriyama@imgsrc.co.jp> User-Agent: Mutt/1.4.2.1i X-Operating-System: FreeBSD vincent 5.4-PRERELEASE FreeBSD 5.4-PRERELEASE cc: perl@freebsd.org Subject: Re: p5-DBD-Pg X-BeenThere: freebsd-perl@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: maintainer of a number of perl-related ports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 09 Mar 2005 07:50:48 -0000 Ok, I have try your patch now it work well thx a lot hope this patch will be send to author and include under ports see ya Le Tue, Mar 08, 2005 at 10:46:03PM +0900, Jun Kuriyama a écrit: > Date: Tue, 08 Mar 2005 22:46:03 +0900 > From: Jun Kuriyama > To: Vincent Bachelier > Cc: perl@FreeBSD.org > Subject: Re: p5-DBD-Pg > User-Agent: Wanderlust/2.12.0 (Your Wildest Dreams) SEMI/1.14.6 (Maruoka) > FLIM/1.14.7 (Sanj?) APEL/10.6 Emacs/21.3 (i386--freebsd) > MULE/5.0 (SAKAKI) > > > My patch was wrong. Original developers are working on this problem. > > Can you try with this? > > > Index: Makefile > =================================================================== > RCS file: /home/ncvs/ports/databases/p5-DBD-Pg/Makefile,v > retrieving revision 1.61 > diff -u -r1.61 Makefile > --- Makefile 2 Mar 2005 18:18:57 -0000 1.61 > +++ Makefile 6 Mar 2005 13:27:57 -0000 > @@ -7,6 +7,7 @@ > > PORTNAME= DBD-Pg > PORTVERSION= 1.40 > +PORTREVISION= 1 > CATEGORIES= databases perl5 > MASTER_SITES= ${MASTER_SITE_PERL_CPAN} > MASTER_SITE_SUBDIR= DBD > Index: files/patch-dbdimp.c > =================================================================== > RCS file: files/patch-dbdimp.c > diff -N files/patch-dbdimp.c > --- /dev/null 1 Jan 1970 00:00:00 -0000 > +++ files/patch-dbdimp.c 8 Mar 2005 13:42:45 -0000 > @@ -0,0 +1,42 @@ > +--- dbdimp.c.orig Tue Mar 8 22:41:12 2005 > ++++ dbdimp.c Tue Mar 8 22:41:36 2005 > +@@ -1,6 +1,6 @@ > + /* > + > +- $Id: dbdimp.c,v 1.98 2005/01/29 18:53:52 turnstep Exp $ > ++ $Id: dbdimp.c,v 1.99 2005/03/07 23:40:45 turnstep Exp $ > + > + Copyright (c) 2002-2005 PostgreSQL Global Development Group > + Portions Copyright (c) 2002 Jeffrey W. Baker > +@@ -793,7 +793,7 @@ > + 2. The attribute "direct" is false > + 3. We can handle server-side prepares > + 4. The attribute "pg_server_prepare" is not 0 > +- 5. The attribute "pg_prepare_now" is true > ++ 5. The attribute "pg_prepare_now" is true and we are a PG8 or up compiled server > + */ > + if (imp_sth->is_dml && > + !imp_sth->direct && > +@@ -1517,7 +1517,9 @@ > + execsize = imp_sth->totalsize; /* Total of all segments */ > + > + /* If using plain old PQexec, we need to quote each value ourselves */ > +- if (imp_dbh->pg_protocol < 3) { > ++ if (imp_dbh->pg_protocol < 3 || > ++ (1 != imp_sth->server_prepare && > ++ imp_sth->numbound != imp_sth->numphs)) { > + for (currph=imp_sth->ph; NULL != currph; currph=currph->nextph) { > + if (NULL == currph->value) { > + Renew(currph->quoted, 5, char); /* freed in dbd_st_execute (and above) */ > +@@ -1628,7 +1630,10 @@ > + > + /* PQexecParams */ > + > +- if (imp_dbh->pg_protocol >= 3 && imp_sth->numphs) { > ++ if (imp_dbh->pg_protocol >= 3 && > ++ imp_sth->numphs && > ++ (1 == imp_sth->server_prepare || > ++ imp_sth->numbound == imp_sth->numphs)) { > + > + if (dbis->debug >= 5) > + PerlIO_printf(DBILOGFP, " dbdpg: using PQexecParams\n"); > > > -- > Jun Kuriyama // IMG SRC, Inc. > // FreeBSD Project -- Vincent Bachelier Language : Francais / English Societ(e/y) : Solintech - http://www.solintech.fr - Serveurs linux Blog : http://dieghostfbsd.blogspot.com Site perso : http://www.solintech.fr/freebsd/ - FreeBSD Donjon Citation (fortune): "I want to buy a husband who, every week when I sit down to watch `St. Elsewhere', won't scream, `FORGET IT, BLANCHE ... IT'S TIME FOR "HEE HAW"!!'" -- Berke Breathed, "Bloom County" From owner-freebsd-perl@FreeBSD.ORG Fri Mar 11 16:45:42 2005 Return-Path: Delivered-To: freebsd-perl@hub.freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 9745A16A4CE; Fri, 11 Mar 2005 16:45:42 +0000 (GMT) Received: from freefall.freebsd.org (freefall.freebsd.org [216.136.204.21]) by mx1.FreeBSD.org (Postfix) with ESMTP id 709F243D2D; Fri, 11 Mar 2005 16:45:42 +0000 (GMT) (envelope-from vs@FreeBSD.org) Received: from freefall.freebsd.org (vs@localhost [127.0.0.1]) by freefall.freebsd.org (8.13.3/8.13.3) with ESMTP id j2BGjgvu003002; Fri, 11 Mar 2005 16:45:42 GMT (envelope-from vs@freefall.freebsd.org) Received: (from vs@localhost) by freefall.freebsd.org (8.13.3/8.13.1/Submit) id j2BGjgMr002998; Fri, 11 Mar 2005 16:45:42 GMT (envelope-from vs) Date: Fri, 11 Mar 2005 16:45:42 GMT From: Volker Stolz Message-Id: <200503111645.j2BGjgMr002998@freefall.freebsd.org> To: vs@FreeBSD.org, freebsd-ports-bugs@FreeBSD.org, freebsd-perl@FreeBSD.org Subject: Re: ports/78700: sa-spamd script does not play well with spamd "-u" flag X-BeenThere: freebsd-perl@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: maintainer of a number of perl-related ports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 11 Mar 2005 16:45:42 -0000 Synopsis: sa-spamd script does not play well with spamd "-u" flag Responsible-Changed-From-To: freebsd-ports-bugs->freebsd-perl Responsible-Changed-By: vs Responsible-Changed-When: Fri Mar 11 16:45:02 GMT 2005 Responsible-Changed-Why: Over to maintainers http://www.freebsd.org/cgi/query-pr.cgi?pr=78700