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

dallas

Active Member
Joined
Oct 21, 2007
Messages
219
Reaction score
31
Location
Sydney, Australia
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
219
Reaction score
31
Location
Sydney, Australia
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

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

shiyas

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

Code:
[email protected]:~ $ 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
[email protected]:~ $ cd/
-bash: cd/: No such file or directory
[email protected]:~ $ cd /
[email protected]:/ $ 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

dallas

Active Member
Joined
Oct 21, 2007
Messages
219
Reaction score
31
Location
Sydney, Australia
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:
  • Like
Reactions: shiyas

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
15,234
Reaction score
2,667
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

PIAF 5 - Powered by 3CX

Forum statistics

Threads
22,448
Messages
138,015
Members
14,613
Latest member
roshan2019