(Migrated) Re: Need a pointer on how to make zato aware of pyodbc

(This message has been automatically imported from the retired mailing list)

Hi again.

./bin/buildout dies out here:


running install_scripts
copying build/scripts-2.7/cygdb -> /opt/zato/1.1/bin
copying build/scripts-2.7/cython -> /opt/zato/1.1/bin
changing mode of /opt/zato/1.1/bin/cygdb to 755
changing mode of /opt/zato/1.1/bin/cython to 755
running install_egg_info
Removing
/opt/zato/1.1/lib/python2.7/site-packages/Cython-0.14-py2.7.egg-info
Writing /opt/zato/1.1/lib/python2.7/site-packages/Cython-0.14-py2.7.egg-info

*Installing gevent_zeromq_patched-src.Cloning into
’/opt/zato/1.1/parts/gevent_zeromq_patched-src’…fatal: unable to connect
to github.com http://github.com:github.com http://github.com[0:
192.30.252.131]: errno=Connection timed out While: Installing
gevent_zeromq_patched-src.Error: Couldn’t clone
git://github.com/dsuch/gevent-zeromq.git
http://github.com/dsuch/gevent-zeromq.git into
/opt/zato/1.1/parts/gevent_zeromq_patched-src user@zatoTest:/opt/zato/1.1$ *
Will try again later and post progress/additional questions. Timeout might
be a network issue here at work.

Thanx for the help.

-Bad

On Tue, Jul 8, 2014 at 10:48 AM, Dariusz Suchojad dsuch@zato.io wrote:
On 07/08/2014 09:51 AM, Baad Sequel wrote:

ImportError: No module named pyodbc
]

Now, pyodbc works great in any other non-zato python script I write.

Hi Baad,

Zato’s dependencies are in 99% isolated from the underlying OS. The only
ones that it shares with your OS are scipy and numpy.

Hence pyodbc may be available in your default Python’s installation but,
given that it’s not bundled with Zato, you can’t make use of it unless
you install it additionally.

The steps are below, assuming Zato binaries are in /opt/zato/1.1/

  • Open /opt/zato/1.1/versions.cfg

  • Add the version of pyodbc you’d like to make use of

  • Close the file

  • Open /opt/zato/1.1/buildout.cfg

  • Add pyodbc to zato.eggs stanza

  • Close the file

  • cd /opt/zato/1.1

  • ./bin/buildout

  • Stop and start the environment again

This will download and install pyodbc for you under /opt/zato/1.1/eggs
and make it available on PYTHONPATH for your services to import it.

I’m not sure if pyodbc has any dependencies - if there are any they will
have to be added to versions.cfg and buildout.cfg as well.

Please post a message if this helps or perhaps you need assistance.

thanks a lot,


Dariusz Suchojad

https://zato.io
ESB, SOA, REST, APIs and cloud integrations in Python

Hi Baad,

El 10/07/14 12:52, Baad Sequel ha escrit:

Hi again.

./bin/buildout dies out here:


running install_scripts
copying build/scripts-2.7/cygdb -> /opt/zato/1.1/bin
copying build/scripts-2.7/cython -> /opt/zato/1.1/bin
changing mode of /opt/zato/1.1/bin/cygdb to 755
changing mode of /opt/zato/1.1/bin/cython to 755
running install_egg_info
Removing
/opt/zato/1.1/lib/python2.7/site-packages/Cython-0.14-py2.7.egg-info
Writing
/opt/zato/1.1/lib/python2.7/site-packages/Cython-0.14-py2.7.egg-info
*Installing gevent_zeromq_patched-src.
Cloning into ‘/opt/zato/1.1/parts/gevent_zeromq_patched-src’…
fatal: unable to connect to github.com http://github.com:
github.com http://github.com[0: 192.30.252.131]: errno=Connection
timed out

While:
Installing gevent_zeromq_patched-src.
Error: Couldn’t clone git://github.com/dsuch/gevent-zeromq.git
http://github.com/dsuch/gevent-zeromq.git into
/opt/zato/1.1/parts/gevent_zeromq_patched-src
user@zatoTest:/opt/zato/1.1$
*
Will try again later and post progress/additional questions. Timeout
might be a network issue here at work.

Thanx for the help.

-Bad

I don’t know if I am doing it properly or not, but in a similar
situation where I needed to use PyMongo I just installed the dependency
using pip from within the user zato:

apt-get install zato

su - zato

$ pip install pymongo

May a similar approach work in your case?

Regards,
Carles

On 07/10/2014 12:52 PM, Baad Sequel wrote:

Hi again.

*Installing gevent_zeromq_patched-src.Cloning into
’/opt/zato/1.1/parts/gevent_zeromq_patched-src’…fatal: unable to connect
to github.com http://github.com:github.com http://github.com[0:
192.30.252.131]: errno=Connection timed out While: Installing
gevent_zeromq_patched-src.Error: Couldn’t clone
git://github.com/dsuch/gevent-zeromq.git
http://github.com/dsuch/gevent-zeromq.git into
/opt/zato/1.1/parts/gevent_zeromq_patched-src user@zatoTest:/opt/zato/1.1$ *
Will try again later and post progress/additional questions. Timeout might
be a network issue here at work.

Right, mhm. Baad - is this is a permanent issues or a intermittent one?
Does it always stop abruptly at this step?

On 07/10/2014 12:52 PM, Baad Sequel wrote:

Hi again.

*Installing gevent_zeromq_patched-src.Cloning into
’/opt/zato/1.1/parts/gevent_zeromq_patched-src’…fatal: unable to connect
to github.com http://github.com:github.com http://github.com[0:
192.30.252.131]: errno=Connection timed out While: Installing
gevent_zeromq_patched-src.Error: Couldn’t clone
git://github.com/dsuch/gevent-zeromq.git
http://github.com/dsuch/gevent-zeromq.git into
/opt/zato/1.1/parts/gevent_zeromq_patched-src user@zatoTest:/opt/zato/1.1$ *
Will try again later and post progress/additional questions. Timeout might
be a network issue here at work.

Right, mhm. Baad - is this is a permanent issues or a intermittent one?
Does it always stop abruptly at this step?

Stopped at the same step the 3-4 times I have tried from work.

Haven’t gotten as far as testing on a computer at home yet. I hope to find
time for that tonight

On Thu, Jul 10, 2014 at 2:14 PM, Dariusz Suchojad dsuch@zato.io wrote:

On 07/10/2014 12:52 PM, Baad Sequel wrote:

Hi again.

*Installing gevent_zeromq_patched-src.Cloning into
’/opt/zato/1.1/parts/gevent_zeromq_patched-src’…fatal: unable to
connect
to github.com http://github.com:github.com http://github.com[0:
192.30.252.131]: errno=Connection timed out While: Installing
gevent_zeromq_patched-src.Error: Couldn’t clone
git://github.com/dsuch/gevent-zeromq.git
http://github.com/dsuch/gevent-zeromq.git into
/opt/zato/1.1/parts/gevent_zeromq_patched-src user@zatoTest:/opt/zato/1.1$

Will try again later and post progress/additional questions. Timeout
might
be a network issue here at work.

Right, mhm. Baad - is this is a permanent issues or a intermittent one?
Does it always stop abruptly at this step?


Dariusz Suchojad

https://zato.io
ESB, SOA, REST, APIs and cloud integrations in Python