Mailing List Archive

softsecure@vivace.homelinux.net wrote:

>>Unable to open database:
>>Driver error was:
>>QMYSQL3: Unable to connect
>>Database error was:
>>Access denied for user: 'mythtv@localhost' (Using password: YES)
>>
>>
>Any guesses for what I might need to do to start using mythtv?
>
Did you set up the database, if the RPMs didn't do that for you?
usually, that's as easy as
mysql < mc.sql
or
mysql -uroot -pyourpassword < /usr/whatever/mc.sql

If you already did that, then the access rights for user mythtv are not
set up properly. A look in /var/log/mysql.-log might help, as well as
reading the MySQL docs about giving user rights.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

> I run Mandrake 9.1 and I used the RPMS from the site that I
> found a link to from the mythtv site...

Did you install Mandrake 9.1 RPMs from nyvalls.se, or Axel Thimm's
RedHat RPMs?

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBPsJ4Tfc1NpCTlP0JEQJPfQCgouNWURi7hwSipcC7dmznwxyv+hcAoMQL
8ZrMShA5qbsGt92/5ooFfoLL
=5BUb
-----END PGP SIGNATURE-----

seems that you have not installed the database yet. did you execute this
(taken from installation manual):
6.4 Setting up the initial database.
This step is only required on the system maintaining the database, which
may or may not be one of your MythTV boxes. If the database is on a
non-MythTV machine, then copy the database/mc.sql file to it.
To setup the initial mysql databases:
$ cd database
$ mysql -u root < mc.sql



Marc






At 18:54 14-5-2003, you wrote:
>OK...I'm having a hard time installing mythtv...probably given my lack of
>experience with Linux more than anything else...
>
>I run Mandrake 9.1 and I used the RPMS from the site that I found a link
>to from the mythtv site...my current problem seems to be that I can't get
>it to work. :-)
>
>I presume after installing, I'm supposed to run mythtvsetup
>
>That stops with the following error:
>
> > Unable to open database:
> > Driver error was:
> > QMYSQL3: Unable to connect
> > Database error was:
> > Access denied for user: 'mythtv@localhost' (Using password: YES)
>
>Any guesses for what I might need to do to start using mythtv?
>
>Scott Rollins
>softsecure@vivace.homelinux.net
>_______________________________________________
>mythtv-users mailing list
>mythtv-users@snowman.net
>http://lists.snowman.net/cgi-bin/mailman/listinfo/mythtv-users

I had a similar problem when I frist set up MythTV (using the Debian-Sid
prepackaged version). Although I got it working, I did so much futzing
around to make it work that I don't think I can describe how to do it
properly. But this question does come up again and again. Is there any
possibility that someone who actually understands this part (I'm trying to
exclude *me* here ... not *you*, Ben) could write it up in a systematic way?

By systematic, I mean with all the details, including common errors and
what to do about them. For example, Ben's explanation below omits any
indication of whether to execute those commands as root, as mythtv, or as
someone else.

I apologize for simply asking someone else to do some work. Plain truth is,
I don't understand mysql well enough to do this for the docs. But I think
it is badly needed. MythTV users shouldn't have to become mysql experts (or
do people disagree with that view?) just to record TV.

At 07:07 PM 5/14/2003 +0200, Ben Bucksch wrote:
>softsecure@vivace.homelinux.net wrote:
>
>>>Unable to open database:
>>>Driver error was:
>>>QMYSQL3: Unable to connect
>>>Database error was:
>>>Access denied for user: 'mythtv@localhost' (Using password: YES)
>>>
>>Any guesses for what I might need to do to start using mythtv?
>Did you set up the database, if the RPMs didn't do that for you? usually,
>that's as easy as
>mysql < mc.sql
>or
>mysql -uroot -pyourpassword < /usr/whatever/mc.sql
>
>If you already did that, then the access rights for user mythtv are not
>set up properly. A look in /var/log/mysql.-log might help, as well as
>reading the MySQL docs about giving user rights.
>
>_______________________________________________
>mythtv-users mailing list
>mythtv-users@snowman.net
>http://lists.snowman.net/cgi-bin/mailman/listinfo/mythtv-users

On Wed, 14 May 2003, Robert Kulagowski wrote:

> > I run Mandrake 9.1 and I used the RPMS from the site that I
> > found a link to from the mythtv site...
>
> Did you install Mandrake 9.1 RPMs from nyvalls.se, or Axel Thimm's
> RedHat RPMs?

The Mandrake 9.1 RPMS from nyvalls.se

Scott Rollins
softsecure@vivace.homelinux.net

Ray Olszewski wrote:

> For example, Ben's explanation below omits any indication of whether
> to execute those commands as root, as mythtv, or as someone else.

As root, although any user having administration access within MySQL
should work.

> I apologize for simply asking someone else to do some work. Plain
> truth is, I don't understand mysql well enough to do this for the
> docs. But I think it is badly needed. MythTV users shouldn't have to
> become mysql experts (or do people disagree with that view?) just to
> record TV.

I agree. I had to look up the MySQL docs as well, and I don't understand
MySQL well enough to describe the steps in a 'systematic way'. In fact,
for example, I can't get access to MySQL from my notebook (different
subnet, but it should have access) and I don't know why.

Ben

On Wed, 14 May 2003, Robert Kulagowski wrote:

> > The Mandrake 9.1 RPMS from nyvalls.se
>
> Did you run the mysql command as specified after the RPM finishes?

I need to check back...no, I didn't but I don't find an mc.sql file to
use...so I probably missed something.

Scott Rollins
softsecure@vivace.homelinux.net

the "host" field in the user table of mysql dictates where a user is allowed
to connect form.

If you want to be able to connect from any machine put a '%' in the host
field for the users that you want to connect as.

When you run a mysql command you can specify on the command line what
user/pass to connect to the DB as. You don't actually have to run the
command AS root.

mysql -U root -P <your pass> .........

-John

> -----Original Message-----
> From: mythtv-users-bounces@snowman.net
> [mailto:mythtv-users-bounces@snowman.net]On Behalf Of Ben Bucksch
> Sent: Wednesday, May 14, 2003 1:34 PM
> To: Discussion about mythtv
> Subject: Re: [mythtv-users] Installation database problems
>
>
> Ray Olszewski wrote:
>
> > For example, Ben's explanation below omits any indication of whether
> > to execute those commands as root, as mythtv, or as someone else.
>
> As root, although any user having administration access within MySQL
> should work.
>
> > I apologize for simply asking someone else to do some work. Plain
> > truth is, I don't understand mysql well enough to do this for the
> > docs. But I think it is badly needed. MythTV users shouldn't have to
> > become mysql experts (or do people disagree with that view?) just to
> > record TV.
>
> I agree. I had to look up the MySQL docs as well, and I don't understand
> MySQL well enough to describe the steps in a 'systematic way'. In fact,
> for example, I can't get access to MySQL from my notebook (different
> subnet, but it should have access) and I don't know why.
>
> Ben
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users@snowman.net
> http://lists.snowman.net/cgi-bin/mailman/listinfo/mythtv-users
>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I'm pretty sure that after installing the mythbackend RPM it gave you
instructions to run mysql to create the database. The Mandrake
packages put the config files in places other than what you find in
the HOWTO or if you install manually, so you'll either need to search
for the files yourself using updatedb and locate, or contact the
packager.

[Down, Cedar! :) ]

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBPsKbSvc1NpCTlP0JEQLIPQCfWqdT96315iPokBvlHB6oTBW+DV8AoLAh
3K/DEqe1xJcnCviPR74n8vED
=7zLE
-----END PGP SIGNATURE-----

>[Down, Cedar! :) ]
>
>
>

Ha Ha Ha! I laughed like hell when I read that. Am I really that
predictable? Well, yes. When I saw the post this morning I could barely
restrain myself, but finally took a few deep breaths and left it
alone. :-D Well, at least it seems that I have gotten my point accross.


best,

Cedar

At 07:18 PM 5/14/03 +0200, Marc Kessels wrote:
>seems that you have not installed the database yet. did you execute this
>(taken from installation manual):
>6.4 Setting up the initial database.
>This step is only required on the system maintaining the database, which
>may or may not be one of your MythTV boxes. If the database is on a
>non-MythTV machine, then copy the database/mc.sql file to it.
>To setup the initial mysql databases:
>$ cd database
>$ mysql -u root < mc.sql


I just installed on RedHat 9 using RPMs (probably different ones? thought
I think they may have been from sweden...)

The setup file was in /usr/share/docs/mythtv/, I think it was under the
database subdirectory there. I ran the command as root. I don't remember
now whether I had to set a root password etc before that.

If the person with the original problem wants to contact me off-list, feel
free, I do a lot of MySQL stuff. I may not know it all off the top of my
head, but I've got the references handy and would be glad to try to help.