Esperyd?s Raspberry PI project

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
 
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
 
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"
 
Put Them in a energy database
Use influx and tag Them as Said. Thats so much easier to work wirh
 
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?
 
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?
 
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]
 
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!
 
The built on usb to Serial have very poor drivers on Linux. I use proper rs232 adaptors :)
 
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: 199
Does anyone know the password for the user (pi) in the iso? I accidentally logged out.
 
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
 
whats on line 19 in your version? Changed something?
 
Look at the image.
 
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
 
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
 
Back
Top