Framed-IP-Address not inserted in mysql

Bernd bernd at kroenchenstadt.de
Wed Dec 7 15:21:22 CET 2016


Hi,

running FreeRADIUS Version 3.0.4 (built for host 
x86_64-redhat-linux-gnu, built on Mar  5 2015 at 23:41:36) from stock 
packages on a CentOS 7 machine.

I have the problem that I see Framed-IP-Address entries in radacct log 
files:

Wed Dec  7 15:11:57 2016
	Acct-Session-Id = '0004xxxx'
	Framed-Protocol = PPP
	Framed-IP-Address = 10.2.3.4
	User-Name = 'user at example.com'
	Acct-Session-Time = 111
	Acct-Input-Octets = 3499
	Acct-Output-Octets = 5252
	Acct-Input-Packets = 45
	Acct-Output-Packets = 57
	Acct-Status-Type = Stop
	Service-Type = Framed-User
	Acct-Delay-Time = 0
	NAS-IP-Address = 12.13.14.15
	Event-Timestamp = 'Dec  7 2016 15:11:57 CET'
	Acct-Unique-Session-Id = '297cb70bcbc4a02b1d1xyz123'
	Timestamp = 1481119917

but they're *not* being inserted into the MySQL database (field is 
empty, tcpdump shows that clearly a '' is being transmitted to MySQL):

INSERT INTO radacct (acctsessionid,		acctuniqueid,		username, 
realm,			nasipaddress,		nasportid, 
nasporttype,		acctstarttime,		acctupdatetime, 
acctstoptime,		acctsessiontime, 	acctauthentic, 
connectinfo_start,	connectinfo_stop, 	acctinputoctets, 
acctoutputoctets,	calledstationid, 	callingstationid, 
acctterminatecause,	servicetype,		framedprotocol, framedipaddress) 
VALUES ('0004xxxx', '297cb70bcbc4a02b1d1xyz123', 'user at example.com', '', 
'12.13.14.15', '', '', FROM_UNIXTIME(1481119920), 
FROM_UNIXTIME(1481119920), NULL, '0', '', '', '', '0', '0', '', '', '', 
'Framed-User', 'PPP', '')

Help very much appreciated.

Best,

Bernd


More information about the Freeradius-Users mailing list