ejabberd - Comments for "migrating mnesia to pgsql and other issues"

This is probably the problem, easy to solve

mfoss — Mon, 07 Jun 2010 13:27:50 +0000

ragged wrote:

the ejabberd installation is from the debian sources. i compiled in the erlang modules for postgres/mysql and ejd2odbc.

could there be the problem?

If you downloaded some source code files from http://github.com/processone/ejabberd/tree/master/src/odbc/ then compiled them and installed in your ejabberd 2.1.*, you will get problems like the one you described, because you mix files from ejabberd 3 with ejabberd 2.

Better get the files from here (notice those are for ejabberd 2):
http://github.com/processone/ejabberd/tree/2.1.x/src/odbc

hi badlop, the ejabberd

ragged — Mon, 07 Jun 2010 11:43:47 +0000

hi badlop,

the ejabberd installation is from the debian sources. i compiled in the erlang modules for postgres/mysql and ejd2odbc.

could there be the problem?

would like to tell you the version number, but ejabberd dont have an options for that. :/

here are the mysql files i compiled in

https://svn.process-one.net/ejabberd-modules/mysql/trunk/src/

Are you sure that is ejabberd 2?

mfoss — Fri, 04 Jun 2010 18:25:17 +0000

ragged wrote:

but i get only following output:
Trying to export Mnesia table 'vcard_search' on server 'jabber.domain.tld' to file '/var/lib/ejabberd/vcard_search.txt'
Result: {aborted,
{undef,
[{exmpp_stringprep,nameprep,["jabber.domain.tld"]},
{ejd2odbc,'-export_common/4-fun-1-',4},
{mnesia_tm,apply_fun,3},
{mnesia_tm,execute_transaction,5},
{mod_ctlextra,'-ctl_process/2-fun-0-',3},
{lists,foreach,2},
{mod_ctlextra,ctl_process,2},
{ejabberd_hooks,run_fold1,4}]}}

It seems you don't have installed ejabberd 2. It seems you have installed ejabberd from the Git repository, 'master' branch; and that is a code still in development.

ragged wrote: i compiled the

mfoss — Fri, 04 Jun 2010 18:22:12 +0000

ragged wrote:

i compiled the erlang pgsql modules from this site http://frihjul.net/pgsql

For ejabberd, you must get the pgsql available in the ejabberd-modules SVN.

export2odbc, dont work

ragged — Fri, 04 Jun 2010 10:58:41 +0000

ok, i found a way it should work.

i try this:
ejabberdctl export2odbc jabber.domain.tld /var/lib/ejabberd/

the files get created, but they are empty. so i dont know right know what to do.

the DAT and DCD files have content in it.

the server on which i try it is new and i loaded a dump of the live system. and then i try the export. is this possible? hope so :/

regards