[Solved] Can't Connection to DB (mythtv not linking to libQt5Sql)
Posted: Thu Dec 27, 2018 4:49 am
This has been driving me nuts and i'm at a loss, so any clues wouldn't be greatly appreciated.
The problem is that i cannot connect to the DB. This problem seems similar to the post entitled "can't connect to database after updating from 0.28 to 0.29" (i can't seem to link directly to the post), but i don't think it is the same solution.
If i run mythtv-setup.real, i see the following error message:
I can connect to the DB via mysql command line client (so the the DB is running).
I even wrote a sample QT program to test that the QT5 MySql driver was installed, and the following QT Sql Drivers appear to be installed QMYSQL being one of them.
When i check the libraries used for the mythtv executables, only sqlite appears. I'd expect to see libQt5Sql.
Reference Info for my system:
The problem is that i cannot connect to the DB. This problem seems similar to the post entitled "can't connect to database after updating from 0.28 to 0.29" (i can't seem to link directly to the post), but i don't think it is the same solution.
If i run mythtv-setup.real, i see the following error message:
Code: Select all
2018-12-26 23:20:25.673000 E DB Error (StorageGroup::StorageGroup()):
Query was:
Driver error was [1/-1]:
Driver not loaded
Database error was:
Driver not loaded
Code: Select all
mythtv@myth ~ % mysql -N --host=localhost --user=mythtv --password=pass mythconverg '--execute=SELECT * FROM settings LIMIT 1;'
+------------------------------+----------------------+------+
| mythfilldatabaseLastRunStart | 2018-12-17T18:53:11Z | NULL |
+------------------------------+----------------------+------+
mythtv@myth ~ % mysql -N --host=192.168.1.3 --user=mythtv --password=pass mythconverg '--execute=SELECT * FROM settings LIMIT 1;'
+------------------------------+----------------------+------+
| mythfilldatabaseLastRunStart | 2018-12-17T18:53:11Z | NULL |
+------------------------------+----------------------+------+
Code: Select all
QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3
Code: Select all
mythtv@myth ~ % ldd =mythtv-setup.real|grep sql
libsqlite3 => /usr/lib/x86_64-linux-gnu/libsqlite3 (0x00007f1563fe2000)
mythtv@myth ~ % ldd =mythfrontend.real|grep sql
libsqlite3 => /usr/lib/x86_64-linux-gnu/libsqlite3 (0x00007fa0ce400000)
Reference Info for my system:
Code: Select all
mythbuntu 18.04
Code: Select all
mariaDB: 10.2
Code: Select all
mythtv@myth ~ % mythutil --version
Please attach all output as a file in bug reports.
MythTV Version : v29.1
MythTV Branch :
Network Protocol : 91
Library API : 29.20180316-1
QT Version : 5.9.5
Options compiled in:
linux profile use_hidesyms using_alsa using_oss using_pulse using_pulseoutput using_backend using_bindings_perl using_bindings_python using_bindings_php using_crystalhd using_dvb using_firewire using_frontend using_hdhomerun using_vbox using_ceton using_hdpvr using_ivtv using_joystick_menu using_libcec using_libcrypto using_libdns_sd using_libfftw3 using_libxml2 using_lirc using_mheg using_opengl using_opengl_video using_opengl_themepainter using_qtwebkit using_qtscript using_qtdbus using_taglib using_v4l2 using_x11 using_xrandr using_xv using_profiletype using_systemd_notify using_systemd_journal using_bindings_perl using_bindings_python using_bindings_php using_freetype2 using_mythtranscode using_opengl using_vaapi using_vdpau using_ffmpeg_threads using_mheg using_libass using_libxml2 using_libmp3lame