RE: Emerald Won't Authenticate..

Erik Lundby ( (no email) )
Fri, 21 Feb 1997 14:37:57 -0600

Because there is a problem with your NAS and secret entries in your SQL
database. Go into administrator and take another look at you NAS ip
address and secret under radius. Just a guess but I had this problem when
i had mistyped an ip address.

-----Original Message-----
From: Ryan Smith [SMTP:ryans@logic-net.com]
Sent: Friday, February 21, 1997 2:20 PM
To: emerald@emerald.iea.com
Subject: Re: Emerald Won't Authenticate..

----------
> From: Dale E. Reed Jr. <daler@iea.com>
> To: emerald@iea.com
> Subject: Re: Emerald Won't Authenticate..
> Date: Friday, February 21, 1997 2:57 PM
>
> Ryan Smith wrote:
> >
> > After our recent fiasco here with SQL Server not installing fully, we
left
> > it as is, halfway installed but working. <sigh> It's very evident it's
not
> > 100% installed because when I run setup from the MSSQL dir, the only
> > options I can choose are top left three, install SQL, upgrade SQL, and
> > install utils. All the other options are grayed out. Anyway, I'll deal
with
> > that in a later message.
> >
> > I'm having the same problem Tim is, but on a PM2E. I *DO* have CHAP
turned
> > off already, verified it just now, and I rebuilt the Emerald database,
and
> > am trying to get a few "test" users in and running again instead of
using
> > Radius in text mode.. Whenever any user logs in, it says user not
found.
> > Even if the user is in the Radius users file, and i'm running in mode
2,
> > which seems odd to me. It's like, because the user is in ODBC, and it
FINDS
> > the user, it just won't authenticate it. Then because it FINDS the user
in
> > ODBC, it won't search for the user in the users file. So, I'm forced to
run
> > radius in mode 0 for a while until I get this one figured out..
>
> Run RadiusNT 1.16.60 in -x15 -b on the command line. Then auth the
> user. What
> does RadiusNT show for the decrypted password and the database
> password? The
> only other thing I can think of is to check the active flags on the
> account.
> Paste the authentication debug to me in email or here and I'll see what
> I can come up with.
>
> --
> Dale E. Reed Jr. (daler@iea.com)

Okay, running Radius -x15 -b on command line.. Here's the paste..

----------------
radrecv: Request from host c7e79210 code=1, id=70, length=63
User-Name = "ryans"
Password = "!\261\372\207\260\235k\027p\030\^\002G\326M"
NAS-Identifier = 199.231.146.16
NAS-Port = 1
NAS-Port-Type = Async
rad_authenticate_ODBC()
Password = "!\261\372\207\260\235k\027p\030\^\002G\326M"
Decrypted Password: =Nei?B+|5??2-+$?
Allocating Statement...

SQL Statement: Select DateAdd(Day, ma.extension, maExpireDate),
DateAdd(Day, sa
..extension, saExpireDate), sa.AccountID, sa.AccountType, sa.Password,
sa.Login,
sa.Shell From MasterAccounts ma, SubAccounts sa Where (sa.Login='ryans' or
sa.Sh
ell='ryans') AND ma.CustomerID=sa.CustomerID and sa.Active<>0 and
ma.Active<>0

Database Password: slayer
Freeing SQL Statement...
LOG: User: ryans Not found

User: ryans Not found
Sending Reject of id 70 to c7e79210 (pm1.logic-net.com)

Response Time: 71

---------------------------

That's a full page, and it just repeats it 4 or 5 times every attempt...
The Decrypted passwod isn't really the ascii garbage like that, it just
showed up like that in the radius screen.. Not sure why though..

Ryan Smith
ryans@logic-net.com
http://www.logic-net.com

begin 600 WINMAIL.DAT
M>)\^(CH4`0:0" `$```````!``$``0>0!@`(````Y 0```````#H``$(@ <`
M& ```$E032Y-:6-R;W-O9G0@36%I;"Y.;W1E`#$(`0V ! `"`````@`"``$$
MD 8`P $```$````0`````P``, (````+``\.``````(!_P\!````30``````
M``"!*Q^DOJ,0&9UN`-T!#U0"`````&5M97)A;&1 96UE<F%L9"YI96$N8V]M
M`%--5% `96UE<F%L9$!E;65R86QD+FEE82YC;VT`````'@`", $````%````
M4TU44 `````>``,P`0```!@```!E;65R86QD0&5M97)A;&0N:65A+F-O;0`#
M`!4,`0````,`_@\&````'@`!, $````:````)V5M97)A;&1 96UE<F%L9"YI
M96$N8V]M)P````(!"S !````'0```%--5% Z14U%4D%,1$!%345204Q$+DE%
M02Y#3TT``````P``.0`````+`$ Z`0```!X`]E\!````& ```&5M97)A;&1
M96UE<F%L9"YI96$N8V]M``(!]U\!````30````````"!*Q^DOJ,0&9UN`-T!
M#U0"`````&5M97)A;&1 96UE<F%L9"YI96$N8V]M`%--5% `96UE<F%L9$!E
M;65R86QD+FEE82YC;VT``````P#]7P$````#`/]?``````(!]@\!````! ``
M``````+I7P$$@ $`(0```%)%.B!%;65R86QD(%=O;B=T($%U=&AE;G1I8V%T
M92XN`/4*`06 `P`.````S0<"`!4`#@`E`#D`!0!<`0$@@ ,`#@```,T'`@`5
M``X`(P`W``4`6 $!"8 !`"$````P.#<Q,C8Y0S,P.$)$,#$Q.4(V.# P-# S
M,S,Q1C9!.0#4!@$#D 8`> P``"$````+``(``0````L`(P```````P`F````
M```+`"D```````,`+@```````P`V``````! `#D`X(+P'C<@O $>`' ``0``
M`"$```!213H@16UE<F%L9"!7;VXG="!!=71H96YT:6-A=&4N+@`````"`7$`
M`0```!8````!O" W'J2<)G$)BS 1T)MH`$ S,?:I```>`!X,`0````4```!3
M3510`````!X`'PP!````$ ```&5R:6M ;&EN:W5P+FYE= `#``80>TP+" ,`
M!Q @"@``'@`($ $```!E````0D5#0553151(15)%25-!4%)/0DQ%35=)5$A9
M3U523D%304Y$4T5#4D5414Y44DE%4TE.64]54E-13$1!5$%"05-%1T])3E1/
M041-24Y)4U12051/4D%.1%1!2T5!3D]42$523 `````"`0D0`0```%@)``!4
M"0``DA ``$Q:1G68!F*2=P`*`0,!]R "I /C`@!C@F@*P'-E=# @!Q.'`H,`
M4 [V<')Q,@_V)GT*@ C((#L);S(U9C4"@ J!=6,`4 L#8P,`00M@;F<Q,#,S
M20NF($(%D&%U#[ @''1H!) 6P 0`(&$@Q1% ;P)@96T@`_ 6X&P@>0AA![!!
M!? `<&2N( ^P!0`/P" )\'0(@0<$( N &%1344P@9 IA`9%A#[ N("!'BF\:
M$70;H&%D;0N OP0`&< :\ 6Q&/(!D&L6P)4`<&\6XB )`&]K%V#?!4 881BC
M!2 <`60)< 01G1CY=1D`'=$<D&1I%J#=&V%*%J %0!=P9PI0!!%D8G4%0$D@
M#X =$6CO%T$7EQ;P`Z!I(G,<,!QPW'EP"8 8X1[Y+@JB"H3#"H0+,&QI,S8!
M0!40*P% %Y%T!9!T$(0Q-M0@+2AR3P409PN !T#C!= ?<6%G92AS);8GA <G
M40L3)X9I+3$T-.,!0"0,3@P`4 ,T"P3J&(@1@-A.@R#8@_@-%)Y`Y%3'# 8
M,5M3($U44#IR+D%S0*,)`"CP8RUN#\ N!:#\;5TEM2U !F ","VG+6 2:1K@
M>2PM4&5B<D)U"L!Y(#(Q,D Q*#DY-S+@.A8Q4$UY,(=4;RVG%^ $D = 9&I
M-34N")!A,#(PB'4,8FHGL2VH93H@1:DU1"!7`B G!4!!(C#](Z%T+] :\!M0
M):<JGR>R7R;4"[8EPRAS*<D^+50@=D0'0!; 11M@.# DH4J:<AM@/!K@%]!R
M0#8U_CX]UC2!-2<V.SXP-S8X+W\Y/SWE/K GH$.0,>\R^37?,V SUCXP/=8N
M.7<G@BV@]SWE2,@^,$$!@!W1&'()</IC&:$@*^ ;, 6@(G 7`O<8$QJB!F%V
M'=$=D1H1''!O!T FT!5P3+!U3Q!&H7?^926T%] !@$IX&" 78!H!QG-&L ^
M;&9W1I!.MNLDH2(B=P6P:T\Q/Z$`D,1G:#XP270G!"!.0?DRT&5V1G!,@A@@
M5& EM.<=D4IX%9 P)5):%G4CD^\B8$<``Z /L74?$ -2%M+S!=$:HVER1K!9
MH@(@3Z#U2GAO!3!I`B $(")@%H#_`Z /<!X0%K$*P!;!6[ =\/\!<1;1"=%&
ML$[%&I)&L%D@_PG '! 6P%[#&/%0J5Y5(C#[`Q A$4%>D5J3';-;MET"/5\Q
M>22A"& P( _P;GGS4B%&L$DG7I$!``= );3_&!)*>!;@'E$:(1=P"V!+TO\'
M@2F"16=*^F2 %_ /@%3P_T]!6:(I@ > %X<'85&3(B(W`B 783/0,C\!(F J
M1 Q/*FE"%L!#2$%0?R6T61 $H F 6QD!(!=@;/\)<!P01J%.00:0") 9$%%!
M=FHA8AV0=U_#6()&X'7?`Q!=LC[A0\4:YBPEM%_K?VH0%M O0&F#&Z IH"&"
M9NT'T2(GH!QP(B!0#[ /H/]FDQD!6+$#`$]!*9 +<4ZSOV\1;I$EM!:@3S%G
MV%(@TWL:$B>@> 5 !&(Z$!MP5W\CH53@'=$`<#+0=A(=\6?O&@)>(05 *8!Y
M!"![\U8']P(0(&%GR45.0"/!;L!9HO][\Q=!>B)9L7FU=A0KX!?0?7"T:6DA
M=N8:(01B);0R_W+U2M(CD"_0&$ /L!?@!"#_!' =$1N@!X!L(512)M =4(=K
M,19X?^I/1$)#@?7!4)5&24Y$4V6Z?]3_?+-P,U- 1%(6D$2X43$;8/Y4(Z)7
MQE%!B5-_IR6T"X'_9^>(-%%!BV0/L K A-$"$)\%P'^X@(2!6!M@4V]D8O\7
M\)$Q3'"%@B6T6+%GV"#$_8,&( _@D3(7<(2A/M$@8/]A02)1=0(BPP(@%L K
MX"' /PEQ8Z-%9TCG6,%YM$Y4M3,@+BA +B<`&A(M+.#^-2A@+4!KD5FB,$$#
M@1D0_T\A&U*,TXO"%M(]UG82>O.S&O ]UF1O!Y&:IW-<H/\'X)$V!8$O0 4P
M)*$*L 00?U-!)+(BHJ'1&O4]UJ*6/_^=HSW66M)B%2+!3T%<-*:R_QXP;J 7
M,AOA#W %D!XP6:+W`- YL&S19@M@?&&<9#W6[P#0!:"7045G4!LPC&&HP_]$
MJ%OA9,$B('2S:B$:(1?@_PMP`R %L1;S<--DDH4!(X'_GZA<-0-P?]$?$!@2
MF5\H<%-(USZ_("@_VRDEND]^:T:2=N9YM9OIG-L;8$C_%P%485FBHI$Y^CS\
M/7H@P?5,479#4G$AT4RA66)<H,$A<6,W93<Y,O /X!L%H $`/3,!1G ]-S#/
M1K 7T!5P%N ]-A7 )<-+&W ;<%5V(2U.:A(]>W60+T,BP$BKL:+$P8$AD%Q<
M,C8`4%PS`< YPX$P-\."`4##D#,U0FO#@# R-W#%(3-MQ+%>Q2'%0$?#T<.@
M3?/""1BQ+4E5$F^B!<#!@.TS,2[$X)LQ-)M@*$#&W(Y0"1'(4LEO="U4)(%A
MP7%!<WEN`."\-E_UB\I?B#(HM87"?\./Q)\[Q:_&MD2B!\\F0Y ]7$0G9 !0
M)V4XU3%FB#]"*]3P838UU>&0,3\R+=72-#\EM.UAH6^LTD]!4P&0)Z '@/^K
M`;I,3<38)D.0!F 7T"? =47C01] *+. 1J$`P"X?>F$)\ "0`B#;LD5X</5:
M4&5%\BER]=L+*8 EM$_;^BF W-II\2Y!JL1)?D3@VLORX-//)G+UX/%,]R^Q
M?*#CEU,6\%Z1+6(%T/VKPG+A)00@`,!&L#<QYB>7*8![$A<1*./V/2<O0[XG
MKH'DB26TY3'HUBD/\%N)<-O"0R%AL1%RX9 ]G^#QZ]@8Y.$"J2(\/@_@?U_G
MV]'MUR6Z1?$;$]0Y<_\+8&-PCJ4M8 G@U]/9NMBG^$Q/1T.0P.)#D"]#![#_
M3I%^,R6Z]*_UN#$1(."W`GYE-V*GPQD0OW"H([Y&*#QP;9LP+ZNUBT-P<W#O
M6_$6P =B0Y WRK6ZS[LO_R7)C- :\%1A=4%/@:*!*:!_B'9P) EP)) :\!H!
M!4 T_ZZ"G! YL >">V(RT!KPV$&_T_#8IXS1LW"B#6_A<T12;V\!3Y&HM$SP
M:2/@=W!R_QL@*:"&4V9#BL?CE:$Q)*'_62$)!X!FE75,\!-B>N'W<OYSF,$C
M@0?"8[!4`+I,+CA_E$4O7S:6%1)/@")P!,!P\#HO+W<2P/KL)R-/@"OONR6Z
M?290`!80`P`0$ `````#`!$0``````,`@!#_____0 `',$#B6]8V(+P!0 `(
M,$#B6]8V(+P!"P`!@ @@!@``````P ```````$8``````X4````````#``*
M"" &``````# ````````1@`````0A0````````,``X (( 8``````, `````
M``!&`````%*%```<#@``'@`$@ @@!@``````P ```````$8`````5(4```$`
M```$````."XP``,`!8 (( 8``````, ```````!&``````&%````````"P`&
M@ @@!@``````P ```````$8`````#H4````````#``> "" &``````# ````
M````1@`````1A0````````,`"( (( 8``````, ```````!&`````!B%````
M````'@`)@ @@!@``````P ```````$8`````-H4```$````!`````````!X`
M"H (( 8``````, ```````!&`````#>%```!`````0`````````>``N "" &
M``````# ````````1@`````XA0```0````$`````````'@`]``$````%````
24D4Z( `````#``TT_3<``"8*
`
end