Bikin server Chat dengan Openfire dengan 2 database berbeda (user nya)

Oke langsung aja step step nya
- download openfire disinih
http://www.igniterealtime.org/downloads/index.jsp
- karena gwe pake yang RPM jadi
ketik aja
% rpm -Uvw openfire.x.x.x.rpm
- terus cek ke /opt/openfire/
- kalo udah ada buat database di lokal server dulu (buat openfire nya)
- kalo dah kelar nyalain openfire pake
% service openfire start
- kalo dah nyala akses via web dengan alamat http://ipnya:9090/ nanti ada gui
untuk instalasi

- lanjut aja wizardnya ampe kelar (lo pasti ngerti caranya), ampe bisa login
- udah gitu matiin server nya
- masuk ke /opt/openfire/conf/
- ketik
% vi openfire.xml
nah buat setingannya kaya gini

<jive>
<jdbcProvider>
<driver>com.mysql.jdbc.Driver</driver>
<connectionString>jdbc:mysql://ipdatabaseuser/dbname?user=usname&amp;password=pass</connectionString>
</jdbcProvider>
<provider>
<auth>
<!-- ini kalo pake enkripsi sendiri -->
<className>com.gusto.plasa.auth.JDBCPlasaAuthProvider</className>
<!-- ini kalo pake enkripsi sendiri -->
<className>org.jivesoftware.openfire.user.JDBCUserProvider</className>
</auth>
<user>
<className>org.jivesoftware.openfire.user.JDBCUserProvider</className>
</user>
</provider>
<jdbcAuthProvider>
<passwordSQL>SELECT password FROM tbl_user WHERE username=?</passwordSQL>
<passwordType>crypt3</passwordType>
</jdbcAuthProvider>
<jdbcUserProvider>
<loadUserSQL>SELECT nama,email FROM tbl_user WHERE username=?</loadUserSQL>
<userCountSQL>SELECT COUNT(*) FROM tbl_user</userCountSQL>
<allUsersSQL>SELECT username FROM tbl_user</allUsersSQL>
<searchSQL>SELECT username FROM tbl_user WHERE</searchSQL>
<usernameField>username</usernameField>
<nameField>nama</nameField>
<emailField>email</emailField>
</jdbcUserProvider>
<!-- END MARDI -->
<adminConsole>
<!-- Disable either port by setting the value to -1 -->
<port>9090</port>
<securePort>9091</securePort>
</adminConsole>
<locale>en</locale>

<connectionProvider>
<className>org.jivesoftware.database.DefaultConnectionProvider</className>
</connectionProvider>
<database>
<defaultProvider>
<driver>com.mysql.jdbc.Driver</driver>
<serverURL>jdbc:mysql://localhost:3306/openfire</serverURL>
<username>xxxxxxxx</username>
<password>xxxxxxxx</password>
<testSQL>select 1</testSQL>
<testBeforeUse>true</testBeforeUse>
<testAfterUse>true</testAfterUse>
<minConnections>5</minConnections>
<maxConnections>25</maxConnections>
<connectionTimeout>1.0</connectionTimeout>
</defaultProvider>
</database>
<setup>true</setup>
</jive>

- restart lagi openfire dan walah nyala deh server openfire

.:cool_sinchan@yahoo.com:.