[Kmymoney] MySQL option does not show up

[Fernando Vilas]

On Sunday, January 22, 2012 12:50:50 Jack wrote:
> On 2012.01.22 12:30, Dr.-Ing. Edgar Alwers wrote:
> > On Sat, 21 Jan 2012 14:53:35 -0600 Fernando Vilas <fvilas at iname.com>
> > 
> > wrote:
> >> KMM asks Qt for a list of drivers installed, and displays everything
> >> found to the user as an option. It should not be a permission issue
> >> within the database itself, either. Is the libqsqlmysql.so library
> >> in the same directory as the rest of the libqsqlxxxx.so drivers? Was
> >> it built for the same version of MySQL and Qt that are installed?
> >> Did you run /sbin/ldconfig after you installed the Qt driver for
> >> MySQL, and before starting KMM?
> > 
> > I built qt-4.7.1 with ./configure ...-plugin-sql-mysql
> > -I/usr/include/mysql \
> > 
> > 			 -plugin-sql-sqlite -I/usr/include \ ....
> > 
> > so both drivers "libqsqlite.so" and  "libqsqlmysql.so" are present in
> > /opt/qt/plugins/sqldrivers/ , I did not compile separate drivers.
> > Later, I built MySQL.
> 
> This is only a guess on my part, but I would think you need to have
> MySql already installed before building the qt MySql drivers.
> 

It could have been built against an old version. I know I had issues with the 
QPSQL driver when I upgraded PostgreSQL several versions ago. It seems to work 
fine, now, though. You could try rebuilding the QMYSQL driver with the new 
MySQL installed. You do not need to rebuild all of Qt, just the database 
driver.

> > I built KMyMoney with the cmake command:
> > CMAKE_PREFIX_PATH=$QT4DIR cmake -DCMAKE_INSTALL_PREFIX=/opt/kde4/
> > --ENABLE_KBANKING=ON ..
> > 
> > Perhaps I have to give an additional parameter indicating the
> > directory of the drivers ? And why is KMM finding the sqllite driver
> > but not the mysql one ? Or is the sqllite driver built in in KMM ?
> 
> 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)"  (I'm on
> Gentoo, so actual locations may be different.)
> 

That was my next guess. There are no database drivers built into KMM, all of 
them are through the QtSQL module. If one is not working, it should be failing 
on all Qt apps. A dependency would be a likely place to look.

-- 
Thanks,
Fernando Vilas
fvilas at iname.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 198 bytes
Desc: This is a digitally signed message part.
URL: <http://mail.kde.org/pipermail/kmymoney/attachments/20120122/1ead0769/attachment.sig>