Proxylizer/Getting Started: Difference between revisions

From MikroTik Wiki
Jump to navigation Jump to search
No edit summary
Line 4: Line 4:
== Install ==
== Install ==


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


The installation includes steps for setting up the following:
The installation includes steps for setting up the following:
Line 24: Line 24:


===Proxylizer server===
===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 ====
==== Web page scripts ====
TODO
TODO


==== Permissions for directories ====
==== Permissions for directories ====
Open console. Change ownership of web page root directory for web server user, commonly "www-data", (example: "chown www-data:proxylizer /var/www/proxylizer -R")
Open console. Change ownership of web page root directory for web server user
 
<pre> "chown www-data:proxylizer /var/www/proxylizer -R" </pre>
 
Set permisions to read files for webserver user
 
<pre> "find -type f -exec chmod u+r {} \;" </pre>
 
Set permisions to read and execute directories for webserver user
 
<pre> "find -type d -exec chmod ug+rwx {} \;" </pre>
 
Set permisions to execute 3 shell script files for webserver user group.
<pre> "chmod g+x checkwebproxy.sh mail_send.php webproxylogtomysql.php"; </pre>


==== Syslog deamon ====
==== Syslog deamon ====
Install syslog-ng deamon.
<pre> "apt-get install syslog-ng" </pre>
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 ====
==== Web server with PHP and PHP-Pear ====

Revision as of 11:13, 6 January 2009

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