Postgis Connection

Rick Levine Richard_D_Levine at RAYTHEON.COM
Thu Jun 30 12:06:47 EDT 2005


Is your dbname really dbpotgis and not dbpostgis?


                                                                           
             Ezequias                                                      
             Rodrigues da                                                  
             Rocha                                                      To 
             <ezequias at RECIFE.         MAPSERVER-USERS at LISTS.UMN.EDU       
             PE.GOV.BR>                                                 cc 
             Sent by: UMN                                                  
             MapServer Users                                       Subject 
             List                      [UMN_MAPSERVER-USERS] Postgis       
             <MAPSERVER-USERS@         Connection                          
             LISTS.UMN.EDU>                                                
                                                                           
                                                                           
             06/30/2005 12:09                                              
             PM                                                            
                                                                           
                                                                           
             Please respond to                                             
                 Ezequias                                                  
               Rodrigues da                                                
                   Rocha                                                   
             <ezequias at RECIFE.                                             
                PE.GOV.BR>                                                 
                                                                           
                                                                           



                                                                            
                                                                            
 I am trying to load a mapserver service with a postgis connection but the  
 MS reported this message below:                                            
                                                                            
                                                                            
 msDrawMap(): Image handling error. Failed to draw layer named 'bairros'.   
 msPOSTGISLayerOpen(): Query error. couldnt make connection to DB with      
 connect string 'user=postgres password=post dbname=dbpotgis                
 host=196.168.0.15 port=5432'.                                              
 Error reported was 'could not create socket: Permission denied '.          
 This error occured when trying to make a connection to the specified       
 postgresql server.                                                         
 Most commonly this is caused by                                            
 (1) incorrect connection string                                            
 (2) you didnt specify a 'user=...' in your connection string               
 (3) the postmaster (postgresql server) isnt running                        
 (4) you are not allowing TCP/IP connection to the postmaster               
 (5) your postmaster is not running on the correct port - if its not on     
 5432 you must specify a 'port=...'                                         
 (6) the security on your system does not allow the webserver (usually user 
 'nobody') to make socket connections to the postmaster                     
 (7) you forgot to specify a 'host=...' if the postmaster is on a different 
 machine                                                                    
 (8) you made a typo                                                        
 Does anyone can tell me what to do  ?                                      
                                                                            
                                                                            
 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-   
                                   Atenciosamente (Sincerely)               
                         Ezequias Rodrigues da Rocha                        
                                 * www.recife.pe.gov.br                     
 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-   
 A pior das democracias ainda é melhor do que a melhor das ditaduras        
 The worst of democracies is still better than the better of dictatorships  
 (Embedded image moved to file: pic18756.jpg)  MSN Messenger:               
 ezequias at hotmail.com                                                       
                                                                            
                                                                            
                                                                            
                                                                            
                                                                            
                                                                            
                                                                            
                                                                            


 (Embedded image moved to file: pic11840.gif)Add FUN to your email - CLICK
 HERE!
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pic18756.jpg
Type: image/jpeg
Size: 1111 bytes
Desc: not available
Url : http://lists.osgeo.org/pipermail/mapserver-users/attachments/20050630/6aafd905/pic18756.jpg
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pic11840.gif
Type: image/gif
Size: 9015 bytes
Desc: not available
Url : http://lists.osgeo.org/pipermail/mapserver-users/attachments/20050630/6aafd905/pic11840.gif


More information about the mapserver-users mailing list