SPOJE.NET

Technická dokumentace

Uživatelské nástroje

Nástroje pro tento web


howto:hosting:firebird

Rozdíly

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

Odkaz na výstup diff

howto:hosting:firebird [2016/10/29 23:05] (aktuální)
Řá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 (upraveno mimo DokuWiki)