[JDEV] xdb_sql problem on mac osx

[Duncan Hoyle]

Hi all

I'm trying to get xdb_sql 1.2 working on an osx server
connecting to a mysql database running on a windows xp
machine and have the following problem...

The server starts ok without complaining about settings and
sql connections. I'm starting it logged in as me, and I own
everything within the jabberd directory. When I try to
create a new jabberd user (with winjab or exodus) the server
crashes with the messages below. The strange thing is that
the user does get added to the database, and if I restart
the server I can log in as that user.
I've tried starting a server on the same machine as the
database and on a winNT machine using the same remote
database and it works ok - new users can create accounts and
reconnect without the crash.
The xdb_sql.xml files for the pc and mac are the same,
they're trying to use the same user to access the database.

Can anyone offer any suggestions. I've only recently stated
using MacOSX/Linux and may the problem lies in how I'm
running the server/user permissions.

Duncan

Tue Jun 11 16:36:00 2002  <iq type="set" id="JCOM_8"><query
xmlns="jabber:iq:register"><username>test666</username><password>test666</password><resource>Winjab</resource></query></iq>
Tue Jun 11 16:36:00 2002  c2s [client.c:277]
pthsock_client_read called with: m:168E40 flag:3 arg:3C36C0
Tue Jun 11 16:36:00 2002  deliver.c:474 DELIVER
4:macjabber.ilp.com <route type='auth'
to='test666 at macjabber.ilp.com' from='16 at c2s/168E40'><iq
type='set' id='JCOM_8'><query
xmlns='jabber:iq:register'><username>test666</username><password>test666</password><resource>Winjab</resource></query></iq></route>
Tue Jun 11 16:36:00 2002  deliver.c:678 delivering to
instance 'sessions'
Tue Jun 11 16:36:00 2002  deliver.c:94 (1690A0)incoming
packet <route type='auth' to='test666 at macjabber.ilp.com'
from='16 at c2s/168E40'><iq type='set' id='JCOM_8'><query
xmlns='jabber:iq:register'><username>test666</username><password>test666</password><resource>Winjab</resource></query></iq></route>
Tue Jun 11 16:36:00 2002  util.c:103 config query auth
Tue Jun 11 16:36:00 2002  mtq 3B8020 entering from pth
Tue Jun 11 16:36:00 2002  mtq 3B8020 one call 3CA930
Tue Jun 11 16:36:00 2002  authreg.c:95 registration set
request
Tue Jun 11 16:36:00 2002  users.c:143
js_user(test666 at macjabber.ilp.com,211000)
Tue Jun 11 16:36:00 2002  users.c:150 js_user not current
Tue Jun 11 16:36:00 2002  deliver.c:474 DELIVER
2:macjabber.ilp.com <xdb type='get'
to='test666 at macjabber.ilp.com' from='sessions'
ns='jabber:iq:auth' id='12'/>
Tue Jun 11 16:36:00 2002  deliver.c:678 delivering to
instance 'xdb'
Tue Jun 11 16:36:00 2002  xdb_sql.c:124 modules = 197130
Tue Jun 11 16:36:00 2002  log.c:116 <log type='alert'
from='-internal'>[xdbsql_auth_get] no results, user not
found</log>
Tue Jun 11 16:36:00 2002  deliver.c:474 DELIVER 3:-internal
<log type='alert' from='-internal'>[xdbsql_auth_get] no
results, user not found</log>
Tue Jun 11 16:36:00 2002  deliver.c:678 delivering to
instance 'elogger'
20020611T16:36:00: [alert] (-internal): [xdbsql_auth_get] no
results, user not found
Tue Jun 11 16:36:00 2002  deliver.c:474 DELIVER 1:sessions
<xdb type='result' to='sessions'
from='test666 at macjabber.ilp.com' ns='jabber:iq:auth'
id='12'/>
Tue Jun 11 16:36:00 2002  deliver.c:678 delivering to
instance 'sessions'
Tue Jun 11 16:36:00 2002  xdb.c:52 xdb_results checking xdb
packet <xdb type='result' to='sessions'
from='test666 at macjabber.ilp.com' ns='jabber:iq:auth'
id='12'/>
Tue Jun 11 16:36:00 2002  modules.c:135 mapi_call 6
Tue Jun 11 16:36:00 2002  modules.c:158 MAPI 1704A0
Tue Jun 11 16:36:00 2002  mod_last storing last for user
test666 at macjabber.ilp.com
Tue Jun 11 16:36:00 2002  deliver.c:474 DELIVER
2:macjabber.ilp.com <xdb type='set'
to='test666 at macjabber.ilp.com' from='sessions'
ns='jabber:iq:last' id='13'><query xmlns='jabber:iq:last'
last='1023813360'>Registered</query></xdb>
Tue Jun 11 16:36:00 2002  deliver.c:678 delivering to
instance 'xdb'
Tue Jun 11 16:36:00 2002  xdb_sql.c:124 modules = 197130
Tue Jun 11 16:36:00 2002  deliver.c:474 DELIVER 1:sessions
<xdb type='result' to='sessions'
from='test666 at macjabber.ilp.com' ns='jabber:iq:last'
id='13'><query xmlns='jabber:iq:last'
last='1023813360'>Registered</query></xdb>
Tue Jun 11 16:36:00 2002  deliver.c:678 delivering to
instance 'sessions'
Tue Jun 11 16:36:00 2002  xdb.c:52 xdb_results checking xdb
packet <xdb type='result' to='sessions'
from='test666 at macjabber.ilp.com' ns='jabber:iq:last'
id='13'><query xmlns='jabber:iq:last'
last='1023813360'>Registered</query></xdb>
Tue Jun 11 16:36:00 2002  modules.c:158 MAPI 170ED0
Tue Jun 11 16:36:00 2002  mod_auth_plain resetting password
Tue Jun 11 16:36:00 2002  deliver.c:474 DELIVER
2:macjabber.ilp.com <xdb type='set'
to='test666 at macjabber.ilp.com' from='sessions'
ns='jabber:iq:auth' id='14'><password
xmlns='jabber:iq:auth'>test666</password></xdb>
Tue Jun 11 16:36:00 2002  deliver.c:678 delivering to
instance 'xdb'
Tue Jun 11 16:36:00 2002  xdb_sql.c:124 modules = 197130
Tue Jun 11 16:36:00 2002  deliver.c:474 DELIVER 1:sessions
<xdb type='result' to='sessions'
from='test666 at macjabber.ilp.com' ns='jabber:iq:auth'
id='14'><password
xmlns='jabber:iq:auth'>test666</password></xdb>
Tue Jun 11 16:36:00 2002  deliver.c:678 delivering to
instance 'sessions'
Tue Jun 11 16:36:00 2002  xdb.c:52 xdb_results checking xdb
packet <xdb type='result' to='sessions'
from='test666 at macjabber.ilp.com' ns='jabber:iq:auth'
id='14'><password
xmlns='jabber:iq:auth'>test666</password></xdb>
Tue Jun 11 16:36:00 2002  modules.c:158 MAPI 170FD0
Tue Jun 11 16:36:00 2002  util.c:103 config query
mod_auth_0k/enable_registration
Tue Jun 11 16:36:00 2002  deliver.c:474 DELIVER
2:macjabber.ilp.com <xdb type='set'
to='test666 at macjabber.ilp.com' from='sessions'
ns='jabber:iq:auth:0k' id='15'/>
Tue Jun 11 16:36:00 2002  deliver.c:678 delivering to
instance 'xdb'
Tue Jun 11 16:36:00 2002  xdb_sql.c:124 modules = 197130
Tue Jun 11 16:36:00 2002  dnsrv.c:155 dnsrv: Read error on
coprocess(1): 0 Undefined error: 0
Tue Jun 11 16:36:00 2002  dnsrv.c:169 DNSRV CHILD: out of
loop.. exiting normal
Bus error