IM gateway not displaying registrations and wont connect to services

Openfire Plugins Kraken - IM Gateway
1

Hi

I have recently installed the IM gateway onto a wildfire server & am using spark as a IM client. I have ticked the needed services ie MSN & then tried to register a user. i get a tick saying registration successfully updated, but it doesnt become listed.

When i log into Spark i can see a grey msn icon & it will only give me the option to enter login information. Once i have done that nothing happens so i dont think it is working (that is assuming something is supposed to happen i.e my msn contacts apear or something). I have looked through this forum and think it maybe something to do with opening ports on teh firewall but am unsure.

In the actual debug logs I see the following:

2006.12.18 09:59:41 Registered jo@primary.intranetics.co.uk/spark as tinker.tiger@ntlworld.com in rosterless mode

2006.12.18 10:07:30 Received iq packet:

2006.12.18 10:13:20 Unable to find registration.

On the actual error log i see the following:

at org.mortbay.http.HttpConnection.service(HttpConnection.java:816)

at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:982)

at org.mortbay.http.HttpConnection.handle(HttpConnection.java:833)

at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)

at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)

at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)

2006.12.18 10:13:20 org.jivesoftware.wildfire.gateway.RegistrationManager.getRegistrations(Registrat ionManager.java:291)

java.sql.SQLException: Table ‘‘wildfire.gatewayRegistration’’ doesn’'t exist

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)

at com.mysql.jdbc.Connection.execSQL(Connection.java:3004)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1128)

at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1222)

at org.jivesoftware.wildfire.gateway.RegistrationManager.getRegistrations(Registra tionManager.java:285)

at org.jivesoftware.wildfire.plugin.gateway.gateway_002dregistrations_jsp._jspServ ice(gateway_002dregistrations_jsp.java:172)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)

at org.jivesoftware.wildfire.container.PluginServlet.handleJSP(PluginServlet.java: 234)

at org.jivesoftware.wildfire.container.PluginServlet.service(PluginServlet.java:92 )

at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)

at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:830)

at org.jivesoftware.admin.PluginFilter.doFilter(PluginFilter.java:69)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:821)

at org.jivesoftware.admin.AuthCheckFilter.doFilter(AuthCheckFilter.java:98)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:821)

at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:11 8)

at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:821)

at org.jivesoftware.util.LocaleFilter.doFilter(LocaleFilter.java:65)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:821)

at org.jivesoftware.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingF ilter.java:41)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:821)

at org.jivesoftware.admin.PluginFilter.doFilter(PluginFilter.java:69)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:821)

at org.jivesoftware.admin.AuthCheckFilter.doFilter(AuthCheckFilter.java:98)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:821)

at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler. java:471)

at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568)

at org.mortbay.http.HttpContext.handle(HttpContext.java:1530)

at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.ja va:633)

at org.mortbay.http.HttpContext.handle(HttpContext.java:1482)

at org.mortbay.http.HttpServer.service(HttpServer.java:909)

at org.mortbay.http.HttpConnection.service(HttpConnection.java:816)

at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:982)

at org.mortbay.http.HttpConnection.handle(HttpConnection.java:833)

at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)

at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)

at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)

I am unsure what is going on. any help or advise anybody could give me would be greatky appreciated

Many thanks

2

Judging from this line: java.sql.SQLException: Table ‘‘wildfire.gatewayRegistration’’ doesn’'t exist

The necessary database tables were never created on your server. What type of DB are you using for Wildfire? (it should automatically have created the tables it needed)

3

Actually, I can see MySQL in the error log there. Did you see any errors what-so-ever related to the database upgrade itself? Try logging into your mysql server and doing the following query:

select * from jiveVersion where name = “gateway”

Let me know what that says, if anything. Likewise, you may be able to “reload” the plugin from the plugins page and see the error message from the table creation again.

4

Thank you very much for your quick reply. I will do what you suggest ad get back to you

thanks

5

The MySql server doesnt return anything at all when that sql statement is run. The only info in the jive version table only has the name and version in the actual table

6

What version of wildfire are you running?

7

I am using Wildfire Enterprise 3.1.1with teh latest version of the IM gateway

8

That… is awefully bizarre. Wildfire is supposed to be checking jiveVersion for the gateway plugin’'s db version number, and running updates as necessary. No matter, Look in plugins/gateway/database/gateway_mysql.sql and run that by hand in whatever your wildfire database is. Then restart wildfire and you should be good to go.

9

Wildfire 3.1.1

Spark 2.0.7

I have same problem with last beta version of IM-gateway. Previous version is working fine, buth there be problems with russian encoding in incoming messages from ICQ-buddies. Because of this I change IM-gateway to PyICQt and it working fine.

After realease of 1.0 Beta6a I try to change PyICQt to IM-Gateway. After copying gateway.jar to plugins directory and restart of Wildfire server I can’'t see my ICQ-buddies list. Status of ICQ is online, in server error log there is nothing about problems with icq transport. In Info log - “icq transport started”.

Please help me. I want to finally change PyICQt to IM-gateway - I do like their abilities of user access control to ICQ transport.

10

Hi

Thanks for your reply.

this is the query in that file:

ALTER TABLE gatewayRegistration ADD COLUMN nickname VARCHAR(255) NULL AFTER password;

  1. Add pseudo roster table

CREATE TABLE gatewayPseudoRoster (

registrationID BIGINT NOT NULL,

username VARCHAR(255) NOT NULL,

nickname VARCHAR(255),

groups VARCHAR(255),

INDEX gatewayPsRs_regid_idx(registrationID),

INDEX gatewayPsRs_uname_idx(username)

);

  1. Update database version

UPDATE jiveVersion SET version = 1 WHERE name = ‘‘gateway’’;

but mysql throws an error saying that the table gatewayRegistration doesn’'t exist.

11

I believe I have fixed the database scripts at this point (GATE-151). They will be repaired in 1.0 Beta 6b. (I need to fix ICQ support as well, whatever has happened to it is currently baffling me)

I will be posting “how to fix your current database” instructions as well at the time.

12

Thank you that did the trick

many thanks

Assetz