mysql and mythtv
in [Suse]
|
Prev: Intel 945
Next: PAR2 question
From: Wodan Wodanson on 23 Nov 2005 14:04 Hello, After many frustrating hours of fiddling I've managed to install all packages needed for MythTV (ver mythtv-frontend-0.18.2-13SVN20051013.i586) (at least I think so). I've managed to set up IVTV and I'm now able to watch tv in MPlayer with sound. I've followed the instructions from http://blog.eleith.com/eblog/?uid1=464&eblog1=1#5.3. However, when I get to "mysqladmin -u mythtv -password mythtv" this command does not work. I've used "mysql_setpermission" to change the password for user mythtv to mythtv. However, I'm not sure this is working as I want to. Anyways, every time I start "mythtv-setup" I get an error that "myth could not connect to the database" (after the mythtv window has opened). I'm sure my problem lies in mysql and how to successfully set up the needed account for mythtv. I've got the "qt3-mysql.3.3.5-19" installed. Any suggestions (step by step, would be preferred) how to solve this problem would be much appreciated. My system is AMD 3500+ 64 BIT Open Suse 10.0 (x86_64) PVR-150 I've pasted the output from trying to run "mythtv-setup" below. Thanks QSqlDatabase: QMYSQL3 driver not loaded QSqlDatabase: available drivers: 2005-11-23 13:48:51.440 New DB connection, total: 1 2005-11-23 13:48:51.441 Unable to connect to database! 2005-11-23 13:48:51.441 No error type from QSqlError? Strange... 2005-11-23 13:48:51.442 Unable to connect to database! 2005-11-23 13:48:51.442 No error type from QSqlError? Strange... 2005-11-23 13:48:51.442 Database not open while trying to load setting: GuiVidModeResolution 2005-11-23 13:48:51.442 Unable to connect to database! 2005-11-23 13:48:51.442 No error type from QSqlError? Strange... 2005-11-23 13:48:51.443 Database not open while trying to load setting: GuiVidModeWidth 2005-11-23 13:48:51.443 Unable to connect to database! 2005-11-23 13:48:51.443 No error type from QSqlError? Strange... 2005-11-23 13:48:51.443 Database not open while trying to load setting: GuiVidModeHeight 2005-11-23 13:48:51.445 Unable to connect to database! 2005-11-23 13:48:51.445 No error type from QSqlError? Strange... 2005-11-23 13:48:51.445 Database not open while trying to load setting: DisplaySizeResolution 2005-11-23 13:48:51.445 Unable to connect to database! 2005-11-23 13:48:51.446 No error type from QSqlError? Strange... 2005-11-23 13:48:51.446 Database not open while trying to load setting: DisplaySizeWidth 2005-11-23 13:48:51.446 Unable to connect to database! 2005-11-23 13:48:51.446 No error type from QSqlError? Strange... 2005-11-23 13:48:51.446 Database not open while trying to load setting: DisplaySizeHeight 2005-11-23 13:48:51.447 Unable to connect to database! 2005-11-23 13:48:51.447 No error type from QSqlError? Strange... 2005-11-23 13:48:51.447 Database not open while trying to load setting: TVVidModeResolution 2005-11-23 13:48:51.447 Unable to connect to database! 2005-11-23 13:48:51.447 No error type from QSqlError? Strange... 2005-11-23 13:48:51.448 Database not open while trying to load setting: TVVidModeWidth 2005-11-23 13:48:51.448 Unable to connect to database! 2005-11-23 13:48:51.448 No error type from QSqlError? Strange... 2005-11-23 13:48:51.448 Database not open while trying to load setting: TVVidModeHeight 2005-11-23 13:48:51.448 Unable to connect to database! 2005-11-23 13:48:51.449 No error type from QSqlError? Strange... 2005-11-23 13:48:51.449 Database not open while trying to load setting: VidModeResolution0 2005-11-23 13:48:51.449 Unable to connect to database! 2005-11-23 13:48:51.449 No error type from QSqlError? Strange... 2005-11-23 13:48:51.449 Database not open while trying to load setting: VidModeWidth0 2005-11-23 13:48:51.450 Unable to connect to database! 2005-11-23 13:48:51.450 No error type from QSqlError? Strange... 2005-11-23 13:48:51.450 Database not open while trying to load setting: VidModeHeight0 2005-11-23 13:48:51.450 Unable to connect to database! 2005-11-23 13:48:51.450 No error type from QSqlError? Strange... 2005-11-23 13:48:51.451 Database not open while trying to load setting: TVVidModeResolution0 2005-11-23 13:48:51.451 Unable to connect to database! 2005-11-23 13:48:51.451 No error type from QSqlError? Strange... 2005-11-23 13:48:51.451 Database not open while trying to load setting: TVVidModeWidth0 2005-11-23 13:48:51.451 Unable to connect to database! 2005-11-23 13:48:51.452 No error type from QSqlError? Strange... 2005-11-23 13:48:51.452 Database not open while trying to load setting: TVVidModeHeight0 2005-11-23 13:48:51.454 Unable to connect to database! 2005-11-23 13:48:51.454 No error type from QSqlError? Strange... 2005-11-23 13:48:51.454 Database not open while trying to load setting: UseVideoModes Total desktop width=1280, height=1024, numscreens=1 2005-11-23 13:48:51.455 Unable to connect to database! 2005-11-23 13:48:51.455 No error type from QSqlError? Strange... 2005-11-23 13:48:51.455 Database not open while trying to load setting: XineramaScreen 2005-11-23 13:48:51.455 Unable to connect to database! 2005-11-23 13:48:51.455 No error type from QSqlError? Strange... 2005-11-23 13:48:51.456 Database not open while trying to load setting: RunFrontendInWindow 2005-11-23 13:48:51.456 Using screen 0, 1280x1024 at 0,0 2005-11-23 13:48:51.456 Unable to connect to database! 2005-11-23 13:48:51.456 No error type from QSqlError? Strange... 2005-11-23 13:48:51.456 Database not open while trying to load setting: Style 2005-11-23 13:48:51.457 Unable to connect to database! 2005-11-23 13:48:51.457 No error type from QSqlError? Strange... 2005-11-23 13:48:51.457 Database not open while trying to load setting: Theme 2005-11-23 13:48:51.457 Switching to square mode (blue) 2005-11-23 13:48:51.457 Unable to connect to database! 2005-11-23 13:48:51.458 No error type from QSqlError? Strange... 2005-11-23 13:48:51.458 Database not open while trying to load setting: GuiOffsetX 2005-11-23 13:48:51.458 Unable to connect to database! 2005-11-23 13:48:51.458 No error type from QSqlError? Strange... 2005-11-23 13:48:51.458 Database not open while trying to load setting: GuiOffsetY 2005-11-23 13:48:51.459 Unable to connect to database! 2005-11-23 13:48:51.459 No error type from QSqlError? Strange... 2005-11-23 13:48:51.459 Database not open while trying to load setting: GuiResolution 2005-11-23 13:48:51.459 Unable to connect to database! 2005-11-23 13:48:51.459 No error type from QSqlError? Strange... 2005-11-23 13:48:51.460 Database not open while trying to load setting: GuiWidth 2005-11-23 13:48:51.460 Unable to connect to database! 2005-11-23 13:48:51.460 No error type from QSqlError? Strange... 2005-11-23 13:48:51.460 Database not open while trying to load setting: GuiHeight 2005-11-23 13:48:51.461 Unable to connect to database! 2005-11-23 13:48:51.461 No error type from QSqlError? Strange... 2005-11-23 13:48:51.461 Database not open while trying to load setting: MenuTheme 2005-11-23 13:48:51.461 Unable to connect to database! 2005-11-23 13:48:51.462 No error type from QSqlError? Strange... 2005-11-23 13:48:51.463 Database not open while trying to load setting: QtFontBig 2005-11-23 13:48:51.463 Unable to connect to database! 2005-11-23 13:48:51.463 No error type from QSqlError? Strange... 2005-11-23 13:48:51.463 Database not open while trying to load setting: QtFontMedium 2005-11-23 13:48:51.464 Unable to connect to database! 2005-11-23 13:48:51.464 No error type from QSqlError? Strange... 2005-11-23 13:48:51.464 Database not open while trying to load setting: QtFontSmall 2005-11-23 13:48:51.486 Unable to connect to database! 2005-11-23 13:48:51.487 No error type from QSqlError? Strange... 2005-11-23 13:48:51.487 Database not open while trying to load setting: HideMouseCursor 2005-11-23 13:48:51.489 Unable to connect to database! 2005-11-23 13:48:51.489 No error type from QSqlError? Strange... 2005-11-23 13:48:51.490 Database not open while trying to load setting: RunFrontendInWindow 2005-11-23 13:48:52.142 Unable to connect to database! 2005-11-23 13:48:52.143 No error type from QSqlError? Strange... 2005-11-23 13:48:52.143 Unable to connect to database! 2005-11-23 13:48:52.143 No error type from QSqlError? Strange... 2005-11-23 13:48:52.144 Unable to connect to database! 2005-11-23 13:48:52.144 No error type from QSqlError? Strange... 2005-11-23 13:48:52.144 Unable to connect to database! 2005-11-23 13:48:52.144 No error type from QSqlError? Strange... 2005-11-23 13:48:52.145 Unable to connect to database! 2005-11-23 13:48:52.145 No error type from QSqlError? Strange... 2005-11-23 13:48:52.145 Unable to connect to database! 2005-11-23 13:48:52.145 No error type from QSqlError? Strange... 2005-11-23 13:48:52.145 Unable to connect to database! 2005-11-23 13:48:52.145 No error type from QSqlError? Strange... 2005-11-23 13:48:52.146 Unable to connect to database! 2005-11-23 13:48:52.146 No error type from QSqlError? Strange... 2005-11-23 13:48:52.146 Unable to connect to database! 2005-11-23 13:48:52.146 No error type from QSqlError? Strange... 2005-11-23 13:48:52.147 Unable to connect to database! 2005-11-23 13:48:52.147 No error type from QSqlError? Strange... 2005-11-23 13:48:52.147 Unable to connect to database! 2005-11-23 13:48:52.147 No error type from QSqlError? Strange... 2005-11-23 13:48:52.147 Unable to connect to database! 2005-11-23 13:48:52.148 No error type from QSqlError? Strange... 2005-11-23 13:48:52.148 Unable to connect to database! 2005-11-23 13:48:52.148 No error type from QSqlError? Strange... 2005-11-23 13:48:52.148 Unable to connect to database! 2005-11-23 13:48:52.148 No error type from QSqlError? Strange... 2005-11-23 13:48:52.149 Unable to connect to database! 2005-11-23 13:48:52.149 No error type from QSqlError? Strange... 2005-11-23 13:48:52.149 Unable to connect to database! 2005-11-23 13:48:52.149 No error type from QSqlError? Strange... 2005-11-23 13:48:52.149 Unable to connect to database! 2005-11-23 13:48:52.150 No error type from QSqlError? Strange... 2005-11-23 13:48:52.150 Unable to connect to database! 2005-11-23 13:48:52.150 No error type from QSqlError? Strange... 2005-11-23 13:48:52.151 Unable to connect to database! 2005-11-23 13:48:52.151 No error type from QSqlError? Strange... 2005-11-23 13:48:52.151 Unable to connect to database! 2005-11-23 13:48:52.151 No error type from QSqlError? Strange... 2005-11-23 13:48:52.151 Unable to connect to database! 2005-11-23 13:48:52.152 No error type from QSqlError? Strange... 2005-11-23 13:48:52.152 Unable to connect to database! 2005-11-23 13:48:52.152 No error type from QSqlError? Strange... 2005-11-23 13:48:52.152 Unable to connect to database! 2005-11-23 13:48:52.152 No error type from QSqlError? Strange... 2005-11-23 13:48:52.153 Unable to connect to database! 2005-11-23 13:48:52.153 No error type from QSqlError? Strange... 2005-11-23 13:48:52.153 Database not open while trying to load setting: Language mythtv: could not connect to socket mythtv: Connection refused lirc_init failed for mythtv, see preceding messages 2005-11-23 13:48:52.284 Joystick disabled. 2005-11-23 13:48:53.444 Unable to connect to database! 2005-11-23 13:48:53.444 No error type from QSqlError? Strange... 2005-11-23 13:48:53.445 Database not open while trying to save setting: Language 2005-11-23 13:48:53.445 Unable to connect to database! 2005-11-23 13:48:53.445 No error type from QSqlError? Strange... 2005-11-23 13:48:53.445 Database not open while trying to load setting: Language 2005-11-23 13:48:53.445 Unable to connect to database! 2005-11-23 13:48:53.445 No error type from QSqlError? Strange... 2005-11-23 13:48:53.446 Database not open while trying to save setting: Language 2005-11-23 13:48:53.455 Unable to connect to database! 2005-11-23 13:48:53.455 No error type from QSqlError? Strange... 2005-11-23 13:48:56.625 User canceled database configuration 2005-11-23 13:48:56.625 Failed to init MythContext, exiting.
From: JohnK on 23 Nov 2005 14:27 Wodan Wodanson wrote: > Hello, > > After many frustrating hours of fiddling I've managed to install all > packages needed for MythTV (ver Do you have qt3-mysql installed?
From: Wodans on 23 Nov 2005 14:28 JohnK wrote: > Wodan Wodanson wrote: > >> Hello, >> >> After many frustrating hours of fiddling I've managed to install all >> packages needed for MythTV (ver > > > Do you have qt3-mysql installed? Hi JohnK Yes I have qt3-mysql.3.3.5-19" installed. Cheers
From: houghi on 23 Nov 2005 14:36 Wodan Wodanson wrote: > Hello, > > After many frustrating hours of fiddling I've managed to install all > packages needed for MythTV (ver > mythtv-frontend-0.18.2-13SVN20051013.i586) (at least I think so). I've > managed to set up IVTV and I'm now able to watch tv in MPlayer with > sound. I've followed the instructions from > http://blog.eleith.com/eblog/?uid1=464&eblog1=1#5.3. I looked through them and also here there is a missing link between the ivtv running and the tuner. It ends with 'modprobe ivtv' and the next step is to do `cat /dev/video0 > test0.mpg`. I still have to figure out how to get the snow I see there into an actual signal. :-( -- houghi Please do not toppost http://houghi.org You are about to enter another dimension, a dimension not only of sight and sound but of mind. A journey into a wondrous land of imagination. Next stop, Usenet
From: JohnK on 23 Nov 2005 14:42
Wodans wrote: > JohnK wrote: > >> Wodan Wodanson wrote: >> >>> Hello, >>> >>> After many frustrating hours of fiddling I've managed to install all >>> packages needed for MythTV (ver >> >> >> >> Do you have qt3-mysql installed? > > > Hi JohnK > > Yes I have qt3-mysql.3.3.5-19" installed. > > Cheers Ok - here is a list of SQL related packages I have installed. I doubt if you need them all but... # rpm -qa | grep -i sql sqlite-2.8.15-3 mysql-shared-4.0.21-4.2 perl-DBD-mysql-2.9004-2.1 xbsql-0.11-102 mysqlcc-0.9.4-88.1 mysql-client-4.0.21-4.2 qt3-mysql-3.3.3-24.1 mysql-4.0.21-4.6 Perhaps one of them is the missing one. Cheers JohnK |