[Firebird-devel] Fw: [firebird-support] Re: Mapping Windows group to FB role is not implemented?

[livius]

Hi,

i see in the source code
https://github.com/FirebirdSQL/firebird/blob/0c75917d38016ab8674889534bf859af475a3ec9/src/auth/trusted/AuthSspi.cpp#L376that
 walking throught windows groups is not implemented?
there is // ToDo: walk groups to which login belongs and list them using 
writerInterface

regards,
Karol Bieniaszewski


From: 'livius' liviusliv...@poczta.onet.pl [firebird-support] 
Sent: Tuesday, March 27, 2018 8:05 PM
To: firebird-supp...@yahoogroups.com 
Subject: [firebird-support] Re: Mapping Windows group to FB role

  
Hi,
anybody can help with - point 4?
1. enable windows authentication is working ok by
CREATE GLOBAL MAPPING TRUSTED_AUTH
USING PLUGIN WIN_SSPI
FROM ANY USER
TO USER;

2. mapping specific windows domain user to internal Firebird user is working ok 
by:
CREATE MAPPING TRUSTED_KBIENIASZEWSKI
USING PLUGIN WIN_SSPI
FROM 'xCORP\KAROL.BIENIASZEWSKI'
TO USER KBIENIASZEWSKI;

3. granting specific role to windows user inside databse is working ok by:
grant WSZYSCY TO 'xCORP\KAROL.BIENIASZEWSKI'

4. mapping windows group to Firebird role is not working 
CREATE MAPPING TRUSTED_WSZYSCY 
USING PLUGIN WIN_SSPI 
FROM predefined_group 'rFirebird-Firebird-DBRido-ReadWrite' 
TO ROLE WSZYSCY;

this also is not working
CREATE MAPPING TRUSTED_WSZYSCY 
USING PLUGIN WIN_SSPI 
FROM predefined_group 'xCorp\rFirebird-Firebird-DBRido-ReadWrite' 
TO ROLE WSZYSCY;

i am missing something obvious?

regards,
Karol Bieniaszewski

>Hi,

>can someone point me how can i map windows group to the Firebird role?
>I have tried already

>CREATE MAPPING TRUSTED_WSZYSCY USING PLUGIN WIN_SSPI FROM predefined_group 
>'rFirebird-Firebird-DBRido-ReadWrite' TO ROLE WSZYSCY

>I have also tested with prefix xcorp\rFirebird... mapping was created but this 
>not work for me. 

>Can someone help?

>Regards, 
>Karol Bieniaszewski

---
Ta wiadomość została sprawdzona na obecność wirusów przez oprogramowanie 
antywirusowe Avast.
https://www.avast.com/antivirus

[Non-text portions of this message have been removed]



__._,_.___


Posted by: "livius"  


  Reply via web post  • Reply to sender  • Reply to group  • Start a New 
Topic  • Messages in this topic (2)  




Have you tried the highest rated email app?
 
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on 
the market. What are you waiting for? Now you can access all your inboxes 
(Gmail, Outlook, AOL and more) in one place. Never delete an email again with 
1000GB of free cloud storage.



++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++ 
Visit Your Group a.. New Members 6 
 • Privacy • Unsubscribe • Terms of Use 

.
 
 __,_._,___--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdotFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Jaybird hang on Firebird 4 with modified TcpRemoteBufferSize

[Alex Peshkoff via Firebird-devel]

On 03/27/18 20:08, Mark Rotteveel wrote:
I increased the TcpRemoteBufferSize to 32767 (the documented maximum 
value) in my firebird.conf, and when I run the full test suite of 
Jaybird, the tests hang consistently on the same test. It is blocked 
on reading from the socket during a fetch.


If I run this test in isolation it works, if I run all tests in the 
same class it works. It only happens when I run all tests. Given this 
test (like most Jaybird tests) creates a new database, it likely isn't 
a problem with the test itself.


If I disable wire encryption, it works. If I comment out 
TcpRemoteBufferSize and re-enable wire encryption, it works. If I set 
TcpRemoteBufferSize to 16384 or 32760 it also works fine.


This all suggests that maybe some data isn't flushed, or there might 
be a buffer overflow or another type of boundary issue somewhere, or 
that maybe somewhere an assumption of multiples of 8 bytes has crept in.


I'm not sure how long this problem has been there (and maybe it 
already exists in Firebird 3), 


That's the first to be checked.

I do recall having similar problems before, but I'm not sure if I 
changed TcpRemoteBufferSize when that happened (I sometimes do and 
sometimes don't change this setting). I'll see if I can find the time 
and energy later this week to run these tests on earlier snapshots and 
Firebird 3 as well, and maybe try some different values.


I hope in the meantime, that maybe one of you has an idea what the 
problem might be.




Code, related with mentioned parameters, was not much changed since fb3 
therefore I ask to check it first of all.




--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Updating README.keywords

[Mark Rotteveel]

On 27-3-2018 16:12, Alex Peshkoff via Firebird-devel wrote:

On 03/27/18 14:32, Mark Rotteveel wrote:

On 26-3-2018 18:03, Alex Peshkoff via Firebird-devel wrote:

On 03/26/18 18:37, Mark Rotteveel wrote:
I just noticed that I should also have updated README.keywords in 
https://github.com/FirebirdSQL/firebird/pull/150


But as I need to update it anyway, is it OK if I do a slightly more 
thorough overhaul? I noticed that some of the words marked with * 
are actually marked as (non-)reserved word in SQL:2016.


If not, which SQL standard was taken as a baseline?



In some old version (1.5? 2.0?) a lot of keywords were reserved. 
Somewhere about 2.1 or 2.5 most of such reserved (in violation of any 
standard) keywords were made non-reserved, as a baseline was taken 
sql-2003 or 2008, but some keywords that caused massive conflicts 
when getting non-reserved were left reserved. So we never exactly 
followed some standard, just tried to get a bit closer to one.


Ok, thanks for the explanation.

Would it be OK if I update the *-marks for those keywords not 
specified as reserved (or non-reserved) in SQL:2016?




And if you add missing fb4 keywords to it too.


Yes, I'll check if other keywords besides DECFLOAT need adding as well.


PS.
Usefulness of this file is suspicious for me. May be it's interesting 
from histrical POV that keyword SKIP was added in 1.0 and made 
non-reserved in 1.5 but I can hardly imagine any proctical use from it. 
A list of keywords, mentioniong standard/extension & 
reserverd/non-reserved, would be much more useful.


I actually find documentation like that very helpful when updating the 
version-specific list of keywords for Jaybird (see 
org.firebirdsql.jdbc.FirebirdVersionMetaData). I then still need to 
compare against SQL:2003, as a JDBC driver needs to return only those 
keywords not specified in SQL:2003.


Mark
--
Mark Rotteveel

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Jaybird hang on Firebird 4 with modified TcpRemoteBufferSize

[Mark Rotteveel]

I increased the TcpRemoteBufferSize to 32767 (the documented maximum 
value) in my firebird.conf, and when I run the full test suite of 
Jaybird, the tests hang consistently on the same test. It is blocked on 
reading from the socket during a fetch.


If I run this test in isolation it works, if I run all tests in the same 
class it works. It only happens when I run all tests. Given this test 
(like most Jaybird tests) creates a new database, it likely isn't a 
problem with the test itself.


If I disable wire encryption, it works. If I comment out 
TcpRemoteBufferSize and re-enable wire encryption, it works. If I set 
TcpRemoteBufferSize to 16384 or 32760 it also works fine.


This all suggests that maybe some data isn't flushed, or there might be 
a buffer overflow or another type of boundary issue somewhere, or that 
maybe somewhere an assumption of multiples of 8 bytes has crept in.


I'm not sure how long this problem has been there (and maybe it already 
exists in Firebird 3), I do recall having similar problems before, but 
I'm not sure if I changed TcpRemoteBufferSize when that happened (I 
sometimes do and sometimes don't change this setting). I'll see if I can 
find the time and energy later this week to run these tests on earlier 
snapshots and Firebird 3 as well, and maybe try some different values.


I hope in the meantime, that maybe one of you has an idea what the 
problem might be.


Mark
--
Mark Rotteveel

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] some issues with sed on macosx firebird master

[marius adrian popa]

Tested with
export DYLD_LIBRARY_PATH=/usr/local/opt/icu4c/lib:$DYLD_LIBRARY_PATH
export DYLD_FALLBACK_LIBRARY_PATH=/usr/local/opt/icu4c/lib

but didn't worked , i will try on a mac first to see the issue

On Fri, Mar 23, 2018 at 11:43 AM, Paul Beach 
wrote:

> > > icu is installed
> > >
> > > ls /usr/local/opt/icu4c/lib
> > >
> > > icu libicuio.59.1.dylib libicutu.59.dylib
> > > libicudata.59.1.dylib libicuio.59.dylib libicutu.a
> > > libicudata.59.dylib libicuio.a libicutu.dylib
> > > libicudata.a libicuio.dylib libicuuc.59.1.dylib
> > > libicudata.dylib libicutest.59.1.dylib libicuuc.59.dylib
> > > libicui18n.59.1.dylib libicutest.59.dylib libicuuc.a
> > > libicui18n.59.dylib libicutest.a libicuuc.dylib
> > > libicui18n.a libicutest.dylib pkgconfig
> > > libicui18n.dylib libicutu.59.1.dylib
> > >
> >
> > Very good. But sooner of all there is no path to it. Please try (first
> > of all)
> > export LD_LIBRARY_PATH=/usr/local/opt/icu4c/lib
> > This is not best way of loading ICU but OK for first attempt.
>
> DYLD_LIBRARY_PATH
>
> Regards
> Paul
>
> 
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdotFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Updating README.keywords

[Alex Peshkoff via Firebird-devel]

On 03/27/18 14:32, Mark Rotteveel wrote:

On 26-3-2018 18:03, Alex Peshkoff via Firebird-devel wrote:

On 03/26/18 18:37, Mark Rotteveel wrote:
I just noticed that I should also have updated README.keywords in 
https://github.com/FirebirdSQL/firebird/pull/150


But as I need to update it anyway, is it OK if I do a slightly more 
thorough overhaul? I noticed that some of the words marked with * 
are actually marked as (non-)reserved word in SQL:2016.


If not, which SQL standard was taken as a baseline?



In some old version (1.5? 2.0?) a lot of keywords were reserved. 
Somewhere about 2.1 or 2.5 most of such reserved (in violation of any 
standard) keywords were made non-reserved, as a baseline was taken 
sql-2003 or 2008, but some keywords that caused massive conflicts 
when getting non-reserved were left reserved. So we never exactly 
followed some standard, just tried to get a bit closer to one.


Ok, thanks for the explanation.

Would it be OK if I update the *-marks for those keywords not 
specified as reserved (or non-reserved) in SQL:2016?




And if you add missing fb4 keywords to it too.

PS.
Usefulness of this file is suspicious for me. May be it's interesting 
from histrical POV that keyword SKIP was added in 1.0 and made 
non-reserved in 1.5 but I can hardly imagine any proctical use from it. 
A list of keywords, mentioniong standard/extension & 
reserverd/non-reserved, would be much more useful.




--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Win1252 Charset on MacOS

[Alex Peshkoff via Firebird-devel]

On 03/27/18 16:47, Elmar Haneke wrote:

It will build, but deprecated implies that you might have an issue trying to
run it on 10.7 or 10.8... In any event without the fix for the _clock_gettime 
function
in configure.in your code will only run on 10.12 and no OS version below it.

By default the build is 64bit... you have to override it to get 32bit so
exporting -m64 and -arch x86_64 should be unnecessary.

Something went wrong without that - it sould not harm to have these defs.

No harm, but not necessary.

I did remove it without problems - presumably it was an leftover from
32Bit build.



For some reason compile stopped with an error when including ICU.
Therefore I did install ICU to /usr/local

What was the error?

Compiling with gcc does result in:


g++ -DBOOT_BUILD -I../src/include/gen -I../src/include -I../src/vulcan
-DNAMESPACE=Vulcan -I../extern/icu/source/common
-I../extern/icu/source/i18n -O0 -DDARWIN -pipe -MMD -fPIC -fno-common
-mmacosx-version-min=10.9 -D_THREAD_SAFE   -fvisibility-inlines-hidden
-fvisibility=hidden  -c ../src/isql/Extender.cpp -o
../temp/boot/isql/Extender.o
g++ -DBOOT_BUILD -I../src/include/gen -I../src/include -I../src/vulcan
-DNAMESPACE=Vulcan -I../extern/icu/source/common
-I../extern/icu/source/i18n -O0 -DDARWIN -pipe -MMD -fPIC -fno-common
-mmacosx-version-min=10.9 -D_THREAD_SAFE   -fvisibility-inlines-hidden
-fvisibility=hidden  -c ../src/isql/InputDevices.cpp -o
../temp/boot/isql/InputDevices.o
g++ -DBOOT_BUILD -I../src/include/gen -I../src/include -I../src/vulcan
-DNAMESPACE=Vulcan -I../extern/icu/source/common
-I../extern/icu/source/i18n -O0 -DDARWIN -pipe -MMD -fPIC -fno-common
-mmacosx-version-min=10.9 -D_THREAD_SAFE   -fvisibility-inlines-hidden
-fvisibility=hidden  -c ../src/isql/ColList.cpp -o
../temp/boot/isql/ColList.o
g++ -DBOOT_BUILD -I../src/include/gen -I../src/include -I../src/vulcan
-DNAMESPACE=Vulcan -I../extern/icu/source/common
-I../extern/icu/source/i18n -O0 -DDARWIN -pipe -MMD -fPIC -fno-common
-mmacosx-version-min=10.9 -D_THREAD_SAFE   -fvisibility-inlines-hidden
-fvisibility=hidden  -c ../src/isql/OptionsBase.cpp -o
../temp/boot/isql/OptionsBase.o
g++    ../temp/boot/isql/extract.o ../temp/boot/isql/isql.o
../temp/boot/isql/show.o ../temp/boot/isql/Extender.o
../temp/boot/isql/InputDevices.o ../temp/boot/isql/ColList.o
../temp/boot/isql/OptionsBase.o ../temp/boot/common/classes/alloc.o
../temp/boot/common/classes/locks.o
../temp/boot/common/classes/semaphore.o
../temp/boot/common/classes/fb_string.o
../temp/boot/common/classes/timestamp.o
../temp/boot/common/classes/PublicHandle.o
../temp/boot/common/classes/TempFile.o
../temp/boot/common/classes/UserBlob.o
../temp/boot/common/classes/SafeArg.o
../temp/boot/common/classes/MsgPrint.o
../temp/boot/common/classes/BaseStream.o
../temp/boot/common/fb_exception.o ../temp/boot/common/thd.o
../temp/boot/common/classes/MetaName.o
../temp/boot/common/StatusHolder.o ../temp/boot/common/classes/init.o
../temp/boot/common/StatusArg.o ../temp/boot/jrd/fbsyslog.o
../temp/boot/common/utils.o ../temp/boot/config/AdminException.o
../temp/boot/config/Args.o ../temp/boot/config/ArgsException.o
../temp/boot/config/ConfObj.o ../temp/boot/config/ConfObject.o
../temp/boot/config/ConfigFile.o ../temp/boot/config/Configuration.o
../temp/boot/config/Element.o ../temp/boot/config/FileName.o
../temp/boot/config/InputFile.o ../temp/boot/config/InputStream.o
../temp/boot/config/Lex.o ../temp/boot/config/ScanDir.o
../temp/boot/config/Stream.o ../temp/boot/config/StreamSegment.o
../temp/boot/vulcan/PathName.o ../temp/boot/vulcan/RefObject.o -o
../gen/firebird/bin/isql_static -L../gen/firebird/lib -lfbstatic  -lm
-framework CoreFoundation  -licuuc -licudata -licui18n
/Applications/Xcode.app/Contents/Developer/usr/bin/make -f
../gen/Makefile.refDatabases ref_databases
rm -f -f msg.fdb
echo create database \'msg.fdb\'\; | ../gen/firebird/bin/isql_static
dyld: Library not loaded:
/Library/Frameworks/Firebird.framework/Versions/A/Libraries/libicuuc.dylib
   Referenced from:
/Users/elmar/Firebird/firebird2_5/gen/../gen/firebird/bin/isql_static
   Reason: image not found
/bin/sh: line 1: 48401 Done    echo create database
\'msg.fdb\'\;
  48402 Abort trap: 6   | ../gen/firebird/bin/isql_static
make[2]: *** [msg.timestamp] Error 134
make[1]: *** [ref_databases] Error 2
make: *** [firebird] Error 2

I would assume that it is necessary to have an ICU installed


Or modify inTemplate & ucTemplate in unicode_util.cpp.


  - it might
be the one from an existing firebird installation which is intentionally
not present on my machine.

Having one at /usr/local does allow build with internal ICU.


Elmar


--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Win1252 Charset on MacOS

[Paul Beach]

> >> For some reason compile stopped with an error when including ICU.
> >> Therefore I did install ICU to /usr/local
> > What was the error?

> /Applications/Xcode.app/Contents/Developer/usr/bin/make -f
> ../gen/Makefile.refDatabases ref_databases
> rm -f -f msg.fdb
> echo create database \'msg.fdb\'\; | ../gen/firebird/bin/isql_static
> dyld: Library not loaded:
> /Library/Frameworks/Firebird.framework/Versions/A/Libraries/libicuuc.dylib
>   Referenced from:
> /Users/elmar/Firebird/firebird2_5/gen/../gen/firebird/bin/isql_static
>   Reason: image not found
> /bin/sh: line 1: 48401 Doneecho create database
> \'msg.fdb\'\;
>  48402 Abort trap: 6   | ../gen/firebird/bin/isql_static
> 
> Compiling with gcc does result in:
> I would assume that it is necessary to have an ICU installed - it might
> be the one from an existing firebird installation which is intentionally
> not present on my machine.
> 
> Having one at /usr/local does allow build with internal ICU.


Ahh yes, I believe superserver needs Firebird installed...
it shouldn't - but for some reason it does and I have never fully
investicated it. 
Or as you have noticed it needs to be able to find libicuuc.dylib via 
DYLD_LIBRARY_PATH

Regards
Paul



--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Win1252 Charset on MacOS

[Elmar Haneke]

> It will build, but deprecated implies that you might have an issue trying to
> run it on 10.7 or 10.8... In any event without the fix for the _clock_gettime 
> function
> in configure.in your code will only run on 10.12 and no OS version below it.

>
>>> By default the build is 64bit... you have to override it to get 32bit so
>>> exporting -m64 and -arch x86_64 should be unnecessary.
>> Something went wrong without that - it sould not harm to have these defs.
> No harm, but not necessary.

I did remove it without problems - presumably it was an leftover from
32Bit build.


>> For some reason compile stopped with an error when including ICU.
>> Therefore I did install ICU to /usr/local
> What was the error?

Compiling with gcc does result in:

> g++ -DBOOT_BUILD -I../src/include/gen -I../src/include -I../src/vulcan
> -DNAMESPACE=Vulcan -I../extern/icu/source/common
> -I../extern/icu/source/i18n -O0 -DDARWIN -pipe -MMD -fPIC -fno-common
> -mmacosx-version-min=10.9 -D_THREAD_SAFE   -fvisibility-inlines-hidden
> -fvisibility=hidden  -c ../src/isql/Extender.cpp -o
> ../temp/boot/isql/Extender.o
> g++ -DBOOT_BUILD -I../src/include/gen -I../src/include -I../src/vulcan
> -DNAMESPACE=Vulcan -I../extern/icu/source/common
> -I../extern/icu/source/i18n -O0 -DDARWIN -pipe -MMD -fPIC -fno-common
> -mmacosx-version-min=10.9 -D_THREAD_SAFE   -fvisibility-inlines-hidden
> -fvisibility=hidden  -c ../src/isql/InputDevices.cpp -o
> ../temp/boot/isql/InputDevices.o
> g++ -DBOOT_BUILD -I../src/include/gen -I../src/include -I../src/vulcan
> -DNAMESPACE=Vulcan -I../extern/icu/source/common
> -I../extern/icu/source/i18n -O0 -DDARWIN -pipe -MMD -fPIC -fno-common
> -mmacosx-version-min=10.9 -D_THREAD_SAFE   -fvisibility-inlines-hidden
> -fvisibility=hidden  -c ../src/isql/ColList.cpp -o
> ../temp/boot/isql/ColList.o
> g++ -DBOOT_BUILD -I../src/include/gen -I../src/include -I../src/vulcan
> -DNAMESPACE=Vulcan -I../extern/icu/source/common
> -I../extern/icu/source/i18n -O0 -DDARWIN -pipe -MMD -fPIC -fno-common
> -mmacosx-version-min=10.9 -D_THREAD_SAFE   -fvisibility-inlines-hidden
> -fvisibility=hidden  -c ../src/isql/OptionsBase.cpp -o
> ../temp/boot/isql/OptionsBase.o
> g++    ../temp/boot/isql/extract.o ../temp/boot/isql/isql.o
> ../temp/boot/isql/show.o ../temp/boot/isql/Extender.o
> ../temp/boot/isql/InputDevices.o ../temp/boot/isql/ColList.o
> ../temp/boot/isql/OptionsBase.o ../temp/boot/common/classes/alloc.o
> ../temp/boot/common/classes/locks.o
> ../temp/boot/common/classes/semaphore.o
> ../temp/boot/common/classes/fb_string.o
> ../temp/boot/common/classes/timestamp.o
> ../temp/boot/common/classes/PublicHandle.o
> ../temp/boot/common/classes/TempFile.o
> ../temp/boot/common/classes/UserBlob.o
> ../temp/boot/common/classes/SafeArg.o
> ../temp/boot/common/classes/MsgPrint.o
> ../temp/boot/common/classes/BaseStream.o
> ../temp/boot/common/fb_exception.o ../temp/boot/common/thd.o
> ../temp/boot/common/classes/MetaName.o
> ../temp/boot/common/StatusHolder.o ../temp/boot/common/classes/init.o
> ../temp/boot/common/StatusArg.o ../temp/boot/jrd/fbsyslog.o
> ../temp/boot/common/utils.o ../temp/boot/config/AdminException.o
> ../temp/boot/config/Args.o ../temp/boot/config/ArgsException.o
> ../temp/boot/config/ConfObj.o ../temp/boot/config/ConfObject.o
> ../temp/boot/config/ConfigFile.o ../temp/boot/config/Configuration.o
> ../temp/boot/config/Element.o ../temp/boot/config/FileName.o
> ../temp/boot/config/InputFile.o ../temp/boot/config/InputStream.o
> ../temp/boot/config/Lex.o ../temp/boot/config/ScanDir.o
> ../temp/boot/config/Stream.o ../temp/boot/config/StreamSegment.o
> ../temp/boot/vulcan/PathName.o ../temp/boot/vulcan/RefObject.o -o
> ../gen/firebird/bin/isql_static -L../gen/firebird/lib -lfbstatic  -lm 
> -framework CoreFoundation  -licuuc -licudata -licui18n
> /Applications/Xcode.app/Contents/Developer/usr/bin/make -f
> ../gen/Makefile.refDatabases ref_databases
> rm -f -f msg.fdb
> echo create database \'msg.fdb\'\; | ../gen/firebird/bin/isql_static
> dyld: Library not loaded:
> /Library/Frameworks/Firebird.framework/Versions/A/Libraries/libicuuc.dylib
>   Referenced from:
> /Users/elmar/Firebird/firebird2_5/gen/../gen/firebird/bin/isql_static
>   Reason: image not found
> /bin/sh: line 1: 48401 Done    echo create database
> \'msg.fdb\'\;
>  48402 Abort trap: 6   | ../gen/firebird/bin/isql_static
> make[2]: *** [msg.timestamp] Error 134
> make[1]: *** [ref_databases] Error 2
> make: *** [firebird] Error 2

I would assume that it is necessary to have an ICU installed - it might
be the one from an existing firebird installation which is intentionally
not present on my machine.

Having one at /usr/local does allow build with internal ICU.


Elmar


--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at 

Re: [Firebird-devel] Updating README.keywords

[Mark Rotteveel]

On 26-3-2018 18:03, Alex Peshkoff via Firebird-devel wrote:

On 03/26/18 18:37, Mark Rotteveel wrote:
I just noticed that I should also have updated README.keywords in 
https://github.com/FirebirdSQL/firebird/pull/150


But as I need to update it anyway, is it OK if I do a slightly more 
thorough overhaul? I noticed that some of the words marked with * are 
actually marked as (non-)reserved word in SQL:2016.


If not, which SQL standard was taken as a baseline?



In some old version (1.5? 2.0?) a lot of keywords were reserved. 
Somewhere about 2.1 or 2.5 most of such reserved (in violation of any 
standard) keywords were made non-reserved, as a baseline was taken 
sql-2003 or 2008, but some keywords that caused massive conflicts when 
getting non-reserved were left reserved. So we never exactly followed 
some standard, just tried to get a bit closer to one.


Ok, thanks for the explanation.

Would it be OK if I update the *-marks for those keywords not specified 
as reserved (or non-reserved) in SQL:2016?


Mark
--
Mark Rotteveel

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] CORE-2998 can be closed

[marius adrian popa]

Not Firebird Core related
http://tracker.firebirdsql.org/browse/CORE-2998
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdotFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel