headers
Chris Harries | 11 May 2009 11:01
Picon

Re: Jabber died

Thanks you're the reply,

Yes it seams fine, I connected in and did some select statements, all users
are still there. That being said, I do not get a "cannot login message" with
pandion, it just cannot connect, so it's not running (so not listening).
It's so odd, nothing changed as far as I am aware

Chris

-----Original Message-----
From: jadmin-bounces <at> jabber.org [mailto:jadmin-bounces <at> jabber.org] On Behalf
Of Karim Malhas
Sent: 11 May 2009 09:56
To: Jabber/XMPP server administration list
Subject: Re: [jadmin] Jabber died

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512

Hey Chris,

> It was half running this morning, people could logon but everyone would
> appear offline, I rebooted the server (BSD) and now nobody can logon. I
> checked /var/log/messages

[snip]

> May 11 09:25:44 servername jabberd/sm[738]: mysql: connection to
> database failed: Can't connect to local MySQL server through socket
> '/tmp/mysql.sock' (2)
(Continue reading)

Permalink | Reply |
headers
Karim Malhas | 11 May 2009 11:15
Picon

Re: Jabber died


Hello Chris,

> Yes it seams fine, I connected in and did some select statements, all users
> are still there. That being said, I do not get a "cannot login message" with
> pandion, it just cannot connect, so it's not running (so not listening).

Your problem is that your jabberd cannot connect to the database, as
clearly stated in the logfile :

> May 11 09:25:44 servername jabberd/sm[738]: mysql: connection to
database failed: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
> May 11 09:25:44 servername jabberd/c2s[740]: mysql: connection to
database failed: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)

This is the problem. You need to find out why this is happening.
Wrong permissions on /tmp/mysql.sock maybe?

Good luck,
Karim
Permalink | Reply |
headers
demuel | 11 May 2009 11:26

Re: Jabber died

I remember this situation before. On the start up script, both the jabberd
daemon as well as the mysql server were loading up. There is a simple
trick with this thing. Just let mysql server run first and create some
time delay. Once done, time for the jabberd to load itself. A simple sh
script will make this work. This is just very plain simple thing.

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA512
>
> Hello Chris,
>
>
>> Yes it seams fine, I connected in and did some select statements, all
>> users
>> are still there. That being said, I do not get a "cannot login message"
>> with
>> pandion, it just cannot connect, so it's not running (so not listening).
>
> Your problem is that your jabberd cannot connect to the database, as
> clearly stated in the logfile :
>
>> May 11 09:25:44 servername jabberd/sm[738]: mysql: connection to
> database failed: Can't connect to local MySQL server through socket
> '/tmp/mysql.sock' (2)
>> May 11 09:25:44 servername jabberd/c2s[740]: mysql: connection to
> database failed: Can't connect to local MySQL server through socket
> '/tmp/mysql.sock' (2)
>
>
> This is the problem. You need to find out why this is happening.
(Continue reading)

Permalink | Reply |
headers
Chris Harries | 11 May 2009 12:18
Picon

Re: Jabber died

Aha, you are correct, it cannot connect to the database (Karim) due to it
starting before the DB (demule), it seams to be ok now, however, this
FreeBSD system is a challenge to find where the start up scripts for mysql
and jabber are, they are not in /etc/rc.local like I expected.

Thank you for your assistance and time

Chris

-----Original Message-----
From: jadmin-bounces <at> jabber.org [mailto:jadmin-bounces <at> jabber.org] On Behalf
Of demuel <at> thephinix.org
Sent: 11 May 2009 10:26
To: jadmin <at> jabber.org
Subject: Re: [jadmin] Jabber died

I remember this situation before. On the start up script, both the jabberd
daemon as well as the mysql server were loading up. There is a simple
trick with this thing. Just let mysql server run first and create some
time delay. Once done, time for the jabberd to load itself. A simple sh
script will make this work. This is just very plain simple thing.

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA512
>
> Hello Chris,
>
>
>> Yes it seams fine, I connected in and did some select statements, all
>> users
(Continue reading)

Permalink | Reply |
headers
demuel | 11 May 2009 12:31

Re: Jabber died

I've done and correcting this stuff for lots of times already. I wonder if
this is jabber 1.x or jabberd 2.x but i suppose this is the latter one. to
solve that thing, just create a sh script and it will be as stable as
ever.

> Aha, you are correct, it cannot connect to the database (Karim) due to it
> starting before the DB (demule), it seams to be ok now, however, this
> FreeBSD system is a challenge to find where the start up scripts for mysql
> and jabber are, they are not in /etc/rc.local like I expected.
>
> Thank you for your assistance and time
>
> Chris
>
> -----Original Message-----
> From: jadmin-bounces <at> jabber.org [mailto:jadmin-bounces <at> jabber.org] On
> Behalf
> Of demuel <at> thephinix.org
> Sent: 11 May 2009 10:26
> To: jadmin <at> jabber.org
> Subject: Re: [jadmin] Jabber died
>
> I remember this situation before. On the start up script, both the jabberd
> daemon as well as the mysql server were loading up. There is a simple
> trick with this thing. Just let mysql server run first and create some
> time delay. Once done, time for the jabberd to load itself. A simple sh
> script will make this work. This is just very plain simple thing.
>
>> -----BEGIN PGP SIGNED MESSAGE-----
>> Hash: SHA512
(Continue reading)

Permalink | Reply |
headers
Ciernik Tomas | 11 May 2009 12:27
Picon

Re: Jabber died

Chris Harries  wrote / napísal(a):
> Aha, you are correct, it cannot connect to the database (Karim) due to it
> starting before the DB (demule), it seams to be ok now, however, this
> FreeBSD system is a challenge to find where the start up scripts for mysql
> and jabber are, they are not in /etc/rc.local like I expected.

They should be in /etc/rc.d/ or /usr/local/etc/rc.d/

Tomas.
Attachment (smime.p7s): application/x-pkcs7-signature, 3625 bytes
_______________________________________________
JAdmin mailing list
FAQ: http://www.jabber.org/discussion-lists/jadmin-faq
Forum: http://www.jabberforum.org/forumdisplay.php?f=19
Info: http://mail.jabber.org/mailman/listinfo/jadmin
Unsubscribe: JAdmin-unsubscribe <at> jabber.org
_______________________________________________
Permalink | Reply |

Gmane