openerp-community team mailing list archive

[Joachim Grubelnik <j.grubelnik@xxxxxxxxx>]

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