Hi All
I am in the process of updating the firmware on my emonpi and I usually do this by provisioning a new SD card and completing an export import exercise.
I am however having issues due to various modifications that cause various errors.
One of the ways of getting around this is to edit the SQL database for the dashboards but I’m unable to install phpmyadmin as it cant find the database? below is a screenshot of the removal of the package but the issue is teh same.
There was some discussion here about this error in a different circumstance (search on mysqld.sock found it).
One thing that has been discovered is that if you have done an upgrade-dist to an EmonSD image you will fall foul of this issue.
What is your starting point (EmonSD?), what modifications do you need and what are the resultant issues that leads you to install phpMyAdmin to fix them?
I’ve never had success in upgrading and its a good mission to upgrade as so many things change as people develop, plus I’ve changed modules like the feed value to choose text size and the colours on the gauge etc.
I believe however the feed value had developed and you can choose font sizes etc.
It would be good however to be able to clone the SD card but its not something I’ve done before.
Here is my main dashboard > http://energy.m0nne.com/emoncms/dashboard/view&id=1
Could you possibly tell me what the ProtectHome value is in file /lib/systemd/system/mariadb.service please?
If it is true, would you mind doing a small test please?
Could you change it to false (see this issue for the best way to do that) and then remove the symbolic link, reload the service and see if it solves the problem.
There might be 2 related issues here cause by this setting.
Protect home is false.
I’ve started again a couple of times as when I import it complains about a file not existing within the graphs code.
I haven’t done a dist-upgrade as I don’t want to break anything that requires a specific version of software.
@glyn.hudson can you think of any reason this problem is occurring (second report but slightly different circumstances). My EmonPi does not have that file.
My guess is that the /etc/mysql/my.cnf is edited during the EmonSD build process as it points to
socket=/home/pi/data/mysql/mysql.sock
Not sure why or how to fix it. This is the global file so anything using mysql would, I would have expected, used it.
Thanks Brian
I have just imported the backup from my working emonpi and I get the following error…
Warning : require_once(Modules/group/group_model.php): failed to open stream: No such file or directory in /var/www/emoncms/Modules/graph/widget/graph_widget.php on line 10
Fatal error : require_once(): Failed opening required ‘Modules/group/group_model.php’ (include_path=‘.:/usr/share/php’) in /var/www/emoncms/Modules/graph/widget/graph_widget.php on line 10
The log directory is effectively held in RAM, (tmpfs) so a reboot will clear it.
If possible, you should try to find out why it filled to capacity, as the fact that it did get full may be an indication of an underlying issue.