search

canonical / charmed-mysql-snap

SNAP for Charmed MySQL charm.
https://snapcraft.io/charmed-mysql
Apache License 2.0
0 stars 4 forks source link

Failed running MYSQL Service #40

Closed lamualfa closed 6 months ago

lamualfa commented 1 year ago

Steps to reproduce

  1. sudo snap install --channel=8.0 mysql-server
  2. sudo snap start mysql-server.mysqld
  3. sudo snap logs mysql-server.mysqld

Expected behavior

MYSQL Service started properly.

Actual behavior

image

Versions

snap    2.59.5
snapd   2.59.5
series  16
ubuntu  22.04
kernel  5.15.0-84-generic

Log output

lamualfa@monoteam-server:~$ sudo snap start mysql-server.mysqld 
Started.
lamualfa@monoteam-server:~$ sudo snap logs mysql-server.mysqld 
2023-10-03T15:44:25Z mysql-server.mysqld[79505]: cp: cannot create regular file '/var/snap/mysql-server/common/mysql/conf.d/mysqldump.cnf': Permission denied
2023-10-03T15:44:25Z mysql-server.mysqld[79505]: cp: cannot create regular file '/var/snap/mysql-server/common/mysql/debian-start': Permission denied
2023-10-03T15:44:25Z mysql-server.mysqld[79505]: cp: cannot create regular file '/var/snap/mysql-server/common/mysql/my.cnf.fallback': Permission denied
2023-10-03T15:44:25Z mysql-server.mysqld[79505]: cp: cannot create regular file '/var/snap/mysql-server/common/mysql/mysql.cnf': Permission denied
2023-10-03T15:44:25Z mysql-server.mysqld[79505]: cp: cannot create regular file '/var/snap/mysql-server/common/mysql/mysql.conf.d/mysql.cnf': Permission denied
2023-10-03T15:44:25Z mysql-server.mysqld[79505]: cp: cannot create regular file '/var/snap/mysql-server/common/mysql/mysql.conf.d/mysqld.cnf': Permission denied
2023-10-03T15:44:25Z mysql-server.mysqld[79508]: sed: couldn't open temporary file /var/snap/mysql-server/common/mysql/mysql.conf.d/sed4hKO2c: Permission denied
2023-10-03T15:44:25Z mysql-server.mysqld[79509]: sed: couldn't open temporary file /var/snap/mysql-server/common/mysql/mysql.conf.d/sedyaEoZ5: Permission denied
2023-10-03T15:44:25Z mysql-server.mysqld[79510]: sed: couldn't open temporary file /var/snap/mysql-server/common/mysql/mysql.conf.d/sedXqvrUH: Permission denied
2023-10-03T15:44:25Z mysql-server.mysqld[79511]: touch: cannot touch '/var/snap/mysql-server/common/mysql/initialized': Permission denied
github-actions[bot] commented 1 year ago

https://warthogs.atlassian.net/browse/DPE-2692

shayancanonical commented 6 months ago

@lamualfa thank you for reporting

This snap is charmed-mysql and not mysql-server (mysql-server must be hosted in a different repository.

I confirmed that I am able to install charmed-mysql and start up mysqld

shayanp@brisbane:~$ sudo snap install charmed-mysql  --channel 8.0/edge
charmed-mysql (8.0/edge) 8.0.36 from Canonical Data Platform (dataplatformbot) installed
shayanp@brisbane:~$ sudo snap start charmed-mysql.mysqld
Started.
shayanp@brisbane:~$ sudo snap logs charmed-mysql.mysqld
2024-04-03T20:50:14Z systemd[1]: Started Service for snap application charmed-mysql.mysqld.
2024-04-03T20:50:14Z charmed-mysql.mysqld[3936200]: 2024-04-03T20:50:14.276833Z mysqld_safe Logging to '/var/snap/charmed-mysql/common/var/log/mysql/error.log'.
2024-04-03T20:50:14Z charmed-mysql.mysqld[3936200]: 2024-04-03T20:50:14.298410Z mysqld_safe Starting mysqld daemon with databases from /var/snap/charmed-mysql/common/var/lib/mysql
2024-04-03T20:50:19Z systemd[1]: Stopping Service for snap application charmed-mysql.mysqld...
2024-04-03T20:50:20Z charmed-mysql.mysqld[3936200]: 2024-04-03T20:50:20.374735Z mysqld_safe mysqld from pid file /var/snap/charmed-mysql/common/var/run/mysqld/mysqld.pid ended
2024-04-03T20:50:20Z systemd[1]: snap.charmed-mysql.mysqld.service: Deactivated successfully.
2024-04-03T20:50:20Z systemd[1]: Stopped Service for snap application charmed-mysql.mysqld.
2024-04-04T11:59:29Z systemd[1]: Started Service for snap application charmed-mysql.mysqld.
2024-04-04T11:59:29Z charmed-mysql.mysqld[3175272]: 2024-04-04T11:59:29.259136Z mysqld_safe Logging to '/var/snap/charmed-mysql/common/var/log/mysql/error.log'.
2024-04-04T11:59:29Z charmed-mysql.mysqld[3175272]: 2024-04-04T11:59:29.282558Z mysqld_safe Starting mysqld daemon with databases from /var/snap/charmed-mysql/common/var/lib/mysql
shayanp@brisbane:~$ sudo snap services charmed-mysql.mysqld
Service               Startup   Current  Notes
charmed-mysql.mysqld  disabled  active   -
shayanp@brisbane:~$ nmap -Pn 127.0.0.1 -p 3306
Starting Nmap 7.94 ( https://nmap.org ) at 2024-04-04 12:00 UTC
Nmap scan report for localhost (127.0.0.1)
Host is up (0.00013s latency).

PORT     STATE SERVICE
3306/tcp open  mysql

Nmap done: 1 IP address (1 host up) scanned in 0.04 seconds