This is normal behaviour since a version or two ago.Sometimes it will make me log back into Grafana.
You can install our site as a web app on your iOS device by utilizing the Add to Home Screen feature in Safari. Please see this thread for more details on this.
Note: This feature may not be available in some browsers.
This is normal behaviour since a version or two ago.Sometimes it will make me log back into Grafana.
I’ve been running Teslamate on a Raspberry Pi for about 6 months and absolutely love it. I find myself obsessively checking my car’s stats whenever I get home after a drive.
In the past month, I’ve been getting a “server not responding” fairly frequently when try to open the web page. This will often persist for a few minutes, but eventually if I hit refresh enough it will come back. Sometimes it will make me log back into Grafana. I’ve never had to reboot the Pi, or do anything more drastic than hitting refresh. And I have never seen it lose a bit of data, so I know it is constantly polling 24/7.
Anyone else ever seen this behavior? If so, is it anything I need to be concerned about? It’s more of an annoyance than anything.
By web page, I mean when I bring up http://localhost:3000/ on my local network. I have not reviewed any logs, but I will look at the router and Pi next time it happens. So not a common thing I take it.When you talk about the web page are you talking about the teslamate home page? That's most likely a problem on your Pi or network.
What do the logs say?
Nope.By web page, I mean when I bring up http://localhost:3000/ on my local network. I have not reviewed any logs, but I will look at the router and Pi next time it happens. So not a common thing I take it.
Following up to say that it appears my router was to blame. I noticed that another device on my 2.4 GHz network was also having problems, so I rebooted the router. The problem immediately disappeared after that and hasn’t been back in nearly a week. Phew! I was worried I might need to find another Raspberry Pi, which are not easy to come by these days.Nope.
If the pi hasn't been rebooted in 6 months then I'd start there.
All 4 show as Up stateWhat do the database logs look like?
Can you show the result ofCode:docker-compose ps
Edit: What did you do to resolve the encryption warning?
You need to run it from within the database. You can login to the database like this:Here are the full DB log.
When I try to run the command from that link I get an error unfortunately.
CT@raspberrypi:~ $ SELECT nextval('positions_id_seq');
-bash: syntax error near unexpected token `('
CT@raspberrypi:~ $ SELECT nextval('positions_id_seq');
SELECT max(id) from positions;
-bash: syntax error near unexpected token `('
-bash: syntax error near unexpected token `('
View attachment 864211
docker exec -it ct_database_1 psql -U teslamate -W teslamate
Thanks for your help, think its sorted. It was related to corrupt data somewhere.You need to run it from within the database. You can login to the database like this:
Code:docker exec -it ct_database_1 psql -U teslamate -W teslamate
The postcode is stored in the addresses table, so it should be possible. I'll need to do some digging to see how to get that out. How are your DBA skills?Is it possible to get postcodes listed in drives information. I see it pulls place names from somewhere, postcodes would be super useful for business mileage tracking!
You'll need to give us some more info if we are to help you. How did you determine what drive is missing? What command did you use to close the drive? Are you able to look at the drives table from the command line?Trying to manually close a drive that has not logged but get the following error:
View attachment 870622
I have checked permissions. Anything else I can check?
Edit: ran as sudo and worked, but the drive is still not logged.
Hi, I checked the drive id in the url for the latest drive and then added 1 assuming that would be the next id. I have done two more drives after which seem to be logged so will check their id’s. I used the command on the website to manually close the drive.I haven’t looked at the drives table as when I run the select command nothing shows so must be doing something wrong. I know sql but not from docker to Postgres. Thanks for helping.You'll need to give us some more info if we are to help you. How did you determine what drive is missing? What command did you use to close the drive? Are you able to look at the drives table from the command line?
You can add a table panel to any of the dashboards and put in SQL there. I do that quite often for quick queries and then just discard the panel.Hi, I checked the drive id in the url for the latest drive and then added 1 assuming that would be the next id. I have done two more drives after which seem to be logged so will check their id’s. I used the command on the website to manually close the drive.I haven’t looked at the drives table as when I run the select command nothing shows so must be doing something wrong. I know sql but not from docker to Postgres. Thanks for helping.
select id, start_date from drives where end_date is null;
Thanks. I just checked the id's and they are sequential. The drive from home to work yesterday is totally missing. The id before my drive to work is 64 and the id for my drive from work to home is 65 so the drive from home to work is totally missing.You can add a table panel to any of the dashboards and put in SQL there. I do that quite often for quick queries and then just discard the panel.
I use this query to find unclosed drives:
Code:select id, start_date from drives where end_date is null;
then use the id in the close drive script. I presume you don't get any errors when you run this? IIRC there's a typo in the command on the Teslamate site.