I am trying to setup the above for authentication using Radius.
Radius is working fine for my Lantronix 16port access server however I get
the following from the Cisco...
NAS-Identifier = 203.58.25.19
NAS-Port = 1
NAS-Port-Type = Async
User-Name = "`"
Password = "h\340\023B\223\220\220a\354\307r\326V\272V-"
rad_authenticate_ODBC()
Password = "h\340\023B\223\220\220a\354\307r\326V\272V-"
SQL Statement: Select DateDiff(Minute, GetDate(), DateAdd(Day,
(ma.Extension+ma.OverDue+1), maExpireDate)), DateDiff(Minute, GetDate(),
DateAdd(Day, sa.Extension+1, saExpireDate)), sa.AccountID, sa.AccountType,
sa.Password, sa.Login, sa.Shell, sa.TimeLeft From MasterAccounts ma,
SubAccounts sa Where (sa.Login='`' or sa.Shell='`' or sa.Email='`') AND
ma.CustomerID=sa.CustomerID and sa.Active<>0 and ma.Active<>0
ODBC Error:00000:1310760:
Sending Reject of id 0 to cb3a1913 (Comserv1)
SQL Statement: INSERT INTO RadLogs(RadLogMsgID, LogDate, Username, Data)
VALUES (10, GetDate(), '`', '|')
ODBC Error:23000:547:
[Microsoft][ODBC SQL Server Driver][SQL Server]INSERT statement conflicted
with COLUMN FOREIGN KEY constraint 'FK__RadLogs__RadLogM__1E1A7EA3'. The
conflict occurred in database 'Emerald', table 'RadLogMsgs', column
'RadLogMsgID'
User: ` Not found
User: ` Not found
Resp Time: 51 Auth: 88/6 -> 94 Acct: 178/0/1 -> 179
radrecv: Request from host cb3a1913 code=1, id=1, length=61
NAS-Identifier = 203.58.25.19
NAS-Port = 1
NAS-Port-Type = Async
User-Name = "`||"
Password = "\301'\227]\276\013q\003(U\272\377\315\223kT"
rad_authenticate_ODBC()
Password = "\301'\227]\276\013q\003(U\272\377\315\223kT"
SQL Statement: Select DateDiff(Minute, GetDate(), DateAdd(Day,
(ma.Extension+ma.OverDue+1), maExpireDate)), DateDiff(Minute, GetDate(),
DateAdd(Day, sa.Extension+1, saExpireDate)), sa.AccountID, sa.AccountType,
sa.Password, sa.Login, sa.Shell, sa.TimeLeft From MasterAccounts ma,
SubAccounts sa Where (sa.Login='`||' or sa.Shell='`||' or sa.Email='`||')
AND ma.CustomerID=sa.CustomerID and sa.Active<>0 and ma.Active<>0
ODBC Error:00000:1310760:
Sending Reject of id 1 to cb3a1913 (Comserv1)
SQL Statement: INSERT INTO RadLogs(RadLogMsgID, LogDate, Username, Data)
VALUES (10, GetDate(), '`||', '')
ODBC Error:23000:547:
[Microsoft][ODBC SQL Server Driver][SQL Server]INSERT statement conflicted
with COLUMN FOREIGN KEY constraint 'FK__RadLogs__RadLogM__1E1A7EA3'. The
conflict occurred in database 'Emerald', table 'RadLogMsgs', column
'RadLogMsgID'
User: `|| Not found
User: `|| Not found
Resp Time: 50 Auth: 88/7 -> 95 Acct: 178/0/1 -> 179
Here's my Cisco setup:
Current configuration:
!
version 11.2
no service udp-small-servers
no service tcp-small-servers
!
hostname comserv1
!
aaa new-model
aaa authentication login default radius local
aaa authentication login admins local
aaa authentication ppp default if-needed radius
aaa authentication ppp dialins radius local
aaa authorization exec local
aaa authorization network radius local
aaa accounting network start-stop radius
enable secret 5 $1$DHmC$qPo2DvcfxHe4JgLi80RVy0
!
username comserv1 password 0 *******
username root password 0 ******
ip subnet-zero
ip domain-name aquarius.com.au
ip name-server 203.58.25.3
ip address-pool local
async-bootp dns-server 203.58.25.5
!
interface Loopback0
ip address 10.10.11.5 255.255.255.0
!
interface Ethernet0
ip address 203.58.25.19 255.255.255.192
!
interface Serial0
no ip address
shutdown
no fair-queue
!
interface Group-Async1
no ip address
encapsulation ppp
ppp authentication pap
group-range 1 16
!
ip local pool 203.58.25.37 203.58.25.52
ip classless
ip route 0.0.0.0 0.0.0.0 203.58.25.15
ip route 203.58.25.0 255.255.255.0 203.58.25.15
!
radius-server host 203.58.25.4 auth-port 1645 acct-port 1646
radius-server key ********
!
line con 0
exec-timeout 30 0
line 1
autoselect arap
autoselect during-login
autoselect ppp
login authentication radius
modem Dialin
transport input all
stopbits 1
speed 115200
flowcontrol hardware
line 2 16
autoselect arap
autoselect during-login
autoselect ppp
login authentication admins
modem Dialin
modem autoconfigure discovery
transport input all
stopbits 1
speed 2400
flowcontrol hardware
line aux 0
line vty 0 4
exec-timeout 30 0
!
end
Any help will be greatly appreciated.
Glen.
--------------------------------------------------------------------
AQUARIUS Communications for all your Internet needs
voice(02)9977-3788 fax(02)9977-3844
http://www.aquarius.com.au mailto:sales@aquarius.com.au
For more information about this list, including removal, please
see this URL: http://www.iea-software.com/maillist.html