Find the answer to your Linux question:
Results 1 to 2 of 2
Hi Experts, We are a small club at the university and want to enable internet access for our members using a VPN tunnel to the university net. So far, every ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    May 2009
    Posts
    2

    Question How to log user IP traffic per MAC in DB?


    Hi Experts,

    We are a small club at the university and want to enable internet access for our members using a VPN tunnel to the university net. So far, every user had to request his/her own VPN user account. However, some members are not enrolled there and thus are unable to get an account. So we want to use internet connection sharing using a single VPN tunnel. I managed to install openwrt (linux based router os) on an asus 500gl premium (router), to establish a VPN tunnel using VPNC, and to restrict access via MAC filter. So we have a working VPN endpoint. Additionally, it is required by the net administration to log all IP traffic and to relate it to individual users (via MAC). MAC spoofing is not considered an issue. So my question is:
    How to accomplish best IP traffic logging on a per user/MAC basis?
    How to store the logs in an external DB (mySQL)? This is required as we do not want to use the router's flash as the continuous delete/write cycles are likely do destroy it after some time. In memory DB is also no option as a power-cycling could be done easily by users acting in a bad faith.
    Any ideas/suggestions/hints?

    Thanks in advance
    fatzopilot

  2. #2
    Just Joined!
    Join Date
    May 2009
    Posts
    2

    Cool

    OK, I tried the following howto

    oldwiki.openwrt.org/iptablesULOGmysqlHowTo.html

    but when I

    >insmod ipt_ULOG

    I get an:
    cannot insert '/lib/modules/2.6.25.17/ipt_ULOG.ko': invalid parameters (17): Invalid argument (all packages are installed, inlcuding ipt_ULOG).

    Any ideas how I might proceed?
    Thanks
    fatzopilot

Posting Permissions

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