Error for configuring - rstudio-connect.gcfg

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"

Hi,

Can you please share your error log? Its located at /var/ log/ rstudio-connect.log