【mysql】crowd在更改IP后无法登录的问题

页面导航:首页 > 数据库 > Mysql > 【mysql】crowd在更改IP后无法登录的问题

【mysql】crowd在更改IP后无法登录的问题

来源: 作者: 时间:2016-02-18 10:28 【

【mysql】crowd在更改IP后无法登录的问题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 ...
【】crowd在更改IP后无法登录的问题
 
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.
 
进入crowd库
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)

 

 
将新的IP按下面方式得到一个串,在shell下执行:
 
# IP=192.168.1.201; printf \\x$(printf "%X %X %X %X" $(echo $IP| tr . ' ')| sed 's/\ /\\x/g')| base64
wKgByQ==

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

 

 
重启crowd就可以了。
Tags:

文章评论

最 近 更 新
热 点 排 行
Js与CSS工具
代码转换工具

<