dirweb
(Dirweb)
October 23, 2015, 6:23pm
1
hi all
today in my office at 13:00 i not receive any calls.
So i test to call on my number and on my mobile phone i felt the hold music but my phones not receive the call.
After i try to go on my admin panel and i saw this message:
FATAL ERROR
DB Error: connect failed
Trace Back/var/www/html/admin/libraries/db_connect.php:71 die_freepbx()
0 : DB Error: connect failed
/var/www/html/admin/bootstrap.php:91 require_once()
/etc/freepbx.conf:9 require_once()
/var/www/html/admin/config.php:99 include_once()
I don’t undestand why, but now not working.
I not update from 2-3 weeks
What i can do? I have to reinstall all??
dicko
(dicko)
October 23, 2015, 7:03pm
3
And also check that your harddrive is not full.
1 Like
dirweb
(Dirweb)
October 23, 2015, 9:41pm
4
hard disk is not full, i have 20 GB in total and i used only 2GB
with service mysqld start i have this error:
[root@centralino ~]# service mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting mysqld: [FAILED]
[root@centralino ~]#
dirweb
(Dirweb)
December 6, 2015, 4:28am
5
Hi
Now i have the same problem.
In the past i reset all reinstall all but was too long…
If i write command line SERVICE MYSQLD START i receive FAILED
What i can do??
Help me please
danielf
(danielf)
December 6, 2015, 8:50am
6
Hi,
You need to delete the socket file of the mysql server like this:
rm -f /var/lib/mysql/mysql.sock
Then try to start the mysql service again:
service mysqld start
Thank you,
Daniel Friedman
Trixton LTD.
dirweb
(Dirweb)
December 6, 2015, 9:55am
7
Hello danielf
I removed this file but when i try to start the service i receive FAILED.
If i go on the admin panel i see always the error message (also now with this file removed)
I tryed to reboot the system but nothing…
What i can do?
danielf
(danielf)
December 6, 2015, 12:34pm
8
Hi,
Please paste here your logs from your actions. Can you also paste the output of this shell command:
ps aux | grep mysql
Thank you,
Daniel Friedman
Trixton LTD.
dirweb
(Dirweb)
December 8, 2015, 4:02pm
9
hi danielf, now i come back in the office and i can make all you ask me, where i can take the log you ask me?
This is the result of the command you ask me in the last message:
root 1355 66.1 7.4 182448 75588 ? R Dec06 2158:49 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --pid-file=/var/run/mysqld/mysqld.pid --basedir=/usr --user=mysql
root 52401 0.0 0.0 103312 828 pts/0 S+ 17:00 0:00 grep mysql
Thank you
danielf
(danielf)
December 8, 2015, 4:19pm
10
Hi,
You need to kill your mysqld service like that:
kill -9 1355
Then:
rm -f /var/lib/mysql/mysql.sock
And then:
service mysqld start
Thank you,
Daniel Friedman
Trixton LTD.
dirweb
(Dirweb)
December 8, 2015, 4:25pm
11
hi,
i follow your guide but i receive it:
[root@voip ~]# kill -9 1355
[root@voip ~]# rm -f /var/lib/mysql/mysql.sock
[root@voip ~]# service mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting mysqld: [FAILED]
[root@voip ~]#
What other can i do?
Thank you
danielf
(danielf)
December 8, 2015, 4:33pm
12
Hi,
Can you paste again the output of this shell command:
ps aux | grep mysql
Daniel Friedman
Trixton LTD.
dirweb
(Dirweb)
December 8, 2015, 4:36pm
13
hi
this is the result
[root@voip ~]# ps aux | grep mysql
root 55374 0.0 0.0 103308 828 pts/0 S+ 17:35 0:00 grep mysql
root 61488 37.8 0.5 112216 5356 pts/0 R 17:22 5:03 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --pid-file=/var/run/mysqld/mysqld.pid --basedir=/usr --user=mysql
[root@voip ~]#
danielf
(danielf)
December 8, 2015, 4:59pm
14
Hi,
Kill your mysql service and validate that it is killed:
kill -9 61488
And then (several times):
ps aux | grep mysql
If you see no mysql processes in the ps
command start the mysql service again:
service mysqld start
Thank you,
Daniel Friedman
Trixton LTD.
dirweb
(Dirweb)
December 8, 2015, 5:15pm
15
hi
i’m trying with ps aux | grep mysql many many times, for now about 50 times, and always change the first number, for example:
[root@voip ~]# ps aux | grep mysql
root 6622 0.0 0.0 103308 820 pts/0 S+ 18:13 0:00 grep mysql
[root@voip ~]# ps aux | grep mysql
root 6624 0.0 0.0 103308 824 pts/0 S+ 18:13 0:00 grep mysql
[root@voip ~]# ps aux | grep mysql
root 6626 0.0 0.0 103308 824 pts/0 S+ 18:13 0:00 grep mysql
[root@voip ~]# ps aux | grep mysql
root 6628 0.0 0.0 103308 824 pts/0 S+ 18:13 0:00 grep mysql
[root@voip ~]# ps aux | grep mysql
root 6630 0.0 0.0 103308 824 pts/0 S+ 18:13 0:00 grep mysql
[root@voip ~]# ps aux | grep mysql
root 6632 0.0 0.0 103308 820 pts/0 S+ 18:13 0:00 grep mysql
[root@voip ~]# ps aux | grep mysql
i have to continue with this command?
danielf
(danielf)
December 8, 2015, 8:22pm
16
Hi,
It seems that there is no mysqld instance running. You can try to start the service.
if it fails again, please paste the log from the /var/log/mysqld.log
Thank you,
Daniel Friedman
Trixton LTD.
dirweb
(Dirweb)
December 8, 2015, 8:25pm
17
i receive failed message
The log file is very long, how i can paste all? you need a specific line?
[root@voip ~]# more /var/log/mysqld.log
151025 15:51:20 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
151025 15:51:20 InnoDB: Initializing buffer pool, size = 8.0M
151025 15:51:20 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
151025 15:51:20 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait…
151025 15:51:20 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait…
151025 15:51:20 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait…
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
151025 15:51:20 InnoDB: Started; log sequence number 0 0
151025 15:51:20 [Note] Event Scheduler: Loaded 0 events
151025 15:51:20 [Note] /usr/libexec/mysqld: ready for connections.
Version: ‘5.1.73’ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 Source distribution
151025 15:51:56 [Note] /usr/libexec/mysqld: Normal shutdown
151025 15:51:56 [Note] Event Scheduler: Purging the queue. 0 events
151025 15:51:56 InnoDB: Starting shutdown…
151025 15:52:00 InnoDB: Shutdown completed; log sequence number 0 44233
151025 15:52:00 [Note] /usr/libexec/mysqld: Shutdown complete
151025 15:52:00 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
151025 15:52:54 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
151025 15:52:54 InnoDB: Initializing buffer pool, size = 8.0M
151025 15:52:54 InnoDB: Completed initialization of buffer pool
151025 15:52:57 InnoDB: Started; log sequence number 0 44233
151025 15:52:58 [Note] Event Scheduler: Loaded 0 events
151025 15:52:58 [Note] /usr/libexec/mysqld: ready for connections.
Version: ‘5.1.73’ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 Source distribution
151025 18:02:29 [Note] /usr/libexec/mysqld: Normal shutdown
151025 18:02:29 [Note] Event Scheduler: Purging the queue. 0 events
151025 18:02:29 InnoDB: Starting shutdown…
151025 18:02:34 InnoDB: Shutdown completed; log sequence number 0 44233
151025 18:02:34 [Note] /usr/libexec/mysqld: Shutdown complete
151025 18:02:34 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
151025 18:03:37 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
151025 18:03:37 InnoDB: Initializing buffer pool, size = 8.0M
151025 18:03:37 InnoDB: Completed initialization of buffer pool
151025 18:03:37 InnoDB: Started; log sequence number 0 44233
151025 18:03:37 [Note] Event Scheduler: Loaded 0 events
151025 18:03:37 [Note] /usr/libexec/mysqld: ready for connections.
Version: ‘5.1.73’ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 Source distribution
151025 21:48:49 [Note] /usr/libexec/mysqld: Normal shutdown
151025 21:48:49 [Note] Event Scheduler: Purging the queue. 0 events
151025 21:48:49 InnoDB: Starting shutdown…
151025 21:48:50 InnoDB: Shutdown completed; log sequence number 0 44233
151025 21:48:50 [Note] /usr/libexec/mysqld: Shutdown complete
151025 21:48:50 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
151025 21:49:53 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
151025 21:49:53 InnoDB: Initializing buffer pool, size = 8.0M
–More–(0%)
BUT it continue…
danielf
(danielf)
December 8, 2015, 8:27pm
18
Hi,
paste this command results:
cat /var/log/mysqld.log | tail -100
Thank you,
Daniel Friedman
Trixton LTD.
dirweb
(Dirweb)
December 9, 2015, 11:00am
19
hi,
this is the result:
[root@voip ~]# cat /var/log/mysqld.log | tail -100
151209 0:08:47 InnoDB: Completed initialization of buffer pool
151209 0:08:47 InnoDB: Started; log sequence number 0 44233
151209 0:08:47 [ERROR] /usr/libexec/mysqld: Error writing file ‘/var/run/mysqld /mysqld.pid’ (Errcode: 28)
151209 0:08:47 [ERROR] Can’t start server: can’t create PID file: No space left on device
151209 00:08:47 mysqld_safe Number of processes running now: 0
151209 00:08:47 mysqld_safe mysqld restarted
151209 0:08:47 InnoDB: Initializing buffer pool, size = 8.0M
151209 0:08:47 InnoDB: Completed initialization of buffer pool
151209 0:08:47 InnoDB: Started; log sequence number 0 44233
151209 0:08:47 [ERROR] /usr/libexec/mysqld: Error writing file ‘/var/run/mysqld /mysqld.pid’ (Errcode: 28)
151209 0:08:47 [ERROR] Can’t start server: can’t create PID file: No space left on device
151209 00:08:47 mysqld_safe Number of processes running now: 0
151209 00:08:47 mysqld_safe mysqld restarted
151209 0:08:48 InnoDB: Initializing buffer pool, size = 8.0M
151209 0:08:48 InnoDB: Completed initialization of buffer pool
151209 0:08:48 InnoDB: Started; log sequence number 0 44233
151209 0:08:48 [ERROR] /usr/libexec/mysqld: Error writing file ‘/var/run/mysqld /mysqld.pid’ (Errcode: 28)
151209 0:08:48 [ERROR] Can’t start server: can’t create PID file: No space left on device
151209 00:08:48 mysqld_safe Number of processes running now: 0
151209 00:08:48 mysqld_safe mysqld restarted
151209 0:08:49 InnoDB: Initializing buffer pool, size = 8.0M
151209 0:08:49 InnoDB: Completed initialization of buffer pool
151209 0:08:49 InnoDB: Started; log sequence number 0 44233
151209 0:08:49 [ERROR] /usr/libexec/mysqld: Error writing file ‘/var/run/mysqld /mysqld.pid’ (Errcode: 28)
151209 0:08:49 [ERROR] Can’t start server: can’t create PID file: No space left on device
151209 00:08:49 mysqld_safe Number of processes running now: 0
151209 00:08:49 mysqld_safe mysqld restarted
151209 0:08:50 InnoDB: Initializing buffer pool, size = 8.0M
151209 0:08:50 InnoDB: Completed initialization of buffer pool
151209 0:08:50 InnoDB: Started; log sequence number 0 44233
151209 0:08:50 [ERROR] /usr/libexec/mysqld: Error writing file ‘/var/run/mysqld /mysqld.pid’ (Errcode: 28)
151209 0:08:50 [ERROR] Can’t start server: can’t create PID file: No space left on device
151209 00:08:50 mysqld_safe Number of processes running now: 0
151209 00:08:50 mysqld_safe mysqld restarted
151209 0:08:50 InnoDB: Initializing buffer pool, size = 8.0M
151209 0:08:50 InnoDB: Completed initialization of buffer pool
151209 0:08:50 InnoDB: Started; log sequence number 0 44233
151209 0:08:50 [ERROR] /usr/libexec/mysqld: Error writing file ‘/var/run/mysqld /mysqld.pid’ (Errcode: 28)
151209 0:08:50 [ERROR] Can’t start server: can’t create PID file: No space left on device
151209 00:08:50 mysqld_safe Number of processes running now: 0
151209 00:08:50 mysqld_safe mysqld restarted
151209 0:08:51 Inn151209 00:08:51 mysqld_safe Number of processes running now: 0
151209 00:08:51 mysqld_safe mysqld restarted
151209 0:08:52 InnoDB: Initializing buffer pool, size = 8.0M
151209 0:08:52 InnoDB: Completed initialization of buffer pool
151209 0:08:52 InnoDB: Started; log sequence number 0 44233
151209 0:08:52 [ERROR] /usr/libexec/mysqld: Error writing file ‘/var/run/mysqld /mysqld.pid’ (Errcode: 28)
151209 0:08:52 [ERROR] Can’t start server: can’t create PID file: No space left on device
151209 00:08:52 mysqld_safe Number of processes running now: 0
151209 00:08:52 mysqld_safe mysqld restarted
151209 0:08:53 InnoDB: Initializing buffer pool, size = 8.0M
151209 0:08:53 InnoDB: Completed initialization of buffer pool
151209 0:08:53 InnoDB: Started; log sequence number 0 44233
151209 0:08:53 [ERROR] /usr/libexec/mysqld: Error writing file ‘/var/run/mysqld /mysqld.pid’ (Errcode: 28)
151209 0:08:53 [ERROR] Can’t start server: can’t create PID file: No space left on device
151209 00:08:53 mysqld_safe Number of processes running now: 0
151209 00:08:53 mysqld_safe mysqld restarted
151209 0:08:53 InnoDB: Initializing buffer pool, size = 8.0M
151209 0:08:53 InnoDB: Completed initialization of buffer pool
151209 0:08:53 InnoDB: Started; log sequence number 0 44233
151209 0:08:53 [ERROR] /usr/libexec/mysqld: Error writing file ‘/var/run/mysqld /mysqld.pid’ (Errcode: 28)
151209 0:08:53 [ERROR] Can’t start server: can’t create PID file: No space left on device
151209 00:08:53 mysqld_safe Number of processes running now: 0
151209 00:08:53 mysqld_safe mysqld restarted
151209 0:08:54 InnoDB: Initializing buffer pool, size = 8.0M
151209 0:08:54 InnoDB: Completed initialization of buffer pool
151209 0:08:54 InnoDB: Started; log sequence number 0 44233
151209 0:08:54 [ERROR] /usr/libexec/mysqld: Error writing file ‘/var/run/mysqld /mysqld.pid’ (Errcode: 28)
151209 0:08:54 [ERROR] Can’t start server: can’t create PID file: No space left on device
151209 00:08:54 mysqld_safe Number of processes running now: 0
151209 00:08:54 mysqld_safe mysqld restarted
151209 0:08:55 InnoDB: Initializing buffer pool, size = 8.0M
151209 0:08:55 InnoDB: Completed initialization of buffer pool
151209 0:08:55 InnoDB: Started; log sequence number 0 44233
151209 0:08:55 [ERROR] /usr/libexec/mysqld: Error writing file ‘/var/run/mysqld /mysqld.pid’ (Errcode: 28)
151209 0:08:55 [ERROR] Can’t start server: can’t create PID file: No space left on device
151209 00:08:55 mysqld_safe Number of processes running now: 0
151209 00:08:55 mysqld_safe mysqld restarted
151209 0:08:56 InnoDB: Initializing buffer pool, size = 8.0M
151209 0:08:56 InnoDB: Completed initialization of buffer pool
151209 0:08:56 InnoDB: Started; log sequence number 0 44233
151209 0:08:56 [ERROR] /usr/libexec/mysqld: Error writing file ‘/var/run/mysqld /mysqld.pid’ (Errcode: 28)
151209 0:08:56 [ERROR] Can’t start server: can’t create PID file: No space left on device
151209 00:08:56 mysqld_safe Number of processes running now: 0
151209 00:08:56 mysqld_safe mysqld restarted
151209 0:08:57 InnoDB: Initializing buffer pool, size = 8.0M
151209 0:08:57 InnoDB: Completed initialization of buffer pool
151209 0:08:57 InnoDB: Started; log sequence number 0 44233
151209 0:08:57 [ERROR] /usr/libexec/mysqld: Error writing file ‘/var/run/mysqld /mysqld.pid’ (Errcode: 28)
151209 0:08:57 [ERROR] Can’t start server: can’t create PID file: No space left on device
151209 00:08:57 mysqld_safe Number of processes running now: 0
151209 00:08:57 mysqld_safe mysqld restarted
151209 0:08:57 InnoDB: Initializing buffer pool, size = 8.0M
151209 0:08:57 InnoDB: Completed initialization of buffer pool
151209 0:08:58 InnoDB: Started; log sequence number 0 44233
151209 0:08:58 [ERROR] /usr/libexec/mysqld: Error writing file ‘/var/run/mysqld /mysqld.pid’ (Errcode: 28)
151209 0:08:58 [ERROR] Can’t start server: can’t create PID file: No space left on device
151209 00:08:58 mysqld_safe Number of processes running now: 0
151209 00:08:58 mysqld_safe mysqld restarted
Now i have another problem (from yesterday):
If i try to remove night service using *280 it not work…
danielf
(danielf)
December 9, 2015, 11:06am
20
Hi,
You have run out of space on your computer:
151209 0:08:53 [ERROR] Can't start server: can't create PID file: No space left on device
Thank you,
Daniel Friedman
Trixton LTD.