【mysql】crowd在更改IP后无法登录的问题_MySQL
程序员文章站
2024-01-12 21:23:28
...
bitsCN.com
【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')| 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
重启crowd就可以了。
bitsCN.com推荐阅读
-
【mysql】crowd在更改IP后无法登录的问题_MySQL
-
【mysql】crowd在更改IP后无法登录的问题_MySQL
-
在Windows7上安装MySQL5.6后没有服务,无法启动的问题_MySQL
-
在Windows7上安装MySQL5.6后没有服务,无法启动的问题_MySQL
-
用ADO更新MYSQL报“无法为更新定位行。一些值可能已在最后一次读取后已更改”问题的解决_MySQL
-
用ADO更新MYSQL报“无法为更新定位行。一些值可能已在最后一次读取后已更改”问题的解决_MySQL
-
解决MySQL5.7安装后没有data文件夹无法登录的问题_MySQL
-
解决MySQL5.7安装后没有data文件夹无法登录的问题_MySQL