anyone experience with a photoresistor and how to translate that to a 0 to 10 volt signal?

I connected it to the analog input of a Neuron L523

is there a limit to the number of lines you can add to the ODBC database driver ?.

if I add another line, he gives a fault with everything I remove that line again, it is fine again

see here under my mysql_ioconfig.rio

ODBC {
Connection "DRIVER=MySQL;SERVER=;PORT=;DATABAS"
"E=;UID=;PWD=*******;;"
#Comment1 "Archive modes: 0=disable, 1=alarm(columns Time,Alar"
#"mID,Code,Level,Value), 2=group(columns Time,GroupID,Value1,Value2,...), 3=gro"
#"up(SQL with ? in order Time, ID, value1,...)"
#Comment2 "Group modes: 0=disable, 1=read (last ID is accepted"
#"), 2=read(last Time before now is accepted), 3=read(SQL first line is accepte"
#"d), 129=write, 130=write with Time, 131=write SQL (with ?, Time is ?T)"
#GUID *******
Group {
Name "Read"
Mode 3
SQL "SELECT Schakelaar1Uit, Schakelaar1Aan, Schakelaar"
"2Uit, Schakelaar2Aan, Schakelaar3Uit, Schakelaar3Aan, Schakelaar4Uit, Schakela"
"ar4Aan, Schakelaar5Uit, Schakelaar5Aan FROM Schakelaars WHERE ID=1"
Period 2
Items "Schakelaar1Uit,Schakelaar1Aan,Schakelaar2Uit,Scha"
"kelaar2Aan,Schakelaar3Uit,Schakelaar3Aan,Schakelaar4Uit,Schakelaar4Aan,Schakel"
"aar5Uit,Schakelaar5Aan"
Type "ssssssssss"
}
Group {
Name "Read2"
Mode 3
SQL "SELECT Schakelaar6Uit, Schakelaar6Aan, Schakelaar"
"7Uit, Schakelaar7Aan, Schakelaar8Uit, Schakelaar8Aan, Schakelaar9Uit, Schakela"
"ar9Aan, Schakelaar10Uit, Schakelaar10Aan FROM Schakelaars WHERE ID=1"
Period 2
Items "Schakelaar6Uit,Schakelaar6Aan,Schakelaar7Uit,Scha"
"kelaar7Aan,Schakelaar8Uit,Schakelaar8Aan,Schakelaar9Uit,Schakelaar9Aan,Schakel"
"aar10Uit,Schakelaar10Aan"
Type "ssssssssss"
}
Group {
Name "Read3"
Mode 3
SQL "SELECT Schakelaar11Uit, Schakelaar11Aan, Schakela"
"ar12Uit, Schakelaar12Aan, Schakelaar13Uit, Schakelaar13Aan, Schakelaar14Uit, S"
"chakelaar14Aan, Schakelaar15Uit, Schakelaar15Aan FROM Schakelaars WHERE ID=1"
Period 2
Items "Schakelaar11Uit,Schakelaar11Aan,Schakelaar12Uit,S"
"chakelaar12Aan,Schakelaar13Uit,Schakelaar13Aan,Schakelaar14Uit,Schakelaar14Aan"
",Schakelaar15Uit,Schakelaar15Aan"
Type "ssssssssss"
}
Group {
Name "Read4"
Mode 3
SQL "SELECT Schakelaar16Uit, Schakelaar16Aan, Schakela"
"ar17Uit, Schakelaar17Aan, Schakelaar18Uit, Schakelaar18Aan, Schakelaar19Uit, S"
"chakelaar19Aan, Schakelaar20Uit, Schakelaar20Aan FROM Schakelaars WHERE ID=1"
Period 2
Items "Schakelaar16Uit,Schakelaar16Aan,Schakelaar17Uit,S"
"chakelaar17Aan,Schakelaar18Uit,Schakelaar18Aan,Schakelaar19Uit,Schakelaar19Aan"
",Schakelaar20Uit,Schakelaar20Aan"
Type "ssssssssss"
}
Group {
Name "Read5"
Mode 3
SQL "SELECT Schakelaar21Uit, Schakelaar21Aan, Schakela"
"ar22Uit, Schakelaar22Aan, Schakelaar23Uit, Schakelaar23Aan FROM Schakelaars WH"
"ERE ID=1"
Period 2
Items "Schakelaar21Uit,Schakelaar21Aan,Schakelaar22Uit,S"
"chakelaar22Aan,Schakelaar23Uit,Schakelaar23Aan"
Type "ssssss"
}
Group {
Name "Read6"
Mode 3
SQL "SELECT SDimmer1Aan, SDimmer1Uit, SDimmer2Aan, SDi"
"mmer2Uit, SDimmer3Aan, SDimmer3Uit, SDimmer4Aan, SDimmer4Uit, SDimmer5Aan, SDi"
"mmer5Uit FROM Schakelaars WHERE ID=1"
Period 2
Items "SDimmer1Aan,SDimmer1Uit,SDimmer2Aan,SDimmer2Uit,S"
"Dimmer3Aan,SDimmer3Uit,SDimmer4Aan,SDimmer4Uit,SDimmer5Aan,SDimmer5Uit"
Type "ssssssssss"
}
Group {
Name "Read7"
Mode 3
SQL "SELECT SDimmer6Aan, SDimmer6Uit, SDimmer7Aan, SDi"
"mmer7Uit, SDimmer8Aan, SDimmer8Uit FROM Schakelaars WHERE ID=1"
Period 2
Items "SDimmer6Aan,SDimmer6Uit,SDimmer7Aan,SDimmer7Uit,S"
"Dimmer8Aan,SDimmer8Uit"
Type "ssssss"
}
Group {
Name "Read8"
Mode 3
SQL "SELECT Dimmer1, Dimmer2, Dimmer3, Dimmer4, Dimmer"
"5, Dimmer6, Dimmer7, Dimmer8, Dimmer9 FROM EntertainmentKnop WHERE Id=?10"
Period 2
Items "Dimmer1,Dimmer2,Dimmer3,Dimmer4,Dimmer5,Dimmer6,D"
"immer7,Dimmer8,Dimmer9,ID"
Type "sssssssssi"
}
Group {
Name "Read9"
Mode 3
SQL "SELECT Dimmer10 FROM EntertainmentKnop WHERE Id=?"
"2"
Period 2
Items "Dimmer10,ID"
Type "si"
}
Group {
Name "Read10"
Mode 3
SQL "SELECT SDimmer9Aan, SDimmer9Uit, SDimmer10Aan, SD"
"immer10Uit, SDimmer11Aan, SDimmer11Uit, SDimmer12Aan, SDimmer12Uit, SDimmer13A"
"an, SDimmer13Uit FROM Schakelaars WHERE ID=1"
Period 2
Items "SDimmer9Aan,SDimmer9Uit,SDimmer10Aan,SDimmer10Uit"
",SDimmer11Aan,SDimmer11Uit,SDimmer12Aan,SDimmer12Uit,SDimmer13Aan,SDimmer13Uit"
Type "ssssssssss"
}
Group {
Name "Read11"
Mode 3
SQL "SELECT SDimmer14Aan, SDimmer14Uit, SDimmer15Aan, "
"SDimmer15Uit, SDimmer16Aan, SDimmer16Uit, SDimmer17Aan, SDimmer17Uit, SDimmer1"
"8Aan, SDimmer18Uit FROM Schakelaars WHERE ID=1"
Period 2
Items "SDimmer14Aan,SDimmer14Uit,SDimmer15Aan,SDimmer15U"
"it,SDimmer16Aan,SDimmer16Uit,SDimmer17Aan,SDimmer17Uit,SDimmer18Aan,SDimmer18U"
"it"
Type "ssssssssss"
}
Group {
Name "Read12"
Mode 3
SQL "SELECT SDimmer19Aan, SDimmer19Uit, SDimmer20Aan, "
"SDimmer20Uit, SDimmer21Aan, SDimmer21Uit, SDimmer22Aan, SDimmer22Uit, SDimmer2"
"3Aan, SDimmer23Uit FROM Schakelaars WHERE ID=1"
Period 2
Items "SDimmer19Aan,SDimmer19Uit,SDimmer20Aan,SDimmer20U"
"it,SDimmer21Aan,SDimmer21Uit,SDimmer22Aan,SDimmer22Uit,SDimmer23Aan,SDimmer23U"
"it"
Type "ssssssssss"
}
Group {
Name "Read13"
Mode 3
SQL "SELECT ?2 FROM Schakelaars WHERE ID=1"
Period 2
Items "SchakelaarAanString,SchakelaarAan"
Type "ss"
}
Group {
Name "Write1"
Mode 131
SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
"d=1"
Period 2
Items "Schakelaar1Satus"
Type "s"
}
Group {
Name "Write2"
Mode 131
SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
"d=2"
Period 2
Items "Schakelaar2Satus"
Type "s"
}
Group {
Name "Write3"
Mode 131
SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
"d=3"
Period 2
Items "Schakelaar3Satus"
Type "s"
}
Group {
Name "Write4"
Mode 131
SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
"d=4"
Period 2
Items "Schakelaar4Satus"
Type "s"
}
Group {
Name "Write5"
Mode 131
SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
"d=5"
Period 2
Items "Schakelaar5Satus"
Type "s"
}
Group {
Name "Write6"
Mode 131
SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
"d=6"
Period 2
Items "Schakelaar6Satus"
Type "s"
}
Group {
Name "Write7"
Mode 131
SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
"d=7"
Period 2
Items "Schakelaar7Satus"
Type "s"
}
Group {
Name "Write8"
Mode 131
SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
"d=8"
Period 2
Items "Schakelaar8Satus"
Type "s"
}
Group {
Name "Write9"
Mode 131
SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
"d=9"
Period 2
Items "Schakelaar9Satus"
Type "s"
}
Group {
Name "Write10"
Mode 131
SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
"d=10"
Period 2
Items "Schakelaar10Satus"
Type "s"
}
Group {
Name "Write11"
Mode 131
SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
"d=11"
Period 2
Items "Schakelaar11Satus"
Type "s"
}
Group {
Name "Write12"
Mode 131
SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
"d=12"
Period 2
Items "Schakelaar12Satus"
Type "s"
}
Group {
Name "Write13"
Mode 131
SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
"d=13"
Period 2
Items "Schakelaar13Satus"
Type "s"
}
Group {
Name "Write14"
Mode 131
SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
"d=14"
Period 2
Items "Schakelaar14Satus"
Type "s"
}
Group {
Name "Write15"
Mode 131
SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
"d=15"
Period 2
Items "Schakelaar15Satus"
Type "s"
}
Group {
Name "Write16"
Mode 131
SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
"d=16"
Period 2
Items "Schakelaar16Satus"
Type "s"
}
Group {
Name "Write17"
Mode 131
SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
"d=17"
Period 2
Items "Schakelaar17Satus"
Type "s"
}
Group {
Name "Write18"
Mode 131
SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
"d=18"
Period 2
Items "Schakelaar18Satus"
Type "s"
}
Group {
Name "Write19"
Mode 131
SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
"d=19"
Period 2
Items "Schakelaar19Satus"
Type "s"
}
}

what is wrong here it is a normal CNR block with the value 1680 I place it outside the subsystem block directly on the output Extentons__xS51_1_AO1 I measure 4.2 volts I place the CNR block in the subsystem block it gives no output to the output Extentons__xS51_1_AO1

how do I Fix this error

pi@raspberrypi:~ $ sudo apt-get install neuron-kernel unipi-firmware
Reading package lists... Done
Building dependency tree
Reading state information... Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
neuron-kernel : Depends: raspberrypi-kernel (= 1.20190819~stretch-1) but 1.20200811-1 is to be installed
E: Unable to correct problems, you have held broken packages.
pi@raspberrypi:~ $

Can anyone help me

I would like to install rexygen on a Neuron L523
i follow this guide
https://www.rexygen.com/doc/ENGLISH/MANUALS/RexygenGettingStarted_UniPi/RexygenGettingStarted_UniPi_ENG.html

but can't get the plc up and running

is there a special way or maybe you need to install extra stuff with rexygen on a Neuron L523

whatever I try I can't get it to work

get this error code

12-8-2020 21:53:30.432 Error MBDRV: Socket receive error (idx=0, code=111)
12-8-2020 21:53:30.432 Error MBDRV: Error while receiving data(ignore, code=-309)

i would like to have the rexgen software running on a Unipi Neuron L523

if I am correct I have to edit the file neuron_cfg.rio to assign all digital inputs and relay outputs

where can I find the data that I have to enter there such as this for example
Item {
Name "RO3_1"
SlaveAdr 0
RegisterAdr 3001
Type 0x00000144
Count 2
}

@martijnperdaan said in Database:

Schakelaars

the input SwitchOn is variable sometimes it is Switch1On and sometimes Switch2On and sometimes Switch3On

so he has to read the value of for example Switch1On from the tablet Switches
for example, he should get back 01101010 as answer because it is stored underneath but he returns Switch1On in response

the system does not log an error because the SQL command line must be normal

what is wrong with this how can I read that value correctly from the database.

my idea says i have to add ?1 but where

Group {
Name "Read13"
Mode 3
SQL "SELECT ?2 FROM Schakelaars WHERE Id=1"
Period 2
Items "SchakelaarAanString,SchakelaarAan"
Type "ss"
}

I would like to have a checkbox 3 times in my hmi. but how do you set that only 1 can be turned on? .. if you click another button the one that was on goes off again. like checkbox 1 or checkbox 2 or checkbox 3 not and