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

[Nayeem (Zajil Com)]

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.


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