Hello,
I would like to ask a question about the connections that Radiator
opens to a database.
If we have an AuthBy SQL clause and a SessionDatabase SQL one, both
connecting to the same database with the same DBUsername, will Radiator
create two separate connections (one for each
On 01/15/2014 10:00 AM, Vangelis Kyriakakis wrote:
If we have an AuthBy SQL clause and a SessionDatabase SQL one, both
connecting to the same database with the same DBUsername, will Radiator
create two separate connections (one for each clause) or just one for
both clauses?
Hello
you could use GENERIC like how Heikki suggested but still have separate rows in
your sql and use SQL to join all the results, and apply the attribute names.
For MySQL, group_concat:
mysql select * from temp;
+++-+
| id | Server | Password|
At the moment I just have a single very simple table that I am testing
with, 2 columns 'Endpoint' 'Password' with 2 rows in the table for 2
different Tunnel endpoints.
I could have multiple columns for the multiple tunnels, but then if I
wanted to add or remove tunnels I would need to update
Hello Jim -
I generally do this sort of thing in a hook, using a dummy AuthBy SQL clause
to operate against.
Doing it this way allows to you use all of the normal Radiator code to do most
of the heavy lifting.
There are a number of examples doing similar things in goodies/hooks.txt that
On 06/26/2012 12:28 PM, Jim Tyrrell wrote:
At the moment I just have a single very simple table that I am testing
with, 2 columns 'Endpoint' 'Password' with 2 rows in the table for 2
different Tunnel endpoints.
How about changing the config to use GENERIC:
AuthColumnDef
Hi,
Is it possible for AuthBy SQL to return multiple attributes if the query
returns multiple rows?
I am currently using AuthBy SQL to return a Tunnel-Endpoint to a LAC
with the following simplified config:
AuthBy SQL
DBSourcedbi:mysql:databasename:192.168.10.3
I seem to remember reading somewhere in the Radiator manual that it will only
process the first sql row received therefore I don't think it will process
multiple row results. I can't seem to find in the manual where i read that
though. On the other hand, you could have all reply values on the
On 02/08/2012 07:40 PM, Lee Solway wrote:
Hello Lee,
Is there a way I can set an access Accept or Reject in the MySQL results
generated by AuthBy SQL?
Please see below for one method.
Currently I have a stored procedure that I call in the following.. I
would like the SP to be able to
On 02/09/2012 01:43 PM, Michael wrote:
I use a reject column in my user database, and SELECT it like this:
SELECT username, crypt, CONCAT('Reject:',reject),
and:
AuthColumnDef 2, Auth-Type, check
Yes, this is a very good method to do it.
so, if the reject column is NULL, CONCAT
Is there a way I can set an access Accept or Reject in the MySQL results
generated by AuthBy SQL?
Currently I have a stored procedure that I call in the following.. I
would like the SP to be able to reject the Access-Request with an error
message also if possible..
AuthSelect
On 11/09/2011 09:08 PM, Michael wrote:
For AuthBy SQL, does anyone know if sql returned values from AuthSelect and
configured as 'request' with AuthColumnDef are suppose to be added to the
request packet if the authentication fails? It does add if success, but
doesn't seem to add values
For AuthBy SQL, does anyone know if sql returned values from AuthSelect and
configured as 'request' with AuthColumnDef are suppose to be added to the
request packet if the authentication fails? It does add if success, but
doesn't seem to add values to the request packet if it fails. I don't
Hello,
I would like to know what happens when AuthSelect query in AuthBy
SQL returns two or more rows. Which one is used? The first or the last?
Example:
Username | Reply_item
---
user | reply1
user | reply2
AuthSelect select
On 03/03/2011 04:49 PM, Vangelis Kyriakakis wrote:
I would like to know what happens when AuthSelect query in AuthBy
SQL returns two or more rows. Which one is used? The first or the last?
Example:
Username | Reply_item
---
user |
That worked. Thank you. What did -i do?
Adam
--
Adam Gerson
Assistant Director of Technology
Columbia Grammar and Prep School
phone. 212-749-6200 ex. 321
fax. 212-428-6806
ager...@cgps.org
http://www.cgps.org
On 6/24/10 5:10 AM, Hugh Irvine wrote:
Hello Adam -
Try this:
Hello Adam -
The -I parameter to perl indicates where to find the Radiator modules.
Here is the help for perl:
Radiator-4.6 hugh$ perl -h
Usage: perl [switches] [--] [programfile] [arguments]
-0[octal] specify record separator (\0, if no argument)
-aautosplit mode
Hello Adam -
Try this:
/opt/local/bin/perl -I /usr/local/src/Radiator/Radiator-Locked-4.6
/usr/local/src/Radiator/Radiator-Locked-4.6/radiusd -config_file
/etc/radiator/radius.cfg -pid_file /var/run/radiusd.pid
regards
Hugh
On 24 Jun 2010, at 03:46, Adam Gerson wrote:
I have
I have figured out that MacPorts installs its own copy of perl into
/opt/local/bin
I need to use that perl, which includes the mysql packages. When I call
that perl explicitly I get this error:
sidekick:~ sadmin$ /opt/local/bin/perl
/usr/local/src/Radiator/Radiator-Locked-4.6/radiusd
Well, nothing has changed in my config file and my database is still up
and working. I have not used Radiator for a week or two. I started it
today to test it and now it cannot contact the database. I got an email
saying my trail had experienced, but at startup Radiator reports its
good until
Hello Adam -
The error message you show below indicates your database is not running (or is
unreachable for some reason).
regards
Hugh
On 22 Jun 2010, at 15:03, Adam Gerson wrote:
Well, nothing has changed in my config file and my database is still up
and working. I have not used
Hello,
I have such a problem. I have users in mysql database, and few so called
multilogin users. These multilogins have simple passwords created by
username, for example ppp/ppp. Problem is, that i need to authenticate
these combination as the same user:
ppp/ppp, PPP/PPP, ppp/PPP, PPP/ppp.
For
Hello Adam -
All you really need to do is use a RewriteUsername and a
CaseInsensitivePasswords with a single AuthBy SQL.
regards
Hugh
On Thursday, Oct 16, 2003, at 00:27 Australia/Melbourne, Adam
Pogorzelski wrote:
Hello,
I have such a problem. I have users in mysql database, and few so
Hi Hugh et al
Thank you for forcing me to run radiator in the foreground.
From the errors generated I managed to fix both problems.
They were both problem with the attributes assigned to particular column's
in the database.
In my first configuration I couldn't insert 'start' records as the
Hello Greg -
I will need to see a complete copy of your configuration file, together
with a trace 4 debug from Radiator showing what is happening.
regards
Hugh
On Saturday, September 28, 2002, at 10:58 AM, Greg 'Rafiq' Clarkson
wrote:
Hi everybody,
I need some clarification for
Hi everybody,
I need some clarification for setting up AuthBy SQL. I am using
Radiator-3.3.1. and any help will be greatly appreciated.
I am experimenting with different accounting tables with different
AcctColumnDef.
The problem is that one configuration only writes records where
What's the difference between AuthBy SQL w/ and empty AuthSelect and AuthLog
SQL??
Regards,
Virgil
--
WebCentral Pty Ltd Australia's #1 Internet Web Hosting Company
Level 5, 100 Wickham St. Network Operations - Systems Engineer
PO Box 930, Fortitude Valley.
AuthLog SQL records access-requests to a database.
AuthBy SQL w /an empty AuthSelect records accounting-requests to a database.
-Frank
-Original Message-
From: radiator [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 14, 2002 12:06 AM
To: '[EMAIL PROTECTED]'
Subject: (RADIATOR) AuthBy SQL
hi all,
I'm using Radiator 2.18.1 with AuthbySQL over MySQL.
I've defined several fields in SUBSCRIBERS table to check them.
I'm interested in checking NAS-Port-Type in a multi-value way, so for
example,
user1@domain
will be accepted if its NAS-Port-Type matches 'Sync' or 'Async'
Hello Julio -
You should use regular expressions to check multiple values:
NASPORTYPE = NAS-Port-type = '/Sync|Async/'
regards
Hugh
On Thu, 7 Mar 2002 22:27, [EMAIL PROTECTED] wrote:
hi all,
I'm using Radiator 2.18.1 with AuthbySQL over MySQL.
I've defined several fields in
+
Message-ID: 00dc01c1afb3$ce093040$[EMAIL PROTECTED]
From: tdn [EMAIL PROTECTED]
To: [EMAIL PROTECTED], [EMAIL PROTECTED]
References: [EMAIL PROTECTED]
[EMAIL PROTECTED]
014801c1ae22$976feb60$[EMAIL PROTECTED]
[EMAIL PROTECTED] Subject: Re: (RADIATOR)
AuthBy SQL and PostgreSQL
Date: Thu, 7
: Wednesday, February 06, 2002 2:31 AM
Subject: Re: (RADIATOR) AuthBy SQL and PostgreSQL
Hello -
Could you please send me a copy of your configuration file (no secrets)
together with a trace 4 debug from Radiator showing what is happening.
thanks
Hugh
On Tue, 5 Feb 2002 19:53, tdn wrote:
Hi
+
Message-ID: 014801c1ae22$976feb60$[EMAIL PROTECTED]
From: tdn [EMAIL PROTECTED]
To: [EMAIL PROTECTED], [EMAIL PROTECTED]
References: [EMAIL PROTECTED]
[EMAIL PROTECTED] Subject: Re: (RADIATOR)
AuthBy SQL and PostgreSQL
Date: Tue, 5 Feb 2002 11:53:33 +0300
MIME-Version: 1.0
Content-Type: text
- Original Message -
From: Hugh Irvine [EMAIL PROTECTED]
To: tdn [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, February 05, 2002 1:38 AM
Subject: Re: (RADIATOR) AuthBy SQL and PostgreSQL
Hello TDN -
Hi,
I'd like to have radiator authenticate users from a Postgres SQL
-- Forwarded Message --
Subject: BOUNCE [EMAIL PROTECTED]:Non-member submission from [tdn
[EMAIL PROTECTED]]
Date: Mon, 4 Feb 2002 04:06:07 -0600
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
From [EMAIL PROTECTED] Mon Feb 4 04:06:05 2002
Received: from mx1.uunet.co.ke
Hello TDN -
Hi,
I'd like to have radiator authenticate users from a Postgres SQL database.
I get the following error whenever I try to test it using radpwtst.
Can't read $DBI::errstr, last handle unknown or destroyed at
/usr/local/lib/perl5/site_perl/5.005/Radius/SqlDb.pm line 136
Am
-- Forwarded Message --
Subject: BOUNCE [EMAIL PROTECTED]:Non-member submission from [Robert
Blayzor [EMAIL PROTECTED]]
Date: Fri, 1 Feb 2002 21:59:11 -0600
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
From [EMAIL PROTECTED] Fri Feb 1 21:59:11 2002
Received: from
I'm using Authby SQL and to keep my user list current I recreat it every
15 minutes through a script. This is to insure that I always have a
acurate list of active and unavtive users But It appears that when ever
I do this radiator hangs for about 5 minutes or so. My question is does
radiator
Hello Aaron -
On Thu, 24 Jan 2002 06:41, Aaron Collins wrote:
I'm using Authby SQL and to keep my user list current I recreat it every
15 minutes through a script. This is to insure that I always have a
acurate list of active and unavtive users But It appears that when ever
I do this
Hi genius,
I am using AuthBy SQL to authenticate users. However, I would like to
verifiy the user's username, password and status=T. So, How, can I
rewrite the statement in sq.cfg to make it works.
Thanks so much for paying attention.
---
Regards,
Sam Cheung
E-mail: [EMAIL PROTECTED]
===
Hello Sam -
Just specify a suitable AuthSelect:
AuthSelect select PASSWORD where USERNAME = '%n' and STATUS = 'T'
AuthColumnDef 0, User-Password, check
regards
Hugh
On Tue, 8 Jan 2002 12:09, Sam Cheung wrote:
Hi genius,
I am using AuthBy SQL to authenticate users.
So I got the bright idea to add a AND PASS='%{Password}' to
the AuthSelect line. But the query ends up AND PASS=''
(nothing is put
in there.) So, obviously RADIUS either 1) can't pass it like
that or 2)
can but I'm doing it wrong.
Perhaps you want AND PASS='%P' ???
--
Robert
Robert,
Most likely. :) *Hits self upside head with large UNIX manual.*
Sadly enough, I *did* search/look through the documentation in
search of such, wondering WHY ON EARTH there was one for User-Name but
not Password. Guess it was a bit too late in the evening to be trying
-- Forwarded Message --
Subject: BOUNCE [EMAIL PROTECTED]:Non-member submission from [Rick
Ross [EMAIL PROTECTED]]
Date: Sun, 23 Dec 2001 18:41:31 -0600
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
From [EMAIL PROTECTED] Sun Dec 23 18:41:31 2001
Received: from
could someon tell me what I am missing here or doing wrong thanks
Sun Dec 23 19:20:28 2001: DEBUG: Rewrote user name to test
Sun Dec 23 19:20:28 2001: DEBUG: Check if Handler Realm=mynet.com should be
used to handle this request
Sun Dec 23 19:20:28 2001: WARNING: Could not find a handler for
Hello Rick -
Your configuration file has a Realm clause for xx.com and another Realm
clause for any other realm, however you don't have a clause to match just a
username by itself.
# define a Realm for username only
Realm
.
/Realm
regards
Hugh
could someon tell me
Hi,
I have a problem on AuthBy SQL, I don't want to be
authenticated using SQL Database but I just want to insert a value into another
self-defined database when the Radiator receives the accouting
start.
Trace result
---
Mon Sep 24 19:07:54 2001: DEBUG: Handling with
Hi,
We're
trying to use Authby Sql, after converting linux 6.2 shadow password file into
MSSQL table by buildsql. But the problem is, we couldn't get the users
authenticated with this Linux MD5 password encryption. We get bad encrypted
password result. But it works fine with Standard Unix
Hello Ujwol -
Please say hello to everyone at MOS for me, and please tell Sanjib that I am
planning on coming to visit Nepal in October this year.
On Thursday 15 March 2001 23:21, Ujwol wrote:
Hi,
We're trying to use Authby Sql, after converting linux 6.2 shadow
password file into
palTel : +977-1-240920Fax :+977-1-225407
- Original Message -
From:
Hugh Irvine
To: Ujwol ; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, March 16, 2001 5:06
AM
Subject: Re: (RADIATOR) Authby Sql
Hello Ujwol -Please say hello to everyone at MOS
for me,
-225407
- Original Message -
From:
Hugh Irvine
To: Ujwol ; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, March 16, 2001 5:06
AM
Subject: Re: (RADIATOR) Authby Sql
Hello Ujwol -Please say hello to everyone at MOS
for me, and please tell Sanjib that I am planning
Hello fellow radiator users,
I'm in the process of consolidating 4 ISPs into one. I'm setting
up AuthBy SQL to handle this. We don't have the passwords to all of
the users, so I'm trying to set up the following. If the user has a
NULL password in the database, then they can get in using
Hello Lachlan -
I was wondering if anyone may be able to help here.
I want to use "AuthColumnDef" option with "AuthSelect" in "AuthBy SQL".
My problem is with reply items. Some users need more reply items than
others.
For example, our permanent modem customers get given a single fixed
Hi Lachlan,
you can use PostAuthHook which allows you to do anything you wish with
reply, strip Framed-Ip-Address attribute for example.
hooks.txt file contains full information how to do it.
MM --- Forwarded mail from [EMAIL PROTECTED]
MM Date: Thu, 28 Dec 2000 17:40:13 +1100 (EST)
MM From:
--- Forwarded mail from [EMAIL PROTECTED]
Date: Thu, 28 Dec 2000 17:40:13 +1100 (EST)
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: BOUNCE [EMAIL PROTECTED]:Non-member submission from ["Lachlan
Fletcher" [EMAIL PROTECTED]]
From mikem Thu Dec 28 17:40:09 2000
Received: by
Hi,
I have a problem with that authentification.
Here is my configuration :
Foreground
Trace 4
AuthPort1645
AcctPort1646
LogDir /var/log/radiator
DbDir /usr/local/etc/radiator
LogFile %L//%Y%m/radiator-%Y%m%d
DictionaryFile %D/dictionary
PidFile
Salut Gildas -
On Sat, 09 Sep 2000, Gildas PERROT wrote:
Hi,
I have a problem with that authentification.
Here is my configuration :
Foreground
Trace 4
AuthPort1645
AcctPort1646
LogDir /var/log/radiator
DbDir /usr/local/etc/radiator
LogFile
Hello Froilan -
On Sat, 10 Jun 2000, Froilan Mendoza wrote:
Hello Hugh,
Thanks for responding ...
On Sat, 10 Jun 2000, Hugh Irvine wrote:
I notice that your Postgress table definitions are in lower case, and your
AuthSelect is in upper case. Is this correct?
Postgres is not
Hello.
I am curious with AuthBy SQL and decided to try it out. After a few
tries, however, I can't get logged in, using the most basic AuthSelect and
the tables/data contained in goodies/postgresCreate.sql. I get this
error complaining about incorrect password:
Fri Jun 9 20:42:02 2000:
Hello Hugh,
Thanks for responding ...
On Sat, 10 Jun 2000, Hugh Irvine wrote:
I notice that your Postgress table definitions are in lower case, and your
AuthSelect is in upper case. Is this correct?
Postgres is not case-sensitive.
radiator= select PASSWORD from SUBSCRIBERS where
Hi Oliver -
On Fri, 13 Aug 1999, O Stockhammer wrote:
Hugh,
Is there anyway to actually have Radiator append info to the
incoming data, so that it only uses on query per request?
I have created an AcctSQLStatement, but it seems because it is an
additional query that it
Hugh, here are the ACCOUNTING logs for two identical logins and the
corresponding (by timestamp) RADLOG entries. One successfully updated and
one did not. There were no error logs corresponding in the text logfile.
My only guess is that perhaps mysql failed to input the entry, although
there
Hi,
I have some questions regarding AuthBy SQL after I had ugraded into 2.1.3:
I have only one AuthBySQL and auth/acct goes into Oracle. Here is the sample
log:
Fri Mar 5 09:28:46 1999: DEBUG: Handling request with Handler
'Realm=DEFAULT'
Fri Mar 5 09:28:46 1999: DEBUG: Rewrote user name to
63 matches
Mail list logo