LawsHosting
Verified User
It seems that my MySQL socket is in /usr/local/mysql/data/, which is symlink'd to /home/mysql/.... Not sure if I changed it or what.
However, a client tried to install DADAMail via Installatron, it kept failing. Initially thought it was an Apache +ExecCGI issue, but it turned out it wasn't.
So, I decided to try to manually install it and the results seem to point to the mysql.sock file. It appears that DBI::mysql wants the mysql.sock in /tmp/ (eg. https://stackoverflow.com/questions/1957916/how-do-i-tell-dbdmysql-where-mysql-sock-is )
I created a symlink from /tmp/ to /usr/local/mysql/data/, but the database test in DADA's manual installer still fails (see attached screenshot).
I even tried changing the socket location to /tmp/ but then PHP panicked and couldn't find it (mysql.default_socket / mysqli.default_socket are blank in the php.ini's). I shouldn't need to edit these, right (eg. If empty, uses the built-in MySQL defaults)?
Furthermore, systemd's mysqld.service has the --socket= argument in, so it overrides the my.cnf one. I thought I was going mad when the socket didn't move.
However, a client tried to install DADAMail via Installatron, it kept failing. Initially thought it was an Apache +ExecCGI issue, but it turned out it wasn't.
So, I decided to try to manually install it and the results seem to point to the mysql.sock file. It appears that DBI::mysql wants the mysql.sock in /tmp/ (eg. https://stackoverflow.com/questions/1957916/how-do-i-tell-dbdmysql-where-mysql-sock-is )
I created a symlink from /tmp/ to /usr/local/mysql/data/, but the database test in DADA's manual installer still fails (see attached screenshot).
I even tried changing the socket location to /tmp/ but then PHP panicked and couldn't find it (mysql.default_socket / mysqli.default_socket are blank in the php.ini's). I shouldn't need to edit these, right (eg. If empty, uses the built-in MySQL defaults)?
Furthermore, systemd's mysqld.service has the --socket= argument in, so it overrides the my.cnf one. I thought I was going mad when the socket didn't move.
Attachments
Last edited: