LinHES Forums
http://forum.linhes.org/

mythlink (pretty) script no longer working for me
http://forum.linhes.org/viewtopic.php?f=6&t=2492		 Page 1 of 1
Author:  ceenvee703 [ Fri Sep 24, 2004 9:01 pm ]
Post subject:  mythlink (pretty) script no longer working for me
My /myth/pretty/ folder is empty. Running mythlink.sh manually just says "Skipping" for each .nuv file in my /myth/tv folder. Checked the system log, can't see any problems. Any ideas on what to do now? Thanks. (PS: can't say for sure this is 0.16 related as I haven't checked the pretty folder recently)
Author:  gr8nash [ Fri Sep 24, 2004 9:29 pm ]
Post subject: 
i had this problem when i R4v4.1 after i updated to .16, but i thought i must have messed up something on my system. i just did a autoupgrade to R4V5 and it went great. but mythpretty is still broken.. its definitly a .16 thing.. mythlink says skipping to all my NUV files as well.
Author:  gr8nash [ Fri Sep 24, 2004 9:58 pm ]
Post subject: 
Quote:
# skip if the nuv doesnt exist
do { print "Skipping $mythpath/$ofn\n"; next } unless -e "$mythpath/$ofn";
$start =~ /^....(........)/;


this is the part of the script that isnt working. if you comment our the two lines under SKIP IF NUV DOESNT EXIT, the script runs fine. Everything i kind of understand but this:
Quote:
$start =~ /^....(........)/;

start is the variable for start time, but what is
Quote:
=~ /^....(........)/;


lol that last part totatly lost me for any meaning in english.. ohh how i miss logical languages like visual basic.. =0P Anyone know??
Author:  ceenvee703 [ Sat Sep 25, 2004 6:24 am ]
Post subject: 
Tried commenting out those lines but now it says

Code:
Failed to create symlink /myth/pretty/The_Magic_School_Bus-The_Magic_School_Bus_Gains_Weight.mpg: Permission denied at -e line 39, <> line 2.


and stops.
Author:  toddm_c [ Sat Sep 25, 2004 1:28 pm ]
Post subject:  Add DATE_FORMAT
It appears that the date format has changed. I altered the SQL line from

Code:
mysql -uroot  mythconverg -B --exec "select chanid,starttime,endtime,title,subtitle from recorded;" >/tmp/mythlink.$$


to

Code:
mysql -uroot  mythconverg -B --exec "select chanid,DATE_FORMAT(starttime,'%Y%m%d%H%i%s'),DATE_FORMAT(endtime,'%Y%m%d%H%i%s'),title,subtitle from recorded;" >/tmp/mythlink.$$


Note the addition of DATE_FORMAT.

It seems to work (for me) with that change.
Author:  ceenvee703 [ Sat Sep 25, 2004 9:14 pm ]
Post subject: 
I thought it might be a database change. Thanks for the edit. Unfortunately I'm still seeing the same symlink permissions error I listed above with the edited script. Ugh.
Author:  tjc [ Sat Sep 25, 2004 9:22 pm ]
Post subject: 
Which crontab is the script in and who owns the directory? It runs as root on my system which pretty much means the permission problems shouldn't be an issue. The directory is owned by mythtv but obviously the symlinks are going to be owned by whoever creates them.
Author:  ceenvee703 [ Sun Sep 26, 2004 3:23 am ]
Post subject: 
Thank you, you're right of course... I was running it manually as mythtv and it wasn't working, but the crontab runs as root and it worked properly. Whew. Thanks again.
Author:  gr8nash [ Sun Sep 26, 2004 6:29 pm ]
Post subject: 
Quote:
It appears that the date format has changed. I altered the SQL line from

Code:
mysql -uroot mythconverg -B --exec "select chanid,starttime,endtime,title,subtitle from recorded;" >/tmp/mythlink.$$


to

Code:
mysql -uroot mythconverg -B --exec "select chanid,DATE_FORMAT(starttime,'%Y%m%d%H%i%s'),DATE_FORMAT(endtime,'%Y%m%d%H%i%s'),title,subtitle from recorded;" >/tmp/mythlink.$$


Note the addition of DATE_FORMAT.

It seems to work (for me) with that change.


that worked for me thanks!!!
Author:  bhb [ Tue Oct 05, 2004 3:28 pm ]
Post subject: 
Please forgive the very newbish question. I installed KnoppMyth over the weekend and it is working splendidly except for the "pretty folder" being empty.

After reading the previous posts, exactly which file do I edit to make the change:

Code:
mysql -uroot mythconverg -B --exec "select chanid,starttime,endtime,title,subtitle from recorded;" >/tmp/mythlink.$$


to

Code:
mysql -uroot mythconverg -B --exec "select chanid,DATE_FORMAT(starttime,'%Y%m%d%H%i%s'),DATE_FORMAT(endtime,'%Y%m%d%H%i%s'),title,subtitle from recorded;" >/tmp/mythlink.$$

Thanks to everyone for the excellent work!
Author:  gr8nash [ Tue Oct 05, 2004 3:58 pm ]
Post subject: 
mythlink.sh i cant remember where its at, and im not at my box so do a
Code:
locate mythlink.sh

it will tell you what dir its in
Author:  WillJitsu [ Tue Oct 05, 2004 11:49 pm ]
Post subject: 
In case you didn't find it, it's located here: /usr/local/bin/mythlink.sh
Author:  bhb [ Wed Oct 06, 2004 3:08 am ]
Post subject: 
Thanks very much. I'll make the change when I get home.
Author:  brendan [ Fri Dec 10, 2004 11:17 am ]
Post subject:  Re: Add DATE_FORMAT
toddm_c wrote:
It appears that the date format has changed. I altered the SQL line from

Code:
mysql -uroot  mythconverg -B --exec "select chanid,starttime,endtime,title,subtitle from recorded;" >/tmp/mythlink.$$


to

Code:
mysql -uroot  mythconverg -B --exec "select chanid,DATE_FORMAT(starttime,'%Y%m%d%H%i%s'),DATE_FORMAT(endtime,'%Y%m%d%H%i%s'),title,subtitle from recorded;" >/tmp/mythlink.$$


Note the addition of DATE_FORMAT.

It seems to work (for me) with that change.


This worked for me as well using R4V5 .

-brendan
Page 1 of 1 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/