AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Freematics traccar edition12/28/2023 The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. Or support in, e.g., GitHub, forums or the Discord chat. Please, share the above information when looking for help System: Home Assistant OS 6.1 (aarch64 / raspberrypi4-64) You are running the latest version of this add-on. executing container initialization scripts. ensuring user provided files have correct perms.exited 0. making user provided files available at /var/run/s6/etc.exited 0. To SELECT * FROM tc_events WHERE deviceId = :deviceId AND eventTime BETWEEN :from AND :to ORDER BY eventTime īest Regards and keep up the amazing work. SELECT * FROM tc_events WHERE deviceId = :deviceId AND serverTime BETWEEN :from AND :to ORDER BY serverTime Response: Unknown column 'serverTime' in 'where clause' - SQLSynta圎rrorException (. Inspecting, we get the following responses form the server: No list of events is reported and the website starts to misbehave (dialogs out of place) When picking up the Report Type: Events, Configuring and pressing show, a list of events should be shown. I don't recall at what release I lost access.īut even after a full home assistant fresh install, the problems persists. Install version update to version 0.15.0 Proposed changesĭatabase update/migration at first start of version 0.15.0Ĭurrently I am not able to show Events reports. Upgrade from = 0.15.0 with out breakting the addon Actual behaviorĪddon won't start and produce high cpu load Steps to reproduce I am aware that it is actually a problem of Traccar itself.īut the addon should actually perform the migration during the update or there should be a separate description for HA/addon how to perform the migration manually. It seems that there is a database update/migration needed ![]() Caused by: org.h2.jdbc.JdbcSQLNonTransientException: General error: "The write f ormat 1 is smaller than the supported format 2 " at org.h2.(DbException.java:573) at org.h2.(DbException.java:496) at org.h2.(DbException.java:216) at org.h2.mvstore.db.nvertMVStoreException(Store.java:166) at org.h2.mvstore.db.Store.(Store.java:140) at org.h2.engine.Database.(Database.java:324) at org.h2.(Engine.java:92) at org.h2.(Engine.java:222) at org.h2.(Engine.java:201) at org.h2.(SessionRemote.jav a:338) at org.h2.jdbc.JdbcConnection.(JdbcConnection.java:117) at org.h2.nnect(Driver.java:59) at .DriverDataSource.getConnection(DriverDataSourc e.java:138) at .PoolBase.newConnection(PoolBase.java:359) at .PoolBase.newPoolEntry(PoolBase.java:201) at .HikariPool.createPoolEntry(HikariPool.java:470 ) at .HikariPool.checkFailFast(HikariPool.java:561). This results in a high CPU load from the java process. I'm a tech geek (aren't we all), and ironically my undergrad major (MIS) involved some coding, but I shy away from too much of that (guided YAML coding is kind of my maximum at the moment, Bash still confuses the hell out of me).Ĭan anyone help point me either to some guides, or to some OBD GPS trackers which would be relatively-easy to plug a SIM into and get working with Traccar (and then Home Assistant), without the need for some significant level of programming? I've done some searching and either I don't know how to look for this, or clarity seems to not exist at the moment on this topic in the areas I've looked.After the latest update the Addon won't start anymore. I even ordered a data-only SIM from my carrier, Google Fi.īut, in double-checking I knew what I was getting into, I noticed that these Freematics devices require some degree of programming. I see all the supported devices and the prominently-mentioned Freematics ONE+ variants. However, this is where I hit a wall, in terms of solution-finding. Seems like the clear solution, as I run an UnRAID server and presumably can run a Traccar server on there (I see a Docker app in the Community Applications store), so no need for a monthly subscription fee (if I understand correctly). ![]() Lo-and-behold, there's a massive market of them on Amazon - but I want something without a subscription service, ideally open-source, that I can integrate in Home Assistant.īoom - Traccar. But this got me thinking about OBD-based GPS trackers. However, my wife has an old Honda Civic and we'd like to track that too (she shot down using a Tile tracker, as she correctly pointed out such a device is mostly useless if the car is taken into the middle of nowhere).īack in the day, I had an Automatic OBD adapter for my old car (also a Honda Civic at the time) - it was great! Of course, Automatic is no more. This is something I love having the ability to do for peace of mind, at a bare minimum. Hey all, so I've been getting into Home Assistant, and I'm lucky enough to own a car which already has a built-in integration, allowing for tracking it via GPS and whatnot.
0 Comments
Read More
Leave a Reply. |