Help - Table Name

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Alshalan
    Member
    • Apr 2017
    • 76
    • 4.2.x

    [Forum] Help - Table Name

    Hi
    I want to know the name of the IP log storage table in database?

    in vBulletin 4.2.5
  • Alshalan
    Member
    • Apr 2017
    • 76
    • 4.2.x

    #2
    Any Help?

    Comment

    • Wayne Luke
      vBulletin Technical Support Lead
      • Aug 2000
      • 73981

      #3
      ipdata - It only records data when someone makes a post. No data is logged on log in or simple visits.
      Translations provided by Google.

      Wayne Luke
      The Rabid Badger - a vBulletin Cloud demonstration site.
      vBulletin 5 API

      Comment

      • Alshalan
        Member
        • Apr 2017
        • 76
        • 4.2.x

        #4
        Originally posted by Wayne Luke
        ipdata - It only records data when someone makes a post. No data is logged on log in or simple visits.
        Thanks
        I found in the table you mentioned data where zeros
        Like
        0.0.0.0
        Although I am in the forum I find all the ips and works well from the first post to the last post so far.
        But what do zeros mean?

        Comment

        • Wayne Luke
          vBulletin Technical Support Lead
          • Aug 2000
          • 73981

          #5
          0.0.0.0 would mean there is no IP. If you're behind a proxy then it is probably recording the incorrect value. You can tell vBulletin which header contains the actual IP Address in your /includes/config.php file.
          Translations provided by Google.

          Wayne Luke
          The Rabid Badger - a vBulletin Cloud demonstration site.
          vBulletin 5 API

          Comment

          • Alshalan
            Member
            • Apr 2017
            • 76
            • 4.2.x

            #6
            Thanks, but in the forum I find all the ip and can not find any zeros.
            what does it mean?
            Originally posted by Wayne Luke
            You can tell vBulletin which header contains the actual IP Address in your /includes/config.php file.

            I did not understand this sentence.

            ​​​​​​​What do I do for the config.php file?
            Last edited by Alshalan; Tue 18 Dec '18, 9:55am.

            Comment

            • Wayne Luke
              vBulletin Technical Support Lead
              • Aug 2000
              • 73981

              #7
              If you use a Proxy Server then that machine will report its IP address as the user's. To work around this, it will place the user's actual IP address in a different header. You have to tell vBulletin to track this different header to get valid IP Address information.

              Code:
              /* #### REVERSE PROXY IP ####
              If your use a system where the main IP address passed to vBulletin is the address of a proxy server
              and the actual 'real' ip address is passed in another http header then you enter the details here
              Enter your known proxy servers here. You can list multiple trusted IPs separated by a comma.
              You can also use the * wildcard (at the end of a definition only) or use the keyword 'all' to represent any ip address.*/
              //$config['Misc']['proxyiplist'] = '127.0.0.1, 192.168.*, all';
              /* If the real IP is passed in a http header variable you can set the name here; */
              //$config['Misc']['proxyipheader'] = 'HTTP_X_FORWARDED_FOR';
              
              /* #### Force VB ALT_IP ####
              Setting this will force vBulletin to use any internally detected alternative ip as the main ip address.
              The core checks three http headers (in order) HTTP_CLIENT_IP, HTTP_CF_CONNECTING_IP, HTTP_X_FORWARDED_FOR.
              It will use the first one it finds as IPADDRESS, and the original REMOTE_ADDR as ALT_IP.
              Do not use this option unless you understand what you are doing, and the possible consequences. */
              //define('USE_VB_ALT_IP', true);
              Translations provided by Google.

              Wayne Luke
              The Rabid Badger - a vBulletin Cloud demonstration site.
              vBulletin 5 API

              Comment

              • Alshalan
                Member
                • Apr 2017
                • 76
                • 4.2.x

                #8
                Originally posted by Wayne Luke
                If you use a Proxy Server then that machine will report its IP address as the user's. To work around this, it will place the user's actual IP address in a different header. You have to tell vBulletin to track this different header to get valid IP Address information.

                Code:
                /* #### REVERSE PROXY IP ####
                If your use a system where the main IP address passed to vBulletin is the address of a proxy server
                and the actual 'real' ip address is passed in another http header then you enter the details here
                Enter your known proxy servers here. You can list multiple trusted IPs separated by a comma.
                You can also use the * wildcard (at the end of a definition only) or use the keyword 'all' to represent any ip address.*/
                //$config['Misc']['proxyiplist'] = '127.0.0.1, 192.168.*, all';
                /* If the real IP is passed in a http header variable you can set the name here; */
                //$config['Misc']['proxyipheader'] = 'HTTP_X_FORWARDED_FOR';
                
                /* #### Force VB ALT_IP ####
                Setting this will force vBulletin to use any internally detected alternative ip as the main ip address.
                The core checks three http headers (in order) HTTP_CLIENT_IP, HTTP_CF_CONNECTING_IP, HTTP_X_FORWARDED_FOR.
                It will use the first one it finds as IPADDRESS, and the original REMOTE_ADDR as ALT_IP.
                Do not use this option unless you understand what you are doing, and the possible consequences. */
                //define('USE_VB_ALT_IP', true);
                Ahaa I understand thank you
                I mean make her like this
                $ config ['Misc'] ['proxyiplist'] = '127.0.0.1, 192.168. *, all';
                And the rest too
                Delete the //

                Comment

                • Wayne Luke
                  vBulletin Technical Support Lead
                  • Aug 2000
                  • 73981

                  #9
                  You would have to ask your hosting provider....

                  127.0.0.1 is a loopback IP and only available on the machine. It isn't needed in the proxy IP list. If you're using this IP Address, it won't use a Proxy Server. In fact, there is no networking involved at all.

                  192.168.* isn't accessible from the internet. It is a block of IPs set aside for personal networking.
                  Translations provided by Google.

                  Wayne Luke
                  The Rabid Badger - a vBulletin Cloud demonstration site.
                  vBulletin 5 API

                  Comment

                  • Alshalan
                    Member
                    • Apr 2017
                    • 76
                    • 4.2.x

                    #10
                    Originally posted by Wayne Luke
                    You would have to ask your hosting provider....

                    127.0.0.1 is a loopback IP and only available on the machine. It isn't needed in the proxy IP list. If you're using this IP Address, it won't use a Proxy Server. In fact, there is no networking involved at all.

                    192.168.* isn't accessible from the internet. It is a block of IPs set aside for personal networking.
                    We have cloudflare

                    What do we do in this case?

                    Comment

                    • Alshalan
                      Member
                      • Apr 2017
                      • 76
                      • 4.2.x

                      #11
                      The problem is that in the ip forum are all present
                      But in the ipdada table, zeros appear
                      What is the solution?

                      Comment

                      • Alshalan
                        Member
                        • Apr 2017
                        • 76
                        • 4.2.x

                        #12
                        Originally posted by Wayne Luke
                        You would have to ask your hosting provider....

                        127.0.0.1 is a loopback IP and only available on the machine. It isn't needed in the proxy IP list. If you're using this IP Address, it won't use a Proxy Server. In fact, there is no networking involved at all.

                        192.168.* isn't accessible from the internet. It is a block of IPs set aside for personal networking.
                        The problem is that in the ip forum are all present
                        But in the ipdada table, zeros appear
                        What is the solution?

                        Comment

                        • Wayne Luke
                          vBulletin Technical Support Lead
                          • Aug 2000
                          • 73981

                          #13
                          I don't know what you mean by ip forum.

                          The solution is to apply the proper alternative IP location so vBulletin can record it.
                          Translations provided by Google.

                          Wayne Luke
                          The Rabid Badger - a vBulletin Cloud demonstration site.
                          vBulletin 5 API

                          Comment

                          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                          Working...