TeslaMate [megathread]

[dakaix]

So three of the 7 months of TeslaFi imported then I got the error above.

I deleted the import files than reimported the ones that failed one by one. They all reported as imported successfully however when I check my drive history I'm missing the last 3 months.

I guess I need to find the row in the csv that's causing the error? Then I think I'll need to restart the import. But given the import tool marked 3 imports as successful yet there's no data to show, should I nuke the existing imports? Suspect I can access TeslaMate via mysql workbench or similar and delete the existing imported rows?

Yes, looks like it's a value out of range (for a signed int16) in the CSV. You can manually access postgres via the CLI (see below), or via any Postgres compatible browser if you prefer.

docker-compose exec database psql teslamate teslamate

 

[Medved_77]

Thanks @dakaix

That's very helpful.

 

[Durzel]

Out of curiosity, does anyone know if GCP/AWS, etc is still being blocked?

 

[simon.c]

Out of curiosity, does anyone know if GCP/AWS, etc is still being blocked?

Still seems to be blocked for me (GCP).

 

[DaveW]

Where can I check this?



Tried that but still complaining: psql: error: could not connect to server: FATAL: role "teslamate" does not exist

I also tried to create a backup first returning a similar error:
pg_dump: error: connection to database "teslamate" failed: FATAL: role "teslamate" does not exist
What is this role "teslamate" that does not exist?

Did you manage to sort this at all?

 

[Utahken]

A couple of quick questions from a TeslaMate newbie; I installed it on a Synology NAS Docker container yesterday, and seemingly successfully imported all of my past TeslaFi data. The only problem I had was concerned with the initial lack of an /import folder which didn't seem to be covered by the installation instructions. But maybe I missed it?

TIA

I installed on my synology also... just open a file viewer and look at where you allocated on your NAS to install teslamate. You will see an import directory under that folder. Make sure you delete the files in the import directory when the import is complete, otherwise teslamate won't run.

 

[4EVar]

I installed it today on a Windows 10 PC used as a media server. Really easy to install docker, then run the install script from PowerShell and it's all running great. Grafana took a few minutes to get my head round but I've set up the default dashboard and it's great. I'm looking forward to seeing the data once it's built up.

 

[IronCoffee_Max]

I moved mine to my Firewalla from AWS. Here's hoping I can continue to get many years of service!

 

[simon.c]

Well I'm leaving my GCP Teslamate instance running just in case Tesla un-blocks it but I've now reinstated a docker instance on my Synology NAS and managed to restore from my last GCP>Google drive backup so I'll just use that for now. I can always VPN back to my home network for remote access if need be.

 

[paulobrien]

AWS still blocked for me.

 

[DaveW]

Someone on the Facebook group (TeslaMate Users) just advised that their GCP TM instance just kicked back into life!

Anyone who's left it confirm the same?

 

[mpandrew]

Someone on the Facebook group (TeslaMate Users) just advised that their GCP TM instance just kicked back into life!

Anyone who's left it confirm the same?

Looks like it is back. Mine now shows car sleeping, was stuck at status Driving during the brownout.

 

[BMW740iL]

Did you manage to sort this at all?

No, not yet. I opened an issue for it on Github FATAL: role "teslamate" does not exist · Issue #916 · adriankumpf/teslamate

 

[DaveW]

No, not yet. I opened an issue for it on Github FATAL: role "teslamate" does not exist · Issue #916 · adriankumpf/teslamate

Damn - On the plus side, GCP seems to be working again. I've just restored mine from the Digital Ocean backup and it appears to be working as expecting (woke the car up to prove it)

 

[BMW740iL]

Damn - On the plus side, GCP seems to be working again. I've just restored mine from the Digital Ocean backup and it appears to be working as expecting (woke the car up to prove it)

That is great news!

 

[simon.c]

Same here - just checked my GCP instance and aside from needing to log into my Tesla account again it seems to be working correctly now. Think I'll keep both GCP and Synology running for the time being until GCP appears to be back for good though.

 

[DaveW]

Same here - just checked my GCP instance and aside from needing to log into my Tesla account again it seems to be working correctly now. Think I'll keep both GCP and Synology running for the time being until GCP appears to be back for good though.

I've just powered off my Digital Ocean 'Droplet' for now, I've still got the two months free because of using a referral link, so it won't cost me anything to have the insurance

 

[dan223]

I've just powered off my Digital Ocean 'Droplet' for now, I've still got the two months free because of using a referral link, so it won't cost me anything to have the insurance

Argh that's annoying i turned my GCP instance off and spun one up on digital ocean to. I'm going to leave it in Digital Ocean for a bit now, might as well make use of my two months, and then switch back if it is still good.

 

[DaveW]

Argh that's annoying i turned my GCP instance off and spun one up on digital ocean to. I'm going to leave it in Digital Ocean for a bit now, might as well make use of my two months, and then switch back if it is still good.

I kept both going, just in case - in DO you can power off the box without it destroying it. It still charges you etc.. so I'll leave it in that state for now and see how GCP goes again

 

[dan223]

I kept both going, just in case - in DO you can power off the box without it destroying it. It still charges you etc.. so I'll leave it in that state for now and see how GCP goes again

My GCP is just turned off, so not a massive deal to get it up and running again. I will leave you guys to test and swap back over if its still stable in two months time