Re: [Firebird-devel] security3.fdb unavailable database
File: src\common\config\config.cpp
Line: 173
Correct:
{TYPE_STRING, SecurityDatabase, (ConfigValue) $(root)security3.fdb}, //
security database name
Kovalenko Dmitry.
2013/3/18 Treeve Jelbert tre...@scarlet.be
I reconfigured firebird3 as follows;
./configure --prefix=/opt/firebird --with-fbconf=/etc/firebird
When I start the firebird server I get
# telinit run firebird3 start
firebird3: Starting Firebird Server
firebird3: success
/etc/firebird//security3.fdb unavailable database
I am not sure if this is because of the // in above message, or why it
appears
like that.
Previously I put everything in /opt/firebird and it worked
the start command was:
su -s /bin/sh -c /opt/firebird/bin/firebird -l firebird
~$ ls -l /etc/firebird/
total 960
-r--r--r-- 1 root root524 Mar 18 13:22 aliases.conf
-rw-r--r-- 1 root root 5295 Mar 18 13:21 fbtrace.conf
-r--r--r-- 1 root root 25376 Mar 18 13:22 firebird.conf
-r--r--r-- 1 root root 26023 Mar 18 13:21 IDPLicense.txt
drwxr-xr-x 2 root root 4096 Mar 18 13:21 intl
-r--r--r-- 1 root root 24301 Mar 18 13:21 IPLicense.txt
drwxr-xr-x 2 root root 4096 Mar 18 13:21 plugins
-rw-r--r-- 1 root root128 Mar 18 13:21 plugins.conf
-rw-r--r-- 1 root root687 Mar 18 13:21 README
-rw--- 1 firebird firebird 868352 Mar 18 13:21 security3.fdb
-rw-r--r-- 1 root root397 Mar 18 13:21 WhatsNew
$ ls -l /opt/firebird
total 1796
drwxr-xr-x 2 root root 4096 Mar 18 13:21 bin
drwxr-xr-x 3 root root 4096 Mar 4 09:09 doc
dr-xr-xr-x 9 root root 4096 Mar 18 13:21 examples
-rw-r- 1 root root 0 Mar 18 13:21 fb_init
lrwxrwxrwx 1 root root 21 Mar 18 13:21 firebird.log -
/var/log/firebird.log
-r--r--r-- 1 root root 140900 Mar 18 13:21 firebird.msg
drwxr-xr-x 2 root root 4096 Mar 18 13:08 help
-r--r--r-- 1 root root 26023 Mar 14 09:57 IDPLicense.txt
drwxr-xr-x 2 root root 4096 Mar 18 13:08 include
drwxr-xr-x 2 root root 4096 Mar 18 13:21 intl
-r--r--r-- 1 root root 24301 Mar 14 09:57 IPLicense.txt
drwxr-xr-x 2 root root 4096 Mar 18 13:21 lib
drwx-- 3 root root 4096 Mar 4 09:09 misc
drwxr-xr-x 3 root root 4096 Mar 18 13:21 plugins
-rw-r--r-- 1 root root687 Mar 14 09:57 README
-rw--- 1 firebird firebird 720896 Mar 3 17:13 security2.fdb
-rw--- 1 firebird firebird 868352 Mar 18 13:21 security3.fdb.xx
drwxr-xr-x 2 root root 4096 Mar 18 13:08 UDF
-rw-r--r-- 1 root root397 Mar 14 09:57 WhatsNew
--
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_mar
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
--
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_marFirebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] security3.fdb unavailable database
On 03/19/13 10:41, Dmitry Kovalenko wrote:
File: src\common\config\config.cpp
Line: 173
Correct:
{TYPE_STRING, SecurityDatabase, (ConfigValue) $(root)security3.fdb}, //
security database name
Yes, it's better but won't solve a problem. Double-slash is eaten with
no-error:
# cat /etc//passwd
root:x:0:0:root:/root:/bin/bash
..
Treeve, can you strace firebird server and send result here? (Sorry have
no time for experiments right now.)
--
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_mar
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] security3.fdb unavailable database
Correct:
{TYPE_STRING, SecurityDatabase, (ConfigValue) $(root)security3.fdb},
//
security database name
Yes, it's better but won't solve a problem. Double-slash is eaten with
no-error:
Hm... As I remember (this is very old problem) my XP SP2 (on test VM) can't
eat this double-slash in fbsecurity3.gdb path.
Kovalenko Dmitry.
--
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_marFirebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] security3.fdb unavailable database
On 03/19/13 11:53, Dmitry Kovalenko wrote:
Correct:
{TYPE_STRING, SecurityDatabase, (ConfigValue) $(root)security3.fdb},
//
security database name
Yes, it's better but won't solve a problem. Double-slash is eaten with
no-error:
Hm... As I remember (this is very old problem) my XP SP2 (on test VM) can't
eat this double-slash in fbsecurity3.gdb path.
I've anyway committed your suggestion - it really looks better. Let's
hope it will fix problem at your XP too.
--
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_mar
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] security3.fdb unavailable database
19.03.2013 11:23, Alex Peshkoff wrote:
Was:
{TYPE_STRING, SecurityDatabase, (ConfigValue) $(root)/security3.fdb}
Correct:
{TYPE_STRING, SecurityDatabase, (ConfigValue) $(root)security3.fdb}
Yes, it's better
I respectfully disagree. The former string clearly distinguishes between
path and filename thus visually representing a full pathname. It was
obvious to understand. The new one looks more cryptic suggesting that
$(root) could be a macro related to the filename, not the path. This may
lead users easily reintroducing the slash back in their custom configs,
just because it does look more natural.
I believe it would be much better to fix PathName to replace double
slashes with single ones inside and forget about any possible
configuration issues.
Dmitry
--
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_mar
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] security3.fdb unavailable database
On 03/19/13 12:33, Dmitry Yemanov wrote:
19.03.2013 11:23, Alex Peshkoff wrote:
Was:
{TYPE_STRING, SecurityDatabase, (ConfigValue) $(root)/security3.fdb}
Correct:
{TYPE_STRING, SecurityDatabase, (ConfigValue) $(root)security3.fdb}
Yes, it's better
I respectfully disagree. The former string clearly distinguishes between
path and filename thus visually representing a full pathname. It was
obvious to understand. The new one looks more cryptic suggesting that
$(root) could be a macro related to the filename, not the path. This may
lead users easily reintroducing the slash back in their custom configs,
just because it does look more natural.
I believe it would be much better to fix PathName to replace double
slashes with single ones inside and forget about any possible
configuration issues.
OK, will do - moreover I'm working with configuration code now.
--
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_mar
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4067) Problem with CREATE DATABASE ... COLLATION ... and 1 dialect
Problem with CREATE DATABASE ... COLLATION ... and 1 dialect -- Key: CORE-4067 URL: http://tracker.firebirdsql.org/browse/CORE-4067 Project: Firebird Core Issue Type: Bug Components: Engine, ISQL Affects Versions: 3.0 Initial Reporter: Kovalenko Dmitry Firebird 3.0.0.30278 c:\Program Files (x86)\Firebird_3_0isql.exe Use CONNECT or CREATE DATABASE to specify a database SQL SET SQL DIALECT 1; SQL CREATE DATABASE 'vxp-fb30:e:\database\test2.gdb' USER 'gamer' PASSWORD 'vermut' PAGE_SIZE 4096 DEFAULT CHARACTER SET win1251 COLLATION win1251; Statement failed, SQLSTATE = 42000 unsuccessful metadata update -ALTER DATABASE failed -Dynamic SQL Error -SQL error code = -817 -Metadata update statement is not allowed by the current database SQL dialect 1 -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_mar Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] FB3 crash
Hi Work with server from multiple clients [IBProvider test system]: firebird.exe!set_server(rem_port * port=0x, unsigned short flags=56) Строка 5455 + 0x6 байт C++ firebird.exe!SRVR_main(rem_port * main_port=0x, unsigned short flags=56) Строка 1058 + 0xe байт C++ firebird.exe!service_connection(rem_port * port=0x) Строка 537 + 0x14 байт C++ firebird.exe!process_connection_thread(void * arg=0x) Строка 370 + 0x9 байт C++ firebird.exe!`anonymous namespace'::ThreadArgs::run() Строка 73 + 0x1f байт C++ firebird.exe!threadStart(void * arg=0x47d8cdf8) Строка 89 C++ msvcr100d.dll!_callthreadstartex() Строка 314 + 0xf байт C msvcr100d.dll!_threadstartex(void * ptd=0x034c7688) Строка 297 C I think, crash can reproduced without any problem ... Regards, Kovalenko Dmitry. -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_marFirebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] FB3 crash
19.03.2013 21:52, Dmitry Kovalenko wrote: Hi Work with server from multiple clients [IBProvider test system]: firebird.exe!set_server(rem_port * port=0x, unsigned short flags=56) Строка 5455 + 0x6 байтC++ firebird.exe!SRVR_main(rem_port * main_port=0x, unsigned short flags=56) Строка 1058 + 0xe байтC++ firebird.exe!service_connection(rem_port * port=0x) Строка 537 + 0x14 байтC++ firebird.exe!process_connection_thread(void * arg=0x) Строка 370 + 0x9 байтC++ firebird.exe!`anonymous namespace'::ThreadArgs::run() Строка 73 + 0x1f байтC++ firebird.exe!threadStart(void * arg=0x47d8cdf8) Строка 89C++ msvcr100d.dll!_callthreadstartex() Строка 314 + 0xf байтC msvcr100d.dll!_threadstartex(void * ptd=0x034c7688) Строка 297C Do you have something at firebird.log ? Regards, Vlad -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_mar Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] FB3 crash
Yes, something exists :) - [fresh crash] firebird.exe!set_server(rem_port * port=0x, unsigned short flags=56) Строка 5455 + 0x6 байт C++ firebird.exe!SRVR_main(rem_port * main_port=0x, unsigned short flags=56) Строка 1058 + 0xe байт C++ firebird.exe!service_connection(rem_port * port=0x) Строка 537 + 0x14 байт C++ firebird.exe!process_connection_thread(void * arg=0x) Строка 370 + 0x9 байт C++ firebird.exe!`anonymous namespace'::ThreadArgs::run() Строка 73 + 0x1f байт C++ firebird.exe!threadStart(void * arg=0x3af533b4) Строка 89 C++ msvcr100d.dll!_callthreadstartex() Строка 314 + 0xf байт C msvcr100d.dll!_threadstartex(void * ptd=0x056c9408) Строка 297 C - [firebird .log] VXP-FB30 Wed Mar 20 08:20:17 2013 unable to allocate memory from operating system VXP-FB30 Wed Mar 20 08:20:28 2013 XNET error: Failed to allocate server port for communication operating system directive CreateFileMapping at line 2050 failed Файл подкачки слишком мал для завершения операции. VXP-FB30 Wed Mar 20 08:20:28 2013 XNET error: Server failed to respond on connect request - [test.log] [20.03.2013 08:20:16] [Thread #3] [START ] cmd|cmd.011.create_cn_WIN1251.work_cn_WIN1251 [#930] [20.03.2013 08:20:17] [Thread #4] [FAILED ] cmd|cmd.010.cn_UNICODE_FSS.marker_win1251.str_3 [20.03.2013 08:20:17] [Thread #4] [START ] cmd|cmd.011.create_cn_WIN1251.work_cn_UNICODE_FSS [#931] [20.03.2013 08:20:21] [Thread #2] [FAILED ] cmd|cmd.010.cn_UNICODE_FSS.marker_unicode_fss.str_7 [20.03.2013 08:20:21] [Thread #2] [START ] cmd|cmd.011.create_cn_WIN1251.work_cn_NONE [#932] [20.03.2013 08:20:28] [Thread #5] [STOP ] cmd|cmd.010.cn_UNICODE_FSS.marker_win1251.str_4 [20.03.2013 08:20:28] [Thread #5] [START ] cmd|cmd.011.create_cn_UNICODE_FSS.work_cn_WIN1251 [#933] [20.03.2013 08:20:28] [Thread #6] [FAILED ] cmd|cmd.010.cn_UNICODE_FSS.marker_win1251.str_5 [20.03.2013 08:20:28] [Thread #6] [START ] cmd|cmd.011.create_cn_UNICODE_FSS.work_cn_UNICODE_FSS [#934] - [test thread #4] [THR:008800] [20.03.2013 08:20:17] [cmd.010] cmd_props.attach_command(cmd.command_obj()) [THR:008800] [20.03.2013 08:20:17] [cmd.010] PREPARE STMT:[bstrselect _win1251'z'/*'*/ from dual] [THR:008800] [20.03.2013 08:20:17] ERROR: [cmd|cmd.010.cn_UNICODE_FSS.marker_win1251.str_3] Preparing a command 1. [LCPI.IBProvider.3]: Ошибка подготовки SQL выражения. unable to allocate memory from operating system Result code=DB_E_ERRORSINCOMMAND [test thread #2] [THR:006176] [20.03.2013 08:20:17] [cmd.010] cmd_props.attach_command(cmd.command_obj()) [THR:006176] [20.03.2013 08:20:21] [cmd.010] PREPARE STMT:[bstrselect _unicode_fss 'раздва' from dual] [THR:006176] [20.03.2013 08:20:21] ERROR: [cmd|cmd.010.cn_UNICODE_FSS.marker_unicode_fss.str_7] Preparing a command 1. [LCPI.IBProvider.3]: Ошибка подготовки SQL выражения. unable to allocate memory from operating system Result code=DB_E_ERRORSINCOMMAND - [test thread #6] [THR:008824] [20.03.2013 08:20:28] [cmd.010] Prepare Command: select _win1251 '' from dual [THR:008824] [20.03.2013 08:20:28] [cmd.010] cmd_props.attach_command(cmd.command_obj()) [THR:008824] [20.03.2013 08:20:28] [cmd.010] PREPARE STMT:[bstrselect _win1251 '' from dual] [THR:008824] [20.03.2013 08:20:28] ERROR: [cmd|cmd.010.cn_UNICODE_FSS.marker_win1251.str_5] Preparing a command 1. [LCPI.IBProvider.3]: Ошибка подготовки SQL выражения. unable to allocate memory from operating system Result code=DB_E_ERRORSINCOMMAND - [VM configuration] Virtual Box, XP SP2, RAM: 512MB Kovalenko Dmitry. PS. Hm. Seem I should convert your unable to allocate memory from operating system into E_OUTOFMEMORY error code :) 2013/3/20 Vlad Khorsun hv...@users.sourceforge.net 19.03.2013 21:52, Dmitry Kovalenko wrote: Hi Work with server from multiple clients [IBProvider test system]: firebird.exe!set_server(rem_port * port=0x, unsigned short flags=56) Строка 5455 + 0x6 байтC++ firebird.exe!SRVR_main(rem_port * main_port=0x, unsigned short flags=56) Строка 1058 + 0xe байтC++ firebird.exe!service_connection(rem_port * port=0x) Строка 537 + 0x14 байтC++ firebird.exe!process_connection_thread(void * arg=0x) Строка 370 + 0x9 байтC++ firebird.exe!`anonymous namespace'::ThreadArgs::run() Строка 73 + 0x1f байтC++ firebird.exe!threadStart(void * arg=0x47d8cdf8) Строка 89C++ msvcr100d.dll!_callthreadstartex() Строка 314 + 0xf байтC msvcr100d.dll!_threadstartex(void * ptd=0x034c7688) Строка 297C Do you have something at firebird.log ? Regards, Vlad -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_mar Firebird-Devel mailing list, web interface at
