Wildfire with Firebird setup

Openfire Openfire Support
1

Hi everybody!

I am a newbie with Wildfire. I am using jabberd 1.4. Now, I want to try Wildfire. However, I have a problem that I want to setup Wildfire with Firebird. Please help me! Is there any one setup Wildfire with Firebird successfully? If there is, please share sql script with me. Where I have to put Firebird JDBC driver? I have put it into libs folder. Unfortunately, Wildfire haven’'t found it.

Thanks in advance!

2

We don’'t officially support Firebird. From a quick forums search, it looks like there might be a few problems like the fact that “password” is a reserved keyword, but we use it in the Wildfire schema. So, two options:

  1. Choose a different database such as MySQL or even the embedded database.

  2. Create a SQL script for Firebird, perform some testing, then help fix any issues that you run into. We wouldn’'t be able to add the script to the official release and support it, but it could be maintained as a community add-on.

Regards,

Matt

3

Thanks matt!

I converted mysql sql script into firebird sql script.

my wildfire.xml contains the following lines:

(XMPPServer.java:145)

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

at java.lang.reflect.Constructor.newInstance(Unknown Source)

at java.lang.Class.newInstance0(Unknown Source)

at java.lang.Class.newInstance(Unknown Source)

at org.jivesoftware.wildfire.starter.ServerStarter.start(ServerStarter.java:88)

at org.jivesoftware.wildfire.starter.ServerStarter.main(ServerStarter.java:49)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at com.exe4j.runtime.LauncherEngine.launch(Unknown Source)

at com.exe4j.runtime.WinLauncher.main(Unknown Source)

Note that line 78 is the connectionString line.

4

Because it’'s XML, you need to escape any “&” characters. To do that,

enter them as &

-Matt