Announcement

Collapse
No announcement yet.

Banned IP addresses have admin locked out too... need assistance

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

  • [Forum] Banned IP addresses have admin locked out too... need assistance

    Somehow the admin's IP has been blocked & locked out of the admin control panel.

    We would like to clean out the banned IP addresses, but cannot get in to accomplish that task.

    Any assistance on how to get into CP would be greatly appreciated.


    EtBliss

  • #2
    ***TAKE A BACKUP OF YOUR DATABASE BEFORE RUNNING ANY QUERY AGAINST IT***

    Run this in phpMyAdmin:

    UPDATE PREFIX_setting SET value = "" WHERE varname = "banip";

    If your tables use a prefix, change PREFIX_ to that prefix, if not, remove that from the query. This will clear all banned IP addresses from the database and let you log in again - be VERY careful about what you're entering when you restore IP addresses to that field in AdminCP
    Vote for:

    - *Admin Settable Paid Subscription Reminder Timeframe*
    -
    *PM - Add ability to reply to originator only*
    - Add Admin ability to auto-subscribe users to specific channel(s)
    - Highlight the correct navigation tab when you are on a custom page
    - "Quick Route" Interface...
    - Allow to use custom icons for individual forums

    Comment


    • #3
      Thank you. Your response was very fast! Impressive.

      Comment


      • #4
        Originally posted by Trevor Hannant View Post
        ***TAKE A BACKUP OF YOUR DATABASE BEFORE RUNNING ANY QUERY AGAINST IT***

        Run this in phpMyAdmin:

        UPDATE PREFIX_setting SET value = "" WHERE varname = "banip";

        If your tables use a prefix, change PREFIX_ to that prefix, if not, remove that from the query. This will clear all banned IP addresses from the database and let you log in again - be VERY careful about what you're entering when you restore IP addresses to that field in AdminCP
        Our web person ran the query and we are still locked out. Is there a plan "B"

        Thank you

        Comment


        • #5
          What is the contents of your htaccess file?

          Comment


          • #6
            I just looked in the directory and the only file I found was in a backup folder and this was the only data in the file.

            AuthType Basic
            AuthName "User Backups"
            AuthUserFile /home/content/23/6745723/html/stats/.statspwd
            require valid-user
            Options +Indexes

            Comment


            • #7
              Originally posted by etbliss View Post
              Our web person ran the query and we are still locked out. Is there a plan "B"

              Thank you
              You can try a proxy such as http://anonymouse.org
              Go to the ACP with it , delete the banned IPs, change the admin's password.


              vB5 is unequivocally the best forum software, but not yet...

              Comment


              • #8
                Originally posted by beishe8 View Post
                You can try a proxy such as http://anonymouse.org
                Go to the ACP with it , delete the banned IPs, change the admin's password.
                I had tried that, and attempted again just now, and still locked out. Awfully frustrating. Anything else I can try?

                Thank you...

                Tom

                Comment


                • #9
                  What is the actual error message the admin gets when he tries to log in?
                  MARK.B | vBULLETIN SUPPORT

                  TalkNewsUK - My vBulletin 5.6.0 Demo
                  AdminAmmo - My Cloud Demo

                  Comment


                  • #10
                    You can use tools.php from the "Do Not Upload" folder to create a new admin account and unban any IP addresses banned from the AdminCP. You may have to use this tool via proxy in order to use an IP address which is not banned.

                    Comment


                    • #11
                      Originally posted by Mark.B View Post
                      What is the actual error message the admin gets when he tries to log in?
                      "Sorry. The administrator has banned your IP address. To contact the administrator click here"

                      Click image for larger version

Name:	Screen Shot 2012-12-18 at 11.15.46 PM.png
Views:	1
Size:	28.3 KB
ID:	3690911

                      http://www.architecturalphotographer...n.php?do=login

                      Comment


                      • #12
                        I am getting that error too. This is not the login strikes system causing this...the site is behaving as if all IPs are banned.

                        Could be a number of causes. Please drop me a PM regarding this.
                        MARK.B | vBULLETIN SUPPORT

                        TalkNewsUK - My vBulletin 5.6.0 Demo
                        AdminAmmo - My Cloud Demo

                        Comment


                        • #13
                          For the record, this is now fixed with some magic from tools.php.
                          MARK.B | vBULLETIN SUPPORT

                          TalkNewsUK - My vBulletin 5.6.0 Demo
                          AdminAmmo - My Cloud Demo

                          Comment


                          • #14
                            Originally posted by ProSportsForums View Post
                            You can use tools.php from the "Do Not Upload" folder to create a new admin account and unban any IP addresses banned from the AdminCP. You may have to use this tool via proxy in order to use an IP address which is not banned.
                            This is the best answer ^^

                            *edit* I see it worked too
                            -- Web Developer for hire
                            ---Online Marketing Tools and Articles

                            Comment


                            • #15
                              Originally posted by Loco.M View Post
                              This is the best answer ^^

                              *edit* I see it worked too
                              It did, but not quite the way described.

                              Creating a new admin account would have simply run into the same problem...the issue was that NOBODY could access the site, as all sessions were getting an IP banned message.
                              MARK.B | vBULLETIN SUPPORT

                              TalkNewsUK - My vBulletin 5.6.0 Demo
                              AdminAmmo - My Cloud Demo

                              Comment

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