Re: podman and mysql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 18/02/2020 18:37, Daniel Walsh wrote:
On 2/17/20 3:17 PM, Simon Colston wrote:


On 17/02/2020 19:56, Daniel Walsh wrote:
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 \


What error are you seeing? What AVCs?

Thanks, but I'm not seeing any errors or AVCs.

I've done some more investigation and I have a reproduction recipe.
If I run with this command

    podman run --userns=keep-id \
          --name=mysql \
          --env="MYSQL_ROOT_PASSWORD=mysql" --publish 3306:3306 \
          --volume=/home/simon/servers/mysql/var/lib/mysql:/var/lib/mysql:Z
          mysql:8.0


I can connect with the mysql client with no errors.

    mysql -u root -p -h 127.0.0.1 -P 3306
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
etc.

If I then do:

    podman stop mysql
    podman start mysql

then I can no longer connect with the mysql client.

    mysql -u root -p -h 127.0.0.1 -P 3306
Enter password:
ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111)

I then reset everything:
    podman stop mysql
    podman rm mysql
and delete all the database files.

If I remove the --userns=keep-id argument I can connect after a 'stop' and a 'start'. (Except that the database files now have an odd user id that I can only delete as root)

So, I think the --userns=keep-id is the problem and it fails after restarts.

So am I doing something wrong?  This was working fine before the upgrade from podman 1.7 to 1.8

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



[Index of Archives]     [Older Fedora Users]     [Fedora Announce]     [Fedora Package Announce]     [EPEL Announce]     [EPEL Devel]     [Fedora Magazine]     [Fedora Summer Coding]     [Fedora Laptop]     [Fedora Cloud]     [Fedora Advisory Board]     [Fedora Education]     [Fedora Security]     [Fedora Scitech]     [Fedora Robotics]     [Fedora Infrastructure]     [Fedora Websites]     [Anaconda Devel]     [Fedora Devel Java]     [Fedora Desktop]     [Fedora Fonts]     [Fedora Marketing]     [Fedora Management Tools]     [Fedora Mentors]     [Fedora Package Review]     [Fedora R Devel]     [Fedora PHP Devel]     [Kickstart]     [Fedora Music]     [Fedora Packaging]     [Fedora SELinux]     [Fedora Legal]     [Fedora Kernel]     [Fedora OCaml]     [Coolkey]     [Virtualization Tools]     [ET Management Tools]     [Yum Users]     [Yosemite News]     [Gnome Users]     [KDE Users]     [Fedora Art]     [Fedora Docs]     [Fedora Sparc]     [Libvirt Users]     [Fedora ARM]

  Powered by Linux