Netgate Discussion Forum
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Search
    • Register
    • Login

    VNstat2 и PF 2.1 calendar problem

    Scheduled Pinned Locked Moved pfSense Packages
    38 Posts 2 Posters 6.4k Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • D
      DasTieRR
      last edited by

      @bryan.paradis:

      Mine matches with pfsense clock. There is defintely something weird going on there. Are you still having the same problem? Is the problem in just the PHP graphs or vnstati as well?

      yes, there is a problem

      Is the problem in just the PHP graphs or vnstati as well? I don't know :( Who can i test this?

      1 Reply Last reply Reply Quote 0
      • B
        bryan.paradis
        last edited by

        Please post the dates from:

        1. running date at console
        2. what date is listed on your pfsense
        3. vnstat info show traffic for days
        4. vnstat php front end

        ![2014-01-16 22_35_23-192.168.55.3 - PuTTY.png](/public/imported_attachments/1/2014-01-16 22_35_23-192.168.55.3 - PuTTY.png)
        ![2014-01-16 22_35_23-192.168.55.3 - PuTTY.png_thumb](/public/imported_attachments/1/2014-01-16 22_35_23-192.168.55.3 - PuTTY.png_thumb)
        ![2014-01-16 22_36_06-pfsense.localdomain - Status_ Dashboard.png](/public/imported_attachments/1/2014-01-16 22_36_06-pfsense.localdomain - Status_ Dashboard.png)
        ![2014-01-16 22_36_06-pfsense.localdomain - Status_ Dashboard.png_thumb](/public/imported_attachments/1/2014-01-16 22_36_06-pfsense.localdomain - Status_ Dashboard.png_thumb)
        ![2014-01-16 22_38_00-pfsense.localdomain - Vnstat2 info for LAN (em1).png](/public/imported_attachments/1/2014-01-16 22_38_00-pfsense.localdomain - Vnstat2 info for LAN (em1).png)
        ![2014-01-16 22_38_00-pfsense.localdomain - Vnstat2 info for LAN (em1).png_thumb](/public/imported_attachments/1/2014-01-16 22_38_00-pfsense.localdomain - Vnstat2 info for LAN (em1).png_thumb)

        1 Reply Last reply Reply Quote 0
        • D
          DasTieRR
          last edited by

          1. running date at console                                    normal
          2. what date is listed on your pfsense                  normal
          3. vnstat info show traffic for days                        normal (current date at the end of the graph)
          4. vnstat php front end                                        bad (minus 1 day)

          1.jpg
          1.jpg_thumb
          2.jpg
          2.jpg_thumb
          3.jpg
          3.jpg_thumb
          4.jpg
          4.jpg_thumb

          1 Reply Last reply Reply Quote 0
          • B
            bryan.paradis
            last edited by

            1. ssh to pfsense & go to shell
            2. cat /conf/config.xml | egrep -E '<timezone>(.*?)</timezone>'
            3. does it display the right timezone?
            4. cat /usr/local/etc/php.ini | grep date
            5. does it display the same time zone?
            6. if no edit /usr/local/etc/php.ini and set the right time zone.
            7. if yes please post the results of the commands.
            1 Reply Last reply Reply Quote 0
            • D
              DasTieRR
              last edited by

              @bryan.paradis:

              1. ssh to pfsense & go to shell
              2. cat /conf/config.xml | egrep -E '<timezone>(.*?)</timezone>'
              3. does it display the right timezone?
              4. cat /usr/local/etc/php.ini | grep date
              5. does it display the same time zone?
              6. if no edit /usr/local/etc/php.ini and set the right time zone.
              7. if yes please post the results of the commands.

              timezone 2) 4) ok :(

              datecommand2.jpg_thumb
              datecommand2.jpg
              44.jpg_thumb
              44.jpg
              22.jpg_thumb
              22.jpg

              1 Reply Last reply Reply Quote 0
              • B
                bryan.paradis
                last edited by

                1. make a new file in /usr/local/www called phpinfo.php include below code
                2. goto http://pfsense/phpinfo.php
                3. 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

                1 Reply Last reply Reply Quote 0
                • D
                  DasTieRR
                  last edited by

                  @bryan.paradis:

                  1. make a new file in /usr/local/www called phpinfo.php include below code
                  2. goto http://pfsense/phpinfo.php
                  3. 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
                  1.jpg_thumb

                  1 Reply Last reply Reply Quote 0
                  • B
                    bryan.paradis
                    last edited by

                    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.

                    1 Reply Last reply Reply Quote 0
                    • D
                      DasTieRR
                      last edited by

                      @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 : vnstat -u -i re1 vnstat -u -i re2 vnstat -u -i re3
                      8. check php front end again to see if the date is fixed.

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

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

                      2.jpg
                      2.jpg_thumb
                      3.jpg
                      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)

                      1 Reply Last reply Reply Quote 0
                      • B
                        bryan.paradis
                        last edited by

                        @DasTieRR:

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

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

                        @DasTieRR:

                        1. 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
                        
                        
                        1 Reply Last reply Reply Quote 0
                        • D
                          DasTieRR
                          last edited by

                          @bryan.paradis:

                          @DasTieRR:

                          @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 : vnstat -u -i re1 vnstat -u -i re2 vnstat -u -i re3
                          8. check php front end again to see if the date is fixed.

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

                          1. 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
                          1.jpg_thumb
                          2.jpg
                          2.jpg_thumb
                          3.jpg
                          3.jpg_thumb

                          1 Reply Last reply Reply Quote 0
                          • B
                            bryan.paradis
                            last edited by

                            @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

                            1 Reply Last reply Reply Quote 0
                            • D
                              DasTieRR
                              last edited by

                              @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...

                              1 Reply Last reply Reply Quote 0
                              • B
                                bryan.paradis
                                last edited by

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

                                1 Reply Last reply Reply Quote 0
                                • D
                                  DasTieRR
                                  last edited by

                                  @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

                                  1 Reply Last reply Reply Quote 0
                                  • B
                                    bryan.paradis
                                    last edited by

                                    Please post your /etc/crontab

                                    1 Reply Last reply Reply Quote 0
                                    • D
                                      DasTieRR
                                      last edited by

                                      @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)

                                      1 Reply Last reply Reply Quote 0
                                      • B
                                        bryan.paradis
                                        last edited by

                                        If you do vnstat -u are the dates correct?

                                        1 Reply Last reply Reply Quote 0
                                        • D
                                          DasTieRR
                                          last edited by

                                          @bryan.paradis:

                                          If you do vnstat -u are the dates correct?

                                          In cmd? in cmd result of vnstat -u empty

                                          1 Reply Last reply Reply Quote 0
                                          • B
                                            bryan.paradis
                                            last edited by

                                            @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

                                            1 Reply Last reply Reply Quote 0
                                            • First post
                                              Last post
                                            Copyright 2025 Rubicon Communications LLC (Netgate). All rights reserved.