FROM debian:12.6
ARG DEBIAN_FRONTEND=noninteractive

RUN apt update -y
RUN apt upgrade -y
RUN apt install -y mariadb-server lsof net-tools 

RUN useradd -m -u 1000 user

RUN mkdir /run/mysqld
RUN chown -R user:user /run/mysqld
# RUN touch /run/mysqld/mysqld.sock
# RUN chown -R user:user /run/mysqld


USER user

RUN mkdir -p /home/user/mariadb/data

# RUN cp /etc/mysql/my.cnf /home/user/mariadb/my.cnf
RUN touch /home/user/mariadb/my.cnf

RUN echo [mysqld] >> /home/user/mariadb/my.cnf
RUN echo datadir = /home/user/mariadb/data >> /home/user/mariadb/my.cnf
RUN echo socket = /home/user/mariadb/mysql.sock >> /home/user/mariadb/my.cnf
RUN echo  >> /home/user/mariadb/my.cnf
RUN echo [client] >> /home/user/mariadb/my.cnf
RUN echo socket = /home/user/mariadb/mysql.sock >> /home/user/mariadb/my.cnf
RUN echo  >> /home/user/mariadb/my.cnf
RUN echo  >> /home/user/mariadb/my.cnf
RUN echo [client-server] >> /home/user/mariadb/my.cnf
RUN echo # Port or socket location where to connect >> /home/user/mariadb/my.cnf
RUN echo port = 7860 >> /home/user/mariadb/my.cnf
RUN echo socket = /home/user/mariadb/mysql.sock >> /home/user/mariadb/my.cnf
RUN echo  >> /home/user/mariadb/my.cnf
RUN echo # Import all .cnf files from configuration directory >> /home/user/mariadb/my.cnf
RUN echo #!includedir /etc/mysql/conf.d/ >> /home/user/mariadb/my.cnf
RUN echo #!includedir /etc/mysql/mariadb.conf.d/ >> /home/user/mariadb/my.cnf




RUN cat /home/user/mariadb/my.cnf

RUN ls /etc/mysql/conf.d/
RUN ls /etc/mysql/mariadb.conf.d/
RUN ls /home/user/mariadb/data
RUN mariadb-install-db --datadir=/home/user/mariadb/data --user=user
RUN ls /home/user/mariadb/data
RUN chown -R user:user /home/user/mariadb
CMD [ "bash","-c","cat /home/user/mariadb/my.cnf; echo ======================================; ls -la /home/user/mariadb/data/; mysqld_safe --defaults-file=/home/user/mariadb/my.cnf & echo aqui ; netstat -tulpn; lsof -i ; apt search -y python; ls -la /home/user/mariadb/data/;  tail -F /home/user/mariadb/data/r-ladogton2010*.* " ]
# [mysqld]
# datadir = /home/user/mariadb/data
# socket = /home/user/mariadb/mysql.sock

# [client]
# socket = /home/user/mariadb/mysql.sock