[BUG] 'pg_trgm' extension not installed for 'ttrss' db, causing 'af_psql_trgm' user plugin to fail and breaking feed refresh

[henryqw]

[BUG] 'pg_trgm' extension not installed for 'ttrss' db, causing 'af_psql_trgm' user plugin to fail and breaking feed refresh

[HenryQW]

Seems TTRSS has renamed the plugins? I will have to look into this when I have time. If you have any suggestions or even better submit a PR.

[HenryQW]

Hi @benfishbus , I tried to reproduce the issue with BBC, it seems it's working fine on my side and no error logs in both TTRSS and nginx. I suspect it's because my database has pg_tram initialized a long time ago (though I definitely didn't do it manually).

Will you be able to enable to plugin, then right click the feed and select Debug Feed, make sure you check both force options.

[HenryQW]

I just found it might also be initialized via an env "DB_NAME" in pgsql container, will you be able to test this?

https://github.com/sameersbn/docker-postgresql#enabling-extensions

[stale]

This issue has been automatically marked as stale because it has not had recent activity in 14 days. It will be closed if no further activity occurs in 7 days. Thank you for your contributions.

[benfishbus]

Since I already installed the extension (and don't know how to uninstall it), debug shows the plugin executing successfully on articles in one of the feeds where it's enabled: [02:16:41/7182] ... Af_Psql_Trgm [02:16:41/7182] === 0.0004 (sec) DB_NAME is set already (per the docker-compose.yml you include) as follows: environment: - DB_NAME=ttrss

…

-Ben

On Tue, Sep 3, 2019 at 7:46 PM Henry Wang ***@***.***> wrote: I just found it might also be initialized via an env "DB_NAME" in pgsql container, will you be able to test this? https://github.com/sameersbn/docker-postgresql#enabling-extensions — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#69?email_source=notifications&email_token=ADLB6YLS6GPFBDTN45PCJDTQH3ZLXA5CNFSM4ISRIPMKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD5Z4UTA#issuecomment-527682124>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ADLB6YPNWOKZYYS35U2JW5DQH3ZLXANCNFSM4ISRIPMA> .