[Lester_Burnham]

rileyp, on 06 February 2012 - 04:30 AM, said:

Lester your supposed to be so kind as explain to me in lay mans terms how you uploaded the file to amcc as I don't know how and I even click on the help ? icon... :D
Oh gosh I just saw it attach this file at bottom of page. Never mind I'm an idoit I was looking in the toolbar!
Oh well there ya go!
cheers rileyp

Lol . I just thought you were asking about best compression format to use, because the board won't let you upload the raw file as a . py :)

Lester

[arkay]

Hehe. Glad you got that sorted out. I think the forum should accept both .zip and .gz. We never changed it for .py or .pl etc though as it makes sense to zip archives up. Also makes sure things are compressed so the board doesn't get too bit with attachments.

Cheers,

Arkay.

[dafrizz]

Still no luck.

I downloaded the file from Lester, unzipped it to my backend.

Output 1:

python ~/scripts/find_orphans.py 

  File "/home/laffi/scripts/find_orphans.py", line 26

    name = u'%s: %s' % (self.host, os.path.join(self.path, self))

                   ^

SyntaxError: invalid syntax

I did read something somewhere about python versions, so I tried this

python2 ~/scripts/find_orphans.py 

Traceback (most recent call last):

  File "/home/laffi/scripts/find_orphans.py", line 221, in <module>

    DB = MythDB()

  File "/usr/lib/python2.7/site-packages/MythTV/database.py", line 958, in __init__

    self.db = DBConnection(dbconn)

  File "/usr/lib/python2.7/site-packages/MythTV/connections.py", line 150, in __init__

    raise MythDBError(MythError.DB_CONNECTION, dbconn)

MythTV.exceptions.MythDBError: Failed to connect to database at 'mythconverg'@'192.168.1.103'for user 'mythtv' with password 'mythtv'.

Here are the bits from ~/.mythtv/mysql.txt

DBHostName=192.168.1.103



# By default, Myth tries to ping the DB host to see if it exists.

# If your DB host or network doesn't accept pings, set this to no:

#

#DBHostPing=no



DBUserName=mythtv

DBPassword=mythtv

so I don't understand why I get that error :confused:

[arkay]

Seems odd. Have you got any other users set up to access the database or is the password not really "mythtv"?

If you try to connect to the database like this:

mysql -u mythtv -p mythconverg

and use a password of "mythtv" when asked does it let you into the database or cause an error?

Cheers,

Arkay.

[dafrizz]

Looks good to me:

Quote

mysql -u mythtv -p mythconverg
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 5.5.11 Source distribution

Copyright © 2000, 2010, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

[rileyp]

cd to the dir its in and then run it and see what happens.
Its clucthing at straws but stranger things have happened.
ie

cd ~/scripts

python find_orphans.pl

The reason is ~ may not be the user in your post above that the script needs to go to
I'm betting
cheers rileyp

This post has been edited by rileyp: 08 February 2012 - 12:54 AM

[Lester_Burnham]

Hi,

Maybe Arch has things running as root. So, maybe a sudo is required.
My mythtv is run as mythtv user.

Lester

[arkay]

Shouldn't matter. As all it's doing is making modifications to the database. If the mythtv user has been granted access to the db (As it has been from what we see above), then the script should work, unless it's some other problem. Either with the version of python, or the code etc.

Worst case scenario you can always do what the script does, but manually. It just runs a few queries and compares what it things is in the recorded table to the files on disk. Anything that doesn't match is removed from the database. I'm sure we can piece together the queries from the code and run them manually if necessary.

Cheers,

Arkay.

[dafrizz]

Thanks for all the help. Did the cumbersome workaround for now and deleted all the recordings manually.

Haven't looked into the live tv stuff, but that should expire automatically anyway I hope.

For now I have other issues though: my guide data is not updating. No idea why, I haven't changed anything.

Running shepherd and mythfilldatabase manually right now, let's see what happens. If this doesn't work I might have to open yet another thread :angry:

[arkay]

Odd. If it runs on the command line then it should be working via cron. Or is yours set upso that myth calls the job? I still do mine the other way around so cron updates the guide data and forces myth to re-read it.

Cheers,

Arkay.

[dafrizz]

Mine is the same, all via cron.

Found the issue. Network problem.

Up until recently my router was taking care of my fixed IPs via fixed hosts. I wanted to change that to having it done via static IP in rc.conf. While my local lan was still working my internet wasn't.
Went back to the old way again and everything is fine.
Will have to look into static IP via rc.conf at some stage again.

[Lester_Burnham]

dafrizz, on 14 February 2012 - 09:08 PM, said:

Up until recently my router was taking care of my fixed IPs via fixed hosts. I wanted to change that to having it done via static IP in rc.conf. While my local lan was still working my internet wasn't.
Went back to the old way again and everything is fine.
Will have to look into static IP via rc.conf at some stage again.

I had exactly the same problem with an Asus RT-N56U. There was only a certain amount of static hosts allowed (8). So, was told by a testing "guru" in whirlpool and the Asus documentation to set static IP on the PC.
Started having the same problem as you. LAN fine, internet not accessible after a period of time.

Lester

This post has been edited by Lester_Burnham: 15 February 2012 - 01:26 AM

[dafrizz]

Lester_Burnham, on 15 February 2012 - 01:25 AM, said:

I had exactly the same problem with an Asus RT-N56U. There was only a certain amount of static hosts allowed (8). So, was told by a testing "guru" in whirlpool and the Asus documentation to set static IP on the PC.
Started having the same problem as you. LAN fine, internet not accessible after a period of time.

Lester

Interesting. I tried a different router and managed to set up static IPs with it. Everything worked fine, so I guess it's a router issue.
Had to go back to my old router though (where I use fixed hosts via the router instead of static IPs), the other one got way too hot and kept loosing the connection.

[Lester_Burnham]

dafrizz, on 19 February 2012 - 08:56 PM, said:

Interesting. I tried a different router and managed to set up static IPs with it. Everything worked fine, so I guess it's a router issue.
Had to go back to my old router though (where I use fixed hosts via the router instead of static IPs), the other one got way too hot and kept loosing the connection.

What routers are they?
Our old Netgear DG834 used to get a bit warm.

Lester

[dafrizz]

Lester_Burnham, on 19 February 2012 - 11:56 PM, said:

What routers are they?

The one that worked with static IPs was Netcomm NB9WMAXX, but after maybe 30min it got redicilously hot, speeds went down, connections were lost.
Then went back to my original one, Open 824RLW (which is a Billion 7404VGP clone). Get's warm as well, not as bad though. I also cut some slots in the case and will probably fit a fan to keep it cool.