| View previous topic :: View next topic |
| Author |
Message |
MadEgg
l33t
Joined: 06 Jun 2002
Posts: 678
Location: Netherlands
|
 Posted: Thu Oct 20, 2005 12:11 pm Post subject: mythtv-setup not doing anything |
 |
|
A while ago I tried to install mythtv, configured something but didn't get it to work the way I wanted.
Now I decided to give it another try, to start from scratch I deleted the mythconverg database form mysql and the /etc/mythtv directory, and re-emerged mythtv.
I was working through the howto at mythtv.org and at http://www.mythtv.org/docs/mythtv-HOWTO-9.html it says to run mythtv-setup. I answer no to the first two questions and then I get thrown back to the console with this message:
| Code: |
2005-10-20 14:07:21.967 New DB connection, total: 1
Total desktop width=1600, height=1200, numscreens=1
2005-10-20 14:07:21.971 Using screen 0, 1600x1200 at 0,0
2005-10-20 14:07:21.974 Setting Lock for Database Schema upgrade. If you see a long pause here it means the Schema is already locked and is being upgraded by another Myth process.
2005-10-20 14:07:21.976 New DB connection, total: 2
2005-10-20 14:07:21.977 Upgrading to schema version 1072
2005-10-20 14:07:21.977 DB Error (Performing database upgrade):
Query was: ALTER TABLE program ADD COLUMN manualid INT UNSIGNED NOT NULL DEFAULT 0;
Error was: Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.program' doesn't exist
new version: 1072
2005-10-20 14:07:21.978 Database Schema upgrade FAILED, unlocking.
Could not find theme: Titivillus
2005-10-20 14:07:21.987 Switching to square mode (Titivillus)
mythtv: could not connect to socket
mythtv: Onbekend bestand of map
lirc_init failed for mythtv, see preceding messages
Could not find theme: Titivillus
Couldn't find theme Titivillus
If this is the master backend server:
Now, please run 'mythfilldatabase' to populate the database
with channel information.
|
It complains about the program table not existing, which is obvious because I deleted everything and wanted to start a new setup. But for some reason mythtv-setup wants to upgrade the DB. It also tells me to run mythfilldatabase which returns:
| Code: |
2005-10-20 14:08:18.866 New DB connection, total: 1
2005-10-20 14:08:18.870 New DB connection, total: 2
----------------- Start of XMLTV output -----------------
2005-10-20 14:08:18.872 New DB connection, total: 3
using config filename /root/.xmltv/tv_grab_nl.conf
config file /root/.xmltv/tv_grab_nl.conf does not exist, run me with --configure
------------------ End of XMLTV output ------------------
Error in 1:1: unexpected end of file
Updating icons for sourceid: 1
2005-10-20 14:08:19.302 New DB connection, total: 4
DB Error (Looking for icons to fetch):
Query was:
SELECT ch.chanid, nim.url FROM channel ch, callsignnetworkmap csm RIGHT JOIN networkiconmap nim ON csm.network = nim.network WHERE ch.callsign = csm.callsign AND (icon = 'none' OR icon = '') AND ch.sourceid = 1
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.callsignnetworkmap' doesn't exist
Updated programs: 0 Unchanged programs: 0
Failed to fetch some program info
|
So, another message about a missing table. How do I actually create all the tables required for MythTV?
I already executed the /usr/share/mythtv/database/mc.sql, so the mythconverg database does exist and the mythtv user has access to it.
_________________
Pentium 4 Prescott 3,2 GHz
Asus P4P800 SE, i865PE chipset
1024 MB PC3200 RAM
AOpen Aeolus GeForce 6800 Ultra 256 MB DDR2
Creative Audigy2 ZS
gentoo-sources-2.6.20-r7
nVidia-drivers version 9755 |
|
| Back to top |
|
 |
MadEgg
l33t
Joined: 06 Jun 2002
Posts: 678
Location: Netherlands
|
| Posted: Fri Oct 21, 2005 4:29 pm Post subject: |
|
|
*kick*
_________________
Pentium 4 Prescott 3,2 GHz
Asus P4P800 SE, i865PE chipset
1024 MB PC3200 RAM
AOpen Aeolus GeForce 6800 Ultra 256 MB DDR2
Creative Audigy2 ZS
gentoo-sources-2.6.20-r7
nVidia-drivers version 9755 |
|
| Back to top |
|
|
Shazam
Apprentice
Joined: 23 Nov 2004
Posts: 191
Location: Germany
|
| Posted: Sat Oct 22, 2005 11:35 am Post subject: |
|
|
u need to delete the myhttv directory, because in there are configuration files, which say you still have a database.
simply
but i have an identical problem. i got to set everything up, and now i'm trying to retrieve some channels (germany), but should be identical to the netherlands, because you need to run | Code: | | mythfilldatase --manual |
, too, but i don't know if there is something wrong with the connection to the server.
or can i setup the channels somehow else?
is there a program which auto scans the frequencies and adds them to the programm guide? |
|
| Back to top |
|
|
MadEgg
l33t
Joined: 06 Jun 2002
Posts: 678
Location: Netherlands
|
| Posted: Mon Oct 24, 2005 12:15 pm Post subject: |
|
|
That did the trick, removing ~/.mythtv worked.
Now I tried to fetch the program guides but I got errors about wrong URL's. After some searching I found an alternative to tv_grab_nl, namely, tv_grab_nl_gert, which does pull program guides but misconfigures all channels, IE the wrong names for the wrong programs, and not all of them work. Any dutch people around here who can tell me how to properly setup the TV channels with MythTV?
_________________
Pentium 4 Prescott 3,2 GHz
Asus P4P800 SE, i865PE chipset
1024 MB PC3200 RAM
AOpen Aeolus GeForce 6800 Ultra 256 MB DDR2
Creative Audigy2 ZS
gentoo-sources-2.6.20-r7
nVidia-drivers version 9755 |
|
| Back to top |
|
|
Shazam
Apprentice
Joined: 23 Nov 2004
Posts: 191
Location: Germany
|
| Posted: Tue Oct 25, 2005 9:01 am Post subject: |
|
|
| well, i don't know what you are using mythtv for, but if you just want to watch TV, i figured out that xawtv+kdetv work well together and have less setup time, about 5 min. |
|
| Back to top |
|
|
MadEgg
l33t
Joined: 06 Jun 2002
Posts: 678
Location: Netherlands
|
| Posted: Tue Oct 25, 2005 9:57 am Post subject: |
|
|
Well, mainly I want to watch TV but it would also be nice to have some TV Guide facilities and be able to record tv programmes, so I think mythtv is really what I need, but I've never tried kdetv/xawtv so I'll take a look.
_________________
Pentium 4 Prescott 3,2 GHz
Asus P4P800 SE, i865PE chipset
1024 MB PC3200 RAM
AOpen Aeolus GeForce 6800 Ultra 256 MB DDR2
Creative Audigy2 ZS
gentoo-sources-2.6.20-r7
nVidia-drivers version 9755 |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
Multimedia
