Export Rflow Collector logs to a web site

From Swallow-Wifi-dashboard
Jump to: navigation, search

Export Rflow Collector logs to a web site

Contents

Foreword

DD-WRT Firmware users know that there is several method to retrieve connexion logs from their routers.
This topic is about using Rflow collector Daemon embed in most of DD-WRT firmware
First of all, here is the DD-WRT wiki url descriebing how to use Rflow Collector:
DD-WRT_Rflow_Collector_Howto

The Rflow Collector Server side, even if providing extend syslog, did not provide web UI but just the availabilty to browse localy log on the Collector Server.
Rflow Collector embed a Mysql exportation module. With this module we are going to filed the databse that will be browse by our web UI.

Pré-Requisit

  1. To have an AMP Server (Apache,Mysql,PHP).
  2. To be able to create and manage mysql users and location
  3. you should download the web site zip file ( Clic Here )

Installation

Once you downloaded the zip file deflat it in the web directory. As result you should see a new web directory call "Rflow_Collector_SQL"
contening  all required files fr the web site.
Check out that this directory is write enable, at least for Apache User (www-data).
Your Mysql server should listen for any queries, not onlye local one.
With your Web browser load the web ui. At first time you should be redirected to the installation script.

File:install_rcs.png

Filed in the form and follow the procedure. When ended, load Rflow collector, and enable mysql exportation with the same mysql data you just used

Use

If Mod Rewrite is enable on your Apache server, the web UI shoulf be protect and require a Login and password (use the same as Mysql to log in),
If not, main dashboard should be directly displayed.

File:dashboard.pngd

If you clic on an IP adress, its logs will be displayed

File:syslog_rcs.png

If you click on aMac address, Device name form will be displayed

File:devname_rcs.png

Usefull Links

Rflow Collector V3 :

http://www.dd-wrt.com/dd-wrtv2/downloads/others/rflow%20collector/RFlowCollectorV3.rar
http://yzy-oui-fi.com/download/Rflow_Collector/RFlowCollectorV3.rar

Yzy-Oui-fi:

https://www.yzy-oui-fi.com
http://blog.yzy-oui-fi.com
http://tools.yzy-oui-fi.com
Personal tools