Dale,
I have an Ascend product (MAX 4004), no USR. I got around the issue by =
inserting a default IP address for the NASIdentifier in the Calls table =
(I only have one NAS right now). There must be a cleaner way to do =
this. Any suggestions? Also, is there a way (and if so how) to capture =
raw input and output to/from RadiusNT. Finally, you mention the problem =
is fixed in RadiusNT 2.1. Is that ready for release, in beta, or what? =
Thanks...Mark
Ok. I worked a problem like this today. If you are using a USR
product, certain versions of their
equipment send either BOTH NAS-IP-Address(4)/NAS-Identifier(32) or just
NAS-Identifier (32).
The dictionary that comes with Emerald/RadiusNT has one old legacy thing
concerning
this. Both of these are called NAS-Identifier, OR they will be reversed.
Grab a dump
of the accounting packet from radrecv to response time. If
NAS-Identifier is NOT
in the packet, you need to rename the dictiionary to match.
This problem has been fixed in RadiusNT 2.1, also.
--=20
Dale E. Reed Jr. (daler@iea.com)
-----Original Message-----
From: Dale E. Reed Jr. [SMTP:daler@iea.com]
Sent: Wednesday, April 30, 1997 11:18 PM
To: RadiusNT@emerald.iea.com
Subject: Re: Password Encryption
Mark A. Knight wrote:
>=20
> BINGO!
>=20
> I have another one for you. Probably just as easy and just as dumb. =
Why do I get the following message and what attribute in what table do I =
need to set to correct it?
>=20
> SQL Statement: INSERT INTO Calls =
(CallDate,UserName,NASPort,AcctStatusType,
> AcctDelayTime,AcctSessionID,FramedProtocol,FramedAddress) VALUES =
(GetDate(),'joe',20
> 101,1,0,'229551867',1,'207.240.11.153')
>=20
> ODBC: SQLExecDirect Error:
> [Microsoft][ODBC SQL Server Driver][SQL Server]The column =
NASIdentifier in table
> Calls may not be null.
> Sending Accounting Ack of id 116 to cff00b03 (expmax1)
_________________________________________________________________
IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
Internet Solutions for Today | http://www.emerald.iea.com
----------------------------------------------------------
RadiusNT Mailing List listserver@emerald.iea.com
------ =_NextPart_000_01BC5689.DD726020
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64
eJ8+IhIGAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEEkAYAyAEAAAEAAAAQAAAAAwAAMAIAAAAL
AA8OAAAAAAIB/w8BAAAATwAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAAAAFJhZGl1c05UQGVtZXJh
bGQuaWVhLmNvbQBTTVRQAFJhZGl1c05UQGVtZXJhbGQuaWVhLmNvbQAAHgACMAEAAAAFAAAAU01U
UAAAAAAeAAMwAQAAABkAAABSYWRpdXNOVEBlbWVyYWxkLmllYS5jb20AAAAAAwAVDAEAAAADAP4P
BgAAAB4AATABAAAAGwAAACdSYWRpdXNOVEBlbWVyYWxkLmllYS5jb20nAAACAQswAQAAAB4AAABT
TVRQOlJBRElVU05UQEVNRVJBTEQuSUVBLkNPTQAAAAMAADkAAAAACwBAOgEAAAAeAPZfAQAAABkA
AABSYWRpdXNOVEBlbWVyYWxkLmllYS5jb20AAAAAAgH3XwEAAABPAAAAAAAAAIErH6S+oxAZnW4A
3QEPVAIAAAAAUmFkaXVzTlRAZW1lcmFsZC5pZWEuY29tAFNNVFAAUmFkaXVzTlRAZW1lcmFsZC5p
ZWEuY29tAAADAP1fAQAAAAMA/18AAAAAAgH2DwEAAAAEAAAAAAAAArFhAQSAAQAYAAAAUkU6IFBh
c3N3b3JkIEVuY3J5cHRpb24AjwgBBYADAA4AAADNBwUAAQAXAC0ANwAEAFkBASCAAwAOAAAAzQcF
AAEAFwAoABkABAA2AQEJgAEAIQAAADRCMjE4MEQzN0JDMkQwMTE5RjBCNDQ0NTUzNTQwMDAwAM8G
AQOQBgCEDgAAIgAAAAsAAgABAAAACwAjAAEAAAADACYAAAAAAAsAKQAAAAAAAwAuAAAAAAACATEA
AQAAAMoAAABQQ0RGRUIwOQABAAIATQAAAAAAAAA4obsQBeUQGqG7CAArKlbCAABNU1BTVC5ETEwA
AAAAAE5JVEH5v7gBAKoAN9luAAAAQzpcRXhjaGFuZ2VcbWFpbGJveC5wc3QAGAAAAAAAAABHwueU
qNbPEZzDREVTVAAAooAAAAAAAAAYAAAAAAAAAEfC55So1s8RnMNERVNUAADCgAAAEAAAAEshgNN7
wtARnwtERVNUAAAYAAAAUkU6IFBhc3N3b3JkIEVuY3J5cHRpb24AAAADADYAAAAAAEAAOQBgpRh8
xFa8AR4AcAABAAAAGAAAAFJFOiBQYXNzd29yZCBFbmNyeXB0aW9uAAIBcQABAAAAFgAAAAG8VsR7
o9OAIUzCexHQnwtERVNUAAAAAB4AHgwBAAAABQAAAFNNVFAAAAAAHgAfDAEAAAAUAAAAbWtuaWdo
dEBwY2UtaW5jLmNvbQADAAYQOH02lQMABxB6BgAAHgAIEAEAAABlAAAAREFMRSxJSEFWRUFOQVND
RU5EUFJPRFVDVChNQVg0MDA0KSxOT1VTUklHT1RBUk9VTkRUSEVJU1NVRUJZSU5TRVJUSU5HQURF
RkFVTFRJUEFERFJFU1NGT1JUSEVOQVNJREVOVAAAAAACAQkQAQAAAJIKAACOCgAAWBcAAExaRnWO
cv37AwAKAHJjcGcxMjVyMgxgYzEDMAEHC2BukQ4QMDMzDxZmZQ+STwH3AqQDYwIAY2gKwHOEZXQC
0XBycTIAAJIqCqFubxJQIDAB0IUB0DYPoDA1MDQUIfMB0BQQNH0HbQKDAFAD1PsR/xMLYhPhFFAT
shj0FNCvBxMCgAKRCOY7CW8wGt/6ZQ4wNRwKHSEc3x3pG/T/HhIcfyBPIA0fjx2/HA8QYPwyOCXa
JvEmrye5G/Qn4r8mTyofKd0pXyePK1Q5DlAfLqQwASgjMAACgnN0eepsB5BoCeB0AAATUAPwUGRj
dGwKsVwyWGGYZGp1MXAFEGdoBUI7FjIMAWMJwDJgAzBzbnxleBcwB7AFsADAAnNzsQBQc2IyFFAx
YGET8PRcawngcAuQMj8yowhg6zKQC4BlMaB2OWABQDObvwwwNGQoADdABKALgGcn8ek05mJhFxBk
AiA1oDVG5zHQM5A7kSAxMTMOUDaf/zevOL8AUTn8AKA0bjx/PYb/MSQPwD6PP59Arw5QOe9DD9tE
Hz2zMwKCExBjNmBLoZMzkD2wdGk5kCBEARCoYXVsBUBQCsBhCcDgYXBoIEYCITYkJUDoZmktD5A4
AUA5MFAz60cPMqNiCyByCVBSUhag2VJSdzQlQRcAcAHQTXJ/M79Kn0umT9BOkAUQAjAtQ08wA2E6
IFRvV7BTKHViagWQdFewRGHodGU6NiQ2T/9RD1If/1MvVDkxwD2jDiFLoTq2DlCbVW9WflI5gRcB
IEg9kfsEkDYkN1lvWn9bj1ydOQ8vXb8PkGlwCNBiCrB0OP9J+g9URhBfv2DGagBh0AtQvHkvT0Bc
sAsRYkVzNiT/KABjP2RPZV9cr1RPa19sb+9tdVfSV3RYqTlvvzM/AzAdabM5c590r3qgRG9j/nUH
gAIwBdBPABoBeNJ4MPd4cHFRAYBuWDAAYAnwTaDvfQACATXgXlJlAPB9ADGAknAegFx2CJB3awuA
/mRrQICiBPAHQBBhAUAOAO9xIj2CggUCEG8FQhchEvINWMBtC1FYwCBDOly6XAXgTwEgDeB/8FyE
9tZFAMADEC5LcHR90BcQt3hwNSFncngBQH8BbjHQ9xrwhpRONGMDIBLzAIAFkPxsdkGhRtAOcDXg
iSIBkP8AIImygPF9QQHBiSEW4A9wzwAARtAM0AGQIC4aEokY/w5QidJOcHjAik+LX4xvD8DfRtAF
gY4Pjx+QL2xrQEbQ7myNz5KPk5UpjJwlQJFv45ZPk4RiICgCkZdviWP/WVCVH5nfmu+b/4mQYxCd
Qv+KH56vn7+MnCgAnU+iz6Pf/6TviZB4AKHPp1+ob6l0CvlvAzB4L3k/es17WKAxoCxrCoUKhUk9
cGFN8QORQXsE8H8BIBdwBHAOcAVAKDBNQVggFFAUQCksAiATUCBVU1IuIL2zUWeDQQrACGC0QXQx
0MYgBAEKUCBiebdAiUHfACA9wpPgiFWzUFCzwE2gDxrwBBF/cbcDTkFTSV+r8gaQCJG30bcDQwdA
bP8EIAGRMaCo4LNgAiBtMLN0WwIgujMgsNSvESm2EVS5h8IgbbCht6CzsSCIwN89kDVgBcBtkLfA
dLXAS3BntwEEALYRQW63wLdwZ85nB5BN0AIgcz/A8bvQfm+1kAQAtwK+sZPgwAIo3wBwNSAGkMFA
tcBoviHAMn+BkAUwCHATgE7AB+ALgHC/Z1CzwTUgZ0HFksBALwNSpwfwPaGwoE5UthFGC4D1u7F5
tZB5CGC+0LqiAiC/twO0cbwhxuDCkW7QeAmA57sixwZFYC4xthLColiw/72gPZG3wLnSGvC/kRcQ
wnHfA6C/MAGQtZAFsXfLscIBI75xAHBrc4V9gHJrP7KMrjSG8qwyrx+wL3tP+mu2E3cFsEagNSCT
4MlG72dwRqDAk8AxZMAQthLD4P/IQgrAE4CwoLhEteEKhbR1/7WQhTAAIK7CYfLBwryAw+CJtxFp
cgqFZXF1BSAffTMXELRB2WDCwiBCT5RUSLpCLbkgLUG5ZBootXAv27O6lygzMn/EYAWxsJIKhdzc
qODdwS7/soy+gbiQDeDBsgrAwCHLsu8FoAeCA/C3ECCF8ASQB0D8ZC/Khxbg2PG9QQbwNSB9MaBn
ANDh0juRCoUFoG7v2AE7ggqFwKRCg0BPINkUfxNx1hKBkTGgNSDc3LWQT/5StwK3wAPwu8C/Ihrw
YfN6ZOAWR07AqNC4gX0gcPcKhdkUs8BjBaC20LgzCrA+Y0agBUDGs07AuXFjdvvAMrmBcMHR1LEH
cdVz3n//uuQHodtwCoW7Ne40yCQ1YP/KIe9zx9AHgLcD4UPhhrXA+wDAiLBo4B/CkclG5AK/MH8J
8MnvyvO1kAdAwlD2nS1/V1AKhbIy4uC2EGHQ+RFKmnK2ESjVQDGgckAIkHRhLuJBKc+N0N/R73t/
zx/QL/+P0ko01DWgEvJizGttzqCrUiBffYCGINlYoWF9+4AHQU9JocfC931wuZFO0GUHQwHLrpZi
/f9vIAL/cL9xz2c/aE9pX2pvP7HUBUZXc4Pw7BH8L1tT0E1UUDr9W10I7wn0/267Cy8MPw1Pcr+x
XEoBBVXeU31BE9StcQVVVyYANWB2c9VBtZBBtHCGIEywMJO1kC/wOTc98DE6daF8UE0Bxh3ZdrEe
3ccGQPuEEOMTLv21Ie8eYVglI07fWNBOkbmg03E1IEXmEOHA/8TQwcEWj67SAr8DzxyPseN/Ac8r
PyxP0rPO0rPwthBLu6vALVJ3trBYweWFPrLmgTPQQklOR08hM2//s1jncbsBvTK50tXRthFXAP/J
YLwRw2As8rPA+HDMwcNgl8OSOGbsYWK2EVdow2D/wHG2Qe5xtxKDILvAL/E90V/iYQhSxcPN4rPA
dC0hYv8OkLcxruA807wEOqP0JmIgu8Zi4jFy7yGDUE3APzTujy8PMB/SHTPQU1FMWAAPvACEAR6S
s1BOU0VS08rwNJBUT7uVKLuiWKJULFW4AU700Sy6UVBr3gDX0EHtkHRFAvmwVL+AUbJ2QZ9Cr0O/
SIJEDuA9wBBU8EFIdLmRwcFJRHYsV3D00WQ30cBA7aBsB07F3CXEYFZBTFVFWb2QKEeDkFiiKLWA
J+Bqb2UnLHsgNOdvABf6IPogIOAnX5A5NTU5daA2N1IQ+iBTYDA3Oi5rMDDLIMswVtAzJ2P+JjPZ
T0RChJBEskXZ+QBjRNlwQCJFQADeAHszWBUwTYWgtrDCUH6QXf5bVnJEtOYwYfF84HngYfH7WVBZ
yF3hAk+BfSCu4Lpf/7wDWBi7pIYAw2A2gb8iieD/u8D2lkShfwHWckiB7bZIgO8yQNkRLlEhYDbE
c4WAELA4YjAzqOB1cNpAYXj2Mf4m5YVfZI9ln2avZ4vj5YVo9UlFQSbQWSFtkd3M8UnmELYRaPJ8
tiDHBh+1kOL1+jG0QcrhRkFR/nNolmpQd3DmQO5xabBcAP/Bs7nDdrDVQWrTtiAtYMYw0DovL3dw
IC4kz0mf/0qvS78BKHHPct/SHftxeH+/eY96nwiayngGstZyTLdQ/4NQfdgOsC0QuAHrESS+rXDP
Bca0MgaodNZ9AIIxgnAAAAMAEBAAAAAAAwAREAAAAAADAIAQ/////0AABzAAwU+3w1a8AUAACDAA
wU+3w1a8AQsAAYAIIAYAAAAAAMAAAAAAAABGAAAAAAOFAAAAAAAAAwAFgAggBgAAAAAAwAAAAAAA
AEYAAAAAUoUAALcNAAAeAAaACCAGAAAAAADAAAAAAAAARgAAAABUhQAAAQAAAAQAAAA4LjAAAwAH
gAggBgAAAAAAwAAAAAAAAEYAAAAAAYUAAAAAAAALABCACCAGAAAAAADAAAAAAAAARgAAAAAOhQAA
AAAAAAMAEYAIIAYAAAAAAMAAAAAAAABGAAAAABCFAAAAAAAAAwASgAggBgAAAAAAwAAAAAAAAEYA
AAAAEYUAAAAAAAADABWACCAGAAAAAADAAAAAAAAARgAAAAAYhQAAAAAAAB4AJYAIIAYAAAAAAMAA
AAAAAABGAAAAADaFAAABAAAAAQAAAAAAAAAeACaACCAGAAAAAADAAAAAAAAARgAAAAA3hQAAAQAA
AAEAAAAAAAAAHgAngAggBgAAAAAAwAAAAAAAAEYAAAAAOIUAAAEAAAABAAAAAAAAAB4APQABAAAA
BQAAAFJFOiAAAAAAAwANNP03AADQNw==
------ =_NextPart_000_01BC5689.DD726020--