[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