[mythtv-users] Upgraded database, myth* can't connect

Dale Pontius DEPontius at edgehp.net
Fri Nov 13 23:41:56 UTC 2015


On 11/13/2015 05:52 PM, Hika van den Hoven wrote:
> Hoi Dale,
> 
> Friday, November 13, 2015, 11:21:35 PM, you wrote:
> 
>> This past weekend I finally upgraded my database, and moved from mysql
>> to mariadb.  Now none of the normal myth* programs can connect to it.
> 
>> I can successfully connect at the command line with: "mysql -u mythtv -p
>> -h <name> mythconverg".  On the backend system I can omit the "-h",
>> which I presume means connecting through a Unix socket.  I can connect
>> to loopback, I can connect to the machine by IP.  I can run the command
>> from other machines on my network and connect OK.
> 
>> Also on the backend system, I can run mythconverg_backup.pl and
>> optimize_mythdb.pl.  Plus when I unzip the database backup file, it
>> looks good.
> 
>> I just can't run mythtv-setup or mythbackend.  I get:
>> $ mythbackend
>> QSqlDatabase: QMYSQL driver not loaded
>> QSqlDatabase: available drivers: QSQLITE QMYSQL3 QMYSQL
> 
>> Cannot login to database
> 
>> Would you like to configure the database connection now? [no]
>> 2015-11-13 14:37:40.452353 C  mythbackend version: fixes/0.26 [v0.26.0]
>> www.mythtv.org
>> 2015-11-13 14:37:40.452362 C  Qt version: compile: 4.8.5, runtime: 4.8.5
>> 2015-11-13 14:37:40.452367 N  Enabled verbose msgs:  general
>> 2015-11-13 14:37:40.452375 N  Setting Log Level to LOG_INFO
>> 2015-11-13 14:37:40.452882 I  Added logging to the console
>> 2015-11-13 14:37:40.452940 I  Setup Interrupt handler
>> 2015-11-13 14:37:40.452955 I  Setup Terminated handler
>> 2015-11-13 14:37:40.452964 I  Setup Segmentation fault handler
>> 2015-11-13 14:37:40.452972 I  Setup Aborted handler
>> 2015-11-13 14:37:40.452981 I  Setup Bus error handler
>> 2015-11-13 14:37:40.452987 I  Setup Floating point exception handler
>> 2015-11-13 14:37:40.452996 I  Setup Illegal instruction handler
>> 2015-11-13 14:37:40.453005 I  Setup Real-time signal 0 handler
>> 2015-11-13 14:37:40.453036 N  Using runtime prefix = /usr
>> 2015-11-13 14:37:40.453060 N  Using configuration directory =
>> /home/mythtv/.mythtv
>> 2015-11-13 14:37:40.453125 I  Assumed character encoding: en_US.UTF-8
>> 2015-11-13 14:37:40.453312 I  Using localhost value of localhost
>> 2015-11-13 14:37:40.454324 E  Unable to init db connection.
>> 2015-11-13 14:37:40.454330 E  MSqlDatabase::OpenDatabase(), db object is
>> not valid!
>> 2015-11-13 14:37:40.681354 I  Starting mythlogserver
>> 2015-11-13 14:37:40.681762 I  Starting process manager
>> 2015-11-13 14:37:40.685529 I  Starting IO manager (write)
>> 2015-11-13 14:37:40.685783 I  Starting IO manager (read)
>> 2015-11-13 14:37:40.686091 I  Starting process signal handler
>> 2015-11-13 14:37:40.786510 I  Added logging to mythlogserver at TCP:35327
>> ^C^C
>> $
>> I can run it as root, I can run it as user mythtv, it doesn't matter.
>> I've searched on this topic, and the most common diagnosis seems to be
>> that the user running the command doesn't have access to
>> ~/.mythtv/config.xme, but that's not the case here.
> 
>> There just wasn't that much changed, this worked before the database
>> upgrade, and the database itself looks good.
> 
>> Thanks for any suggestions,
>> Dale Pontius
>> _______________________________________________
> 
> 
> I guess qt and maria are not properly linked. Here on Gentoo I simply
> would rebuild qtsql, but you might need a qt package linked against
> mariadb?
> 
I've rebuilt qtsql already, but I suppose I should go to town with ldd
and find out if I need to rebuild anything else.  I had a little bit of
a go-around with UTF-8 (and of course utf-8, which isn't the same thing)
and have done numerous rebuilds, but maybe I just need to do it again.
I should be able to walk through things with ldd and see.

We'll see.
Dale



More information about the mythtv-users mailing list