# Upgrade 32 bit to 64 bit

**URL:** <https://syncloud.discourse.group/t/upgrade-32-bit-to-64-bit/444>\
**Category:** System Updates\
**Created:** [24 June 2024 11:17 UTC](https://syncloud.discourse.group/t/upgrade-32-bit-to-64-bit/444 "2024-06-24T11:17:59Z")\
**Posts on this page:** 20\
**Page:** 2

<div class="post-metadata">

**Author:** ![boris](https://avatars.discourse-cdn.com/v4/letter/b/74df32/32.png) [@boris](https://syncloud.discourse.group/u/boris)\
**Post date:** [9 July 2024 21:17 UTC](https://syncloud.discourse.group/t/upgrade-32-bit-to-64-bit/444/21 "2024-07-09T21:17:50Z")

</div>

Can you try this:

```auto
snap run nextcloud.psql -c "select * from oc_ldap_group_membership"

```

This changed in v29.

---

<div class="post-metadata">

**Author:** ![boris](https://avatars.discourse-cdn.com/v4/letter/b/74df32/32.png) [@boris](https://syncloud.discourse.group/u/boris)\
**Post date:** [9 July 2024 21:21 UTC](https://syncloud.discourse.group/t/upgrade-32-bit-to-64-bit/444/22 "2024-07-09T21:21:18Z")

</div>

Also this:

```auto
snap run nextcloud.psql -c "select * from oc_ldap_group_mapping"

```

---

<div class="post-metadata">

**Author:** ![boris](https://avatars.discourse-cdn.com/v4/letter/b/74df32/32.png) [@boris](https://syncloud.discourse.group/u/boris)\
**Post date:** [9 July 2024 21:33 UTC](https://syncloud.discourse.group/t/upgrade-32-bit-to-64-bit/444/23 "2024-07-09T21:33:17Z")

</div>

And this:

```auto
snap run nextcloud.occ group:info admin

```

---

<div class="post-metadata">

**Author:** ![boris](https://avatars.discourse-cdn.com/v4/letter/b/74df32/32.png) [@boris](https://syncloud.discourse.group/u/boris)\
**Post date:** [9 July 2024 21:35 UTC](https://syncloud.discourse.group/t/upgrade-32-bit-to-64-bit/444/24 "2024-07-09T21:35:58Z")

</div>

One more:

```auto
snap run nextcloud.occ user:info trevor

```

---

<div class="post-metadata">

**Author:** ![trevorprinn](https://yyz2.discourse-cdn.com/free1/user_avatar/syncloud.discourse.group/trevorprinn/32/14_2.png) [@trevorprinn](https://syncloud.discourse.group/u/trevorprinn)\
**Post date:** [9 July 2024 21:36 UTC](https://syncloud.discourse.group/t/upgrade-32-bit-to-64-bit/444/25 "2024-07-09T21:36:43Z")

</div>

```auto
 snap run nextcloud.psql -c "select * from oc_ldap_group_membership"
 id | groupid | userid
----+---------+--------
  2 | alex | alex
  3 | abtuse | alex
  4 | abtuse | brian
  5 | abtuse | bruce
  6 | abtuse | henry
  7 | abtuse | scott
  9 | brian | brian
 10 | bruce | bruce
 11 | danny | danny
 12 | henry | henry
 13 | sarah | sarah
 14 | scott | scott
(12 rows)

```

```auto
snap run nextcloud.psql -c "select * from oc_ldap_group_mapping"                                                                                                                                                          
snap run nextcloud.psql -c "select * from oc_ldap_group_mapping"
 owncloud_name | ldap_dn | directory_uuid | ldap_dn_hash
---------------+------------------------------------------+--------------------------------------+------------------------------------------------------------------
 alex | cn=alex,ou=groups,dc=syncloud,dc=org | 819f3618-d234-103e-9e7e-552073deadc2 | 6a60e17d2543a3a6e93676b7898e964b9695c2f7a6e1dde854794d186f608205
 brian | cn=brian,ou=groups,dc=syncloud,dc=org | dcb10978-d234-103e-9e81-552073deadc2 | aa08486944bd66c3424c26c1a30b2504d82ee7afb0648693e22ce17084417f73
 bruce | cn=bruce,ou=groups,dc=syncloud,dc=org | ed689b46-d234-103e-9e83-552073deadc2 | 066e572295c0778d864b7145a33e1c051f114b2572cb3a5e2fb135b129e7f772
 danny | cn=danny,ou=groups,dc=syncloud,dc=org | 022d4f36-d235-103e-9e85-552073deadc2 | e860edba60ea8b63a39ceb04fb0d31ddcfa81fb22b438f309f73924241e5ba4e
 henry | cn=henry,ou=groups,dc=syncloud,dc=org | 190a66f8-d235-103e-9e87-552073deadc2 | 4c863f623b5b2a3931016028fc65b2a5e410e35f93301b2876920cd6f2c30e00
 sarah | cn=sarah,ou=groups,dc=syncloud,dc=org | 35fe65e8-d235-103e-9e89-552073deadc2 | 9ea3d167779a9513536a15f55ac308bb78299b4b6db1d4936ca6b33f4457d1a8
 scott | cn=scott,ou=groups,dc=syncloud,dc=org | 5897b794-d235-103e-9e8b-552073deadc2 | 3f65d32297c5a526e2f5ce08abff084d072d09d70359b3326dda702989ef4d6d
 abtuse | cn=abtuse,ou=groups,dc=syncloud,dc=org | bced903e-d234-103e-9e80-552073deadc2 | e4917328e79527f8c2293ca8375ce19092433f5fadaea3014074c71f2cda19b5
 admin | cn=syncloud,ou=groups,dc=syncloud,dc=org | 5c228aae-d147-103e-9917-353e2aed4c26 | aac22646179b2b187a05c325be3431b95e39ef12a19def4ad4ea2e3aa0dc5123
(9 rows)

```

```auto
snap run nextcloud.occ group:info admin
  - groupID: admin
  - displayName: admin
  - backends:
    - Database
    - LDAP

```

---

<div class="post-metadata">

**Author:** ![boris](https://avatars.discourse-cdn.com/v4/letter/b/74df32/32.png) [@boris](https://syncloud.discourse.group/u/boris)\
**Post date:** [9 July 2024 21:43 UTC](https://syncloud.discourse.group/t/upgrade-32-bit-to-64-bit/444/26 "2024-07-09T21:43:37Z")

</div>

This one please:

```auto
snap run nextcloud.occ user:info trevor

```

---

<div class="post-metadata">

**Author:** ![trevorprinn](https://yyz2.discourse-cdn.com/free1/user_avatar/syncloud.discourse.group/trevorprinn/32/14_2.png) [@trevorprinn](https://syncloud.discourse.group/u/trevorprinn)\
**Post date:** [9 July 2024 21:44 UTC](https://syncloud.discourse.group/t/upgrade-32-bit-to-64-bit/444/27 "2024-07-09T21:44:58Z")

</div>

```auto
snap run nextcloud.occ user:info trevor
  - user_id: trevor
  - display_name: trevor
  - email: trevor@tprinn.syncloud.it
  - cloud_id: trevor@http://localhost
  - enabled: true
  - groups:
  - quota: none
  - storage:
    - free: 914476216320
    - used: 33526024003
    - total: 948002240323
    - relative: 3.54
    - quota: -3
  - last_seen: 2024-07-09T21:28:09+00:00
  - user_directory: /opt/disk/external/nextcloud/trevor
  - backend: LDAP

```

---

<div class="post-metadata">

**Author:** ![trevorprinn](https://yyz2.discourse-cdn.com/free1/user_avatar/syncloud.discourse.group/trevorprinn/32/14_2.png) [@trevorprinn](https://syncloud.discourse.group/u/trevorprinn)\
**Post date:** [9 July 2024 21:47 UTC](https://syncloud.discourse.group/t/upgrade-32-bit-to-64-bit/444/28 "2024-07-09T21:47:00Z")

</div>

I’d already tried to add myself to the admin group

```auto
snap run nextcloud.occ group:adduser admin trevor

```

Doesn’t seem to do anything

---

<div class="post-metadata">

**Author:** ![boris](https://avatars.discourse-cdn.com/v4/letter/b/74df32/32.png) [@boris](https://syncloud.discourse.group/u/boris)\
**Post date:** [9 July 2024 22:03 UTC](https://syncloud.discourse.group/t/upgrade-32-bit-to-64-bit/444/29 "2024-07-09T22:03:11Z")

</div>

How about

```auto
snap run nextcloud.occ group:removeuser admin trevor
snap run nextcloud.occ group:adduser admin trevor

```

Logout/login

---

<div class="post-metadata">

**Author:** ![trevorprinn](https://yyz2.discourse-cdn.com/free1/user_avatar/syncloud.discourse.group/trevorprinn/32/14_2.png) [@trevorprinn](https://syncloud.discourse.group/u/trevorprinn)\
**Post date:** [9 July 2024 22:12 UTC](https://syncloud.discourse.group/t/upgrade-32-bit-to-64-bit/444/30 "2024-07-09T22:12:46Z")

</div>

Made no difference 😞

---

<div class="post-metadata">

**Author:** ![trevorprinn](https://yyz2.discourse-cdn.com/free1/user_avatar/syncloud.discourse.group/trevorprinn/32/14_2.png) [@trevorprinn](https://syncloud.discourse.group/u/trevorprinn)\
**Post date:** [9 July 2024 23:20 UTC](https://syncloud.discourse.group/t/upgrade-32-bit-to-64-bit/444/31 "2024-07-09T23:20:00Z")

</div>

I’ve made sarah an admin from the cli and logged in on her account. That worked, but making me an admin from her account in the UI still doesn’t work. I add the admin group to my account but it disappears when I refresh or login as myself.

I’ve added the contacts and calendar apps using her account and imported the backups I made yesterday to my account and that has worked. I can probably make a separate admin account and just leave the mystery of why I can’t make myself an admin for the moment.

Gogs is still working fine. It recognises me as admin and also has the local accounts, and repos and orgs all seem to be there.

---

<div class="post-metadata">

**Author:** ![boris](https://avatars.discourse-cdn.com/v4/letter/b/74df32/32.png) [@boris](https://syncloud.discourse.group/u/boris)\
**Post date:** [10 July 2024 06:11 UTC](https://syncloud.discourse.group/t/upgrade-32-bit-to-64-bit/444/32 "2024-07-10T06:11:27Z")

</div>

Few more:

```auto
snap run nextcloud.occ ldap:check-user trevor

snap run nextcloud.occ ldap:show-config

```

---

<div class="post-metadata">

**Author:** ![trevorprinn](https://yyz2.discourse-cdn.com/free1/user_avatar/syncloud.discourse.group/trevorprinn/32/14_2.png) [@trevorprinn](https://syncloud.discourse.group/u/trevorprinn)\
**Post date:** [10 July 2024 06:56 UTC](https://syncloud.discourse.group/t/upgrade-32-bit-to-64-bit/444/33 "2024-07-10T06:56:15Z")

</div>

```auto
snap run nextcloud.occ ldap:check-user trevor
Cannot check user existence, because disabled LDAP configurations are present.

```

```auto
 snap run nextcloud.occ ldap:show-config
+-------------------------------+--------------------------------------------+
| Configuration | s01 |
+-------------------------------+--------------------------------------------+
| hasMemberOfFilterSupport | 0 |
| homeFolderNamingRule | |
| lastJpegPhotoLookup | 0 |
| ldapAdminGroup | |
| ldapAgentName | cn=admin,dc=syncloud,dc=org |
| ldapAgentPassword | *** |
| ldapAttributeAddress | |
| ldapAttributeBiography | |
| ldapAttributeFediverse | |
| ldapAttributeHeadline | |
| ldapAttributeOrganisation | |
| ldapAttributePhone | |
| ldapAttributeRole | |
| ldapAttributeTwitter | |
| ldapAttributeWebsite | |
| ldapAttributesForGroupSearch | |
| ldapAttributesForUserSearch | |
| ldapBackgroundHost | |
| ldapBackgroundPort | |
| ldapBackupHost | |
| ldapBackupPort | 389 |
| ldapBase | dc=syncloud,dc=org |
| ldapBaseGroups | ou=groups,dc=syncloud,dc=org |
| ldapBaseUsers | ou=users,dc=syncloud,dc=org |
| ldapCacheTTL | 600 |
| ldapConfigurationActive | 1 |
| ldapConnectionTimeout | 15 |
| ldapDefaultPPolicyDN | |
| ldapDynamicGroupMemberURL | |
| ldapEmailAttribute | mail |
| ldapExperiencedAdmin | 0 |
| ldapExpertUUIDGroupAttr | |
| ldapExpertUUIDUserAttr | |
| ldapExpertUsernameAttr | cn |
| ldapExtStorageHomeAttribute | |
| ldapGidNumber | gidNumber |
| ldapGroupDisplayName | cn |
| ldapGroupFilter | (&(|(objectclass=posixGroup))) |
| ldapGroupFilterGroups | |
| ldapGroupFilterMode | 0 |
| ldapGroupFilterObjectclass | posixGroup |
| ldapGroupMemberAssocAttr | memberUid |
| ldapHost | ldap://localhost |
| ldapIgnoreNamingRules | |
| ldapLoginFilter | (&(|(objectclass=inetOrgPerson))(cn=%uid)) |
| ldapLoginFilterAttributes | |
| ldapLoginFilterEmail | 0 |
| ldapLoginFilterMode | 0 |
| ldapLoginFilterUsername | 1 |
| ldapMatchingRuleInChainState | unknown |
| ldapNestedGroups | 0 |
| ldapOverrideMainServer | |
| ldapPagingSize | 500 |
| ldapPort | 389 |
| ldapQuotaAttribute | |
| ldapQuotaDefault | |
| ldapTLS | 0 |
| ldapUserAvatarRule | default |
| ldapUserDisplayName | cn |
| ldapUserDisplayName2 | |
| ldapUserFilter | (|(objectclass=inetOrgPerson)) |
| ldapUserFilterGroups | |
| ldapUserFilterMode | 0 |
| ldapUserFilterObjectclass | inetOrgPerson |
| ldapUuidGroupAttribute | auto |
| ldapUuidUserAttribute | auto |
| markRemnantsAsDisabled | 0 |
| turnOffCertCheck | 1 |
| turnOnPasswordChange | 0 |
| useMemberOfToDetectMembership | 1 |
+-------------------------------+--------------------------------------------+
+-------------------------------+-------------+
| Configuration | s02 |
+-------------------------------+-------------+
| hasMemberOfFilterSupport | 0 |
| homeFolderNamingRule | |
| lastJpegPhotoLookup | 0 |
| ldapAdminGroup | |
| ldapAgentName | |
| ldapAgentPassword | *** |
| ldapAttributeAddress | |
| ldapAttributeBiography | |
| ldapAttributeFediverse | |
| ldapAttributeHeadline | |
| ldapAttributeOrganisation | |
| ldapAttributePhone | |
| ldapAttributeRole | |
| ldapAttributeTwitter | |
| ldapAttributeWebsite | |
| ldapAttributesForGroupSearch | |
| ldapAttributesForUserSearch | |
| ldapBackgroundHost | |
| ldapBackgroundPort | |
| ldapBackupHost | |
| ldapBackupPort | |
| ldapBase | |
| ldapBaseGroups | |
| ldapBaseUsers | |
| ldapCacheTTL | 600 |
| ldapConfigurationActive | |
| ldapConnectionTimeout | 15 |
| ldapDefaultPPolicyDN | |
| ldapDynamicGroupMemberURL | |
| ldapEmailAttribute | |
| ldapExperiencedAdmin | 0 |
| ldapExpertUUIDGroupAttr | |
| ldapExpertUUIDUserAttr | |
| ldapExpertUsernameAttr | |
| ldapExtStorageHomeAttribute | |
| ldapGidNumber | gidNumber |
| ldapGroupDisplayName | cn |
| ldapGroupFilter | |
| ldapGroupFilterGroups | |
| ldapGroupFilterMode | 0 |
| ldapGroupFilterObjectclass | |
| ldapGroupMemberAssocAttr | |
| ldapHost | |
| ldapIgnoreNamingRules | |
| ldapLoginFilter | |
| ldapLoginFilterAttributes | |
| ldapLoginFilterEmail | 0 |
| ldapLoginFilterMode | 0 |
| ldapLoginFilterUsername | 1 |
| ldapMatchingRuleInChainState | unknown |
| ldapNestedGroups | 0 |
| ldapOverrideMainServer | |
| ldapPagingSize | 500 |
| ldapPort | |
| ldapQuotaAttribute | |
| ldapQuotaDefault | |
| ldapTLS | 0 |
| ldapUserAvatarRule | default |
| ldapUserDisplayName | displayName |
| ldapUserDisplayName2 | |
| ldapUserFilter | |
| ldapUserFilterGroups | |
| ldapUserFilterMode | 0 |
| ldapUserFilterObjectclass | |
| ldapUuidGroupAttribute | auto |
| ldapUuidUserAttribute | auto |
| markRemnantsAsDisabled | 0 |
| turnOffCertCheck | 0 |
| turnOnPasswordChange | 0 |
| useMemberOfToDetectMembership | 1 |
+-------------------------------+-------------+

```

---

<div class="post-metadata">

**Author:** ![trevorprinn](https://yyz2.discourse-cdn.com/free1/user_avatar/syncloud.discourse.group/trevorprinn/32/14_2.png) [@trevorprinn](https://syncloud.discourse.group/u/trevorprinn)\
**Post date:** [10 July 2024 08:16 UTC](https://syncloud.discourse.group/t/upgrade-32-bit-to-64-bit/444/34 "2024-07-10T08:16:22Z")

</div>

Just found another problem. I’ve been accessing the server from within my network. I hadn’t realised that it’s not accessible from the internet. The router setup is the same as before, forwarding ports 80 and 443 to the server.

 ![image](https://global.discourse-cdn.com/free1/uploads/syncloud/original/1X/a333e7f62634808ce6672cab7e72eccc71492354.png)

---

<div class="post-metadata">

**Author:** ![boris](https://avatars.discourse-cdn.com/v4/letter/b/74df32/32.png) [@boris](https://syncloud.discourse.group/u/boris)\
**Post date:** [10 July 2024 08:18 UTC](https://syncloud.discourse.group/t/upgrade-32-bit-to-64-bit/444/35 "2024-07-10T08:18:55Z")

</div>

Is there any error on save?

---

<div class="post-metadata">

**Author:** ![boris](https://avatars.discourse-cdn.com/v4/letter/b/74df32/32.png) [@boris](https://syncloud.discourse.group/u/boris)\
**Post date:** [10 July 2024 08:19 UTC](https://syncloud.discourse.group/t/upgrade-32-bit-to-64-bit/444/36 "2024-07-10T08:19:43Z")

</div>

Also can you create a separate thread per problem please?

---

<div class="post-metadata">

**Author:** ![boris](https://avatars.discourse-cdn.com/v4/letter/b/74df32/32.png) [@boris](https://syncloud.discourse.group/u/boris)\
**Post date:** [10 July 2024 08:21 UTC](https://syncloud.discourse.group/t/upgrade-32-bit-to-64-bit/444/37 "2024-07-10T08:21:52Z")

</div>

It would be good to try to find the problem with admin, can you remove the s02 (it was suggested in past by nextcloud to create this empty one but not needed anymore) config and try again?

```auto
snap run nextcloud.occ ldap:delete-config s02

```

Then

```auto
snap run nextcloud.occ ldap:check-user trevor

```

---

<div class="post-metadata">

**Author:** ![trevorprinn](https://yyz2.discourse-cdn.com/free1/user_avatar/syncloud.discourse.group/trevorprinn/32/14_2.png) [@trevorprinn](https://syncloud.discourse.group/u/trevorprinn)\
**Post date:** [10 July 2024 08:23 UTC](https://syncloud.discourse.group/t/upgrade-32-bit-to-64-bit/444/38 "2024-07-10T08:23:38Z")

</div>

> [@boris](#):
>
> Also can you create a separate thread per problem please?

Sorry. Actually, I just fixed that problem. For some reason, I had to add IPV6 firewall rules to the router.

---

<div class="post-metadata">

**Author:** ![trevorprinn](https://yyz2.discourse-cdn.com/free1/user_avatar/syncloud.discourse.group/trevorprinn/32/14_2.png) [@trevorprinn](https://syncloud.discourse.group/u/trevorprinn)\
**Post date:** [10 July 2024 08:34 UTC](https://syncloud.discourse.group/t/upgrade-32-bit-to-64-bit/444/39 "2024-07-10T08:34:10Z")

</div>

```auto
snap run nextcloud.occ ldap:delete-config s02
Deleted configuration with configID 's02'

snap run nextcloud.occ ldap:check-user trevor
The user is still available on LDAP.

```

That’s gone a long way to fixing it! The trevor account is now an admin. The only problem I can see is that the only User listed on the nextcloud users page is me, and under admins I can see me and sarah. The other users and the groups aren’t visible in that list

---

<div class="post-metadata">

**Author:** ![trevorprinn](https://yyz2.discourse-cdn.com/free1/user_avatar/syncloud.discourse.group/trevorprinn/32/14_2.png) [@trevorprinn](https://syncloud.discourse.group/u/trevorprinn)\
**Post date:** [10 July 2024 08:50 UTC](https://syncloud.discourse.group/t/upgrade-32-bit-to-64-bit/444/40 "2024-07-10T08:50:52Z")

</div>

All the users and groups, apart from trevor and the syncloud group, seem to have disappeared from the users app (or I no longer have access to them).

[Previous page](https://syncloud.discourse.group/t/upgrade-32-bit-to-64-bit/444.md?page=1)

[Next page](https://syncloud.discourse.group/t/upgrade-32-bit-to-64-bit/444.md?page=3)