[mapserver-users] PostGIS Connection Failure

[Humberto Cereser Ibanez]

Hi Krishna,

On Tue, 2014-06-24 at 09:35 -0400, Krishna Priya Patury wrote:
> Just wanted to add, when I do a service iptables status, it is says
> Firewall is not running. 
> 
> 
> On Tue, Jun 24, 2014 at 9:30 AM, Krishna Priya Patury
> <krishna.patury at gmail.com> wrote:
>         Hi All,
>          
>         Any other ideas?
>          
>         The map server application installed outside of my Centos VM
>         can connect to the Postgres database on the VM. I can also
>         connect to the database both from within and outside the VM
>         using psql.
>          
>         I believe the Mapserver installation on my VM is fine too as
>         my shp2img and running the mapserver through command line work
>         just fine. The issue is only when I try to connect to the
>         database through the application from my VM.
>         I do not see anything additional in the logs. 

I think that the requisition from your application is not achieving your
VM.
Is the request sent by your application pass through a proxy that blocks
the 5432 port or there is a bridge over which the requests flow
directly?
 
>         I can see that the database logs are not updated when I hit it
>         though the application within the VM, understandably so with
>         the error message in the browser.
>          
>         The only difference between running shp2img and the
>         application is perhaps the user? I was able to open a
>         succesful connection through psql as an 'apache' user as
>         well(User which is running the Apache server). So am not sure
>         what is missing. 
>          
>         Thanks,
>         Krishna.
>          
Best regards,

Humberto Cereser Ibanez
>         
>         
>         On Mon, Jun 23, 2014 at 5:24 PM, Krishna
>         <krishna.patury at gmail.com> wrote:
>                 Yes I can connect to Postgres using the same
>                 connection information through psql both from within
>                 and outside my vm.
>                 
>                 Sent from my iPhone
>                 
>                 > On Jun 23, 2014, at 5:20 PM, Paul Ramsey
>                 <pramsey at cleverelephant.ca> wrote:
>                 >
>                 > Did you restart your postgresql after making the
>                 changes to pg_hba and postgresql.conf? Can you telnet
>                 to port 5432? Can you connect with psql? Just ignore
>                 mapserver for now, you have a connection issue.
>                 >
>                 > P.
>                 >
>                 >
>                 > --
>                 > http://postgis.net
>                 > http://cleverelephant.ca
>                 >
>                 >
>                 > On June 23, 2014 at 2:17:19 PM, Krishna
>                 (krishna.patury at gmail.com) wrote:
>                 >>> As I mentioned I have disabled the firewall. Or so
>                 I think. When
>                 >> I login as 'root' and click firewall it says
>                 disabled. Any way
>                 >> I can confirm/ test this?
>                 >
>                 
>         
>         
> 
> 
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users