Error: [sql] database query error

Teguh Kurniawan teguhkurniawanwijaya at gmail.com
Thu Feb 11 05:25:03 CET 2010


Hello, I need more advice from all of you about my freeradius 2.10
configuration on ubuntu server 9.10.
I've got error message :

Thu Feb 11 11:04:57 2010 : Error: [sql] database query error, SELECT
groupname           FROM radusergroup           WHERE username =
'user'           ORDER BY priority: Table 'radius.radusergroup'
doesn't exist
Thu Feb 11 11:04:57 2010 : Error: [sql] Error retrieving group list
Thu Feb 11 11:04:57 2010 : Error: [sql] Error processing groups; rejecting user

root at radiusmanager:/tmp# radtest user 1111 127.0.0.1 1812 testing123
Sending Access-Request of id 82 to 127.0.0.1 port 1812
        User-Name = "user"
        User-Password = "1111"
        NAS-IP-Address = 192.168.0.3
        NAS-Port = 1812
rad_recv: Access-Reject packet from host 127.0.0.1 port 1812, id=82, length=20

I was change "ipaddr = *" to "ipaddr = 127.0.0.1" on radiusd.conf
What should I do ?
Best Regards,


Teguh Kurniawan



More information about the Freeradius-Users mailing list