Hi, I'm having some trouble with nsoracle tests.
I have instaled AOLserver 4.5.1 (from sourceforge tarball) and nsoracle (from source on git). On the webserver (openSUSE 11.2, 32 bits): - AOLserver 4.5.1 - TCL 8.5.12 - Oracle Client 11.2.0.3.0 (32 bits) On the oracle server (SuSE Linux Enterprise Server 11 SP2, 64 bits): - Oracle Server 11.2.0.3.0 (64 bits) Everything was installed according instructions and I could connect AOLserver with our database server without any problems. Please, visit the following URLs: - AOLserver 4.5.1 installation: http://desenv.saudenaweb.com.br:84/ - AOLserver connection test page with our database server (just a "select sysdate from dual" from Oracle): http://desenv.saudenaweb.com.br:84/db.adp Until now I could install AOLserver 4.5.1 and connect it to our database server. But, when I try to test the nsoracle installation with the tests scripts provided by nsoracle, I got an error with the "clob-test.tcl" test. All other tests were done whit success. Please, visit the following URLs: - table-test.tcl: OK http://desenv.saudenaweb.com.br:84/nsoracle/table-test.tcl - bind-test.tcl: OK http://desenv.saudenaweb.com.br:84/nsoracle/bind-test.tcl - error-test.tcl: OK http://desenv.saudenaweb.com.br:84/nsoracle/error-test.tcl - clob-test.tcl: ERROR!! http://desenv.saudenaweb.com.br:84/nsoracle/clob-test.tcl The "ns_ora clob_dml_file" correctly inserted a small file as clob in the test table. The problem is with "ns_ora clob_get_file": when selecting the clob and writing it to a return file, the resulting file have a binary charset, and so a diff between the original file and the retrurned file fails (should be equal). The ORIGINAL file inserted on database (ns_ora clob_dml_file): > cat markd-small.txt this is a small test file > file -i markd-small.txt markd-small.txt: text/plain; charset=us-ascii The RETURNED file (ns_ora clob_get_file): > cat markd-small.txt-back this is a small test file > file -i markd-small.txt-back markd-small.txt-back: text/plain; charset=binary Now, aparently the problem is in ns_ora clob_get_file: it is writing a "binary" file insted of a "character" file: -rw-r--r-- 1 wwwrun www 26 2012-08-18 13:54 markd-small.txt -rw------- 1 wwwrun www 977K 2012-08-18 13:54 markd-small.txt-back Any ideas? I have been discussing this on openACS forum (http://www.openacs.org/forums/message-view?message_id=3954708) but I think here is a more appropriate place to discuss nsoracle problems. thanks! ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ aolserver-talk mailing list aolserver-talk@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/aolserver-talk
