Sunday, August 25, 2024

Re: MariaDB install any different for OpenBSD 7.5 than 6.4?

After a cursory reading, it looks OK.  But don't forget to read the  supplied documentation, after installing the package:        less /usr/local/share/doc/pkg-readmes/mariadb-server    Also, most of those steps don't have to do with mariadb, but with simple  system administration.  Installing the package, starting and stopping  services, and checking if processes are running and ports are open are  all tasks you should be familiar with.

All good to this point, thanks.

Now I'm reading this in

/usr/local/share/doc/pkg-readmes/mariadb-server

Given that lighttpd runs in chroot am I correct that I need to run the following

install and then edit /etc/my.cnf for things to play nicely together?

Thanks,

David

--------------------------------------------------------------------------------------------------------------------

chrooted daemons and MariaDB socket
===================================

For external program running under a chroot(8) to be able to access the
MariaDB server without using a network connection, the socket must be
placed inside the chroot.

e.g. httpd(8) or nginx(8): connecting to MariaDB from PHP
---------------------------------------------------------
Create a directory for the MariaDB socket:

    # install -d -m 0711 -o _mysql -g _mysql /var/www/var/run/mysql

Adjust /etc/my.cnf to use the socket in the chroot - this
applies to both client and server processes:

    [client-server]
    socket = /var/www/var/run/mysql/mysql.sock

No comments:

Post a Comment