[ANSWERED]: SQL Logger error

Posted on
Mon Jun 29, 2015 5:28 am
jens offline
Posts: 265
Joined: May 03, 2015
Location: Sweden

[ANSWERED]: SQL Logger error

Hey,
Get this error log now when I start the SQL, began after I switched to the new Z-Wave USB stick (z-wave.Me) ...

Please help :)
Attachments
SQL.png
SQL.png (289.94 KiB) Viewed 5329 times

Posted on
Mon Jun 29, 2015 9:47 am
matt (support) offline
Site Admin
User avatar
Posts: 21411
Joined: Jan 27, 2003
Location: Texas

Re: SQL Logger error

Indigo isn't able to connect to your PostgreSQL server. Are you sure it is running? Can you connect to it from another client or the command line?

Image

Posted on
Mon Jun 29, 2015 11:01 am
jens offline
Posts: 265
Joined: May 03, 2015
Location: Sweden

Re: [ANSWERED]: SQL Logger error

How do you start it ?? has not tried to connect, do not know how to do it... sooorryy

//Jens

Posted on
Mon Jun 29, 2015 11:41 am
FlyingDiver offline
User avatar
Posts: 7189
Joined: Jun 07, 2014
Location: Southwest Florida, USA

Re: [ANSWERED]: SQL Logger error

jens wrote:
How do you start it ?? has not tried to connect, do not know how to do it... sooorryy

//Jens


If you don't know how to start or connect to a PostgresSQL server, you should probably either disable the SQL Logger plugin, or switch it to SQLight.

joe (aka FlyingDiver)
my plugins: http://forums.indigodomo.com/viewforum.php?f=177

Posted on
Mon Jun 29, 2015 1:21 pm
matt (support) offline
Site Admin
User avatar
Posts: 21411
Joined: Jan 27, 2003
Location: Texas

Re: [ANSWERED]: SQL Logger error

FlyingDiver is correct. PostgreSQL is neither included nor installed by Indigo. There is no way Indigo can connect to it unless you have installed and configured it. The SQLite option will work out-of-the-box though.

Image

Posted on
Tue Jun 30, 2015 12:12 am
jens offline
Posts: 265
Joined: May 03, 2015
Location: Sweden

Re: [ANSWERED]: SQL Logger error

Get this message now :( I can delete the old file and SQL creates a new ???

//Jens
Attachments
Skärmavbild 2015-06-30 kl. 08.09.46.png
Skärmavbild 2015-06-30 kl. 08.09.46.png (486.05 KiB) Viewed 5233 times

Posted on
Tue Jun 30, 2015 4:46 am
FlyingDiver offline
User avatar
Posts: 7189
Joined: Jun 07, 2014
Location: Southwest Florida, USA

Re: [ANSWERED]: SQL Logger error

Yes, you can delete the old .sqlite file and Indigo will create a new one. Make sure Indigo is not running (UI and server) when you do that.

joe (aka FlyingDiver)
my plugins: http://forums.indigodomo.com/viewforum.php?f=177

Posted on
Tue Jun 30, 2015 7:22 am
jens offline
Posts: 265
Joined: May 03, 2015
Location: Sweden

Re: [ANSWERED]: SQL Logger error

Okey, thanks will try

Skickat från min D6603 via Tapatalk

Posted on
Fri Jul 10, 2015 2:06 am
jens offline
Posts: 265
Joined: May 03, 2015
Location: Sweden

Re: [ANSWERED]: SQL Logger error

Has now removed the SQL log file, but get the same error message :(

//Jens

Posted on
Fri Jul 10, 2015 9:15 am
matt (support) offline
Site Admin
User avatar
Posts: 21411
Joined: Jan 27, 2003
Location: Texas

Re: [ANSWERED]: SQL Logger error

It sounds like there is a file/folder permission problem. Re-run the Indigo installer. It will attempt to fix some permission problems.

Image

Posted on
Sat Jul 11, 2015 3:15 am
jens offline
Posts: 265
Joined: May 03, 2015
Location: Sweden

Re: [ANSWERED]: SQL Logger error

Will try

Skickat från min D6603 via Tapatalk

Posted on
Mon Jul 13, 2015 2:46 am
jens offline
Posts: 265
Joined: May 03, 2015
Location: Sweden

Re: [ANSWERED]: SQL Logger error

Still the same problem after Re-run the Indigo installer, some more idea :(

//Jens

Posted on
Thu Jul 16, 2015 10:55 am
matt (support) offline
Site Admin
User avatar
Posts: 21411
Joined: Jan 27, 2003
Location: Texas

Re: [ANSWERED]: SQL Logger error

When you deleted the old indigo_history.sqlite file, did you make sure that both the Indigo client and Indigo Server were stopped first?

Image

Posted on
Sat Jul 18, 2015 10:25 am
jens offline
Posts: 265
Joined: May 03, 2015
Location: Sweden

Re: [ANSWERED]: SQL Logger error

No client Was on :(


Sent from my iPhone 6 using Tapatalk

Posted on
Sat Jul 18, 2015 10:26 am
jens offline
Posts: 265
Joined: May 03, 2015
Location: Sweden

Re: [ANSWERED]: SQL Logger error

And mayby server


Sent from my iPhone 6 using Tapatalk

Who is online

Users browsing this forum: No registered users and 3 guests