2020-10-08 - Re: [GRASE-Hotspot] Simultaneous-Use

Header Data

From: Christopher Gregory <ch***y@mail.com>
Message Hash: 99276c298a65020073c59a95ffe8126c118d569a2e064c4f06455451886f66cc
Message ID: <trinity-de4024d9-d2f1-4f92-921b-ab8347d9ed62-1602198642164@3c-app-mailcom-lxa10>
Reply To: <trinity-2fd59a99-2982-45ac-bb66-918cc472dfd2-1601319320189@3c-app-mailcom-lxa12>
UTC Datetime: 2020-10-08 16:10:42 UTC
Raw Date: Fri, 09 Oct 2020 01:10:42 +0200

Raw message 

Hello Tim,

After many battles, I seem to have managed to get this to work correctly.  I have no idea at this stage what *exactly* made it work, but it is indeed now showing in radius.log that people are being rejected.

The thing that was constant with it not working, was the warning that the "sql" module was being ignored when freeradius started up.  Now I only get the warning that the "ldap" module is ignored, which I am not using anyway.

If it would assist you in getting it working for this version of freeradius, I am more than willing to upload the conf files to pastebin so that you can perhaps test it on your dev box when you have time.  I can even provide a dump of the current mysql database if you need it, though as I have stated below, I have added every user-account to the radcheck table, by adding a new column to accommodate it.

I just wish I knew what the final "solution" was.

I even upgraded from freeradius 3.0.17 to 3.0.21 as this is available in the buster-backports.

Regards,

Christopher.

> Sent: Tuesday, September 29, 2020 at 7:55 AM
> From: "Christopher Gregory" <ch***y@mail.com>
> To: gr***t@grasehotspot.org
> Subject: [GRASE-Hotspot] Simultaneous-Use
>
> Hello Tim,
>
> I have been fighting to get Simultaneous-Use working for a few days now, and what I have done does not seem to be working, even though the freeradius 3.0 docs and forums/mailing lists that I have scoured state that it does.
>
> I am going to outline what I have done, then move onto what I have discovered in your graseperl script.
>
> I first added the Simultaneous-Use := 1 line into the radgrooup check in the freeradius database, like you had in the previous version.  That in itself did not work, so it was at that point I went hunting for how to make it work.
>
> I also have added a new "column" to radcheck in the database and added every user there to have the Simultaneous-Use := 1 in there.
>
> Then on one of the freeradius groups, someone said that they added the following to /etc/freeradius/3.0/users file:
>
> DEFAULT Simultaneous-Use := 1
>         Fall-Through = Yes
>
> Even this does not appear to work.  From the notes in the file DEFAULT is a special group that applies to all users, so it should have worked.  I notice that you have defined DEFAULT_GRASE in your files.  I am not sure if that overrides the DEFAULT group or not, so I even tried adding DEFAULT_GRASE but that did not work.
>
> After taking a look at your graseperl script, I notice that there is a function for checksimul, but that along with all but two functions are commented out.  From looking at the sql_counters.pl file in the perl-modules the database connection is commented out.
>
> I have no idea at this stage if simultaneous use still has to have more coding done by you to work.
>
> I have enabled radutmp in the configuration, as I am not sure if a database lookup is being performed or not.  Before activating this, radwho showed no connections,  now it shows the logged in users.
>
> I am somewhat confused by the documentation stating to include the "sql" module in the session, accounting and post-auth sections, as you seem to be mostly using your own grasesql and adding -sql to conditionally load the module results in some rather spectacular failures.  Granted this is probably due to me not being a programmer.
>
> Regards,
>
> Christopher.
>
> --
> This mailing list is for the Grase Hotspot Project http://grasehotspot.org
> ---
> You received this message because you are subscribed to the Google Groups "Grase Hotspot" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to gr***e@grasehotspot.org.
> To view this discussion on the web visit https://groups.google.com/a/grasehotspot.org/d/msgid/grase-hotspot/trinity-2fd59a99-2982-45ac-bb66-918cc472dfd2-1601319320189%403c-app-mailcom-lxa12.
>

Thread