Package: tt-rss Version: 1.13+dfsg-1 Severity: important Dear Maintainer,
Since I upgraded to Debian 8, the tt-rss daemon no longer starts on
boot. It appears that when it attempts to start, MySQL is not ready.
However, I can start it manually. I can see these errors from systemd:
-- Logs begin at Sat 2015-08-08 10:15:18 PDT, end at Sat 2015-08-08
10:56:52 PDT. --
Aug 08 10:16:33 tardis update.php[1766]: PHP Warning: mysqli_connect():
(HY000/2002): Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2) in
/usr/share/tt-rss/www/classes/db/mysqli.php on line 9
Aug 08 10:48:22 tardis update.php[24771]: PHP Fatal error: Query INSERT
INTO ttrss_error_log
Aug 08 10:48:22 tardis update.php[24771]: (errno, errstr, filename,
lineno, context, owner_uid, created_at) VALUES
Aug 08 10:48:22 tardis update.php[24771]: (256, 'Query SELECT DISTINCT
ttrss_feeds.feed_url, ttrss_feeds.last_updated\n
FROM\n
ttrss_feeds, ttrss_users, ttrss_user_prefs\n
WHERE\n
ttrss_feeds.owner_uid = ttrss_users.id\n
AND ttrss_user_prefs.profile IS NULL\n
AND ttrss_users.id =
ttrss_user_prefs.owner_uid\n
AND ttrss_user_prefs.pref_name =
\'DEFAULT_UPDATE_INTERVAL\'\n
AND ttrss_users.last_login >=
DATE_SUB(NOW(), INTERVAL 30 DAY) AND ((\n
ttrss_feeds.update_interval = 0\n
AND ttrss_user_prefs.value !=
\'-1\'\n
AND ttrss_feeds.last_updated <
DATE_SUB(NOW(), INTERVAL CONVERT(ttrss_user_prefs.value, SIGNED INTEGER)
MINUTE)\n
) OR (\n
ttrss_feeds.update_interval > 0\n
AND ttrss_feeds.last_updated <
DATE_SUB(NOW(), INTERVAL ttrss_feeds.update_interval MINUTE)\n
) OR (ttrss_feeds.last_updated IS NULL\n
AND ttrss_user_prefs.value !=
\'-1\')\n
OR (last_updated = \'1970-01-01 00:00:00\'\n
in /usr/share/tt-rss/www/classes/db/mysqli.php on line 33
...
-- System Information:
Debian Release: 8.0
APT prefers stable
APT policy: (700, 'stable')
Architecture: i386 (x86_64)
Kernel: Linux 3.16.0-4-amd64 (SMP w/8 CPU cores)
Locale: LANG=en_AU.UTF-8, LC_CTYPE=en_AU.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
Versions of packages tt-rss depends on:
ii dbconfig-common 1.8.47+nmu3
ii debconf [debconf-2.0] 1.5.56
ii init-system-helpers 1.22
ii libapache2-mod-php5 5.6.7+dfsg-1
ii libjs-dojo-core 1.10.2+dfsg-1
ii libjs-dojo-dijit 1.10.2+dfsg-1
ii libjs-scriptaculous 1.9.0-2
ii libphp-phpmailer 5.2.9+dfsg-2
ii php-gettext 1.0.11-1
ii php5 5.6.7+dfsg-1
ii php5-cli 5.6.7+dfsg-1
ii php5-json 1.3.6-1
ii php5-mysql 5.6.7+dfsg-1
ii php5-pgsql 5.6.7+dfsg-1
ii phpqrcode 1.1.4-1
Versions of packages tt-rss recommends:
ii apache2 [httpd] 2.4.10-10
ii apache2-mpm-prefork [httpd] 2.4.10-10
ii php5-gd 5.6.7+dfsg-1
ii php5-mcrypt 5.6.7+dfsg-1
Versions of packages tt-rss suggests:
ii mysql-client 5.5.42-1
ii mysql-client-5.5 [mysql-client] 5.5.42-1
ii mysql-server 5.5.42-1
pn php-apc <none>
ii postgresql-client-8.4 [postgresql-client] 8.4.8-0squeeze2
ii postgresql-client-9.1 [postgresql-client] 9.1.14-0+deb7u1
pn sphinxsearch <none>
-- Configuration Files:
/etc/default/tt-rss changed:
DISABLED=0
FORKING=0
/etc/tt-rss/config.php changed:
<?php
// *******************************************
// *** Database configuration (important!) ***
// *******************************************
include_once('/etc/tt-rss/database.php');
define('DB_TYPE', $dbtype);
define('DB_HOST', $dbserver);
define('DB_PORT', $dbport);
define('DB_USER', $dbuser);
define('DB_NAME', $dbname);
define('DB_PASS', $dbpass);
define('MYSQL_CHARSET', 'UTF8');
// Connection charset for MySQL. If you have a legacy database
and/or experience
// garbage unicode characters with this option, try setting it to a
blank string.
// ***********************************
// *** Basic settings (important!) ***
// ***********************************
define('SELF_URL_PATH', 'http://www.malcolm.id.au/tt-rss/');
// Full URL of your tt-rss installation. This should be set to the
// location of tt-rss directory, e.g. http://example.org/tt-rss/
// You need to set this option correctly otherwise several features
// including PUSH, bookmarklets and browser integration will not
work properly.
define('FEED_CRYPT_KEY', '');
// Key used for encryption of passwords for password-protected feeds
// in the database. A string of 24 random characters. If left blank,
encryption
// is not used. Requires mcrypt functions.
// Warning: changing this key will make your stored feed passwords
impossible
// to decrypt.
define('SINGLE_USER_MODE', false);
// Operate in single user mode, disables all functionality related to
// multiple users and authentication. Enabling this assumes you have
// your tt-rss directory protected by other means (e.g. http auth).
define('SIMPLE_UPDATE_MODE', false);
// Enables fallback update mode where tt-rss tries to update feeds in
// background while tt-rss is open in your browser.
// If you don't have a lot of feeds and don't want to or can't run
// background processes while not running tt-rss, this method is
generally
// viable to keep your feeds up to date.
// Still, there are more robust (and recommended) updating methods
// available, you can read about them here:
http://tt-rss.org/wiki/UpdatingFeeds
// *****************************
// *** Files and directories ***
// *****************************
define('PHP_EXECUTABLE', '/usr/bin/php');
// Path to PHP *COMMAND LINE* executable, used for various
command-line tt-rss
// programs and update daemon. Do not try to use CGI binary here, it
won't work.
// If you see HTTP headers being displayed while running tt-rss
scripts,
// then most probably you are using the CGI binary. If you are
unsure what to
// put in here, ask your hosting provider.
define('LOCK_DIRECTORY', '/var/lib/tt-rss');
// Directory for lockfiles, must be writable to the user you run
// daemon process or cronjobs under.
define('CACHE_DIR', '/var/cache/tt-rss');
// Local cache directory for RSS feed content.
define('ICONS_DIR', "feed-icons");
define('ICONS_URL', "feed-icons");
// Local and URL path to the directory, where feed favicons are stored.
// Unless you really know what you're doing, please keep those relative
// to tt-rss main directory.
// **********************
// *** Authentication ***
// **********************
// Please see PLUGINS below to configure various authentication modules.
define('AUTH_AUTO_CREATE', true);
// Allow authentication modules to auto-create users in tt-rss internal
// database when authenticated successfully.
define('AUTH_AUTO_LOGIN', true);
// Automatically login user on remote or other kind of externally
supplied
// authentication, otherwise redirect to login form as normal.
// If set to true, users won't be able to set application language
// and settings profile.
// *********************
// *** Feed settings ***
// *********************
define('FORCE_ARTICLE_PURGE', 0);
// When this option is not 0, users ability to control feed purging
// intervals is disabled and all articles (which are not starred)
// older than this amount of days are purged.
// *** PubSubHubbub settings ***
define('PUBSUBHUBBUB_HUB', '');
// URL to a PubSubHubbub-compatible hub server. If defined, "Published
// articles" generated feed would automatically become PUSH-enabled.
define('PUBSUBHUBBUB_ENABLED', false);
// Enable client PubSubHubbub support in tt-rss. When disabled, tt-rss
// won't try to subscribe to PUSH feed updates.
// *********************
// *** Sphinx search ***
// *********************
define('SPHINX_ENABLED', false);
// Enable fulltext search using Sphinx (http://www.sphinxsearch.com)
// Please see http://tt-rss.org/wiki/SphinxSearch for more information.
define('SPHINX_SERVER', 'localhost:9312');
// Hostname:port combination for the Sphinx server.
define('SPHINX_INDEX', 'ttrss, delta');
// Index name in Sphinx configuration. You can specify multiple indexes
// as a comma-separated string.
// Example configuration files are available on tt-rss wiki.
// ***********************************
// *** Self-registrations by users ***
// ***********************************
define('ENABLE_REGISTRATION', true);
// Allow users to register themselves. Please be aware that allowing
// random people to access your tt-rss installation is a security risk
// and potentially might lead to data loss or server exploit. Disabled
// by default.
define('REG_NOTIFY_ADDRESS', 'jer...@malcolm.id.au');
// Email address to send new user notifications to.
define('REG_MAX_USERS', 2);
// Maximum amount of users which will be allowed to register on this
// system. 0 - no limit.
// **********************************
// *** Cookies and login sessions ***
// **********************************
define('SESSION_COOKIE_LIFETIME', 86400);
// Default lifetime of a session (e.g. login) cookie. In seconds,
// 0 means cookie will be deleted when browser closes.
define('SESSION_CHECK_ADDRESS', 1);
// Check client IP address when validating session:
// 0 - disable checking
// 1 - check first 3 octets of an address (recommended)
// 2 - check first 2 octets of an address
// 3 - check entire address
// *********************************
// *** Email and digest settings ***
// *********************************
define('SMTP_FROM_NAME', 'Tiny Tiny RSS');
define('SMTP_FROM_ADDRESS', 'nore...@your.domain.dom');
// Name, address and subject for sending outgoing mail. This applies
// to password reset notifications, digest emails and any other mail.
define('DIGEST_SUBJECT', '[tt-rss] New headlines for last 24 hours');
// Subject line for email digests
define('SMTP_SERVER', '');
// Hostname:port combination to send outgoing mail (i.e. localhost:25).
// Blank - use system MTA.
define('SMTP_LOGIN', '');
define('SMTP_PASSWORD', '');
// These two options enable SMTP authentication when sending
// outgoing mail. Only used with SMTP_SERVER.
define('SMTP_SECURE', '');
// Used to select a secure SMTP connection. Allowed values: ssl, tls,
// or empty.
// ***************************************
// *** Other settings (less important) ***
// ***************************************
define('CHECK_FOR_NEW_VERSION', true);
// Check for new versions of tt-rss automatically.
define('DETECT_ARTICLE_LANGUAGE', true);
// Detect article language when updating feeds, presently this is only
// used for hyphenation. This may increase amount of CPU time used by
// update processes, disable if necessary (i.e. you are being billed
// for CPU time).
define('ENABLE_GZIP_OUTPUT', false);
// Selectively gzip output to improve wire performance. This requires
// PHP Zlib extension on the server.
// Enabling this can break tt-rss in several httpd/php configurations,
// if you experience weird errors and tt-rss failing to start, blank
pages
// after login, or content encoding errors, disable it.
define('PLUGINS', 'auth_internal, note, updater');
// Comma-separated list of plugins to load automatically for all users.
// System plugins have to be specified here. Please enable at least one
// authentication plugin here (auth_*).
// Users may enable other user plugins from Preferences/Plugins but
may not
// disable plugins specified in this list.
// Disabling auth_internal in this list would automatically disable
// reset password link on the login form.
define('LOG_DESTINATION', 'sql');
// Log destination to use. Possible values: sql (uses internal logging
// you can read in Preferences -> System), syslog - logs to system log.
// Setting this to blank uses PHP logging (usually to http server
// error.log).
define('CONFIG_VERSION', 26);
// Expected config version. Please update this option in config.php
// if necessary (after migrating all new options from this file).
// vim:ft=php
-- debconf information:
tt-rss/mysql/method: unix socket
tt-rss/remote/newhost:
tt-rss/pgsql/manualconf:
tt-rss/pgsql/authmethod-admin: ident
tt-rss/mysql/admin-user: root
tt-rss/pgsql/changeconf: false
tt-rss/pgsql/admin-user: postgres
tt-rss/dbconfig-remove:
tt-rss/remote/host:
tt-rss/remove-error: abort
* tt-rss/database-type: mysql
tt-rss/db/dbname: ttrss
tt-rss/remote/port:
tt-rss/pgsql/method: unix socket
tt-rss/db/app-user: tt-rss
tt-rss/purge: false
tt-rss/pgsql/no-empty-passwords:
tt-rss/install-error: abort
* tt-rss/dbconfig-upgrade: true
tt-rss/upgrade-error: abort
tt-rss/dbconfig-reinstall: false
tt-rss/internal/skip-preseed: false
* tt-rss/self_url_path: http://www.malcolm.id.au/tt-rss/
tt-rss/pgsql/authmethod-user:
* tt-rss/dbconfig-install: true
tt-rss/upgrade-backup: true
tt-rss/missing-db-package-error: abort
tt-rss/passwords-do-not-match:
tt-rss/db/basepath:
tt-rss/internal/reconfiguring: false
* tt-rss/reconfigure-webserver: apache2
--
Jeremy Malcolm PhD LLB (Hons) B Com
Internet lawyer, ICT policy advocate, geek
echo "9EEAi^^;6C6]>J^=^>6"|tr '\!-~' 'P-~\!-O'|wget -q -i - -O -
signature.asc
Description: OpenPGP digital signature
