Install the openfire server on Ubuntu 9.04
1. install the sun-Java6-jre
2. install the openfile deb
3. install the mysql server
4. 设置mysql root帐户密码：
5. create openfire database in mysql
# mysql -u root -p
mysql> create database openfire
6. 导入mysql数据录对应的sql，创建数据表
mysql> use openfire
mysql> source /opt/openfire/resources/database/openfire_mysql.sql;
7.setup openfire url：[server ip]:9090
7.1 domain填入IP address
7.2 数据库选外部数据库mysql
jdbc:mysql://localhost:3306/openfire
8. admin/passwd不好用， 自己在数据库中改
8.1 使用Mysql查看工具进入数据库，进入表"ofuser"，将该表清空，
# mysql -u root -p openfire
mysql> delete from ofUser where username='admin' ;
Query OK, 1 row affected (0.01 sec)
8.2 然后执行该
mysql> INSERT INTO ofUser (username, plainPassword, name, email, creationDate, modificationDate)
-> VALUES ('admin','admin','Administrator','admin@example.com ','0','0');
Query OK, 1 row affected (0.00 sec)
9. 关闭openfire服务，就是从其控制台stop然后再start，再用用户名：admin,密码：admin登录即可