0002105: phpPgAdmin not working with quercus

Viewing Issue Simple Details [ Jump to Notes ]

[ View Advanced ] [ Issue History ] [ Print ]

Category

Severity

Reproducibility

Date Submitted

Last Update

0002105

[Quercus]

major

always

10-22-07 14:01

11-14-07 19:33

Reporter

rickburque

View Status

public

Assigned To

Priority

normal

Resolution

fixed

Status

closed

Product Version

3.1.3

Summary

0002105: phpPgAdmin not working with quercus

Description

I can connect to a postgresql database directly using unmodified php code in quercus (pg_connect working fine).

However when I attempt to run phpPgAdmin, the phpPgAdmin web page comes up I get a server error:

SQL error:
The server's client_encoding parameter was changed to UTF8. The JDBC driver requires client_encoding to be UNICODE for correct operation.

In statement:
SET CLIENT_ENCODING TO 'UTF8'

Failed to set client encoding in database.

The above errors are displayed directly on the webpage. I greped the phpPgAdmin php files for UTF8 and ENCODING but got no hits, leading me to thinkl that the errors are coming from quercus.

phpPgAdmin does not show up on your "known to work" php applications so I am wondering is this a known problem? Or am I the first one to try this?

Additional Information

phpPgadmin is working fine from standard apache mod_php.

Attached Files

Relationships

Notes
(0002493) mo 11-14-07 19:31	The attached patch fixes this problem.

(0002494) mo 11-14-07 19:33	Added test cases: php/437c.qa php/437d.qa

Issue History
Date Modified	Username	Field	Change
10-22-07 14:01	rickburque	New Issue
11-13-07 14:15	mo	Status	new => assigned
11-13-07 14:15	mo	Assigned To	=> mo
11-14-07 19:31	mo	Note Added: 0002493
11-14-07 19:33	mo	Status	assigned => closed
11-14-07 19:33	mo	Note Added: 0002494
11-14-07 19:33	mo	Resolution	open => fixed
11-14-07 19:33	mo	Fixed in Version	=> 3.1.4
12-12-07 10:01	extremia	Issue Monitored: extremia

Mantis 1.0.0rc3[^]

33 total queries executed.
28 unique queries executed.