Re: [Firebird-devel] security3.fdb unavailable database
On 03/20/13 13:33, Treeve Jelbert wrote:
> On Tuesday 19 March 2013 11:23:43 Alex Peshkoff wrote:
>> 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.)
>>
> I ran strace on svn rev 30280
> it appears that the firebird server also expects that the engine will be in
> /etc/firebird
>
>
> open("/etc/firebird/plugins/libEngine12.so", O_RDONLY|O_CLOEXEC) = -1 ENOENT
> (No such file or directory)
>
Far not the best default. The main excuse here is that --with-somedir
options were expected to be used all together - to fine-tune firebird
locations in distro-native packages.
--
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 Tuesday 19 March 2013 11:23:43 Alex Peshkoff wrote:
> 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.)
>
I ran strace on svn rev 30280
it appears that the firebird server also expects that the engine will be in
/etc/firebird
open("/etc/firebird/plugins/libEngine12.so", O_RDONLY|O_CLOEXEC) = -1 ENOENT
(No such file or directory)
After creating some symlinks it now works
# ls -l /etc/firebird/
total 952
-r--r--r-- 1 root root524 Mar 20 09:18 aliases.conf
-rw-r--r-- 1 root root 5295 Mar 20 09:17 fbtrace.conf
-r--r--r-- 1 root root 25376 Mar 20 09:18 firebird.conf
lrwxrwxrwx 1 root root 21 Mar 20 09:37 firebird.log ->
/var/log/firebird.log
lrwxrwxrwx 1 root root 26 Mar 18 17:45 firebird.msg ->
/opt/firebird/firebird.msg
-r--r--r-- 1 root root 26023 Mar 20 09:18 IDPLicense.txt
lrwxrwxrwx 1 root root 19 Mar 20 10:25 intl -> /opt/firebird/intl/
-r--r--r-- 1 root root 24301 Mar 20 09:18 IPLicense.txt
lrwxrwxrwx 1 root root 22 Mar 20 10:26 plugins ->
/opt/firebird/plugins/
-rw-r--r-- 1 root root128 Mar 20 09:17 plugins.conf
-rw-r--r-- 1 root root687 Mar 20 09:18 README
-rw--- 1 firebird firebird 868352 Mar 20 10:27 security3.fdb
-rw-r--r-- 1 root root397 Mar 20 09:18 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_mar
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] security3.fdb unavailable database
On 19-03-2013 05: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.
>
I completely agree. $(root)security3.fdb is crap.
Adriano
--
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
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 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
> 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 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
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
> 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
[Firebird-devel] security3.fdb unavailable database
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
