Re: Accounting error

2009-03-18 Thread ahmed adel
freeradius-users@lists.freeradius.org Sent: Tuesday, March 17, 2009 6:18:19 PM Subject: Re: Accounting error I hope anyone can help me with these errors I have in the radius.log file: Error: rlm_sql_getvpdata: database query error Error: rlm_sql (sql): SQL query error; rejecting user Error

Re: Accounting error

2009-03-18 Thread tnt
radius_xlat: 'EXEC acct_update '2009-03-18 22:45:44', '17096', '253790', '426579', '', '', 'Acct-Update', '0', '153354240', '0002380B', '...@', 'xxx.xxx.xxx.xxx', '2aa4d04abb7544a1', 'DEFAULT', '0', 'Virtual', 'RADIUS', '', '', 'Framed-User', 'PPP', 'xxx.xxx.xxx.xxx';' rlm_sql (sql):

Re: Accounting error

2009-03-18 Thread ahmed adel
: Wednesday, March 18, 2009 11:38:15 PM Subject: Re: Accounting error radius_xlat: 'EXEC acct_update '2009-03-18 22:45:44', '17096', '253790', '426579', '', '', 'Acct-Update', '0', '153354240', '0002380B', '...@', 'xxx.xxx.xxx.xxx', '2aa4d04abb7544a1', 'DEFAULT', '0', 'Virtual', 'RADIUS

Re: Accounting error

2009-03-18 Thread tnt
The procedures work most of the time plus on the failing cases when I run the procedure by my self it works, anyway what about the other error: radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'xx' ORDER BY id' rlm_sql (sql): Reserving sql socket id: 6

Re: Accounting error

2009-03-18 Thread ahmed adel
, 2009 12:05:15 AM Subject: Re: Accounting error The procedures work most of the time plus on the failing cases when I run the procedure by my self it works, anyway what about the other error: radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'xx' ORDER

Accounting error

2009-03-17 Thread ahmed adel
Dear All I hope anyone can help me with these errors I have in the radius.log file: Error: rlm_sql_getvpdata: database query error Error: rlm_sql (sql): SQL query error; rejecting user Error: rlm_sql (sql): Couldn't update SQL accounting ALIVE record - 0 I am using freeradius

Re: Accounting error

2009-03-17 Thread tnt
I hope anyone can help me with these errors I have in the radius.log file: Error: rlm_sql_getvpdata: database query error Error: rlm_sql (sql): SQL query error; rejecting user Error: rlm_sql (sql): Couldn't update SQL accounting ALIVE record - 0 I am using freeradius 1.1.7 with

Re: Accounting error

2006-07-28 Thread Alan DeKok
Elie Hani [EMAIL PROTECTED] wrote: I have this error in the log file: rlm_sql: packet has no account status type. [user '', nas x.x.x.x] ... Any idea? The NAS is broken, and sending accounting packets that don't follow the RFC's. I note also that you were careful to NOT show the

Sql accounting error

2004-07-29 Thread Costas Christonis
Hi to all, we use freeradius 0.9 running on a linux box. After a system crash (the one with the mysql database) we have problem with the accounting. When we start the raedius it connects on the database but we have no record and in the log file we have always these errors: Error: rlm_sql

Re: Sql accounting error

2004-07-29 Thread Costas Christonis
CC Hi to all, CC we use freeradius 0.9 running on a linux box. CC After a system crash (the one with the mysql database) we have problem CC with the accounting. When we start the raedius it connects on the CC database but we have no record and in the log file we have always CC these errors: CC

Re: Sql accounting error

2004-07-29 Thread Costas Christonis
this is the output of the debug mode... rlm_sql_mysql: MYSQL check_error: 1062 received rlm_sql: Couldn't insert SQL accounting STOP record - Duplicate entry '2336002' for key 1 rlm_sql (sql): Released sql socket id: 3 modcall[accounting]: module sql returns fail modcall: group accounting

Re: Sql accounting error

2004-07-29 Thread Kostas Kalevras
On Thu, 29 Jul 2004, Costas Christonis wrote: Hi to all, we use freeradius 0.9 running on a linux box. After a system crash (the one with the mysql database) we have problem with the accounting. When we start the raedius it connects on the database but we have no record and in the log file