Projects tigase _server server-core Issues #318
History of Chatting messages are not storing into the TIG_MA_MSGS table (#318)
Closed
Khaleel Shaik opened 1 decade ago

Hi,

We have installed Tigase 5.2 server in five servers. In one server everything working fine. But in the remaining four instances the History of Chatting messages are not storing into the TIG_MA_MSGS table.

Our init.property file configuration related to Messae Archive is:

--user-db = mysql

--user-db-uri = jdbc:mysql://localhost/tigasenewdb?user=tigase&password=tigase123

--comp-name-6 = message-archive

--comp-class-6 = tigase.archive.MessageArchiveComponent

message-archive/archive-repo-uri = jdbc:mysql://localhost/tigasenewdb?user=tigase&password=tigase123

--message-archive/auto = true

--sm-plugins = +message-archive-xep-0136

sess-man/plugins-conf/message-archive-xep-0136/component-jid = admin@localhost

sess-man/plugins-conf/message-archive-xep-0136/default-store-method = message

sess-man/plugins-conf/message-archive-xep-0136/required-store-method=body

Any thing else missing? How to debug this issue? any guide is also helpful.

Thanks

Khaleel

Artur Hefczyc commented 1 decade ago

Please use our forums to ask general questions and the issue tracking system to report bug and other issues.

To answer your question, you most likely should remove the line:

sess-man/plugins-conf/message-archive-xep-0136/component-jid = admin@localhost
Khaleel Shaik commented 1 decade ago

Hi,

Thanks for quick reply. I have removed that line, still I didn't see any difference.

Here is my complete properties now:

--virt-hosts = lpt-khalshai, lpt-khalshai.bodhtree-int.com, localhost

--auth-db = mysql

--auth-db-uri = jdbc:mysql://localhost/tigasenewdb?user=tigase&password=tigase123

--user-db = mysql

--user-db-uri = jdbc:mysql://localhost/tigasenewdb?user=tigase&password=tigase123

--admins = admin@localhost

#config-type = --gen-config-def

config-type = --gen-config-all

--comp-name-1 = muc

#--comp-class-1 = tigase.muc.MUCComponent

--comp-class-1 = tigase.muc.cluster.MUCComponentClustered

--comp-name-2 = pubsub

#--comp-class-2 = tigase.pubsub.PubSubComponent

--comp-class-2 = tigase.pubsub.cluster.PubSubComponentClustered

--comp-name-3 = proxy

--comp-class-3 = tigase.socks5.Socks5ProxyComponent

#--comp-name-4 = stun

#--comp-class-4 = tigase.stun.StunComponent

--comp-name-5 = rest

--comp-class-5 = tigase.http.rest.RestMessageReceiver

--comp-name-6 = message-archive

--comp-class-6 = tigase.archive.MessageArchiveComponent

message-archive/archive-repo-uri = jdbc:mysql://localhost/tigasenewdb?user=tigase&password=tigase123

--message-archive/auto = true

--comp-name-7 = test

--comp-class-7 = test.BoshTest

--cluster-mode = false

#--cluster-nodes= (add comma separated if there are more servers in cluster)

--sm-plugins = +message-archive-xep-0136,+jabber:iq:auth,+urn:ietf:params:xml:ns:xmpp-sasl,+urn:ietf:params:xml:ns:xmpp-bind,+urn:ietf:params:xml:ns:xmpp-session,+jabber:iq:register,+jabber:iq:roster,+presence,+jabber:iq:privacy,+jabber:iq:version,+http://jabber.org/protocol/stats,+starttls,+msgoffline,+vcard-temp,+http://jabber.org/protocol/commands,+jabber:iq:private,+urn:xmpp:ping,+basic-filter,+domain-filter,+pep,-zlib

#sess-man/plugins-conf/message-archive-xep-0136/component-jid = admin@localhost

#sess-man/plugins-conf/message-archive-xep-0136/default-store-method = message

#sess-man/plugins-conf/message-archive-xep-0136/required-store-method=body

--debug = server,xmpp.impl,db,cluster,tigase.server.bosh

#Khaleel added

--tls-jdk-nss-bug-workaround-active=true

--bosh-extra-headers-file=/etc/tigase/bosh-extra-headers-file.txt

--bosh-ports=5280,5281

--bosh/connections/5281/socket=ssl

--bosh/connections/5281/type=accept

#For Embeded Jetty Server for HTTP-API server

#--port=8080

#--context=/rest

#--rest-scripts-dir=/scripts/rest/

#--rest/use-local-server=false

--basic-conf/auth-repo-params/sasl-mechs=PLAIN

Any more changes required in these properties? please help.

Thanks,

Khaleel

Khaleel Shaik commented 1 decade ago

Hi,

Here is the complete log file:

componentInfo{Title=Tigase XMPP Server, Version=5.2.0-b3447/48635d0a (2014-02-12/17:29:15), Class=tigase.xml.XMLUtils}

componentInfo{Title=Tigase XMPP Server, Version=5.2.0-b3447/48635d0a (2014-02-12/17:29:15), Class=tigase.util.ClassUtil}

componentInfo{Class=tigase.server.XMPPServer}

2014-04-24 09:16:38.131 [main] DNSResolver.() WARNING: Resolving default host name took: 15

2014-04-24 09:16:38.148 [main] ConfiguratorAbstract.parseArgs() CONFIG: Setting defaults: -Djdbc.drivers=com.mysql.jdbc.Driver = tigase.server.XMPPServer

2014-04-24 09:16:38.148 [main] ConfiguratorAbstract.parseArgs() CONFIG: Setting defaults: --property-file = etc/init.properties

2014-04-24 09:16:38.149 [main] ConfiguratorAbstract.parseArgs() CONFIG: Loading initial properties from property file: etc/init.properties

2014-04-24 09:16:38.151 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--comp-class-1=tigase.muc.cluster.MUCComponentClustered)

2014-04-24 09:16:38.152 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--bosh/connections/5281/socket=ssl)

2014-04-24 09:16:38.152 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--virt-hosts=lpt-khalshai, lpt-khalshai.bodhtree-int.com, localhost)

2014-04-24 09:16:38.153 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--auth-db-uri=jdbc:mysql://localhost/tigasenewdb?user=tigase&password=tigase123)

2014-04-24 09:16:38.153 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--user-db-uri=jdbc:mysql://localhost/tigasenewdb?user=tigase&password=tigase123)

2014-04-24 09:16:38.154 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--user-db=mysql)

2014-04-24 09:16:38.155 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--bosh-ports=5280,5281)

2014-04-24 09:16:38.155 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--admins=admin@localhost)

2014-04-24 09:16:38.155 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--tls-jdk-nss-bug-workaround-active=true)

2014-04-24 09:16:38.156 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--bosh-extra-headers-file=/etc/tigase/bosh-extra-headers-file.txt)

2014-04-24 09:16:38.156 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--comp-name-7=test)

2014-04-24 09:16:38.156 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--comp-name-6=message-archive)

2014-04-24 09:16:38.157 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--comp-name-5=rest)

2014-04-24 09:16:38.157 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--auth-db=mysql)

2014-04-24 09:16:38.157 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--message-archive/auto=true)

2014-04-24 09:16:38.157 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (config-type=--gen-config-all)

2014-04-24 09:16:38.157 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--comp-name-3=proxy)

2014-04-24 09:16:38.158 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--comp-name-2=pubsub)

2014-04-24 09:16:38.158 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--comp-name-1=muc)

2014-04-24 09:16:38.158 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--cluster-mode=false)

2014-04-24 09:16:38.158 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--sm-plugins=+message-archive-xep-0136,+jabber:iq:auth,+urn:ietf:params:xml:ns:xmpp-sasl,+urn:ietf:params:xml:ns:xmpp-bind,+urn:ietf:params:xml:ns:xmpp-session,+jabber:iq:register,+jabber:iq:roster,+presence,+jabber:iq:privacy,+jabber:iq:version,+http://jabber.org/protocol/stats,+starttls,+msgoffline,+vcard-temp,+http://jabber.org/protocol/commands,+jabber:iq:private,+urn:xmpp:ping,+basic-filter,+domain-filter,+pep,-zlib)

2014-04-24 09:16:38.159 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--basic-conf/auth-repo-params/sasl-mechs=PLAIN)

2014-04-24 09:16:38.159 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--comp-class-7=test.BoshTest)

2014-04-24 09:16:38.159 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--comp-class-6=tigase.archive.MessageArchiveComponent)

2014-04-24 09:16:38.159 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--debug=server,xmpp.impl,db,cluster,tigase.server.bosh)

2014-04-24 09:16:38.160 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--comp-class-5=tigase.http.rest.RestMessageReceiver)

2014-04-24 09:16:38.160 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--bosh/connections/5281/type=accept)

2014-04-24 09:16:38.160 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--comp-class-3=tigase.socks5.Socks5ProxyComponent)

2014-04-24 09:16:38.160 [main] ConfiguratorAbstract.parseArgs() CONFIG: Added default config parameter: (--comp-class-2=tigase.pubsub.cluster.PubSubComponentClustered)

2014-04-24 09:16:38.177 [main] MessageRouter.addRegistrator() INFO: Adding registrator: Configurator

2014-04-24 09:16:38.177 [main] MessageRouter.addComponent() INFO: Adding component:

2014-04-24 09:16:38.178 [main] ConfiguratorAbstract.componentAdded() CONFIG: component: basic-conf

2014-04-24 09:16:38.178 [main] ConfiguratorAbstract.setup() CONFIG: Setting up component: basic-conf

2014-04-24 09:16:38.180 [main] ConfiguratorAbstract.setup() CONFIG: Component basic-conf defaults: {component-id=basic-conf@lpt-khalshai.bodhtree-int.com, def-hostname=lpt-khalshai.bodhtree-int.com, admins=[Ljava.lang.String;@103d246, scripts-dir=scripts/admin, command/ALL=ADMIN, logging/.level=CONFIG, logging/handlers=java.util.logging.ConsoleHandler java.util.logging.FileHandler, logging/java.util.logging.ConsoleHandler.formatter=tigase.util.LogFormatter, logging/java.util.logging.ConsoleHandler.level=WARNING, logging/java.util.logging.FileHandler.append=true, logging/java.util.logging.FileHandler.count=5, logging/java.util.logging.FileHandler.formatter=tigase.util.LogFormatter, logging/java.util.logging.FileHandler.limit=10000000, logging/java.util.logging.FileHandler.pattern=logs/tigase.log, logging/tigase.useParentHandlers=true, logging/java.util.logging.FileHandler.level=ALL, logging/tigase.server.level=ALL, logging/tigase.xmpp.impl.level=ALL, logging/tigase.db.level=ALL, logging/tigase.cluster.level=ALL, logging/tigase.tigase.server.bosh.level=ALL, user-domain-repo-pool=tigase.db.UserRepositoryMDImpl, auth-domain-repo-pool=tigase.db.AuthRepositoryMDImpl, user-repo-pool-size=10, data-repo-pool-size=10, user-repo-class=mysql, user-repo-url=jdbc:mysql://localhost/tigasenewdb?user=tigase&password=tigase123, auth-repo-class=mysql, auth-repo-url=jdbc:mysql://localhost/tigasenewdb?user=tigase&password=tigase123, ssl-container-class=tigase.io.SSLContextContainer, ssl-certs-location=certs/, ssl-def-cert-domain=default, config-dump-file=etc/config-dump.properties}

2014-04-24 09:16:38.180 [main] ConfiguratorAbstract.setup() CONFIG: Component basic-conf configuration: {component-id=basic-conf@lpt-khalshai.bodhtree-int.com, def-hostname=lpt-khalshai.bodhtree-int.com, admins=[Ljava.lang.String;@103d246, scripts-dir=scripts/admin, command/ALL=ADMIN, logging/.level=CONFIG, logging/handlers=java.util.logging.ConsoleHandler java.util.logging.FileHandler, logging/java.util.logging.ConsoleHandler.formatter=tigase.util.LogFormatter, logging/java.util.logging.ConsoleHandler.level=WARNING, logging/java.util.logging.FileHandler.append=true, logging/java.util.logging.FileHandler.count=5, logging/java.util.logging.FileHandler.formatter=tigase.util.LogFormatter, logging/java.util.logging.FileHandler.limit=10000000, logging/java.util.logging.FileHandler.pattern=logs/tigase.log, logging/tigase.useParentHandlers=true, logging/java.util.logging.FileHandler.level=ALL, logging/tigase.server.level=ALL, logging/tigase.xmpp.impl.level=ALL, logging/tigase.db.level=ALL, logging/tigase.cluster.level=ALL, logging/tigase.tigase.server.bosh.level=ALL, user-domain-repo-pool=tigase.db.UserRepositoryMDImpl, auth-domain-repo-pool=tigase.db.AuthRepositoryMDImpl, user-repo-pool-size=10, data-repo-pool-size=10, user-repo-class=mysql, user-repo-url=jdbc:mysql://localhost/tigasenewdb?user=tigase&password=tigase123, auth-repo-class=mysql, auth-repo-url=jdbc:mysql://localhost/tigasenewdb?user=tigase&password=tigase123, ssl-container-class=tigase.io.SSLContextContainer, ssl-certs-location=certs/, ssl-def-cert-domain=default, config-dump-file=etc/config-dump.properties}

2014-04-24 09:16:38.181 [main] ConfiguratorAbstract.setProperties() INFO: Propeties size is 37, and here are all propeties: {component-id=basic-conf@lpt-khalshai.bodhtree-int.com, def-hostname=lpt-khalshai.bodhtree-int.com, admins=[Ljava.lang.String;@103d246, scripts-dir=scripts/admin, command/ALL=ADMIN, logging/.level=CONFIG, logging/handlers=java.util.logging.ConsoleHandler java.util.logging.FileHandler, logging/java.util.logging.ConsoleHandler.formatter=tigase.util.LogFormatter, logging/java.util.logging.ConsoleHandler.level=WARNING, logging/java.util.logging.FileHandler.append=true, logging/java.util.logging.FileHandler.count=5, logging/java.util.logging.FileHandler.formatter=tigase.util.LogFormatter, logging/java.util.logging.FileHandler.limit=10000000, logging/java.util.logging.FileHandler.pattern=logs/tigase.log, logging/tigase.useParentHandlers=true, logging/java.util.logging.FileHandler.level=ALL, logging/tigase.server.level=ALL, logging/tigase.xmpp.impl.level=ALL, logging/tigase.db.level=ALL, logging/tigase.cluster.level=ALL, logging/tigase.tigase.server.bosh.level=ALL, user-domain-repo-pool=tigase.db.UserRepositoryMDImpl, auth-domain-repo-pool=tigase.db.AuthRepositoryMDImpl, user-repo-pool-size=10, data-repo-pool-size=10, user-repo-class=mysql, user-repo-url=jdbc:mysql://localhost/tigasenewdb?user=tigase&password=tigase123, auth-repo-class=mysql, auth-repo-url=jdbc:mysql://localhost/tigasenewdb?user=tigase&password=tigase123, ssl-container-class=tigase.io.SSLContextContainer, ssl-certs-location=certs/, ssl-def-cert-domain=default, config-dump-file=etc/config-dump.properties, shared-user-repo=null, shared-user-repo-params=null, shared-auth-repo=null, shared-auth-repo-params=null}

Jid vhost-manager;

2014-04-24 09:16:39.766 [main] VHostManager.setProperties() WARNING: {localhost=Domain: localhost, enabled: true, anonym: true, register: true, maxusers: 0, tls: false, s2sSecret: null, domainFilter: ALL, lpt-khalshai=Domain: lpt-khalshai, enabled: true, anonym: true, register: true, maxusers: 0, tls: false, s2sSecret: null, domainFilter: ALL, lpt-khalshai.bodhtree-int.com=Domain: lpt-khalshai.bodhtree-int.com, enabled: true, anonym: true, register: true, maxusers: 0, tls: false, s2sSecret: null, domainFilter: ALL}

2014-04-24 09:16:39.843 [main] MessageRouterConfig.hasClassForServerComponent() WARNING: Can't load component rest: tigase.http.rest.RestMessageReceiver

Loading component: bosh :: componentInfo{Class=tigase.server.bosh.BoshConnectionManager}

Loading component: c2s :: componentInfo{Class=tigase.server.xmppclient.ClientConnectionManager}

Loading component: message-archive :: componentInfo{Title=Tigase Message Archiving Component, Version=1.0.0-b36/0fe62ee0, Class=tigase.archive.MessageArchiveComponent}

Loading component: monitor :: componentInfo{Class=tigase.server.monitor.MonitorComponent}

Loading component: muc :: componentInfo{Title=Tigase Advanced Clustering Strategy - MUC Component, Version=1.0.0-b15/e8435c02, Class=tigase.muc.cluster.MUCComponentClustered, componentData={MUCClusteringStrategy=class tigase.muc.cluster.DefaultStrategy}}

Loading component: proxy :: componentInfo{Title=Tigase Socks5 Component, Version=1.0.0-b41/0e920198, Class=tigase.socks5.Socks5ProxyComponent}

Loading component: pubsub :: componentInfo{Title=Tigase Advanced Clustering Strategy - PubSub Component, Version=1.0.0-b13/158bb9d3, Class=tigase.pubsub.cluster.PubSubComponentClustered, componentData={PubSubClusteringStrategy=class tigase.pubsub.cluster.PartitionedStrategy}}

Loading component: s2s :: componentInfo{Class=tigase.server.xmppserver.S2SConnectionManager}

Loading plugin: session-close=4 ...

Loading plugin: session-open=4 ...

Loading plugin: default-handler=4 ...

Loading plugin: jabber:iq:register=4 ...

Loading plugin: jabber:iq:auth=4 ...

Loading plugin: urn:ietf:params:xml:ns:xmpp-sasl=4 ...

Loading plugin: urn:ietf:params:xml:ns:xmpp-bind=4 ...

Loading plugin: urn:ietf:params:xml:ns:xmpp-session=4 ...

Loading plugin: jabber:iq:roster=8 ...

Loading plugin: jabber:iq:privacy=4 ...

Loading plugin: jabber:iq:version=4 ...

Loading plugin: http://jabber.org/protocol/stats=4 ...

Loading plugin: starttls=4 ...

Loading plugin: vcard-temp=4 ...

Loading plugin: http://jabber.org/protocol/commands=4 ...

Loading plugin: jabber:iq:private=4 ...

Loading plugin: urn:xmpp:ping=4 ...

Loading plugin: presence=8 ...

Loading plugin: disco=4 ...

Loading plugin: amp=4 ...

Loading plugin: message-carbons=4 ...

Loading plugin: message-archive-xep-0136=4 ...

MA LOADED = message-archive@lpt-khalshai.bodhtree-int.com

Loading plugin: msgoffline=4 ...

Loading component: sess-man :: componentInfo{Class=tigase.server.xmppsession.SessionManager}

Jid srecv@lpt-khalshai.bodhtree-int.com;

Loading component: srecv :: componentInfo{Class=tigase.server.sreceiver.StanzaReceiver}

Loading component: ssend :: componentInfo{Class=tigase.server.ssender.StanzaSender}

TESTBOSH component is loaded....successfully

Loading component: test :: componentInfo{Class=test.BoshTest}

Loading component: ws2s :: componentInfo{Class=tigase.server.websocket.WebSocketClientConnectionManager}

2014-04-24 09:16:43.514 [main] ConfigurationCache.store() WARNING: Dumping server configuration to: etc/config-dump.properties

2014-04-24 09:16:54.151 [ConnectionOpenThread] SocketThread.() WARNING: 17 socketReadThreads started.

2014-04-24 09:16:54.183 [ConnectionOpenThread] SocketThread.() WARNING: 17 socketWriteThreads started

Thanks

Khaleel

Andrzej Wójcik (Tigase) commented 1 decade ago

Features you are trying to use were added in version 1.0.1 of Tigase Message Archiving component (as stated on wiki page with configuration description) while with Tigase XMPP Server 5.2.0 was released version 1.0.0 of Tigase Messsage Archiving component. To use this new features you would need to upgrade Tigase Message Archiving component to new version, but please remember that 1.0.1 is SNAPSHOT build.

Khaleel Shaik commented 1 decade ago

If you look at my init.properties I have commented out the archive related properties

#sess-man/plugins-conf/message-archive-xep-0136/component-jid = admin@localhost

#sess-man/plugins-conf/message-archive-xep-0136/default-store-method = message

#sess-man/plugins-conf/message-archive-xep-0136/required-store-method=body

I have read https://projects.tigase.org/projects/message-archiving/wiki/Configuration and tried adding sess-man/plugins-conf/message-archive-xep-0136/component-jid=message-archive@localhost still no use.

Could you please help me once I Install Tigase 5.2 Final, then what is the configuration I should see in init.properties to store the history of records?

Thanks, waiting fo help.

Khaleel Shaik commented 1 decade ago

Taken the code from latest master copy 1.0.1-SNAPSHOT and build the project in eclipse with this source code, removed the (5.2 final ) software supplied archivie-messages.jar .

Still the messages are not getting stored.

Could you please provide me debug pointers to identify where the issue is?

wojciech.kapcia@tigase.net commented 1 decade ago

There is an issue with your configuration. In the logs you have

MA LOADED = message-archive@lpt-khalshai.bodhtree-int.com

which indicate under which JID address message archive component is available and you HAVE TO use this exact address in the plugin configuration to forward messages to the correct component, hence your configuration:

sess-man/plugins-conf/message-archive-xep-0136/component-jid=message-archive@localhost

is wrong because you are directing messages to non-existing component @message-archive@localhost@. You should use following:

sess-man/plugins-conf/message-archive-xep-0136/component-jid=message-archive@lpt-khalshai.bodhtree-int.com
Khaleel Shaik commented 1 decade ago

Hi,

Thanks for the continuous help. I raised another ticket for the same as ticket https://projects.tigase.org/issues/1944 and message-archive project and it got closed immediately.

For the benefit of other, I want to say that I have tried keeping component-jid values for message-archive@localhost, admin@localhost, message-archive@lpt-khalshai.bodhtree-int.com, admin@lpt-khalshai.bodhtree-int.com, admin@lpt-khalshai (hoping that I have all hosts configured in --vshots, but nothing worked.

Finally the simple mistake I identified was having the property sess-man/plugins-conf/message-archive-xep-0136/required-store-method=body (wihtout -- before the property) started working well. The issues is closed.

Thanks a lot again.

issue 1 of 1
Type
Question
Priority
Normal
Assignee
RedmineID
1939
Issue Votes (0)
Watchers (0)
Reference
tigase/_server/server-core#318
Please wait...
Page is in error, reload to recover