Min/Max plugin has stopped working

[bjmouton]

Hi,

My plugin has quit working for some reason. Below is log text after restart:

28 21:32:05 logger enabled for THREADDEBUG
28 21:32:05 logger enabled for DEBUG
21:32:05 logger enabled for INFO
21:32:05 logger enabled for WARNING
2021-04-28 21:32:05.872 ERROR Plugin.__init__ logger enabled for ERROR
2021-04-28 21:32:05.872 CRITICAL Plugin.__init__ logger enabled for CRITICAL
21:32:05 -myLogSet setting parameters -- logFileActive= indigo; logFile= /Library/Application Support/Perceptive Automation/Indigo 7.5/Logs/com.karlwachs.minMax/plugin.log; debugLevel= [u'Sql', u'Setup']
21:32:05 Configuration:
21:32:05 Dev/Var-Name----- ID State ignoreLess ignoreGreater format tracking measures: -------
21:32:05 Front Door Sensor 18622376 onOffState -9876543210 9876543210 '%.1f' lastDay- Count1
thisDay- Count1
21:32:05 Ecobee Hallway Remote - Guest Bedroom 218001346 sensorValue -9876543210 9876543210 '%.1f' thisDay- Min Max Ave
21:32:05 Tool Room Multi - Temperature 644478552 sensorValue -9876543210 9876543210 '%.1f' thisDay- Min Max Ave
21:32:05 Patio Door Sensor 61344331 onOffState -9876543210 9876543210 '%.1f' lastDay- Count1
thisDay- Count1
21:32:05 Attic Temperature 442644910 sensorValue -9876543210 9876543210 '%.1f' thisDay- Min Max Ave
21:32:05 Pump Shed - Temperature 1692324660 sensorValue -9876543210 9876543210 '%.1f' thisDay- Min Max Ave
21:32:05 Ecobee Hallway Remote - Office 920894099 sensorValue -9876543210 9876543210 '%.1f' thisDay- Min Max Ave
21:32:05 Ecobee Hallway Remote - Living Room 212449776 sensorValue -9876543210 9876543210 '%.1f' thisDay- Min Max Ave
21:32:05 Ecobee Hallway Remote - Kitchen 1193883684 sensorValue -9876543210 9876543210 '%.1f' thisDay- Min Max Ave
21:32:05 Ecobee Hallway Remote - Master Bedroom 979009114 sensorValue -9876543210 9876543210 '%.1f' thisDay- Min Max Ave
21:32:05 Ecobee Hallway 861920429temperatureInput1 -9876543210 9876543210 '%.1f' thisDay- Min Max Ave
21:32:05 PatioTemperature 1774580169 value -9876543210 9876543210 '%.1f' thisHour- Min Max Ave
lastHour- Min Max Ave
lastDay- DateMax Min Max DateMin Ave
thisDay- Min Max Ave
21:32:05 Deck Door Sensor 364274916 onOffState -9876543210 9876543210 '%.1f' lastDay- Count1
thisDay- Count1
21:32:05 AmbientTemperature 729752752 value -9876543210 9876543210 '%.1f' thisHour- Min Max Ave
lastHour- Min Max Ave
21:32:05 config parameters foldername >minMax<
21:32:05 config parameters refreshRate >180.0<
21:32:05 config parameters liteOrPsql >psql<
21:32:05 config parameters refreshRate >180.0<[secs]
21:32:05 config parameters liteOrPsql >psql<
21:32:05 config parameters liteOrPsqlString >/Applications/Postgres.app/Contents/Versions/latest/bin/psql indigo_history postgres<
21:32:05 config parameters postgresPassword ><
21:32:05 config parameters timeFormatDisplay >%Y-%m-%d-%H:%M:%S<
28 21:32:06 /Applications/Postgres.app/Contents/Versions/latest/bin/psql indigo_history postgres -t -A -F ';' -c "SELECT to_char(ts,'YYYY-mm-dd-HH24:MI:ss'), onOffState from device_history_18622376 where to_char(ts,'YYYY-mm-dd-HH24:MI:ss') > '2021-02-28-00:32:06' ORDER by id ;"
28 21:32:06 data-out:
28 21:32:06 err-out: psql: error: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

28 21:32:06 /Applications/Postgres.app/Contents/Versions/latest/bin/psql indigo_history postgres -t -A -F ';' -c "SELECT to_char(ts,'YYYY-mm-dd-HH24:MI:ss'), sensorValue from device_history_218001346 where to_char(ts,'YYYY-mm-dd-HH24:MI:ss') > '2021-02-28-00:32:06' ORDER by id ;"
28 21:32:06 data-out:
28 21:32:06 err-out: psql: error: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

28 21:32:06 /Applications/Postgres.app/Contents/Versions/latest/bin/psql indigo_history postgres -t -A -F ';' -c "SELECT to_char(ts,'YYYY-mm-dd-HH24:MI:ss'), sensorValue from device_history_644478552 where to_char(ts,'YYYY-mm-dd-HH24:MI:ss') > '2021-02-28-00:32:06' ORDER by id ;"
28 21:32:06 data-out:
28 21:32:06 err-out: psql: error: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

28 21:32:06 /Applications/Postgres.app/Contents/Versions/latest/bin/psql indigo_history postgres -t -A -F ';' -c "SELECT to_char(ts,'YYYY-mm-dd-HH24:MI:ss'), onOffState from device_history_61344331 where to_char(ts,'YYYY-mm-dd-HH24:MI:ss') > '2021-02-28-00:32:06' ORDER by id ;"
28 21:32:06 data-out:
28 21:32:06 err-out: psql: error: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

28 21:32:06 /Applications/Postgres.app/Contents/Versions/latest/bin/psql indigo_history postgres -t -A -F ';' -c "SELECT to_char(ts,'YYYY-mm-dd-HH24:MI:ss'), sensorValue from device_history_442644910 where to_char(ts,'YYYY-mm-dd-HH24:MI:ss') > '2021-02-28-00:32:06' ORDER by id ;"
28 21:32:06 data-out:
28 21:32:06 err-out: psql: error: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

28 21:32:06 /Applications/Postgres.app/Contents/Versions/latest/bin/psql indigo_history postgres -t -A -F ';' -c "SELECT to_char(ts,'YYYY-mm-dd-HH24:MI:ss'), sensorValue from device_history_1692324660 where to_char(ts,'YYYY-mm-dd-HH24:MI:ss') > '2021-02-28-00:32:06' ORDER by id ;"
28 21:32:06 data-out:
28 21:32:06 err-out: psql: error: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

28 21:32:06 /Applications/Postgres.app/Contents/Versions/latest/bin/psql indigo_history postgres -t -A -F ';' -c "SELECT to_char(ts,'YYYY-mm-dd-HH24:MI:ss'), sensorValue from device_history_920894099 where to_char(ts,'YYYY-mm-dd-HH24:MI:ss') > '2021-02-28-00:32:06' ORDER by id ;"
28 21:32:06 data-out:
28 21:32:06 err-out: psql: error: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

28 21:32:06 /Applications/Postgres.app/Contents/Versions/latest/bin/psql indigo_history postgres -t -A -F ';' -c "SELECT to_char(ts,'YYYY-mm-dd-HH24:MI:ss'), sensorValue from device_history_212449776 where to_char(ts,'YYYY-mm-dd-HH24:MI:ss') > '2021-02-28-00:32:06' ORDER by id ;"
28 21:32:06 data-out:
28 21:32:06 err-out: psql: error: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

28 21:32:06 /Applications/Postgres.app/Contents/Versions/latest/bin/psql indigo_history postgres -t -A -F ';' -c "SELECT to_char(ts,'YYYY-mm-dd-HH24:MI:ss'), sensorValue from device_history_1193883684 where to_char(ts,'YYYY-mm-dd-HH24:MI:ss') > '2021-02-28-00:32:06' ORDER by id ;"
28 21:32:06 data-out:
28 21:32:06 err-out: psql: error: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

28 21:32:06 /Applications/Postgres.app/Contents/Versions/latest/bin/psql indigo_history postgres -t -A -F ';' -c "SELECT to_char(ts,'YYYY-mm-dd-HH24:MI:ss'), sensorValue from device_history_979009114 where to_char(ts,'YYYY-mm-dd-HH24:MI:ss') > '2021-02-28-00:32:06' ORDER by id ;"
28 21:32:06 data-out:
28 21:32:06 err-out: psql: error: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

28 21:32:06 /Applications/Postgres.app/Contents/Versions/latest/bin/psql indigo_history postgres -t -A -F ';' -c "SELECT to_char(ts,'YYYY-mm-dd-HH24:MI:ss'), temperatureInput1 from device_history_861920429 where to_char(ts,'YYYY-mm-dd-HH24:MI:ss') > '2021-02-28-00:32:06' ORDER by id ;"
28 21:32:06 data-out:
28 21:32:06 err-out: psql: error: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

28 21:32:06 /Applications/Postgres.app/Contents/Versions/latest/bin/psql indigo_history postgres -t -A -F ';' -c "SELECT to_char(ts,'YYYY-mm-dd-HH24:MI:ss'), value from variable_history_1774580169 where to_char(ts,'YYYY-mm-dd-HH24:MI:ss') > '2021-02-28-00:32:06' ORDER by id ;"
28 21:32:06 data-out:
28 21:32:06 err-out: psql: error: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

28 21:32:06 /Applications/Postgres.app/Contents/Versions/latest/bin/psql indigo_history postgres -t -A -F ';' -c "SELECT to_char(ts,'YYYY-mm-dd-HH24:MI:ss'), onOffState from device_history_364274916 where to_char(ts,'YYYY-mm-dd-HH24:MI:ss') > '2021-02-28-00:32:06' ORDER by id ;"
28 21:32:06 data-out:
28 21:32:06 err-out: psql: error: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

28 21:32:06 /Applications/Postgres.app/Contents/Versions/latest/bin/psql indigo_history postgres -t -A -F ';' -c "SELECT to_char(ts,'YYYY-mm-dd-HH24:MI:ss'), value from variable_history_729752752 where to_char(ts,'YYYY-mm-dd-HH24:MI:ss') > '2021-02-28-00:32:06' ORDER by id ;"
28 21:32:06 data-out:
28 21:32:06 err-out: psql: error: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

21:32:26 subscribing to device changes
21:32:26 subscribing to variable changes

[kw123]

As it states. It can not connect to the psql server.
Did you do an upgrade anything?
Can you open terminal and type
psql
Does that give an error?


Sent from my iPhone using Tapatalk

[bjmouton]

Yes, I get the error when running psql from terminal. Not understanding, the app is installed. Have not done upgrades of any kind, has been working fine since installation in January. Did experience an extended power outage recently which took Indigo server box down.

[kw123]

Try reinstalling the psql app.

And is sqllogger enabled in indigo? And you don’t get any error messages?

And why kind of error do you get when launching psql in terminal?


Sent from my iPhone using Tapatalk

[bjmouton]

Reinstalled the app. Restarted Sqllogger in Indigo, here's Indigo log text:
2021-04-30 13:24:11.131 SQL Logger Error PostgreSQL server 127.0.0.1 is not reachable (may not have started yet)
2021-04-30 13:24:11.131 SQL Logger Error reconnect attempt scheduled in 5 seconds

This is terminal text when I try to launch:
Last login: Fri Apr 30 13:21:29 on ttys000
Billys-Mac-mini:~ billymouton$ psql
psql: error: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
Billys-Mac-mini:~ billymouton$

[kw123]

This has nothing to do with min max plugin

You did install postgres on the indigo server?


Sent from my iPhone using Tapatalk

[bjmouton]

Yes I did.

[kw123]

Is psql running?
Double click on the app.


Sent from my iPhone using Tapatalk

[bjmouton]

Got postgres working only after using a an app removal utility to completely remove the app and then did another install.

Thanks for your assistance

[bjmouton]

The postgres app on my Indigo server seems to have been corrupted. Could you please send me a link to the app that I need to run? I tried the app available at https://www.postgresql.org/download/, but that does not work for me.

Thanks

[kw123]

ThAt works for me

You also need to install the Apple intel emulator when you run this on an m1


Sent from my iPhone using Tapatalk

[bjmouton]

I don't see a link or attachment....

[bjmouton]

Do you have a document explaining how to setup postgres to be used with the plugin or explaining how to setup the plugin with postgres?

[kw123]

1. Can you install Postgres? Does it start? Did you enable sqllogger in Indigo?
2. What kind of mac and which opsys
3. In min max you need to define the path to Postgres in config. There are examples given.


Sent from my iPhone using Tapatalk