FramedIPAddress not showing in MySQL
Fred Casavant
casfr at touchtunes.com
Thu Feb 2 03:03:15 CET 2006
The FramedIPAddress
<sql.php?lang=en-utf-8&server=1&collation_connection=utf8_general_ci&db=radius&table=radacct&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2AFROM+%60radacct%60++ORDER+BY+%60FramedIPAddress%60+ASC>
are showing up in my accounting file (the detail-date file) but it's not
showing up in the radacct table in mysql. At first I thought it was an
issue with the NASes but the IPs are always showing up in the flat file
(after an Accounting Stop action) so I doubt the NASes are the problem.
And I didn't touch the default sql.conf file at all and the mysql radius
schema was created with the db_mysql.sql that come with the freeradius
tarball. So I wonder what could be the problem here. Could it be because
I'm logging the accounting stuff in two places (flat detail file and
mysql) at the same time?
My setup is freeradius 1.1.0 with MySQL 4.1.16 on a FC4 distro.
More information about the Freeradius-Users
mailing list