once. I have attached
a few lines from my configuration and make sure it is
correct.
session {
sql
}
accounting {
acct_unique
sql
}
Would having the above sections in my radiusd.conf be what I
am looking for to make this happen? I currently
have my
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
> OK, but the attribute is getting written to the accouting detail file,
> so if it is getting into the accounting detail file (which is just a text
> file) then why can I not write it to MySQL.
I don't know. See the SQL queries, and SQL logs for d
>
> The request is logged to the accounting detail file, and THEN the
> FreeRADIUS-Proxied-To is generated, and the packet is proxied.
>
> Order is important. Since the packet was logged before it was
> proxied, there is no FreeRADIUS-Proxied-To attribute to log.
>
OK, but the attribute is ge
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
> I guess what has me stumped, is if it is showing up in the detail file
> then why wouldn't it show up sqltrace.sql ?
>
> When I use NTRadping, I add the Freeradius-Proxied-To = 111.222.111.222
> and it is sent by NTRadping as a name/value pair and g
> > 2. But when I use something like NTRadping to test the accounting start
> > and accounting stop and send the additional attributes
> > "Freeradius-Proxied-To"
> > it gets written to both the master detail file and my radacct table.
>
> Find out what's different between the packets from the N
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
> I am currently in the process of setting up MySQL to handle the
> accounting records. Just about everything seems to working except I
> cannot get the attribute "Freeradius-Proxied-To" to write to my
> radacct table.
Odds are that the attribute i
HI,
I am using FreeRADIUS-0.9.1 primarily to proxy requests to other ISP's
radius
servers. I have 4 dial up accelerator servers that are acting as NAS's
(clients to
our radius server). I have added the vendors dictionary to FreeRADIUS and
all seems to be working well, requests are proxied reliab
I am running Freeradius 0.9 and I am writing accounting records to an
Oracle DB ver 8i. If the Database goes down, the Freeradius gives a
segmentation fault error and dies. I've tried also to point to another
database as a fail-over option, but the same results were encountered.
Please find below t
Solved make sure RadAcctId Extras is set to auto_increment must have got
lost in the scheme of things
Thanks, self
>You bet!
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 11, 2003 4:13 PM
Subject: Couldn't insert
: Info:
Ready to process requests.
Fri Jul 11 15:54:50 2003 : Error: rlm_sql: Couldn't insert SQL accounting
STOP record - Duplicate entry '0' for key 1Fri Jul 11 15:54:52 2003 : Error: rlm_sql:
Couldn't insert SQL accounting
STOP record - Duplicate entry '0' for key 1Fr
[EMAIL PROTECTED] (Derrik Pates) wrote:
> Actually, it pointed me in the right direction anyway - the checkrad
> script tried talking to the RAS server via SNMP, and got no response,
> and died of SIGTERM, for whatever reason knocking radiusd over with it.
> Anyone have any insight on that?
Ther
On Mon, Feb 24, 2003 at 10:40:13AM -0600, Chris Parker wrote:
> Use GDB it's much handier at finding the cause of the sigterm than
> strace.
Actually, it pointed me in the right direction anyway - the checkrad
script tried talking to the RAS server via SNMP, and got no response,
and died of SIGTER
At 11:26 AM 2/24/2003 -0500, Derrik Pates wrote:
For some reason, I've started to see FreeRADIUS die of a SIGTERM
somewhere in its SQL accounting code. It's going something like this:
radius_xlat: 'SELECT RadAcctId, AcctSessionId, UserName, NASIPAddress,
NASPortId,
For some reason, I've started to see FreeRADIUS die of a SIGTERM
somewhere in its SQL accounting code. It's going something like this:
radius_xlat: 'USERNAME'
rlm_sql (sql): sql_set_user escaped user --> 'USERNAME'
radius_xlat: 'SELECT COUNT(*) FROM
Simon White <[EMAIL PROTECTED]> wrote:
> > my NAS (portslave) sending to freeradius accounting packet with
> > calling-station-id = +21234567, and stored it normally into logfile and
> > radutmp. BUT into sql table radacct is stores as =2B21234567
> > asks: how TURN OFF this quoting? where this quo
On Wed, Dec 18, 2002 at 10:44:28AM +, Simon White wrote:
> 18-Dec-02 at 12:59, Malakhov Alexander ([EMAIL PROTECTED]) wrote :
> > hello! (sorry for my english)
> > I have a problem:
> > my NAS (portslave) sending to freeradius accounting packet with
> > calling-station-id = +21234567, and store
18-Dec-02 at 12:59, Malakhov Alexander ([EMAIL PROTECTED]) wrote :
> hello! (sorry for my english)
> I have a problem:
> my NAS (portslave) sending to freeradius accounting packet with
> calling-station-id = +21234567, and stored it normally into logfile and
> radutmp. BUT into sql table radacct is
hello! (sorry for my english)
I have a problem:
my NAS (portslave) sending to freeradius accounting packet with
calling-station-id = +21234567, and stored it normally into logfile and
radutmp. BUT into sql table radacct is stores as =2B21234567
asks: how TURN OFF this quoting? where this quoting pe
Thanks, I'll try it ASAP.
On Wed, Nov 06, 2002 at 12:23:34PM -0800, Hielke Christian Braun wrote:
> Date: Wed, 6 Nov 2002 12:23:34 -0800
> From: Hielke Christian Braun <[EMAIL PROTECTED]>
>
> Hi,
>
> i am using that with a cvs version from september, but it worked with
> all version up to from
Hi,
i am using that with a cvs version from september, but it worked with
all version up to from 0.5
Regards,
Christian.
On Wed, Nov 06, 2002 at 10:10:27PM +0200, Alexey Chetroi wrote:
> Hello Christian,
> I'd like to have that patches regarding converting of the
> cisco-avpair attributes, if
Hello Thomas,
On Wed, Nov 06, 2002 at 09:15:30AM +0100, Thomas Jalsovsky wrote:
>
> On Wed, 6 Nov 2002, Alexey Chetroi wrote:
>
> > Is it possible to rewrite attribute names eg in preprocess module,
> > like cisco_vsa_hack. eg to convert from:
> >
> > Cisco-AVPair = "nas-rx-speed=31200"
> > to
On Wed, Nov 06, 2002 at 09:15:30AM +0100, Thomas Jalsovsky wrote:
> > > > doc/variables.txt mentions that you can use %{Attribute-Name},
> > > > but what if there are several attributes with the same name,
> > > > eg Cisco-AVpair?
> > >
> > > The server doesn't handle that right now.
> > >
> > >
On Wed, 6 Nov 2002, Alexey Chetroi wrote:
> On Tue, Nov 05, 2002 at 10:49:12AM -0500, Alan DeKok wrote:
> > > doc/variables.txt mentions that you can use %{Attribute-Name},
> > > but what if there are several attributes with the same name,
> > > eg Cisco-AVpair?
> >
> > The server doesn't hand
On Tue, Nov 05, 2002 at 10:49:12AM -0500, Alan DeKok wrote:
> > doc/variables.txt mentions that you can use %{Attribute-Name},
> > but what if there are several attributes with the same name,
> > eg Cisco-AVpair?
>
> The server doesn't handle that right now.
>
> > I just want to log ras-tx-s
Alexey Chetroi <[EMAIL PROTECTED]> wrote:
> doc/variables.txt mentions that you can use %{Attribute-Name},
> but what if there are several attributes with the same name,
> eg Cisco-AVpair?
The server doesn't handle that right now.
> I just want to log ras-tx-speed and ras-rx-speed attributes
Hello All,
doc/variables.txt mentions that you can use %{Attribute-Name},
but what if there are several attributes with the same name,
eg Cisco-AVpair?
I just want to log ras-tx-speed and ras-rx-speed attributes
from the cisco in sql table. Is there any trick?
--
Best regards,
Alexey C
The NAS wasn't setup to account to the right place. *sigh*
It works now. Thanks for all the help!
--Aaron
Alan DeKok wrote:
> Aaron Paetznick <[EMAIL PROTECTED]> wrote:
>
>>I've just setup FreeRADIUS v0.6.0, and it works great in every way
>>except that it won't account correctly. Mayb
Aaron Paetznick <[EMAIL PROTECTED]> wrote:
> I've just setup FreeRADIUS v0.6.0, and it works great in every way
> except that it won't account correctly. Maybe better said that it won't
> account correctly for me. I'm trying to use the radacct MySQL table,
> but nothing ever shows up (zero ro
I've been use ICRADIUS for years now with great success. I'm familiar
with it's MySQL table structure. This isn't an ICRADIUS list, so I'll
get to the point.
I've just setup FreeRADIUS v0.6.0, and it works great in every way
except that it won't account correctly. Maybe better said that it
While in the process of trying to migrate from Cistron Radius to
FreeRadius, I have been testing posting of my detail files to a test server
running the latest Freeradius via cvs and postgresql. One problem I have
run into is that the logs from my MAX sometimes will create radius records
tha
Mike Tancsa <[EMAIL PROTECTED]> wrote:
> While in the process of trying to migrate from Cistron Radius to
> FreeRadius, I have been testing posting of my detail files to a test server
> running the latest Freeradius via cvs and postgresql. One problem I have
> run into is that the logs from my
Mike Cathey <[EMAIL PROTECTED]> wrote:
> I'd love to see some account usage report queries/scripts too if
> possible... :)
radiusreport. See:
http://www.freeradius.org/related/
Alan DeKok.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Saad wrote:
> Since this discussion has started . I would like to know how stable is
> radius in accouting with sql ,especially in oracle? any observations?
I'd love to see some account usage report queries/scripts too if
possible... :)
--
Mike Cathey - http://www.mikecathey.com/
Network Ad
rlm_sql: Couldn't update SQL accounting for ALIVE
packet - You have an error in your SQL syntax near
'WHERE AcctSessionTime=0 AND AcctStopTime=0 AND
NASIPAddress= '194.69.1.210' AND ' at line 1
rlm_sql: Released sql socket id: 4
I can get auth from LDAP but with Mysql ac
Sounds like a user permissions problem. When running in -x mode, the
server uses the permissions of the user who ran the command. Without the
-x, it runs with the permissions defined in the radiusd.conf file.
At 08:54 AM 2/5/2002 -0500, you wrote:
>SQL Accounting logging does not work for
Sounds like a user permissions problem. When running in -x mode, the
server uses the permissions of the user who ran the command. Without the
-x, it runs with the permissions defined in the radiusd.conf file.
At 08:54 AM 2/5/2002 -0500, you wrote:
>SQL Accounting logging does not work for
SQL Accounting logging does not work for me when I start radius with just
the -y option (radiusd -y), but it does work when I start radius with the
-y -x options (radiusd -y -x). Why would this be?
Paul Boyer Jr.
Intrada Technologies, LLC
Partner
1401 E. Third St
Williamsport, PA 17701
Email
I know I am new to both SQL and radius accounting. However I was
wondering why the accounting table isnt divided into 2 tables - joined.
1) Accounting session ID
2) AVP for each Accouting session ID
Or better yet 3 tables .. for each accounting packet to be logged
It seems impossible to create
Eric Reischer <[EMAIL PROTECTED]> wrote:
> Forgive me if this question has already been asked, but since there's no
> search option for the archives, I figured asking would be quicker :-)
http://www.google.com
> I'm using LDAP authentication for my radius server, however I want to be
> able
Forgive me if this question has already been asked, but since there's no
search option for the archives, I figured asking would be quicker
:-)
I'm using LDAP authentication for my radius server, however I want to be
able to log accounting information to a postgres database, so we can
retrieve the
40 matches
Mail list logo
