http://laimburggasse.onthewifi.com/mediawiki/api.php?action=feedcontributions&feedformat=atom&user=Uweaquarium-doc - User contributions [en]2026-09-02T10:20:29ZUser contributionsMediaWiki 1.37.1http://laimburggasse.onthewifi.com/mediawiki/index.php?title=Control_application&diff=161Control application2023-04-08T17:59:11Z<p>Uwe: </p>
<hr />
<div>The main control application of Aquarium control implements the following features:<br />
<br />
* [[Data acquisition of water temperature, pH and conductivity]]<br />
* [[Data acquisition of ambient temperature and humidity]]<br />
* Fresh water refill control<br />
* Feed control<br />
* Water temperature control using air ventilation and heater<br />
* [[Calculation of refill tank content]] based on [[water level measurement]] <br />
* Actuation of pump for water exchange<br />
<br />
Additionally, the main control application implements the following supporting features:<br />
* HW-Tests<br />
* Text-To-Speech interface<br />
* Logging<br />
* Command interface to receive instructions from outside of the application<br />
* Storage of recorded data in SQL database<br />
* File-based communication to web application<br />
* [[Relay Board Control|Monitoring and repair of relay board state]]<br />
* [[Device Scheduling]]<br />
<br />
The control application makes extensive use of the [https://abyz.me.uk/rpi/pigpio/ pigpio library].<br />
<br />
The [[architecture]] of the application uses various threads.<br />
<br />
The application is [[automatic start by using systemd]].<br />
<br />
== Installation ==<br />
<br />
for the installation of the operating system on the Raspberry Pi, please follow the instructions of the [https://www.raspberrypi.com Raspberry Pi foundation].<br />
Use the 64-bit version.<br />
<br />
=== Clone the repository, build and install the control SW ===<br />
Create the folder with the usage rights:<br />
<br />
<code>sudo mkdir /usr/local/src/aquarium-ctrl</code><br />
<br />
<code>sudo chown pi /usrlocal/src/aquarium-ctrl</code><br />
<br />
<code>cd /usr/local/src/aquarium-ctrl</code><br />
<br />
Next, clone the repository:<br />
<code>git clone https://in-dubio@bitbucket.org/in-dubio/aquarium-ctrl.git</code><br />
<br />
Install the required libraries:<br />
<code>bash libinstall.sh</code><br />
<br />
=== Enable I2C on Raspberry Pi ===<br />
See [https://www.mathworks.com/help/supportpkg/raspberrypiio/ref/enablei2c.html detailed instructions how to use rasp-config].<br />
<br />
=== Create a file for the message queue ===<br />
The file is automatically created when running <code>make install</code>.<br />
<br />
Alternatively, run the command <code>sudo touch /var/local/aquarium-ctrl.mq</code>.<br />
<br />
The file is defined in the source file <code>UsrIntrfc/MsgQu.h</code>.<br />
<br />
=== Create a ramdisk ===<br />
Create the folder <code>/mnt/ramdisk</code>.<br />
<br />
Add the following line to <code>/etc/fstab</code>: <code>tmpfs /mnt/ramdisk tmpfs nodev,nosuid,size=50M 0 0</code>.<br />
<br />
Add a symbolic link using the command <code>ln -s /mnt/ramdisk /var/local/aquarium-ctrl</code>.<br />
<br />
=== Automatic start of control application ===<br />
[[Automatic_start_by_using_systemd|Follow instructions for configuring automatic start of control application.]]<br />
<br />
=== Create the website ===<br />
In the folder <code>/var/www/html</code>, create the website using <code>git clone https://in-dubio@bitbucket.org/in-dubio/aquarium-web.git</code>.<br />
<br />
Change the owner of the website to user <code>pi</code> and change the group of the website to <code>www-data</code>.<br />
<br />
Create a symbolic link to the log file running <code>ln -s /var/log/aquarium-ctrl-session.log /var/www/html/aquarium-web/logfile.txt</code>.<br />
<br />
Create the file <code>/var/www/app.ini</code> with the following content (set the correct password):<br />
<code><br />
<br />
[database]<br />
<br />
server = localhost<br />
<br />
port = 3306<br />
<br />
user = aquarium<br />
<br />
password = YourPassword<br />
<br />
database = aquarium<br />
</code><br />
<br />
[[Download and install the node JavaScript libraries.]]<br />
<br />
=== Setup of database ===<br />
* Download or clone an SQL database dump: <code>git clone https://in-dubio@bitbucket.org/in-dubio/aquarium-database.git</code><br />
* [https://www.digitalocean.com/community/tutorials/how-to-import-and-export-databases-in-mysql-or-mariadb Import a database.]<br />
* Create the user <code>aquarium</code> and assign access rights to the <code>aquarium</code> database.<br />
* Check the user rights using [https://www.phpmyadmin.net phpmyadmin]</div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=Control_application&diff=160Control application2023-04-08T17:58:19Z<p>Uwe: /* Installation */</p>
<hr />
<div>The main control application of Aquarium control implements the following features:<br />
<br />
* [[Data acquisition of water temperature, pH and conductivity]]<br />
* [[Data acquisition of ambient temperature and humidity]]<br />
* Fresh water refill control<br />
* Feed control<br />
* Water temperature control using air ventilation and heater<br />
* [[Calculation of refill tank content]] based on [[water level measurement]] <br />
* Actuation of pump for water exchange<br />
<br />
Additionally, the main control application implements the following supporting features:<br />
* HW-Tests<br />
* Text-To-Speech interface<br />
* Logging<br />
* Command interface to receive instructions from outside of the application<br />
* Storage of recorded data in SQL database<br />
* File-based communication to web application<br />
* [[Relay Board Control|Monitoring and repair of relay board state]]<br />
* [[Device Scheduling]]<br />
<br />
The control application makes extensive use of the [https://abyz.me.uk/rpi/pigpio/ pigpio library].<br />
<br />
The [[architecture]] of the application uses various threads.<br />
<br />
The application is [[automatic start by using systemd]].<br />
<br />
== Installation ==<br />
<br />
for the installation of the operating system on the Raspberry Pi, please follow the instructions of the [https://www.raspberrypi.com Raspberry Pi foundation].<br />
Use the 64-bit version.<br />
<br />
=== Clone the repository, build and install the control SW ===<br />
Create the folder with the usage rights:<br />
<br />
<code>sudo mkdir /usr/local/src/aquarium-ctrl</code><br />
<br />
<code>sudo chown pi /usrlocal/src/aquarium-ctrl</code><br />
<br />
<code>cd /usr/local/src/aquarium-ctrl</code><br />
<br />
Next, clone the repository:<br />
<code>git clone https://in-dubio@bitbucket.org/in-dubio/aquarium-ctrl.git</code><br />
<br />
Install the required libraries:<br />
<code>bash libinstall.sh</code><br />
<br />
=== Enable I2C on Raspberry Pi ===<br />
See [https://www.mathworks.com/help/supportpkg/raspberrypiio/ref/enablei2c.html detailed instructions how to use rasp-config].<br />
<br />
=== Create a file for the message queue ===<br />
The file is automatically created when running <code>make install</code>.<br />
<br />
Alternatively, run the command <code>sudo touch /var/local/aquarium-ctrl.mq</code>.<br />
<br />
The file is defined in the source file <code>UsrIntrfc/MsgQu.h</code>.<br />
<br />
=== Create a ramdisk ===<br />
Create the folder <code>/mnt/ramdisk</code>.<br />
<br />
Add the following line to <code>/etc/fstab</code>: <code>tmpfs /mnt/ramdisk tmpfs nodev,nosuid,size=50M 0 0</code>.<br />
<br />
Add a symbolic link using the command <code>ln -s /mnt/ramdisk /var/local/aquarium-ctrl</code>.<br />
<br />
=== Automatic start of control application ===<br />
[[Automatic_start_by_using_systemd|Follow instructions for configuring automatic start of control application.]]<br />
<br />
=== Create the website ===<br />
In the folder <code>/var/www/html</code>, create the website using <code>git clone https://in-dubio@bitbucket.org/in-dubio/aquarium-web.git</code>.<br />
<br />
Change the owner of the website to user <code>pi</code> and change the group of the website to <code>www-data</code>.<br />
<br />
Create a symbolic link to the log file running <code>ln -s /var/log/aquarium-ctrl-session.log /var/www/html/aquarium-web/logfile.txt</code>.<br />
<br />
Create the file <code>/var/www/app.ini</code> with the following content (set the correct password):<br />
<code><br />
<br />
[database]<br />
<br />
server = localhost<br />
<br />
port = 3306<br />
<br />
user = aquarium<br />
<br />
password = YourPassword<br />
<br />
database = aquarium<br />
</code><br />
<br />
[[Download and install the node JavaScript libraries.]]<br />
<br />
=== Setup of database ===<br />
* Download or [[git clone https://in-dubio@bitbucket.org/in-dubio/aquarium-database.git|clone an SQL database dump]].<br />
* [https://www.digitalocean.com/community/tutorials/how-to-import-and-export-databases-in-mysql-or-mariadb Import a database.]<br />
* Create the user <code>aquarium</code> and assign access rights to the <code>aquarium</code> database.<br />
* Check the user rights using [https://www.phpmyadmin.net phpmyadmin]</div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=Control_application&diff=159Control application2023-04-08T17:42:10Z<p>Uwe: /* Setup of database */</p>
<hr />
<div>The main control application of Aquarium control implements the following features:<br />
<br />
* [[Data acquisition of water temperature, pH and conductivity]]<br />
* [[Data acquisition of ambient temperature and humidity]]<br />
* Fresh water refill control<br />
* Feed control<br />
* Water temperature control using air ventilation and heater<br />
* [[Calculation of refill tank content]] based on [[water level measurement]] <br />
* Actuation of pump for water exchange<br />
<br />
Additionally, the main control application implements the following supporting features:<br />
* HW-Tests<br />
* Text-To-Speech interface<br />
* Logging<br />
* Command interface to receive instructions from outside of the application<br />
* Storage of recorded data in SQL database<br />
* File-based communication to web application<br />
* [[Relay Board Control|Monitoring and repair of relay board state]]<br />
* [[Device Scheduling]]<br />
<br />
The control application makes extensive use of the [https://abyz.me.uk/rpi/pigpio/ pigpio library].<br />
<br />
The [[architecture]] of the application uses various threads.<br />
<br />
The application is [[automatic start by using systemd]].<br />
<br />
== Installation ==<br />
<br />
for the installation of the operating system on the Raspberry Pi, please follow the instructions of the [https://www.raspberrypi.com Raspberry Pi foundation].<br />
Use the 64-bit version.<br />
<br />
=== Clone the repository, build and install the control SW ===<br />
Create the folder with the usage rights:<br />
<br />
<code>sudo mkdir /usr/local/src/aquarium-ctrl</code><br />
<br />
<code>sudo chown pi /usrlocal/src/aquarium-ctrl</code><br />
<br />
<code>cd /usr/local/src/aquarium-ctrl</code><br />
<br />
Next, clone the repository:<br />
<code>git clone https://in-dubio@bitbucket.org/in-dubio/aquarium-ctrl.git</code><br />
<br />
Install the required libraries:<br />
<code>bash libinstall.sh</code><br />
<br />
=== Enable I2C on Raspberry Pi ===<br />
See [https://www.mathworks.com/help/supportpkg/raspberrypiio/ref/enablei2c.html detailed instructions how to use rasp-config].<br />
<br />
=== Create a file for the message queue ===<br />
The file is automatically created when running <code>make install</code>.<br />
<br />
Alternatively, run the command <code>sudo touch /var/local/aquarium-ctrl.mq</code>.<br />
<br />
The file is defined in the source file <code>UsrIntrfc/MsgQu.h</code>.<br />
<br />
=== Create a ramdisk ===<br />
Create the folder <code>/mnt/ramdisk</code>.<br />
<br />
Add the following line to <code>/etc/fstab</code>: <code>tmpfs /mnt/ramdisk tmpfs nodev,nosuid,size=50M 0 0</code>.<br />
<br />
Add a symbolic link using the command <code>ln -s /mnt/ramdisk /var/local/aquarium-ctrl</code>.<br />
<br />
=== Automatic start of control application ===<br />
[[Automatic_start_by_using_systemd|Follow instructions for configuring automatic start of control application.]]<br />
<br />
=== Create the website ===<br />
In the folder <code>/var/www/html</code>, create the website using <code>git clone https://in-dubio@bitbucket.org/in-dubio/aquarium-web.git</code>.<br />
<br />
Change the owner of the website to user <code>pi</code> and change the group of the website to <code>www-data</code>.<br />
<br />
Create a symbolic link to the log file running <code>ln -s /var/log/aquarium-ctrl-session.log /var/www/html/aquarium-web/logfile.txt</code>.<br />
<br />
Create the file <code>/var/www/app.ini</code> with the following content (set the correct password):<br />
<code><br />
<br />
[database]<br />
<br />
server = localhost<br />
<br />
port = 3306<br />
<br />
user = aquarium<br />
<br />
password = YourPassword<br />
<br />
database = aquarium<br />
</code><br />
<br />
[[Download and install the node JavaScript libraries.]]<br />
<br />
=== Setup of database ===<br />
* [https://www.digitalocean.com/community/tutorials/how-to-import-and-export-databases-in-mysql-or-mariadb Import a database.]<br />
* Create the user <code>aquarium</code> and assign access rights to the <code>aquarium</code> database.<br />
* Check the user rights using [https://www.phpmyadmin.net phpmyadmin]</div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=Control_application&diff=158Control application2023-04-08T17:37:37Z<p>Uwe: /* Setup of database */</p>
<hr />
<div>The main control application of Aquarium control implements the following features:<br />
<br />
* [[Data acquisition of water temperature, pH and conductivity]]<br />
* [[Data acquisition of ambient temperature and humidity]]<br />
* Fresh water refill control<br />
* Feed control<br />
* Water temperature control using air ventilation and heater<br />
* [[Calculation of refill tank content]] based on [[water level measurement]] <br />
* Actuation of pump for water exchange<br />
<br />
Additionally, the main control application implements the following supporting features:<br />
* HW-Tests<br />
* Text-To-Speech interface<br />
* Logging<br />
* Command interface to receive instructions from outside of the application<br />
* Storage of recorded data in SQL database<br />
* File-based communication to web application<br />
* [[Relay Board Control|Monitoring and repair of relay board state]]<br />
* [[Device Scheduling]]<br />
<br />
The control application makes extensive use of the [https://abyz.me.uk/rpi/pigpio/ pigpio library].<br />
<br />
The [[architecture]] of the application uses various threads.<br />
<br />
The application is [[automatic start by using systemd]].<br />
<br />
== Installation ==<br />
<br />
for the installation of the operating system on the Raspberry Pi, please follow the instructions of the [https://www.raspberrypi.com Raspberry Pi foundation].<br />
Use the 64-bit version.<br />
<br />
=== Clone the repository, build and install the control SW ===<br />
Create the folder with the usage rights:<br />
<br />
<code>sudo mkdir /usr/local/src/aquarium-ctrl</code><br />
<br />
<code>sudo chown pi /usrlocal/src/aquarium-ctrl</code><br />
<br />
<code>cd /usr/local/src/aquarium-ctrl</code><br />
<br />
Next, clone the repository:<br />
<code>git clone https://in-dubio@bitbucket.org/in-dubio/aquarium-ctrl.git</code><br />
<br />
Install the required libraries:<br />
<code>bash libinstall.sh</code><br />
<br />
=== Enable I2C on Raspberry Pi ===<br />
See [https://www.mathworks.com/help/supportpkg/raspberrypiio/ref/enablei2c.html detailed instructions how to use rasp-config].<br />
<br />
=== Create a file for the message queue ===<br />
The file is automatically created when running <code>make install</code>.<br />
<br />
Alternatively, run the command <code>sudo touch /var/local/aquarium-ctrl.mq</code>.<br />
<br />
The file is defined in the source file <code>UsrIntrfc/MsgQu.h</code>.<br />
<br />
=== Create a ramdisk ===<br />
Create the folder <code>/mnt/ramdisk</code>.<br />
<br />
Add the following line to <code>/etc/fstab</code>: <code>tmpfs /mnt/ramdisk tmpfs nodev,nosuid,size=50M 0 0</code>.<br />
<br />
Add a symbolic link using the command <code>ln -s /mnt/ramdisk /var/local/aquarium-ctrl</code>.<br />
<br />
=== Automatic start of control application ===<br />
[[Automatic_start_by_using_systemd|Follow instructions for configuring automatic start of control application.]]<br />
<br />
=== Create the website ===<br />
In the folder <code>/var/www/html</code>, create the website using <code>git clone https://in-dubio@bitbucket.org/in-dubio/aquarium-web.git</code>.<br />
<br />
Change the owner of the website to user <code>pi</code> and change the group of the website to <code>www-data</code>.<br />
<br />
Create a symbolic link to the log file running <code>ln -s /var/log/aquarium-ctrl-session.log /var/www/html/aquarium-web/logfile.txt</code>.<br />
<br />
Create the file <code>/var/www/app.ini</code> with the following content (set the correct password):<br />
<code><br />
<br />
[database]<br />
<br />
server = localhost<br />
<br />
port = 3306<br />
<br />
user = aquarium<br />
<br />
password = YourPassword<br />
<br />
database = aquarium<br />
</code><br />
<br />
[[Download and install the node JavaScript libraries.]]<br />
<br />
=== Setup of database ===<br />
* Import a database.<br />
* Create the user <code>aquarium</code> and assign access rights to the <code>aquarium</code> database.<br />
* Check the user rights using [https://www.phpmyadmin.net phpmyadmin]</div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=Control_application&diff=157Control application2023-04-08T17:32:11Z<p>Uwe: /* Installation */</p>
<hr />
<div>The main control application of Aquarium control implements the following features:<br />
<br />
* [[Data acquisition of water temperature, pH and conductivity]]<br />
* [[Data acquisition of ambient temperature and humidity]]<br />
* Fresh water refill control<br />
* Feed control<br />
* Water temperature control using air ventilation and heater<br />
* [[Calculation of refill tank content]] based on [[water level measurement]] <br />
* Actuation of pump for water exchange<br />
<br />
Additionally, the main control application implements the following supporting features:<br />
* HW-Tests<br />
* Text-To-Speech interface<br />
* Logging<br />
* Command interface to receive instructions from outside of the application<br />
* Storage of recorded data in SQL database<br />
* File-based communication to web application<br />
* [[Relay Board Control|Monitoring and repair of relay board state]]<br />
* [[Device Scheduling]]<br />
<br />
The control application makes extensive use of the [https://abyz.me.uk/rpi/pigpio/ pigpio library].<br />
<br />
The [[architecture]] of the application uses various threads.<br />
<br />
The application is [[automatic start by using systemd]].<br />
<br />
== Installation ==<br />
<br />
for the installation of the operating system on the Raspberry Pi, please follow the instructions of the [https://www.raspberrypi.com Raspberry Pi foundation].<br />
Use the 64-bit version.<br />
<br />
=== Clone the repository, build and install the control SW ===<br />
Create the folder with the usage rights:<br />
<br />
<code>sudo mkdir /usr/local/src/aquarium-ctrl</code><br />
<br />
<code>sudo chown pi /usrlocal/src/aquarium-ctrl</code><br />
<br />
<code>cd /usr/local/src/aquarium-ctrl</code><br />
<br />
Next, clone the repository:<br />
<code>git clone https://in-dubio@bitbucket.org/in-dubio/aquarium-ctrl.git</code><br />
<br />
Install the required libraries:<br />
<code>bash libinstall.sh</code><br />
<br />
=== Enable I2C on Raspberry Pi ===<br />
See [https://www.mathworks.com/help/supportpkg/raspberrypiio/ref/enablei2c.html detailed instructions how to use rasp-config].<br />
<br />
=== Create a file for the message queue ===<br />
The file is automatically created when running <code>make install</code>.<br />
<br />
Alternatively, run the command <code>sudo touch /var/local/aquarium-ctrl.mq</code>.<br />
<br />
The file is defined in the source file <code>UsrIntrfc/MsgQu.h</code>.<br />
<br />
=== Create a ramdisk ===<br />
Create the folder <code>/mnt/ramdisk</code>.<br />
<br />
Add the following line to <code>/etc/fstab</code>: <code>tmpfs /mnt/ramdisk tmpfs nodev,nosuid,size=50M 0 0</code>.<br />
<br />
Add a symbolic link using the command <code>ln -s /mnt/ramdisk /var/local/aquarium-ctrl</code>.<br />
<br />
=== Automatic start of control application ===<br />
[[Automatic_start_by_using_systemd|Follow instructions for configuring automatic start of control application.]]<br />
<br />
=== Create the website ===<br />
In the folder <code>/var/www/html</code>, create the website using <code>git clone https://in-dubio@bitbucket.org/in-dubio/aquarium-web.git</code>.<br />
<br />
Change the owner of the website to user <code>pi</code> and change the group of the website to <code>www-data</code>.<br />
<br />
Create a symbolic link to the log file running <code>ln -s /var/log/aquarium-ctrl-session.log /var/www/html/aquarium-web/logfile.txt</code>.<br />
<br />
Create the file <code>/var/www/app.ini</code> with the following content (set the correct password):<br />
<code><br />
<br />
[database]<br />
<br />
server = localhost<br />
<br />
port = 3306<br />
<br />
user = aquarium<br />
<br />
password = YourPassword<br />
<br />
database = aquarium<br />
</code><br />
<br />
[[Download and install the node JavaScript libraries.]]<br />
<br />
=== Setup of database ===<br />
* Import an empty database.<br />
* Create the user <code>aquarium</code> and assign access rights to the <code>aquarium</code> database.</div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=Control_application&diff=156Control application2023-04-08T17:31:31Z<p>Uwe: /* Clone the repository, build and install the control SW */</p>
<hr />
<div>The main control application of Aquarium control implements the following features:<br />
<br />
* [[Data acquisition of water temperature, pH and conductivity]]<br />
* [[Data acquisition of ambient temperature and humidity]]<br />
* Fresh water refill control<br />
* Feed control<br />
* Water temperature control using air ventilation and heater<br />
* [[Calculation of refill tank content]] based on [[water level measurement]] <br />
* Actuation of pump for water exchange<br />
<br />
Additionally, the main control application implements the following supporting features:<br />
* HW-Tests<br />
* Text-To-Speech interface<br />
* Logging<br />
* Command interface to receive instructions from outside of the application<br />
* Storage of recorded data in SQL database<br />
* File-based communication to web application<br />
* [[Relay Board Control|Monitoring and repair of relay board state]]<br />
* [[Device Scheduling]]<br />
<br />
The control application makes extensive use of the [https://abyz.me.uk/rpi/pigpio/ pigpio library].<br />
<br />
The [[architecture]] of the application uses various threads.<br />
<br />
The application is [[automatic start by using systemd]].<br />
<br />
== Installation ==<br />
<br />
for the installation of the operating system on the Raspberry Pi, please follow the instructions of the [https://www.raspberrypi.com Raspberry Pi foundation].<br />
<br />
=== Clone the repository, build and install the control SW ===<br />
Create the folder with the usage rights:<br />
<br />
<code>sudo mkdir /usr/local/src/aquarium-ctrl</code><br />
<br />
<code>sudo chown pi /usrlocal/src/aquarium-ctrl</code><br />
<br />
<code>cd /usr/local/src/aquarium-ctrl</code><br />
<br />
Next, clone the repository:<br />
<code>git clone https://in-dubio@bitbucket.org/in-dubio/aquarium-ctrl.git</code><br />
<br />
Install the required libraries:<br />
<code>bash libinstall.sh</code><br />
<br />
=== Enable I2C on Raspberry Pi ===<br />
See [https://www.mathworks.com/help/supportpkg/raspberrypiio/ref/enablei2c.html detailed instructions how to use rasp-config].<br />
<br />
=== Create a file for the message queue ===<br />
The file is automatically created when running <code>make install</code>.<br />
<br />
Alternatively, run the command <code>sudo touch /var/local/aquarium-ctrl.mq</code>.<br />
<br />
The file is defined in the source file <code>UsrIntrfc/MsgQu.h</code>.<br />
<br />
=== Create a ramdisk ===<br />
Create the folder <code>/mnt/ramdisk</code>.<br />
<br />
Add the following line to <code>/etc/fstab</code>: <code>tmpfs /mnt/ramdisk tmpfs nodev,nosuid,size=50M 0 0</code>.<br />
<br />
Add a symbolic link using the command <code>ln -s /mnt/ramdisk /var/local/aquarium-ctrl</code>.<br />
<br />
=== Automatic start of control application ===<br />
[[Automatic_start_by_using_systemd|Follow instructions for configuring automatic start of control application.]]<br />
<br />
=== Create the website ===<br />
In the folder <code>/var/www/html</code>, create the website using <code>git clone https://in-dubio@bitbucket.org/in-dubio/aquarium-web.git</code>.<br />
<br />
Change the owner of the website to user <code>pi</code> and change the group of the website to <code>www-data</code>.<br />
<br />
Create a symbolic link to the log file running <code>ln -s /var/log/aquarium-ctrl-session.log /var/www/html/aquarium-web/logfile.txt</code>.<br />
<br />
Create the file <code>/var/www/app.ini</code> with the following content (set the correct password):<br />
<code><br />
<br />
[database]<br />
<br />
server = localhost<br />
<br />
port = 3306<br />
<br />
user = aquarium<br />
<br />
password = YourPassword<br />
<br />
database = aquarium<br />
</code><br />
<br />
[[Download and install the node JavaScript libraries.]]<br />
<br />
=== Setup of database ===<br />
* Import an empty database.<br />
* Create the user <code>aquarium</code> and assign access rights to the <code>aquarium</code> database.</div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=Control_application&diff=155Control application2023-04-08T17:31:05Z<p>Uwe: /* Clone the repository, build and install the control SW */</p>
<hr />
<div>The main control application of Aquarium control implements the following features:<br />
<br />
* [[Data acquisition of water temperature, pH and conductivity]]<br />
* [[Data acquisition of ambient temperature and humidity]]<br />
* Fresh water refill control<br />
* Feed control<br />
* Water temperature control using air ventilation and heater<br />
* [[Calculation of refill tank content]] based on [[water level measurement]] <br />
* Actuation of pump for water exchange<br />
<br />
Additionally, the main control application implements the following supporting features:<br />
* HW-Tests<br />
* Text-To-Speech interface<br />
* Logging<br />
* Command interface to receive instructions from outside of the application<br />
* Storage of recorded data in SQL database<br />
* File-based communication to web application<br />
* [[Relay Board Control|Monitoring and repair of relay board state]]<br />
* [[Device Scheduling]]<br />
<br />
The control application makes extensive use of the [https://abyz.me.uk/rpi/pigpio/ pigpio library].<br />
<br />
The [[architecture]] of the application uses various threads.<br />
<br />
The application is [[automatic start by using systemd]].<br />
<br />
== Installation ==<br />
<br />
for the installation of the operating system on the Raspberry Pi, please follow the instructions of the [https://www.raspberrypi.com Raspberry Pi foundation].<br />
<br />
=== Clone the repository, build and install the control SW ===<br />
Create the folder with the usage rights:<br />
<br />
<code>sudo mkdir /usr/local/src/aquarium-ctrl</code><br />
<br />
<code>sudo chown pi /usrlocal/src/aquarium-ctrl/code><br />
<br />
<code>cd /usr/local/src/aquarium-ctrl</code><br />
<br />
Next, clone the repository:<br />
<br />
<code>git clone https://in-dubio@bitbucket.org/in-dubio/aquarium-ctrl.git</code><br />
<br />
Install the required libraries:<br />
<br />
<code>bash libinstall.sh</code><br />
<br />
=== Enable I2C on Raspberry Pi ===<br />
See [https://www.mathworks.com/help/supportpkg/raspberrypiio/ref/enablei2c.html detailed instructions how to use rasp-config].<br />
<br />
=== Create a file for the message queue ===<br />
The file is automatically created when running <code>make install</code>.<br />
<br />
Alternatively, run the command <code>sudo touch /var/local/aquarium-ctrl.mq</code>.<br />
<br />
The file is defined in the source file <code>UsrIntrfc/MsgQu.h</code>.<br />
<br />
=== Create a ramdisk ===<br />
Create the folder <code>/mnt/ramdisk</code>.<br />
<br />
Add the following line to <code>/etc/fstab</code>: <code>tmpfs /mnt/ramdisk tmpfs nodev,nosuid,size=50M 0 0</code>.<br />
<br />
Add a symbolic link using the command <code>ln -s /mnt/ramdisk /var/local/aquarium-ctrl</code>.<br />
<br />
=== Automatic start of control application ===<br />
[[Automatic_start_by_using_systemd|Follow instructions for configuring automatic start of control application.]]<br />
<br />
=== Create the website ===<br />
In the folder <code>/var/www/html</code>, create the website using <code>git clone https://in-dubio@bitbucket.org/in-dubio/aquarium-web.git</code>.<br />
<br />
Change the owner of the website to user <code>pi</code> and change the group of the website to <code>www-data</code>.<br />
<br />
Create a symbolic link to the log file running <code>ln -s /var/log/aquarium-ctrl-session.log /var/www/html/aquarium-web/logfile.txt</code>.<br />
<br />
Create the file <code>/var/www/app.ini</code> with the following content (set the correct password):<br />
<code><br />
<br />
[database]<br />
<br />
server = localhost<br />
<br />
port = 3306<br />
<br />
user = aquarium<br />
<br />
password = YourPassword<br />
<br />
database = aquarium<br />
</code><br />
<br />
[[Download and install the node JavaScript libraries.]]<br />
<br />
=== Setup of database ===<br />
* Import an empty database.<br />
* Create the user <code>aquarium</code> and assign access rights to the <code>aquarium</code> database.</div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=Control_application&diff=154Control application2023-04-08T17:30:40Z<p>Uwe: </p>
<hr />
<div>The main control application of Aquarium control implements the following features:<br />
<br />
* [[Data acquisition of water temperature, pH and conductivity]]<br />
* [[Data acquisition of ambient temperature and humidity]]<br />
* Fresh water refill control<br />
* Feed control<br />
* Water temperature control using air ventilation and heater<br />
* [[Calculation of refill tank content]] based on [[water level measurement]] <br />
* Actuation of pump for water exchange<br />
<br />
Additionally, the main control application implements the following supporting features:<br />
* HW-Tests<br />
* Text-To-Speech interface<br />
* Logging<br />
* Command interface to receive instructions from outside of the application<br />
* Storage of recorded data in SQL database<br />
* File-based communication to web application<br />
* [[Relay Board Control|Monitoring and repair of relay board state]]<br />
* [[Device Scheduling]]<br />
<br />
The control application makes extensive use of the [https://abyz.me.uk/rpi/pigpio/ pigpio library].<br />
<br />
The [[architecture]] of the application uses various threads.<br />
<br />
The application is [[automatic start by using systemd]].<br />
<br />
== Installation ==<br />
<br />
for the installation of the operating system on the Raspberry Pi, please follow the instructions of the [https://www.raspberrypi.com Raspberry Pi foundation].<br />
<br />
=== Clone the repository, build and install the control SW ===<br />
Create the folder with the usage rights:<br />
<br />
<code>sudo mkdir /usr/local/src/aquarium-ctrl</code><br />
<br />
<code>sudo chown pi /usrlocal/src/aquarium-ctrl/code><br />
<br />
<code>cd /usr/local/src/aquarium-ctrl</code><br />
<br />
Next, clone the repository:<br />
<code>git clone https://in-dubio@bitbucket.org/in-dubio/aquarium-ctrl.git</code><br />
<br />
Install the required libraries:<br />
<code>bash libinstall.sh</code><br />
<br />
=== Enable I2C on Raspberry Pi ===<br />
See [https://www.mathworks.com/help/supportpkg/raspberrypiio/ref/enablei2c.html detailed instructions how to use rasp-config].<br />
<br />
=== Create a file for the message queue ===<br />
The file is automatically created when running <code>make install</code>.<br />
<br />
Alternatively, run the command <code>sudo touch /var/local/aquarium-ctrl.mq</code>.<br />
<br />
The file is defined in the source file <code>UsrIntrfc/MsgQu.h</code>.<br />
<br />
=== Create a ramdisk ===<br />
Create the folder <code>/mnt/ramdisk</code>.<br />
<br />
Add the following line to <code>/etc/fstab</code>: <code>tmpfs /mnt/ramdisk tmpfs nodev,nosuid,size=50M 0 0</code>.<br />
<br />
Add a symbolic link using the command <code>ln -s /mnt/ramdisk /var/local/aquarium-ctrl</code>.<br />
<br />
=== Automatic start of control application ===<br />
[[Automatic_start_by_using_systemd|Follow instructions for configuring automatic start of control application.]]<br />
<br />
=== Create the website ===<br />
In the folder <code>/var/www/html</code>, create the website using <code>git clone https://in-dubio@bitbucket.org/in-dubio/aquarium-web.git</code>.<br />
<br />
Change the owner of the website to user <code>pi</code> and change the group of the website to <code>www-data</code>.<br />
<br />
Create a symbolic link to the log file running <code>ln -s /var/log/aquarium-ctrl-session.log /var/www/html/aquarium-web/logfile.txt</code>.<br />
<br />
Create the file <code>/var/www/app.ini</code> with the following content (set the correct password):<br />
<code><br />
<br />
[database]<br />
<br />
server = localhost<br />
<br />
port = 3306<br />
<br />
user = aquarium<br />
<br />
password = YourPassword<br />
<br />
database = aquarium<br />
</code><br />
<br />
[[Download and install the node JavaScript libraries.]]<br />
<br />
=== Setup of database ===<br />
* Import an empty database.<br />
* Create the user <code>aquarium</code> and assign access rights to the <code>aquarium</code> database.</div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=Automatic_start_by_using_systemd&diff=153Automatic start by using systemd2023-04-08T13:57:36Z<p>Uwe: </p>
<hr />
<div>The content of systemd unit file /lib/systemd/system/aquarium-ctrl.service as following:<br />
<br />
<code><br />
[Unit]<br />
<br />
Description=Aquarium Control Application<br />
<br />
After=multi-user.target<br />
<br />
<br />
[Service]<br />
<br />
Type=forking<br />
<br />
ExecStart=bash /usr/local/bin/aquarium-ctrl-startup<br />
<br />
[Install]<br />
<br />
WantedBy=multi-user.target<br />
</code><br />
<br />
<br />
Upon creation/modification of the unit file, one must run the command <code>sudo systemctl daemon-reload</code> in order to activate the changes.<br />
<br />
Then, also the command <code>sudo systemctl enable aquarium-ctrl.service</code> is required to enable the service.<br />
<br />
For starting the control application manually via systemd, one can use the command <code>sudo systemctl start aquarium-ctrl.service</code>.<br />
<br />
When running the application in a configuration that utilises the relay board, the startup script needs to start the <code>screen<code> application prior to the control application in order to set the baud rate of the relay boards:<br />
<br />
<code><br />
screen -dm /dev/ttyUSB0 19200<br />
<br />
screen -dm /dev/ttyUSB1 19200<br />
<br />
/usr/local/bin/aquarium-ctrl -f On -r On -u Off -d On -s On -g On -t Off -b On > /dev/null&<br />
</code></div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=Automatic_start_by_using_systemd&diff=152Automatic start by using systemd2023-04-08T13:44:13Z<p>Uwe: </p>
<hr />
<div>The content of systemd unit file /lib/systemd/system/aquarium-ctrl.service as following:<br />
<br />
<code><br />
[Unit]<br />
<br />
Description=Aquarium Control Application<br />
<br />
After=multi-user.target<br />
<br />
<br />
[Service]<br />
<br />
Type=forking<br />
<br />
ExecStart=bash /usr/local/bin/aquarium-ctrl-startup<br />
<br />
[Install]<br />
<br />
WantedBy=multi-user.target<br />
</code><br />
<br />
<br />
Upon creation/modification of the unit file, one must run the command <code>sudo systemctl daemon-reload</code> in order to activate the changes.<br />
<br />
For starting the control application manually via systemd, one can use the command <code>sudo systemctl start aquarium-ctrl.service</code>.<br />
<br />
When running the application in a configuration that utilises the relay board, the startup script needs to start the <code>screen<code> application prior to the control application in order to set the baud rate of the relay boards:<br />
<br />
<code><br />
screen -dm /dev/ttyUSB0 19200<br />
<br />
screen -dm /dev/ttyUSB1 19200<br />
<br />
/usr/local/bin/aquarium-ctrl -f On -r On -u Off -d On -s On -g On -t Off -b On > /dev/null&<br />
</code></div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=Device_Scheduling&diff=151Device Scheduling2023-04-02T10:41:33Z<p>Uwe: </p>
<hr />
<div>The following components actuate the relays:<br />
* Refill Control: refilling of fresh water depending on water level<br />
* Feeder Control: stopping flow pumps, skimmer and actuating the feeder<br />
* Water Exchange Control: actuating the external pump for water exchange<br />
* Balling Control: actuating the pumps for mineral dosing<br />
<br />
There are two requirements, which ask for a more sophisticated control of the relays:<br />
* The dosing of minerals needs to be as precise as possible.<br />
* The hardware shall be tested before commencing certain operations.<br />
* The communication with the board needs to be reinitialised or reopened after certain periods of time.<br />
<br />
== Avoiding conflicting access to the relays ==<br />
This functionality is implemented in <code>DevSchdlr/DevSchdlr.c</code>.<br />
<br />
Mutual exclusion is implemented using a semaphore.<br />
<br />
The semaphore is used only by the function <code>DevSchdlr</code>.<br />
This function is the central gateway for all other components to initiate usage of the relays.<br />
It shall give control of the hardware to a calling component so that the calling component can execute a sequence of commands which shall not be interrupted. <br />
<br />
The function uses three callbacks which are provided via argument and a label informing which component is using the relay board:<br />
<br />
<code>DevSchdlr (int TestFuncRlyBrd(void), int TestFuncControllino(void), void ExecFunc(void), char *lbl)</code><br />
<br />
The first and second callback functions (<code>TestFunc</code>) allow the calling component to determine specifically which tests needs to be carried out before the sequence can be initiated.<br />
For example, the Balling dosing only needs to actuate the low voltage relays while the feeder control only actuates the high voltage relays.<br />
<br />
The test functions implement specific recovery strategy.<br />
<br />
The callback function (<code>ExecFunc</code>) gives control to the calling component for execution of the sequence.<br />
Execution is only triggered if one call of the test function returned with a successful result.</div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=Relay_Board_Control&diff=150Relay Board Control2023-04-02T10:37:01Z<p>Uwe: </p>
<hr />
<div>The relay board control implements the following features:<br />
* Low level communication via serial port to the board<br />
* Watchdog for reading/writing to serial port<br />
* HW functionality test before executing commands<br />
* Monitoring and repair of relay board states<br />
* Avoiding conflicting access to relay board<br />
<br />
== Low level communication via serial port ==<br />
This functionality is implemented in <code>RlyBrdCtrl/RlyBrdCmd.c</code>.<br />
The communication follows the protocol laid out in the [https://asset.conrad.com/media10/add/160267/c1/-/gl/000197720ML02/bedienungsanleitung-197720-conrad-components-197720-relaiskarte-baustein-12-vdc-24-vdc.pdf user manual of the 197730/197730 relay boards].<br />
<br />
Every command consists of a sequence of 4 byte.<br />
{| class="wikitable"<br />
|+ command sequence for 197730/197720 relay boards<br />
|-<br />
! Byte # !! Content<br />
|-<br />
| 0 || command<br />
|-<br />
| 1 || board address<br />
|-<br />
| 2 || data<br />
|-<br />
| 3 || checksum<br />
|}<br />
<br />
The command can assume one of 8 values, whereby the controller only uses a subset of these:<br />
{| class="wikitable"<br />
|+ commands used for control of 197730/197720 relay boards<br />
|-<br />
! command # !! Meaning !! byte 0 value in board response<br />
|-<br />
| 1 || initialisation || 254<br />
|-<br />
| 2 || get relay states || 253<br />
|-<br />
| 6 || switch on relay || 249<br />
|-<br />
| 7 || switch off relay || 248<br />
|}<br />
<br />
The relay boards offer functionality to connect multiple boards in a bus system.<br />
Therefore, the commands have to specify an address to identify the board for which the command is issued.<br />
The aquarium controller does not use this functionality. Low voltage board and high voltage board are connected via separate USB connections.<br />
Hence, address is always set to one.<br />
<br />
The checksum is computed as XOR of byte 0, 1 and 2.<br />
<br />
The low level communication is done using one of two functions inside <code>RlyBrdCmd.c</code>.<br />
* <code>RlyBrdInitCom</code> for initialisation of the communication<br />
* <code>RlyBrdCmd</code> for sending commands to the boards<br />
<br />
Both commands use the semaphore <code>mutexRlyBrd</code> to guarantee exclusive access to the devices.<br />
Both commands check the length of the response from the board and issue an error if the length is not as expected.<br />
<br />
During the initialisation, the board responds an 8 byte sequence which seems to correspond to the SW version. Information regarding this sequence could not be found inside the user manual.<br />
{| class="wikitable"<br />
|+ initialisation response for 197730/197720 relay boards<br />
|-<br />
! Byte #!! 0 !! 1 !! 2 !! 3 !! 4 !! 5 !! 6 !! 7<br />
|-<br />
| Value || 0xfe || 0x01 || 0x0b || 0xf4 || 0x01 || 0x02 || 0x0b || 0x08<br />
|}<br />
The command <code>RlyBrdInitCom</code> checks if the relay board responds with this sequence.<br />
<br />
The command <code>RlyBrdCmd</code> checks the checksum of the board's response.<br />
Additionally, the function checks the response of the relay board.<br />
The response of the relay board sporadically deviates from the response defined in the user manual.<br />
Specified is a response which can be computed as <code>255 - command #</code>.<br />
After some time of operation the board changes to responding with <code> command #</code>.<br />
After some more time of operation, the board may change back to the specified response.<br />
The control adapts to this toggling response behaviour.<br />
Expected response is computed accordingly. Each byte of the board's response is checked.<br />
<br />
== Watchdog for reading/writing to serial port ==<br />
This functionality is implemented in <code>RlyBrdCtrl/RlyBrdWtchDg.c</code>.<br />
<br />
For communication with the relay boards, the application uses read and write instructions which may block the control flow at these points if the operation does not terminate.<br />
<br />
In order to detect such events, a separate thread <code>RlyBrdRdWrWtchDgThread</code> monitors the duration of the read/write operations.<br />
The flag monitors how long certain flags are <code>true</code>:<br />
* <code>RBC_Get_flgRlyBrdRdStarting</code> provides the flag for monitoring read operations.<br />
* <code>RBC_Get_flgRlyBrdWrStarting</code> provides the flag for monitoring write operations.<br />
<br />
The flags are set to <code>true</code> directly before the read/write operation and they are set to <code>false</code> directly after the operation.<br />
<br />
The watch dog thread increases a counter for each second the read/write operation takes. When the counter exceeds the threshold </code>RLYBRD_RD_WR_WTCHDG_MAX_T</code>, the thread issues a log file entry, forces flushing of file buffers via <code>sync();</code> and initiates a reboot of the device using <code>reboot(RB_AUTOBOOT);</code>.<br />
<br />
== HW functionality test ==<br />
This functionality is implemented in <code>RlyBrdCtrl/RlyBrdFdbck.c</code>.<br />
<br />
The control system connects a voltage input through one relay of each board to a GPIO pin of the Raspberry Pi.<br />
<br />
By measuring the GPIO pin state, the control system can determine if the opening/closing of the relay really happened instead of just relying on the feedback of each board.<br />
<br />
The feedback test evaluates three steps:<br />
# Starting with an open relay, check if GPIO state is <code>FALSE</code><br />
# Closing the relay, check if GPIO state is <code>TRUE</code><br />
# Opening the relay, check if GPIO state is <code>FALSE</code><br />
<br />
The feedback test executed before relay switching sequences (e.g. feeding pattern, Balling dosing, ...) and in regular time intervals (every 30min).<br />
<br />
== Monitoring and repair of relay board states ==<br />
This functionality is implemented in <code>RlyBrdCtrl/RlyBrdMidLay.c</code>.<br />
This middle layer component was introduced to record the commanded states and acquire the state information responded by the relay boards.<br />
Except for initialisation and shutdown, the low level communication with the board passes through this component.<br />
The function <code>RlyBrdChckStates</code> inside this component compares the commanded and the responded state.<br />
In case of differences, the function <code>RlyBrdRepairStates</code> issues commands to the related relay board in order to reestablish the previously commanded state.<br />
Both functions are called every minute from <code>RlyBrdChckStateThread</code>.</div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=Device_Scheduling&diff=149Device Scheduling2023-04-02T10:35:42Z<p>Uwe: Created page with "The following components actuate the relays: * Refill Control: refilling of fresh water depending on water level * Feeder Control: stopping flow pumps, skimmer and actuating the feeder * Water Exchange Control: actuating the external pump for water exchange * Balling Control: actuating the pumps for mineral dosing There are two requirements, which ask for a more sophisticated control of the relays: * The dosing of minerals needs to be as precise as possible. * The HW sh..."</p>
<hr />
<div>The following components actuate the relays:<br />
* Refill Control: refilling of fresh water depending on water level<br />
* Feeder Control: stopping flow pumps, skimmer and actuating the feeder<br />
* Water Exchange Control: actuating the external pump for water exchange<br />
* Balling Control: actuating the pumps for mineral dosing<br />
<br />
There are two requirements, which ask for a more sophisticated control of the relays:<br />
* The dosing of minerals needs to be as precise as possible.<br />
* The HW shall be tested before commencing certain operations.<br />
* The communication with the board needs to be reinitialised or reopened after certain periods of time.</div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=Control_application&diff=148Control application2023-04-02T10:33:07Z<p>Uwe: </p>
<hr />
<div>The main control application of Aquarium control implements the following features:<br />
<br />
* [[Data acquisition of water temperature, pH and conductivity]]<br />
* [[Data acquisition of ambient temperature and humidity]]<br />
* Fresh water refill control<br />
* Feed control<br />
* Water temperature control using air ventilation and heater<br />
* [[Calculation of refill tank content]] based on [[water level measurement]] <br />
* Actuation of pump for water exchange<br />
<br />
Additionally, the main control application implements the following supporting features:<br />
* HW-Tests<br />
* Text-To-Speech interface<br />
* Logging<br />
* Command interface to receive instructions from outside of the application<br />
* Storage of recorded data in SQL database<br />
* File-based communication to web application<br />
* [[Relay Board Control|Monitoring and repair of relay board state]]<br />
* [[Device Scheduling]]<br />
<br />
The control application makes extensive use of the [https://abyz.me.uk/rpi/pigpio/ pigpio library].<br />
<br />
The [[architecture]] of the application uses various threads.<br />
<br />
The application is [[automatic start by using systemd]].<br />
<br />
== Installation ==<br />
=== Enable I2C on Raspberry Pi ===<br />
See [https://www.mathworks.com/help/supportpkg/raspberrypiio/ref/enablei2c.html detailed instructions how to use rasp-config].<br />
<br />
=== Create a file for the message queue ===<br />
The file is automatically created when running <code>make install</code>.<br />
<br />
Alternatively, run the command <code>sudo touch /var/local/aquarium-ctrl.mq</code>.<br />
<br />
The file is defined in the source file <code>UsrIntrfc/MsgQu.h</code>.<br />
<br />
=== Create a ramdisk ===<br />
Create the folder <code>/mnt/ramdisk</code>.<br />
<br />
Add the following line to <code>/etc/fstab</code>: <code>tmpfs /mnt/ramdisk tmpfs nodev,nosuid,size=50M 0 0</code>.<br />
<br />
Add a symbolic link using the command <code>ln -s /mnt/ramdisk /var/local/aquarium-ctrl</code>.<br />
<br />
=== Automatic start of control application ===<br />
[[Automatic_start_by_using_systemd|Follow instructions for configuring automatic start of control application.]]<br />
<br />
=== Create the website ===<br />
In the folder <code>/var/www/html</code>, create the website using <code>git clone https://in-dubio@bitbucket.org/in-dubio/aquarium-web.git</code>.<br />
<br />
Change the owner of the website to user <code>pi</code> and change the group of the website to <code>www-data</code>.<br />
<br />
Create a symbolic link to the log file running <code>ln -s /var/log/aquarium-ctrl-session.log /var/www/html/aquarium-web/logfile.txt</code>.<br />
<br />
Create the file <code>/var/www/app.ini</code> with the following content (set the correct password):<br />
<code><br />
<br />
[database]<br />
<br />
server = localhost<br />
<br />
port = 3306<br />
<br />
user = aquarium<br />
<br />
password = YourPassword<br />
<br />
database = aquarium<br />
</code><br />
<br />
[[Download and install the node JavaScript libraries.]]<br />
<br />
=== Setup of database ===<br />
* Import an empty database.<br />
* Create the user <code>aquarium</code> and assign access rights to the <code>aquarium</code> database.</div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=Relay_boards&diff=147Relay boards2023-04-02T10:27:49Z<p>Uwe: </p>
<hr />
<div>The control system can use up to two relay boards.<br />
[[File:RelayBoardsMountedInControlCabinet.jpg|thumb|Relay boards mounted in the control cabinet. Low voltage to the left, high voltage to the right]]<br />
The supplier of the relay boards is Conrad electronics:<br />
* [https://www.conrad.at/de/p/conrad-components-197720-relaiskarte-baustein-12-v-dc-24-v-dc-197720.html Low-voltage relay board 197720]<br />
* [https://www.conrad.at/de/p/conrad-components-197730-relaiskarte-baustein-12-v-dc-197730.html High-voltage relay board 197730]<br />
<br />
The Raspberry Pi communicates with the relay board via USB, therefore an additional module needs to be assembled onto each relay board:<br />
* [https://www.conrad.at/de/p/197257-schnittstellenwandler-1-st-197257.html RS232 to USB converter]<br />
<br />
Experience from longer usage indicates that the high-voltage relay board is not stable leading to a major failure of the control system.<br />
The low-voltage relay board only showed minor deviations in device response, there it has been deactivated for the main controls as well.<br />
<br />
Both relay boards have been replaced by [[Controllino]].<br />
<br />
For future extensions, the control SW still includes the SW parts for operating the relay boards.</div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=Relay_boards&diff=146Relay boards2023-04-02T10:27:15Z<p>Uwe: </p>
<hr />
<div>The control system can use up to two relay boards.<br />
[[File:RelayBoardsMountedInControlCabinet.jpg|thumb|Relay boards mounted in the control cabinet. Low voltage to the left, high voltage to the right]]<br />
The supplier of the relay boards is Conrad electronics:<br />
* [https://www.conrad.at/de/p/conrad-components-197720-relaiskarte-baustein-12-v-dc-24-v-dc-197720.html Low-voltage relay board 197720]<br />
* [https://www.conrad.at/de/p/conrad-components-197730-relaiskarte-baustein-12-v-dc-197730.html High-voltage relay board]<br />
<br />
The Raspberry Pi communicates with the relay board via USB, therefore an additional module needs to be assembled onto each relay board:<br />
* [https://www.conrad.at/de/p/197257-schnittstellenwandler-1-st-197257.html RS232 to USB converter]<br />
<br />
Experience from longer usage indicates that the high-voltage relay board is not stable leading to a major failure of the control system.<br />
The low-voltage relay board only showed minor deviations in device response, there it has been deactivated for the main controls as well.<br />
<br />
Both relay boards have been replaced by [[Controllino]].<br />
<br />
For future extensions, the control SW still includes the SW parts for operating the relay boards.</div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=Control_cabinet&diff=145Control cabinet2023-04-02T10:23:33Z<p>Uwe: </p>
<hr />
<div>The control cabinet includes the following components<br />
<br />
* Main control unit (Raspberry Pi)<br />
* [[Controllino]]<br />
* [[Relay boards]]<br />
* Power supply 12V<br />
* Power supply 5V<br />
* Fuses<br />
* Circuit breaker<br />
* Relays for [[manual control of pumps and skimmer]]<br />
* Sockets for power output to pumps and skimmer<br />
* Voltage converter</div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=Control_application&diff=144Control application2023-03-28T07:40:36Z<p>Uwe: </p>
<hr />
<div>The main control application of Aquarium control implements the following features:<br />
<br />
* [[Data acquisition of water temperature, pH and conductivity]]<br />
* [[Data acquisition of ambient temperature and humidity]]<br />
* Fresh water refill control<br />
* Feed control<br />
* Water temperature control using air ventilation and heater<br />
* [[Calculation of refill tank content]] based on [[water level measurement]] <br />
* Actuation of pump for water exchange<br />
<br />
Additionally, the main control application implements the following supporting features:<br />
* HW-Tests<br />
* Text-To-Speech interface<br />
* Logging<br />
* Command interface to receive instructions from outside of the application<br />
* Storage of recorded data in SQL database<br />
* File-based communication to web application<br />
* [[Relay Board Control|Monitoring and repair of relay board state]]<br />
<br />
The control application makes extensive use of the [https://abyz.me.uk/rpi/pigpio/ pigpio library].<br />
<br />
The [[architecture]] of the application uses various threads.<br />
<br />
The application is [[automatic start by using systemd]].<br />
<br />
== Installation ==<br />
=== Enable I2C on Raspberry Pi ===<br />
See [https://www.mathworks.com/help/supportpkg/raspberrypiio/ref/enablei2c.html detailed instructions how to use rasp-config].<br />
<br />
=== Create a file for the message queue ===<br />
The file is automatically created when running <code>make install</code>.<br />
<br />
Alternatively, run the command <code>sudo touch /var/local/aquarium-ctrl.mq</code>.<br />
<br />
The file is defined in the source file <code>UsrIntrfc/MsgQu.h</code>.<br />
<br />
=== Create a ramdisk ===<br />
Create the folder <code>/mnt/ramdisk</code>.<br />
<br />
Add the following line to <code>/etc/fstab</code>: <code>tmpfs /mnt/ramdisk tmpfs nodev,nosuid,size=50M 0 0</code>.<br />
<br />
Add a symbolic link using the command <code>ln -s /mnt/ramdisk /var/local/aquarium-ctrl</code>.<br />
<br />
=== Automatic start of control application ===<br />
[[Automatic_start_by_using_systemd|Follow instructions for configuring automatic start of control application.]]<br />
<br />
=== Create the website ===<br />
In the folder <code>/var/www/html</code>, create the website using <code>git clone https://in-dubio@bitbucket.org/in-dubio/aquarium-web.git</code>.<br />
<br />
Change the owner of the website to user <code>pi</code> and change the group of the website to <code>www-data</code>.<br />
<br />
Create a symbolic link to the log file running <code>ln -s /var/log/aquarium-ctrl-session.log /var/www/html/aquarium-web/logfile.txt</code>.<br />
<br />
Create the file <code>/var/www/app.ini</code> with the following content (set the correct password):<br />
<code><br />
<br />
[database]<br />
<br />
server = localhost<br />
<br />
port = 3306<br />
<br />
user = aquarium<br />
<br />
password = YourPassword<br />
<br />
database = aquarium<br />
</code><br />
<br />
[[Download and install the node JavaScript libraries.]]<br />
<br />
=== Setup of database ===<br />
* Import an empty database.<br />
* Create the user <code>aquarium</code> and assign access rights to the <code>aquarium</code> database.</div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=Control_application&diff=143Control application2023-03-26T07:38:16Z<p>Uwe: /* Automatic start of control application */</p>
<hr />
<div>The main control application of Aquarium control implements the following features:<br />
<br />
* [[Data acquisition of water temperature, pH and conductivity]]<br />
* [[Data acquisition of ambient temperature and humidity]]<br />
* Fresh water refill control<br />
* Feed control<br />
* Water temperature control using air ventilation and heater<br />
* [[Calculation of refill tank content]] based on [[water level measurement]] <br />
* Actuation of pump for water exchange<br />
<br />
Additionally, the main control application implements the following supporting features:<br />
* HW-Tests<br />
* Text-To-Speech interface<br />
* Logging<br />
* Command interface to receive instructions from outside of the application<br />
* Storage of recorded data in SQL database<br />
* File-based communication to web application<br />
* [[Relay Board Control|Monitoring and repair of relay board state]]<br />
<br />
The control application makes extensive use of the [https://abyz.me.uk/rpi/pigpio/ pigpio library].<br />
<br />
The [[architecture]] of the application uses various threads.<br />
<br />
The application is [[automatic start by using systemd]].<br />
<br />
== Installation ==<br />
=== Enable I2C on Raspberry Pi ===<br />
See [https://www.mathworks.com/help/supportpkg/raspberrypiio/ref/enablei2c.html detailed instructions how to use rasp-config].<br />
<br />
=== Create a file for the message queue ===<br />
The file is automatically created when running <code>make install</code>.<br />
<br />
Alternatively, run the command <code>sudo touch /var/local/aquarium-ctrl.mq</code>.<br />
<br />
The file is defined in the source file <code>UsrIntrfc/MsgQu.h</code>.<br />
<br />
=== Create a ramdisk ===<br />
Create the folder <code>/mnt/ramdisk</code>.<br />
<br />
Add the following line to <code>/etc/fstab</code>: <code>tmpfs /mnt/ramdisk tmpfs nodev,nosuid,size=50M 0 0</code>.<br />
<br />
Add a symbolic link using the command <code>ln -s /mnt/ramdisk /var/local/aquarium-ctrl</code>.<br />
<br />
=== Automatic start of control application ===<br />
[[Automatic_start_by_using_systemd|Follow instructions for configuring automatic start of control application.]]<br />
<br />
=== Create the website ===<br />
In the folder <code>/var/www/html</code>, create the website using <code>git clone https://in-dubio@bitbucket.org/in-dubio/aquarium-web.git</code>.<br />
<br />
Change the owner of the website to user <code>pi</code> and change the group of the website to <code>www-data</code>.<br />
<br />
Create a symbolic link to the log file running <code>ln -s /var/log/aquarium-ctrl-session.log /var/www/html/aquarium-web/logfile.txt</code>.<br />
<br />
Create the file <code>/var/www/app.ini</code> with the following content (set the correct password):<br />
<code><br />
[database]<br />
server = localhost<br />
port = 3306<br />
user = aquarium<br />
password = YourPassword<br />
database = aquarium<br />
</code><br />
<br />
=== Setup of database ===<br />
* Import an empty database.<br />
* Create the user <code>aquarium</code> and assign access rights to the <code>aquarium</code> database.</div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=Control_application&diff=142Control application2023-03-26T07:37:25Z<p>Uwe: </p>
<hr />
<div>The main control application of Aquarium control implements the following features:<br />
<br />
* [[Data acquisition of water temperature, pH and conductivity]]<br />
* [[Data acquisition of ambient temperature and humidity]]<br />
* Fresh water refill control<br />
* Feed control<br />
* Water temperature control using air ventilation and heater<br />
* [[Calculation of refill tank content]] based on [[water level measurement]] <br />
* Actuation of pump for water exchange<br />
<br />
Additionally, the main control application implements the following supporting features:<br />
* HW-Tests<br />
* Text-To-Speech interface<br />
* Logging<br />
* Command interface to receive instructions from outside of the application<br />
* Storage of recorded data in SQL database<br />
* File-based communication to web application<br />
* [[Relay Board Control|Monitoring and repair of relay board state]]<br />
<br />
The control application makes extensive use of the [https://abyz.me.uk/rpi/pigpio/ pigpio library].<br />
<br />
The [[architecture]] of the application uses various threads.<br />
<br />
The application is [[automatic start by using systemd]].<br />
<br />
== Installation ==<br />
=== Enable I2C on Raspberry Pi ===<br />
See [https://www.mathworks.com/help/supportpkg/raspberrypiio/ref/enablei2c.html detailed instructions how to use rasp-config].<br />
<br />
=== Create a file for the message queue ===<br />
The file is automatically created when running <code>make install</code>.<br />
<br />
Alternatively, run the command <code>sudo touch /var/local/aquarium-ctrl.mq</code>.<br />
<br />
The file is defined in the source file <code>UsrIntrfc/MsgQu.h</code>.<br />
<br />
=== Create a ramdisk ===<br />
Create the folder <code>/mnt/ramdisk</code>.<br />
<br />
Add the following line to <code>/etc/fstab</code>: <code>tmpfs /mnt/ramdisk tmpfs nodev,nosuid,size=50M 0 0</code>.<br />
<br />
Add a symbolic link using the command <code>ln -s /mnt/ramdisk /var/local/aquarium-ctrl</code>.<br />
<br />
=== Automatic start of control application ===<br />
[[http://laimburggasse.onthewifi.com/mediawiki/index.php/Automatic_start_by_using_systemd|Follow instructions for configuring automatic start of control application.]]<br />
<br />
=== Create the website ===<br />
In the folder <code>/var/www/html</code>, create the website using <code>git clone https://in-dubio@bitbucket.org/in-dubio/aquarium-web.git</code>.<br />
<br />
Change the owner of the website to user <code>pi</code> and change the group of the website to <code>www-data</code>.<br />
<br />
Create a symbolic link to the log file running <code>ln -s /var/log/aquarium-ctrl-session.log /var/www/html/aquarium-web/logfile.txt</code>.<br />
<br />
Create the file <code>/var/www/app.ini</code> with the following content (set the correct password):<br />
<code><br />
[database]<br />
server = localhost<br />
port = 3306<br />
user = aquarium<br />
password = YourPassword<br />
database = aquarium<br />
</code><br />
<br />
=== Setup of database ===<br />
* Import an empty database.<br />
* Create the user <code>aquarium</code> and assign access rights to the <code>aquarium</code> database.</div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=Control_application&diff=141Control application2023-03-26T07:34:14Z<p>Uwe: </p>
<hr />
<div>The main control application of Aquarium control implements the following features:<br />
<br />
* [[Data acquisition of water temperature, pH and conductivity]]<br />
* [[Data acquisition of ambient temperature and humidity]]<br />
* Fresh water refill control<br />
* Feed control<br />
* Water temperature control using air ventilation and heater<br />
* [[Calculation of refill tank content]] based on [[water level measurement]] <br />
* Actuation of pump for water exchange<br />
<br />
Additionally, the main control application implements the following supporting features:<br />
* HW-Tests<br />
* Text-To-Speech interface<br />
* Logging<br />
* Command interface to receive instructions from outside of the application<br />
* Storage of recorded data in SQL database<br />
* File-based communication to web application<br />
* [[Relay Board Control|Monitoring and repair of relay board state]]<br />
<br />
The control application makes extensive use of the [https://abyz.me.uk/rpi/pigpio/ pigpio library].<br />
<br />
The [[architecture]] of the application uses various threads.<br />
<br />
The application is [[automatic start by using systemd]].<br />
<br />
== Installation ==<br />
=== Enable I2C on Raspberry Pi ===<br />
See [https://www.mathworks.com/help/supportpkg/raspberrypiio/ref/enablei2c.html detailed instructions how to use rasp-config].<br />
<br />
=== Create a file for the message queue ===<br />
The file is automatically created when running <code>make install</code>.<br />
<br />
Alternatively, run the command <code>sudo touch /var/local/aquarium-ctrl.mq</code>.<br />
<br />
The file is defined in the source file <code>UsrIntrfc/MsgQu.h</code>.<br />
<br />
=== Create a ramdisk ===<br />
Create the folder <code>/mnt/ramdisk</code>.<br />
<br />
Add the following line to <code>/etc/fstab</code>: <code>tmpfs /mnt/ramdisk tmpfs nodev,nosuid,size=50M 0 0</code>.<br />
<br />
Add a symbolic link using the command <code>ln -s /mnt/ramdisk /var/local/aquarium-ctrl</code>.<br />
<br />
=== Create the website ===<br />
In the folder <code>/var/www/html</code>, create the website using <code>git clone https://in-dubio@bitbucket.org/in-dubio/aquarium-web.git</code>.<br />
<br />
Change the owner of the website to user <code>pi</code> and change the group of the website to <code>www-data</code>.<br />
<br />
Create a symbolic link to the log file running <code>ln -s /var/log/aquarium-ctrl-session.log /var/www/html/aquarium-web/logfile.txt</code>.<br />
<br />
Create the file <code>/var/www/app.ini</code> with the following content (set the correct password):<br />
<code><br />
[database]<br />
server = localhost<br />
port = 3306<br />
user = aquarium<br />
password = YourPassword<br />
database = aquarium<br />
</code><br />
<br />
=== Setup of database ===<br />
* Import an empty database.<br />
* Create the user <code>aquarium</code> and assign access rights to the <code>aquarium</code> database.</div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=Control_application&diff=140Control application2023-03-26T07:32:40Z<p>Uwe: </p>
<hr />
<div>The main control application of Aquarium control implements the following features:<br />
<br />
* [[Data acquisition of water temperature, pH and conductivity]]<br />
* [[Data acquisition of ambient temperature and humidity]]<br />
* Fresh water refill control<br />
* Feed control<br />
* Water temperature control using air ventilation and heater<br />
* [[Calculation of refill tank content]] based on [[water level measurement]] <br />
* Actuation of pump for water exchange<br />
<br />
Additionally, the main control application implements the following supporting features:<br />
* HW-Tests<br />
* Text-To-Speech interface<br />
* Logging<br />
* Command interface to receive instructions from outside of the application<br />
* Storage of recorded data in SQL database<br />
* File-based communication to web application<br />
* [[Relay Board Control|Monitoring and repair of relay board state]]<br />
<br />
The control application makes extensive use of the [https://abyz.me.uk/rpi/pigpio/ pigpio library].<br />
<br />
The [[architecture]] of the application uses various threads.<br />
<br />
The application is [[automatic start by using systemd]].<br />
<br />
== Installation ==<br />
=== Enable I2C on Raspberry Pi ===<br />
See [https://www.mathworks.com/help/supportpkg/raspberrypiio/ref/enablei2c.html detailed instructions how to use rasp-config].<br />
<br />
=== Create a file for the message queue ===<br />
The file is automatically created when running <code>make install</code>.<br />
<br />
Alternatively, run the command <code>sudo touch /var/local/aquarium-ctrl.mq</code>.<br />
<br />
The file is defined in the source file <code>UsrIntrfc/MsgQu.h</code>.<br />
<br />
=== Create a ramdisk ===<br />
Create the folder <code>/mnt/ramdisk</code>.<br />
<br />
Add the following line to <code>/etc/fstab</code>: <code>tmpfs /mnt/ramdisk tmpfs nodev,nosuid,size=50M 0 0</code>.<br />
<br />
Add a symbolic link using the command <code>ln -s /mnt/ramdisk /var/local/aquarium-ctrl</code>.<br />
<br />
=== Create the website ===<br />
In the folder <code>/var/www/html</code>, create the website using <code>git clone https://in-dubio@bitbucket.org/in-dubio/aquarium-web.git</code>.<br />
<br />
Change the owner of the website to user <code>pi</code> and change the group of the website to <code>www-data</code>.<br />
<br />
Create a symbolic link to the log file running <code>ln -s /var/log/aquarium-ctrl-session.log /var/www/html/aquarium-web/logfile.txt</code>.<br />
<br />
Create the file <code>/var/www/app.ini</code> with the following content (set the correct password):<br />
<code><br />
[database]<br />
server = localhost<br />
port = 3306<br />
user = aquarium<br />
password = YourPassword<br />
database = aquarium<br />
</code></div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=Control_application&diff=139Control application2023-03-26T07:24:53Z<p>Uwe: </p>
<hr />
<div>The main control application of Aquarium control implements the following features:<br />
<br />
* [[Data acquisition of water temperature, pH and conductivity]]<br />
* [[Data acquisition of ambient temperature and humidity]]<br />
* Fresh water refill control<br />
* Feed control<br />
* Water temperature control using air ventilation and heater<br />
* [[Calculation of refill tank content]] based on [[water level measurement]] <br />
* Actuation of pump for water exchange<br />
<br />
Additionally, the main control application implements the following supporting features:<br />
* HW-Tests<br />
* Text-To-Speech interface<br />
* Logging<br />
* Command interface to receive instructions from outside of the application<br />
* Storage of recorded data in SQL database<br />
* File-based communication to web application<br />
* [[Relay Board Control|Monitoring and repair of relay board state]]<br />
<br />
The control application makes extensive use of the [https://abyz.me.uk/rpi/pigpio/ pigpio library].<br />
<br />
The [[architecture]] of the application uses various threads.<br />
<br />
The application is [[automatic start by using systemd]].<br />
<br />
== Installation ==<br />
=== Enable I2C on Raspberry Pi ===<br />
See [https://www.mathworks.com/help/supportpkg/raspberrypiio/ref/enablei2c.html detailed instructions how to use rasp-config].<br />
<br />
=== Create a file for the message queue ===<br />
The file is automatically created when running <code>make install</code>.<br />
<br />
Alternatively, run the command <code>sudo touch /var/local/aquarium-ctrl.mq</code>.<br />
<br />
The file is defined in the source file <code>UsrIntrfc/MsgQu.h</code>.<br />
<br />
=== Create a ramdisk ===<br />
Create the folder <code>/mnt/ramdisk</code>.<br />
<br />
Add the following line to <code>/etc/fstab</code>: <code>tmpfs /mnt/ramdisk tmpfs nodev,nosuid,size=50M 0 0</code>.<br />
<br />
Add a symbolic link using the command <code>ln -s /mnt/ramdisk /var/local/aquarium-ctrl</code>.</div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=Control_application&diff=138Control application2023-03-26T07:24:36Z<p>Uwe: </p>
<hr />
<div>The main control application of Aquarium control implements the following features:<br />
<br />
* [[Data acquisition of water temperature, pH and conductivity]]<br />
* [[Data acquisition of ambient temperature and humidity]]<br />
* Fresh water refill control<br />
* Feed control<br />
* Water temperature control using air ventilation and heater<br />
* [[Calculation of refill tank content]] based on [[water level measurement]] <br />
* Actuation of pump for water exchange<br />
<br />
Additionally, the main control application implements the following supporting features:<br />
* HW-Tests<br />
* Text-To-Speech interface<br />
* Logging<br />
* Command interface to receive instructions from outside of the application<br />
* Storage of recorded data in SQL database<br />
* File-based communication to web application<br />
* [[Relay Board Control|Monitoring and repair of relay board state]]<br />
<br />
The control application makes extensive use of the [https://abyz.me.uk/rpi/pigpio/ pigpio library].<br />
<br />
The [[architecture]] of the application uses various threads.<br />
<br />
The application is [[automatic start by using systemd]].<br />
<br />
== Installation ==<br />
=== Enable I2C on Raspberry Pi ===<br />
See [https://www.mathworks.com/help/supportpkg/raspberrypiio/ref/enablei2c.html detailed instructions how to use rasp-config].<br />
<br />
=== Create a file for the message queue ===<br />
The file is automatically created when running <code>make install</code>.<br />
<br />
Alternatively, run the command <code>sudo touch /var/local/aquarium-ctrl.mq</code>.<br />
<br />
The file is defined in the source file <code>UsrIntrfc/MsgQu.h</code>.<br />
<br />
== Create a ramdisk ==<br />
Create the folder <code>/mnt/ramdisk</code>.<br />
<br />
Add the following line to <code>/etc/fstab</code>: <code>tmpfs /mnt/ramdisk tmpfs nodev,nosuid,size=50M 0 0</code>.<br />
<br />
Add a symbolic link using the command <code>ln -s /mnt/ramdisk /var/local/aquarium-ctrl</code>.</div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=Control_application&diff=137Control application2023-03-26T07:19:36Z<p>Uwe: </p>
<hr />
<div>The main control application of Aquarium control implements the following features:<br />
<br />
* [[Data acquisition of water temperature, pH and conductivity]]<br />
* [[Data acquisition of ambient temperature and humidity]]<br />
* Fresh water refill control<br />
* Feed control<br />
* Water temperature control using air ventilation and heater<br />
* [[Calculation of refill tank content]] based on [[water level measurement]] <br />
* Actuation of pump for water exchange<br />
<br />
Additionally, the main control application implements the following supporting features:<br />
* HW-Tests<br />
* Text-To-Speech interface<br />
* Logging<br />
* Command interface to receive instructions from outside of the application<br />
* Storage of recorded data in SQL database<br />
* File-based communication to web application<br />
* [[Relay Board Control|Monitoring and repair of relay board state]]<br />
<br />
The control application makes extensive use of the [https://abyz.me.uk/rpi/pigpio/ pigpio library].<br />
<br />
The [[architecture]] of the application uses various threads.<br />
<br />
The application is [[automatic start by using systemd]].<br />
<br />
== Installation ==<br />
=== Enable I2C on Raspberry Pi ===<br />
See [https://www.mathworks.com/help/supportpkg/raspberrypiio/ref/enablei2c.html detailed instructions how to use rasp-config].<br />
<br />
=== Create a file for the message queue ===<br />
The file is automatically created when running <code>make install</code>.<br />
Alternatively, run the command <code>sudo touch /var/local/aquarium-ctrl.mq</code>.<br />
The file is defined in the source file <code>UsrIntrfc/MsgQu.h</code>.</div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=Automatic_start_by_using_systemd&diff=136Automatic start by using systemd2023-03-26T07:11:59Z<p>Uwe: </p>
<hr />
<div>The content of systemd unit file /lib/systemd/system/aquarium-ctrl.service as following:<br />
<br />
<code><br />
[Unit]<br />
<br />
Description=Aquarium Control Application<br />
<br />
After=multi-user.target<br />
<br />
<br />
[Service]<br />
<br />
Type=forking<br />
<br />
ExecStart=bash /usr/local/bin/aquarium-ctrl-startup<br />
<br />
[Install]<br />
<br />
WantedBy=multi-user.target<br />
</code><br />
<br />
<br />
Upon creation/modification of the unit file, one must run the command <code>sudo systemctl daemon-reload</code> in order to activate the changes.<br />
<br />
For starting the control application manually via systemd, one can use the command <code>sudo systemctl start aquarium-ctrl</code>.<br />
<br />
When running the application in a configuration that utilises the relay board, the startup script needs to start the <code>screen<code> application prior to the control application in order to set the baud rate of the relay boards:<br />
<br />
<code><br />
screen -dm /dev/ttyUSB0 19200<br />
<br />
screen -dm /dev/ttyUSB1 19200<br />
<br />
/usr/local/bin/aquarium-ctrl -f On -r On -u Off -d On -s On -g On -t Off -b On > /dev/null&<br />
</code></div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=SQL_database&diff=135SQL database2023-03-24T13:29:28Z<p>Uwe: </p>
<hr />
<div>Aquarium Control uses MariaDB.<br />
<br />
== Installation ==<br />
Use the following commands to install MariaDB:<br />
* <code>sudo apt-get update</code><br />
* <code>sudo apt-get upgrade</code><br />
* <code>sudo apt install mariadb-server</code><br />
* <code>sudo apt-get install libmariadb-dev</code><br />
* <code>sudo apt-get install libmariadb-dev-compat</code><br />
* <code>sudo apt-get install libgsl-dev</code><br />
<br />
The commands are also inside the <code>libinstall</code> script inside the repository of aquarium-ctrl.<br />
<br />
== Backup ==<br />
Manual backup works as following:<br />
* Export of database with <code>sudo mysqldump -u root aquarium > name_of_backup.sql</code><br />
* Transfer of data to alternative storage<br />
* Before restoring, create the database <code>aquarium</code> on the new device (log in with <code>sudo mysql -u root</code> and execute <code>create database aquarium;</code>)<br />
* Restoring data from backup works with <code>sudo mysql -u root aquarium < name_of_backup.sql</code><br />
<br />
== Create user ==<br />
Create user "aquarium" with matching password when restoring on a new device:<br />
* log in with <code>sudo mysql -u root</code><br />
* execute <code>create user aquarium identified by 'password';</code><br />
* execute <code>grant all privileges on aquarium.* to aquarium with grant option;</code><br />
<br />
== Maintaining the database ==<br />
Use phpmyadmin to administrate user rights.<br />
Installation is done with the following steps:<br />
* <code>sudo apt install phpmyadmin</code><br />
* Choose the Apache web server for configuration. This will automatically trigger the installation of Apache.<br />
<br />
== Structure of database ==<br />
The database contains the following tables:</div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=SQL_database&diff=134SQL database2023-03-24T13:19:43Z<p>Uwe: </p>
<hr />
<div>Aquarium Control uses MariaDB.<br />
<br />
== Installation ==<br />
Use the following commands to install MariaDB:<br />
* <code>sudo apt-get update</code><br />
* <code>sudo apt-get upgrade</code><br />
* <code>sudo apt install mariadb-server</code><br />
* <code>sudo apt-get install libmariadb-dev</code><br />
* <code>sudo apt-get install libmariadb-dev-compat</code><br />
* <code>sudo apt-get install libgsl-dev</code><br />
<br />
The commands are also inside the <code>libinstall</code> script inside the repository of aquarium-ctrl.<br />
<br />
== Backup ==<br />
Manual backup works as following:<br />
* Export of database with <code>sudo mysqldump -u root aquarium > name_of_backup.sql</code><br />
* Transfer of data to alternative storage<br />
* Before restoring, create the database <code>aquarium</code> on the new device (log in with <code>sudo mysql -u root</code> and execute <code>create database aquarium;</code>)<br />
* Restoring data from backup works with <code>sudo mysql -u root aquarium < name_of_backup.sql</code><br />
* keep in mind to create user "aquarium" with matching password when restoring on a new device<br />
<br />
== Maintaining the database ==<br />
Use phpmyadmin to administrate user rights.<br />
Installation is done with the following steps:<br />
* <code>sudo apt install phpmyadmin</code><br />
Choose the Apache web server for configuration. This will automatically trigger the installation of Apache.<br />
<br />
== Structure of database ==<br />
The database contains the following tables:</div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=SQL_database&diff=133SQL database2023-03-24T13:18:53Z<p>Uwe: </p>
<hr />
<div>Aquarium Control uses MariaDB.<br />
<br />
== Installation ==<br />
Use the following commands to install MariaDB:<br />
* <code>sudo apt-get update</code><br />
* <code>sudo apt-get upgrade</code><br />
* <code>sudo apt install mariadb-server</code><br />
* <code>sudo apt-get install libmariadb-dev</code><br />
* <code>sudo apt-get install libmariadb-dev-compat</code><br />
* <code>sudo apt-get install libgsl-dev</code><br />
<br />
The commands are also inside the <code>libinstall</code> script inside the repository of aquarium-ctrl.<br />
<br />
== Backup ==<br />
Manual backup works as following:<br />
* Export of database with <code>sudo mysqldump -u root aquarium > name_of_backup.sql</code><br />
* Transfer of data to alternative storage<br />
* Before restoring, create the database <code>aquarium</code> on the new device (log in with <code>sudo mysql -u root</code> and execute <code>create database aquarium;</code>)<br />
* Restoring data from backup works with <code>sudo mysql -u root aquarium < name_of_backup.sql</code><br />
* keep in mind to create user "aquarium" with matching password when restoring on a new device<br />
<br />
== Maintaining the database ==<br />
Use phpmyadmin to administrate user rights.<br />
Installation is done with the following steps:<br />
* <code>sudo apt install phpmyadmin</code><br />
<br />
== Structure of database ==<br />
The database contains the following tables:</div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=SQL_database&diff=132SQL database2023-03-24T13:17:11Z<p>Uwe: </p>
<hr />
<div>Aquarium Control uses MariaDB.<br />
<br />
== Installation ==<br />
Use the following commands to install MariaDB:<br />
* <code>sudo apt-get update</code><br />
* <code>sudo apt-get upgrade</code><br />
* <code>sudo apt install mariadb-server</code><br />
* <code>sudo apt-get install libmariadb-dev</code><br />
* <code>sudo apt-get install libmariadb-dev-compat</code><br />
* <code>sudo apt-get install libgsl-dev</code><br />
<br />
The commands are also inside the <code>libinstall</code> script inside the repository of aquarium-ctrl.<br />
<br />
== Backup ==<br />
Manual backup works as following:<br />
* Export of database with <code>sudo mysqldump -u root aquarium > name_of_backup.sql</code><br />
* Transfer of data to alternative storage<br />
* Before restoring, create the database <code>aquarium</code> on the new device (log in with <code>sudo mysql -u root</code> and execute <code>create database aquarium;</code>)<br />
* Restoring data from backup works with <code>sudo mysql -u root aquarium < name_of_backup.sql</code><br />
* keep in mind to create user "aquarium" with matching password when restoring on a new device<br />
<br />
== Maintaining the database ==<br />
Use phpmyadmin to administrate user rights.<br />
Installation is done with the following steps:<br />
* <code>sudo apt-get install php</code><br />
<br />
== Structure of database ==<br />
The database contains the following tables:</div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=SQL_database&diff=131SQL database2023-03-24T13:16:58Z<p>Uwe: </p>
<hr />
<div>Aquarium Control uses MariaDB.<br />
<br />
== Installation ==<br />
Use the following commands to install MariaDB:<br />
* <code>sudo apt-get update</code><br />
* <code>sudo apt-get upgrade</code><br />
* <code>sudo apt install mariadb-server</code><br />
* <code>sudo apt-get install libmariadb-dev</code><br />
* <code>sudo apt-get install libmariadb-dev-compat</code><br />
* <code>sudo apt-get install libgsl-dev</code><br />
<br />
The commands are also inside the <code>libinstall</code> script inside the repository of aquarium-ctrl.<br />
<br />
== Backup ==<br />
Manual backup works as following:<br />
* Export of database with <code>sudo mysqldump -u root aquarium > name_of_backup.sql</code><br />
* Transfer of data to alternative storage<br />
* Before restoring, create the database <code>aquarium</code> on the new device (log in with <code>sudo mysql -u root</code> and execute <code>create database aquarium;</code>)<br />
* Restoring data from backup works with <code>sudo mysql -u root aquarium < name_of_backup.sql</code><br />
* keep in mind to create user "aquarium" with matching password when restoring on a new device<br />
<br />
== Maintaining the database ==<br />
Use phpmyadmin to administrate user rights.<br />
Installation is done with the following steps:<br />
* <code>sudo apt-get install apt</code><br />
<br />
== Structure of database ==<br />
The database contains the following tables:</div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=SQL_database&diff=130SQL database2023-03-24T13:12:19Z<p>Uwe: </p>
<hr />
<div>Aquarium Control uses MariaDB.<br />
<br />
== Installation ==<br />
Use the following commands to install MariaDB:<br />
<br />
<code>sudo apt-get update</code><br />
<br />
<code>sudo apt-get upgrade</code><br />
<br />
<code>sudo apt install mariadb-server</code><br />
<br />
<code>sudo apt-get install libmariadb-dev</code><br />
<br />
<code>sudo apt-get install libmariadb-dev-compat</code><br />
<br />
<code>sudo apt-get install libgsl-dev</code><br />
<br />
The commands are also inside the <code>libinstall</code> script inside the repository of aquarium-ctrl.<br />
<br />
== Backup ==<br />
Manual backup works as following:<br />
* Export of database with <code>sudo mysqldump -u root aquarium > name_of_backup.sql</code><br />
* Transfer of data to alternative storage<br />
* Before restoring, create the database <code>aquarium</code> on the new device (log in with <code>sudo mysql -u root</code> and execute <code>create database aquarium;</code>)<br />
* Restoring data from backup works with <code>sudo mysql -u root aquarium < name_of_backup.sql</code><br />
* keep in mind to create user "aquarium" with matching password when restoring on a new device<br />
<br />
== Heading text ==<br />
The database contains the following tables:</div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=SQL_database&diff=129SQL database2023-03-24T13:11:37Z<p>Uwe: /* Backup */</p>
<hr />
<div>Aquarium Control uses MariaDB.<br />
<br />
== Installation ==<br />
Use the following commands to install MariaDB:<br />
<br />
<code>sudo apt-get update</code><br />
<br />
<code>sudo apt-get upgrade</code><br />
<br />
<code>sudo apt install mariadb-server</code><br />
<br />
<code>sudo apt-get install libmariadb-dev</code><br />
<br />
<code>sudo apt-get install libmariadb-dev-compat</code><br />
<br />
<code>sudo apt-get install libgsl-dev</code><br />
<br />
The commands are also inside the <code>libinstall</code> script inside the repository of aquarium-ctrl.<br />
<br />
== Backup ==<br />
Manual backup works as following:<br />
* Export of database with <code>sudo mysqldump -u root aquarium > name_of_backup.sql</code><br />
* Transfer of data to alternative storage<br />
* Before restoring, create the database <code>aquarium</code> on the new device (log in with <code>sudo mysql -u root</code> and execute <code>create database aquarium;</code>)<br />
* Restoring data from backup works with <code>mysql aquarium < name_of_backup.sql</code><br />
* keep in mind to create user "aquarium" with matching password when restoring on a new device<br />
<br />
== Heading text ==<br />
The database contains the following tables:</div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=SQL_database&diff=128SQL database2023-03-24T13:05:06Z<p>Uwe: </p>
<hr />
<div>Aquarium Control uses MariaDB.<br />
<br />
== Installation ==<br />
Use the following commands to install MariaDB:<br />
<br />
<code>sudo apt-get update</code><br />
<br />
<code>sudo apt-get upgrade</code><br />
<br />
<code>sudo apt install mariadb-server</code><br />
<br />
<code>sudo apt-get install libmariadb-dev</code><br />
<br />
<code>sudo apt-get install libmariadb-dev-compat</code><br />
<br />
<code>sudo apt-get install libgsl-dev</code><br />
<br />
The commands are also inside the <code>libinstall</code> script inside the repository of aquarium-ctrl.<br />
<br />
== Backup ==<br />
Manual backup works as following:<br />
* Export of database with <code>sudo mysqldump -u root aquarium > name_of_backup.sql</code><br />
* Transfer of data to alternative storage<br />
* Restoring data from backup works with <code>mysql aquarium < name_of_backup.sql</code><br />
* keep in mind to create user "aquarium" with matching password when restoring on a new device<br />
<br />
== Heading text ==<br />
The database contains the following tables:</div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=SQL_database&diff=127SQL database2023-03-24T13:04:38Z<p>Uwe: </p>
<hr />
<div>Aquarium Control uses MariaDB.<br />
<br />
== Installation ==<br />
Use the following commands to install MariaDB:<br />
<br />
<code>sudo apt-get update</code><br />
<br />
<code>sudo apt-get upgrade</code><br />
<br />
<code>sudo apt install mariadb-server</code><br />
<br />
<code>sudo apt-get install libmariadb-dev</code><br />
<br />
<code>sudo apt-get install libmariadb-dev-compat</code><br />
<br />
<code>sudo apt-get install libgsl-dev</code><br />
<br />
The commands are also inside the <code>libinstall</code> script inside the repository of aquarium-ctrl.<br />
<br />
== Backup ==<br />
Manual backup works as following:<br />
* Export of database with <code>sudo mysqldump -u root aquarium > name_of_backup.sql<br />
* Transfer of data to alternative storage<br />
* Restoring data from backup works with <code>mysql aquarium < name_of_backup.sql<br />
* keep in mind to create user "aquarium" with matching password when restoring on a new device<br />
<br />
== Heading text ==<br />
The database contains the following tables:</div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=SQL_database&diff=126SQL database2023-03-24T10:35:31Z<p>Uwe: </p>
<hr />
<div>Aquarium Control uses MariaDB.<br />
<br />
== Installation ==<br />
Use the following commands to install MariaDB:<br />
<br />
<code>sudo apt-get update</code><br />
<br />
<code>sudo apt-get upgrade</code><br />
<br />
<code>sudo apt install mariadb-server</code><br />
<br />
<code>sudo apt-get install libmariadb-dev</code><br />
<br />
<code>sudo apt-get install libmariadb-dev-compat</code><br />
<br />
<code>sudo apt-get install libgsl-dev</code><br />
<br />
The commands are also inside the <code>libinstall</code> script inside the repository of aquarium-ctrl.<br />
<br />
== Backup ==<br />
Manual backup works as following:<br />
<br />
== Heading text ==<br />
The database contains the following tables:</div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=SQL_database&diff=125SQL database2023-03-24T10:32:51Z<p>Uwe: /* Installation */</p>
<hr />
<div>Aquarium Control uses MariaDB.<br />
<br />
== Installation ==<br />
Use the following commands to install MariaDB:<br />
<code>sudo apt-get update</code><br />
<code>sudo apt-get upgrade</code><br />
<br />
== Backup ==<br />
Manual backup works as following:<br />
<br />
== Heading text ==<br />
The database contains the following tables:</div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=SQL_database&diff=124SQL database2023-03-24T10:31:21Z<p>Uwe: </p>
<hr />
<div>Aquarium Control uses MariaDB.<br />
<br />
== Installation ==<br />
Use the following commands to install MariaDB:<br />
{{code |lang=bash | sudo apt-get update}}<br />
<br />
<br />
== Backup ==<br />
Manual backup works as following:<br />
<br />
== Heading text ==<br />
The database contains the following tables:</div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=SQL_database&diff=123SQL database2023-03-24T10:27:50Z<p>Uwe: </p>
<hr />
<div>Aquarium Control uses MariaDB.<br />
<br />
== Installation ==<br />
Installation<br />
<br />
== Backup ==<br />
Manual backup works as following:<br />
<br />
== Heading text ==<br />
The database contains the following tables:</div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=SQL_database&diff=122SQL database2023-03-24T10:26:32Z<p>Uwe: Created page with "Aquarium Control uses MariaDB. == Heading text == Installation == Heading text == Backup == Heading text == Structure"</p>
<hr />
<div>Aquarium Control uses MariaDB.<br />
<br />
== Heading text ==<br />
Installation<br />
<br />
== Heading text ==<br />
Backup<br />
<br />
== Heading text ==<br />
Structure</div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=Aquarium-Control&diff=121Aquarium-Control2023-03-24T10:25:27Z<p>Uwe: </p>
<hr />
<div>Aquarium-Control is a control system for salt-water aquariums.<br />
<br />
The main features include:<br />
* [[Refill control for fresh water]]<br />
* [[Data acquisition of water temperature, pH and conductivity|Data acquisition for sensor data of temperature, pH, conductivity]]<br />
* Temperature control using ventilation fans and heater<br />
* Automatic feeder<br />
* Balling mineral dosing<br />
<br />
The components of the control system are assembled in one [[control cabinet]].<br />
<br />
Aquarium-Control consists of the following SW systems:<br />
* [[Control application]]<br />
* [[Dynamic Webpage]]<br />
* [[SQL database]]<br />
* [https://play.google.com/store/apps/details?id=com.laimburggasse.aquariumcontroller Android application]<br />
<br />
The control application, the webpage and the SQL database are designed to run on a [https://www.raspberrypi.org Raspberry Pi].</div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=Calculation_of_refill_tank_content&diff=120Calculation of refill tank content2023-02-20T13:51:28Z<p>Uwe: </p>
<hr />
<div>Based on the geometrical parameters of the tank and the distance from the lid of the tank to the water surface, the control system calculates the content of the refill tank.<br />
<br />
The calculation assumes that the refill tank has the geometry of a cuboid.<br />
<br />
The calculation is done in the [[SW component RefillTnkLvl]].<br />
<br />
[[File:RefillTankLevelChart.png|1200px]]<br />
<br />
The control application applies two filters:<br />
* a low-pass filter (blue signal)<br />
* a filter checking if the new value is within a permissible range compared to the low-pass filtered signal</div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=Calculation_of_refill_tank_content&diff=119Calculation of refill tank content2023-02-20T13:51:14Z<p>Uwe: </p>
<hr />
<div>Based on the geometrical parameters of the tank and the distance from the lid of the tank to the water surface, the control system calculates the content of the refill tank.<br />
<br />
The calculation assumes that the refill tank has the geometry of a cuboid.<br />
<br />
The calculation is done in the [[SW component RefillTnkLvl]].<br />
<br />
[[File:RefillTankLevelChart.png|1000px]]<br />
<br />
The control application applies two filters:<br />
* a low-pass filter (blue signal)<br />
* a filter checking if the new value is within a permissible range compared to the low-pass filtered signal</div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=Calculation_of_refill_tank_content&diff=118Calculation of refill tank content2023-02-20T13:51:03Z<p>Uwe: </p>
<hr />
<div>Based on the geometrical parameters of the tank and the distance from the lid of the tank to the water surface, the control system calculates the content of the refill tank.<br />
<br />
The calculation assumes that the refill tank has the geometry of a cuboid.<br />
<br />
The calculation is done in the [[SW component RefillTnkLvl]].<br />
<br />
[[File:RefillTankLevelChart.png|600px]]<br />
<br />
The control application applies two filters:<br />
* a low-pass filter (blue signal)<br />
* a filter checking if the new value is within a permissible range compared to the low-pass filtered signal</div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=Calculation_of_refill_tank_content&diff=117Calculation of refill tank content2023-02-20T13:50:53Z<p>Uwe: </p>
<hr />
<div>Based on the geometrical parameters of the tank and the distance from the lid of the tank to the water surface, the control system calculates the content of the refill tank.<br />
<br />
The calculation assumes that the refill tank has the geometry of a cuboid.<br />
<br />
The calculation is done in the [[SW component RefillTnkLvl]].<br />
<br />
[[File:RefillTankLevelChart.png|200px]]<br />
<br />
The control application applies two filters:<br />
* a low-pass filter (blue signal)<br />
* a filter checking if the new value is within a permissible range compared to the low-pass filtered signal</div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=Calculation_of_refill_tank_content&diff=116Calculation of refill tank content2023-02-20T13:45:10Z<p>Uwe: </p>
<hr />
<div>Based on the geometrical parameters of the tank and the distance from the lid of the tank to the water surface, the control system calculates the content of the refill tank.<br />
<br />
The calculation assumes that the refill tank has the geometry of a cuboid.<br />
<br />
The calculation is done in the [[SW component RefillTnkLvl]].<br />
<br />
[[File:RefillTankLevelChart.png|thumb]]<br />
<br />
The control application applies two filters:<br />
* a low-pass filter (blue signal)<br />
* a filter checking if the new value is within a permissible range compared to the low-pass filtered signal</div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=File:RefillTankLevelChart.png&diff=115File:RefillTankLevelChart.png2023-02-20T13:44:47Z<p>Uwe: </p>
<hr />
<div>Chart generated by the website showing the raw signal and the filtered signal of the refill tank level water volume</div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=Water_level_measurement&diff=114Water level measurement2023-02-19T09:52:54Z<p>Uwe: </p>
<hr />
<div>==== Motivation ====<br />
The measured water level is input for the calculation of the refill tank content.<br />
In order not to contaminate the water, a contact-less measurement is preferred.<br />
<br />
==== Implementation ====<br />
The control system uses a device which generates an ultrasonic sound and measures when the sound wave has travelled back from the water surface.<br />
The SW system will record the time used for this travel and calculate the corresponding distance using the speed of sound.<br />
[[File:Ultra Sonic Distance Sensor Installed On Top Of Refill Tank.png|thumb|Ultra Sonic Distance Sensor Installed On Top Of Refill Tank]]<br />
<br />
==== Hardware ====<br />
The ultrasonic distance measurement device is sold with the commercial name [https://www.sparkfun.com/products/15569 HC-SR04].<br />
The device has 4 pins:<br />
* VCC: Supply voltage 5V<br />
* GND<br />
* TRIG: external trigger for sound wave<br />
* ECHO: measurement of return of sound wave<br />
<br />
The device is connected to an Arduino Uno.<br />
<br />
The control logic is as following:<br />
* The control system sets the TRIG channel to high.<br />
* HC-SR04 sends an ultrasonic wave to the surface of the water tank and set the ECHO channel to high at the same time.<br />
* The surface reflects the wave back towards the microphone of the HC-SR04.<br />
* The HC-SRC04 sets the ECHO channel to low upon receiving the reflected wave.<br />
<br />
==== Software ====<br />
The Arduino Uno measures the travel time of the Ultra Sonic Wave.<br />
Arduino Uno and Raspberry Pi are connected via USB.<br />
The control SW running on the Raspberry Pi<br />
* reads the travel time of the wave in the [[SW Component ArdnIntrfc]].<br />
* calculates the travel distance and a low-pass filtered version of this signal in the [[SW Component UltrSncDstncMsr]].<br />
* calculates the corresponding water level of the refill tank in the [[SW Component RefillTnkLvl]].</div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=Calculation_of_refill_tank_content&diff=113Calculation of refill tank content2023-02-19T09:42:26Z<p>Uwe: </p>
<hr />
<div>Based on the geometrical parameters of the tank and the distance from the lid of the tank to the water surface, the control system calculates the content of the refill tank.<br />
<br />
The calculation assumes that the refill tank has the geometry of a cuboid.<br />
<br />
The calculation is done in the [[SW component RefillTnkLvl]].<br />
<br />
The control application applies two filters:<br />
- a low-pass filter (blue signal)<br />
- a filter checking if the new value is within a permissible range compared to the low-pass filtered signal</div>Uwehttp://laimburggasse.onthewifi.com/mediawiki/index.php?title=Relay_Board_Control&diff=112Relay Board Control2023-01-05T16:03:59Z<p>Uwe: /* Monitoring and repair of relay board states */</p>
<hr />
<div>The following components utilise the relay board:<br />
* Refill Control: refilling of fresh water depending on water level<br />
* Feeder Control: stopping flow pumps, skimmer and actuating the feeder<br />
* Water Exchange Control: actuating the external pump for water exchange<br />
* Balling Control: actuating the pumps for mineral dosing<br />
<br />
<br />
There are two requirements, which ask for a more sophisticated control of the relay board:<br />
* The dosing of minerals needs to be as precise as possible.<br />
* The communication with the board needs to be reinitialised and even reopened after certain periods of time.<br />
<br />
<br />
The relay board control implements the following features:<br />
* Low level communication via serial port to the board<br />
* Watchdog for reading/writing to serial port<br />
* HW functionality test before executing commands<br />
* Monitoring and repair of relay board states<br />
* Avoiding conflicting access to relay board<br />
<br />
== Low level communication via serial port ==<br />
This functionality is implemented in <code>RlyBrdCtrl/RlyBrdCmd.c</code>.<br />
The communication follows the protocol laid out in the [https://asset.conrad.com/media10/add/160267/c1/-/gl/000197720ML02/bedienungsanleitung-197720-conrad-components-197720-relaiskarte-baustein-12-vdc-24-vdc.pdf user manual of the 197730/197730 relay boards].<br />
<br />
Every command consists of a sequence of 4 byte.<br />
{| class="wikitable"<br />
|+ command sequence for 197730/197720 relay boards<br />
|-<br />
! Byte # !! Content<br />
|-<br />
| 0 || command<br />
|-<br />
| 1 || board address<br />
|-<br />
| 2 || data<br />
|-<br />
| 3 || checksum<br />
|}<br />
<br />
The command can assume one of 8 values, whereby the controller only uses a subset of these:<br />
{| class="wikitable"<br />
|+ commands used for control of 197730/197720 relay boards<br />
|-<br />
! command # !! Meaning !! byte 0 value in board response<br />
|-<br />
| 1 || initialisation || 254<br />
|-<br />
| 2 || get relay states || 253<br />
|-<br />
| 6 || switch on relay || 249<br />
|-<br />
| 7 || switch off relay || 248<br />
|}<br />
<br />
The relay boards offer functionality to connect multiple boards in a bus system.<br />
Therefore, the commands have to specify an address to identify the board for which the command is issued.<br />
The aquarium controller does not use this functionality. Low voltage board and high voltage board are connected via separate USB connections.<br />
Hence, address is always set to one.<br />
<br />
The checksum is computed as XOR of byte 0, 1 and 2.<br />
<br />
The low level communication is done using one of two functions inside <code>RlyBrdCmd.c</code>.<br />
* <code>RlyBrdInitCom</code> for initialisation of the communication<br />
* <code>RlyBrdCmd</code> for sending commands to the boards<br />
<br />
Both commands use the semaphore <code>mutexRlyBrd</code> to guarantee exclusive access to the devices.<br />
Both commands check the length of the response from the board and issue an error if the length is not as expected.<br />
<br />
During the initialisation, the board responds an 8 byte sequence which seems to correspond to the SW version. Information regarding this sequence could not be found inside the user manual.<br />
{| class="wikitable"<br />
|+ initialisation response for 197730/197720 relay boards<br />
|-<br />
! Byte #!! 0 !! 1 !! 2 !! 3 !! 4 !! 5 !! 6 !! 7<br />
|-<br />
| Value || 0xfe || 0x01 || 0x0b || 0xf4 || 0x01 || 0x02 || 0x0b || 0x08<br />
|}<br />
The command <code>RlyBrdInitCom</code> checks if the relay board responds with this sequence.<br />
<br />
The command <code>RlyBrdCmd</code> checks the checksum of the board's response.<br />
Additionally, the function checks the response of the relay board.<br />
The response of the relay board sporadically deviates from the response defined in the user manual.<br />
Specified is a response which can be computed as <code>255 - command #</code>.<br />
After some time of operation the board changes to responding with <code> command #</code>.<br />
After some more time of operation, the board may change back to the specified response.<br />
The control adapts to this toggling response behaviour.<br />
Expected response is computed accordingly. Each byte of the board's response is checked.<br />
<br />
== Watchdog for reading/writing to serial port ==<br />
This functionality is implemented in <code>RlyBrdCtrl/RlyBrdWtchDg.c</code>.<br />
<br />
For communication with the relay boards, the application uses read and write instructions which may block the control flow at these points if the operation does not terminate.<br />
<br />
In order to detect such events, a separate thread <code>RlyBrdRdWrWtchDgThread</code> monitors the duration of the read/write operations.<br />
The flag monitors how long certain flags are <code>true</code>:<br />
* <code>RBC_Get_flgRlyBrdRdStarting</code> provides the flag for monitoring read operations.<br />
* <code>RBC_Get_flgRlyBrdWrStarting</code> provides the flag for monitoring write operations.<br />
<br />
The flags are set to <code>true</code> directly before the read/write operation and they are set to <code>false</code> directly after the operation.<br />
<br />
The watch dog thread increases a counter for each second the read/write operation takes. When the counter exceeds the threshold </code>RLYBRD_RD_WR_WTCHDG_MAX_T</code>, the thread issues a log file entry, forces flushing of file buffers via <code>sync();</code> and initiates a reboot of the device using <code>reboot(RB_AUTOBOOT);</code>.<br />
<br />
== HW functionality test ==<br />
This functionality is implemented in <code>RlyBrdCtrl/RlyBrdFdbck.c</code>.<br />
<br />
The control system connects a voltage input through one relay of each board to a GPIO pin of the Raspberry Pi.<br />
<br />
By measuring the GPIO pin state, the control system can determine if the opening/closing of the relay really happened instead of just relying on the feedback of each board.<br />
<br />
The feedback test evaluates three steps:<br />
# Starting with an open relay, check if GPIO state is <code>FALSE</code><br />
# Closing the relay, check if GPIO state is <code>TRUE</code><br />
# Opening the relay, check if GPIO state is <code>FALSE</code><br />
<br />
The feedback test executed before relay switching sequences (e.g. feeding pattern, Balling dosing, ...) and in regular time intervals (every 30min).<br />
<br />
== Monitoring and repair of relay board states ==<br />
This functionality is implemented in <code>RlyBrdCtrl/RlyBrdMidLay.c</code>.<br />
This middle layer component was introduced to record the commanded states and acquire the state information responded by the relay boards.<br />
Except for initialisation and shutdown, the low level communication with the board passes through this component.<br />
The function <code>RlyBrdChckStates</code> inside this component compares the commanded and the responded state.<br />
In case of differences, the function <code>RlyBrdRepairStates</code> issues commands to the related relay board in order to reestablish the previously commanded state.<br />
Both functions are called every minute from <code>RlyBrdChckStateThread</code>.<br />
<br />
== Avoiding conflicting access to relay board ==<br />
This functionality is implemented in <code>RlyBrdCtrl/RlyBrdHiLay.c</code>.<br />
<br />
Mutual exclusion is implemented using the semaphore <code>mutRlyBrdSchdlr</code>.<br />
<br />
The semaphore is used only by the function <code>RlyBrdSchdlr</code>.<br />
This function is the central gateway for all other components to initiate usage of the relay board.<br />
It shall give control of the relay board to a calling component so that the calling component can execute a sequence of commands which shall not be interrupted. <br />
<br />
The function uses two callbacks which are provided via argument and a label informing which component is using the relay board:<br />
<br />
<code>RlyBrdSchdlr (int TestFunc(void), void ExecFunc(void), char *lbl)</code><br />
<br />
The first callback function (<code>TestFunc</code>) allows the calling component to determine specifically which tests needs to be carried out before the relay board can be used.<br />
For example, the Balling dosing only needs to actuate the low voltage relay board while the feeder control only actuates the high voltage relay board.<br />
<br />
In case the test function fails, there are two recovery strategies:<br />
# The communication with the relay board is reinitialised sending the related command. The test function is called again.<br />
# If the test function fails again, the serial device is reopened. The test function is called again.<br />
<br />
The second callback function (<code>ExecFunc</code>) gives control to the calling component for execution of the sequence.<br />
Execution is only triggered if one call of the test function returned with a successful result.</div>Uwe