Esperyd?s Raspberry PI project

Announcement - Help us fight the BOTS! Please report all spam including stuff in your inbox!

Walde

Member
Joined
May 18, 2018
Messages
120
Hello everyone, have a nice weekend.

I have a little problem.
Maybe you can hero me.
Didn't find what I was looking for online and after four hours of searching, I'm just done with the world.

I have two SDM230, each with its own database. How can I calculate the difference in KW / h?
The representation of each one goes with no problems

Code for No. 1 from DataBase "DB_Meters"

Code for No 2: from DataBase "DB_Meters2"



image_kyjruo.jpg



image_ykeosg.jpg


Greetings Dirk

Thanks in advance
 

daromer

Moderator
Joined
Oct 8, 2016
Messages
5,659
You should have the data in same database and then just tag them different. If you run Influx thats a must for quick calculation. And to be honest it should be like that in other DBs to.

So start by making sure you have all energy data in same database and just with different tags
Like tag=meter1 and tag=meter2
and then have the value in the field named value
So much easier to work with
 

Walde

Member
Joined
May 18, 2018
Messages
120
daromer said:
You should have the data in same database and then just tag them different. If you run Influx thats a must for quick calculation. And to be honest it should be like that in other DBs to.

So start by making sure you have all energy data in same database and just with different tags
Like tag=meter1 and tag=meter2
and then have the value in the field named value
So much easier to work with

I have two SDM230, each with its own database

DataBase "DB_Meters" and DataBase "DB_Meters2"
 

daromer

Moderator
Joined
Oct 8, 2016
Messages
5,659
Put Them in a energy database
Use influx and tag Them as Said. Thats so much easier to work wirh
 

Michel

New member
Joined
Apr 30, 2018
Messages
14
Have any of you managed to get two PIP's in parallel to work? We've downloaded the DUALPIP4048 scripts from the the original github repository, modified the serial device name/location.

After some fooling around it appears to be reading some data, but influx rejects the status data, possibly due to some syntax error? See below the tcpdump data from the conversation between the script and influx. General information (aka settings) are successfully pushed into influx.

image_kxwhkm.jpg

Error appears to be:
Code:
X-Influxdb-Error: unable to parse 'undefinedquery_general_status0

Any suggestions?
 

daromer

Moderator
Joined
Oct 8, 2016
Messages
5,659
It looks like you get an undefined value and that gets set together with general query and that doesnt exist in the db.
Are you running solar-sis?
 

iantully

New member
Joined
Feb 2, 2018
Messages
6
Michel,



YesIhavetwo5048systemsworking,the5048isanewerversionofthe4048,apowerfactorof1.Ididhave4048initiallythoughonefailedandhadto upgrade. I had to get serial cables that contain aFtdi Chipset that is more expensive.


I needed to create this script and cron job to restart it periodically as it would stop communicating.




image_rkjaff.jpg



# m h dom mon dow comma
5,10,15,20,30,35,40,45,50,55 * * * * /home/pi/start_solar.sh > /home/pi/restart.log
The script start_solar.sh


#!/bin/bash

/usr/bin/sudo /bin/systemctl restart solar_pip
/usr/bin/sudo /bin/systemctl restart solar_pip1



I use openhab to interface the invertors to alter turning on and off devices. I use a curl callto influx db to do this.


It has been very reliable running for 2 + years.














Have any of you managed to get two PIP's in parallel to work? We've downloaded the DUALPIP4048 scripts from the the original github repository, modified the serial device name/location.

After some fooling around it appears to be reading some data, but influx rejects the status data, possibly due to some syntax error? See below the tcpdump data from the conversation between the script and influx. General information (aka settings) are successfully pushed into influx.

image_kxwhkm.jpg

Error appears to be:
Code:
X-Influxdb-Error: unable to parse 'undefinedquery_general_status0

Any suggestions?[/quote]
 

Michel

New member
Joined
Apr 30, 2018
Messages
14
iantully said:
Michel,



YesIhavetwo5048systemsworking,the5048isanewerversionofthe4048,apowerfactorof1.Ididhave4048initiallythoughonefailedandhadto upgrade. I had to get serial cables that contain aFtdi Chipset that is more expensive.


I needed to create this script and cron job to restart it periodically as it would stop communicating.




image_rkjaff.jpg



# m h dom mon dow comma
5,10,15,20,30,35,40,45,50,55 * * * * /home/pi/start_solar.sh > /home/pi/restart.log
The script start_solar.sh


#!/bin/bash

/usr/bin/sudo /bin/systemctl restart solar_pip
/usr/bin/sudo /bin/systemctl restart solar_pip1



I use openhab to interface the invertors to alter turning on and off devices. I use a curl callto influx db to do this.


It has been very reliable running for 2 + years.














Have any of you managed to get two PIP's in parallel to work? We've downloaded the DUALPIP4048 scripts from the the original github repository, modified the serial device name/location.

After some fooling around it appears to be reading some data, but influx rejects the status data, possibly due to some syntax error? See below the tcpdump data from the conversation between the script and influx. General information (aka settings) are successfully pushed into influx.

image_kxwhkm.jpg

Error appears to be:
Code:
X-Influxdb-Error: unable to parse 'undefinedquery_general_status0

Any suggestions?







[/quote]

I @iantully,

Thank you for your reply. Just to get a better understanding of your set-up:
  • Why did you need to get a 3rd party USB/Serial cable? The built in Serial/USB converter in the PIP didn't work for you? It appears to be working for us, but the script seems to fail to parse the received data correctly.
  • What scripts are you using? And have you had to modify anything? Mind sharing them?
Thank you in advance!
 

daromer

Moderator
Joined
Oct 8, 2016
Messages
5,659
The built on usb to Serial have very poor drivers on Linux. I use proper rs232 adaptors :)
 

iantully

New member
Joined
Feb 2, 2018
Messages
6
Michel said:
1523[/ATTACH]


image_uwaajn.jpg



First Invertor

{

"serial_port": "/dev/ttyUSB0",
"serial_baudrate": 2400,
"serial_queue_delay": 200,
"serial_parsers_readline": "\r",
"serial_restart_threshold": 10000,
"serial_clear_command_queue_on_restart": true,
"http_port": 3001,
"influx_pre_header": "pip1_",
"influxUrl": "http://localhost:8086/write?db=powerwall&precision=s",
"IntervalCommands": [
{
"name": "general_status",
"config": "query_config",
"command": "query/general_status",
"interval": 3000,
"max": 0,
"influx": true
},
{
"name": "device_rated_information",
"config": "query_config",
"command": "query/device_rated_information",
"interval": 40000,
"max": 0,
"influx": true
}
],
"OnInit": {
"StartInterval": ["general_status", "device_rated_information"]
}
}




Second Invertor
{

"serial_port": "/dev/ttyUSB1",
"serial_baudrate": 2400,
"serial_queue_delay": 200,
"serial_parsers_readline": "\r",
"serial_restart_threshold": 10000,
"serial_clear_command_queue_on_restart": true,
"http_port": 3003,
"influx_pre_header": "pip_",
"influxUrl": "http://localhost:8086/write?db=powerwall&precision=s",
"IntervalCommands": [
{
"name": "general_status",
"config": "query_config",
"command": "query/general_status",
"interval": 3000,
"max": 0,
"influx": true
},
{
"name": "device_rated_information",
"config": "query_config",
"command": "query/device_rated_information",
"interval": 40000,
"max": 0,
"influx": true
}
],
"OnInit": {
"StartInterval": ["general_status", "device_rated_information"]
}
}



iantully said:
Michel,



YesIhavetwo5048systemsworking,the5048isanewerversionofthe4048,apowerfactorof1.Ididhave4048initiallythoughonefailedandhadto upgrade. I had to get serial cables that contain aFtdi Chipset that is more expensive.


I needed to create this script and cron job to restart it periodically as it would stop communicating.




image_rkjaff.jpg



# m h dom mon dow comma
5,10,15,20,30,35,40,45,50,55 * * * * /home/pi/start_solar.sh > /home/pi/restart.log
The script start_solar.sh


#!/bin/bash

/usr/bin/sudo /bin/systemctl restart solar_pip
/usr/bin/sudo /bin/systemctl restart solar_pip1



I use openhab to interface the invertors to alter turning on and off devices. I use a curl callto influx db to do this.


It has been very reliable running for 2 + years.














Have any of you managed to get two PIP's in parallel to work? We've downloaded the DUALPIP4048 scripts from the the original github repository, modified the serial device name/location.

After some fooling around it appears to be reading some data, but influx rejects the status data, possibly due to some syntax error? See below the tcpdump data from the conversation between the script and influx. General information (aka settings) are successfully pushed into influx.

image_kxwhkm.jpg

Error appears to be:
Code:
X-Influxdb-Error: unable to parse 'undefinedquery_general_status0

Any suggestions?

















I @iantully,

Thank you for your reply. Just to get a better understanding of your set-up:
  • Why did you need to get a 3rd party USB/Serial cable? The built in Serial/USB converter in the PIP didn't work for you? It appears to be working for us, but the script seems to fail to parse the received data correctly.
  • What scripts are you using? And have you had to modify anything? Mind sharing them?
Thank you in advance!
[/quote]
 

Attachments

  • image_aavmve.jpg
    image_aavmve.jpg
    342.2 KB · Views: 162

oilskov

New member
Joined
Apr 24, 2018
Messages
8
Does anyone know the password for the user (pi) in the iso? I accidentally logged out.
 

ejaz

New member
Joined
Jul 11, 2019
Messages
8
hello

thanks for your iso i am using two years now my sd card is broken i buy new card after installation i have this error
image_ywmhjh.jpg
 

daromer

Moderator
Joined
Oct 8, 2016
Messages
5,659
whats on line 19 in your version? Changed something?
 

daromer

Moderator
Joined
Oct 8, 2016
Messages
5,659
Look at the image.
 

ejaz

New member
Joined
Jul 11, 2019
Messages
8
daromer

i dont understand i made two things one upgrade solar-sis with git pull command and another pip4084 folder npm modules and serial port /dev/hidraw1 to /dev/ttyAMA0
 

daromer

Moderator
Joined
Oct 8, 2016
Messages
5,659
The image says you have an issue in one of the files on line 19. Look at that to see. You obviously changed something that make it fail
 
Top