MEPO Forum :: Linux系統管理

Changed By: HP
Change Date: March 24, 2019 07:41PM

Install a LAPP Stack (Apache 2.4/PHP 7/PostgreSQL 10/MariaDB 10) on openSUSE Tumbleweed

Assume the Tumbleweed linux is ready.

<center>I. Database </center>Install the database first (PostgreSQL 10):

1. Install database
<div style="background:#ddd;padding-left:1em">zypper install postgresql10 postgresql10-contrib postgresql10-server</div>

2. Enable auto-start on boot
<div style="background:#ddd;padding-left:1em">chkconfig -a postgresql</div>

3. Start PostgreSQL
<div style="background:#ddd;padding-left:1em">systemctl start postgresql.service</div>

4. Set password for postgres
Switch user to postgres:
<div style="background:#ddd;padding-left:1em">su postgres
psql</div>
In the psql console, set the password:
<div style="background:#ddd;padding-left:1em">\password postgres</div>

5. Fine-tune performance
(1) Edit postgresql.conf
<div style="background:#ddd;padding-left:1em">vi /var/lib/pgsql/data/postgresql.conf</div>
(2) Set parameters
<div style="background:#ddd;padding-left:1em">shared_buffers = 4GB
work_mem = 32MB
effective_cache_size = 8GB</div>

<b>shared_buffers</b>: 1/4 of total memory is a reasonable starting value
<b>effective_cache_size</b>: 1/2 of total memory would be a normal setting

<div style="text-align:center">II. Web Server</div>
1. Install apache2
<div style="background:#ddd;padding-left:1em">zypper install apache2 apache2-mod_evasive</div>

2. Add commonly-used modules
Add modules:
<div style="background:#ddd;padding-left:1em">a2enmod php7</div>
<div style="background:#ddd;padding-left:1em">a2enmod rewrite</div>
<div style="background:#ddd;padding-left:1em">a2enmod headers</div>
List apache loaded modules:
<div style="background:#ddd;padding-left:1em">apachectl -M</div>

3. Enable auto-start on boot
<div style="background:#ddd;padding-left:1em">chkconfig -a apache2</div>

4. Edit <b>default-server.conf</b> (/etc/apache2)
(1) Edit DocumentRoot to your own default websidte directory (e.g. DocumentRoot "/home/yoursite").
(2) Edit the <Directory> right below DocumentRoot.
(3) Add/Append the following directives:
<div style="background:#ddd;padding-left:1em">ServerName website.com</div>
<div style="background:#ddd;padding-left:1em">ExtendedStatus On</div>
<div style="background:#ddd;padding-left:1em">TraceEnable Off</div>
<div style="background:#ddd;padding-left:1em">AddType image/x-icon .ico</div>

5. Modify server-tuning.conf (/etc/apache2)
(1) Raise <i>StartServers</i> if necessary
(2) Raise <i>MaxSpareServers</i> if necessary
(3) Raise <i>ServerLimit</i> if necessary
(4) Raise <i>MaxClients</i> if necessary

<div style="text-align:center">III. Hypertext Preprocessor</div>
1. Install php7
<div style="background:#ddd;padding-left:1em">zypper install php7 php7-pgsql</div>

2. Install commonly-used modules
<div style="background:#ddd;padding-left:1em">zypper install php7-curl php7-fileinfo php7-gd php7-mbstring php7-openssl php7-zip php7-zlib</div>

<div style="background:#ddd;padding-left:1em"></div>

MariaDB
1. Install mariadb
<div style="background:#ddd;padding-left:1em">zypper install mariadb mariadb-tools</div>

2. Security setting
<div style="background:#ddd;padding-left:1em">mysql_secure_installation</div>
(all "yes" is preferred)

3. Enable auto-start on boot
<div style="background:#ddd;padding-left:1em">chkconfig -a mysql</div>

References:
<a href=http://mepopedia.com/forum/read.php?135,76348>Install a LAPP server: openSUSE 42 / Apahce 2.4/PostgreSQL 9.4/ PHP 5.6</a>
<a href=https://www.howtoforge.com/tutorial/how-to-install-postgresql-and-phppgadmin-on-opensuse-leap-42.1/>How to Install PostgreSQL and phpPgAdmin on OpenSUSE Leap 42.1</a>
<a href=http://httpd.apache.org/docs/2.4/mod/prefork.html>Apache MPM prefork</a>
<a href=http://httpd.apache.org/docs/2.4/mod/mpm_common.html>Apache MPM Common Directives</a>

Changed By: HP
Change Date: March 24, 2019 07:34PM

Install a LAPP Stack (Apache 2.4/PHP 7/PostgreSQL 10/MariaDB 10) on openSUSE Tumbleweed

Assume the Tumbleweed linux is ready.

<center>I. Database </center>Install the database first (PostgreSQL 10):

1. Install database
<div style="background:#ddd;padding-left:1em">zypper install postgresql10 postgresql10-contrib postgresql10-server</div>

2. Enable auto-start on boot
<div style="background:#ddd;padding-left:1em">chkconfig -a postgresql</div>

3. Start PostgreSQL
<div style="background:#ddd;padding-left:1em">systemctl start postgresql.service</div>

4. Set password for postgres
Switch user to postgres:
<div style="background:#ddd;padding-left:1em">su postgres
psql</div>
In the psql console, set the password:
<div style="background:#ddd;padding-left:1em">\password postgres</div>

5. Fine-tune performance
(1) Edit postgresql.conf
<div style="background:#ddd;padding-left:1em">vi /var/lib/pgsql/data/postgresql.conf</div>
(2) Set parameters
<div style="background:#ddd;padding-left:1em">shared_buffers = 4GB
work_mem = 32MB
effective_cache_size = 8GB</div>

<b>shared_buffers</b>: 1/4 of total memory is a reasonable starting value
<b>effective_cache_size</b>: 1/2 of total memory would be a normal setting

<div style="text-align:center">II. Web Server</div>
1. Install apache2
<div style="background:#ddd;padding-left:1em">zypper install apache2 apache2-mod_evasive</div>

2. Add commonly-used modules
Add modules:
<div style="background:#ddd;padding-left:1em">a2enmod php7</div>
<div style="background:#ddd;padding-left:1em">a2enmod rewrite</div>
<div style="background:#ddd;padding-left:1em">a2enmod headers</div>
List apache loaded modules:
<div style="background:#ddd;padding-left:1em">apachectl -M</div>

3. Enable auto-start on boot
<div style="background:#ddd;padding-left:1em">chkconfig -a apache2</div>

4. Edit <b>default-server.conf</b> (/etc/apache2)
(1) Edit DocumentRoot to your own default websidte directory (e.g. DocumentRoot "/home/yoursite").
(2) Edit the <Directory> right below DocumentRoot.
(3) Add/Append the following directives:
<div style="background:#ddd;padding-left:1em">ServerName website.com</div>
<div style="background:#ddd;padding-left:1em">ExtendedStatus On</div>
<div style="background:#ddd;padding-left:1em">TraceEnable Off</div>
<div style="background:#ddd;padding-left:1em">AddType image/x-icon .ico</div>

5. Modify server-tuning.conf (/etc/apache2)
(1) Raise <i>StartServers</i> if necessary
(2) Raise <i>MaxSpareServers</i> if necessary
(3) Raise <i>ServerLimit</i> if necessary
(4) Raise <i>MaxClients</i> if necessary

<div style="text-align:center">III. Hypertext Preprocessor</div>
1. Install php7
<div style="background:#ddd;padding-left:1em">zypper install php7 php7-pgsql</div>

2. Install commonly-used modules
<div style="background:#ddd;padding-left:1em">zypper install php7-curl php7-fileinfo php7-gd php7-mbstring php7-openssl php7-zlib</div>

<div style="background:#ddd;padding-left:1em"></div>

MariaDB
1. Install mariadb
<div style="background:#ddd;padding-left:1em">zypper install mariadb mariadb-tools</div>

2. Security setting
<div style="background:#ddd;padding-left:1em">mysql_secure_installation</div>
(all "yes" is preferred)

3. Enable auto-start on boot
<div style="background:#ddd;padding-left:1em">chkconfig -a mysql</div>

References:
<a href=http://mepopedia.com/forum/read.php?135,76348>Install a LAPP server: openSUSE 42 / Apahce 2.4/PostgreSQL 9.4/ PHP 5.6</a>
<a href=https://www.howtoforge.com/tutorial/how-to-install-postgresql-and-phppgadmin-on-opensuse-leap-42.1/>How to Install PostgreSQL and phpPgAdmin on OpenSUSE Leap 42.1</a>
<a href=http://httpd.apache.org/docs/2.4/mod/prefork.html>Apache MPM prefork</a>
<a href=http://httpd.apache.org/docs/2.4/mod/mpm_common.html>Apache MPM Common Directives</a>

Changed By: HP
Change Date: March 20, 2019 03:43PM

Install a LAPP Stack (Apache 2.4/PHP 7/PostgreSQL 10/MariaDB 10) on openSUSE Tumbleweed

Assume the Tumbleweed linux is ready.

<center>I. Database </center>Install the database first (PostgreSQL 10):

1. Install database
<div style="background:#ddd;padding-left:1em">zypper install postgresql10 postgresql10-contrib postgresql10-server</div>

2. Enable auto-start on boot
<div style="background:#ddd;padding-left:1em">chkconfig -a postgresql</div>

3. Start PostgreSQL
<div style="background:#ddd;padding-left:1em">systemctl start postgresql.service</div>

4. Set password for postgres
Switch user to postgres:
<div style="background:#ddd;padding-left:1em">su postgres
psql</div>
In the psql console, set the password:
<div style="background:#ddd;padding-left:1em">\password postgres</div>

5. Fine-tune performance
(1) Edit postgresql.conf
<div style="background:#ddd;padding-left:1em">vi /var/lib/pgsql/data/postgresql.conf</div>
(2) Set parameters
<div style="background:#ddd;padding-left:1em">shared_buffers = 4GB
work_mem = 32MB
effective_cache_size = 8GB</div>

<b>shared_buffers</b>: 1/4 of total memory is a reasonable starting value
<b>effective_cache_size</b>: 1/2 of total memory would be a normal setting

<div style="text-align:center">II. Web Server</div>
1. Install apache2
<div style="background:#ddd;padding-left:1em">zypper install apache2 apache2-mod_evasive</div>

2. Add commonly-used modules
Add modules:
<div style="background:#ddd;padding-left:1em">a2enmod php7</div>
<div style="background:#ddd;padding-left:1em">a2enmod rewrite</div>
<div style="background:#ddd;padding-left:1em">a2enmod headers</div>
List apache loaded modules:
<div style="background:#ddd;padding-left:1em">apachectl -M</div>

3. Enable auto-start on boot
<div style="background:#ddd;padding-left:1em">chkconfig -a apache2</div>

4. Edit <b>default-server.conf</b> (/etc/apache2)
(1) Edit DocumentRoot to your own default websidte directory (e.g. DocumentRoot "/home/yoursite").
(2) Edit the <Directory> right below DocumentRoot.
(3) Add/Append the following directives:
<div style="background:#ddd;padding-left:1em">ServerName website.com</div>
<div style="background:#ddd;padding-left:1em">ExtendedStatus On</div>
<div style="background:#ddd;padding-left:1em">TraceEnable Off</div>
<div style="background:#ddd;padding-left:1em">AddType image/x-icon .ico</div>

5. Modify server-tuning.conf (/etc/apache2)
(1) Raise <i>StartServers</i> if necessary
(2) Raise <i>MaxSpareServers</i> if necessary
(3) Raise <i>ServerLimit</i> if necessary
(4) Raise <i>MaxClients</i> if necessary

<div style="text-align:center">III. Hypertext Preprocessor</div>
1. Install php7
<div style="background:#ddd;padding-left:1em">zypper install php7 php7-pgsql</div>

2. Install commonly-used modules
<div style="background:#ddd;padding-left:1em">zypper install php7-curl php7-gd php7-mbstring php7-openssl php7-zlib</div>

<div style="background:#ddd;padding-left:1em"></div>

MariaDB
1. Install mariadb
<div style="background:#ddd;padding-left:1em">zypper install mariadb mariadb-tools</div>

2. Security setting
<div style="background:#ddd;padding-left:1em">mysql_secure_installation</div>
(all "yes" is preferred)

3. Enable auto-start on boot
<div style="background:#ddd;padding-left:1em">chkconfig -a mysql</div>

References:
<a href=http://mepopedia.com/forum/read.php?135,76348>Install a LAPP server: openSUSE 42 / Apahce 2.4/PostgreSQL 9.4/ PHP 5.6</a>
<a href=https://www.howtoforge.com/tutorial/how-to-install-postgresql-and-phppgadmin-on-opensuse-leap-42.1/>How to Install PostgreSQL and phpPgAdmin on OpenSUSE Leap 42.1</a>
<a href=http://httpd.apache.org/docs/2.4/mod/prefork.html>Apache MPM prefork</a>
<a href=http://httpd.apache.org/docs/2.4/mod/mpm_common.html>Apache MPM Common Directives</a>

Changed By: HP
Change Date: March 18, 2019 09:09AM

Install a LAPP Stack (Apache 2.4/PHP 7/PostgreSQL 10/MariaDB 10) on openSUSE Tumbleweed

Assume the Tumbleweed linux is ready.

<center>I. Database </center>Install the database first (PostgreSQL 10):

1. Install database
<div style="background:#ddd;padding-left:1em">zypper install postgresql10 postgresql10-contrib postgresql10-server</div>

2. Enable auto-start on boot
<div style="background:#ddd;padding-left:1em">chkconfig -a postgresql</div>

3. Start PostgreSQL
<div style="background:#ddd;padding-left:1em">systemctl start postgresql.service</div>

4. Set password for postgres
Switch user to postgres:
<div style="background:#ddd;padding-left:1em">su postgres
psql</div>
In the psql console, set the password:
<div style="background:#ddd;padding-left:1em">\password postgres</div>

5. Fine-tune performance
(1) Edit postgresql.conf
<div style="background:#ddd;padding-left:1em">vi /var/lib/pgsql/data/postgresql.conf</div>
(2) Set parameters
<div style="background:#ddd;padding-left:1em">shared_buffers = 4GB
work_mem = 32MB
effective_cache_size = 8GB</div>

<b>shared_buffers</b>: 1/4 of total memory is a reasonable starting value
<b>effective_cache_size</b>: 1/2 of total memory would be a normal setting

<div style="text-align:center">II. Web Server</div>
1. Install apache2
<div style="background:#ddd;padding-left:1em">zypper install apache2</div>

2. Add commonly-used modules
Add modules:
<div style="background:#ddd;padding-left:1em">a2enmod php7</div>
<div style="background:#ddd;padding-left:1em">a2enmod rewrite</div>
<div style="background:#ddd;padding-left:1em">a2enmod headers</div>
List apache loaded modules:
<div style="background:#ddd;padding-left:1em">apachectl -M</div>

3. Enable auto-start on boot
<div style="background:#ddd;padding-left:1em">chkconfig -a apache2</div>

4. Edit <b>default-server.conf</b> (/etc/apache2)
(1) Edit DocumentRoot to your own default websidte directory (e.g. DocumentRoot "/home/yoursite").
(2) Edit the <Directory> right below DocumentRoot.
(3) Add/Append the following directives:
<div style="background:#ddd;padding-left:1em">ServerName website.com</div>
<div style="background:#ddd;padding-left:1em">ExtendedStatus On</div>
<div style="background:#ddd;padding-left:1em">TraceEnable Off</div>
<div style="background:#ddd;padding-left:1em">AddType image/x-icon .ico</div>

5. Modify server-tuning.conf (/etc/apache2)
(1) Raise <i>StartServers</i> if necessary
(2) Raise <i>MaxSpareServers</i> if necessary
(3) Raise <i>ServerLimit</i> if necessary
(4) Raise <i>MaxClients</i> if necessary

<div style="text-align:center">III. Hypertext Preprocessor</div>
1. Install php7
<div style="background:#ddd;padding-left:1em">zypper install php7 php7-pgsql</div>

2. Install commonly-used modules
<div style="background:#ddd;padding-left:1em">zypper install php7-curl php7-gd php7-mbstring php7-openssl php7-zlib</div>

<div style="background:#ddd;padding-left:1em"></div>

MariaDB
1. Install mariadb
<div style="background:#ddd;padding-left:1em">zypper install mariadb mariadb-tools</div>

2. Security setting
<div style="background:#ddd;padding-left:1em">mysql_secure_installation</div>
(all "yes" is preferred)

3. Enable auto-start on boot
<div style="background:#ddd;padding-left:1em">chkconfig -a mysql</div>

References:
<a href=http://mepopedia.com/forum/read.php?135,76348>Install a LAPP server: openSUSE 42 / Apahce 2.4/PostgreSQL 9.4/ PHP 5.6</a>
<a href=https://www.howtoforge.com/tutorial/how-to-install-postgresql-and-phppgadmin-on-opensuse-leap-42.1/>How to Install PostgreSQL and phpPgAdmin on OpenSUSE Leap 42.1</a>
<a href=http://httpd.apache.org/docs/2.4/mod/prefork.html>Apache MPM prefork</a>
<a href=http://httpd.apache.org/docs/2.4/mod/mpm_common.html>Apache MPM Common Directives</a>

Changed By: HP
Change Date: March 03, 2019 02:31AM

Install a LAPP Stack (Apache 2.4/PHP 7/PostgreSQL 10/MariaDB 10) on openSUSE Tumbleweed

Assume the Tumbleweed linux is ready.

<center>I. Database </center>Install the database first (PostgreSQL 10):

1. Install database
<div style="background:#ddd;padding-left:1em">zypper install postgresql10 postgresql10-contrib postgresql10-server</div>

2. Enable auto-start on boot
<div style="background:#ddd;padding-left:1em">chkconfig -a postgresql</div>

3. Start PostgreSQL
<div style="background:#ddd;padding-left:1em">systemctl start postgresql.service</div>

4. Set password for postgres
Switch user to postgres:
<div style="background:#ddd;padding-left:1em">su postgres
psql</div>
In the psql console, set the password:
<div style="background:#ddd;padding-left:1em">\password postgres</div>

5. Fine-tune performance
(1) Edit postgresql.conf
<div style="background:#ddd;padding-left:1em">vi /var/lib/pgsql/data/postgresql.conf</div>
(2) Set parameters
<div style="background:#ddd;padding-left:1em">shared_buffers = 4GB
work_mem = 32MB
effective_cache_size = 8GB</div>

<b>shared_buffers</b>: 1/4 of total memory is a reasonable starting value
<b>effective_cache_size</b>: 1/2 of total memory would be a normal setting

<div style="text-align:center">II. Web Server</div>
1. Install apache2
<div style="background:#ddd;padding-left:1em">zypper install apache2</div>

2. Add commonly-used modules
Add modules:
<div style="background:#ddd;padding-left:1em">a2enmod php7</div>
<div style="background:#ddd;padding-left:1em">a2enmod rewrite</div>
<div style="background:#ddd;padding-left:1em">a2enmod headers</div>
List apache loaded modules:
<div style="background:#ddd;padding-left:1em">apachectl -M</div>

3. Enable auto-start on boot
<div style="background:#ddd;padding-left:1em">chkconfig -a apache2</div>

4. Edit <b>default-server.conf</b> (/etc/apache2)
(1) Edit DocumentRoot to your own default websidte directory (e.g. DocumentRoot "/home/yoursite").
(2) Edit the <Directory> right below DocumentRoot.
(3) Add/Append the following directives:
<div style="background:#ddd;padding-left:1em">ServerName website.com</div>
<div style="background:#ddd;padding-left:1em">ExtendedStatus On</div>
<div style="background:#ddd;padding-left:1em">TraceEnable Off</div>
<div style="background:#ddd;padding-left:1em">AddType image/x-icon .ico</div>

5. Modify server-tuning.conf (/etc/apache2)
(1) Raise <i>StartServers</i> if necessary
(2) Raise <i>MaxSpareServers</i> if necessary
(3) Raise <i>ServerLimit</i> if necessary
(4) Raise <i>MaxClients</i> if necessary

<div style="text-align:center">II. I. Hypertext Preprocessor</div>
1. Install php7
<div style="background:#ddd;padding-left:1em">zypper install php7 php7-pgsql</div>

2. Install commonly-used modules
<div style="background:#ddd;padding-left:1em">zypper install php7-gd php7-mbstring php7-openssl php7-zlib</div>

<div style="background:#ddd;padding-left:1em"></div>

MariaDB
1. Install mariadb
<div style="background:#ddd;padding-left:1em">zypper install mariadb mariadb-tools</div>

2. Security setting
<div style="background:#ddd;padding-left:1em">mysql_secure_installation</div>
(all "yes" is preferred)

3. Enable auto-start on boot
<div style="background:#ddd;padding-left:1em">chkconfig -a mysql</div>

References:
<a href=http://mepopedia.com/forum/read.php?135,76348>Install a LAPP server: openSUSE 42 / Apahce 2.4/PostgreSQL 9.4/ PHP 5.6</a>
<a href=https://www.howtoforge.com/tutorial/how-to-install-postgresql-and-phppgadmin-on-opensuse-leap-42.1/>How to Install PostgreSQL and phpPgAdmin on OpenSUSE Leap 42.1</a>
<a href=http://httpd.apache.org/docs/2.4/mod/prefork.html>Apache MPM prefork</a>
<a href=http://httpd.apache.org/docs/2.4/mod/mpm_common.html>Apache MPM Common Directives</a>

Changed By: HP
Change Date: March 03, 2019 02:20AM

Install a LAPP Stack (Apache 2.4/PHP 7/PostgreSQL 10) on openSUSE Tumbleweed

Assume the Tumbleweed linux is ready.

<center>I. Database </center>Install the database first (PostgreSQL 10):

1. Install database
<div style="background:#ddd;padding-left:1em">zypper install postgresql10 postgresql10-contrib postgresql10-server</div>

2. Enable auto-start on boot
<div style="background:#ddd;padding-left:1em">chkconfig -a postgresql</div>

3. Start PostgreSQL
<div style="background:#ddd;padding-left:1em">systemctl start postgresql.service</div>

4. Set password for postgres
Switch user to postgres:
<div style="background:#ddd;padding-left:1em">su postgres
psql</div>
In the psql console, set the password:
<div style="background:#ddd;padding-left:1em">\password postgres</div>

5. Fine-tune performance
(1) Edit postgresql.conf
<div style="background:#ddd;padding-left:1em">vi /var/lib/pgsql/data/postgresql.conf</div>
(2) Performance fine-tuning
Set parameters
<div style="background:#ddd;padding-left:1em">shared_buffers = 4GB
work_mem = 32MB
effective_cache_size = 8GB</div>

<b>shared_buffers</b>: 1/4 of total memory is a reasonable starting value
<b>effective_cache_size</b>: 1/2 of total memory would be a normal setting

<div style="text-align:center">II. Web Server</div>
1. Install apache2
<div style="background:#ddd;padding-left:1em">zypper install apache2</div>

2. Add commonly-used modules
Add modules:
<div style="background:#ddd;padding-left:1em">a2enmod php7</div>
<div style="background:#ddd;padding-left:1em">a2enmod rewrite</div>
<div style="background:#ddd;padding-left:1em">a2enmod headers</div>
List apache loaded modules:
<div style="background:#ddd;padding-left:1em">apachectl -M</div>

3. Enable auto-start on boot
<div style="background:#ddd;padding-left:1em">chkconfig -a apache2</div>

4. Edit <b>default-server.conf </b> (/etc/apache2)
(1) Edit DocumentRoot to your own default websidte directory.
(e.g. DocumentRoot "/home/yoursite").
(2) Edit the <Directory> right below DocumentRoot.
(3) Add /Append the following directives:
<div style="background:#ddd;padding-left:1em">ServerName website.com</div>
<div style="background:#ddd;padding-left:1em">ExtendedStatus On</div>
<div style="background:#ddd;padding-left:1em">TraceEnable Off</div>
<div style="background:#ddd;padding-left:1em">AddType image/x-icon .ico</div>

5. Modify server-tuning.conf (/etc/apache2)
(1) Raise <i>StartServers</i> if necessary
(2) Raise <i>MaxSpareServers</i> if necessary
(3) Raise <i>ServerLimit</i> if necessary
(4) Raise <i>MaxClients</i> if necessary

<div style="text-align:center">II. Hypertext Preprocessor</div>
1. Install php7
<div style="background:#ddd;padding-left:1em">zypper install php7 php7-pgsql</div>

2. Install commonly-used modules
<div style="background:#ddd;padding-left:1em">zypper install php7-gd php7-mbstring php7-openssl php7-zlib</div>

<div style="background:#ddd;padding-left:1em"></div>
<div style="background:#ddd;padding-left:1em"></div>

References:
<a href=http://mepopedia.com/forum/read.php?135,76348>Install a LAPP server: openSUSE 42 / Apahce 2.4/PostgreSQL 9.4/ PHP 5.6</a>
<a href=https://www.howtoforge.com/tutorial/how-to-install-postgresql-and-phppgadmin-on-opensuse-leap-42.1/>How to Install PostgreSQL and phpPgAdmin on OpenSUSE Leap 42.1</a>
<a href=http://httpd.apache.org/docs/2.4/mod/prefork.html>Apache MPM prefork</a>
<a href=http://httpd.apache.org/docs/2.4/mod/mpm_common.html>Apache MPM Common Directives</a>

Changed By: HP
Change Date: March 03, 2019 12:04AM

Install a LAPP Stack (Apache 2.4/PHP 7/PostgreSQL 10) on openSUSE Tumbleweed

Assume the Tumbleweed linux is ready.

<center>I. Database </center>Install the database first (PostgreSQL 10):

1. Install database
<div style="background:#ddd;padding-left:1em">zypper install postgresql10 postgresql10-contrib postgresql10-server</div>

2. Enable auto-start on boot
<div style="background:#ddd;padding-left:1em">chkconfig -a postgresql</div>

3. Start PostgreSQL
<div style="background:#ddd;padding-left:1em">systemctl start postgresql.service</div>

4. Set password for postgres
Switch user to postgres:
<div style="background:#ddd;padding-left:1em">su postgres
psql</div>
In the psql console, set the password:
<div style="background:#ddd;padding-left:1em">\password postgres</div>

5. Fine-tune performance
(1) Edit postgresql.conf
<div style="background:#ddd;padding-left:1em">vi /var/lib/pgsql/data/postgresql.conf</div>
(2) Performance fine-tuning
<div style="background:#ddd;padding-left:1em">shared_buffers = 4GB
work_mem = 32MB
effective_cache_size = 8GB</div>

<b>shared_buffers</b>: 1/4 of total memory is a reasonable starting value
<b>effective_cache_size</b>: 1/2 of total memory would be a normal setting

<div style="text-align:center">II. Web Server</div>
1. Install apache2
<div style="background:#ddd;padding-left:1em">zypper install apache2</div>

2. Add commonly-used modules
Add modules:
<div style="background:#ddd;padding-left:1em">a2enmod php7</div>
<div style="background:#ddd;padding-left:1em">a2enmod rewrite</div>
<div style="background:#ddd;padding-left:1em">a2enmod headers</div>
List apache loaded modules:
<div style="background:#ddd;padding-left:1em">apachectl -M</div>

3. Enable auto-start on boot
<div style="background:#ddd;padding-left:1em">chkconfig -a apache2</div>

4. Edit default-server.conf (/etc/apache2)
(1) Edit DocumentRoot to your own default websidte directory.
(2) Edit the <Directory> right below DocumentRoot.
(3) Add the following directives:
<div style="background:#ddd;padding-left:1em">ServerName website.com</div>
<div style="background:#ddd;padding-left:1em">ExtendedStatus On</div>
<div style="background:#ddd;padding-left:1em">TraceEnable Off</div>
<div style="background:#ddd;padding-left:1em">AddType image/x-icon .ico</div>

4. 5. Modify server-tuning.conf (/etc/apache2)
(1) Raise <i>StartServers</i> if necessary
(2) Raise <i>MaxSpareServers</i> if necessary
(3) Raise <i>ServerLimit</i> if necessary
(4) Raise <i>MaxClients</i> if necessary

<div style="text-align:center">II. Hypertext Preprocessor</div>
1. Install php7
<div style="background:#ddd;padding-left:1em">zypper install php7 php7-pgsql</div>

2. Install commonly-used modules
<div style="background:#ddd;padding-left:1em">zypper install php7-gd php7-mbstring php7-openssl php7-zlib</div>

<div style="background:#ddd;padding-left:1em"></div>
<div style="background:#ddd;padding-left:1em"></div>

References:
<a href=http://mepopedia.com/forum/read.php?135,76348>Install a LAPP server: openSUSE 42 / Apahce 2.4/PostgreSQL 9.4/ PHP 5.6</a>
<a href=https://www.howtoforge.com/tutorial/how-to-install-postgresql-and-phppgadmin-on-opensuse-leap-42.1/>How to Install PostgreSQL and phpPgAdmin on OpenSUSE Leap 42.1</a>
<a href=http://httpd.apache.org/docs/2.4/mod/prefork.html>Apache MPM prefork</a>
<a href=http://httpd.apache.org/docs/2.4/mod/mpm_common.html>Apache MPM Common Directives</a>

Changed By: HP
Change Date: March 02, 2019 08:11PM

Install a LAPP Stack (Apache 2.4/PHP 7/PostgreSQL 10) on openSUSE Tumbleweed

Assume the Tumbleweed linux is ready.

<center>I. Database </center>Install the database first (PostgreSQL 10):

1. Install database
<div style="background:#ddd;padding-left:1em">zypper install postgresql10 postgresql10-contrib postgresql10-server</div>

2. Enable auto-start on boot
<div style="background:#ddd;padding-left:1em">chkconfig -a postgresql</div>

3. Start PostgreSQL
<div style="background:#ddd;padding-left:1em">systemctl start postgresql.service</div>

4. Set password for postgres
Switch user to postgres:
<div style="background:#ddd;padding-left:1em">su postgres
psql</div>
In the psql console, set the password:
<div style="background:#ddd;padding-left:1em">\password postgres</div>

5. Fine-tune performance
(1) Edit postgresql.conf
<div style="background:#ddd;padding-left:1em">vi /var/lib/pgsql/data/postgresql.conf</div>
(2) Performance fine-tuning
<div style="background:#ddd;padding-left:1em">shared_buffers = 4GB
work_mem = 32MB
effective_cache_size = 8GB</div>

<b>shared_buffers</b>: 1/4 of total memory is a reasonable starting value
<b>effective_cache_size</b>: 1/2 of total memory would be a normal setting

<div style="text-align:center">II. Web Server</div>
1. Install apache2
<div style="background:#ddd;padding-left:1em">zypper install apache2</div>

2. Add commonly-used modules
Add modules:
<div style="background:#ddd;padding-left:1em">a2enmod php7</div>
<div style="background:#ddd;padding-left:1em">a2enmod rewrite</div>
<div style="background:#ddd;padding-left:1em">a2enmod headers</div>
List apache loaded modules:
<div style="background:#ddd;padding-left:1em">apachectl -M</div>

3. Edit default-server.conf (/etc/apache2)
(1) Edit DocumentRoot to your own default websidte directory.
(2) Edit the <Directory> right below DocumentRoot.
(3) Add the following directives:
<div style="background:#ddd;padding-left:1em">ServerName website.com</div>
<div style="background:#ddd;padding-left:1em">ExtendedStatus On</div>
<div style="background:#ddd;padding-left:1em">TraceEnable Off</div>
<div style="background:#ddd;padding-left:1em">AddType image/x-icon .ico</div>

4. Modify server-tuning.conf (/etc/apache2)
(1) Raise <i>StartServers</i> if necessary
(2) Raise <i>MaxSpareServers</i> if necessary
(3) Raise <i>ServerLimit</i> if necessary
(4) Raise <i>MaxClients</i> if necessary

<div style="text-align:center">II. Hypertext Preprocessor</div>
1. Install php7
<div style="background:#ddd;padding-left:1em">zypper install php7 php7-pgsql</div>

2. Install commonly-used modules
<div style="background:#ddd;padding-left:1em">zypper install php7-gd php7-mbstring php7-openssl php7-zlib</div>

<div style="background:#ddd;padding-left:1em"></div>
<div style="background:#ddd;padding-left:1em"></div>

References:
<a href=http://mepopedia.com/forum/read.php?135,76348>Install a LAPP server: openSUSE 42 / Apahce 2.4/PostgreSQL 9.4/ PHP 5.6</a>
<a href=https://www.howtoforge.com/tutorial/how-to-install-postgresql-and-phppgadmin-on-opensuse-leap-42.1/>How to Install PostgreSQL and phpPgAdmin on OpenSUSE Leap 42.1</a>
<a href=http://httpd.apache.org/docs/2.4/mod/prefork.html>Apache MPM prefork</a>
<a href=http://httpd.apache.org/docs/2.4/mod/mpm_common.html>Apache MPM Common Directives</a>

Changed By: mepoadm
Change Date: March 02, 2019 06:01PM

Install a LAPP Stack (Apache 2.4/PHP 7/PostgreSQL 10) on openSUSE Tumbleweed

Assume the Tumbleweed linux is ready.

<center>I. Database </center>Install the database first (PostgreSQL 10):

1. Install database
<div style="background:#ddd;padding-left:1em">zypper install postgresql10 postgresql10-contrib postgresql10-server</div>

2. Enable auto-start on boot
<div style="background:#ddd;padding-left:1em">chkconfig -a postgresql</div>

3. Start PostgreSQL
<div style="background:#ddd;padding-left:1em">systemctl start postgresql.service</div>

4. Set password for postgres
Switch user to postgres:
<div style="background:#ddd;padding-left:1em">su postgres
psql</div>
In the psql console, set the password:
<div style="background:#ddd;padding-left:1em">\password postgres</div>

<div style="text-align:center">II. Web Server</div>
1. Install apache2
<div style="background:#ddd;padding-left:1em">zypper install apache2</div>

2. Add commonly-used modules
Add modules:
<div style="background:#ddd;padding-left:1em">a2enmod php7</div>
<div style="background:#ddd;padding-left:1em">a2enmod rewrite</div>
<div style="background:#ddd;padding-left:1em">a2enmod headers</div>
List apache loaded modules:
<div style="background:#ddd;padding-left:1em">apachectl -M</div>

3. Edit default-server.conf (/etc/apache2)
(1) Edit DocumentRoot to your own default websidte directory.
(2) Edit the <Directory> right below DocumentRoot.
(3) Add the following directives:
<div style="background:#ddd;padding-left:1em">ServerName website.com</div>
<div style="background:#ddd;padding-left:1em">ExtendedStatus On</div>
<div style="background:#ddd;padding-left:1em">TraceEnable Off</div>
<div style="background:#ddd;padding-left:1em">AddType image/x-icon .ico</div>

4. Modify server-tuning.conf (/etc/apache2)
(1) Raise <i>StartServers</i> if necessary
(2) Raise <i>MaxSpareServers</i> if necessary
(3) Raise <i>ServerLimit</i> if necessary
(4) Raise <i>MaxClients</i> if necessary

<div style="text-align:center">II. Hypertext Preprocessor</div>
1. Install php7
<div style="background:#ddd;padding-left:1em">zypper install php7 php7-pgsql</div>

2. Install commonly-used modules
<div style="background:#ddd;padding-left:1em">zypper install php7-gd php7-mbstring php7-openssl php7-zlib</div>

<div style="background:#ddd;padding-left:1em"></div>
<div style="background:#ddd;padding-left:1em"></div>

References:
<a href=http://mepopedia.com/forum/read.php?135,76348>Install a LAPP server: openSUSE 42 / Apahce 2.4/PostgreSQL 9.4/ PHP 5.6</a>
<a href=https://www.howtoforge.com/tutorial/how-to-install-postgresql-and-phppgadmin-on-opensuse-leap-42.1/>How to Install PostgreSQL and phpPgAdmin on OpenSUSE Leap 42.1</a>
<a href=http://httpd.apache.org/docs/2.4/mod/prefork.html>Apache MPM prefork</a>
<a href=http://httpd.apache.org/docs/2.4/mod/mpm_common.html>Apache MPM Common Directives</a>

Changed By: mepoadm
Change Date: February 28, 2019 10:59PM

Install a LAPP Stack (Apache 2.4/PHP 7/PostgreSQL 10) on openSUSE Tumbleweed

Assume the Tumbleweed linux is ready.

<center>I. Database </center>Install the database first (PostgreSQL 10):

1. Install database
<div style="background:#ddd;padding-left:1em">zypper install postgresql10 postgresql10-contrib postgresql10-server</div>

2. Enable auto-start on boot
<div style="background:#ddd;padding-left:1em">chkconfig -a postgresql</div>

3. Start PostgreSQL
<div style="background:#ddd;padding-left:1em">systemctl start postgresql.service</div>

4. Set password for postgres
Switch user to postgres:
<div style="background:#ddd;padding-left:1em">su postgres
psql</div>
In the psql console, set the password:
<div style="background:#ddd;padding-left:1em">\password postgres</div>

<div style="text-align:center">II. Web Server</div>
1. Install apache2
<div style="background:#ddd;padding-left:1em">zypper install apache2</div>

2. Add commonly-used modules
Add modules:
<div style="background:#ddd;padding-left:1em">a2enmod php</div>
<div style="background:#ddd;padding-left:
<b>>a2enmod rewrit </b> v>
<div style="background:#ddd;padding-left:1em">a2<b>od headers</div>
List </b> he loaded modules:
<div style="background:#dd
(conservative)
em">apachectl -M</div>

3. Edit default-server.conf (/etc/apache2)
(1) Edit DocumentRoot to your own default websidte directory.
(2) Edit the <Directory> right below DocumentRoot.
(3) Add the following directives:
<div style="background:#ddd;padding-left:1em">ServerName website.com</div>
<div style="background:#ddd;padding-left:1em">ExtendedStatus On</div>
<div style="background:#ddd;padding-left:1em">TraceEnable Off</div>
<div style="background:#ddd;padding-left:1em">AddType image/x-icon .ico</div>

4. Modify server-tuning.conf (/etc/apache2)
(1) Raise <i>StartServers</i> if necessary
(2) Raise <i>MaxSpareServers</i> if necessary
(3) Raise <i>ServerLimit</i> if necessary
(4) Raise <i>MaxClients</i> if necessary

<div style="text-align:center">II. Hypertext Preprocessor</div>
1. Install php7
<div style="background:#ddd;padding-left:1em">zypper install php7 php7-pgsql</div>

2. Install commonly-used modules
<div style="background:#ddd;padding-left:1em">zypper install php7-gd php7-mbstring php7-zlib</div>

<div style="background:#ddd;padding-left:1em"></div>
<div style="background:#ddd;padding-left:1em"></div>

References:
<a href=http://mepopedia.com/forum/read.php?135,76348>Install a LAPP server: openSUSE 42 / Apahce 2.4/PostgreSQL 9.4/ PHP 5.6</a>
<a href=https://www.howtoforge.com/tutorial/how-to-install-postgresql-and-phppgadmin-on-opensuse-leap-42.1/>How to Install PostgreSQL and phpPgAdmin on OpenSUSE Leap 42.1</a>
<a href=http://httpd.apache.org/docs/2.4/mod/prefork.html>Apache MPM prefork</a>
<a href=http://httpd.apache.org/docs/2.4/mod/mpm_common.html>Apache MPM Common Directives</a>

Changed By: mepoadm
Change Date: February 28, 2019 10:58PM

Install a LAPP Stack (Apache 2.4/PHP 7/PostgreSQL 10) on openSUSE Tumbleweed

Assume the Tumbleweed linux is ready.

<center>I. Database </center>Install the database first (PostgreSQL 10):

1. Install database
<div style="background:#ddd;padding-left:1em">zypper install postgresql10 postgresql10-contrib postgresql10-server</div>

2. Enable auto-start on boot
<div style="background:#ddd;padding-left:1em">chkconfig -a postgresql</div>

3. Start PostgreSQL
<div style="background:#ddd;padding-left:1em">systemctl start postgresql.service</div>

4. Set password for postgres
Switch user to postgres:
<div style="background:#ddd;padding-left:1em">su postgres
psql</div>
In the psql console, set the password:
<div style="background:#ddd;padding-left:1em">\password postgres</div>

5. Modify performance parameters
(1) Edit postgresql.conf
<div style="background:#ddd;padding-left:1em">vi /var/lib/pgsql/data/postgresql.conf</div>
(2) Performance fine-tuning
<div style="background:#ddd;padding-left:1em">shared_buffers = 4GB
work_mem = 32MB
effective_cache_size = 8GB</div>
shared_buffers: 1/4 of total memory is a reasonable starting value
effective_cache_size: 1/2 of total memory would be a normal setting
em">apachectl -M</div>

3. Edit default-server.conf (/etc/apache2)
(1) Edit DocumentRoot to your own default websidte directory.
(2) Edit the <Directory> right below DocumentRoot.
(3) Add the following directives:
<div style="background:#ddd;padding-left:1em">ServerName website.com</div>
<div style="background:#ddd;padding-left:1em">ExtendedStatus On</div>
<div style="background:#ddd;padding-left:1em">TraceEnable Off</div>
<div style="background:#ddd;padding-left:1em">AddType image/x-icon .ico</div>

4. Modify server-tuning.conf (/etc/apache2)
(1) Raise <i>StartServers</i> if necessary
(2) Raise <i>MaxSpareServers</i> if necessary
(3) Raise <i>ServerLimit</i> if necessary
(4) Raise <i>MaxClients</i> if necessary

<div style="text-align:center">II. Hypertext Preprocessor</div>
1. Install php7
<div style="background:#ddd;padding-left:1em">zypper install php7 php7-pgsql</div>

2. Install commonly-used modules
<div style="background:#ddd;padding-left:1em">zypper install php7-gd php7-mbstring php7-zlib</div>

<div style="background:#ddd;padding-left:1em"></div>
<div style="background:#ddd;padding-left:1em"></div>

References:
<a href=http://mepopedia.com/forum/read.php?135,76348>Install a LAPP server: openSUSE 42 / Apahce 2.4/PostgreSQL 9.4/ PHP 5.6</a>
<a href=https://www.howtoforge.com/tutorial/how-to-install-postgresql-and-phppgadmin-on-opensuse-leap-42.1/>How to Install PostgreSQL and phpPgAdmin on OpenSUSE Leap 42.1</a>
<a href=http://httpd.apache.org/docs/2.4/mod/prefork.html>Apache MPM prefork</a>
<a href=http://httpd.apache.org/docs/2.4/mod/mpm_common.html>Apache MPM Common Directives</a>

Changed By: HP
Change Date: February 27, 2019 09:54PM

Install a LAPP Stack (Apache 2.4/PHP 7/PostgreSQL 10) on openSUSE Tumbleweed

Assume the Tumbleweed linux is ready.

<center>I. Database </center>Install the database first (PostgreSQL 10):

1. Install database
<div style="background:#ddd;padding-left:1em">zypper install postgresql10 postgresql10-contrib postgresql10-server</div>

2. Enable auto-start on boot
<div style="background:#ddd;padding-left:1em">chkconfig -a postgresql</div>

3. Start PostgreSQL
<div style="background:#ddd;padding-left:1em">systemctl start postgresql.service</div>

4. Set password for postgres
Switch user to postgres:
<div style="background:#ddd;padding-left:1em">su postgres
psql</div>
In the psql console, set the password:
<div style="background:#ddd;padding-left:1em">\password postgres</div>
em">apachectl -M</div>

3. Edit default-server.conf (/etc/apache2)
(1) Edit DocumentRoot to your own default websidte directory.
(2) Edit the <Directory> right below DocumentRoot.
(3) Add the following directives:
<div style="background:#ddd;padding-left:1em">ServerName website.com</div>
<div style="background:#ddd;padding-left:1em">ExtendedStatus On</div>
<div style="background:#ddd;padding-left:1em">TraceEnable Off</div>
<div style="background:#ddd;padding-left:1em">AddType image/x-icon .ico</div>

4. Modify server-tuning.conf (/etc/apache2)
(1) Raise <i>StartServers</i> if necessary
(2) Raise <i>MaxSpareServers</i> if necessary
(3) Raise <i>ServerLimit</i> if necessary
(4) Raise <i>MaxClients</i> if necessary

<div style="text-align:center">II. Hypertext Preprocessor</div>
1. Install php7
<div style="background:#ddd;padding-left:1em">zypper install php7 php7-pgsql</div>

2. Install commonly-used modules
<div style="background:#ddd;padding-left:1em">zypper install php7-gd php7-mbstring php7-zlib</div>

<div style="background:#ddd;padding-left:1em"></div>
<div style="background:#ddd;padding-left:1em"></div>

References:
<a href=http://mepopedia.com/forum/read.php?135,76348>Install a LAPP server: openSUSE 42 / Apahce 2.4/PostgreSQL 9.4/ PHP 5.6</a>
<a href=https://www.howtoforge.com/tutorial/how-to-install-postgresql-and-phppgadmin-on-opensuse-leap-42.1/>How to Install PostgreSQL and phpPgAdmin on OpenSUSE Leap 42.1</a>
<a href=http://htt php7-zliborg/docs/2.4/mod/prefork.html>Apache MPM prefork</a>
<a href=http://httpd.apache.org/docs/2.4/mod/mpm_common.html>Apache MPM Common Directives</a>

Changed By: HP
Change Date: February 26, 2019 08:13AM

Install a LAPP Stack (Apache 2.4/PHP 7/PostgreSQL 10) on openSUSE Tumbleweed

Assume the Tumbleweed linux is ready.

<center>I. Database </center>Install the database first (PostgreSQL 10):

1. Install database
<div style="background:#ddd;padding-left:1em">zypper install postgresql10 postgresql10-contrib postgresql10-server</div>

2. Enable auto-start on boot
<div style="background:#ddd;padding-left:1em">chkconfig -a postgresql</div>

3. Start PostgreSQL
<div style="background:#ddd;padding-left:1em">systemctl start postgresql.service</div>

4. Set password for postgres
Switch user to postgres:
<div style="background:#ddd;padding-left:1em">su postgres
psql</div>
In the psql console, set the password:
<div style="background:#ddd;padding-left:1em">\password postgres</div>
em">apachectl -M</div>

3. Edit default-server.conf (/etc/apache2)
(1) Edit DocumentRoot to your own default websidte directory.
(2) Edit the <Directory> right below DocumentRoot.
(3) Add the following directives:
<div style="background:#ddd;padding-left:1em">ServerName website.com</div>
<div style="background:#ddd;padding-left:1em">ExtendedStatus On</div>
<div style="background:#ddd;padding-left:1em">TraceEnable Off</div>
<div style="background:#ddd;padding-left:1em">AddType image/x-icon .ico</div>

4. Modify server-tuning.conf (/etc/apache2)
(1) Raise <i>StartServers</i> if necessary
(2) Raise <i>MaxSpareServers</i> if necessary
(3) Raise <i>ServerLimit</i> if necessary
(4) Raise <i>MaxClients</i> if necessary

<div style="text-align:center">II. Hypertext Preprocessor</div>
1. Install php7
<div style="background:#ddd;padding-left:1em">zypper install php7 php7-pgsql</div>

2. Install commonly-used modules
<div style="background:#ddd;padding-left:1em">zypper install php7-gd php7-mbstring php7-zlib</div>

<div style="background:#ddd;padding-left:1em"></div>
<div style="background:#ddd;padding-left:1em"></div>

References:
<a href=http://mepopedia.com/forum/read.php?135,76348>Install a LAPP server: openSUSE 42 / Apahce 2.4/PostgreSQL 9.4/ PHP 5.<div style="background:#ddd;padding-left:1em">zypper install php7 php7-pgsql php7-mbstring</div>

<div style="background:#ddd;padding-left:1em">zypper install php7 php7-pgsql</div>

2. Install commonly-used modules
<div style="background:#ddd;padding-left:1em">zypper install php7-gd php7-mbstring</div>
s/2.4/mod/prefork.html>Apache MPM prefork</a>
<a href=http://httpd.apache.org/docs/2.4/mod/mpm_common.html>Apache MPM Common Directives</a>

Changed By: HP
Change Date: February 25, 2019 01:04AM

Install a LAPP Stack (Apache 2.4/PHP 7/PostgreSQL 10) on openSUSE Tumbleweed

Assume the Tumbleweed linux is ready.

<center>I. Database </center>Install the database first (PostgreSQL 10):

1. Install database
<div style="background:#ddd;padding-left:1em">zypper install postgresql10 postgresql10-contrib postgresql10-server</div>

2. Enable auto-start on boot
<div style="background:#ddd;padding-left:1em">chkconfig -a postgresql</div>

3. Start PostgreSQL
<div style="background:#ddd;padding-left:1em">systemctl start postgresql.service</div>

4. Set password for postgres
Switch user to postgres:
<div style="background:#ddd;padding-left:1em">su postgres
psql</div>
In the psql console, set the password:
<div style="background:#ddd;padding-left:1em">\password postgres</div>
em">apachectl -M</div>

3. Edit default-server.conf (/etc/apache2)
(1) Edit DocumentRoot to your own default websidte directory.
(2) Edit t2e <Directory> right below DocumentRoot.
(3) Add the following directives:
<div style="background:#ddd;padding-left:1em">ServerName website.com</div>
<div style="background:#ddd;pa<div style="background:#ddd;padding-left:1em">a2enmod headers</div>
padding-left:1em">TraceEnable Off</div>
<div style="background:#ddd;padding-left:1em">AddType image/x-icon .ico</div>

4. Modify server-tuning.conf (/etc/apache2)
(1) Raise <i>StartServers</i> if necessary
(2) Raise <i>MaxSpareServers</i> if necessary
(3) Raise <i>ServerLimit</i> if necessary
(4) Raise <i>MaxClients</i> if necessary

<div style="text-align:center">II. Hypertext Preprocessor</div>
1. Install php7
<div style="background:#ddd;padding-left:1em">zypper install php7 php7-pgsql</div>

2. Install commonly-used modules
<div style="background:#ddd;padding-left:1em">zypper install php7-gd php7-mbstring php7-zlib</div>

<div style="background:#ddd;padding-left:1em"></div>
<div style="background:#ddd;padding-left:1em"></div>

References:
<a href=http://mepopedia.com/forum/read.php?135,76348>Install a LAPP server: openSUSE 42 / Apahce 2.4/PostgreSQL 9.4/ PHP 5.<div style="background:#ddd;padding-left:1em">zypper install php7 php7-pgsql php7-mbstring</div>

s/2.4/mod/prefork.html>Apache MPM prefork</a>
<a href=http://httpd.apache.org/docs/2.4/mod/mpm_common.html>Apache MPM Common Directives</a>

Changed By: HP
Change Date: February 24, 2019 05:41PM

Install a LAPP Stack (Apache 2.4/PHP 7/PostgreSQL 10) on openSUSE Tumbleweed

Assume the Tumbleweed linux is ready.

<center>I. Database </center>Install the database first (PostgreSQL 10)
:

1. Install database
<div style="background:#ddd;padding-left:1em">zypper install postgresql10 postgresql10-contrib postgresql10-server</div>

2. Enable auto-start on boot
<div style="background:#ddd;padding-left:1em">chkconfig -a postgresql</div>

3. Start PostgreSQL
<div style="background:#ddd;padding-left:1em">systemctl start postgresql.service</div>

4. Set password for postgres
Switch user to postgres:
<div style="background:#ddd;padding-left:1em">su postgres
psql</div>
In the psql console, set the password:
<div style="background:#ddd;padding-left:1em">\password postgres</div>
e<div style="text-align:center">default-server
</div>
/etc/apache2)
(1) Edit DocumentRoot to your own default websidte directory.
(2) Edit te <Directory> right below DocumentRoot.
(3) Add the following directives:
<div style="background:#ddd;padding-left:1em">ServerName website.com</div>
<div style="background:#ddd;papadding-left:1em">TraceEnable Off</div>
<div style="background:#ddd;padding-left:1em">AddType image/x-icon .ico</div>

4. Modify server-tuning.conf (/etc/apache2)
(1) Raise <i>StartServers</i> if necessary
(2) Raise <i>MaxSpareServers</i> if necessary
(3) Raise <i>ServerLimit</i> if necessary
(4) Raise <i>MaxClients</i> if necessary

<div style="text-align:center">II. Hypertext Preprocessor</div>
1. Install php7
<div style="background:#ddd;padding-left:1em">zypper install php7 php7-pgsql</div>

2. Install commonly-used modules
<div style="background:#ddd;padding-left:1em"II. PHP
4. Modify server-tuning.conf (/etc/apache2)
(1) Raise <i>StartServers</i> if necessary
(2) Raise <i>MaxSpareServers</i> if necessary
(3) Raise <i>ServerLimit</i> if necessary
(4) Raise <i>MaxClients</i> if necessary

135,7style="text-align:center">II. Hypertext Preprocessor</div>
1. Install php7
<div style="background:#ddd;padding-left:1em">zypper install php7 php7-pgsql php7-mbstring</div>

s/2.4/mod/prefork.html>Apache MPM prefork</a>
<a href=http://httpd.apache.org/docs/2.4/mod/mpm_common.html>Apache MPM Common Directives</a>
<a href=http://httpd.apache.org/docs/2.4/mod/prefork.html>Apache MPM prefork</a>
<a href=http://httpd.apache.org/docs/2.4/mod/mpm_common.html>Apache MPM Common Directives</a>

Changed By: HP
Change Date: February 24, 2019 10:48AM

Install a LAPP Stack (Apache 2.4/PHP 7/PostgreSQL 10) on openSUSE Tumbleweed

Assume the Tumbleweed linux is ready.

I. Install the database first (PostgreSQL 10)
1. Install database
<div style="background:#ddd;padding-left:1em">zypper install postgresql10 postgresql10-contrib postgresql10-server</div>

2. Enable auto-start on boot
<div style="background:#ddd;padding-left:1em">chkconfig -a postgresql</div>

3. Start PostgreSQL
<div style="background:#ddd;padding-left:1em">systemctl start postgresql.service</div>

4. Set password for postgres
Switch user to postgres:
<div style="background:#ddd;padding-left:1em">su postgres
psql</div>
In the psql console, set the password:
<div style="background:#ddd;padding-left:1em">\password postgres</div>
edefault-server
/etc/apache2)
(1) Edit DocumentRoot to your own default websidte directory.
(2) Edit te <Directory> right below DocumentRoot.
(3) Add the following directives:
<div style="background:#ddd;padding-left:1em">ServerName website.com</div>
<div style="background:#ddd;papadding-left:1em">TraceEnable Off</div>
<div style="background:#ddd;padding-left:1em">AddType 3. Edit default-server.conf (/etc/apache2)
(1) Edit DocumentRoot to your own default websidte directory.
(2) Edit the <Directory> right below DocumentRoot.
(3) Add the following directives:
<div style="background:#ddd;padding-left:1em">ServerName website.com</div>
<div style="background:#ddd;padding-left:1em">ExtendedStatus On</div>
<div style="background:#ddd;padding-left:1em">TraceEnable Off</div>
<div style="background:#ddd;padding-left:1em">AddType image/x-icon .ico</div>

II. PHP
135,7style="background:#ddd;padding-left:1em">zypper install php7 php7-pgsql</div>

s<div style="background:#ddd;padding-left:1em"></div>
/2.4/mod/prefork.html>Apache MPM prefork</a>
<a href=http://httpd.apache.org/docs/2.4/mod/mpm_common.html>Apache MPM Common Directives</a>

Changed By: HP
Change Date: February 02, 2019 11:17PM

Install a LAPP Stack (Apache 2.4/PHP 7/PostgreSQL 10) on openSUSE Tumbleweed

Assume the Tumbleweed linux is ready.

I. Install the database first (PostgreSQL 10)
1. Install database
<div style="background:#ddd;padding-left:1em">zypper install postgresql10 postgresql10-contrib postgresql10-server</div>

2. Enable auto-start on boot
<div style="background:#ddd;padding-left:1em">chkconfig -a postgresql</div>

3. Start PostgreSQL
<div style="background:#ddd;padding-left:1em">systemctl start postgresql.service</div>

4. Set password for postgres
Switch user to postgres:
<div style="background:#ddd;padding-left:1em">su postgres
psql</div>
In the psql console, set the password:
<div style="background:#ddd;padding-left:1em">\password postgres</div>
edefault-server
/etc/apache2)
(1) Edit DocumentRoot to your own default websidte directory.
(2) Edit te <Directory> right below DocumentRoot.
(3) Add the following directives:
<div style="background:#ddd;padding-left:1em">ServerName website.com</div>
<div style="background:#ddd;papadding-left:1em">TraceEnable Off</div>
<div style="background:#ddd;padding-left:1em">AddType II. PHP
135,7style="background:#ddd;padding-left:1em">zypper install php7 php7-pgsql</div>

s<div style="background:#ddd;padding-left:1em"></div>
/2.4/mod/prefork.html>Apache MPM prefork</a>
<a href=http://httpd.apache.org/docs/2.4/mod/mpm_common.html

References:
<a href=http://mepopedia.com/forum/read.php?135,76348>Install a LAPP server: openSUSE 42 / Apahce 2.4/PostgreSQL 9.4/ PHP 5.6</a>
<a href=https://www.howtoforge.com/tutorial/how-to-install-postgresql-and-phppgadmin-on-opensuse-leap-42.1/>How to Install PostgreSQL and phpPgAdmin on OpenSUSE Leap 42.1</a>

Changed By: HP
Change Date: February 02, 2019 11:13PM

Install a LAPP Stack (Apache 2.4/PHP 7/PostgreSQL 10) on openSUSE Tumbleweed

Assume the Tumbleweed linux is ready.

I. Install the database first (PostgreSQL 10)
1. Install database
<div style="background:#ddd;padding-left:1em">zypper install postgresql10 postgresql10-contrib postgresql10-server</div>

2. Enable auto-start on boot
<div style="background:#ddd;padding-left:1em">chkconfig -a postgresql</div>

3. Start PostgreSQL
<div style="background:#ddd;padding-left:1em">systemctl start postgresql.service</div>

4. Set password for postgres
Switch user to postgres
:
<div style="background:#ddd;padding-left:1em">su postgres
psql</div>
In the psql console, set the password:
<div style="background:#ddd;padding-left:1em">\password postgres</div>
edefault-server
/etc/apache2)
(1) Edit DocumentRoot to your own default websidte directory.
(2) Edit te <Directory> righly-used DocumentAdd modules:
the following directives:
<div style="background:#ddd;padding-left:1em">ServerName website.com</div>
<div style="background:#ddd;paList apache loaded modules:
<div style="background:#ddd;padding-left:1em">apachectl -M</div>
II. PHP
135,7style="background:#ddd;padding-left:1em">zypper install php7 php7-pgsql</div>

s<div style="background:#ddd;padding-left:1em"></div>
/2.4/mod/prefork.html>Apache MPM prefork</a>
<a href=http://httpd.apache.org/docs/2.4/mod/mpm_common.html

Changed By: HP
Change Date: February 02, 2019 11:11PM

Install a LAPP Stack (Apache 2.4/PHP 7/PostgreSQL 10) on openSUSE Tumbleweed

Assume the Tumbleweed linux is ready.

I. Install the database first (PostgreSQL 10)
1. Install database
<div style="background:#ddd;padding-left:1em">zypper install postgresql10 postgresql10-contrib postgresql10-server</div>

2. Enable auto-start on boot
<div style="background:#ddd;padding-left:1em">chkconfig -a postgresql</div>

3. Start PostgreSQL
<div style="background:#ddd;padding-left:1em">systemctl start postgresql.service</div>

4. Set password for postgres
Switch user to postgres
<div style="background:#ddd;padding-left:1em">su postgres
psql</div>
In the psql console, set the password:
<div style="background:#ddd;padding-left:1em">\password postgres</div>
eII. Web Server
1. Install apache2
<div style="background:#ddd;padding-left:1em">zypper install apache</div>

2. Add common modules
<div style="background:#ddd;padding-left:1em">a2enmod php</div>
<div style="background:#ddd;padding-left:1em">a2enmod rewrite</div>

II. PHP
<div style="background:#ddd;padding-left:1em">zypper install php7 php7-pgsql</div>

s<div style="background:#ddd;padding-left:1em"></div>
/2.4/mod/prefork.html>Apache MPM prefork</a>
<a href=http://httpd.apache.org/docs/2.4/mod/mpm_common.html

Original Message

作者: HP
Date: February 02, 2019 09:12PM

Install a LAPP Stack (Apache 2.4/PHP 7/PostgreSQL 10) on openSUSE Tumbleweed

Assume the Tumbleweed linux is ready.

I. Install the database first (PostgreSQL 10)
1. Install database

zypper install postgresql10 postgresql10-contrib postgresql10-server

2. Enable auto-start on boot

chkconfig -a postgresql

3. Start PostgreSQL

systemctl start postgresql.service

4. Set password for postgres

su postgres
psql

In the psql console, set the password:

\password postgres

e
s

/2.4/mod/prefork.html>Apache MPM prefork

Change History

Original Message