Debian package - Revision history

Uwe: /* Database creation */

2026-01-02T07:42:36Z

Database creation

← Older revision		Revision as of 09:42, 2 January 2026
Line 86:		Line 86:
	* password		* password

	The script ~~will~~:		The script:
	* ~~create~~ the database using the desired database name		* creates the database using the desired database name
	* ~~import~~ the SQL dump to the database		* imports the SQL dump to the database
	* ~~create~~ the SQL user with the corresponding user name and password		* creates the SQL user with the corresponding user name and password
	* ~~grant~~ all privileges on the database to the user		* grants all privileges on the database to the user
	* ~~update~~ the main control configuration file with the database name, user name and password		* updates the main control configuration file with the database name, user name and password
			* updates the db.php with the database name, user name and password

	== Database update ==		== Database update ==

Uwe: /* Automatic start */

2026-01-01T15:10:04Z

Automatic start

← Older revision		Revision as of 17:10, 1 January 2026
Line 126:		Line 126:

	== Automatic start ==		== Automatic start ==
	The package configures the operating system to automatically start the application after booting up as described [Automatic_start_by_using_systemd \| here].		The package configures the operating system to automatically start the application after booting up as described [[Automatic_start_by_using_systemd \| here]].

	== Instructions to the user ==		== Instructions to the user ==

Uwe at 15:09, 1 January 2026

2026-01-01T15:09:22Z

← Older revision		Revision as of 17:09, 1 January 2026
Line 124:		Line 124:
	* <code>moment.min.js</code> from <code>https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.29.1/moment.min.js</code>		* <code>moment.min.js</code> from <code>https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.29.1/moment.min.js</code>
	* <code>vue.global.prod.js</code> from <code>https://unpkg.com/vue@3/dist/vue.global.prod.js</code>		* <code>vue.global.prod.js</code> from <code>https://unpkg.com/vue@3/dist/vue.global.prod.js</code>

			== Automatic start ==
			The package configures the operating system to automatically start the application after booting up as described [Automatic_start_by_using_systemd \| here].

	== Instructions to the user ==		== Instructions to the user ==

Uwe: /* Instructions to the user */

2026-01-01T15:05:35Z

Instructions to the user

← Older revision		Revision as of 17:05, 1 January 2026
Line 126:		Line 126:

	== Instructions to the user ==		== Instructions to the user ==
			After executing above activities, the package installation informs the user that the corresponding database content needs to be created in case the database has been created during the installation of the package.

			The installation refers to the <code>aquariumcontrol_database_setup.sh</code>.

Uwe at 15:03, 1 January 2026

2026-01-01T15:03:02Z

← Older revision		Revision as of 17:03, 1 January 2026
Line 118:		Line 118:
	Hash: 7066cbf85e2fa71b47d984b7da09d791a3003675a9a8f16ea16ee63d3487b14e		Hash: 7066cbf85e2fa71b47d984b7da09d791a3003675a9a8f16ea16ee63d3487b14e
	</pre>		</pre>

	~~== Message queue creation ==~~

	== Setup of webpage ==		== Setup of webpage ==
Line 126:		Line 124:
	* <code>moment.min.js</code> from <code>https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.29.1/moment.min.js</code>		* <code>moment.min.js</code> from <code>https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.29.1/moment.min.js</code>
	* <code>vue.global.prod.js</code> from <code>https://unpkg.com/vue@3/dist/vue.global.prod.js</code>		* <code>vue.global.prod.js</code> from <code>https://unpkg.com/vue@3/dist/vue.global.prod.js</code>

	~~== Setup of main application configuration file ==~~

	~~== Setup of main application ==~~

	~~== Setup of terminal client ==~~

	== Instructions to the user ==		== Instructions to the user ==

Uwe: /* Database update */

2026-01-01T14:59:22Z

Database update

← Older revision		Revision as of 16:59, 1 January 2026
Line 109:		Line 109:
	This table needs to be updated with the hash of the executable.		This table needs to be updated with the hash of the executable.
	When executing the main control with the parameter <code>--version</code>, the program will inform the version and the hash:		When executing the main control with the parameter <code>--version</code>, the program will inform the version and the hash:
	<~~code~~>		<pre>
	pi@raspberrypi:/var/www/html $ aquarium_control --version		pi@raspberrypi:/var/www/html $ aquarium_control --version
	[2026-01-01 15:58:04.558 +01:00 INFO aquarium_control::utilities::version_information] path of this executable is: /usr/local/bin/aquarium_control		[2026-01-01 15:58:04.558 +01:00 INFO aquarium_control::utilities::version_information] path of this executable is: /usr/local/bin/aquarium_control
Line 117:		Line 117:
	Build: 1		Build: 1
	Hash: 7066cbf85e2fa71b47d984b7da09d791a3003675a9a8f16ea16ee63d3487b14e		Hash: 7066cbf85e2fa71b47d984b7da09d791a3003675a9a8f16ea16ee63d3487b14e
	</~~code~~>		</pre>

	== Message queue creation ==		== Message queue creation ==

Uwe: /* Database update */

2026-01-01T14:59:05Z

Database update

← Older revision		Revision as of 16:59, 1 January 2026
Line 95:		Line 95:
	== Database update ==		== Database update ==
	The database contains a table <code>version</code> which includes the release number and a corresponding hash of the executable.		The database contains a table <code>version</code> which includes the release number and a corresponding hash of the executable.
	<~~code~~>		<pre>
	MariaDB [aquarium]> desc version;		MariaDB [aquarium]> desc version;
	+-------+--------------+------+-----+---------+-------+		+-------+--------------+------+-----+---------+-------+
Line 106:		Line 106:
	+-------+--------------+------+-----+---------+-------+		+-------+--------------+------+-----+---------+-------+
	4 rows in set (0.032 sec)		4 rows in set (0.032 sec)
	</~~code~~>		</pre>
	This table needs to be updated with the hash of the executable.		This table needs to be updated with the hash of the executable.
	When executing the main control with the parameter <code>--version</code>, the program will inform the version and the hash:		When executing the main control with the parameter <code>--version</code>, the program will inform the version and the hash:

Uwe: /* Database update */

2026-01-01T14:58:50Z

Database update

← Older revision		Revision as of 16:58, 1 January 2026
Line 94:		Line 94:

	== Database update ==		== Database update ==
			The database contains a table <code>version</code> which includes the release number and a corresponding hash of the executable.
			<code>
			MariaDB [aquarium]> desc version;
			+-------+--------------+------+-----+---------+-------+
			\| Field \| Type \| Null \| Key \| Default \| Extra \|
			+-------+--------------+------+-----+---------+-------+
			\| major \| int(11) \| YES \| \| NULL \| \|
			\| minor \| int(11) \| YES \| \| NULL \| \|
			\| build \| int(11) \| YES \| \| NULL \| \|
			\| hash \| varchar(255) \| YES \| \| NULL \| \|
			+-------+--------------+------+-----+---------+-------+
			4 rows in set (0.032 sec)
			</code>
			This table needs to be updated with the hash of the executable.
			When executing the main control with the parameter <code>--version</code>, the program will inform the version and the hash:
			<code>
			pi@raspberrypi:/var/www/html $ aquarium_control --version
			[2026-01-01 15:58:04.558 +01:00 INFO aquarium_control::utilities::version_information] path of this executable is: /usr/local/bin/aquarium_control
			Version information:
			Major: 0
			Minor: 16
			Build: 1
			Hash: 7066cbf85e2fa71b47d984b7da09d791a3003675a9a8f16ea16ee63d3487b14e
			</code>

	== Message queue creation ==		== Message queue creation ==

Uwe: /* Content */

2026-01-01T14:55:27Z

Content

← Older revision		Revision as of 16:55, 1 January 2026
Line 69:		Line 69:
	\|-		\|-
	\|}		\|}

			Except for the database dump, the files are copied to their target directories.

			The database dump file is extracted to a temporary location and deleted after use.

	== Creation of directories and files ==		== Creation of directories and files ==

Uwe: /* Setup of webpage */

2026-01-01T14:53:29Z

Setup of webpage

← Older revision		Revision as of 16:53, 1 January 2026
Line 95:		Line 95:
	== Setup of webpage ==		== Setup of webpage ==
	Additionally, to copying the corresponding php, html and png files from the package to the target directory, the script downloads a set of libraries to <code>/var/www/html/js/</code>:		Additionally, to copying the corresponding php, html and png files from the package to the target directory, the script downloads a set of libraries to <code>/var/www/html/js/</code>:
	* <code>Chart.min.js</code>		* <code>Chart.min.js</code> from <code>https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.9.4/Chart.min.js</code>
	* <code>moment.min.js</code>		* <code>moment.min.js</code> from <code>https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.29.1/moment.min.js</code>
	* <code>vue.global.prod.js</code>		* <code>vue.global.prod.js</code> from <code>https://unpkg.com/vue@3/dist/vue.global.prod.js</code>

	== Setup of main application configuration file ==		== Setup of main application configuration file ==