Skip to content
forked from econpy/torque

A set of tools used with the Torque app for Android to store OBD2 data in MySQL, view GPS data from Torque on a map in real time using the Google Maps JavaScript API, plot OBD2 data in time series charts, and export the data to CSV or JSON.

License

Notifications You must be signed in to change notification settings

jvandenbroek/torque

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

48 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

This repo contains everything needed to setup an interface for uploading ODB2 data logged from your car in real-time using the Torque Pro app for Android.

The interface allows the user to:

  • View Google Map of showing your trips in logged with Torque
  • Create time series plots of OBD2 data
  • Easily export data to CSV or JSON

Demo

Check out the demo!

Requirements

These instructions assume you already have a LAMP-like server (on a Linux/UNIX based host) or have access to one. Specifically, you'll need the following:

  • MySQL database
  • Apache webserver
  • PHP server-side scripting

If in doubt, I'd recommend using Ubuntu 12.04 LTS.

Server Setup

First clone the repo:

git clone https://github.com/econpy/torque
cd torque

Configure MySQL

To get started, create a database named torque and a user with permission to insert and read data from the database. In this tutorial, we'll create a user steve with password zissou that has access to all tables in the database torque from localhost:

CREATE DATABASE torque;
CREATE USER 'steve'@'localhost' IDENTIFIED BY 'zissou';
GRANT USAGE, FILE TO 'steve'@'localhost';
GRANT ALL PRIVILEGES ON torque.* TO 'steve'@'localhost';
FLUSH PRIVILEGES;

Then create a table in the database to store the logged data using the create_torque_log_table.sql file provided in the scripts folder of this repo:

mysql -u yoursqlusername -p < scripts/create_torque_log_table.sql

Configure Webserver

Move the contents of the web folder to your webserver and set the appropriate permissions. For example, using an Apache server located at /var/www:

mv web /var/www/torque
cd /var/www/torque
find . -type d -exec chmod 755 {} +
find . -type f -exec chmod 644 {} +

Rename the creds-sample.php file to creds.php:

mv creds-sample.php creds.php

Then edit/enter your MySQL username and password in the empty $db_user and $db_pass fields:

...
$db_host = "localhost";
$db_user = "steve";
$db_pass = "zissou";
$db_name = "torque";
$db_table = "raw_logs";
...

Settings in Torque App

To use your database/server with Torque, open the app on your phone and navigate to:

Settings -> Data Logging & Upload -> Webserver URL

Enter the URL to your upload_data.php script and press OK. Test that it works by clicking Test settings and you should see a success message like the image on the right:

The final thing you'll want to do before going for a drive is to check the appropriate boxes on the Data Logging & Upload page under the REALTIME WEB UPLOAD section. Personally, I have both Upload to webserver and Only when ODB connected checked.

At this point, you should be all setup. The next time you connect to Torque in your car, data will begin syncing into your MySQL database in real-time!

About

A set of tools used with the Torque app for Android to store OBD2 data in MySQL, view GPS data from Torque on a map in real time using the Google Maps JavaScript API, plot OBD2 data in time series charts, and export the data to CSV or JSON.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published