From Bugzilla Helper: User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.2.1) Gecko/20021130 Description of problem: pgAdminII (http://pgadmin.postgresql.org) is the preferred Windows client application for connecting to PostgreSQL servers. When connecting to RH's version of PostgreSQL 7.3, pgAdmin crashes. Version-Release number of selected component (if applicable): 7.3-2 and higher. How reproducible: Always Steps to Reproduce: 1. start RH's PostgreSQL 7.3 on server 2. start pgAdminII on client 3. connect to server Actual Results: pgAdminII crashes Expected Results: pgAdminII should continue to operate, obviously. :) Additional info: - pgAdminII (hereafter referred to as pgAdm) fully interoperates with PostgreSQL (pgSQL) 7.2, either RedHat or PGDG (PostgreSQL Global Development Group) RPM versions. - pgAdm also works with the RPM's compiled by PGDG (for RedHat 8.0). - pgAdm crashes with RedHat's RawHide pgSQL version (7.3-2) on a RHL 8.0 platform, and it crashes with 7.3-6 on RHL 8.0.92 (this bug report). - I recompiled RawHide 7.3-2 on a stock RHL 8.0, and pgAdm connects just fine. I suspect there is a component in the latest build environnments (glibc ?) which causes incompatibilities with pgAdm, as a recompiled 7.3 on RHL 8.0 works just fine. Please inform me of any extensive logs to be produced, which could be helpful in tracing the culprit.
Out of curiosity, if you add the Windows client IP address to a /etc/hosts entry does it work?
Comment #1 : no, adding IP addresses doesn't make a difference (no resolver issue, I guess). I'll try to add some DEBUG logs from both PostgreSQL 7.2.x and 7.3 later today.
In attachment, four logs. A/ Two logs per server config : - a standard psql connection ('psql template1 -U postgres) from the localhost, for comparative purposes ; - a pgAdminII connection, from a VMWare Win2K client. The Windows client has been tested with combinations of WinMe/Win2K/WinXP, pgAdminII 1.4.0/1.4.12, psqlODBC 7.2.x/7.2.5. B/ Two server configs : - Phoebe (P-200, 64MB), with the latest pre-compiled PostgreSQL 7.3-6 RPM ; - RH8 (P3-1200, 768MB), with a recompiled PostgreSQL 7.3-2 SRPM (as the original RawHide pre-compiled 7.3-2 RPM fails too). As you can see, the pre-compiled connection fails, where the recompiled one runs forth. Anything else I can do to trace the problem ?
Created attachment 88915 [details] RH8 - psql connection All logs are DEBUG5 level.
Created attachment 88916 [details] RH8 - Successful pgAdminII connection
Created attachment 88917 [details] Phoebe - psql connection
Created attachment 88918 [details] Phoebe - Failed pgAdminII connection
Initial testing in pgAdmin is pointing to an incompatibility with Microsoft's MDAC or psqlODBC and the Redhat build of PostgreSQL causing this bug, rather than pgAdmin itself. I will post further test results once I have access to a Redhat system to reproduce it in a debugger. Dave (pgAdmin lead developer).
This is caused by a buffer overflow in psqlODBC's SQLGetInfo function (info.c) for SQL_DBMS_VER calls. The overlength string in this case is: 07.02.0005 PostgreSQL 7.3 on i386-redhat-linux-gnu, compiled by GCC i386- redhat-linux-gcc (GCC) 3.2.1 20021207 (Red Hat Linux 8.0 3.2.1-2) I have increased MAX_INFO_STRING to 256 in psqlodbc.h for the time being. The fix will be in the next release of psqlODBC.