Database connection error on mac when using 'localhost' instead of '127.0.01' as database configuration host parameter

[Jean-François Brazeau]

I have met a problem with jorani when trying to install it (for evaluation purpose) on my mac. Despite many tries I didn't manage to make the database connection work and didn't get any feedback (log or anything else) that could lead me to understand what was wrong.

I filled a ticket here : https://github.com/bbalet/jorani/issues/159#issuecomment-300763723

Benjamin Ballet gracefully suggested me to use the requirements.php page to give him more information about this issue. Thanks to that tip, I finally managed to make it work as I saw in this page the following error at the top :

Warning: mysqli::mysqli(): (HY000/2002): No such file or directory in /XXX/YYYY/ZZZZ/jorani/requirements.php on line 41

This allowed to google it and quickly find the solution here : http://stackoverflow.com/questions/4219970/warning-mysql-connect-2002-no-such-file-or-directory-trying-to-connect-vi

I only had to change localhost in my configuration by 127.0.0.1 (loopback IP).

I have not spent anymore time to understand why, and I must admit that I am surprised to see that using 127.0.0.1 is not equivalent to localhost (and even more surprised by the error that it raises), but I think that people developping jorani should be aware of this.

Maybe a simple note could be added to the installation documentation at the database configuration chapter : http://jorani.org/how-to-install-jorani.html#14

[Benjamin BALET]

Thank you for the detailled feedback.

It appears that it's a bug of MySQL running on Mac.

--
You received this message because you are subscribed to the Google Groups "jorani" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jorani+unsubscribe@googlegroups.com.
To post to this group, send email to jor...@googlegroups.com.
Visit this group at https://groups.google.com/group/jorani.
To view this discussion on the web visit https://groups.google.com/d/msgid/jorani/9e221951-f181-46ab-b8cd-dab0c0913a97%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.