Hi,
I am trying to configure external postgresql and adding the config as per documentation. But I am getting an error, when I restart the server.
rstudio-connect.service - RStudio Connect
Loaded: loaded (/etc/systemd/system/rstudio-connect.service; enabled; vendor preset: disabled)
Active: failed (Result: exit-code) since Tue 2020-05-12 10:23:06 EDT; 29min ago
Process: 16995 ExecStart=/bin/sh -c exec /opt/rstudio-connect/bin/connect --config /etc/rstudio-connect/rstudio-connect.gcfg >> /var/log/rstudio-connect.log 2>&1 (code=exited, status=1/FAILURE)
Main PID: 16995 (code=exited, status=1/FAILURE)
May 12 10:23:06 1201 systemd[1]: Started RStudio Connect.
May 12 10:23:06 1201 systemd[1]: rstudio-connect.service: main process exited, code=exited, status=1/FAILURE
May 12 10:23:06 1201 systemd[1]: Unit rstudio-connect.service entered failed state.
May 12 10:23:06 1201 systemd[1]: rstudio-connect.service failed.
Here is my sample config file:
; RStudio Connect configuration file
[Server]
; SenderEmail is an email address used by RStudio Connect to send outbound
; email. The system will not be able to send administrative email until this
; setting is configured.
;
; SenderEmail = account@company.com
SenderEmail =
; Address is a public URL for this RStudio Connect server. Must be configured
; to enable features like including links to your content in emails. If
; Connect is deployed behind an HTTP proxy, this should be the URL for Connect
; in terms of that proxy.
;
; Address = https://rstudio-connect.company.com
Address = xxxxxx
[HTTP]
; RStudio Connect will listen on this network address for HTTP connections.
Listen = :80
#[HTTPS]
#Listen = :3939
#Listen = :443
[Authentication]
; Specifies the type of user authentication.
#Provider = password
Provider = pam
#Provider = LDAP
[PAM]
Service = rstudio-connect
Logging = true
#[LDAP "any"]
#Logging = true
; Connection to AWS RDS - Postgresql
[Database]
Provider = postgres
[Postgres]
URL = "postgres://postgres:password@xxxxxitx-bja-rstudio-postgresql.rds.amazonaws.com/rstudio-connect"