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 = "[EMAIL PROTECTED]"
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 [EMAIL PROTECTED],
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
<[EMAIL PROTECTED] To: "James Wiegand"
u> <[EMAIL PROTECTED]>,
Sent by: "'[EMAIL PROTECTED]'"
owner-radiator@o <[EMAIL PROTECTED]>
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:
>
> [EMAIL PROTECTED] -> [EMAIL PROTECTED] sent to host1
> -> [EMAIL PROTECTED] sent to host2
>
> [EMAIL PROTECTED] -> user sent to host1
> -> user sent to host2
>
> [EMAIL PROTECTED] -> [EMAIL PROTECTED] 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 [EMAIL PROTECTED]
> To unsubscribe, email '[EMAIL PROTECTED]' 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 [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
