Thread: Re: PostgreSQL 7.3/RH 9/PGAdmin Not a good combo?
Hi Jim, This is a bug caused by a very long string in the RedHat build of PostgreSQL that overflows a buff in the ODBC driver. Please try the snapshot driver from http://www.geocities.jp/inocchichichi/psqlodbc/ Regards, Dave. > -----Original Message----- > From: Jim Hines [mailto:jhines@wdtv.com] > Sent: 03 April 2003 17:16 > To: pgadmin-support@postgresql.org > Subject: [pgadmin-support] PostgreSQL 7.3/RH 9/PGAdmin Not a > good combo? > > > Hi all, > Yesterday, I upgraded my db server to RH9, and as usual with > RH updates, it > did not go smoothly. After several hours of 'tweaking', I finally got > everything working again, except now pgadmin crashes whenever > connecting to > the database. This happens on every client machine. Here is > the log from one > of them. > > > > 2003-04-03 10:57:35 - SQL (template1): SELECT version() > 2003-04-03 10:57:35 - SQL (template1): SELECT datlastsysoid > FROM pg_database > WHERE datname = 'template1' > > 2003-04-03 10:57:35 - > ******************************************************************* > 2003-04-03 10:57:35 - Error(s) > 2003-04-03 10:57:35 - > ******************************************************************* > 2003-04-03 10:57:35 - Error in pgAdmin > II:frmConnect.cmdConnect_Click: > -2147417848 - Automation error > The object invoked has disconnected from its clients. > > 2003-04-03 10:57:35 - Windows Version: Windows 2000 v5.0 > build 2195 Service > Pack 2 > 2003-04-03 10:57:35 - pgSchema Version: 1.4.12 > 2003 > > > Does anyone have any idea what this means or how to correct > it? Please help! > > Thanks, > > -- > Jim Hines > IT Mgr, WDTV NewsChannel 5 > Your Hometown News > > TEL:304.848.5000 > FAX:304.842.7501 > <http://www.wdtv.com> > <jhines@wdtv.com> > > WDTV NewsChannel 5 is a CBS Affiliate > > > This email is confidential. If you received it in error, > please delete it, do > not use or disclose the information in any way and notify me > of the error. > The contents of this email may contain personal views, which > are not the > views of Withers Broadcasting unless otherwise stated. > > > ---------------------------(end of > broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > http://www.postgresql.org/docs/faqs/FAQ.html
On Thursday 03 April 2003 01:47 pm, Dave Page wrote: > Hi Jim, > > This is a bug caused by a very long string in the RedHat build of > PostgreSQL that overflows a buff in the ODBC driver. > > Please try the snapshot driver from > http://www.geocities.jp/inocchichichi/psqlodbc/ If I would remove the Redhat build and put in the RPMs from the Postgresql.org site, would that fix this issue as well? -- Jim Hines IT Mgr, WDTV NewsChannel 5 Your Hometown News TEL:304.848.5000 FAX:304.842.7501 <http://www.wdtv.com> <jhines@wdtv.com> WDTV NewsChannel 5 is a CBS Affiliate This email is confidential. If you received it in error, please delete it, do not use or disclose the information in any way and notify me of the error. The contents of this email may contain personal views, which are not the views of Withers Broadcasting unless otherwise stated.
> -----Original Message----- > From: Jim Hines [mailto:jhines@wdtv.com] > Sent: 03 April 2003 20:05 > To: Dave Page; pgadmin-support@postgresql.org > Subject: Re: [pgadmin-support] PostgreSQL 7.3/RH 9/PGAdmin > Not a good combo? > > > On Thursday 03 April 2003 01:47 pm, Dave Page wrote: > > Hi Jim, > > > > This is a bug caused by a very long string in the RedHat build of > > PostgreSQL that overflows a buff in the ODBC driver. > > > > Please try the snapshot driver from > > http://www.geocities.jp/inocchichichi/psqlodbc/ > > If I would remove the Redhat build and put in the RPMs from > the Postgresql.org > site, would that fix this issue as well? Depends if they were built on Redhat 9 because the error comes from the long gcc version string that PostgreSQL includes in it's version string. Regards, Dave.
> > > This is a bug caused by a very long string in the RedHat build of > > > PostgreSQL that overflows a buff in the ODBC driver. > > > > > > Please try the snapshot driver from > > > http://www.geocities.jp/inocchichichi/psqlodbc/ > > > > If I would remove the Redhat build and put in the RPMs from > > the Postgresql.org > > site, would that fix this issue as well? > > Depends if they were built on Redhat 9 because the error comes from the > long gcc version string that PostgreSQL includes in it's version string. I think I will try this with RH8.0 RPM builds. I cannot seem to make the beta ODBC driver work any better. It behaves identically. I went to "Connection Debugging Tools/ODBC connect" , chose the new PGSQLODBC30 DSN I created, and viola, it did the same thing. :( Thanks, -- Jim Hines IT Mgr, WDTV NewsChannel 5 Your Hometown News TEL:304.848.5000 FAX:304.842.7501 <http://www.wdtv.com> <jhines@wdtv.com> WDTV NewsChannel 5 is a CBS Affiliate This email is confidential. If you received it in error, please delete it, do not use or disclose the information in any way and notify me of the error. The contents of this email may contain personal views, which are not the views of Withers Broadcasting unless otherwise stated.
On Thursday 03 April 2003 14:21, Jim Hines wrote: > > Depends if they were built on Redhat 9 because the error comes from the > > long gcc version string that PostgreSQL includes in it's version string. > I think I will try this with RH8.0 RPM builds. I cannot seem to make the > beta ODBC driver work any better. It behaves identically. I went to > "Connection Debugging Tools/ODBC connect" , chose the new PGSQLODBC30 DSN I > created, and viola, it did the same thing. :( It probably won't help, since: [lowen@localhost lowen]$ gcc --version gcc (GCC) 3.2.2 20030222 (Red Hat Linux 3.2.2-5) Copyright (C) 2002 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. [lowen@localhost lowen]$ cat /etc/redhat-release Red Hat Linux release 9 (Shrike) [lowen@localhost lowen]$ ssh server.localdomain [lowen@server lowen]$ gcc --version gcc (GCC) 3.2 20020903 (Red Hat Linux 8.0 3.2-7) Copyright (C) 2002 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. [lowen@server lowen]$ cat /etc/redhat-release Red Hat Linux release 8.0 (Psyche) [lowen@server lowen]$ (server.localdomain is a real, publicly visible machine whose identity has been masked for security reasons.) Contrasted to: [lowen@dev lowen]$ gcc --version 2.96 [lowen@dev lowen]$ cat /etc/redhat-release Aurora SPARC Project release 0.42 (Douglas) Based on Red Hat Linux 7.X [lowen@dev lowen]$ Dev is not publicly visible, and is an Ultra 5 running Aurora 0.42, which is almost the same thing as (the fictional, not real) Red Hat 7.3 for SPARC (with updates). This will break from-source builds, too, so it isn't an RPM-specific problem, AFAICT. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11
Dave, I got the snapshot driver working correctly. I had not put it in the right place. You're right. What a freaking version string!!! How do I make PGAdmin use this driver by default? It still wants to the standard one on normal connects. Should I just rename the .dll and drop the 30 from the name? -- Jim Hines IT Mgr, WDTV NewsChannel 5 Your Hometown News TEL:304.848.5000 FAX:304.842.7501 <http://www.wdtv.com> <jhines@wdtv.com> WDTV NewsChannel 5 is a CBS Affiliate This email is confidential. If you received it in error, please delete it, do not use or disclose the information in any way and notify me of the error. The contents of this email may contain personal views, which are not the views of Withers Broadcasting unless otherwise stated.
> How do I make PGAdmin use this driver by default? It still wants to the > standard one on normal connects. Should I just rename the .dll and drop the > 30 from the name? I went ahead and tried the rename of the psqlodbc30.dll to psqlodbc.dll.....and it worked! Thanks much for all the help. Problem finally solved....now onto the next problem (non-psql) RH9 has left me with. Jim Hines IT Mgr, WDTV NewsChannel 5 Your Hometown News TEL:304.848.5000 FAX:304.842.7501 <http://www.wdtv.com> <jhines@wdtv.com> WDTV NewsChannel 5 is a CBS Affiliate This email is confidential. If you received it in error, please delete it, do not use or disclose the information in any way and notify me of the error. The contents of this email may contain personal views, which are not the views of Withers Broadcasting unless otherwise stated.
> -----Original Message----- > From: Jim Hines [mailto:jhines@wdtv.com] > Sent: 03 April 2003 20:55 > To: pgadmin-support@postgresql.org > Subject: Re: [pgadmin-support] PostgreSQL 7.3/RH 9/PGAdmin > Not a good combo? > > > > > How do I make PGAdmin use this driver by default? It still wants to > > the standard one on normal connects. Should I just rename > the .dll and > > drop the 30 from the name? > > I went ahead and tried the rename of the psqlodbc30.dll to > psqlodbc.dll.....and it worked! Thanks much for all the help. > Problem finally solved....now onto the next problem > (non-psql) RH9 has left me > with. Glad it's working - have fun! Regards, Dave.
> -----Original Message----- > From: Lamar Owen [mailto:lamar.owen@wgcr.org] > Sent: 03 April 2003 20:38 > To: Jim Hines; Dave Page; pgadmin-support@postgresql.org > Subject: Re: [pgadmin-support] PostgreSQL 7.3/RH 9/PGAdmin > Not a good combo? > > > This will break from-source builds, too, so it isn't an > RPM-specific problem, > AFAICT. Hi Lamar, It does appear to have started sometime just after Redhat 8 (and yes, source builds would also be affected). This problem was logged with Redhat here https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=80394 So no, there's nothing wrong with your RPMs :-) Regards, Dave.