I've followed the Radiator manual for AuthLog SQL
Here are my config entries:
AuthLog SQL
Identifier SQL-AuthLog1
FailureQueryEXEC sp_RadiusAuthLog
'%{GlobalVar:ServerID}','%n','%{Class}','%N','%{Called-Station-Id}','%{C
alling-Station-Id}','%1'
LogSuccess
Hi Hugh,
I have a small problem with AuthLog SQL. I posted a previous message
and just assumed to try putting the connect information in the config
file. It appears to work.
I get the results placed in the database, and trace 4 shows no errors...
Thu May 30 09:56:34 2002: DEBUG:
We currently run radiator on 2 servers.
We use MS SQL for Client List and for User Auth
We use MySQL for Accounting
I have radiator configured to use a text file in the event
that the database fails, my AuthBy SQL returns an
Ignore and then it moves on to my AuthBy File
this works
Greetings,
I recall a while back there was some talk of a super-secret project
regarding reliable accounting for Radius. Has anything come of this? There's
still demand for it!
Thanks!
--Doug
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To
Hugh,Mike,
We switched to using the Radiator's Address Allocator routines. I recently
discovered what I perceive to be a bug in the mapResult function. I noticed
that our NAS was getting sporadic occurances of users getting an address
assigned from our backup pool. This pool is only on the NAS
Hello Tony -
You can specify multiple DBSource, DBUsername, DBAuth lines exactly as you
would for an AuthBy SQL clause.
At this time there is nothing you can do if there is no database at all.
regards
Hugh
On Fri, 31 May 2002 02:23, Tony Bunce wrote:
We currently run radiator on 2
Hello Leon -
Your understanding of what Radiator does in this case is incorrect.
If the AuthBy DYNADDRESS clause sees that there is a Framed-IP-Address
already present in the reply packet, it leaves it alone and does not do any
address allocation. This is to allow specific user definitions
Hello Lee -
If you are using the standard Radiator dictionary, you should change the
configuration file like this:
Handler NAS-IP-Address = ip address here
AuthBy FILE
Filename ./users
# Generate MPPE keys to encrypt pptp vpns
Hi,
Could anyone please lead me in the direction of the
documentation as to how to setup a maximum time and time left for a user in mysql database.
Thanks
Jack
Hello Jack -
Have a look at the file goodies/radmin.cfg which will give you some ideas.
regards
Hugh
On Fri, 31 May 2002 05:57, Jaskaran Singh wrote:
Hi,
Could anyone please lead me in the direction of the documentation as to
how to setup a maximum time and time left for a user in mysql
Hello Robert -
You would use the same DBSource, DBUsername and DBAuth as for the other SQL
clauses.
AuthLog SQL
DBSource
DBUsername .
DBAuth
.
/AuthLog
regards
Hugh
On Thu, 30 May 2002 23:28, Robert Blayzor wrote:
I've followed the
Title: Message
Jack,
Take a look at the mailing list archives and look for "AcctSQLStatement"
You should find quite a few in there matching what you are looking for.
That is the statement that is mostly used to "update" the MySQL row when the
user logs off.If you cannot see what you
I was referring to this post:
http://www.open.com.au/archives/radiator/2001-05/msg00335.html
Unfortunately our wish list for reliable accounting pretty much says it all.
We would like end-to-end reliability from the NAS to the SQL server. I know
that's a tall order, and I was asking more in a
Hello Doug -
I don't think anything ever came of that discussion.
However, you could fairly easily build a tunnel between the NAS and the
Radiator host and route the radius packets across it. Kind of a band-aid
solution though.
Note that there is a lot of work going on at present on the
Hello Hugh,
In Radmin1.5 , we can specify Radius Check and Reply Radius
attribute for each user. So we would like to set "Ascend-IP-Direct" for Radius
Reply , but there are no this attribute when I click drop-down menu in "Radius
attribute for user " window. So I try to append this
Hello Chairath -
The first thing to do is check whether you need the Ascend vendor-specifics,
which depends on what software version you are running on the MAX. If you
aren't already running recent software that supports the vendor-specifics, I
suggest you upgrade.
Next, you will have to
16 matches
Mail list logo