FATAL: role "teslamate" does not exist #916

GtHbbrr · 2020-09-12T07:03:17Z

GtHbbrr
Sep 12, 2020

Describe the bug

I get [FATAL: role "teslamate"] does not exist when trying to backup or restore the Teslamate database

Expected behavior

backup or restore without a Fatal error

How to reproduce it (as minimally and precisely as possible):

I destroyed the Droplet on Digital Ocean, started a new Droplet and reinstalled Teslamate using Traefik: same Fatal error

Relevant entries from the logs

Last login: Sat Sep 12 08:39:47 on ttys001
iMac:~ admin$ ssh root@178.62.xx
root@178.xx's password: 
Welcome to Ubuntu 20.04.1 LTS (GNU/Linux 5.4.0-42-generic x86_64)

 * Documentation:  https://help.ubuntu.com
 * Management:     https://landscape.canonical.com
 * Support:        https://ubuntu.com/advantage

  System information as of Sat Sep 12 06:47:38 UTC 2020

  System load:                      0.12
  Usage of /:                       18.7% of 24.06GB
  Memory usage:                     51%
  Swap usage:                       1%
  Processes:                        151
  Users logged in:                  1
  IPv4 address for br-909955cce917: 172.19.0.1
  IPv4 address for docker0:         172.17.0.1
  IPv4 address for eth0:            178.62.xx
  IPv4 address for eth0:            10.18.0.5

0 updates can be installed immediately.
0 of these updates are security updates.


The list of available updates is more than a week old.
To check for new updates run: sudo apt update

********************************************************************************

Welcome to DigitalOcean's 1-Click Docker Droplet.
To keep this Droplet secure, the UFW firewall is enabled.
All ports are BLOCKED except 22 (SSH), 2375 (Docker) and 2376 (Docker).

* The Docker 1-Click Quickstart guide is available at:
  https://do.co/3j6j3po#start

* You can SSH to this Droplet in a terminal as root: ssh root@178.62.xx

* Docker is installed and configured per Docker's recommendations:
  https://docs.docker.com/install/linux/docker-ce/ubuntu/

* Docker Compose is installed and configured per Docker's recommendations:
  https://docs.docker.com/compose/install/#install-compose

For help and more information, visit https://do.co/3j6j3po

********************************************************************************

To delete this message of the day: rm -rf /etc/update-motd.d/99-one-click
Last login: Sat Sep 12 06:40:01 2020 from 213.xx
root@docker-ubuntu-s-1vcpu-1gb-ams3-01:~# docker-compose exec -T database pg_dump -U teslamate teslamate > tesselmate.bck
pg_dump: error: connection to database "teslamate" failed: FATAL:  role "teslamate" does not exist
root@docker-ubuntu-s-1vcpu-1gb-ams3-01:~# docker-compose logs
Attaching to root_teslamate_1, root_grafana_1, root_database_1, root_mosquitto_1, root_proxy_1
database_1   | 
database_1   | PostgreSQL Database directory appears to contain a database; Skipping initialization
database_1   | 
database_1   | 2020-09-12 06:44:48.358 UTC [1] LOG:  starting PostgreSQL 12.4 (Debian 12.4-1.pgdg100+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit
database_1   | 2020-09-12 06:44:48.358 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
database_1   | 2020-09-12 06:44:48.358 UTC [1] LOG:  listening on IPv6 address "::", port 5432
database_1   | 2020-09-12 06:44:48.360 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
database_1   | 2020-09-12 06:44:48.410 UTC [24] LOG:  database system was shut down at 2020-09-12 06:42:51 UTC
database_1   | 2020-09-12 06:44:48.424 UTC [1] LOG:  database system is ready to accept connections
database_1   | 2020-09-12 06:48:31.211 UTC [58] FATAL:  role "teslamate" does not exist
grafana_1    | t=2020-09-12T06:44:48+0000 lvl=info msg="Starting Grafana" logger=server version=7.1.5 commit=9893b8c53d branch=HEAD compiled=2020-08-25T08:27:17+0000
grafana_1    | t=2020-09-12T06:44:48+0000 lvl=info msg="Config loaded from" logger=settings file=/usr/share/grafana/conf/defaults.ini
grafana_1    | t=2020-09-12T06:44:48+0000 lvl=info msg="Config loaded from" logger=settings file=/etc/grafana/grafana.ini
grafana_1    | t=2020-09-12T06:44:48+0000 lvl=info msg="Config overridden from command line" logger=settings arg="default.paths.data=/var/lib/grafana"
grafana_1    | t=2020-09-12T06:44:48+0000 lvl=info msg="Config overridden from command line" logger=settings arg="default.paths.logs=/var/log/grafana"
grafana_1    | t=2020-09-12T06:44:48+0000 lvl=info msg="Config overridden from command line" logger=settings arg="default.paths.plugins=/var/lib/grafana-plugins"
grafana_1    | t=2020-09-12T06:44:48+0000 lvl=info msg="Config overridden from command line" logger=settings arg="default.paths.provisioning=/etc/grafana/provisioning"
grafana_1    | t=2020-09-12T06:44:48+0000 lvl=info msg="Config overridden from command line" logger=settings arg="default.log.mode=console"
grafana_1    | t=2020-09-12T06:44:48+0000 lvl=info msg="Config overridden from Environment variable" logger=settings var="GF_PATHS_DATA=/var/lib/grafana"
grafana_1    | t=2020-09-12T06:44:48+0000 lvl=info msg="Config overridden from Environment variable" logger=settings var="GF_PATHS_LOGS=/var/log/grafana"
grafana_1    | t=2020-09-12T06:44:48+0000 lvl=info msg="Config overridden from Environment variable" logger=settings var="GF_PATHS_PLUGINS=/var/lib/grafana-plugins"
grafana_1    | t=2020-09-12T06:44:48+0000 lvl=info msg="Config overridden from Environment variable" logger=settings var="GF_PATHS_PROVISIONING=/etc/grafana/provisioning"
grafana_1    | t=2020-09-12T06:44:48+0000 lvl=info msg="Config overridden from Environment variable" logger=settings var="GF_SERVER_ROOT_URL=https://dograf.g358xh.nl"
grafana_1    | t=2020-09-12T06:44:48+0000 lvl=info msg="Config overridden from Environment variable" logger=settings var="GF_ANALYTICS_REPORTING_ENABLED=FALSE"
grafana_1    | t=2020-09-12T06:44:48+0000 lvl=info msg="Config overridden from Environment variable" logger=settings var="GF_SECURITY_ADMIN_USER=admin"
grafana_1    | t=2020-09-12T06:44:48+0000 lvl=info msg="Config overridden from Environment variable" logger=settings var="GF_SECURITY_ADMIN_PASSWORD=*********"
grafana_1    | t=2020-09-12T06:44:48+0000 lvl=info msg="Config overridden from Environment variable" logger=settings var="GF_SECURITY_DISABLE_GRAVATAR=true"
grafana_1    | t=2020-09-12T06:44:48+0000 lvl=info msg="Config overridden from Environment variable" logger=settings var="GF_SECURITY_ALLOW_EMBEDDING=true"
grafana_1    | t=2020-09-12T06:44:48+0000 lvl=info msg="Config overridden from Environment variable" logger=settings var="GF_USERS_ALLOW_SIGN_UP=false"
grafana_1    | t=2020-09-12T06:44:48+0000 lvl=info msg="Config overridden from Environment variable" logger=settings var="GF_AUTH_ANONYMOUS_ENABLED=false"
proxy_1      | time="2020-09-12T06:44:48Z" level=info msg="Configuration loaded from flags."
mosquitto_1  | 1599893088: mosquitto version 1.6.12 starting
mosquitto_1  | 1599893088: Config loaded from /mosquitto/config/mosquitto.conf.
mosquitto_1  | 1599893088: Opening ipv4 listen socket on port 1883.
mosquitto_1  | 1599893088: Opening ipv6 listen socket on port 1883.
mosquitto_1  | 1599893088: mosquitto version 1.6.12 running
mosquitto_1  | 1599893118: New connection from 172.19.0.6 on port 1883.
mosquitto_1  | 1599893118: New client connected from 172.19.0.6 as TESLAMATE_302E3437343 (p2, c1, k60).
teslamate_1  | 08:44:54.038 [info] Already up
teslamate_1  | 08:45:16.358 [info] Version: 1.20.0-dev
teslamate_1  | 08:45:17.297 [info] Refreshed api tokens
teslamate_1  | 08:45:17.306 [info] Scheduling token refresh in 5 wk 5 d
teslamate_1  | 08:45:17.310 [info] Running TeslaMateWeb.Endpoint with cowboy 2.8.0 at :::4000 (http)
teslamate_1  | 08:45:17.313 [info] Access TeslaMateWeb.Endpoint at http://xxx
teslamate_1  | 08:45:18.106 [info] Starting logger for '** BATTERY LOW **'
teslamate_1  | 08:45:18.132 [info] MQTT connection has been established
teslamate_1  | 08:45:18.978 car_id=1 [info] Start / :offline
teslamate_1  | 08:45:19.854 [info] tzdata release in place is from a file last modified Wed, 11 Sep 2019 19:35:17 GMT. Release file on server was last modified Fri, 24 Apr 2020 04:15:20 GMT.
teslamate_1  | 08:45:21.639 [info] Tzdata has updated the release from 2019c to 2020a
teslamate_1  | 08:46:08.953 [info] GET /
teslamate_1  | 08:46:08.972 [info] Sent 200 in 19ms
teslamate_1  | 08:46:36.551 [info] GET /
teslamate_1  | 08:46:36.556 [info] Sent 200 in 4ms
grafana_1    | t=2020-09-12T06:44:48+0000 lvl=info msg="Config overridden from Environment variable" logger=settings var="GF_AUTH_BASIC_ENABLED=true"
grafana_1    | t=2020-09-12T06:44:48+0000 lvl=info msg="Path Home" logger=settings path=/usr/share/grafana
grafana_1    | t=2020-09-12T06:44:48+0000 lvl=info msg="Path Data" logger=settings path=/var/lib/grafana
grafana_1    | t=2020-09-12T06:44:48+0000 lvl=info msg="Path Logs" logger=settings path=/var/log/grafana
grafana_1    | t=2020-09-12T06:44:48+0000 lvl=info msg="Path Plugins" logger=settings path=/var/lib/grafana-plugins
grafana_1    | t=2020-09-12T06:44:48+0000 lvl=info msg="Path Provisioning" logger=settings path=/etc/grafana/provisioning
grafana_1    | t=2020-09-12T06:44:48+0000 lvl=info msg="App mode production" logger=settings
grafana_1    | t=2020-09-12T06:44:48+0000 lvl=info msg="Connecting to DB" logger=sqlstore dbtype=sqlite3
grafana_1    | t=2020-09-12T06:44:48+0000 lvl=info msg="Starting DB migration" logger=migrator
grafana_1    | t=2020-09-12T06:44:48+0000 lvl=info msg="Starting plugin search" logger=plugins
grafana_1    | t=2020-09-12T06:44:48+0000 lvl=info msg="Registering plugin" logger=plugins name="Direct Input"
grafana_1    | t=2020-09-12T06:44:48+0000 lvl=info msg="Registering plugin" logger=plugins name="Pie Chart"
grafana_1    | t=2020-09-12T06:44:48+0000 lvl=info msg="Registering plugin" logger=plugins name="Map Panel"
grafana_1    | t=2020-09-12T06:44:48+0000 lvl=info msg="Registering plugin" logger=plugins name=Discrete
grafana_1    | t=2020-09-12T06:44:48+0000 lvl=info msg="Registering plugin" logger=plugins name=TrackMap
grafana_1    | t=2020-09-12T06:44:49+0000 lvl=info msg="HTTP Server Listen" logger=http.server address=[::]:3000 protocol=http subUrl= socket=
grafana_1    | t=2020-09-12T06:45:46+0000 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=179.43.169.182 time_ms=0 size=29 referer=
grafana_1    | t=2020-09-12T06:45:46+0000 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=179.43.169.182 time_ms=0 size=29 referer=
grafana_1    | t=2020-09-12T06:46:16+0000 lvl=eror msg="Failed to look up user based on cookie" logger=context error="user token not found"
grafana_1    | t=2020-09-12T06:46:16+0000 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/d/xo4BNRkZz status=302 remote_addr=213.127.63.191 time_ms=1 size=29 referer=https://dobeta.g358xh.nl/
grafana_1    | t=2020-09-12T06:46:22+0000 lvl=info msg="Successful Login" logger=http.server User=admin@localhost
grafana_1    | t=2020-09-12T06:47:26+0000 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=205.251.139.166 time_ms=0 size=29 referer=
grafana_1    | t=2020-09-12T06:47:31+0000 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=205.251.139.166 time_ms=0 size=29 referer=
root@docker-ubuntu-s-1vcpu-1gb-ams3-01:~#

Data

For example, to export charge data after January 1, 2020:

$ docker-compose exec database psql teslamate teslamate -c
"COPY (select * from charges where date > '2020-01-01') TO STDOUT WITH CSV HEADER" > charges.csv

gives same error: FATAL: role "teslamate" does not exist

$ docker-compose exec database psql teslamate teslamate -c
"COPY (select * from charging_processes where start_date > '2020-01-01') TO STDOUT WITH CSV HEADER" > charging_processes.csv

gives same error: FATAL: role "teslamate" does not exist

To export drive data after January 1, 2020:

$ docker-compose exec database psql teslamate teslamate -c
"COPY (select id, car_id, drive_id, date, elevation, speed, power, odometer, ideal_battery_range_km, est_battery_range_km, rated_battery_range_km, battery_level, usable_battery_level, battery_heater_no_power, battery_heater_on, battery_heater, inside_temp, outside_temp, fan_status, driver_temp_setting, passenger_temp_setting, is_climate_on, is_rear_defroster_on, is_front_defroster_on from positions where date > '2020-01-20') TO STDOUT WITH CSV HEADER" > positions.csv

gives same error: FATAL: role "teslamate" does not exist

$ docker-compose exec database psql teslamate teslamate -c
"COPY (select * from drives where start_date > '2020-01-01') TO STDOUT WITH CSV HEADER" > drives.csv

gives same error: FATAL: role "teslamate" does not exist

Environment

TeslaMate version: v1.20dev
Type of installation: Docker
OS TeslaMate is installed on: Digital Ocean Docker Droplet
User OS & Browser: Ubuntu
Others:

anjiannian · 2020-09-28T04:12:32Z

anjiannian
Sep 28, 2020

It looks like you are not using default postgres user teslamate, check your .env file to make sure

0 replies

GtHbbrr · 2020-09-28T06:05:33Z

GtHbbrr
Sep 28, 2020
Author

Thanks! I will check and report back

0 replies

pihomeserver · 2020-10-20T07:46:02Z

pihomeserver
Oct 20, 2020

I confirm that's the solution. I had the same error and using the correct user defined in the .env file solved the point

0 replies

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

FATAL: role "teslamate" does not exist #916

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{editor}}'s edit

{{editor}}'s edit

Uh oh!

Replies: 3 comments

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{title}}

Uh oh!

Select a reply

Uh oh!

FATAL: role "teslamate" does not exist #916

Uh oh!

Uh oh!

GtHbbrr Sep 12, 2020

Replies: 3 comments

Uh oh!

anjiannian Sep 28, 2020

Uh oh!

GtHbbrr Sep 28, 2020 Author

Uh oh!

pihomeserver Oct 20, 2020

GtHbbrr
Sep 12, 2020

anjiannian
Sep 28, 2020

GtHbbrr
Sep 28, 2020
Author

pihomeserver
Oct 20, 2020