Re: running mythtv-setup as myself?

Top Page

Reply to this message
Author: Jon N
Date:  
To: dmo-discussion
Subject: Re: running mythtv-setup as myself?
I have been doing some more work trying to figure this out, but first
a different question. Is this even the right group to ask about this.
I was thinking that just because I download the packages from
deb-multimedia that doesn't mean it's the right place to ask about
problems with the resulting system. So I'll try to put some of what I
did below, if this isn't really the best place please let me know.

So first I tried to completely uninstall everything (mythtv & mysql)
and make sure the user mythtv, and all folders and files related to
the old setup were gone. It didn't help a bit, the next install still
had the same problem :-). I started reading some of the mythtv.org
manual (duh!), I thought it most mostly for compiling mythtv from
source so didn't pay much attention to it previously. But reading
about setting the root password got me started.

So, following some of those instructions I was able to see the user
table, and saw a 'mythtv'@'localhost and 'mythtv'@% (or is it '%', I'm
not sure). I found in /usr/share/mythtv/sql/mc.sql and made a copy
changing the part after the @ to my host name Bedlum, then ran mysql
<Bedlum.sql. I noticed 2 things.

One, in the user table it has a new user, but the host is lower case,
'bedlum'. I know it's capitalized in the .sql file. And, even though
there isn't anything about a password in the sql file there apparently
is one for this new user. If I can at least use the 'Password' field
in the user table to compare passwords between different users this
new password is different than 'mythtv'@'localhost'.

I guess this is were I really messed things up. I used the same
command to create a password for root to change the password for all
the mythtv user entries. They looked the same in the user table. But
when I run "mythtv-setup" now it crashes. Here is part of the output
that looks significant:

2014-02-08 17:23:22.793982 E SaveSettingOnHost('Country') - No database yet
2014-02-08 17:23:22.793986 E SaveSettingOnHost('FreqTable') - No database yet
2014-02-08 17:23:22.793990 E SaveSettingOnHost('ISO639Language0') -
No database yet
2014-02-08 17:23:22.793994 E SaveSettingOnHost('ISO639Language1') -
No database yet
2014-02-08 17:23:22.793997 E SaveSettingOnHost('Language') - No database yet
2014-02-08 17:23:22.794000 E SaveSettingOnHost('TVFormat') - No database yet
2014-02-08 17:23:22.794003 E SaveSettingOnHost('VbiFormat') - No database yet
2014-02-08 17:23:22.794010 E SaveSettingOnHost('DateFormat') - No database yet
2014-02-08 17:23:22.794014 E
SaveSettingOnHost('MythArchiveDateFormat') - No database yet
2014-02-08 17:23:22.794019 E
SaveSettingOnHost('MythArchiveTimeFormat') - No database yet
2014-02-08 17:23:22.794023 E
SaveSettingOnHost('MythArchiveVideoFormat') - No database yet
2014-02-08 17:23:22.794028 E SaveSettingOnHost('ShortDateFormat') -
No database yet
2014-02-08 17:23:22.794032 E SaveSettingOnHost('TimeFormat') - No database yet
2014-02-08 17:23:22.883796 I ScreenSaverX11Private: XScreenSaver
support enabled
2014-02-08 17:23:22.884430 I ScreenSaverX11Private: DPMS is disabled.
2014-02-08 17:23:22.892688 E Error preparing query: SELECT DISTINCT
dirname FROM storagegroup WHERE groupname = :GROUP AND hostname =
:HOSTNAME
2014-02-08 17:23:22.892703 E Driver error was [2/1146]:
QMYSQL3: Unable to prepare statement
Database error was:
Table 'mythconverg.storagegroup' doesn't exist

2014-02-08 17:23:22.892824 E DB Error (StorageGroup::StorageGroup()):
Query was:
SELECT DISTINCT dirname FROM storagegroup WHERE groupname = :GROUP AND
hostname = :HOSTNAME
Bindings were:
:GROUP="Themes", :HOSTNAME="Bedlum"
Driver error was [2/1064]:
QMYSQL: Unable to execute query
Database error was:
You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near ':GROUP AND hostname = :HOSTNAME' at line 1

2014-02-08 17:23:22.893147 N Inserting MythTV initial database information.
2014-02-08 17:23:22.893161 C Upgrading to MythTV schema version 1307
libcec.so.1: cannot open shared object file: No such file or directory

So, 3 things stand out to me (but then again, obviously I don't know
much about what I am doing)
a) a bunch of lines saying there is no database
b) an error about SQL syntax, I'm familiar with those from my little
bit of use of the mysql command line. Why would it be wrong?
c) Is it creating a database in the 3rd line from the end?

Thanks,
Jon