rlm_sql module do not write sql requests into log file

[Laurent Bourqui]

Hi,

Thanks for the tips, didn't know that running in debug mode wouldn't log. But this still doesn't work. I checked file permission but no way, the sqllog.sql file is not created and if I "touch" it and give him the correct permissions, nothing is written in it:

snip of radiusd.conf:
-------------------------------------------
prefix = /usr/local
exec_prefix = /usr/local
sysconfdir = /user/local/etc
localstatedir = /var
sbindir = /usr/local/sbin
logdir = ${localstatedir}/log/radius
raddbdir = ${sysconfdir}/raddb
radacctdir = ${logdir}/radacct

#  name of the running server.  See also the "-n" command-line option.
name = radiusd

#  Location of config and logfiles.
confdir = ${raddbdir}
modconfdir = ${confdir}/mods-config
certdir = ${confdir}/certs
cadir   = ${confdir}/certs
run_dir = ${localstatedir}/run/${name}

db_dir = ${localstatedir}/lib/radiusd
#libdir = /usr/lib64/freeradius
libdir = /usr/local/lib/freeradius
pidfile = ${run_dir}/${name}.pid

max_request_time = 30
cleanup_delay = 5
max_requests = 256
hostname_lookups = yes

log {
	destination = files
	colourise = yes
	file = ${logdir}/radius.log
	syslog_facility = daemon
	stripped_names = no
	auth = yes
	auth_badpass = yes
	auth_goodpass = no
	msg_goodpass = ""
	msg_badpass = ""
}

#  The program to execute to do concurrency checks.
checkrad = ${sbindir}/checkrad

# SECURITY CONFIGURATION
#
security {
	user = radiusd
	group = radiusd
	allow_core_dumps = no
	max_attributes = 200
	reject_delay = 1
	status_server = yes
	allow_vulnerable_openssl = 'CVE-2014-0160'
}
-------------------------------------------


Snip of /etc/passwd:
-------------------------------------------
radiusd:x:95:95:radiusd user:/home/radiusd:/sbin/nologin
-------------------------------------------

List of log directory:
[root at dev radius]# ls -la
total 4256
drwx------. 3 radiusd radiusd    4096 Apr 21 19:43 .
drwxr-xr-x. 8 root    root       4096 Apr 20 15:20 ..
drwx------. 3 radiusd radiusd      22 Dec 10 22:09 radacct
-rw-r-----  1 radiusd radiusd 4289522 Apr 21 19:45 radius.log
-rw-r-----. 1 radiusd radiusd   17339 Dec 23 22:06 radius.log-20160101.gz
-rw-r-----. 1 radiusd radiusd     185 Jan  1 03:23 radius.log-20160201.gz
-rw-r-----. 1 radiusd radiusd    2151 Feb  4 15:37 radius.log-20160301
-rw-r-----. 1 radiusd radiusd   22020 Mar 27 16:37 radius.log-20160330
-rw-r-----  1 radiusd radiusd       0 Mar 30 03:30 radius.log-20160401
[root at dev radius]# 


I must have configured something wrong but cannot see it.

Any hit is welcome.

Regards
Laurent



-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html