[jadmin] setting up jabber with mysql

[Julian Opificius]

Gerardo Santana Gómez Garrido wrote:
> On 8/3/05, Julian Opificius <julianop at barnlea.com> wrote:
> 
>>Having a little trouble setting up jabber with mysql, with respect to
>>passwords.
>>
>>Do the passwords listed in c2s.xl and sm.xl have to be encrypted, or are
> 
> You mean c2s.xml and sm.xml
> 
> 
>>they plain text?
> 
> 
> plain text
> 

OK, Thanks.

> 
>>When I try to run jabberd, I get
>>"ERROR: sm died. Shutting down server."
>>
>>and my mysql log gives me "access denied" errors.
> 
> 
> Test it. Try connecting manually to your MySQL server with the mysql
> utility using the user/password in your *.xml files. You've probably
> not set up permissions correctly. It implies adding records to the
> user and db tables in the mysql database.
> 
> 

Doing "mysql -u jabber -p"  works.

Question: the set up instructions doesn't tell me to do so, but do I 
need to put the username/password in ALL the xml files?

Is this also true for logging? Log info is still not being written in 
the /usr/local/var/jabberd/log directory.

Here's relevant log info:

Aug  3 10:40:10 engsrv su: (to jabber) julian_opificius on /dev/pts/4
Aug  3 10:40:10 engsrv su: pam_unix2: session started for user jabber, 
service su
Aug  3 10:40:12 engsrv jabberd/router[15344]: starting up
Aug  3 10:40:12 engsrv jabberd/router[15344]: process id is 15344, 
written to /usr/local/var/jabberd/pid/router.pid
Aug  3 10:40:12 engsrv jabberd/router[15344]: loaded user table (1 users)
Aug  3 10:40:12 engsrv jabberd/router[15344]: [0.0.0.0, port=5347] 
listening for incoming connections
Aug  3 10:40:12 engsrv jabberd/resolver[15345]: starting up
Aug  3 10:40:12 engsrv jabberd/resolver[15345]: process id is 15345, 
written to /usr/local/var/jabberd/pid/resolver.pid
Aug  3 10:40:12 engsrv jabberd/resolver[15345]: attempting connection to 
router at 127.0.0.1, port=5347
Aug  3 10:40:12 engsrv jabberd/router[15344]: [127.0.0.1, port=34987] 
connect
Aug  3 10:40:12 engsrv jabberd/router[15344]: [127.0.0.1, port=34987] 
authenticated as jabberd
Aug  3 10:40:12 engsrv jabberd/resolver[15345]: connection to router 
established
Aug  3 10:40:12 engsrv jabberd/router[15344]: [resolver] online (bound 
to 127.0.0.1, port 34987)
Aug  3 10:40:12 engsrv jabberd/s2s[15347]: starting up (interval=60, 
queue=60, keepalive=0, idle=86400)
Aug  3 10:40:12 engsrv jabberd/s2s[15347]: process id is 15347, written 
to /usr/local/var/jabberd/pid/s2s.pid
Aug  3 10:40:12 engsrv jabberd/s2s[15347]: attempting connection to 
router at 127.0.0.1, port=5347
Aug  3 10:40:12 engsrv jabberd/router[15344]: [127.0.0.1, port=34988] 
connect
Aug  3 10:40:12 engsrv jabberd/router[15344]: [127.0.0.1, port=34988] 
authenticated as jabberd
Aug  3 10:40:12 engsrv jabberd/s2s[15347]: connection to router established
Aug  3 10:40:12 engsrv jabberd/router[15344]: [s2s] set as default route
Aug  3 10:40:12 engsrv jabberd/router[15344]: [s2s] online (bound to 
127.0.0.1, port 34988)
Aug  3 10:40:12 engsrv jabberd/resolver[15345]: ready to resolve
Aug  3 10:40:12 engsrv jabberd/resolver[15345]: shutting down
Aug  3 10:40:12 engsrv jabberd/router[15344]: [127.0.0.1, port=34987] 
disconnect
Aug  3 10:40:12 engsrv jabberd/router[15344]: [resolver] offline
Aug  3 10:40:12 engsrv jabberd/s2s[15347]: shutting down
Aug  3 10:40:12 engsrv jabberd/router[15344]: [127.0.0.1, port=34988] 
disconnect
Aug  3 10:40:12 engsrv jabberd/router[15344]: [s2s] default route offline
Aug  3 10:40:12 engsrv jabberd/router[15344]: [s2s] offline
Aug  3 10:40:12 engsrv jabberd/router[15344]: shutting down

Thanks

Julian.