Tiny Tiny RSS: Community

TT-RSS with MariaDB 10 (Synology NAS)

Hello,

is it possible to use MariaDB 10 instead of MariaDB 5 for TT-RSS on a synology nas?
If so, what changes are necessary?

In theory, since MariaDB as a whole is designed to be a drop in replacement to MySQL, yes you can use it. As for version compatibility, since TTRSS was never made for MariaDB you’ll have to try it yourself.

I’d suggest looking here: https://mariadb.com/kb/en/library/mariadb-vs-mysql-compatibility/
It lists the versions that are more or less equivalent, MariaDB 10.0 and up is supposed to be compatible with MySQL 5.5 and 5.6, so should support everything they support, your mileage may vary of course, maybe someone else can chime in here if they are using MariaDB10 successfully.

In my setup tt-rss works very well with MariaDB 10.1.34 and PHP 7.2.7 in a Ubuntu 18.04 installation

I am using MariaDB version 10.1 on https://ttrss.info without any issues.

Does the following have to be changed in the config file?
define(‘DB_PORT’, ‘’) -> define(‘DB_PORT’, ‘3307’)

No. If you’re using standard ports (i.e. the defaults for the databases) you can just leave the DB_PORT constant as an empty string.

Be aware that DB_TYPE should be pgsql if using PostgreSQL; or mysql if using MySQL or MariaDB (because the latter is a drop-in replacement).

after a reinstall, i get this error message when going to http://192.168.178.31/tt-rss/install/

SQLSTATE[HY000] [2002] Connection refused
Unable to connect to database using specified parameters (driver: mysql).

curl, iconv, intl, mysqli, pdo_mysql ist activated.
HTTP-Backend-Server: Ngnix
PHP: 7.2

Does anyone have any idea what could be causing it?

Is MySQL running? Is it listening on the right port?

EDIT: Error found. You have to start MariaDB10 once and activate TCP/IP connections

If you can, move to Postgres… You will not regret it.