Project

General

Profile

Offline message not storing while using AMP plugin.

Vinoth Rajendran
Added about 4 years ago

I am using Tigase 5.2.3 and my init.properties file attached below.

I have activated amp plugin.

While I send message to a offline user and when user comes online, its not displayed.

If user is offline, when I send message This exception is happening,

2015-03-20 19:56:29.180 [in_0-amp] MsgRepository.storeMessage() WARNING: Problem adding new entry to DB:

java.sql.SQLException: Field 'msg_type' doesn't have a default value

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)

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

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

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

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

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)

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

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2019)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1937)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1922)

at tigase.server.amp.MsgRepository.storeMessage(MsgRepository.java:488)

at tigase.server.amp.action.Store.execute(Store.java:129)

at tigase.server.amp.AmpComponent.processPacket(AmpComponent.java:294)

at tigase.server.AbstractMessageReceiver$QueueListener.run(AbstractMessageReceiver.java:1475)

In my init.properties file,

I have tried this also, --sm-plugins=amp,-message,-msgoffline


Replies (6)

Avatar?id=6023&size=32x32

Added by Artur Hefczyc TigaseTeam about 4 years ago

It looks like you may have mismatched Tigase libraries version (use components in incompatible version with earlier Tigase version). Are you sure you use Tigase and all components from the installation package only?

Added by Wojciech Kapcia TigaseTeam almost 4 years ago

Vinoth Rajendran wrote:

I am using Tigase 5.2.3 and my init.properties file attached below.

I have activated amp plugin.

While I send message to a offline user and when user comes online, its not displayed.

If user is offline, when I send message This exception is happening,

2015-03-20 19:56:29.180 [in_0-amp] MsgRepository.storeMessage() WARNING: Problem adding new entry to DB:

java.sql.SQLException: Field 'msg_type' doesn't have a default value

Have you, by any chance, tried to use newer version of Tigase at any point in time on the same database? It looks like you have - please remove offending column from the database to use older version of Tigase.

Added by Anonymous almost 4 years ago

This is my mistake, Sorry. I have set wrong database name in --amp-uri.

And One more thing i wanted to ask you, that If I using AMP and login user

A in two device and user B in one device. If user B send message to user A

these two devices are not getting sent message.

This problem is in If using AMP.

My properties are,

--sm-plugins = +message-archive-xep-0136, amp, -msgoffline, -message

--amp-repo-uri=jdbc:mysql://localhost/tigasedb1?user=root&password=root

sess-man/plugins-conf/amp/amp-jid=amp@192.168.1.94

--amp-security-level=NONE

Can U help this?

On Mon, Mar 23, 2015 at 3:31 PM, support@tigase.org wrote:

Added by Wojciech Kapcia TigaseTeam almost 4 years ago

You've provided to little details. Configuration looks ok, so my suggestion would be to track the message in Tigase logs while it's being processed. It could be helpful to enable debugging:

--debug=server,xmpp.impl

Added by Vinoth Rajendran almost 4 years ago

Please find the attached log file and help me to resolve this issue.

FYI, I enabled message-carbon protocol(XEP-0280) in order to that all the resources of receiver should get the message. Carbon works for sender.

Due to this integration with AMP, this carbon functionality doesn't work.

Added by Wojciech Kapcia TigaseTeam almost 4 years ago

Related: #2877

    (1-6/6)