confluence server id 변경

confluence server id 변경 방법이다.

우선 mysql 접속

# mysql -u root -p

Enter password:

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 873

Server version: 5.1.66 Source distribution

Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use confluence;              --> db 접속

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

mysql> select * from BANDANA where bandanakey = 'confluence.server.id';       --> id 확인

+-----------+----------------+----------------------+--------------------------------------+

| BANDANAID | BANDANACONTEXT | BANDANAKEY           | BANDANAVALUE                         |

+-----------+----------------+----------------------+--------------------------------------+

|    491521 | _GLOBAL        | confluence.server.id | <string>xxxx-xxxx-xxxx-xxx4</string> |

+-----------+----------------+----------------------+--------------------------------------+

1 row in set (0.00 sec)

mysql>

mysql> update BANDANA set bandanavalue = '<string>xxxx-xxxx-xxxx-xxx5</string>' where bandanakey = 'confluence.server.id';               --> id 변경

Query OK, 1 row affected (0.08 sec)

Rows matched: 1  Changed: 1  Warnings: 0

mysql> select * from BANDANA where bandanakey = 'confluence.server.id';     --> id 변경된거 확인

+-----------+----------------+----------------------+--------------------------------------+

| BANDANAID | BANDANACONTEXT | BANDANAKEY           | BANDANAVALUE                         |

+-----------+----------------+----------------------+--------------------------------------+

|    491521 | _GLOBAL        | confluence.server.id | <string>xxxx-xxxx-xxxx-xxx5</string> |

+-----------+----------------+----------------------+--------------------------------------+

1 row in set (0.00 sec)

mysql>