<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2873" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>The item DATA this badly written: </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial
size=2> DATA "<name field
geometry> from <table>"</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Example : </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2> DATA
"The_geom from ag_sinabip_18"<BR> CONNECTION "user=postgres
password=password dbname=mapas host=elcaro port=5432"<BR>
CONNECTIONTYPE postgis </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>These safe of the user? </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Fernado Luyo</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=rockwell_001@YAHOO.COM href="mailto:rockwell_001@YAHOO.COM">rock
well</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=MAPSERVER-USERS@LISTS.UMN.EDU
href="mailto:MAPSERVER-USERS@LISTS.UMN.EDU">MAPSERVER-USERS@LISTS.UMN.EDU</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, May 30, 2006 3:55 PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [UMN_MAPSERVER-USERS] Mapfile
connection string for postgis</DIV>
<DIV><BR></DIV>
<DIV>Hello all i was trying to connect postgis remote database from mapserver,
so i included a connection string in the mapfile as </DIV>
<DIV> </DIV>
<DIV>CONNECTIONTYPE POSTGIS <BR>CONNECTION "host=remoteserverhostname
user=postgres password=random1 dbname=tes port=5432"<BR>DATA "* from
tablename"</DIV>
<DIV> </DIV>
<DIV>but this gives me the following errors</DIV>
<DIV> </DIV>
<DIV><STRONG>Warning</STRONG>: [MapServer Error]: msPOSTGISLayerOpen():
couldnt make connection to DB with connect string </DIV>
<DIV>Error reported was 'FATAL: Ident authentication failed for user
"postgres" '. <BR>This error occured when trying to make a connection to the
specified postgresql server. <BR></DIV>
<DIV>I dont know if the connection string is right or not, or do we have to
change anything in the configuration file for postgresql .....</DIV>
<DIV> </DIV>
<DIV>Thanks for your time and appreciate it .......</DIV>
<DIV>kris</DIV>
<P>
<HR SIZE=1>
Do you Yahoo!?<BR>Get on board. <A
href="http://us.rd.yahoo.com/evt=40791/*http://advision.webevents.yahoo.com/handraisers">You're
invited</A> to try the new Yahoo! Mail Beta.</BLOCKQUOTE></BODY></HTML>