I've tracked down where the problem was occurring and I can fix it. Not sure though why it was occurring and if I should fix it as I have.
When a new user registered they were added to the sql db but no entry was added to the users0k table and the server crashed. When the server was restarted the user still didn't have a 0k entry so couldn't log on, but logging on as an existing user added a 0k entry for the newly registered user. The server was falling over at mod_auth_0k line 217. To see what would happen I commented out lines 215 - 217 // /* if the password is to be changed, just remove the old 0k auth vars, they'll get reset on next auth get */ // if(xmlnode_get_tag_data(m->packet->iq,"password") != NULL) // xdb_set(m->si->xc, id, NS_AUTH_0K, NULL); and I was able to register new users and log them in without server crashes. 0k entries get added into the sql db immediately on registration. The code I commented out says it's for changing passwords but I tried changing some after the comment out and was able to. Anyone know what's going on? Duncan Duncan Hoyle wrote: > > 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. > _______________________________________________ jdev mailing list [EMAIL PROTECTED] http://mailman.jabber.org/listinfo/jdev
