[jadmin] creating jabberd2 accounts by directly manipulating db backend

[Darren Jacobs]

Hi all,

I'm running jabberd2 2.1.15 and I'm looking to generate accounts by  
directly modifying the mysql back end tables as opposed to registering  
new accounts through a jabber client.

I've tried inserting account information into the authreg and vcard  
tables and the login process is partially successful:

--
Nov  6 16:41:13 gpu jabberd/c2s[1083]: [8] [1.2.3.4, port=49915] connect
Nov  6 16:41:13 gpu jabberd/c2s[1083]: [8] SASL authentication  
succeeded: mechanism=DIGEST-MD5; authzid=dh at x.y.ca
Nov  6 16:41:13 gpu jabberd/c2s[1083]: [8] bound: jid=dh at x.y.ca/Adium
Nov  6 16:41:13 gpu jabberd/c2s[1083]: [8] requesting session: jid=dh at x.y.ca 
/Adium
Nov  6 16:41:13 gpu jabberd/sm[1081]: user not found, can't start  
session: jid=dh at x.y.ca/Adium
Nov  6 16:41:13 gpu jabberd/c2s[1083]: [8] [1.2.3.4, port=49915]  
disconnect jid=unbound, packets: 2
Nov  6 16:41:15 gpu jabberd/c2s[1083]: [8] [1.2.3.4, port=49916] connect
Nov  6 16:41:15 gpu jabberd/c2s[1083]: [8] SASL authentication  
succeeded: mechanism=DIGEST-MD5; authzid=dh at x.y.ca
Nov  6 16:41:15 gpu jabberd/c2s[1083]: [8] bound: jid=dh at x.y.ca/Adium
Nov  6 16:41:15 gpu jabberd/c2s[1083]: [8] requesting session: jid=dh at x.y.ca 
/Adium
Nov  6 16:41:15 gpu jabberd/sm[1081]: user not found, can't start  
session: jid=dh at x.y.ca/Adium
--

but sm basically craps out saying it can't find the user.  Where is sm  
looking?  Exactly what tables should be populated with user  
information to make a manual insertion work?


Darren.....