<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>
Thomas,<br><br>That did it! I had tried removing the single quotes from the username, but not the db, but not both, I can't remember. By removing single quotes around<br>both the dbname and the username it started working. It's still strange to me that it works with single quotes on all my other sites.<br><br>Thanks for your suggestion!<br><br>Trent<br><br><div><div id="SkyDrivePlaceholder"></div>> Date: Fri, 3 Feb 2012 09:33:15 +0100<br>> Subject: Re: [mapserver-users] PostGIS Connection String - Thread Issue?<br>> From: thomas.bonfort@gmail.com<br>> To: pintj@hotmail.com<br>> CC: mapserver-users@lists.osgeo.org<br>> <br>> There were some changes to string quoting/escaping in version 6 (I think).<br>> <br>> Are the errors you are seeing intermittent, or is it reproducible<br>> consistently on all requests?<br>> What happens if you use<br>> <br>> CONNECTION "dbname=interlocken user=interlocken ..."<br>> <br>> instead of<br>> <br>> CONNECTION "dbname='interlocken' user='interlocken' ..."<br>> <br>> --<br>> thomas<br>> <br>> On Thu, Feb 2, 2012 at 23:00, Trent Pingenot <pintj@hotmail.com> wrote:<br>> > Hi list,<br>> ><br>> > We recently upgraded from MapServer 5.x to 6.0.1 on Linux. We have 21 sites<br>> > running all running smoothly with identical configurations off this server.<br>> > On one site the MapServer connection to Postgres/PostGIS fails on all<br>> > layers. The MS debug message is as follows<br>> ><br>> > [Thu Feb 2 14:41:04 2012].823297 msPostGISLayerOpen(): Query error.<br>> > Database connection failed (FATAL: no pg_hba.conf entry for host "[local]",<br>> > user "interlocken", database "nterlocNken", SSL off<br>> > ) with connect string 'dbname='nterlocNken' user='interlocken'<br>> > password=*******************'<br>> ><br>> > And the entry in the map file<br>> ><br>> > CONNECTIONTYPE postgis<br>> > PROCESSING "CLOSE_CONNECTION=DEFER"<br>> > CONNECTION "dbname='interlocken' user='interlocken'<br>> > password='**************'"<br>> > DATA 'the_geom FROM "ext_lighting_existing_point" USING UNIQUE gid USING<br>> > srid=4326'<br>> ><br>> > I can log into psql on the server as the interlocken user and hit the DB<br>> > just fine so it's not the pg_hba.conf file settings which are set that the<br>> > db username and db name must match. My question is why<br>> > does the dbname get corrupted to nterlocNken? Is this a bug or how mapserver<br>> > should present the connection items in a debug statement? I can use our old<br>> > copy 5.4 copy of mapserver and it runs the map file fine. One difference in<br>> > this build is that we don't have the --with-threads support. We are looking<br>> > at getting the build rebuilt with this thread locking option included.<br>> > Could threading be the problem? I'm not sure how/if threading might be<br>> > related but thought I would mention it.<br>> ><br>> > I've stripped out all layers from the mapfile except a single test layer.<br>> > I've got 60+ layers running in other map files and databases with identical<br>> > setups on the same server without problems, why this one? We even tried<br>> > wiping out the DB and associated user and reloading and still the same<br>> > problem.<br>> ><br>> > Thanks in advance for any help or tips you can provide.<br>> ><br>> > Thanks,<br>> ><br>> > Trent<br>> ><br>> > _______________________________________________<br>> > mapserver-users mailing list<br>> > mapserver-users@lists.osgeo.org<br>> > http://lists.osgeo.org/mailman/listinfo/mapserver-users<br>> ><br></div> </div></body>
</html>