<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
I was very excited when Lawrence Rust published the instructions to
install a mythtv frontend on the rPi2 and immediately ordered one to
play with. This lead to several days of frustration when the
frontend couldn't connect to the backend database. I am posting the
solution here in case others find themselves in the same situation.<br>
<br>
Background:<br>
<br>
1. Installed Raspbian Wheezy image from <a
href="https://downloads.raspberrypi.org/raspbian/images/raspbian-2015-05-07/2015-05-05-raspbian-wheezy.zip"><a class="moz-txt-link-freetext" href="https://downloads.raspberrypi.org/raspbian/images/raspbian-2015-05-07/2015-05-05-raspbian-wheezy.zip">https://downloads.raspberrypi.org/raspbian/images/raspbian-2015-05-07/2015-05-05-raspbian-wheezy.zip</a></a><br>
2. Upgraded installed packages with sudo apt-get update and sudo
apt-get dist-upgrade<br>
3. Installed the pre-built frontend archive and dependencies
following Lawrence's instructions <a
href="http://www.softsystem.co.uk/download/mythtv/mythtv_for_rpi.txt">here</a>.
<br>
<br>
Problem:<br>
<br>
The frontend could not connect to the database and gave the
following error 'CoreContext mythdbcon.cpp:80 (MSqlDatabase) -
Unable to init db connection.'<br>
I double checked the database settings in config.xml and also
confirmed that I could manually connect to the database from the rPi
using these settings. I was totally stumped.<br>
<br>
Solution:<br>
<br>
In desperation, I finally enlisted the help of my son, Tim, who
suggested running the frontend via strace to see what system calls
were being initiated and this revealed that the frontend was
unsuccessfully searching for libmysqlclient.so.18 which was not
present on my system. I only had libmysqlclient.so.16 installed.<br>
<br>
In the end the solution was simply - sudo apt-get install
libmysqlclient18 <br>
<br>
Many thanks to Lawrence for all the work he has put into producing a
fronted for the rPi. It works great.<br>
<br>
Greg<br>
</body>
</html>