Upgrade causes jauth.db missing Display projects WMS links and other options

[pcav]

Until 3.3.0 the admin could choose to display the URL of the WMS service.
In 3.3.3 this option has disappeared.
See attached screenshots.

[nboisteault]

Weird issue. I can't reproduce it in 3.3.3.

[pcav]

You can check WMS links are not present e.g. in https://lizmap.faunalia.eu (they were before the update to 3.3.3)
Thanks for checking

[Gustry]

I can't reproduce too on 3.3.4-pre

[pcav]

Thanks @Gustry for checking. Have you also a 3.3.3 installation to check? Have you seen my example? Could this be a side effect of the upgrade rather than a fresh install?

[pcav]

Tried a fresh install of 3.3.3, the option is there. Then upgrading, still there. So it's a local issue, probably due to some upgrade issue (I noticed it in an installation that has undergone many upgrades, since version 2). I can close this. I would appreciate a suggestion on how to clean it up, as this is a production instance and I cannot just drop all users and groups.
Thanks.

[pcav]

The other strange thing is that group rights are not displayed correctly, see attached

[pcav]

Further investigation: row lizmap.tools.displayGetCapabilitiesLinks is missing from old jauth.db

[pcav]

Adding the record back makes the option available.
Remaining issues:

• the option is not available to admin, it has to be added by hand in the Rights of groups page
• the order in that page is wrong (Display projects WMS links is the first row)
• some rights are displayed with the wrong name (acl.grp.group.management and acl.grp.user.management)

[pcav]

Any hint on how I can clean up the second and third point? I tried running again
php lizmap/install/installer.php
and
php lizmap/install/upgrade-to-3.php
to no avail.
Thanks.

[rldhont]

@pcav I don't think that jelix as a command line to check and upgarde jauth-db.

[pcav]

/s/as/has?

[pcav]

/s/jauth-db/jauth.db?

[pcav]

More info: in correct db,
acl.group.create jelix~acl2db.acl.group.create acl.grp.group.management
is replaced by
acl.group.create jacl2db~acl2db.acl.group.create acl.grp.group.management
this fixes the names of rights (e.g. Create a group) but not those of headings (e.g. acl.grp.group.management)

[pcav]

Same for jacl2db~acl2db.acl.grp.group.management and jacl2db~acl2db.acl.grp.user.management

[pcav]

Issue solved for me, I leave it open for reference (I believe other can have the same issue during upgrades), feel free to close it @rldhont