[jadmin] xdb_sql and jit (x:data namespace)

[Michael Wyraz]

Hi,
I tried to send this mail also to dev at xmppd.org but this list seems to 
be broken (I get no subscription confirmation and my mails are sent 
back). So i try it here and hope to get some help :-)

===========

Hi,

i'm currently running an old version of jabberd14+jit on our old server
(running since jan 2003). Now i want to setup recent versions on the new
server and use xdm_sql as xml storage.

Everything including import from old spool works fine except of jit's
registered users. The data for user accounts is stored as jabber:x:data
which is not handled by the sql configuration example.

I have read the example sql queries but they are quite complex
(especially the xml substring handling) so i have no idea how i must
configure jabberd to store jabber:x:data to an sql table. On google i
could not find any hints.

So could you please explain (or add the the default configuration) how
to store jabber:x:data with xdb_sql?

Alternatively i could use the old filestore for this data but i would
prefer to have anything in xml.

Regards,
Michael.