Problem with authentication

[Pablo Lucchetti]

gessuttia:~# freeradius -x
Starting - reading configuration files ...
Using deprecated naslist file.  Support for this will go away soon.
Module: Loaded PAP
Module: Instantiated pap (pap)
Module: Loaded CHAP
Module: Instantiated chap (chap)
Module: Loaded MS-CHAP
Module: Instantiated mschap (mschap)
Module: Loaded SQL
rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
rlm_sql (sql): Attempting to connect to root at 127.0.0.1:/radius
rlm_sql (sql): starting 0
rlm_sql (sql): Attempting to connect rlm_sql_mysql #0
rlm_sql_mysql: Starting connect to MySQL server for #0
rlm_sql (sql): Connected new DB handle, #0
rlm_sql (sql): starting 1
rlm_sql (sql): Attempting to connect rlm_sql_mysql #1
rlm_sql_mysql: Starting connect to MySQL server for #1
rlm_sql (sql): Connected new DB handle, #1
rlm_sql (sql): starting 2
rlm_sql (sql): Attempting to connect rlm_sql_mysql #2
rlm_sql_mysql: Starting connect to MySQL server for #2
rlm_sql (sql): Connected new DB handle, #2
rlm_sql (sql): starting 3
rlm_sql (sql): Attempting to connect rlm_sql_mysql #3
rlm_sql_mysql: Starting connect to MySQL server for #3
rlm_sql (sql): Connected new DB handle, #3
rlm_sql (sql): starting 4
rlm_sql (sql): Attempting to connect rlm_sql_mysql #4
rlm_sql_mysql: Starting connect to MySQL server for #4
rlm_sql (sql): Connected new DB handle, #4
Module: Instantiated sql (sql)
Module: Loaded Acct-Unique-Session-Id
Module: Instantiated acct_unique (acct_unique)
Initializing the thread pool...
Listening on authentication *:1812
Listening on accounting *:1813
Ready to process requests.

sql.conf

sql {
         driver = "rlm_sql_mysql"

         server = "127.0.0.1"
         login = "dbuser"
         password = "dbpass"
         radius_db = "radius"

acct_table1 = "radacct"
acct_table2 = "radacct"

        postauth_table = "radpostauth"
        authcheck_table = "radcheck"
        authreply_table = "radreply"
        groupcheck_table = "radgroupcheck"
        groupreply_table = "radgroupreply"
        usergroup_table = "usergroup"

deletestalesessions = yes

sqltrace = no
sqltracefile = ${logdir}/sqltrace.sql

num_sql_socks = 5
connect_failure_retry_delay = 60

}

radreoply table

mysql> select * from radreply;
+----+-----------+-------------------+----+---------------+
| id | UserName  | Attribute         | op | Value         |
+----+-----------+-------------------+----+---------------+
|  1 | test-user | Framed-IP-Address | =  | 192.168.1.109 |
|  2 | test-user | Framed-IP-Address | =  | 0.0.0.0       |
+----+-----------+-------------------+----+---------------+
2 rows in set (0.00 sec)





tnt at kalik.co.yu wrote:
> Send radiusd -X output. Have you done something to sql.conf apart from
> database connection details?
> 
> Ivan Kalik
> Kalik Informatika ISP
> 
> 
> Dana 13/12/2007, "Pablo Lucchetti" <pablo at lnx.org.ar> piše:
> 
>> Hi,
>>
>> I've a Freeradius on a Debian Etch with Mysql but when I'm triying to
>> test with NTRadPing always got the same error.
>> The user already exists in database
>>
>>
>> rad_recv: Access-Request packet from host 192.168.1.109:4027, id=2,
>> length=49
>>        User-Name = "test-user"
>>        User-Password = "test-pass"
>> rlm_sql (sql): Reserving sql socket id: 4
>> rlm_sql (sql): SQL query error; rejecting user
>> rlm_sql (sql): Released sql socket id: 4
>> Sending Access-Reject of id 2 to 192.168.1.109 port 4027
>>
>>
>> Any help please?
>>
>>
>> Thanks in advance,
>> Pablo
>> -
>> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>>
>>
> 
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
> 
> __________ Información de NOD32, revisión 2721 (20071213) __________
> 
> Este mensaje ha sido analizado con  NOD32 antivirus system
> http://www.nod32.com
> 
> 
>