Re: [mysar-support] mysar - can't open access.log although right set.

[blacky z. <bla...@ya...>]

Hi
Thanks so much for your reply.
Here is the infor that you want to know, please see below:

---------------------------
# 
# ls -l /var/squid/logs/access.log 
-rw-r--r--  1 _squid  _squid  59325917 Jul  5 10:20 /var/squid/logs/access.log
# 
# 
# ls -dl /var/squid/logs           
drwxrwxr-x  2 _squid  _squid  1024 Jul  4 00:00 /var/squid/logs
# 
# 
# ls -dl /var/squid/logs 
drwxrwxr-x  2 _squid  _squid  1024 Jul  4 00:00 /var/squid/logs
# 
# 
# ls -dl /var
drwxr-xr-x  31 root  wheel  512 Jun 18 12:09 /var
# 
----------------------------------------

If you need any information, please feel free to ask me.
Thanks again for your help. Hope receive your reply soon

Regards,

--
b:z


From: Giannis Stoilis <giannis@st...> 
    Re: mysar - can't open access.log although right set.   
   2006-06-18 08:34



Hello,
 
 paste me the output of the following commands:
 ls -l /var/squid/logs/access.log
 ls -dl /var/squid/logs
 ls -dl /var/squid
 ls -dl /var



blacky zero <bla...@ya...> wrote: Hi Giannis,

I am an user of mysar for long time (more than 1 years), for now i intend to upgrade mysar to new version (2.0.11). After completed initial setup, tell mysar about squid log location file, but when i try to manual run mysar-importer.php i got the following error:
---------------------
#!/usr/bin/php  /htdocs/adm/mod-webaccess/inc/common.inc.php(36) -> Disabling PHP's execution time limit...Yes Initializing database connection... dbHost=localhost,dbUser=dtmysaruser,dbPass=dtmysarpass Done. Selecting database... dbName=dtmysar Done. Start timestamp is 1150365320 Configuration:Array (     [dbUser] => dtmysaruser     [dbPass] => dtmysarpass     [dbHost] => localhost     [dbName] => dtmysar )  (SELECT value FROM config WHERE name='mysarImporter') Getting last proccessed record timestamp... (SELECT value FROM config WHERE name='lastTimestamp')0 (SELECT value FROM config WHERE  name='squidLogPath') Opening log file/var/squid/logs/access.log... ERROR: squid log file(/var/squid/logs/access.log) does not exist! Exiting...
----------------------
I'm sure that the /var/squid/logs/access.log is right path of squid log file.

I have the different setup to your instructions, i put all original source (uncompress) into my document root instead of /usr/local/, but i think it is no problem because i can browse mysar properly.

About crontab, is that exactly for current config:
 --------------------------------------------------------------
*       *       *       *       *       /var/www/htdocs/adm/mod-webaccess/bin/mysar-importer.php > /tmp/mysar.log 2>&1
*       *       *        *       *       /var/www/htdocs/adm/mod-webaccess/bin/mysar-resolver.php > /tmp/mysar.log 2>&1
*       *       *       *       *       /var/www/htdocs/adm/mod-webaccess/bin/mysar-maintenance.php > /tmp/mysar.log 2>&1

Note: /var/www/htdocs/adm/mod-webaccess is full path of mysar.

Please help me.
Thank you very much
Regards,

--
b:z
  __________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 


 			
---------------------------------
Sneak preview the  all-new Yahoo.com. It's not radically different. Just radically better.