Re: (RADIATOR) EncryptedPassword Problem.

1999-08-09 Thread Hugh Irvine


Hi Cameron -

On Mon, 09 Aug 1999, Cameron Andrews wrote:
 Hi guys,
   Got a small problem,  below is my AuthSQL with my AuthSelect in it, but
 for some reason the encrypted passwords dont appear to be working, people can
 login supplying anything for their password, could someone please show me what
 to do to fix this little problem, thanx..
 
 AuthSelect select ENCRYPTEDPASSWORD, concat('Expiration = 
',FROM_UNIXTIME(TERM_DATE,'%%b %%d %%Y')), if(IPNUMBER,concat("Framed-IP-Address = ", 
IPNUMBER), concat("Framed-Group = ", IPGROUP)), CHECKATTR, REPLYATTR from SUBSCRIBERS 
where USERNAME='%n'
 EncryptedPassword
 AuthColumnDef 1, Expiration, check
 AuthColumnDef 2, GENERIC, reply
 AuthColumnDef 3, GENERIC, check
 AuthColumnDef 4, GENERIC, reply
 AddToReply 
Service-Type=Framed-User,Framed-Protocol=PPP,Framed-Routing=Broadcast-Listen,Framed-MTU=552
 

I don't think there is anything wrong with your AuthSelect, rather your users
file or SQL database has a DEFAULT user in it without a password. Please
send us your config file (no secrets) and a debug trace (level 4) so we can see
what is happening.

hth

Hugh

--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8,
NT, Rhapsody

===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.



(RADIATOR) EncryptedPassword Problem.

1999-08-08 Thread Cameron Andrews

Hi guys,
Got a small problem,  below is my AuthSQL with my AuthSelect in it, but
for some reason the encrypted passwords dont appear to be working, people can
login supplying anything for their password, could someone please show me what
to do to fix this little problem, thanx..

AuthSelect select ENCRYPTEDPASSWORD, concat('Expiration = 
',FROM_UNIXTIME(TERM_DATE,'%%b %%d %%Y')), if(IPNUMBER,concat("Framed-IP-Address = ", 
IPNUMBER), concat("Framed-Group = ", IPGROUP)), CHECKATTR, REPLYATTR from SUBSCRIBERS 
where USERNAME='%n'
EncryptedPassword
AuthColumnDef 1, Expiration, check
AuthColumnDef 2, GENERIC, reply
AuthColumnDef 3, GENERIC, check
AuthColumnDef 4, GENERIC, reply
AddToReply 
Service-Type=Framed-User,Framed-Protocol=PPP,Framed-Routing=Broadcast-Listen,Framed-MTU=552

Thanx for your help.

 --
Regards,
Cameron Andrews.

--
SysAdmin for: Soft-Tech Information Services / Brisnet Star Hub
  http://www.st.net.au / http://www.star.brisnet.org.au

 And: My personal project,  Darkrealm.net
  http://www.darkrealm.net

===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.