# phpMyAdmin Install Issues **URL:** \ **Category:** emonPi\ **Tags:** emonpi\ **Created:** [24 February 2019 09:48 UTC](https://community.openenergymonitor.org/t/phpmyadmin-install-issues/10219 "2019-02-24T09:48:28Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Dave](https://community.openenergymonitor.org/letter_avatar_proxy/v4/letter/d/ee7513/32.png) [@Dave](https://community.openenergymonitor.org/u/Dave)\ **Post date:** [24 February 2019 09:48 UTC](https://community.openenergymonitor.org/t/phpmyadmin-install-issues/10219/1 "2019-02-24T09:48:28Z")
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. ![phpMyAdmin](https://community.openenergymonitor.org/uploads/default/original/2X/6/6ebd8e6eff3c9ff75739974a9c0247d42ab9826c.jpeg) Kind Regards Dave ---
**Author:** ![borpin](https://community.openenergymonitor.org/user_avatar/community.openenergymonitor.org/borpin/32/193_2.png) [@borpin](https://community.openenergymonitor.org/u/borpin)\ **Post date:** [24 February 2019 11:37 UTC](https://community.openenergymonitor.org/t/phpmyadmin-install-issues/10219/2 "2019-02-24T11:37:50Z")
There was some discussion [here](https://community.openenergymonitor.org/t/log-rotate-errors/10003) 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](https://github.com/emoncms/emoncms/issues/1202). 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? ---
**Author:** ![Dave](https://community.openenergymonitor.org/letter_avatar_proxy/v4/letter/d/ee7513/32.png) [@Dave](https://community.openenergymonitor.org/u/Dave)\ **Post date:** [24 February 2019 12:51 UTC](https://community.openenergymonitor.org/t/phpmyadmin-install-issues/10219/3 "2019-02-24T12:51:01Z")
Hi Brian I resolved the issue by creating a symbolic link… > ln -s /home/pi/data/mysql/mysql.sock /var/run/mysqld/mysqld.sock 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](http://energy.m0nne.com/emoncms/dashboard/view&id=1) King Regards Dave ---
**Author:** ![borpin](https://community.openenergymonitor.org/user_avatar/community.openenergymonitor.org/borpin/32/193_2.png) [@borpin](https://community.openenergymonitor.org/u/borpin)\ **Post date:** [24 February 2019 15:50 UTC](https://community.openenergymonitor.org/t/phpmyadmin-install-issues/10219/4 "2019-02-24T15:50:50Z")
Have you done a `dist-upgrade`? 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. ---
**Author:** ![Dave](https://community.openenergymonitor.org/letter_avatar_proxy/v4/letter/d/ee7513/32.png) [@Dave](https://community.openenergymonitor.org/u/Dave)\ **Post date:** [24 February 2019 17:20 UTC](https://community.openenergymonitor.org/t/phpmyadmin-install-issues/10219/5 "2019-02-24T17:20:30Z")
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. Kind Regards Dave ---
**Author:** ![borpin](https://community.openenergymonitor.org/user_avatar/community.openenergymonitor.org/borpin/32/193_2.png) [@borpin](https://community.openenergymonitor.org/u/borpin)\ **Post date:** [24 February 2019 20:29 UTC](https://community.openenergymonitor.org/t/phpmyadmin-install-issues/10219/6 "2019-02-24T20:29:56Z")
Ok thanks, eliminates that as a cause then. @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 ```auto 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. ---
**Author:** ![Dave](https://community.openenergymonitor.org/letter_avatar_proxy/v4/letter/d/ee7513/32.png) [@Dave](https://community.openenergymonitor.org/u/Dave)\ **Post date:** [24 February 2019 22:43 UTC](https://community.openenergymonitor.org/t/phpmyadmin-install-issues/10219/7 "2019-02-24T22:43:49Z")
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** Regards Dave ---
**Author:** ![whatsupskip](https://community.openenergymonitor.org/letter_avatar_proxy/v4/letter/w/5f9b8f/32.png) [@whatsupskip](https://community.openenergymonitor.org/u/whatsupskip)\ **Post date:** [25 February 2019 01:09 UTC](https://community.openenergymonitor.org/t/phpmyadmin-install-issues/10219/8 "2019-02-25T01:09:43Z")
I haven’t done upgrade on one of my systems. I have just tried to install phpmyAdmin and I have hit problems as well. ```auto > E: Write error - ~LZMAFILE (28: No space left on device) > E: Sub-process /usr/bin/dpkg returned an error code (1) ``` Which is a bit strange: ```auto > Filesystem 1K-blocks Used Available Use% Mounted on > /dev/root 3999680 1677392 2133856 45% / > devtmpfs 495480 0 495480 0% /dev > tmpfs 500088 0 500088 0% /dev/shm > tmpfs 500088 19196 480892 4% /run > tmpfs 5120 4 5116 1% /run/lock > tmpfs 500088 0 500088 0% /sys/fs/cgroup > tmpfs 51200 51200 0 100% /var/log > tmpfs 30720 4 30716 1% /tmp > tmpfs 1024 0 1024 0% /var/tmp > /dev/mmcblk0p3 11255794 309152 10374740 3% /home/pi/data > /dev/mmcblk0p1 43539 22506 21034 52% /boot > tmpfs 100016 0 100016 0% /run/user/1000 ``` I was trying to change the Write API Key to the same as a previous install with corrupted. Otherwise I need to update about 15 devices ☹ _Edit - formatted text for readability. BT - Moderator_ ---
**Author:** ![Bill.Thomson](https://community.openenergymonitor.org/user_avatar/community.openenergymonitor.org/bill.thomson/32/1834_2.png) [@Bill.Thomson](https://community.openenergymonitor.org/u/Bill.Thomson)\ **Post date:** [25 February 2019 04:07 UTC](https://community.openenergymonitor.org/t/phpmyadmin-install-issues/10219/9 "2019-02-25T04:07:31Z")
> [@whatsupskip](#): > > tmpfs 51200 51200 0 100% /var/log Not _too_ strange… Your log directory is full: ```auto tmpfs 51200 51200 0 100% /var/log ``` 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. ---
**Author:** ![borpin](https://community.openenergymonitor.org/user_avatar/community.openenergymonitor.org/borpin/32/193_2.png) [@borpin](https://community.openenergymonitor.org/u/borpin)\ **Post date:** [25 February 2019 08:14 UTC](https://community.openenergymonitor.org/t/phpmyadmin-install-issues/10219/10 "2019-02-25T08:14:29Z")
> [@Dave](#): > > I have just imported the backup from my working emonpi To where? A self install? Neither the **group** and **graph** modules are core modules installed with Emoncms (but may be insatlled on the EmonSD - can’t check right now) and need to be installed separately from the main EmonCMS organisation. [GitHub - emoncms/graph: Versatile graphing module for emoncms](https://github.com/emoncms/graph), [GitHub - emoncms/group: In development: Emoncms groups module](https://github.com/emoncms/group) No, I don’t know why either. Just how the overall system has developed over time.