Nextcloud 24 support

[susnux]

Looks like nextcloud 24 does not have any critical API changes, and this plugin looks like it works with PHP8.1 (only requirement change in NC24).
Has anyone tested it on NC24? And will NC25 be officially supported?

[millquarterlabs]

Works partially, login works for most users however some users did apparently not get imported fully or something. The "User" view shows the correct number of users however it does not display all. The "oc_accounts" db contains only 40 users.

[tobox]

Any news on this?

[Thom1b]

Hi, how can we help to make user_sql available for NC-24?

[jvllmr]

We are using this plugin at the company I am working at with NC24 for quite a while now and we did not run into issues (still with php7 afaik)

[Trooper123]

Does anyone know when nc24 will be supported?
Are there other systems where the plugin runs under nc24?( please qoute)

[d-jsb]

Having NC 24.0.4 I see this in the log
Allowed memory size of 536870912 bytes exhausted (tried to allocate 16384 bytes) at /var/[...]/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php#92
First I had only 256M (php limit) but I increased it to recommended 512M. Still not enough? It used to work fine with ~480 Users in DB
Showing groups with small number (<10) of members tend to work better but not all of them show user list.

[d-jsb]

Allowed memory size of 536870912 bytes exhausted (tried to allocate 4096 bytes) at /www/.../apps/user_sql/lib/Query/DataQuery.php#258

[Bakaras]

Version 24 is mentioned in the fork https://github.com/ulukyn/user_sql
Maybe it is the solution?

[poVoq]

I am also having issues with this, and it is unclear if that is simply caused by a mis-configuration or lacking NC24 support.

[d-jsb]

Latest NC 24 upgrade today did not improve the situation. As the config was not changed, I guess it is missing support in user_sql.
Unfortunately I did not code in PHP for years, so I have no idea how to fix this.

[d-jsb]

I found I maybe solved my problem by disabling email sync in the user_sql options. Will observe and report in case of new errors.
According to the debug log the EmailSync#doAction appears to run into a recursion, the following log lines repeat over and over again - I did not investigate the details of the DB rows triggering the problem

`{"reqId":"xxx","level":0,"time":"2022-09-27T19:41:24+00:00","remoteAddr":"7xxx1","user":"1","app":"user_sql","method":"GET","url":"/ocs/v2.php/cloud/groups/21/users/details?offset=0&limit=25&search=","message":"Entering userExists(418)","userAgent":"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:104.0) Gecko/20100101 Firefox/104.0","version":"24.0.5.1","data":{"app":"user_sql"}}
{"reqId":"xxx","level":0,"time":"2022-09-27T19:41:24+00:00","remoteAddr":"7xxx1","user":"1","app":"user_sql","method":"GET","url":"/ocs/v2.php/cloud/groups/21/users/details?offset=0&limit=25&search=","message":"Executing query: SELECT u.id AS uid, u.username AS username, u.name AS name, u.email AS email, null AS quota, null AS home, true AS active, false AS avatar, null AS salt FROM c9m37_users u WHERE u.id = :uid AND NOT u.block, 418","userAgent":"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:104.0) Gecko/20100101 Firefox/104.0","version":"24.0.5.1","data":{"app":"user_sql"}}
{"reqId":"xxx","level":0,"time":"2022-09-27T19:41:24+00:00","remoteAddr":"7xxx1","user":"1","app":"user_sql","method":"GET","url":"/ocs/v2.php/cloud/groups/21/users/details?offset=0&limit=25&search=","message":"Entering EmailSync#doAction(418)","userAgent":"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:104.0) Gecko/20100101 Firefox/104.0","version":"24.0.5.1","data":{"app":"user_sql"}}

{"reqId":"xxx","level":0,"time":"2022-09-27T19:41:24+00:00","remoteAddr":"7xxx1","user":"1","app":"user_sql","method":"GET","url":"/ocs/v2.php/cloud/groups/21/users/details?offset=0&limit=25&search=","message":"Entering userExists(418)","userAgent":"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:104.0) Gecko/20100101 Firefox/104.0","version":"24.0.5.1","data":{"app":"user_sql"}}
{"reqId":"xxx","level":0,"time":"2022-09-27T19:41:24+00:00","remoteAddr":"7xxx1","user":"1","app":"user_sql","method":"GET","url":"/ocs/v2.php/cloud/groups/21/users/details?offset=0&limit=25&search=","message":"Executing query: SELECT u.id AS uid, u.username AS username, u.name AS name, u.email AS email, null AS quota, null AS home, true AS active, false AS avatar, null AS salt FROM c9m37_users u WHERE u.id = :uid AND NOT u.block, 418","userAgent":"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:104.0) Gecko/20100101 Firefox/104.0","version":"24.0.5.1","data":{"app":"user_sql"}}
{"reqId":"xxx","level":0,"time":"2022-09-27T19:41:24+00:00","remoteAddr":"7xxx1","user":"1","app":"user_sql","method":"GET","url":"/ocs/v2.php/cloud/groups/21/users/details?offset=0&limit=25&search=","message":"Entering EmailSync#doAction(418)","userAgent":"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:104.0) Gecko/20100101 Firefox/104.0","version":"24.0.5.1","data":{"app":"user_sql"}}
`