jabberd, mysql.. how to initialize the database (solution plus bonus client question)
I've had mysql working for a while, now I want to play with the jabberd in suse 9.3, using mysql as the auth/storage system. I couldn't find the script to set up the jabberd tables in mysql anywhere after installing the jabberd package from the suse disc ( jabberd-2.0cvs20050111-3.x86_64.rpm ), but I did find it here: http://jabberstudio.org/cgi-bin/viewcvs.cgi/*checkout*/cvs/jabberd2/ tools/db-setup.mysql Hope this helps someone. The next problem I've run into is that iChat ( the only jabber-aware client I have handy) is failing to connect. Or rather, it connects but then immediately disconnects and doesn't successfully log in. I just get unenlightening entries like this in the message log: Feb 5 22:56:26 fess jabberd/s2s[23573]: ready for connections Feb 5 22:56:53 fess jabberd/c2s[23561]: [7] [192.168.42.97, port=58673] connect Feb 5 22:56:53 fess jabberd/c2s[23561]: [7] [192.168.42.97, port=58673] disconnect .. and a "failed to connect" from iChat. I have added the username, realm, and password to the authreg database manually and checked it via, mysql -u jabberd2 -ppassword -e 'select username, realm, password from authreg;' so I know that much at least works. I haven't tried any other jabber client yet though so I don't know if this is an iChat or jabber issue. (I've only been working on this for a little while this evening, and just tried iChat for the first time a few minutes ago.) Would it help to find more recent jabberd2 sources? Anyone else messing with this stuff? The docs on jabberd are a little skimpy.
participants (1)
-
John Grant