Proxylizer/Getting Started

From MikroTik Wiki
Revision as of 11:13, 6 January 2009 by Janisd (talk | contribs)
Jump to navigation Jump to search

Download

TODO

Install

All the examples assume that Proxylizer server IP address is 10.1.1.2;

The installation includes steps for setting up the following:

  1. Web-proxy log export to remote host (Proxylizer server)
  1. Web page scripts
  2. Permissions for directories
  3. Syslog deamon
  4. Web server with PHP and PHP-Pear
  5. MySQL database server
  6. MySQL user created for proxylizer database
  7. Scripts/daemons forwarding records from syslog to MySQL
  8. Scheduled scripts for report generation

Mikrotik router

Web-proxy log export to remote host

TODO

Proxylizer server

All the exemples assume that web page root directory is "/var/www/proxylizer", webserver user is "www-data", Proxylizer server system user is "proxylizer" and .pipe file destination/name is "/home/proxylizer/mysql.pipe".

Web page scripts

TODO

Permissions for directories

Open console. Change ownership of web page root directory for web server user

 "chown www-data:proxylizer /var/www/proxylizer -R" 

Set permisions to read files for webserver user

 "find -type f -exec chmod u+r {} \;" 

Set permisions to read and execute directories for webserver user

 "find -type d -exec chmod ug+rwx {} \;" 

Set permisions to execute 3 shell script files for webserver user group.

 "chmod g+x checkwebproxy.sh mail_send.php webproxylogtomysql.php"; 

Syslog deamon

Install syslog-ng deamon.

 "apt-get install syslog-ng" 

Change syslog-ng config to recieve logs from Mikroutik router and put them into mysql.pipe file. Open

Web server with PHP and PHP-Pear

TODO

MySQL database server

TODO

MySQL user created for proxylizer database

TODO

Scripts/daemons forwarding records from syslog to MySQL

TODO

Scheduled scripts for report generation

TODO