Error syntax in sql accounting.

2013-02-04 Thread Hocine M
Hi everybody, I always have an error in radius.log file : Mon Feb 4 16:16:52 2013 : Error: [sql_acct] Couldn't insert SQL accounting START record - Erreur de syntaxe pr?s de '' ? la ligne 1 Mon Feb 4 16:17:01 2013 : Error: [sql_acct] Couldn't insert SQL accounting START record - Erreur de

Re: Error syntax in sql accounting.

2013-02-04 Thread Alan DeKok
Hocine M wrote: Hi everybody, I always have an error in radius.log file : Mon Feb 4 16:16:52 2013 : Error: [sql_acct] Couldn't insert SQL accounting START record - Erreur de syntaxe pr�s de '' � la ligne 1 Don't edit the configuration files and break them. You do understand what

HP-Command-String in sql accounting

2012-03-12 Thread Marc Boisis-Delavaud
Hello, I've enabled command accounting of my HP procure switches. The information is sent to radius : rad_recv: Accounting-Request packet from host 10.10.0.138 port 1274, id=79, length=128 Acct-Session-Id = 00280016 Acct-Status-Type = Interim-Update Service-Type =

RE: HP-Command-String in sql accounting

2012-03-12 Thread Edvin Seferovic | Kolpinghaus Sankt Pölten
Of Marc Boisis-Delavaud Sent: Montag, 12. März 2012 15:56 To: FreeRadius users mailing list Subject: HP-Command-String in sql accounting Hello, I've enabled command accounting of my HP procure switches. The information is sent to radius : rad_recv: Accounting-Request packet from host

Re: HP-Command-String in sql accounting

2012-03-12 Thread Arran Cudbard-Bell
On 12 Mar 2012, at 15:55, Marc Boisis-Delavaud wrote: Hello, I've enabled command accounting of my HP procure switches. The information is sent to radius : rad_recv: Accounting-Request packet from host 10.10.0.138 port 1274, id=79, length=128 Acct-Session-Id = 00280016

Re: Multiple sql accounting queries

2012-03-11 Thread Fajar A. Nugraha
On Sun, Mar 11, 2012 at 11:05 AM, Joe Holden li...@rewt.org.uk wrote: Hi guys, I'm looking into the best way to implement multiple sql queries for accounting... what is the proper way of doing this (besides evil sql magic), stored procedure works fine. can I define another sql instance?

Re: Multiple sql accounting queries

2012-03-11 Thread Joe Holden
Fajar A. Nugraha wrote: On Sun, Mar 11, 2012 at 11:05 AM, Joe Holden li...@rewt.org.uk wrote: Hi guys, I'm looking into the best way to implement multiple sql queries for accounting... what is the proper way of doing this (besides evil sql magic), stored procedure works fine. can I define

Multiple sql accounting queries

2012-03-10 Thread Joe Holden
Hi guys, I'm looking into the best way to implement multiple sql queries for accounting... what is the proper way of doing this (besides evil sql magic), can I define another sql instance? How do I go about mapping queries to that etc? Thanks, Joe - List info/subscribe/unsubscribe? See

Re: SQL accounting

2010-04-21 Thread Alexander
--- On Tue, 4/20/10, Alan DeKok al...@deployingradius.com wrote:   Make the NAS send accounting packets. Actually my NAS is sending accounting packets.   FreeRADIUS can't log information it doesn't have. After digging into it turned out that something in my SQL schema was missing.

Re: SQL accounting

2010-04-21 Thread John Raja
hi, I want to deploy radius for proxy Server authentication. Please suggest how can i do that... Regards, John Raja Network Engineer IP Extn : 500092

SQL accounting

2010-04-20 Thread Alexander
Dear all, accounting data gets sent to MySQL in my setup. Unfortunatly active sessions do not show up in radacct. Although terminated sessions show up in the table correctly. Eg. neither AcctStartTime information nor perodic accounting updates get displayed in radacct table until the session

Re: SQL accounting

2010-04-20 Thread Alan DeKok
Alexander wrote: Dear all, accounting data gets sent to MySQL in my setup. Unfortunatly active sessions do not show up in radacct. Although terminated sessions show up in the table correctly. Eg. neither AcctStartTime information nor perodic accounting updates get displayed in radacct

Re: Stripping Realms from SQL Accounting Queries

2009-11-24 Thread tnt
Perhaps do what is suggested wherever you care to look (this list, documentation, website, ...) - run server in debug mode (radiusd -X). Then you will see exactly what is happening. I did that, and it didn't help. I added a realm definition back in to the config file, and here's the debug

Stripping Realms from SQL Accounting Queries

2009-11-23 Thread Tim Gustafson
Hi, I'm using FreeRADIUS with LDAP for authentication and mySQL for logging. The LDAP queries seem to be stripping the realm name properly, whereas the mySQL queries are not. I'm running FreeRADIUS 2.1.6 on FreeBSD: FreeRADIUS Version 2.1.6, for host i386-portbld-freebsd7.2, built on Nov 10

Re: Stripping Realms from SQL Accounting Queries

2009-11-23 Thread tnt
Hi, I'm using FreeRADIUS with LDAP for authentication and mySQL for logging. The LDAP queries seem to be stripping the realm name properly, whereas the mySQL queries are not. I'm running FreeRADIUS 2.1.6 on FreeBSD: FreeRADIUS Version 2.1.6, for host i386-portbld-freebsd7.2, built on Nov

Re: Stripping Realms from SQL Accounting Queries

2009-11-23 Thread Alexander Clouter
Tim Gustafson t...@soe.ucsc.edu wrote: I'm using FreeRADIUS with LDAP for authentication and mySQL for logging. The LDAP queries seem to be stripping the realm name properly, whereas the mySQL queries are not. I'm running FreeRADIUS 2.1.6 on FreeBSD: FreeRADIUS Version 2.1.6, for

Re: Stripping Realms from SQL Accounting Queries

2009-11-23 Thread Tim Gustafson
...erm, '%{%{Stripped-User-Name}:-%{User-Name}}', I think what you have there is some really old depreated or bad syntax'ed version. Same in your SQL queries too strangely. You will want to make sure you use 'SQL-User-Name' instead too, and not directly 'User-Name' (think SQL injection).

Re: Stripping Realms from SQL Accounting Queries

2009-11-23 Thread Tim Gustafson
Perhaps do what is suggested wherever you care to look (this list, documentation, website, ...) - run server in debug mode (radiusd -X). Then you will see exactly what is happening. I did that, and it didn't help. I added a realm definition back in to the config file, and here's the debug

SQL-Accounting

2009-02-26 Thread Tim Stone
Hello, is it possible to call only a simple Stored Procedure (SP) on the MySQL-Server to do the Accounting Job, like the sql-log module (rlm_sql_log(5)), but do not log in file, instead of this, call the SP: I can't find more Information for such configuration. Thanx for help, Tim - List

Re: SQL-Accounting

2009-02-26 Thread tnt
is it possible to call only a simple Stored Procedure (SP) on the MySQL-Server to do the Accounting Job, like the sql-log module (rlm_sql_log(5)), but do not log in file, instead of this, call the SP: I can't find more Information for such configuration. unlang supports only SELECT statements.

Re: SQL-Accounting

2009-02-26 Thread Tim Stone
unlang supports only SELECT statements. Call your procedure from a perl script. 1) can I access to all accounting releated information from the perl module like in the sql-module? Are any examples out there? # Start = INSERT INTO ${acct_table} (AcctSessionId, UserName, \ #

Re: SQL-Accounting

2009-02-26 Thread tnt
1) can I access to all accounting releated information from the perl module like in the sql-module? You said that you want to call a stored procedure. Yes, your database does have access to all the information stored in it. Are any examples out there? $query = CALL your_procedure; If you need

Re: SQL-Accounting

2009-02-26 Thread Tim Stone
2009/2/27 t...@kalik.net: 1) can I access to all accounting releated information from the perl module like in the sql-module? You said that you want to call a stored procedure. Yes, your database does have access to all the information stored in it. Are any examples out there? $query = CALL

Re: SQL-Accounting

2009-02-26 Thread Tim Stone
Thanks for help !!! - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

SQL Accounting but only for specific groups

2008-09-14 Thread Marinko Tarlac
Hi there I want to use sql accounting but only for specific user groups... Is there any chance to do this (maybe Unlang can help?) - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: sql accounting - no records - 2.0.1 RESOLVED

2008-01-30 Thread Andrew Long
I expected to see some traffic too soon, now it's coming... but where are the accounting queries? Andrew On Jan 30, 2008 8:52 AM, Andrew Long [EMAIL PROTECTED] wrote: I've just installed 2.0.1 on CentOS 5 with MySQL 5.x. I can get the clients to authenticate and I see accounting requests come

Re: sql accounting - no records - 2.0.1 RESOLVED

2008-01-30 Thread JB
Hi Andrew, in mysql.conf, there should be another file included: $INCLUDE sql/${database}/dialup.conf So, in your case that would be $INCLUDE sql/mysql/dialup.conf There you should find several accounting queries. JB Andrew Long (30.01.2008 15:49): I expected to see some traffic too soon,

sql accounting - no records - 2.0.1

2008-01-30 Thread Andrew Long
I've just installed 2.0.1 on CentOS 5 with MySQL 5.x. I can get the clients to authenticate and I see accounting requests come in, also I see the accounting query as it should be updated to mysql, i.e., expand: UPDATE radacct I also see the accounting response returned to the client, but no

Re: FR-2.0.0-pre2 - doubled sql accounting

2007-10-25 Thread Alan DeKok
Tomasz Zieleniewski wrote: I have the home_server configuration which points to my localhost. Why? So the scenario is the following that when I receive the Accounting-Request with the user name of the form [EMAIL PROTECTED] I check the realm for particular domain and strip the user name

Re: SQL Accounting problem with 1.0.3 - The maximum number of threads (32) are active

2007-04-19 Thread Rick Macdougall
On 4/19/07, Alan DeKok [EMAIL PROTECTED] wrote: Rick Macdougall wrote: Recompiled with --without-threads and it locks up hard on the first accounting request. And when I say locks up hard, I mean not even a kill -9 will stop it, I have to reboot the server. Are you sure your OS isn't

Re: SQL Accounting problem with 1.0.3 - The maximum number of threads (32) are active

2007-04-19 Thread Rick Macdougall
Ok, I've taken out the SQL accounting completely, left in the SQL authentication and the problem still persists. On accounting packets with threads disabled, the accounting process stops completely after one packet, on accounting packets with threads enabled, the accounts process reports

Re: SQL Accounting problem with 1.0.3 - The maximum number of threads (32) are active

2007-04-19 Thread Rick Macdougall
Well, I went through everything in the accounting { } and the problems turns out to be radutmp Any reason this might be a problem. The file gets created but never written to. If I comment it out of the accounting { }, then everything, including mysql records being written, works just fine.

Re: SQL Accounting problem with 1.0.3 - The maximum number of threads (32) are active

2007-04-19 Thread Peter Nixon
On Thu 19 Apr 2007, Rick Macdougall wrote: Well, I went through everything in the accounting { } and the problems turns out to be radutmp Any reason this might be a problem. The file gets created but never written to. If I comment it out of the accounting { }, then everything, including

Re: SQL Accounting problem with 1.0.3 - The maximum number of threads (32) are active

2007-04-19 Thread Alan DeKok
Rick Macdougall wrote: Well, I went through everything in the accounting { } and the problems turns out to be radutmp Any reason this might be a problem. The file gets created but never written to. If I comment it out of the accounting { }, then everything, including mysql records being

Re: SQL Accounting problem with 1.0.3 - The maximum number of threads (32) are active

2007-04-19 Thread Rick Macdougall
You are right on with the NFS locking issue. I believe that is exactly the problem, my only concern now is why it happens with CentOS 4.x and not with Fedora Core 3. More info in the morning as I'm currently having a beer (or 4) and watching the Hockey playoffs. Thanks for the help. Regards,

Re: SQL Accounting problem with 1.0.3 - The maximum number of threads (32) are active

2007-04-18 Thread Rick Macdougall
On 4/17/07, Alan DeKok [EMAIL PROTECTED] wrote: Rick Macdougall wrote: Hi, We seem to be having the The maximum number of threads (32) are active with Freeradius 1.0.3. Version 1.0.1 works just fine. Upgrade to 1.1.6. It has a whole host of fixes. Hi, Upgraded to 1.1.6 and the

Re: SQL Accounting problem with 1.0.3 - The maximum number of threads (32) are active

2007-04-18 Thread Peter Nixon
On Wed 18 Apr 2007, Rick Macdougall wrote: On 4/17/07, Alan DeKok [EMAIL PROTECTED] wrote: Rick Macdougall wrote: Hi, We seem to be having the The maximum number of threads (32) are active with Freeradius 1.0.3. Version 1.0.1 works just fine. Upgrade to 1.1.6. It has a whole

Re: SQL Accounting problem with 1.0.3 - The maximum number of threads (32) are active

2007-04-18 Thread Rick Macdougall
Follow up. It is updating/inserting records into the mysql radacct database but it seems that an ACK is not sent back to the remote server and the thread is not released. A minute later the remote server tries again, etc etc until the threds max out at 32. Regards, Rick - List

Re: SQL Accounting problem with 1.0.3 - The maximum number of threads (32) are active

2007-04-18 Thread Rick Macdougall
Yep. Your backend is too slow to keep up. Accounting is inserts and updates... Auth is selects.. BIG difference in speed... Not a speed issue, the mysql records are inserted within milliseconds of the detail file being written. Running radiusd -x shows the sql accounting happening almost

Re: SQL Accounting problem with 1.0.3 - The maximum number of threads (32) are active

2007-04-18 Thread Alan DeKok
Rick Macdougall wrote: It is updating/inserting records into the mysql radacct database but it seems that an ACK is not sent back to the remote server and the thread is not released. A minute later the remote server tries again, etc etc until the threds max out at 32. That says that the

Re: SQL Accounting problem with 1.0.3 - The maximum number of threads (32) are active

2007-04-18 Thread Alan DeKok
Rick Macdougall wrote: Recompiled with --without-threads and it locks up hard on the first accounting request. And when I say locks up hard, I mean not even a kill -9 will stop it, I have to reboot the server. Are you sure your OS isn't buggy? It's a bad problem if kill -9 doesn't work.

SQL Accounting problem with 1.0.3 - The maximum number of threads (32) are active

2007-04-17 Thread Rick Macdougall
Hi, We seem to be having the The maximum number of threads (32) are active with Freeradius 1.0.3. Version 1.0.1 works just fine. I tried to do a valgrind with - but when radiusd displays that message, you can no longer kill it. I have the debug output from the - and it shows the

Re: SQL Accounting problem with 1.0.3 - The maximum number of threads (32) are active

2007-04-17 Thread Rick Macdougall
On 4/17/07, Alan DeKok [EMAIL PROTECTED] wrote: Rick Macdougall wrote: Hi, We seem to be having the The maximum number of threads (32) are active with Freeradius 1.0.3. Version 1.0.1 works just fine. Upgrade to 1.1.6. It has a whole host of fixes. Yah, I've already downloaded it in

Re: SQL Accounting problem with 1.0.3 - The maximum number of threads (32) are active

2007-04-17 Thread Alan DeKok
Rick Macdougall wrote: Hi, We seem to be having the The maximum number of threads (32) are active with Freeradius 1.0.3. Version 1.0.1 works just fine. Upgrade to 1.1.6. It has a whole host of fixes. Alan DeKok. -- http://deployingradius.com - The web site of the book

Re: SQL Accounting problem with 1.0.3 - The maximum number of threads (32) are active

2007-04-17 Thread Peter Nixon
On Tue 17 Apr 2007, Rick Macdougall wrote: On 4/17/07, Alan DeKok [EMAIL PROTECTED] wrote: Rick Macdougall wrote: Hi, We seem to be having the The maximum number of threads (32) are active with Freeradius 1.0.3. Version 1.0.1 works just fine. Upgrade to 1.1.6. It has a whole

Re: radutmp and/or SQL Accounting

2006-10-22 Thread Peter Nixon
On Sat 21 Oct 2006 13:25, Matt Harlum wrote: Actually, is anyone able to confirm if the accounting is actually dependant on my hardware? because i'm thinking the RADIUS on my Access Point doesn't support the accounting functions. Yes. Your access point has to SEND you the accounting.. Cheers

Re: radutmp and/or SQL Accounting

2006-10-22 Thread Matt Harlum
Many thanks, this is what happens when i spend my nights toying with things when i should be asleep, i suppose i can just watch the postauth responses for an indication as to who is logged in as my AP requires automatic re-authing every 15 minutes. Thanks for the help pete. On

Re: radutmp and/or SQL Accounting

2006-10-21 Thread Matt Harlum
Database for WPA Enterprise encryption, However i cannot get radutmp or SQL accounting to work, i'm running it on OSX 10.4.8 My Radiusd.conf is attached radius.conf - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/ users.html - List info/subscribe/unsubscribe? See

RE: SQL Accounting oddness

2006-10-13 Thread John Williams
? John -Original Message- From: freeradius-users- [EMAIL PROTECTED] [mailto:freeradius-users- [EMAIL PROTECTED] On Behalf Of John Williams Sent: 12 October 2006 13:10 To: 'FreeRadius users mailing list' Subject: RE: SQL Accounting oddness Dave There aren't any errors in the mysql

RE: SQL Accounting oddness - SOLVED

2006-10-13 Thread John Williams
-Original Message- From: freeradius-users- [EMAIL PROTECTED] [mailto:freeradius-users- [EMAIL PROTECTED] On Behalf Of John Williams Sent: 13 October 2006 11:45 To: 'FreeRadius users mailing list' Subject: RE: SQL Accounting oddness Here is something else I found. I run radius in debug

RE: SQL Accounting oddness

2006-10-12 Thread John Williams
freeradius sending it if I run radius in debug mode. John -Original Message- From: freeradius-users- [EMAIL PROTECTED] [mailto:freeradius-users- [EMAIL PROTECTED] On Behalf Of Sean Sent: 11 October 2006 17:39 To: freeradius-users@lists.freeradius.org Subject: RE: SQL Accounting oddness

RE: SQL Accounting oddness

2006-10-12 Thread David Roze
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Williams Sent: 12 October 2006 08:26 To: 'FreeRadius users mailing list' Subject: Spam:RE: SQL Accounting oddness All the ports are open. The authentication packets and accounting packets are hitting

RE: SQL Accounting oddness

2006-10-12 Thread John Williams
-- http://www.netexpertise.eu -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Williams Sent: 12 October 2006 08:26 To: 'FreeRadius users mailing list' Subject: Spam:RE: SQL Accounting oddness All the ports are open. The authentication packets

RE: SQL Accounting oddness

2006-10-11 Thread John Williams
radius accounting isnt getting logged to sql from the new radius server. Help someone??? Thanks John From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Williams Sent: 10 October 2006 17:06 To: 'FreeRadius users mailing list' Subject: SQL Accounting oddness Ive

RE: SQL Accounting oddness

2006-10-11 Thread Sean
Hi, Check that you have all the ports used by FreeRadius open. It looks as if the accounting traffic is not getting through to the server. Let me know if I'm right. Regards, Sean Bracken http://swarmhotspots.com - List info/subscribe/unsubscribe? See

Re: SQL Accounting oddness

2006-10-11 Thread LeRoy DeVries
On Wednesday 11 October 2006 10:38, Sean wrote: Hi, Check that you have all the ports used by FreeRadius open. It looks as if the accounting traffic is not getting through to the server. Let me know if I'm right. Regards, Sean Bracken Sean: I'm having the same problem and have the

SQL Accounting oddness

2006-10-10 Thread John Williams
authenticating from the database. However accounting information is not being entered into the radacct table, its currently empty but we are getting accounting packets back. I run freeradius in debug mode and found the following sql accounting queries that dont look right: sql

Re: SQL Accounting and Null Attribute Values

2006-03-02 Thread trs
: radius_xlat: 'UPDATE radacct SET AcctStartTime = '2006-03-02 01:18:04', AcctStartDelay = '', It fails with: rlm_sql (sql): Couldn't update SQL accounting START record - ERROR: invalid input syntax for type bigint: Can freeradius substitute a zero if an integer attribute is missing

Re: SQL Accounting and Null Attribute Values

2006-03-02 Thread Peter Nixon
: radius_xlat: 'UPDATE radacct SET AcctStartTime = '2006-03-02 01:18:04', AcctStartDelay = '', It fails with: rlm_sql (sql): Couldn't update SQL accounting START record - ERROR: invalid input syntax for type bigint: Can freeradius substitute a zero if an integer attribute

SQL Accounting and Null Attribute Values

2006-03-01 Thread trs
Accounting queries fail if an attribute is null when supplied as a value for certain column types. Partial line from debug output: radius_xlat: 'UPDATE radacct SET AcctStartTime = '2006-03-02 01:18:04', AcctStartDelay = '', It fails with: rlm_sql (sql): Couldn't update SQL accounting START

Re: SQL Accounting and Null Attribute Values

2006-03-01 Thread Peter Nixon
): Couldn't update SQL accounting START record - ERROR: invalid input syntax for type bigint: Can freeradius substitute a zero if an integer attribute is missing from an accounting packet, instead of just a null value? Yes. You need: AcctStopDelay = '%{Acct-Delay-Time:-0}' I already fixed

postgres sql accounting....

2006-02-10 Thread Robert Myers
check_error: PGRES_FATAL_ERROR, returning SQL_DOWN rlm_sql (sql): failed after re-connect rlm_sql (sql): Couldn't insert SQL accounting STOP record - ERROR: invalid input syntax for integer: rlm_sql (sql): Released sql socket id: 0 modcall[accounting]: module sql returns fail for request 6 modcall

Re: Cisco-AVPair SQL accounting (attr. not duplicated)

2005-12-15 Thread Nicolas Baradakis
-AVPair[index]} syntaxes I've seen suggested for Cisco VSAs in various places. rlm_sql complains of an unknown xlat function or non-existent attribute. Has anyone managed to do this? If so, what is the correct syntax to use these in SQL accounting statements? The syntax %{Cisco-AVPair[n

RE: Cisco-AVPair SQL accounting (attr. not duplicated)

2005-12-15 Thread Lenir
-AVPair SQL accounting (attr. not duplicated) G'day, Sorry if this has been covered already, as I imagine it's a common issue, but I haven't been able to rustle any working answers up after a long time googling and grepping $FR/src. I've got an AS5300 that sends a few attributes, with accounting

Cisco-AVPair SQL accounting (attr. not duplicated)

2005-12-14 Thread James Wakefield (Sunet Sysadmin)
-existent attribute. Has anyone managed to do this? If so, what is the correct syntax to use these in SQL accounting statements? Cheers, -- James Wakefield Systems Administrator +61 03 5227 6888 We have now moved head office to 8-12 Pakington Street, Geelong West. - List info/subscribe

SQL accounting and users on seperate servers

2005-04-19 Thread Greg Ulyatt
I'm trying to get a 2 server SQL setup going where all user data is kept on one system, and the accounting is on another. I have tried several things (including copyingrenaming sql.conf to sqlacct.conf then using them both... no joy!) Of course, I could do this with radrelay but that seems to

Re: SQL accounting and users on seperate servers

2005-04-19 Thread Kostas Kalevras
On Tue, 19 Apr 2005, Greg Ulyatt wrote: I'm trying to get a 2 server SQL setup going where all user data is kept on one system, and the accounting is on another. I have tried several things (including copyingrenaming sql.conf to sqlacct.conf then using them both... no joy!) Of course, I could

Re: SQL accounting and users on seperate servers

2005-04-19 Thread Greg Ulyatt
aha! works like a charm. I was mis-reading the docs on that, but I now see how it works. Cheers! Kostas Kalevras wrote: On Tue, 19 Apr 2005, Greg Ulyatt wrote: I'm trying to get a 2 server SQL setup going where all user data is kept on one system, and the accounting is on another. I have tried

detail files vs. SQL Accounting.

2005-03-17 Thread Chris Knipe
Lo everyone, I'm not 100% sure on where the problem lies, so please bare with me. The relavent parts of my configuration: details { detail details { detailfile = ${radacctdir}/detail-%{Realm:-LOCAL} detailperm = 0600 dirperm = 0755 locking = yes } radutmp { filename =

RE: detail files vs. SQL Accounting.

2005-03-17 Thread Michael Markstaller
Now, using radreport (I know, not a FR product), radreport uses the details the radreport I tried some months ago was broken, very broken. sql-accounting and details files in FR are 100% accurate, at least here. My questions thus... 1) Is there a application available that can write

Re: detail files vs. SQL Accounting.

2005-03-17 Thread Chris Knipe
Now, using radreport (I know, not a FR product), radreport uses the details the radreport I tried some months ago was broken, very broken. sql-accounting and details files in FR are 100% accurate, at least here. Allrighty. I suspected that. My questions thus... 1) Is there a application available

sql accounting basic question

2005-03-07 Thread Adam KOSA
Hi could anyone tell the difference between AcctSessionId and AcctUniqueId in the sql table? and also: i see that an insert is performed with acctstarttime set to the timestamp and acctstoptime set to 0 at accounting start. an update is done at accounting stop, and another insert is done with

Re: sql accounting basic question

2005-03-07 Thread Alan DeKok
Adam KOSA [EMAIL PROTECTED] wrote: could anyone tell the difference between AcctSessionId and AcctUniqueId in the sql table? The first is the Acct-Session-Id, as sent by the NAS. NASes tend to re-use ID's however, despite the standard saying to NOT do that. As a result, FreeRADIUS create

Re: Secondary SQL accounting instance needed

2005-03-04 Thread Mark Elkins
On Wed, 2005-03-02 at 13:19 +0200, Mark Elkins wrote: I want to collect the current allocate IP address and username into a separate MySql table - if it (the user (=key)) exists - update the IP, if the user does not exist, add user and IP. I (think that I) understand that I need to have a

Re: Secondary SQL accounting instance needed

2005-03-04 Thread Mark Elkins
and IP. I (think that I) understand that I need to have a second instance of 'sql'.. Phew - it works (exactly as I documented :) Might have spoken too soon I'm getting... (in radius.log) Error: rlm_sql (sql_catch_ip): Couldn't insert SQL accounting START record - Duplicate entry

Secondary SQL accounting instance needed

2005-03-02 Thread Mark Elkins
Before I go forth and break my radius and have a few thousand people looking for me I want to collect the current allocate IP address and username into a separate MySql table - if it (the user (=key)) exists - update the IP, if the user does not exist, add user and IP. I (think that I)

Re: Secondary SQL accounting instance needed

2005-03-02 Thread Thomas MARCHESSEAU
Hi Mark , yes, you can You dont need to log the stop ticket ? this could be usefull. Regards Thomas re I go forth and break my radius and have a few thousand people looking for me I want to collect the current allocate IP address and username into a separate MySql table - if it (the user

Re: sql accounting failover

2005-02-19 Thread [EMAIL PROTECTED]
hello, I have this lines in radiusd.conf: accounting { detail redundant { sql detail_fail } } and the output from radiusd -X is rlm_sql_postgresql: Status: PGRES_TUPLES_OK

Re: sql accounting failover

2005-02-19 Thread Alan DeKok
[EMAIL PROTECTED] [EMAIL PROTECTED] wrote: why is module detail_fail called if module sql returns OK ? It's a bug. See bugs.freeradius.org. It's fixed in the 1.0.2, and in recent CVS versions. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

sql accounting failover

2005-02-17 Thread [EMAIL PROTECTED]
hello, I am interested to know if it is possible to configure freeradius sql module to write in a file only the failed querys (accounting and/or auth) ? from what I understand the sqltrace boolean parameter is used to log all the sql querys. I want to be able to reaply the only the failed

Re: sql accounting failover

2005-02-17 Thread Thor Spruyt
[EMAIL PROTECTED] wrote: I am interested to know if it is possible to configure freeradius sql module to write in a file only the failed querys (accounting and/or auth) ? Yes, read doc/configurable_failover from what I understand the sqltrace boolean parameter is used to log all the sql querys.

handling of sql accounting stop queries (main and alternate)

2005-02-04 Thread Bruno Lague
Hi, We are having difficulty making FreeRadius efficient in our environment because we cannot reliably attempt to insert records in the SQL database prior to attempting an update. In one environment, our NAS'es are sending STOP accounting requests only (no START and UPDATE). In such a case, it

Sql accounting error

2004-07-29 Thread Costas Christonis
): Couldn't update SQL accounting for START packet - Duplicate entry '2336002' Error: rlm_sql: Couldn't insert SQL accounting STOP record - Duplicate entry '2336002' for key 1 Can someone help? Costas A. Christonis Networking Communications Centre Gallos Campus - University of Crete email

Re: Sql accounting error

2004-07-29 Thread Costas Christonis
Error: rlm_sql (sql): Couldn't update SQL accounting for CC START packet - Duplicate entry '2336002' CC Error: rlm_sql: Couldn't insert SQL accounting STOP record - CC Duplicate entry '2336002' for key 1 CC Can someone help? I also want to add this error that we see when running in debug mode

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
we have always these errors: Error: rlm_sql (sql): Couldn't update SQL accounting for START packet - Duplicate entry '2336002' Error: rlm_sql: Couldn't insert SQL accounting STOP record - Duplicate entry '2336002' for key 1 Can someone help? Run CHECK TABLE Costas A. Christonis

Re: SQL Accounting

2004-02-23 Thread Guy Fraser
Daniel_Baughman wrote: Whats more is the sqltrace file has valid querys. If i execute the querys in the sql trace file with the same account freeradius is using it populates the database just fine. Any suggestions? -- Original Message -- From:

Re: SQL Accounting

2004-02-23 Thread Guy Fraser
Daniel_Baughman wrote: Answer from hat Your permissions are wrong and your db is regecting Your were right, my pgsql log looks like this: ERROR: permission denied for sequence radacct_radacctid_seq ERROR: permission denied for sequence radacct_radacctid_seq ERROR: permission denied for

SQL Accounting

2004-02-20 Thread Daniel_Baughman
Ok I have the accounting publishing properly to my text files but the database isn't populating with accounting data, how do I tell it to do that? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: SQL Accounting

2004-02-20 Thread Daniel_Baughman
Whats more is the sqltrace file has valid querys. If i execute the querys in the sql trace file with the same account freeradius is using it populates the database just fine. Any suggestions? -- Original Message -- From: Daniel_Baughman [EMAIL PROTECTED]

Is it possible to test sql accounting locally

2004-01-08 Thread Antoine Cavalié
Hi everybody As I modified and recompiled freeradius 0.9.3 to have accounting work as I want it to work, I would like to test accounting locally In other words, I would like to know if there is a equivalent to radtest, which only runs authorization modules, that could run sql accounting modules

Re: Is it possible to test sql accounting locally

2004-01-08 Thread Robert Causey
modules, that could run sql accounting modules. Thank you for your help Antoine Cavalié - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

RE: Is it possible to test sql accounting locally

2004-01-08 Thread Antoine Cavalié
Sorry, I didn't read the radclient documentation Antoine Cavalié - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html