sqltrace log

[Søren Schrøder]

Greetings

I'm running FreeRadius with mysql backend, and for some reason I cannot
get the sqltrace logfile enabled.

Im running Freeradius on Freebsd 7.0, and I have tried installing from
FreeBSD ports (2.0.5) and a build from source (2.1.1), but with the same
result:

Running freeradius in debug mode (-X -xx), it outputs:

Tue Nov 11 15:24:10 2008 : Debug:  Module: Linked to module rlm_sql
Tue Nov 11 15:24:10 2008 : Debug:  Module: Instantiating sql
Tue Nov 11 15:24:10 2008 : Debug:   sql {
Tue Nov 11 15:24:10 2008 : Debug:       driver = "rlm_sql_mysql"
Tue Nov 11 15:24:10 2008 : Debug:       server = "localhost"
Tue Nov 11 15:24:10 2008 : Debug:       port = ""
Tue Nov 11 15:24:10 2008 : Debug:       login = "radius"
Tue Nov 11 15:24:10 2008 : Debug:       password = "<blanked>"
Tue Nov 11 15:24:10 2008 : Debug:       radius_db = "radius"
Tue Nov 11 15:24:10 2008 : Debug:       read_groups = yes
Tue Nov 11 15:24:10 2008 : Debug:       sqltrace = yes
Tue Nov 11 15:24:10 2008 : Debug:       sqltracefile =
"/var/log/radius/sqltrace.sql"
...
...

I touched and 666'ed the logfile to eliminate right-issues

[root at server /var/log/radius]# ls -al
total 6
drwxr-xr-x  3 freeradius  wheel   512 Nov 11 15:26 .
drwxr-xr-x  4 root        wheel  1536 Nov 11 15:21 ..
drwxr-xr-x  3 root        wheel   512 Nov 11 15:21 radacct
-rw-rw-rw-  1 freeradius  wheel     0 Nov 11 15:26 sqltrace.sql

but I simply doesnt get anything in the sqltrace logfile

I can do auth and acct with the DB, so it actually works, but I would
have liked the sqltrace in the debugging phase.

Any explanation on why sqltrace doesn't log ??? 


-- 
Søren Schrøder, Tecnical Innovation, Cybercity (a Telenor Company).
sch at cybercity.dk, (+45) 60503045.
"Obey Gravity.... It's the LAW!"