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: Started RStudio Connect. May 12 10:23:06 1201 systemd: rstudio-connect.service: main process exited, code=exited, status=1/FAILURE May 12 10:23:06 1201 systemd: Unit rstudio-connect.service entered failed state. May 12 10:23:06 1201 systemd: 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 = email@example.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:firstname.lastname@example.org/rstudio-connect"