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? 
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)
[root@asterisk ~]# /etc/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting mysqld: [FAILED]
[root@asterisk ~]#
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…
[root@asterisk ~]# rm -f /var/lib/mysql/mysql.sock
[root@asterisk ~]# service mysqld restart
Stopping mysqld: [ OK ]
Timeout error occurred trying to start MySQL Daemon.
Starting mysqld: [FAILED]
[root@asterisk ~]#
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.
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.