segmentation fault with postgresql and cisco vsa, please help
Hello group, I just downloaded the pre 1 release of the freeradius and using it with cisco vsa hack and postgresql. When I start radiusd, I receive a segmentation fault, sql: postauth_table = "radpostauth" sql: postauth_query = "" sql: safe-characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /" Segmentation fault The tables and databases are created successfully and I tested. I commented out vsa-hack and still see the same segmentation fault. please help. -apu __ Do you Yahoo!? Yahoo! Mail is new and improved - Check it out! http://promotions.yahoo.com/new_mail - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: segmentation fault with postgresql and cisco vsa, please help
actually it's the latest version that you have on your website (not the cvs). --- Alan DeKok <[EMAIL PROTECTED]> wrote: > Apu islam <[EMAIL PROTECTED]> wrote: > > I just downloaded the pre 1 release of the > freeradius > > Why? -pre3 has been out for a while. Try it > instead. > > Alan DeKok. > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html > __ Do you Yahoo!? New and Improved Yahoo! Mail - Send 10MB messages! http://promotions.yahoo.com/new_mail - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
discrapencies on pre3 + postgres setup ?
I had been using freeradius 0.9.3 for a while and now for a larger deployment I am choosing pre3 with postgres option. However, there are some discrapencies I have noticed while I wanted to build it with pgsql-voip with cisco vsa hack. The database schema provided on src/billing/cisco_xxx.sql file gets loaded fine to the postgres database. However, the tables created for accounting records are 'startvoip' and 'stopvoip'. and while I want to use this with the pgsql-voip.conf file provided under raddb I see the accounting tables as 'Start' and 'Stop'. I have tested the server many times and it crashes anytime I want to load the sql modules, even after changing the pgsql-voip.conf . Has anyone tested the vsa hack with postgres on pre3 ? would you please inform if you had seen the same problem and how you solved it ? Platform FreeBSD 4.7, freeradius 1.0 pre3 regards, apu __ Do you Yahoo!? Yahoo! Mail Address AutoComplete - You start. We finish. http://promotions.yahoo.com/new_mail - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
bug ?
Hello, I am trying to get the 1.0 pre3 version working with postgresql in freebsd4.7. I tested with mysql and worked fine, however when I use postgresql both pgsql-voip.conf and the postgresql.conf I receive segmentation fault. One thing I had noticed when I was using pgsql-voip.conf was that the accounting table 1 (start accounting recrods) shows up as radacct (should be startvoip?) and the acct table 2 is stopvoip. Gdb trace included, is this a bug? how should I make this work ? Core was generated by `radiusd'. Program terminated with signal 11, Segmentation fault. Reading symbols from /usr/lib/libcrypt.so.2...done. Reading symbols from /usr/lib/libcipher.so.2...done. Reading symbols from /usr/local/lib/libradius-1.0.0-pre3.so...done. Reading symbols from /usr/local/lib/libltdl.so.4...done. Reading symbols from /usr/lib/libc_r.so.4...done. Reading symbols from /usr/lib/libc.so.4...done. Reading symbols from /usr/local/lib/rlm_exec-1.0.0-pre3.so...done. Reading symbols from /usr/local/lib/rlm_expr-1.0.0-pre3.so...done. Reading symbols from /usr/local/lib/rlm_pap-1.0.0-pre3.so...done. Reading symbols from /usr/local/lib/rlm_chap-1.0.0-pre3.so...done. Reading symbols from /usr/local/lib/rlm_mschap-1.0.0-pre3.so...done. Reading symbols from /usr/local/lib/rlm_unix-1.0.0-pre3.so...done. Reading symbols from /usr/local/lib/libeap-1.0.0-pre3.so...done. Reading symbols from /usr/local/lib/rlm_eap-1.0.0-pre3.so...done. Reading symbols from /usr/local/lib/rlm_eap_md5-1.0.0-pre3.so...done. Reading symbols from /usr/local/lib/rlm_eap_leap-1.0.0-pre3.so...done. Reading symbols from /usr/local/lib/rlm_eap_gtc-1.0.0-pre3.so...done. Reading symbols from /usr/local/lib/rlm_eap_mschapv2-1.0.0-pre3.so...done. Reading symbols from /usr/local/lib/rlm_preprocess-1.0.0-pre3.so...done. Reading symbols from /usr/local/lib/rlm_realm-1.0.0-pre3.so...done. Reading symbols from /usr/local/lib/rlm_files-1.0.0-pre3.so...done. Reading symbols from /usr/local/lib/rlm_acct_unique-1.0.0-pre3.so...done. Reading symbols from /usr/local/lib/rlm_detail-1.0.0-pre3.so...done. Reading symbols from /usr/local/lib/rlm_radutmp-1.0.0-pre3.so...done. Reading symbols from /usr/local/lib/rlm_sql-1.0.0-pre3.so...done. Reading symbols from /usr/libexec/ld-elf.so.1...done. #0 0x280c102c in lt_dlclose (handle=0x816ef00) at ltdl.c:3274 3274 lt_user_data data = handle->loader->dlloader_data; (gdb) bt #0 0x280c102c in lt_dlclose (handle=0x816ef00) at ltdl.c:3274 #1 0x280bfd84 in unload_deplibs (handle=0x816eec0) at ltdl.c:2460 #2 0x280c05b6 in try_dlopen (phandle=0xbfbfe854, filename=0x80a3c60 "rlm_sql_postgresql.la") at ltdl.c:2800 #3 0x280c09ef in lt_dlopenext (filename=0x80a3c20 "rlm_sql_postgresql") at ltdl.c:2956 #4 0x28257721 in rlm_sql_instantiate (conf=0x80a54e0, instance=0x8178f08) at rlm_sql.c:671 #5 0x80540b7 in find_module_instance (instname=0x80a76c0 "pgsql-voip") at modules.c:358 #6 0x805525e in do_compile_modsingle (component=3, ci=0x80a8340, filename=0x805db87 "radiusd.conf", grouptype=0, modname=0xbfbfea84) at modcall.c:814 #7 0x80552c7 in compile_modsingle (component=3, ci=0x80a8340, filename=0x805db87 "radiusd.conf", modname=0xbfbfea84) at modcall.c:829 #8 0x8054518 in load_component_section (cs=0x80a82c0, comp=3, filename=0x805db87 "radiusd.conf") at modules.c:584 #9 0x805499d in setup_modules () at modules.c:874 #10 0x804c91c in main (argc=2, argv=0xbfbffbfc) at radiusd.c:965 #11 0x804bc25 in _start () (gdb) __ Do you Yahoo!? Vote for the stars of Yahoo!'s next ad campaign! http://advision.webevents.yahoo.com/yahoo/votelifeengine/ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: cisco_vsa_hack
Hello Kafui, Is that hack being sent with CVS/Standard distribution ? Does that work with the posgreSQL billing options that are provided ? -apu --- Amedzekor Kafui <[EMAIL PROTECTED]> wrote: > Yes I did write it. > > Kafui Amedzekor. > > --- Peter Nixon <[EMAIL PROTECTED]> wrote: > > > On Friday 06 August 2004 18:19, Amedzekor Kafui > > wrote: > > --snip-- > > > Anyway what I am aiming at is to write a hack > for > > > quintum gateways so that Quintums sending cisco > > type > > > accounting packets can use the schema provided > by > > > Peter Nixon in src/billing. > > > > > > Has anyone written this already? > > > Thanks. > > > > > > Kafui Amedzekor. > > > > Did anyone ever write a Quintum VSA hack? > > > > Regards > > > > -- > > > > Peter Nixon > > http://www.peternixon.net/ > > PGP Key: http://www.peternixon.net/public.asc > > > > - > > List info/subscribe/unsubscribe? See > > http://www.freeradius.org/list/users.html > > > > > > > ___ > Do you Yahoo!? > Declare Yourself - Register online to vote today! > http://vote.yahoo.com > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html > __ Do you Yahoo!? Yahoo! Mail - You care about security. So do we. http://promotions.yahoo.com/new_mail - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
[FreeRadius] rlm_postgresql cannot link driver
Hello Gang, I just installed the 1.01 on my red hat, but having problems with the pgsql-voip module. I did what the doc says, but ended up with this error rlm_sql (pgsql-voip): Could not link driver rlm_sql_postgresql: file not found rlm_sql (pgsql-voip): Make sure it (and all its dependent libraries!) are in the search path of your system's ld. radiusd.conf[9]: pgsql-voip: Module instantiation failed. can someone shed some light? -apu __ Do you Yahoo!? Meet the all-new My Yahoo! - Try it today! http://my.yahoo.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
[freeradius] postgresql index stoptelephonycombo on pgsql-voip
Hello, I am trying to run pgsql-voip(version 1.01) schema on RHAT 7.3, however I am seeing the following error : rlm_sql (pgsql-voip): Reserving sql socket id: 6 ERROR: duplicate key violates unique constraint "stoptelephonycombo" I checked the database and found the following indexes: Indexes: "stoptelephony_pkey" primary key, btree (radacctid) "stoptelephonycombo" unique, btree (h323setuptime, nasipaddress, callid, cisconasport) it seems to me the cisconasport attribute is a little fishy. Anyone else encountered this problem? should this be a bug ? -apu __ Do you Yahoo!? The all-new My Yahoo! - Get yours free! http://my.yahoo.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: PHP web page radius authentation
I never tried with with php, but there is an apache module available which you can pretty easily use with perl or perhaps mod_perl even. Here is the sample code, Apache::AuthenRadius # Configuration in httpd.conf PerlModule Apache::AuthenRadius # Authentication in .htaccess AuthName Radius AuthType Basic # authenticate via Radius PerlAuthenHandler Apache::AuthenRadius PerlSetVar Auth_Radius_host radius.foo.com PerlSetVar Auth_Radius_port 1647 PerlSetVar Auth_Radius_secret MySharedSecret PerlSetVar Auth_Radius_timeout 5 require valid-user -apu --- "Global Net, LLC" <[EMAIL PROTECTED]> wrote: > Does anyone have a working php authentation page > working with the radius > server > to authentate users to a website using the radius > server? > > I have found one example on the net, but able to get > it to work. > using Freebsd, and apache and php5> - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- Do or Do Not, there is no try. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
postgreSQL 8.1 & FR 1.0.5
I have previous versions of FR running fine with postreSQL7.4 and pgsql-voip. However, this new installation that I am doing seems to present a segmentation fault. Only thing I have changed is the database, now it's the new 8.1 version. Anyone else has experienced this issue ? ( I am running on FreeBSD 5.4 ). FR runs fine without the Pgsql-voip part of it. How to debug the core ? suggestions ? -apu -- Do or Do Not, there is no try. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: rlm_sql_mysql on FreeBSD 5.4 - Segmentation fault at startup
Thank you nico for posting this. I did have a hard time with the seg faults at FBsd5.4 but I did manage to compile statically and got that to work (after hundreds of config changes). This post will help others who are suffering. We are here to learn, not to fight an OS war. --- Nicolas Baradakis <[EMAIL PROTECTED]> wrote: > Brian A. Seklecki wrote: > > > On Thu, 8 Dec 2005, Nicolas Baradakis wrote: > > > > > Someone else managed to make MySQL work under > FreeBSD. > > > > http://lists.freeradius.org/pipermail/freeradius-users/2005-October/047693.html > > > > With that kind of cynicism flying around, someone > is likely to have their > > feeling get hurt. > > It was absolutely not my intention. I apologize to > Matthew if my > statement was poorly formulated, nevertheless the > long version of what > I really wanted to say is: "Someone else experienced > the same troubles > on FreeBSD, and you may look at the post below to > find out how he > managed to get around the problem". > > I hope other people can understand that: > - I have no obligation to give answers on the list > - I don't have much time to do that either > - I'm not a native english speaker > > So if sometimes you get ungraceful answers, it's not > out of bad > intentions. > > -- > Nicolas Baradakis > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RADIUSD reloading
is there a way to reload the radiusd without really ever stopping it ? more like a reload command ? are there other ways to push in the changes of the config files without closing the listening ports ? -apu - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Radiusd using up 99% CPU
My freeradius installation on FreeBSD5.3 is using up 99% of CPU resources. it is running with postgresql in a dual intel 800 machine with 1 gb ram. Basic functionality it provides is only accounting. Anyone has any input on this ? -Apu = --- Before God we are all equally wise - and equally foolish. -Albert Einstein __ Do you Yahoo!? Yahoo! Mail - Find what you need with new enhanced search. http://info.mail.yahoo.com/mail_250 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: aqua gatekeeper sql
you want to place the columns frequently changes on your index if you are creating 'Unique' index. The existing indexing scheme will work just fine, since you have a multiple column index. The likelihood of being all those similar is close to none. So, do not change it. -apu --- Dmitriy Milashenko <[EMAIL PROTECTED]> wrote: > Hi, freeradius-users. > > I'm using Aqua Gatekeeper to manage voip services. > It makes accounting to sql. > I've used > src/billing/cisco_h323_db_schema-postgres.sql to > create > tables. Table stopvoip have index > > create UNIQUE index stopvoipcombo on stopvoip > (h323SetupTime, nasipaddress, CallID); > > but aqua sends answer and originate accounting > records between 2 > different clients with the same h323SetupTime. So > the second row can > not be inserted into the database... > > So the question... Will it be safely to modify this > index like > > create UNIQUE index stopvoipcombo on stopvoip > (h323SetupTime, > nasipaddress, CallID, h323callorign); > -- > Thank you, > Dmitriy > mailto:[EMAIL PROTECTED] > > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html > --- Before God we are all equally wise - and equally foolish. -Albert Einstein __ Do you Yahoo!? Yahoo! Mail - Easier than ever with enhanced search. Learn more. http://info.mail.yahoo.com/mail_250 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Re[2]: aqua gatekeeper sql
the callid should not be the same even if the other ones are. The chances are very very low. You can change it (add another column to index), there is no harm but you will increase your index size and therefore increasing insert/delete/update operation time on that database. -apu --- Dmitriy Milashenko <[EMAIL PROTECTED]> wrote: > Hi, Apu. > > Apu wrote 15 ìàðòà 2005 ã., 20:15:56: > > > you want to place the columns frequently changes > on > > your index if you are creating 'Unique' index. The > > existing indexing scheme will work just fine, > since > > you have a multiple column index. The likelihood > of > > being all those similar is close to none. So, do > not > > change it. > > > -apu > > It seems like I MUST to change this index, because > unique index works > like constraint and NAS server can send stop records > for caller and > callee with the same h323setuptime, NASIpaddress, > and callid. But one > of them is answer and other is originate. If index > looks like > create UNIQUE index stopvoipcombo on > stopvoip(h323SetupTime, nasipaddress, CallID); > it is impossible to insert the second > Accounting-Stop row. And it > seem to me developers should change index by adding > h323callorign > field to index or the other way is to make this > index not unique and > add constraint for fields h323SetupTime, > nasipaddress, CallID, > h323callorign to make impossible duplicate records > in database in > case of duplicate sending Accounting packets by > NASServer (that is > the ordinar case in radius protocol) > > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html > --- Before God we are all equally wise - and equally foolish. -Albert Einstein __ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
radrelay taking too long
I have an accounting data file (1 GB) that I am pushing off to a server running freeradius 1,0 w pgsql-voip. It has been three days but the data is still not done populating the tables. I see it progressing, but the speed is horrible. Anyone knows how I can make this fast ? -apu -- Do or Do Not, there is no try. __ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
rlm_sql an old question.
Hello guyz, I am new to the forum and want to thank the developers to put such a good stuff out there. I have placed it in my freeBSD system and off it goes. However, I am dicking around with the sql module and cannot have it to populate the radius->radacct tables. The table structres has been created and I cheked the rlm_sql option and that is set for mysql. the version of freeradius is 0.93 any suggestion ? Apu Islam __ Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: rlm_sql an old question.
I looked at the CVS snapsot. Here is my radiusd.conf relavant parts : # Accounting. Log to detail file, and to the radwtmp file, and maintain # radutmp. accounting { # acct_unique detail # counter unix radutmp # sradutmp } Does this look right ? should I put sql in one line there ? I have the sql.conf file configured with the right user and pass and tables are set. Thank you for your support. Apu --- Alan DeKok <[EMAIL PROTECTED]> wrote: > Apu islam <[EMAIL PROTECTED]> wrote: > > However, I am dicking around with the sql module > and > > cannot have it to populate the radius->radacct > tables. > > List "sql" in the "accounting" section. > > Grab the latest CVS snapshot, and read > "raddb/radiusd.conf.in" > (without building it). Look for references to > "sql", and do similar > things to your "radiusd.conf". > > Alan DeKok. > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
[freeRADIUS] filtering attribute values, any clues ?
hello guys, I need to filter some values once I make the INSERT statement on sql.conf . Here is what I see on the log file Quintum-h323-disconnect-time = "h323-disconnect time=18:47:03.610 UTC Sat Mar 13 2004" where I need to extract the value of time and insert it into the appropriate column after filtering it. There are other attributes that needs special processing as well. is it possible to use some perl code to change the strings ? are there other ways this can be achieved ? (not just time, attribute values in general.) Any help appreciated. Apu __ Do you Yahoo!? Yahoo! Mail - More reliable, more storage, less spam http://mail.yahoo.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: hey
lighten up guys. I think Alan does a great job supporting. We just need a few more people like him. I do think it's a little funny though... --- Steve OBrien <[EMAIL PROTECTED]> wrote: - If you are complaining about the support on free software then youare a bigger idiot than your post made you look. Grow up. [EMAIL PROTECTED] wrote: - To: <[EMAIL PROTECTED]> From: "Brian Schuetz" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] Date: 03/19/2004 12:06PM Subject: hey Alan, Is your last name Dekok for a reason? -List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ Do you Yahoo!? Yahoo! Mail - More reliable, more storage, less spam http://mail.yahoo.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
quintum VSA
I have seen that the latest CVS snapshot accepts cisco VSA hacks to aid in voIP billing. Is there any plan to embed quintum as well ? regards, Apu __ Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger. http://messenger.yahoo.com/ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Auth-Type issue
Hello good FreeRadius People, I have the radius server running fine, however I am having issues with user being authenticated. To note, I am using dialup-admin to create the user. Here is the error output: --- rad_recv: Access-Request packet from host x.x.x.x:63762, id=252, length=156 NAS-Identifier = "border01" NAS-Port = 0 NAS-Port-Type = Virtual Service-Type = Framed-User Framed-Protocol = PPP User-Name = "apu" MS-CHAP-Challenge = 0xbb1e683234213423423423 MS-CHAP2-Response = 0x82174309827423842879a5c39e672 Processing the authorize section of radiusd.conf modcall: entering group authorize for request 1 modcall[authorize]: module "preprocess" returns ok for request 1 modcall: leaving group authorize (returns ok) for request 1 auth: No authenticate method (Auth-Type) configuration found for the request: Rejecting the user can you tell me how to get around that ? I have dug in but did not see any way I could set the flag when I create the user in dialup-admin. Any help is appreciated. Apu ---------- Apu Islam ( E Pluribus Unum) - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
MS-CHAPv2 error, clues ?
Here is the error message I am getting when I am trying to authenticate, Processing the authenticate section of radiusd.conf modcall: entering group MS-CHAP for request 1 rlm_mschap: Told to do MS-CHAPv2 for apu with NT-Password rlm_mschap: FAILED: MS-CHAP2-Response is incorrect modcall[authenticate]: module "mschap" returns reject for request 1 Any clues would be appreciated. Apu ------ Apu Islam ( E Pluribus Unum) - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
rewriting Frame-IP-Netmask
I am having problems rewriting the IP Netmask attribure. I am using mysql for my user authorization. the IP address seems to get set right, but the Netmask does not. I have specified it specifically and even changed the default, but could not get this to work. Its a PPP framed connection. What should I look at ? Thank you for suggestions. Apu -- Apu Islam ( E Pluribus Unum) - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Choice database
sql.conf on /usr/local/etc/raddb while you are at it, look at the other .conf file too. --- Marilene Lima <[EMAIL PROTECTED]> wrote: > Hi, > > I am setting up my first radius server, and I have > two databases. Someone > could tell me if there is a file in freeradius where > I can choice what > database I will to use? > > Thanks a lot, > Marilene > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- Apu Islam ( E Pluribus Unum) Want to start your own business? Learn how on Yahoo! Small Business. http://smallbusiness.yahoo.com/r-index - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
cisco and incoming dial in setup bounty $100
I am willing to pay someone $100 for a cisco dial-in and a FreeRadius setup. It will be a first come first serve kind of a thing and on a good faith basis. The setup is as follows: 1. A cisco AS 5200 with 48 modem pool 2. A CAC FXO channel bank for a/d conversion 3. A freeBSD/Linux server with FR1.05 and dialupadmin installed. I am in U.S. and will pay someone preferrably via Paypal. International parties are also welcome. regards Apu -- Apu Islam ( E Pluribus Unum) - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html