On 2/17/20 2:49 PM, Simon Colston wrote: > Fedora 31 Workstation > > I am running mysql in a container using podman. After some > experimenting I got it running with this command: > > podman run --detach --userns=keep-id \ > --security-opt label=disable \ > --name=mysql \ > --env="MYSQL_ROOT_PASSWORD=mysql" --publish 3306:3306 \ > --volume=/home/simon/servers/mysql/var/lib/mysql:/var/lib/mysql > mysql:8.0 \ Change this line to --volume=/home/simon/servers/mysql/var/lib/mysql:/var/lib/mysql:Z mysql:8.0 \ And you won't need to disable SELinux separation. > --character-set-server=utf8mb4 > --collation-server=utf8mb4_unicode_ci \ > --lower_case_table_names=1 > > The bits that took time to research were: > --userns=keep-id - which maps my user to the same uid > in the container > --security-opt label=disable - which disables SELinux in the > container (dev machine so OK) > > I could then connect to the database using the mysql client: > > mysql -u root -p -h 127.0.0.1 -P 3306 > > > Now, after a dnf upgrade this has stopped working and I get an error > message: > > ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111) > > The container is running and appears to be healthy. I've tried > recreating the container and reinitialising the database (by deleting > all the files). > > [simon@hedgehog ~]$ podman ps > CONTAINER ID IMAGE COMMAND > CREATED STATUS PORTS NAMES > d7ee24d35a93 docker.io/library/mysql:8.0 --character-s 12 minutes > ago Up 12 minutes ago 0.0.0.0:3306->3306/tcp mysql > > > Podman was updated during the upgrade, as was the kernel and a bunch > of other stuff. > > simon@hedgehog ~]$ dnf history info 70 | grep podman > Upgrade > podman-2:1.8.0-2.fc31.x86_64 @updates > Upgraded > podman-2:1.7.0-2.fc31.x86_64 @@System > Upgrade > podman-plugins-2:1.8.0-2.fc31.x86_64 @updates > Upgraded > podman-plugins-2:1.7.0-2.fc31.x86_64 @@System > > Does anyone have any idea how I can get this working again? Or any > clues as to how I should go about investigating further? > > Thanks, > > Simon > _______________________________________________ > users mailing list -- users@xxxxxxxxxxxxxxxxxxxxxxx > To unsubscribe send an email to users-leave@xxxxxxxxxxxxxxxxxxxxxxx > Fedora Code of Conduct: > https://docs.fedoraproject.org/en-US/project/code-of-conduct/ > List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines > List Archives: > https://lists.fedoraproject.org/archives/list/users@xxxxxxxxxxxxxxxxxxxxxxx _______________________________________________ users mailing list -- users@xxxxxxxxxxxxxxxxxxxxxxx To unsubscribe send an email to users-leave@xxxxxxxxxxxxxxxxxxxxxxx Fedora Code of Conduct: https://docs.fedoraproject.org/en-US/project/code-of-conduct/ List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines List Archives: https://lists.fedoraproject.org/archives/list/users@xxxxxxxxxxxxxxxxxxxxxxx
