Page 1 of 1

SQLite Error message on Indigo 5

PostPosted: Tue Nov 22, 2011 7:48 am
by rlust
I am getting the following messages in my log file. What could be causing this?


"Activity Kitchen" on
Trigger Activity Kitchen
SQLite exception logging variable change: attempt to write a readonly database
SQLite exception logging variable change: attempt to write a readonly database

Thanks,
Randy

Re: SQLite Error message on Indigo 5

PostPosted: Tue Nov 22, 2011 1:07 pm
by matt (support)
From the Terminal app (/Applications/Utilities/Terminal), copy/paste these lines and press return:

Code: Select all
id
cd /Library/Application\ Support/Perceptive\ Automation/Indigo\ 5/IndigoSqlClient
ls -al

And then copy/paste the results from the Terminal window into a reply for me.

Have you tried restarting your Mac to see if the problem persists?

Re: SQLite Error message on Indigo 5

PostPosted: Wed Nov 23, 2011 8:35 am
by rlust
Here are the results

macpro:~ user$ id
uid=507(user) gid=20(staff) groups=20(staff),106(com.apple.sharepoint.group.6),101(com.apple.sharepoint.group.1),408(com.apple.sharepoint.group.13),...
macpro:~ user$ cd /Library/Application\ Support/Perceptive\ Automation/Indigo\ 5/IndigoSqlClient
macpro:IndigoSqlClient user$ ls -al
total 13704
drwxrwxr-x 8 root admin 272 Nov 20 14:35 .
drwxrwxr-x 14 root admin 476 Nov 21 11:30 ..
-rw-rw-r-- 1 root admin 1623 Sep 2 2009 IndigoSqlClient.conf
-rwxrwxr-x@ 1 root admin 6095 Mar 24 2009 IndigoSqlClient.py
-rw-rw-r-- 1 root admin 1071 Jun 6 2008 ReadMe.html
drwxrwxr-x 4 root admin 136 Nov 20 14:33 devhelpers
drwxrwxr-x 13 root admin 442 Nov 20 14:35 indigopy
-rw-r--r-- 1 501 admin 6998016 Aug 18 20:15 sqlite_db

Re: SQLite Error message on Indigo 5

PostPosted: Wed Nov 23, 2011 9:28 am
by matt (support)
The sqlite_db file in that folder has the wrong user owner (it was probably moved over from another Mac or you have done an OS X reinstall). To fix it from the Terminal enter:

Code: Select all
cd /Library/Application\ Support/Perceptive\ Automation/Indigo\ 5/IndigoSqlClient
sudo chown 507:admin sqlite_db