VNstat2 и PF 2.1 calendar problem

bryan.paradis

make a new file in /usr/local/www called phpinfo.php include below code
goto http://pfsense/phpinfo.php
check and paste the lines I pasted below


phpinfo();

?>

Configuration File (php.ini) Path /usr/local/etc
Loaded Configuration File /usr/local/etc/php.ini
Scan this dir for additional .ini files /usr/local/etc/php

date/time support enabled
"Olson" Timezone Database Version 2013.3
Timezone Database internal
Default timezone America/Montreal

Directive Local Value Master Value
date.default_latitude 31.7667 31.7667
date.default_longitude 35.2333 35.2333
date.sunrise_zenith 90.583333 90.583333
date.sunset_zenith 90.583333 90.583333
date.timezone America/Montreal America/Montreal

DasTieRR

@bryan.paradis:

make a new file in /usr/local/www called phpinfo.php include below code

goto http://pfsense/phpinfo.php

check and paste the lines I pasted below
phpinfo();

?>
Configuration File (php.ini) Path /usr/local/etc
Loaded Configuration File /usr/local/etc/php.ini
Scan this dir for additional .ini files /usr/local/etc/php

date/time support enabled
"Olson" Timezone Database Version 2013.3
Timezone Database internal
Default timezone America/Montreal

Directive Local Value Master Value
date.default_latitude 31.7667 31.7667
date.default_longitude 35.2333 35.2333
date.sunrise_zenith 90.583333 90.583333
date.sunset_zenith 90.583333 90.583333
date.timezone America/Montreal America/Montreal

Configuration File (php.ini) Path /usr/local/etc
Loaded Configuration File /usr/local/etc/php.ini

date/time support enabled
"Olson" Timezone Database Version 2013.3
Timezone Database internal
Default timezone Europe/Moscow

Directive Local Value Master Value
date.default_latitude 31.7667 31.7667
date.default_longitude 35.2333 35.2333
date.sunrise_zenith 90.583333 90.583333
date.sunset_zenith 90.583333 90.583333
date.timezone Europe/Moscow Europe/Moscow

1.jpg_thumb

bryan.paradis

1. Please upload a zip of your /usr/local/www/vnstat directory
2. Paste result of find / -name *vnstat*
3. Paste result of find / -name *re1*
4. Paste result of ls in /conf/vnstat
5. Backup your /conf/vnstat folder
6. Delete all files inside /conf/vnstat
7. Add the interfaces to vnstat one at a time: vnstat -u -i re1 then vnstat -u -i re2 then vnstat -u -i re3
8. Check php front end again to see if the date is fixed.

DasTieRR

@bryan.paradis:

Please upload a zip of your /usr/local/www/vnstat directory

Paste result of find / -name *vnstat*

Paste result of find / -name *re1*

Paste result of ls in /conf/vnstat

backup your /conf/vnstat folder

delete all files inside /conf/vnstat

add the interfaces to vnstat : vnstat -u -i re1 vnstat -u -i re2 vnstat -u -i re3

check php front end again to see if the date is fixed.

upload my file /usr/local/www/vnstat here?

vnstat : vnstat -u -i re1 vnstat -u -i re2 vnstat -u -i re3 - command not found

2.jpg_thumb

3.jpg_thumb
![4 ls conf vnstat.jpg](/public/imported_attachments/1/4 ls conf vnstat.jpg)
![4 ls conf vnstat.jpg_thumb](/public/imported_attachments/1/4 ls conf vnstat.jpg_thumb)
![error adding interface.jpg](/public/imported_attachments/1/error adding interface.jpg)
![error adding interface.jpg_thumb](/public/imported_attachments/1/error adding interface.jpg_thumb)

bryan.paradis

@DasTieRR:

upload my file /usr/local/www/vnstat here?

Looks like there is a bit of a mess going on here

@DasTieRR:

vnstat : vnstat -u -i re1 vnstat -u -i re2 vnstat -u -i re3 - command not found

I meant to use them one at a time for each interface


vnstat -u -i re1
vnstat -u -i re2
vnstat -u -i re3

DasTieRR

@bryan.paradis:

@DasTieRR:

@bryan.paradis:

Please upload a zip of your /usr/local/www/vnstat directory

Paste result of find / -name *vnstat*

Paste result of find / -name *re1*

Paste result of ls in /conf/vnstat

backup your /conf/vnstat folder

delete all files inside /conf/vnstat

add the interfaces to vnstat : vnstat -u -i re1 vnstat -u -i re2 vnstat -u -i re3

check php front end again to see if the date is fixed.

upload my file /usr/local/www/vnstat here?

vnstat : vnstat -u -i re1 vnstat -u -i re2 vnstat -u -i re3 - command not found

I cleaned up my post. Please use the command one at a time. vnstat -u -i interfacename.

1. I cleared /cf/vnstat/ folder
2. I executed command, they are created new DB with normal date (today date), then i copied old vnstat data (re1 re2 re3 files) and it shows me old date 16 jan (again).
How can I can save my old vnstat data in new DataBase re1 re 2 re3?

1.jpg_thumb

2.jpg_thumb

3.jpg_thumb

bryan.paradis

@DasTieRR:

1. I cleared /cf/vnstat/ folder
2. I executed command, they are created new DB with normal date (today date), then i copied old vnstat data (re1 re2 re3 files) and it shows me old date 16 jan. How can I can save my old vnstat data?

This means that something has gone wrong with your old database. Did you change your server date sometime? Make a timezone change? Or something?

1. With new database do vnstat –dumpdb -i re1 and vnstat --dumpdb -i .re1
2. With old database put back do vnstat --dumpdb -i re1 and vnstat --dumpdb -i .re1
3. Please zip .re1 & re1 files and attach to your post

DasTieRR

@bryan.paradis:

@DasTieRR:

1. I cleared /cf/vnstat/ folder
2. I executed command, they are created new DB with normal date (today date), then i copied old vnstat data (re1 re2 re3 files) and it shows me old date 16 jan. How can I can save my old vnstat data?

This means that something has gone wrong with your old database. Did you change your server date sometime? Make a timezone change? Or something?

1. With new database do vnstat –dumpdb -i re1 and vnstat --dumpdb -i .re1
2. With old database put back do vnstat --dumpdb -i re1 and vnstat --dumpdb -i .re1

I do not remember, I changed timezone in old server - 2.0.x
then we bought new PC and i installed clean PF 2.1, imported some config (from backup/restore) but vnstat database I did not copy. But I have one server, whith clean install and clean configurations, whithout backups and restore and it have same problem.
Is there right command? They look same in first and second part.
I done first command:
vnstat –dumpdb -i re1
then
vnstat --dumpdb -i .re1
then copied old base re1 and .re1 with ovewright files
then in cmd - vnstat --dumpdb -i re1 and vnstat --dumpdb -i .re1 and not see data from new base, only old data with 16 jan, and not 17 jan...

bryan.paradis

Please paste the results and zip the old .re1 and re1 files and upload them here http://www.sendspace.com/ and give me link

DasTieRR

@bryan.paradis:

Please paste the results and zip the old .re1 and re1 files and upload them here http://www.sendspace.com/ and give me link

http://www.sendspace.com/file/a95550

bryan.paradis

Please post your /etc/crontab

DasTieRR

@bryan.paradis:

Please post your /etc/crontab

SHELL=/bin/sh
PATH=/etc:/bin:/sbin:/usr/bin:/usr/sbin
HOME=/var/log
#minute hour mday month wday who command

pfSense specific crontab entries

Created: January 17, 2014, 4:27 pm

0 * * * * root /usr/bin/nice -n20 newsyslog
1,31 0-5 * * * root /usr/bin/nice -n20 adjkerntz -a
1 3 1 * * root /usr/bin/nice -n20 /etc/rc.update_bogons.sh
*/60 * * * * root /usr/bin/nice -n20 /usr/local/sbin/expiretable -v -t 3600 sshlockout
1 1 * * * root /usr/bin/nice -n20 /etc/rc.dyndns.update
*/60 * * * * root /usr/bin/nice -n20 /usr/local/sbin/expiretable -v -t 3600 virusprot
30 12 * * * root /usr/bin/nice -n20 /etc/rc.update_urltables
0 0 * * * root /bin/rm /var/squid/cache/swap.state; /usr/pbi/squid-i386/sbin/squid -k rotate
*/15 * * * * root /usr/local/pkg/swapstate_check.php
*/1 * * * * root /usr/local/pkg/vnstat2.sh
*/1 * * * * root /root/tolog.sh
*/10 * * * * root /usr/bin/perl /usr/pbi/lightsquid-i386/www/lightsquid/lightparser.pl today
15 0 * * * root /usr/bin/perl /usr/pbi/lightsquid-i386/www/lightsquid/lightparser.pl yesterday
0 0 * * * root /usr/bin/nice -n20 /usr/pbi/squidguard-i386/etc/rc.d/squidGuard_logrotate

If possible do not add items to this file manually.

If you do so, this file must be terminated with a blank line (e.g. new line)

bryan.paradis

If you do vnstat -u are the dates correct?

DasTieRR

@bryan.paradis:

If you do vnstat -u are the dates correct?

In cmd? in cmd result of vnstat -u empty

bryan.paradis

@DasTieRR:

@bryan.paradis:

If you do vnstat -u are the dates correct?

In cmd? in cmd result of vnstat -u empty

Look at php front end dates now. does it say 17th

DasTieRR

@bryan.paradis:

@DasTieRR:

@bryan.paradis:

If you do vnstat -u are the dates correct?

In cmd? in cmd result of vnstat -u empty

Look at php front end dates now. does it say 17th

Yes, but in Moscow 18 jan…

bryan.paradis

@DasTieRR:

@bryan.paradis:

@DasTieRR:

@bryan.paradis:

If you do vnstat -u are the dates correct?

In cmd? in cmd result of vnstat -u empty

Look at php front end dates now. does it say 17th

Yes, but in Moscow 18 jan…

so does it say 18th now?

DasTieRR

@bryan.paradis:

@DasTieRR:

@bryan.paradis:

@DasTieRR:

@bryan.paradis:

If you do vnstat -u are the dates correct?

In cmd? in cmd result of vnstat -u empty

Look at php front end dates now. does it say 17th

Yes, but in Moscow 18 jan…

so does it say 18th now?

No 17…
Today, 18 jan I (have) test:
I del files re1 re2 re3 .re1 .re2 .re3 and cmd vnstat -u -i re1 and others
I got at the phpfrontend clean base with zero data and date 17 jan (but today 18)

4.jpg_thumb

DasTieRR

add:

Then I copied old base (end data 16 jan) and refresh phpfrontend - programm add 17 jan, not 18…

In russian thread is another person with same problem - in the base he has two 2013 year. (And I have two 2013 year too)

bryan.paradis

@DasTieRR:

1. I cleared /cf/vnstat/ folder
2. I executed command, they are created new DB with normal date (today date), then i copied old vnstat data (re1 re2 re3 files) and it shows me old date 16 jan (again).
How can I can save my old vnstat data in new DataBase re1 re 2 re3?

So when you create new database files for re1 re2 and re3 is the date right or wrong? You seem to have contradicted yourself. Forget about copying back the old files. We need to know if the new database files have the correct date or not.