Hello! 

We want to have a look at the geospatial addon to see how far things are 
already with the 7.0 port , what works an what not. 
Maybe we can jump into as well and give our 3 cents. 

therefore i need to Install the Basic Module, but till now i was not able to 
get it running in our environment, maybe 
there is a version Problem on postgres, but the community for sure already 
tested much more than myself :-) 

Please have a short look in what i did maybe someone sees in a sec. what the 
problem is. think i just missed something at the database 
requirements or installation 

---- INSTALLATION BEGIN ---- 

Starting on our Ubuntu 12.04 OpenERP OCB 7.0 

apt-get install python-shapely 
apt-add-repository ppa:ubuntugis/ppa 
apt-get update apt-get install postgis 
apt-get install postgresql-server-dev-9.3 apt-get install libgeos-3.2.2 
libgeos-c1 libgeos-dbg libgeos-dev libgeos-doc libgeos-ruby1.8 
wget wget 
https://pypi.python.org/packages/source/g/geojson/geojson-1.0.tar.gz#md5=2d36a78208ac6e85e3b6abace6fcceb0
 
python setup.py install 

apt-get purge postgis --> standard test without thinking to much just to make 
it running for a first preview 
after testing around nothing worked with the database and the script 
create_postgis_template.sh seems not to be able to import the two sql files 
ERROR AT THIS psql -d postgis01 -f 
/opt/openerp/ope-7.0-42069/custom-addons/camp2camp/7.0/base_geoengine/postgis_sql/postgis.sql
 
ERROR AT THIS psql -d postgis01 -f 
/opt/openerp/ope-7.0-42069/custom-addons/camp2camp/7.0/base_geoengine/postgis_sql/spatial_ref_sys.sql
 
starting search and debug 
uninstalled postgis and started with the following link, cause we are running 
our installations at postgres9.3 
http://technobytz.com/install-postgis-postgresql-9-3-ubuntu.html 

so testing postgres 9.3 with postgis 2.1 .... . Manual testing 
uninstalled postgis 
apt-get install postgresql-9.3-postgis-2.1 -f 
psql -d template_postgis2.1 -f 
/usr/share/postgresql/9.3/extension/postgis--2.1.1.sql 
seems to import everything cleanly 
psql -d template_postgis2.1 -c "GRANT ALL ON geometry_columns TO PUBLIC;" 
psql -d template_postgis2.1 -c "GRANT ALL ON geography_columns TO PUBLIC;" 
psql -d template_postgis2.1 -c "GRANT ALL ON spatial_ref_sys TO PUBLIC;" 

creating the DB for Postgis like README in /base_geoengine 
createdb postgis01 -O ope_42069 -T template_postgis2.1 
psql -d postgis01 -f /opt/openerp/ope-7.0-42069/custom-addons/ 
geospatial-addons/ 7.0/base_geoengine/postgis_sql/postgis.sql 
psql -d postgis01 -f /opt/openerp/ope-7.0-42069/custom-addons/ 
geospatial-addons/ 7.0/base_geoengine/postgis_sql/spatial_ref_sys.sql 
THIS FAILS TOOO same as if i do the standard postgis install --> I did not try 
to use lower version or Postgres till now, but if this is not the problem i 
would prefer ot make it running in the existing environment 
or wrong Template ? 

after this tests with the Module 
1. from the community and 
2. from camp2camp 
which can be found in launchpad it didnt work out for me and i think the 
problem is just my Postgis setup 
File 
"/opt/openerp/ope-7.0-42069/custom-addons-loaded/base_geoengine/geo_model.py", 
line 63, in _auto_init
  raise Exception(_('Can not install GeoEngine PostGIS does not seems'
Exception: Can not install GeoEngine PostGIS does not seems to be installed or 
spatial_sys_ref table not initialized Please go to 
http://postgis.refractions.net/docs/ch02.html for more information. You can 
also use script create_postgis_template.sh available in modul 
_______________________________________________
Mailing list: https://launchpad.net/~openerp-community
Post to     : openerp-community@lists.launchpad.net
Unsubscribe : https://launchpad.net/~openerp-community
More help   : https://help.launchpad.net/ListHelp

Reply via email to