Hello Tunde -
You just need to add an AuthBy SQL clause to your configuration file, something like this:
<Client localhost>
��� # ipass client for VNAS (incoming metrong roamers)
������� Secret
������� Identifier ipassclient
������� IdenticalClients 63.10.10.212
������� RewriteUsername s/^IPASS\/([^@]+)\@([^@]+)$/IPASS\/$1#$2\@myipass/
</Client>
�
<AuthBy RADIUS>
������� Identifier����� ipassNetserver
������� Host����������� 63.10.10.211
������� Secret����������
������� AuthPort������� 11812
������� AcctPort������� 11813
������� AddToRequest Called-Station-Id=%{Called-Station-Id}, NAS-IP-Address=%N
������� DefaultSimultaneousUse 1
</AuthBy>
�
<AuthBy SQL>
Identifier SQLAccounting
DBSource .....
DBUsername .....
DBAuth .....
# empty AuthSelect to disable authentication
AuthSelect
# configure AccountingTable and AcctColumnDef's
AccountingTable IPASSACCOUNTING
AcctColumnDef .....
.....
</AuthBy>
<Handler Realm=myipass>
������� AcctLogFileName� %L/ipass/detail
������� RewriteUsername� s/^IPASS\/([^#]+)\#([^@]+)\@myipass$/IPASS\/$1\@$2/
AuthByPolicy ContinueAlways
AuthBy SQLAccounting
������� AuthBy ipassNetserver
</Handler>
�
<Handler Client-Identifier=ipassclient>
������� AuthByPolicy ContinueWhileAccept
������� RewriteUsername s/^([^@]+).*/$1/
������� RewriteUsername tr/A-Z/a-z/
������� UsernameCharset a-zA-Z0-9\._@-
������� AcctLogFileName�������� %L/account.log
������� PasswordLogFileName���� %L/password.log
������� SessionDatabase SDB1
������� AuthBy SQLClientauth
������� StripFromReply Framed-IP-Address
</Handler>
�
regards
Hugh
On Thursday, Jan 16, 2003, at 06:52 Australia/Melbourne, Ayotunde Itayemi wrote:
Hi Hugh, Hi All,
�
I would like to log only IPASS accounting start and stop request to a database
table�so as to get some sort of record locally - how can I implement this?
I want something a little bit "simpler" than the long detail file generated by
the AcctLogFileName clause (see below pls). One can more easily peruse
entries in an Oracle table.
�
Regards,
Tunde Itayemi.
�
�
Relevant parts of my config :
�
<Client localhost>
��� # ipass client for VNAS (incoming metrong roamers)
������� Secret
������� Identifier ipassclient
������� IdenticalClients 63.10.10.212
������� RewriteUsername s/^IPASS\/([^@]+)\@([^@]+)$/IPASS\/$1#$2\@myipass/
</Client>
�
<AuthBy RADIUS>
������� Identifier����� ipassNetserver
������� Host����������� 63.10.10.211
������� Secret����������
������� AuthPort������� 11812
������� AcctPort������� 11813
������� AddToRequest Called-Station-Id=%{Called-Station-Id}, NAS-IP-Address=%N
������� DefaultSimultaneousUse 1
</AuthBy>
�
<Handler Realm=myipass>
������� AcctLogFileName� %L/ipass/detail
������� RewriteUsername� s/^IPASS\/([^#]+)\#([^@]+)\@myipass$/IPASS\/$1\@$2/
������� AuthBy ipassNetserver
</Handler>
�
<Handler Client-Identifier=ipassclient>
������� AuthByPolicy ContinueWhileAccept
������� RewriteUsername s/^([^@]+).*/$1/
������� RewriteUsername tr/A-Z/a-z/
������� UsernameCharset a-zA-Z0-9\._@-
������� AcctLogFileName�������� %L/account.log
������� PasswordLogFileName���� %L/password.log
������� SessionDatabase SDB1
������� AuthBy SQLClientauth
������� StripFromReply Framed-IP-Address
</Handler>
�
-- 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.
