|
Работа сервисов с изменённым параметром SecurityDatabase (Firebird 3)
|
|||
---|---|---|---|
#18+
К примеру есть база [FIXED databases.conf] test = d:\fb\fb30\data\test.fdb { DefaultDbCachePages = 32K TempBlockSize = 2M TempCacheLimit = 1G LockMemSize = 8M LockHashSlots = 19927 SecurityDatabase = test } при попытке получить статистику по одной из таблиц (или сразу по всем) получаем ошибку IBEMissing security context for test. согласно документации для того чтобы всё работало надо указать сервису какую базу данных безопасности использовать README.services_extension5) Services API extension - using services with non-default security database. (Alex Peshkov, peshkoff@mail.ru, 2013) If one wants to use services API to access database which is configured to use non-default security database, new SPB item isc_spb_expected_db should be used when attaching to services manager. Value of this item is a database which is expected to be accessed. Formally this does not raise backward incompatibility - as long as one does not use new FB3 feature (multiple security databases) he has no problems with old programs using services API. In a case when one has really big need to use old program for a database with non-default configuration there is a workaround: setting environment variable FB_EXPECTED_DB which will be added to SPB automatically. Example. Imagine we have the following lines in databases.conf: employee = $(dir_sampledb)/employee.fdb { SecurityDatabase = employee } i.e. employee database is configured as security database for itself. To access it using fbsvcmgr one should use the following command line: fbsvcmgr host:service_mgr user sysdba password xxx expected_db employee action_db_stats dbname employee sts_data_pages or in advance set FB_EXPECTED_DB: export FB_EXPECTED_DB=employee fbsvcmgr host:service_mgr user sysdba password xxx action_db_stats dbname employee sts_data_pages Certainly any other database action can be used here. Можно ли что-нибудь придумать чтобы это работало в IBE? Например указывать эту БД в свойствах подключения ... |
|||
:
Нравится:
Не нравится:
|
|||
11.07.2015, 15:20 |
|
|
start [/forum/topic.php?fid=42&fpage=28&tid=1599492]: |
0ms |
get settings: |
8ms |
get forum list: |
12ms |
check forum access: |
3ms |
check topic access: |
3ms |
track hit: |
45ms |
get topic data: |
11ms |
get forum data: |
2ms |
get page messages: |
37ms |
get tp. blocked users: |
1ms |
others: | 303ms |
total: | 425ms |
0 / 0 |