- Freeradius-Devel - lists.freeradius.org

Re: If SQL not available during startup, then it not available all the time
by Ruslan A Dautkhanov 08 Jun '06

08 Jun '06

Hello ! > > Sun Apr 23 10:08:22 2006 : Error: rlm_sql (pgsql-voip): Failed to connect DB handle #0 > > Sun Apr 23 10:08:22 2006 : Debug: rlm_sql (pgsql-voip): starting 1 > > Sun Apr 23 10:08:22 2006 : Debug: rlm_sql (pgsql-voip): starting 2 > > Sun Apr 23 10:08:22 2006 : Debug: rlm_sql (pgsql-voip): starting 3 > > Sun Apr 23 10:08:22 2006 : Debug: rlm_sql (pgsql-voip): starting 4 > > Sun Apr 23 10:08:22 2006 : Debug: rlm_sql (pgsql-voip): Failed to > > connect to any SQL server. > > > Sun Apr 23 10:08:22 2006 : Debug: Module: Instantiated sql (pgsql-voip) > > then it will not available all the time until we reload FreeRADIUS daemon - > > it not ever try to reconnect: > > Sun Apr 23 10:17:51 2006 : Debug: radius_xlat: 'INSERT into > > radoriginate (RadiusServerName, UserName, NASIPAddress, > AcctStartTime, AcctStopTime, Cal > > > Sun Apr 23 10:17:51 2006 : Debug: rlm_sql (pgsql-voip): Ignoring unconnected handle 4.. > > Sun Apr 23 10:17:51 2006 : Debug: rlm_sql (pgsql-voip): Ignoring unconnected handle 3.. > > Sun Apr 23 10:17:51 2006 : Debug: rlm_sql (pgsql-voip): Ignoring unconnected handle 2.. > > Sun Apr 23 10:17:51 2006 : Debug: rlm_sql (pgsql-voip): Ignoring unconnected handle 1.. > > Sun Apr 23 10:17:51 2006 : Debug: rlm_sql (pgsql-voip): Ignoring unconnected handle 0.. > > Sun Apr 23 10:17:51 2006 : Info: rlm_sql (pgsql-voip): There are no DB handles to use! skipped 5, tried to connect 0 > > Why FreeRADIUS do not try to reconnect during sql command must be > proceeded ? > Is it possible to fix via configuration parameter or its hard-coded bug ? > > P.S. I had maid perl-script to recover radius cdrs into DB from > standard FreeRADIUS detail-* files. > If any interesting in it, I'll public it on the web. Please help to resolve this bug... > I would be interested, however there is already a perl script that does > exactly that called h323detail2db.pl in src/billing/ > It is specific to Cisco h323 VSA records and my pqsl-voip schema but it can be > trivially changed to work with "standard" records. > If you give me a look at your script, maybe we can combine our work. http://www.onlinebilling.ru/freeradius/rad-details/radvoiplogs2db.pl I think this is much pretty script - it's easy to configure to different scheme. It's only have no any preparations for open Cisco-AVPair since my FR parse all needed attributes self, but it can be easily done... -- Ruslan A Dautkhanov

2 3

Automatic report from sources (radiusd) between 07.06.2006 - 08.06.2006 GMT
by Automatic cvs log generator 08 Jun '06

08 Jun '06

CVS log entries from 07.06.2006 (Wed) 08:00:01 - 08.06.2006 (Thu) 08:00:01 GMT ===================================================== Summary by authors ===================================================== Author: pnixon File: radiusd/src/billing/h323detail2db.pl; Revisions: 1.18 ===================================================== Log entries ===================================================== Description: minor gramatical fix Modified files: File: radiusd/src/billing/h323detail2db.pl; Revision: 1.18; Date: 2006/06/07 17:20:52; Author: pnixon; Lines: (+3 -3) ===================================================== Summary of modified files ===================================================== File: radiusd/src/billing/h323detail2db.pl Revisions: 1.18 Authors: pnixon (+3 -3) -- Automatic cron job from /web/pages/us.freeradius.org/bin/new_makelog.pl

1 0

Excellent Position for a Sr. Software Engineer (Radius Applications) || GA || 6 months Contract
by Dharmendra Sachdeva 05 Jun '06

05 Jun '06

Hi, I have an urgent position for a Sr. Software Engineer in Atlanta, GA for a 6 months Contract. Please go through the requirement once you feel comfortable please reply me back with your Updated Resume in Word Format , Present Location , Expected Rate on hourly basis and Availability. Key Words: Radius (c or java) unix administration shell (cvs or ant or gdb or sh or "gnu c" or "sun java" ) ospf bgp (wan or "wide area network") (rf or microwave) (wireless or isp or adelphia) Required Skills: . C or Java system programming skills in a Unix environment. . Debugging multithreaded applications. . Knowledge of some Unix system administration skills. . Understanding of software development life cycle i.e. requirement, design, development, testing, deployment, and support. . Knowledge of basic software development tools and Unix shell script(s) i.e. .CVS, make, ant, gdb, sh, gnu C compiler, Sun Java compiler, and others. . Knowledge and experience with the RADIUS application. . Complex OSPF and BGP design in a large Wide Area Network environment. . RF/Microwave and Communication Systems, GIS Systems, and/or web portal-based authentication systems. Desired: Complex networks - both wired and wireless and in a large Internet Service Provider context. Job Description: Atlanta, GA # Of Openings: 1 6 months . Reports to Software Engineer Team Lead. . Core responsibility to troubleshoot and debug multithreaded applications. Thanks & Regards, Dharmendra Sachdeva cyberThink Inc. Tel : (908) 429-8008 x 390 Fax : (908) 429-8005 dharmendra(a)cyberThink.com mr.dharmendra(a)msn.com www.cyberThink.com cyberThink has been recognized as one of the fastest growing IT Services and Staffing companies in the U.S. by INC. magazine, Deloitte & Touche and Purple Squirrel.cyberThink Inc. is an Equal Opportunity Employer""We are open to hire US Citizens, Green Card holders & H1b Visa Holders"

1 0

1.1.2: specifying installation directory (env R) causes install to fail
by Kevin Bonner 05 Jun '06

05 Jun '06

OS: CentOS 4 FR version: 1.1.2 I've tried to build the latest FR release and found the modules were being linked against the 1.1.0 version of libradius I had installed. After removing all 1.1.0 binaries and libraries, I tried compiling again and am receiving the following errors. I'm having some trouble determining where to fix this, so any patches/suggestions would be appreciated. I can provide more output (or the full output) if it helps with debugging. In the gcc line, if I add "-L/tmp/freeradius-buildroot/usr/local/lib" and run it by hand to build the module, everything works as expected. Probably just a missing $(R) somewhere, but it's been a while since I've had to heavily dive into autoconf/make files. Thanks, Kevin Bonner $ mkdir /tmp/freeradius-buildroot $ ./configure && make && make R=/tmp/freeradius-buildroot install ... gcc -shared rlm_checkval.lo -Wl,--rpath -Wl,/usr/local/lib -L/usr/local/lib -lradius -lnsl -lresolv -lpthread -Wl,-soname -Wl,rlm_checkval-1.1.2.so -o .libs/rlm_checkval-1.1.2.so /usr/bin/ld: cannot find -lradius collect2: ld returned 1 exit status libtool: install: error: relink `rlm_checkval.la' with the above command before installing it libtool: install: warning: remember to run `libtool --finish /usr/local/lib' ... $ cd /tmp/freeradius-buildroot/usr/local/lib/ $ ls -1 libradius* libradius-1.1.2.la libradius-1.1.2.so libradius.a libradius.la libradius.so

2 2

RE: 1.1.2: specifying installation directory (env R) causesinstallto fail
by Ryan Melendez 05 Jun '06

05 Jun '06

Sorry, set the vars to : -L/alt/dir/to/usr/local/lib Rather than just the path. Ryan > -----Original Message----- > From: freeradius-devel-bounces+rmelendez=wayport.net(a)lists.freeradius.org > [mailto:freeradius-devel- > bounces+rmelendez=wayport.net(a)lists.freeradius.org] On Behalf Of Ryan > Melendez > Sent: Monday, June 05, 2006 10:19 AM > To: FreeRadius developers mailing list > Subject: RE: 1.1.2: specifying installation directory (env R) > causesinstallto fail > > > As you noted, adding -L... helps. I'm not sure how to do this with > > libtool, because it's "install" stage doesn't accept linker options, > > even though it's actually doing linking. > > > > Did I mention I hated that PoS? > > > > Maybe setting LD_LIBRARY_PATH before running libtool --install will > > work? > > I had this same problem as I set R as well. This was fixed for me by > setting: > > LDFLAGS (before ./configure) > RLM_LDFLAGS (when you call make) > > I made my own makefile one directory up: > > all: > cd ${SRCDIR} && LDFLAGS=/alt/dir/to/usr/local/lib \ > ./configure \ > (etc....) \ > && make \ > RLM_LDFLAGS=/alt/dir/to/usr/local/lib > > Thanks, > Ryan > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/devel.html

1 0

RE: 1.1.2: specifying installation directory (env R) causes installto fail
by Ryan Melendez 05 Jun '06

05 Jun '06

> As you noted, adding -L... helps. I'm not sure how to do this with > libtool, because it's "install" stage doesn't accept linker options, > even though it's actually doing linking. > > Did I mention I hated that PoS? > > Maybe setting LD_LIBRARY_PATH before running libtool --install will > work? I had this same problem as I set R as well. This was fixed for me by setting: LDFLAGS (before ./configure) RLM_LDFLAGS (when you call make) I made my own makefile one directory up: all: cd ${SRCDIR} && LDFLAGS=/alt/dir/to/usr/local/lib \ ./configure \ (etc....) \ && make \ RLM_LDFLAGS=/alt/dir/to/usr/local/lib Thanks, Ryan

1 0

Excellent Position for a Sr. Software Engineer (Radius Applications) || GA || 6 months Contract
by Dharmendra Sachdeva 05 Jun '06

05 Jun '06

Hi, I have an urgent position for a Sr. Software Engineer in Atlanta, GA for a 6 months Contract. Please go through the requirement once you feel comfortable please reply me back with your Updated Resume in Word Format , Present Location , Expected Rate on hourly basis and Availability. Key Words: Radius (c or java) unix administration shell (cvs or ant or gdb or sh or "gnu c" or "sun java" ) ospf bgp (wan or "wide area network") (rf or microwave) (wireless or isp or adelphia) Required Skills: . C or Java system programming skills in a Unix environment. . Debugging multithreaded applications. . Knowledge of some Unix system administration skills. . Understanding of software development life cycle i.e. requirement, design, development, testing, deployment, and support. . Knowledge of basic software development tools and Unix shell script(s) i.e. .CVS, make, ant, gdb, sh, gnu C compiler, Sun Java compiler, and others. . Knowledge and experience with the RADIUS application. . Complex OSPF and BGP design in a large Wide Area Network environment. . RF/Microwave and Communication Systems, GIS Systems, and/or web portal-based authentication systems. Desired: Complex networks - both wired and wireless and in a large Internet Service Provider context. Job Description: Atlanta, GA # Of Openings: 1 6 months . Reports to Software Engineer Team Lead. . Core responsibility to troubleshoot and debug multithreaded applications. Thanks & Regards, Dharmendra Sachdeva cyberThink Inc. Tel : (908) 429-8008 x 390 Fax : (908) 429-8005 dharmendra(a)cyberThink.com mr.dharmendra(a)msn.com www.cyberThink.com cyberThink has been recognized as one of the fastest growing IT Services and Staffing companies in the U.S. by INC. magazine, Deloitte & Touche and Purple Squirrel.cyberThink Inc. is an Equal Opportunity Employer""We are open to hire US Citizens, Green Card holders & H1b Visa Holders"

1 0

Does freeradius now support sybase ASE 15.0 yet?
by 陈旭 05 Jun '06

05 Jun '06

FreeRadiusDevel Does freeradius now support sybase ASE 15.0 yet? I am running freeradius1.0.5 on Redhat Enterprise Linux 4.0, with ASE 15.0 now, and lots of problems I an dealing now! Problems occured while I am compling freeradius, compiling module rlm_sql_sybase, it is not very easy to conquer all these problems, but I made it! At last, freeradius has been set up, but while accessing to my ASE15.0 server, an error dumped to my screen: Client Library error: severity(0) number(49) origin(1) layer(1) rlm_sql_sybase(sql_select_query): Unable to send command (ct_send()) What the problem is?

1 0

1.1.2 is broken if you have closefrom()
by Frank Cusack 02 Jun '06

02 Jun '06

So on Solaris, it's broken. src/include/autoconf.h.in#1.66 needs to be imported to the 1.1 branch. Probably other changes as well. (1.55 is the last change in the 1.1 branch.) It's also interesting that the freeradius closefrom() returns int (unlike solaris which returns void), yet no one uses the return value. I'd suggest just having it return void. I actually wouldn't mind adding some changes to a 1.1.3 release, if this problem warrants a new release. -frank

3 6

sql_sybase.c:767: error: conflicting types for 'sql_error'
by 陈旭 02 Jun '06

02 Jun '06

Dear FreeRadiusDevel I am trying to install freeradius 1.0.5 on my linux server, which running RedHat Enterpise Linux 4.0, and the database is sybase15.0. When compiling the moduel rlm_sql_sybase, a stange error occured. The message dumped into my screen is as following: ------------------------------------------------------------------------------------------- ... sql_sybase.c:666: warning: nested extern declaration of `sql_error' sql_sybase.c:262: warning: redundant redeclaration of 'sql_error' sql_sybase.c:262: warning: previous implicit declaration of 'sql_error' was here sql_sybase.c:666: warning: format argument is not a pointer (arg 3) sql_sybase.c: At top level: sql_sybase.c:682: warning: no previous prototype for 'sql_fetch_row' sql_sybase.c: In function `sql_fetch_row': sql_sybase.c:702: warning: nested extern declaration of `sql_error' sql_sybase.c:262: warning: redundant redeclaration of 'sql_error' sql_sybase.c:262: warning: previous implicit declaration of 'sql_error' was here sql_sybase.c:702: warning: format argument is not a pointer (arg 3) sql_sybase.c:706: warning: nested extern declaration of `sql_close' sql_sybase.c:381: warning: redundant redeclaration of 'sql_close' sql_sybase.c:381: warning: previous implicit declaration of 'sql_close' was here sql_sybase.c: At top level: sql_sybase.c:767: error: conflicting types for 'sql_error' sql_sybase.c:262: error: previous implicit declaration of 'sql_error' was here sql_sybase.c: In function `sql_error': sql_sybase.c:830: warning: return makes pointer from integer without a cast sql_sybase.c: At top level: sql_sybase.c:842: warning: static declaration of 'sql_close' follows non-static declaration sql_sybase.c:381: warning: previous implicit declaration of 'sql_close' was here sql_sybase.c:896: warning: static declaration of 'sql_finish_select_query' follows non-static declaration sql_sybase.c:579: warning: previous implicit declaration of 'sql_finish_select_query' was here sql_sybase.c:896: warning: unused parameter 'config' sql_sybase.c:873: warning: unused parameter 'config' sql_sybase.c:842: warning: unused parameter 'sqlsocket' sql_sybase.c:842: warning: unused parameter 'config' sql_sybase.c:767: warning: unused parameter 'sqlsocket' sql_sybase.c:767: warning: unused parameter 'config' sql_sybase.c:746: warning: unused parameter 'sqlsocket' sql_sybase.c:746: warning: unused parameter 'config' sql_sybase.c:621: warning: unused parameter 'sqlsocket' sql_sybase.c:621: warning: unused parameter 'config' sql_sybase.c:303: warning: unused parameter 'config' sql_sybase.c:54: warning: unused parameter 'cp' sql_sybase.c:55: warning: unused parameter 'chp' sql_sybase.c:92: warning: unused parameter 'context' sql_sybase.c:93: warning: unused parameter 'conn' sql_sybase.c:133: warning: unused parameter 'context' make: *** [sql_sybase.lo] Error 1 -------------------------------------------------------------------------------------------------- Attention should be paied to these two lines: sql_sybase.c:767: error: conflicting types for 'sql_error' sql_sybase.c:262: error: previous implicit declaration of 'sql_error' was here somebody tell me what is going on!!!!!! I installed the same version FR on the RedHat Personal 9.0 successfully!!!! Thanks a lot!

1 0