#tt-rss

I have never used mysql before, so running tt-rss is a learning process for me.

Unfortunately, immediately after installing tt-rss I forgot my password and went searching to see how to reset the admin password. I eventually found LoginNotes157 on the tt-rss wiki but since I haven't used mysql before I didn't know where to paste the SQL line.

Note: See config.php in tt-rss's installation directory for your mysql username/ database name / password/ etc, if you've forgotten those too.

First you have to run mysql client: mysql -u ttrss -p

Now use the ttrss database: mysql> use ttrss

Paste the line from the wiki: (don't forget the semicolon!) mysql> UPDATE ttrss_users SET pwd_hash = 'SHA1:5baa61e4c9b93f3f0682250b6cf8331b7ee68fd8' WHERE login = 'admin';

If that doesn't work you're probably using a newer version of tt-rss that salts passwords, so you'll have to paste the following: (don't forget the semicolon!) mysql> UPDATE ttrss_users SET pwd_hash = 'SHA1:5baa61e4c9b93f3f0682250b6cf8331b7ee68fd8', salt= '' WHERE login = 'admin';

Tiny Tiny RSS 1.11 is available in the WebUpd8 Tiny Tiny RSS PPA.

Changes:

Minor parser bugfixes

Fix upgrading from older tt-rss versions

Minor performance improvements

Other bugfixes

API: fix labels not applying because API call expected labels in wrong format

Important: when upgrading, make sure to either select to replace the old config file with the new one when you’re prompted (this should happen when upgrading the package using apt-get, Software Updater, etc.) or to manually edit /etc/tt-rss/config.php and add this:

define('DETECT_ARTICLE_LANGUAGE', true);

(also add a tab in front of the line)

Package info:

Description: Tiny Tiny RSS is an open source web-based RSS reader that you can install on your server (ideally, but you can also install it on your desktop), that features an Ajax-powered interface, keyboard shortcuts, OPML import/export so you can easily import your Google Reader feeds, article sharing, supports mobile devices, can be extended through plugins and much more.

Package name: “tt-rss”

Ubuntu versions: 14.04, 13.10, 13.04, 12.10, 12.04

I am using tt-rss as my RSS solution.  However, it stopped showing me images.  The problem is due to LastPass, saving the "Use less traffic" field when it shouldn't.