[ejabberd] export2sql

Badlop badlop at gmail.com
Mon Oct 24 14:44:36 MSK 2016


Hi,

Regarding the first problem, you are right, there was a ; missing in
those lines.
It's now fixed in git. Thanks for reporting!

Regarding the second problem, I don't see it in my small test, and I
don't know how to reproduce it.


---
Badlop
ProcessOne


On 18 October 2016 at 14:00, Marcio Luciano Donada
<mdonada at auroraalimentos.com.br> wrote:
> Hi list
>
> I'm using export2sql[1] to migrate mnesia database files to SQL (MySQL) but
> in some cases missing ";" for execution, for example:
>
>
>
> insert into privacy_list_data(id, t, value, action, ord, match_all,
> match_iq, match_message, match_presence_in, match_presence_out) values
> (11866, 'n', '', 'd', 1, 0, 0, 0, 0, 1)
>
>
>
> another more curious detail is that export2sql creates (exports) the most
> data from the field can receive:
>
>
>
> delete from rosterusers where username='vagner-zorzi' and jid='não houve
> reunião do comitê da qualidade na semana de 29/07 a 02/08/2013 devido a
> visita coorporativa da matriz do departamento da qualidade com foco na norma
> de seguranç
>
> insert into rosterusers( username, jid, nick, subscription, ask, askmessage,
> server, subscribe, type) values ('vagner-zorzi', 'não houve reunião do
> comitê da qualidade na semana de 29/07 a 02/08/2013 devido a visita
> coorporativa da ma
>
> delete from rostergroups where username='vagner-zorzi' and jid='não houve
> reunião do comitê da qualidade na semana de 29/07 a 02/08/2013 devido a
> visita coorporativa da matriz do departamento da qualidade com foco na norma
> de seguran▒
>
>
>
> root at localhost [modulos_ejabberd]> desc rosterusers;
>
> +--------------+--------------+------+-----+-------------------+-------+
>
> | Field        | Type         | Null | Key | Default           | Extra |
>
> +--------------+--------------+------+-----+-------------------+-------+
>
> | username     | varchar(191) | NO   | MUL | NULL              |       |
>
> | jid          | varchar(191) | NO   | MUL | NULL              |       |
>
> | nick         | text         | NO   |     | NULL              |       |
>
> | subscription | char(1)      | NO   |     | NULL              |       |
>
> | ask          | char(1)      | NO   |     | NULL              |       |
>
> | askmessage   | text         | NO   |     | NULL              |       |
>
> | server       | char(1)      | NO   |     | NULL              |       |
>
> | subscribe    | text         | NO   |     | NULL              |       |
>
> | type         | text         | YES  |     | NULL              |       |
>
> | created_at   | timestamp    | NO   |     | CURRENT_TIMESTAMP |       |
>
> +--------------+--------------+------+-----+-------------------+-------+
>
>
>
> that is, the id field is varchar 191. I’am using FreeBSD ejabberd 16.09
>
>
>
> [1]. su - ejabberd -c "env ejabberdctl export2sql domain new-file.sql"
>
>
>
> Thanks.
>
> __
>
> Márcio Luciano Donada
>
> Analista  DBA/Suporte
>
> Depto de TI – Chapecó(SC)
>
> Tel.: (49) 33213262
>
> VOIP: 66 16 3262
>
> Aurora Alimentos
>
> Cooperativa Central Aurora Alimentos
>
>
>
> ________________________________
>
> Aviso: Esta mensagem (incluindo qualquer anexo) e os arquivos nela contidos
> é confidencial e legalmente protegida, somente podendo ser usada pelo
> indivíduo ou entidade a quem foi endereçada. Caso você a tenha recebido por
> engano, deverá devolvê-la ao remetente e, posteriormente, apagá-la, pois, a
> disseminação, encaminhamento, uso, impressão ou cópia do conteúdo desta
> mensagem são expressamente proibidos.
> Warning: This message (including any attachments) contains confidential
> information intended for a specific individual and purpose, and is protected
> by law. If you are not the intended recipient, you should delete this
> message. Any disclosure, copying, or distribution of this message, or the
> taking of any action based on it, is strictly prohibited.
>
> _______________________________________________
> ejabberd mailing list
> ejabberd at jabber.ru
> http://lists.jabber.ru/mailman/listinfo/ejabberd
>


More information about the ejabberd mailing list