Install openfire on Ubuntu

First, the [tag] Ubuntu [/Tag] Server Installation will not be mentioned. You can view this article on this site. [tag] openfire [/Tag] requires lamp, select this option when installing the server.
1. Install phpMyAdmin directly in the new software package;
2. Set the MySQL Root Account password:

1. $ Mysql-u Root
2. Mysql> grant all privileges on *. * to root @ localhost identified by "123456 ";

3. Use phpMyAdmin to create a database named "openfire" and select "utf-8_unicode_ci" as the sorting format"
4. Download openfire. Of course, Deb format is downloaded under Ubuntu. The latest version is 3.4.3, which is officially available on this site.
5. install Java

1. $ Sudo apt-Get install sun-java6-bin
2. $ Sudo Update-alternatives -- config Java

Select Java 6 as the default Java environment

1. /Usr/lib/JVM/Java-6-sun/JRE/bin/Java

6. Install openfire_3.4.3_all.deb
7. After the installation is complete, access http: // localhost: 9090/and set it. The setting process is simple. Here is a detailed graphic tutorial,
Note that when selecting a database

1. JDBC: mysql: // [host-name]: 3306/[database-name]

Changed:

1. JDBC: mysql: // localhost: 3306/openfire? Useunicode = true & characterencoding = UTF-8 & charactersetresults = UTF-8

The actual information should be:

1. JDBC: mysql: // localhost: 3306/openfire? Useunicode = true & amp; characterencoding = UTF-8 & amp; charactersetresults = UTF-8