Difference between revisions of "Install server"

From Gestinux Wiki
Jump to navigation Jump to search
(19 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 
{{#CustomTitle:Installing a server}}
 
{{#CustomTitle:Installing a server}}
  
−
[[Installing|Back to Gestinux installation]]
+
If you do not want to [http://mrit.com/cloud/index.php?Langue=en use a database hosted in the internet], Gestinux requires either '''MySql Server''' or '''MariaDb Server''' (>= 5.0) or '''PostgreSQL Server''' (>= 8.4) installed on your local system, or on any server your network can access.
  
−
If you do not want to use a database hosted in the internet, Gestinux requires either '''MySql Server''' (>= 5.0) or '''PostgreSQL Server''' (>= 8.4) installed on your local system, or on any server reacheable through your network.
+
The easiest installation is setting up MySql on Linux.
  
−
The easiest to install is MySql on Linux.
+
The power of current computers means you will still have spare processing capacity after installing a server locally.  
  
−
They are not consuming much, with the power of current computers.
+
You must have an ''administrator'' account before you can install.
  
−
You must have an ''administrator'' account to be able to install.
+
The following is a short guide to installing. For more details, please refer to the official documentation.
  
−
Below is a short guide to install these servers. For more details, please refer to the official documentation.
+
=== To install MySql server : ===
−
 
 
−
===To install MySql server :===
 
  
 
* On Ubuntu :  
 
* On Ubuntu :  
−
** Install the package '''mysql-server''', using Synaptic.
+
** Use the software center, or synaptic to install the package '''mysql-server'''.
−
** Confirm a few choices
+
** Confirm a few options
 
** You can enter a blank password for the root account if you are evaluating.
 
** You can enter a blank password for the root account if you are evaluating.
 
* On Windows :
 
* On Windows :
−
** Go to [http://dev.mysql.com/downloads/mysql/ mysql download page]
+
** Go to the [http://dev.mysql.com/downloads/mysql/ mysql download page]
 
** Download the appropriate installer (in most cases, the first one)
 
** Download the appropriate installer (in most cases, the first one)
−
** Execute the setup, using a priviledged account.
+
** Execute the setup.exe, using a privileged account.
−
** You can confirm the default choices
+
** You can accept the default options
 
** You can choose a standard configuration
 
** You can choose a standard configuration
−
** A non blank root password is requested, '''remember it''' !
+
** A non-blank root password is required: '''Remember it''' !
 +
 
 +
=== To install MariaDb Server : ===
 +
* On Linux Ubuntu :
 +
On Ubuntu 14.04 LTS and newer, MariaDB can be installed with the software center, or synaptic, or you can run in a terminal :
 +
sudo apt-get install mariadb-server
 +
On older versions, see [http://askubuntu.com/questions/64772/how-to-install-mariadb this documentation]
 +
* On Windows :
 +
Download [https://downloads.mariadb.org/mariadb/5.5.32/#os_group=windows from this page]
  
−
===To install PostgreSQL server :===
+
=== To install PostgreSQL server : ===
  
 
* On Ubuntu :
 
* On Ubuntu :
 
** Install the package '''postgresql'''
 
** Install the package '''postgresql'''
 
* On Windows
 
* On Windows
−
** To be documented...
+
** Go to the [http://www.enterprisedb.com/products-services-training/pgdownload PostgreSQL download page]
 +
** Download the appropriate installer (x86-32 or x86-64 according your Windows version)
 +
** Execute the ''postgresql-(version)-windows(-x64).exe'', using a privileged account.
 +
** You can accept the default paths for installation and data
 +
** Define a non-blank superuser password: '''remember it!'''
 +
** You can accept the default port number (5432). If you define a new one: '''remember it!'''
 +
** Define your locale settings
 +
** After files were copied, uncheck '''Execute Stack Builder''' on exit
 +
** In the client-server configuration
 +
***Go to the directory <''data''> defined at the step before and edit the file '''pg_hba.conf''' by adding this line at the end: ''host <database> all <network>/24 md5''
 +
*** ''Example: host gestinux all 192.168.1.0/24 md5 (Allow all users on the local network 192.168.1.* to access the database gestinux)''
 +
*** And finally you must open the used port (default'' 5432'') in your firewall
  
  
 
[[Installing|Back to Gestinux installation]]
 
[[Installing|Back to Gestinux installation]]

Revision as of 15:40, 13 March 2017

 Français Español

{{#CustomTitle:Installing a server}}

If you do not want to use a database hosted in the internet, Gestinux requires either MySql Server or MariaDb Server (>= 5.0) or PostgreSQL Server (>= 8.4) installed on your local system, or on any server your network can access.

The easiest installation is setting up MySql on Linux.

The power of current computers means you will still have spare processing capacity after installing a server locally.

You must have an administrator account before you can install.

The following is a short guide to installing. For more details, please refer to the official documentation.

To install MySql server :

  • On Ubuntu :
    • Use the software center, or synaptic to install the package mysql-server.
    • Confirm a few options
    • You can enter a blank password for the root account if you are evaluating.
  • On Windows :
    • Go to the mysql download page
    • Download the appropriate installer (in most cases, the first one)
    • Execute the setup.exe, using a privileged account.
    • You can accept the default options
    • You can choose a standard configuration
    • A non-blank root password is required: Remember it !

To install MariaDb Server :

  • On Linux Ubuntu :

On Ubuntu 14.04 LTS and newer, MariaDB can be installed with the software center, or synaptic, or you can run in a terminal : 

sudo apt-get install mariadb-server

On older versions, see this documentation

  • On Windows :

Download from this page

To install PostgreSQL server :

  • On Ubuntu :
    • Install the package postgresql
  • On Windows
    • Go to the PostgreSQL download page
    • Download the appropriate installer (x86-32 or x86-64 according your Windows version)
    • Execute the postgresql-(version)-windows(-x64).exe, using a privileged account.
    • You can accept the default paths for installation and data
    • Define a non-blank superuser password: remember it!
    • You can accept the default port number (5432). If you define a new one: remember it!
    • Define your locale settings
    • After files were copied, uncheck Execute Stack Builder on exit
    • In the client-server configuration
      • Go to the directory <data> defined at the step before and edit the file pg_hba.conf by adding this line at the end: host <database> all <network>/24 md5
      • Example: host gestinux all 192.168.1.0/24 md5 (Allow all users on the local network 192.168.1.* to access the database gestinux)
      • And finally you must open the used port (default 5432) in your firewall


Back to Gestinux installation

Retrieved from "https://gestinux.net/mediawiki/index.php?title=Install_server&oldid=3704"