Announcement

Collapse
No announcement yet.

Help - Table Name

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • [Forum] Help - Table Name

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

    in vBulletin 4.2.5

  • #2
    Any Help?

    Comment


    • #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 customization and demonstration site.
      vBulletin 5 Documentation - Updated every Friday. Report issues here.
      vBulletin 5 API - Full / Mobile
      I am not currently available for vB Messenger Chats.

      Comment


      • #4
        Originally posted by Wayne Luke View Post
        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


        • #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 customization and demonstration site.
          vBulletin 5 Documentation - Updated every Friday. Report issues here.
          vBulletin 5 API - Full / Mobile
          I am not currently available for vB Messenger Chats.

          Comment


          • #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 View Post
            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 18th Dec '18, 9:55am.

            Comment


            • #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 customization and demonstration site.
              vBulletin 5 Documentation - Updated every Friday. Report issues here.
              vBulletin 5 API - Full / Mobile
              I am not currently available for vB Messenger Chats.

              Comment


              • #8
                Originally posted by Wayne Luke View Post
                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


                • #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 customization and demonstration site.
                  vBulletin 5 Documentation - Updated every Friday. Report issues here.
                  vBulletin 5 API - Full / Mobile
                  I am not currently available for vB Messenger Chats.

                  Comment


                  • #10
                    Originally posted by Wayne Luke View Post
                    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


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

                      Comment


                      • #12
                        Originally posted by Wayne Luke View Post
                        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


                        • #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 customization and demonstration site.
                          vBulletin 5 Documentation - Updated every Friday. Report issues here.
                          vBulletin 5 API - Full / Mobile
                          I am not currently available for vB Messenger Chats.

                          Comment

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