[Kmymoney] MySQL option does not show up

Jack ostroffjh at sbcglobal.net
Sun Jan 22 20:37:48 UTC 2012


On 2012.01.22 15:20, Dr.-Ing. Edgar Alwers wrote:
> On Sun, 22 Jan 2012 12:50:50 -0500
> Jack <ostroffjh at sbcglobal.net> wrote:
> 
> > It might be interesting to do "ldd libqsqlmysql" to see if is has  
> any
> > links into mysql.  For example, mine includes  
> "libmysqlclient_r.so.16
> > => /usr/lib64/libmysqlclient_r.so.16 (0x00007fa926a73000)"
> 
> ldd libqsqlmysql.so ->
> libmysqlclient_r.so.16 => not found
> 
> and ldd libqsqlite.so ->
> libQtSQl.so.4 => /opt/qt-4.7.1/lib/libQtSql.so.4  ( 0xb77cb000)
> 
> mhmm..., could you help a little with the analysis ?

If nothing else, this means we are probably on the right track.  To me,  
this means that libqsqlmysql.so (the QT MySql driver) is looking for  
libmysqlclient_r.so.16, which is part of MySql, but it can't find it.   
There are several possible reasons for this.

First, see if you can find that file anywhere.  If it is not present on  
your system, then you need to re-install MySql (or perhaps some  
sub-component).  The specific package to install would depend on your  
distribution.

If you do find that file, then you need to determine why ldd is not  
finding it.  First, I would run "ldconfig -p | grep mysql" to see if it  
is on the list.  If it is not, then you should try running "ldconfig"  
(as root) and then try the ldd and/or ldconfig -p again.  If it IS on  
the list, then as Fernando suggested, you should try to rebuild the Qt  
MySql driver.

Instead of getting into more details now, I'll wait to see how the  
first steps of troubleshooting go.

Jack


More information about the KMyMoney mailing list