W dniu 08.05.2019 o 08:06, Marc Chamberlin pisze:
Ha! I am going to surprise the reader because I already know of a temporary solution to get phpMyAdmin to work, and I know that it is going to be part of the real solution, however it is going to get resolved. I just don't grok how to report it (it is a bug), I don't know what package has the responsibility for this issue, (phpMyAdmin or Mariadb) and the solution I have only works until the computer is rebooted. So I am going to need some real guidance here from a guru...
In a nutshell, as currently packaged, phpMyAdmin will NOT come up and work on OpenSuSE Leap 15.0, out of the box, as described in so many LAMP articles posted around the internet, including the ones posted by/for OpenSuSE Leap 15.0. When MariaDB/MySQL is installed, it sets up a bunch of stuff, including an all important socket in the directory /var/lib/mysql. However, by default, phpMyAdmin appears to be expecting this stuff to be installed at /var/run/mysql. /var/run is a temporary directory that gets reconstructed each time the system is booted up. I can "fix" this by creating a link i.e. - ln -s /var/lib/mysql /var/run/mysql but this is only a temporary solution and gets wiped out on reboot. (I am still looking for a possible means of configuring phpMyAdmin with the knowledge it needs to find the MariaDB stuff.)
And for the curious, if one tries to bring up phpMyAdmin without this link, one is going to get an absolutely horrid error message that has people all over the internet scratching around looking for a solution. The error is - "mysqli_real_connect(): (HY000/2002): No such file or directory" Yeah I have seen bad error messages before but the guy who came up with this dozy needs to be shot and retired from the software development game! And for a real brain twist take a look at the solutions/suggestions people are coming up with, that often do not work at all. In my case it took a hell of a lot of detective work to get as far as I have, but at least I found the &*$#&! problem!
Now all I need is a good persistent solution and perhaps help with getting it reported in a way that the developers will comprehend. I vaguely remember coming up with a way to create a persistent directory in /var/run a couple years ago but not sure what I did nor if it is applicable to creating a persistent link instead.
Thanks in advance for help and ideas... Marc... (sorry for the colorful remarks, it is LATE at night and I am tired!)
I think it's a bug in phpMyAdmin package. It should be patched to have correct path to mysql socket.