[mythtv-users] Config data not saving in backend

Ryan B Elliott rbelliott at raytheon.com
Fri Jun 8 15:57:42 UTC 2007


Well, first I logged in with my own user account (ryan) and tried to 
connect to the mysql database, and
was able to do so successfully.  I found that there was a database for 
mythtv containing a table
called "mythconverg".  But when I ran the command "DESCRIBE mythconverg;" 
it gave me an error
about not being able to find the table file.  I'll get the actual error 
message if you think it would help.  But
it sounds like my tables did not get created properly.  I could drop the 
table and recreate it, but I don't 
know what it is supposed to look like.  Would it be best to try 
re-installing everything, or is there a tool
to re-create the mysql tables?

For completeness, I was going to try the last suggestion you made (Log in 
with the mythtv backend),
but I looked under the administrative tools and only 2 accounts are listed 
("ryan" and "root") for my 
installation of Ubuntu.  So the installation instructions I followed did 
not create any account for the
mythtv backend (that I can see). . .

WAIT, now that I re-read your email, it looks like you meant log into the 
database, not the computer, with the
mythtv account.  So I guess I did accomplish that much.

So as Gilda Radner used to say . . . nevermind.





"Calvin Dodge" <caldodge at gmail.com> 
Sent by: mythtv-users-bounces at mythtv.org
06/05/2007 04:10 PM
Please respond to
Discussion about mythtv <mythtv-users at mythtv.org>


To
"Discussion about mythtv" <mythtv-users at mythtv.org>
cc

Subject
Re: [mythtv-users] Config data not saving in backend






On 6/5/07, Ryan B Elliott <rbelliott at raytheon.com> wrote:
> The Video Sources info is not being saved either.  It must be a problem 
with
> the database.

Is the database on the same system as the mythtv backend? If not, has
Mysql been configured to accept the mythtv user from another system?

What happens if you login to the system with the mythtv backend, and
run the following command line? (assuming you accepted the default
name and password when creating the database)

mysql   -h DBHOST -u mythtv --password=mythtv mythconverg

where DBHOST is the name or IP address of the computer containing the 
database.

> I know that my user account is supposed to be in a special group, so 
I'll
> check that, then

That shouldn't be required for mysql access - I think that's so the
backend can run as a non-privileged user, and still access the video
and audio devices. Since my system has no direct connection to the
Internet, and it was a pain getting the backend to run reliably as a
non-privileged user (I'd edit the /etc/init.d/mythbackend script, but
it would be overwritten every time the mythtv-backend package was
updated), I have it running as root.

> I'll go figure out how to access the mysql database (I dutifully wrote 
down
> the generated
> password, so it shouldn't be too hard).  Can I assume that the database 
is
> running on the
> standard port 3350?

It should be.

>  Once I get in, I'm not sure what I should look for that
> may be wrong
> with it.  If the database structure is documented somewhere, I'll 
compare it
> to the spec,

Since you can't save video source info either, but mythtv-setup is
apparently starting up without a problem, my suspicion is that you
have a mythconverg database, but haven't actually run the script to
create the tables in it.

Calvin
_______________________________________________
mythtv-users mailing list
mythtv-users at mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20070608/9c6f9813/attachment.htm 


More information about the mythtv-users mailing list