michael

Forum Replies Created

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • in reply to: Captive Portal has 2 accounting entries for one guest #54052
    michael
    Member

    I had a more detailed look on to the logs.
    The entries with the MAC as name are from the hostap, if a WiFi connect was made. I use WPA without Enterprise. I thought Radius request would only be made with Enterprise – but this is wrong. Therefor I found those entries in the Accounting. There does not exist a switch that allows to turn of the Radius for WiFi.

    I also had a mistake in my accounting class (post paid instead of pre paid). Now everything seems to work

    Regards,
    Michael

    in reply to: Read-only file system, but hdd not full #53997
    michael
    Member

    Try “df -i” may be you are out of inodes and you need to clear some log data.

    Regards,
    Michael

    in reply to: Accounting Class #53740
    michael
    Member

    Concerning the export did you had a look at this:
    https://www.zeroshell.org/forum/viewtopic.php?t=3295&highlight=

    I am not sure if it still works with the current release.

    I have a problem with the current release. In the accounting panel I have entries for the user and for the used MAC address (as User-Id). Therefore I can not decide which is the right entry to use. In my case it seems to be a combination of both.

    Do you also have 2 entries for one logged in user?

    Regards,
    Michael

    in reply to: How to export captive portal web log ? #53983
    michael
    Member

    Did you had a look at this:
    https://www.zeroshell.org/forum/viewtopic.php?t=3295&highlight=

    I am not sure of it still works with the current release.

    Regards,
    Michael

    in reply to: Exporting captive portal logs to Excel #52120
    michael
    Member

    Try this as Cron job to list all accounts with the name “roomxx”:
    pakRad(){

    echo “Cost;IP;Last;MAC;NAS;RX;TX;Time;Traffic;start;stop;room” >/tmp/log.csv
    cd /Database/var/register/system/acct/entries/
    for DIRNAME in `find ./r* -name MAC -printf “%h “`
    do
    echo ${DIRNAME} | sed -e”s/./(room..)/.*/1/”
    # awk ‘FNR==1{f++}{a[f,FNR]=$1}END{for(x=1;x<=FNR;x++){for(y=1;y>/tmp/log.csv
    awk ‘FNR==1{f++}{a[f,FNR]=$1}END{for(x=1;x<=FNR;x++){for(y=1;y>/tmp/log.csv
    echo ${DIRNAME} | sed -e”s/./(room..)/.*/1/” >>/tmp/log.csv
    done

    ftp yourFtpServer.xx< ftpUser
    ftpPassword
    put /tmp/log.csv ./log.csv
    quit
    EOF
    rm -f /tmp/log.csv
    }

    pakRad

Viewing 5 posts - 1 through 5 (of 5 total)