SPOJE.NET

Technická dokumentace

Uživatelské nástroje

Nástroje pro tento web


howto:hosting:firebird
no way to compare when less than two revisions

Rozdíly

Zde můžete vidět rozdíly mezi vybranou verzí a aktuální verzí dané stránky.


howto:hosting:firebird [2016/10/29 23:05] (aktuální) – vytvořeno - upraveno mimo DokuWiki 127.0.0.1
Řádek 1: Řádek 1:
 +====== Firebird databázový server v Debianu ======
  
 +===== Potřebné balíčky =====
 +
 +  * firebird2.5-superclassic
 +  * libnagios-plugin-perl
 +  * libdbd-firebird-perl
 +
 +===== Konfigurace =====
 +
 +  * ''%%dpkg-reconfigure firebird2.5-superclassic%%'' - vynutí znovu nastavení hesla pro hlavního uživatele SYSDBA. Defaultně se používá heslo ''%%masterkey%%'', ale samozřejmě záleží na nastavení aplikace, kterou budete používat = doporučuji nahlédnout do dokumentace výrobce.
 +  * Editace souboru ''%%/etc/firebird/2.5/firebird.conf%%'' - nastaveni pro zakladni funkčnost, ostatní je mošno doladit dle potřeby
 +
 +<file ini /etc/firebird/2.5/firebird.conf>
 +#######################################
 +#
 +# Firebird configuration file
 +#
 +# Comments
 +# --------
 +# The # character is used for comments and can be placed anywhere on a
 +# line.  Anything following the # character on a line is considered a
 +# comment.
 +#
 +# Examples:
 +#
 +#    # This is a comment
 +#    DefaultDbCachePages = 2048   # This is an end-of-line comment
 +#
 +# Entries
 +# -------
 +# The default value for each entry is listed to the right of the "=".
 +# To activate an entry, remove the leading "#"s and supply the desired
 +# value.
 +#
 +# Please note, a number of the values are specified in **Bytes** (Not KB).
 +# Accordingly, we have provided some simple conversion tables at the bottom
 +# of this file.
 +#
 +# There are three types of configuration values: integer, boolean and string.
 +#
 +# Integer
 +# --------
 +# Integers is what they sound like, an integral value. Examples:
 +#   1
 +#   42
 +#   4711
 +#
 +# Boolean
 +# -------
 +# Boolean is expressed as integer values with 0 (zero) being "false" and
 +# non-zero is taken to mean "true". For consistency we recommend you
 +# only use 0/1.
 +#
 +# String
 +# ------
 +# Strings are also what they sound like, strings. Examples:
 +#   RootDirectory  = /opt/firebird
 +#   RemotePipeName = pipe47
 +#
 +#
 +# Portions of this file have been reproduced/made available with the
 +# permission of Ann Harrison @ IBPhoenix.
 +#######################################
 +#
 +# Firebird configuration file
 +#
 +# Comments
 +# --------
 +# The # character is used for comments and can be placed anywhere on a
 +# line.  Anything following the # character on a line is considered a
 +# comment.
 +#
 +# Examples:
 +#
 +#    # This is a comment
 +#    DefaultDbCachePages = 2048   # This is an end-of-line comment
 +#
 +# Entries
 +# -------
 +# The default value for each entry is listed to the right of the "=".
 +# To activate an entry, remove the leading "#"s and supply the desired
 +# value.
 +#
 +# Please note, a number of the values are specified in **Bytes** (Not KB).
 +# Accordingly, we have provided some simple conversion tables at the bottom
 +# of this file.
 +#
 +# There are three types of configuration values: integer, boolean and string.
 +#
 +# Integer
 +# --------
 +# Integers is what they sound like, an integral value. Examples:
 +#   1
 +#   42
 +#   4711
 +#
 +# Boolean
 +# -------
 +# Boolean is expressed as integer values with 0 (zero) being "false" and
 +# non-zero is taken to mean "true". For consistency we recommend you
 +# only use 0/1.
 +#
 +# String
 +# ------
 +# Strings are also what they sound like, strings. Examples:
 +#   RootDirectory  = /opt/firebird
 +#   RemotePipeName = pipe47
 +#
 +#
 +# Portions of this file have been reproduced/made available with the
 +# permission of Ann Harrison @ IBPhoenix.
 +#######################################
 +#
 +# Firebird configuration file
 +#
 +# Comments
 +# --------
 +# The # character is used for comments and can be placed anywhere on a
 +# line.  Anything following the # character on a line is considered a
 +# comment.
 +#
 +# Examples:
 +#
 +#    # This is a comment
 +#    DefaultDbCachePages = 2048   # This is an end-of-line comment
 +#
 +# Entries
 +# -------
 +# The default value for each entry is listed to the right of the "=".
 +# To activate an entry, remove the leading "#"s and supply the desired
 +# value.
 +#
 +# Please note, a number of the values are specified in **Bytes** (Not KB).
 +# Accordingly, we have provided some simple conversion tables at the bottom
 +# of this file.
 +#
 +# There are three types of configuration values: integer, boolean and string.
 +#
 +# Integer
 +# --------
 +# Integers is what they sound like, an integral value. Examples:
 +#   1
 +#   42
 +#   4711
 +#
 +# Boolean
 +# -------
 +# Boolean is expressed as integer values with 0 (zero) being "false" and
 +# non-zero is taken to mean "true". For consistency we recommend you
 +# only use 0/1.
 +#
 +# String
 +# ------
 +# Strings are also what they sound like, strings. Examples:
 +#   RootDirectory  = /opt/firebird
 +#   RemotePipeName = pipe47
 +#
 +#
 +# Portions of this file have been reproduced/made available with the
 +# permission of Ann Harrison @ IBPhoenix.
 +#######################################
 +#
 +# Firebird configuration file
 +#
 +# Comments
 +# --------
 +# The # character is used for comments and can be placed anywhere on a
 +# line.  Anything following the # character on a line is considered a
 +# comment.
 +#
 +# Examples:
 +#
 +#    # This is a comment
 +#    DefaultDbCachePages = 2048   # This is an end-of-line comment
 +#
 +# Entries
 +# -------
 +# The default value for each entry is listed to the right of the "=".
 +# To activate an entry, remove the leading "#"s and supply the desired
 +# value.
 +#
 +# Please note, a number of the values are specified in **Bytes** (Not KB).
 +# Accordingly, we have provided some simple conversion tables at the bottom
 +# of this file.
 +#
 +# There are three types of configuration values: integer, boolean and string.
 +#
 +# Integer
 +# --------
 +# Integers is what they sound like, an integral value. Examples:
 +#   1
 +#   42
 +#   4711
 +#
 +# Boolean
 +# -------
 +# Boolean is expressed as integer values with 0 (zero) being "false" and
 +# non-zero is taken to mean "true". For consistency we recommend you
 +# only use 0/1.
 +#
 +# String
 +# ------
 +# Strings are also what they sound like, strings. Examples:
 +#   RootDirectory  = /opt/firebird
 +#   RemotePipeName = pipe47
 +#
 +#
 +# Portions of this file have been reproduced/made available with the
 +# permission of Ann Harrison @ IBPhoenix.
 +#######################################
 +
 +# ----------------------------
 +# Database Paths/Directories
 +#
 +# DatabaseAccess may be None, Full or Restrict. If you choose Restrict,
 +# provide ';'-separated trees list, where database files are stored.
 +# Relative paths are treated relative to RootDirectory entry
 +# (see above). Default value 'Full' gives full access to all files
 +# on your site. To specify access to specific trees, enum all required
 +# paths (for Win32 this may be something like 'C:\DataBase;D:\Mirror',
 +# for unix - '/db;/mnt/mirrordb'). If you choose 'None', then only
 +# databases listed in aliases.conf can be attached.
 +#
 +# Note: simple quotation marks shown above should *NOT* be used when
 +# specifying values and directory path names. Examples:
 +#
 +# DatabaseAccess = None
 +# DatabaseAccess = Restrict C:\DataBase
 +# DatabaseAccess = Restrict C:\DataBase;D:\Mirror
 +# DatabaseAccess = Restrict /db
 +# DatabaseAccess = Restrict /db;/mnt/mirrordb
 +# DatabaseAccess = Full
 +#
 +# UNCONTROLLED DATABASE ACCESS MAY COMPROMISE YOUR SYSTEM!
 +# IT IS STRONGLY RECOMMENDED THAT THIS SETTING BE USED TO LIMIT
 +# DATABASE LOCATIONS!
 +#
 +# Type: string (special format)
 +#
 +#DatabaseAccess = Full
 +DatabaseAccess = Restrict /var/lib/firebird
 +
 +# ----------------------------
 +# Temporary directories
 +#
 +# Provide ';'-separated trees list, where temporary files are stored.
 +# Relative paths are treated relative to RootDirectory entry
 +# (see above). Default value is determined using FIREBIRD_TMP,
 +# TEMP or TMP environment options. Once the first specified
 +# directory has no available space, the engine will switch to the
 +# next one, and so on.
 +#
 +# E.g.:
 +# TempDirectories = c:\temp
 +# or
 +# TempDirectories = c:\temp;d:\temp
 +#
 +# Type: string (special format)
 +#
 +TempDirectories = /var/lib/firebird/2.5/tmp
 +
 +# ----------------------------
 +# External File Paths/Directories
 +#
 +# ExternalFileAccess may be None, Full or Restrict. If you choose
 +# Restrict, provide ';'-separated trees list, where external files
 +# are stored. Relative paths are treated relative to RootDirectory entry
 +# (see above). Default value 'None' disables any use of external files
 +# on your site. To specify access to specific trees, enum all required
 +# paths (for Win32 this may be something like 'C:\ExternalTables',
 +# for unix - '/db/extern;/mnt/extern').
 +#
 +# NOTE: THE EXTERNAL TABLE ENGINE FEATURE COULD BE USED TO COMPROMISE
 +# THE SERVER/HOST AS WELL AS DATABASE SECURITY!!
 +#
 +# IT IS STRONGLY RECOMMENDED THAT THIS SETTING BE USED TO LIMIT
 +# EXTERNAL TABLE LOCATIONS!
 +#
 +# Type: string (special format)
 +#
 +ExternalFileAccess = Restrict /var/lib/firebird/inisoft
 +
 + Allows incoming connections to be bound to the IP address of a
 +# specific network card. It enables rejection of incoming connections
 +# through any other network interface except this one. By default,
 +# connections from any available network interface are allowed.
 +# If you are using Classic Server, this setting is for Windows only.
 +# Under Linux, BSD or Mac OS X, with Classic server use xinetd or launchd
 +# configuration file (bind parameter).
 +#
 +# Type: string
 +#
 +#RemoteBindAddress =
 +RemoteBindAddress = 172.16.33.1
 +</file>
 +
 +  - **DatabaseAccess** = omezíme přístup jen do adresáře s databázema
 +  - **RemoteBindAddress** = nastavíme vnitřní adresu firemního serveru, kde má firebird poslouchat. Zbytečně  neotevíráme do Internetu.
 +
 +  * Následně vytvoříme v adresáři **/var/lib/firebird** adresář se jménem aplikace a do ní nahrajeme databázové soubory **dbg**. V našem případě se jedná o aplikaci inisoft. V adresáři je defaultně ještě adresář **2.5**, který obsahuje systémové databáze firebirdu.
 +  * **Pozor na nastavení přístupových práv** = všechny soubory a podadresáře včetně adresáře ''%%/var/lib/firebird%%'' musí vlastnit uživatel a skupina **firebird**. Následně adresáře musí mít práva **775** a soubory **660** !!!
 +  * V aplikaci potom zadáme IP adresu, na kterém poslouchá firebird a potom celou cestu k datovému souboru databáze, tj. např. ''%%/var/lib/firebird/inisoft/dbini.gdb%%''
 +
 +===== Monitoring nagiosem =====
 +
 +Pro monitoring jsem použil plugin [[http://exchange.nagios.org/directory/Plugins/Databases/check_firebird-2Epl/details]] - ke stažení např. také z naší wiki: {{:howto:hosting:check_firebird.pl.gz|}}. \\
 +
 +Plugin přidáme do nrpe.conf \\
 +''%%command[check_firebird]=/usr/lib/nagios/plugins/check_firebird.pl -H 172.16.33.1 -U SYSDBA -P <heslo> -D /var/lib/firebird/inisoft/dbini.gdb%%'' \\
 +
 +<code bash>
 +root@server:/var/lib/firebird# /usr/lib/nagios/plugins/check_firebird.pl -H 172.16.33.1 -U SYSDBA -P <heslo> -D /var/lib/firebird/inisoft/dbini.gdb
 +OK: Database looks intact
 +</code>
howto/hosting/firebird.txt · Poslední úprava: 2016/10/29 23:05 autor: 127.0.0.1