Read radius client from database

2008-11-26 Thread Saeed Akhtar
Hi all, I am having problem to configure Radius to read client information from mysql database table nas. I found an option at last line of sql.conf readclients = yes i uncommented it ... then added record in nas table... then tried to send request from newly added client but it says unknown

re:Re: Read radius client from database

2008-11-26 Thread mj mailing lists user
Hi seems to me you are missing rlm_sql, when I start radiusd -X I get the following lines: rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked .. rlm_sql_mysql: query: SELECT id, nasname, shortname, type, secret FROM nas this last line is then followed by rlm_sql

Re: Read radius client from database

2008-11-26 Thread Alan DeKok
Saeed Akhtar wrote: Debug Trace: You're not running 2.x. You should upgrade. You haven't configured the SQL module. You need to do this for it to work. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Read radius client from database

2008-11-26 Thread Saeed Akhtar
Debug Trace: Starting - reading configuration files ... reread_config: reading radiusd.conf Config: including file: /usr/local/etc/raddb/proxy.conf Config: including file: /usr/local/etc/raddb/clients.conf Config: including file: /usr/local/etc/raddb/snmp.conf Config: including file:

Re: Read radius client from database

2008-11-26 Thread Saeed Akhtar
Thanks for ur help setting sql in authorize section of radiusd.conf solved the problem But now when sql checks for username and password it gives error Unknow Attribute Cleartext-Password.. I am not upgrading to 2.x because i tried to configure jradius with 2.1.1 it gave

Re: Read radius client from database

2008-11-26 Thread tnt
sql is commented out in radiusd.conf by default. Enable it somewhere. This is the old server version. Use the latest one. Even for testing. It's so much better. Ivan Kalik Kalik Informatika ISP Dana 26/11/2008, Saeed Akhtar [EMAIL PROTECTED] piše: Debug Trace: Starting - reading

Re: Read radius client from database

2008-11-26 Thread tnt
1.1.3 doesn't use Cleartext-Password. That came in 1.1.4. Read the users file. It should be User-Password. Ivan Kalik Kalik Informatika ISP Dana 26/11/2008, Saeed Akhtar [EMAIL PROTECTED] piše: Thanks for ur help setting sql in authorize section of radiusd.conf solved the problem

Re: Read radius client from database

2008-11-26 Thread tnt
Post the debug of the server startup. Ivan Kalik Kalik Informatika ISP Dana 26/11/2008, Saeed Akhtar [EMAIL PROTECTED] piše: Hi all, I am having problem to configure Radius to read client information from mysql database table nas. I found an option at last line of sql.conf readclients =

Re: Read radius client from database

2008-11-26 Thread Saeed Akhtar
Thanks It worked but here comes another issue where im stuck ... using both sql and jradius for authorization creates a problem First freeradius goes to sql and check for the user record... regardless of result of sql , request is also fwd to jradius. and jradius also

Re: Read radius client from database

2008-11-26 Thread Alan DeKok
Saeed Akhtar wrote: please...formatyourmessages in a normal way. Formatting them badly makes them harder to understand. i dont now that is there any conditional statements in configuration file which will help me hopeful for some help :) FreeRADIUS 2.x comes with a

Re: Read radius client from database

2008-11-26 Thread tnt
First freeradius goes to sql and check for the user record... regardless of result of sql , request is also fwd to jradius. and jradius also checks for the same username in another database over another server (as im using jradius for having connectivity to another server)... i want freeradius to