TIPS "DB ERROR: Connect Failed"

Status
Not open for further replies.

shiyas

New Member
Joined
Dec 30, 2018
Messages
7
Reaction score
0
File: full.4 in var/log/asterisk is about 22GB big.

I am assuming I can delete it. How does that get to be so big, and how do I stop that from happening again?

Thanks

Dear Friend,
i am facing same problem disk space is full, i am using 250 gb hdd. I don't know how can i find unwanted files and how to delet this one. My Sql is not loading showing time out error how can i ressolve this issue,
 

Attachments

  • 49136524_614033442364276_7424119793139056640_n.jpg
    49136524_614033442364276_7424119793139056640_n.jpg
    196.5 KB · Views: 3
  • 48971518_584693255310780_351871814269403136_n.jpg
    48971518_584693255310780_351871814269403136_n.jpg
    246.4 KB · Views: 4

dallas

Active Member
Joined
Oct 21, 2007
Messages
844
Reaction score
247
This is a very old thread. A disk with no free space can cause many issues.
I think if you can resolve your issue with disk space Sql will come good. I would start by deleting everything in /var/log/asterisk.
 

shiyas

New Member
Joined
Dec 30, 2018
Messages
7
Reaction score
0
This is a very old thread. A disk with no free space can cause many issues.
I think if you can resolve your issue with disk space Sql will come good. I would start by deleting everything in /var/log/asterisk.

Dear Friend,
how can i delete everyhing in /var/log/asterisk. which command i will use, i dont have any experince in linux. please help me.
 

dallas

Active Member
Joined
Oct 21, 2007
Messages
844
Reaction score
247
Dear Friend,
how can i delete everyhing in /var/log/asterisk. which command i will use, i dont have any experince in linux. please help me.
Please post the output of “df -h”

Edit. Never mind, I see the disk is full.
Use these commands to empty the /var/log/asterisk directory
‘cd /var/log/asterisk’
‘rm *’

Then post the output of ‘df -h’
 
Last edited:

shiyas

New Member
Joined
Dec 30, 2018
Messages
7
Reaction score
0
Please post the output of “df -h”

Edit. Never mind, I see the disk is full.
Use these commands to empty the /var/log/asterisk directory
‘cd /var/log/asterisk’
‘rm *’

Then post the output of ‘df -h’[/QUOTE
Dear Friend,
when i am running command
its asking remove regular empty file event_log?
freepbx-bounce_op.log?

shall i remove these files
 

Attachments

  • WhatsApp Image 2018-12-31 at 8.27.27 AM.jpeg
    WhatsApp Image 2018-12-31 at 8.27.27 AM.jpeg
    109.9 KB · Views: 1

shiyas

New Member
Joined
Dec 30, 2018
Messages
7
Reaction score
0
Dear Friend,
i removed the file but after running df -h command
still same size of file available in disk,
no free up space.
i checked largest file using du -sk * | sort -n
 

Attachments

  • IMG_0957.JPG
    IMG_0957.JPG
    908.1 KB · Views: 2

shiyas

New Member
Joined
Dec 30, 2018
Messages
7
Reaction score
0
Getting same error.
Cannot connect to any sip extensions either.

Code:
root@pbx:~ $ df
Filesystem           1K-blocks      Used Available Use% Mounted on
/dev/sda2             76024929  76024728         0 100% /
/dev/sda1               118523      9596    102905   9% /boot
tmpfs                  1037060         0   1037060   0% /dev/shm
root@pbx:~ $ cd/
-bash: cd/: No such file or directory
root@pbx:~ $ cd /
root@pbx:/ $ du -sk * | sort -n
du: cannot read directory `proc/12000': No such file or directory

0       misc
0       net
0       proc
0       sys
1       home
1       media
1       selinux
1       srv
12      lost+found
120     dev
1855    tmp
2766    tftpboot
5482    boot
6401    bin
29721   sbin
44849   etc
75509   lib
82149   opt
110862  tmp.mondo.19696
217912  root
666001  mondo.scratch.7136
1494296 usr
7494884 var
32770426        backup
32994124        mnt
In the backup folder, I see 50 mondo rescue iso's all created on 7/25/2010. There are 50 iso's in one day (a sunday).
mnt/usbmondo had another load of files, created on 7/18/2010 (which is 7 days difference)
So, I deleted these.

I see a scheduled cron job in webmin, three together
Code:
/etc/cron.weekly/0anacron
/etc/cron.weekly/disk-backup.cron
/etc/cron.weekly/makewhatis.cron
So I made these inactive. Any issues with this?
I ran update-fixes as suggested above after freeing disk space.

I've been running this system for over a year, never configured any mondo backups/crons????? Never checked if it was just running in background, and now file size finally maybe became too large.
I do not see any unauthorized calls in my cdr.

Code:
            PBX in a Flash Version 1.3 Daemon Status
********************************************************************
* Asterisk  * ONLINE  * Zaptel    * ONLINE  * MySQL      * ONLINE  *
* SSH       * ONLINE  * Apache    * ONLINE  * Iptables   * ONLINE  *
* Fail2ban  * ONLINE  * IP Connect* ONLINE  * Ip6tables  * ONLINE  *
* BlueTooth * ONLINE  * Hidd      * ONLINE  * NTPD       * ONLINE  *
* Sendmail  * ONLINE  * Samba     * OFFLINE * Webmin     * ONLINE  *
* Ethernet0 * ONLINE  * Ethernet1 *   N/A   * Wlan0      *   N/A   *
********************************************************************
* Running Asterisk Version : LOADING
* Asterisk Source Version  : 1.4.21.2
* Zaptel Source Version    : 1.4.12.1
* Libpri Source Version    : 1.4.7
* Addons Source Version    : 1.4.7
********************************************************************
pbx.local on 192.xx.xx.xx - eth0
CentOS release 5.2 (Final) :32 Bit Kernel: 2.6.18-92.1.6.el5
********************************************************************
 For help on PBX commands than you can run type help-pbx           *
********************************************************************

Dear Friend,
please find the logs after running du -sk * | sort -n command,
i dont know which one causing full my HDD. I am using 250 GB hDD. now frre sapce , i think that why my sql db is loading, showing time out error. how i can ressolve the issue.
 

Attachments

  • IMG_0957.JPG
    IMG_0957.JPG
    908.1 KB · Views: 1

dallas

Active Member
Joined
Oct 21, 2007
Messages
844
Reaction score
247
You will have to search and find the big files. I’m not sure du will find them.

Edit. Look at the du arguments (du — help) and list and sort the files in /usr and /var to identify the biggest files. 250Gb is much larger than needed to run a PBX. There must be a huge log file there somewhere. I’m not at my PC at the moment so I’m out of ideas.
 
Last edited:

shiyas

New Member
Joined
Dec 30, 2018
Messages
7
Reaction score
0
You will have to search and find the big files. I’m not sure du will find them.
Dear Friend,
which command will help to me find large file. please help me i am new one in linux field.
 

wardmundy

Nerd Uno
Joined
Oct 12, 2007
Messages
19,169
Reaction score
5,199
Code:
find / -type f -size +5000k -exec ls -lh {} \; | awk '{ print $9 ": " $5 }'

Files ending in .tar.gz or .pdf can be safely deleted. Ask first with others!
 

shiyas

New Member
Joined
Dec 30, 2018
Messages
7
Reaction score
0
Code:
find / -type f -size +5000k -exec ls -lh {} \; | awk '{ print $9 ": " $5 }'

Files ending in .tar.gz or .pdf can be safely deleted. Ask first with others!
which command i can use for deleting .tar .gz files
 
Status
Not open for further replies.

Members online

No members online now.

Forum statistics

Threads
25,782
Messages
167,509
Members
19,203
Latest member
frapu
Get 3CX - Absolutely Free!

Link up your team and customers Phone System Live Chat Video Conferencing

Hosted or Self-managed. Up to 10 users free forever. No credit card. Try risk free.

3CX
A 3CX Account with that email already exists. You will be redirected to the Customer Portal to sign in or reset your password if you've forgotten it.
Top