Hi Gustaf,
We updated nsoracle.c to produce the logging similar to that of AOL4.5.1. Instead of removing the Ns_Log lines, we are checking the verbose flag controlled via logsqlerrors to enable/disable this logging at the pool level. LogMinDuration had no effect on any logging.
nsoralce.c diff:
585c585
\< Ns_Log(Ns_LogSqlDebug, "SQL(): %s", query);
---
\> if(dbh->verbose) Ns_Log(Ns_LogSqlDebug, "SQL(): %s", query);
693c693
\< Ns_Log(Ns_LogSqlDebug, "SQL(): %s", query);
---
\> if(dbh->verbose) Ns_Log(Ns_LogSqlDebug, "SQL(): %s", query);
965a966
\> if(dbh->verbose) Ns_Log(Ns_LogSqlDebug, "SQL(): %s", query);
967,968d967
\< /* Ns_Log(Ns_LogSqlDebug, "SQL(): %s", query); */
\< if(dbh->verbose) Ns_Log(Notice, "SQL(): %s", query);
1508c1507
\< Ns_Log(Ns_LogSqlDebug, "SQL(): %s", query);
---
\> if(dbh->verbose) Ns_Log(Ns_LogSqlDebug, "SQL(): %s", query);
1587a1587
\> if (dbh->verbose) {
1589a1590
\> }
1590a1592
\> if (dbh->verbose) {
1594a1597
\> }
1706c1709
\< Ns_Log(Ns_LogSqlDebug, "SQL(): %s", query);
---
\> if(dbh->verbose) Ns_Log(Ns_LogSqlDebug, "SQL(): %s", query);
1867c1870
\< Ns_Log(Ns_LogSqlDebug, " CLOB # %d, filename %s", i, fetchbuf->buf);
---
\> if (dbh->verbose) { Ns_Log(Ns_LogSqlDebug, " CLOB # %d, filename %s", i, fetchbuf->buf); }
1868a1872
\> if (dbh->verbose) {
1871a1876
\> }
2016c2021
\< Ns_Log(Ns_LogSqlDebug, "SQL(): %s", query);
---
\> if(dbh->verbose) Ns_Log(Ns_LogSqlDebug, "SQL(): %s", query);
nsstats.tcl?@page=loglevel:
The following table shows the current loglevels:
Key Value
Bug on
Debug off
Debug(access) off
Debug(connchan) off
Debug(ns:driver) off
Debug(nsproxy) off
Debug(request) off
Debug(sql) on
Debug(task) off
Debug(timeout) off
Debug(urlspace) off
Debug(writer) off
Dev off
Error on
Fatal on
Notice on
Warning on
Thank you for your help.