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@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@cybercity.dk, (+45) 60503045. "Obey Gravity.... It's the LAW!"
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 ???
radiusd doesn't write to logs (radius.log, sqltrace.log, ...) in debug mode. You can log the whole debug into the file if you want to. Ivan Kalik Kalik Informatika ISP
radiusd doesn't write to logs (radius.log, sqltrace.log, ...) in debug mode. You can log the whole debug into the file if you want to.
default sql.conf claims opposite: # Print all SQL statements when in debug mode (-x) sqltrace = yes sqltracefile = ${logdir}/sqltrace.sql But to check your statement, I started radiusd in demonmode (rc script), and I still dont get queries logged in the tracefile -- Søren Schrøder, Tecnical Innovation, Cybercity (a Telenor Company). sch@cybercity.dk, (+45) 60503045. "Obey Gravity.... It's the LAW!"
default sql.conf claims opposite:
# Print all SQL statements when in debug mode (-x) sqltrace = yes sqltracefile = ${logdir}/sqltrace.sql
But to check your statement, I started radiusd in demonmode (rc script), and I still dont get queries logged in the tracefile
That's -x not -X. Ivan Kalik Kalik Informatika ISP
default sql.conf claims opposite:
# Print all SQL statements when in debug mode (-x) sqltrace = yes sqltracefile = ${logdir}/sqltrace.sql
But to check your statement, I started radiusd in demonmode (rc script), and I still dont get queries logged in the tracefile
That's -x not -X.
man 8 radiusd: "-X Debugging mode. Equivalent to -sfxx -l stdout" but nothing should be un-tested, so followed your suggestion: radiusd -x radiusd -xx radiusd -f -x but still no output in sqltrace.log Has anyone actually got sqltrace-output in 2.x ? The few mentions I find on the net all seems to relate to 1.x configurations. in the sourcecode I find: src/modules/rlm_sql/drivers/rlm_sql_mysql/sql_mysql.c: if (config->sqltrace) radlog(L_DBG,"rlm_sql_mysql: query: %s", querystr); Doesnt that mean that its written to the L_DBG (radius.log) file and not to sqltrace.log ? I do see those in the radius.log: /var/log/radius/radius.log:rlm_sql_mysql: query: SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'blabla' ORDER BY id I think sqltrace has defacto been depricated .... -- Søren Schrøder, Tecnical Innovation, Cybercity (a Telenor Company). sch@cybercity.dk, (+45) 60503045. "Obey Gravity.... It's the LAW!"
participants (2)
-
Søren Schrøder -
tnt＠kalik.net