Wallabag is back!

[girish]

The upstream wallabag authors have enabled support for PG10. This means that Wallabag now works in the latest Cloudron version. We have pushed out a new version and it's now available for all -https://cloudron.io/store/org.wallabag.cloudronapp.html

Note that for installations "stuck" in Cloudron 3.2.3, we will enable updates so that they catch up to the latest release (which is 3.5.2)

[girish]

We have started pushing out Cloudron updates slowly for 3.2.3 cloudrons. Note that if you have ownCloud, your Cloudron will still be stuck on the old release. I have asked upstream devs for a timeline for ownCloud release but they haven't responded.

[necrevistonnezr]

The current version of Wallabag is 2.3.8 (https://github.com/wallabag/wallabag/releases), Cloudron packages 2.3.6...

Fixes since then:

• Add ability to match many domains for credentials #3937
• Enable no-referrer on img tags, enable strict-origin-when-cross-origin by default #3943
• Fix Intl Locale issue #3964
• material: fix left padding on non-entry pages #3901
• Make dev/install/update script posix compatible #3860
• epub: fix exception when articles have the same title #3908
• Fix PHP warning #3909
• material: add metadata to list view #3942
• Remove preview picture from share view page #3922
• Fix bad order parameter in the API #3841
• Update composer.json to add php-tidy (ext-tidy) #3853
• Add dedicated email for site config issue #3861
• Fix read & starred status in Pocket import #3819
• Fix broken 2 factor auth logo image #3869
• Fix CORS for API #3882
• Add support of expect parameter to change return object when deleting entry #3887
• epub export: fix missing cover image, only for exports of one article #3886
• Allow optional --ignore-root-warning #3885
• material: fix left padding of content on medium screens #3893
• material: hide creation date from card actions on specific sizes #3894

[girish]

@necrevistonnezr Good catch! The upstream version is incorrect - Cloudron is already on 2.4 actually (it's from the dev branch even). https://git.cloudron.io/cloudron/wallabag-app/blob/master/Dockerfile#L11

I will fix up the description to state the right version.

[A Former User]

@girish said in Wallabag is back!:

Cloudron is already on 2.4 actually

This is not the case --- currently my instance's About shows "Version: 2.3.7-dev". So, please update to 2.3.8

[nebulon]

Update to 2.4.0 pushed

[doodlemania2]

@nebulon Updated to a big pile of errors. Sample:

Dec 10 14:20:36 Step 3 of 4: Administration setup.
Dec 10 14:20:36 ----------------------------------
Dec 10 14:20:36
Dec 10 14:20:36
Dec 10 14:20:36 In AbstractPostgreSQLDriver.php line 57:
Dec 10 14:20:36
Dec 10 14:20:36 An exception occurred while executing 'INSERT INTO "wallabag_user" (usernam
Dec 10 14:20:36 e, username_canonical, email, email_canonical, enabled, salt, password, las
Dec 10 14:20:36 t_login, confirmation_token, password_requested_at, roles, id, name, create
Dec 10 14:20:36 d_at, updated_at, authCode, googleAuthenticatorSecret, backupCodes, emailTw
Dec 10 14:20:36 oFactor) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'
Dec 10 14:20:36 with params ["wallabag", "wallabag", "wallabag@wallabag.io", "wallabag@wall
Dec 10 14:20:36 abag.io", 1, "E2fmeRpuxHgqbmIakevuH.zbadPYn/ztfmNb.hk3iUE", "yc0J61fO3rpBr
Dec 10 14:20:36 Nz0Kw0xbVZURi/ElOMlPnbk5JJBd/2H1IRYF80cCQ9WHPMUNR6tsheZlsD9HeX/94ruhKqcS
Dec 10 14:20:36 A==", null, null, null, "a:2:{i:0;s:9:"ROLE_USER";i:1;s:16:"ROLE_SUPER_A
Dec 10 14:20:36 DMIN";}", 157, null, "2020-12-10 20:20:36", "2020-12-10 20:20:36", null, n
Dec 10 14:20:36 ull, null, 0]:
Dec 10 14:20:36
Dec 10 14:20:36 SQLSTATE[23505]: Unique violation: 7 ERROR: duplicate key value violates u
Dec 10 14:20:36 nique constraint "uniq_1d63e7e592fc23a8"
Dec 10 14:20:36 DETAIL: Key (username_canonical)=(wallabag) already exists.
Dec 10 14:20:36
Dec 10 14:20:36
Dec 10 14:20:36 In PDOStatement.php line 131:
Dec 10 14:20:36
Dec 10 14:20:36 SQLSTATE[23505]: Unique violation: 7 ERROR: duplicate key value violates u
Dec 10 14:20:36 nique constraint "uniq_1d63e7e592fc23a8"
Dec 10 14:20:36 DETAIL: Key (username_canonical)=(wallabag) already exists.
Dec 10 14:20:36
Dec 10 14:20:36
Dec 10 14:20:36 In PDOStatement.php line 129:
Dec 10 14:20:36
Dec 10 14:20:36 SQLSTATE[23505]: Unique violation: 7 ERROR: duplicate key value violates u
Dec 10 14:20:36 nique constraint "uniq_1d63e7e592fc23a8"
Dec 10 14:20:36 DETAIL: Key (username_canonical)=(wallabag) already exists.
Dec 10 14:20:36
Dec 10 14:20:36
Dec 10 14:20:36 + /usr/local/bin/gosu www-data:www-data php bin/console doctrine:migrations:migrate --env prod --no-interaction
Dec 10 14:20:36
Dec 10 14:20:36 Application Migrations
Dec 10 14:20:36
Dec 10 14:20:36
Dec 10 14:20:36 Migrating up to 20200428072628 from 20190425115043
Dec 10 14:20:36
Dec 10 14:20:36 ++ migrating 20190510141130
Dec 10 14:20:36
Dec 10 14:20:36 -> ALTER TABLE "wallabag_oauth2_access_tokens" DROP CONSTRAINT FK_368A4209A76ED395
Dec 10 14:20:36 -> ALTER TABLE "wallabag_oauth2_access_tokens" ADD CONSTRAINT FK_368A4209A76ED395 FOREIGN KEY (user_id) REFERENCES "wallabag_user" (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE
Dec 10 14:20:36 -> ALTER TABLE "wallabag_oauth2_clients" DROP CONSTRAINT idx_user_oauth_client
Dec 10 14:20:36 Migration 20190510141130 failed during Execution. Error An exception occurred while executing 'ALTER TABLE "wallabag_oauth2_clients" DROP CONSTRAINT idx_user_oauth_client':
Dec 10 14:20:36
Dec 10 14:20:36 SQLSTATE[42704]: Undefined object: 7 ERROR: constraint "idx_user_oauth_client" of relation "wallabag_oauth2_clients" does not exist
Dec 10 14:20:36 20:20:36 ERROR [console] Error thrown while running command "doctrine:migrations:migrate --env prod --no-interaction". Message: "An exception occurred while executing 'ALTER TABLE "wallabag_oauth2_clients" DROP CONSTRAINT idx_user_oauth_client':
Dec 10 14:20:36
Dec 10 14:20:36 SQLSTATE[42704]: Undefined object: 7 ERROR: constraint "idx_user_oauth_client" of relation "wallabag_oauth2_clients" does not exist" ["exception" => Doctrine\DBAL\Exception\DriverException { …},"command" => "doctrine:migrations:migrate --env prod --no-interaction","message" => """ An exception occurred while executing 'ALTER TABLE "wallabag_oauth2_clients" DROP CONSTRAINT idx_user_oauth_client':\n \n SQLSTATE[42704]: Undefined object: 7 ERROR: constraint "idx_user_oauth_client" of relation "wallabag_oauth2_clients" does not exist """]
Dec 10 14:20:36
Dec 10 14:20:36 In AbstractPostgreSQLDriver.php line 89:
Dec 10 14:20:36
Dec 10 14:20:36 An exception occurred while executing 'ALTER TABLE "wallabag_oauth2_clients
Dec 10 14:20:36 " DROP CONSTRAINT idx_user_oauth_client':
Dec 10 14:20:36
Dec 10 14:20:36 SQLSTATE[42704]: Undefined object: 7 ERROR: constraint "idx_user_oauth_cli
Dec 10 14:20:36 ent" of relation "wallabag_oauth2_clients" does not exist
Dec 10 14:20:36
Dec 10 14:20:36
Dec 10 14:20:36 In PDOConnection.php line 91:
Dec 10 14:20:36
Dec 10 14:20:36 SQLSTATE[42704]: Undefined object: 7 ERROR: constraint "idx_user_oauth_cli
Dec 10 14:20:36 ent" of relation "wallabag_oauth2_clients" does not exist
Dec 10 14:20:36
Dec 10 14:20:36
Dec 10 14:20:36 In PDOConnection.php line 86:
Dec 10 14:20:36
Dec 10 14:20:36 SQLSTATE[42704]: Undefined object: 7 ERROR: constraint "idx_user_oauth_cli
Dec 10 14:20:36 ent" of relation "wallabag_oauth2_clients" does not exist
Dec 10 14:20:36
Dec 10 14:20:36
Dec 10 14:20:36 doctrine:migrations:migrate [--write-sql [WRITE-SQL]] [--dry-run] [--query-time] [--allow-no-migration] [--configuration [CONFIGURATION]] [--db-configuration [DB-CONFIGURATION]] [--db DB] [--em EM] [--shard SHARD] [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [-e|--env ENV] [--no-debug] [--] <command> [<version>]
Dec 10 14:20:36
Dec 10 14:21:03 + mkdir -p /run/wallabag/cache /run/wallabag/logs /run/wallabag/sessions
Dec 10 14:21:03 + sed -e 's/database_driver:./database_driver: pdo_pgsql/' -e 's/database_host:./database_host: postgresql/' -e 's/database_port:./database_port: 5432/' -e 's/database_name:./database_name: db2b5e244172f54b24892e5da4603c3f00/' -e 's/database_user:./database_user: user2b5e244172f54b24892e5da4603c3f00/' -e 's/database_password:./database_password: xjYkbFoxOr6akUreTftb7Q3PLcWEYcNgg5JePeLwXcNQ7hOVqDktVn0iuxZjwc2ztYjVrXYzmTLdvFLZsGPIrYdJBqr94sVcoSmiWAkPAH2X9oLlg2c8jXZSlfwfBomg/' -e 's/database_charset: ./database_charset: utf8/' -e 's,domain_name: .,domain_name: https://later.thedoodleproject.net,' -e 's/redis_host:./redis_host: redis-2b5e2441-72f5-4b24-892e-5da4603c3f00/' -e 's/redis_port:./redis_port: 6379/' -e 's/redis_password:./redis_password: uIwMlh8OVs2n8lzryNHucHedW7UQDNFr5Ur2JTm6I8QzxOeouvmyoe7ftapLsDi4zGC1j1uqY1P91dWYYJSSWv9Pr6hN6KUKpvnaSbMUi3vLj_tVPJWfm3leTlJFNK17/' -e 's/mailer_host:./mailer_host: mail:2525/' -e 's/mailer_user:./mailer_user: later.app@thedoodleproject.net/' -e 's/mailer_password:./mailer_password: isgalKoJVZh7wlBcTsLnCwEN3CGWBGapRPmrQlpwFG2y7jCNCPmAgd3HAZma2uMS5DqNKwe2EQZBBxsYsSc7BKdFKhQCxq9TP__jcJzhZkOSsogwAM4jpF9Fn535xwdI/' -e 's/from_email:./from_email: later.app@thedoodleproject.net/' -e 's/twofactor_sender:./twofactor_sender: later.app@thedoodleproject.net/' -e 's/fosuser_registration:./fosuser_registration: false/' -e 's/fosuser_confirmation:./fosuser_confirmation: false/' /app/code/parameters.yml
Dec 10 14:21:03 + sed -e 's/save_path:./save_path: '''/run/wallabag/sessions'''/' /app/code/config.yml
Dec 10 14:21:03 + sed -e 's/path:./path: '''/run/wallabag/wallabag.log'''/' /app/code/config_prod.yml
Dec 10 14:21:03 + [[ ! -f /app/data/php.ini ]]
Dec 10 14:21:03 + mkdir -p /app/data/uploads/import /app/data/assets/images /app/data/data
Dec 10 14:21:03 + chown -R www-data:www-data /run/wallabag /app/data
Dec 10 14:21:03 + gosu='/usr/local/bin/gosu www-data:www-data'
Dec 10 14:21:03 + /usr/local/bin/gosu www-data:www-data php bin/console wallabag:install --env prod --no-interaction
Dec 10 14:21:03
Dec 10 14:21:03 wallabag installer
Dec 10 14:21:03 ==================
Dec 10 14:21:03
Dec 10 14:21:03 Step 1 of 4: Checking system requirements.
Dec 10 14:21:03 ------------------------------------------
Dec 10 14:21:03
Dec 10 14:21:03 ------------------------ -------- ----------------
Dec 10 14:21:03 Checked Status Recommendation
Dec 10 14:21:03 ------------------------ -------- ----------------
Dec 10 14:21:03 PDO Driver (pdo_pgsql) OK!
Dec 10 14:21:03 Database connection OK!
Dec 10 14:21:03 Database version OK!
Dec 10 14:21:03 curl_exec OK!
Dec 10 14:21:03 curl_multi_init OK!
Dec 10 14:21:03 ------------------------ -------- ----------------
Dec 10 14:21:03
Dec 10 14:21:03
Dec 10 14:21:03 [OK] Success! Your system can run wallabag properly.
Dec 10 14:21:03
Dec 10 14:21:03
Dec 10 14:21:03 Step 2 of 4: Setting up database.
Dec 10 14:21:03 ---------------------------------
Dec 10 14:21:03
Dec 10 14:21:03 Clearing the cache...
Dec 10 14:21:06
Dec 10 14:21:06 Database successfully setup.
Dec 10 14:21:06
Dec 10 14:21:06 Step 3 of 4: Administration setup.
Dec 10 14:21:06 ----------------------------------
Dec 10 14:21:06
Dec 10 14:21:06
Dec 10 14:21:06 In AbstractPostgreSQLDriver.php line 57:
Dec 10 14:21:06
Dec 10 14:21:06 An exception occurred while executing 'INSERT INTO "wallabag_user" (usernam
Dec 10 14:21:06 e, username_canonical, email, email_canonical, enabled, salt, password, las
Dec 10 14:21:06 t_login, confirmation_token, password_requested_at, roles, id, name, create
Dec 10 14:21:06 d_at, updated_at, authCode, googleAuthenticatorSecret, backupCodes, emailTw
Dec 10 14:21:06 oFactor) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'
Dec 10 14:21:06 with params ["wallabag", "wallabag", "wallabag@wallabag.io", "wallabag@wall
Dec 10 14:21:06 abag.io", 1, "w/ripY14AbJUEF0KpmnEaRz4T4NeSsomoZTgliNN9XM", "5yzHxktIVYAi1
Dec 10 14:21:06 kA48QZCbrQ+Vsf14YFFEdabxr44j9srrXDWTo4Wn5mTMSUIp82zn4XGp76/wdtCYkZYrMF3Sw=
Dec 10 14:21:06 =", null, null, null, "a:2:{i:0;s:9:"ROLE_USER";i:1;s:16:"ROLE_SUPER_ADM
Dec 10 14:21:06 IN";}", 158, null, "2020-12-10 20:21:06", "2020-12-10 20:21:06", null, nul
Dec 10 14:21:06 l, null, 0]:
Dec 10 14:21:06
Dec 10 14:21:06 SQLSTATE[23505]: Unique violation: 7 ERROR: duplicate key value violates u
Dec 10 14:21:06 nique constraint "uniq_1d63e7e592fc23a8"
Dec 10 14:21:06 DETAIL: Key (username_canonical)=(wallabag) already exists.
Dec 10 14:21:06
Dec 10 14:21:06
Dec 10 14:21:06 In PDOStatement.php line 131:
Dec 10 14:21:06
Dec 10 14:21:06 SQLSTATE[23505]: Unique violation: 7 ERROR: duplicate key value violates u
Dec 10 14:21:06 nique constraint "uniq_1d63e7e592fc23a8"
Dec 10 14:21:06 DETAIL: Key (username_canonical)=(wallabag) already exists.
Dec 10 14:21:06
Dec 10 14:21:06
Dec 10 14:21:06 In PDOStatement.php line 129:
Dec 10 14:21:06
Dec 10 14:21:06 SQLSTATE[23505]: Unique violation: 7 ERROR: duplicate key value violates u
Dec 10 14:21:06 nique constraint "uniq_1d63e7e592fc23a8"
Dec 10 14:21:06 DETAIL: Key (username_canonical)=(wallabag) already exists.
Dec 10 14:21:06
Dec 10 14:21:06
Dec 10 14:21:06 + /usr/local/bin/gosu www-data:www-data php bin/console doctrine:migrations:migrate --env prod --no-interaction
Dec 10 14:21:07
Dec 10 14:21:07 Application Migrations
Dec 10 14:21:07
Dec 10 14:21:07
Dec 10 14:21:07 Migrating up to 20200428072628 from 20190425115043
Dec 10 14:21:07
Dec 10 14:21:07 ++ migrating 20190510141130
Dec 10 14:21:07
Dec 10 14:21:07 -> ALTER TABLE "wallabag_oauth2_access_tokens" DROP CONSTRAINT FK_368A4209A76ED395
Dec 10 14:21:07 -> ALTER TABLE "wallabag_oauth2_access_tokens" ADD CONSTRAINT FK_368A4209A76ED395 FOREIGN KEY (user_id) REFERENCES "wallabag_user" (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE
Dec 10 14:21:07 -> ALTER TABLE "wallabag_oauth2_clients" DROP CONSTRAINT idx_user_oauth_client
Dec 10 14:21:07 Migration 20190510141130 failed during Execution. Error An exception occurred while executing 'ALTER TABLE "wallabag_oauth2_clients" DROP CONSTRAINT idx_user_oauth_client':
Dec 10 14:21:07
Dec 10 14:21:07 SQLSTATE[42704]: Undefined object: 7 ERROR: constraint "idx_user_oauth_client" of relation "wallabag_oauth2_clients" does not exist
Dec 10 14:21:07 20:21:07 ERROR [console] Error thrown while running command "doctrine:migrations:migrate --env prod --no-interaction". Message: "An exception occurred while executing 'ALTER TABLE "wallabag_oauth2_clients" DROP CONSTRAINT idx_user_oauth_client':
Dec 10 14:21:07
Dec 10 14:21:07 SQLSTATE[42704]: Undefined object: 7 ERROR: constraint "idx_user_oauth_client" of relation "wallabag_oauth2_clients" does not exist" ["exception" => Doctrine\DBAL\Exception\DriverException { …},"command" => "doctrine:migrations:migrate --env prod --no-interaction","message" => """ An exception occurred while executing 'ALTER TABLE "wallabag_oauth2_clients" DROP CONSTRAINT idx_user_oauth_client':\n \n SQLSTATE[42704]: Undefined object: 7 ERROR: constraint "idx_user_oauth_client" of relation "wallabag_oauth2_clients" does not exist """]
Dec 10 14:21:07
Dec 10 14:21:07 In AbstractPostgreSQLDriver.php line 89:
Dec 10 14:21:07
Dec 10 14:21:07 An exception occurred while executing 'ALTER TABLE "wallabag_oauth2_clients
Dec 10 14:21:07 " DROP CONSTRAINT idx_user_oauth_client':
Dec 10 14:21:07
Dec 10 14:21:07 SQLSTATE[42704]: Undefined object: 7 ERROR: constraint "idx_user_oauth_cli
Dec 10 14:21:07 ent" of relation "wallabag_oauth2_clients" does not exist
Dec 10 14:21:07
Dec 10 14:21:07
Dec 10 14:21:07 In PDOConnection.php line 91:
Dec 10 14:21:07
Dec 10 14:21:07 SQLSTATE[42704]: Undefined object: 7 ERROR: constraint "idx_user_oauth_cli
Dec 10 14:21:07 ent" of relation "wallabag_oauth2_clients" does not exist
Dec 10 14:21:07
Dec 10 14:21:07
Dec 10 14:21:07 In PDOConnection.php line 86:
Dec 10 14:21:07
Dec 10 14:21:07 SQLSTATE[42704]: Undefined object: 7 ERROR: constraint "idx_user_oauth_cli
Dec 10 14:21:07 ent" of relation "wallabag_oauth2_clients" does not exist
Dec 10 14:21:07
Dec 10 14:21:07
Dec 10 14:21:07 doctrine:migrations:migrate [--write-sql [WRITE-SQL]] [--dry-run] [--query-time] [--allow-no-migration] [--configuration [CONFIGURATION]] [--db-configuration [DB-CONFIGURATION]] [--db DB] [--em EM] [--shard SHARD] [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [-e|--env ENV] [--no-debug] [--] <command> [<version>]
Dec 10 14:21:07

[nebulon]

Oh that does not look good, I have reverted that version now. For a start please restore your instance to the old version.

Given the schema changes, we may have to publish a new app altogether with some export/import migration path. Have to see tomorrow.

[doodlemania2]

@nebulon no problem - looks like the migration just didn't like from version to version

[girish]

@doodlemania2 @nebulon I guess https://github.com/wallabag/wallabag/issues/4826 ?

[nebulon]

So we have to wait for the next patch release to fix a few regressions it seems: https://github.com/wallabag/wallabag/milestone/65