Hello. This is what returns the 2 servers:
Production Server:
['/usr/local/lib/python2.7/site-packages/setuptools-0.6c11-py2.7.egg',
'/usr/local/lib/python27.zip', '/usr/local/lib/python2.7',
'/usr/local/lib/python2.7/plat-freebsd8',
'/usr/local/lib/python2.7/lib-tk', '/usr/local/lib/python2.7/lib-old',
'/usr/local/lib/python2.7/lib-dynload',
'/usr/local/lib/python2.7/site-packages']
Test Server:
['/usr/local/lib/python2.7/site-packages/setuptools-0.6c11-py2.7.egg',
'/usr/local/lib/python27.zip', '/usr/local/lib/python2.7',
'/usr/local/lib/python2.7/plat-freebsd9',
'/usr/local/lib/python2.7/lib-tk', '/usr/local/lib/python2.7/lib-old',
'/usr/local/lib/python2.7/lib-dynload',
'/usr/local/lib/python2.7/site-packages']
Craig: Sorry about the details.
This is what we got:
Production server:
FreeBSD 8.2
Postgresql 9.1.2
Python 2.7.3 (default, Jul 10 2012, 21:36:33)
Test server:
FreeBSD 9
Postgresql 9.1.3
Python 2.7.2 (default, Mar 26 2012, 18:07:58)
We tested on other server (it worked) that use
FreeBSD 8.3
Python 2.6.8 (unknown, Jul 4 2012, 00:49:01)
PostgreSQL 9.1.3
Thank you
On 07/10/2012 05:34 PM, Efraín Déctor wrote:
We tested, the code directly into Python:
from googlemaps import GoogleMaps
gmaps= GoogleMaps()
address = gmaps.latlng_to_address(18.835124317498853,-97.11448417315677)
repr(address)
And on both servers work without a problem. My guess is that something
about OpenSSL on the production server is not working with plpython. But
I don't know how to fix this.
So in your function add the following to the beginning and see what it
returns on each server. More to the point is there a difference?:
import sys
plpy.notice(sys.path)
Thanks
--
Adrian Klaver
adrian.klaver@xxxxxxxxx
-----Mensaje original-----
From: Craig Ringer
Sent: Tuesday, July 10, 2012 10:43 PM
To: Efraín Déctor
Cc: pgsql-general@xxxxxxxxxxxxxx
Subject: Re: Error with plpython
On 07/11/2012 06:16 AM, Efraín Déctor wrote:
However, once we installed it on our production server that function
doesnt work, it keeps sending this message:
ERROR: ImportError: cannot import name SSLError
CONTEXT: Traceback (most recent call last):
The strange thing is that our server are the same in everything so we don’t
know why is failing in our production eviroment.
I'm guessing it isn't really the same.
You're probably missing a library that Python's SSL support requires,
missing some Python modules, or have a library that isn't compatible
with the one Python's SSL support was built against.
Since you've neglected to describe your client or server environments at
all, it's hard to say more.
--
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
