[jadmin] setting up jabber with mysql

[Julian Opificius]

Gerardo Santana Gómez Garrido wrote:
> On 8/4/05, Julian Opificius <julianop at barnlea.com> wrote:
> 
>>Gerardo Santana Gómez Garrido wrote:
>>
>>>
>>>You must have this line
>>>
>>><log type='file'>
>>>
>>>and permissions to access /usr/local/var/jabberd/log and to write in
>>>the log file
>>>
>>
>>Yes, I got that resolved, thank you. I had misread the commenting in the
>>xml files.
>>
>>I now have all processes running, per log below,
>>
>>But attempts to connect fail ...
>>
>>
>>The first attempt (127.0.0.1) was via a SSH tunnel, the second
>>(192.168.100.166) was across the network.
>>
>>Clues would be much appreciated!
>>
>>Julian.
> 
> 
> 
> What does mysql says, and the rest of the jabber logs.
> 

I just restarted jabber.

This is what got put into the mysql log:
050804 13:11:16      84 Connect     jabberd2 at localhost on jabberd2
050804 13:11:17      85 Connect     jabberd2 at localhost on jabberd2

This is what got put into c2s.log:
Thu Aug  4 13:11:17 2005 [notice] starting up
Thu Aug  4 13:11:17 2005 [info] process id is 24376, written to 
/usr/local/var/jabberd/pid/c2s.pid
Thu Aug  4 13:11:17 2005 [notice] initialised auth module 'mysql'
Thu Aug  4 13:11:17 2005 [notice] [localhost] configured; realm=(null)
Thu Aug  4 13:11:17 2005 [notice] attempting connection to router at 
127.0.0.1,port=5347
Thu Aug  4 13:11:17 2005 [notice] connection to router established
Thu Aug  4 13:11:17 2005 [notice] [0.0.0.0, port=5222] listening for 
connections
Thu Aug  4 13:11:17 2005 [notice] ready for connections
c2s.log lines 1-8/8 (END)

And this is what got put into sm.log:
Thu Aug  4 13:11:16 2005 [notice] starting up
Thu Aug  4 13:11:16 2005 [notice] id: localhost
Thu Aug  4 13:11:16 2005 [info] process id is 24359, written to 
/usr/local/var/jabberd/pid/sm.pid
Thu Aug  4 13:11:16 2005 [notice] initialised storage driver 'mysql'
Thu Aug  4 13:11:16 2005 [notice] version: jabberd sm 2.0s9
Thu Aug  4 13:11:16 2005 [notice] attempting connection to router at 
127.0.0.1,port=5347
Thu Aug  4 13:11:16 2005 [notice] connection to router established
Thu Aug  4 13:11:16 2005 [notice] ready for sessions


When I tried to start a new account/connection (username is already in 
mysql), this appeared in c2s.log:
Thu Aug  4 13:15:02 2005 [notice] [7] [192.168.100.166, port=1354] connect
Thu Aug  4 13:15:02 2005 [notice] [7] [192.168.100.166, port=1354] 
disconnect

Hope this helps.

Julian.