Save chat to MySQL

[Stephen Davies]

Hi,

I'm pretty new to xmpp. Is it possible to save chat to a database such as MySQL? I want web users to be able to interact with chat app users (i'm using Conversations Android app). If would be great if app users could retrieve discussion history stored in a database. I develop using PHP/MySQL and xmpp is all very new to me and I'm not sure how difficult it would be.

[Stanislav N. aka pztrn]

See XEP-0313 (http://xmpp.org/extensions/xep-0313.html).

24 октября 2016 г., 18:00, "Stephen Davies" <stephenj...@gmail.com> написал:

Hi,

I'm pretty new to xmpp. Is it possible to save chat to a database such as MySQL? I want web users to be able to interact with chat app users (i'm using Conversations Android app). If would be great if app users could retrieve discussion history stored in a database. I develop using PHP/MySQL and xmpp is all very new to me and I'm not sure how difficult it would be.

--
You received this message because you are subscribed to the Google Groups "Prosody IM Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to prosody-user...@googlegroups.com.
To post to this group, send email to prosod...@googlegroups.com.
Visit this group at https://groups.google.com/group/prosody-users.
For more options, visit https://groups.google.com/d/optout.

With best regards,
Stanislav N. aka pztrn
Key ID: 083FD824
Jabber: pz...@pztrn.name
E-Mail: pz...@pztrn.name
Blog: http://pztrn.name && http://en.pztrn.name
Telegram: @pztrn

[deoren]

What version of Prosody are you using? I use the prosody 0.10 nightly
releases with mostly good results. Every so often something will break
for me, but it's pretty rare.

I Conversations also and am a big fan of the support for syncing the
history between various devices (phone, tablet, etc).

I use these modules for that support:

* mod_mam
* mod_mam_archive

I also use mod_carbons to duplicate received messages across online
devices. That combination of modules is working well thus far.

See these pages for background and configuration details:

* https://prosody.im/doc/archiving
* https://prosody.im/doc/modules/mod_storage_sql
* https://prosody.im/doc/mysql
* https://prosody.im/doc/developers/modules/mod_storage_sql
* https://modules.prosody.im/mod_mam.html
* https://modules.prosody.im/mod_mam_archive.html
* https://modules.prosody.im/mod_carbons.html