On Tuesday 06 January 2009 18:57:33 Hugh Williams wrote:
> Hi Kjetil,
>
> You can use the Virtuoso trace_on() function as detailed at:
>
> http://docs.openlinksw.com/virtuoso/fn_trace_on.html#(NULL)
>
> Which enables detailed and controlled logging of Virtuoso server
> activity to be added to the virtuoso log file including queries being
> executed ...
OK, good, but I can't see what I need to enable to get a dump of the endpoint
queries... I've set exec, sql_send and client_sql. but this is all I see
12:45:32 EXEC_1 0 127.0.0.1 1111:21 s1111_21_0 Exec 1 time(s) trace_on
('client_sql')
12:46:35 CSLQ_0 0 127.0.0.1 1111:21 s1111_21_0 trace_on ('sql_send')
12:46:35 EXEC_1 0 127.0.0.1 1111:21 s1111_21_0 Exec 1 time(s) trace_on
('sql_send')
Also, the documentation mentions that there is a trace_status_show(), but I
get
SQL> trace_status_show();
*** Error 42001: [Virtuoso Driver][Virtuoso Server]SR185: Undefined procedure
DB.DBA.trace_status_show. at line 9 of Top-Level:
And this is all I get from
SQL> trace_status();
Done. -- 1 msec.
If I run a query on the isql command line, I get an entry in the logs, but
that's not what I want, I need those that ran against the endpoint.
How do I do that?
Kind regards
Kjetil Kjernsmo
--
Senior Knowledge Engineer
Mobile: +47 986 48 234
Email: [email protected]
Web: http://www.computas.com/
| SHARE YOUR KNOWLEDGE |
Computas AS PO Box 482, N-1327 Lysaker | Phone:+47 6783 1000 | Fax:+47 6783
1001
