RE: RadiusNT 2.2.41

Bruno A. Karoly ( (no email) )
Sun, 27 Jul 1997 22:58:57 -0400

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------ =_NextPart_000_01BC9AE0.AB58B300
Content-Type: text/plain

-x15 means just text files. In your RadiusNT administrator it looks to
me like you are also specifying and odbc source. You have to remove the
reference to the source to have text file only mode be ok. Screwed me
up plenty at first!

Hope this helps.

Regards,

Bruno
Bruno@queenbee.net
http://www.queenbee.net
ftp.queenbee.net
v 914.834.7834
f 914.834.7835

-----Original Message-----
From: Ronnie D. Franklin [SMTP:ronnie@itexas.net]
Sent: Sunday, July 27, 1997 10:53 PM
To: 'radiusnt@emerald.iea.com'
Subject: RadiusNT 2.2.41

This is my first attempt to get RadiusNT up and running
and it looks as though I am missing one piece of the puzzle
someplace....

Here is the response from -x15

=================================
Resp Time: 731 Auth: 0/2 -> 2 Acct: 1/0/0 -> 1
radrecv: Request from host cf16c605 code=1, id=3,
length=80
User-Name = "testradius"
Password =
"\324\2710\317P\225\2522O\214\353>\335`\336\262"
NAS-Identifier = 207.22.198.5
NAS-Port = 7
NAS-Port-Type = Async
User-Service = Framed-User
Framed-Protocol = PPP
rad_authenticate_ODBC()
Password =
"\324\2710\317P\225\2522O\214\353>\335`\336\262"

SQL Statement: Select DateAdd(Day, (ma.extension +
ma.overdue), maExpireDate),
DateAdd(Day, sa.extension, saExpireDate), sa.AccountID,
sa.AccountType, sa.Passw
ord, sa.Login, sa.Shell, sa.LoginLimit From
MasterAccounts ma, SubAccounts sa W
here (sa.Login='testradius' or sa.Shell='testradius')
AND ma.CustomerID=sa.Custo
merID and sa.Active<>0 and ma.Active<>0

Decrypted Password: testradiusnt
Database Password: testradiusnt
Checking for duplicate logins.

SQL Statement: Select Count(*) from CallsOnline Where
UserName='testradius' and
AcctStatusType=1

testradius found on-line 0 time(s).
Checking for port access.

SQL Statement: Select MaxSessionLength From Servers s,
ServerAccess sa Where s
.ServerID = sa.ServerID AND sa.Port=7 AND s.IPAddress =
'207.22.198.5' AND sa.Ac
countType = 'PPP - UA - 12 m'

LOG: ODBC: SQLFetch Error: (S0022)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid
column name 'AccountType
'.

ODBC: SQLFetch Error: (S0022)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid
column name 'AccountType
'.
ODBC: SQLFetch Error: (S0022)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid
column name 'AccountType
'.
Sending Reject of id 3 to cf16c605 (pm4.granbury)
LOG: User: testradius port Access denied
User: testradius port Access denied
SQL Statement: INSERT INTO RadLogs(RadLogMsgID,
LogDate, UserName, Data) VALUE
S (16, GetDate(), 'testradius', 'Server: Port:0')

ODBC: SQLExecDirect Error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid
column name 'Data'.

Resp Time: 681 Auth: 0/3 -> 3 Acct: 1/0/0 -> 1
=================================

Ronnie@itexas.net

----------------------------------------------------------
RadiusNT Mailing List
listserver@emerald.iea.com

------ =_NextPart_000_01BC9AE0.AB58B300
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64

eJ8+IjwCAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQWAAwAOAAAAzQcHABsAFgA6ADkAAAB/AQEggAMADgAAAM0HBwAb
ABYAOgA6AAAAgAEBCYABACEAAAA3NUI5MTNERjlBMDVEMTExOUE2ODAwNTA0RTAxMUNBRQAMBwEE
gAEAFAAAAFJFOiBSYWRpdXNOVCAyLjIuNDEAQAUBDYAEAAIAAAACAAIAAQOQBgAsEgAALgAAAAMA
NgAAAAAAAwAFgAggBgAAAAAAwAAAAAAAAEYAAAAAUoUAALcNAAAeAAaACCAGAAAAAADAAAAAAAAA
RgAAAABUhQAAAQAAAAQAAAA4LjAAAwAHgAggBgAAAAAAwAAAAAAAAEYAAAAAAYUAAAAAAAALAAGA
CCAGAAAAAADAAAAAAAAARgAAAAADhQAAAAAAAAsAEIAIIAYAAAAAAMAAAAAAAABGAAAAAA6FAAAA
AAAAAwARgAggBgAAAAAAwAAAAAAAAEYAAAAAEIUAAAAAAAADABKACCAGAAAAAADAAAAAAAAARgAA
AAARhQAAAAAAAAMAFYAIIAYAAAAAAMAAAAAAAABGAAAAABiFAAAAAAAAHgAlgAggBgAAAAAAwAAA
AAAAAEYAAAAANoUAAAEAAAABAAAAAAAAAB4AJoAIIAYAAAAAAMAAAAAAAABGAAAAADeFAAABAAAA
AQAAAAAAAAAeACeACCAGAAAAAADAAAAAAAAARgAAAAA4hQAAAQAAAAEAAAAAAAAAAgEJEAEAAAAX
DQAAEw0AALceAABMWkZ1Q1juWQMACgByY3BnMTI1cjIMYGMxAzABBwtgbpEOEDAzMw8WZmUPkk8B
9wKkA2MCAGNoCsBzhGV0AtFwcnEyAACSKgqhbm8SUCAwAdCFAdA2D6AwNTA0FCHzAdAUEDR9B20C
gwBQA9T7Ef8TC2IT4RRQE7IY9BTQiwcTFeQ2EY4yMzgXVKIgB20gQ0UV5Dcaf6cUQBuvHLV5chXk
ORGOrxpQFjEe/wOCRwnRawKD3wwBIP8OUCIvA3NUCHAj1LsWMSENOBphJZ8DgkIHQP50DeAj1CVh
FmwbeAcTHQb/G3Aq/x63LJUgVQ4wFk4h6P8slCOJGmEwTiVmLJQm5x2RvzBNKJcslComApEI5jsJ
b+owOL9lDjA1Oeo7ATq//zvJOdQ78jpfPi897T1vO5/zOe8QYDI4Q7pE0USPRZn/OdRFwkQvR/9H
vUc/RW9JNH45DlBMhE3hRgNN4AKCc6h0eWwHkGgJ4HQAAEMTUAPwZGN0bAqxXGFQOGFkanVPUAUQ
Z+5oBUIWMgwBYwnAUEADMPBzbmV4FzAHsAWwAMDFAnNzAFBzYjIUUE9A0mET8FxrCeBwC5BQH69Q
gwhgUHALgGVPgHZXQP8BQFF7DDBSRBuQVSAEoAuApmdF0VLGYmEXEGQCIJ9TgFMmT7BRcFlxIDFP
E/8OUFR/VY9WnwBRV9wAoFJO/1pfW2ZPBA/AXG9df16PDlBvV89g72H/W5MzAoITEGM/VEBpgVFw
W5AqUFdwIERJARBhdSpAIFAKwGHBCcBhcGggRgIhVATpMBFpLQ+QOAFAVxBuE+tk71CDYgsgcglQ
cDIWoNlwMnc0QyEXAHAB0GtSf1GfaH9phm2wbHAFEAIwLSttEANhOikQb3WQU3UUYmoFkHR1kERh
dPxlOlQEGmFt/28PcB9xL/9yN0+gW4MOIWmBWJYOUHNPzXReUldhFwEgSFtxBJD/VAQdkXdveH95
j3qbVu97n5cPkIdQCNBiCrB0OGfafw9UY/B9n36mh+B/sAtQed4vbSB6kAsRgCVzVAQbkf+BL4I/
g096n3I/iU+KX4tkf3WydVR2iSDQja9RL4eEOYeRf5KPmIBEb2N1B4D/AjAF0GzgaraQhGuVDGAJ
UI5jJBCZiGsxSHlwBJD7hVEjwX2WspYQllCPMQGA/m52EABgCfBrgJrgAgFTwH18MmUA8JrgT2Ce
QA5QdukIkHdrC4BkHsChogTwzwdARjEPwKGiemsOUA4A748CW2KjhQIQbwVCFyES8h12oG0LUXag
HQA6XFz1dOBvbMFtbRADEAeQpjAmTQ3gA2BzbwGAIE/XASAN4KDwXKfmRQDAAxD6LmlQdJ7QFxCW
UFMBhVLueGQRqaJsFGMDIBLzAID5BZBsdl+BZLAOcFPAq4L/AZAAIKwSofGbIQHBq4EW4J8PcAAA
ZLAM0AGQIC438v+reKNxrEEqQJagrK+tv67Pvw/AZLAFgbBvsX+yj2wewN1ksGywL7TvtfUprvww
EMezz7ivteRiICgCkbnP/6vDGmC3f7w/vU++X6vwHZD/v6Ksf8EPwh+u/BuQv6/FL//GP8dPq/Ag
0MQvyb/Kz8vUHwr5AzCWD5cfmK17LXhvdLEHgAYi0vIgdqBTYCBDjLBPgS4gIEkDoHmPCGEH8FuB
0wBOVCDS0H5tC4AEANMgdpAFsWugIHkJAG9rBCDYENTR2HBpX2SA1oLXYDjQ12Bsp5Ag95BgBZAG
kHlbogBwUwAEcLxiY9pQCGGoINYxWdmh/xbga9HY4TjQBGDckk+w3OH7EFA40G6oINjS3WLbpNjS
b9x01abbQMigedTQBHEg6mLgIWvWMVMFAAfQCYDx2QJ1cCALUJsh4HB2kDPV0RcAdCEKhQqFSG//
nkDdUQQAW1HR4NYg40x/sBJnCxFzLONMQnJ17xNQCoUCkgiQbAswD0Brgb0AIHkS8uixC4DVYXuA
IABZUEVSTElOS5fU0KkB2BA652NAcQpQfwnw4ODb8FNABUACkBLyZB12kGHoU1hxC4A5NyAAANDJ
6nn5us4AEYyCAKoAS6moCwIA7uAD7uHg7e0CNO7hbQBhAGkAAGwAdABvADoAgEIAcgB1AG7xIWhA
AHHxoWXyYfHQYv3yYy7xwfJw8RDu4DfwApL/6IAXAGxRCMEL8pz16y+pYB838ee/6M/p3NNgdHA6
6C8vd/pQLuuP7J90wNftz+7f/XUy/fFo8QHxEOpw8UEvADF3AHPzMPI///NFAEDzv/TK+e/2T/df
+G8/6kWfkASiCSH6j/ufOTPX/M/93wyWMA0hZv/ZDtQ/AO8B/wMPnQQJjgXpdiBAOTE0LjgzFXA3
6xWRBiVmFUo1BibQo9Ff/9Jv6dHjTBfWhVDOkhhfGW+P9KFS0p4Aq1Jia23YsDnNsiBfm2CpEHaB
YX26LSByT2eB0TA3UU3WEPlkMGdlIHMXa9D2gN2NAP8cL46fj6+FH4Yvhz+IT9Q01x52dVOlcGHL
MFJpYM4gL2vh1jB1UNsQayfhIFtgU01UUDqncC2CQO9roFNQaSAKQl0iHyMkjJt/JF8lbyZ/kJ/T
vGfhHoVTP5shLQQGkTem54D7wHkszCBKbEDikDI3ObCV0JPtkZ3wOjUL4FBNBih3N4eUkThtJ2yg
1wLQEEAnpZBZQKKgZC6hsGEu+mOU8Cc7PzkydhQ4bdbn5DIuQlA0MTAf0TIb738c/zYf1EMGKDv2
5ILkkW3/4pDi4+KhpYLVcdjwIaCk0P/W5+IR2xLncVli2wPYV2kg/91RJ7BnoNZQ12CmsNeQIXD3
W6JpYKXwcKGw3hGnoN1T8HB1enrgEaeQ2RClsf/b4VBh403d0UjS3WQ1UGlgtYABZnVhINSS40w9
VE9vVU3llzVQlIBp2RB1kDekMzHWQCBBJ8BodZBkMC+dQC0+Y0BXsWP5dkIxL1gwngBYcUKmPZH5
3aBjdnWQf7AJwdVhUtPvTSDVYZ0gdyBjZFD8sD7gmc5QPTE5sESQPTM5sHXiUWfdYD2NAAYlXlJV
MYAAci1OpqCl8D0g7iJ2oNfS1wIiXflsgCFwXnfYIEwwX0GmMDOJEVzvOiCd8GGRgOBQYeF8sGHh
ejV9cE9h4RVgYZE64D47YZEXQGBkEncwYfA2MsFgGk5BUy1JzlLaoOehsFQhWJAwN0JgQlCV0Ow4
LhdWZZZQ2CCk0F9AZjdnrwdwLVSeMV8xQdxzed4AXf44EHKhoN4R519ALgHZEGQtXqJd+Wy136ZR
2BA+4KswX0BQbzBZ2D5fquDdYWZBopB2oF9P4ERCQygpYC9hP2JPz2NfZG/jl+FQUUzhUAsQv6WB
OCI4ASggRLCVI0GcYNYolTA5oSio8C5+4Qnw004AfnAgK+qhLt0hpHDNCdApObCo8EV4TpDdoP+V
MnsABiV4myGAeZh9Mntaz31CWNEnsNAQSUR/CmpS330zcfMGJXJBfTNMpnDRMNV9M1PkwWyCKExX
INhRvyzCm1FGAIwAf1VI8WE5sO9AUYUXIYDWQFcGJeTA2eHSKIJGPSdfeCeB4YLXpYhLKVfATkR6
UkNF8fVP4XJ/wD19UYszBiWLg+fbA38jnJI8Pp4A2xJ5ceuNp3ZNRECQcp4wlVBMMP9x9pUQX3jQ
EI+37MGZspDPdZHbQ+TAY6HhS/CgcSD/etClsHCD2HEg8eUOdy94NLJDf4IoKoqgUtNDoqD92iBP
yKAn8YbQh2Neol7y/4hM2xFd9ljSmCLXIGpSXMC/lv1eU194lZE5YeAxLZqT70GgjtDZEIewKeUW
lRtScP8foVAwqCAhcJbvl/94UoSw7ng4EE3xTlBMXXNt8lLx/2wSbCCGgYXBp5NY0SFhhpL9muRz
BiWDAKeTjQFfQILib6o2isKBAmihPe2gq5MuvElQeNFSQeSgX0AnZur/iQCrlVjQBiWAV61ibzFT
EHVekEGwgTETYD8HBiVMvE9HWrBw4ngBpMBGL+BSY01gRXJukHJasCjOUyngc+BxN1tNbFBukPNP
0AmAXVtw4qSkp5MtwK9GIHqhtXC16F3WYHaaMHNHQW7RdW3RQCEQ2REn+4A5BiUn5R2yj7OftK+1
v/+2z7ffuO+5+7s/vE+9X75v/79/wI/Bn7n7OBEpklrBQIIfTuJHQQvg2OFb9yhwbdcVcEcg2xBi
3tB5cTayM/9eopPKovSolWYhBtCcxs+P79CfnMekvepwUwiw11DqcExUT0qCgnFzKNaETfxzZ3/C
gnF4kjmwm0Y5sAMgIoqgIFZBTFVF78tGeVBcEDmwRy/geJJxID85sIha2zGnhFqwaJI6MN+KkLpf
w6R7UECQRHuBeGH/xGTFT8Zfx2/If8mGICK6PvlWyTY4V5oL4FhxC+BYz/9T3+nfVfvlVi8OsVxd
9iBz/+7v7//xDyH3Sogf4kvShAD/CDH0GCfgRgBtMXqhPh4e9ifLwR/JBiZ9APhgAAMAJgAAAAAA
AwAuAAAAAAALAAIAAQAAAB4AcAABAAAAFAAAAFJFOiBSYWRpdXNOVCAyLjIuNDEAAgFxAAEAAAAW
AAAAAbybAlqkNVOB4wbuEdGHIABQTQAAJgAAQAA5APAnMTECm7wBAwDxPwkEAAAeADFAAQAAAAYA
AABCUlVOTwAAAAMAGkAAAAAAHgAwQAEAAAAGAAAAQlJVTk8AAAADABlAAAAAAAMA/T/kBAAAAwCA
EP////8CAUcAAQAAACsAAABjPVVTO2E9IDtwPVFORVQ7bD1QT0xBUklTLTk3MDcyODAyNTg1N1ot
MzMAAAIB+T8BAAAATwAAAAAAAADcp0DIwEIQGrS5CAArL+GCAQAAAAAAAAAvTz1RTkVUL09VPVBP
TEFSSVMuUVVFRU5CRUUvQ049UkVDSVBJRU5UUy9DTj1CUlVOTwAAHgD4PwEAAAAGAAAAQnJ1bm8A
AAAeADhAAQAAAAYAAABCUlVOTwAAAAIB+z8BAAAATwAAAAAAAADcp0DIwEIQGrS5CAArL+GCAQAA
AAAAAAAvTz1RTkVUL09VPVBPTEFSSVMuUVVFRU5CRUUvQ049UkVDSVBJRU5UUy9DTj1CUlVOTwAA
HgD6PwEAAAAGAAAAQnJ1bm8AAAAeADlAAQAAAAYAAABCUlVOTwAAAEAABzAgF28wApu8AUAACDAg
lWMxApu8AR4APQABAAAABQAAAFJFOiAAAAAAHgAdDgEAAAAQAAAAUmFkaXVzTlQgMi4yLjQxAB4A
NRABAAAAPgAAADwzMUE4Q0U0M0ZBQjhEMDExOUE0MDAwNTA0RTAxMUNBRTAyMTMyNUBQT0xBUklT
LlFVRUVOQkVFLk5FVD4AAAALACkAAAAAAAsAIwAAAAAAAwAGENVil4IDAAcQHgkAAAMAEBAAAAAA
AwAREAAAAAAeAAgQAQAAAGUAAAAtWDE1TUVBTlNKVVNUVEVYVEZJTEVTSU5ZT1VSUkFESVVTTlRB
RE1JTklTVFJBVE9SSVRMT09LU1RPTUVMSUtFWU9VQVJFQUxTT1NQRUNJRllJTkdBTkRPREJDU09V
UkNFWU9VAAAAAAIBfwABAAAAPgAAADwzMUE4Q0U0M0ZBQjhEMDExOUE0MDAwNTA0RTAxMUNBRTAy
MTMyNUBQT0xBUklTLlFVRUVOQkVFLk5FVD4AAACjiQ==

------ =_NextPart_000_01BC9AE0.AB58B300--