Re: MySQL accounting issue

2008-01-21 Thread Alan DeKok
Andy Smith wrote: I have attempted to configure freeradius to write accounting data to MySQL, however currently its not working. No data is being written to MySQL and the Radius client is complaining its not recieving a reply for accounting requests. I subsituted the detail setting in the

Re: MySQL accounting issue

2008-01-21 Thread A.smith
Hi, ok this is an example of when its meant to do some accounting, in this example I have both detail and sql set for accounting in radiusd.conf. Nothing to do. Sleeping until we see a request. rad_recv: Accounting-Request packet from host 89.107.16.10:35377, id=82, length=145

Re: MySQL accounting issue

2008-01-21 Thread A.smith
Ah, ok, now I see the other post regarding this. The problem is OpenSER and this status type: rlm_sql (sql): Unsupported Acct-Status-Type = 15 Whats the latest on this? Has the incompatibility been addressed in freeradius 2.0? thanks Andy.

Re: MySQL accounting issue

2008-01-21 Thread tnt
Again, send a debug with the Start and Stop packets. Ivan Kalik Kalik Informatika ISP Dana 21/1/2008, A.smith [EMAIL PROTECTED] piše: Also, regarding radius 1.x I now have a patch which allows this type of record. However next issue is that with accounting set to sql in radiusd.conf the SQL

Re: MySQL accounting issue

2008-01-21 Thread Andy Smith
put in the database... What have I done wrong? thank u! - Original Message - From: Andy Smith [EMAIL PROTECTED] To: FreeRadius users mailing list freeradius-users@lists.freeradius.org Sent: Monday, January 21, 2008 4:40 PM Subject: Re: MySQL accounting issue Ok, Im seeing this from

Re: MySQL accounting issue

2008-01-21 Thread tnt
Dana 21/1/2008, A.smith [EMAIL PROTECTED] piše: Also, regarding radius 1.x I now have a patch which allows this type of record. However next issue is that with accounting set to sql in radiusd.conf the SQL statements are being written just to /usr/local/var/log/radius/sqltrace.sql and nothing is

MySQL accounting issue

2008-01-20 Thread Andy Smith
Hi List, ok next issue I have :P I have attempted to configure freeradius to write accounting data to MySQL, however currently its not working. No data is being written to MySQL and the Radius client is complaining its not recieving a reply for accounting requests. I subsituted the detail

Radius accounting issue

2004-10-18 Thread Russell Premont
I cannot get Radius accounting to work. I am running Freeradius 0.9.3 on Solaris 9. Authentication works fine. When I start radius in debug mode I see processing the config file with no errors and listening on the proper ports that I have set in the /etc/services file. /etc/services excerpt

Re: Radius accounting issue

2004-10-18 Thread Alan DeKok
Russell Premont [EMAIL PROTECTED] wrote: Then I see the following: rad_recv: Accounting-Request packet from host 192.168.1.14:1027, id=176, length=210 Ignoring request from unknown home server 192.168.1.14:1027 Why do you have the client sending packets to port 1027? The debug log of

Re: Accounting issue

2004-09-01 Thread Erik Immers
On Tue, Aug 31, 2004 at 12:44:21PM -0400, Alan DeKok wrote: Erik Immers [EMAIL PROTECTED] wrote: detailfile = ${radacctdir}//detail-${Huntgroup-Name} I tried to do this but it just ignores it. I tried using an % instead of an $, but then the server wont even start. Try using

Re: Accounting issue

2004-08-31 Thread Erik Immers
On Mon, Aug 30, 2004 at 10:36:56AM -0400, Alan DeKok wrote: Erik Immers [EMAIL PROTECTED] wrote: Is there within freeradius (0.8.1) the possibility to log to 2 detail files depending on the NAS. You should upgrade to 1.0.0. And the detail file is configurable. See the comments in

RE: Accounting issue

2004-08-31 Thread Bastien
d'origine- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de Erik Immers Envoyé : mardi 31 août 2004 10:34 À : [EMAIL PROTECTED] Objet : Re: Accounting issue On Mon, Aug 30, 2004 at 10:36:56AM -0400, Alan DeKok wrote: Erik Immers [EMAIL PROTECTED] wrote: Is there within freeradius

Re: Accounting issue

2004-08-31 Thread Dominique Demore
I will be away on holidays until September 2. Should you require immediate assistance, please contact Rod MacLeod or George Gauthier. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Accounting issue

2004-08-31 Thread Erik Immers
of an $, but then the server wont even start. greets, Erik -Message d'origine- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de Erik Immers Envoyé : mardi 31 août 2004 10:34 À : [EMAIL PROTECTED] Objet : Re: Accounting issue On Mon, Aug 30, 2004 at 10:36:56AM

Re: Accounting issue

2004-08-31 Thread Alan DeKok
Erik Immers [EMAIL PROTECTED] wrote: detailfile = ${radacctdir}//detail-${Huntgroup-Name} I tried to do this but it just ignores it. I tried using an % instead of an $, but then the server wont even start. Try using 1.0.0, rather than 0.8.1. I don't even recall if that was configurable

accounting issue with postgres + Cisco (1.0.0 pre1)

2004-06-08 Thread Graeme Hinchliffe
Hiya have been getting a few odd errors since we started directing Cisco accounting traffic to freeradius and using postgres. I am seeing error message: Tue Jun 8 16:51:46 2004 : Error: rlm_sql (sql): failed after re-connect Tue Jun 8 16:51:46 2004 : Error: rlm_sql (sql): Couldn't