(RADIATOR) Selecting domain stripping in AuthBySQLRADIUS
James Wiegand
jwiegand at fiberlink.com
Fri Jul 12 09:03:05 CDT 2002
Hello,
I am trying to get the rewrite working and there is an error when I try to
define the REWRITE column. This is with the patch bundle from the web site
(AuthSQLRADIUS 1.6, 2002/06/17). The DBI and AuthSQLRADIUS works normally
until I define a value for the rewrite column.
Here is the trace output (secrets and domains changed):
Fri Jul 12 21:43:53 2002: DEBUG: Packet dump:
*** Received from 172.16.2.15 port 63939 ....
Code: Access-Request
Identifier: 109
Authentic: <221><197><242><246>\<30>8r <208><215><25>5<172><200>e
Attributes:
User-Name = "test at foo.com"
User-Password
= "<178>$/<251>AKo<174><127>7^<169><166><231><146><188>"
Fri Jul 12 21:43:53 2002: DEBUG: Handling request with Handler ''
Fri Jul 12 21:43:53 2002: DEBUG: Deleting session for test at foo.com,
172.16.2.15,
Fri Jul 12 21:43:53 2002: DEBUG: Handling with Radius::AuthRADIUS
Fri Jul 12 21:43:53 2002: DEBUG: Query is: select HOST1, SECRET, AUTHPORT,
ACCTPORT, RETRIES, RETRYTIMEOUT, REWRITE from RADSQLRADIUS where TARGETNAME
= 'foo.com'
Can't use string ("s/\s+//g") as an ARRAY ref while "strict refs" in use at
/usr/lib/perl5/site_perl/5.6.1/Radius/Radius.pm line 1452.
Here is the relevant radius.cfg entry:
<Handler>
Identifier DefaultSQL
<AuthBy SQLRADIUS>
HostSelect select HOST%0, SECRET, AUTHPORT, ACCTPORT,
\
RETRIES, RETRYTIMEOUT, REWRITE from RADSQLRADIUS where TARGETNAME
= '%R'
HostColumnDef 0, Host
HostColumnDef 1, Secret
HostColumnDef 2, AuthPort
HostColumnDef 3, AcctPort
HostColumnDef 4, Retries
HostColumnDef 5, RetryTimeout
HostColumnDef 6, RewriteUsername
DBSource dbi:mysql:radius
DBUsername XXXX
DBAuth XXXX
Timeout 5
FailureBackoffTime 1
</Authby>
</Handler>
And the data in the table is:
mysql> select * from RADSQLRADIUS;
+------------+-------------+-------+---------+----------+----------+---------+--------------+----------+
| TARGETNAME | HOST1 | HOST2 | SECRET | AUTHPORT | ACCTPORT |
RETRIES | RETRYTIMEOUT | REWRITE |
+------------+-------------+-------+---------+----------+----------+---------+--------------+----------+
| foo.com | 172.16.3.15 | NULL | xxx | 1663 | 1664 | NULL |
NULL | s/\s+//g |
+------------+-------------+-------+---------+----------+----------+---------+--------------+----------+
1 row in set (0.00 sec)
Jim Wiegand, BSEE, MSE
Supervisor, Infrastructure Operations
Fiberlink Communications
215 793 6554
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender and delete the material from any
computer.
Hugh Irvine
<hugh at open.com.a To: "James Wiegand"
u> <jwiegand at fiberlink.com>,
Sent by: "'radiator at open.com.au'"
owner-radiator at o <radiator at open.com.au>
pen.com.au cc:
Subject: Re: (RADIATOR) Selecting domain
stripping in AuthBySQLRADIUS
07/08/2002 07:11
PM
Please respond
to hugh
Hello James -
In Radiator 3.1, you can use the AuthBy SQLRADIUS clause with
HostColumnDef's
to supply a RewriteUsername (or not).
Note that you will need the patched version of AuthBy SQLRADIUS from the
Radiator 3.1 patches area.
See section 6.45 in the Radiator 3.1 reference manual ("doc/ref.html").
regards
Hugh
On Tue, 9 Jul 2002 06:31, James Wiegand wrote:
> Hello,
>
> I am trying to come up with a config where we can store the bulk of our
> roaming configurations in an SQL table. There is one question that does
> not seem to be obvious from the configuration. Is it possible to have to
> strip the domain (or not) based on the (domain, host) key?
>
> Here's the scenario:
>
> user at foo.com -> user at foo.com sent to host1
> -> user at foo.com sent to host2
>
> user at bar.com -> user sent to host1
> -> user sent to host2
>
> user at zed.com -> user at zed.com sent to host1
> -> user sent to host2
>
> Any ideas?
>
> Jim Wiegand, BSEE, MSE
> Supervisor, Infrastructure Operations
> Fiberlink Communications
> 215 793 6554
>
>
> The information transmitted is intended only for the person or entity to
> which it is addressed and may contain confidential and/or privileged
> material. Any review, retransmission, dissemination or other use of, or
> taking of any action in reliance upon, this information by persons or
> entities other than the intended recipient is prohibited. If you
received
> this in error, please contact the sender and delete the material from any
> computer.
>
>
> ===
> Archive at http://www.open.com.au/archives/radiator/
> Announcements on radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' with
> 'unsubscribe radiator' in the body of the message.
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.
More information about the radiator
mailing list