[postgis-users] Calling shp2pgsql with PHP's exec()

[Obe, Regina]

Are you running on windows or linux.
 
I know at least on Windows - that error is usually caused one of the
following
 
1) if you typed the password in wrong on the services section or if you
changed the windows nt password for the account that the postgresql
service is running under or for whatever reason it doesn have run at
server rights.  You have to go into services and retype in the password
or change the local policy to give it run as service rights.
 
    2) you screwed up on your postgresql.conf file. e.g you set memory
or buffers too high etc and it can't allocate that much
 
3) Malformed pg_hba.conf file.
 
Regarding the other issue about shp2pgsql.  I myself haven't tried
running this from PHP, but I have run other exes form php.  In order for
exes to execute from PHP, you need to make sure the IIS_WPG group (for
windows 2003) or (IUSR and IWAM accounts, Network Service) have execute
rights to the exe and related exes.  E.g. I think they need execute
rights to cmd.exe which sometimes  gets removed by security lock down
tools.
 
Hope that helps,
Regina

________________________________

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
shojka at web.de
Sent: Tuesday, June 26, 2007 9:51 AM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] Calling shp2pgsql with PHP's exec() 



Siva wrote:

check shp2pgsql.exe cmd.exe internet user permision shp2pgsql.exe \\path

 

How can I check internet user permission? I checked shp2pgsql options
there is none about user permissions.

Also for some reason I cannot start the postgis database service. After
starting I got a message that PGSQL8.1. on the Local computed started
and then stopped.

What might be the reason for this




 <https://img.web.de/p.gif> 	
XXL-Speicher, PC-Virenschutz, Spartarife & mehr: Nur im WEB.DE Club!    
Jetzt testen! http://produkte.web.de/club/?mc=021130
<http://produkte.web.de/club/?mc=021130>   	



-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070626/dbea13bb/attachment.html>