Error and problem after module update

hi all
2-3 days ago i update 4-5 module from my dashboard and now i can not access via browser, i receive this message.

my phone also not work (sometimes yes, sometimes no)

I reboot also my system but nothing changed.

How is possible all that? What mean?
Thank you

no one can help me? :frowning:

Hi!

From https://dev.mysql.com/doc/refman/5.7/en/can-not-connect-to-server.html :

The error (2002) Can’t connect to … normally means that there is no MySQL server running on the system or that you are using an incorrect Unix socket file name or TCP/IP port number when trying to connect to the server. You should also check that the TCP/IP port you are using has not been blocked by a firewall or port blocking service.

You just need to figure out what you did that caused that…

By the way, you stand a better chance of getting good answers if you give more information about your setup… Are you using the distro (if so which version) or something else?

Good luck and have a nice day!

Nick

hi marbel
thank you for the reply.

i not use a distro, i just follow all the steps from here:
http://wiki.freepbx.org/display/FOP/Installing+FreePBX+13+on+CentOS+6

i made this installation 3 months ago and i received this errore page 2-3 days ago, after update of module.

It’s the 2nd or 3rd time i have this problem after 3-4 months, always i have to reinstall all from 0 and this i don’t like because i less to many time for installation and configuration.

I install it always on a cloud server, maybe this give me always problems after 3-4 months?

So, now how i can solve this problem? Where i have to begin?
Thank you

now i check mysql status and is stopped but if i launch

/etc/init.d/mysqld start
or
/etc/init.d/mysqld restart

it not start or restart…
how is possible?

after command /etc/init.d/mysqld start i receive this message (timeout)

[[email protected] ~]# /etc/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting mysqld: [FAILED]
[[email protected] ~]#

Hello,

Try this:

rm -f /var/lib/mysql/mysql.sock
service mysqld restart

Thank you,

Daniel Friedman
Trixton LTD.

hello daniel, i tryed but nothing…

[[email protected] ~]# rm -f /var/lib/mysql/mysql.sock
[[email protected] ~]# service mysqld restart
Stopping mysqld: [ OK ]
Timeout error occurred trying to start MySQL Daemon.
Starting mysqld: [FAILED]
[[email protected] ~]#

Hello,

Please send me the output of the command: df -h
and the output of the command tail -f /var/log/mysqld.log

Thank you,

Daniel Friedman
Trixton LTD.

hi daniel

this is the first output

the second output like this but is very long and always write the same:

170201 16:07:27 InnoDB: Initializing buffer pool, size = 8.0M
170201 16:07:27 InnoDB: Completed initialization of buffer pool
170201 16:07:28 InnoDB: Started; log sequence number 0 376556
170201 16:07:28 [ERROR] /usr/libexec/mysqld: Error writing file ‘/var/run/mysqld/mysqld.pid’ (Errcode: 28)
170201 16:07:28 [ERROR] Can’t start server: can’t create PID file: No space left on device
170201 16:07:28 mysqld_safe Number of processes running now: 0
170201 16:07:28 mysqld_safe mysqld restarted

Maybe i have no space on my cloud server?
What i can delete for take more space?

Hello,

Your problem is that you run out of disk space, and that is why your mysql server is not running. Search for your logs and delete all the large files.

Then run again service mysqld restart.

Thank you,

Daniel Friedman
Trixton LTD.

hello, which file i can delete?
on this cloud server i have only asterisk and freepbx, i do not if i can increese space on it, i have to ask

Hello,

Send me the output of du -h /var/log/

Thank you,

Daniel Friedman
Trixton LTD.

hello,
here is the output

4.0K /var/log/asterisk/cel-custom
4.0K /var/log/asterisk/cdr-custom
4.0K /var/log/asterisk/cdr-csv
12G /var/log/asterisk
30M /var/log/audit
1.5M /var/log/httpd
4.0K /var/log/ntpstats
4.0K /var/log/mail
4.0K /var/log/cluster
32K /var/log/prelink
16K /var/log/ConsoleKit
19M /var/log/sa
12G /var/log/

Hello,

You need to delete all the log files in /var/log/asterisk and reboot your server.

Thank you,

Daniel Friedman
Trixton LTD.

hello, in this folder i have this files:

drwxrwxr-x 2 asterisk asterisk 4096 Oct 29 13:05 cdr-csv
drwxrwxr-x 2 asterisk asterisk 4096 Oct 29 13:05 cdr-custom
drwxrwxr-x 2 asterisk asterisk 4096 Oct 29 13:05 cel-custom
-rw-rw-r-- 1 asterisk asterisk 38166528 Jan 31 11:29 freepbx.log
-rw-r–r-- 1 asterisk asterisk 18972672 Jan 31 08:36 freepbx_security.log
-rw-r–r-- 1 root root 598165055 Feb 1 17:09 full
-rw-r–r-- 1 root root 4821877363 Jan 28 02:18 full.0
-rw-r–r-- 1 root root 3550100744 Dec 27 22:20 full.1
-rw-r–r-- 1 root root 1852731531 Dec 1 16:50 full.2
-rw-r–r-- 1 asterisk asterisk 1521186852 Nov 14 20:07 full.3
-rw-rw-r-- 1 asterisk asterisk 124531 Feb 1 16:53 queue_log

i have to delete only this 2 files:
-rw-rw-r-- 1 asterisk asterisk 38166528 Jan 31 11:29 freepbx.log
-rw-r–r-- 1 asterisk asterisk 18972672 Jan 31 08:36 freepbx_security.log

Later i have to create this file or is automatic?
thank you for all

Hello,

You can delete more files: rm -f /var/log/asterisk/full*

Reboot your server and the files will be created automatically.

Thank you,

Daniel Friedman
Trixton LTD.

1 Like

hello,
thank you
now is working and file created automatically

So, next time just need to deleted it, right?

Hello,

You should set a log rotate to avoid this type of situation.

Thank you,

Daniel Friedman
Trixton LTD.