Control application - Revision history

Uwe at 17:59, 8 April 2023

2023-04-08T17:59:11Z

← Older revision		Revision as of 19:59, 8 April 2023
Line 91:		Line 91:

	=== Setup of database ===		=== Setup of database ===
	* Download or [[git clone https://in-dubio@bitbucket.org/in-dubio/aquarium-database.git~~\|clone an SQL database dump]].~~		* Download or clone an SQL database dump: <code>git clone https://in-dubio@bitbucket.org/in-dubio/aquarium-database.git</code>
	* [https://www.digitalocean.com/community/tutorials/how-to-import-and-export-databases-in-mysql-or-mariadb Import a database.]		* [https://www.digitalocean.com/community/tutorials/how-to-import-and-export-databases-in-mysql-or-mariadb Import a database.]
	* Create the user <code>aquarium</code> and assign access rights to the <code>aquarium</code> database.		* Create the user <code>aquarium</code> and assign access rights to the <code>aquarium</code> database.
	* Check the user rights using [https://www.phpmyadmin.net phpmyadmin]		* Check the user rights using [https://www.phpmyadmin.net phpmyadmin]

2023-04-08T17:58:19Z

Installation

← Older revision		Revision as of 19:58, 8 April 2023
Line 91:		Line 91:

	=== Setup of database ===		=== Setup of database ===
			* Download or [[git clone https://in-dubio@bitbucket.org/in-dubio/aquarium-database.git\|clone an SQL database dump]].
	* [https://www.digitalocean.com/community/tutorials/how-to-import-and-export-databases-in-mysql-or-mariadb Import a database.]		* [https://www.digitalocean.com/community/tutorials/how-to-import-and-export-databases-in-mysql-or-mariadb Import a database.]
	* Create the user <code>aquarium</code> and assign access rights to the <code>aquarium</code> database.		* Create the user <code>aquarium</code> and assign access rights to the <code>aquarium</code> database.
	* Check the user rights using [https://www.phpmyadmin.net phpmyadmin]		* Check the user rights using [https://www.phpmyadmin.net phpmyadmin]

2023-04-08T17:42:10Z

Setup of database

← Older revision		Revision as of 19:42, 8 April 2023
Line 91:		Line 91:

	=== Setup of database ===		=== Setup of database ===
	* Import a database.		* [https://www.digitalocean.com/community/tutorials/how-to-import-and-export-databases-in-mysql-or-mariadb Import a database.]
	* Create the user <code>aquarium</code> and assign access rights to the <code>aquarium</code> database.		* Create the user <code>aquarium</code> and assign access rights to the <code>aquarium</code> database.
	* Check the user rights using [https://www.phpmyadmin.net phpmyadmin]		* Check the user rights using [https://www.phpmyadmin.net phpmyadmin]

2023-04-08T17:37:37Z

Setup of database

← Older revision		Revision as of 19:37, 8 April 2023
Line 91:		Line 91:

	=== Setup of database ===		=== Setup of database ===
	* Import ~~an empty~~ database.		* Import a database.
	* Create the user <code>aquarium</code> and assign access rights to the <code>aquarium</code> database.		* Create the user <code>aquarium</code> and assign access rights to the <code>aquarium</code> database.
			* Check the user rights using [https://www.phpmyadmin.net phpmyadmin]

2023-04-08T17:32:11Z

Installation

← Older revision		Revision as of 19:32, 8 April 2023
Line 28:		Line 28:

	for the installation of the operating system on the Raspberry Pi, please follow the instructions of the [https://www.raspberrypi.com Raspberry Pi foundation].		for the installation of the operating system on the Raspberry Pi, please follow the instructions of the [https://www.raspberrypi.com Raspberry Pi foundation].
			Use the 64-bit version.

	=== Clone the repository, build and install the control SW ===		=== Clone the repository, build and install the control SW ===

2023-04-08T17:31:31Z

Clone the repository, build and install the control SW

← Older revision		Revision as of 19:31, 8 April 2023
Line 34:		Line 34:
	<code>sudo mkdir /usr/local/src/aquarium-ctrl</code>		<code>sudo mkdir /usr/local/src/aquarium-ctrl</code>

	<code>sudo chown pi /usrlocal/src/aquarium-ctrl/code>		<code>sudo chown pi /usrlocal/src/aquarium-ctrl</code>

	<code>cd /usr/local/src/aquarium-ctrl</code>		<code>cd /usr/local/src/aquarium-ctrl</code>

	Next, clone the repository:		Next, clone the repository:

	<code>git clone https://in-dubio@bitbucket.org/in-dubio/aquarium-ctrl.git</code>		<code>git clone https://in-dubio@bitbucket.org/in-dubio/aquarium-ctrl.git</code>

	Install the required libraries:		Install the required libraries:

	<code>bash libinstall.sh</code>		<code>bash libinstall.sh</code>

2023-04-08T17:31:05Z

Clone the repository, build and install the control SW

← Older revision		Revision as of 19:31, 8 April 2023
Line 39:		Line 39:

	Next, clone the repository:		Next, clone the repository:

	<code>git clone https://in-dubio@bitbucket.org/in-dubio/aquarium-ctrl.git</code>		<code>git clone https://in-dubio@bitbucket.org/in-dubio/aquarium-ctrl.git</code>

	Install the required libraries:		Install the required libraries:

	<code>bash libinstall.sh</code>		<code>bash libinstall.sh</code>

2023-04-08T17:30:40Z

@@ Line 26: / Line 26: @@
 == Installation ==
 === Enable I2C on Raspberry Pi ===
 See [https://www.mathworks.com/help/supportpkg/raspberrypiio/ref/enablei2c.html detailed instructions how to use rasp-config].

2023-04-02T10:33:07Z

← Older revision		Revision as of 12:33, 2 April 2023
Line 17:		Line 17:
	* File-based communication to web application		* File-based communication to web application
	* [[Relay Board Control\|Monitoring and repair of relay board state]]		* [[Relay Board Control\|Monitoring and repair of relay board state]]
			* [[Device Scheduling]]

	The control application makes extensive use of the [https://abyz.me.uk/rpi/pigpio/ pigpio library].		The control application makes extensive use of the [https://abyz.me.uk/rpi/pigpio/ pigpio library].

2023-03-28T07:40:36Z

← Older revision		Revision as of 09:40, 28 March 2023
Line 54:		Line 54:
	Create the file <code>/var/www/app.ini</code> with the following content (set the correct password):		Create the file <code>/var/www/app.ini</code> with the following content (set the correct password):
	<code>		<code>

	[database]		[database]

	server = localhost		server = localhost

	port = 3306		port = 3306

	user = aquarium		user = aquarium

	password = YourPassword		password = YourPassword

	database = aquarium		database = aquarium
	</code>		</code>

			[[Download and install the node JavaScript libraries.]]

	=== Setup of database ===		=== Setup of database ===
	* Import an empty database.		* Import an empty database.
	* Create the user <code>aquarium</code> and assign access rights to the <code>aquarium</code> database.		* Create the user <code>aquarium</code> and assign access rights to the <code>aquarium</code> database.