Error: [sql] database query error
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@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
On Thu, Feb 11, 2010 at 11:56:45AM +0700, Fajar A. Nugraha wrote:
On Thu, Feb 11, 2010 at 11:25 AM, Teguh Kurniawan <teguhkurniawanwijaya@gmail.com> wrote:
Table 'radius.radusergroup' doesn't exist
Do you have that table?
Perhaps it's a case of not importing the database schema found in /etc/freeradius/sql/... -- 2. That which causes joy or happiness.
participants (3)
-
Fajar A. Nugraha -
Josip Rodin -
Teguh Kurniawan