[gentoo-user] OT - MythTV won't connect to my database!

[gentoo-user] OT - MythTV won't connect to my database!

[Michael Sullivan]

I've ensured that mysql is indeed running, but when I try to run
mythfrontend, I get this:

michael@camille ~ $ mythfrontend
2006-06-17 16:09:09.260 Using runtime prefix = /usr
2006-06-17 16:09:09.320 XScreenSaver support enabled
2006-06-17 16:09:09.359 New DB connection, total: 1
2006-06-17 16:09:09.442 Unable to connect to database!
2006-06-17 16:09:09.442 Driver error was [1/2003]:
QMYSQL3: Unable to connect
Database error was:
Can't connect to MySQL server on 'camille' (111)

QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2006-06-17 16:09:09.554 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-06-17 16:09:09.672 Unable to connect to database!
2006-06-17 16:09:09.672 Driver error was [1/2003]:
QMYSQL3: Unable to connect
Database error was:
Can't connect to MySQL server on 'camille' (111)

QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2006-06-17 16:09:09.826 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-06-17 16:09:09.882 Database not open while trying to load setting:
GuiVidModeResolution
2006-06-17 16:09:10.056 Unable to connect to database!
2006-06-17 16:09:10.056 Driver error was [1/2003]:
QMYSQL3: Unable to connect
Database error was:
Can't connect to MySQL server on 'camille' (111)

QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2006-06-17 16:09:10.298 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-06-17 16:09:10.354 Database not open while trying to load setting:
GuiVidModeWidth
2006-06-17 16:09:10.576 Unable to connect to database!
2006-06-17 16:09:10.576 Driver error was [1/2003]:
QMYSQL3: Unable to connect
Database error was:
Can't connect to MySQL server on 'camille' (111)

QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2006-06-17 16:09:10.926 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-06-17 16:09:10.982 Database not open while trying to load setting:
GuiVidModeHeight
2006-06-17 16:09:11.390 Unable to connect to database!
2006-06-17 16:09:11.390 Driver error was [1/2003]:
QMYSQL3: Unable to connect
Database error was:
Can't connect to MySQL server on 'camille' (111)

QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2006-06-17 16:09:11.834 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-06-17 16:09:11.890 Database not open while trying to load setting:
DisplaySizeResolution
2006-06-17 16:09:12.295 Unable to connect to database!
2006-06-17 16:09:12.295 Driver error was [1/2003]:
QMYSQL3: Unable to connect
Database error was:
Can't connect to MySQL server on 'camille' (111)

QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2006-06-17 16:09:12.750 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-06-17 16:09:12.806 Database not open while trying to load setting:
DisplaySizeWidth
2006-06-17 16:09:13.163 Unable to connect to database!
2006-06-17 16:09:13.163 Driver error was [1/2003]:
QMYSQL3: Unable to connect
Database error was:
Can't connect to MySQL server on 'camille' (111)

Why isn't the frontend connecting to my database?

-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] OT - MythTV won't connect to my database!

[Alan]

On Sat, Jun 17, 2006 at 04:10:30PM -0500, Michael Sullivan wrote:
> I've ensured that mysql is indeed running, but when I try to run
> mythfrontend, I get this:
> 
> michael@camille ~ $ mythfrontend
> 2006-06-17 16:09:09.260 Using runtime prefix = /usr
> 2006-06-17 16:09:09.320 XScreenSaver support enabled
> 2006-06-17 16:09:09.359 New DB connection, total: 1
> 2006-06-17 16:09:09.442 Unable to connect to database!
> 2006-06-17 16:09:09.442 Driver error was [1/2003]:
> QMYSQL3: Unable to connect
> Database error was:
> Can't connect to MySQL server on 'camille' (111)

I'm assuming that 'camille' is a separate computer?  Can you connect
with 
$ mysql -u username -ppassword -h camille dbname

?

-- 
Alan <alan@ufies.org> - http://arcterex.net
--------------------------------------------------------------------
"Backups are for people who don't pray."                 -- big Mike
-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] OT - MythTV won't connect to my database!

[Alan]

Alternatively if camille is the local server, try setting the database
hostname in the mythtv set up to localhost instead.

-- 
Alan <alan@ufies.org> - http://arcterex.net
--------------------------------------------------------------------
"Backups are for people who don't pray."                 -- big Mike
-- 
gentoo-user@gentoo.org mailing list

OT - Can't watch Live TV! (WAS: Re: [gentoo-user] OT - MythTV won't connect to my database!)

[Michael Sullivan]

On Sat, 2006-06-17 at 19:22 -0700, Alan wrote:
> Alternatively if camille is the local server, try setting the database
> hostname in the mythtv set up to localhost instead.
> 
> -- 
> Alan <alan@ufies.org> - http://arcterex.net
> --------------------------------------------------------------------
> "Backups are for people who don't pray."                 -- big Mike

I figured out how to get mythfrontend to connect to the database.  I did
what you said and changed "camille" to "localhost".  Now I have a new
problem; I can't watch LiveTV.  I'm not sure why.  If I go to Schedule
Recordings I see what I expected to see.  When I go to Watch LiveTV, I
get some funky output in my terminal.  Here's the important info:

camille mythtv # uname -a
Linux camille 2.6.15-gentoo-r1 #1 SMP Thu Jun 15 16:50:26 CDT 2006 i686
Intel(R) Celeron(R) CPU 2.66GHz GNU/Linux

camille mythtv # lspci -v
.
.
.
05:00.0 Multimedia video controller: Internext Compression Inc iTVC16
(CX23416) MPEG-2 Encoder (rev 01)
        Subsystem: Hauppauge computer works Inc. WinTV PVR 250
        Flags: bus master, medium devsel, latency 64, IRQ 22
        Memory at d0000000 (32-bit, prefetchable) [size=64M]
        Capabilities: [44] Power Management version 2
.
.
.

camille mythtv # dmesg | grep 'ivtv'
ivtv:  ==================== START INIT IVTV ====================
ivtv:  version 0.4.5 (tagged release) loading
ivtv:  Linux version: 2.6.15-gentoo-r1 SMP 486 gcc-3.4
ivtv:  In case of problems please include the debug info between
ivtv:  the START INIT IVTV and END INIT IVTV lines, along with
ivtv:  any module options, when mailing the ivtv-users mailinglist.
ivtv0: Autodetected WinTV PVR 250 card (cx23416 based)
ivtv0: Unreasonably low latency timer, setting to 64 (was 32)
ivtv0: i2c attach to card #0 ok [client=tveeprom, addr=50]
tuner 0-0061: chip found @ 0xc2 (ivtv i2c driver #0)
ivtv0: i2c attach to card #0 ok [client=(tuner unset), addr=61]
saa7115 0-0021: saa7115 found @ 0x42 (ivtv i2c driver #0)
ivtv0: i2c attach to card #0 ok [client=saa7115, addr=21]
ivtv0: i2c attach to card #0 ok [client=MSP4448G-A2, addr=40]
tda9887 0-0043: chip found @ 0x86 (ivtv i2c driver #0)
ivtv0: i2c attach to card #0 ok [client=tda9887, addr=43]
ivtv0: loaded v4l-cx2341x-enc.fw firmware (262144 bytes)
ivtv0: Encoder revision: 0x02050032
ivtv0: Allocate DMA encoder MPEG stream: 128 x 32768 buffers (4096KB
total)
ivtv0: Allocate DMA encoder YUV stream: 194 x 10800 buffers (2048KB
total)
ivtv0: Allocate DMA encoder VBI stream: 120 x 17472 buffers (2048KB
total)
ivtv0: Allocate DMA encoder PCM audio stream: 455 x 4608 buffers (2048KB
total)
ivtv0: Create encoder radio stream
ivtv0: Initialized WinTV PVR 250, card #0
ivtv:  ====================  END INIT IVTV  ====================
ivtv0: All encoder MPEG stream buffers are full. Dropping data.
ivtv0: Cause: the application is not reading fast enough.
ivtv0: All encoder MPEG stream buffers are full. Dropping data.
ivtv0: Cause: the application is not reading fast enough.
camille mythtv #


michael@camille ~ $ mythfrontend
2006-06-17 21:45:31.805 Using runtime prefix = /usr
2006-06-17 21:45:31.827 XScreenSaver support enabled
2006-06-17 21:45:31.909 New DB connection, total: 1
2006-06-17 21:45:31.947 Connected to database 'mythconverg' at host:
localhost
2006-06-17 21:45:31.950 Total desktop dim: 1024x768, with 1 screen[s].
2006-06-17 21:45:31.964 Using screen 0, 1024x768 at 0,0
2006-06-17 21:45:31.972 Current Schema Version: 1123
2006-06-17 21:45:31.972 mythfrontend version: 0.19.20060121-2
www.mythtv.org
2006-06-17 21:45:31.973 Enabled verbose msgs:  important general
2006-06-17 21:45:32.158 lang0: eng
2006-06-17 21:45:32.158 lang: eng
2006-06-17 21:45:32.192 lang1: eng
2006-06-17 21:45:32.193 lang: eng
2006-06-17 21:45:32.310 Total desktop dim: 1024x768, with 1 screen[s].
2006-06-17 21:45:32.313 Using screen 0, 1024x768 at 0,0
2006-06-17 21:45:32.323 Switching to square mode (G.A.N.T.)
mythtv: could not connect to socket
mythtv: No such file or directory
lirc_init failed for mythtv, see preceding messages
2006-06-17 21:45:32.756 Joystick disabled.
2006-06-17 21:45:32.849 Registering Internal as a media playback plugin.
2006-06-17 21:45:37.001 New DB connection, total: 2
2006-06-17 21:45:37.002 Connected to database 'mythconverg' at host:
localhost
2006-06-17 21:45:37.052 Connecting to backend server: 192.168.1.3:6543
(try 1 of 5)
2006-06-17 21:45:57.058 ReadStringList timeout (quick).
2006-06-17 21:45:57.059 Unexpected response to MYTH_PROTO_VERSION:
2006-06-17 21:45:57.071 TV: Attempting to change from None to None
^C
michael@camille ~ $


Can anyone help me make sense of this output?


-- 
gentoo-user@gentoo.org mailing list