Hi,
I was tryting to install Proxylizer, but its not working. I get a blank page with only a Mikrotik Logo at the bottom. I followed all the steps as per the Wiki, but no progress.
Please let me know how will i be able to set it up properly.
I have made database.
when i try to open the web-page this is what i get besides getting a config page.
that’s really strange. there should be a login form on this page you see 
can you right-click on the page and choose “view source”?
also try another browser, just in case something is misconfigured in this firefox. try Google Chrome
Hi,
Dear Normis,
I installed Chrome as well as Opera. Still the same.
The source of the page from Chrome is as follows
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd> "> MikroTik Proxylizer
Let me know how will i be able to resolve this problem.
Hi,
I got it working, by doing a complete re-install of the Proxylizer.
Now i am facing anther issue.
When i execute the Crontab of Proxylizer manually i get the following error
PHP Notice: Undefined property: DB_mysql::$disconnect in /var/www/proxylizer/mail_send.php on line 54
Please let me know what to do with this..
Hi,
Somehow i have come around the problem that i described in my last.
My last problem was resolved by using “/usr/bin/php” to execute .php files.
Now i am facing a new problem.
i am getting " Not valid web proxy log!!! " message in /var/log/proxylizer/webproxytodb_debug.log , how i ever i am able to see all the logs in my “mysql.pipe” file, going smoothly.
in my mikrotik i have selected “web-proxy” + " debug" both for the logs, becasue when i select only “web-proxy” without “debug” i see no logs at all, not in Winbox Logs and also not in mysql.pipe.
please tell me what to do with this proxylizer. Its creating a lot of troubles for me. 
And i need this software to work urgently.
Looking forward for a quick response.
I resolved this issue also by editing he PHP file. There are allot of mistakes in PHP files, believe me.
Now when i do cat /root/mysql.pipe , i see the logs going.
And aslo in my proxylizer page it is showing that i have logs. But how to use this Dumb thing. Unable to do any thing.
For me Proxylizer is the Dumbest Software, becasue it is not at all user-friendly. (My opinion).
could you please point out some mistakes that you found? we would like to fix them on our side too.
Hi.
Dear Normis,
First thing is that, when i enable logging for “topic=web-proxy, !debug” . I see no logs at all, not in Mikrotik’s Log or anywhere.
The only way i see logs related to Web-proxy is “web-proxy,debug,packet”. So I had to edit the file webproxylogtomysql.php
I did the follosing chages
//if ($rawlog[‘3’] == ‘web-proxy,account’) {
if ($rawlog[‘3’] == ‘web-proxy,debug,packet’) {
$host = ip2long($rawlog[‘0’]);
if ($host === false) echo date("Y-m-d H:i | ") . “Invalid Host IP address\n”;
//$IP = eregIP($rawlog[‘4’]);
$IP = eregIP($rawlog[‘0’]);
if ($IP !== false) {
//$IP = ip2long($rawlog[‘4’]);
$IP = ip2long($rawlog[‘0’]);
if ($IP !== false) {
//parseURL($rawlog[‘6’]);
parseURL($rawlog[‘10’]);
//parseDomain($fulldomain);
//parseAction($rawlog[‘7’]);
parseAction($rawlog[‘9’]);
parseCache($line);
Lines starting with “//” are default lines, followed by the lines that i made. After making changes Proxylizer started recieving Logs, and was also showing logs on the proxylizer web.
But i was unable to anything from there. I am unable to understand how to use/operate this proxylizer.
The core problem here is syslog on the router. Web proxy should send all the logs when configured as described in http://wiki.mikrotik.com/wiki/Proxylizer/Getting_Started#Web-proxy_log_export_to_remote_host_.28Proxylizer_server.29 . If you would have this step working, you would not have to replace any line in PHP code.
When you are logging debug packets, they may contain completely different information, which comes in different format. Therefore you have to modify PHP to understand these other logs. But you MUST NOT to that, because data you are receiving this way, contains different info.
Looks like there are platform dependencies causing problems. Because we are deploying proxylizer for half a year without problems - logs are inserted, reports generated and sent over email.
What platform are you using on the Proxylizer side? Ubuntu? Which web server? Apache2? Which version of PHP and MySQL? Which SysLog client - Syslog-NG?
Check your firewall - maybe it is blocking syslog messages or somehow modifying them. Are you using Layer-7 filtering?
When following the Getting started guide, at which step are you stuck now? Is the web page working? Have you configured reports? Are they sent over email?
Hi,
Dear let me requote, when i use “topics=web-proxy, !debug” i get no logs at all. And i really mean no logs, so what will be transfered if i have no logs. The only way i see any sort of web-proxy logs is “topics=web-proxy,debug” .
I am using Red-Hat Enterprise 5, with Apache2 and PHP 5.xx and MySQL 5.xx . And using SYSLOG-NG.
I am saying again, i can see the logs in mysql.pipi, but it always say “Not Valid Web-Proxy Logs”, so for this i edited the file, which some how started working.
It is showing me that logs are being generated on the main page of Proxylizer, but how to use this App. Mails are not being generated, no logs are being mailed at all.
Please tell me how to resolve this issue.
Why do you keep insisting on using the debug option?
Just make the rule “topics=web-proxy” and leave it at that. Point the action to memory and watch the log whilst you browse.
What version of RouterOS are you running?
Hi,
Dear when i make a rule “topics=web-proxy” still the logs that i see have the “debug” option in it. So its no use.
I am using 2.9 as well as 3.23.
I have 3 machine on 2.9 and 2 machine on 3.23. And i want to make a centralized loggin server, for which i have re-installed my server with CentOS 5.3, with all the required dependencies.
Still the same.
Even if you leave debug messages on, it should work - the debug messages are not in the required format, so they are simply discarded. The question is - why do you receive logs in different format?
Could you, please, send web-proxy logs to memory for a while (/system logging set … action=memory), watch the logs (/log print follow) and paste one of the entries, containing accounting info (the whole line) here, in this topic.
And, it could really help, if you could give us (Mikrotik) access to your RedHat box - provide us with IP address, username and password - send it to support at mikrotik dot com!
We would like to help, but it is hard to identify the problem.
New idea of possible bug: have you configured Syslog NG correctly (http://wiki.mikrotik.com/wiki/Proxylizer/Getting_Started#Syslog_daemon)?
Special attention to line containing the template:
template("$HOST $YEAR-$MONTH-$DAY $HOUR:$MIN:$SEC $MSG\n") template-escape(yes));