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

[Hugh Irvine]

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.