John, thanks for the tips.
I checked the log and it seemed like I run out of space. So, I deleted six of asterisk log files (2 GB each; I don't know why they were so big) and now I have :
[EMAIL PROTECTED] ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/hda2 18G 1.5G 16G 9% /
/dev/hda1 99M 8.4M 86M 9% /boot
none 125M 0 125M 0% /dev/shm
and the log for my sql has changed to this:
[EMAIL PROTECTED] ~]# tail /var/log/mysqld.log
061028 15:35:49 InnoDB: Starting shutdown...
061028 15:35:50 InnoDB: Shutdown completed; log sequence number 0 43644
061028 15:35:50 [Note] /usr/libexec/mysqld: Shutdown complete
061028 15:35:50 mysqld ended
061028 15:38:24 mysqld started
061028 15:38:25 InnoDB: Started; log sequence number 0 43644
/usr/libexec/mysqld: ready for connections.
Version: '4.1.20' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
[EMAIL PROTECTED] ~]#
So, I dont' know what the problem is now. I can access the first page for trixbox now but the sys admin page and freepbx still don't show.
Thanks,
Bruce
From: "John Cianfarani" <[EMAIL PROTECTED]>
To: "'Bruce Nik'" <[EMAIL PROTECTED]>,<[email protected]>
Subject: RE: [on-asterisk] MySQL fails
Date: Sat, 28 Oct 2006 12:40:26 -0400
MIME-Version: 1.0
Received: from iran.unitycode.org ([205.207.27.18]) by bay0-mc9-f11.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2444); Sat, 28 Oct 2006 09:42:31 -0700
Received: (qmail 23589 invoked by alias); 28 Oct 2006 16:40:33 -0000
Received: (qmail 4031 invoked by uid 0); 28 Oct 2006 16:40:32 -0000
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]Try to start the service manually
And then tail /var/log/mysqld.log
Post the output that might indicate why its not loading.
Thanks
John
From: Bruce Nik [mailto:[EMAIL PROTECTED]
Sent: Saturday, October 28, 2006 12:34 AM
To: [email protected]
Subject: [on-asterisk] MySQL fails
Hello everyone,
First, here is a short summery of my machine:
I have had a stable Trixbox system for a while now. I upgraded to 1.2.1 and there were some issues with it, though, my box was working up to my expectations. I have recently uploaded g723 and g729 to the box (intel codecs) and also created a trunk for uplink (the skype bridge program). Other than these changes, I have had the general settings altered to accept outside SIP registration requests.
My system does start now, however, MySQL fails. There are also mails the /dev/hda has problem and there are uncorrectable or unreadable sectors.
So, I am wondering if the bad sectors have caused the MySQL to not load. I don't think that is the problem though because the first page for Trixbox loads up and I can use all the features except for FreePBX. This is the msg that I get when I try to access FreePBX:
[nativecode=Lost connection to MySQL server during query] ** mysql://asteriskuser:[EMAIL PROTECTED]/asterisk
^^^^^^so, obviously because MySQL didn't start up.
I tried starting mySQL but it shuts off again for some reason.
I don't want to scrap the system and re-install. What could be the solution? or infact, what is the problem?
Thanks,
Bruce
Experience Live Search from your PC or mobile device today.
Ready for the world's first international mobile film festival celebrating the creative potential of today's youth? Check out Mobile Jam Fest for your a chance to WIN $10,000!
