April 2009 - Freeradius-Users - lists.freeradius.org

RE: Freeradius 2.1.5 and Solaris gmake install problem.
by Ville Leinonen 20 Apr '09

20 Apr '09

Hi, Yes i go make "gmake" before 2gmake install" and i went fine. Br, Ville -----Original Message----- From: freeradius-users-bounces+ville.leinonen=solodel.com(a)lists.freeradius.org on behalf of Alan DeKok Sent: Mon 20/04/2009 14:11 To: FreeRadius users mailing list Subject: Re: Freeradius 2.1.5 and Solaris gmake install problem. Ville Leinonen wrote: > I try to install FR to my Solaris 10 (SPARC) box. > Now i run gmake install and get this error: Did you follow the instructions to type "make", before "make install"? Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

2 1

Freeradius 2.1.5 and Solaris gmake install problem.
by Ville Leinonen 20 Apr '09

20 Apr '09

Hi, I try to install FR to my Solaris 10 (SPARC) box. Now i run gmake install and get this error: Making install in rlm_acct_unique... gmake[6]: Entering directory `/home/ta/freeradius-server-2.1.4/src/modules/rlm_acct_unique' if [ "xrlm_acct_unique" != "x" ]; then \ /home/ta/freeradius-server-2.1.4/libtool --mode=install /home/ta/freeradius-server-2.1.4/install-sh -c -c \ rlm_acct_unique.la /usr/local/lib/rlm_acct_unique.la || exit $?; \ rm -f /usr/local/lib/rlm_acct_unique-2.1.5.la; \ ln -s rlm_acct_unique.la /usr/local/lib/rlm_acct_unique-2.1.5.la || exit $?; \ fi libtool: install: warning: relinking `rlm_acct_unique.la' (cd /home/ta/freeradius-server-2.1.4/src/modules/rlm_acct_unique; /bin/bash /home/ta/freeradius-server-2.1.4/libtool --mode=relink gcc -release 2.1.5 -module -export-dynamic -o rlm_acct_unique.la -rpath /usr/local/lib rlm_acct_unique.lo rlm_acct_unique.c /home/ta/freeradius-server-2.1.4/src/lib/libfreeradius-radius.la -lnsl -lresolv -lsocket -lposix4 -lpthread ) mv: cannot access rlm_acct_unique-2.1.5.so libtool: install: error: relink `rlm_acct_unique.la' with the above command before installing it gmake[6]: *** [install] Error 1 gmake[6]: Leaving directory `/home/ta/freeradius-server-2.1.4/src/modules/rlm_acct_unique' gmake[5]: *** [common] Error 2 gmake[5]: Leaving directory `/home/ta/freeradius-server-2.1.4/src/modules' gmake[4]: *** [install] Error 2 gmake[4]: Leaving directory `/home/ta/freeradius-server-2.1.4/src/modules' gmake[3]: *** [common] Error 2 gmake[3]: Leaving directory `/home/ta/freeradius-server-2.1.4/src' gmake[2]: *** [install] Error 2 gmake[2]: Leaving directory `/home/ta/freeradius-server-2.1.4/src' gmake[1]: *** [common] Error 2 gmake[1]: Leaving directory `/home/ta/freeradius-server-2.1.4' gmake: *** [install] Error 2 Any suggestions? Br, Ville

2 1

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