jebinc
Well-Known Member
Yep. This is my rig - Raspberry Pi 4 8GB running docker. Rock solid and ultra low power consumption.
-
Want to remove ads? Register an account and login to see fewer ads, and become a Supporting Member to remove almost all ads.
Grab the relevant rclone.exe file from here:Hi init6, yep, Pi has a browser installed, but still wont auto launch the browser. Sorry im a newbie to this - How do i run the rclone authorise command on my PC? what program am i using to do that? if you have step by step for that part i would really appreciate that
I don't have windows so can't test it, but that should work.
One other thought. How are you running commands on the Pi? Do you have a keyboard and monitor connected or are you ssh'ing into it?Hi init6, yep, Pi has a browser installed, but still wont auto launch the browser. Sorry im a newbie to this - How do i run the rclone authorise command on my PC? what program am i using to do that? if you have step by step for that part i would really appreciate that
I was SSH'ing into the Pi - But with your instructions I've got it workingGrab the relevant rclone.exe file from here:
Then run the exe from the command line e.g. rclone.exe authorise blah blah blah.
I don't have windows so can't test it, but that should work.
Thank you so much!Reporting in after a week of use. Today, it started failing reaching the auth server for token refresh. Turns out when I rebooted my Intel NUC yesterday my VPN auto started. So it looks like the Tesla API remains accessible when on VPN until a token refresh is attempted to the Auth server… I fixed my daemon for next time I reboot.
I am starting to see a ton of health check failures and the internet connectivity on my Pi actually dies. Docker container continues to run, but opening Chrome does not allow me to browse externally. A ping does not hit external resources. If I shut down the Docker containers, all returns to normal. This happens after about two or three hours once the car has gone to sleep. No clue yet as to why.
Logs from TeslaMate or the Pi? TeslaMate just throws 408 or 540 errors.
Ethernet. WiFi is not connected.
Worth mentioning, I ran an apt-get update and upgrade and it has been stable. Also, seems to be stable when I am running a constant ping. So not sure if the Ethernet interface is going to sleep or not. Which I find hard to believe, since TeslaMate's docker container can reach out to Tesla API. Still just trying to narrow it down.
Amy logs
Pi logs would be my first port of call. I had problems with the Pi I use for Octoprint dropping the wifi connection. Ethernet has been rock solid so hopefully that's been ruled out.
Did you have a VPN or am I thinking of someone else?
Interesting similarity here:
Pi eventually loses network connectivity since starting to use docker and docker-compose
I'm having this issue on both a Pi 3B and a Pi 4 4GB model. I'm running some programs I wrote that run with docker-compose, and most days, if not every day, around the same times I suddenly won't b...
raspberrypi.stackexchange.com
I will have to look into how to get the Pi logs off the Ethernet port. What is really interesting is that my eth0 port is renamed to something really obscure.Amy logs
Pi logs would be my first port of call. I had problems with the Pi I use for Octoprint dropping the wifi connection. Ethernet has been rock solid so hopefully that's been ruled out.
Did you have a VPN or am I thinking of someone else?
Interesting similarity here:
Pi eventually loses network connectivity since starting to use docker and docker-compose
I'm having this issue on both a Pi 3B and a Pi 4 4GB model. I'm running some programs I wrote that run with docker-compose, and most days, if not every day, around the same times I suddenly won't b...
No VPN on this device. That was someone else on the thread.
Going on almost about 12 - 14 hours and it has been rock solid. We shall see. Thanks for the link! Will check it out.
garylovesbeer
Member
Hi, is there any way to bulk update Supercharger, or any Geo-Fenced, locations? Supercharger prices are going up incrementally and it seems awfully inefficient to have to edit every entry.
Thanks for your help.
Thanks for your help.
Pretty sure if you edit a geofence, will prompt you to apply to previous charges.
If that does not work, you could drop all the charge totals from the database and then redo the step above. It would definitely ask you to fill in blank sessions.
But curious - why would you want to backfill / correct the data? It was right at the time of charge / data stored and properly calculated how much you paid. It’s not like they are coming back and recharging you, so you need to update the value.
garylovesbeer
Member
I should preface this post by saying that I do not as yet have a Tesla, I am waiting on delivery, I am just wanting to get Teslamate ready so I don't have to start editing a live database and risk losing all my data. So onwards ...
I meant can you bulk edit EVERY Supercharger in the database eg all the superchargers I have listed in Australia at once or more quickly than opening and editing every singe supercharger one at a time.
I asked a question the other day regarding exporting all the geo-fence locations from the database and am now trying to work out how to reimport them back into the database. However my knowledge and experience with Postgres, and all other databases in general, is extremely lacking. I have edited MariaDB with myphpadmin but this tool is not compatible with Postgres. The graphical administration tools for postgres don't seem compatible with my install, a Debian LXC in Proxmox, and my terminal skills for administration are basically copy and paste from forums.
So are there any tools to manipulate the postgres database that anyone can recommend?
Thanks.
Last edited:
garylovesbeer
Member
Ok just found this in the Teslamate github discussion.
UPDATE charging_processes SET cost=charge_energy_used*0.18521369 WHERE address_id='1';
Could I use this type of command to update all instances containing "Supercharger"?
Also I note that the database has a name cost_per_unit instead of charge_energy_used.
UPDATE charging_processes SET cost=charge_energy_used*0.18521369 WHERE address_id='1';
Could I use this type of command to update all instances containing "Supercharger"?
Also I note that the database has a name cost_per_unit instead of charge_energy_used.
There is no need to do any db work at all on Teslamate.
You will likely find that you only use a handful of superchargers routinely. For example. There is little point in me inputting data for the South of England as I am highly unlikely to use those Superchargers. Certainly there is zero point in keeping the prices for those SuCs up to date. If for some bizarre reason I find myself using an SuC in the South of England, then as @cwanja says it's a simple enough task to add that SuC and it's costs from the Teslamate GUI.
Methinks you are looking for problems that don't really exist. Wait until you get your car and see what you NEED to change about Teslamate. I'd also say if you need a GUI to manipulate a DB, then you're best to leave the DB commands alone. There's a lot you can do with Teslamate and Grafana without logging directly into the DB.
@init6 It's so weird! The issue happened again where I can't access 4000/3000 on any device. It just says connection timed out. If I execute a `sudo restart` (`sudo shutdown -r now`) it will go back to normal. Data tracks while I can't access 3000/4000.... logs don't show anything unusual. Don't know what to do :O
Oh I was looking at the pi_grafana_1, pi_teslamate_1, etc.
If I look at syslog (var/log/syslog) nothing much interesting shows up - see logs from around the time I tried to access 3000/4000 and couldn't access.
Similar threads
