Re: [jabberd2] converting bdb to mysql

2008-04-03 Thread Christian Weiske
Hello Daniel, > > The structure is taken directly from svn, too. So what am I doing > > wrong? > > Hmm, I wrote it a while back (7 months), so the actual bdb structure > might not be what the script expects, as Tomasz pointed out. > > Could you send me some dummy database entries so I could ha

[jabberd2] jabberd with berkeley db backend?

2008-04-03 Thread Scott Baker
I have (for simplicity) a berkeley db backend for my jabberd2 server. It works great for both auth and storage. Now I have a user who forgot their password. The authreg.db file is apparently some hybrid crazy BerkelyDB because I can't db_dump or connect to it via perl. How do I look up, or re

Re: [jabberd2] converting bdb to mysql

2008-04-03 Thread Daniel Willmann
Hello, On Thu, 3 Apr 2008 14:03:14 +0200 Christian Weiske <[EMAIL PROTECTED]> wrote: > Hello, > > I tried to convert our bdb database to mysql using the ruby script in > svn, but get the following error: cool, seems my script will be useful to someone else, too. :-) > cweiske:~/jabber> ruby bd

Re: [jabberd2] converting bdb to mysql

2008-04-03 Thread Tomasz Sterna
Dnia 2008-04-03, czw o godzinie 14:03 +0200, Christian Weiske pisze: > Adding statements for table authreg > bdb2mysql.rb:187:in `query': Unknown column 'sequence' in 'field > list' (Mysql::Error) > from bdb2mysql.rb:187 > from bdb2mysql.rb:186:in `each' > from bdb2mysql.rb:

[jabberd2] converting bdb to mysql

2008-04-03 Thread Christian Weiske
Hello, I tried to convert our bdb database to mysql using the ruby script in svn, but get the following error: cweiske:~/jabber> ruby bdb2mysql.rb -a -u root -h localhost -d jabberd2 db/ Looking for authreg.db in db/authreg.db Looking for sm.db in db/sm.db Adding statements for table authreg bdb