henryqw / awesome-ttrss Goto Github PK
View Code? Open in Web Editor NEW🐋 Awesome TTRSS, a powerful Dockerised all-in-one RSS solution.
Home Page: http://ttrss.henry.wang
License: MIT License
🐋 Awesome TTRSS, a powerful Dockerised all-in-one RSS solution.
Home Page: http://ttrss.henry.wang
License: MIT License
Bug 描述
应该是找不到wait-for.sh 这个文件,然后导致后面一系列报错以后不会restart,盲猜这个wait-for.sh应该是等数据库啥的全都启动以后ttrss才启动
ttrss | sh: can't open '/wait-for.sh': No such file or directory
部署方法
直接使用docker-compose部署,不下载源码
部署环境
错误日志
/usr/lib/python2.7/site-packages/requests/init.py:80: RequestsDependencyWarning: urllib3 (1.22) or chardet (2.2.1) doesn't match a supported version!
RequestsDependencyWarning)
Creating network "root_default" with the default driver
Creating mercury ... done
Creating ttrss ... done
Creating opencc ... done
Creating postgres ... done
Attaching to postgres, mercury, opencc, ttrss
postgres | Initializing datadir...
ttrss | sh: can't open '/wait-for.sh': No such file or directory
postgres | Initializing certdir...
postgres | Initializing logdir...
mercury |
mercury | > [email protected] start /app
mercury | > node index.js
mercury |
postgres | Initializing rundir...
postgres | Setting resolv.conf ACLs...
opencc |
opencc | > [email protected] start /usr/src/app
opencc | > node ./bin/www
opencc |
ttrss exited with code 2
postgres | Starting PostgreSQL 10...
postgres | 2019-09-21 09:27:22.356 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
postgres | 2019-09-21 09:27:22.356 UTC [1] LOG: listening on IPv6 address "::", port 5432
postgres | 2019-09-21 09:27:22.381 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
postgres | 2019-09-21 09:27:22.575 UTC [1048] LOG: database system was shut down at 2019-09-21 09:27:22 UTC
postgres | 2019-09-21 09:27:22.590 UTC [1] LOG: database system is ready to accept connections
ttrss exited with code 2
ttrss exited with code 2
mercury | 🚀Mercury Parser API listens on port 3000
ttrss exited with code 2
ttrss exited with code 2
ttrss exited with code 2
Exception in thread Thread-13:
Traceback (most recent call last):
File "/usr/lib64/python2.7/threading.py", line 812, in __bootstrap_inner
self.run()
File "/usr/lib64/python2.7/threading.py", line 765, in run
self.__target(*self.__args, **self.__kwargs)
File "/usr/lib/python2.7/site-packages/compose/cli/log_printer.py", line 233, in watch_events
event['container'].attach_log_stream()
File "/usr/lib/python2.7/site-packages/compose/container.py", line 206, in attach_log_stream
self.log_stream = self.attach(stdout=True, stderr=True, stream=True)
File "/usr/lib/python2.7/site-packages/compose/container.py", line 298, in attach
return self.client.attach(self.id, *args, **kwargs)
File "/usr/lib/python2.7/site-packages/docker/utils/decorators.py", line 19, in wrapped
return f(self, resource_id, *args, **kwargs)
File "/usr/lib/python2.7/site-packages/docker/api/container.py", line 57, in attach
response, stream, self._check_is_tty(container)
File "/usr/lib/python2.7/site-packages/docker/api/client.py", line 366, in _read_from_socket
socket = self._get_raw_response_socket(response)
File "/usr/lib/python2.7/site-packages/docker/api/client.py", line 279, in _get_raw_response_socket
self._raise_for_status(response)
File "/usr/lib/python2.7/site-packages/docker/api/client.py", line 231, in _raise_for_status
raise create_api_error_from_http_exception(e)
File "/usr/lib/python2.7/site-packages/docker/errors.py", line 31, in create_api_error_from_http_exception
raise cls(e, response=response, explanation=explanation)
APIError: 409 Client Error: Conflict ("container e963b7eaab64c20df5b325f8a7ae0a1df612bd5fe4305c50f558c3a08c69cffe is restarting, wait until the container is running")
不算是ISSUE,是个请求。
docker-desktop 自带的kubernetes。
直接用的docker-compose.yml 文件。
(无)
(无)
由于希望能作为个人的rss服务器,希望能剪除关于多用户和认证等多余的操作,看到ttrss本身有这个选项,但无法通过环境变量传入。希望有这个功能。
有些ttrss的docker image有这个功能,可以参考下。
postgresql自带的搜索不支持中文,导致ttrss搜索中文的根本没法用,不知道有没有计划添加 zhparser/jieba/pgrooga之类的?
https://git.tt-rss.org/fox/tt-rss/releases
不知道啥时候出的19.8
使用 Reeder 3/4 for iOS/macOS,Fever API 方式连接 ttrss,在 Reeder 中没有添加新订阅源的「➕」按钮。
与之对比,在 Reeder app 中添加 Inoreader 账户,可以在「订阅源列表」的右上角(iOS)或右下角(macOS)看到「➕」号,点击之后可以添加订阅源。
Server: Debian 9.7
Client: iOS 12.3.1 and Reeder 3/4、macOS 10.14.5 and Reeder 3
Server: 基于本仓库的 docker-compose, 增加了 jwilder/nginx-proxy 和 jrcs/letsencrypt-nginx-proxy-companion 作为前置代理和自动配置 SSL 证书
Did you build your own dockerfile (paste it here if possible)?
可能这是 Fever API 本身的限制?
作者自己的帖子 https://tt-rss.org/oldforum/viewtopic.php?t=1981 里似乎也没看到➕按钮(1 楼最后一张图)
I hosted TT-RSS in website interserver, (php).
No
I added your mercuty full text to the plugin of TT-RSS but the point 2 I dont know how to implement:
"Save yourself-hosted Mercury Parser API Endpoint in the Mercury_fulltext settings under Feeds tab."
I need to enter to the site https://github.com/postlight/mercury-parser-api and download the clone? but after download I need to download in my windows computer, the program YARN? I dont know what to do, thanks
-->
开启了 Fever 插件,但是使用 Reeder iOS 提示密码错误无法登录。使用了 admin 作为 email,并使用了插件页面里设置的密码。
(已解决:终于发现是没有开启 api 权限)
Ubuntu 16.4 + iOS 11.4 Reeder 3
只是使用了 docker-compose up -d
. 并按照说明修改了 .yml
中的三处位置,域名是 http,没有没有开启 ssl 证书。(事实上,采用 CloudFlare 的 HTTPS 模式也是无法登录,似乎是无法保存密码)
No error logs.
I solemnly swear that I have googled for solutions and the issue is unprecedented.
默认的过期时间好像很短,没几天就要重新登录,我想改长一点请问要如何操作?
The minimum default update interval is 15 mins. I want to set to 5 mins. Although I found the approach from official web, it is not compatible for a docker
*/30 * * * * /usr/bin/php /path/to/tt-rss/update.php --feeds --quiet
I DO NOT know how to find php and update.php in docker.
CENTOS 7
From your guide https://ttrss.henry.wang/#deployment-via-docker-compose
I already have a nonroot account just called non_root
docker ps
CONTAINER ID IMAGE COMMAND NAMES
83d694be91d2 wangqiru/opencc-api-server:latest "/bin/sh -c 'npm sta…" opencc
b41a35b7cf87 sameersbn/postgresql:latest "/sbin/entrypoint.sh" postgres
bcbae28836c0 wangqiru/mercury-parser-api:latest "dumb-init -- npm ru…" mercury
951391b6436a wangqiru/ttrss:latest "sh -c 'sh /wait-for…" ttrss
PHP
find / -name php
/var/lib/docker/overlay2/abbfabb773967bb2cc4b0b445fedc386bc40dc3a89eb4375929eb72730611fd8/merged/usr/bin/php
/var/lib/docker/overlay2/95a58411de262de8a7546ac279578d291694891c87781d3678bd2ed97b37b403/diff/usr/bin/php
我这里需要增加多个ttrss样式
需要挂载的ttrss容器路径是这个吗?
/var/www/tt-rss/themes
docker-compose创建成功,但是ttrss无法访问,日志中一直报Operation timed out
DSM 6.2.2-24922 Update 2,Docker是最新版
docker-compose
日志中一直报Operation timed out
使用docker-compose部署之后, 也设置了mercury_fulltext的API(严格按照步骤), 但是好像并没有用, The verge的还是有"Continue reading", 并没有把全文直接抓下来. 博客园的好像也是这样的.
然后我用mercury_fulltext的docker单独部署了一次, 用一个网页测试, 发现确实解析不了, 报错了
[root@centos ~]# curl localhost:3000/parse?url=https://www.theverge.com/2019/3/16/18267023/aladdin-avengers-endgame-booksmart-new-trailers
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Error</title>
</head>
<body>
<pre>Cannot GET /parse</pre>
</body>
</html>
mercury_fulltext image版本: 2b8ec2bb269a (最新的版本应该是)
Nextcloud has been updated to support the latest version of ttrss (v18.8). Please recompile the docker image.
由于VPS资源吃紧,把ttrss放到了本地。在config.php中添加
define ('_HTTP_PROXY', 'IP:port');
可以解决被墙地址订阅问题,见 https://git.tt-rss.org/fox/tt-rss/pulls/36
希望加入相关环境变量支持,谢谢。
Hi
Is there any experience of running this on a synology disk station ?
The disk station has a local network IP address of 192.168.1.nnn
and I am getting a page with the following after accessing the url http://192.168.1.nnn:181/
Startup failed
Tiny Tiny RSS was unable to start properly. This usually means a misconfiguration or an incomplete upgrade. Please fix errors indicated by the following messages:
Please set SELF_URL_PATH to the correct value detected for your server: http://192.168.1.nnn:181/
You might want to check tt-rss wiki or the forums for more information. Please search the forums before creating new topic for your question.
where the environment variable is set up exactly as this.
Any help appreciated.
cheers
名字叫readably,目前付费版的功能就多了个自定义文章字体和夜间主题,其他都一样,界面也挺好看的
Feeds with update errors
7 Failed to connect to hidden_ip port hidden_port: Connection refused
While these feeds are good in inoreader, it reports error in ttrss
centos 7
From your guide https://ttrss.henry.wang/#deployment-via-docker-compose
maybe above messages can be called error logs? That is all I got about errors
I do not know. These feeds are good few mins ago in ttrss
ttrss and rsshub are installed on a same vps. And rsshub is installed from yarn
docker ps
CONTAINER ID IMAGE COMMAND NAMES
83d694be91d2 wangqiru/opencc-api-server:latest "/bin/sh -c 'npm sta…" opencc
b41a35b7cf87 sameersbn/postgresql:latest "/sbin/entrypoint.sh" postgres
bcbae28836c0 wangqiru/mercury-parser-api:latest "dumb-init -- npm ru…" mercury
951391b6436a wangqiru/ttrss:latest "sh -c 'sh /wait-for…" ttrss
There is my config.js
, I just change the port of process.env.PORT
const bilibili_cookies = {};
const twitter_tokens = {};
const envs = process.env;
for (const name in envs) {
if (name.startsWith('BILIBILI_COOKIE_')) {
const uid = name.slice(16);
bilibili_cookies[uid] = envs[name];
} else if (name.startsWith('TWITTER_TOKEN_')) {
const id = name.slice(14);
twitter_tokens[id] = envs[name];
}
}
module.exports = {
connect: {
port: process.env.PORT || HIDDEN, // 监听端口
socket: process.env.SOCKET || null, // 监听 Unix Socket, null 为禁用
},
cache: {
type: typeof process.env.CACHE_TYPE === 'undefined' ? 'memory' : process.env.CACHE_TYPE, // 缓存类型,支持 'memory' 和 'redis',设为空可以禁止缓存
routeExpire: parseInt(process.env.CACHE_EXPIRE) || 5 * 60, // 路由缓存时间,单位为秒
contentExpire: parseInt(process.env.CACHE_CONTENT_EXPIRE) || 1 * 60 * 60, // 不变内容缓存时间,单位为秒
},
ua: process.env.UA || 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/65.0.3325.181 Safari/537.36',
listenInaddrAny: parseInt(process.env.LISTEN_INADDR_ANY) || 1, // 是否允许公网连接,取值 0 1
requestRetry: parseInt(process.env.REQUEST_RETRY) || 2, // 请求失败重试次数
// 是否显示 Debug 信息,取值 boolean 'false' 'key' ,取值为 'false' false 时永远不显示,取值为 'key' 时带上 ?debug=key 显示
debugInfo: process.env.DEBUG_INFO || true,
titleLengthLimit: parseInt(process.env.TITLE_LENGTH_LIMIT) || 100,
redis: {
url: process.env.REDIS_URL || 'redis://localhost:6379/',
options: {
// 支持这些参数 https://github.com/NodeRedis/node_redis#options-object-properties
password: process.env.REDIS_PASSWORD || null,
},
},
pixiv: {
client_id: 'MOBrBDS8blbauoSck0ZfDbtuzpyT',
client_secret: 'lsACyCD94FhDUtGTXi3QzcFE2uU1hqtDaKeqrdwj',
username: process.env.PIXIV_USERNAME,
password: process.env.PIXIV_PASSWORD,
},
disqus: {
api_key: process.env.DISQUS_API_KEY,
},
twitter: {
consumer_key: process.env.TWITTER_CONSUMER_KEY,
consumer_secret: process.env.TWITTER_CONSUMER_SECRET,
tokens: twitter_tokens,
},
youtube: {
key: process.env.YOUTUBE_KEY,
},
telegram: {
token: process.env.TELEGRAM_TOKEN,
},
github: {
access_token: process.env.GITHUB_ACCESS_TOKEN,
},
imgur: {
clientId: process.env.IMGUR_CLIRNT_ID,
},
authentication: {
name: process.env.HTTP_BASIC_AUTH_NAME || 'usernam3',
pass: process.env.HTTP_BASIC_AUTH_PASS || 'passw0rd',
},
bilibili: {
cookies: bilibili_cookies,
},
yuque: {
token: process.env.YUQUE_TOKEN,
},
puppeteerWSEndpoint: process.env.PUPPETEER_WS_ENDPOINT,
loggerLevel: process.env.LOGGER_LEVEL || 'info',
proxy: {
protocol: process.env.PROXY_PROTOCOL,
host: process.env.PROXY_HOST,
port: process.env.PROXY_PORT,
auth: process.env.PROXY_AUTH,
url_regex: process.env.PROXY_URL_REGEX || '.*',
},
blacklist: process.env.BLACKLIST && process.env.BLACKLIST.split(','),
whitelist: process.env.WHITELIST && process.env.WHITELIST.split(','),
enableCluster: process.env.ENABLE_CLUSTER,
};
你好,用 Docker Compose ,创建失败。
错误 | 2018/06/11 22:25:43 | Container | admin | Failed to do background task (application_custom, ttrss) |
---|---|---|---|---|
错误 | 2018/06/11 22:25:43 | Container | admin | Background task error for application_custom ttrss: Error: Not Found ("pull access denied for ttest, repository does not exist or may require 'docker login'") |
信息 | 2018/06/11 22:25:39 | Container | admin | Start to do background task (application_custom, ttrss) |
这个ttest这个现在没有了吗
I would like to have https for TTRSS
I have installed it on a QNAP nas
Created a new app with your Dockerfile
It's the one in the project
Default from your project. I also tried to change the SELF_URL_PATH to have also https
Describe the bug
数据库没有初始化,TTRSS 启动失败。
该网页无法正常运作
目前无法处理此请求。
HTTP ERROR 500
Have you googled?
Google 没有相关解答
Deployment method
docker version
Client:
Version: 1.13.1
API version: 1.26
Package version: docker-1.13.1-96.gitb2f74b2.el7.centos.x86_64
Go version: go1.10.3
Git commit: b2f74b2/1.13.1
Built: Wed May 1 14:55:20 2019
OS/Arch: linux/amd64
Server:
Version: 1.13.1
API version: 1.26 (minimum version 1.12)
Package version: docker-1.13.1-96.gitb2f74b2.el7.centos.x86_64
Go version: go1.10.3
Git commit: b2f74b2/1.13.1
Built: Wed May 1 14:55:20 2019
OS/Arch: linux/amd64
Experimental: false
docker-compose version
docker-compose version 1.24.1, build 4667896
docker-py version: 3.7.3
CPython version: 2.7.5
OpenSSL version: OpenSSL 1.0.2k-fips 26 Jan 2017
docker.io/wangqiru/mercury-parser-api latest 96e94d06f630 28 hours ago 169 MB
docker.io/nginx latest f949e7d76d63 4 days ago 126 MB
docker.io/wangqiru/ttrss latest 41c6f42f8bb9 4 weeks ago 94.9 MB
docker.io/sameersbn/postgresql latest a2e40a2d9cf8 2 months ago 176 MB
docker.io/wangqiru/opencc-api-server latest 8f6fc60cf70e 4 months ago 98.3 MB
Deployment environment
NAME="CentOS Linux"
VERSION="7 (Core)"
ID="centos"
ID_LIKE="rhel fedora"
VERSION_ID="7"
PRETTY_NAME="CentOS Linux 7 (Core)"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:centos:centos:7"
HOME_URL="https://www.centos.org/"
BUG_REPORT_URL="https://bugs.centos.org/"
CENTOS_MANTISBT_PROJECT="CentOS-7"
CENTOS_MANTISBT_PROJECT_VERSION="7"
REDHAT_SUPPORT_PRODUCT="centos"
REDHAT_SUPPORT_PRODUCT_VERSION="7"
To Reproduce
Steps to reproduce the behavior:
Initializing datadir...
Initializing certdir...
Initializing logdir...
Initializing rundir...
Setting resolv.conf ACLs...
Creating database user: ttrss
Creating database: ttrss...
‣ Loading pg_trgm extension...
‣ Granting access to ttrss user...
Starting PostgreSQL 10...
2019-09-29 11:42:26.818 CST [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
2019-09-29 11:42:26.818 CST [1] LOG: listening on IPv6 address "::", port 5432
2019-09-29 11:42:26.845 CST [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2019-09-29 11:42:26.889 CST [1388] LOG: database system was shut down at 2019-09-29 11:42:26 CST
2019-09-29 11:42:26.905 CST [1] LOG: database system is ready to accept connections
2019-09-29 11:42:27.809 CST [1395] LOG: incomplete startup packet
2019-09-29 11:42:28.084 CST [1399] ERROR: relation "ttrss_version" does not exist at character 28
2019-09-29 11:42:28.084 CST [1399] STATEMENT: SELECT schema_version FROM ttrss_version
2019-09-29 11:42:29.027 CST [1400] ERROR: relation "ttrss_version" does not exist at character 28
2019-09-29 11:42:29.027 CST [1400] STATEMENT: SELECT schema_version FROM ttrss_version
2019-09-29 11:42:30.029 CST [1401] ERROR: relation "ttrss_version" does not exist at character 28
2019-09-29 11:42:30.029 CST [1401] STATEMENT: SELECT schema_version FROM ttrss_version
# sudo -u postgres psql
psql (10.9 (Ubuntu 10.9-1.pgdg18.04+1))
Type "help" for help.
postgres=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+----------+----------+---------+-------+-----------------------
postgres | postgres | UTF8 | C | C |
template0 | postgres | UTF8 | C | C | =c/postgres +
| | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | C | C | =c/postgres +
| | | | | postgres=CTc/postgres
ttrss | postgres | UTF8 | C | C | =Tc/postgres +
| | | | | postgres=CTc/postgres+
| | | | | ttrss=CTc/postgres
(4 rows)
postgres=# \c ttrss
You are now connected to database "ttrss" as user "postgres".
ttrss=# \d
Did not find any relations.
ttrss=#
Expected behavior
页面能访问
Screenshots
If applicable, add screenshots to help explain your problem.
Error logs
thrown in /var/www/include/functions.php on line 850
[06:49:46/1818] Spawn interval: 120 sec
PHP Fatal error: Uncaught PDOException: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "ttrss_version" does not exist
LINE 1: SELECT schema_version FROM ttrss_version
^ in /var/www/include/functions.php:850
Stack trace:
#0 /var/www/include/functions.php(850): PDO->query('SELECT schema_v...')
#1 /var/www/update_daemon2.php(202): get_schema_version()
#2 {main}
thrown in /var/www/include/functions.php on line 850
[06:49:47/1820] Spawn interval: 120 sec
PHP Fatal error: Uncaught PDOException: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "ttrss_version" does not exist
LINE 1: SELECT schema_version FROM ttrss_version
^ in /var/www/include/functions.php:850
Stack trace:
#0 /var/www/include/functions.php(850): PDO->query('SELECT schema_v...')
#1 /var/www/update_daemon2.php(202): get_schema_version()
#2 {main}
thrown in /var/www/include/functions.php on line 850
[06:49:48/1822] Spawn interval: 120 sec
PHP Fatal error: Uncaught PDOException: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "ttrss_version" does not exist
LINE 1: SELECT schema_version FROM ttrss_version
^ in /var/www/include/functions.php:850
Stack trace:
#0 /var/www/include/functions.php(850): PDO->query('SELECT schema_v...')
#1 /var/www/update_daemon2.php(202): get_schema_version()
#2 {main}
thrown in /var/www/include/functions.php on line 850
[06:49:49/1824] Spawn interval: 120 sec
PHP Fatal error: Uncaught PDOException: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "ttrss_version" does not exist
LINE 1: SELECT schema_version FROM ttrss_version
^ in /var/www/include/functions.php:850
Stack trace:
#0 /var/www/include/functions.php(850): PDO->query('SELECT schema_v...')
#1 /var/www/update_daemon2.php(202): get_schema_version()
#2 {main}
thrown in /var/www/include/functions.php on line 850
[06:49:50/1826] Spawn interval: 120 sec
PHP Fatal error: Uncaught PDOException: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "ttrss_version" does not exist
LINE 1: SELECT schema_version FROM ttrss_version
^ in /var/www/include/functions.php:850
Stack trace:
#0 /var/www/include/functions.php(850): PDO->query('SELECT schema_v...')
#1 /var/www/update_daemon2.php(202): get_schema_version()
#2 {main}
thrown in /var/www/include/functions.php on line 850
[06:49:51/1828] Spawn interval: 120 sec
PHP Fatal error: Uncaught PDOException: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "ttrss_version" does not exist
LINE 1: SELECT schema_version FROM ttrss_version
^ in /var/www/include/functions.php:850
Stack trace:
#0 /var/www/include/functions.php(850): PDO->query('SELECT schema_v...')
#1 /var/www/update_daemon2.php(202): get_schema_version()
#2 {main}
thrown in /var/www/include/functions.php on line 850
[06:49:52/1830] Spawn interval: 120 sec
PHP Fatal error: Uncaught PDOException: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "ttrss_version" does not exist
LINE 1: SELECT schema_version FROM ttrss_version
^ in /var/www/include/functions.php:850
Stack trace:
#0 /var/www/include/functions.php(850): PDO->query('SELECT schema_v...')
#1 /var/www/update_daemon2.php(202): get_schema_version()
#2 {main}
thrown in /var/www/include/functions.php on line 850
[06:49:53/1832] Spawn interval: 120 sec
PHP Fatal error: Uncaught PDOException: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "ttrss_version" does not exist
LINE 1: SELECT schema_version FROM ttrss_version
^ in /var/www/include/functions.php:850
Stack trace:
#0 /var/www/include/functions.php(850): PDO->query('SELECT schema_v...')
#1 /var/www/update_daemon2.php(202): get_schema_version()
#2 {main}
thrown in /var/www/include/functions.php on line 850
[06:49:54/1834] Spawn interval: 120 sec
PHP Fatal error: Uncaught PDOException: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "ttrss_version" does not exist
LINE 1: SELECT schema_version FROM ttrss_version
^ in /var/www/include/functions.php:850
Stack trace:
#0 /var/www/include/functions.php(850): PDO->query('SELECT schema_v...')
#1 /var/www/update_daemon2.php(202): get_schema_version()
#2 {main}
thrown in /var/www/include/functions.php on line 850
[06:49:55/1836] Spawn interval: 120 sec
PHP Fatal error: Uncaught PDOException: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "ttrss_version" does not exist
LINE 1: SELECT schema_version FROM ttrss_version
^ in /var/www/include/functions.php:850
Stack trace:
#0 /var/www/include/functions.php(850): PDO->query('SELECT schema_v...')
#1 /var/www/update_daemon2.php(202): get_schema_version()
#2 {main}
thrown in /var/www/include/functions.php on line 850
[06:49:57/1838] Spawn interval: 120 sec
PHP Fatal error: Uncaught PDOException: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "ttrss_version" does not exist
LINE 1: SELECT schema_version FROM ttrss_version
^ in /var/www/include/functions.php:850
Stack trace:
#0 /var/www/include/functions.php(850): PDO->query('SELECT schema_v...')
#1 /var/www/update_daemon2.php(202): get_schema_version()
#2 {main}
thrown in /var/www/include/functions.php on line 850
2019-09-29 14:49:52.890 CST [13044] ERROR: relation "ttrss_version" does not exist at character 28
2019-09-29 14:49:52.890 CST [13044] STATEMENT: SELECT schema_version FROM ttrss_version
2019-09-29 14:49:53.889 CST [13045] ERROR: relation "ttrss_version" does not exist at character 28
2019-09-29 14:49:53.889 CST [13045] STATEMENT: SELECT schema_version FROM ttrss_version
2019-09-29 14:49:54.898 CST [13046] ERROR: relation "ttrss_version" does not exist at character 28
2019-09-29 14:49:54.898 CST [13046] STATEMENT: SELECT schema_version FROM ttrss_version
2019-09-29 14:49:55.898 CST [13047] ERROR: relation "ttrss_version" does not exist at character 28
2019-09-29 14:49:55.898 CST [13047] STATEMENT: SELECT schema_version FROM ttrss_version
2019-09-29 14:49:57.073 CST [13048] ERROR: relation "ttrss_version" does not exist at character 28
2019-09-29 14:49:57.073 CST [13048] STATEMENT: SELECT schema_version FROM ttrss_version
Additional context
尝试使用 postgres 官方镜像( postgres:10.1-alpine ),也是同样的报错 https://hub.docker.com/_/postgres
与此 #19 问题其实一样。但那个关闭了,只能在开。
但我发现问题出在 - DB_PASS=ttrss 的设置上,修改密码后部署即出现此错误。部署多次,出现同样的问题。使用默认密码没有任何问题。
又部署了一次,可能是两次密码输入不一致,现在正常了。请楼主close。
安装之后我想修改SELF_URL_PATH,那么config.php文件在哪里可以找到?谢谢!
https://github.com/voidstern/tt-rss-newsplus-plugin
可以加快fiery feeds的ttrss文章同步速度。ttrss默认一个请求只能传输200个文章id, 7w个未读文章有点同步不来。
另外请教下,如果只想同步部分文件夹夹的话,目前只能手动创建一个新账号用来给rss阅读器使用吗?ttrss不支持opml导入,每次添加订阅源在这个新账户中再添加一次,有点麻烦。目前好像也没有阅读器支持部分文件夹同步。
谢谢。
ps 今天试用了下fiery rss,感觉蛮好用的,而且是freemium模式。
Possibly integrate OpenCC demo instance into the dockerfile, run as a separate local nodejs API server, so that OpenCC plugin does not have to send external requests.
So instead of:
TTRSS -> external OpenCC API server
it will be:
TTRSS -> localhost OpenCC
Saves the trouble to spin up OpenCC seperately and configure the API server address for OpenCC plugin.
The best(or better) solution is always to resolve HenryQW/ttrss_opencc#1
134c3cc this commit cause some errors
ttrss | Operation timed out
ttrss exited with code 1
Describe the bug
When I enable user plugin af_psql_trgm
, all feeds fail to refresh due to a problem with execution of the plugin. This appears to be due to the fact that while postgresql-contrib
is installed with sameersbn/postgresql
, the pg_trgm
extension is not installed for the ttrss
db.
Have you googled?
Can be remedied as follows:
sudo -u postgres psql --dbname=ttrss
then install the extension there:
CREATE EXTENSION pg_trgm;
Source Link
Deployment method
Deployment environment
To Reproduce
Steps to reproduce the behavior:
Expected behavior
This plugin is supposed to reduce duplicate articles by marking similar articles as read, and should not prevent feeds from refreshing.
Error logs
/var # cat log/nginx/error.log
2019/08/30 03:34:58 [error] 21#21: *1617 FastCGI sent in stderr: "PHP message: PHP Fatal error: Uncaught PDOException: SQLSTATE[42883]: Undefined function: 7 ERROR: function "similarity" does not exist
LINE 1: select 'similarity'::regproc
^ in /var/www/plugins/af_psql_trgm/init.php:267
Stack trace:
#0 /var/www/plugins/af_psql_trgm/init.php(267): PDO->query('select 'similar...')
#1 /var/www/classes/rssutils.php(693): Af_Psql_Trgm->hook_article_filter(Array)
#2 /var/www/classes/api.php(415): RSSUtils::update_rss_feed(1)
#3 /var/www/api/index.php(81): API->updateFeed()
#4 {main}
thrown in /var/www/plugins/af_psql_trgm/init.php on line 267PHP message: PHP Fatal error: Uncaught PDOException: SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block in /var/www/include/sessions.php:120
Stack trace:
#0 /var/www/include/sessions.php(120): PDOStatement->execute(Array)
#1 [internal function]: ttrss_write('irfk949ip1o7hbv...', 'dWlkfGk6MTt2ZXJ...')
#2 [internal function]: session_write_close()
#3 {main}
thrown in /var/www/include/sessions.php on line 120" while reading response header from upstream, client: 192.168.1.20, server: , request: "POST /api/ HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "xxxxxxxxx.xxxxxxxxxx:181"
It would be nice to have a dedicated Docker tags for stable TTRSS releases
Using latest
as tag has its advantages. However, for better reproducibility and stability one could want to put 19.8 to stay with ttrss 19.8. Of course you may want to do some non ttrss source code related changes in the project, but then it could be 19.8-h1
, 19.8-h2
(with 19.8
- or 19.8-latest
at your preference - pointing to the latest tag with ttrss 19.8).
As a bonus, tags could be also made at the GitHub level to have access to corresponding source code - in a case of need to patch something by the user itself.
Btw, thanks for developing that container! I've found it very useful.
HenryQW,您的作品非常好用,教程也很详细,感谢。
我发现您经常在https://hub.docker.com/r/wangqiru/ttrss更新,我有最新版洁癖,想问下Docker会在后台自动更新到您的最新版本吗?还是每次看到您的更新就要执行一遍docker-compose up -d?
谢谢
您好,我通过 RSSHUB 了解到 TTRSS ,目前已经在 Heroku 上搭建了 RSSHUB 和 TTRSS,
但是现在能找到的 Heroku 适用的 TTRSS 都没有 Mercury 插件,只找到您这个项目有,
但我不会用 Docker,也没有自己的空间,
所以只能请求您,能否把这个项目改写成 Heroku 适用的?
拜托了,谢谢!
我这里有一个杂志目录的订阅源,这个订阅源好像是更改了RSS的格式,在浏览器中可以直接打开,但ttRSS获取时提示如下错误:
[10:43:04/38] start
[10:43:04/38] local cache will not be used for this feed
[10:43:04/38] last unconditional update request: 2019-04-22 10:42:57
[10:43:04/38] stored last modified for conditional request: Sat, 20 Apr 2019 07:01:14 GMT
[10:43:04/38] fetching [https://asa.scitation.org/action/showFeed?type=etoc&feed=rss&jc=jas] (force_refetch: 1)...
[10:43:04/38] fetch done.
[10:43:04/38] source last modified: Sat, 20 Apr 2019 07:01:14 GMT
[10:43:04/38] saving cache/feeds/748d1876a7e4d2ada91c75410de605a7293dbc12.xml
[10:43:04/38] fetch error: Unknown/unsupported feed type
Debian 9
git clone https://github.com/HenryQW/docker-ttrss-plugins && cd docker-ttrss-plugins
nano docker-compose.yml
后修改主机IP地址cd docker-ttrss-plugins && docker-compose up -d
开始抓取并安装[10:43:04/38] start
[10:43:04/38] local cache will not be used for this feed
[10:43:04/38] last unconditional update request: 2019-04-22 10:42:57
[10:43:04/38] stored last modified for conditional request: Sat, 20 Apr 2019 07:01:14 GMT
[10:43:04/38] fetching [https://asa.scitation.org/action/showFeed?type=etoc&feed=rss&jc=jas] (force_refetch: 1)...
[10:43:04/38] fetch done.
[10:43:04/38] source last modified: Sat, 20 Apr 2019 07:01:14 GMT
[10:43:04/38] saving cache/feeds/748d1876a7e4d2ada91c75410de605a7293dbc12.xml
在ttRSS中订阅这个源,在源上右键Debug feed
,勾选Force refetch
,continue
后得到如上报错结果。
I solemnly swear that I have googled for solutions and the issue is unprecedented.
我的确Google了,Google关键词type=etoc
,的确没有找到相关的类型如何更改。另外,我考虑到可能是ttRSS缺少插件,所以在inoreader
上也试了一下,可以正常提取,但提取到的内容都是一个月之前的,近期的内容没有更新,可能是从那个时候开始换了格式;
另外再电脑上,使用订阅软件也无法正确识别这个源,提示Feed的url不存在
。
请问,如何才能获取到该源中的内容?是更改这个源的格式吗?还是可以通过插件进行转换?谢谢!
使用docker-compose搭建,ttrss容器不断重启(其他容器正常)
群晖DSM6.1.4 最新Docker
docker-compose
查看日志一直报错sh: can't open '/wait-for.sh': No such file or directory
Please set SELF_URL_PATH to the correct value for your server (possible value: http://XXX.XXX.XXX.XXX:XXXX/)
原因是什么啊
这个应该是tiny rss本身的问题?或者是我哪里设置的不对?
我无法把一个订阅同时设置在多个文件夹,比如 【掘金-后端】这个订阅,我想同时存在于【资讯】和【掘金】这两个文件夹中,但是并不可以,其他的比如feedly,reeder,Inoreader都可以, tiny rss是否支持此功能?
docker-compose 摘录如下
version: "3"
services:
service.rss:
image: wangqiru/ttrss:latest
container_name: ttrss
ports:
- 181:80
environment:
- SELF_URL_PATH=http://feed.mydomin.com/
- DB_HOST=127.0.0.1
- DB_PORT=5432
- DB_NAME=ttrss
- DB_USER=postgres
- DB_PASS=*********
stdin_open: true
tty: true
restart: always
我把SELF_URL_PATH改成 http://ip/
也无法启动。
这是为什么?
无法从指定的网址下载:; 28 Connection timed out after 15000 milliseconds
CentOS 7 Latest
测试了 Docker 内 ping 没有问题
链接是 https://rsshub.app/bilibili/user/video/9838560.rss
在宿主机上使用 curl 可以正常获取
如题,我是通过 docker-compose 部署的,不知道插件的文件夹在哪?该如何安装其他插件呢?
我用的是群晖里的docker,群晖的网关是主路由网关(不能翻墙),我想让ttrss容器翻墙(用旁路网关),有可能实现吗?
ttrss的主代码库https://git.tt-rss.org/git/tt-rss/src/master 使用了 Cloudflare,docker安装时无法从git.tt-rss.org下载源程序,安装失败。
建议修改ttrss下载地址为https://gitlab.com/gothfox/tt-rss 或增加设置ttrss下载地址的全局变量
如何自行配置呢?能否给个简单的说明。
希望支持arm架构处理器的设备,比如斐讯N1小钢炮,树莓派
armhf | arm32v7-latest
arm64 | arm64v8-latest
x86-64 | amd64-latest
Raspberry Pi / arm7 / arm8.
N1小钢炮系统NDM
compose与直接安装都试过。参考https://ttrss.henry.wang/zh/
页面打不开,查看日志一直报错:standard_init_linux.go:207:exec用户进程导致“exec格式错误”
网上的方法(修改格式等)并不管用
在linode上,centos 7 X64位,通过 docker-compose 部署成功,可以订阅RSS,但“设置”里面的“Plugins”项空白,没法启用Mercury_fulltext、Fever等插件。另外,点击“设置”里面的“feeds”选项,会进入死循环,不能正常退出,只能关闭浏览器。
该功能能够解决的问题
ttrss实例启动时日志出现警告:
[24-Sep-2019 05:57:27] WARNING: [pool www] server reached pm.max_children setting (5), consider raising it
形容理想的解决方案
支持通过ENV或者挂载volume设置fpm pool
其他
https://docs.bitnami.com/bch/apps/tiny-tiny-rss/configuration/configure-phpfpm-processes/
通过 docker-compose 部署更新
通过Nginx 反代 Https
访问偏好设置无法访问
Ubuntu 18.04.2 LTS
docker-compose.yml
- SELF_URL_PATH=https://域名/
Nginx配置
upstream ttrss {
server 127.0.0.1:181;
}
server
{
listen 80;
server_name 域名 ;
return 301 https://域名$request_uri;
}
server
{
listen 443 ssl;
gzip on;
server_name 域名 ;
ssl_certificate /usr/local/nginx/conf/ssl/域名/fullchain.cer;
ssl_certificate_key /usr/local/nginx/conf/ssl/域名/域名.key;
access_log /home/wwwlogs/ttrss.log combined;
location / {
proxy_redirect off;
proxy_pass http://ttrss;
proxy_set_header Host $http_host;
proxy_set_header X-Real-IP $remote_addr;
proxy_set_header X-Forwarded-Ssl on;
proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
proxy_set_header X-Forwarded-Proto $scheme;
proxy_set_header X-Frame-Options SAMEORIGIN;
client_max_body_size 100m;
client_body_buffer_size 128k;
proxy_buffer_size 4k;
proxy_buffers 4 32k;
proxy_busy_buffers_size 64k;
proxy_temp_file_write_size 64k;
}
}
debian 9
docker安装
TTRSS的中文搜索什么都搜不到,加上双引号也搜不到,filter也搜不到中文
另外,如果rss源是GBK,而非utf-8的话,订阅不了,即使订阅上了,debug抓取内容错误
[05:25:29/700] start
[05:25:29/700] setting basic feed info for 70 [[Unknown], ]...
[05:25:30/700] local cache will not be used for this feed
[05:25:30/700] last unconditional update request:
[05:25:30/700] maximum allowed interval for conditional requests exceeded, forcing refetch
[05:25:30/700] fetching [https://bbs.eastgame.org/rss.php?fid=719&auth=987a3nvo...........CpVFx5fbni0wbSs%2FBs.......h2A] (force_refetch: 1)...
[05:25:31/700] fetch done.
[05:25:31/700] source last modified:
[05:25:31/700] saving cache/feeds/a15604b9ba5b86a1256fe33400bef6e389b73c47.xml
[05:25:31/700] fetch error: LibXML error 1 at line 0 (column 0): iconv : problems with filters for 'gbk'
[05:25:31/700] + LibXML error 1 at line 0 (column 0): iconv : problems with filters for 'gbk'
[05:25:31/700] + LibXML error 32 at line 1 (column 35): Unsupported encoding gbk
[05:25:31/700] update failed.
更新了新的 image 后无法正常使用
Ubuntu 16.04
docker run -it --name ttrss --restart=always \
--link ttrssdb:db \
-e SELF_URL_PATH=https://rss.fengkx.top \
-e DB_USER=ttrss \
-e DB_PASS=ttrss \
-p 1541:80 \
-d wangqiru/ttrss
Using nginx proxy_pass to localhost:1541
docker logs
Tiny Tiny RSS was unable to start properly. This usually means a misconfiguration or an incomplete upgrade.
Please fix errors indicated by the following messages:
* Please set SELF_URL_PATH to the correct value for your server (possible value: <b>http://</b>)
You might want to check tt-rss wiki or the forums for more information.
Please search the forums before creating new topic for your question.
[28-Jul-2018 15:06:31] NOTICE: fpm is running, pid 9
[28-Jul-2018 15:06:31] NOTICE: ready to handle connections
Tiny Tiny RSS was unable to start properly. This usually means a misconfiguration or an incomplete upgrade.
Please fix errors indicated by the following messages:
* Please set SELF_URL_PATH to the correct value for your server (possible value: <b>http://</b>)
You might want to check tt-rss wiki or the forums for more information.
Please search the forums before creating new topic for your question.
Tiny Tiny RSS was unable to start properly. This usually means a misconfiguration or an incomplete upgrade.
Please fix errors indicated by the following messages:
* Please set SELF_URL_PATH to the correct value for your server (possible value: <b>http://</b>)
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.