[Mysql] crowd cannot log on after changing the IP address _ MySQL

[Mysql] crowd cannot log on to bitsCN.com after changing the IP address

[Mysql] crowd cannot log on after changing the IP address

Org. codehaus. xfire. fault. XFireFault: Client with address "192.168.1.222", and hostname "192.168.1.222" is forbidden from making requests to the application, crowd.

Enter the crowd Library

mysql> select * from cwd_application_address;+----------------+-----------------------+-----------------------+---------------------+| application_id | remote_address        | remote_address_binary | remote_address_mask |+----------------+-----------------------+-----------------------+---------------------+|              2 | 127.0.0.1             | fwAAAQ==              |                   0 ||              2 | 192.168.1.111         | wKgBmw==              |                   0 ||              2 | localhost             | NULL                  |                   0 ||              2 | localhost.localdomain | NULL                  |                   0 ||              3 | 127.0.0.1             | fwAAAQ==              |                   0 ||              3 | localhost             | NULL                  |                   0 ||              4 | 127.0.0.1             | fwAAAQ==              |                   0 ||              4 | localhost             | NULL                  |                   0 ||              5 | 127.0.0.1             | fwAAAQ==              |                   0 ||              6 | 127.0.0.1             | fwAAAQ==              |                   0 ||              7 | 127.0.0.1             | fwAAAQ==              |                   0 |+----------------+-----------------------+-----------------------+---------------------+11 rows in set (0.00 sec)

Run the following command to obtain a string from the new IP address:

# IP=192.168.1.201; printf //x$(printf "%X %X %X %X" $(echo $IP| tr . ' ')| sed 's// ///x/g')| base64wKgByQ==mysql> update cwd_application_address set remote_address="192.168.1.222" , remote_address_binary="wKgByQ==" where application_id=2 and remote_address_binary="wKgBmw==";      Query OK, 1 row affected (0.00 sec)Rows matched: 1  Changed: 1  Warnings: 0

Restart crowd.

BitsCN.com