(RADIATOR) How can I ignore request for Invalid character in User-Name

N_H_D SAME THING n_h_d at hotmail.com
Tue May 9 09:01:32 CDT 2006


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.


--
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