Install/2-0/ServerPackages - Revision history

Alofoxx: update to mysql 8 and php 8

2023-10-07T00:02:29Z

update to mysql 8 and php 8

← Older revision		Revision as of 19:02, 6 October 2023
Line 5:		Line 5:

	= Installing Software on the Server =		= Installing Software on the Server =

			'''''Note: This is not a comprehensive guide on how to set up a properly secured server for production. Please look into and take steps to harden a production server, such as setting up the firewall and proper sshd settings.'''''


	This section of the guide will walk you through the configuration of a server running Ubuntu Server 22.04 LTS, on which Convention Master can run. If your server is not yet installed, you can follow the official Ubuntu guide to do so:		This section of the guide will walk you through the configuration of a server running Ubuntu Server 22.04 LTS, on which Convention Master can run. If your server is not yet installed, you can follow the official Ubuntu guide to do so:
Line 33:		Line 36:

	'''MySQL 8.0'''		'''MySQL 8.0'''
	Currently ~~several people are running~~ MySQL 8.0~~, and not having any issues at all~~. ~~We are curently still "testing" 8~~.~~0 and probably will continue to classify as "testing". If you would prefer to use~~ MySQL ~~5.7 see the instructions below~~, ~~otherwise feel free to~~ run 8.0		Currently, MySQL 8.0.x is the recommended version for Convention Master.

			To install the MySQL database server software, run the following command:
			<syntaxhighlight lang="bash">
			sudo apt install mysql-server
			sudo systemctl start mysql.service
			</syntaxhighlight>


	~~'''MySQL 5.7'''~~		You will need to take some extra steps to get the user accounts and special settings Convention Master needs set up.
	~~With the server restarted, we~~ will ~~prepare your server to install MySQL 5.7, which is not available on Ubuntu 22.04 LTS from either the default Ubuntu or MySQL repositories. As a result, we~~ need to ~~manually configure where~~ to get ~~these packages~~.

			Use the following command to get into the MySQL prompt
	<syntaxhighlight lang="bash">		<syntaxhighlight lang="bash">
	sudo ~~apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 5072E1F5~~		sudo mysql
	~~sudo echo 'deb http://repo.~~mysql~~.com/apt/ubuntu bionic mysql-5.7' \| sudo tee /etc/apt/sources.list.d/mysql.list~~
	~~sudo apt update~~
	</syntaxhighlight>		</syntaxhighlight>


	'''~~NOTE:~~''' We are aware that official support from MySQL for version 5.7 ends in October 2023. We have run Convention Master on MySQL 8.0 in a number of scenarios without incident, however we have not yet completed specific testing on 8.0 in order to make it our supported version. We expect to have this testing completed by the release of CM v11.		While in the MySQL prompt type the following commands. Note: replace your_new_mysql_root_password with your own unique password that you make sure you don't forget.
			<syntaxhighlight lang="MySQL">
			ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_new_mysql_root_password';
			exit;
			</syntaxhighlight>


	~~With~~ MySQL ~~configured~~, you ~~can~~ use ~~the following~~ command ~~to install all~~ the ~~packages a standard Convention Master setup needs~~.		This will make sure you don't get locked out by the next step. If you need to get back into the MySQL prompt in the future, you will use this command "mysql -u root -p" and enter the password you just set.

			Next we should take some basic steps to secure the MySQL server. Run the following command to start a wizard that will walk you through some changes to your MySQL server.
	<syntaxhighlight lang="bash">		<syntaxhighlight lang="bash">
	sudo ~~apt install -y php8.1 php8.1-cli php8.1-curl php8.1-gd php8.1-mysql php8.1-mbstring php8.1-intl~~		sudo mysql_secure_installation
	~~subversion ntp nano joe apache2 libapache2-mod-php7.4 bind9 bind9utils samba html2ps~~
	~~htmldoc mysql-client=5.7* mysql-server=5.7* mcrypt python3-pil curl~~
	</syntaxhighlight>		</syntaxhighlight>


	~~'''PHP 7~~.~~x:''' Convention Master 10~~.x will ~~technically run on PHP 7~~.~~x. However~~, these ~~versions of PHP are no longer supported by Zend,~~ so ~~we highly recommend~~ immediately ~~upgrading your server to PHP 8~~.~~x for best security and compatibility~~. Convention Master will ~~cease supporting PHP 7.x as of version 11, currently under development at time of writing~~.		* When it starts, it will ask you for your MySQL root password. This will be the same one you set above.
			* It will ask if you want to enable the VALIDATE PASSWORD COMPONENT - enter N
			* It will ask if you want to change your root password - you can say no since you already set a password
			* From there, you can press Y and then ENTER to accept the defaults for all the subsequent questions. This will remove some anonymous users and the test database, disable remote root logins, and load these new rules so that MySQL immediately respects the changes you have made.

			Once the script completes, MySQL is now installed. You will need to make some configuration changes to properly run Convention Master which will be covered in step 3.2

	~~Finally~~, ~~let's go ahead and run~~ the ~~wizard~~ to ~~properly secure your new MySQL installation:~~		With MySQL configured, you can use the following command to install all the packages a standard Convention Master setup needs.

	<syntaxhighlight lang="bash">		<syntaxhighlight lang="bash">
	sudo ~~mysql_secure_installation~~		sudo apt install -y php8.1 php8.1-cli php8.1-curl php8.1-gd php8.1-mysql php8.1-mbstring php8.1-intl
			subversion ntp nano joe apache2 libapache2-mod-php8.1 html2ps
			htmldoc mcrypt python3-pil curl
	</syntaxhighlight>		</syntaxhighlight>

Alofoxx at 09:58, 30 September 2023

2023-09-30T09:58:27Z

← Older revision		Revision as of 04:58, 30 September 2023
Line 50:		Line 50:

	<syntaxhighlight lang="bash">		<syntaxhighlight lang="bash">
	sudo apt install -y php8.1 php8.1-cli php8.1-curl php8.1-gd php8.1-mysql php8.1-mbstring		sudo apt install -y php8.1 php8.1-cli php8.1-curl php8.1-gd php8.1-mysql php8.1-mbstring php8.1-intl
	subversion ntp nano joe apache2 libapache2-mod-php7.4 bind9 bind9utils samba html2ps		subversion ntp nano joe apache2 libapache2-mod-php7.4 bind9 bind9utils samba html2ps
	htmldoc mysql-client=5.7* mysql-server=5.7* mcrypt python3-pil curl		htmldoc mysql-client=5.7* mysql-server=5.7* mcrypt python3-pil curl

Trapa at 00:17, 6 February 2023

2023-02-06T00:17:46Z

← Older revision		Revision as of 19:17, 5 February 2023
Line 32:		Line 32:
	...to restart the server.		...to restart the server.

			'''MySQL 8.0'''
			Currently several people are running MySQL 8.0, and not having any issues at all. We are curently still "testing" 8.0 and probably will continue to classify as "testing". If you would prefer to use MySQL 5.7 see the instructions below, otherwise feel free to run 8.0

			'''MySQL 5.7'''
	With the server restarted, we will prepare your server to install MySQL 5.7, which is not available on Ubuntu 22.04 LTS from either the default Ubuntu or MySQL repositories. As a result, we need to manually configure where to get these packages.		With the server restarted, we will prepare your server to install MySQL 5.7, which is not available on Ubuntu 22.04 LTS from either the default Ubuntu or MySQL repositories. As a result, we need to manually configure where to get these packages.

Silvershock: Updating page for 22.04/PHP 8.1

2022-12-14T23:08:24Z

Updating page for 22.04/PHP 8.1

← Older revision		Revision as of 18:08, 14 December 2022
Line 6:		Line 6:
	= Installing Software on the Server =		= Installing Software on the Server =

	This section of the guide will walk you through the configuration of a server running Ubuntu Server 18.04 LTS, on which Convention Master can run. If your server is not yet installed, you can follow the official Ubuntu guide to do so:		This section of the guide will walk you through the configuration of a server running Ubuntu Server 22.04 LTS, on which Convention Master can run. If your server is not yet installed, you can follow the official Ubuntu guide to do so:

	https://tutorials.ubuntu.com/tutorial/tutorial-install-ubuntu-server		https://tutorials.ubuntu.com/tutorial/tutorial-install-ubuntu-server
Line 17:		Line 17:
	Once your server's operating system is installed, we can begin installing the packages you will need to run Convention Master. Log in as the user you created during installation (or any user with sudo rights), and input the following commands.		Once your server's operating system is installed, we can begin installing the packages you will need to run Convention Master. Log in as the user you created during installation (or any user with sudo rights), and input the following commands.

	sudo apt~~-get~~ update		<syntaxhighlight lang="bash">
	sudo apt~~-get~~ dist-upgrade -y		sudo apt update
			sudo apt dist-upgrade -y
			</syntaxhighlight>


	These will ensure your server has the very latest versions of its available packages and kernel. With those done, run...		These will ensure your server has the very latest versions of its available packages and kernel. With those done, run...

	sudo reboot		<syntaxhighlight lang="bash">
			sudo reboot
			</syntaxhighlight>


			...to restart the server.

			With the server restarted, we will prepare your server to install MySQL 5.7, which is not available on Ubuntu 22.04 LTS from either the default Ubuntu or MySQL repositories. As a result, we need to manually configure where to get these packages.

			<syntaxhighlight lang="bash">
			sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 5072E1F5
			sudo echo 'deb http://repo.mysql.com/apt/ubuntu bionic mysql-5.7' \| sudo tee /etc/apt/sources.list.d/mysql.list
			sudo apt update
			</syntaxhighlight>


	...to ~~restart the server~~. ~~When it comes back up, you can use the following command~~ to ~~install all~~ the ~~standard packages Convention Master needs~~.		'''NOTE:''' We are aware that official support from MySQL for version 5.7 ends in October 2023. We have run Convention Master on MySQL 8.0 in a number of scenarios without incident, however we have not yet completed specific testing on 8.0 in order to make it our supported version. We expect to have this testing completed by the release of CM v11.

	~~sudo apt-get~~ install ~~-y php7~~.~~4 php7.4-curl php7.4-gd php7.4-mysql php7.4-mbstring~~		With MySQL configured, you can use the following command to install all the packages a standard Convention Master setup needs.
	~~subversion ntp nano joe apache2 libapache2-mod-php7.4 bind9 bind9utils samba html2ps~~
	~~htmldoc mysql-client mysql-server mcrypt python3-pil curl~~

			<syntaxhighlight lang="bash">
			sudo apt install -y php8.1 php8.1-cli php8.1-curl php8.1-gd php8.1-mysql php8.1-mbstring
			subversion ntp nano joe apache2 libapache2-mod-php7.4 bind9 bind9utils samba html2ps
			htmldoc mysql-client=5.7* mysql-server=5.7* mcrypt python3-pil curl
			</syntaxhighlight>

	'''PHP 7.1:''' Convention Master's PHP support tracks that of Zend themselves, and as such PHP 7.1 will be supported until the end of 2019. If installing on PHP 7.1, you will need to add an additional package to the list above:

	~~php-sodium~~		'''PHP 7.x:''' Convention Master 10.x will technically run on PHP 7.x. However, these versions of PHP are no longer supported by Zend, so we highly recommend immediately upgrading your server to PHP 8.x for best security and compatibility. Convention Master will cease supporting PHP 7.x as of version 11, currently under development at time of writing.

			Finally, let's go ahead and run the wizard to properly secure your new MySQL installation:

	'''PHP 7.3:''' You may have noticed that we are installing PHP 7.2. At the time of writing (Convention Master 10.0), the software has not been tested on PHP 7.3, as Ioncube Encoder was not available in a final version before the previous CM release. Support for PHP 7.3 will be added in an upcoming release.		<syntaxhighlight lang="bash">
			sudo mysql_secure_installation
			</syntaxhighlight>

Alofoxx at 03:44, 22 August 2022

2022-08-22T03:44:45Z

← Older revision		Revision as of 22:44, 21 August 2022
Line 26:		Line 26:
	...to restart the server. When it comes back up, you can use the following command to install all the standard packages Convention Master needs.		...to restart the server. When it comes back up, you can use the following command to install all the standard packages Convention Master needs.

	sudo apt-get install -y php7.2 php7.2-curl php7.2-gd php7.2-mysql php7.2-mbstring		sudo apt-get install -y php7.4 php7.4-curl php7.4-gd php7.4-mysql php7.4-mbstring
	subversion ntp nano joe apache2 libapache2-mod-php7.2 bind9 bind9utils samba html2ps		subversion ntp nano joe apache2 libapache2-mod-php7.4 bind9 bind9utils samba html2ps
	htmldoc mysql-client mysql-server mcrypt python3-pil curl		htmldoc mysql-client mysql-server mcrypt python3-pil curl

Aloha at 21:59, 24 February 2020

2020-02-24T21:59:04Z

← Older revision		Revision as of 16:59, 24 February 2020
Line 28:		Line 28:
	sudo apt-get install -y php7.2 php7.2-curl php7.2-gd php7.2-mysql php7.2-mbstring		sudo apt-get install -y php7.2 php7.2-curl php7.2-gd php7.2-mysql php7.2-mbstring
	subversion ntp nano joe apache2 libapache2-mod-php7.2 bind9 bind9utils samba html2ps		subversion ntp nano joe apache2 libapache2-mod-php7.2 bind9 bind9utils samba html2ps
	htmldoc mysql-client mysql-server mcrypt ~~python~~-pil		htmldoc mysql-client mysql-server mcrypt python3-pil curl

Silvershock at 20:44, 23 November 2019

2019-11-23T20:44:05Z

← Older revision		Revision as of 15:44, 23 November 2019
Line 26:		Line 26:
	...to restart the server. When it comes back up, you can use the following command to install all the standard packages Convention Master needs.		...to restart the server. When it comes back up, you can use the following command to install all the standard packages Convention Master needs.

	sudo apt-get install -y php7.2 php7.2-curl php7.2-gd php7.2-mysql ~~subversion~~		sudo apt-get install -y php7.2 php7.2-curl php7.2-gd php7.2-mysql php7.2-mbstring
	ntp nano joe apache2 libapache2-mod-php7.2 bind9 bind9utils samba html2ps		subversion ntp nano joe apache2 libapache2-mod-php7.2 bind9 bind9utils samba html2ps
	htmldoc mysql-client mysql-server mcrypt python-pil		htmldoc mysql-client mysql-server mcrypt python-pil

Silvershock at 03:16, 24 July 2019

2019-07-24T03:16:38Z

← Older revision		Revision as of 22:16, 23 July 2019
Line 29:		Line 29:
	ntp nano joe apache2 libapache2-mod-php7.2 bind9 bind9utils samba html2ps		ntp nano joe apache2 libapache2-mod-php7.2 bind9 bind9utils samba html2ps
	htmldoc mysql-client mysql-server mcrypt python-pil		htmldoc mysql-client mysql-server mcrypt python-pil


	'''PHP 7.1:''' Convention Master's PHP support tracks that of Zend themselves, and as such PHP 7.1 will be supported until the end of 2019. If installing on PHP 7.1, you will need to add an additional package to the list above:		'''PHP 7.1:''' Convention Master's PHP support tracks that of Zend themselves, and as such PHP 7.1 will be supported until the end of 2019. If installing on PHP 7.1, you will need to add an additional package to the list above:

Silvershock at 03:16, 24 July 2019

2019-07-24T03:16:23Z

← Older revision		Revision as of 22:16, 23 July 2019
Line 33:		Line 33:

	php-sodium		php-sodium


	'''PHP 7.3:''' You may have noticed that we are installing PHP 7.2. At the time of writing (Convention Master 10.0), the software has not been tested on PHP 7.3, as Ioncube Encoder was not available in a final version before the previous CM release. Support for PHP 7.3 will be added in an upcoming release.		'''PHP 7.3:''' You may have noticed that we are installing PHP 7.2. At the time of writing (Convention Master 10.0), the software has not been tested on PHP 7.3, as Ioncube Encoder was not available in a final version before the previous CM release. Support for PHP 7.3 will be added in an upcoming release.

Silvershock at 03:16, 24 July 2019

2019-07-24T03:16:11Z

← Older revision		Revision as of 22:16, 23 July 2019
Line 30:		Line 30:
	htmldoc mysql-client mysql-server mcrypt python-pil		htmldoc mysql-client mysql-server mcrypt python-pil

			'''PHP 7.1:''' Convention Master's PHP support tracks that of Zend themselves, and as such PHP 7.1 will be supported until the end of 2019. If installing on PHP 7.1, you will need to add an additional package to the list above:

	~~Note~~: You may have noticed that we are installing PHP 7.2. At the time of writing (Convention Master 10.0), the software has not been tested on PHP 7.3, as Ioncube Encoder was not available in a final version before the previous CM release. Support for PHP 7.3 will be added in an upcoming release.		php-sodium

			'''PHP 7.3:''' You may have noticed that we are installing PHP 7.2. At the time of writing (Convention Master 10.0), the software has not been tested on PHP 7.3, as Ioncube Encoder was not available in a final version before the previous CM release. Support for PHP 7.3 will be added in an upcoming release.