2007/05/08
IRC [01:53] *** samer__________ joined the chat.
IRC [02:19] *** cacrus joined the chat.
IRC [04:34] *** samer__________ parted the chat.
IRC [05:58] *** wowow joined the chat.
IRC [06:29] *** wowow parted the chat.
IRC [06:50] *** tektubby joined the chat.
IRC [07:37] *** tektubby parted the chat.
IRC [09:18] *** dekoy joined the chat.
IRC [09:42] <dekoy> good morning
IRC [09:43] <cacrus> Hi , so did it work with you , the utf-8 issue ?
IRC [09:50] <dekoy> got pulled out in a meeting did not even had time to look at it yesterday
IRC [09:50] <dekoy> im starting to work on it again now
IRC [09:50] <dekoy> got myself a devserver same config as the production to see if it will work
IRC [09:51] <cacrus> good luck
IRC [09:51] <dekoy> i thought this will be a just a config issue :)
IRC [09:52] <Dossy> Great.
IRC [09:52] <Dossy> It should be just a config issue.
IRC [09:53] <Dossy> But, it's a combination of your aolserver config .tcl, and your env vars when you start nsd.
IRC [09:54] <dekoy> oh
IRC [09:54] <Dossy> Wait--what version of AOLserver are you using?
IRC [09:55] <dekoy> 4.0.10
IRC [09:56] <dekoy> Dossy i got nscp working is there like a docu somewhere that i can read to show mydata in oracle
IRC [09:56] <dekoy> let me ask google too about that
IRC [09:56] <Dossy> ?
IRC [09:57] <Dossy> show your data? nscp is just like a tcl shell, except you have *most* of the AOLserver Tcl API available to you
IRC [09:57] <dekoy> oh
IRC [09:57] <Dossy> you can do ns_db from the control port
IRC [09:57] <dekoy> thanks
IRC [09:57] <Dossy> that's why having the nscp is so useful :)
IRC [09:58] <dekoy> :)
IRC [09:58] <dekoy> okay let me play with this
IRC [09:58] <Dossy> cool.
IRC [09:58] <dekoy> aolserver has never failed me before
IRC [09:58] <dekoy> i know it wont :) hehe
IRC [09:59] <Dossy> dekoy, what site are you working on?
IRC [09:59] <dekoy> hrmm ethicon tvt registry
IRC [10:00] <dekoy> oh if i remember ryan's story you worked on the oracle driver here before
IRC [10:00] <dekoy> aolserver and 10g
IRC [10:00] <dekoy> something like that
IRC [10:01] <dekoy> 3 years ago i think
IRC [10:01] <dekoy> 2 or 3 years ago i guess
IRC [10:14] <Dossy> dekoy, URL?
IRC [10:17] *** partymola joined the chat.
IRC [10:23] <cacrus> Dossy do you know if aolserver oracle driver , nsoracle, works fine with oracle with MTS ? has anyone used it with MTS oracle ?
IRC [10:31] <Dossy> MTS?
IRC [10:32] <partymola> better don't ask lol
IRC [10:33] <dekoy> sorry got pulled again
IRC [10:33] <dekoy> ehehe
IRC [10:57] *** partymola parted the chat.
IRC [10:58] <dekoy> nscp will have the same env variables as the running aolserver right ?
IRC [11:18] <dekoy> okay from nscp ns_db is not showing the special characters too
IRC [11:22] <Dossy> What's it showing?
IRC [11:22] <Dossy> Question marks? "?
IRC [11:23] <dekoy> set text_string [ns_set get $row "text_string"]
IRC [11:23] <dekoy> Bitte geben Sie an, welche Aussagen Ihren heutigen Gesundheitszustand
IRC [11:24] <Dossy> What was it supposed to be?
IRC [11:24] <dekoy> Wahlen Sie mehr als einen Kasten in jeder Gruppe nicht.
IRC [11:24] <dekoy> supposed to show
IRC [11:24] <dekoy> Wählen Si
IRC [11:24] <dekoy> e mehr als einen Kasten in jeder Gruppe nicht.
IRC [11:25] <dekoy> with the special characters
IRC [11:25] <Dossy> Hmm. Sounds like Oracle might be transcoding?
IRC [11:25] <Dossy> I haven't worked in Oracle in years ... what's the way to find out the session's encoding setting from Oracle?
IRC [11:25] <Dossy> There's some V$ view, I think.
IRC [11:26] <dekoy> sqlplus shows the data
IRC [11:26] <dekoy> and special characters
IRC [11:26] <dekoy> let me check
IRC [11:26] <Dossy> Sure, but SQLPlus may be setting a different encoding for the DB connection/session.
IRC [11:26] <Dossy> in nscp, what does "set env(NLS_LANG)" return?
IRC [11:27] <dekoy> server1:nscp 10> env get NLS_LANG
IRC [11:27] <dekoy> AMERICAN_AMERICA.UTF8
IRC [11:27] <dekoy> changed the system encoding to utf-8 too
IRC [11:28] <Dossy> I suspect that might be causing Oracle to change encoding.
IRC [11:28] <dekoy> server1:nscp 1> encoding system
IRC [11:28] <dekoy> utf-8
IRC [11:29] <dekoy> NLS_CHARACTERSET
IRC [11:29] <dekoy> AL32UTF8
IRC [11:29] <dekoy> that's from select * from nls_database_parameters
IRC [11:30] <dekoy> NLS_NCHAR_CHARACTERSET
IRC [11:30] <dekoy> AL16UTF16
IRC [11:36] <Dossy> right, that's the database ...
IRC [11:38] <Dossy> select * from nls_session_parameters
IRC [11:41] <Dossy> compare the result of that query from SQL*Plus and from nscp
IRC [11:52] <dekoy> sorry give me another 10 minutes people keeps on calling me
IRC [11:52] <dekoy> hehe
IRC [12:21] <dekoy> nscp returned the same thing
IRC [12:21] <dekoy> server1:nscp 9> set value [ns_set get $row "value"]
IRC [12:21] <dekoy> AL32UTF8
IRC [12:22] <Dossy> ?
IRC [12:22] <Dossy> it returns more than one row
IRC [12:22] <dekoy> sorry with the NLS_CHARSET in sqlplus/oracle and with nscp
IRC [12:22] <Dossy> I'm interested in NLS_CHARSET
IRC [12:22] <dekoy> yep that's NLS_CHARSET
IRC [12:22] <dekoy> set row [ns_db 0or1row $db "select * from nls_database_parameters where parameter='NLS_CHARACTERSET'"]
IRC [12:22] <Dossy> and NLS_LANGUAGE, etc.
IRC [12:22] <dekoy> oh oki
IRC [12:26] <Dossy> oh, what is env get LANG
IRC [12:26] <Dossy> and env get LC_ALL
IRC [12:26] <Dossy> from within nscp?
IRC [12:39] <dekoy> sorry hehe busy day people keeps on pulling me out
IRC [12:40] <dekoy> server1:nscp 21> env get LANG
IRC [12:40] <dekoy> UTF8
IRC [12:40] <dekoy> server1:nscp 22> env get LC_ALL
IRC [12:40] <dekoy> LC_ALL is empty
IRC [12:41] <Dossy> ...
IRC [12:42] <Dossy> I'd need to fiddle with the env, at this point I'm not sure what's causing your transcoding issue.
IRC [12:44] <dekoy> yeah ill eat first might boost the brain power
IRC [12:44] <dekoy> hehe
IRC [12:44] <dekoy> ill be back lunch time
IRC [13:23] *** cacru1 joined the chat.
IRC [13:23] *** cacru1 parted the chat.
IRC [13:24] <CIA-25> 03michael_andrews * 10aolserver/tcl/init.tcl: No longer adds $AOLSERVER/lib to the auto_path if it already exists.
IRC [14:25] *** cacru1 joined the chat.
IRC [14:26] *** cacrus parted the chat.
IRC [14:31] *** Hubertus parted the chat.
IRC [14:47] *** cacru1 parted the chat.
IRC [14:48] *** cacrus joined the chat.
IRC [14:50] <CIA-25> 03michael_andrews * 10aolserver/tcl/packages.tcl: Optimized the code.
IRC [14:50] <CIA-25> 03michael_andrews * 10aolserver/tcl/packages.tcl: removed hard return used for testing.
IRC [15:43] <dekoy> I got it to work
IRC [15:43] <dekoy> :)
IRC [15:44] <cacrus> Congratulations : so what was it ?
IRC [15:45] <dekoy> configuration
IRC [15:45] <cacrus> ye kia hey
IRC [15:45] <dekoy> you don't need to change the source
IRC [15:46] <dekoy> the key is NLS_LANG=.UTF8 in the environment variable for aolserver
IRC [15:46] <cacrus> oops sorry wrong window
IRC [15:46] <cacrus> .UTF8 ?
IRC [15:46] <dekoy> server1:nscp 4> set name [ns_set get $row2 "usr_name"
IRC [15:46] <dekoy> server1:nscp 4>>> ]
IRC [15:46] <dekoy> Santé bien
IRC [15:46] <dekoy> yep
IRC [15:46] <dekoy> i guess it's an aolserver thingy
IRC [15:47] <dekoy> :)
IRC [15:47] <cacrus> or amerian_america.utf-8
IRC [15:47] <dekoy> no
IRC [15:47] <dekoy> just NLS_LANG=.UTF8
IRC [15:47] <dekoy> on my run file(daemontools) i added export NLS_LANG=.UTF8
IRC [15:47] <cacrus> Ohh , that i didnt know , i will check that , although its totlally different from what oracle recommends the value for this parameter
IRC [15:48] <dekoy> ns_param DefaultCharset utf-8
IRC [15:48] <dekoy> ns_param HttpOpenCharset utf-8
IRC [15:48] <dekoy> ns_param OutputCharset utf-8
IRC [15:48] <dekoy> ns_param URLCharset utf-8
IRC [15:48] <dekoy> ns_param PreferredCharsets { utf-8 iso8859-1 }
IRC [15:48] <dekoy> nsd.tcl has that
IRC [15:48] <dekoy> im not sure if all of them are needed but the more the merrier
IRC [15:48] <dekoy> hehe
IRC [15:48] <cacrus> :)
IRC [15:48] <dekoy> now testing
IRC [15:49] <dekoy> im letting the developers test it now
IRC [15:49] <dekoy> hehe
IRC [15:49] <cacrus> so there is a . in front of UTF8
IRC [15:49] <dekoy> hopefully that will solve our next project asian characters
IRC [15:49] <dekoy> yep
IRC [15:50] <dekoy> ORACLE_SID=dev; export ORACLE_SID
IRC [15:50] <dekoy> export NLS_LANG=.UTF8
IRC [15:50] <cacrus> i will check that first thing in the morning , its better not to recompile source with all those changes
IRC [15:50] <dekoy> yeah
IRC [15:51] <dekoy> hehe i guess they already solved this problem since 04 dang
IRC [15:51] <dekoy> might be a good addition to the wiki
IRC [15:51] <dekoy> so it will be easier to find
IRC [15:51] <cacrus> i will also check if its the case with aolserver 4.5.0
IRC [15:52] <dekoy> how would you rate 4.5.0 against 4.0.10
IRC [15:52] <dekoy> any real noticeable improvements ?
IRC [15:52] <cacrus> well i have done a benchmark for that
IRC [15:52] <cacrus> check this out
IRC [15:53] <cacrus> or just google for aolserver benchmark with ab
IRC [15:53] <cacrus> you will find a scribd document
IRC [15:53] <cacrus> g aolserver benchmark
IRC [15:53] <dekoy> http://www.scribd.com/doc/24386/Aolserver-benchmark-with-ab
IRC [15:53] <dekoy> ?
IRC [15:54] <cacrus> this is the top result
IRC [15:54] <cacrus> yrs
IRC [15:55] <cacrus> check the result at the bottom of the page
IRC [15:56] <dekoy> Aol4.0.10 server way much better than aolserver 4.5
IRC [15:56] <dekoy> that one :)
IRC [15:56] <dekoy> hehe
IRC [15:56] <cacrus> yes :)
IRC [15:57] <dekoy> there are some instance ( I'm still trying to find out what) aolserver will just hang and needs a restart
IRC [15:57] <dekoy> there are no blocking session in the database
IRC [15:57] <dekoy> load is so low but aolserver would just not respond
IRC [15:57] <cacrus> there was no database invol;ved
IRC [15:57] <dekoy> there is, that's the thing looked at oracle and it says no blocking sessions
IRC [15:58] <dekoy> and nothing significant aolserver is running on a 4 x 2.8 xeon proc with 32 gigs of memory
IRC [15:59] <dekoy> before if that happens there are blockign session in oracle
IRC [15:59] <cacrus> enable verbose log on on database pools and check the error log
IRC [15:59] <dekoy> yeah ill do that it just happened yesterday 5 pm
IRC [15:59] <dekoy> kinda odd
IRC [15:59] <dekoy> out of the blue
IRC [15:59] <dekoy> hehe
IRC [16:27] *** cacrus parted the chat.
IRC [17:00] *** CIA-25 parted the chat.
IRC [17:07] *** CIA-25 joined the chat.
IRC [18:35] *** partymola joined the chat.
IRC [18:44] <partymola> hey :)
IRC [18:49] *** holycow parted the chat.
IRC [21:14] *** partymola parted the chat.