LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 07-09-2017, 04:37 AM   #1
nk5454
LQ Newbie
 
Registered: Jul 2017
Posts: 4

Rep: Reputation: Disabled
CACTI login webpage gives error - root directory 100%


Cacti webpage gives below error;
FATAL: Cannot connect to MySQL server on 'localhost'. Please make sure you have specified a valid MySQL database name in 'include/config.php' Warning: Unknown: write failed: No space left on device (28) in Unknown on line 0 Warning: Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/var/lib/php/session) in Unknown on line 0

Root directory partition is 100%, is it safe to empty mysqld.log file consuming 28G out of 38G? or can i reduce /home partition and increase root partition.. what would be the best solution?

Thanks
 
Old 07-09-2017, 11:12 AM   #2
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 23,934

Rep: Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021
Quote:
Originally Posted by nk5454 View Post
Cacti webpage gives below error;
FATAL: Cannot connect to MySQL server on 'localhost'. Please make sure you have specified a valid MySQL database name in 'include/config.php' Warning: Unknown: write failed: No space left on device (28) in Unknown on line 0 Warning: Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/var/lib/php/session) in Unknown on line 0

Root directory partition is 100%, is it safe to empty mysqld.log file consuming 28G out of 38G? or can i reduce /home partition and increase root partition.. what would be the best solution?
Stop MySQL first, then remove the log(s) in question, and restart it, and consider looking at logrotate to keep things like that from happening. And 'reduce /home partition' isn't an easy thing to do, unless you have LVM in place, and are also running LVM on your / partition as well...which you probably aren't. A 38GB root partition is very small these days.
 
Old 07-10-2017, 09:22 AM   #3
nk5454
LQ Newbie
 
Registered: Jul 2017
Posts: 4

Original Poster
Rep: Reputation: Disabled
will it effect the current graphs and configuration if i empty mysqld.log file? or its just a logs and would make no difference..
 
Old 07-10-2017, 09:30 AM   #4
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 23,934

Rep: Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021
Quote:
Originally Posted by nk5454 View Post
will it effect the current graphs and configuration if i empty mysqld.log file? or its just a logs and would make no difference..
If you're concerned, then back up the logs/copy them elsewhere. But these are just MySQL log files, not the data that drives anything. Again, stop MySQL, and do as you wish with the logs, and again, look into using logrotate.
 
Old 07-10-2017, 09:41 AM   #5
nk5454
LQ Newbie
 
Registered: Jul 2017
Posts: 4

Original Poster
Rep: Reputation: Disabled
Thanks TB0ne,
Could you please let me know how can i backup logs and apply logrotate..
Regards
 
Old 07-10-2017, 10:07 AM   #6
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 23,934

Rep: Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021
Quote:
Originally Posted by nk5454 View Post
Thanks TB0ne,
Could you please let me know how can i backup logs and apply logrotate..
AGAIN: as said before, you can copy them elsewhere. How you do this and where you copy them to is up to you. And you can read the documentation on logrotate from their website and the many logrotate tutorials you can find with a brief Google search.
 
Old 07-11-2017, 04:18 AM   #7
nk5454
LQ Newbie
 
Registered: Jul 2017
Posts: 4

Original Poster
Rep: Reputation: Disabled
I copied the file into other directory after stopping service: service mysqld stop, then when i completed copying, i tried to start the services by command service mysqld start, its giving below error;
Timeout error occurred trying to start MySQL Daemon
Starting mysqld: [FAILED]

how can i get mysqld started again?

Regards..
 
Old 07-11-2017, 06:56 AM   #8
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 23,934

Rep: Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021
Quote:
Originally Posted by nk5454 View Post
I copied the file into other directory after stopping service: service mysqld stop, then when i completed copying, i tried to start the services by command service mysqld start, its giving below error;
Timeout error occurred trying to start MySQL Daemon
Starting mysqld: [FAILED]

how can i get mysqld started again?
Check our disk space again. If you copied that file to another folder on the same out-of-space drive, you've done nothing but relocate the problem. Also try running
Code:
service mysqld stop; mysqld_safe &
...to see if that helps. Again, as you've been asked a couple of times now, why is your / partition so small? Have you tried to reboot? Did you check any of the system logs to see if there are any errors??

Read the "Question Guidelines" link in my posting signature; putting your exact error message into Google yields lots of suggestions/results.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Root directory 100% full - but disk utilization doesn't add up. Maybe solved? gustep12 Linux - Newbie 3 10-18-2016 12:08 PM
[SOLVED] root directory 100% used krisen_nadasen Linux - Newbie 10 12-31-2010 05:53 AM
Cacti installation on Debian Sarge: create cacti database error Yahweee Debian 2 08-26-2008 06:35 AM
CPU 100% with cacti reallove Linux - Software 1 03-14-2007 06:39 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 12:52 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration