TTRSS Just Grinding

Support requests, bug reports, etc. go here. Dedicated servers / VDS hosting only
Jake
Bear Rating Trainee
Bear Rating Trainee
Posts: 9
Joined: 31 Oct 2005, 16:35

TTRSS Just Grinding

Postby Jake » 06 Aug 2006, 17:46

My server recently died and I'm moving my ttrss instance to a new machine. I've copied the ttrss web folder and mysql database to the new server. But now, when I try to access the site, it just hangs on the "Loading" page, and the browser seems to be trying forever.

Apache's logs show no errors, and the access log shows the last thing run is backend.php?op=sanityCheck.

What's the next step in troubleshooting this? I've been without my RSS feeds for days now and I'm starting to go crazy.

Jake
Bear Rating Trainee
Bear Rating Trainee
Posts: 9
Joined: 31 Oct 2005, 16:35

Postby Jake » 06 Aug 2006, 17:51

Oops, that last access is backend.php?op=rpc&subop=sanityCheck

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Postby fox » 06 Aug 2006, 21:34

Try to open it in the browser and see what happens there.

Also, open tt-rss.php?debug=1 (after logging in) and see if there is anything wrong in debug log.

Jake
Bear Rating Trainee
Bear Rating Trainee
Posts: 9
Joined: 31 Oct 2005, 16:35

Postby Jake » 07 Aug 2006, 01:08

Neither of those showed any issues.

I gave up and re-installed from scratch, which is working perfectly.

I just need to see if I can recover my feeds list (and maybe even starred articles) from the old database. So far I'm not having any luck.

Thanks for the suggestions. My best guess is that it was some obscure problem with the database I moved.

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Postby fox » 07 Aug 2006, 11:00

Feedlist is easy - just do

Code: Select all

SELECT feed_url FROM ttrss_feeds WHERE owner_uid = your_uid


on your old database and you'll get your feed URLs. You can also try xml import/export tools, although I'm not sure if they would work with the latest schema.

Jake
Bear Rating Trainee
Bear Rating Trainee
Posts: 9
Joined: 31 Oct 2005, 16:35

Postby Jake » 07 Aug 2006, 16:46

Yeah, I managed to get all my data migrated. It wasn't a problem with knowing which tables to import/export, it was that the disk with the old data was misbehaving and would only spit out partial dumps sometimes. I got a usb enclosure and mounted it on another pc and was able to save my data.

This whole experience has reminded me how much I love ttrss. That system ran several sites and my email, but I believe ttrss is what I was most upset over losing. I use it so often-- especially the mobile set. Thanks again fox.

Now, my final issue. The update_daemon doesn't seem to be updating-- it's only purging! Here's my config.php:

Code: Select all

        define('DB_TYPE', "mysql"); // or mysql
        define('DB_HOST', "localhost");
        define('DB_USER', "iwontpostmyuser");
        define('DB_NAME', "rss");
        define('DB_PASS', "iwontpostmypass");
        define(RSS_BACKEND_TYPE, "magpie");
        define('MAGPIE_CACHE_DIR', '/var/tmp/magpie-ttrss-cache');
        define('SIMPLEPIE_CACHE_DIR',   '/var/tmp/simplepie-ttrss-cache');
        define('WEB_DEMO_MODE', false);
        define('ICONS_DIR', "icons");
        define('ICONS_URL', "icons");
        define('USE_HTTP_AUTH', false);
        define('SINGLE_USER_MODE', true);
        define('DAEMON_REFRESH_ONLY', true);
        define('SMART_RPC_COUNTERS', false);
        define('GLOBAL_ENABLE_LABELS', false);
        define('ENABLE_LOGIN_SSL', false);
        define('MAIL_RESET_PASS', true);
        define('MAIL_FROM', 'TT-RSS Daemon <[email protected]>');
        define('ENABLE_FEED_BROWSER', true);
        define('TMP_DIRECTORY', '/tmp');
        define('FEEDS_FRAME_REFRESH', 600);
        define('MAX_UPDATE_TIME', 0);
        define('ENABLE_UPDATE_DAEMON', true);
        define('DAEMON_SLEEP_INTERVAL', 120);
        define('DATABASE_BACKED_SESSIONS', false);
        define('SESSION_CHECK_ADDRESS', true);
        define('SESSION_COOKIE_LIFETIME', 0);
        define('SESSION_EXPIRE_TIME', 86400);
        define('DAEMON_UPDATE_LOGIN_LIMIT', 30);
        define('CONFIG_VERSION', 3);
   


All update_daemon.php seems to say is:

Code: Select all

Purging old posts (random 30 feeds)...
Purged feed 24 (60): deleted 0 articles
Purged feed 19 (60): deleted 0 articles
Purged feed 27 (60): deleted 0 articles
...SNIP...
Purged feed 23 (60): deleted 0 articles
Scheduled 0 feeds to update...
Sleeping for 120 seconds...
Scheduled 0 feeds to update...
Sleeping for 120 seconds...


Any idea what's caused this strange behavior?

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Postby fox » 07 Aug 2006, 18:08

Check your global update interval in preferences and feed last update times and update intervals.

Also, updating could be affected by DAEMON_UPDATE_LOGIN_LIMIT which uses last login time of your user.

Jake
Bear Rating Trainee
Bear Rating Trainee
Posts: 9
Joined: 31 Oct 2005, 16:35

Postby Jake » 07 Aug 2006, 18:32

DAEMON_UPDATE_LOGIN_LIMIT was the block for that. Setting it to 0 let me proceed. . . to a new issue :(

I suspect my new issue is related to the fact I migrated the running system to a new machine:

Code: Select all

Scheduled 39 feeds to update...
Feed: http://dotnetkicks.com/feeds/rss: (108/1800, 1) Update not needed.
Feed: http://haacked.com/rss.aspx: (48820/1800, 1) Updating...

Notice: Undefined index:  id in /var/www/feeds/functions.php on line 399

Notice: Undefined index:  date in /var/www/feeds/functions.php on line 409

Notice: Undefined index:  issued in /var/www/feeds/functions.php on line 410


Glancing at the code leads me to believe this is related to magpie-rss. Or is it a problem with the database tables I imported?

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Postby fox » 07 Aug 2006, 19:42

Nah, don't worry about that. TT-rss checks for a lot of optional attributes in the feed, when they aren't present this notice (access to an undefined array key or something like that) is generated.

If you see actual new posts appearing in the interface, it's all ok.

Jake
Bear Rating Trainee
Bear Rating Trainee
Posts: 9
Joined: 31 Oct 2005, 16:35

Postby Jake » 07 Aug 2006, 23:22

Heh, all those warnings scared me too much to let it run through. It all seems to be running fine now. Thank you very much!


Return to “Support”

Who is online

Users browsing this forum: No registered users and 14 guests