[ANSWERED]: Can't find indigo_history.sqlite

Posted on
Sun Mar 29, 2015 11:55 am
Nine offline
Posts: 78
Joined: Feb 15, 2015
Location: Zurich, Switzerland

[ANSWERED]: Can't find indigo_history.sqlite

Even though the SQL Logger Plugin is enabled and no error is shown in the log, I can't find the SQLite-Database indigo_history.sqlite on my maschine... any hints?

The log says that SQL Logger is working:

Code: Select all
  Z-Wave                          received "Motion Sensor Gang/Küche" status update is on
  SQL Logger Debug                state change list for "Motion Sensor Gang/Küche": [(u'onOffState', True)]
  SQL Logger Debug                INSERT INTO device_history_1081114426 ("batterylevel", "batterylevel_ui", "onoffstate") VALUES (?, ?, ?);
  SQL Logger Debug                     (u'100', u'100%', u'True')

Posted on
Sun Mar 29, 2015 4:30 pm
DaveL17 offline
User avatar
Posts: 6742
Joined: Aug 20, 2013
Location: Chicago, IL, USA

Re: Can't find indigo_history.sqlite

In the log window, click on the button labelled "Show Event Logs Folder", and you should be able to find it there.

Dave

I came here to drink milk and kick ass....and I've just finished my milk.

[My Plugins] - [My Forums]

Posted on
Tue Mar 31, 2015 7:12 am
Nine offline
Posts: 78
Joined: Feb 15, 2015
Location: Zurich, Switzerland

Re: Can't find indigo_history.sqlite

In that folder are only my log-files ... but no *.sqlite :roll:

Posted on
Tue Mar 31, 2015 8:15 am
DaveL17 offline
User avatar
Posts: 6742
Joined: Aug 20, 2013
Location: Chicago, IL, USA

Re: Can't find indigo_history.sqlite

Hmm. I think the location is set by the plugin so it *should* be there.

I came here to drink milk and kick ass....and I've just finished my milk.

[My Plugins] - [My Forums]

Posted on
Tue Mar 31, 2015 8:51 am
RogueProeliator offline
User avatar
Posts: 2501
Joined: Nov 13, 2012
Location: Baton Rouge, LA

Re: Can't find indigo_history.sqlite

Even though the SQL Logger Plugin is enabled and no error is shown in the log, I can't find the SQLite-Database indigo_history.sqlite on my maschine... any hints?

If you open the SQL Logger Plugin Configuration (Plugins->SQL Logger->Configure) there is a box for entering the SQLite file. Is this not filled in?

At any rate, you can drop to a Terminal window and enter:
Code: Select all
find /Library/Application\ Support/ -name "*.sqlite"

If it is outside the base directory, may need to expand to use / instead of /Library/Application\ Support/ but you might get lots of permissions errors as it searches (won't hurt anything, just have to look through them to find the file...)

Adam

Posted on
Tue Mar 31, 2015 10:16 am
Nine offline
Posts: 78
Joined: Feb 15, 2015
Location: Zurich, Switzerland

Re: Can't find indigo_history.sqlite

ahhhh good old terminal :D says my file is here:

/Library/Application Support//Perceptive Automation/Indigo 6/Plugins/SQL Logger.indigoPlugin/Contents/Server Plugin/indigo_history.sqlite

but I did not enter a path in the plugin-configuration...

Posted on
Tue Mar 31, 2015 6:54 pm
matt (support) offline
Site Admin
User avatar
Posts: 21411
Joined: Jan 27, 2003
Location: Texas

Re: [ANSWERED]: Can't find indigo_history.sqlite

That is strange – I'm not sure how it ended up in there (or why it was created there originally if that is the case).

Image

Page 1 of 1

Who is online

Users browsing this forum: No registered users and 1 guest