Community discussions

MikroTik App
 
thayer7
just joined
Topic Author
Posts: 20
Joined: Tue Feb 22, 2005 9:45 pm

Mikrotik + Freeradius Issue + MSSql (Platypus)

Sat Dec 21, 2013 7:09 am

We are attempting to migrate to the Platypus billing solution and are extremely close. We are having a random issue that we cannot figure out, hopefully someone can shed some light on what we are dealing with here.

90%+ of of the users are redirecting from Mikrotik to the Freeradius server which checks Platypus for MAC and Rate credentials perfectly, they come into the Mikrotik Host list with either an AH or AD and are then queued with their rate limit tag and authenticate with NO problems!!

However the other 10% give or take, do not authenticate. They come into the host list with just a "D" and will sit there and the user will just get the login page over and over. The only way that we have found to resolve the issue is to Knock them out of the host list, at this point 99% of the time they will come back in and then Authenticate.

I don't understand why this would be happening to certain users and we cannot figure out what those users have in common, as all of our users are setup the same.

Thanks for any help on this!
 
User avatar
MadEngineer
Member Candidate
Member Candidate
Posts: 135
Joined: Mon May 02, 2011 10:47 am
Location: New Zealand

Re: Mikrotik + Freeradius Issue + MSSql (Platypus)

Sat Dec 21, 2013 10:02 am

there should be an entry in the log along with a reason for the login failure on the web page
MTCNA
 
thayer7
just joined
Topic Author
Posts: 20
Joined: Tue Feb 22, 2005 9:45 pm

Re: Mikrotik + Freeradius Issue + MSSql (Platypus)

Sat Dec 21, 2013 8:46 pm

Sorry In which system? Mikrotik, Plat or Freeradius?
 
User avatar
OwenITGuy
just joined
Posts: 23
Joined: Wed May 09, 2012 6:04 am
Location: Iowa, USA & Bunia, DRCongo
Contact:

Re: Mikrotik + Freeradius Issue + MSSql (Platypus)

Mon Mar 10, 2014 9:19 am

Did you ever get this working? I'm struggling to even get FreeRADIUS to authenticate against the MS SQL Server database.
Owen Fuller
IT Specialist with Mission Aviation Fellowship in D.R. Congo
http://livinglifefuller.com
 
nerdtron
Member Candidate
Member Candidate
Posts: 123
Joined: Sat Nov 30, 2013 7:49 am

Re: Mikrotik + Freeradius Issue + MSSql (Platypus)

Tue Mar 11, 2014 3:32 am

Sorry In which system? Mikrotik, Plat or Freeradius?
When the user fails to authenticate, what is the error on the mikrotik log?
If mikrotik sends the credentials to the radius server, what is the error on the freeradius server?

Who is online

Users browsing this forum: msatter, Zacharias and 90 guests