Custom Database(db2) Integration Error

Openfire Openfire Dev
1

hi all,

when I use wildfire to integrate with my user table,which is use db2 database, and use its user which is in the db2 database to login in wildfire system,it will throw exceptions as follows:

COM.ibm.db2.jdbc.DB2Exception: [JDBC Driver] CLI0618E User ID and/or Password is incorrect. SQLSTATE=28000

but when i use mysql database, it can run normally,why? could someone help me? thank you very much!

my part config is as follows, other is the same:

<!mysql,run normally>

2

no one can help me???

3

Hi hdhmail2000,

After doing a quick Google and finding this link it looks like your connectionString is not quite formatted correctly, try the following:

<connectionString>jdbc:db2://localhost:6789/message:user=db2;password=admin;</connectionString>

Hope that helps,

Ryan

4

it also throws exceptions

5

Try chaning your driver settings to the following:

<driver>COM.ibm.db2.jdbc.app.DB2Driver</driver>

Thanks,

Ryan

Message was edited by: ryang - changed “net” to “app”

6

I haven’'t resolved it yet . I have updated it follow your advice

it seem that such format data string is only suited for mysql database, other database may be need to separate the url , user name and password. If that is true, what should i do?

did some one use other database except mysql? if you do ,could you share your experience with me?

7

Hi hdhmail2000,

The connection url is going to vary greatly depending on the database. For instance, the Oracle url looks like:

"jdbc:oracle:thin:[username]/[password]@[host-name]:1521:[SID]"

so I don’‘t that’'s going to help you much.

Since everything else looks right, something you might want to try is to go through the Wildfire setup process and see if you can connect to DB2 as if you weren’‘t using the custom database integration. That will at least eliminate the possibility that it’'s a permissions issue.

Thanks,

Ryan

8

hi,Ryan

thank you for your care about it all the time. mybe db2 haven’'t such connection string.

so i read the Wildfire source code, and update the connection method.well,i can connect db2 now .

i suggest that it’’’'d better use url, username and password in database connection config separately, not use it together. only my suggestion:)

9

Hi hdhmail2000,

Good to hear you got it working.

I agree that the username and password fields should be split into their own elements, I’'ll create a JIRA issue for that.

Cheers,

Ryan

10

My wildfire.xml is follow:

<!Add by me>

<!Add by me>

<!Add by me>

<!Add by me>

<!Add by me>

<!Add by me>