【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 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就可以了。
