mandriva>proxylizer mysql problem

hello
I installed proxyzlizer to mandriva linux (2010)
Web page its working -syslog ng is working i see logs from router in mysql.pipe
but in the web page is :
HIT/MISS ratio : 0 %
Total domain count : 0
Total hit count : 0
Oldest record : unknown
Latest record : unknown
Data base size : 0.11 MB

so its nothing

crontab its ok
crontab -l -u proxylizer
SHELL=/bin/sh
PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin

    • * * *           /var/www/html/proxylizer/mail_send.php >> /var/log/proxylizer/mail_send_log.log
      
    • * * *           /var/www/html/proxylizer/checkwebproxy.sh >> /var/log/proxylizer/checkwebproxy.log &
      

ls -an /home/proxilyzer/
total 27988
drwxrwxrwx 6 10004 10002 4096 2010-06-20 21:13 ./
drwxr-xr-x 7 0 0 4096 2010-06-19 00:36 ../
-rw------- 1 10004 10002 195 2010-06-20 21:16 .bash_history
-rw-r–r-- 1 10004 10002 24 2010-06-18 11:56 .bash_logout
-rw-r–r-- 1 10004 10002 191 2010-06-18 11:56 .bash_profile
drwx------ 3 10004 10002 4096 2010-06-20 21:09 .mc/
prw-r----- 1 0 0 0 2010-06-20 21:27 mysql.pipe|
-rw-r–r-- 1 0 0 0 2010-06-18 22:48 proxy
-rwxrwxrwx 1 10004 10002 293 2010-06-19 16:17 proxylizercontrab*
-rw-r–r-- 1 10004 10002 3793 2010-06-18 11:56 .screenrc
drwxrwxrwx 3 10004 10002 4096 2010-06-20 21:09 tmp/

i tryed with 777 mysql.pipe also with 640
i use syslog-ng config file from the proxylizer vmware
no messages in log files
[root@proxylizer proxylizer]# ls -an
total 12
drwxr-xr-x 2 10004 10002 4096 2010-06-20 21:06 ./
drwxr-xr-x 16 0 0 4096 2010-06-20 21:09 ../
-rw-r–r-- 1 0 0 0 2010-06-20 21:06 checkwebproxy.log
-rw-r–r-- 1 0 0 1 2010-06-20 21:06 mail_send_log.log
-rw-r–r-- 1 0 0 0 2010-06-20 21:06 webproxytodb_debug.log
-rw-r–r-- 1 0 0 0 2010-06-20 21:06 webproxytodb_error.log
[root@proxylizer proxylizer]#

i tryed with root user too now im made with proxylizer user
i did exact the same way
http://wiki.mikrotik.com/wiki/Proxylizer/Getting_Started#Install_method_1

Any help would be appreciated realy , im stuck i have no idea what to try.
Thank you

PS. I can’t change the linux distribution and i think the problem its not with mandriva.

problem solved
syslog-ng version 2 template its not ok with version 3 syslog-ng :slight_smile:

http://www.syslog.org/logged/pot-of-syslog-ng-tricks-version-3/

I have the same problem.
Could you tell how you solved it?

And another problem.
When I run crontab /home/proxylizer/proxylizercrontab in webproxytodb_debug.log this line appears - Not valid web proxy log!!!
and this file increase in 1MB/s

proxylizercrontab:
SHELL=/bin/sh
PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin

          • /var/www/html/proxylizer/mail_send.php >> /var/log/proxylizer/mail_send_log.log
          • /var/www/html/proxylizer/checkwebproxy.sh >> /var/log/proxylizer/checkwebproxy.log &

please, help!