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 ===== | ||
+ | |||
+ | * '' | ||
+ | * Editace souboru '' | ||
+ | |||
+ | <file ini / | ||
+ | ####################################### | ||
+ | # | ||
+ | # 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 "#" | ||
+ | # value. | ||
+ | # | ||
+ | # Please note, a number of the values are specified in **Bytes** (Not KB). | ||
+ | # Accordingly, | ||
+ | # 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 " | ||
+ | # non-zero is taken to mean " | ||
+ | # only use 0/1. | ||
+ | # | ||
+ | # String | ||
+ | # ------ | ||
+ | # Strings are also what they sound like, strings. Examples: | ||
+ | # | ||
+ | # | ||
+ | # | ||
+ | # | ||
+ | # Portions of this file have been reproduced/ | ||
+ | # 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 "#" | ||
+ | # value. | ||
+ | # | ||
+ | # Please note, a number of the values are specified in **Bytes** (Not KB). | ||
+ | # Accordingly, | ||
+ | # 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 " | ||
+ | # non-zero is taken to mean " | ||
+ | # only use 0/1. | ||
+ | # | ||
+ | # String | ||
+ | # ------ | ||
+ | # Strings are also what they sound like, strings. Examples: | ||
+ | # | ||
+ | # | ||
+ | # | ||
+ | # | ||
+ | # Portions of this file have been reproduced/ | ||
+ | # 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 "#" | ||
+ | # value. | ||
+ | # | ||
+ | # Please note, a number of the values are specified in **Bytes** (Not KB). | ||
+ | # Accordingly, | ||
+ | # 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 " | ||
+ | # non-zero is taken to mean " | ||
+ | # only use 0/1. | ||
+ | # | ||
+ | # String | ||
+ | # ------ | ||
+ | # Strings are also what they sound like, strings. Examples: | ||
+ | # | ||
+ | # | ||
+ | # | ||
+ | # | ||
+ | # Portions of this file have been reproduced/ | ||
+ | # 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 "#" | ||
+ | # value. | ||
+ | # | ||
+ | # Please note, a number of the values are specified in **Bytes** (Not KB). | ||
+ | # Accordingly, | ||
+ | # 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 " | ||
+ | # non-zero is taken to mean " | ||
+ | # only use 0/1. | ||
+ | # | ||
+ | # String | ||
+ | # ------ | ||
+ | # Strings are also what they sound like, strings. Examples: | ||
+ | # | ||
+ | # | ||
+ | # | ||
+ | # | ||
+ | # Portions of this file have been reproduced/ | ||
+ | # permission of Ann Harrison @ IBPhoenix. | ||
+ | ####################################### | ||
+ | |||
+ | # ---------------------------- | ||
+ | # Database Paths/ | ||
+ | # | ||
+ | # DatabaseAccess may be None, Full or Restrict. If you choose Restrict, | ||
+ | # provide ';' | ||
+ | # Relative paths are treated relative to RootDirectory entry | ||
+ | # (see above). Default value ' | ||
+ | # on your site. To specify access to specific trees, enum all required | ||
+ | # paths (for Win32 this may be something like ' | ||
+ | # for unix - '/ | ||
+ | # 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: | ||
+ | # DatabaseAccess = Restrict /db | ||
+ | # DatabaseAccess = Restrict / | ||
+ | # 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 = Restrict / | ||
+ | |||
+ | # ---------------------------- | ||
+ | # Temporary directories | ||
+ | # | ||
+ | # Provide ';' | ||
+ | # 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: | ||
+ | # | ||
+ | # Type: string (special format) | ||
+ | # | ||
+ | TempDirectories = / | ||
+ | |||
+ | # ---------------------------- | ||
+ | # External File Paths/ | ||
+ | # | ||
+ | # ExternalFileAccess may be None, Full or Restrict. If you choose | ||
+ | # Restrict, provide ';' | ||
+ | # are stored. Relative paths are treated relative to RootDirectory entry | ||
+ | # (see above). Default value ' | ||
+ | # on your site. To specify access to specific trees, enum all required | ||
+ | # paths (for Win32 this may be something like ' | ||
+ | # for unix - '/ | ||
+ | # | ||
+ | # 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 / | ||
+ | |||
+ | | ||
+ | # 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 = 172.16.33.1 | ||
+ | </ | ||
+ | |||
+ | - **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ě | ||
+ | |||
+ | * Následně vytvoříme v adresáři **/ | ||
+ | * **Pozor na nastavení přístupových práv** = všechny soubory a podadresáře včetně adresáře '' | ||
+ | * V aplikaci potom zadáme IP adresu, na kterém poslouchá firebird a potom celou cestu k datovému souboru databáze, tj. např. '' | ||
+ | |||
+ | ===== Monitoring nagiosem ===== | ||
+ | |||
+ | Pro monitoring jsem použil plugin [[http:// | ||
+ | |||
+ | Plugin přidáme do nrpe.conf \\ | ||
+ | '' | ||
+ | |||
+ | <code bash> | ||
+ | root@server:/ | ||
+ | OK: Database looks intact | ||
+ | </ |