[JDEV] Re: xdb_sql problem on mac osx

[Duncan Hoyle]

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.
>