HOW TO save in the database Cisco AVPairs?

2004-08-17 Thread Costin Manda
Hello... I need to save in the database a Cisco AVPair. I see in the log file something like: Cisco-AVPair = "gw-final-xlated-cdn=ton:0,npi:1,#:100340098214329147" gw-final-xlated-cdn = "ton:0,npi:1,#:100340098214329147" How should I modify the sql query in order to save me the in

Unresponsive child? I don't have children!

2004-06-18 Thread Costin Manda
After solving a lot of the errors I got from freeradius I have only one left: "Eror: WARNING: Unresponsive child (id 4534545) for request 54654" I am using freeradius with pgsql and billing. Can someone help me explain this error and maybe help me solve it? Thanks. Costin - List info/subscrib

authorising?

2004-04-30 Thread Costin Manda
Hello! I am trying to authorise some users with freeradius and pgSQL. Anyone know what I must put into radcheck and radreply tables? Or any other tables, for that matter? It is an easy enough thing: I want to authorise username="callerid" and get a response attribute with the account number. How

Re: how to do accounting with mysql?

2004-04-23 Thread Costin Manda
Because of this I have both Mysql and postgreSQL installed on my computer. In a way it is safer, if one fails, you have the other.    The thing with the mysql-postgress issue is that mysql doesn't have stored procedure support yet and the Cisco timestamp is not supported by Mysql. However, i

Re: how to do accounting with mysql?

2004-04-23 Thread Costin Manda
doesn't work. you must use postgresql. look in the src/billing directory and all will be revealed! - Original Message - From: Rogelio Alvarado Anchisi To: [EMAIL PROTECTED] Sent: Friday, April 23, 2004 03:50 PM Subject: how to do accounting with mysql?

Re: sqltrace, mysql authentication

2004-04-09 Thread Costin Manda
When running in debug mode there is no sql trace file. - Original Message - From: "mel" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, April 09, 2004 01:11 PM Subject: sqltrace, mysql authentication > Hi, > > I've managed to set up freeradius to authenticate > users using th

Re: suggestion!!

2004-04-01 Thread Costin Manda
- Original Message - From: "Guy Fraser" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 31, 2004 6:56 PM Subject: Re: suggestion!! > Costin Manda wrote: > > > >My suggestion is to add a configuration setting that does not allow ra

Re: Could not link driver "rlm_sql_mysql" problem.

2004-04-01 Thread Costin Manda
you can check dependencies with the Linux command ldd. What version of Freeradius are you using and have you compiled freeradius yourself? - Original Message - From: "Shannon Sariman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 01, 2004 10:29 AM Subject: Could not l

suggestion!!

2004-03-31 Thread Costin Manda
For some weird reason, freeradius is starting very slowly, the reason being that it connects to the postgreSQL server very slowly. I rebooted the computer and then I looked in the radius log. To my surprise, radius got an error "Database system starting up" or something like that, and then proceede

Re: h323-incoming-conf-id

2004-03-31 Thread Costin Manda
x27;h323-incoming-conf-id' > which is coming as Cisco-AVpair. In fact there are > some other variables also which come as Cisco-AVpair. > > For Example:Cisco-AVPair = "subscriber=RegularLine" > > If I want to log this information, how do I do this ? > > ---

Re: h323-incoming-conf-id

2004-03-30 Thread Costin Manda
The actual problem is that I don't understand what you want exactly. From what I gather, you want to log in the database the stripped value "C4E45877 818F11D8 86419EDB 53428773" and not "h323-conf-id=C4E45877 818F11D8 86419EDB 53428773". Is that correct? In my postygreSQL + freeRadius setup I alaw

Re: h323-incoming-conf-id

2004-03-30 Thread Costin Manda
- Original Message - From: "Kiran" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, March 30, 2004 4:42 PM Subject: h323-incoming-conf-id > Hi, > Out of a Cisco box, I get the following accounting > packet. > VSA_HACK is enabled so I get "0063D7C2 815F11D8 > 85C29EDB 53428773"

Re: Thnkx

2004-03-28 Thread Costin Manda
As far as I know, MySQL for Windows is nothing more than the Linux MySQL source compiled on Windows with the necessary adjustments. Connecting with the MySQL client from Linux should not be a problem. Do  mysql --help | more to see the usage of the client. Eventually, try doing a   man mysq

Re: Help me out, waiting 4 response

2004-03-26 Thread Costin Manda
Did you build freeradius yourself? did you use the complete source? - Original Message - From: "arshad shah" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, March 26, 2004 2:29 PM Subject: Help me out, waiting 4 response > Hi Dear, > is there any one other who like to help me,

Re: Proxy bug or did I do something wrong?

2004-03-25 Thread Costin Manda
- Original Message - From: "Alan DeKok" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, March 25, 2004 5:33 PM Subject: Re: Proxy bug or did I do something wrong? > Why are you logging requests locally *and* proxying them? Or are > you trying to proxy some, and log others

Proxy bug or did I do something wrong?

2004-03-25 Thread Costin Manda
Yes, it's me again. :p I have found out that when using freeradius as a radius proxy, the requests get transformed while going through Freeradius. The most notable change is that cisco_vsa_hack applies to proxied requests. As some radius software do not understand hacked requests, the proxy fails

null port name?

2004-03-23 Thread Costin Manda
I am using freeradius as a proxy for another radius. Everything works perfectly when trying to authenticate a prepaid calling card, but when the user dials, the primary radius rejects all the calls on the ground of "null portname error". As far as I see, freeRadius sends forth what was sent to it.

null port name?

2004-03-22 Thread Costin Manda
i am trying to use freeradius as a proxy between a Cisco gateway and a billing software. Everything worked fine, but then I couldn't dial anything. The billing software returns the error "Null portname error". Any insight? Thanks! - List info/subscribe/unsubscribe? See http://www.freeradius

simple question:

2004-03-12 Thread Costin Manda
Ok, i have freeradius and postgreSQL to authorise and authenticate users for VoIP usage with a Cisco gateway. I have only one question: where do I put the account codes that let the people use the system and where do I put the money they have?! - List info/subscribe/unsubscribe? See http://www.f

So, what do I do now?

2004-03-12 Thread Costin Manda
Ok, I give up! I have no idea what I am doing. I need some yahoo/MSN messenger help because right now I am lost completely. My yahoo ID is interpointman2 and my MSN id is [EMAIL PROTECTED] I am trying to use freeradius for the following things: 0) make freeradius authorise the use of VoIP for t

Re: Freeradius for Voip

2004-03-12 Thread Costin Manda
- Original Message - From: "ROY" <[EMAIL PROTECTED]> To: "freeradius-users" <[EMAIL PROTECTED]> Sent: Friday, March 12, 2004 4:52 AM Subject: Re: Freeradius for Voip > I think I've ran into this too.. > The problem was with text timezone not being recognized by Postgres. > > Here's what

Re: Freeradius for Voip

2004-03-12 Thread Costin Manda
On Fri, 12 Mar 2004 10:52:56 +0800 ROY <[EMAIL PROTECTED]> wrote: > I think I've ran into this too.. > The problem was with text timezone not being recognized by Postgres. > > Here's what I've done: Thank you. I will try it and get back to you if it doesn&#x

Freeradius for Voip

2004-03-11 Thread Costin Manda
I am trying to use freeradius with a Cisco VoIP gateway to auth and acc prepaid cards. This is what I did: Installed the following: - Perl 5.8.3 - PostgreSQL 7.4.2 (with perl) - Freeradius 0.9.3 I followed the instructions from postgres/src/billing concerning using freeradius with prepaid cards.

freeradius pqsql segmentation fault?!

2004-03-11 Thread Costin Manda
I am trying to use Freeradius 0.9.3 with PostgreSQL 7.4.2 and Perl 5.8.3 so do prepaid billing for Cisco. I configured everything that was in the README file in the src/billing directory and when starting radius, a 'segmentation fault' message appears whenever a request is sent to it, crashing the