OpenBSD Nginx/PHP/MariaDB/PHP-FPM Stack

Question

I have a minimal OpenBSD 5.7 amd64 install in VMware where I have installed matching versions of PHP and PHP-FPM, plus nginx, and mariadb using pkg_add. I configure all the services, and get nginx to parse HTML through PHP-FPM, and everything is fine, until I try to connect to MariaDB. It does not connect to MySQL/MariaDB. I have tried three different PHP CMSes using correct credentials, and each gives the following error:

Warning: mysql_connect(): Can't connect to local MySQL server through socket Warning: mysql_connect(): Can't connect to local MySQL server through socket /var/run/mysql/mysql.sock (62 "Too many levels of symbolic links") in /htdocs/index.php on line 5

This is after doing ths

mkdir -p /var/www/var/run/
ln -s /var/run/mysql /var/www/var/run/mysql

What in the world is the problem here? I have tried four different tutorials, and I just simply cannot get PHP and MySQL to work with each other. Even though I am certain MySQL is running, and I can use mysql -p -u ... to connect just fine to the server.

Please help.

EDIT:

# ls -al /var/run/mysql /var/www/var/run/mysql
lrwxr-xr-x  1 root  daemon  14 May  5 11:07 /var/www/var/run/mysql -> /var/run/mysql

/var/run/mysql:
total 8
drwx--x--x  2 _mysql  _mysql  512 May  5 11:01 .
drwxr-xr-x  4 root    wheel   512 May  5 11:06 ..
srwxrwxrwx  1 _mysql  _mysql    0 May  5 11:01 mysql.sock
#

Show `ls -al /var/run/mysql /var/www/var/run/mysql` ... – Fox May 05 '15 at 16:21 — Fox, May 05 '15 at 16:21
Done adding the result of `ls -al ...` – David May 05 '15 at 16:32 — David, May 05 '15 at 16:32

score 4 · Accepted Answer · answered May 05 '15 at 18:24

Your /var/www/var/run/mysql points to /var/run/mysql. By the directory structure I presume, you are chrooting your apache/php into /var/www. It probably is a default of OpenBSD.

When chrooted into /var/www your link actually becomes /var/run/mysql -> /var/run/mysql, which is pretty much infinite loop.

You either need to provide socket inside that chroot, using socket configuration option, or use TCP connections.

Edit: Just by the way, if you are not used to working with OpenBSD, you probably should not use that for production. You probably won't get any more secure than with a system/distro you know well.

score -1 · Answer 2 · edited May 25 '15 at 08:43

-1

I have a similar problem. When doing a netstat -an |grep 3306, it returns

tcp6         0      0  *.3306                 *.*                    LISTEN

Setting localhost to "::1" in the php script sort of 'solves' the problem. Seems strange but might be a hint for you.

edited May 25 '15 at 08:43

masegaloeh

18,236
10
57
106

answered May 25 '15 at 07:05

ole

1

This has absolutely nothing to do with the question. – Michael Hampton May 25 '15 at 13:23

OpenBSD Nginx/PHP/MariaDB/PHP-FPM Stack

2 Answers2