Delete spreed signaling server account on Nextcloud Snap

[Moto]

Support intro

Sorry to hear you’re facing problems

help.nextcloud.com is for home/non-enterprise users. If you’re running a business, paid support can be accessed via portal.nextcloud.com where we can ensure your business keeps running smoothly.

In order to help you as quickly as possible, before clicking Create Topic please provide as much of the below as you can. Feel free to use a pastebin service for logs, otherwise either indent short log examples with four spaces:

example

Or for longer, use three backticks above and below the code snippet:

longer
example
here

Some or all of the below information will be requested if it isn’t supplied; for fastest response please provide as much as you can

Some useful links to gather information about your Nextcloud Talk installation:
Information about Signaling server: /index.php/index.php/settings/admin/talk#signaling_server
Information about TURN server: /index.php/settings/admin/talk#turn_server
Information about STUN server: /index.php/settings/admin/talk#stun_server

Nextcloud version (eg, 24.0.1): 32.0.5
Talk Server version (eg, 14.0.2): 22.0.6
Custom Signaling server configured: no
Custom TURN server configured: no
Custom STUN server configured: no

In case the web version of Nextcloud Talk is involved:
Operating system (eg, Windows/Ubuntu/…):
Browser name and version (eg, Chrome v101):

In case mobile Nextcloud Talk apps are involved:
Talk iOS version (eg, 14.0.2):
Talk Android version (eg, 14.0.2):

The issue you are facing:

Is this the first time you’ve seen this error? (Y/N): N

I tried out the hosted high-performance backend and no longer want to use it. According to Spreed.eu, it’s already been deleted. However, all the data is still displayed in my Nextcloud Snap instance. How can I delete it?

[scubamuc]

Hey @Moto, welcome to the Nextcloud community and thanks for supporting Nextcloud snap

Sorry to hear you are having issues with your Nextcloud snap installation. If you’ve come this far, you’re on the right track!

Below are some links to how-to’s answering frequently asked questions and may help you help yourself;

• How to install Nextcloud snap
• How to configure Nextcloud snap
• How to edit config.php for Nextcloud snap
• How to use OCC management console for Nextcloud snap
• How to revert Nextcloud snap after failed update
• How to manage failed automatic update in Nextcloud snap
• Nextcloud snap wiki and support

pay special attention to:

How to use OCC management console for Nextcloud snap

OCC management console for Nextcloud snap OCC management console OCC (Own Cloud Console) is a commandline management interface requiring root privileges and is accessed from the Nextcloud snap host shell [grafik] Nextcloud management console usage sudo nextcloud.occ TIP Some systems don’t add /snap/bin to the $PATH. Try sudo /snap/bin/nextcloud.occ Nextcloud management console help sudo nextcloud.occ --help View status sudo nextcloud.occ status List console functions sudo nextcloud.occ…

View apps in Nextcloud

sudo nextcloud.occ app:list

Disable apps

sudo nextcloud.occ app:disable <appname>

Remove apps

sudo nextcloud.occ app:remove <appname>

in your case

sudo nextcloud.occ app:remove spreed

alternatively see:

Apps management — Nextcloud latest Administration Manual latest documentation

[Moto]

Hi again,

it’s not about Spreed, I probably should have worded that differently. I’m trying to delete the entries under “hosted high-performance backend”. Is that possible?

[scubamuc]

so I’m doing what’s expected… reading the docs

WARNING: never copy & paste, always double check!

double check: sudo nextcloud.occ config:app:get spreed

OCC Help suggests: sudo nextcloud.occ config:app:delete spreed

[scubamuc]

Uh-oh, probably jumped the gun again sorry🤔. Looks like you need to remove those entries from the database: Hosted high-performance backend - cannot delete

so you’ll need to access the database sudo nextcloud.mysql-client and execute the following queries:

WARNING: never copy & paste, always double check!

DELETE FROM `oc_appconfig` WHERE `appid` = 'spreed' AND `configkey` = 'hosted-signaling-server-account'; 
DELETE FROM `oc_appconfig` WHERE `appid` = 'spreed' AND `configkey` = 'hosted-signaling-server-account-id'; 
DELETE FROM `oc_appconfig` WHERE `appid` = 'spreed' AND `configkey` = 'hosted-signaling-server-nonce'; 
DELETE FROM `oc_appconfig` WHERE `appid` = 'spreed' AND `configkey` = 'signaling_servers'; 
UPDATE `oc_appconfig` SET `configvalue` = 'internal' WHERE `appid` = 'spreed' AND `configkey` = 'signaling_mode';

please be aware, i’ve not tested this i’m hacking here

@Moto i must admit though, if this is the only method to reset those settings, then that’s something upstream would have to make more user friendly! if this doesn’t work, then we’ll have to wait for some clued up folks to help out…

@Moto

I probably should have worded that differently

I updated the topic heading to: “Delete spreed signaling server account on Nextcloud Snap”

[Moto]

Hi, I can access the database, it seems, but I can’t delete anything… do I need to enter something else?

[SysKeeper]

The command is wrong. There’s a “nextcloud” and a new line before the actual DELETE.

[SysKeeper]

@scubamuc

UPDATE `oc_appconfig` SET `configvalue` = 'internal' WHERE `appid` = 'spreed' AND `configkey` = 'signaling_mode';

This is should not be set. Also, please use occ commands instead of fiddling with the database.

[scubamuc]

@SysKeeper

@SysKeeper

please use occ commands instead of fiddling with the database

I’m at a loss for that occ command see Delete spreed signaling server account on Nextcloud Snap - #4 by scubamuc any hints?

[SysKeeper]

Sorry, didn’t see that

See here for details Error "Getting the account information failed: account not found" when HPB trial expired · Issue #9656 · nextcloud/spreed · GitHub

[scubamuc]

@SysKeeper thanks for that hint

@Moto here for the OCC commands for the snap:

sudo nextcloud.occ config:app:delete spreed hosted-signaling-server-account

sudo nextcloud.occ config:app:delete spreed hosted-signaling-server-account-id

sudo nextcloud.occ config:app:delete spreed signaling_mode

sudo nextcloud.occ config:app:delete spreed signaling_servers

[Moto]

I executed the commands without any error messages. However, there’s still data there…

I guess I’ll have to leave it like that, even though it’s visually annoying…

I’m still having the problem that the Windows version of Talk says the connection to the signaling server was lost immediately after starting. Could this be related to the entries that won’t disappear?

Talk on Windows works fine otherwise; it just displays the error message.

[SysKeeper]

@Moto

However, there’s still data there…

Which, where?

[Moto]

see my screenshot from the first post

[scubamuc]

@Moto maybe that’s a caching issue, please restart and see if that helps?

[Moto]

I tried using a completely different browser for testing, one I don’t log into constantly, and the data is still there too…

[scubamuc]

@Moto try running these commands again and restarting the snap afterwards

@scubamuc

sudo nextcloud.occ config:app:delete spreed hosted-signaling-server-account

sudo nextcloud.occ config:app:delete spreed hosted-signaling-server-account-id

sudo nextcloud.occ config:app:delete spreed signaling_mode

sudo nextcloud.occ config:app:delete spreed signaling_servers

sudo snap restart nextcloud

[Moto]

@scubamuc

sudo snap restart nextcloud

The data is still there. I’ve attached a screenshot from the terminal and a screenshot from the cloud log.

[scubamuc]

@Moto and @SysKeeper this doesn’t make sense at all.

please be clear, is the snap working, can you login to your cloud normally?

we’ll need your logs:

How to manage Nextcloud snap logs

Managing Nextcloud snap logs Managing Nextcloud snap logs Nextcloud snap logs In the event of an issue the Nextcloud logs could help figure out a probable cause. Most activities and actions in Nextcloud are logged. An automated log rotation mechanism within Nextcloud clears and retains the logs regularly to prevent an overflow. TIP Apps for viewing logs: Use your favourite viewer less, more, head, tail, cat, bat or lnav to view logs, sic. scubamuc > "less is more, from head to tail with ca…

so run the debugging script and post the results here.

[Moto]

Nextcloud Snap is running without any problems, and I can log in at any time.

The log is quite long. Should I really post it here?