1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Can´t access PSA / admin login / IP range

Discussion in 'Plesk for Linux - 8.x and Older' started by testguys, Oct 20, 2006.

  1. testguys

    testguys Guest

    0
     
    Hi everybody,

    I have originally restricted access towards the login page /PSA to an IP range of 84.xxx.0.0/16. But surprisingly and without any notification the telco provider has changed the routing and now i have with my internet connection an IP from the range 217.224.0.0/11.

    Of course, i can´t log in at https://my-servers-ip:8443/login.php3 as admin any longer, even though the password is correct :((.

    I assume that the IP range is stored in the DB, how to "reset" it or delete it?
    I am using Plesk 8.0.1 - anyone knows what to do?

    Thank you
     
  2. testguys

    testguys Guest

    0
     
    SOLUTION

    For other users with that IP range change problem for login into the control / admin panel - that worked for me:

    SWsoft Knowledgebase

    LOGIN INTO MYSQL:

    sh:/ # mysql -uadmin -p psa
    Enter password:

    Welcome to the MySQL monitor. Commands end with ; or \g.
    Your MySQL connection id is 3100 to server version: 4.1.10a

    Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

    SEE WHAT IP´s ARE ACTIVE:

    mysql> select * from cp_access;
    +----+-------+------------+-------------+
    | id | type | netaddr | netmask |
    +----+-------+------------+-------------+
    | 1 | allow | 84.128.0.0 | 255.192.0.0 |
    | 2 | deny | 84.128.0.0 | 255.192.0.0 |
    +----+-------+------------+-------------+
    2 rows in set (0.00 sec)

    WHICH POLICY:

    mysql> select * from misc where param='access_policy';
    +---------------+------+
    | param | val |
    +---------------+------+
    | access_policy | deny |
    +---------------+------+
    1 row in set (0.00 sec)

    DID NOT WORK FOR ME:

    mysql> delete * from cp_access;
    ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* fro m cp_access' at line 1

    WORKED:

    mysql> update misc set val="allow" where param='access_policy';
    Query OK, 1 row affected (0.03 sec)
    Rows matched: 1 Changed: 1 Warnings: 0

    Problem solved :D *Very Happy* - Weekend is sunny again - ;)
     
Loading...