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.
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.
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.
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.
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.
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.
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.