Page 2 of 7 FirstFirst 1234 ... LastLast
Results 11 to 20 of 70

Thread: 100% Works Ubuntu 12.04 LTS + Freeradius + Coova-Chill + daloRADIUS

  1. #11
    Join Date
    Feb 2013
    Beans
    9

    Thumbs up Re: 100% Works Ubuntu 12.04 LTS + Freeradius + Coova-Chill + daloRADIUS

    Quote Originally Posted by laughmo View Post
    Edit radius.conf file
    To do this, edit /etc/freeradius/radiusd.conf and pretty much ignore everything except around about line 640 in the modules section uncomment or make sure that you have,

    $INCLUDE sql.conf

    and then further down make sure you have,

    $INCLUDE sql/mysql/counter.conf

    Then further around line 710 in the instantiate section make sure you have,

    chillispot_max_bytes
    noresetcounter


    which are our counters which we define in the next section. Then in /etc/freeradius/sites-available/default, in the authorize section after it has the "Look in an SQL database..." it has an "sql" entry that may be commented out so uncomment it and add the new counters so that it is now,


    sql
    chillispot_max_bytes
    noresetcounter

    That should be it. Now update the counter.conf in the next section.

    FreeRadius SQL counter.conf settings needed
    To match the radcheck and radgroupchecks we use then you also need to add two matching counter.conf checks as follows. Edit the /etc/freeradius/sql/mysql/counter.conf file (unless the counter is already defined in that), add the following at the end,

    sqlcounter noresetcounter {
    counter-name = Session-Timeout
    check-name = Session-Timeout
    reply-name = Session-Timeout
    sqlmod-inst = sql
    key = User-Name
    reset = never
    query = "SELECT SUM(Acctsessiontime) FROM radacct WHERE UserName='%{%k}'"
    }

    sqlcounter chillispot_max_bytes {
    counter-name = ChilliSpot-Max-Total-Octets
    check-name = ChilliSpot-Max-Total-Octets
    reply-name = ChilliSpot-Max-Total-Octets
    sqlmod-inst = sql
    key = User-Name
    reset = never
    query = "SELECT SUM(AcctInputOctets) + SUM(AcctOutputOctets) FROM radacct WHERE UserName='%{%k}'"
    }
    i encountered a problem after following the above instructions.
    i can no longer start freeradius.

    root@cportal:/etc/freeradius# /etc/init.d/freeradius restart
    * Stopping FreeRADIUS daemon freeradius
    * /var/run/freeradius/freeradius.pid not found... [ OK ]
    * Starting FreeRADIUS daemon freeradius [fail]

    please help me solove this.. thanks.

  2. #12
    Join Date
    Feb 2013
    Beans
    9

    Thumbs up Re: 100% Works Ubuntu 12.04 LTS + Freeradius + Coova-Chill + daloRADIUS

    Quote Originally Posted by laughmo View Post
    Edit radius.conf file
    To do this, edit /etc/freeradius/radiusd.conf and pretty much ignore everything except around about line 640 in the modules section uncomment or make sure that you have,

    $INCLUDE sql.conf

    and then further down make sure you have,

    $INCLUDE sql/mysql/counter.conf

    Then further around line 710 in the instantiate section make sure you have,

    chillispot_max_bytes
    noresetcounter


    which are our counters which we define in the next section. Then in /etc/freeradius/sites-available/default, in the authorize section after it has the "Look in an SQL database..." it has an "sql" entry that may be commented out so uncomment it and add the new counters so that it is now,


    sql
    chillispot_max_bytes
    noresetcounter

    That should be it. Now update the counter.conf in the next section.

    FreeRadius SQL counter.conf settings needed
    To match the radcheck and radgroupchecks we use then you also need to add two matching counter.conf checks as follows. Edit the /etc/freeradius/sql/mysql/counter.conf file (unless the counter is already defined in that), add the following at the end,

    sqlcounter noresetcounter {
    counter-name = Session-Timeout
    check-name = Session-Timeout
    reply-name = Session-Timeout
    sqlmod-inst = sql
    key = User-Name
    reset = never
    query = "SELECT SUM(Acctsessiontime) FROM radacct WHERE UserName='%{%k}'"
    }

    sqlcounter chillispot_max_bytes {
    counter-name = ChilliSpot-Max-Total-Octets
    check-name = ChilliSpot-Max-Total-Octets
    reply-name = ChilliSpot-Max-Total-Octets
    sqlmod-inst = sql
    key = User-Name
    reset = never
    query = "SELECT SUM(AcctInputOctets) + SUM(AcctOutputOctets) FROM radacct WHERE UserName='%{%k}'"
    }
    i encountered a problem after following the above instructions.
    i can no longer start freeradius.

    root@cportal:/etc/freeradius# /etc/init.d/freeradius restart
    * Stopping FreeRADIUS daemon freeradius
    * /var/run/freeradius/freeradius.pid not found... [ OK ]
    * Starting FreeRADIUS daemon freeradius [fail]

    please help me solve this.. thanks.

  3. #13
    Join Date
    May 2011
    Beans
    19

    Re: 100% Works Ubuntu 12.04 LTS + Freeradius + Coova-Chill + daloRADIUS

    eth0 is your internet interface. you have to set it either on dhcp or static ip

  4. #14
    Join Date
    May 2011
    Beans
    19

    Re: 100% Works Ubuntu 12.04 LTS + Freeradius + Coova-Chill + daloRADIUS

    can you start freeradius in debug mode
    #freeradius -X

    and paste the output you get. there is a line which will point out the error

  5. #15
    Join Date
    Feb 2013
    Beans
    9

    Re: 100% Works Ubuntu 12.04 LTS + Freeradius + Coova-Chill + daloRADIUS

    Quote Originally Posted by laughmo View Post
    can you start freeradius in debug mode
    #freeradius -X

    and paste the output you get. there is a line which will point out the error

    thanks for the response..

    after issuing the command #freeradius -X it indicated that there are too many closing brackets in my counter.conf file..

    i deleted the excess bracket at the end of the file and was able to start freeradius again..
    thanks a lot..

  6. #16
    Join Date
    May 2011
    Beans
    19

    Re: 100% Works Ubuntu 12.04 LTS + Freeradius + Coova-Chill + daloRADIUS

    nice one!

  7. #17
    Join Date
    Feb 2013
    Beans
    9

    Re: 100% Works Ubuntu 12.04 LTS + Freeradius + Coova-Chill + daloRADIUS

    good day!

    do you in any way have a manual for configuring the daloradius web manager?

    can we add users that can also administer daloradius say for example adding vouchers and viewing bills and accounts but not necessarily as powerful as an administrator? i'm referring to cashiers or managers. thanks for your help...

  8. #18
    Join Date
    May 2011
    Beans
    19

    Re: 100% Works Ubuntu 12.04 LTS + Freeradius + Coova-Chill + daloRADIUS

    i dont have a MANUAL but yes you can add admin daloradius users. when you login, go to Config>Operators>New operator
    this will allow you to add admin users and set their permissions

  9. #19
    Join Date
    Feb 2013
    Beans
    9

    Re: 100% Works Ubuntu 12.04 LTS + Freeradius + Coova-Chill + daloRADIUS

    thanks i tried it as soon as i read your post. vey helpful!

    if i may, i'd like to ask more questions. thanks in advance.

    i read these posts in the daloradius discussions:

    https://sourceforge.net/projects/dal.../topic/3311600 https://sourceforge.net/projects/dal.../topic/3307738


    are these issues already solved with the last set of instructions in this thread?
    id like to know because i really dont have an idea on what the last instructions do. im referring to those instructions wherein we set the sqlcounters in the counter file.. thanks

  10. #20
    Join Date
    May 2011
    Beans
    19

    Re: 100% Works Ubuntu 12.04 LTS + Freeradius + Coova-Chill + daloRADIUS

    yes the sql counters in my howto address all these and the user will be limited on either time or bandwidth.
    there is however no documentation on these. i hope i can document this in another HOWTO

Page 2 of 7 FirstFirst 1234 ... LastLast

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •