Progressive Web App (PWA) and Push Notifications

[deleted]

askvortsov
Dropped table - still nothing. Reinstalled extension, cleared cache... Problem is still there:

Next Illuminate\Database\QueryException: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes (SQL: alter table `edupush_subscriptions` add unique `edupush_subscriptions_endpoint_unique`(`endpoint`)) in /home/xxxx/mysite/vendor/illuminate/database/Connection.php:664
Stack trace:
#0 /home/xxxx/mysite/vendor/illuminate/database/Connection.php(624): Illuminate\Database\Connection->runQueryCallback('alter table `ed...', Array, Object(Closure))
#1 /home/xxxx/mysite/vendor/illuminate/database/Connection.php(459): Illuminate\Database\Connection->run('alter table `ed...', Array, Object(Closure))

askvortsov

[deleted] Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes

THat's actually a different issue! See https://discuss.flarum.org/d/24018-looking-for-testers-for-a-push-notifications-extension/15

pkernstock

askvortsov removing the askvortsov-pwa.vapid.private and askvortsov-pwa.vapid.public entries, then it should regenerate keys.

This worked out fantastic! No massive log spam as of now, nor JavaScript errors as there were previously. Thanks! 🙂

askvortsov Make sure you're using minishlink\web-push v5.2.5, looking at the source code, that seems to have the correct source code.

I had 5.2.5 installed, as I read earlier comments about issues in later releases.

askvortsov

pkernstock One thing to try if you're still experiencing issues is upgrading to the latest version of askvortsov/flarum-pwa (1.0.4 I believe?).

pkernstock

askvortsov 1.0.4 I believe

$ composer require "askvortsov/flarum-pwa:1.0.4"  --no-cache
./composer.json has been updated
Loading composer repositories with package information
Updating dependencies (including require-dev)
Your requirements could not be resolved to an installable set of packages.

  Problem 1
    - askvortsov/flarum-pwa v1.0.4 conflicts with minishlink/web-push[v5.2.5].
    - minishlink/web-push v5.2.5 conflicts with askvortsov/flarum-pwa[v1.0.4].
    - askvortsov/flarum-pwa v1.0.4 conflicts with minishlink/web-push[v5.2.5].
    - Installation request for askvortsov/flarum-pwa 1.0.4 -> satisfiable by askvortsov/flarum-pwa[v1.0.4].
    - Installation request for minishlink/web-push 5.2.5 -> satisfiable by minishlink/web-push[v5.2.5].

According to your composer.json:

  "conflict": {
    "minishlink/web-push": "<=5.2.5 || >=6"
  },

I believe this be something like >5.2.5 instead?

askvortsov

pkernstock oh no..... I can't believe I've done that... 🤣

[deleted]

I know this might be off topic, but can anyone help me install this extension. I have the same problem (as before):

Next Illuminate\Database\QueryException: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes (SQL: alter tableedupush_subscriptionsadd uniqueedupush_subscriptions_endpoint_unique(endpoint)) in /home/xxxx/mysite/vendor/illuminate/database/Connection.php:664 Stack trace: #0 /home/xxxx/mysite/vendor/illuminate/database/Connection.php(624): Illuminate\Database\Connection->runQueryCallback('alter tableed...', Array, Object(Closure))
#1 /home/xxxx/mysite/vendor/illuminate/database/Connection.php(459): Illuminate\Database\Connection->run('alter table ed...', Array, Object(Closure))

How to tweak mysql database to resolve

Specified key was too long; max key length is 767 bytes...

Thanks.

askvortsov

[deleted] what database version are you using?

[deleted]

[deleted] Next Illuminate\Database\QueryException: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes (SQL: alter tableedupush_subscriptionsadd uniqueedupush_subscriptions_endpoint_unique(endpoint)) in /home/xxxx/mysite/vendor/illuminate/database/Connection.php:664

I managed to resolve this issue:

in config.php made changes:
'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',
drop table _push_subscriptions
cleared cache
reactivated extension

[deleted]

@askvortsov

PHP 7.4.9

MySQL
10.1.41-MariaDB

Fantomen

[deleted] Upgrade to MariaDB 10,2, solved my issues. Drop the related tables and reinstall.

AADev

@askvortsov
My Progressive Web App is working fine without https://packagist.org/packages/minishlink/web-push and GMP PHP extension

When I try to install https://packagist.org/packages/minishlink/web-push it give error of conflicting with this extension due to which it can't be installed
Any Solution for that?
I don't use command line. I add package names in composer.json and then run update from my site control panel (as that is what I am allowed to do on my site in shared hosting environment by my host).

[deleted]

Fantomen
Well, I'm on shared host, so I have to wait for update to be pushed from hosting company. 🙁

L1fe

I'm getting the following from the status check:

The gmp PHP extension and minishlink/web-push library (composer require minishlink/web-push) MUST be enabled for push notifications to work.

Both GMP & minishlink.web-push library have been installed. Any advice?

GMP is in my php --ini dump

SQL DATABASE VERSION: 14.14 distribution 5.7.31

L1fe

do I need to enable the bundle in the GITHUB it mentions enabling it in app/kernal?

It also explains i have to change a configuration: app/config/config.yml.

Are these steps I have to do @askvortsov ?

askvortsov

L1fe In addition to being installed, php-gmp must be enabled. Has this been done?

L1fe

@askvortsov I am not sure how to enable it.

askvortsov

Depends on your operating system; here's a tutorial from a google search: https://scripts.mit.edu/faq/64/how-do-i-enable-additional-php-extensions

L1fe

My comment only came out partially. I have ubuntu in the /etc/php/7.4/cli php.ini i added extension=gmp.so is there anything else that I need to do to enable it other than modifying the ini script?

askvortsov

Is gmp listed if you run php -m? You might also need to restart php.

L1fe

@askvortsov it is showing listed when i php -m

« Previous Page Next Page »