- Freeradius-Users - lists.freeradius.org

questions regarding sql xlat
by Uwe Kastens 20 Apr '09

20 Apr '09

Hello list, I am trying to use some internal database function to calculate the Session-Timeout. If I set the value for Session-Timeout to a integer like 123, its correctly delivered as answer to my request. If I try to use sql xlat I will get the answer: Error: rlm_sql: Failed to create the pair: Unknown value %{sql:SELECT disctime.time FROM `disctime` WHERE disctime.user = %{User-Name}} for attribute Session-Timeout Sun Apr 19 20:11:03 2009 : Error: rlm_sql (sql): Error getting data from database I tried several different things: Use a select statement to query the integer directly. I ends up in the same error. I am using: - freeradius: FreeRADIUS Version 2.0.4, for host i486-pc-linux-gnu, built on Sep 7 2008 at 23:35:34 - Debian GNU/Linux 5.0 (lenny) - postgresql 8.3.7-0lenny1 BR Uwe -- kiste lat: 54.322684, lon: 10.13586

2 4

Same vlan id to multiple user
by Mitul Modi 20 Apr '09

20 Apr '09

hi, How we can assign same vlan id to multiple user using free radius server. Thanks, mitul modi

2 1

freeradius Exiting normally
by Asaad 20 Apr '09

20 Apr '09

Hi the freeradius dies some times (many times through the day , max 3 ) and gives at log : Info: Exiting normally radius version FreeRADIUS Version 2.0.5 on i686 in the mailing list i noticed that the problem may be from 86 , for that i moved to the same radius version on another x86_64 server , but problem remains i have a perl module enabled on the server , and the database system performance is very good please any hint that help me to fix these issues Thanks lot _________________________________________________________________ Rediscover Hotmail®: Get e-mail storage that grows with you. http://windowslive.com/RediscoverHotmail?ocid=TXT_TAGLM_WL_HM_Rediscover_St…

1 0

FW: rewrite attribute with perl module
by Asaad 20 Apr '09

20 Apr '09

Hi the freeradius dies some times (many times through the day , max 3 ) and gives at log : Info: Exiting normally radius version FreeRADIUS Version 2.0.5 on i686 in the mailing list i noticed that the problem may be from 86 , for that i moved to the same radius version on another x86_64 server , but problem remains i have a perl module enabled on the server , and the database system performance is very good please any hint that help me to fix these issues Thanks lot _________________________________________________________________ Windows Live™: Keep your life in sync. http://windowslive.com/explore?ocid=TXT_TAGLM_WL_allup_1a_explore_042009

1 0

possible radutmp problem in 2.1.4 and/or 2.1.5-git(2009-04-17 state)?
by Rozsahegyi Bela 19 Apr '09

19 Apr '09

Hello! I use freeradius 1.1.x version a few years ago without any problems with 5 cisco NAS and ~15,000 online user in daytime. This work with realtime mysql accounting, but more user, more accounting record --> growing problem with the records rotate and user search without long sql lock. A few days before I changed the version to 2.1.4 with modified configuration, traditional authentication and separate radrelay process for accounting. If I need rotate the radacct table, only stop the radrelay, and this is ideal for me, I do the rotate without sql locking problem or the tech support team can do a search without long time lock :) But I found some problem. On the 2.1.4 version found the "detail file polling go crazy" problem and the fix from 2.1.5-git. This works very well, thanks :) The second problem both the 2.1.4 and 2.1.5, but the 2.1.5git well tested: In this situation: -or the network connection interrupted for a few seconds or a minute between the radius server and NAS or sql server -or the radiusd need stop, some second still and start -or after 5-10 hour (the longest running time 16 hour), -or the radutmp file size around 1.8-2.2 Mbyte the radius stop responding. I was luck, and catch an strace output, while stop: stat("/usr/local/freeradius/var/log/radius/radacct/radrelay/detail", 0x705d786a5ba0) = -1 ENOENT (No file or directory) stat("/usr/local/freeradius/var/log/radius/radacct/radrelay", {st_mode=S_IFDIR|0755, st_size=6, ...}) open("/usr/local/freeradius/var/log/radius/radacct/radrelay/detail", O_WRONLY|O_CREAT|O_APPEND, 0600) lseek(127, 0, SEEK_SET) = 0 flock(127, LOCK_EX|LOCK_NB) = 0 fstat(127, {st_mode=S_IFREG|0600, st_size=0, ...}) = 0 fcntl(127, F_GETFL) = 0x8401 (flags O_WRONLY|O_APPEND|O_LARGEFILE) fstat(127, {st_mode=S_IFREG|0600, st_size=0, ...}) = 0 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x6a8898c4d000 lseek(127, 0, SEEK_CUR) = 0 fstat(127, {st_mode=S_IFREG|0600, st_size=0, ...}) = 0 lseek(127, 0, SEEK_SET) = 0 write(127, "Fri Apr 17 21:45:34 2009\n\tAcct-S"..., 492) = 492 lseek(127, 0, SEEK_SET) = 0 flock(127, LOCK_UN) = 0 close(127) = 0 munmap(0x6a8898c4d000, 4096) = 0 open("/usr/local/freeradius/var/log/radius/radutmp", O_RDWR|O_CREAT, 0600) = 127 flock(127, LOCK_EX ...and this point freeze the process, rarely only the kill -9 the solution for stop. The restart is not possible, it can do accept one or two user after start, and freeze again. The only one solution is delete the radutmp file, and start again. At this moment (when can do only 1-2 user) do a debug with -X paramter. The latest lines, twice probe to start: The first probe: [radrelay-detail] expand: /usr/local/freeradius/var/log/radius/radacct/radrelay/detail -> /usr/local/freeradius/var/log/radius/radacct/radrelay/detail [radrelay-detail] /usr/local/freeradius/var/log/radius/radacct/radrelay/detail expands to /usr/local/freeradius/var/log/radius/radacct/radrelay/detail [radrelay-detail] Acquired filelock, tried 1 time(s) [radrelay-detail] expand: %t -> Sun Apr 19 16:34:03 2009 [radrelay-detail] Released filelock ++[radrelay-detail] returns ok [radutmp] expand: /dev/shm/radutmp -> /dev/shm/radutmp [radutmp] expand: %{User-Name} -> myuser(a)myrealm.hu ...and this pont freeze and not responding. The second probe to start: [radrelay-detail] expand: /usr/local/freeradius/var/log/radius/radacct/radrelay/detail -> /usr/local/freeradius/var/log/radius/radacct/radrelay/detail [radrelay-detail] /usr/local/freeradius/var/log/radius/radacct/radrelay/detail expands to /usr/local/freeradius/var/log/radius/radacct/radrelay/detail [radrelay-detail] Acquired filelock, tried 1 time(s) [radrelay-detail] expand: %t -> Sun Apr 19 16:34:59 2009 [radrelay-detail] Released filelock ++[radrelay-detail] returns ok [radutmp] expand: /dev/shm/radutmp -> /dev/shm/radutmp [radutmp] expand: %{User-Name} -> myotheruser(a)myrealm.hu ...and this pont freeze and not responding. When delete the radutmp, and start the radius, the authentication is very fast, a custom, radclient style monitoring system say about 10-12 msec for a login. If the radutmp file grow, this time going over 30 msec, when the radutmp file in the /dev/shm "ramdisk". If the radutmp file on standard filesystem, had similar effect, but a little slower respond. Could someone help, what should I do? Ran out of ideas... The radutmp file usage better me, than the sql backend, because the radrelay do a little delay. Thanks, RB

2 2

upgrading freeradius .1.1.6 on ubuntu 7.10
by Nizar Zulmi 19 Apr '09

19 Apr '09

i've read the previous tread on this mailing list about upgrading freeradius. in that tread i got this :this command to upgrade freeradius./configuremakemake install i did run those command and everything in my freeradiu going mess, like when i try to restart my freeradius it return like cannot found library freeradius-library.2.5.1.so what happen,,??

1 0

FreeRADIUS 2.1.5 on CentOS 4.4
by Glen Millard 19 Apr '09

19 Apr '09

Hello All; I have been spinning my wheels on this for a couple of days now. I build FreeRADIUS from the source , no errors, builds successfully. However, when I launch the FreeRADIUS server ( radiusd -X) this is what I see. If I use the 'fake' certs ( the test ones with the bootstrap script) , it runs successfully. Any ideas? I see discussion similar, but nothing very clear. Anyone? Thanks Glen +++++++++++++++++++++++++++++++++++ FreeRADIUS Version 2.1.5, for host i686-pc-linux-gnu, built on Apr 18 2009 at 05:17:11 Copyright (C) 1999-2008 The FreeRADIUS server project and contributors. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. You may redistribute copies of FreeRADIUS under the terms of the GNU General Public License v2. Starting - reading configuration files ... including configuration file /usr/local/etc/raddb/radiusd.conf including configuration file /usr/local/etc/raddb/proxy.conf including configuration file /usr/local/etc/raddb/clients.conf including files in directory /usr/local/etc/raddb/modules/ including configuration file /usr/local/etc/raddb/modules/mac2vlan including configuration file /usr/local/etc/raddb/modules/always including configuration file /usr/local/etc/raddb/modules/exec including configuration file /usr/local/etc/raddb/modules/expiration including configuration file /usr/local/etc/raddb/modules/detail including configuration file /usr/local/etc/raddb/modules/radutmp including configuration file /usr/local/etc/raddb/modules/attr_rewrite including configuration file /usr/local/etc/raddb/modules/realm including configuration file /usr/local/etc/raddb/modules/expr including configuration file /usr/local/etc/raddb/modules/ldap including configuration file /usr/local/etc/raddb/modules/passwd including configuration file /usr/local/etc/raddb/modules/otp including configuration file /usr/local/etc/raddb/modules/etc_group including configuration file /usr/local/etc/raddb/modules/acct_unique including configuration file /usr/local/etc/raddb/modules/digest including configuration file /usr/local/etc/raddb/modules/linelog including configuration file /usr/local/etc/raddb/modules/smsotp including configuration file /usr/local/etc/raddb/modules/detail.log including configuration file /usr/local/etc/raddb/modules/mac2ip including configuration file /usr/local/etc/raddb/modules/echo including configuration file /usr/local/etc/raddb/modules/pap including configuration file /usr/local/etc/raddb/modules/checkval including configuration file /usr/local/etc/raddb/modules/wimax including configuration file /usr/local/etc/raddb/modules/sql_log including configuration file /usr/local/etc/raddb/modules/smbpasswd including configuration file /usr/local/etc/raddb/modules/chap including configuration file /usr/local/etc/raddb/modules/policy including configuration file /usr/local/etc/raddb/modules/detail.example.com including configuration file /usr/local/etc/raddb/modules/preprocess including configuration file /usr/local/etc/raddb/modules/pam including configuration file /usr/local/etc/raddb/modules/attr_filter including configuration file /usr/local/etc/raddb/modules/logintime including configuration file /usr/local/etc/raddb/modules/inner-eap including configuration file /usr/local/etc/raddb/modules/unix including configuration file /usr/local/etc/raddb/modules/counter including configuration file /usr/local/etc/raddb/modules/files including configuration file /usr/local/etc/raddb/modules/mschap including configuration file /usr/local/etc/raddb/modules/perl including configuration file /usr/local/etc/raddb/modules/krb5 including configuration file /usr/local/etc/raddb/modules/sradutmp including configuration file /usr/local/etc/raddb/modules/ippool including configuration file /usr/local/etc/raddb/modules/sqlcounter_expire_on_login including configuration file /usr/local/etc/raddb/eap.conf including configuration file /usr/local/etc/raddb/policy.conf including files in directory /usr/local/etc/raddb/sites-enabled/ including configuration file /usr/local/etc/raddb/sites-enabled/default including configuration file /usr/local/etc/raddb/sites-enabled/control-socket including configuration file /usr/local/etc/raddb/sites-enabled/inner-tunnel including dictionary file /usr/local/etc/raddb/dictionary main { prefix = "/usr/local" localstatedir = "/usr/local/var" logdir = "/usr/local/var/log/radius" libdir = "/usr/local/lib" radacctdir = "/usr/local/var/log/radius/radacct" hostname_lookups = no max_request_time = 30 cleanup_delay = 5 max_requests = 1024 allow_core_dumps = yes pidfile = "/usr/local/var/run/radiusd/radiusd.pid" checkrad = "/usr/local/sbin/checkrad" debug_level = 0 proxy_requests = yes log { stripped_names = no auth = no auth_badpass = no auth_goodpass = no } security { max_attributes = 200 reject_delay = 1 status_server = yes } } radiusd: #### Loading Realms and Home Servers #### proxy server { retry_delay = 5 retry_count = 3 default_fallback = no dead_time = 120 wake_all_if_all_dead = no } home_server localhost { ipaddr = 127.0.0.1 port = 1812 type = "auth" secret = "testing123" response_window = 20 max_outstanding = 65536 require_message_authenticator = no zombie_period = 40 status_check = "status-server" ping_interval = 30 check_interval = 30 num_answers_to_alive = 3 num_pings_to_alive = 3 revive_interval = 120 status_check_timeout = 4 irt = 2 mrt = 16 mrc = 5 mrd = 30 } home_server_pool my_auth_failover { type = fail-over home_server = localhost } realm example.com { auth_pool = my_auth_failover } realm LOCAL { } radiusd: #### Loading Clients #### client localhost { ipaddr = 127.0.0.1 require_message_authenticator = no secret = "testing123" nastype = "other" } radiusd: #### Instantiating modules #### instantiate { Module: Linked to module rlm_exec Module: Instantiating exec exec { wait = no input_pairs = "request" shell_escape = yes } Module: Linked to module rlm_expr Module: Instantiating expr Module: Linked to module rlm_expiration Module: Instantiating expiration expiration { reply-message = "Password Has Expired " } Module: Linked to module rlm_logintime Module: Instantiating logintime logintime { reply-message = "You are calling outside your allowed timespan " minimum-timeout = 60 } } radiusd: #### Loading Virtual Servers #### server inner-tunnel { modules { Module: Checking authenticate {...} for more modules to load Module: Linked to module rlm_pap Module: Instantiating pap pap { encryption_scheme = "auto" auto_header = no } Module: Linked to module rlm_chap Module: Instantiating chap Module: Linked to module rlm_mschap Module: Instantiating mschap mschap { use_mppe = yes require_encryption = no require_strong = no with_ntdomain_hack = no } Module: Linked to module rlm_unix Module: Instantiating unix unix { radwtmp = "/usr/local/var/log/radius/radwtmp" } Module: Linked to module rlm_eap Module: Instantiating eap eap { default_eap_type = "md5" timer_expire = 60 ignore_unknown_eap_types = no cisco_accounting_username_bug = no max_sessions = 2048 } Module: Linked to sub-module rlm_eap_md5 Module: Instantiating eap-md5 Module: Linked to sub-module rlm_eap_leap Module: Instantiating eap-leap Module: Linked to sub-module rlm_eap_gtc Module: Instantiating eap-gtc gtc { challenge = "Password: " auth_type = "PAP" } Module: Linked to sub-module rlm_eap_tls Module: Instantiating eap-tls tls { rsa_key_exchange = no dh_key_exchange = yes rsa_key_length = 512 dh_key_length = 512 verify_depth = 0 pem_file_type = yes private_key_file = "/usr/local/etc/raddb/certs/server.pem" certificate_file = "/usr/local/etc/raddb/certs/server.pem" CA_file = "/usr/local/etc/raddb/certs/ca.pem" private_key_password = "rifywbi!" dh_file = "/usr/local/etc/raddb/certs/dh" random_file = "/usr/local/etc/raddb/certs/random" fragment_size = 1024 include_length = yes check_crl = no cipher_list = "DEFAULT" make_cert_command = "/usr/local/etc/raddb/certs/bootstrap" cache { enable = no lifetime = 24 max_entries = 255 } } rlm_eap: SSL error error:0906D06C:PEM routines:PEM_read_bio:no start line rlm_eap_tls: Error reading private key file /usr/local/etc/raddb/certs/server.pem rlm_eap: Failed to initialize type tls /usr/local/etc/raddb/eap.conf[17]: Instantiation failed for module "eap" /usr/local/etc/raddb/sites-enabled/inner-tunnel[223]: Failed to find module "eap". /usr/local/etc/raddb/sites-enabled/inner-tunnel[176]: Errors parsing authenticate section. } } Errors initializing modules

2 5

RE: NAS table
by Nizar Zulmi 18 Apr '09

18 Apr '09

so thak you ivan...really apreciate for your answeri just install it using apt-get install command ubuntu 7.10. so i'll upgrade to wich version??which version is better..?? --- On Sat, 4/18/09, Ivan Kalik <tnt(a)kalik.net> wrote: From: Ivan Kalik <tnt(a)kalik.net> Subject: RE: NAS table To: "'FreeRadius users mailing list'" <freeradius-users(a)lists.freeradius.org> Date: Saturday, April 18, 2009, 3:06 AM Upgrade. That's a very old server version. In 1.x you had to have an entry in clients.conf for sql to read clients. And something is wrong with your clients.conf since debug stops when server tries to read it. Ivan Kalik Kalik Informatika ISP -----Original Message----- From: freeradius-users-bounces+tnt=kalik.net(a)lists.freeradius.org [mailto:freeradius-users-bounces+tnt=kalik.net@lists.freeradius.org] On Behalf Of Nizar Zulmi Sent: 16 April 2009 13:25 To: FreeRadius users mailing list Subject: RE: NAS table dearl list all..don't know how to thanks to you to reply my email and answer my quest. and sorry for to much question.:D i've run this command radiusd -X but it return this The program 'radiusd' can be found in the following packages: * radiusd-livingston * yardradius * xtradius Try: apt-get install <selected package i read freeradius documentation to do debug in ubuntu, and i try this command but i freeradius -X and return this message freeradius -X Starting - reading configuration files ... reread_config: reading radiusd.conf Config: including file: /etc/freeradius/proxy.conf Config: including file: /etc/freeradius/clients.conf Config: including file: /etc/freeradius/snmp.conf Config: including file: /etc/freeradius/eap.conf Config: including file: /etc/freeradius/sql.conf main: prefix = "/usr" main: localstatedir = "/var" main: logdir = "/var/log/freeradius" main: libdir = "/usr/lib/freeradius" main: radacctdir = "/var/log/freeradius/radacct" main: hostname_lookups = no main: max_request_time = 30 main: cleanup_delay = 5 main: max_requests = 1024 main: delete_blocked_requests = 0 main: port = 0 main: allow_core_dumps = no main: log_stripped_names = no main: log_file = "/var/log/freeradius/radius.log" main: log_auth = no main: log_auth_badpass = no main: log_auth_goodpass = no main: pidfile = "/var/run/freeradius/freeradius.pid" main: user = "freerad" main: group = "freerad" main: usercollide = no main: lower_user = "no" main: lower_pass = "no" main: nospace_user = "no" main: nospace_pass = "no" main: checkrad = "/usr/sbin/checkrad" main: proxy_requests = yes proxy: retry_delay = 5 proxy: retry_count = 3 proxy: synchronous = no proxy: default_fallback = yes proxy: dead_time = 120 proxy: post_proxy_authorize = no proxy: wake_all_if_all_dead = no security: max_attributes = 200 security: reject_delay = 1 security: status_server = no main: debug_level = 0 read_config_files: reading dictionary read_config_files: reading naslist Using deprecated naslist file. Support for this will go away soon. read_config_files: reading clients this message after i comment out this inf clients.conf #client 127.0.0.1 { # secret = passwordradius # shortname = localhost # nastype = other # localhost isn't usually a NAS... # } but if i uncomment that then i run freeradius -X it return this message main: debug_level = 0 read_config_files: reading dictionary read_config_files: reading naslist Using deprecated naslist file. Support for this will go away soon. read_config_files: reading clients read_config_files: reading realms radiusd: entering modules setup Module: Library search path is /usr/lib/freeradius Module: Loaded exec exec: wait = yes exec: program = "(null)" exec: input_pairs = "request" exec: output_pairs = "(null)" exec: packet_type = "(null)" rlm_exec: Wait=yes but no output defined. Did you mean output=none? Module: Instantiated exec (exec) Module: Loaded expr Module: Instantiated expr (expr) Module: Loaded PAP pap: encryption_scheme = "crypt" pap: auto_header = yes Module: Instantiated pap (pap) Module: Loaded CHAP Module: Instantiated chap (chap) Module: Loaded MS-CHAP mschap: use_mppe = yes mschap: require_encryption = no mschap: require_strong = no mschap: with_ntdomain_hack = no mschap: passwd = "(null)" mschap: ntlm_auth = "(null)" Module: Instantiated mschap (mschap) Module: Loaded System unix: cache = no unix: passwd = "(null)" unix: shadow = "/etc/shadow" unix: group = "(null)" unix: radwtmp = "/var/log/freeradius/radwtmp" unix: usegroup = no unix: cache_reload = 600 Module: Instantiated unix (unix) Module: Loaded eap eap: default_eap_type = "md5" eap: timer_expire = 60 eap: ignore_unknown_eap_types = no eap: cisco_accounting_username_bug = no rlm_eap: Loaded and initialized type md5 rlm_eap: Loaded and initialized type leap gtc: challenge = "Password: " gtc: auth_type = "PAP" rlm_eap: Loaded and initialized type gtc mschapv2: with_ntdomain_hack = no rlm_eap: Loaded and initialized type mschapv2 Module: Instantiated eap (eap) Module: Loaded preprocess preprocess: huntgroups = "/etc/freeradius/huntgroups" preprocess: hints = "/etc/freeradius/hints" preprocess: with_ascend_hack = no preprocess: ascend_channels_per_line = 23 preprocess: with_ntdomain_hack = no preprocess: with_specialix_jetstream_hack = no preprocess: with_cisco_vsa_hack = no preprocess: with_alvarion_vsa_hack = no Module: Instantiated preprocess (preprocess) Module: Loaded realm realm: format = "suffix" realm: delimiter = "@" realm: ignore_default = no realm: ignore_null = no Module: Instantiated realm (suffix) Module: Loaded SQL sql: driver = "rlm_sql_mysql" sql: server = "localhost" sql: port = "" sql: login = "root" sql: password = "jOeLya" sql: radius_db = "radius" sql: nas_table = "nas" sql: sqltrace = no sql: sqltracefile = "/var/log/freeradius/sqltrace.sql" sql: readclients = yes sql: deletestalesessions = yes sql: num_sql_socks = 5 sql: sql_user_name = "%{User-Name}" sql: default_user_profile = "" sql: query_on_not_found = no sql: authorize_check_query = "SELECT id, UserName, Attribute, Value, op FROM radcheck WHERE Username = '%{SQL-User-Name}' ORDER B Y id" sql: authorize_reply_query = "SELECT id, UserName, Attribute, Value, op FROM radreply WHERE Username = '%{SQL-User-Name}' ORDER B Y id" sql: authorize_group_check_query = "SELECT radgroupcheck.id,radgroupcheck.Group Name,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op FROM radgroup check,usergroup WHERE usergroup.Username = '%{SQL-User-Name}' AND usergroup.Grou pName = radgroupcheck.GroupName ORDER BY radgroupcheck.id" sql: authorize_group_reply_query = "SELECT radgroupreply.id,radgroupreply.Group Name,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op FROM radgroup reply,usergroup WHERE usergroup.Username = '%{SQL-User-Name}' AND usergroup.Grou pName = radgroupreply.GroupName ORDER BY radgroupreply.id" sql: accounting_onoff_query = "UPDATE radacct SET AcctStopTime='%S', AcctSessio nTime=unix_timestamp('%S') - unix_timestamp(AcctStartTime), AcctTerminateCause=' %{Acct-Terminate-Cause}', AcctStopDelay = '%{Acct-Delay-Time}' WHERE AcctSession Time=0 AND AcctStopTime=0 AND NASIPAddress= '%{NAS-IP-Address}' AND AcctStartTim e <= '%S'" sql: accounting_update_query = "UPDATE radacct SET FramedIPAddress = '%{Framed-IP-Address}', AcctSessionTime = '%{Acct-Session-Time}', AcctInputOctets = '%{Acct-Input-Octets}', AcctOutputOctets = '%{ Acct-Output-Octets}' WHERE AcctSessionId = '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}' AND NASIPAddress= '%{NAS-IP-Addr ess}'" sql: accounting_update_query_alt = "INSERT into radacct (AcctSessionId, AcctUni queId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, Acc tSessionTime, AcctAuthentic, ConnectInfo_start, AcctInputOctets, AcctOutputOctet s, CalledStationId, CallingStationId, ServiceType, FramedProtocol, FramedIPAddre ss, AcctStartDelay) values('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '% {SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Ty pe}', DATE_SUB('%S',INTERVAL (%{Acct-Session-Time:-0} + %{Acct-Delay-Time:-0}) S ECOND), '%{Acct-Session-Time}', '%{Acct-Authentic}', '', '%{Acct-Input-Octets}', '%{Acct-Output-Octets}', '%{Called-Station-Id}', '%{Calling-Station-Id}', '%{Se rvice-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '0')" sql: accounting_start_query = "INSERT into radacct (AcctSessionId, AcctUniqueId , UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctStop Time, AcctSessionTime, AcctAuthentic, ConnectInfo_start, ConnectInfo_stop, AcctI nputOctets, AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCa use, ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStopDelay ) values('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', '%S', '0', ' 0', '%{Acct-Authentic}', '%{Connect-Info}', '', '0', '0', '%{Called-Station-Id}' , '%{Calling-Station-Id}', '', '%{Service-Type}', '%{Framed-Protocol}', '%{Frame d-IP-Address}', '%{Acct-Delay-Time}', '0')" sql: accounting_start_query_alt = "UPDATE radacct SET AcctStartTime = '%S', Acc tStartDelay = '%{Acct-Delay-Time}', ConnectInfo_start = '%{Connect-Info}' WHERE AcctSessionId = '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}' AND NASIP Address = '%{NAS-IP-Address}'" sql: accounting_stop_query = "UPDATE radacct SET AcctStopTime = '%S', AcctSessi onTime = '%{Acct-Session-Time}', AcctInputOctets = '%{Acct-Input-Octets}', AcctO utputOctets = '%{Acct-Output-Octets}', AcctTerminateCause = '%{Acct-Terminate-Ca use}', AcctStopDelay = '%{Acct-Delay-Time}', ConnectInfo_stop = '%{Connect-Info} ' WHERE AcctSessionId = '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}' A ND NASIPAddress = '%{NAS-IP-Address}'" sql: accounting_stop_query_alt = "INSERT into radacct (AcctSessionId, AcctUniqu eId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctS topTime, AcctSessionTime, AcctAuthentic, ConnectInfo_start, ConnectInfo_stop, Ac ctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminat eCause, ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStopDe lay) values('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name} ', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', DATE_SUB( '%S', INTERVAL (%{Acct-Session-Time:-0} + %{Acct-Delay-Time:-0}) SECOND), '%S', '%{Acct-Session-Time}', '%{Acct-Authentic}', '', '%{Connect-Info}', '%{Acct-Inpu t-Octets}', '%{Acct-Output-Octets}', '%{Called-Station-Id}', '%{Calling-Station- Id}', '%{Acct-Terminate-Cause}', '%{Service-Type}', '%{Framed-Protocol}', '%{Fra med-IP-Address}', '0', '%{Acct-Delay-Time}')" sql: group_membership_query = "SELECT GroupName FROM usergroup WHERE UserName=' %{SQL-User-Name}'" sql: connect_failure_retry_delay = 60 sql: simul_count_query = "" sql: simul_verify_query = "SELECT RadAcctId, AcctSessionId, UserName, NASIPAddr ess, NASPortId, FramedIPAddress, CallingStationId, FramedProtocol FROM radacct W HERE UserName='%{SQL-User-Name}' AND AcctStopTime = 0" sql: postauth_query = "INSERT into radpostauth (id, user, pass, reply, date) va lues ('', '%{User-Name}', '%{User-Password:-Chap-Password}', '%{reply:Packet-Typ e}', NOW())" sql: safe-characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ01 23456789.-_: /" rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked rlm_sql (sql): Attempting to connect to root@localhost:/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 rlm_sql (sql): - generate_sql_clients rlm_sql (sql): Query: SELECT * FROM nas rlm_sql (sql): Reserving sql socket id: 4 rlm_sql (sql): Read entry nasname=127.0.0.1,shortname=localhost,secret=passwordr adius rlm_sql (sql): Adding client 127.0.0.1 (localhost) to clients list rlm_sql (sql): Released sql socket id: 4 Module: Instantiated sql (sql) Module: Loaded Acct-Unique-Session-Id acct_unique: key = "User-Name, Acct-Session-Id, NAS-IP-Address, Client-IP-Addre ss, NAS-Port" Module: Instantiated acct_unique (acct_unique) Module: Loaded files files: usersfile = "/etc/freeradius/users" files: acctusersfile = "/etc/freeradius/acct_users" files: preproxy_usersfile = "/etc/freeradius/preproxy_users" files: compat = "no" Module: Instantiated files (files) Module: Loaded detail detail: detailfile = "/var/log/freeradius/radacct/%{Client-IP-Address}/detail-% Y%m%d" detail: detailperm = 384 detail: dirperm = 493 detail: locking = no Module: Instantiated detail (detail) Module: Loaded radutmp radutmp: filename = "/var/log/freeradius/radutmp" radutmp: username = "%{User-Name}" radutmp: case_sensitive = yes radutmp: check_with_nas = yes radutmp: perm = 384 radutmp: callerid = yes Module: Instantiated radutmp (radutmp) Listening on authentication *:1812 Listening on accounting *:1813 Ready to process requests. whats really wrong...still cannot read NAS from nas table on radius..was it? really apreciate your answer. Nizar --- On Thu, 4/16/09, Ivan Kalik <tnt(a)kalik.net> wrote: From: Ivan Kalik <tnt(a)kalik.net> Subject: RE: NAS table To: "'FreeRadius users mailing list'" <freeradius-users(a)lists.freeradius.org> Date: Thursday, April 16, 2009, 4:02 AM this is result of freeradius -X reread_config: reading radiusd.conf Config: including file: /etc/freeradius/proxy.conf Config: including file: /etc/freeradius/clients.conf Config: including file: /etc/freeradius/snmp.conf Config: including file: /etc/freeradius/eap.conf Config: including file: /etc/freeradius/sql.conf It's not. It's a result of HUP. Now post what you were told. Ivan Kalik Kalik Informatika ISP -----Inline Attachment Follows----- - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.0.238 / Virus Database: 270.11.57/2060 - Release Date: 04/15/09 19:52:00 -----Inline Attachment Follows----- - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

2 1

how to disable double connection
by Tseveendorj 18 Apr '09

18 Apr '09

Hello, I'm providing internet to customers via ADSL2+. I have cisco router and FreeRADIUS 2.1.3. Customer can make double connection via PPPoE. How to disable double connection ? What kind of attribute can do that ? Thanks for any help. Sincerely, Tseveen.

3 5

Re: Freeradius-Users Digest, Vol 48, Issue 70
by Khan 17 Apr '09

17 Apr '09

On Fri, Apr 17, 2009 at 5:00 AM, <freeradius-users-request(a)lists.freeradius.org> wrote: > Send Freeradius-Users mailing list submissions to > freeradius-users(a)lists.freeradius.org > > To subscribe or unsubscribe via the World Wide Web, visit > http://lists.freeradius.org/mailman/listinfo/freeradius-users > or, via email, send a message with subject or body 'help' to > freeradius-users-request(a)lists.freeradius.org > > You can reach the person managing the list at > freeradius-users-owner(a)lists.freeradius.org > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Freeradius-Users digest..." > > > Today's Topics: > > 1. FreeRADIUS 2 Installation failed on ubuntu hardy (Khan) > 2. Re: problev with radius (A.L.M.Buxey(a)lboro.ac.uk) > 3. Re: FreeRADIUS 2 Installation failed on ubuntu hardy > (A.L.M.Buxey(a)lboro.ac.uk) > 4. Re: FreeRADIUS 2 Installation failed on ubuntu hardy > (EasyHorpak.com) > 5. Re: FreeRADIUS 2 Installation failed on ubuntu hardy (Alan DeKok) > 6. Re: radpostauth sql logging of bad passwords (Alan DeKok) > 7. RE: rlm_perl behavior (Meyers, Dan) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Fri, 17 Apr 2009 01:33:31 -0500 > From: Khan <khansfriend(a)gmail.com> > Subject: FreeRADIUS 2 Installation failed on ubuntu hardy > To: freeradius-users(a)lists.freeradius.org > Message-ID: > <d0992c780904162333m676a83c9o65b1f5921922a753(a)mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > Hello everyone, > > I am new to VoIP, its my first time installing FR on my server. I > followed the instructions and first installed dependencies and then > FR. > > My installation process and other steps i took can be found on this > link: http://voiprookie.blogspot.com/ > > I tried to install it several time but no luck, first I used aptitude > which installed the 1.x version so i removed it and then I used > synaptic to install that didn't work, finally i took manual approach > and installed it as posted on the link above. > > However during installation I have seen many warnings, I tried to > capture the screen dump which can be found at this link: > http://pastebin.com/f1d50a81 > > Obviously it didn't install right but i have no clue where to go from > here, could anyone please help me guide to the right procedure. The > version on other information are posted on my bloggspot link. > > Does installing, removing, and re-installing several times screwed up > my server and now it wouldn't let me install ? > > Please help!!! > > > Thanks ya'all in advance... > > > Khan > > > ------------------------------ > > Message: 2 > Date: Fri, 17 Apr 2009 08:38:29 +0100 > From: A.L.M.Buxey(a)lboro.ac.uk > Subject: Re: problev with radius > To: FreeRadius users mailing list > <freeradius-users(a)lists.freeradius.org> > Message-ID: <20090417073829.GA14282(a)lboro.ac.uk> > Content-Type: text/plain; charset=us-ascii > > Hi, > >> Fri Apr 17 09:52:09 2009 : Auth: Login OK: [miracle] (from client st17-gw port 367362 cli 00:14:A4:46:73:26) >> Fri Apr 17 09:52:12 2009 : Auth: Login OK: [stepanov] (from client st17-gw port 367363 cli 00:0E:A6:3A:A5:4E) >> Fri Apr 17 09:52:13 2009 : Auth: Login OK: [260130] (from client rep-hsgw01 port 2151678103 cli 00:1F:C6:A6:F9:A6) >> >> What this mean this error? >> > > it means your server is hanging around waiting for authentication stuff > to be sorted out ...and the request is being asked again...and again... > > the cause is usually a very slow database or LDAP server. > > alan > > > ------------------------------ > > Message: 3 > Date: Fri, 17 Apr 2009 08:46:24 +0100 > From: A.L.M.Buxey(a)lboro.ac.uk > Subject: Re: FreeRADIUS 2 Installation failed on ubuntu hardy > To: FreeRadius users mailing list > <freeradius-users(a)lists.freeradius.org> > Message-ID: <20090417074624.GB14282(a)lboro.ac.uk> > Content-Type: text/plain; charset=us-ascii > > Hi, > >> My installation process and other steps i took can be found on this >> link: http://voiprookie.blogspot.com/ >> >> I tried to install it several time but no luck, first I used aptitude >> which installed the 1.x version so i removed it and then I used >> synaptic to install that didn't work, finally i took manual approach >> and installed it as posted on the link above. >> >> However during installation I have seen many warnings, I tried to >> capture the screen dump which can be found at this link: >> http://pastebin.com/f1d50a81 > > http://wiki.freeradius.org/Build#Building_Ubuntu_packages > > what do you mean by 'it didnt install right'? what happens when > you run "radiusd -X"? i get errors in modular installation and it fails: rlm_eap: Failed to initialize type tls /usr/local/etc/raddb/eap.conf[17]: Instantiation failed for module "eap" /usr/local/etc/raddb/sites-enabled/inner-tunnel[223]: Failed to find module "eap". /usr/local/etc/raddb/sites-enabled/inner-tunnel[176]: Errors parsing authenticate section. Detailed output is at this line: http://pastebin.com/m1c3688bc Problem areas are highlighted in my guess but i could be wrong... > >> Does installing, removing, and re-installing several times screwed up >> my server and now it wouldn't let me install ? > > only if you threw it all over the place and didnt clean up after. the > server is pretty good at dealing with older bits in the wrong places > (because it wont read them - as the location of files its supposed > to read are in the config file!). if it installed into /usr/local/lib > then is that in your LDPATH? > I was only in usr/src directory when i followed installation instructions, the step by step what i did is at my blogspot to review. Here is the link to that: http://voiprookie.blogspot.com/ > alan > > > ------------------------------ > > Message: 4 > Date: Fri, 17 Apr 2009 15:42:55 +0700 > From: "EasyHorpak.com" <info(a)easyhorpak.com> > Subject: Re: FreeRADIUS 2 Installation failed on ubuntu hardy > To: "FreeRadius users mailing list" > <freeradius-users(a)lists.freeradius.org> > Message-ID: <002101c9bf38$80f73c10$03b6a8c0@nznf80c39ca487> > Content-Type: text/plain; format=flowed; charset="windows-874"; > reply-type=original > > Ubuntu 8.04 hardy is freeradius 1.7 > > if Ubuntu 8.10 is freeradius 2.1 > > > > ----- Original Message ----- > From: <A.L.M.Buxey(a)lboro.ac.uk> > To: "FreeRadius users mailing list" <freeradius-users(a)lists.freeradius.org> > Sent: Friday, April 17, 2009 2:46 PM > Subject: Re: FreeRADIUS 2 Installation failed on ubuntu hardy > > >> Hi, >> >>> My installation process and other steps i took can be found on this >>> link: http://voiprookie.blogspot.com/ >>> >>> I tried to install it several time but no luck, first I used aptitude >>> which installed the 1.x version so i removed it and then I used >>> synaptic to install that didn't work, finally i took manual approach >>> and installed it as posted on the link above. >>> >>> However during installation I have seen many warnings, I tried to >>> capture the screen dump which can be found at this link: >>> http://pastebin.com/f1d50a81 >> >> http://wiki.freeradius.org/Build#Building_Ubuntu_packages >> >> what do you mean by 'it didnt install right'? what happens when >> you run "radiusd -X"? >> >>> Does installing, removing, and re-installing several times screwed up >>> my server and now it wouldn't let me install ? >> >> only if you threw it all over the place and didnt clean up after. the >> server is pretty good at dealing with older bits in the wrong places >> (because it wont read them - as the location of files its supposed >> to read are in the config file!). if it installed into /usr/local/lib >> then is that in your LDPATH? >> >> alan >> - >> List info/subscribe/unsubscribe? See >> http://www.freeradius.org/list/users.html >> > > > > ------------------------------ > > Message: 5 > Date: Fri, 17 Apr 2009 11:07:42 +0200 > From: Alan DeKok <aland(a)deployingradius.com> > Subject: Re: FreeRADIUS 2 Installation failed on ubuntu hardy > To: FreeRadius users mailing list > <freeradius-users(a)lists.freeradius.org> > Message-ID: <49E846DE.7040500(a)deployingradius.com> > Content-Type: text/plain; charset=ISO-8859-1 > > Khan wrote: >> My installation process and other steps i took can be found on this >> link: http://voiprookie.blogspot.com/ > > The discussion on editing the "configure" arguments is unnecessary. > If you had read the rest of the debian/control file, you would see how > OpenSSL *should* be enabled. > >> I tried to install it several time but no luck, first I used aptitude >> which installed the 1.x version so i removed it and then I used >> synaptic to install that didn't work, finally i took manual approach >> and installed it as posted on the link above. > > It didn't work because you didn't install the libssl-dev package. It is already installed, i made sure i have dependencies installed before i started to install but i might have forgotten something. As you can see my libssl-dev is already installed root@voipbiznet:~# apt-get install libssl-dev Reading package lists... Done Building dependency tree Reading state information... Done libssl-dev is already the newest version. libssl-dev set to manually installed. 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 5 not fully installed or removed. After this operation, 0B of additional disk space will be used. Setting up freeradius-iodbc (2.1.4-0) ... * Restarting FreeRADIUS server freeradius [fail] * Failed to stop freeradius. invoke-rc.d: initscript freeradius, action "restart" failed. dpkg: error processing freeradius-iodbc (--configure): subprocess post-installation script returned error exit status 1 Setting up freeradius-krb5 (2.1.4-0) ... * Restarting FreeRADIUS server freeradius [fail] * Failed to stop freeradius. invoke-rc.d: initscript freeradius, action "restart" failed. dpkg: error processing freeradius-krb5 (--configure): subprocess post-installation script returned error exit status 1 Setting up freeradius-ldap (2.1.4-0) ... * Restarting FreeRADIUS server freeradius [fail] * Failed to stop freeradius. invoke-rc.d: initscript freeradius, action "restart" failed. dpkg: error processing freeradius-ldap (--configure): subprocess post-installation script returned error exit status 1 Setting up freeradius-mysql (2.1.4-0) ... * Restarting FreeRADIUS server freeradius [fail] * Failed to stop freeradius. invoke-rc.d: initscript freeradius, action "restart" failed. dpkg: error processing freeradius-mysql (--configure): subprocess post-installation script returned error exit status 1 Setting up freeradius-postgresql (2.1.4-0) ... * Restarting FreeRADIUS server freeradius [fail] * Failed to stop freeradius. invoke-rc.d: initscript freeradius, action "restart" failed. dpkg: error processing freeradius-postgresql (--configure): subprocess post-installation script returned error exit status 1 Errors were encountered while processing: freeradius-iodbc freeradius-krb5 freeradius-ldap freeradius-mysql freeradius-postgresql E: Sub-process /usr/bin/dpkg returned an error code (1) r > >> However during installation I have seen many warnings, I tried to >> capture the screen dump which can be found at this link: >> http://pastebin.com/f1d50a81 > > I've never understood why people get worried about compile warnings. > Ignore them. Thanks, now i know not to worry about warnings... > >> Does installing, removing, and re-installing several times screwed up >> my server and now it wouldn't let me install ? > > It takes a lot of hard work to break things that badly. I guess working in the middle of night is not good idea, i have no recollection of what happened :( > > Alan DeKok. > > > ------------------------------ > > Message: 6 > Date: Fri, 17 Apr 2009 11:08:17 +0200 > From: Alan DeKok <aland(a)deployingradius.com> > Subject: Re: radpostauth sql logging of bad passwords > To: FreeRadius users mailing list > <freeradius-users(a)lists.freeradius.org> > Message-ID: <49E84701.3080600(a)deployingradius.com> > Content-Type: text/plain; charset=ISO-8859-1 > > Guy Fraser wrote: >> I have installed : >> "radiusd: FreeRADIUS Version 2.1.3, for host i386-portbld-freebsd7.1, >> built on Feb 26 2009 at 15:47:46" >> >> I have not been able figure out how to get it to log failed >> authentication attempts >> into the radpostauth sql table, like I had it working in Version 1. > > What do you mean by that? > > Q: "I tried to do stuff, but it didn't work". > A: Huh? > > Alan DeKok. > > > ------------------------------ > > Message: 7 > Date: Fri, 17 Apr 2009 10:26:36 +0100 > From: "Meyers, Dan" <d.meyers(a)lancaster.ac.uk> > Subject: RE: rlm_perl behavior > To: "FreeRadius users mailing list" > <freeradius-users(a)lists.freeradius.org> > Message-ID: > <9FFF610D5DF89A4CAC9CB450C756566302456448(a)exchange-be4.lancs.local> > Content-Type: text/plain; charset="us-ascii" > >> >> It should be running one Perl thread per system thread. The > server >> >> core already manages min/max spare threads, idle threads, etc. > <snip> >> > I hope this implementation will satisfy Borislav too. Will he be >> > able to >> > instantiate different perl scripts for different needs? >> > >> > So, when do I start testing :) > > Just to say, we're currently using FreeRadius 2.1.3 with rlm_perl in a > project currently in active development, and having read this i'm > holding off upgrading to 2.1.4 as we also use the multiple perl threads > functionality of the module to parallel process and increase throughput. > We have a specific development server/environment, and would be more > than happy to test any patches designed to fix this 2.1.4 issue on it. > > -- > Dan Meyers > Network Specialist, Lancaster University > E-Mail: d.meyers(a)lancaster.ac.uk > > > > > > > ------------------------------ > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html > > > End of Freeradius-Users Digest, Vol 48, Issue 70 > ************************************************ >

1 0