Hello, Please help As per the attached error it was not bringing the users data, when we cross checked our database with quries.conf which is below. We found on the oracle database table only a "username" as attached where as in queries.conf ""SQL-User-Name" Therefore, if replace in my quries.conf from ""SQL-User-Name" with "User-Name" that should work. I appreciate your Usual support. Here is the query.conf file. queries.conf allocate_begin = "commit" start_begin = "commit" alive_begin = "commit" stop_begin = "commit" on_begin = "commit" off_begin = "commit" allocate_find = "\ SELECT framedipaddress \ FROM ${ippool_table} \ WHERE pool_name = '%{control:Pool-Name}' \ AND expiry_time < current_timestamp \ AND rownum <= 1 \ ORDER BY \ (username <> '%{SQL-User-Name}'), \ (callingstationid <> '%{Calling-Station- Id}'), \ expiry_time \ FOR UPDATE" pool_check = "\ SELECT id \ FROM (\ SELECT id \ FROM ${ippool_table} \ WHERE pool_name='%{control:Pool-Name}'\ ) \ WHERE ROWNUM = 1" allocate_update = "\ UPDATE ${ippool_table} \ SET \ nasipaddress = '%{NAS-IP-Address}', \ pool_key = '${pool_key}', \ callingstationid = '%{Calling-Station-Id}', \ username = '%{SQL-User-Name}', \ expiry_time = current_timestamp + INTERVAL '${lease_duration}' second(1) \ WHERE framedipaddress = '%I'" allocate_clear = "\ UPDATE ${ippool_table} \ SET \ nasipaddress = '', \ pool_key = 0, \ callingstationid = '', \ expiry_time = current_timestamp - INTERVAL '1' second(1) \ WHERE pool_key = '${pool_key}'" start_update = "\ UPDATE ${ippool_table} \ SET \ expiry_time = current_timestamp + INTERVAL '${lease_duration}' second(1) \ WHERE nasipaddress = '%{NAS-IP-Address}' \ AND pool_key = '${pool_key}'" stop_clear = "\ UPDATE ${ippool_table} \ SET \ nasipaddress = '', \ pool_key = 0, \ callingstationid = '', \ expiry_time = current_timestamp - INTERVAL '1' second(1) \ WHERE nasipaddress = '%{Nas-IP-Address}' \ AND pool_key = '${pool_key}' \ AND username = '%{SQL-User-Name}' \ AND callingstationid = '%{Calling-Station-Id}'" alive_update = "\ UPDATE ${ippool_table} \ SET \ expiry_time = current_timestamp + INTERVAL '${lease_duration}' second(1) \ WHERE nasipaddress = '%{Nas-IP-Address}' \ AND pool_key = '${pool_key}' \ AND framedipaddress = '%{Framed-IP-Address}' \ AND username = '%{SQL-User-Name}' \ AND callingstationid = '%{Calling-Station-Id}'" on_clear = "\ UPDATE ${ippool_table} \ SET \ nasipaddress = '', \ pool_key = 0, \ callingstationid = '', \ expiry_time = current_timestamp - INTERVAL '1' second(1) \ WHERE nasipaddress = '%{Nas-IP-Address}'" off_clear = "\ UPDATE ${ippool_table} \ SET \ nasipaddress = '', \ pool_key = 0, \ callingstationid = '', \ expiry_time = current_timestamp - INTERVAL '1' second(1) \ WHERE nasipaddress = '%{Nas-IP-Address}'" Thanks, Mohammed Ejaz Asst. Operation Director of Systems. Cyberia SAUDI ARABIA P.O.Box: 301079, Riyadh 11372 Phone: (+966) 11 464 7114 Ext. 140 Mobile: (+966) 562311787 Fax: (+966) 11 465 4735 Website: http://www.cyberia.net.sa
hi, umm, wheres your dialup.conf line in sql.conf? you've butchered the config without knowing what you are doing. the default config works fine for most people once you've just added server/user details you should have: # Read driver-specific configuration $INCLUDE sql/${database}/dialup.conf and in that dial.conf you'll see the bits that populate SQL-User-Name - since you are not including it, SQL-User-Name is not being created alan
Hello. Sorry for being late. I am unable to get chance to test it, but before going live, I wanted confirm and make sure from you the below. I don’t see dialup.conf file anywhere the server. Which you asked me to add in sql.conf (which is actually oraclesql.conf). in raddb. Directory. If I want to add this file, it should exists?? Where as I have "sql" file in /usr/local/freeradius3/etc/raddb /default mods-enabled, since I am using oracle database as backend, seems I need to modify "sql" file instead dialup.conf?? Regards Ejaz -----Original Message----- From: Freeradius-Users [mailto:freeradius-users-bounces+mejaz=cyberia.net.sa@lists.freeradius.org] On Behalf Of Alan Buxey Sent: Wednesday, November 16, 2016 1:12 PM To: 'FreeRadius users mailing list' <freeradius-users@lists.freeradius.org> Subject: Re: authentication-failed hi, umm, wheres your dialup.conf line in sql.conf? you've butchered the config without knowing what you are doing. the default config works fine for most people once you've just added server/user details you should have: # Read driver-specific configuration $INCLUDE sql/${database}/dialup.conf and in that dial.conf you'll see the bits that populate SQL-User-Name - since you are not including it, SQL-User-Name is not being created alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Hi,
I don’t see dialup.conf file anywhere the server. Which you asked me to add in sql.conf (which is actually oraclesql.conf). in raddb. Directory. If I want to add this file, it should exists??
then your config is butchered beyond help
I have "sql" file in /usr/local/freeradius3/etc/raddb /default mods-enabled, since I am using oracle database as backend, seems I need to modify "sql" file instead dialup.conf??
due to the nature of freeradius, the stuff in dialup.conf COULD be in the sql config...but by default its called from dialup.conf with an INCLUDE directive. you dont have the valid calls in your config. take the base freeradius config files (grab a copy from freeradius.org or from GIT and then look at the files. alan
On Tue, Nov 22, 2016 at 10:12:38AM +0000, A.L.M.Buxey@lboro.ac.uk wrote:
I don’t see dialup.conf file anywhere the server. Which you asked me to add in sql.conf (which is actually oraclesql.conf). in raddb. Directory. If I want to add this file, it should exists??
then your config is butchered beyond help
Looks like it was renamed queries.conf (which makes more sense these days). I missed that one as well... though I don't generally use sql. f0fdc9f2 Matthew -- Matthew Newton, Ph.D. <mcn4@leicester.ac.uk> Systems Specialist, Infrastructure Services, I.T. Services, University of Leicester, Leicester LE1 7RH, United Kingdom For IT help contact helpdesk extn. 2253, <ithelp@le.ac.uk>
Hello Allan/Mathews, Before to go live just I wanted to make sure, please advice below is correct. Since I don’t have testing environment to test. Shall I use the below in oraclesql.conf file # Read driver-specific configuration $INCLUDE sql/${database}/queries.conf (where as in quries.conf I have all the database structure, tables and quries. And statements) ========================================================== These 4 tables I have in my oracle database, ================== authreply_table = "radreply" groupcheck_table = "radgroupcheck" groupreply_table = "radgroupreply" usergroup_table = "usergroup" ==================================================================== Note: Since I don’t have table "radpostauth" in my database, hence I commented this in quries.conf and sql. Please help. Ejaz -----Original Message----- From: Freeradius-Users [mailto:freeradius-users-bounces+mejaz=cyberia.net.sa@lists.freeradius.org] On Behalf Of Matthew Newton Sent: Tuesday, November 22, 2016 1:42 PM To: FreeRadius users mailing list <freeradius-users@lists.freeradius.org> Subject: Re: authentication-failed On Tue, Nov 22, 2016 at 10:12:38AM +0000, A.L.M.Buxey@lboro.ac.uk wrote:
I don’t see dialup.conf file anywhere the server. Which you asked me to add in sql.conf (which is actually oraclesql.conf). in raddb. Directory. If I want to add this file, it should exists??
then your config is butchered beyond help
Looks like it was renamed queries.conf (which makes more sense these days). I missed that one as well... though I don't generally use sql. f0fdc9f2 Matthew -- Matthew Newton, Ph.D. <mcn4@leicester.ac.uk> Systems Specialist, Infrastructure Services, I.T. Services, University of Leicester, Leicester LE1 7RH, United Kingdom For IT help contact helpdesk extn. 2253, <ithelp@le.ac.uk> - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
take the base freeradius config files (grab a copy from freeradius.org or from GIT and then look at the files.
I have tried to get those file but unable to find "oraclesql.conf" Would you please share me the link to have the file which I mistakenly removed some lines from it..
Looks like it was renamed queries.conf (which makes more sense these days). I missed that one as well... though I don't generally use sql
As per Mathews email I am not sure. Should look and modify quries.conf, or SQL file which is resides in " usr/local/freeradius3/etc/raddb /default mods-enabled" I am sorry to bother you this is the first time I am installing freeradius. Please help. Ejaz -----Original Message----- From: Freeradius-Users [mailto:freeradius-users-bounces+mejaz=cyberia.net.sa@lists.freeradius.org] On Behalf Of A.L.M.Buxey@lboro.ac.uk Sent: Tuesday, November 22, 2016 1:13 PM To: FreeRadius users mailing list <freeradius-users@lists.freeradius.org> Subject: Re: authentication-failed Hi,
I don’t see dialup.conf file anywhere the server. Which you asked me to add in sql.conf (which is actually oraclesql.conf). in raddb. Directory. If I want to add this file, it should exists??
then your config is butchered beyond help
I have "sql" file in /usr/local/freeradius3/etc/raddb /default mods-enabled, since I am using oracle database as backend, seems I need to modify "sql" file instead dialup.conf??
due to the nature of freeradius, the stuff in dialup.conf COULD be in the sql config...but by default its called from dialup.conf with an INCLUDE directive. you dont have the valid calls in your config. take the base freeradius config files (grab a copy from freeradius.org or from GIT and then look at the files. alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
participants (4)
-
A.L.M.Buxey＠lboro.ac.uk -
Alan Buxey
-
Ejaz -
Matthew Newton