Re: podman and mysql

[Daniel Walsh]

On 2/18/20 4:20 PM, Simon Colston wrote:
> 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 -- [e-mail]
> To unsubscribe send an email to [e-mail]
> 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/[e-mail]

Seems like it could be something with slirp4netns?

Giuseppe any ideas?