Thread: [cx-oracle-users] 4.1.2 install: Ubuntu Linux, Oracle 10.1.0.3 instant client problems
Brought to you by:
atuining
Menu
▾
▴
cx-oracle-users
|
From: cpoetzel <cpo...@an...> - 2006-02-06 16:27:00
|
Hi,
I am trying to install cx_Oracle 4.1.2 on a new Ubuntu Breezy Box. Its a
64bit amd box.
I have already installed the oracle 10.1.0.3 64 bit instant client.
Install looks like this
root@athena:/usr/lib/oracle/10.1.0.3/client# ls -R
.:
bin lib tnsnames.ora
./bin:
sqlplus
./lib:
classes12.jar glogin.sql libclntsh.so libclntsh.so.10.1 libnnz10.so
libocci.so libocci.so.10.1 libociei.so libocijdbc10.so libsqlplus.so
ojdbc14.jar sdk
./lib/sdk:
demo include
./lib/sdk/demo:
cdemo81.c demo.mk occidemod.sql occidemo.sql occidml.cpp
./lib/sdk/include:
nzerror.h occiAQ.h occiControl.h occi.h oci1.h ociap.h
ocidef.h ocidfn.h oci.h ocixmldb.h oratypes.h ori.h oro.h xa.h
nzt.h occiCommon.h occiData.h occiObjects.h oci8dp.h ociapr.h
ocidem.h ociextp.h ocikpr.h odci.h orid.h orl.h ort.h
Env:
ORACLE_HOME=3D/usr/lib/oracle/10.1.0.3/client/lib
TNS_ADMIN=3D/usr/lib/oracle/10.1.0.3/client
LD_LIBRARY_PATH=3D/usr/lib/oracle/10.1.0.3/client/lib
Installing the client:
root@athena:/usr/local/build/Python-CxOracle/cx_Oracle-4.1.2# python
setup.py build
running build
running build_ext
building 'cx_Oracle' extension
creating build
creating build/temp.linux-x86_64-2.4
gcc -pthread -fno-strict-aliasing -DNDEBUG -g -O3 -Wall -Wstrict-prototypes
-fPIC -I/usr/lib/oracle/10.1.0.3/client/lib/rdbms/demo
-I/usr/lib/oracle/10.1.0.3/client/lib/rdbms/public
-I/usr/lib/oracle/10.1.0.3/client/lib/network/public
-I/usr/lib/oracle/10.1.0.3/client/lib/sdk/include -I/usr/include/python2.4
-c cx_Oracle.c -o build/temp.linux-x86_64-2.4/cx_Oracle.o
-DBUILD_TIME=3D"February 06, 2006 10:21:45"
In file included from
/usr/lib/oracle/10.1.0.3/client/lib/sdk/include/oci.h:2327,
from cx_Oracle.c:9:
/usr/lib/oracle/10.1.0.3/client/lib/sdk/include/oci1.h:148: warning:
function declaration isn=B9t a prototype
In file included from
/usr/lib/oracle/10.1.0.3/client/lib/sdk/include/ociap.h:206,
from
/usr/lib/oracle/10.1.0.3/client/lib/sdk/include/oci.h:2351,
from cx_Oracle.c:9:
/usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:674: warning: functio=
n
declaration isn=B9t a prototype
/usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2665: warning:
function declaration isn=B9t a prototype
/usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2674: warning:
function declaration isn=B9t a prototype
/usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2684: warning:
function declaration isn=B9t a prototype
/usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2693: warning:
function declaration isn=B9t a prototype
/usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2702: warning:
function declaration isn=B9t a prototype
/usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2711: warning:
function declaration isn=B9t a prototype
/usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2719: warning:
function declaration isn=B9t a prototype
/usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2729: warning:
function declaration isn=B9t a prototype
/usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2736: warning:
function declaration isn=B9t a prototype
/usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2744: warning:
function declaration isn=B9t a prototype
In file included from
/usr/lib/oracle/10.1.0.3/client/lib/sdk/include/oci.h:2351,
from cx_Oracle.c:9:
/usr/lib/oracle/10.1.0.3/client/lib/sdk/include/ociap.h:9952: warning:
function declaration isn=B9t a prototype
/usr/lib/oracle/10.1.0.3/client/lib/sdk/include/ociap.h:9958: warning:
function declaration isn=B9t a prototype
In file included from SessionPool.c:134,
from cx_Oracle.c:76:
Connection.c: In function =8CConnection_Acquire=B9:
Connection.c:184: warning: pointer targets in passing argument 5 of
=8COCISessionGet=B9 differ in signedness
In file included from Variable.c:89,
from Cursor.c:211,
from Connection.c:354,
from SessionPool.c:134,
from cx_Oracle.c:76:
NumberVar.c: In function =8CNumberVar_SetValue=B9:
NumberVar.c:178: warning: pointer targets in passing argument 2 of
=8COCINumberFromText=B9 differ in signedness
NumberVar.c:178: warning: pointer targets in passing argument 4 of
=8COCINumberFromText=B9 differ in signedness
In file included from Variable.c:93,
from Cursor.c:211,
from Connection.c:354,
from SessionPool.c:134,
from cx_Oracle.c:76:
DateTimeVar.c: In function =8CDateTimeVar_SetValue=B9:
DateTimeVar.c:81: warning: unused variable =8Cstatus=B9
In file included from cx_Oracle.c:76:
SessionPool.c: In function =8CSessionPool_Init=B9:
SessionPool.c:246: warning: pointer targets in passing argument 6 of
=8COCISessionPoolCreate=B9 differ in signedness
creating build/lib.linux-x86_64-2.4
gcc -pthread -shared build/temp.linux-x86_64-2.4/cx_Oracle.o
-L/usr/lib/oracle/10.1.0.3/client/lib/lib
-L/usr/lib/oracle/10.1.0.3/client/lib -lclntsh -o
build/lib.linux-x86_64-2.4/cx_Oracle.so -s
root@athena:/usr/local/build/Python-CxOracle/cx_Oracle-4.1.2# python
setup.py install
running install
running build
running build_ext
running install_lib
copying build/lib.linux-x86_64-2.4/cx_Oracle.so ->
/usr/lib/python2.4/site-packages
Not sure if these warnings are normal but have seen other people have them
in the postings.=20
root@athena:/tmp# ldd /usr/lib/python2.4/site-packages/cx_Oracle.so
libclntsh.so.10.1 =3D>
/usr/lib/oracle/10.1.0.3/client/lib/libclntsh.so.10.1 (0x00002aaaaabc3000)
libpthread.so.0 =3D> /lib/libpthread.so.0 (0x00002aaaaba7b000)
libc.so.6 =3D> /lib/libc.so.6 (0x00002aaaabb90000)
libnnz10.so =3D> /usr/lib/oracle/10.1.0.3/client/lib/libnnz10.so
(0x00002aaaabdc7000)
libdl.so.2 =3D> /lib/libdl.so.2 (0x00002aaaac038000)
libm.so.6 =3D> /lib/libm.so.6 (0x00002aaaac13a000)
libnsl.so.1 =3D> /lib/libnsl.so.1 (0x00002aaaac2bf000)
/lib64/ld-linux-x86-64.so.2 (0x0000555555554000)
I get the following error when trying to run a script
[Mon Feb 06 10:00:01 2006] [error] [client 146.137.1.33] File
"/usr/lib/cgi-bin/cxOracle-test.py", line 10, in ?
[Mon Feb 06 10:00:01 2006] [error] [client 146.137.1.33] connection =3D
cx_Oracle.connect("ectuser", "xxxxxx", "ect1");
[Mon Feb 06 10:00:01 2006] [error] [client 146.137.1.33]
cx_Oracle.DatabaseError: ORA-12154: TNS:could not resolve the connect
identifier specified
[Mon Feb 06 10:00:01 2006] [error] [client 146.137.1.33]
[Mon Feb 06 10:00:01 2006] [error] [client 146.137.1.33] Premature end of
script headers: cxOracle-test.py
It appears that cx_oracle can not find the tns admin file whish I defined i=
n
my environment.
Thank you much,
Chris Poetzel
|
|
From: Anthony T. <ant...@gm...> - 2006-02-07 16:16:16
|
SXRzIHVuZm9ydHVuYXRlIHRoYXQgeW91IGRvbid0IGhhdmUgdG5zcGluZyBhdmFpbGFibGUgYXMg dGhhdCB0ZWxscwp5b3Ugd2hldGhlciBvciBub3QgdGhlIE9yYWNsZSBjbGllbnQgY2FuIGZpbmQg dGhlIHRuc25hbWVzLm9yYSBmaWxlCmFuZCB3aGV0aGVyIGl0IGNvbnRhaW5zIHdoYXQgeW91IHRo aW5rIGl0IGNvbnRhaW5zLiA6LSkgIFlvdSBkbywKaG93ZXZlciwgaGF2ZSBTUUwqUGx1cyBzbyB5 b3Ugc2hvdWxkIGZpcnN0IHZlcmlmeSB0aGF0IHlvdSBjYW4gY29ubmVjdAp1c2luZyBpdCB3aXRo IHRoZSBzYW1lIGNvbm5lY3Qgc3RyaW5nIHlvdSBhcmUgdXNpbmcgd2l0aCBjeF9PcmFjbGUuCllv dSBjYW4gYWxzbyBtYWtlIHVzZSBvZiB0aGUgY3hfT3JhY2xlLm1ha2VfZHNuKCkgbWV0aG9kIHRv IGdlbmVyYXRlCnRoZSBzdHJpbmcgdGhhdCBpcyBub3JtYWxseSBmb3VuZCBpbiBhIHRuc25hbWVz Lm9yYSBmaWxlIGFuZCB1c2UgdGhhdAp0byBjb25uZWN0LiBJZiB5b3Ugd2FudCB0byBrbm93IHdo aWNoIGxvY2F0aW9ucyBPcmFjbGUgaXMgc2VhcmNoaW5nCmZvciB0bnNuYW1lcy5vcmEgeW91IGNh biB1c2UgdGhlIHN0cmFjZSBjb21tYW5kIC0tIHRoZXJlIGFyZSBzZXZlcmFsCnBsYWNlcy4gSG9w ZSB0aGlzIGhlbHBzIHlvdSB0cmFjayBkb3duIHRoZSBpc3N1ZS4KCk9uIDIvNi8wNiwgY3BvZXR6 ZWwgPGNwb2V0emVsQGFubC5nb3Y+IHdyb3RlOgo+IEhpLAo+IEkgYW0gdHJ5aW5nIHRvIGluc3Rh bGwgY3hfT3JhY2xlIDQuMS4yIG9uIGEgbmV3IFVidW50dSBCcmVlenkgQm94LiBJdHMgYQo+IDY0 Yml0IGFtZCBib3guCj4gSSBoYXZlIGFscmVhZHkgaW5zdGFsbGVkIHRoZSBvcmFjbGUgMTAuMS4w LjMgNjQgYml0IGluc3RhbnQgY2xpZW50Lgo+IEluc3RhbGwgbG9va3MgbGlrZSB0aGlzCj4KPiBy b290QGF0aGVuYTovdXNyL2xpYi9vcmFjbGUvMTAuMS4wLjMvY2xpZW50IyBscyAtUgo+IC46Cj4g YmluICBsaWIgIHRuc25hbWVzLm9yYQo+Cj4gLi9iaW46Cj4gc3FscGx1cwo+Cj4gLi9saWI6Cj4g Y2xhc3NlczEyLmphciAgZ2xvZ2luLnNxbCAgbGliY2xudHNoLnNvICBsaWJjbG50c2guc28uMTAu MSAgbGlibm56MTAuc28KPiBsaWJvY2NpLnNvICBsaWJvY2NpLnNvLjEwLjEgIGxpYm9jaWVpLnNv ICBsaWJvY2lqZGJjMTAuc28gIGxpYnNxbHBsdXMuc28KPiBvamRiYzE0LmphciAgc2RrCj4KPiAu L2xpYi9zZGs6Cj4gZGVtbyAgaW5jbHVkZQo+Cj4gLi9saWIvc2RrL2RlbW86Cj4gY2RlbW84MS5j ICBkZW1vLm1rICBvY2NpZGVtb2Quc3FsICBvY2NpZGVtby5zcWwgIG9jY2lkbWwuY3BwCj4KPiAu L2xpYi9zZGsvaW5jbHVkZToKPiBuemVycm9yLmggIG9jY2lBUS5oICAgICAgb2NjaUNvbnRyb2wu aCAgb2NjaS5oICAgICAgICAgb2NpMS5oICAgIG9jaWFwLmgKPiBvY2lkZWYuaCAgb2NpZGZuLmgg ICBvY2kuaCAgICAgb2NpeG1sZGIuaCAgb3JhdHlwZXMuaCAgb3JpLmggIG9yby5oICB4YS5oCj4g bnp0LmggICAgICBvY2NpQ29tbW9uLmggIG9jY2lEYXRhLmggICAgIG9jY2lPYmplY3RzLmggIG9j aThkcC5oICBvY2lhcHIuaAo+IG9jaWRlbS5oICBvY2lleHRwLmggIG9jaWtwci5oICBvZGNpLmgg ICAgICBvcmlkLmggICAgICBvcmwuaCAgb3J0LmgKPgo+Cj4gRW52Ogo+IE9SQUNMRV9IT01FPS91 c3IvbGliL29yYWNsZS8xMC4xLjAuMy9jbGllbnQvbGliCj4gVE5TX0FETUlOPS91c3IvbGliL29y YWNsZS8xMC4xLjAuMy9jbGllbnQKPiBMRF9MSUJSQVJZX1BBVEg9L3Vzci9saWIvb3JhY2xlLzEw LjEuMC4zL2NsaWVudC9saWIKPgo+Cj4gSW5zdGFsbGluZyB0aGUgY2xpZW50Ogo+IHJvb3RAYXRo ZW5hOi91c3IvbG9jYWwvYnVpbGQvUHl0aG9uLUN4T3JhY2xlL2N4X09yYWNsZS00LjEuMiMgcHl0 aG9uCj4gc2V0dXAucHkgYnVpbGQKPiBydW5uaW5nIGJ1aWxkCj4gcnVubmluZyBidWlsZF9leHQK PiBidWlsZGluZyAnY3hfT3JhY2xlJyBleHRlbnNpb24KPiBjcmVhdGluZyBidWlsZAo+IGNyZWF0 aW5nIGJ1aWxkL3RlbXAubGludXgteDg2XzY0LTIuNAo+IGdjYyAtcHRocmVhZCAtZm5vLXN0cmlj dC1hbGlhc2luZyAtRE5ERUJVRyAtZyAtTzMgLVdhbGwgLVdzdHJpY3QtcHJvdG90eXBlcwo+IC1m UElDIC1JL3Vzci9saWIvb3JhY2xlLzEwLjEuMC4zL2NsaWVudC9saWIvcmRibXMvZGVtbwo+IC1J L3Vzci9saWIvb3JhY2xlLzEwLjEuMC4zL2NsaWVudC9saWIvcmRibXMvcHVibGljCj4gLUkvdXNy L2xpYi9vcmFjbGUvMTAuMS4wLjMvY2xpZW50L2xpYi9uZXR3b3JrL3B1YmxpYwo+IC1JL3Vzci9s aWIvb3JhY2xlLzEwLjEuMC4zL2NsaWVudC9saWIvc2RrL2luY2x1ZGUgLUkvdXNyL2luY2x1ZGUv cHl0aG9uMi40Cj4gLWMgY3hfT3JhY2xlLmMgLW8gYnVpbGQvdGVtcC5saW51eC14ODZfNjQtMi40 L2N4X09yYWNsZS5vCj4gLURCVUlMRF9USU1FPSJGZWJydWFyeSAwNiwgMjAwNiAxMDoyMTo0NSIK PiBJbiBmaWxlIGluY2x1ZGVkIGZyb20KPiAvdXNyL2xpYi9vcmFjbGUvMTAuMS4wLjMvY2xpZW50 L2xpYi9zZGsvaW5jbHVkZS9vY2kuaDoyMzI3LAo+ICAgICAgICAgICAgICAgICAgZnJvbSBjeF9P cmFjbGUuYzo5Ogo+IC91c3IvbGliL29yYWNsZS8xMC4xLjAuMy9jbGllbnQvbGliL3Nkay9pbmNs dWRlL29jaTEuaDoxNDg6IHdhcm5pbmc6Cj4gZnVuY3Rpb24gZGVjbGFyYXRpb24gaXNuuXQgYSBw cm90b3R5cGUKPiBJbiBmaWxlIGluY2x1ZGVkIGZyb20KPiAvdXNyL2xpYi9vcmFjbGUvMTAuMS4w LjMvY2xpZW50L2xpYi9zZGsvaW5jbHVkZS9vY2lhcC5oOjIwNiwKPiAgICAgICAgICAgICAgICAg IGZyb20KPiAvdXNyL2xpYi9vcmFjbGUvMTAuMS4wLjMvY2xpZW50L2xpYi9zZGsvaW5jbHVkZS9v Y2kuaDoyMzUxLAo+ICAgICAgICAgICAgICAgICAgZnJvbSBjeF9PcmFjbGUuYzo5Ogo+IC91c3Iv bGliL29yYWNsZS8xMC4xLjAuMy9jbGllbnQvbGliL3Nkay9pbmNsdWRlL256dC5oOjY3NDogd2Fy bmluZzogZnVuY3Rpb24KPiBkZWNsYXJhdGlvbiBpc265dCBhIHByb3RvdHlwZQo+IC91c3IvbGli L29yYWNsZS8xMC4xLjAuMy9jbGllbnQvbGliL3Nkay9pbmNsdWRlL256dC5oOjI2NjU6IHdhcm5p bmc6Cj4gZnVuY3Rpb24gZGVjbGFyYXRpb24gaXNuuXQgYSBwcm90b3R5cGUKPiAvdXNyL2xpYi9v cmFjbGUvMTAuMS4wLjMvY2xpZW50L2xpYi9zZGsvaW5jbHVkZS9uenQuaDoyNjc0OiB3YXJuaW5n Ogo+IGZ1bmN0aW9uIGRlY2xhcmF0aW9uIGlzbrl0IGEgcHJvdG90eXBlCj4gL3Vzci9saWIvb3Jh Y2xlLzEwLjEuMC4zL2NsaWVudC9saWIvc2RrL2luY2x1ZGUvbnp0Lmg6MjY4NDogd2FybmluZzoK PiBmdW5jdGlvbiBkZWNsYXJhdGlvbiBpc265dCBhIHByb3RvdHlwZQo+IC91c3IvbGliL29yYWNs ZS8xMC4xLjAuMy9jbGllbnQvbGliL3Nkay9pbmNsdWRlL256dC5oOjI2OTM6IHdhcm5pbmc6Cj4g ZnVuY3Rpb24gZGVjbGFyYXRpb24gaXNuuXQgYSBwcm90b3R5cGUKPiAvdXNyL2xpYi9vcmFjbGUv MTAuMS4wLjMvY2xpZW50L2xpYi9zZGsvaW5jbHVkZS9uenQuaDoyNzAyOiB3YXJuaW5nOgo+IGZ1 bmN0aW9uIGRlY2xhcmF0aW9uIGlzbrl0IGEgcHJvdG90eXBlCj4gL3Vzci9saWIvb3JhY2xlLzEw LjEuMC4zL2NsaWVudC9saWIvc2RrL2luY2x1ZGUvbnp0Lmg6MjcxMTogd2FybmluZzoKPiBmdW5j dGlvbiBkZWNsYXJhdGlvbiBpc265dCBhIHByb3RvdHlwZQo+IC91c3IvbGliL29yYWNsZS8xMC4x LjAuMy9jbGllbnQvbGliL3Nkay9pbmNsdWRlL256dC5oOjI3MTk6IHdhcm5pbmc6Cj4gZnVuY3Rp b24gZGVjbGFyYXRpb24gaXNuuXQgYSBwcm90b3R5cGUKPiAvdXNyL2xpYi9vcmFjbGUvMTAuMS4w LjMvY2xpZW50L2xpYi9zZGsvaW5jbHVkZS9uenQuaDoyNzI5OiB3YXJuaW5nOgo+IGZ1bmN0aW9u IGRlY2xhcmF0aW9uIGlzbrl0IGEgcHJvdG90eXBlCj4gL3Vzci9saWIvb3JhY2xlLzEwLjEuMC4z L2NsaWVudC9saWIvc2RrL2luY2x1ZGUvbnp0Lmg6MjczNjogd2FybmluZzoKPiBmdW5jdGlvbiBk ZWNsYXJhdGlvbiBpc265dCBhIHByb3RvdHlwZQo+IC91c3IvbGliL29yYWNsZS8xMC4xLjAuMy9j bGllbnQvbGliL3Nkay9pbmNsdWRlL256dC5oOjI3NDQ6IHdhcm5pbmc6Cj4gZnVuY3Rpb24gZGVj bGFyYXRpb24gaXNuuXQgYSBwcm90b3R5cGUKPiBJbiBmaWxlIGluY2x1ZGVkIGZyb20KPiAvdXNy L2xpYi9vcmFjbGUvMTAuMS4wLjMvY2xpZW50L2xpYi9zZGsvaW5jbHVkZS9vY2kuaDoyMzUxLAo+ ICAgICAgICAgICAgICAgICAgZnJvbSBjeF9PcmFjbGUuYzo5Ogo+IC91c3IvbGliL29yYWNsZS8x MC4xLjAuMy9jbGllbnQvbGliL3Nkay9pbmNsdWRlL29jaWFwLmg6OTk1Mjogd2FybmluZzoKPiBm dW5jdGlvbiBkZWNsYXJhdGlvbiBpc265dCBhIHByb3RvdHlwZQo+IC91c3IvbGliL29yYWNsZS8x MC4xLjAuMy9jbGllbnQvbGliL3Nkay9pbmNsdWRlL29jaWFwLmg6OTk1ODogd2FybmluZzoKPiBm dW5jdGlvbiBkZWNsYXJhdGlvbiBpc265dCBhIHByb3RvdHlwZQo+IEluIGZpbGUgaW5jbHVkZWQg ZnJvbSBTZXNzaW9uUG9vbC5jOjEzNCwKPiAgICAgICAgICAgICAgICAgIGZyb20gY3hfT3JhY2xl LmM6NzY6Cj4gQ29ubmVjdGlvbi5jOiBJbiBmdW5jdGlvbiCMQ29ubmVjdGlvbl9BY3F1aXJluToK PiBDb25uZWN0aW9uLmM6MTg0OiB3YXJuaW5nOiBwb2ludGVyIHRhcmdldHMgaW4gcGFzc2luZyBh cmd1bWVudCA1IG9mCj4gjE9DSVNlc3Npb25HZXS5IGRpZmZlciBpbiBzaWduZWRuZXNzCj4gSW4g ZmlsZSBpbmNsdWRlZCBmcm9tIFZhcmlhYmxlLmM6ODksCj4gICAgICAgICAgICAgICAgICBmcm9t IEN1cnNvci5jOjIxMSwKPiAgICAgICAgICAgICAgICAgIGZyb20gQ29ubmVjdGlvbi5jOjM1NCwK PiAgICAgICAgICAgICAgICAgIGZyb20gU2Vzc2lvblBvb2wuYzoxMzQsCj4gICAgICAgICAgICAg ICAgICBmcm9tIGN4X09yYWNsZS5jOjc2Ogo+IE51bWJlclZhci5jOiBJbiBmdW5jdGlvbiCMTnVt YmVyVmFyX1NldFZhbHVluToKPiBOdW1iZXJWYXIuYzoxNzg6IHdhcm5pbmc6IHBvaW50ZXIgdGFy Z2V0cyBpbiBwYXNzaW5nIGFyZ3VtZW50IDIgb2YKPiCMT0NJTnVtYmVyRnJvbVRleHS5IGRpZmZl ciBpbiBzaWduZWRuZXNzCj4gTnVtYmVyVmFyLmM6MTc4OiB3YXJuaW5nOiBwb2ludGVyIHRhcmdl dHMgaW4gcGFzc2luZyBhcmd1bWVudCA0IG9mCj4gjE9DSU51bWJlckZyb21UZXh0uSBkaWZmZXIg aW4gc2lnbmVkbmVzcwo+IEluIGZpbGUgaW5jbHVkZWQgZnJvbSBWYXJpYWJsZS5jOjkzLAo+ICAg ICAgICAgICAgICAgICAgZnJvbSBDdXJzb3IuYzoyMTEsCj4gICAgICAgICAgICAgICAgICBmcm9t IENvbm5lY3Rpb24uYzozNTQsCj4gICAgICAgICAgICAgICAgICBmcm9tIFNlc3Npb25Qb29sLmM6 MTM0LAo+ICAgICAgICAgICAgICAgICAgZnJvbSBjeF9PcmFjbGUuYzo3NjoKPiBEYXRlVGltZVZh ci5jOiBJbiBmdW5jdGlvbiCMRGF0ZVRpbWVWYXJfU2V0VmFsdWW5Ogo+IERhdGVUaW1lVmFyLmM6 ODE6IHdhcm5pbmc6IHVudXNlZCB2YXJpYWJsZSCMc3RhdHVzuQo+IEluIGZpbGUgaW5jbHVkZWQg ZnJvbSBjeF9PcmFjbGUuYzo3NjoKPiBTZXNzaW9uUG9vbC5jOiBJbiBmdW5jdGlvbiCMU2Vzc2lv blBvb2xfSW5pdLk6Cj4gU2Vzc2lvblBvb2wuYzoyNDY6IHdhcm5pbmc6IHBvaW50ZXIgdGFyZ2V0 cyBpbiBwYXNzaW5nIGFyZ3VtZW50IDYgb2YKPiCMT0NJU2Vzc2lvblBvb2xDcmVhdGW5IGRpZmZl ciBpbiBzaWduZWRuZXNzCj4gY3JlYXRpbmcgYnVpbGQvbGliLmxpbnV4LXg4Nl82NC0yLjQKPiBn Y2MgLXB0aHJlYWQgLXNoYXJlZCBidWlsZC90ZW1wLmxpbnV4LXg4Nl82NC0yLjQvY3hfT3JhY2xl Lm8KPiAtTC91c3IvbGliL29yYWNsZS8xMC4xLjAuMy9jbGllbnQvbGliL2xpYgo+IC1ML3Vzci9s aWIvb3JhY2xlLzEwLjEuMC4zL2NsaWVudC9saWIgLWxjbG50c2ggLW8KPiBidWlsZC9saWIubGlu dXgteDg2XzY0LTIuNC9jeF9PcmFjbGUuc28gLXMKPiByb290QGF0aGVuYTovdXNyL2xvY2FsL2J1 aWxkL1B5dGhvbi1DeE9yYWNsZS9jeF9PcmFjbGUtNC4xLjIjIHB5dGhvbgo+IHNldHVwLnB5IGlu c3RhbGwKPiBydW5uaW5nIGluc3RhbGwKPiBydW5uaW5nIGJ1aWxkCj4gcnVubmluZyBidWlsZF9l eHQKPiBydW5uaW5nIGluc3RhbGxfbGliCj4gY29weWluZyBidWlsZC9saWIubGludXgteDg2XzY0 LTIuNC9jeF9PcmFjbGUuc28gLT4KPiAvdXNyL2xpYi9weXRob24yLjQvc2l0ZS1wYWNrYWdlcwo+ Cj4gTm90IHN1cmUgaWYgdGhlc2Ugd2FybmluZ3MgYXJlIG5vcm1hbCBidXQgaGF2ZSBzZWVuIG90 aGVyIHBlb3BsZSBoYXZlIHRoZW0KPiBpbiB0aGUgcG9zdGluZ3MuCj4KPgo+Cj4gcm9vdEBhdGhl bmE6L3RtcCMgIGxkZCAvdXNyL2xpYi9weXRob24yLjQvc2l0ZS1wYWNrYWdlcy9jeF9PcmFjbGUu c28KPiAgICAgICAgIGxpYmNsbnRzaC5zby4xMC4xID0+Cj4gL3Vzci9saWIvb3JhY2xlLzEwLjEu MC4zL2NsaWVudC9saWIvbGliY2xudHNoLnNvLjEwLjEgKDB4MDAwMDJhYWFhYWJjMzAwMCkKPiAg ICAgICAgIGxpYnB0aHJlYWQuc28uMCA9PiAvbGliL2xpYnB0aHJlYWQuc28uMCAoMHgwMDAwMmFh YWFiYTdiMDAwKQo+ICAgICAgICAgbGliYy5zby42ID0+IC9saWIvbGliYy5zby42ICgweDAwMDAy YWFhYWJiOTAwMDApCj4gICAgICAgICBsaWJubnoxMC5zbyA9PiAvdXNyL2xpYi9vcmFjbGUvMTAu MS4wLjMvY2xpZW50L2xpYi9saWJubnoxMC5zbwo+ICgweDAwMDAyYWFhYWJkYzcwMDApCj4gICAg ICAgICBsaWJkbC5zby4yID0+IC9saWIvbGliZGwuc28uMiAoMHgwMDAwMmFhYWFjMDM4MDAwKQo+ ICAgICAgICAgbGlibS5zby42ID0+IC9saWIvbGlibS5zby42ICgweDAwMDAyYWFhYWMxM2EwMDAp Cj4gICAgICAgICBsaWJuc2wuc28uMSA9PiAvbGliL2xpYm5zbC5zby4xICgweDAwMDAyYWFhYWMy YmYwMDApCj4gICAgICAgICAvbGliNjQvbGQtbGludXgteDg2LTY0LnNvLjIgKDB4MDAwMDU1NTU1 NTU1NDAwMCkKPgo+Cj4gSSBnZXQgdGhlIGZvbGxvd2luZyBlcnJvciB3aGVuIHRyeWluZyB0byBy dW4gYSBzY3JpcHQKPgo+IFtNb24gRmViIDA2IDEwOjAwOjAxIDIwMDZdIFtlcnJvcl0gW2NsaWVu dCAxNDYuMTM3LjEuMzNdICAgRmlsZQo+ICIvdXNyL2xpYi9jZ2ktYmluL2N4T3JhY2xlLXRlc3Qu cHkiLCBsaW5lIDEwLCBpbiA/Cj4gW01vbiBGZWIgMDYgMTA6MDA6MDEgMjAwNl0gW2Vycm9yXSBb Y2xpZW50IDE0Ni4xMzcuMS4zM10gICAgIGNvbm5lY3Rpb24gPQo+IGN4X09yYWNsZS5jb25uZWN0 KCJlY3R1c2VyIiwgInh4eHh4eCIsICJlY3QxIik7Cj4gW01vbiBGZWIgMDYgMTA6MDA6MDEgMjAw Nl0gW2Vycm9yXSBbY2xpZW50IDE0Ni4xMzcuMS4zM10KPiBjeF9PcmFjbGUuRGF0YWJhc2VFcnJv cjogT1JBLTEyMTU0OiBUTlM6Y291bGQgbm90IHJlc29sdmUgdGhlIGNvbm5lY3QKPiBpZGVudGlm aWVyIHNwZWNpZmllZAo+IFtNb24gRmViIDA2IDEwOjAwOjAxIDIwMDZdIFtlcnJvcl0gW2NsaWVu dCAxNDYuMTM3LjEuMzNdCj4gW01vbiBGZWIgMDYgMTA6MDA6MDEgMjAwNl0gW2Vycm9yXSBbY2xp ZW50IDE0Ni4xMzcuMS4zM10gUHJlbWF0dXJlIGVuZCBvZgo+IHNjcmlwdCBoZWFkZXJzOiBjeE9y YWNsZS10ZXN0LnB5Cj4KPgo+IEl0IGFwcGVhcnMgdGhhdCBjeF9vcmFjbGUgY2FuIG5vdCBmaW5k IHRoZSB0bnMgYWRtaW4gZmlsZSB3aGlzaCBJIGRlZmluZWQgaW4KPiBteSBlbnZpcm9ubWVudC4K Pgo+IFRoYW5rIHlvdSBtdWNoLAo+Cj4gQ2hyaXMgUG9ldHplbAo+Cj4KPgo+IC0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0KPiBUaGlzIFNGLm5l dCBlbWFpbCBpcyBzcG9uc29yZWQgYnk6IFNwbHVuayBJbmMuIERvIHlvdSBncmVwIHRocm91Z2gg bG9nIGZpbGVzCj4gZm9yIHByb2JsZW1zPyAgU3RvcCEgIERvd25sb2FkIHRoZSBuZXcgQUpBWCBz ZWFyY2ggZW5naW5lIHRoYXQgbWFrZXMKPiBzZWFyY2hpbmcgeW91ciBsb2cgZmlsZXMgYXMgZWFz eSBhcyBzdXJmaW5nIHRoZSAgd2ViLiAgRE9XTkxPQUQgU1BMVU5LIQo+IGh0dHA6Ly9zZWwuYXMt dXMuZmFsa2FnLm5ldC9zZWw/Y21kbG5rJmtpZBAzNDMyJmJpZCMwNDg2JmRhdBIxNjQyCj4gX19f X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18KPiBjeC1vcmFjbGUt dXNlcnMgbWFpbGluZyBsaXN0Cj4gY3gtb3JhY2xlLXVzZXJzQGxpc3RzLnNvdXJjZWZvcmdlLm5l dAo+IGh0dHBzOi8vbGlzdHMuc291cmNlZm9yZ2UubmV0L2xpc3RzL2xpc3RpbmZvL2N4LW9yYWNs ZS11c2Vycwo+Cg== |
|
From: cpoetzel <cpo...@an...> - 2006-02-07 21:00:39
|
Anthony,
Thanks for the response.
I was able to get a connection and response when using a script as myself
with cx_Oracle.
However, when I try to run the same script from the web server, I get the
same error.
[Tue Feb 07 14:42:56 2006] [error] [client 146.137.1.33] ORA-12154:
TNS:could not resolve the connect identifier specified
I passed the web server the same env variables I have
Variable Value
LD_LIBRARY_PATH /usr/lib/oracle/10.1.0.3/client/lib
TNS_ADMIN /usr/lib/oracle/10.1.0.3/client
PATH /usr/local/bin:/usr/bin:/bin
PWD /etc/apache2
LANG C
SHLVL 1
ORACLE_HOME /usr/lib/oracle/10.1.0.3/client
_ /usr/sbin/apache2
Is there a way have a python program print out what tnsadmin.ora is looking
for when called from the web server?
There are only a handfull of python scripts that use cx_Oracle through the
web and if I have to statically set the env for TNS_ADMIN
I can live with that. I just don=E2=80=99t know how.
Thanks,
Chris Poetzel
On 2/7/06 10:06 AM, "Anthony Tuininga" <ant...@gm...> wrote:
> Its unfortunate that you don't have tnsping available as that tells
> you whether or not the Oracle client can find the tnsnames.ora file
> and whether it contains what you think it contains. :-) You do,
> however, have SQL*Plus so you should first verify that you can connect
> using it with the same connect string you are using with cx_Oracle.
> You can also make use of the cx_Oracle.make_dsn() method to generate
> the string that is normally found in a tnsnames.ora file and use that
> to connect. If you want to know which locations Oracle is searching
> for tnsnames.ora you can use the strace command -- there are several
> places. Hope this helps you track down the issue.
>=20
> On 2/6/06, cpoetzel <cpo...@an...> wrote:
>> > Hi,
>> > I am trying to install cx_Oracle 4.1.2 on a new Ubuntu Breezy Box. Its=
a
>> > 64bit amd box.
>> > I have already installed the oracle 10.1.0.3 64 bit instant client.
>> > Install looks like this
>> >
>> > root@athena:/usr/lib/oracle/10.1.0.3/client# ls -R
>> > .:
>> > bin lib tnsnames.ora
>> >
>> > ./bin:
>> > sqlplus
>> >
>> > ./lib:
>> > classes12.jar glogin.sql libclntsh.so libclntsh.so.10.1 libnnz10.s=
o
>> > libocci.so libocci.so.10.1 libociei.so libocijdbc10.so libsqlplus.=
so
>> > ojdbc14.jar sdk
>> >
>> > ./lib/sdk:
>> > demo include
>> >
>> > ./lib/sdk/demo:
>> > cdemo81.c demo.mk occidemod.sql occidemo.sql occidml.cpp
>> >
>> > ./lib/sdk/include:
>> > nzerror.h occiAQ.h occiControl.h occi.h oci1.h ociap=
.h
>> > ocidef.h ocidfn.h oci.h ocixmldb.h oratypes.h ori.h oro.h x=
a.h
>> > nzt.h occiCommon.h occiData.h occiObjects.h oci8dp.h ociap=
r.h
>> > ocidem.h ociextp.h ocikpr.h odci.h orid.h orl.h ort.h
>> >
>> >
>> > Env:
>> > ORACLE_HOME=3D/usr/lib/oracle/10.1.0.3/client/lib
>> > TNS_ADMIN=3D/usr/lib/oracle/10.1.0.3/client
>> > LD_LIBRARY_PATH=3D/usr/lib/oracle/10.1.0.3/client/lib
>> >
>> >
>> > Installing the client:
>> > root@athena:/usr/local/build/Python-CxOracle/cx_Oracle-4.1.2# python
>> > setup.py build
>> > running build
>> > running build_ext
>> > building 'cx_Oracle' extension
>> > creating build
>> > creating build/temp.linux-x86_64-2.4
>> > gcc -pthread -fno-strict-aliasing -DNDEBUG -g -O3 -Wall -Wstrict-proto=
types
>> > -fPIC -I/usr/lib/oracle/10.1.0.3/client/lib/rdbms/demo
>> > -I/usr/lib/oracle/10.1.0.3/client/lib/rdbms/public
>> > -I/usr/lib/oracle/10.1.0.3/client/lib/network/public
>> > -I/usr/lib/oracle/10.1.0.3/client/lib/sdk/include -I/usr/include/pytho=
n2.4
>> > -c cx_Oracle.c -o build/temp.linux-x86_64-2.4/cx_Oracle.o
>> > -DBUILD_TIME=3D"February 06, 2006 10:21:45"
>> > In file included from
>> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/oci.h:2327,
>> > from cx_Oracle.c:9:
>> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/oci1.h:148: warning:
>> > function declaration isn=C2=B9t a prototype
>> > In file included from
>> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/ociap.h:206,
>> > from
>> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/oci.h:2351,
>> > from cx_Oracle.c:9:
>> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:674: warning:
>> function
>> > declaration isn=C2=B9t a prototype
>> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2665: warning:
>> > function declaration isn=C2=B9t a prototype
>> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2674: warning:
>> > function declaration isn=C2=B9t a prototype
>> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2684: warning:
>> > function declaration isn=C2=B9t a prototype
>> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2693: warning:
>> > function declaration isn=C2=B9t a prototype
>> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2702: warning:
>> > function declaration isn=C2=B9t a prototype
>> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2711: warning:
>> > function declaration isn=C2=B9t a prototype
>> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2719: warning:
>> > function declaration isn=C2=B9t a prototype
>> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2729: warning:
>> > function declaration isn=C2=B9t a prototype
>> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2736: warning:
>> > function declaration isn=C2=B9t a prototype
>> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2744: warning:
>> > function declaration isn=C2=B9t a prototype
>> > In file included from
>> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/oci.h:2351,
>> > from cx_Oracle.c:9:
>> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/ociap.h:9952: warning:
>> > function declaration isn=C2=B9t a prototype
>> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/ociap.h:9958: warning:
>> > function declaration isn=C2=B9t a prototype
>> > In file included from SessionPool.c:134,
>> > from cx_Oracle.c:76:
>> > Connection.c: In function =C5=92Connection_Acquire=C2=B9:
>> > Connection.c:184: warning: pointer targets in passing argument 5 of
>> > =C5=92OCISessionGet=C2=B9 differ in signedness
>> > In file included from Variable.c:89,
>> > from Cursor.c:211,
>> > from Connection.c:354,
>> > from SessionPool.c:134,
>> > from cx_Oracle.c:76:
>> > NumberVar.c: In function =C5=92NumberVar_SetValue=C2=B9:
>> > NumberVar.c:178: warning: pointer targets in passing argument 2 of
>> > =C5=92OCINumberFromText=C2=B9 differ in signedness
>> > NumberVar.c:178: warning: pointer targets in passing argument 4 of
>> > =C5=92OCINumberFromText=C2=B9 differ in signedness
>> > In file included from Variable.c:93,
>> > from Cursor.c:211,
>> > from Connection.c:354,
>> > from SessionPool.c:134,
>> > from cx_Oracle.c:76:
>> > DateTimeVar.c: In function =C5=92DateTimeVar_SetValue=C2=B9:
>> > DateTimeVar.c:81: warning: unused variable =C5=92status=C2=B9
>> > In file included from cx_Oracle.c:76:
>> > SessionPool.c: In function =C5=92SessionPool_Init=C2=B9:
>> > SessionPool.c:246: warning: pointer targets in passing argument 6 of
>> > =C5=92OCISessionPoolCreate=C2=B9 differ in signedness
>> > creating build/lib.linux-x86_64-2.4
>> > gcc -pthread -shared build/temp.linux-x86_64-2.4/cx_Oracle.o
>> > -L/usr/lib/oracle/10.1.0.3/client/lib/lib
>> > -L/usr/lib/oracle/10.1.0.3/client/lib -lclntsh -o
>> > build/lib.linux-x86_64-2.4/cx_Oracle.so -s
>> > root@athena:/usr/local/build/Python-CxOracle/cx_Oracle-4.1.2# python
>> > setup.py install
>> > running install
>> > running build
>> > running build_ext
>> > running install_lib
>> > copying build/lib.linux-x86_64-2.4/cx_Oracle.so ->
>> > /usr/lib/python2.4/site-packages
>> >
>> > Not sure if these warnings are normal but have seen other people have =
them
>> > in the postings.
>> >
>> >
>> >
>> > root@athena:/tmp# ldd /usr/lib/python2.4/site-packages/cx_Oracle.so
>> > libclntsh.so.10.1 =3D>
>> > /usr/lib/oracle/10.1.0.3/client/lib/libclntsh.so.10.1 (0x00002aaaaabc3=
000)
>> > libpthread.so.0 =3D> /lib/libpthread.so.0 (0x00002aaaaba7b000)
>> > libc.so.6 =3D> /lib/libc.so.6 (0x00002aaaabb90000)
>> > libnnz10.so =3D> /usr/lib/oracle/10.1.0.3/client/lib/libnnz10.so
>> > (0x00002aaaabdc7000)
>> > libdl.so.2 =3D> /lib/libdl.so.2 (0x00002aaaac038000)
>> > libm.so.6 =3D> /lib/libm.so.6 (0x00002aaaac13a000)
>> > libnsl.so.1 =3D> /lib/libnsl.so.1 (0x00002aaaac2bf000)
>> > /lib64/ld-linux-x86-64.so.2 (0x0000555555554000)
>> >
>> >
>> > I get the following error when trying to run a script
>> >
>> > [Mon Feb 06 10:00:01 2006] [error] [client 146.137.1.33] File
>> > "/usr/lib/cgi-bin/cxOracle-test.py", line 10, in ?
>> > [Mon Feb 06 10:00:01 2006] [error] [client 146.137.1.33] connectio=
n =3D
>> > cx_Oracle.connect("ectuser", "xxxxxx", "ect1");
>> > [Mon Feb 06 10:00:01 2006] [error] [client 146.137.1.33]
>> > cx_Oracle.DatabaseError: ORA-12154: TNS:could not resolve the connect
>> > identifier specified
>> > [Mon Feb 06 10:00:01 2006] [error] [client 146.137.1.33]
>> > [Mon Feb 06 10:00:01 2006] [error] [client 146.137.1.33] Premature end=
of
>> > script headers: cxOracle-test.py
>> >
>> >
>> > It appears that cx_oracle can not find the tns admin file whish I defi=
ned
>> in
>> > my environment.
>> >
>> > Thank you much,
>> >
>> > Chris Poetzel
>> >
>> >
>> >
>> > -------------------------------------------------------
>> > This SF.net email is sponsored by: Splunk Inc. Do you grep through log
>> files
>> > for problems? Stop! Download the new AJAX search engine that makes
>> > searching your log files as easy as surfing the web. DOWNLOAD SPLUNK=
!
>> > http://sel.as-us.falkag.net/sel?cmdlnk
>> <http://sel.as-us.falkag.net/sel?cmdlnk&kid> =103432&bid#0486&dat=121642
>> > _______________________________________________
>> > cx-oracle-users mailing list
>> > cx-...@li...
>> > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>> >
> NH=C2=B5=C5=A0=C2=B2=C2=B2u=C2=A6=C2=90=0E=C2=BA=C2=A6=C2=A2=E2=80=93=C5=A0~=C2=AEz=C2=B6=C2=A3=C2=A1=E2=80=A6=C3=80^=C2=AD=C5=BEz=C2=B6zj=C5=A0=C2=A2=C2=A2=E2=80=A2=C2=B1=C3=89=C2=BA=C5=BE{=0C,H=
4=C2=B6=C2=B1=C2=B2j=E2=80=9A=C3=BE
>=20
|
|
From: Anthony T. <ant...@gm...> - 2006-02-07 21:25:28
|
T24gMi83LzA2LCBjcG9ldHplbCA8Y3BvZXR6ZWxAYW5sLmdvdj4gd3JvdGU6Cj4gIEFudGhvbnks Cj4gIFRoYW5rcyBmb3IgdGhlIHJlc3BvbnNlLgo+ICBJIHdhcyBhYmxlIHRvIGdldCBhIGNvbm5l Y3Rpb24gYW5kIHJlc3BvbnNlIHdoZW4gdXNpbmcgYSBzY3JpcHQgYXMgbXlzZWxmCj4gd2l0aCBj eF9PcmFjbGUuCj4KPiAgSG93ZXZlciwgd2hlbiBJIHRyeSB0byBydW4gdGhlIHNhbWUgc2NyaXB0 IGZyb20gdGhlIHdlYiBzZXJ2ZXIsIEkgZ2V0IHRoZQo+IHNhbWUgZXJyb3IuCj4gIFtUdWUgRmVi IDA3IDE0OjQyOjU2IDIwMDZdIFtlcnJvcl0gW2NsaWVudCAxNDYuMTM3LjEuMzNdIE9SQS0xMjE1 NDoKPiBUTlM6Y291bGQgbm90IHJlc29sdmUgdGhlIGNvbm5lY3QgaWRlbnRpZmllciBzcGVjaWZp ZWQKPgo+ICBJIHBhc3NlZCB0aGUgd2ViIHNlcnZlciB0aGUgc2FtZSBlbnYgdmFyaWFibGVzIEkg aGF2ZQo+Cj4gIFZhcmlhYmxlICAgIFZhbHVlCj4gIExEX0xJQlJBUllfUEFUSCAgICAvdXNyL2xp Yi9vcmFjbGUvMTAuMS4wLjMvY2xpZW50L2xpYgo+ICBUTlNfQURNSU4gICAgL3Vzci9saWIvb3Jh Y2xlLzEwLjEuMC4zL2NsaWVudAo+ICBQQVRIICAgIC91c3IvbG9jYWwvYmluOi91c3IvYmluOi9i aW4KPiAgUFdEICAgIC9ldGMvYXBhY2hlMgo+ICBMQU5HICAgIEMKPiAgU0hMVkwgICAgMQo+ICBP UkFDTEVfSE9NRSAgICAvdXNyL2xpYi9vcmFjbGUvMTAuMS4wLjMvY2xpZW50Cj4gIF8gICAgL3Vz ci9zYmluL2FwYWNoZTIKPgo+Cj4gIElzIHRoZXJlIGEgd2F5IGhhdmUgYSBweXRob24gcHJvZ3Jh bSBwcmludCBvdXQgd2hhdCB0bnNhZG1pbi5vcmEgaXMgbG9va2luZwo+IGZvciB3aGVuIGNhbGxl ZCBmcm9tIHRoZSB3ZWIgc2VydmVyPwoKTm8gaWRlYS4KCj4gIFRoZXJlIGFyZSBvbmx5IGEgaGFu ZGZ1bGwgb2YgcHl0aG9uIHNjcmlwdHMgdGhhdCB1c2UgY3hfT3JhY2xlIHRocm91Z2ggdGhlCj4g d2ViIGFuZCBpZiBJIGhhdmUgdG8gc3RhdGljYWxseSBzZXQgdGhlIGVudiBmb3IgVE5TX0FETUlO Cj4gIEkgY2FuIGxpdmUgd2l0aCB0aGF0LiBJIGp1c3QgZG9uJ3Qga25vdyBob3cuCgpOb3QgY2Vy dGFpbiBvZiB0aGF0LCBlaXRoZXIuIENhbiB5b3UgbWFrZSBhIHN1Y2Nlc3NmdWwgY29ubmVjdGlv bgp1c2luZyB0aGUgY29ubmVjdCBzdHJpbmcgZ2VuZXJhdGVkIGJ5IG1ha2VfZHNuKCk/IFRoYXQg bWF5IGJlIGEKd29ya2Fyb3VuZCB5b3UgY2FuIHVzZSBmb3Igbm93LiBCZXlvbmQgdGhhdCB5b3Un bGwgaGF2ZSB0byBnZXQgaW50bwpkaWFnbm9zaW5nIHdoeSB0aGUgd2ViIGVudmlyb25tZW50IGlz IGRpZmZlcmVudCAtLSBhbmQgSSBkb250IGhhdmUKbXVjaCBleHBlcmllbmNlIG9uIHRoYXQgZnJv bnQuIFBlcmhhcHMgb3RoZXJzIGNhbiBoZWxwPwoKPiAgVGhhbmtzLAo+ICBDaHJpcyBQb2V0emVs Cj4KPgo+Cj4gIE9uIDIvNy8wNiAxMDowNiBBTSwgIkFudGhvbnkgVHVpbmluZ2EiIDxhbnRob255 LnR1aW5pbmdhQGdtYWlsLmNvbT4gd3JvdGU6Cj4KPgo+IEl0cyB1bmZvcnR1bmF0ZSB0aGF0IHlv dSBkb24ndCBoYXZlIHRuc3BpbmcgYXZhaWxhYmxlIGFzIHRoYXQgdGVsbHMKPiAgeW91IHdoZXRo ZXIgb3Igbm90IHRoZSBPcmFjbGUgY2xpZW50IGNhbiBmaW5kIHRoZSB0bnNuYW1lcy5vcmEgZmls ZQo+ICBhbmQgd2hldGhlciBpdCBjb250YWlucyB3aGF0IHlvdSB0aGluayBpdCBjb250YWlucy4g Oi0pICBZb3UgZG8sCj4gIGhvd2V2ZXIsIGhhdmUgU1FMKlBsdXMgc28geW91IHNob3VsZCBmaXJz dCB2ZXJpZnkgdGhhdCB5b3UgY2FuIGNvbm5lY3QKPiAgdXNpbmcgaXQgd2l0aCB0aGUgc2FtZSBj b25uZWN0IHN0cmluZyB5b3UgYXJlIHVzaW5nIHdpdGggY3hfT3JhY2xlLgo+ICBZb3UgY2FuIGFs c28gbWFrZSB1c2Ugb2YgdGhlIGN4X09yYWNsZS5tYWtlX2RzbigpIG1ldGhvZCB0byBnZW5lcmF0 ZQo+ICB0aGUgc3RyaW5nIHRoYXQgaXMgbm9ybWFsbHkgZm91bmQgaW4gYSB0bnNuYW1lcy5vcmEg ZmlsZSBhbmQgdXNlIHRoYXQKPiAgdG8gY29ubmVjdC4gSWYgeW91IHdhbnQgdG8ga25vdyB3aGlj aCBsb2NhdGlvbnMgT3JhY2xlIGlzIHNlYXJjaGluZwo+ICBmb3IgdG5zbmFtZXMub3JhIHlvdSBj YW4gdXNlIHRoZSBzdHJhY2UgY29tbWFuZCAtLSB0aGVyZSBhcmUgc2V2ZXJhbAo+ICBwbGFjZXMu IEhvcGUgdGhpcyBoZWxwcyB5b3UgdHJhY2sgZG93biB0aGUgaXNzdWUuCj4KPiAgT24gMi82LzA2 LCBjcG9ldHplbCA8Y3BvZXR6ZWxAYW5sLmdvdj4gd3JvdGU6Cj4gID4gSGksCj4gID4gSSBhbSB0 cnlpbmcgdG8gaW5zdGFsbCBjeF9PcmFjbGUgNC4xLjIgb24gYSBuZXcgVWJ1bnR1IEJyZWV6eSBC b3guIEl0cyBhCj4gID4gNjRiaXQgYW1kIGJveC4KPiAgPiBJIGhhdmUgYWxyZWFkeSBpbnN0YWxs ZWQgdGhlIG9yYWNsZSAxMC4xLjAuMyA2NCBiaXQgaW5zdGFudCBjbGllbnQuCj4gID4gSW5zdGFs bCBsb29rcyBsaWtlIHRoaXMKPiAgPgo+ICA+IHJvb3RAYXRoZW5hOi91c3IvbGliL29yYWNsZS8x MC4xLjAuMy9jbGllbnQjIGxzIC1SCj4gID4gLjoKPiAgPiBiaW4gIGxpYiAgdG5zbmFtZXMub3Jh Cj4gID4KPiAgPiAuL2JpbjoKPiAgPiBzcWxwbHVzCj4gID4KPiAgPiAuL2xpYjoKPiAgPiBjbGFz c2VzMTIuamFyICBnbG9naW4uc3FsICBsaWJjbG50c2guc28gIGxpYmNsbnRzaC5zby4xMC4xICBs aWJubnoxMC5zbwo+ICA+IGxpYm9jY2kuc28gIGxpYm9jY2kuc28uMTAuMSAgbGlib2NpZWkuc28g IGxpYm9jaWpkYmMxMC5zbyAgbGlic3FscGx1cy5zbwo+ICA+IG9qZGJjMTQuamFyICBzZGsKPiAg Pgo+ICA+IC4vbGliL3NkazoKPiAgPiBkZW1vICBpbmNsdWRlCj4gID4KPiAgPiAuL2xpYi9zZGsv ZGVtbzoKPiAgPiBjZGVtbzgxLmMgIGRlbW8ubWsgIG9jY2lkZW1vZC5zcWwgIG9jY2lkZW1vLnNx bCAgb2NjaWRtbC5jcHAKPiAgPgo+ICA+IC4vbGliL3Nkay9pbmNsdWRlOgo+ICA+IG56ZXJyb3Iu aCAgb2NjaUFRLmggICAgICBvY2NpQ29udHJvbC5oICBvY2NpLmggICAgICAgICBvY2kxLmggICAg b2NpYXAuaAo+ICA+IG9jaWRlZi5oICBvY2lkZm4uaCAgIG9jaS5oICAgICBvY2l4bWxkYi5oICBv cmF0eXBlcy5oICBvcmkuaCAgb3JvLmggIHhhLmgKPiAgPiBuenQuaCAgICAgIG9jY2lDb21tb24u aCAgb2NjaURhdGEuaCAgICAgb2NjaU9iamVjdHMuaCAgb2NpOGRwLmggIG9jaWFwci5oCj4gID4g b2NpZGVtLmggIG9jaWV4dHAuaCAgb2Npa3ByLmggIG9kY2kuaCAgICAgIG9yaWQuaCAgICAgIG9y bC5oICBvcnQuaAo+ICA+Cj4gID4KPiAgPiBFbnY6Cj4gID4gT1JBQ0xFX0hPTUU9L3Vzci9saWIv b3JhY2xlLzEwLjEuMC4zL2NsaWVudC9saWIKPiAgPiBUTlNfQURNSU49L3Vzci9saWIvb3JhY2xl LzEwLjEuMC4zL2NsaWVudAo+ICA+IExEX0xJQlJBUllfUEFUSD0vdXNyL2xpYi9vcmFjbGUvMTAu MS4wLjMvY2xpZW50L2xpYgo+ICA+Cj4gID4KPiAgPiBJbnN0YWxsaW5nIHRoZSBjbGllbnQ6Cj4g ID4KPiByb290QGF0aGVuYTovdXNyL2xvY2FsL2J1aWxkL1B5dGhvbi1DeE9yYWNsZS9jeF9PcmFj bGUtNC4xLjIjCj4gcHl0aG9uCj4gID4gc2V0dXAucHkgYnVpbGQKPiAgPiBydW5uaW5nIGJ1aWxk Cj4gID4gcnVubmluZyBidWlsZF9leHQKPiAgPiBidWlsZGluZyAnY3hfT3JhY2xlJyBleHRlbnNp b24KPiAgPiBjcmVhdGluZyBidWlsZAo+ICA+IGNyZWF0aW5nIGJ1aWxkL3RlbXAubGludXgteDg2 XzY0LTIuNAo+ICA+IGdjYyAtcHRocmVhZCAtZm5vLXN0cmljdC1hbGlhc2luZyAtRE5ERUJVRyAt ZyAtTzMgLVdhbGwKPiAtV3N0cmljdC1wcm90b3R5cGVzCj4gID4gLWZQSUMgLUkvdXNyL2xpYi9v cmFjbGUvMTAuMS4wLjMvY2xpZW50L2xpYi9yZGJtcy9kZW1vCj4gID4gLUkvdXNyL2xpYi9vcmFj bGUvMTAuMS4wLjMvY2xpZW50L2xpYi9yZGJtcy9wdWJsaWMKPiAgPiAtSS91c3IvbGliL29yYWNs ZS8xMC4xLjAuMy9jbGllbnQvbGliL25ldHdvcmsvcHVibGljCj4gID4gLUkvdXNyL2xpYi9vcmFj bGUvMTAuMS4wLjMvY2xpZW50L2xpYi9zZGsvaW5jbHVkZQo+IC1JL3Vzci9pbmNsdWRlL3B5dGhv bjIuNAo+ICA+IC1jIGN4X09yYWNsZS5jIC1vIGJ1aWxkL3RlbXAubGludXgteDg2XzY0LTIuNC9j eF9PcmFjbGUubwo+ICA+IC1EQlVJTERfVElNRT0iRmVicnVhcnkgMDYsIDIwMDYgMTA6MjE6NDUi Cj4gID4gSW4gZmlsZSBpbmNsdWRlZCBmcm9tCj4gID4KPiAvdXNyL2xpYi9vcmFjbGUvMTAuMS4w LjMvY2xpZW50L2xpYi9zZGsvaW5jbHVkZS9vY2kuaDoyMzI3LAo+ICA+ICAgICAgICAgICAgICAg ICAgZnJvbSBjeF9PcmFjbGUuYzo5Ogo+ICA+Cj4gL3Vzci9saWIvb3JhY2xlLzEwLjEuMC4zL2Ns aWVudC9saWIvc2RrL2luY2x1ZGUvb2NpMS5oOjE0ODoKPiB3YXJuaW5nOgo+ICA+IGZ1bmN0aW9u IGRlY2xhcmF0aW9uIGlzbsK5dCBhIHByb3RvdHlwZQo+ICA+IEluIGZpbGUgaW5jbHVkZWQgZnJv bQo+ICA+Cj4gL3Vzci9saWIvb3JhY2xlLzEwLjEuMC4zL2NsaWVudC9saWIvc2RrL2luY2x1ZGUv b2NpYXAuaDoyMDYsCj4gID4gICAgICAgICAgICAgICAgICBmcm9tCj4gID4KPiAvdXNyL2xpYi9v cmFjbGUvMTAuMS4wLjMvY2xpZW50L2xpYi9zZGsvaW5jbHVkZS9vY2kuaDoyMzUxLAo+ICA+ICAg ICAgICAgICAgICAgICAgZnJvbSBjeF9PcmFjbGUuYzo5Ogo+ICA+Cj4gL3Vzci9saWIvb3JhY2xl LzEwLjEuMC4zL2NsaWVudC9saWIvc2RrL2luY2x1ZGUvbnp0Lmg6Njc0Ogo+IHdhcm5pbmc6IGZ1 bmN0aW9uCj4gID4gZGVjbGFyYXRpb24gaXNuwrl0IGEgcHJvdG90eXBlCj4gID4KPiAvdXNyL2xp Yi9vcmFjbGUvMTAuMS4wLjMvY2xpZW50L2xpYi9zZGsvaW5jbHVkZS9uenQuaDoyNjY1Ogo+IHdh cm5pbmc6Cj4gID4gZnVuY3Rpb24gZGVjbGFyYXRpb24gaXNuwrl0IGEgcHJvdG90eXBlCj4gID4K PiAvdXNyL2xpYi9vcmFjbGUvMTAuMS4wLjMvY2xpZW50L2xpYi9zZGsvaW5jbHVkZS9uenQuaDoy Njc0Ogo+IHdhcm5pbmc6Cj4gID4gZnVuY3Rpb24gZGVjbGFyYXRpb24gaXNuwrl0IGEgcHJvdG90 eXBlCj4gID4KPiAvdXNyL2xpYi9vcmFjbGUvMTAuMS4wLjMvY2xpZW50L2xpYi9zZGsvaW5jbHVk ZS9uenQuaDoyNjg0Ogo+IHdhcm5pbmc6Cj4gID4gZnVuY3Rpb24gZGVjbGFyYXRpb24gaXNuwrl0 IGEgcHJvdG90eXBlCj4gID4KPiAvdXNyL2xpYi9vcmFjbGUvMTAuMS4wLjMvY2xpZW50L2xpYi9z ZGsvaW5jbHVkZS9uenQuaDoyNjkzOgo+IHdhcm5pbmc6Cj4gID4gZnVuY3Rpb24gZGVjbGFyYXRp b24gaXNuwrl0IGEgcHJvdG90eXBlCj4gID4KPiAvdXNyL2xpYi9vcmFjbGUvMTAuMS4wLjMvY2xp ZW50L2xpYi9zZGsvaW5jbHVkZS9uenQuaDoyNzAyOgo+IHdhcm5pbmc6Cj4gID4gZnVuY3Rpb24g ZGVjbGFyYXRpb24gaXNuwrl0IGEgcHJvdG90eXBlCj4gID4KPiAvdXNyL2xpYi9vcmFjbGUvMTAu MS4wLjMvY2xpZW50L2xpYi9zZGsvaW5jbHVkZS9uenQuaDoyNzExOgo+IHdhcm5pbmc6Cj4gID4g ZnVuY3Rpb24gZGVjbGFyYXRpb24gaXNuwrl0IGEgcHJvdG90eXBlCj4gID4KPiAvdXNyL2xpYi9v cmFjbGUvMTAuMS4wLjMvY2xpZW50L2xpYi9zZGsvaW5jbHVkZS9uenQuaDoyNzE5Ogo+IHdhcm5p bmc6Cj4gID4gZnVuY3Rpb24gZGVjbGFyYXRpb24gaXNuwrl0IGEgcHJvdG90eXBlCj4gID4KPiAv dXNyL2xpYi9vcmFjbGUvMTAuMS4wLjMvY2xpZW50L2xpYi9zZGsvaW5jbHVkZS9uenQuaDoyNzI5 Ogo+IHdhcm5pbmc6Cj4gID4gZnVuY3Rpb24gZGVjbGFyYXRpb24gaXNuwrl0IGEgcHJvdG90eXBl Cj4gID4KPiAvdXNyL2xpYi9vcmFjbGUvMTAuMS4wLjMvY2xpZW50L2xpYi9zZGsvaW5jbHVkZS9u enQuaDoyNzM2Ogo+IHdhcm5pbmc6Cj4gID4gZnVuY3Rpb24gZGVjbGFyYXRpb24gaXNuwrl0IGEg cHJvdG90eXBlCj4gID4KPiAvdXNyL2xpYi9vcmFjbGUvMTAuMS4wLjMvY2xpZW50L2xpYi9zZGsv aW5jbHVkZS9uenQuaDoyNzQ0Ogo+IHdhcm5pbmc6Cj4gID4gZnVuY3Rpb24gZGVjbGFyYXRpb24g aXNuwrl0IGEgcHJvdG90eXBlCj4gID4gSW4gZmlsZSBpbmNsdWRlZCBmcm9tCj4gID4KPiAvdXNy L2xpYi9vcmFjbGUvMTAuMS4wLjMvY2xpZW50L2xpYi9zZGsvaW5jbHVkZS9vY2kuaDoyMzUxLAo+ ICA+ICAgICAgICAgICAgICAgICAgZnJvbSBjeF9PcmFjbGUuYzo5Ogo+ICA+Cj4gL3Vzci9saWIv b3JhY2xlLzEwLjEuMC4zL2NsaWVudC9saWIvc2RrL2luY2x1ZGUvb2NpYXAuaDo5OTUyOgo+IHdh cm5pbmc6Cj4gID4gZnVuY3Rpb24gZGVjbGFyYXRpb24gaXNuwrl0IGEgcHJvdG90eXBlCj4gID4K PiAvdXNyL2xpYi9vcmFjbGUvMTAuMS4wLjMvY2xpZW50L2xpYi9zZGsvaW5jbHVkZS9vY2lhcC5o Ojk5NTg6Cj4gd2FybmluZzoKPiAgPiBmdW5jdGlvbiBkZWNsYXJhdGlvbiBpc27CuXQgYSBwcm90 b3R5cGUKPiAgPiBJbiBmaWxlIGluY2x1ZGVkIGZyb20gU2Vzc2lvblBvb2wuYzoxMzQsCj4gID4g ICAgICAgICAgICAgICAgICBmcm9tIGN4X09yYWNsZS5jOjc2Ogo+ICA+IENvbm5lY3Rpb24uYzog SW4gZnVuY3Rpb24gxZJDb25uZWN0aW9uX0FjcXVpcmXCuToKPiAgPiBDb25uZWN0aW9uLmM6MTg0 OiB3YXJuaW5nOiBwb2ludGVyIHRhcmdldHMgaW4gcGFzc2luZyBhcmd1bWVudCA1IG9mCj4gID4g xZJPQ0lTZXNzaW9uR2V0wrkgZGlmZmVyIGluIHNpZ25lZG5lc3MKPiAgPiBJbiBmaWxlIGluY2x1 ZGVkIGZyb20gVmFyaWFibGUuYzo4OSwKPiAgPiAgICAgICAgICAgICAgICAgIGZyb20gQ3Vyc29y LmM6MjExLAo+ICA+ICAgICAgICAgICAgICAgICAgZnJvbSBDb25uZWN0aW9uLmM6MzU0LAo+ICA+ ICAgICAgICAgICAgICAgICAgZnJvbSBTZXNzaW9uUG9vbC5jOjEzNCwKPiAgPiAgICAgICAgICAg ICAgICAgIGZyb20gY3hfT3JhY2xlLmM6NzY6Cj4gID4gTnVtYmVyVmFyLmM6IEluIGZ1bmN0aW9u IMWSTnVtYmVyVmFyX1NldFZhbHVlwrk6Cj4gID4gTnVtYmVyVmFyLmM6MTc4OiB3YXJuaW5nOiBw b2ludGVyIHRhcmdldHMgaW4gcGFzc2luZyBhcmd1bWVudCAyIG9mCj4gID4gxZJPQ0lOdW1iZXJG cm9tVGV4dMK5IGRpZmZlciBpbiBzaWduZWRuZXNzCj4gID4gTnVtYmVyVmFyLmM6MTc4OiB3YXJu aW5nOiBwb2ludGVyIHRhcmdldHMgaW4gcGFzc2luZyBhcmd1bWVudCA0IG9mCj4gID4gxZJPQ0lO dW1iZXJGcm9tVGV4dMK5IGRpZmZlciBpbiBzaWduZWRuZXNzCj4gID4gSW4gZmlsZSBpbmNsdWRl ZCBmcm9tIFZhcmlhYmxlLmM6OTMsCj4gID4gICAgICAgICAgICAgICAgICBmcm9tIEN1cnNvci5j OjIxMSwKPiAgPiAgICAgICAgICAgICAgICAgIGZyb20gQ29ubmVjdGlvbi5jOjM1NCwKPiAgPiAg ICAgICAgICAgICAgICAgIGZyb20gU2Vzc2lvblBvb2wuYzoxMzQsCj4gID4gICAgICAgICAgICAg ICAgICBmcm9tIGN4X09yYWNsZS5jOjc2Ogo+ICA+IERhdGVUaW1lVmFyLmM6IEluIGZ1bmN0aW9u IMWSRGF0ZVRpbWVWYXJfU2V0VmFsdWXCuToKPiAgPiBEYXRlVGltZVZhci5jOjgxOiB3YXJuaW5n OiB1bnVzZWQgdmFyaWFibGUgxZJzdGF0dXPCuQo+ICA+IEluIGZpbGUgaW5jbHVkZWQgZnJvbSBj eF9PcmFjbGUuYzo3NjoKPiAgPiBTZXNzaW9uUG9vbC5jOiBJbiBmdW5jdGlvbiDFklNlc3Npb25Q b29sX0luaXTCuToKPiAgPiBTZXNzaW9uUG9vbC5jOjI0Njogd2FybmluZzogcG9pbnRlciB0YXJn ZXRzIGluIHBhc3NpbmcgYXJndW1lbnQgNiBvZgo+ICA+IMWST0NJU2Vzc2lvblBvb2xDcmVhdGXC uSBkaWZmZXIgaW4gc2lnbmVkbmVzcwo+ICA+IGNyZWF0aW5nIGJ1aWxkL2xpYi5saW51eC14ODZf NjQtMi40Cj4gID4gZ2NjIC1wdGhyZWFkIC1zaGFyZWQgYnVpbGQvdGVtcC5saW51eC14ODZfNjQt Mi40L2N4X09yYWNsZS5vCj4gID4gLUwvdXNyL2xpYi9vcmFjbGUvMTAuMS4wLjMvY2xpZW50L2xp Yi9saWIKPiAgPiAtTC91c3IvbGliL29yYWNsZS8xMC4xLjAuMy9jbGllbnQvbGliIC1sY2xudHNo IC1vCj4gID4gYnVpbGQvbGliLmxpbnV4LXg4Nl82NC0yLjQvY3hfT3JhY2xlLnNvIC1zCj4gID4K PiByb290QGF0aGVuYTovdXNyL2xvY2FsL2J1aWxkL1B5dGhvbi1DeE9yYWNsZS9jeF9PcmFjbGUt NC4xLjIjCj4gcHl0aG9uCj4gID4gc2V0dXAucHkgaW5zdGFsbAo+ICA+IHJ1bm5pbmcgaW5zdGFs bAo+ICA+IHJ1bm5pbmcgYnVpbGQKPiAgPiBydW5uaW5nIGJ1aWxkX2V4dAo+ICA+IHJ1bm5pbmcg aW5zdGFsbF9saWIKPiAgPiBjb3B5aW5nIGJ1aWxkL2xpYi5saW51eC14ODZfNjQtMi40L2N4X09y YWNsZS5zbyAtPgo+ICA+IC91c3IvbGliL3B5dGhvbjIuNC9zaXRlLXBhY2thZ2VzCj4gID4KPiAg PiBOb3Qgc3VyZSBpZiB0aGVzZSB3YXJuaW5ncyBhcmUgbm9ybWFsIGJ1dCBoYXZlIHNlZW4gb3Ro ZXIgcGVvcGxlIGhhdmUKPiB0aGVtCj4gID4gaW4gdGhlIHBvc3RpbmdzLgo+ICA+Cj4gID4KPiAg Pgo+ICA+IHJvb3RAYXRoZW5hOi90bXAjICBsZGQKPiAvdXNyL2xpYi9weXRob24yLjQvc2l0ZS1w YWNrYWdlcy9jeF9PcmFjbGUuc28KPiAgPiAgICAgICAgIGxpYmNsbnRzaC5zby4xMC4xID0+Cj4g ID4gL3Vzci9saWIvb3JhY2xlLzEwLjEuMC4zL2NsaWVudC9saWIvbGliY2xudHNoLnNvLjEwLjEK PiAoMHgwMDAwMmFhYWFhYmMzMDAwKQo+ICA+ICAgICAgICAgbGlicHRocmVhZC5zby4wID0+IC9s aWIvbGlicHRocmVhZC5zby4wICgweDAwMDAyYWFhYWJhN2IwMDApCj4gID4gICAgICAgICBsaWJj LnNvLjYgPT4gL2xpYi9saWJjLnNvLjYgKDB4MDAwMDJhYWFhYmI5MDAwMCkKPiAgPiAgICAgICAg IGxpYm5uejEwLnNvID0+Cj4gL3Vzci9saWIvb3JhY2xlLzEwLjEuMC4zL2NsaWVudC9saWIvbGli bm56MTAuc28KPiAgPiAoMHgwMDAwMmFhYWFiZGM3MDAwKQo+ICA+ICAgICAgICAgbGliZGwuc28u MiA9PiAvbGliL2xpYmRsLnNvLjIgKDB4MDAwMDJhYWFhYzAzODAwMCkKPiAgPiAgICAgICAgIGxp Ym0uc28uNiA9PiAvbGliL2xpYm0uc28uNiAoMHgwMDAwMmFhYWFjMTNhMDAwKQo+ICA+ICAgICAg ICAgbGlibnNsLnNvLjEgPT4gL2xpYi9saWJuc2wuc28uMSAoMHgwMDAwMmFhYWFjMmJmMDAwKQo+ ICA+ICAgICAgICAgL2xpYjY0L2xkLWxpbnV4LXg4Ni02NC5zby4yICgweDAwMDA1NTU1NTU1NTQw MDApCj4gID4KPiAgPgo+ICA+IEkgZ2V0IHRoZSBmb2xsb3dpbmcgZXJyb3Igd2hlbiB0cnlpbmcg dG8gcnVuIGEgc2NyaXB0Cj4gID4KPiAgPiBbTW9uIEZlYiAwNiAxMDowMDowMSAyMDA2XSBbZXJy b3JdIFtjbGllbnQgMTQ2LjEzNy4xLjMzXSAgIEZpbGUKPiAgPiAiL3Vzci9saWIvY2dpLWJpbi9j eE9yYWNsZS10ZXN0LnB5IiwgbGluZSAxMCwgaW4gPwo+ICA+IFtNb24gRmViIDA2IDEwOjAwOjAx IDIwMDZdIFtlcnJvcl0gW2NsaWVudCAxNDYuMTM3LjEuMzNdICAgICBjb25uZWN0aW9uID0KPiAg PiBjeF9PcmFjbGUuY29ubmVjdCgiZWN0dXNlciIsICJ4eHh4eHgiLCAiZWN0MSIpOwo+ICA+IFtN b24gRmViIDA2IDEwOjAwOjAxIDIwMDZdIFtlcnJvcl0gW2NsaWVudCAxNDYuMTM3LjEuMzNdCj4g ID4gY3hfT3JhY2xlLkRhdGFiYXNlRXJyb3I6IE9SQS0xMjE1NDogVE5TOmNvdWxkIG5vdCByZXNv bHZlIHRoZSBjb25uZWN0Cj4gID4gaWRlbnRpZmllciBzcGVjaWZpZWQKPiAgPiBbTW9uIEZlYiAw NiAxMDowMDowMSAyMDA2XSBbZXJyb3JdIFtjbGllbnQgMTQ2LjEzNy4xLjMzXQo+ICA+IFtNb24g RmViIDA2IDEwOjAwOjAxIDIwMDZdIFtlcnJvcl0gW2NsaWVudCAxNDYuMTM3LjEuMzNdIFByZW1h dHVyZSBlbmQgb2YKPiAgPiBzY3JpcHQgaGVhZGVyczogY3hPcmFjbGUtdGVzdC5weQo+ICA+Cj4g ID4KPiAgPiBJdCBhcHBlYXJzIHRoYXQgY3hfb3JhY2xlIGNhbiBub3QgZmluZCB0aGUgdG5zIGFk bWluIGZpbGUgd2hpc2ggSSBkZWZpbmVkCj4gaW4KPiAgPiBteSBlbnZpcm9ubWVudC4KPiAgPgo+ ICA+IFRoYW5rIHlvdSBtdWNoLAo+ICA+Cj4gID4gQ2hyaXMgUG9ldHplbAo+ICA+Cj4gID4KPiAg Pgo+ICA+IC0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0KPiAgPiBUaGlzIFNGLm5ldCBlbWFpbCBpcyBzcG9uc29yZWQgYnk6IFNwbHVuayBJbmMu IERvIHlvdSBncmVwIHRocm91Z2ggbG9nCj4gZmlsZXMKPiAgPiBmb3IgcHJvYmxlbXM/ICBTdG9w ISAgRG93bmxvYWQgdGhlIG5ldyBBSkFYIHNlYXJjaCBlbmdpbmUgdGhhdCBtYWtlcwo+ICA+IHNl YXJjaGluZyB5b3VyIGxvZyBmaWxlcyBhcyBlYXN5IGFzIHN1cmZpbmcgdGhlICB3ZWIuICBET1dO TE9BRCBTUExVTkshCj4gID4gaHR0cDovL3NlbC5hcy11cy5mYWxrYWcubmV0L3NlbD9jbWRsbmsK PiA8aHR0cDovL3NlbC5hcy11cy5mYWxrYWcubmV0L3NlbD9jbWRsbmsma2lkPgo+IBAzNDMyJmJp ZCMwNDg2JmRhdBIxNjQyCj4gID4gX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX18KPiAgPiBjeC1vcmFjbGUtdXNlcnMgbWFpbGluZyBsaXN0Cj4gID4gY3gtb3Jh Y2xlLXVzZXJzQGxpc3RzLnNvdXJjZWZvcmdlLm5ldAo+ICA+Cj4gaHR0cHM6Ly9saXN0cy5zb3Vy Y2Vmb3JnZS5uZXQvbGlzdHMvbGlzdGluZm8vY3gtb3JhY2xlLXVzZXJzCj4gID4KPiBOSMK1xaDC ssKydSZicmtiYXI7wpAOwromYnJrYmFyO8Ki4oCTxaB+KHIpesK2wqPCoeKApsOAXsKtxb56wrZ6 asWgwqLCouKAosKxw4nCusW+ewwsSDTCtsKxwrJq4oCaw74KPgo+Cj4K |
|
From: Marcus E. <i...@eg...> - 2006-02-08 11:03:43
|
cpoetzel wrote: > Anthony, > Thanks for the response. > I was able to get a connection and response when using a script as > myself with cx_Oracle. > > However, when I try to run the same script from the web server, I get > the same error. > [Tue Feb 07 14:42:56 2006] [error] [client 146.137.1.33] ORA-12154: > TNS:could not resolve the connect identifier specified > > I passed the web server the same env variables I have > > Variable Value > LD_LIBRARY_PATH /usr/lib/oracle/10.1.0.3/client/lib > TNS_ADMIN /usr/lib/oracle/10.1.0.3/client > PATH /usr/local/bin:/usr/bin:/bin > PWD /etc/apache2 > LANG C > SHLVL 1 > ORACLE_HOME /usr/lib/oracle/10.1.0.3/client > _ /usr/sbin/apache2 > > > Is there a way have a python program print out what tnsadmin.ora is > looking for when called from the web server? > There are only a handfull of python scripts that use cx_Oracle through > the web and if I have to statically set the env for TNS_ADMIN > I can live with that. I just don’t know how. > > Thanks, > Chris Poetzel > How are you executing that script? If you are using suEXEC you should be aware, that suEXEC itself passes only environment variables listed in the safe environment list (declared at compiletime of suexec). And this list ist _very_ short. It's just a shot in the dark, but maybe it helps. Kind Regards, Marcus |
|
From: D.R. B. <da...@as...> - 2006-02-08 11:30:13
|
Hoi Chris,
> There are only a handfull of python scripts that use cx_Oracle through the
> web and if I have to statically set the env for TNS_ADMIN
> I can live with that. I just don=E2=80=99t know how.
You can use something like the following in your program.
import os
if not os.environ.has_key('TNS_ADMIN'):
os.environ['TNS_ADMIN'] =3D '/usr/lib/oracle/10.1.0.3/client'
although I'm not completely sure whether that's what you mean.
We do this in the `sitecustomize.py' ourselves and that works just fine.
I think the client library will also look at $HOME/.tnsnames.ora, which
might work if your environment variables are stripped under suExec.
Ciao,
Danny
On Tue, Feb 07, 2006 at 03:00:24PM -0600, cpoetzel wrote:
> Anthony,
> Thanks for the response.
> I was able to get a connection and response when using a script as myself
> with cx_Oracle.
>=20
> However, when I try to run the same script from the web server, I get the
> same error.
> [Tue Feb 07 14:42:56 2006] [error] [client 146.137.1.33] ORA-12154:
> TNS:could not resolve the connect identifier specified
>=20
> I passed the web server the same env variables I have
>=20
> Variable Value
> LD_LIBRARY_PATH /usr/lib/oracle/10.1.0.3/client/lib
> TNS_ADMIN /usr/lib/oracle/10.1.0.3/client
> PATH /usr/local/bin:/usr/bin:/bin
> PWD /etc/apache2
> LANG C
> SHLVL 1
> ORACLE_HOME /usr/lib/oracle/10.1.0.3/client
> _ /usr/sbin/apache2
>=20
>=20
> Is there a way have a python program print out what tnsadmin.ora is looki=
ng
> for when called from the web server?
> There are only a handfull of python scripts that use cx_Oracle through the
> web and if I have to statically set the env for TNS_ADMIN
> I can live with that. I just don=E2=80=99t know how.
>=20
> Thanks,
> Chris Poetzel
>=20
>=20
> On 2/7/06 10:06 AM, "Anthony Tuininga" <ant...@gm...> wrote:
>=20
> > Its unfortunate that you don't have tnsping available as that tells
> > you whether or not the Oracle client can find the tnsnames.ora file
> > and whether it contains what you think it contains. :-) You do,
> > however, have SQL*Plus so you should first verify that you can connect
> > using it with the same connect string you are using with cx_Oracle.
> > You can also make use of the cx_Oracle.make_dsn() method to generate
> > the string that is normally found in a tnsnames.ora file and use that
> > to connect. If you want to know which locations Oracle is searching
> > for tnsnames.ora you can use the strace command -- there are several
> > places. Hope this helps you track down the issue.
> >=20
> > On 2/6/06, cpoetzel <cpo...@an...> wrote:
> >> > Hi,
> >> > I am trying to install cx_Oracle 4.1.2 on a new Ubuntu Breezy Box. I=
ts a
> >> > 64bit amd box.
> >> > I have already installed the oracle 10.1.0.3 64 bit instant client.
> >> > Install looks like this
> >> >
> >> > root@athena:/usr/lib/oracle/10.1.0.3/client# ls -R
> >> > .:
> >> > bin lib tnsnames.ora
> >> >
> >> > ./bin:
> >> > sqlplus
> >> >
> >> > ./lib:
> >> > classes12.jar glogin.sql libclntsh.so libclntsh.so.10.1 libnnz10=
.so
> >> > libocci.so libocci.so.10.1 libociei.so libocijdbc10.so libsqlplu=
s.so
> >> > ojdbc14.jar sdk
> >> >
> >> > ./lib/sdk:
> >> > demo include
> >> >
> >> > ./lib/sdk/demo:
> >> > cdemo81.c demo.mk occidemod.sql occidemo.sql occidml.cpp
> >> >
> >> > ./lib/sdk/include:
> >> > nzerror.h occiAQ.h occiControl.h occi.h oci1.h oci=
ap.h
> >> > ocidef.h ocidfn.h oci.h ocixmldb.h oratypes.h ori.h oro.h =
xa.h
> >> > nzt.h occiCommon.h occiData.h occiObjects.h oci8dp.h oci=
apr.h
> >> > ocidem.h ociextp.h ocikpr.h odci.h orid.h orl.h ort.h
> >> >
> >> >
> >> > Env:
> >> > ORACLE_HOME=3D/usr/lib/oracle/10.1.0.3/client/lib
> >> > TNS_ADMIN=3D/usr/lib/oracle/10.1.0.3/client
> >> > LD_LIBRARY_PATH=3D/usr/lib/oracle/10.1.0.3/client/lib
> >> >
> >> >
> >> > Installing the client:
> >> > root@athena:/usr/local/build/Python-CxOracle/cx_Oracle-4.1.2# python
> >> > setup.py build
> >> > running build
> >> > running build_ext
> >> > building 'cx_Oracle' extension
> >> > creating build
> >> > creating build/temp.linux-x86_64-2.4
> >> > gcc -pthread -fno-strict-aliasing -DNDEBUG -g -O3 -Wall -Wstrict-pro=
totypes
> >> > -fPIC -I/usr/lib/oracle/10.1.0.3/client/lib/rdbms/demo
> >> > -I/usr/lib/oracle/10.1.0.3/client/lib/rdbms/public
> >> > -I/usr/lib/oracle/10.1.0.3/client/lib/network/public
> >> > -I/usr/lib/oracle/10.1.0.3/client/lib/sdk/include -I/usr/include/pyt=
hon2.4
> >> > -c cx_Oracle.c -o build/temp.linux-x86_64-2.4/cx_Oracle.o
> >> > -DBUILD_TIME=3D"February 06, 2006 10:21:45"
> >> > In file included from
> >> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/oci.h:2327,
> >> > from cx_Oracle.c:9:
> >> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/oci1.h:148: warning:
> >> > function declaration isn=C2=B9t a prototype
> >> > In file included from
> >> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/ociap.h:206,
> >> > from
> >> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/oci.h:2351,
> >> > from cx_Oracle.c:9:
> >> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:674: warning:
> >> function
> >> > declaration isn=C2=B9t a prototype
> >> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2665: warning:
> >> > function declaration isn=C2=B9t a prototype
> >> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2674: warning:
> >> > function declaration isn=C2=B9t a prototype
> >> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2684: warning:
> >> > function declaration isn=C2=B9t a prototype
> >> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2693: warning:
> >> > function declaration isn=C2=B9t a prototype
> >> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2702: warning:
> >> > function declaration isn=C2=B9t a prototype
> >> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2711: warning:
> >> > function declaration isn=C2=B9t a prototype
> >> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2719: warning:
> >> > function declaration isn=C2=B9t a prototype
> >> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2729: warning:
> >> > function declaration isn=C2=B9t a prototype
> >> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2736: warning:
> >> > function declaration isn=C2=B9t a prototype
> >> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2744: warning:
> >> > function declaration isn=C2=B9t a prototype
> >> > In file included from
> >> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/oci.h:2351,
> >> > from cx_Oracle.c:9:
> >> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/ociap.h:9952: warnin=
g:
> >> > function declaration isn=C2=B9t a prototype
> >> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/ociap.h:9958: warnin=
g:
> >> > function declaration isn=C2=B9t a prototype
> >> > In file included from SessionPool.c:134,
> >> > from cx_Oracle.c:76:
> >> > Connection.c: In function =C5=92Connection_Acquire=C2=B9:
> >> > Connection.c:184: warning: pointer targets in passing argument 5 of
> >> > =C5=92OCISessionGet=C2=B9 differ in signedness
> >> > In file included from Variable.c:89,
> >> > from Cursor.c:211,
> >> > from Connection.c:354,
> >> > from SessionPool.c:134,
> >> > from cx_Oracle.c:76:
> >> > NumberVar.c: In function =C5=92NumberVar_SetValue=C2=B9:
> >> > NumberVar.c:178: warning: pointer targets in passing argument 2 of
> >> > =C5=92OCINumberFromText=C2=B9 differ in signedness
> >> > NumberVar.c:178: warning: pointer targets in passing argument 4 of
> >> > =C5=92OCINumberFromText=C2=B9 differ in signedness
> >> > In file included from Variable.c:93,
> >> > from Cursor.c:211,
> >> > from Connection.c:354,
> >> > from SessionPool.c:134,
> >> > from cx_Oracle.c:76:
> >> > DateTimeVar.c: In function =C5=92DateTimeVar_SetValue=C2=B9:
> >> > DateTimeVar.c:81: warning: unused variable =C5=92status=C2=B9
> >> > In file included from cx_Oracle.c:76:
> >> > SessionPool.c: In function =C5=92SessionPool_Init=C2=B9:
> >> > SessionPool.c:246: warning: pointer targets in passing argument 6 of
> >> > =C5=92OCISessionPoolCreate=C2=B9 differ in signedness
> >> > creating build/lib.linux-x86_64-2.4
> >> > gcc -pthread -shared build/temp.linux-x86_64-2.4/cx_Oracle.o
> >> > -L/usr/lib/oracle/10.1.0.3/client/lib/lib
> >> > -L/usr/lib/oracle/10.1.0.3/client/lib -lclntsh -o
> >> > build/lib.linux-x86_64-2.4/cx_Oracle.so -s
> >> > root@athena:/usr/local/build/Python-CxOracle/cx_Oracle-4.1.2# python
> >> > setup.py install
> >> > running install
> >> > running build
> >> > running build_ext
> >> > running install_lib
> >> > copying build/lib.linux-x86_64-2.4/cx_Oracle.so ->
> >> > /usr/lib/python2.4/site-packages
> >> >
> >> > Not sure if these warnings are normal but have seen other people hav=
e them
> >> > in the postings.
> >> >
> >> >
> >> >
> >> > root@athena:/tmp# ldd /usr/lib/python2.4/site-packages/cx_Oracle.so
> >> > libclntsh.so.10.1 =3D>
> >> > /usr/lib/oracle/10.1.0.3/client/lib/libclntsh.so.10.1 (0x00002aaaaab=
c3000)
> >> > libpthread.so.0 =3D> /lib/libpthread.so.0 (0x00002aaaaba7b00=
0)
> >> > libc.so.6 =3D> /lib/libc.so.6 (0x00002aaaabb90000)
> >> > libnnz10.so =3D> /usr/lib/oracle/10.1.0.3/client/lib/libnnz1=
0.so
> >> > (0x00002aaaabdc7000)
> >> > libdl.so.2 =3D> /lib/libdl.so.2 (0x00002aaaac038000)
> >> > libm.so.6 =3D> /lib/libm.so.6 (0x00002aaaac13a000)
> >> > libnsl.so.1 =3D> /lib/libnsl.so.1 (0x00002aaaac2bf000)
> >> > /lib64/ld-linux-x86-64.so.2 (0x0000555555554000)
> >> >
> >> >
> >> > I get the following error when trying to run a script
> >> >
> >> > [Mon Feb 06 10:00:01 2006] [error] [client 146.137.1.33] File
> >> > "/usr/lib/cgi-bin/cxOracle-test.py", line 10, in ?
> >> > [Mon Feb 06 10:00:01 2006] [error] [client 146.137.1.33] connect=
ion =3D
> >> > cx_Oracle.connect("ectuser", "xxxxxx", "ect1");
> >> > [Mon Feb 06 10:00:01 2006] [error] [client 146.137.1.33]
> >> > cx_Oracle.DatabaseError: ORA-12154: TNS:could not resolve the connect
> >> > identifier specified
> >> > [Mon Feb 06 10:00:01 2006] [error] [client 146.137.1.33]
> >> > [Mon Feb 06 10:00:01 2006] [error] [client 146.137.1.33] Premature e=
nd of
> >> > script headers: cxOracle-test.py
> >> >
> >> >
> >> > It appears that cx_oracle can not find the tns admin file whish I de=
fined
> >> in
> >> > my environment.
> >> >
> >> > Thank you much,
> >> >
> >> > Chris Poetzel
> >> >
> >> >
> >> >
> >> > -------------------------------------------------------
> >> > This SF.net email is sponsored by: Splunk Inc. Do you grep through l=
og
> >> files
> >> > for problems? Stop! Download the new AJAX search engine that makes
> >> > searching your log files as easy as surfing the web. DOWNLOAD SPLU=
NK!
> >> > http://sel.as-us.falkag.net/sel?cmdlnk
> >> <http://sel.as-us.falkag.net/sel?cmdlnk&kid> =103432&bid#0486&dat=1216=
42
> >> > _______________________________________________
> >> > cx-oracle-users mailing list
> >> > cx-...@li...
> >> > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> >> >
> > NH=C2=B5=C5=A0=C2=B2=C2=B2u=C2=A6=C2=90=0E=C2=BA=C2=A6=C2=A2=E2=80=93=
=C5=A0~=C2=AEz=C2=B6=C2=A3=C2=A1=E2=80=A6=C3=80^=C2=AD=C5=BEz=C2=B6zj=C5=A0=
=C2=A2=C2=A2=E2=80=A2=C2=B1=C3=89=C2=BA=C5=BE{=0C,H4=C2=B6=C2=B1=C2=B2j=E2=
=80=9A=C3=BE
> >=20
>=20
>=20
|
|
From: cpoetzel <cpo...@an...> - 2006-02-08 15:12:18
|
Danny,
Thanks for the tip about sitecustomize.py. I did the following
# more /usr/lib/python2.4/site-packages/sitecustomize.py
import os
os.environ['TNS_ADMIN'] =3D '/usr/lib/oracle/10.1.0.3/client';
Now my cx_Oracle through the web server is picking up the correct
tnsadmin.ora file and is working correctly.
Thanks for all the help everyone.
Chris Poetzel
On 2/8/06 5:29 AM, "D.R. Boxhoorn" <da...@as...> wrote:
>=20
>=20
> Hoi Chris,
>=20
>> > There are only a handfull of python scripts that use cx_Oracle through=
the
>> > web and if I have to statically set the env for TNS_ADMIN
>> > I can live with that. I just don=E2=80=99t know how.
>=20
> You can use something like the following in your program.
>=20
> import os
>=20
> if not os.environ.has_key('TNS_ADMIN'):
> os.environ['TNS_ADMIN'] =3D '/usr/lib/oracle/10.1.0.3/client'
>=20
> although I'm not completely sure whether that's what you mean.
> We do this in the `sitecustomize.py' ourselves and that works just fine.
> I think the client library will also look at $HOME/.tnsnames.ora, which
> might work if your environment variables are stripped under suExec.
>=20
> Ciao,
>=20
> Danny
>=20
>=20
> On Tue, Feb 07, 2006 at 03:00:24PM -0600, cpoetzel wrote:
>> > Anthony,
>> > Thanks for the response.
>> > I was able to get a connection and response when using a script as mys=
elf
>> > with cx_Oracle.
>> >
>> > However, when I try to run the same script from the web server, I get =
the
>> > same error.
>> > [Tue Feb 07 14:42:56 2006] [error] [client 146.137.1.33] ORA-12154:
>> > TNS:could not resolve the connect identifier specified
>> >
>> > I passed the web server the same env variables I have
>> >
>> > Variable Value
>> > LD_LIBRARY_PATH /usr/lib/oracle/10.1.0.3/client/lib
>> > TNS_ADMIN /usr/lib/oracle/10.1.0.3/client
>> > PATH /usr/local/bin:/usr/bin:/bin
>> > PWD /etc/apache2
>> > LANG C
>> > SHLVL 1
>> > ORACLE_HOME /usr/lib/oracle/10.1.0.3/client
>> > _ /usr/sbin/apache2
>> >
>> >
>> > Is there a way have a python program print out what tnsadmin.ora is lo=
oking
>> > for when called from the web server?
>> > There are only a handfull of python scripts that use cx_Oracle through=
the
>> > web and if I have to statically set the env for TNS_ADMIN
>> > I can live with that. I just don=E2=80=99t know how.
>> >
>> > Thanks,
>> > Chris Poetzel
>> >
>> >
>> > On 2/7/06 10:06 AM, "Anthony Tuininga" <ant...@gm...> wr=
ote:
>> >
>>> > > Its unfortunate that you don't have tnsping available as that tells
>>> > > you whether or not the Oracle client can find the tnsnames.ora file
>>> > > and whether it contains what you think it contains. :-) You do,
>>> > > however, have SQL*Plus so you should first verify that you can conn=
ect
>>> > > using it with the same connect string you are using with cx_Oracle.
>>> > > You can also make use of the cx_Oracle.make_dsn() method to generat=
e
>>> > > the string that is normally found in a tnsnames.ora file and use th=
at
>>> > > to connect. If you want to know which locations Oracle is searching
>>> > > for tnsnames.ora you can use the strace command -- there are severa=
l
>>> > > places. Hope this helps you track down the issue.
>>> > >
>>> > > On 2/6/06, cpoetzel <cpo...@an...> wrote:
>>>>> > >> > Hi,
>>>>> > >> > I am trying to install cx_Oracle 4.1.2 on a new Ubuntu Breezy =
Box.
Its a
>>>>> > >> > 64bit amd box.
>>>>> > >> > I have already installed the oracle 10.1.0.3 64 bit instant cl=
ient.
>>>>> > >> > Install looks like this
>>>>> > >> >
>>>>> > >> > root@athena:/usr/lib/oracle/10.1.0.3/client# ls -R
>>>>> > >> > .:
>>>>> > >> > bin lib tnsnames.ora
>>>>> > >> >
>>>>> > >> > ./bin:
>>>>> > >> > sqlplus
>>>>> > >> >
>>>>> > >> > ./lib:
>>>>> > >> > classes12.jar glogin.sql libclntsh.so libclntsh.so.10.1
>>>>> libnnz10.so
>>>>> > >> > libocci.so libocci.so.10.1 libociei.so libocijdbc10.so
>>>>> libsqlplus.so
>>>>> > >> > ojdbc14.jar sdk
>>>>> > >> >
>>>>> > >> > ./lib/sdk:
>>>>> > >> > demo include
>>>>> > >> >
>>>>> > >> > ./lib/sdk/demo:
>>>>> > >> > cdemo81.c demo.mk occidemod.sql occidemo.sql occidml.cpp
>>>>> > >> >
>>>>> > >> > ./lib/sdk/include:
>>>>> > >> > nzerror.h occiAQ.h occiControl.h occi.h oci1.h
>>>>> ociap.h
>>>>> > >> > ocidef.h ocidfn.h oci.h ocixmldb.h oratypes.h ori.h =
oro.h
xa.h
>>>>> > >> > nzt.h occiCommon.h occiData.h occiObjects.h oci8dp.=
h
>>>>> ociapr.h
>>>>> > >> > ocidem.h ociextp.h ocikpr.h odci.h orid.h orl.h =
ort.h
>>>>> > >> >
>>>>> > >> >
>>>>> > >> > Env:
>>>>> > >> > ORACLE_HOME=3D/usr/lib/oracle/10.1.0.3/client/lib
>>>>> > >> > TNS_ADMIN=3D/usr/lib/oracle/10.1.0.3/client
>>>>> > >> > LD_LIBRARY_PATH=3D/usr/lib/oracle/10.1.0.3/client/lib
>>>>> > >> >
>>>>> > >> >
>>>>> > >> > Installing the client:
>>>>> > >> > root@athena:/usr/local/build/Python-CxOracle/cx_Oracle-4.1.2#
python
>>>>> > >> > setup.py build
>>>>> > >> > running build
>>>>> > >> > running build_ext
>>>>> > >> > building 'cx_Oracle' extension
>>>>> > >> > creating build
>>>>> > >> > creating build/temp.linux-x86_64-2.4
>>>>> > >> > gcc -pthread -fno-strict-aliasing -DNDEBUG -g -O3 -Wall
>>>>> -Wstrict-prototypes
>>>>> > >> > -fPIC -I/usr/lib/oracle/10.1.0.3/client/lib/rdbms/demo
>>>>> > >> > -I/usr/lib/oracle/10.1.0.3/client/lib/rdbms/public
>>>>> > >> > -I/usr/lib/oracle/10.1.0.3/client/lib/network/public
>>>>> > >> > -I/usr/lib/oracle/10.1.0.3/client/lib/sdk/include
>>>>> -I/usr/include/python2.4
>>>>> > >> > -c cx_Oracle.c -o build/temp.linux-x86_64-2.4/cx_Oracle.o
>>>>> > >> > -DBUILD_TIME=3D"February 06, 2006 10:21:45"
>>>>> > >> > In file included from
>>>>> > >> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/oci.h:2327,
>>>>> > >> > from cx_Oracle.c:9:
>>>>> > >> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/oci1.h:148: >>=
>>>
warning:
>>>>> > >> > function declaration isn=C2=B9t a prototype
>>>>> > >> > In file included from
>>>>> > >> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/ociap.h:206,
>>>>> > >> > from
>>>>> > >> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/oci.h:2351,
>>>>> > >> > from cx_Oracle.c:9:
>>>>> > >> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:674: war=
ning:
>>>> > >> function
>>>>> > >> > declaration isn=C2=B9t a prototype
>>>>> > >> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2665: >>=
>>>
warning:
>>>>> > >> > function declaration isn=C2=B9t a prototype
>>>>> > >> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2674: >>=
>>>
warning:
>>>>> > >> > function declaration isn=C2=B9t a prototype
>>>>> > >> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2684: >>=
>>>
warning:
>>>>> > >> > function declaration isn=C2=B9t a prototype
>>>>> > >> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2693: >>=
>>>
warning:
>>>>> > >> > function declaration isn=C2=B9t a prototype
>>>>> > >> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2702: >>=
>>>
warning:
>>>>> > >> > function declaration isn=C2=B9t a prototype
>>>>> > >> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2711: >>=
>>>
warning:
>>>>> > >> > function declaration isn=C2=B9t a prototype
>>>>> > >> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2719: >>=
>>>
warning:
>>>>> > >> > function declaration isn=C2=B9t a prototype
>>>>> > >> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2729: >>=
>>>
warning:
>>>>> > >> > function declaration isn=C2=B9t a prototype
>>>>> > >> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2736: >>=
>>>
warning:
>>>>> > >> > function declaration isn=C2=B9t a prototype
>>>>> > >> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2744: >>=
>>>
warning:
>>>>> > >> > function declaration isn=C2=B9t a prototype
>>>>> > >> > In file included from
>>>>> > >> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/oci.h:2351,
>>>>> > >> > from cx_Oracle.c:9:
>>>>> > >> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/ociap.h:9952: =
>>>>>
warning:
>>>>> > >> > function declaration isn=C2=B9t a prototype
>>>>> > >> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/ociap.h:9958: =
>>>>>
warning:
>>>>> > >> > function declaration isn=C2=B9t a prototype
>>>>> > >> > In file included from SessionPool.c:134,
>>>>> > >> > from cx_Oracle.c:76:
>>>>> > >> > Connection.c: In function =C5=92Connection_Acquire=C2=B9:
>>>>> > >> > Connection.c:184: warning: pointer targets in passing argument=
5 of
>>>>> > >> > =C5=92OCISessionGet=C2=B9 differ in signedness
>>>>> > >> > In file included from Variable.c:89,
>>>>> > >> > from Cursor.c:211,
>>>>> > >> > from Connection.c:354,
>>>>> > >> > from SessionPool.c:134,
>>>>> > >> > from cx_Oracle.c:76:
>>>>> > >> > NumberVar.c: In function =C5=92NumberVar_SetValue=C2=B9:
>>>>> > >> > NumberVar.c:178: warning: pointer targets in passing argument =
2 of
>>>>> > >> > =C5=92OCINumberFromText=C2=B9 differ in signedness
>>>>> > >> > NumberVar.c:178: warning: pointer targets in passing argument =
4 of
>>>>> > >> > =C5=92OCINumberFromText=C2=B9 differ in signedness
>>>>> > >> > In file included from Variable.c:93,
>>>>> > >> > from Cursor.c:211,
>>>>> > >> > from Connection.c:354,
>>>>> > >> > from SessionPool.c:134,
>>>>> > >> > from cx_Oracle.c:76:
>>>>> > >> > DateTimeVar.c: In function =C5=92DateTimeVar_SetValue=C2=B9:
>>>>> > >> > DateTimeVar.c:81: warning: unused variable =C5=92status=C2=B9
>>>>> > >> > In file included from cx_Oracle.c:76:
>>>>> > >> > SessionPool.c: In function =C5=92SessionPool_Init=C2=B9:
>>>>> > >> > SessionPool.c:246: warning: pointer targets in passing argumen=
t 6
of
>>>>> > >> > =C5=92OCISessionPoolCreate=C2=B9 differ in signedness
>>>>> > >> > creating build/lib.linux-x86_64-2.4
>>>>> > >> > gcc -pthread -shared build/temp.linux-x86_64-2.4/cx_Oracle.o
>>>>> > >> > -L/usr/lib/oracle/10.1.0.3/client/lib/lib
>>>>> > >> > -L/usr/lib/oracle/10.1.0.3/client/lib -lclntsh -o
>>>>> > >> > build/lib.linux-x86_64-2.4/cx_Oracle.so -s
>>>>> > >> > root@athena:/usr/local/build/Python-CxOracle/cx_Oracle-4.1.2#
python
>>>>> > >> > setup.py install
>>>>> > >> > running install
>>>>> > >> > running build
>>>>> > >> > running build_ext
>>>>> > >> > running install_lib
>>>>> > >> > copying build/lib.linux-x86_64-2.4/cx_Oracle.so ->
>>>>> > >> > /usr/lib/python2.4/site-packages
>>>>> > >> >
>>>>> > >> > Not sure if these warnings are normal but have seen other peop=
le
>>>>> have them
>>>>> > >> > in the postings.
>>>>> > >> >
>>>>> > >> >
>>>>> > >> >
>>>>> > >> > root@athena:/tmp# ldd
>>>>> /usr/lib/python2.4/site-packages/cx_Oracle.so
>>>>> > >> > libclntsh.so.10.1 =3D>
>>>>> > >> > /usr/lib/oracle/10.1.0.3/client/lib/libclntsh.so.10.1
>>>>> (0x00002aaaaabc3000)
>>>>> > >> > libpthread.so.0 =3D> /lib/libpthread.so.0
>>>>> (0x00002aaaaba7b000)
>>>>> > >> > libc.so.6 =3D> /lib/libc.so.6 (0x00002aaaabb90000)
>>>>> > >> > libnnz10.so =3D>
>>>>> /usr/lib/oracle/10.1.0.3/client/lib/libnnz10.so
>>>>> > >> > (0x00002aaaabdc7000)
>>>>> > >> > libdl.so.2 =3D> /lib/libdl.so.2 (0x00002aaaac038000)
>>>>> > >> > libm.so.6 =3D> /lib/libm.so.6 (0x00002aaaac13a000)
>>>>> > >> > libnsl.so.1 =3D> /lib/libnsl.so.1 (0x00002aaaac2bf000)
>>>>> > >> > /lib64/ld-linux-x86-64.so.2 (0x0000555555554000)
>>>>> > >> >
>>>>> > >> >
>>>>> > >> > I get the following error when trying to run a script
>>>>> > >> >
>>>>> > >> > [Mon Feb 06 10:00:01 2006] [error] [client 146.137.1.33] Fil=
e
>>>>> > >> > "/usr/lib/cgi-bin/cxOracle-test.py", line 10, in ?
>>>>> > >> > [Mon Feb 06 10:00:01 2006] [error] [client 146.137.1.33]
>>>>> connection =3D
>>>>> > >> > cx_Oracle.connect("ectuser", "xxxxxx", "ect1");
>>>>> > >> > [Mon Feb 06 10:00:01 2006] [error] [client 146.137.1.33]
>>>>> > >> > cx_Oracle.DatabaseError: ORA-12154: TNS:could not resolve the =
>>>>>
connect
>>>>> > >> > identifier specified
>>>>> > >> > [Mon Feb 06 10:00:01 2006] [error] [client 146.137.1.33]
>>>>> > >> > [Mon Feb 06 10:00:01 2006] [error] [client 146.137.1.33] Prema=
ture
end of
>>>>> > >> > script headers: cxOracle-test.py
>>>>> > >> >
>>>>> > >> >
>>>>> > >> > It appears that cx_oracle can not find the tns admin file whis=
h I
>>>>> defined
>>>> > >> in
>>>>> > >> > my environment.
>>>>> > >> >
>>>>> > >> > Thank you much,
>>>>> > >> >
>>>>> > >> > Chris Poetzel
>>>>> > >> >
>>>>> > >> >
>>>>> > >> >
>>>>> > >> > -------------------------------------------------------
>>>>> > >> > This SF.net email is sponsored by: Splunk Inc. Do you grep thr=
ough
log
>>>> > >> files
>>>>> > >> > for problems? Stop! Download the new AJAX search engine that
makes
>>>>> > >> > searching your log files as easy as surfing the web. DOWNLOA=
D
>>>>> SPLUNK!
>>>>> > >> > http://sel.as-us.falkag.net/sel?cmdlnk
>>>> > >> <http://sel.as-us.falkag.net/sel?cmdlnk
>>>> <http://sel.as-us.falkag.net/sel?cmdlnk&kid>
>>>> <http://sel.as-us.falkag.net/sel?cmdlnk > > =103432&bid#0486&dat=121642
>>>>> > >> > _______________________________________________
>>>>> > >> > cx-oracle-users mailing list
>>>>> > >> > cx-...@li...
>>>>> > >> > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>>>>> > >> >
>>> > > NH=C2=B5=C5=A0=C2=B2=C2=B2u=C2=A6=C2=90=0E=C2=BA=C2=A6=C2=A2=E2=80=93=C5=A0~=C2=AEz=C2=B6=C2=A3=C2=A1=E2=80=A6=C3=80^=C2=AD=C5=BEz=C2=B6zj=C5=A0=C2=A2=C2=A2=E2=80=A2=C2=B1=C3=89=C2=BA=
=C5=BE{=0C,H4=C2=B6=C2=B1=C2=B2j=E2=80=9A=C3=BE
>>> > >
>> >
>> >
>=20
>=20
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through log fi=
les
> for problems? Stop! Download the new AJAX search engine that makes
> searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
> http://sel.as-us.falkag.net/sel?cmd=3Dk
> <http://sel.as-us.falkag.net/sel?cmd=3Dk&kid> =103432&bid#0486&dat=121642
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>=20
|
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X