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.
    • 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
                                      • D
                                        DasTieRR
                                        last edited by

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

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

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

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

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

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