Efx Efx wrote:
Phil, I configured my freeradius server as in your example above ( It looks like case letters doesn't make any difference in MySQL statements)
1) PLEASE edit your posts to remove extra text. It's just polite.
User is successfully authenticated because of radcheck table. Maybe I need to reinstall freeradius server , because a month ago there was "Dialup Admin" installed too. Radcheck sql statements runs from "dialup.conf" file.
*This is my table:*
CREATE TABLE `Resv` ( `Username` varchar(20) NOT NULL, `Start-Time` int(11) NOT NULL, `End-Time` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
*This is my output:*
Which you clearly didn't read. Why?
rlm_sql (sql): database query error, select Start_time from Resv where Username='ieva': Unknown column 'Start_time' in 'field list'
What is so hard to understand about that message? The whole point of debug output is for you to READ IT. Alan DeKok.