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