Your Own Server - Revision history

Freddie: /* Install MariaDB database */

2022-07-25T21:10:24Z

Install MariaDB database

← Older revision		Revision as of 21:10, 25 July 2022
Line 188:		Line 188:


	=== Install ~~Maria~~ database ===		=== Install MariaDB database ===

	MySQL database software is controlled by Oracle and not made available for inclusion in Raspberry Pi repository.		MySQL database software is controlled by Oracle and not made available for inclusion in Raspberry Pi repository.

Freddie: /* Restarting Web Server */

2022-07-25T21:07:52Z

Restarting Web Server

← Older revision		Revision as of 21:07, 25 July 2022
Line 329:		Line 329:
	=== Restarting Web Server ===		=== Restarting Web Server ===

	After all these installs, we need to restart your web server (so it loads the PHP and MariaDB), if you have installed apache 2 do this by typing <code>sudo ~~service apache2~~ restart</code> or (if we just want the Apache configuration reloaded) by typing <code>sudo systemctl reload apache2</code>. Similar commands apply for other web servers.		After all these installs, we need to restart your web server (so it loads the PHP and MariaDB), if you have installed apache 2 do this by typing <code>sudo systemctl restart apache2</code> or (if we just want the Apache configuration reloaded) by typing <code>sudo systemctl reload apache2</code>. Similar commands apply for other web servers.

	We will need to restart Apache (or whichever web server we installed) any time we change our php.ini files, database passwords, and anything else that is checked when the web server starts.		We will need to restart Apache (or whichever web server we installed) any time we change our php.ini files, database passwords, and anything else that is checked when the web server starts.

Freddie: /* Getting web and database servers ready for use */

2022-07-25T21:04:02Z

Getting web and database servers ready for use

← Older revision		Revision as of 21:04, 25 July 2022
Line 214:		Line 214:
	===Getting web and database servers ready for use===		===Getting web and database servers ready for use===

	We need to create a user for PhpMyAdmin (or adMiner or whatever) to access our database and another for Cumulus to use to access the database tables. At the moment our database access has the single '''root@localhost''' user we created when we installed MariaDB. The initial password was set then, and we need to use it to get access to ~~MariDB~~ monitor where we can insert some SQL commands to create these two users.		We need to create a user for PhpMyAdmin (or adMiner or whatever) to access our database and another for Cumulus to use to access the database tables. At the moment our database access has the single '''root@localhost''' user we created when we installed MariaDB. The initial password was set then, and we need to use it to get access to MariaDB monitor where we can insert some SQL commands to create these two users.

	Most tools, like PhpMyAdmin, on first start up will ask for username (here I choose "admin") and password, thereafter the tool should use same log-in (by default you see log-in screen each time you restart or if it is left idle for a long time), let us create a user called 'admin' for it.		Most tools, like PhpMyAdmin, on first start up will ask for username (here I choose "admin") and password, thereafter the tool should use same log-in (by default you see log-in screen each time you restart or if it is left idle for a long time), let us create a user called 'admin' for it.
Line 234:		Line 234:

	As I type this, Cumulus MX has no exception handling if the username and password defined in the settings do not exist in the database, therefore in this situation it will crash out (with message press Enter to close).		As I type this, Cumulus MX has no exception handling if the username and password defined in the settings do not exist in the database, therefore in this situation it will crash out (with message press Enter to close).


	=== Installing Adminer, or PhpMyAdmin ===		=== Installing Adminer, or PhpMyAdmin ===

Freddie: /* Install MariaDB database */

2022-07-25T21:01:42Z

Install MariaDB database

← Older revision		Revision as of 21:01, 25 July 2022
Line 192:		Line 192:
	MySQL database software is controlled by Oracle and not made available for inclusion in Raspberry Pi repository.		MySQL database software is controlled by Oracle and not made available for inclusion in Raspberry Pi repository.

	~~MariaSQL~~ is an alternative that has largely similar command syntax so is likely to work with code (like MX) designed to work with MySQL. Since the MX developer (Mark Crossley) actually uses ~~Maria DB~~, we can have plenty of confidence it is suitable.		MariaDB is an alternative that has largely similar command syntax so is likely to work with code (like MX) designed to work with MySQL. Since the MX developer (Mark Crossley) actually uses MariaDB, we can have plenty of confidence it is suitable.

	To install this database server, we type <code>sudo apt install mariadb-server php-mysql -y</code>.		To install this database server, we type <code>sudo apt install mariadb-server php-mysql -y</code>.

Freddie: /* Install a web server */

2022-07-25T20:56:15Z

Install a web server

← Older revision		Revision as of 20:56, 25 July 2022
Line 83:		Line 83:
	I will first mention 3 possible web servers than can run on a Microsoft Windows personal computer (or server box):		I will first mention 3 possible web servers than can run on a Microsoft Windows personal computer (or server box):
	#You might choose '''Apache 2''' as it is probably the most comprehensive, so if you have enough space on your PC, install it following instructions at the official site [https://httpd.apache.org/download.cgi] (or one of many other web sites that give instructions for installing apache2 on Microsoft Windows).		#You might choose '''Apache 2''' as it is probably the most comprehensive, so if you have enough space on your PC, install it following instructions at the official site [https://httpd.apache.org/download.cgi] (or one of many other web sites that give instructions for installing apache2 on Microsoft Windows).
	#You might choose ‘’’Uniform Server’’’, which is extremely simple as it comes as a package including PHP script, and ~~MariaSQL~~ database in one package from [http://www.uniformserver.com/], although you may need to update to a newer release of PHP from [https://windows.php.net/download/] and a newer phpMyAdmin from [https://www.phpmyadmin.net/downloads/] as Uniform Server tends to issue upgrades very rarely.		#You might choose ‘’’Uniform Server’’’, which is extremely simple as it comes as a package including PHP script, and MariaDB database in one package from [http://www.uniformserver.com/], although you may need to update to a newer release of PHP from [https://windows.php.net/download/] and a newer phpMyAdmin from [https://www.phpmyadmin.net/downloads/] as Uniform Server tends to issue upgrades very rarely.
	#You might choose to install the Abyss web server from [aprelium.com]		#You might choose to install the Abyss web server from [aprelium.com]

Freddie: /* All in one versus separate components */

2022-07-25T20:54:10Z

All in one versus separate components

← Older revision		Revision as of 20:54, 25 July 2022
Line 66:		Line 66:
	# web server – there are various options listed below; beware "apache2" is huge as it is very complicated, but secure; other options consume fewer resources, and may be easier to use, but they will also be more restrictive		# web server – there are various options listed below; beware "apache2" is huge as it is very complicated, but secure; other options consume fewer resources, and may be easier to use, but they will also be more restrictive
	# PHP script - from [https://windows.php.net/download/] - this provides a way of controlling what SQL is run depending on other factors		# PHP script - from [https://windows.php.net/download/] - this provides a way of controlling what SQL is run depending on other factors
	# Database server - MySQL Community edition from [mysql.com] or ~~MariaSQL~~ from [https://downloads.mariadb.org/].		# Database server - MySQL Community edition from [mysql.com] or MariaDB from [https://downloads.mariadb.org/].
	# Integrating components like ‘’’phpMyAdmin’’ (there are alternatives) from [https://www.phpmyadmin.net/downloads/] which combines PHP and MySQL		# Integrating components like ‘’’phpMyAdmin’’ (there are alternatives) from [https://www.phpmyadmin.net/downloads/] which combines PHP and MySQL

	There are a number of packages that combine all of these:		There are a number of packages that combine all of these:
	*If designed for Microsoft Windows and including Apache2, PHP, and either ~~MariaSQL~~ or MySQL, the package is often described as ‘’’WAMP’’’		*If designed for Microsoft Windows and including Apache2, PHP, and either MariaDB or MySQL, the package is often described as ‘’’WAMP’’’
	*If designed for UNIX (including Linux), then XAMP will include Apache2, PHP, and either ~~MariaSQL~~ or MySQL		*If designed for UNIX (including Linux), then XAMP will include Apache2, PHP, and either MariaDB or MySQL

	Obviously, there are other web servers, some come on their own, others come as a package.		Obviously, there are other web servers, some come on their own, others come as a package.

Sfws: Updated wiki page for MX changes since 3.6.0 when page was created

2022-06-16T18:00:24Z

Updated wiki page for MX changes since 3.6.0 when page was created

Show changes

Sfws at 09:01, 18 May 2021

2021-05-18T09:01:44Z

Show changes

Sfws: Skeleton for new page (to contain information that was on another page)

2021-05-17T17:44:39Z

Skeleton for new page (to contain information that was on another page)

New page

{{Template:WorkInProgressBanner}}
This page describes how I set up a web server and a database server on my Raspberry Pi computer.

For more information about running MX in a Linux environment please see [[MX on Linux]].

For more information about Raspberry Pi computers see [[Raspberry Pi computer page]].

For more information on log files that you might want to convert to database tables, please see [[Diary.db|MX Weather Diary]], [[Log.xml|Legacy Weather Diary]], [[Dayfile.txt|daily summary log (dayfile.txt)]], [[Speciallog.txt]], [[Standard log files]], [[Extra Sensor Files]], and [[Air Link Log.txt]].

[[Category:WebTips]]