Mailing List Archive

More MythMusic Help
OK, I've got a LM 9.1 box with thac's mandrake-club RPMs installed for
mythtv 0.8.

Live TV works.
TV recording works.
mythweather works.
mythgallery works.

Mythmusic, however, does not.

I was unable to run the mysql command after installing. (There was a
message after the installation of the rpm to run.

mysql < /usr/share/doc/mythmusic-0.8/musicdb/metadata.sql

When I attempt to run that, I get the following error:

bash: /usr/share/doc/mythmusic-0.8/musicdb/metadata.sql: No such file or
directory

Well, I read the documentation and changed the location of where it looked
for my music in /usr/share/mythtv/mythmusic-settings.txt

The mysql command still won't run, but if I load up mythbackend and then
mythfrontend, mythmusic appears. The console shows it scanning through
the music directory, but once it is done, there are no files available for
me to play. It does, however, recognize cds.

Any ideas on what to fix?


-- RJV -- ..ooOO miracle@procyon.com

-- Institution of Postgraduate Education - Graduation 2001
-- Institution of Undergraduate Education - Alumnus 1997

The opinions expressed in any email originating from this account are the
sole opinions of the author. They do not reflect the opinions or policies
of any institution or individuals other than myself.
Re: More MythMusic Help [ In reply to ]
You need to find the file 'metadata.sql' and load it into your
database. The mysql command you tried is probably looking for a file
that is not in the location the rpm message said. Find the file, 'cd'
to its directory, then run 'mysql < metadata.sql' from there.

No music is showing up because, although mythmusic can find your music
files (you edited mythmusic-settings.txt, right?), it cannot insert the
metadata into the database because the tables don't exist.

-Joe C.

On Wed, 2003-04-09 at 00:23, RJV wrote:
> OK, I've got a LM 9.1 box with thac's mandrake-club RPMs installed for
> mythtv 0.8.
>
> Live TV works.
> TV recording works.
> mythweather works.
> mythgallery works.
>
> Mythmusic, however, does not.
>
> I was unable to run the mysql command after installing. (There was a
> message after the installation of the rpm to run.
>
> mysql < /usr/share/doc/mythmusic-0.8/musicdb/metadata.sql
>
> When I attempt to run that, I get the following error:
>
> bash: /usr/share/doc/mythmusic-0.8/musicdb/metadata.sql: No such file or
> directory
>
> Well, I read the documentation and changed the location of where it looked
> for my music in /usr/share/mythtv/mythmusic-settings.txt
>
> The mysql command still won't run, but if I load up mythbackend and then
> mythfrontend, mythmusic appears. The console shows it scanning through
> the music directory, but once it is done, there are no files available for
> me to play. It does, however, recognize cds.
>
> Any ideas on what to fix?
>
>
> -- RJV -- ..ooOO miracle@procyon.com
>
> -- Institution of Postgraduate Education - Graduation 2001
> -- Institution of Undergraduate Education - Alumnus 1997
>
> The opinions expressed in any email originating from this account are the
> sole opinions of the author. They do not reflect the opinions or policies
> of any institution or individuals other than myself.
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users@snowman.net
> http://lists.snowman.net/cgi-bin/mailman/listinfo/mythtv-users
Re: More MythMusic Help [ In reply to ]
On Wed, 9 Apr 2003, Joseph A. Caputo wrote:

> You need to find the file 'metadata.sql' and load it into your
> database. The mysql command you tried is probably looking for a file
> that is not in the location the rpm message said. Find the file, 'cd'
> to its directory, then run 'mysql < metadata.sql' from there.
>
> No music is showing up because, although mythmusic can find your music
> files (you edited mythmusic-settings.txt, right?), it cannot insert the
> metadata into the database because the tables don't exist.
>
> -Joe C.

I did edit mythmusic-settings.txt.

It appears that metadata.sql isn't anywhere on my box.
http://rpm.nyvalls.se/graphics9.1.html is where I got the rpms. They're
in testing phase, so it's expected that some don't work.

Where can I pick up a fresh metadata.sql copy?

-- RJV -- ..ooOO miracle@procyon.com

-- Institution of Postgraduate Education - Graduation 2001
-- Institution of Undergraduate Education - Alumnus 1997

The opinions expressed in any email originating from this account are the
sole opinions of the author. They do not reflect the opinions or policies
of any institution or individuals other than myself.
Re: More MythMusic Help [ In reply to ]
On Wednesday 09 April 2003 10:37 am, RJV wrote:

>
> Where can I pick up a fresh metadata.sql copy?
>

http://cvs.mythtv.org/cgi-bin/viewcvs.cgi/mythmusic/musicdb/

- thor
RE: More MythMusic Help [ In reply to ]
Hmmm... I've never used the RPMs to install Myth, so I'm not sure if the
file is even included. Here is a link to the current metadata.sql file in
CVS:

http://cvs.mythtv.org/cgi-bin/viewcvs.cgi/*checkout*/mythmusic/musicdb/metad
ata.sql?rev=HEAD&content-type=text/plain

-Joe C.

> -----Original Message-----
> From: mythtv-users-bounces@snowman.net
> [mailto:mythtv-users-bounces@snowman.net]On Behalf Of RJV
> Sent: Wednesday, April 09, 2003 10:38 AM
> To: Discussion about mythtv
> Subject: Re: [mythtv-users] More MythMusic Help
>
>
>
> I did edit mythmusic-settings.txt.
>
> It appears that metadata.sql isn't anywhere on my box.
> http://rpm.nyvalls.se/graphics9.1.html is where I got the rpms. They're
> in testing phase, so it's expected that some don't work.
>
> Where can I pick up a fresh metadata.sql copy?
>
> -- RJV -- ..ooOO miracle@procyon.com