(RADIATOR) How can I ignore request for Invalid character in User-Name
Hugh Irvine
hugh at open.com.au
Tue May 9 18:17:56 CDT 2006
Hello Nayeem -
You should set up a test environment and do some testing to verify
correct operation.
regards
Hugh
On 10 May 2006, at 00:01, N_H_D SAME THING wrote:
>
> Hi all,
>
> Just a question but would something like a rewrite at the global
> level solve the problem.
>
> " RewriteUsername tr/A-Z/a-z/
> RewriteUsername s/[^a-zA-Z0-9_\-\@\.]/X/g "
>
> Thanks in advance.
> Nayef
>
>
>> From: Hugh Irvine <hugh at open.com.au>
>> To: "Nayeem (Zajil Com)" <nayeem at ksa.zajil.com>
>> CC: <radiator at open.com.au>
>> Subject: Re: (RADIATOR) How can I ignore request for Invalid
>> character in User-Name
>> Date: Tue, 9 May 2006 19:44:47 +1000
>>
>>
>> Hello Nayeem -
>>
>> I am suggesting you use UsernameCharset at the global level.
>>
>> Otherwise you can use a RewriteUsername to remove the problem
>> characters.
>>
>> regards
>>
>> Hugh
>>
>>
>> On 9 May 2006, at 19:39, Nayeem ((Zajil Com)) wrote:
>>
>>> Hi Hugh,
>>>
>>> Thanks for reply but I'm already using this UsernameCharset but
>>> in Authlog
>>> while insert into database it will give error. Handler which we
>>> use is
>>> mention below.
>>>
>>> <Client 192.168.1.1>
>>> Identifier NAS2428
>>> Secret hotmail
>>> DupInterval 0
>>> </Client>
>>>
>>> <Handler NAS-IP-Address=192.168.1.1, Realm =
>>> /64.zajil.net|128.zajil.net|256.zajil.net|512.zajil.net/>
>>>
>>> UsernameCharset a-zA-Z0-9\._ at -
>>>
>>> MaxSessions 1
>>>
>>> <AuthLog SQL>
>>>
>>> DBSource dbi:ODBC:dsn
>>> DBUsername dbuser
>>> DBAuth dbpassword
>>>
>>> Table Logcalls
>>> SuccessQuery Insert into Logcalls (username, priority, Message,
>>> Phonenumber, Password, NAS) \
>>> values ('%w', %0, %1, '%{Calling-Station-Id}', '%P',
>>> '%N')
>>>
>>> FailureQuery Insert into Logcalls (username, priority, Message,
>>> Phonenumber, Password, NAS) \
>>> values ('%w', %0, %1, '%{Calling-Station-Id}', '%P',
>>> '%N')
>>>
>>> LogFailure 1
>>>
>>> </AuthLog>
>>>
>>>
>>> AuthByPolicy ContinueWhileAccept
>>> <AuthBy GROUP>
>>> AuthByPolicy ContinueUntilAccept
>>> AuthBy Check_FILE
>>> AuthBy Check_SQL
>>> </AuthBy>
>>>
>>> AuthBy AllocateIPAddressDSL
>>> AcctLogFileName %L/email/detail
>>> SessionDatabase SDB1
>>> StripFromReply PoolHint
>>> </Handler>
>>>
>>> Regards,
>>> Nayeem.
>>>
>>> -----Original Message-----
>>> From: Hugh Irvine [mailto:hugh at open.com.au]
>>> Sent: Tuesday, May 09, 2006 12:35 PM
>>> To: Nayeem (Zajil Com)
>>> Cc: radiator at open.com.au
>>> Subject: Re: (RADIATOR) How can I ignore request for Invalid
>>> character in
>>> User-Name
>>>
>>>
>>> Hello Nayeem -
>>>
>>> You can use a UsernameCharset to specify the characters that will be
>>> accepted in usernames.
>>>
>>> See section 5.4.31 in the Radiator 3.14 reference manual ("doc/
>>> ref.html").
>>>
>>> regards
>>>
>>> Hugh
>>>
>>>
>>> On 9 May 2006, at 18:44, Nayeem ((Zajil Com)) wrote:
>>>
>>>>
>>>> Dear All,
>>>>
>>>> Actually I want to ignore the request which is Invalid character in
>>>> Username because while inserting data in database in <AuthLog SQL>
>>>>
>>>> Tue May 9 00:07:37 2006: INFO: Access rejected for 2w"&j=m
>>>> L?OpDSn{0'@swccj.com.sa: Invalid character in User-Name Tue May 9
>>>> 00:07:37 2006: ERR: do failed for 'Insert into Logcalls (username,
>>>> priority, Message, Phonenumber, Password, NAS) values ('2w"&j=m
>>>> L?OpDSn{0'@swccj.com.sa', 1, 'Invalid character in User-Name', '',
>>>> 'A1U A{',
>>>> '192.19.12.4')': [Microsoft][ODBC SQL Server Driver][SQL Server]
>>>> Line
>>>> 1:
>>>> Incorrect syntax near '@swccj'. (SQL-42000)
>>>>
>>>> So any one can help to solve this issue.
>>>>
>>>> Regards,
>>>> Nayeem.
>>>>
>>>> --
>>>> 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.
>>>
>>>
>>> NB:
>>>
>>> Have you read the reference manual ("doc/ref.html")?
>>> Have you searched the mailing list archive (www.open.com.au/
>>> archives/
>>> radiator)?
>>> Have you had a quick look on Google (www.google.com)?
>>> Have you included a copy of your configuration file (no
>>> secrets), together
>>> with a trace 4 debug showing what is happening?
>>>
>>> --
>>> Radiator: the most portable, flexible and configurable RADIUS server
>>> anywhere. Available on *NIX, *BSD, Windows, MacOS X.
>>> -
>>> Nets: internetwork inventory and management - graphical, extensible,
>>> flexible with hardware, software, platform and database
>>> independence.
>>> -
>>> CATool: Private Certificate Authority for Unix and Unix-like
>>> systems.
>>>
>>
>>
>> NB:
>>
>> Have you read the reference manual ("doc/ref.html")?
>> Have you searched the mailing list archive (www.open.com.au/
>> archives/ radiator)?
>> Have you had a quick look on Google (www.google.com)?
>> Have you included a copy of your configuration file (no secrets),
>> together with a trace 4 debug showing what is happening?
>>
>> --
>> Radiator: the most portable, flexible and configurable RADIUS server
>> anywhere. Available on *NIX, *BSD, Windows, MacOS X.
>> -
>> Nets: internetwork inventory and management - graphical, extensible,
>> flexible with hardware, software, platform and database independence.
>> -
>> CATool: Private Certificate Authority for Unix and Unix-like systems.
>>
>>
>> --
>> 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.
>
NB:
Have you read the reference manual ("doc/ref.html")?
Have you searched the mailing list archive (www.open.com.au/archives/
radiator)?
Have you had a quick look on Google (www.google.com)?
Have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
-
CATool: Private Certificate Authority for Unix and Unix-like systems.
--
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