Alpine Linux - User contributions [en]

Zabbix - cgi and mysql

2016-06-28T05:32:47Z

ZavNDW: /* Install Zabbix */

The purpose of this document is to assist in installing the Zabbix server software and Zabbix agent on the Alpine Linux operating system. Instructions on how to configure and use Zabbix - as well as many useful tutorials - can be found at http://www.zabbix.com.

{{Note|The minimum required version of Alpine Linux required to install Zabbix is Alpine 2.2.}}

= Install Lighttpd, and PHP =

{{:Setting Up Lighttpd With FastCGI}}

= Configure PostgreSQL =

Install PostgreSQL

{{Cmd|apk add postgresql postgresql-client}}

Now configure PostgreSQL:
{{Cmd|/etc/init.d/postgresql setup
/etc/init.d/postgresql start
rc-update add postgresql}}

= Install Zabbix =

{{Cmd|apk add zabbix zabbix-pgsql zabbix-webif zabbix-setup}}

Now we need to set up the zabbix database. Substitute '*********' in the example below for a real password:

{{Cmd|<nowiki>psql –U postgres
postgres=# create user zabbix with password '*********';
postgres=# create database zabbix owner zabbix;
postgres=# \q
cd /usr/share/zabbix/database/postgresql
cat postgresql.sql | psql -U zabbix zabbix
cd ..
cd data/
cat data.sql | psql -U zabbix zabbix
cat images_pgsql.sql | psql -U zabbix zabbix</nowiki>}}

Create a softlink for the Zabbix web-frontend files:

{{Cmd|rm /var/www/localhost/htdocs -R
ln -s /usr/share/webapps/zabbix /var/www/localhost/htdocs}}

Edit PHP configuration to satisfy some zabbix requirements. Edit /etc/php/php.ini and configure the following values at least:

<pre>
Max_execution_time = 600
Expose_php = off
Date.timezone = <insert your timezone here>
post_max_size = 32M
upload_max_filesize = 16M
max_input_time = 600
memory_limit = 256M
</pre>

Configure the following entries in /etc/zabbix/zabbix_server.conf, where DBPassword is the password chosen for the database above:

<pre>
DBName=zabbix

# Database user

DBUser=zabbix

# Database password
# Comment this line if no password used

DBPassword=*********

FpingLocation=/usr/sbin/fping
</pre>

Start Zabbix server:

{{Cmd|rc-update add zabbix-server
/etc/init.d/zabbix-server start}}

Fix permissions on conf directory.

{{Cmd|chown -R lighttpd /usr/share/webapps/zabbix/conf}}

You should now be able to browse to the Zabbix frontend: http://yourservername/.

or

You should now be able to browse to the Zabbix setup frontend: http://yourserverip/instal.php.

Follow the setup instructions to configure Zabbix, supplying the database information used above.

After setup, login using: Login name: '''Admin''' Password:'''zabbix'''. (as described at http://www.zabbix.com/documentation/1.8/manual/installation)

Finally, Zabbix requires special permissions to use the fping binary.

{{Cmd|chmod u+s /usr/sbin/fping}}

= Install Zabbix Agent on Monitored Servers =

Zabbix can monitor almost any operating system, including Alpine Linux hosts. Complete the following steps to install the Zabbix agent on Alpine Linux.

{{Note|Support to allow zabbix-agentd to view running processes on Alpine Linux has been added since linux-grsec-2.6.35.9-r2. Please ensure you have that kernel installed prior to attempting to run zabbix-agentd.}}

Ensure that the readproc group exists (support added since alpine-baselayout-2.0_rc1-r1), by adding the following line to /etc/group:

{{Cmd|readproc:x:30:zabbix}}

Install the agent package:

{{Cmd|apk add zabbix-agent}}

Edit the /etc/zabbix/zabbix_agentd.conf file and configure at least the following option:
<pre>
Server=<ip or hostname of zabbix server>
Hostname=<ip or hostname of zabbix agent>
ListenPort=10050
</pre>

Start the zabbix-agent:

{{Cmd|rc-update add zabbix-agentd
/etc/init.d/zabbix-agentd start}}

In case you want to monitor using SNMP agent on remote machines you have to add these packages on zabbix server:

{{Cmd|apk add net-snmp net-snmp-tools}}

And add these packages on remote machines:

{{Cmd|apk add net-snmp }}

= Optional: Crash course in adding hosts, checks, and notifications =

''Note:'' This is optional since it's not specific to Alpine Linux, but I wanted a couple notes for how to perform a simple check on a server that doesn't have the agent installed on it, and be notified on state changes.

Administration -> Media Types -> Email
* Setup server, helo, email from address

Administration -> Users
* Setup each user who'll get notified, make sure they have media type "Email" added with their address

Configuration -> Hosts -> Create host
* In Linux Servers hostgroup
* Define dns name, ip, connect by IP
* If the machine is a simple networking device that will only be monitored using SNMP, add it to Template_SNMPv2_Device, and you're done.

Configuration -> Templates -> Create template
* Give it a name (Template_Alpine_Linux_Infra_HTTP)
* In Templates group

Configuration -> Templates -> Template_Alpine_Linux_Infra_HTTP -> Items
* Create Item
* Host: Template_Alpine_Linux_Infra_HTTP
* Description: HTTP Basic Check
* Type: Simple_check
* Key: http,80

Configuration -> Templates -> Template_Alpine_Linux_Infra_HTTP -> Triggers
* Create Trigger
* Name: "HTTP Trigger"
* Expression: {Template_Alpine_Linux_Infra_HTTP:http,80.last(0)}#1
* Severity: High

Configuration -> Actions ->
* Create Action
* name: Email notifications
* Event source: triggers
* Default Subject: add "{HOST.DNS}:" to the beginning
* Default message: add "{HOST.DNS}:" to the beginning
* Conditions: make host have to be from "Linux Servers" hostgroup, and Template_Alpine_Linux_Infra_HTTP:HTTP trigger" is not 1
* Email affected users

[[Category:Monitoring]]
[[Category:PHP]]
[[Category:SQL]]

FreePBX

2016-06-05T06:42:08Z

ZavNDW: /* MySQL */

This document will be a quick c/p guide to setup asterisk with [http://www.freepbx.org/ FreepPBX] on Alpine Linux. What we will setup is the following:

* Lighttpd with PHP using FastCGI
* MySQL server
* Freepbx 2.7.0

== Install Lighttpd and PHP ==

{{:Setting Up Lighttpd With FastCGI}}

== Install pear DB ==

{{Cmd|apk add php5-pear; pear install DB}}

== MySQL ==

Install MySQL

{{Cmd|apk add mysql mysql-client}}

Initiate databases

{{Cmd|<nowiki>/usr/bin/mysql_install_db --user=mysql</nowiki>}}

Start MySQL and add to system start

{{Cmd|/etc/init.d/mariadb start && rc-update add mariadb default}}

Set MySQL root password

{{Cmd|/usr/bin/mysqladmin -u root password 'new-password'}}

== Asterisk ==

Install asterisk (replace vserver with your kernel version).

{{Cmd|apk add asterisk asterisk-sample-config dahdi-linux-vserver asterisk-addons-mysql}}

Start asterisk (do not add to system start)

{{Cmd|/etc/init.d/asterisk start}}

== FreePBX ==

Download Freepbx

{{Cmd|wget http://mirror.freepbx.org/freepbx-2.7.0.tar.gz}}

Unpack source

{{Cmd|tar zxvf freepbx-2.7.0.tar.gz && cd freepbx-2.7.0}}

Add freepbx databases to MySQL

{{Cmd|mysqladmin create asterisk -p
mysqladmin create asteriskcdrdb -p}}

Import SQL data into MySQL

{{Cmd|mysql -D asterisk -u root -p < SQL/newinstall.sql
mysql -D asteriskcdrdb -u root -p < SQL/cdr_mysql_table.sql}}

Open connection to MySQL

{{Cmd|mysql -u root -p}}

Create MySQL users

{{Cmd|GRANT ALL PRIVILEGES ON asterisk.* TO asteriskuser@localhost IDENTIFIED BY 'amp109';
GRANT ALL PRIVILEGES ON asteriskcdrdb.* TO asteriskuser@localhost IDENTIFIED BY 'amp109';}}

Close connection

{{Cmd|exit}}

Freepbx installer does not like busybox sed so we add normal sed, we need to patch 2 files later on so we need patch (you can remove them afterwards)

{{Cmd|apk add sed patch}}

Flash operator panel needs Perl

{{Cmd|apk add perl}}

Start the installer (you can accept the defaults)

{{Cmd|./install_amp}}

== Finishing up ==

Change user/group of lighttpd to asterisk

{{Cmd|vim +50 /etc/lighttpd/lighttpd.conf}}

Change permissions of lighttpd/freepbx files

{{Cmd|/etc/init.d/lighttpd stop
chown -R asterisk:asterisk /var/log/lighttpd
chown -R asterisk:asterisk /var/run/lighttpd*
chown -R asterisk:asterisk /var/www/localhost/htdocs/freepbx
/etc/init.d/lighttpd start}}

Stop asterisk

{{Cmd|/etc/init.d/asterisk stop}}

Patch FreePBX to support Alpine Linux
[[File:Freepbx_engine.patch.txt]]

{{Cmd|cd /var/lib/asterisk/bin
patch -p0 < freepbx_engine.patch}}

This file gets overwritten when using freepbx so we need to patch the original
[[File:Freepbx_engine.patch.txt]]

{{Cmd|cd /var/www/localhost/htdocs/freepbx/admin/modules/framework/bin/
patch -p0 freepbx_engine.patch}}

Start Asterisk with FreePBX

{{Cmd|amportal start}}

Load needed dahdi modules

{{Cmd|modprobe dahdi
modprobe dahdi_dummy}}

Make them load on boot

{{Cmd|echo dahdi >> /etc/modules
echo dahdi_dummy >> /etc/modules}}

[[Category:Telephony]]
[[Category:Server]]
[[Category:PHP]]
[[Category:SQL]]

Setting Up Apache with PHP

2016-06-05T06:21:20Z

ZavNDW: /* Installing Apache + PHP */

== Installing Apache + PHP ==
Add the main packages with the command:

{{Cmd|#apk add apache2 php5-apache2}}

== Testing ==

Move to the directory where your site will reside:

{{Cmd|#cd /var/www/localhost/htdocs}}

And create an index.php file to test if everything is ok:

{{Cmd|#vi index.php}}

Add the following lines in the file:

{{Cmd|<?php
phpinfo();
?>}}

That done, let us start apache2 web server:

{{Cmd|rc-service apache2 start}}

Now access: http://<ip_address> and if everything is ok you will see the php info page.

== Ending ==

Finally let us set up apache2 to start on operating system startup:

{{Cmd|rc-update add apache2}}

Now you can create your php site and host in this directory.

== Note ==
This is the easiest way to setup apache with php support, but it's the most inefficient (resource wise) setup, please refer to [[Apache with php-fpm]]

FreePBX

2016-06-05T05:57:47Z

ZavNDW: /* Install pear DB */

This document will be a quick c/p guide to setup asterisk with [http://www.freepbx.org/ FreepPBX] on Alpine Linux. What we will setup is the following:

* Lighttpd with PHP using FastCGI
* MySQL server
* Freepbx 2.7.0

== Install Lighttpd and PHP ==

{{:Setting Up Lighttpd With FastCGI}}

== Install pear DB ==

{{Cmd|apk add php5-pear; pear install DB}}

== MySQL ==

Install MySQL

{{Cmd|apk add mysql mysql-client}}

Initiate databases

{{Cmd|<nowiki>/usr/bin/mysql_install_db --user=mysql</nowiki>}}

Start MySQL and add to system start

{{Cmd|/etc/init.d/mysql start && rc-update add mysql default}}

Set MySQL root password

{{Cmd|/usr/bin/mysqladmin -u root password 'new-password'}}

== Asterisk ==

Install asterisk (replace vserver with your kernel version).

{{Cmd|apk add asterisk asterisk-sample-config dahdi-linux-vserver asterisk-addons-mysql}}

Start asterisk (do not add to system start)

{{Cmd|/etc/init.d/asterisk start}}

== FreePBX ==

Download Freepbx

{{Cmd|wget http://mirror.freepbx.org/freepbx-2.7.0.tar.gz}}

Unpack source

{{Cmd|tar zxvf freepbx-2.7.0.tar.gz && cd freepbx-2.7.0}}

Add freepbx databases to MySQL

{{Cmd|mysqladmin create asterisk -p
mysqladmin create asteriskcdrdb -p}}

Import SQL data into MySQL

{{Cmd|mysql -D asterisk -u root -p < SQL/newinstall.sql
mysql -D asteriskcdrdb -u root -p < SQL/cdr_mysql_table.sql}}

Open connection to MySQL

{{Cmd|mysql -u root -p}}

Create MySQL users

{{Cmd|GRANT ALL PRIVILEGES ON asterisk.* TO asteriskuser@localhost IDENTIFIED BY 'amp109';
GRANT ALL PRIVILEGES ON asteriskcdrdb.* TO asteriskuser@localhost IDENTIFIED BY 'amp109';}}

Close connection

{{Cmd|exit}}

Freepbx installer does not like busybox sed so we add normal sed, we need to patch 2 files later on so we need patch (you can remove them afterwards)

{{Cmd|apk add sed patch}}

Flash operator panel needs Perl

{{Cmd|apk add perl}}

Start the installer (you can accept the defaults)

{{Cmd|./install_amp}}

== Finishing up ==

Change user/group of lighttpd to asterisk

{{Cmd|vim +50 /etc/lighttpd/lighttpd.conf}}

Change permissions of lighttpd/freepbx files

{{Cmd|/etc/init.d/lighttpd stop
chown -R asterisk:asterisk /var/log/lighttpd
chown -R asterisk:asterisk /var/run/lighttpd*
chown -R asterisk:asterisk /var/www/localhost/htdocs/freepbx
/etc/init.d/lighttpd start}}

Stop asterisk

{{Cmd|/etc/init.d/asterisk stop}}

Patch FreePBX to support Alpine Linux
[[File:Freepbx_engine.patch.txt]]

{{Cmd|cd /var/lib/asterisk/bin
patch -p0 < freepbx_engine.patch}}

This file gets overwritten when using freepbx so we need to patch the original
[[File:Freepbx_engine.patch.txt]]

{{Cmd|cd /var/www/localhost/htdocs/freepbx/admin/modules/framework/bin/
patch -p0 freepbx_engine.patch}}

Start Asterisk with FreePBX

{{Cmd|amportal start}}

Load needed dahdi modules

{{Cmd|modprobe dahdi
modprobe dahdi_dummy}}

Make them load on boot

{{Cmd|echo dahdi >> /etc/modules
echo dahdi_dummy >> /etc/modules}}

[[Category:Telephony]]
[[Category:Server]]
[[Category:PHP]]
[[Category:SQL]]

Setting Up Lighttpd With FastCGI

2016-06-05T05:50:22Z

ZavNDW: edit php version

Install the additional packages:
{{Cmd|apk add lighttpd php5-common php5-iconv php5-json php5-gd php5-curl php5-xml php5-pgsql php5-imap php5-cgi fcgi}}
{{Cmd|apk add php5-pdo php5-pdo_pgsql php5-soap php5-xmlrpc php5-posix php5-mcrypt php5-gettext php5-ldap php5-ctype php5-dom}}

==Configure Lighttpd==
{{Cmd|vi /etc/lighttpd/lighttpd.conf}}
Uncomment line:
include "mod_fastcgi.conf"

==Start lighttpd service and add to needed runlevel==

{{Cmd|rc-service lighttpd start && rc-update add lighttpd default}}

[[Category:Server]]
[[Category:PHP]]