Connexion impossible depuis la mise à jour de TTRSS [résolu]

Calipra · July 19, 2017, 12:14pm

Bonjour,
J’ai un problème depuis la mise à jour de Tiny Tiny RSS que j’ai faite aujourd’hui. Il me dit que “Vous n’avez pas les permissions nécessaires pour exécuter ce script”. Il me renvoie sur la page /tt-rss/public.php?op=dbupdate et je ne peux pas me connecter à TTRSS.

Est-ce que quelqu’un aurait une piste pour m’aider à régler le problème. Merci d’avance.

JimboJoe · July 19, 2017, 4:45pm

Bonjour,

Je n’arrive malheureusement pas à reproduire ton problème.
As-tu essayé de te déconnecté du portail YunoHost, puis de te reconnecter avant d’aller dans TTRSS ?
Depuis quelle version as-tu mis à jour ? Aurais-tu par hasard les logs de la mise à jour ?

Calipra · July 20, 2017, 10:14am

Merci

Oui, je me suis bien déconnecté et ça ne permet toujours pas de se connecter.
Pour la version, je devais a priori être sur l’avant-dernière version disponible.
Pour les logs, lesquels il faudrait ?

ferro · July 20, 2017, 11:01am

Hello,

i have got the same problem after updating ttrss. I found the following update/installation log, (/var/log/yunohost/yunohost-api.log):

2017-07-19 10:35:20,338 INFO     yunohost.tools tools_update - [685.13] Die Liste der verfügbaren Pakete wird aktualisiert...
2017-07-19 10:35:49,263 INFO     yunohost.tools tools_update - [685.13] Erledigt
2017-07-19 10:35:49,279 INFO     urllib3.connectionpool _new_conn - Starting new HTTPS connection (1): app.yunohost.org
2017-07-19 10:35:49,809 SUCCESS  yunohost.app success - [685.13] Appliste yunohost wurde erfolgreich heruntergelanden
2017-07-19 10:35:50,227 INFO     geventwebsocket.handler log_request - 127.0.0.1 - - [2017-07-19 10:35:50] "PUT /update HTTP/1.1" 200 209 32.339131
2017-07-19 10:36:22,928 INFO     moulinette.actionsmap process - processing action [685.14]: yunohost.tools.upgrade
2017-07-19 10:36:23,558 INFO     yunohost.app app_upgrade - [685.14] Upgrading apps description, license, installed, label, id, name
2017-07-19 10:36:23,658 WARNING  yunohost.app app_upgrade - [685.14] Es muss eine URL angegeben werden, um deine benutzerdefinierte App gogs zu aktualisieren
2017-07-19 10:36:23,705 WARNING  yunohost.app app_upgrade - [685.14] Es muss eine URL angegeben werden, um deine benutzerdefinierte App syncthing zu aktualisieren
2017-07-19 10:36:24,061 INFO     yunohost.app _fetch_app_from_git - [685.14] Wird heruntergeladen...
2017-07-19 10:36:25,861 INFO     yunohost.app _extract_app_from_file - [685.14] Wird entpackt...
2017-07-19 10:36:26,018 INFO     yunohost.app _extract_app_from_file - [685.14] Erledigt
2017-07-19 10:36:26,028 INFO     yunohost.app _check_manifest_requirements - [685.14] Überprüfe notwendige Pakete...
2017-07-19 10:36:28,709 INFO     yunohost.hook hook_exec - [685.14] Skript '/var/cache/yunohost/from_file/ttrss_ynh-605cb921203b138f537a5542ca7b873cd58cd1a7/scripts/upgrade' wird ausgeührt...
2017-07-19 10:36:29,074 INFO     yunohost.hook <lambda> - [685.14] + set -e
2017-07-19 10:36:29,081 INFO     yunohost.hook <lambda> - [685.14] + source ./_common.sh
2017-07-19 10:36:29,083 INFO     yunohost.hook <lambda> - [685.14] ++ APPNAME=ttrss
2017-07-19 10:36:29,085 INFO     yunohost.hook <lambda> - [685.14] ++ VERSION=09628e1b1a
2017-07-19 10:36:29,086 INFO     yunohost.hook <lambda> - [685.14] ++ TTRSS_BINARY_URL=https://git.tt-rss.org/git/tt-rss/archive/09628e1b1a.zip
2017-07-19 10:36:29,088 INFO     yunohost.hook <lambda> - [685.14] + app=ttrss
2017-07-19 10:36:29,091 INFO     yunohost.hook <lambda> - [685.14] ++ sudo yunohost app setting ttrss domain
2017-07-19 10:36:31,293 INFO     yunohost.hook <lambda> - [685.14] + domain=mydomain.com
2017-07-19 10:36:31,302 INFO     yunohost.hook <lambda> - [685.14] ++ sudo yunohost app setting ttrss path
2017-07-19 10:36:33,321 INFO     yunohost.hook <lambda> - [685.14] + path=/ttrss/
2017-07-19 10:36:33,323 INFO     yunohost.hook <lambda> - [685.14] + db_user=ttrss
2017-07-19 10:36:33,326 INFO     yunohost.hook <lambda> - [685.14] ++ sudo yunohost app setting ttrss mysqlpwd
2017-07-19 10:36:35,287 INFO     yunohost.hook <lambda> - [685.14] + db_pwd=YwnnMHOrS5dvdLKbpxZ8KfLz
2017-07-19 10:36:35,290 INFO     yunohost.hook <lambda> - [685.14] + final_path=/var/www/ttrss
2017-07-19 10:36:35,292 INFO     yunohost.hook <lambda> - [685.14] + sudo mkdir -p /var/www/ttrss
2017-07-19 10:36:35,366 INFO     yunohost.hook <lambda> - [685.14] + extract_ttrss /var/www/ttrss
2017-07-19 10:36:35,368 INFO     yunohost.hook <lambda> - [685.14] + local DESTDIR=/var/www/ttrss
2017-07-19 10:36:35,370 INFO     yunohost.hook <lambda> - [685.14] ++ mktemp -d
2017-07-19 10:36:35,374 INFO     yunohost.hook <lambda> - [685.14] + local TMPDIR=/tmp/tmp.JXOBpqNXF8
2017-07-19 10:36:35,376 INFO     yunohost.hook <lambda> - [685.14] + ttrss_tarball=/tmp/ttrss.zip
2017-07-19 10:36:35,386 INFO     yunohost.hook <lambda> - [685.14] + rm -f /tmp/ttrss.zip
2017-07-19 10:36:35,388 INFO     yunohost.hook <lambda> - [685.14] + wget -q -O /tmp/ttrss.zip https://git.tt-rss.org/git/tt-rss/archive/09628e1b1a.zip
2017-07-19 10:36:39,720 INFO     yunohost.hook <lambda> - [685.14] + unzip -q /tmp/ttrss.zip -d /tmp/tmp.JXOBpqNXF8
2017-07-19 10:36:41,672 INFO     yunohost.hook <lambda> - [685.14] + sudo rsync -a /tmp/tmp.JXOBpqNXF8/tt-rss/api /tmp/tmp.JXOBpqNXF8/tt-rss/atom-to-html.xsl /tmp/tmp.JXOBpqNXF8/tt-rss/backend.php /tmp/tmp.JXOBpqNXF8/tt-rss/cache /tmp/tmp.JXOBpqNXF8/tt-rss/classes /tmp/tmp.JXOBpqNXF8/tt-rss/config.php-dist /tmp/tmp.JXOBpqNXF8/tt-rss/CONTRIBUTING.md /tmp/tmp.JXOBpqNXF8/tt-rss/COPYING /tmp/tmp.JXOBpqNXF8/tt-rss/css /tmp/tmp.JXOBpqNXF8/tt-rss/errors.php /tmp/tmp.JXOBpqNXF8/tt-rss/feed-icons /tmp/tmp.JXOBpqNXF8/tt-rss/images /tmp/tmp.JXOBpqNXF8/tt-rss/include /tmp/tmp.JXOBpqNXF8/tt-rss/index.php /tmp/tmp.JXOBpqNXF8/tt-rss/install /tmp/tmp.JXOBpqNXF8/tt-rss/js /tmp/tmp.JXOBpqNXF8/tt-rss/lib /tmp/tmp.JXOBpqNXF8/tt-rss/locale /tmp/tmp.JXOBpqNXF8/tt-rss/lock /tmp/tmp.JXOBpqNXF8/tt-rss/messages.pot /tmp/tmp.JXOBpqNXF8/tt-rss/opml.php /tmp/tmp.JXOBpqNXF8/tt-rss/plugins /tmp/tmp.JXOBpqNXF8/tt-rss/plugins.local /tmp/tmp.JXOBpqNXF8/tt-rss/prefs.php /tmp/tmp.JXOBpqNXF8/tt-rss/public.php /tmp/tmp.JXOBpqNXF8/tt-rss/README.md /tmp/tmp.JXOBpqNXF8/tt-rss/register.php /tmp/tmp.JXOBpqNXF8/tt-rss/schema /tmp/tmp.JXOBpqNXF8/tt-rss/templates /tmp/tmp.JXOBpqNXF8/tt-rss/tests /tmp/tmp.JXOBpqNXF8/tt-rss/themes /tmp/tmp.JXOBpqNXF8/tt-rss/themes.local /tmp/tmp.JXOBpqNXF8/tt-rss/update_daemon2.php /tmp/tmp.JXOBpqNXF8/tt-rss/update.php /tmp/tmp.JXOBpqNXF8/tt-rss/utils /var/www/ttrss
2017-07-19 10:36:48,946 INFO     yunohost.hook <lambda> - [685.14] + rm -rf /tmp/ttrss.zip /tmp/tmp.JXOBpqNXF8
2017-07-19 10:36:49,141 INFO     yunohost.hook <lambda> - [685.14] + sudo cp ../conf/config.php /var/www/ttrss/
2017-07-19 10:36:49,237 INFO     yunohost.hook <lambda> - [685.14] + sudo cp ../conf/init.patch ../conf/update.patch /tmp/
2017-07-19 10:36:49,327 INFO     yunohost.hook <lambda> - [685.14] + sudo patch -d /var/www/ttrss -p0
2017-07-19 10:36:49,441 INFO     yunohost.hook <lambda> - [685.14] patching file update.php
2017-07-19 10:36:49,444 INFO     yunohost.hook <lambda> - [685.14] Hunk #1 succeeded at 324 (offset 13 lines).
2017-07-19 10:36:49,460 INFO     yunohost.hook <lambda> - [685.14] + sudo patch -d /var/www/ttrss/plugins/auth_remote/ -p0
2017-07-19 10:36:49,556 INFO     yunohost.hook <lambda> - [685.14] patching file init.php
2017-07-19 10:36:49,560 INFO     yunohost.hook <lambda> - [685.14] Hunk #1 succeeded at 71 (offset 2 lines).
2017-07-19 10:36:49,573 INFO     yunohost.hook <lambda> - [685.14] + sudo sed -i s/yunouser/ttrss/g /var/www/ttrss/config.php
2017-07-19 10:36:49,667 INFO     yunohost.hook <lambda> - [685.14] + sudo sed -i s/yunopass/YwnnMHOrS5dvdLKbpxZ8KfLz/g /var/www/ttrss/config.php
2017-07-19 10:36:49,768 INFO     yunohost.hook <lambda> - [685.14] + sudo sed -i s/yunobase/ttrss/g /var/www/ttrss/config.php
2017-07-19 10:36:49,880 INFO     yunohost.hook <lambda> - [685.14] + sudo sed -i s,yunopath,https://mydomain.com/ttrss/,g /var/www/ttrss/config.php
2017-07-19 10:36:49,978 INFO     yunohost.hook <lambda> - [685.14] + sudo chown -R www-data: /var/www/ttrss
2017-07-19 10:36:50,262 INFO     yunohost.hook <lambda> - [685.14] + sudo sed -i s@PATHTOCHANGE@/ttrss/@g ../conf/nginx.conf
2017-07-19 10:36:50,362 INFO     yunohost.hook <lambda> - [685.14] + sudo sed -i s@ALIASTOCHANGE@/var/www/ttrss/@g ../conf/nginx.conf
2017-07-19 10:36:50,464 INFO     yunohost.hook <lambda> - [685.14] + sudo cp ../conf/nginx.conf /etc/nginx/conf.d/mydomain.com.d/ttrss.conf
2017-07-19 10:36:50,575 INFO     yunohost.hook <lambda> - [685.14] + sudo service nginx reload
2017-07-19 10:36:52,077 INFO     yunohost.hook <lambda> - [685.14] + sudo yunohost app setting ttrss skipped_uris -v /public.php,/api
2017-07-19 10:36:54,217 INFO     yunohost.hook <lambda> - [685.14] + sudo sudo -u www-data php /var/www/ttrss/update.php --update-schema
2017-07-19 10:36:54,690 INFO     yunohost.hook <lambda> - [685.14] [08:36:54/13174] Lock: update.lock
2017-07-19 10:36:54,692 INFO     yunohost.hook <lambda> - [685.14] error: Can't create lockfile (update.lock). Maybe another update process is already running.
2017-07-19 10:36:55,052 SUCCESS  yunohost.app success - [685.14] ttrss wurde erfolgreich aktualisiert
2017-07-19 10:36:55,970 SUCCESS  yunohost.app success - [685.14] Die Konfiguration von SSOwat war erfolgreich
2017-07-19 10:36:55,971 SUCCESS  yunohost.app success - [685.14] Upgrade vollständig
2017-07-19 10:36:55,973 SUCCESS  yunohost.tools success - [685.14] Das System wurde aktualisiert

JimboJoe · July 20, 2017, 11:41am

Thanks for the logs!

Can you try to locate the mentioned update.lock in /var/www/ttrss?
Can you then try to move it elsewhere and run sudo -u www-data php /var/www/ttrss/update.php --update-schema as root?

ferro · July 20, 2017, 12:44pm

Thanks for the quick response,

no i couldn’t find the mentioned update.lock in the ttrss directory, but executing the command sudo -u www-data php /var/www/ttrss/update.php --update-schema as root fixed the problem! I can access ttrss again. Maybe it’s the same for @Calipra.

Calipra · July 20, 2017, 1:12pm

Thank you @JimboJoe & @ferro , the command also worked for me.