crowd在更改IP后无法登录的问题(2)

来源：未知责任编辑：责任编辑发表时间:2014-01-25 11:34　点击:次

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