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:.