MySQL Database suddenly can't start anymore

Hi All,

I tried logging on to my freepbx some few munites ago and discovered that the MySQL Database have not started. I tried various troubleshooting , but still getting an error saying "[ERROR] /usr/libexec/mysqld: Error writing file 'var/run/mysqld/mysqld.pid [Error code: 28]
[ERROR] can’t start server: can’t create PID file: no space left on device.

any clue on how to fix this for my box.

Cheers.

Hi azfhasterisk at qwest.net,

I have checked all what you adviced (/etc/asterisk/asterisk.conf) it points to the correct path. (i.e /var/run/asterisk).

[quote]I think you also need to change the amportal config too and change the
/var/run/mysqld dir back to mysql user account.
[/quote]
Can u please explain more about this, as its not clear. Despite that, I check and found out that everything is OK.

Now going by what I said b4. I think MySQL database refused to start, bringing out ERORR Code 28 (No more space left on device) bcos of of my table (or total space for tmp_table_dir which is 32M as default) got filled up and no space left. I therefore need to know how to access the MySQL system variabe so as to change or increase the size of variable tmp_table_dir.

can someone please help with this. My box is still down, (web interface) not working because of this issue.

Cheers to all.

Check to see if your /etc/asterisk/asterisk.conf says astrundir =>
/var/run/asterisk and not astrundir => /var/run

Amportal will change the permissions on the run dir and not allow mysql to
run.

I think you also need to change the amportal config too and change the
/var/run/mysqld dir back to mysql user account.

In the older Freepbx/amportal install doc’s it tells you to change the
makefile to this path but for some reason the new ones don’t.

Rick

-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of kayodea
Sent: Sunday, December 03, 2006 9:49 AM
To: [email protected]
Subject: Re: [Amportal-users] MySQL Database suddenly can’t start anymore

Hi All,

I am still battling with this problem and there is no way out yet. I need to
logon to the web interface of freepbx and that is not possible since this
problem started. Can someone help please.

Cheers.


Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net’s Techsay panel and you’ll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV


Amportal-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/amportal-users


Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net’s Techsay panel and you’ll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV


Amportal-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/amportal-users

Post generated using Mail2Forum (http://www.mail2forum.com)

Hi All,

I am still battling with this problem and there is no way out yet. I need to logon to the web interface of freepbx and that is not possible since this problem started. Can someone help please.

Cheers.

Sorry i did read the whole post…I was stoke about the custom context

Have you delete the files from
/tmp
/var/tmp

can use use a sql manager to export the database and delete data from the table

I have checked it., there is nothing inside /tmp and /var/tmp.

Can u please tell me how to use any MySQl manager to access the tables, because as of writing MySQL have refused to start, giving the same error as I stated earlier. and more importantly, is there a way I can access the system variable so as to increase the size of tmp_table_size and also to assign a path to tmpdir, even though MySQL is not started.

Cheers.

ya Bubba, I red that post before openning your reply. Its not the same problem here. I had my Box working for 3 months before this happened., and I think it had to do with the asteriskcdrdb table filling up. Thanks alot.

ya covici at ccs.covici.com, its not a disk cleanup as in HDD full. it has to do with a MySQL system variable called tmp_table_size which have passed its initial limit (or size of 32M as default.) and causing MySQL to convert the table (in this case I guess its asteriscdrdb table) to a MYISAM disk drive, and also for a variale tmpdir which I didn’t set when I do my installation.

Now I am asking, if there is anyone who have come across this type of problem and how can it be fix.

Regards to all.

see this post

http://www.freepbx.org/forums/viewtopic.php?t=1152

Well, no space left on device seems obvious to me – you need to do
some dcleanup!

on Sunday 12/03/2006 kayodea([email protected]) wrote

Hi All,

I tried logging on to my freepbx some few munites ago and discovered that the MySQL Database have not started. I tried various troubleshooting , but still getting an error saying "[ERROR] /usr/libexec/mysqld: Error writing file 'var/run/mysqld/mysqld.pid [Error code: 28]
[ERROR] can’t start server: can’t create PID file: no space left on device.

any clue on how to fix this for my box.

Cheers.


Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net’s Techsay panel and you’ll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV


Amportal-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/amportal-users


Your life is like a penny. You’re going to lose it. The question is:
How do
you spend it?

     John Covici
     [email protected]

Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net’s Techsay panel and you’ll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV


Amportal-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/amportal-users

Post generated using Mail2Forum (http://www.mail2forum.com)

help please
i need to know the exact location of the database my_sql
/…/…/

Hi,
look in /etc/my.cnf
This is the mysql config file and will show where the actual database files are stored.
It’s probably /var/lib/mysql