Nextcloud Talk mobile app connection issues

ℹ️ Support
1
Server info

Server configuration detail

Operating system: Linux 6.1.0-11-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.1.38-4 (2023-08-08) x86_64

Webserver: Apache/2.4.57 (Debian) (fpm-fcgi)

Database: mysql 10.11.3

PHP version: 8.2.8

Modules loaded: Core, date, libxml, openssl, pcre, zlib, filter, hash, json, random, Reflection, SPL, session, standard, sodium, cgi-fcgi, mysqlnd, PDO, xml, apcu, bcmath, calendar, ctype, curl, dom, mbstring, FFI, fileinfo, ftp, gd, gettext, gmp, iconv, imagick, intl, exif, mysqli, pdo_mysql, Phar, posix, readline, shmop, SimpleXML, sockets, sysvmsg, sysvsem, sysvshm, tokenizer, xmlreader, xmlrpc, xmlwriter, xsl, zip, Zend OPcache

Nextcloud version: 27.0.2 - 27.0.2.1

Updated from an older Nextcloud/ownCloud or fresh install:

Where did you install Nextcloud from: unknown

Signing status

List of activated apps 
Enabled:
 - activity: 2.19.0
 - calendar: 4.4.4
 - circles: 27.0.1
 - cloud_federation_api: 1.10.0
 - contacts: 5.3.2
 - contactsinteraction: 1.8.0
 - dashboard: 7.7.0
 - dav: 1.27.0
 - federatedfilesharing: 1.17.0
 - federation: 1.17.0
 - files: 1.22.0
 - files_pdfviewer: 2.8.0
 - files_rightclick: 1.6.0
 - files_sharing: 1.19.0
 - files_trashbin: 1.17.0
 - files_versions: 1.20.0
 - firstrunwizard: 2.16.0
 - logreader: 2.12.0
 - lookup_server_connector: 1.15.0
 - mail: 3.3.0
 - maps: 1.1.0
 - nextcloud_announcements: 1.16.0
 - notifications: 2.15.0
 - oauth2: 1.15.1
 - password_policy: 1.17.0
 - photos: 2.3.0
 - privacy: 1.11.0
 - provisioning_api: 1.17.0
 - related_resources: 1.2.0
 - serverinfo: 1.17.0
 - settings: 1.9.0
 - sharebymail: 1.17.0
 - spreed: 17.0.3
 - support: 1.10.0
 - survey_client: 1.15.0
 - text: 3.8.0
 - theming: 2.2.0
 - twofactor_backupcodes: 1.16.0
 - unsplash: 2.2.1
 - updatenotification: 1.17.0
 - user_status: 1.7.0
 - viewer: 2.1.0
 - weather_status: 1.7.0
 - workflowengine: 2.9.0
Disabled:
 - admin_audit
 - bruteforcesettings
 - comments: 1.17.0
 - encryption
 - files_external
 - recommendations: 1.6.0
 - suspicious_login
 - systemtags: 1.17.0
 - twofactor_totp
 - user_ldap
Configuration (config/config.php) 
{
    "instanceid": "***REMOVED SENSITIVE VALUE***",
    "passwordsalt": "***REMOVED SENSITIVE VALUE***",
    "secret": "***REMOVED SENSITIVE VALUE***",
    "trusted_domains": [
        "cloud.straysonlineplayground.xyz"
    ],
    "datadirectory": "***REMOVED SENSITIVE VALUE***",
    "dbtype": "mysql",
    "version": "27.0.2.1",
    "overwrite.cli.url": "https:\/\/cloud.straysonlineplayground.xyz",
    "dbname": "***REMOVED SENSITIVE VALUE***",
    "dbhost": "***REMOVED SENSITIVE VALUE***",
    "dbport": "",
    "dbtableprefix": "oc_",
    "mysql.utf8mb4": true,
    "dbuser": "***REMOVED SENSITIVE VALUE***",
    "dbpassword": "***REMOVED SENSITIVE VALUE***",
    "installed": true,
    "mail_smtpmode": "sendmail",
    "mail_sendmailmode": "smtp",
    "mail_from_address": "***REMOVED SENSITIVE VALUE***",
    "mail_domain": "***REMOVED SENSITIVE VALUE***",
    "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
    "mail_smtpport": "587",
    "mail_smtpauth": 1,
    "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
    "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
    "default_phone_region": "US",
    "memcache.local": "\\OC\\Memcache\\APCu",
    "maintenance": false,
    "theme": "",
    "loglevel": 2,
    "app_install_overwrite": [
        "money"
    ]
}

Cron Configuration: Array
(
[backgroundjobs_mode] => cron
[lastcron] => 1692722705
)

External storages: files_external is disabled

Encryption: no

User-backends:

  • OC\User\Database

Talk configuration:

STUN servers

TURN servers

Signaling servers (mode: default):

Browser: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/116.0

The issue I am facing: I have 6 users in my Nextcloud instance, 2 are of my young children. I mostly have them for them to communicate via the Talk app with one another while they are playing games with each other, or to call me when they want to talk to me while I am away from the house (I’m a truck driver, so that is 90% of the time). When I first installed it, it worked great, video calls worked great between the 2 of them, and even to me. About 3 months in, the kids cannot video call each other. Well, they can, but the image freezes. Audio still works. One can call me, or I can call one, but not both at the same time. If I call both at the same time, the connection won’t happen. I have restarted the server, cleared the cache, reset the app on the kids’ device, uninstall and reinstalled the app, restarted my home network, and nothing seems to fix it. This has been going on for about a month now.

I have done a little digging, and I found that people were having no problems connecting via LAN, but having problems connecting outside network, but mine is reversed. Kids’ devices are old cell phones that only connect via WiFi. There is no problems when using the PC.

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

The output of your Nextcloud log in Admin > Logging:

Log to one specific user, which I feel may be useful?

[no app in context] Error: OC\DB\Exceptions\DbalException: An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘[{USER}]’ for key ‘user_status_uid_ix’ at <>

  1. /var/www/cloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 328
    OC\DB\Exceptions\DbalException::wrap()
  2. /var/www/cloud/lib/public/AppFramework/Db/QBMapper.php line 137
    OC\DB\QueryBuilder\QueryBuilder->executeStatement()
  3. /var/www/cloud/apps/user_status/lib/Service/StatusService.php line 299
    OCP\AppFramework\Db\QBMapper->insert()
  4. /var/www/cloud/apps/user_status/lib/Connector/UserStatusProvider.php line 61
    OCA\UserStatus\Service\StatusService->setUserStatus()
  5. /var/www/cloud/lib/private/UserStatus/Manager.php line 113
    OCA\UserStatus\Connector\UserStatusProvider->setUserStatus()
  6. /var/www/cloud/apps/spreed/lib/Status/Listener.php line 77
    OC\UserStatus\Manager->setUserStatus()
  7. /var/www/cloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 251
    OCA\Talk\Status\Listener::setUserStatus()
  8. /var/www/cloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 73
    Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
  9. /var/www/cloud/lib/private/EventDispatcher/EventDispatcher.php line 94
    Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
  10. /var/www/cloud/apps/spreed/lib/Service/ParticipantService.php line 1082
    OC\EventDispatcher\EventDispatcher->dispatch()
  11. /var/www/cloud/apps/spreed/lib/Controller/CallController.php line 128
    OCA\Talk\Service\ParticipantService->changeInCall()
  12. /var/www/cloud/lib/private/AppFramework/Http/Dispatcher.php line 230
    OCA\Talk\Controller\CallController->joinCall()
  13. /var/www/cloud/lib/private/AppFramework/Http/Dispatcher.php line 137
    OC\AppFramework\Http\Dispatcher->executeController()
  14. /var/www/cloud/lib/private/AppFramework/App.php line 183
    OC\AppFramework\Http\Dispatcher->dispatch()
  15. /var/www/cloud/lib/private/Route/Router.php line 315
    OC\AppFramework\App::main()
  16. /var/www/cloud/ocs/v1.php line 64
    OC\Route\Router->match()
  17. /var/www/cloud/ocs/v2.php line 23
    require_once(“/var/www/cloud/ocs/v1.php”)

Caused by:

Doctrine\DBAL\Exception\UniqueConstraintViolationException: An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘[{USER}]’ for key ‘user_status_uid_ix’ at <>

  1. /var/www/cloud/3rdparty/doctrine/dbal/src/Connection.php line 1814
    Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert()
  2. /var/www/cloud/3rdparty/doctrine/dbal/src/Connection.php line 1749
    Doctrine\DBAL\Connection->handleDriverException()
  3. /var/www/cloud/3rdparty/doctrine/dbal/src/Connection.php line 1163
    Doctrine\DBAL\Connection->convertExceptionDuringQuery()
  4. /var/www/cloud/lib/private/DB/Connection.php line 295
    Doctrine\DBAL\Connection->executeStatement()
  5. /var/www/cloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php line 354
    OC\DB\Connection->executeStatement()
  6. /var/www/cloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 280
    Doctrine\DBAL\Query\QueryBuilder->execute()
  7. /var/www/cloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 326
    OC\DB\QueryBuilder\QueryBuilder->execute()
  8. /var/www/cloud/lib/public/AppFramework/Db/QBMapper.php line 137
    OC\DB\QueryBuilder\QueryBuilder->executeStatement()
  9. /var/www/cloud/apps/user_status/lib/Service/StatusService.php line 299
    OCP\AppFramework\Db\QBMapper->insert()
  10. /var/www/cloud/apps/user_status/lib/Connector/UserStatusProvider.php line 61
    OCA\UserStatus\Service\StatusService->setUserStatus()
  11. /var/www/cloud/lib/private/UserStatus/Manager.php line 113
    OCA\UserStatus\Connector\UserStatusProvider->setUserStatus()
  12. /var/www/cloud/apps/spreed/lib/Status/Listener.php line 77
    OC\UserStatus\Manager->setUserStatus()
  13. /var/www/cloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 251
    OCA\Talk\Status\Listener::setUserStatus()
  14. /var/www/cloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 73
    Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
  15. /var/www/cloud/lib/private/EventDispatcher/EventDispatcher.php line 94
    Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
  16. /var/www/cloud/apps/spreed/lib/Service/ParticipantService.php line 1082
    OC\EventDispatcher\EventDispatcher->dispatch()
  17. /var/www/cloud/apps/spreed/lib/Controller/CallController.php line 128
    OCA\Talk\Service\ParticipantService->changeInCall()
  18. /var/www/cloud/lib/private/AppFramework/Http/Dispatcher.php line 230
    OCA\Talk\Controller\CallController->joinCall()
  19. /var/www/cloud/lib/private/AppFramework/Http/Dispatcher.php line 137
    OC\AppFramework\Http\Dispatcher->executeController()
  20. /var/www/cloud/lib/private/AppFramework/App.php line 183
    OC\AppFramework\Http\Dispatcher->dispatch()
  21. /var/www/cloud/lib/private/Route/Router.php line 315
    OC\AppFramework\App::main()
  22. /var/www/cloud/ocs/v1.php line 64
    OC\Route\Router->match()
  23. /var/www/cloud/ocs/v2.php line 23
    require_once(“/var/www/cloud/ocs/v1.php”)

Caused by:

Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘[{USER}]’ for key ‘user_status_uid_ix’ at <>

  1. /var/www/cloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php line 103
    Doctrine\DBAL\Driver\PDO\Exception::new()
  2. /var/www/cloud/3rdparty/doctrine/dbal/src/Connection.php line 1153
    Doctrine\DBAL\Driver\PDO\Statement->execute()
  3. /var/www/cloud/lib/private/DB/Connection.php line 295
    Doctrine\DBAL\Connection->executeStatement()
  4. /var/www/cloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php line 354
    OC\DB\Connection->executeStatement()
  5. /var/www/cloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 280
    Doctrine\DBAL\Query\QueryBuilder->execute()
  6. /var/www/cloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 326
    OC\DB\QueryBuilder\QueryBuilder->execute()
  7. /var/www/cloud/lib/public/AppFramework/Db/QBMapper.php line 137
    OC\DB\QueryBuilder\QueryBuilder->executeStatement()
  8. /var/www/cloud/apps/user_status/lib/Service/StatusService.php line 299
    OCP\AppFramework\Db\QBMapper->insert()
  9. /var/www/cloud/apps/user_status/lib/Connector/UserStatusProvider.php line 61
    OCA\UserStatus\Service\StatusService->setUserStatus()
  10. /var/www/cloud/lib/private/UserStatus/Manager.php line 113
    OCA\UserStatus\Connector\UserStatusProvider->setUserStatus()
  11. /var/www/cloud/apps/spreed/lib/Status/Listener.php line 77
    OC\UserStatus\Manager->setUserStatus()
  12. /var/www/cloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 251
    OCA\Talk\Status\Listener::setUserStatus()
  13. /var/www/cloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 73
    Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
  14. /var/www/cloud/lib/private/EventDispatcher/EventDispatcher.php line 94
    Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
  15. /var/www/cloud/apps/spreed/lib/Service/ParticipantService.php line 1082
    OC\EventDispatcher\EventDispatcher->dispatch()
  16. /var/www/cloud/apps/spreed/lib/Controller/CallController.php line 128
    OCA\Talk\Service\ParticipantService->changeInCall()
  17. /var/www/cloud/lib/private/AppFramework/Http/Dispatcher.php line 230
    OCA\Talk\Controller\CallController->joinCall()
  18. /var/www/cloud/lib/private/AppFramework/Http/Dispatcher.php line 137
    OC\AppFramework\Http\Dispatcher->executeController()
  19. /var/www/cloud/lib/private/AppFramework/App.php line 183
    OC\AppFramework\Http\Dispatcher->dispatch()
  20. /var/www/cloud/lib/private/Route/Router.php line 315
    OC\AppFramework\App::main()
  21. /var/www/cloud/ocs/v1.php line 64
    OC\Route\Router->match()
  22. /var/www/cloud/ocs/v2.php line 23
    require_once(“/var/www/cloud/ocs/v1.php”)

Caused by:

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘[{USER}]’ for key ‘user_status_uid_ix’ at <>

  1. /var/www/cloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php line 101
    PDOStatement->execute()
  2. /var/www/cloud/3rdparty/doctrine/dbal/src/Connection.php line 1153
    Doctrine\DBAL\Driver\PDO\Statement->execute()
  3. /var/www/cloud/lib/private/DB/Connection.php line 295
    Doctrine\DBAL\Connection->executeStatement()
  4. /var/www/cloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php line 354
    OC\DB\Connection->executeStatement()
  5. /var/www/cloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 280
    Doctrine\DBAL\Query\QueryBuilder->execute()
  6. /var/www/cloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 326
    OC\DB\QueryBuilder\QueryBuilder->execute()
  7. /var/www/cloud/lib/public/AppFramework/Db/QBMapper.php line 137
    OC\DB\QueryBuilder\QueryBuilder->executeStatement()
  8. /var/www/cloud/apps/user_status/lib/Service/StatusService.php line 299
    OCP\AppFramework\Db\QBMapper->insert()
  9. /var/www/cloud/apps/user_status/lib/Connector/UserStatusProvider.php line 61
    OCA\UserStatus\Service\StatusService->setUserStatus()
  10. /var/www/cloud/lib/private/UserStatus/Manager.php line 113
    OCA\UserStatus\Connector\UserStatusProvider->setUserStatus()
  11. /var/www/cloud/apps/spreed/lib/Status/Listener.php line 77
    OC\UserStatus\Manager->setUserStatus()
  12. /var/www/cloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 251
    OCA\Talk\Status\Listener::setUserStatus()
  13. /var/www/cloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 73
    Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
  14. /var/www/cloud/lib/private/EventDispatcher/EventDispatcher.php line 94
    Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
  15. /var/www/cloud/apps/spreed/lib/Service/ParticipantService.php line 1082
    OC\EventDispatcher\EventDispatcher->dispatch()
  16. /var/www/cloud/apps/spreed/lib/Controller/CallController.php line 128
    OCA\Talk\Service\ParticipantService->changeInCall()
  17. /var/www/cloud/lib/private/AppFramework/Http/Dispatcher.php line 230
    OCA\Talk\Controller\CallController->joinCall()
  18. /var/www/cloud/lib/private/AppFramework/Http/Dispatcher.php line 137
    OC\AppFramework\Http\Dispatcher->executeController()
  19. /var/www/cloud/lib/private/AppFramework/App.php line 183
    OC\AppFramework\Http\Dispatcher->dispatch()
  20. /var/www/cloud/lib/private/Route/Router.php line 315
    OC\AppFramework\App::main()
  21. /var/www/cloud/ocs/v1.php line 64
    OC\Route\Router->match()
  22. /var/www/cloud/ocs/v2.php line 23
    require_once(“/var/www/cloud/ocs/v1.php”)

POST /ocs/v2.php/apps/spreed/api/v4/call/rribraxd
from 72.204.29.204 by [{USER}] at 2023-08-22T16:21:12+00:00

The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):

See under Server info above

The output of your Apache/nginx/system log in /var/log/____:

Apache error log

[Tue Aug 22 09:23:10.485728 2023] [proxy:error] [pid 739:tid 140186524579520] (2)No such file or directory: AH02454: FCGI: attempt to connect to Unix domain socket /run/php/php8.2-fpm.sock (*:80) failed
[Tue Aug 22 09:23:10.485791 2023] [proxy_fcgi:error] [pid 739:tid 140186524579520] [client 194.156.136.192:53996] AH01079: failed to make connection to backend: httpd-UDS
[Tue Aug 22 10:24:37.983751 2023] [access_compat:error] [pid 739:tid 140186381969088] [client 194.156.136.192:46424] AH01797: client denied by server configuration: /var/www/cloud/data/.ocdata
[Tue Aug 22 10:41:33.316516 2023] [access_compat:error] [pid 738:tid 140186499401408] [client 194.156.136.192:18256] AH01797: client denied by server configuration: /var/www/cloud/data/.ocdata
[Tue Aug 22 10:44:55.004097 2023] [access_compat:error] [pid 739:tid 140185467590336] [client 194.156.136.192:6116] AH01797: client denied by server configuration: /var/www/cloud/data/.ocdata
[Tue Aug 22 11:38:34.246124 2023] [access_compat:error] [pid 739:tid 140186340005568] [client 194.156.136.192:57166] AH01797: client denied by server configuration: /var/www/cloud/data/.ocdata

Output errors in nextcloud.log in /var/www/ or as admin user in top right menu, filtering for errors. Use a pastebin service if necessary.

Info

Only recent error logs are caused by a recent change to adding a STUN and TURN server in an attempt to fix the problem. Aside from the user error posted above. Other errors were related to my phone failing to sign in for CalDav app. Forgot to change the password on the app after changing password for my account.

1 Like