Ha ha... (Irishwoman)
Yes, I have a backup of my OpenEMR data.
Purging mysql... I have been here before. See code below.
The basic problem seems to be that I cannot remove MySQL because in order to do so OpenEMR has to be removed, which cannot be done either because the MySQL installation is broken.
robert@robert-ideacentre-AIO-520-22IKU ~ $ sudo apt-get purge mysql-server
[sudo] password for robert:
Reading package lists... Done
Building dependency tree
Reading state information... Done
Package 'mysql-server' is not installed, so not removed
You might want to run 'apt-get -f install' to correct these:
The following packages have unmet dependencies.
openemr : Depends: mysql-server or
mariadb-server but it is not going to be installed
Depends: libdbd-mysql-perl but it is not going to be installed
E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).
robert@robert-ideacentre-AIO-520-22IKU ~ $ sudo apt-get -f install
Reading package lists... Done
Building dependency tree
Reading state information... Done
Correcting dependencies... Done
The following packages were automatically installed and are no longer required:
cabextract gstreamer0.10-ffmpeg libavcodec-extra libbasicusageenvironment1
libdirectfb-1.2-9 libdvbpsi10 libebml4v5 libgroupsock8 libgsasl7
libhal1-flash libiso9660-8 libkyotocabinet16v5 liblivemedia50 libmatroska6v5
libmpcdec6 libmspack0 libntlm0 libproxy-tools libqt5x11extras5
libresid-builder0c2a libsdl-image1.2 libsidplay2v5 libssh2-1 libunshield0
libupnp6 libusageenvironment3 libva-drm1 libva-x11-1 libvcdinfo0 libvlc5
libvlccore8 libvncclient1 libxcb-composite0 libxcb-xv0 mailutils-common
oxideqt-codecs-extra unshield vlc vlc-data vlc-nox vlc-plugin-notify
Use 'sudo apt autoremove' to remove them.
The following additional packages will be installed:
libdbd-mysql-perl libmysqlclient20 mysql-client-5.7 mysql-client-core-5.7
mysql-server mysql-server-5.7 mysql-server-core-5.7
Suggested packages:
mailx tinyca
Recommended packages:
libhtml-template-perl
The following NEW packages will be installed
libdbd-mysql-perl libmysqlclient20 mysql-client-5.7 mysql-client-core-5.7
mysql-server mysql-server-5.7 mysql-server-core-5.7
0 to upgrade, 7 to newly install, 0 to remove and 7 not to upgrade.
1 not fully installed or removed.
Need to get 18,3 MB/19,2 MB of archives.
After this operation, 165 MB of additional disk space will be used.
Do you want to continue? [Y/n] y
Get:1
http://ubuntu.cica.es/ubuntu xenial-updates/main amd64 mysql-client-core-5.7 amd64 5.7.25-0ubuntu0.16.04.2 [6.673 kB]
Get:2
http://ubuntu.cica.es/ubuntu xenial-updates/main amd64 mysql-client-5.7 amd64 5.7.25-0ubuntu0.16.04.2 [1.726 kB]
Get:3
http://ubuntu.cica.es/ubuntu xenial-updates/main amd64 mysql-server-core-5.7 amd64 5.7.25-0ubuntu0.16.04.2 [7.272 kB]
Get:4
http://ubuntu.cica.es/ubuntu xenial-updates/main amd64 mysql-server-5.7 amd64 5.7.25-0ubuntu0.16.04.2 [2.623 kB]
Get:5
http://ubuntu.cica.es/ubuntu xenial-updates/main amd64 mysql-server all 5.7.25-0ubuntu0.16.04.2 [10,8 kB]
Fetched 18,3 MB in 2s (8.418 kB/s)
Preconfiguring packages ...
Selecting previously unselected package mysql-client-core-5.7.
dpkg: warning: files list file for package 'mysql-common' missing; assuming package has no files currently installed
(Reading database ... 281485 files and directories currently installed.)
Preparing to unpack .../mysql-client-core-5.7_5.7.25-0ubuntu0.16.04.2_amd64.deb ...
Unpacking mysql-client-core-5.7 (5.7.25-0ubuntu0.16.04.2) ...
Selecting previously unselected package mysql-client-5.7.
Preparing to unpack .../mysql-client-5.7_5.7.25-0ubuntu0.16.04.2_amd64.deb ...
Unpacking mysql-client-5.7 (5.7.25-0ubuntu0.16.04.2) ...
Selecting previously unselected package mysql-server-core-5.7.
Preparing to unpack .../mysql-server-core-5.7_5.7.25-0ubuntu0.16.04.2_amd64.deb ...
Unpacking mysql-server-core-5.7 (5.7.25-0ubuntu0.16.04.2) ...
Selecting previously unselected package mysql-server-5.7.
Preparing to unpack .../mysql-server-5.7_5.7.25-0ubuntu0.16.04.2_amd64.deb ...
grep: /etc/mysql/: No such file or directory
Unpacking mysql-server-5.7 (5.7.25-0ubuntu0.16.04.2) ...
Selecting previously unselected package mysql-server.
Preparing to unpack .../mysql-server_5.7.25-0ubuntu0.16.04.2_all.deb ...
Unpacking mysql-server (5.7.25-0ubuntu0.16.04.2) ...
Selecting previously unselected package libmysqlclient20:amd64.
Preparing to unpack .../libmysqlclient20_5.7.25-0ubuntu0.16.04.2_amd64.deb ...
Unpacking libmysqlclient20:amd64 (5.7.25-0ubuntu0.16.04.2) ...
Selecting previously unselected package libdbd-mysql-perl.
Preparing to unpack .../libdbd-mysql-perl_4.033-1ubuntu0.1_amd64.deb ...
Unpacking libdbd-mysql-perl (4.033-1ubuntu0.1) ...
Processing triggers for man-db (2.7.5-1) ...
Processing triggers for systemd (229-4ubuntu21.21) ...
Processing triggers for ureadahead (0.100.0-19) ...
ureadahead will be reprofiled on next reboot
Processing triggers for libc-bin (2.23-0ubuntu11) ...
Setting up mysql-client-core-5.7 (5.7.25-0ubuntu0.16.04.2) ...
Setting up mysql-client-5.7 (5.7.25-0ubuntu0.16.04.2) ...
Setting up mysql-server-core-5.7 (5.7.25-0ubuntu0.16.04.2) ...
Setting up mysql-server-5.7 (5.7.25-0ubuntu0.16.04.2) ...
/var/lib/dpkg/info/mysql-server-5.7.postinst: line 143: /usr/share/mysql-common/configure-symlinks: No such file or directory
dpkg: error processing package mysql-server-5.7 (--configure):
subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
mysql-server depends on mysql-server-5.7; however:
Package mysql-server-5.7 is not configured yet.
dpkg: error processing package mysql-server (--configure):
dependency problems - leaving unconfigured
Setting up libmysqlclient20:amd64 (5.7.25-0ubuntu0.16.04.2) ...
No apport report written because the error message indicates it's a follow-up error from a previous failure.
Setting up libdbd-mysql-perl (4.033-1ubuntu0.1) ...
dpkg: dependency problems prevent configuration of openemr:
openemr depends on mysql-server | mariadb-server; however:
Package mysql-server is not configured yet.
Package mariadb-server is not installed.
dpkg: error processing package openemr (--configure):
dependency problems - leaving unconfigured
No apport report written because the error message indicates it's a follow-up error from a previous failure.
Processing triggers for systemd (229-4ubuntu21.21) ...
Processing triggers for ureadahead (0.100.0-19) ...
Processing triggers for libc-bin (2.23-0ubuntu11) ...
Errors were encountered while processing:
mysql-server-5.7
mysql-server
openemr
E: Sub-process /usr/bin/dpkg returned an error code (1)
robert@robert-ideacentre-AIO-520-22IKU ~ $