[SOLVED]can't connect to database after updating from 0.28 to 0.29
Moderator: Forum Moderators
[SOLVED]can't connect to database after updating from 0.28 to 0.29
Howdy all,
Mythtv used to work fine until versoin 0.28.1.
After upgrading to 0.29.x , it don't work anymore : can't connect to database.
for example if I launch mythtv-setup I have the following errors :
2018-05-17 14:59:04.465768 E DB Error (StorageGroup::StorageGroup()):
Query was:
Driver error was [1/-1]:
Driver not loaded
Database error was:
Driver not loaded
I think it's a QT5 issue .
Some hints :
Mythtv is installed from source
installed :
mariadb-10.2.14
qt5-5.9.5
qt5-webkit-5.9.1
the sql drivers for QT5 are present
in /usr/lib64/qt5/plugins/sqldrivers , i have libqsqlite. so and libqsqlmysql. so
i tried to add this in /etc/ld. so.conf :
/usr/lib64/qt5/
/usr/lib64/qt5/plugins/
/usr/lib64/qt5/plugins/sqldrivers
Nope, that don't work
I would appreciate any help.
Thank you.
Mythtv used to work fine until versoin 0.28.1.
After upgrading to 0.29.x , it don't work anymore : can't connect to database.
for example if I launch mythtv-setup I have the following errors :
2018-05-17 14:59:04.465768 E DB Error (StorageGroup::StorageGroup()):
Query was:
Driver error was [1/-1]:
Driver not loaded
Database error was:
Driver not loaded
I think it's a QT5 issue .
Some hints :
Mythtv is installed from source
installed :
mariadb-10.2.14
qt5-5.9.5
qt5-webkit-5.9.1
the sql drivers for QT5 are present
in /usr/lib64/qt5/plugins/sqldrivers , i have libqsqlite. so and libqsqlmysql. so
i tried to add this in /etc/ld. so.conf :
/usr/lib64/qt5/
/usr/lib64/qt5/plugins/
/usr/lib64/qt5/plugins/sqldrivers
Nope, that don't work
I would appreciate any help.
Thank you.
Last edited by john9393 on Mon May 21, 2018 11:39 pm, edited 3 times in total.
Re: can't connect to database after updating from 0.28 to 0.29
My best shot is this: https://www.mythtv.org/wiki/Build_from_ ... th_Ansible
for the list of packages.
I building/running fine with *buntu 17.10 and this:
for the list of packages.
I building/running fine with *buntu 17.10 and this:
Code: Select all
$ mythutil --version
MythTV Version : v30-Pre-626-ga35421f02d-dirty
MythTV Branch : master
Network Protocol : 91
Library API : 30.20180319-1
QT Version : 5.9.1
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_libcrypto using_libdns_sd using_libfftw3 using_libxml2 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
$ mysql --version
mysql Ver 15.1 Distrib 10.1.30-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2
Re: can't connect to database after updating from 0.28 to 0.29
Thanks you for your answer, bill6502
seeing my mythutil --version 's output and proofreading thoroughly the output of configure ,
I had found up the binding mysql-python is missing
seeing my mythutil --version 's output and proofreading thoroughly the output of configure ,
I had found up the binding mysql-python is missing
Re: [Solved] can't connect to database after updating from 0.28 to 0.29
This topic had been tagged "SOLVED" by moderators , but it is NOT.
I have compiled with python-binding and perl-bindings taken in account and i still have the same error!
here the output of mythui --version:
I have compiled with python-binding and perl-bindings taken in account and i still have the same error!
here the output of mythui --version:
Code: Select all
MythTV Version : v29.1-9b7b962834
MythTV Branch : tag: v29.1
Network Protocol : 91
Library API : 29.20180131-3
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_dvb using_firewire using_frontend using_hdhomerun using_vbox using_ceton using_hdpvr using_ivtv using_joystick_menu 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_bindings_perl using_bindings_python using_bindings_php using_freetype2 using_mythtranscode using_opengl using_vaapi using_vdpau using_ffmpeg_threads using_mheg using_libxml2
Re: can't connect to database after updating from 0.28 to 0.29
Makes sense that python-bindings weren't a solution, misread your earlier
comment to imply success, and figured something else changed too.
I updated to Ubuntu 18.04 yesterday and now have the same version of Qt
as you, and run setup/frontend/backend A-OK. Naturally, I had to rebuild the
whole project 1st. I do run make distclean before major changes like this.
I also do git clean -xfd. Run with -xfdn 1st to be sure they're aren't any things
you'd like to keep. Beyond that, I'm out of ideas. Maybe look for a stale library with:
find . -name "*0\.??\.so\.0\.??" -ls (really shouldn't exist.)
I'd attach the full output of ./configure <allYourSwitches> and mythtv-setup --logpath /tmp --quiet
(where the setup output will be similar to: /tmp/mythtv-setup.20180520173913.6100.log
Maybe others will pick up on something.
comment to imply success, and figured something else changed too.
I updated to Ubuntu 18.04 yesterday and now have the same version of Qt
as you, and run setup/frontend/backend A-OK. Naturally, I had to rebuild the
whole project 1st. I do run make distclean before major changes like this.
I also do git clean -xfd. Run with -xfdn 1st to be sure they're aren't any things
you'd like to keep. Beyond that, I'm out of ideas. Maybe look for a stale library with:
find . -name "*0\.??\.so\.0\.??" -ls (really shouldn't exist.)
I'd attach the full output of ./configure <allYourSwitches> and mythtv-setup --logpath /tmp --quiet
(where the setup output will be similar to: /tmp/mythtv-setup.20180520173913.6100.log
Maybe others will pick up on something.
Code: Select all
$ mythtv-setup --version
MythTV Version : v30-Pre-628-g862e510f58
MythTV Branch : master
Network Protocol : 91
Library API : 30.20180319-1
QT Version : 5.9.5
...
$ ldd /usr/local/bin/mythtv-setup|grep -i sql
libQt5Sql.so.5 => /usr/lib/x86_64-linux-gnu/libQt5Sql.so.5 (0x00007f7d6952a000)
libsqlite3.so.0 => /usr/lib/x86_64-linux-gnu/libsqlite3.so.0 (0x00007f7d5725e000)
$ locate -b '\libqsqlmysql.so'
/usr/lib/x86_64-linux-gnu/qt5/plugins/sqldrivers/libqsqlmysql.so
Re: can't connect to database after updating from 0.28 to 0.29
I was able to produce the same log messages, actually while trying to start mythfrontend.
It happened when I was testing another forum item and switched the <Port> in config.xml
to 3307. In my case the Driver not loaded message looks like a red herring.
Try: diff {~mythtv,~}/.mythtv/config.xml and ls -ld {~mythtv,~}/.mythtv/config.xml
checking for differences and broken links if there are any. Also, /etc/mysql has
different conf.d directories for mysql and mariadb.
It happened when I was testing another forum item and switched the <Port> in config.xml
to 3307. In my case the Driver not loaded message looks like a red herring.
Try: diff {~mythtv,~}/.mythtv/config.xml and ls -ld {~mythtv,~}/.mythtv/config.xml
checking for differences and broken links if there are any. Also, /etc/mysql has
different conf.d directories for mysql and mariadb.
Re: can't connect to database after updating from 0.28 to 0.29
I tried the git version with the same result
here the result of ./configure https://app.box.com/s/0l2593ttlhmcoeut9wrks3yf6fajtxzm
Code: Select all
mythutil --version
Please attach all output as a file in bug reports.
MythTV Version : v30-Pre-628-g862e510f58
MythTV Branch : master
Network Protocol : 91
Library API : 30.20180319-1
QT Version : 5.9.5
ldd /usr/local/bin/mythtv-setup|grep -i sql
libQt5Sql.so.5 => /usr/lib64/libQt5Sql.so.5 (0x00007fa04200d000)
libsqlite3.so.0 => /usr/lib64/libsqlite3.so.0 (0x00007fa0352f3000)
Re: can't connect to database after updating from 0.28 to 0.29
Code: Select all
nmap -p 3306 --reason <yourBackendHostNameOrIP>
# If that works, then:
mythtv-setup --logpath /tmp --quiet -v all,norefcount,nosocket,nogui,nofile,noupnp --loglevel debug
pastebin.com works too.
Just start setup and exit immediately. The file will be about 100 lines long.
Re: [SOLVED]can't connect to database after updating from 0.28 to 0.29
I actually solved,
In fact the starting script of mariadb built by my distrib (slackware) the option "--skip-networking" was set,
removing it, fixed the issue.
in the script there was :
In fact the starting script of mariadb built by my distrib (slackware) the option "--skip-networking" was set,
removing it, fixed the issue.
in the script there was :
Code: Select all
# To allow outside connections to the database comment out the next line.
# If you don't need incoming network connections, then leave the line
# uncommented to improve system security.
#SKIP="--skip-networking"