Unable to connect EmonCMS

nwyrsch · 2019-01-14T15:57:16.795Z

Today, I temptatively upgraded my raspery pi and EmonCMS (within the application using the dedicated upgrade buttons). A subsequent check of the database check resulted in an error (I forgot the details). After a few login out an reboot of the raspberry, I am in a situation where I cannot log anymore: getting the error mesage Can’t connect to MySQL server on ‘127.0.0.1’. The issue seems to be related to the MySQL service that does not start. I tried to start manually bit it immediately fails. Ath this point I would like to know if

what are the possible reason for MySQL service not starting
possible solutions to solve the proble
a way to backup the MySQL database (and later recover the data) without having the service running.

May thanks for pointers and help

TrystanLea · 2019-01-14T16:43:55.409Z

Hello @nwyrsch

What do you see if you type:

sudo service mysql status

could you also copy the output of Administration > Server Information (see copy to clipboard).

nwyrsch · 2019-01-14T18:04:45.698Z

Here is the output

● mysql.service - LSB: Start and stop the mysql database server daemon
   Loaded: loaded (/etc/init.d/mysql)
   Active: failed (Result: exit-code) since Mon 2019-01-14 16:29:22 CET; 1h 40min ago
  Process: 1722 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)

Jan 14 16:29:22 emonpi mysql[1722]: /etc/init.d/mysql: ERROR: The partition...d!
Jan 14 16:29:22 emonpi systemd[1]: mysql.service: control process exited, c...=1
Jan 14 16:29:22 emonpi systemd[1]: Failed to start LSB: Start and stop the ...n.
Jan 14 16:29:22 emonpi systemd[1]: Unit mysql.service entered failed state.
Hint: Some lines were ellipsized, use -l to show in full.

borpin · 2019-01-14T21:23:47.532Z

@TrystanLea @glyn.hudson second one this week.

Might be a trend. Help: "Fatal error: . . . " after emonPi update looks very similar.

borpin · 2019-01-14T21:36:19.855Z

There is a very similar thread I have linked to.

Have you tried the button again? If not, can you please post the contents of /home/pi/data/emonpiupdate.log

If you have used the button more than once then the file will be less useful as it is cleared (I think) each time.

nwyrsch:

Hint: Some lines were ellipsized, use -l to show in full.

Could you do this please (use -l switch).

When you post the output, please put 3 backticks (top left of keyboard) on a line before the pasted output and then 3 more on a line below the pasted output (if you edit your post above, you will see what I have done).

borpin · 2019-01-14T21:44:16.136Z

nwyrsch:

I am in a situation where I cannot log anymore

TrystanLea:

could you also copy the output of Administration > Server Information (see copy to clipboard).

@TrystanLea sadly @nwyrsch can’t.

Does this update process do an sudo apt update & sudo apt upgrade?

glyn.hudson · 2019-01-15T01:44:58.811Z

Sorry to hear, we will do our best to help. Do you know what version emonSD you are running?

It’s displayed on the Emoncms admin page or can be found with:

$ ls /boot | grep emonSD

nwyrsch · 2019-01-21T20:37:28.028Z

I finally found the origin of my problem. I run out of SD card space! I am using a hard drive but I did not properly set the use of the latter. I have now to see if I can restart the MySQL service when the partition is increases and get access to the my data.