Mythppv
From MythTV
Contents |
What is MythPPV?
MythPPV is a series of scripts that retrive the Dish Network PPV (Pay-Per-View) titles and insert them into your MythTV Guide.
How does MythPPV work?
MythPPV has a client and server portion. The server (www.mythppv.com) grabs the Dish Network PPV data and then parses it a format the client will understand. The client is loaded on your MythTV box and setup to run nightly. The client will retreive the parsed data from the server based on your TimeZone and then update the MythTV Guide with title, description, rating, start/end time, etc.
What is required to run MythPPV?
** For *nix users: you should be able to start the Perl Package Manger by typing perl -MCPAN -e shell **
** For Windows users: run the Perl Package Manager, under Active Perl start menu folder **
Once you are at the cpan> or ppm> prompt, type: install <package>
| *nix <package> | windows <package> |
| WWW::Mechanize | WWW-Mechanize |
| HTML::TokeParser::Simple | HTML-TokeParser-Simple |
| Date::Calc | Date-Calc |
| FindBin::Real | FindBin-Real |
| IO::Zlib | IO-Zlib |
| Tie::Gzip | Tie-Gzip |
| DBD::mysql | DBD-mysql |
Where do I get MythPPV?
You can download the client side script from www.MythPPV.com under the download section. The current Client release is:
Version 1.1 of sql.pl, built on Monday March 21st 2005
Quick installation of sql.pl
If your MySql setup is default, then you will have nothing to do config wise. If its not the same, then open up the sql.pl in your favorite editor and starting on line 37 you will see the below, just change it to match your settings. The script does assume that you are using program, programgenres, and programrating (which are all MythTV defaults).
- Set your auth mysql info here
my $database = "mythconverg"; my $hostname = "localhost:3306"; my $user = "mythtv"; my $password = "mythtv";
Running the script
I would recomend running this in cron about an hour after your mythfilldatabase
You can make a simple shell script, lets call it getppv.sh, which calls mythfilldatabase then sql.pl and put that in cron.
| . |
| example getppv.sh |
| just some fill to make my rows a wee bit larger, don't cha know |
| #!/bin/sh |
| /usr/bin/mythfilldatabase |
| /scripts/sql.pl <SCRIPT OPTIONS SEE BELOW> |
| . |
| . |
| example cron to run nightly at 2:00am |
| just some fill to make my rows a wee bit larger, don't cha know |
| type 'su - root' , then type 'crontab -e' |
| . |
| 00 02 * * * /script/getppv.sh |
| /usr/bin/mythfilldatabase |
| . |
Script Options
- The Defaults of this script are to grab the Eastern Time Zone file from http://www.mythppv.com.
| . |
| If you are in a Time Zone other then Eastern, you will have to specify your timezone with the -tz option |
| . |
example for Central: ./sql.pl -tz Central other valid options are (Eastern Central Mountain Pacific Alaska Hawaii)
You may also do a ./sql.pl -h for the other command line options.
Problems
I don't think you will have to do this step if you are running locally. But if you get errors saying you cannot connect, then just do it. I pulled this from the KnoppMyth Doc's.
| Edit /etc/mysql/my.cnf, comment out 'skip-networking'. |
| . |
| Before: |
| skip-networking |
| . |
| After |
| # skip-networking |
| . |
| Restart MySQL(as root) |
| /etc/init.d/mysql restart |
| . |
| You can contact either me from the MythPPV.com contacts page if you have any issues. I |
| don't run MythTV at the moment, so if you have any problems please shoot me off an email. |
| . |
| About the only issues we have had so far deal with the server-side scripts, and those usually |
| get fixed a day or two after I have been contacted by one of the MythPPV users telling me its down. |
| Just some more fill so I can get this table a bit wider. Maybe a bit more.. almost there now. Need more |
| Enjoy |
| . |
| Dish Network dish network ppv PPV pay per view Pay Per View pay-per-view |
| Pay-Per-View Dishnetwork Dishnet net dishnetwork dishnet dish |
