Figured I'd ask here since I'm not finding any solution on the net other than re-install which I prefer not to do.
I have a couple of freebsd 13 servers running with freshly installed mariadb 10.5.
I have
sysrc mysql_enable="YES"
in the /etc/rc.conf.
I ran the safe installation and got everything going. However, trying to control the service leads to nothing having been installed in the rc.d folder.
Oddly, it was running but after a reboot, nothing.
# sockstat -4 -6 | grep mysql
nothing running.
The result showed it was running when it was before this problem.
# service mariadb status (and variations)
mariadb does not exist in /etc/rc.d or the local startup
directories (/usr/local/etc/rc.d), or is not executable
# service mariadb-server status
mariadb-server does not exist in /etc/rc.d or the local startup
directories (/usr/local/etc/rc.d), or is not executable
# ls -la /usr/local/etc/rc.d
-rwxr-xr-x 1 root wheel 6132 Apr 11 22:14 apache24
-rwxr-xr-x 1 root wheel 3070 Apr 7 20:55 garb
-rwxr-xr-x 1 root wheel 1732 Apr 11 22:14 htcacheclean
-rwxr-xr-x 1 root wheel 1212 Apr 15 18:15 php-fpm
-rwxr-xr-x 1 root wheel 986 Apr 7 02:52 rsyncd
All of the db files are still in the /var/db structure.
What's happened and what's the quickest fix so I can get back to work?
Maybe all I need is the file that does into the rc.d? Maybe someone can share theirs?
See, I swear it was running! .
I have a couple of freebsd 13 servers running with freshly installed mariadb 10.5.
I have
sysrc mysql_enable="YES"
in the /etc/rc.conf.
I ran the safe installation and got everything going. However, trying to control the service leads to nothing having been installed in the rc.d folder.
Oddly, it was running but after a reboot, nothing.
# sockstat -4 -6 | grep mysql
nothing running.
The result showed it was running when it was before this problem.
# service mariadb status (and variations)
mariadb does not exist in /etc/rc.d or the local startup
directories (/usr/local/etc/rc.d), or is not executable
# service mariadb-server status
mariadb-server does not exist in /etc/rc.d or the local startup
directories (/usr/local/etc/rc.d), or is not executable
# ls -la /usr/local/etc/rc.d
-rwxr-xr-x 1 root wheel 6132 Apr 11 22:14 apache24
-rwxr-xr-x 1 root wheel 3070 Apr 7 20:55 garb
-rwxr-xr-x 1 root wheel 1732 Apr 11 22:14 htcacheclean
-rwxr-xr-x 1 root wheel 1212 Apr 15 18:15 php-fpm
-rwxr-xr-x 1 root wheel 986 Apr 7 02:52 rsyncd
All of the db files are still in the /var/db structure.
What's happened and what's the quickest fix so I can get back to work?
Maybe all I need is the file that does into the rc.d? Maybe someone can share theirs?
See, I swear it was running! .
Code:
2022-05-11 10:20:50 0 [Note] InnoDB: Uses event mutexes
2022-05-11 10:20:50 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-05-11 10:20:50 0 [Note] InnoDB: Number of pools: 1
2022-05-11 10:20:50 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-05-11 10:20:50 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
2022-05-11 10:20:50 0 [Note] InnoDB: Completed initialization of buffer pool
2022-05-11 10:20:50 0 [Note] InnoDB: 128 rollback segments are active.
2022-05-11 10:20:50 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-05-11 10:20:50 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-05-11 10:20:50 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-05-11 10:20:50 0 [Note] InnoDB: 10.5.15 started; log sequence number 60409; transaction id 44
2022-05-11 10:20:50 0 [Note] InnoDB: Loading buffer pool(s) from /var/db/mysql/ib_buffer_pool
2022-05-11 10:20:50 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-05-11 10:20:50 0 [Note] InnoDB: Buffer pool(s) load completed at 220511 10:20:50
2022-05-11 10:20:50 0 [Note] Server socket created on IP: '::'.
2022-05-11 10:20:50 0 [Note] Reading of all Master_info entries succeeded
2022-05-11 10:20:50 0 [Note] Added new Master_info '' to hash table
2022-05-11 10:20:50 0 [Note] /usr/local/libexec/mariadbd: ready for connections.
Version: '10.5.15-MariaDB' socket: '/var/run/mysql/mysql.sock' port: 3306 FreeBSD Ports
2022-05-11 11:45:26 0 [Note] /usr/local/libexec/mariadbd (initiated by: unknown): Normal shutdown
2022-05-11 11:45:26 0 [Note] Event Scheduler: Purging the queue. 0 events
2022-05-11 11:45:26 0 [Note] InnoDB: FTS optimize thread exiting.
2022-05-11 11:45:26 0 [Note] InnoDB: Starting shutdown...
2022-05-11 11:45:26 0 [Note] InnoDB: Dumping buffer pool(s) to /var/db/mysql/ib_buffer_pool
2022-05-11 11:45:26 0 [Note] InnoDB: Buffer pool(s) dump completed at 220511 11:45:26
2022-05-11 11:45:26 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-05-11 11:45:26 0 [Note] InnoDB: Shutdown completed; log sequence number 61565; transaction id 49
2022-05-11 11:45:26 0 [Note] /usr/local/libexec/mariadbd: Shutdown complete