Failed to start Spreed WebRTC server

hustenfrei · December 11, 2016, 12:23pm

After install spreedme I cannot press “Generate Spreed WebRTC config”.

Step 3) i: of this manual: nextcloud-spreedme/README.md at master · strukturag/nextcloud-spreedme · GitHub

Any idea?

Same with the button “Show advanced settings”

“Save settings” results into a blank page.

leon · December 12, 2016, 9:54am

What’s happens if you click the Generate Spreed WebRTC config button?
Please enable Nextcloud’s debug mode (i.e. add 'debug' => true, to the Nextcloud config/config.php), open your browser’s developer console and paste its output here.

hustenfrei · December 12, 2016, 11:12am

Set ‘debug’ => true,
Restarted apache
Opened Firefox Console
Pressed “Generate Spreed WebRTC config”
Nothing happened:

MichaIng · December 19, 2016, 3:07pm

Did you check folder permissions? After setting strong folder permissions your http-user might not be able to write the config file anymore. Read here about that: https://docs.nextcloud.com/server/11/admin_manual/maintenance/update.html#setting-permissions-for-updating

nitroese · December 19, 2016, 3:30pm

Hi my webrtc/spreed.me stuff runs fine… i have done the config manually and not with the app…so you get also a “OwnCloudConfig.js”.
It is a great video guide at this site https://nextcloud.com/webrtc/ …just scroll a bit down… at the end of video there ist the way to go to generate the config manually. The Guide works very well from a-z

What u need starts at 8:59 but maybe u should looking the part of server configuration to…because of shared secrets etc…

this should help you
regards

leon · December 22, 2016, 2:30pm

Have you checked the Nextcloud and/or web server error log?

hustenfrei · December 26, 2016, 1:11am

I don’t know why, but now pressing “Generate …” is working.

Followed the manual above:

Installed SpreedWebRTC from repositories
Replaced content of /etc/spreed/webrtc.conf with the result of Admin-Page
Configured Apache
Restarted services spreed-webrtc and apache2

Get this error when calling the app:

The Admin-Page is still showing me this:

hustenfrei · December 26, 2016, 1:44am

Nextcloud log, level Info. Apache mismatch configuration!?!?

Error core
Error while running background job (Doctrine\DBAL\Exception\SyntaxErrorException): An exception occurred while executing ‘DELETE FROM oc_activity_mq WHERE amq_timestamp <= ? AND amq_affecteduser IN ()’ with params [1482715802]: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)’ at line 1

OCA\Activity\BackgroundJob\EmailNotification ):
/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php - line 128: Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\DBAL\Driver\PDOException))
/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Statement.php - line 177: Doctrine\DBAL\DBALException driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(Doctrine\DBAL\Driver\PDOException), 'DELETE FROM `oc...', Array)
/var/www/nextcloud/apps/activity/lib/MailQueueHandler.php - line 334: Doctrine\DBAL\Statement->execute(Array)
/var/www/nextcloud/apps/activity/lib/BackgroundJob/EmailNotification.php - line 131: OCA\Activity\MailQueueHandler->deleteSentItems(Array, 1482715802)
/var/www/nextcloud/apps/activity/lib/BackgroundJob/EmailNotification.php - line 81: OCA\Activity\BackgroundJob\EmailNotification->runStep(500, 1482715802)
/var/www/nextcloud/lib/private/BackgroundJob/Job.php - line 53: OCA\Activity\BackgroundJob\EmailNotification->run(NULL)
/var/www/nextcloud/lib/private/BackgroundJob/TimedJob.php - line 54: OC\BackgroundJob\Job->execute(Object(OC\BackgroundJob\JobList), Object(OC\Log))
/var/www/nextcloud/cron.php - line 121: OC\BackgroundJob\TimedJob->execute(Object(OC\BackgroundJob\JobList), Object(OC\Log))
{main} 2016-12-26T02:30:03+0100
Warning core Trusted domain error. “163.172.68.183” tried to access using “79.207.239.223” as host. 2016-12-26T02:07:37+0100

Warning core Login failed: ‘system’ (Remote IP: ‘79.207.239.223’) 2016-12-26T01:45:02+0100

Error core
Error while running background job (Doctrine\DBAL\Exception\SyntaxErrorException): An exception occurred while executing ‘DELETE FROM oc_activity_mq WHERE amq_timestamp <= ? AND amq_affecteduser IN ()’ with params [1482712202]: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)’ at line 1

OCA\Activity\BackgroundJob\EmailNotification ):
/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php - line 128: Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\DBAL\Driver\PDOException))
/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Statement.php - line 177: Doctrine\DBAL\DBALException driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(Doctrine\DBAL\Driver\PDOException), 'DELETE FROM `oc...', Array)
/var/www/nextcloud/apps/activity/lib/MailQueueHandler.php - line 334: Doctrine\DBAL\Statement->execute(Array)
/var/www/nextcloud/apps/activity/lib/BackgroundJob/EmailNotification.php - line 131: OCA\Activity\MailQueueHandler->deleteSentItems(Array, 1482712202)
/var/www/nextcloud/apps/activity/lib/BackgroundJob/EmailNotification.php - line 81: OCA\Activity\BackgroundJob\EmailNotification->runStep(500, 1482712202)
/var/www/nextcloud/lib/private/BackgroundJob/Job.php - line 53: OCA\Activity\BackgroundJob\EmailNotification->run(NULL)
/var/www/nextcloud/lib/private/BackgroundJob/TimedJob.php - line 54: OC\BackgroundJob\Job->execute(Object(OC\BackgroundJob\JobList), Object(OC\Log))
/var/www/nextcloud/cron.php - line 121: OC\BackgroundJob\TimedJob->execute(Object(OC\BackgroundJob\JobList), Object(OC\Log))
{main} 2016-12-26T01:30:03+0100
Error core
Error while running background job (Doctrine\DBAL\Exception\SyntaxErrorException): An exception occurred while executing ‘DELETE FROM oc_activity_mq WHERE amq_timestamp <= ? AND amq_affecteduser IN ()’ with params [1482710401]: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)’ at line 1

OCA\Activity\BackgroundJob\EmailNotification ):
/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php - line 128: Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\DBAL\Driver\PDOException))
/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Statement.php - line 177: Doctrine\DBAL\DBALException driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(Doctrine\DBAL\Driver\PDOException), 'DELETE FROM `oc...', Array)
/var/www/nextcloud/apps/activity/lib/MailQueueHandler.php - line 334: Doctrine\DBAL\Statement->execute(Array)
/var/www/nextcloud/apps/activity/lib/BackgroundJob/EmailNotification.php - line 131: OCA\Activity\MailQueueHandler->deleteSentItems(Array, 1482710401)
/var/www/nextcloud/apps/activity/lib/BackgroundJob/EmailNotification.php - line 81: OCA\Activity\BackgroundJob\EmailNotification->runStep(500, 1482710401)
/var/www/nextcloud/lib/private/BackgroundJob/Job.php - line 53: OCA\Activity\BackgroundJob\EmailNotification->run(NULL)
/var/www/nextcloud/lib/private/BackgroundJob/TimedJob.php - line 54: OC\BackgroundJob\Job->execute(Object(OC\BackgroundJob\JobList), Object(OC\Log))
/var/www/nextcloud/cron.php - line 121: OC\BackgroundJob\TimedJob->execute(Object(OC\BackgroundJob\JobList), Object(OC\Log))
{main} 2016-12-26T01:00:02+0100
Error core
Error while running background job (Doctrine\DBAL\Exception\SyntaxErrorException): An exception occurred while executing ‘DELETE FROM oc_activity_mq WHERE amq_timestamp <= ? AND amq_affecteduser IN ()’ with params [1482715802]: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)’ at line 1 2016-12-26T02:30:03+0100
Warning core Trusted domain error. “163.172.68.183” tried to access using “79.207.239.223” as host. 2016-12-26T02:07:37+0100

Warning core
Login failed: ‘system’ (Remote IP: ‘79.207.239.223’) 2016-12-26T01:45:02+0100
Error core Error while running background job (Doctrine\DBAL\Exception\SyntaxErrorException): An exception occurred while executing ‘DELETE FROM oc_activity_mq WHERE amq_timestamp <= ? AND amq_affecteduser IN ()’ with params [1482712202]: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)’ at line 1 2016-12-26T01:30:03+0100

hustenfrei · December 26, 2016, 10:36am

“service spreed-webrts start” in syslog:

Dec 26 11:29:52 owncloud systemd[1]: Stopped Spreed WebRTC server.
Dec 26 11:29:56 owncloud systemd[1]: Started Spreed WebRTC server.
Dec 26 11:29:56 owncloud systemd[1]: spreed-webrtc.service: Main process exited, code=exited, status=255/n/a
Dec 26 11:29:56 owncloud systemd[1]: spreed-webrtc.service: Unit entered failed state.
Dec 26 11:29:56 owncloud systemd[1]: spreed-webrtc.service: Failed with result ‘exit-code’.
Dec 26 11:29:56 owncloud systemd[1]: spreed-webrtc.service: Service hold-off time over, scheduling restart.
Dec 26 11:29:56 owncloud systemd[1]: Stopped Spreed WebRTC server.
Dec 26 11:29:56 owncloud systemd[1]: Started Spreed WebRTC server.
Dec 26 11:29:56 owncloud systemd[1]: spreed-webrtc.service: Main process exited, code=exited, status=255/n/a
Dec 26 11:29:56 owncloud systemd[1]: spreed-webrtc.service: Unit entered failed state.
Dec 26 11:29:56 owncloud systemd[1]: spreed-webrtc.service: Failed with result ‘exit-code’.
Dec 26 11:29:56 owncloud systemd[1]: spreed-webrtc.service: Service hold-off time over, scheduling restart.
Dec 26 11:29:56 owncloud systemd[1]: Stopped Spreed WebRTC server.
Dec 26 11:29:56 owncloud systemd[1]: Started Spreed WebRTC server.
Dec 26 11:29:56 owncloud systemd[1]: spreed-webrtc.service: Main process exited, code=exited, status=255/n/a
Dec 26 11:29:56 owncloud systemd[1]: spreed-webrtc.service: Unit entered failed state.
Dec 26 11:29:56 owncloud systemd[1]: spreed-webrtc.service: Failed with result ‘exit-code’.
Dec 26 11:29:57 owncloud systemd[1]: spreed-webrtc.service: Service hold-off time over, scheduling restart.
Dec 26 11:29:57 owncloud systemd[1]: Stopped Spreed WebRTC server.
Dec 26 11:29:57 owncloud systemd[1]: Started Spreed WebRTC server.
Dec 26 11:29:57 owncloud systemd[1]: spreed-webrtc.service: Main process exited, code=exited, status=255/n/a
Dec 26 11:29:57 owncloud systemd[1]: spreed-webrtc.service: Unit entered failed state.
Dec 26 11:29:57 owncloud systemd[1]: spreed-webrtc.service: Failed with result ‘exit-code’.
Dec 26 11:29:57 owncloud systemd[1]: spreed-webrtc.service: Service hold-off time over, scheduling restart.
Dec 26 11:29:57 owncloud systemd[1]: Stopped Spreed WebRTC server.
Dec 26 11:29:57 owncloud systemd[1]: Started Spreed WebRTC server.
Dec 26 11:29:57 owncloud systemd[1]: spreed-webrtc.service: Main process exited, code=exited, status=255/n/a
Dec 26 11:29:57 owncloud systemd[1]: spreed-webrtc.service: Unit entered failed state.
Dec 26 11:29:57 owncloud systemd[1]: spreed-webrtc.service: Failed with result ‘exit-code’.
Dec 26 11:29:57 owncloud systemd[1]: spreed-webrtc.service: Service hold-off time over, scheduling restart.
Dec 26 11:29:57 owncloud systemd[1]: Stopped Spreed WebRTC server.
Dec 26 11:29:57 owncloud systemd[1]: spreed-webrtc.service: Start request repeated too quickly.
Dec 26 11:29:57 owncloud systemd[1]: Failed to start Spreed WebRTC server.

hustenfrei · December 26, 2016, 10:49am

tail -f /var/log/spreed/webrtc/server.log

server 2016/12/26 11:29:56 Unable to find client. Path correct and compiled css?
server 2016/12/26 11:29:56 Unable to find client. Path correct and compiled css?
server 2016/12/26 11:29:56 Unable to find client. Path correct and compiled css?
server 2016/12/26 11:29:57 Unable to find client. Path correct and compiled css?
server 2016/12/26 11:29:57 Unable to find client. Path correct and compiled css?

hustenfrei · December 26, 2016, 10:59am

These both folders are still empty. Is this correct?

ll /var/www/nextcloud/apps/spreedme/config/
total 12
drwxr-xr-x  2 www-data www-data 4096 Dec 26 00:55 ./
drwxr-xr-x 18 www-data www-data 4096 Dec 26 00:55 ../
-rw-r--r--  1 www-data www-data 1978 Dec 26 00:55 config.php.in


ll /var/www/nextcloud/apps/spreedme/extra/static/config/
total 12
drwxr-xr-x 2 www-data www-data 4096 Dec 26 00:55 ./
drwxr-xr-x 5 www-data www-data 4096 Dec 26 00:55 ../
-rw-r--r-- 1 www-data www-data  830 Dec 26 00:55 OwnCloudConfig.js.in

hustenfrei · December 26, 2016, 11:04am

Actual Spreed.ME config in Admin-Page:

nitroese · December 26, 2016, 12:56pm

Have u ever watched the video wich i posted and / or following the video guide step by step, so that u generate the config manually ?

hustenfrei · December 26, 2016, 1:58pm

Thanks @nitroese.

I think the only different is that I used Ubuntu repositories. You downloaded and compiled manually from github?

hustenfrei · December 26, 2016, 2:30pm

No way:

service spreed-webrtc restart

results into

server 2016/12/26 14:55:25 Unable to find client. Path correct and compiled css?

hustenfrei · December 26, 2016, 3:03pm

$ sudo systemctl status spreed-webrtc

● spreed-webrtc.service - Spreed WebRTC server
   Loaded: loaded (/lib/systemd/system/spreed-webrtc.service; enabled; vendor preset: enabled)
   Active: inactive (dead) (Result: exit-code) since Mon 2016-12-26 15:22:44 CET; 36min ago
  Process: 33533 ExecStart=/usr/sbin/spreed-webrtc-server -c ${WEBRTC_CONF} -l ${WEBRTC_LOG} ${WEBRTC_ARGS} (code=e
 Main PID: 33533 (code=exited, status=255)

Dec 26 15:22:44 owncloud systemd[1]: spreed-webrtc.service: Unit entered failed state.
Dec 26 15:22:44 owncloud systemd[1]: spreed-webrtc.service: Failed with result 'exit-code'.
Dec 26 15:22:44 owncloud systemd[1]: spreed-webrtc.service: Service hold-off time over, scheduling restart.
Dec 26 15:22:44 owncloud systemd[1]: Stopped Spreed WebRTC server.
Dec 26 15:22:44 owncloud systemd[1]: spreed-webrtc.service: Start request repeated too quickly.
Dec 26 15:22:44 owncloud systemd[1]: Failed to start Spreed WebRTC server.

hustenfrei · December 26, 2016, 5:59pm

OMG … got it:

In /etc/spreed/webrtc.conf I had to add this to **http** section:

root = /usr/share/spreed-webrtc-server/www/

If installed from repositories for Ubuntu seems to be mandatory.

@spreed.me developers: Please add this to your documentation / installation scripts!!!

Found solution here: https://github.com/strukturag/spreed-webrtc/issues/383#issuecomment-257289125

PS: I’m using the stable repositories:

$ sudo apt-add-repository ppa:strukturag/spreed-webrtc
$ sudo apt-get update
$ sudo apt-get install spreed-webrtc

B4ALLB4U · July 7, 2018, 12:19pm

Hi Nitrosee, I am also unable to configure Spreed.ME on my linux shared server. Except this everything is working fine on NC 13 version.

error details

config/config.php was not found. We will use the Nextcloud database to read/write config values.

You can change them here:
A new SPREED_WEBRTC_CONFIG was generated.
Simply remove everything from your current server.conf and paste the new config in instead.
Restart Spreed WebRTC afterwards.

; Minimal Spreed WebRTC configuration for Nextcloud

[http]
listen = 127.0.0.1:8080
basePath =
;root = /usr/share/spreed-webrtc-server/www

Pls help me in this regards

Sanook · July 17, 2018, 2:02pm

Here is a complete installation guide:
https://www.allerstorfer.at/install-spreed-me-on-nextcloud/