Menu
▾
▴
mysar-support
|
From: Ashfaq A K. <ash...@nu...> - 2011-03-10 05:35:23
|
Dear all, i have recently installed and configure mysar on fedora but the page shows 0 activity. Its not working. anyone plz help me. -- Ashfaq A Khan System Officer FAST-NU Peshawar Campus |
|
From: Freestate _ <sta...@ho...> - 2011-03-10 05:49:02
|
Are you add mysar-importer script to you contrab file and restart the service cron? Check cron´s logs and see if mysar-importer is there. regards Date: Thu, 10 Mar 2011 10:35:17 +0500 From: ash...@nu... To: mys...@li... Subject: [mysar-support] reports are not generating Dear all, i have recently installed and configure mysar on fedora but the page shows 0 activity. Its not working. anyone plz help me. -- Ashfaq A Khan System Officer FAST-NU Peshawar Campus ------------------------------------------------------------------------------ Colocation vs. Managed Hosting A question and answer guide to determining the best fit for your organization - today and in the future. http://p.sf.net/sfu/internap-sfd2d _______________________________________________ mysar-support mailing list mys...@li... https://lists.sourceforge.net/lists/listinfo/mysar-support |
|
From: Freestate _ <sta...@ho...> - 2011-03-10 05:50:19
|
i mean, CRONTAB. /etc/crontab From: sta...@ho... To: mys...@li... Date: Wed, 9 Mar 2011 23:48:56 -0600 Subject: Re: [mysar-support] reports are not generating Are you add mysar-importer script to you contrab file and restart the service cron? Check cron´s logs and see if mysar-importer is there. regards Date: Thu, 10 Mar 2011 10:35:17 +0500 From: ash...@nu... To: mys...@li... Subject: [mysar-support] reports are not generating Dear all, i have recently installed and configure mysar on fedora but the page shows 0 activity. Its not working. anyone plz help me. -- Ashfaq A Khan System Officer FAST-NU Peshawar Campus ------------------------------------------------------------------------------ Colocation vs. Managed Hosting A question and answer guide to determining the best fit for your organization - today and in the future. http://p.sf.net/sfu/internap-sfd2d _______________________________________________ mysar-support mailing list mys...@li... https://lists.sourceforge.net/lists/listinfo/mysar-support ------------------------------------------------------------------------------ Colocation vs. Managed Hosting A question and answer guide to determining the best fit for your organization - today and in the future. http://p.sf.net/sfu/internap-sfd2d _______________________________________________ mysar-support mailing list mys...@li... https://lists.sourceforge.net/lists/listinfo/mysar-support |
|
From: Ashfaq A K. <ash...@nu...> - 2011-03-10 09:17:36
|
let me check,,, but if u go a little bit in explanation and step by step procedure then it will be easy to me. thanks On Thu, Mar 10, 2011 at 10:50 AM, Freestate _ <sta...@ho...> wrote: > i mean, CRONTAB. /etc/crontab > > ------------------------------ > From: sta...@ho... > > To: mys...@li... > Date: Wed, 9 Mar 2011 23:48:56 -0600 > Subject: Re: [mysar-support] reports are not generating > > > Are you add mysar-importer script to you contrab file and restart the > service cron? Check cron´s logs and see if mysar-importer is there. > > > regards > > ------------------------------ > Date: Thu, 10 Mar 2011 10:35:17 +0500 > From: ash...@nu... > To: mys...@li... > Subject: [mysar-support] reports are not generating > > Dear all, > > i have recently installed and configure mysar on fedora but the page shows > 0 activity. Its not working. > > anyone plz help me. > > > > -- > Ashfaq A Khan > System Officer > > FAST-NU > Peshawar Campus > > ------------------------------------------------------------------------------ > Colocation vs. Managed Hosting A question and answer guide to determining > the best fit for your organization - today and in the future. > http://p.sf.net/sfu/internap-sfd2d > _______________________________________________ mysar-support mailing list > mys...@li... > https://lists.sourceforge.net/lists/listinfo/mysar-support > ------------------------------------------------------------------------------ > Colocation vs. Managed Hosting A question and answer guide to determining > the best fit for your organization - today and in the future. > http://p.sf.net/sfu/internap-sfd2d > _______________________________________________ mysar-support mailing list > mys...@li... > https://lists.sourceforge.net/lists/listinfo/mysar-support > > > ------------------------------------------------------------------------------ > Colocation vs. Managed Hosting > A question and answer guide to determining the best fit > for your organization - today and in the future. > http://p.sf.net/sfu/internap-sfd2d > _______________________________________________ > mysar-support mailing list > mys...@li... > https://lists.sourceforge.net/lists/listinfo/mysar-support > > -- Ashfaq A Khan System Officer FAST-NU Peshawar Campus |
|
From: Ashfaq A K. <ash...@nu...> - 2011-03-10 09:40:51
|
yes mysar scripts has been added to crontab. wht next On Thu, Mar 10, 2011 at 2:17 PM, Ashfaq A Khan <ash...@nu...>wrote: > let me check,,, but if u go a little bit in explanation and step by step > procedure then it will be easy to me. > > thanks > > On Thu, Mar 10, 2011 at 10:50 AM, Freestate _ <sta...@ho...>wrote: > >> i mean, CRONTAB. /etc/crontab >> >> ------------------------------ >> From: sta...@ho... >> >> To: mys...@li... >> Date: Wed, 9 Mar 2011 23:48:56 -0600 >> Subject: Re: [mysar-support] reports are not generating >> >> >> Are you add mysar-importer script to you contrab file and restart the >> service cron? Check cron´s logs and see if mysar-importer is there. >> >> >> regards >> >> ------------------------------ >> Date: Thu, 10 Mar 2011 10:35:17 +0500 >> From: ash...@nu... >> To: mys...@li... >> Subject: [mysar-support] reports are not generating >> >> Dear all, >> >> i have recently installed and configure mysar on fedora but the page shows >> 0 activity. Its not working. >> >> anyone plz help me. >> >> >> >> -- >> Ashfaq A Khan >> System Officer >> >> FAST-NU >> Peshawar Campus >> >> ------------------------------------------------------------------------------ >> Colocation vs. Managed Hosting A question and answer guide to determining >> the best fit for your organization - today and in the future. >> http://p.sf.net/sfu/internap-sfd2d >> _______________________________________________ mysar-support mailing list >> mys...@li... >> https://lists.sourceforge.net/lists/listinfo/mysar-support >> ------------------------------------------------------------------------------ >> Colocation vs. Managed Hosting A question and answer guide to determining >> the best fit for your organization - today and in the future. >> http://p.sf.net/sfu/internap-sfd2d >> _______________________________________________ mysar-support mailing list >> mys...@li... >> https://lists.sourceforge.net/lists/listinfo/mysar-support >> >> >> ------------------------------------------------------------------------------ >> >> Colocation vs. Managed Hosting >> A question and answer guide to determining the best fit >> for your organization - today and in the future. >> http://p.sf.net/sfu/internap-sfd2d >> _______________________________________________ >> mysar-support mailing list >> mys...@li... >> https://lists.sourceforge.net/lists/listinfo/mysar-support >> >> > > > -- > Ashfaq A Khan > System Officer > > FAST-NU > Peshawar Campus > -- Ashfaq A Khan System Officer FAST-NU Peshawar Campus |
|
From: Freestate _ <sta...@ho...> - 2011-03-10 15:08:30
|
Check the logs of cron. /var/log/cron This is an example of the output Mar 6 04:48:01 proxy crond[30723]: (root) CMD (/usr/local/mysar/bin/mysar-importer.php > /usr/local/mysar/log/mysar-importer.log 2>&1) Mar 6 04:49:01 proxy crond[30728]: (root) CMD (/usr/local/mysar/bin/mysar-importer.php > /usr/local/mysar/log/mysar-importer.log 2>&1) Mar 6 04:50:01 proxy crond[30732]: (root) CMD (/usr/local/mysar/bin/mysar-importer.php > /usr/local/mysar/log/mysar-importer.log 2>&1) Mar 6 04:51:01 proxy crond[30737]: (root) CMD (/usr/local/mysar/bin/mysar-importer.php > /usr/local/mysar/log/mysar-importer.log 2>&1) This is an example of my /etc/crontab SHELL=/bin/bash PATH=/sbin:/bin:/usr/sbin:/usr/bin MAILTO=root HOME=/ # run-parts * * * * * root /usr/local/mysar/bin/mysar-importer.php > /usr/local/mysar/log/mysar-importer.log 2>&1 01 * * * * root run-parts /etc/cron.hourly 02 4 * * * root run-parts /etc/cron.daily 22 4 * * 0 root run-parts /etc/cron.weekly 42 4 1 * * root run-parts /etc/cron.monthly also check the log /usr/local/mysar/log this is and example of my log ___________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ 555 records processed regards Date: Thu, 10 Mar 2011 14:40:44 +0500 From: ash...@nu... To: mys...@li... Subject: Re: [mysar-support] reports are not generating yes mysar scripts has been added to crontab. wht next On Thu, Mar 10, 2011 at 2:17 PM, Ashfaq A Khan <ash...@nu...> wrote: let me check,,, but if u go a little bit in explanation and step by step procedure then it will be easy to me. thanks On Thu, Mar 10, 2011 at 10:50 AM, Freestate _ <sta...@ho...> wrote: i mean, CRONTAB. /etc/crontab From: sta...@ho... To: mys...@li... Date: Wed, 9 Mar 2011 23:48:56 -0600 Subject: Re: [mysar-support] reports are not generating Are you add mysar-importer script to you contrab file and restart the service cron? Check cron´s logs and see if mysar-importer is there. regards Date: Thu, 10 Mar 2011 10:35:17 +0500 From: ash...@nu... To: mys...@li... Subject: [mysar-support] reports are not generating Dear all, i have recently installed and configure mysar on fedora but the page shows 0 activity. Its not working. anyone plz help me. -- Ashfaq A Khan System Officer FAST-NU Peshawar Campus ------------------------------------------------------------------------------ Colocation vs. Managed Hosting A question and answer guide to determining the best fit for your organization - today and in the future. http://p.sf.net/sfu/internap-sfd2d _______________________________________________ mysar-support mailing list mys...@li... https://lists.sourceforge.net/lists/listinfo/mysar-support ------------------------------------------------------------------------------ Colocation vs. Managed Hosting A question and answer guide to determining the best fit for your organization - today and in the future. http://p.sf.net/sfu/internap-sfd2d _______________________________________________ mysar-support mailing list mys...@li... https://lists.sourceforge.net/lists/listinfo/mysar-support ------------------------------------------------------------------------------ Colocation vs. Managed Hosting A question and answer guide to determining the best fit for your organization - today and in the future. http://p.sf.net/sfu/internap-sfd2d _______________________________________________ mysar-support mailing list mys...@li... https://lists.sourceforge.net/lists/listinfo/mysar-support -- Ashfaq A Khan System Officer FAST-NU Peshawar Campus -- Ashfaq A Khan System Officer FAST-NU Peshawar Campus ------------------------------------------------------------------------------ Colocation vs. Managed Hosting A question and answer guide to determining the best fit for your organization - today and in the future. http://p.sf.net/sfu/internap-sfd2d _______________________________________________ mysar-support mailing list mys...@li... https://lists.sourceforge.net/lists/listinfo/mysar-support |
|
From: Francisco A. Q. <fra...@ch...> - 2011-03-11 03:28:04
|
make sure you have installed,php modules for mysql and "anacron" This is my crontab # /etc/crontab: system-wide crontab # Unlike any other crontab you don't have to run the `crontab' # command to install the new version when you edit this file # and files in /etc/cron.d. These files also have username fields, # that none of the other crontabs do. SHELL=/bin/sh PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin # m h dom mon dow user command 17 * * * * root cd / && run-parts --report /etc/cron.hourly 25 6 * * * root test -x /usr/sbin/anacron || ( cd / && run-parts --report /etc/cron.daily ) 47 6 * * 7 root test -x /usr/sbin/anacron || ( cd / && run-parts --report /etc/cron.weekly ) 52 6 1 * * root test -x /usr/sbin/anacron || ( cd / && run-parts --report /etc/cron.monthly ) * * * * * root /usr/local/mysar/bin/mysar-importer.php > /usr/local/mysar/log/mysar-importer.log 2>&1 * * * * * root /usr/local/mysar/bin/mysar-resolver.php > /usr/local/mysar/log/mysar-resolver.log 2>&1 0 0 * * * root /usr/local/mysar/bin/mysar-maintenance.php > /usr/local/mysar/log/mysar-maintenance.log 2>&1 regards! > Check the logs of cron. /var/log/cron > > This is an example of the output > > Mar 6 04:48:01 proxy crond[30723]: (root) CMD > (/usr/local/mysar/bin/mysar-importer.php > > /usr/local/mysar/log/mysar-importer.log 2>&1) > Mar 6 04:49:01 proxy crond[30728]: (root) CMD > (/usr/local/mysar/bin/mysar-importer.php > > /usr/local/mysar/log/mysar-importer.log 2>&1) > Mar 6 04:50:01 proxy crond[30732]: (root) CMD > (/usr/local/mysar/bin/mysar-importer.php > > /usr/local/mysar/log/mysar-importer.log 2>&1) > Mar 6 04:51:01 proxy crond[30737]: (root) CMD > (/usr/local/mysar/bin/mysar-importer.php > > /usr/local/mysar/log/mysar-importer.log 2>&1) > > This is an example of my /etc/crontab > > SHELL=/bin/bash > PATH=/sbin:/bin:/usr/sbin:/usr/bin > MAILTO=root > HOME=/ > > # run-parts > * * * * * root /usr/local/mysar/bin/mysar-importer.php > > /usr/local/mysar/log/mysar-importer.log 2>&1 > 01 * * * * root run-parts /etc/cron.hourly > 02 4 * * * root run-parts /etc/cron.daily > 22 4 * * 0 root run-parts /etc/cron.weekly > 42 4 1 * * root run-parts /etc/cron.monthly > > also check the log /usr/local/mysar/log > > this is and example of my log > > ___________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ > 555 records processed > > > > regards > Date: Thu, 10 Mar 2011 14:40:44 +0500 > From: ash...@nu... > To: mys...@li... > Subject: Re: [mysar-support] reports are not generating > > yes mysar scripts has been added to crontab. > > wht next > > > > On Thu, Mar 10, 2011 at 2:17 PM, Ashfaq A Khan <ash...@nu...> > wrote: > > let me check,,, but if u go a little bit in explanation and step by step > procedure then it will be easy to me. > > > thanks > > On Thu, Mar 10, 2011 at 10:50 AM, Freestate _ <sta...@ho...> > wrote: > > > > > > > > i mean, CRONTAB. /etc/crontab > > > > > From: sta...@ho... > To: mys...@li... > > Date: Wed, 9 Mar 2011 23:48:56 -0600 > Subject: Re: [mysar-support] reports are not generating > > > > > Are you add mysar-importer script to you contrab file and restart the > service cron? Check cron´s logs and see if mysar-importer is there. > > > regards > > > > Date: Thu, 10 Mar 2011 10:35:17 +0500 > From: ash...@nu... > To: mys...@li... > > > Subject: [mysar-support] reports are not generating > > > Dear all, > > i have recently installed and configure mysar on fedora but the page shows > 0 activity. Its not working. > > anyone plz help me. > > > -- > Ashfaq A Khan > System Officer > > > > FAST-NU > Peshawar Campus > > ------------------------------------------------------------------------------ > Colocation vs. Managed Hosting A question and answer guide to determining > the best fit for your organization - today and in the future. > http://p.sf.net/sfu/internap-sfd2d > > > _______________________________________________ mysar-support mailing list > mys...@li... > https://lists.sourceforge.net/lists/listinfo/mysar-support > > > ------------------------------------------------------------------------------ > Colocation vs. Managed Hosting A question and answer guide to determining > the best fit for your organization - today and in the future. > http://p.sf.net/sfu/internap-sfd2d > > > _______________________________________________ mysar-support mailing list > mys...@li... > https://lists.sourceforge.net/lists/listinfo/mysar-support > > > > ------------------------------------------------------------------------------ > > Colocation vs. Managed Hosting > > A question and answer guide to determining the best fit > > for your organization - today and in the future. > > http://p.sf.net/sfu/internap-sfd2d > _______________________________________________ > > mysar-support mailing list > > mys...@li... > > https://lists.sourceforge.net/lists/listinfo/mysar-support > > > > > -- > Ashfaq A Khan > System Officer > > FAST-NU > Peshawar Campus > > > > > -- > Ashfaq A Khan > System Officer > > FAST-NU > Peshawar Campus > > > > ------------------------------------------------------------------------------ > Colocation vs. Managed Hosting > A question and answer guide to determining the best fit > for your organization - today and in the future. > http://p.sf.net/sfu/internap-sfd2d > _______________________________________________ > mysar-support mailing list > mys...@li... > https://lists.sourceforge.net/lists/listinfo/mysar-support > ------------------------------------------------------------------------------ > Colocation vs. Managed Hosting > A question and answer guide to determining the best fit > for your organization - today and in the future. > http://p.sf.net/sfu/internap-sfd2d_______________________________________________ > mysar-support mailing list > mys...@li... > https://lists.sourceforge.net/lists/listinfo/mysar-support > -- "Hay una fuerza motriz más poderosa que el vapor, la electricidad y la energía atómica: la voluntad." Albert Einstein. .. "One machine can do the work of fifty ordinary men. No machine can do the work of one extraordinary man". Elbert Hubbard US author (1856 - 1915) ... |
|
From: Ashfaq A K. <ash...@nu...> - 2011-03-11 03:44:35
|
when I opened log /usr/local/mysar/log it contains the following error
ERROR on SQL query
SQL query: INSERT INTO traffic(date,time,ip,resultCode,bytes,url,authuser)
VALUES
('1970-01-01','05:03:12',INET_ATON('-'),'[10/Mar/2011:10:35:00','+0500]','
mail.google.com:443','HTTP/1.0\"')
Database error number: 1048
Database error message: Column 'ip' cannot be null
Exiting...
what is the problem.
regards
On Fri, Mar 11, 2011 at 3:27 AM, Francisco Arencibia Quesada <
fra...@ch...> wrote:
> make sure you have installed,php modules for mysql and "anacron"
>
>
> This is my crontab
>
> # /etc/crontab: system-wide crontab
> # Unlike any other crontab you don't have to run the `crontab'
> # command to install the new version when you edit this file
> # and files in /etc/cron.d. These files also have username fields,
> # that none of the other crontabs do.
>
> SHELL=/bin/sh
> PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin
>
> # m h dom mon dow user command
> 17 * * * * root cd / && run-parts --report /etc/cron.hourly
> 25 6 * * * root test -x /usr/sbin/anacron || ( cd / && run-parts
> --report
> /etc/cron.daily )
> 47 6 * * 7 root test -x /usr/sbin/anacron || ( cd / && run-parts
> --report
> /etc/cron.weekly )
> 52 6 1 * * root test -x /usr/sbin/anacron || ( cd / && run-parts
> --report
> /etc/cron.monthly )
>
>
> * * * * * root /usr/local/mysar/bin/mysar-importer.php >
> /usr/local/mysar/log/mysar-importer.log 2>&1
> * * * * * root /usr/local/mysar/bin/mysar-resolver.php >
> /usr/local/mysar/log/mysar-resolver.log 2>&1
> 0 0 * * * root /usr/local/mysar/bin/mysar-maintenance.php >
> /usr/local/mysar/log/mysar-maintenance.log 2>&1
>
>
> regards!
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> > Check the logs of cron. /var/log/cron
> >
> > This is an example of the output
> >
> > Mar 6 04:48:01 proxy crond[30723]: (root) CMD
> > (/usr/local/mysar/bin/mysar-importer.php >
> > /usr/local/mysar/log/mysar-importer.log 2>&1)
> > Mar 6 04:49:01 proxy crond[30728]: (root) CMD
> > (/usr/local/mysar/bin/mysar-importer.php >
> > /usr/local/mysar/log/mysar-importer.log 2>&1)
> > Mar 6 04:50:01 proxy crond[30732]: (root) CMD
> > (/usr/local/mysar/bin/mysar-importer.php >
> > /usr/local/mysar/log/mysar-importer.log 2>&1)
> > Mar 6 04:51:01 proxy crond[30737]: (root) CMD
> > (/usr/local/mysar/bin/mysar-importer.php >
> > /usr/local/mysar/log/mysar-importer.log 2>&1)
> >
> > This is an example of my /etc/crontab
> >
> > SHELL=/bin/bash
> > PATH=/sbin:/bin:/usr/sbin:/usr/bin
> > MAILTO=root
> > HOME=/
> >
> > # run-parts
> > * * * * * root /usr/local/mysar/bin/mysar-importer.php >
> > /usr/local/mysar/log/mysar-importer.log 2>&1
> > 01 * * * * root run-parts /etc/cron.hourly
> > 02 4 * * * root run-parts /etc/cron.daily
> > 22 4 * * 0 root run-parts /etc/cron.weekly
> > 42 4 1 * * root run-parts /etc/cron.monthly
> >
> > also check the log /usr/local/mysar/log
> >
> > this is and example of my log
> >
> >
> ___________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
> > 555 records processed
> >
> >
> >
> > regards
> > Date: Thu, 10 Mar 2011 14:40:44 +0500
> > From: ash...@nu...
> > To: mys...@li...
> > Subject: Re: [mysar-support] reports are not generating
> >
> > yes mysar scripts has been added to crontab.
> >
> > wht next
> >
> >
> >
> > On Thu, Mar 10, 2011 at 2:17 PM, Ashfaq A Khan <ash...@nu...>
> > wrote:
> >
> > let me check,,, but if u go a little bit in explanation and step by step
> > procedure then it will be easy to me.
> >
> >
> > thanks
> >
> > On Thu, Mar 10, 2011 at 10:50 AM, Freestate _ <sta...@ho...>
> > wrote:
> >
> >
> >
> >
> >
> >
> >
> > i mean, CRONTAB. /etc/crontab
> >
> >
> >
> >
> > From: sta...@ho...
> > To: mys...@li...
> >
> > Date: Wed, 9 Mar 2011 23:48:56 -0600
> > Subject: Re: [mysar-support] reports are not generating
> >
> >
> >
> >
> > Are you add mysar-importer script to you contrab file and restart the
> > service cron? Check cron´s logs and see if mysar-importer is there.
> >
> >
> > regards
> >
> >
> >
> > Date: Thu, 10 Mar 2011 10:35:17 +0500
> > From: ash...@nu...
> > To: mys...@li...
> >
> >
> > Subject: [mysar-support] reports are not generating
> >
> >
> > Dear all,
> >
> > i have recently installed and configure mysar on fedora but the page
> shows
> > 0 activity. Its not working.
> >
> > anyone plz help me.
> >
> >
> > --
> > Ashfaq A Khan
> > System Officer
> >
> >
> >
> > FAST-NU
> > Peshawar Campus
> >
> >
> ------------------------------------------------------------------------------
> > Colocation vs. Managed Hosting A question and answer guide to determining
> > the best fit for your organization - today and in the future.
> > http://p.sf.net/sfu/internap-sfd2d
> >
> >
> > _______________________________________________ mysar-support mailing
> list
> > mys...@li...
> > https://lists.sourceforge.net/lists/listinfo/mysar-support
> >
> >
> >
> ------------------------------------------------------------------------------
> > Colocation vs. Managed Hosting A question and answer guide to determining
> > the best fit for your organization - today and in the future.
> > http://p.sf.net/sfu/internap-sfd2d
> >
> >
> > _______________________________________________ mysar-support mailing
> list
> > mys...@li...
> > https://lists.sourceforge.net/lists/listinfo/mysar-support
> >
> >
> >
> >
> ------------------------------------------------------------------------------
> >
> > Colocation vs. Managed Hosting
> >
> > A question and answer guide to determining the best fit
> >
> > for your organization - today and in the future.
> >
> > http://p.sf.net/sfu/internap-sfd2d
> > _______________________________________________
> >
> > mysar-support mailing list
> >
> > mys...@li...
> >
> > https://lists.sourceforge.net/lists/listinfo/mysar-support
> >
> >
> >
> >
> > --
> > Ashfaq A Khan
> > System Officer
> >
> > FAST-NU
> > Peshawar Campus
> >
> >
> >
> >
> > --
> > Ashfaq A Khan
> > System Officer
> >
> > FAST-NU
> > Peshawar Campus
> >
> >
> >
> >
> ------------------------------------------------------------------------------
> > Colocation vs. Managed Hosting
> > A question and answer guide to determining the best fit
> > for your organization - today and in the future.
> > http://p.sf.net/sfu/internap-sfd2d
> > _______________________________________________
> > mysar-support mailing list
> > mys...@li...
> > https://lists.sourceforge.net/lists/listinfo/mysar-support
> >
> ------------------------------------------------------------------------------
> > Colocation vs. Managed Hosting
> > A question and answer guide to determining the best fit
> > for your organization - today and in the future.
> >
> http://p.sf.net/sfu/internap-sfd2d_______________________________________________
> > mysar-support mailing list
> > mys...@li...
> > https://lists.sourceforge.net/lists/listinfo/mysar-support
> >
>
>
> --
> "Hay una fuerza motriz más poderosa que el vapor, la electricidad y la
> energía atómica: la voluntad."
> Albert Einstein. ..
>
> "One machine can do the work of fifty ordinary men. No machine can do the
> work of one extraordinary man".
> Elbert Hubbard US author (1856 - 1915) ...
>
>
>
> ------------------------------------------------------------------------------
> Colocation vs. Managed Hosting
> A question and answer guide to determining the best fit
> for your organization - today and in the future.
> http://p.sf.net/sfu/internap-sfd2d
> _______________________________________________
> mysar-support mailing list
> mys...@li...
> https://lists.sourceforge.net/lists/listinfo/mysar-support
>
--
Ashfaq A Khan
System Officer
FAST-NU
Peshawar Campus
|
|
From: Freestate _ <sta...@ho...> - 2011-03-11 16:19:26
|
Are you clock set properly?
Date: Fri, 11 Mar 2011 08:44:27 +0500
From: ash...@nu...
To: mys...@li...
Subject: Re: [mysar-support] reports are not generating
when I opened log /usr/local/mysar/log it contains the following error
ERROR on SQL querySQL query: INSERT INTO traffic(date,time,ip,resultCode,bytes,url,authuser) VALUES ('1970-01-01','05:03:12',INET_ATON('-'),'[10/Mar/2011:10:35:00','+0500]','mail.google.com:443','HTTP/1.0\"')
Database error number: 1048Database error message: Column 'ip' cannot be null
Exiting...
what is the problem.
regards
On Fri, Mar 11, 2011 at 3:27 AM, Francisco Arencibia Quesada <fra...@ch...> wrote:
make sure you have installed,php modules for mysql and "anacron"
This is my crontab
# /etc/crontab: system-wide crontab
# Unlike any other crontab you don't have to run the `crontab'
# command to install the new version when you edit this file
# and files in /etc/cron.d. These files also have username fields,
# that none of the other crontabs do.
SHELL=/bin/sh
PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin
# m h dom mon dow user command
17 * * * * root cd / && run-parts --report /etc/cron.hourly
25 6 * * * root test -x /usr/sbin/anacron || ( cd / && run-parts --report
/etc/cron.daily )
47 6 * * 7 root test -x /usr/sbin/anacron || ( cd / && run-parts --report
/etc/cron.weekly )
52 6 1 * * root test -x /usr/sbin/anacron || ( cd / && run-parts --report
/etc/cron.monthly )
* * * * * root /usr/local/mysar/bin/mysar-importer.php >
/usr/local/mysar/log/mysar-importer.log 2>&1
* * * * * root /usr/local/mysar/bin/mysar-resolver.php >
/usr/local/mysar/log/mysar-resolver.log 2>&1
0 0 * * * root /usr/local/mysar/bin/mysar-maintenance.php >
/usr/local/mysar/log/mysar-maintenance.log 2>&1
regards!
> Check the logs of cron. /var/log/cron
>
> This is an example of the output
>
> Mar 6 04:48:01 proxy crond[30723]: (root) CMD
> (/usr/local/mysar/bin/mysar-importer.php >
> /usr/local/mysar/log/mysar-importer.log 2>&1)
> Mar 6 04:49:01 proxy crond[30728]: (root) CMD
> (/usr/local/mysar/bin/mysar-importer.php >
> /usr/local/mysar/log/mysar-importer.log 2>&1)
> Mar 6 04:50:01 proxy crond[30732]: (root) CMD
> (/usr/local/mysar/bin/mysar-importer.php >
> /usr/local/mysar/log/mysar-importer.log 2>&1)
> Mar 6 04:51:01 proxy crond[30737]: (root) CMD
> (/usr/local/mysar/bin/mysar-importer.php >
> /usr/local/mysar/log/mysar-importer.log 2>&1)
>
> This is an example of my /etc/crontab
>
> SHELL=/bin/bash
> PATH=/sbin:/bin:/usr/sbin:/usr/bin
> MAILTO=root
> HOME=/
>
> # run-parts
> * * * * * root /usr/local/mysar/bin/mysar-importer.php >
> /usr/local/mysar/log/mysar-importer.log 2>&1
> 01 * * * * root run-parts /etc/cron.hourly
> 02 4 * * * root run-parts /etc/cron.daily
> 22 4 * * 0 root run-parts /etc/cron.weekly
> 42 4 1 * * root run-parts /etc/cron.monthly
>
> also check the log /usr/local/mysar/log
>
> this is and example of my log
>
> ___________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
> 555 records processed
>
>
>
> regards
> Date: Thu, 10 Mar 2011 14:40:44 +0500
> From: ash...@nu...
> To: mys...@li...
> Subject: Re: [mysar-support] reports are not generating
>
> yes mysar scripts has been added to crontab.
>
> wht next
>
>
>
> On Thu, Mar 10, 2011 at 2:17 PM, Ashfaq A Khan <ash...@nu...>
> wrote:
>
> let me check,,, but if u go a little bit in explanation and step by step
> procedure then it will be easy to me.
>
>
> thanks
>
> On Thu, Mar 10, 2011 at 10:50 AM, Freestate _ <sta...@ho...>
> wrote:
>
>
>
>
>
>
>
> i mean, CRONTAB. /etc/crontab
>
>
>
>
> From: sta...@ho...
> To: mys...@li...
>
> Date: Wed, 9 Mar 2011 23:48:56 -0600
> Subject: Re: [mysar-support] reports are not generating
>
>
>
>
> Are you add mysar-importer script to you contrab file and restart the
> service cron? Check cron´s logs and see if mysar-importer is there.
>
>
> regards
>
>
>
> Date: Thu, 10 Mar 2011 10:35:17 +0500
> From: ash...@nu...
> To: mys...@li...
>
>
> Subject: [mysar-support] reports are not generating
>
>
> Dear all,
>
> i have recently installed and configure mysar on fedora but the page shows
> 0 activity. Its not working.
>
> anyone plz help me.
>
>
> --
> Ashfaq A Khan
> System Officer
>
>
>
> FAST-NU
> Peshawar Campus
>
> ------------------------------------------------------------------------------
> Colocation vs. Managed Hosting A question and answer guide to determining
> the best fit for your organization - today and in the future.
> http://p.sf.net/sfu/internap-sfd2d
>
>
> _______________________________________________ mysar-support mailing list
> mys...@li...
> https://lists.sourceforge.net/lists/listinfo/mysar-support
>
>
> ------------------------------------------------------------------------------
> Colocation vs. Managed Hosting A question and answer guide to determining
> the best fit for your organization - today and in the future.
> http://p.sf.net/sfu/internap-sfd2d
>
>
> _______________________________________________ mysar-support mailing list
> mys...@li...
> https://lists.sourceforge.net/lists/listinfo/mysar-support
>
>
>
> ------------------------------------------------------------------------------
>
> Colocation vs. Managed Hosting
>
> A question and answer guide to determining the best fit
>
> for your organization - today and in the future.
>
> http://p.sf.net/sfu/internap-sfd2d
> _______________________________________________
>
> mysar-support mailing list
>
> mys...@li...
>
> https://lists.sourceforge.net/lists/listinfo/mysar-support
>
>
>
>
> --
> Ashfaq A Khan
> System Officer
>
> FAST-NU
> Peshawar Campus
>
>
>
>
> --
> Ashfaq A Khan
> System Officer
>
> FAST-NU
> Peshawar Campus
>
>
>
> ------------------------------------------------------------------------------
> Colocation vs. Managed Hosting
> A question and answer guide to determining the best fit
> for your organization - today and in the future.
> http://p.sf.net/sfu/internap-sfd2d
> _______________________________________________
> mysar-support mailing list
> mys...@li...
> https://lists.sourceforge.net/lists/listinfo/mysar-support
> ------------------------------------------------------------------------------
> Colocation vs. Managed Hosting
> A question and answer guide to determining the best fit
> for your organization - today and in the future.
> http://p.sf.net/sfu/internap-sfd2d_______________________________________________
> mysar-support mailing list
> mys...@li...
> https://lists.sourceforge.net/lists/listinfo/mysar-support
>
--
"Hay una fuerza motriz más poderosa que el vapor, la electricidad y la
energía atómica: la voluntad."
Albert Einstein. ..
"One machine can do the work of fifty ordinary men. No machine can do the
work of one extraordinary man".
Elbert Hubbard US author (1856 - 1915) ...
------------------------------------------------------------------------------
Colocation vs. Managed Hosting
A question and answer guide to determining the best fit
for your organization - today and in the future.
http://p.sf.net/sfu/internap-sfd2d
_______________________________________________
mysar-support mailing list
mys...@li...
https://lists.sourceforge.net/lists/listinfo/mysar-support
--
Ashfaq A Khan
System Officer
FAST-NU
Peshawar Campus
------------------------------------------------------------------------------
Colocation vs. Managed Hosting
A question and answer guide to determining the best fit
for your organization - today and in the future.
http://p.sf.net/sfu/internap-sfd2d
_______________________________________________
mysar-support mailing list
mys...@li...
https://lists.sourceforge.net/lists/listinfo/mysar-support |
|
From: Freestate _ <sta...@ho...> - 2011-03-29 21:00:24
|
hi friends Anyone work with squid-arp and mysar? |
|
From: daniel a. <dab...@gm...> - 2011-03-29 21:21:04
|
Hey guys, thanks for the replies, i'll try it soon and them post here! cya! Daniel 2011/3/29 Freestate _ <sta...@ho...> > hi friends > > Anyone work with squid-arp and mysar? > > > ------------------------------------------------------------------------------ > Enable your software for Intel(R) Active Management Technology to meet the > growing manageability and security demands of your customers. Businesses > are taking advantage of Intel(R) vPro (TM) technology - will your software > be a part of the solution? Download the Intel(R) Manageability Checker > today! http://p.sf.net/sfu/intel-dev2devmar > _______________________________________________ > mysar-support mailing list > mys...@li... > https://lists.sourceforge.net/lists/listinfo/mysar-support > > -- att, ** *Daniel Bridun* (11) 6566-6321 <http://www.polosit.com.br/> |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X