Re: [Firebird-devel] isc_dpb_dbkey_scope

[Paul Beach]

>How is subj supposed to work? I see that it forces engine to start a 
> transaction and that's all.

It maintains all the rdb$db_key values for the length of a connection - i.e.
they are not allowed to change. An internal transaction gets started for this.
It was introduced to support Cognos' Powerhouse 4GL product which made 
extensive 
use of db_keys.

Obviously it can have issues re. garbage collection...

Regards
Paul


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] MacOS problem with dlclose

[Paul Beach]

> On 24/01/2022 06:50, Alex Peshkoff via Firebird-devel wrote:
> > On 1/24/22 12:28, Alex Peshkoff via Firebird-devel wrote:
> > 
> >> for FB3 and may be fb4 option 1 is a way to go.
> > 
> > BTW, looks like we have 3.0.9 release soon.
> > 
> 
> As I talked earlier, FB 3 apparently was not affected.
> 
> Now looking for details I see that configure.ac has:
> 
> case $host in
> *-darwin*)
> ac_cv_func_clock_gettime=no
> ;;
> *)
>   AC_SEARCH_LIBS(clock_gettime, rt)
> AC_CHECK_FUNCS(clock_gettime)
> ;;
> esac
> 
> Leading to imprecise curTime() (MasterImplementation), not firing timers
> in correct moment.
> 
> This is introduced in this commit:
> 
> commit 20542beae18d13c3d2453a9ac2af51b095136c16
> Author: paulbeach 
> Date:   Mon Jul 17 14:13:23 2017 +0200
> 
> clock_gettime is only supported on 10.12, but lazy binding means
> that the code will compile even though version-min is set to 10.7 and
> Firebird will then throw a run time error on any versions of OSX post
> 10.7 and pre 10.12 - disable the function
> 
> 
> Should this be maintained in FB 3?

No, Min version now for 3.0.8 is 10.15

Regards
Paul


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Thread about Jaybird / Firebird Embedded crash on firebird-java

[Paul Beach]

Mark,

> On 23-07-2021 10:26, Mark Rotteveel wrote:
> > On 23-07-2021 10:06, Vlad Khorsun wrote:
> >> 23.07.2021 10:50, Mark Rotteveel wrote:
> >>> Hi,
> >>>
> >>> Last week a question was asked on firebird-java regarding a JVM crash 
> >>> on Linux when Firebird Embedded is used in combination with a UDF, 
> >>> but to be honest, I have no clue what to look for.
> >>>
> >>> I have been able to reproduce the crash (or possibly even two 
> >>> different crashes) with the application and basic UDF provided by the 
> >>> OP. Can someone look at 
> >>> https://groups.google.com/g/firebird-java/c/22G7zPGNnkY?
> >>
> >>Since you are able to reproduce the crash - could you provide us 
> >> with stack backtrace ?
> >> Also, I saw no mention of messages in firebird.log - could you check 
> >> it also ?
> > 
> > 
> > Thanks, I'll try to get that information tomorrow or Sunday.
> 
> Unfortunately, I don't know enough about Linux or about Firebird on 
> Linux to get any further on this. The Firebird install I have on Linux 
> doesn't seem to have debugging symbols available, so I'm simply stuck 
> there. I have asked the OP from the thread on firebird-java to come 
> here. Maybe they can get more info.

This might help

https://www.ibphoenix.com/resources/documents/search/doc_36

Regards
Paul



Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Invalid SPB

[Paul Beach]

> > BTW, anybody remembers the reason why version 2 has two values - 
> > isc_spb_version, isc_spb_current_version - at the beginning?
> >
> 
> Sooner of all this should be asked in Borland / Inprise - that was so in 
> IB6.0.

No obvious explanation but its the best you will get
https://www.ibphoenix.com/resources/documents/search/doc_186

Regards
Paul



Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] LibreOffice Patch : Can't use System V semaphores in a sandboxed macOS process

[Paul Beach]

>

Not really

https://github.com/FirebirdSQL/firebird/commit/6ec7a10aa3b772527320729b6c67d6bc83258d39=

Paul



Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] MacOS build sometimes hangs

[Paul Beach]

> On 28/11/2019 05:57, Paul Beach wrote:
> >> More or less related question. As far as I know latest builds done by 
> >> Paul Beach were done using llvm. gcc had some problems. May be try llvm 
> >> instead it?
> > Alex is correct, LLVM/Clang is now the default compiler on MacOS, and
> > thats what we currently use to build Firebird.
> >
> >
> But look:
> 
> Travis:
> 
> $ g++ --version
> Configured with:
> --prefix=/Applications/Xcode-9.2.app/Contents/Developer/usr
> --with-gxx-include-dir=/usr/include/c++/4.2.1
> Apple LLVM version 9.0.0 (clang-900.0.39.2)
> Target: x86_64-apple-darwin16.7.0
> Thread model: posix
> InstalledDir:
> /Applications/Xcode-9.2.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin
> 
> $ clang++ --version
> Apple LLVM version 9.0.0 (clang-900.0.39.2)
> Target: x86_64-apple-darwin16.7.0
> Thread model: posix
> InstalledDir:
> /Applications/Xcode-9.2.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin
> 
> 
> 
> GitHub:
> 
> $ g++ --version
> Configured with: --prefix=/Applications/Xcode.app/Contents/Developer/usr
> --with-gxx-include-dir=/Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX.sdk/usr/
> include/c++/4.2.1
> Apple clang version 11.0.0 (clang-1100.0.33.8)
> Target: x86_64-apple-darwin19.0.0
> Thread model: posix
> InstalledDir:
> /Applications/Xcode_11.1.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin
> 
> $ clang++ --version
> Apple clang version 11.0.0 (clang-1100.0.33.8)
> Target: x86_64-apple-darwin19.0.0
> Thread model: posix
> InstalledDir:
> /Applications/Xcode_11.1.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin
> 
> 
> 
> g++ in both env. seems just the frontend, using LLVM/clang backend.
> Is this still problematic and should use clang frontend as well?

Nope g++ is invoked on my MacBook Pro running High Sierra 10.13.6
which then defaults to LLVM/Clang

gcc -v
Configured with: --prefix=/Applications/Xcode.app/Contents/Developer/usr 
--with-gxx-include-dir=/usr/include/c++/4.2.1
Apple LLVM version 10.0.0 (clang-1000.11.45.5)
Target: x86_64-apple-darwin17.7.0
Thread model: posix
InstalledDir: 
/Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin

So this is not the cause of the hangs by the look of it.

Regards
Paul




Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] MacOS build sometimes hangs

[Paul Beach]

> More or less related question. As far as I know latest builds done by 
> Paul Beach were done using llvm. gcc had some problems. May be try llvm 
> instead it?

Alex is correct, LLVM/Clang is now the default compiler on MacOS, and
thats what we currently use to build Firebird.

Paul 


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] MacOS build

[Paul Beach]

Adriano,

> I'm trying to setup github-actions with MacOS build.
> Guess what? Errors after errors.
> Is the master code supposed to build without patches? 

I haven't looked at building MacOS on master, mainly because its a port,
so I wait until the code stabilises before I start working on it so its going 
to die
a horrible death until Alex and I look at it in detail.

Firebird 3 should build OK...

first you need to install a copy of ICU and build it.
then you need to set the CFLAGS, LDFLAGS, and CXXFLAGS as per 
prefix.darwin_x86_64
Make sure you use builtin-libtommath


Regards
Paul





Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] How to fb 3.0.4 embedde in android with delphi 10.2

[Paul Beach]

>

I don't know about Android, but Windows and Linux

https://www.ibphoenix.com/files/Embedded_fb3.pdf

MacOSX

http://paulbeachsblog.blogspot.com/2019/09/firebird-3-embedded-on-macosx.html

Regards
Paul



Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Build, install and test 3.0 on Debian 10

[Paul Beach]

> I try to make and test "my own" build with Debian 10. First with default 
> settings, just execute "autogen.sh", "make" and "make install" without 
> any modification. At the last step I got the next problem:
> 
> 
> Firebird 3.0.5.33140-0.amd64 Installation
> 
> Press Enter to start installation or ^C to abort
> Extracting install data
> Please enter new password for SYSDBA user: masterkey
> /usr/local/firebird/bin/gsec: error while loading shared libraries: 
> libfbclient.so.2: cannot open shared object file: No such file or directory

a, is there a findable symlink from libfbclient.so.2 to the real name of
libfbclient (probably libfbclient.so.3.0.5)
b, is the installer creating it?

Paul


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] ? Firebird 3 embedded om iOS?

[Paul Beach]

> > > Thank you very much for the answer. Adrian Marius Popa wrote in 
> > > October a blog post regarding Firebird 3 (and 2.5) on iOS: 
> > > https://mapopa.blogspot.com/2017/10/firebird-3-on-apple-ios.html?m=1
> > >
> > > The blog post contains little information other than that it is 
> > > possible. For technical details it refers the reader to this mailing 
> > > list. It does though say that the Mac OS X release of Firebird 3.0.3 
> > > contains a Mach-O dynamically linked shared library for arm_v7 that 
> > > can be used on iOS.
> > >
> > > I would like to work on getting Firebird 3 running on iOS. Can anyone 
> > > give some clues to get me started?
> > >
> > 
> > First of all you need a tool to perform cross build of firebird (suppose 
> > ideal host platform is Mac). There is a sample of cross building FB on 
> > linux for android. It has 2 key files - builds/posix/make.android.arme 
> > (mentioned in ./configure command line as 
> > --with-cross-build=android.arme) which defines in 
> > CROSS_CONFIG=android.arme seconf key file 
> > src/include/cross/android.arme. You should create replacement of this 
> > files for iOS on arm_v7 and after is start cross-build. Pay attention 
> > that first of all almost full build for host is done in order to be able 
> > to run FB tools needed for the build. After it set of target binaries is 
> > built.
> 
> The specific command line I used when I was looking at this last was 
> /Users/pbeach/icu54/icu/source/configure --host=arm-apple-darwin 
> --enable-static --disable-shared 
> -with-cross-build=/Users/pbeach/icu54/icu/armBuild

Note this was when Apple insisted on static linking for ios and I was trying to 
see if
a static build of Firebird was possible (it isn't) nowadays AFAIR dynamic
linking is now allowed and I did manage to build 2.5 dynamically for ios.

So you can remove  --enable-static --disable-shared

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] ? Firebird 3 embedded om iOS?

[Paul Beach]

> > Thank you very much for the answer. Adrian Marius Popa wrote in 
> > October a blog post regarding Firebird 3 (and 2.5) on iOS: 
> > https://mapopa.blogspot.com/2017/10/firebird-3-on-apple-ios.html?m=1
> >
> > The blog post contains little information other than that it is 
> > possible. For technical details it refers the reader to this mailing 
> > list. It does though say that the Mac OS X release of Firebird 3.0.3 
> > contains a Mach-O dynamically linked shared library for arm_v7 that 
> > can be used on iOS.
> >
> > I would like to work on getting Firebird 3 running on iOS. Can anyone 
> > give some clues to get me started?
> >
> 
> First of all you need a tool to perform cross build of firebird (suppose 
> ideal host platform is Mac). There is a sample of cross building FB on 
> linux for android. It has 2 key files - builds/posix/make.android.arme 
> (mentioned in ./configure command line as 
> --with-cross-build=android.arme) which defines in 
> CROSS_CONFIG=android.arme seconf key file 
> src/include/cross/android.arme. You should create replacement of this 
> files for iOS on arm_v7 and after is start cross-build. Pay attention 
> that first of all almost full build for host is done in order to be able 
> to run FB tools needed for the build. After it set of target binaries is 
> built.

The specific command line I used when I was looking at this last was 
/Users/pbeach/icu54/icu/source/configure --host=arm-apple-darwin 
--enable-static --disable-shared 
-with-cross-build=/Users/pbeach/icu54/icu/armBuild

If you want my autconfig file for arm_v7 ask.

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] Firebird 3 embedded om iOS

[Paul Beach]

> I am sorry if this has been covered somewhere already, but I would like to 
> know what it would take run Firebird 3 
> embedded on iOS. 

An appropriate build for iOS. Its not impossible and is in fact perfectly 
feasible, 
I just think no-one has really tried to do it.

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] Suppress database encryption callback

[Paul Beach]

> 13.04.2018 17:01, Mark Rotteveel wrote:
> > Let me rephrase: exactly what causes Firebird to perform a callback to the 
> > client, and 
> > what must a KeyHolderPlugin do to make sure no callback is performed.
> 
>Firebird calls client callback when key holder in keyCallback() calls the 
> callback 
> received in parameters.
>If the holder don't call the callback - no callback is performed.
> 
>Code example:
> 
> int KeyHolderSample::keyCallback(CheckStatusWrapper* status, 
> ICryptKeyCallback* callback)
> {
> // Here Firebird will send callback request to client
> // Comment this line out to disable client callback
>  return callback->callback(0, NULL, sizeof(Buffer), Buffer);
> }

S in theory, you could put an if scenario around that...
i.e. if KeyFile no callback
if Callback, callback?

Correct?

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

[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

[Paul Beach]

> > Where did you get the code you are using from? Ideally you should have got 
> > it
> > from github B2_5_Release.
> 
> It's not from Github but official tarbal fom firebirdsql.org.

Which does not contain the few changes I added to make it build properly after
2.5.8 was released on Linux and Windows
 
> > -mmacosx-version-min=10.7 is now -mmacosx-version-min=10.9 libstdc++
> > has been deprecated. 
> 
> I'm going to change that on next builds. But currently seems to wokt
> with 10.7 setting. Indeed I do not have an 10.7 at hand to test it.

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.

> > --with-system-icu? Apple don't ship a proper full ICU with the OS, you 
> > should be using the one
> > provided with Firebird.
> 
> For some reason compile stopped with an error when including ICU.
> Therefore I did install ICU to /usr/local

What was the error?

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] some issues with sed on macosx firebird master

[Paul Beach]

> > 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

Re: [Firebird-devel] Win1252 Charset on MacOS

[Paul Beach]

 
> An real debug-build did make the crash vanish therefore no further
> stacktrace.
> 
> After switching to -O0 the problem is vanished, with -O1 it does fail

Right and thats the right thing to do  - I found and fixed this for 2.5.8 
release 
- thats why I asked what optimisation level you were using. There seems to be a 
problem with OSX/Clang when it tries to optimise the code in that particular 
place.

Where did you get the code you are using from? Ideally you should have got it
from github B2_5_Release.
 
> Overall I did configure FirebirsSQL like this:
> 
> > export CFLAGS='-m64 -O0 -arch x86_64 -mmacosx-version-min=10.7'
> > export CXXFLAGS='-m64 -O0 -arch x86_64 -mmacosx-version-min=10.7'

-mmacosx-version-min=10.7 is now -mmacosx-version-min=10.9 libstdc++ has been 
deprecated.

> > export CXX="clang++ $CFLAGS"
> > export CC="clang $CXXFLAGS"
> >
> > #!/bin/sh
> > ./configure \
> > --build=x86_64-darwin \
> > --without-fbsample \
> > --without-fbsample-db \
> > --without-fbdoc \
> > --without-fbhelp \
> > --disable-largefile \
> > --without-fbplugins \
> > --with-system-icu
> 
> the Exports at top cannot be ommitted, there is some trouble within
> configure script consistently switching to 64Bit code generation.

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

--with-system-icu? Apple don't ship a proper full ICU with the OS, you should 
be using the one
provided with Firebird.

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

[Paul Beach]

> >> After compiling firebird 2.5.8 on latest MacOS I run into problem that
> >> win1252 charset seems to crash software when using embedded to open
> >> local database file.
> >>
> >> When charset is specified on connect crash does happen there.
> >> When connect is done using UTF8 crash does happen as soon as an table
> >> defined with win1252 charset is accessed with reading sorted rows.
> >>
> >> How can I avoid (or further investigate) that problem?
> > ? When you compiled it - what optimisation level did you use (if any)?
> 
> just the defaults from configure script. Compilation is done using XCode
> gcc-frontend.

Do a debug build, enable crash dumps, post the full back trace from the crashes.

ulimit -c unlimited
the core file should be placed in /cores

I assume you are building with the latest version of XCode and Clang,
therefore lldb will be your debugger

lldb -c core.nn
thread backtrace all

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

[Paul Beach]

> >> After compiling firebird 2.5.8 on latest MacOS I run into problem that
> >> win1252 charset seems to crash software when using embedded to open
> >> local database file.
> >>
> >> When charset is specified on connect crash does happen there.
> >> When connect is done using UTF8 crash does happen as soon as an table
> >> defined with win1252 charset is accessed with reading sorted rows.
> >>
> >> How can I avoid (or further investigate) that problem?
> > ? When you compiled it - what optimisation level did you use (if any)?
> 
> just the defaults from configure script. Compilation is done using XCode
> gcc-frontend.

Email me privately, tell me exactly how you build fireird and
then explain to me exactly how to reproduce the problem. When I get chance
I will take a look at it.

Unfortunately I am pretty busy at the moment.

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

[Paul Beach]

> After compiling firebird 2.5.8 on latest MacOS I run into problem that
> win1252 charset seems to crash software when using embedded to open
> local database file.
> 
> When charset is specified on connect crash does happen there.
> When connect is done using UTF8 crash does happen as soon as an table
> defined with win1252 charset is accessed with reading sorted rows.
> 
> How can I avoid (or further investigate) that problem?

? When you compiled it - what optimisation level did you use (if any)?

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] Firebird 3.0.3 build on Fedora rawhide icu 60.2

[Paul Beach]

Philippe,

> firebird-3.0.3.32900 doesn't build on Fedora rawhide with icu 60.2
>
> Any idea on how to fix it ?
>
> error: 'char16_t' does not name a type; did you mean 'charset'?
> error: 'UChar' does not name a type; did you mean 'UChar32'?
>
> etc..
>
> Log:
>
> https://paste.fedoraproject.org/paste/o4g95lyp3QPMWO80NfwM3A
>

Saw this on the icu support list.. re. the following

  // The error is:
  aCC -DU_ATTRIBUTE_DEPRECATED= -D_REENTRANT -D_THREAD_SAFE  -DU_HAVE_ELF_H=1 
-DU_HAVE_ATOMIC=0 -DU_HAVE_STRTOD_L=0  -I../common
+O2 +Ofltacc  +DD64 -mt   -AA -Wc,-ansi_for_scope,on +W740 +W749 +W823 +W4232 
-c  +Z -o stubdata.o stubdata.cpp
"../common/unicode/umachine.h", line 347: error #2020: identifier "char16_t"
  is undefined
  typedef char16_t UChar;

  // my steps:
  cd xx/icu602_hpia64/source
  chmod +x runConfigureICU configure install-sh
  ./runConfigureICU  HP-UX/ACC -with-library-bits=64
  gmake  // got error here.

The response...

As of version 59, ICU4C now uses and requires C++11 language features and 
libraries.
According to http://en.cppreference.com/w/cpp/compiler_support , the aCC 
compiler doesn't fully support C++11 yet.
However, it looks like it does support the new character types (char16_t and 
char32_t), but you don't get C++11 support by default
though.
According to the manual ( 
https://support.hpe.com/hpsc/doc/public/display?docId=emr_na-c04221956) for the 
aCC compiler, you need to
use a command line switch to enable the C++11 support.
>From the manual:
+std=c++11This option turns on support for several core language 
features introduced by the ISO C++11 language standard.
Can you try adding this option, and see if it works?

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] About support for embed into iOS/Android

[Paul Beach]

Karol,

<>

Then please feel free to add an item to the tracker, and we will see...
If there is enough interest maybe people would be prepared to fund the
development work...

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] About support for embed into iOS/Android

[Paul Beach]

> But since nobody seemed to want it, I stopped work on it.
> Its not a simple exercise

>

Thats your opinion, I did a port for firebird 2.x a few years ago...

http://paulbeachsblog.blogspot.fr/2013/09/an-update-about-firebird-on-ios.html

I got virtually no feed back, which maked me wonder who, other that yourself 
actually
wants it... if there were any serious users who wanted this they could have let 
me know,
I work for a company that specialises in Firebird development, support and 
consulting.

On a plus point - thankfully nowadays there is no need for 
a statically combined binary

<>

Its an open source database which is truly open source, i.e. anybody
can download and use it with any type of application without having to
worry about licensing issues. Money given to the Firebird Foundation is
spent on development not marketing...

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] About support for embed into iOS/Android

[Paul Beach]

Mario,

<= 8 and Android Api >= 24).>>

You are the first and only person to date who has expressed any interest in 
this. 
I managed to build Firebird 2.x on IOS, and got as far as getting the 3.x 
libfbclient to 
cross compile for IOS. But since nobody seemed to want it, I stopped work on 
it. 
Its not a simple exercise. Mind you if somebody wanted to help subsidise the 
work, I would be prepared to continue

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-odbc-devel] ODBC connection problem

[Paul Beach]

Please take a look at this...

https://www.ibphoenix.com/files/installing_firebird_odbc_driver.pdf

Regards
Paul

-Original Message-
From: Angel Tomov [mailto:angeltomov1...@gmail.com]
Sent: 17 January 2018 11:12
To: firebird-odbc-devel@lists.sourceforge.net
Subject: [Firebird-odbc-devel] ODBC connection problem


Hello,


My name is Angel Tomov and I am a BI developer.
 
My latest client is using Firebird 2.5 database. 


I have downloaded firebird ODBC drivers  and Firebird .dll’s from 
https://firebirdsql.org/en/odbc-driver/
 
 
My machine is x64, so I downloaded odbc x64.
 
 
After I have installed the driver and copy/paste the .dll’s from 
OdbcFb_DLL_2.0.5.156_x64.zip into Windows/System32
 
 
 
Whenever I try to test the connection, ODBC administrator crashes. 


I have Administrator Rights, and I am using Windows Server 2016. 
 
I have tried with both, x32 and x64. 


Any help will be highly appreciated,

Sincerely Yours, Angel Tomov
 
 
Sent from Mail for Windows 10
 


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

[Firebird-devel] Something of interest to some perhaps....

[Paul Beach]

pwd = /Users/pbeach/30ios/gen/Release/firebird/lib
MacPro:lib pbeach$ file libfb*
libfbclient.dylib.3.0.3: Mach-O dynamically linked shared library arm_v7

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

[Firebird-devel] Firebird 3.0.3 for MacOSX

[Paul Beach]

A beta version of a 64bit Firebird 3.0.3 for MacOSX is now available as a 
download 
http://www.ibphoenix.com/download/firebird/30
for those of you who might be interested in trying it.

Regards
Paul Beach
Tel (France): +33 (0) 2 47 58 30 43
Mob (France): +33 (0) 6 79 24 32 32



--
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] Firebird 3.x MacOSX

[Paul Beach]

Et al,

I have a beta installer of 64bit Firebird 3.0.3 running on MacOSX.
It runs by default as SuperServer currently (as it should) with no 
simple way to switch to Classic. That work needs to be finished.
If any one wants copy to download an install and test - please email me.

Regards
Paul Beach
Tel (France): +33 (0) 2 47 58 30 43
Mob (France): +33 (0) 6 79 24 32 32



--
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] hello world example of gpre requested

[Paul Beach]

<>

I have some cobol samples - on paper.
I have used gpre fairly extensively over the years, but you are right
in terms of deprecation, it doesn't support new features and its very
long in the tooth. Adding cobol support to Firebird by doing a build
isn't complicated, a simple

./configure –with-gpre-cobol
make

Should do the trick.

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] gpre cobol can't access memory segfault with trace

[Paul Beach]

> I ran a back trace on it as per Brian Tiffin's suggestion at gnucobol. I
> was able to use gdb.

I believe gnucobol is an implementation of opencobol, in which case this
is probably relevant...

http://www.ibphoenix.com/resources/documents/search/doc_382

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] Firebird 3.x on MacOS

[Paul Beach]

I will try and do my best to revisit the MacOS build once 3.0.2 comes out 
(which is 
likely to be very shortly).

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

[Firebird-devel] Firebird 3.x on MacOS

[Paul Beach]

A question by Vlad has prompted me to write this brief message...

Some of you may have noticed that we have no official installer for 
Firebird 3.x on MacOSX... to date thats been down to me, and on 
my todo list when I get enough time. I have started work on it
but I haven't been able to finish it. Other commitments keep
getting in the way. Firebird 3 compiles and runs fine on 
the latest version of MacOSX and Clang. Setting up the build
is a bit complicated, but if anyone would like to step in and 
help I am more than happy to offer advice where necessary.

Volunteers?

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] Firebird 3 on MacOS not working as an embedded server

[Paul Beach]

> I think placed plugins/libEngine12.dylib one level above (not beneath) my bin 
> folder, and now my CREATE statement works!

Hmm the default build for Firebird on MacOSX creates a framework, and all the 
libraries/binaries 
(where applicable - libfbclient) have the framework location built into them, 
you can verify
this by using otool -L

However code was added to config_root.cpp to simulate binreloc (posix) on 
MacOSX. so it can 
find the name of the excutable in the directory below firebird, strip the 
executable name, strip 
the lowest directory, now use the remainder to find the configuration file, 
firebird.conf, and read 
the conf file to get the actual RootDirectory for Firebird so an embedded 
version can work in the
way that you suggest...i.e plugins will expect to be found one level down from 
wherever FIREBIRD
is assumed to be (the location of firebird.conf). 

If you really want to proper embedded version of Firebird for your application 
you will need to do
some work with install_name_tool 
cf
http://paulbeachsblog.blogspot.fr/2012/09/firebird-embedded-on-macosx.html

or change the build so it doesn't default to a framework...

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] alloc.h global operator new replacement violating alignment requirements

[Paul Beach]

On 17/02/2017 09:39, Stephan Bergmann wrote:
> On 02/17/2017 12:24 PM, Alex Peshkoff wrote:
>> On 02/17/17 14:15, Stephan Bergmann wrote:
>>
>> This idea seems to be much better than DEBUG_GDS_ALLOC:
>>
>>> Since LibreOffice builds intended for widespread distribution are on
>>> Linux usually done with GCC not Clang, this shouldn't have a performance
>>> impact.)
>> But what makes me surprised - I know that at least one of FB developers
>> often does build firebird using clang (Adriano - is it so?). And we
>> never used to meet such issues before. What changed? New version? Too
>> good optimization flags?
> I think this aggressive alignment-assumption behavior is new with 
> upcoming Clang 4.  (And you need at least -O optimization for such 
> problematic MOVAPS code to be produced.)

Clang is also the default compiler on MacOSX nowadays 

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] LibreOffice 5.3.0 is using firebird 3.0

[Paul Beach]

On 9-2-2017 11:03, Paul Beach wrote:
> "Since a future version of firebird will have a backwards compatibility
> module, some future version of LibreOffice (embedding this future
> version of firebird) will also be able to open these older files."
>
> < and earlier compatibility will come in the (near) future. This was
> essentially promised in the 3.0 release notes, see
> https://www.firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-engine.html#rnfb30-engine-providers
> under "Other providers".
>
> And yes, I know it says *may* in "A suitable provider may be considered
> for inclusion in a later sub-release.", but that is not how people read
> this.
>
> Is there any progress in that area?>>
>
> IBPhoenix has written one.

<>

I was hoping to recoup at least the cost of development...

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] LibreOffice 5.3.0 is using firebird 3.0

[Paul Beach]

> LibreOffice Release notes
>
> https://wiki.documentfoundation.org/ReleaseNotes/5.3#Base
>
> And hackernews
>
> https://news.ycombinator.com/item?id=13542234

"Since a future version of firebird will have a backwards compatibility 
module, some future version of LibreOffice (embedding this future 
version of firebird) will also be able to open these older files."

>

IBPhoenix has written one.

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] When will version 3.0 be available for Mac OS X ?

[Paul Beach]

>

>From my notes (so far):

ICU
Amend config/mh-darwin
Note install-path LD_SONAME

## Compiler switches to embed a library name and version informationifeq 
($(ENABLE_RPATH),YES)
LD_SONAME = -Wl,-compatibility_version -Wl,$(SO_TARGET_VERSION_MAJOR) -Wl,-curre
nt_version -Wl,$(SO_TARGET_VERSION) -install_name $(libdir)/$(notdir $(MIDDLE_SO
_TARGET))
else
LD_SONAME = -Wl,-compatibility_version -Wl,$(SO_TARGET_VERSION_MAJOR) -Wl,-curre
nt_version -Wl,$(SO_TARGET_VERSION) -install_name /Library/Frameworks/Firebird.f
ramework/Versions/A/Libraries/$(notdir $(MIDDLE_SO_TARGET))
endif

Build ICU
ICU ./configure --enable-renaming=no

Set for ./autogen.sh (--with-builtin-libtommath?)
  ./configure

CFLAGS
(ucnv.h)-I/Users/homedir/icu54/icu/source/common
(libtommath.h)  -I/opt/local/include/libtommath

LDFLAGS
(-licuuc)   -L/Users/homedir/icu54/icu/source/lib
(-ltommath) -L/opt/local/lib

for make

CXXFLAGS
(ucnv.h)-I/Users/homedir/icu54/icu/source/common
(libtommath.h)  -I/opt/local/include/libtommath
(utrans.h)  -I/Users/homedir/icu54/icu/source/i18n


--
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Firebird3 build fails on MacOsX

[Paul Beach]

>

http://paulbeachsblog.blogspot.fr/2016/03/dyldlibrarypath-and-el-capitan.html

Regards
Paul

--
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Building Firebird 3.0 sometimes fails with aSIGSEGV in gfix

[Paul Beach]

> When building Firebird 3.0 as part of LibreOffice (on Linux), it 
> occasionally happens that the build fails with
> 
> ...
> > rm -f ../../gen/examples/employee.fdb
> > ./empbuild ../../gen/examples/employee.fdb
> > creating database ../../gen/examples/employee.fdb
> > Turning forced writes off
> > Couldn't turn forced writes off (139)
> > Makefile.examples:125: recipe for target '../../gen/examples/employee.fdb' 
> > failed

You probably need Michal Kubecek's patch

OpenSuSE >= 13.1 adds minor version into ICU soname to cope with
repeated upstream ABI breakages. We therefore need to make
unicode_util functions adapt to this.
---
 src/common/unicode_util.cpp | 23 ++-
 1 file changed, 18 insertions(+), 5 deletions(-)

diff --git a/src/common/unicode_util.cpp b/src/common/unicode_util.cpp
index ba77825f4a64..89149c74410a 100644
--- a/src/common/unicode_util.cpp
+++ b/src/common/unicode_util.cpp
@@ -52,6 +52,8 @@
 
 // The next major ICU version after 4.8 is 49.
 #define ICU_NEW_VERSION_MEANING49
+// openSUSE >= 13.1 adds minor version to soname
+#define ICU_VERSION_SUSE_HACK 51
 
 
 using namespace Firebird;
@@ -347,7 +349,9 @@ static void formatFilename(PathName& filename, const char* 
templateName,
int majorVersion, int minorVersion)
 {
string s;
-   if (majorVersion >= ICU_NEW_VERSION_MEANING)
+   if (majorVersion >= ICU_VERSION_SUSE_HACK)
+   s.printf("%d_%d", majorVersion, minorVersion);
+   else if (majorVersion >= ICU_NEW_VERSION_MEANING)
s.printf("%d", majorVersion);
else
s.printf("%d%d", majorVersion, minorVersion);
@@ -970,13 +974,20 @@ UnicodeUtil::ICU* UnicodeUtil::loadICU(const string& 
icuVersion, const string& c
, );
 
if (n == 1)
-   minorVersion = 0;
+   {
+   n = sscanf((*i == "default" ? version : *i).c_str(), 
"%d_%d",
+   , );
+   if (n == 1)
+   minorVersion = 0;
+   }
else if (n != 2)
continue;
 
string configVersion;
 
-   if (majorVersion >= ICU_NEW_VERSION_MEANING)
+   if (majorVersion >= ICU_VERSION_SUSE_HACK)
+   configVersion.printf("%d_%d", majorVersion, 
minorVersion);
+   else if (majorVersion >= ICU_NEW_VERSION_MEANING)
{
minorVersion = 0;
configVersion.printf("%d", majorVersion);
@@ -1138,7 +1149,7 @@ UnicodeUtil::ConversionICU& 
UnicodeUtil::getConversionICU()
LocalStatus ls;
CheckStatusWrapper lastError();
string version;
-   const int majorArray[] = {5, 4, 3, 6, 0};
+   const int majorArray[] = {5, 51, 52, 53, 54, 55, 56, 57, 58, 59, 4, 3, 
6, 0};
 
for (const int* major = majorArray; *major; ++major)
{
@@ -1180,7 +1191,9 @@ string UnicodeUtil::getDefaultIcuVersion()
string rc;
UnicodeUtil::ConversionICU& icu(UnicodeUtil::getConversionICU());
 
-   if (icu.vMajor >= ICU_NEW_VERSION_MEANING)
+   if (icu.vMajor >= ICU_VERSION_SUSE_HACK)
+   rc.printf("%d_%d", icu.vMajor, icu.vMinor);
+   else if (icu.vMajor >= ICU_NEW_VERSION_MEANING)
rc.printf("%d", icu.vMajor);
else
rc.printf("%d.%d", icu.vMajor, icu.vMinor);

Regards
Paul


--
The Command Line: Reinvented for Modern Developers
Did the resurgence of CLI tooling catch you by surprise?
Reconnect with the command line and become more productive. 
Learn the new .NET and ASP.NET CLI. Get your free copy!
http://sdm.link/telerik
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] When will version 3.0 be available for Mac OS X ?

[Paul Beach]

>

Probably when I find time to finish the work I have started. 
But I am not sure when that will be. 

Firebird 3 compiles on MacOS if you install all the right stuff 
in the right places (ICU, libtommatch etc) and set the appropriate 
compile/link flags. Unfortunately I still haven't finish work
on the packaging and installer. 

Paul

--
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] C++11 features

[Paul Beach]

>As I was said, it would drop out some platforms such as HPUX and Solaris
> where compilers don't support C++11 standard.

>> Are these platforms that significant anymore for Firebird?

Still used (and maintained) by some customers (and IBPhoenix) on 2.5 

> Are there more than 1000 Firebird deployments on them?

HPUX 2.0.3 Classic 2,737 + 3,247 = 5984 Downloads
HPUX 2.1.4 Classic 93 + 113 = 206 Downloads

Solaris (Sparc) Classic 2.0.5 2,305 Downloads
Solaris (Sparc) Classic 2.1.3 793 Downloads

So the trend does seem to be away from such platforms.
If Companies like HP, Oracle, IBM, are not producing current compilers that 
support
such standards, then as you say - its time to move on.

Paul

--
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Atomics

[Paul Beach]

> < Linux).
> Is it a problem for us ?>>
>
> An interesting question, I do know of a few users who continue to use AIX and 
> HPUX and
> who actively build on 2.5... Will we still have AIX and HPUX users by the 
> time we release
> Firebird 4.0 - I don't know.

   <>

Just an observation.

Currently GCC on AIX produces awful debug versions of Firebird, that in effect 
are useless
for analysing crash dumps etc, only XLC seems to work properly for this.

Paul

--
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785351=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Atomics

[Paul Beach]

>> in new codebase (v4) we going to use atomic operations more intensively than
>> before. The question is: could we use standard features of C++11 or should
>> choose some 3rd party library (such as libatomic_ops) for it ?
>>
>>  The main concern about C++11 atomics is - if all platforms where 
>> Firebird
>> can be built have support for it (by software and hardware) ? We have no
>> problem with Intel\AMD and Linux\Windows (GCC and MSVC supports C++11 
>> atomics)
>> but i have no idea about MAC\HP\AIX\ARM and other...
>>
>>  Opinions ?
>
> Looking at this table:
> http://en.cppreference.com/w/cpp/compiler_support
> looks like we may safely switch to use of c++11 atomics support.

<>

An interesting question, I do know of a few users who continue to use AIX and 
HPUX and
who actively build on 2.5... Will we still have AIX and HPUX users by the time 
we release
Firebird 4.0 - I don't know.

Paul

--
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785351=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Atomics

[Paul Beach]

>

Having just checked - Clang (LLVM) 3.5 is installed via XCode on my Mac.
So thats OK.

Paul

--
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785351=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Git

[Paul Beach]

> > e.g.
> > git checkout -b mac-port B3_0_Release
> 
> You need "git clone" before that (just once for all the subsequent work).

I have got as far as that - I am now trying to work out exactly what I need 
to do to start committing some of my changes for the Mac Port for 3.0
back into git... now that I have 3.0 building cleanly.

Regards
Paul

--
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785231=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] gpre and boolean fields

[Paul Beach]

>Do you agree that support for boolean fields in gpre is a good thing?

If somebody provides the support, then I am unlikely to complain, strangely 
enough
I do know a few users who continue to use gpre.

Regards
Paul 

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Improve compilation on OS X El Capitan

[Paul Beach]

> Is there anything wrong with my previous message?

No

> Should I do things differently?

No

> Is compiling Firebird on OS X El Capitan supported?

Yes - it worked (with some minor issues) the last time I looked 
at it. I intend to sort out the port of FB3 now that RC2 is about
to be released as soon as I can find some spare time.

Paul

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Compiler for official Firebird 4 release on Windows

[Paul Beach]

>> There comes a time when some OSs/installs need to be recognized as *legacy*.
> Such as Solaris, for example?..

Still alive and kicking I am afraid. Firebird 2.5 Compiles cleanly for Solaris 
and is in use.

Paul

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Solaris port

[Paul Beach]

Dimitry,

<>

AFAIK, 2.5 should build on both gcc and CC and this has been done relatively 
recently.
The same should be true for AIX and HPUX.

Regards
Paul 

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] ODP: Re: fb3 connections limit

[Paul Beach]

>Only constant FD_SETSIZE at compilation time which can by changed in code.

See:
src/remote/inet.cpp

#ifdef  WIN_NT
#define FD_SETSIZE 2048
#endif

Regards
Paul 

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] ODP: Re: fb3 connections limit

[Paul Beach]

>> may i ask what is the reason of that limit on windows?
> 
> http://tracker.firebirdsql.org/browse/CORE-4439

> That doesn't really answer the why :)

It does if you google FD_SETSIZE and winsock
https://msdn.microsoft.com/en-us/library/windows/desktop/ms739169%28v=vs.85%29.aspx

Paul

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] [Firebird-checkins] SF.net SVN: firebird:[62678] firebird/trunk/src/yvalve/why.cpp

[Paul Beach]

<<   I do not want to rollback my commit as you demanded because it is required 
if IBPhoenix 
want to sell their crypt plugin to Firebird users. If Paul is ready to limit 
sales to 
Avalerion users only - no problem, I'll rollback it on his order.>>

It would be nice to offer an ecryption plugin that works to all Firebird users, 
not
just via our own internal replication fork.

Paul

--
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-4966) Firebird installer fails on El Capitan (MacOSX 10.11)

[Paul Beach (JIRA)]

Firebird installer fails on El Capitan (MacOSX 10.11)
-

 Key: CORE-4966
 URL: http://tracker.firebirdsql.org/browse/CORE-4966
 Project: Firebird Core
  Issue Type: Bug
  Components: Installation
Affects Versions: 2.5.4
 Environment: El Capitan - MacOSX 10.11 - Released 30th Sep 2015 
Reporter: Paul Beach


Firebird MacOSX installer fails on the latest release of OSX. Apple have 
finally deprecated the installer format we use. 
A new installer needs to be written using pkgbuild and productbuild.


installer log created by Firebird Installer.

Sep 23 16:30:02 mac-mbp Installer[66897]: LSExceptions [0x7f93d9603070] loaded
Sep 23 16:30:02 mac-mbp Installer[66897]: @(#)PROGRAM:Install  
PROJECT:Install-1000
Sep 23 16:30:02 mac-mbp Installer[66897]: @(#)PROGRAM:Installer  
PROJECT:Installer-853
Sep 23 16:30:02 mac-mbp Installer[66897]: Hardware: MacBookPro9,1 @ 2.60 GHz (x 
8), 8192 MB RAM
Sep 23 16:30:02 mac-mbp Installer[66897]: Running OS Build: Mac OS X 10.11.1 
(15B17c)
Sep 23 16:30:02 mac-mbp Installer[66897]: Env: 
TMPDIR=/var/folders/z1/c5tfsznx0ts_cdbdhww69qrmgn/T/
Sep 23 16:30:02 mac-mbp Installer[66897]: Env: 
FS_TRASHER_SOCKET=/private/tmp/com.apple.launchd.9wJ4tCTvtL/ListeningSocket
Sep 23 16:30:02 mac-mbp Installer[66897]: Env: 
__CF_USER_TEXT_ENCODING=0x1F5:0x0:0x0
Sep 23 16:30:02 mac-mbp Installer[66897]: Env: HOME=/Users/macuser
Sep 23 16:30:02 mac-mbp Installer[66897]: Env: SHELL=/bin/bash
Sep 23 16:30:02 mac-mbp Installer[66897]: Env: 
Apple_PubSub_Socket_Render=/private/tmp/com.apple.launchd.OR4quis6LU/Render
Sep 23 16:30:02 mac-mbp Installer[66897]: Env: 
SSH_AUTH_SOCK=/private/tmp/com.apple.launchd.j4vOrTOuXP/Listeners
Sep 23 16:30:02 mac-mbp Installer[66897]: Env: 
PATH=/usr/bin:/bin:/usr/sbin:/sbin
Sep 23 16:30:02 mac-mbp Installer[66897]: Env: LOGNAME=macuser
Sep 23 16:30:02 mac-mbp Installer[66897]: Env: 
XPC_SERVICE_NAME=com.apple.installer.78432
Sep 23 16:30:02 mac-mbp Installer[66897]: Env: USER=macuser
Sep 23 16:30:02 mac-mbp Installer[66897]: Env: XPC_FLAGS=0x0
Sep 23 16:30:02 mac-mbp Installer[66897]: Firebird Database  Installation Log
Sep 23 16:30:02 mac-mbp Installer[66897]: Opened from: 
/Users/macuser/Downloads/FirebirdCS-2.5.4-26856-x86_64.pkg
Sep 23 16:30:03 mac-mbp Installer[66897]: Top component package 
/Users/macuser/Downloads/FirebirdCS-2.5.4-26856-x86_64.pkg not found or 
understood: treat as unsigned
Sep 23 16:30:13 mac-mbp Installer[66897]: LSExceptions [0x7f93d9603070] unloaded
Sep 23 16:30:35 mac-mbp Installer[66897]: InstallerStatusNotifications plugin 
loaded
Sep 23 16:30:43 mac-mbp Installer[66897]: Administrator authorization granted.
Sep 23 16:30:43 mac-mbp Installer[66897]: 

Sep 23 16:30:43 mac-mbp Installer[66897]: User picked Standard Install
Sep 23 16:30:43 mac-mbp Installer[66897]: Choices selected for installation:
Sep 23 16:30:43 mac-mbp Installer[66897]: Upgrade: "Firebird Database"
Sep 23 16:30:43 mac-mbp Installer[66897]: 
FirebirdCS-2.5.4-26856-x86_64.pkg : org.firebirdsql.Firebird : 2.5.0.2.5
Sep 23 16:30:43 mac-mbp Installer[66897]: 

Sep 23 16:30:43 mac-mbp Installer[66897]: It took 0.00 seconds to summarize the 
package selections.
Sep 23 16:30:43 mac-mbp Installer[66897]: -[IFPKGDerivedDocument 
sortedPackageLocations]: result = (
"file://localhost"
)
Sep 23 16:30:43 mac-mbp Installer[66897]: -[IFDInstallController(Private) 
_buildInstallPlanReturningError:]: location = file://localhost
Sep 23 16:30:43 mac-mbp Installer[66897]: -[IFDInstallController(Private) 
_buildInstallPlanReturningError:]: 
file://localhost/Users/macuser/Downloads/FirebirdCS-2.5.4-26856-x86_64.pkg
Sep 23 16:30:43 mac-mbp Installer[66897]: Set authorization level to root for 
session
Sep 23 16:30:43 mac-mbp Installer[66897]: Administrator authorization granted.
Sep 23 16:30:43 mac-mbp Installer[66897]: Package 
file://localhost/Users/macuser/Downloads/FirebirdCS-2.5.4-26856-x86_64.pkg not 
supported by PK
Sep 23 16:30:43 mac-mbp Installer[66897]: Unable to use PK session due to 
incompatible packages. Terminating.
Sep 23 16:30:43 mac-mbp Installer[66897]: Install failed: The Installer could 
not install the software because there was no software found to install.
Sep 23 16:30:43 mac-mbp Installer[66897]: IFDInstallController D94322A0 state = 
8
Sep 23 16:30:43 mac-mbp Installer[66897]: Displaying 'Install Failed' UI.
Sep 23 16:30:43 mac-mbp Installer[66897]: 'Install Failed' UI displayed 
message:'The Installer could not install the software.

The Installer could not install the software because there was no software 
found to install.'. 



-- 
This message is automatically generated by JIRA.
-
If you think it was sent inc

[Firebird-devel] Re. Fix Firebird build against OS X SDK 10.11

[Paul Beach]

new small patch from libo 
https://github.com/LibreOffice/core/commit/a799d7c9a66464f33bd8ee42d535e29a976d64ae
Paul please apply if consider as necessarily

There will have been a reason why that particular flag was used 

The change for nodefaultlibs was added to fix a problem with gcc 4.1 by the 
look of it.
Since we are no longer using gcc 4.1, since MacOS 10.8 (currently used to build 
2.x)
is now running gcc 4.2, its probably OK to remove it.

See original checkin below:

Modified Files:
  Tag: B2_5_Release
darwin.defaults 
Log Message:
Fixed darwin built with gcc4.1

Index: darwin.defaults
===
RCS file: /cvsroot/firebird/firebird2/builds/posix/darwin.defaults,v
retrieving revision 1.4
retrieving revision 1.4.2.1
diff -b -U3 -r1.4 -r1.4.2.1
--- darwin.defaults 11 Sep 2009 10:49:30 -  1.4
+++ darwin.defaults 12 Oct 2009 13:41:00 -  1.4.2.1
@@ -55,8 +55,15 @@
 
 LINK_TRACE = $(LIB_LINK) $(LIB_BUNDLE_OPTIONS)
 
-LINK_CLIENT = $(CLIENTLIB_LINK) $(LINK_FIREBIRD_CLIENT_SYMBOLS) 
$(LIB_LINK_OPTIONS) $(LIB_LINK_IMPLIB)\
+LINK_CLIENT = $(LIB_LINK) -nodefaultlibs $(LINK_FIREBIRD_CLIENT_SYMBOLS) 
$(LIB_LINK_OPTIONS) $(LIB_LINK_IMPLIB)\
  $(LIB_CLIENT_LINK_OPTIONS) $(LIB_LINK_SONAME)
 
+ifeq (@VOID_PTR_SIZE@,8)
+GCCS=-lgcc_s.10.5
+else
+GCCS=-lgcc_s.10.4
+endif
+STATIC_CXX_SUPPORT = -lsupc++ $(GCCS) -lgcc_eh -lSystem
+
 LINK_EMBED = $(LIB_LINK) $(LINK_FIREBIRD_EMBED_SYMBOLS) $(LIB_LINK_OPTIONS)\
  $(LIB_EMBED_LINK_OPTIONS) $(LIB_LINK_SONAME)

Paul


--
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] firebird 2.5.4 on osx 64 configure host

[Paul Beach]

One issue is that  bash firebird configure script detects host/target as 
i386-darwin on x86-64 osx
so I had to use the 2.5.2 trick from libreoffice and force the build for 
darwin_x86_64
i*86-*-darwin*)
MAKEFILE_PREFIX=darwin_x86_64
issue was libreoffice detects host to be darwin x86_64 and firebird configure 
detects it as i386 darwin
so we had this error while linking
ld: warning: ignoring file ../temp/boot/jrd/dsc.o, file was built for 
unsupported file format ( 0xCF 0xFA 0xED 0xFE 0x07 0x00 0x00
0x01 0x03 0x00 0x00 0x00 0x01 0x00 0x00 0x00 ) which is not the architecture 
being linked (i386): ../temp/boot/jrd/dsc.o
http://ci.libreoffice.org/job/lo_gerrit_master/2971/Gerrit=Gerrit,Platform=MacOSX/consoleText

This was fixed in B2_5_Release sometime ago. Configure detects both 64bit and 
32bit using

x*64-*-darwin* | x*64_*-darwin*)
MAKEFILE_PRIFIX=darwin_x86_64
and
i*86-*-darwin* | i*86_*-darwin*)
MAKEFILE_PRIFIX=darwin_i386

Regards
Paul


--
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Build Firebird on Mac OSX Yosemite with CMake

[Paul Beach]

I built 64-bit version of Firebird (OS X 10.10, AppleClang 6.0.0, Xcode 6.2).
The symbol O_CLOEXEC is present, but as you see it has negative effect
on socket() call.

Ahh - good - that gets rid of one possible reason for failure.
Perhaps FD_CLOEXEC instead?

Paul

--
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Build Firebird on Mac OSX Yosemite with CMake

[Paul Beach]

On 03/29/15 21:56, Egor Pugin wrote:
 Hi,

 Actually I didn't try to run Firebird on OS X before, but...
 I ran fbserver from Xcode and the standard socket() function cannot
 create socket.
 remote/inet.cpp:3060
 fd = ::socket(domain, type | O_CLOEXEC, protocol);
 (The execution does not go into the next if statement. It seems errno
 has other value than specified in the condition.)

 Without the 'O_CLOEXEC' flag the server starts well.
 fd = ::socket(domain, type, protocol);

 You can ask core developers about this issue.

 On 29 March 2015 at 19:32, Nils mrnightlifelo...@yahoo.com wrote:
 However today I tried to actually use it on my Mac. And I guess the schemes
 in Xcode are not ready to simply start it from the ide. So in the build
 directory I tried to start it using fbguard:

 sudo bin/fbguard -daemon

 Which failed with the following entries in the Firebird.log file:

 macbook.local   Sun Mar 29 18:27:05 2015
  socket: error creating socket (family 2, socktype 1, protocol 6


 macbook.local   Sun Mar 29 18:27:05 2015
  startup:INET_connect:
  Unable to complete network request to host 127.0.0.1.
  Error while listening for an incoming connection.


 I set the address to 127.0.0.1 in the Firebird.conf:

 RemoteBindAddress = 127.0.0.1

 Also for testing I turned off the Firewall completely, but still was unable
 to start it. I assume that the client/server communicate via tcp/ip but what
 about UNIX sockets? Where can I set which method should be used? I also
 seems that both fail.


O_CLOEXEC was added in FB3 in order to better support fork() in user code.
If OS/X does not support it (not too big surprise telling true) we 
should add some ifdefs around.

Hmmm in /usr/include/sys/fcntl.h

#if __DARWIN_C_LEVEL = 200809L
#define O_CLOEXEC   0x100 /* implictly set FD_CLOEXEC */

So its there, but 200809L is OSX 10.7 AFAIR

We now build using Clang and 10.7 is now the minimum build level for MacOS
(there is a TLS issue with 10.6). Not 10.6 as previously when we built with g++

Did you build 32bit FB3 from Trunk or 64bit?

Regards
Paul

--
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Time to update our headers.

[Paul Beach]

 The IPL license hosted on IBPhoenix was the license originally used, i.e. we 
 hosted the original license that the InterBase code
was
 released with (as Ann and I devised it). If I remember rightly the Inprise 
 license was slightly modified after release.

 We also hosted the IDPL license because again if I remember rightly, Jim 
 initially used the IDPL for the Vulcan work.

   IIRC, it was time when Firebird project just didn't have its own web site. 
Now it has
one and can encapsulate its resources to avoid external dependencies.

I wasn't arguing about it - just pointing out some historical facts that were 
valid at some time in the past.

Paul


--
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Time to update our headers.

[Paul Beach]

05.03.2015 16:13, Dimitry Sibiryakov wrote:
 We are talking about sources (particularly headers), no?..

   I mean that if you are going to update headers to a new license URL, it 
would be better
if it is official project's site URL, not IBPhoenix one.

The IPL license hosted on IBPhoenix was the license originally used, i.e. we 
hosted the original license that the InterBase code was
released with (as Ann and I devised it). If I remember rightly the Inprise 
license was slightly modified after release.

We also hosted the IDPL license because again if I remember rightly, Jim 
initially used the IDPL for the Vulcan work.

Paul


--
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Time to update our headers.

[Paul Beach]

http://www.ibphoenix.com/main.nfs?a=ibphoenixpage=ibp_idpl.
is pointing to nothing. We need to update the files in the repository to
point to the right location of the license or please suggest an alternative.
I think that only FB v3 matters.

ipl - http://www.ibphoenix.com/about/firebird/ipl
idpl - http://www.ibphoenix.com/about/firebird/idpl

Regards
Paul



--
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Start Firebird Service under OSX Yosemite

[Paul Beach]

http://paulbeachsblog.blogspot.fr/2015/02/yosemite-superserver-and-startupitems.html

Suffice to say I will be updating the installer to support this in due course. 

Regards
Paul 

--
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration  more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=190641631iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] (no subject)

[Paul Beach]

and the related question with startup script issue
http://stackoverflow.com/questions/28544413/start-firebird-service-under-osx-yosemite

 I am downloading Yosemite now.

Hmm - everything looks fine if you install SuperServer directly, i.e. 
SuperServer starts
without a problem. But on reboot - it doesn't start automatically as it should. 
Going to
/Library/StartupItems/Firebird and running ./Firebird start will start the 
server assuming
that the files needed are there.

But I assume if you install Yosemite without reinstalling Firebird then the 
StartupItems
directory does not exist anymore, so a reinstall will be necessary, and manual 
startup
on reboot.

A search tells me the following:

Startup Items
Deprecation Note: Startup items are a deprecated technology. Launching of 
daemons through this process may be removed or eliminated
in a future release of OS X.

Which is obviously what has happened.

This is followed by

Unless your software requires compatibility with OS X v10.3 or earlier, use 
the launchd facility instead.

Which is currently what Classic does.

I am going to have to redo how SuperServer starts, to be compatible with 
Yosemite (10.10)

Regards
Paul


--
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration  more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=190641631iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Start Firebird Service under OSX Yosemite

[Paul Beach]

and the related question with startup script issue 
http://stackoverflow.com/questions/28544413/start-firebird-service-under-osx-yosemite

I am downloading Yosemite now.

Regards
Paul 

--
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration  more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=190641631iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Firebird and CMake and Darwin

[Paul Beach]

I see. If architecture/i386/io.h is used, we need to add some #ifdefs 
here.

Correct, otherwise the default Darwin build will be broken if that line is 
commented out.

By the way did you try to build Firebird with cmake? Does it work?

No, cureently we build using GNU Make and either gcc/g++ or clang

Paul 


--
New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
GigeNET is offering a free month of service with a new server in Ashburn.
Choose from 2 high performing configs, both with 100TB of bandwidth.
Higher redundancy.Lower latency.Increased capacity.Completely compliant.
http://p.sf.net/sfu/gigenet
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Firebird and CMake and Darwin

[Paul Beach]

Using:

--- src/isql/InputDevices.cpp   (revision 60530)
+++ src/isql/InputDevices.cpp   (working copy)
@@ -23,12 +23,12 @@

 #include firebird.h
 #ifdef DARWIN
-#if defined(i386) || defined(__x86_64__)
-#include architecture/i386/io.h
-#else
+//#if defined(i386) || defined(__x86_64__)
+//#include architecture/i386/io.h
+//#else
 #include io.h
+//#endif
 #endif
-#endif

Produces:

g++  -I../src/include/gen -I../src/include -I../src/vulcan -DNAMESPACE=Vulcan 
-I../extern/icu/source/common -I../extern/icu/source/i
18n -ggdb -DDARWIN -pipe -MMD -fPIC -fno-common -Wall -mmacosx-version-min=10.7 
-DDEV_BUILD -D_THREAD_SAFE   -fvisibility-inlines-hi
dden -fvisibility=hidden  -c ../src/isql/InputDevices.cpp -o 
../temp/std/isql/InputDevices.o
../src/isql/InputDevices.cpp:29:10: fatal error: 'io.h' file not found
#include io.h
 ^
1 error generated.
make: *** [../temp/std/isql/InputDevices.o] Error 1

-- io.h is found in architecture/i386/ on Darwin


Index: src/yvalve/config/os/darwin/config_root.cpp
===
--- src/yvalve/config/os/darwin/config_root.cpp (revision 60530)
+++ src/yvalve/config/os/darwin/config_root.cpp (working copy)
@@ -37,7 +37,7 @@
 #include ../common/os/path_utils.h
 #include ../common/file_params.h

-#include CoreServices/CoreServices.h
+//#include CoreServices/CoreServices.h
 #include CoreFoundation/CFBundle.h
 #include CoreFoundation/CFURL.h
 #include mach-o/dyld.h

CoreServices.h is the master include file for multiple services found on Darwin
However it doesn't look like we depend on this include file any more. 
config_root.cpp
was rewritten for 2.5 (use Posix dl functions not DarwinNS), so CoreServices.h 
looks like
its now an artefact from previous versions.

Regards
Paul




--
New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
GigeNET is offering a free month of service with a new server in Ashburn.
Choose from 2 high performing configs, both with 100TB of bandwidth.
Higher redundancy.Lower latency.Increased capacity.Completely compliant.
http://p.sf.net/sfu/gigenet
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Visual Studio Community 2013

[Paul Beach]

On 11/18/14 11:44, Ji?í ?in?ura wrote:
 Are you suggesting this become the basis for all Windows based builds
 going forward?

 I wasn't, but it moving from Visual Studio 2010 to 2013 (or the upcoming
 2015) might be something to consider for the near future.
 And we *might* benefit from support for AVX and AVX2 instructions (among 
 others optimizations).


If move somewhere - than on my mind to clang. It's much more friendly
than both current gcc and msvc10 (do not know about 12/13). Also it's
primary compiler for Darwin.

Ditto.

Regards
Paul


--
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration  more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=157005751iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Multiple instances under windows (wasRe:UsingFirebird 3, beta 1 - installer report)

[Paul Beach]

I don't know what the 
situation is on other platforms such as the mac. 

I am not prepared to even think about it. Trying to get an installer 
that can handle 3.0 is proving to be more complicated than it should be. 

Regards
Paul

--
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Firebird 3.0 on MacOSX

[Paul Beach]

I need to post this on devel to canvass some opinions re. Firebird 3.x on 
MacOSX.

As you may know in firebird 3.0 on posix now relies on a OS pre-installed 
version
of ICU for both development and runtime, rather than what was our own build of 
ICU. Although this
has its inherent problems (databases need to backed up and restored across 
different versions
of ICU) it does make our use of ICU easier, that is, until we get to MacOSX.

OSX only has a core ICU install by default, Firebird needs more. So the 
solution from 
a build perspective is to install MacPorts ICU and link to that, however that 
now creates 
additional external dependencies...

Does that mean - in future - that a Firebird user on MaOSX needs to install ICU 
via MacPorts
into opt/local/lib? Or should I try and ship the ICU libs with the Framework, 
along with any
relevant dependent libs?

The same is also true for the usage of libtommath...

A find / libicu on my Mac seems to indicate that other software that uses ICU 
does ship ICU
with with their frameworks.

Comments? 

I am at the point where we need to make a decision as I am currently re-writing 
the 
MacOSX Firebird installer for Firebird 3.0

Regards
Paul

--
Slashdot TV.  Video for Nerds.  Stuff that Matters.
http://pubads.g.doubleclick.net/gampad/clk?id=160591471iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Firebird 3.0 on MacOSX

[Paul Beach]

Marius,

An update, Firebird 3.0 now compiles on MacOSX (10.9.x)
using clang etc under XCode 5.1 

Am now working on the updated installer.

Regards
Paul Beach

--
Want excitement?
Manually upgrade your production database.
When you want reliability, choose Perforce.
Perforce version control. Predictably reliable.
http://pubads.g.doubleclick.net/gampad/clk?id=157508191iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Server-side plugins and character sets

[Paul Beach]

Just one tech detail - if we define such method somewhere in main 
interfaces set (like IUtl) would not it mean that fbclient library start 
to depend from ICU? Telling true there is _big_ desire to avoid such 
dependency, specially on windows.

And on MacOSX.

Regards
Paul

--
Open source business process management suite built on Java and Eclipse
Turn processes into business applications with Bonita BPM Community Edition
Quickly connect people, data, and systems into organized workflows
Winner of BOSSIE, CODIE, OW2 and Gartner awards
http://p.sf.net/sfu/Bonitasoft
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Cursor stability in READ COMMITTED transactions

[Paul Beach]

But, after reading MS-SQL's read committed isolation level, their
default behavior is the same as Firebird's. And, they introduced the
READ COMMITTED SNAPSHOT isolation level, which is at the statement
level, and that is what Nickolay is looking for. And, both READ
COMMITTED isolation levels fall within the SQL Standard.

Exactly... we need to keep our default behaviour as is and 
create a new isolation level that supports the cursor stability
in Read Committed that Nikolay wants.

Regards
Paul Beach
Tel (France): +33 (0) 2 47 58 30 43
Mob (France): +33 (0) 6 79 24 32 32



--
Open source business process management suite built on Java and Eclipse
Turn processes into business applications with Bonita BPM Community Edition
Quickly connect people, data, and systems into organized workflows
Winner of BOSSIE, CODIE, OW2 and Gartner awards
http://p.sf.net/sfu/Bonitasoft
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] DDL Triggers, how to retrieve type?

[Paul Beach]

 - Any other suggestion?

 Drop dialect 1 support.

   Allow dialect 1 to have access to BIGINT fields.

I don't have to work for this to happen, so I don't really have a say...

but the question that arises is why?

What are the reasons to continue to use dialect 1?

Because there are large numbers of databases out there still using it...
and if we are going to drop support for dialect 1, we should announce it 
well in advance, not at alpha stage of a release.

Regards
Paul

--
Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos.
Get unparalleled scalability from the best Selenium testing platform available
Simple to use. Nothing to install. Get started now for free.
http://p.sf.net/sfu/SauceLabs
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] DDL Triggers, how to retrieve type?

[Paul Beach]

On Fri, 23 May 2014 09:03:35 +0200, Paul Beach pbe...@ibphoenix.com
wrote:
 - Any other suggestion?

 Drop dialect 1 support.

   Allow dialect 1 to have access to BIGINT fields.
 
 I don't have to work for this to happen, so I don't really have a
say...
 
 but the question that arises is why?
 
 What are the reasons to continue to use dialect 1?
 
 Because there are large numbers of databases out there still using it...
 and if we are going to drop support for dialect 1, we should announce it

 well in advance, not at alpha stage of a release.

Sorry, but IMHO declaring dialect 1 as legacy and announcing dropping of
support was already done with Interbase 6.0. The Interbase 6.0 Getting
Started Guide explicitly states that moving from Interbase 5 to Interbase 6
you need to migrate databases and clients from dialect 1 to 3. It also says
(page 27): In a future release, InterBase will allow only the dialect 3
behavior, (page 42): Future versions of InterBase will no longer support
dialect 1. It is offered now as a transitional mode.

Firebird isn't InterBase. There is a difference between supporting it, adding
new features to it (something we don't do), breaking it or removing it 
completely.
We haven't supported dialect 1 since the projct started, but if we make a 
change that makes dialect 1 unusable then thats a problem.

I'd say that has been warning enough. People have had +/- 15 years to
migrate. If they haven't done so by now, they can stay on Firebird 2.5. If
they want the goodies from Firebird 3.0 they will finally have good reason
to invest in migrating.

And I repeat - doing at an Alpha stage seems silly. A knee jerk reaction.

I think it was a serious mistake that dialect 1 support wasn't dropped
earlier, eg in Firebird 1.5 or 2.0.

Its never been supported, but then we haven't broken it or removed it either.

Regards
Paul

--
Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos.
Get unparalleled scalability from the best Selenium testing platform available
Simple to use. Nothing to install. Get started now for free.
http://p.sf.net/sfu/SauceLabs
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Gpre and DYN

[Paul Beach]

 On 18/03/2014 13:09, Claudio Valderrama C. wrote:
  People, GPRE's cmd.cpp and sql.cpp generate a lot of DYN commands.
  FB3 doesn't understand DYN. What should we do, disable 
 those places in GPRE
  with an error message?
 
 
 Why the engine error message about unsupported DYN is not sufficient?

A preprocessing error is better than defining something and discovering that
the DDL doesn't work when you compile the preprocessed file with the rest of
your program and run it.

Agreed. Steve is not the only user out there still relying/using on gpre. 

Paul



--
Learn Graph Databases - Download FREE O'Reilly Book
Graph Databases is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Firebird 3.0 Alpha 2 release is available fortesting

[Paul Beach]

 No builds for macosx ?

Just as an FYI.

Thanks to assistance from Alex, we now have Firebird 3.0 building on MacOSX 
10.8 with XCode 4.6.3

Regards
Paul

--
Managing the Performance of Cloud-Based Applications
Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
Read the Whitepaper.
http://pubads.g.doubleclick.net/gampad/clk?id=121054471iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Firebird 3.0 Alpha 2 release is available fortesting

[Paul Beach]

 No builds for macosx ?

No... I am still in the process of trying to do the port...
MacOSX gcc is broken (exception handling) - even the version in MacPorts AFAICS 
(64bit only)
So am attempting to use clang... (latest version of XCode on Mavericks) 
Which brings its own problems... TLS issues and 10.7+ support only
or will have to revert to a previous version of MacOSX and XCode that works
If you are bored you can join in the fun.

Paul

On Sat, Feb 1, 2014 at 10:55 AM, Dmitry Yemanov firebi...@yandex.ru wrote:
 Firebird Project announces the second Alpha release of Firebird 3.0, the
 next major version of the Firebird relational database, which is now
 available for testing.

 This Alpha release arrives with an early preview of the features and
 improvements currently under development by the Firebird development
 team, as well as with countless bugfixes. Our users are appreciated
 giving it a try and providing feedback to this mailing list. Apparent
 bugs can be reported directly to the bugtracker.

 Alpha releases are not encouraged for production usage or any other
 goals that require a stable system. They are, however, recommended for
 those users who want to help in identifying issues and bottlenecks thus
 allowing to progress faster through the Beta/RC stages towards the
 final release.

 Please read the Release Notes carefully before installing and testing
 this Alpha release.


 Download page:
 http://www.firebirdsql.org/en/firebird-3-0-0-alpha2/

 Release Notes:
 http://web.firebirdsql.org/download/prerelease/rlsnotes/Firebird-3.0.0_Alpha2-ReleaseNotes.pdf


 --
 Dmitry Yemanov


--
WatchGuard Dimension instantly turns raw network data into actionable 
security intelligence. It gives you real-time visual feedback on key
security issues and trends.  Skip the complicated setup - simply import
a virtual appliance and go from zero to informed in seconds.
http://pubads.g.doubleclick.net/gampad/clk?id=123612991iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] license for examples wrong links

[Paul Beach]

The two links at IBPhoenix for the original license (IPL) 
http://www.ibphoenix.com/about/firebird/ipl
and the (IDPL) 
http://www.ibphoenix.com/about/firebird/idpl

Are true representatives of both licenses. 

The IPL is the original license, that was released along with the original 
source
code (i.e the same Inprise web page) as per how Ann, I and others devised it, 
subsequent Inprise/Borland versions had some modifications made by 
Inprise/Borland (as was their right), 
however as far as the Firebird project was concerned we always pointed to the 
original version since this was the license that was used when the code was 
forked. 
You can take a copy if the licenses, place them on firebirdsql,org and point to 
that if you like. 

However regardless of whether the source code has currently the right URL or 
not, IBP has always 
hosted an original and correct version of both licenses.

Regards
Paul 

--
See everything from the browser to the database with AppDynamics
Get end-to-end visibility with application monitoring from AppDynamics
Isolate bottlenecks and diagnose root cause in seconds.
Start your free trial of AppDynamics Pro today!
http://pubads.g.doubleclick.net/gampad/clk?id=48808831iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] RFC: non-expandable fields

[Paul Beach]

 i wrote this RFC by request of one local company which have (as many others)
 wrote own replicator and got some issues which could be resolved very easy
 with a little support from the Firebird engine side. I think we could discuss 
 it and
 determine if requested feature could add some value to the engine for wider
 audience.

Their software (replicator) add's some service field(s) to the customer 
 tables
 to track changes. In most cases it doesn't harm and customer software works
 as expected, i.e. ignores unknown for it new fields. But there are two cases
 when such service fields could change application's logic and even broke it. I
 mean queries where list of fields is not set explicitly by a programmer but
 expanded by the engine in run-time:
 a) select * from table
 b) insert into table values (...)

So, the proposition is simple: add ability for engine to distinguish such 
 service
 fields and not include it into auto expanded list of fields for table or view 
 at the
 queries above. I.e. service fields is fully accessible if present in query 
 text explicitly
 and hidden otherwise.

I prefer to discuss implementation details after (if) we agreed on 
 feasibility of
 such feature.

 Comments, ideas are welcome ;)

IMHO a hack, which shouldn't go into a public release. But that's just 
my personal opinion. ;-)

I'm with Thomas..
Hmm, if they want this functionality in a private build/patch OK, but in the 
public release?
I don't see how this benefits anybody...
Sorry.

Paul 

--
Minimize network downtime and maximize team effectiveness.
Reduce network management and security costs.Learn how to hire 
the most talented Cisco Certified professionals. Visit the 
Employer Resources Portal
http://www.cisco.com/web/learning/employer_resources/index.html
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Build firebird 2.0.7 on Mac OS X 10.8.2

[Paul Beach]

Markus

I'm trying to build version 2.0.7 on OSX 10.8.2 (to create a Homebrew
formula) but had no luck. This is what I tried so far:

$ export CFLAGS='-m32 -arch i386'
$ export CXXFLAGS='-m32 -arch i386'
$ export LD_FLAGS='-m32 -arch i386'
$ export MACOSX_DEPLOYMENT_TARGET=10.4
$ LIBTOOL=glibtool LIBTOOLIZE=glibtoolize ./autogen.sh

Fine...

| Running ./configure ...
| checking whether make sets $(MAKE)... yes
| checking build system type... x86_64-apple-darwin12.2.1
| checking host system type... x86_64-apple-darwin12.2.1
| checking target system type... x86_64-apple-darwin12.2.1
| configure: error: unsupported platform x86_64-apple-darwin12.2.1

I tweeked 'configure.in' a bit so it recognizes 'x86_64-apple-darwin12.2.1':

| case $target in
|   i686-*-darwin*)
|
| case $target in
|   x86_64-*-darwin*)

Now autogen works

I am aware of that modification..., the fact that the latest version of XCode 
doesn't
ship with its own autconf etc is pretty irritating.


 but I get a strange compilation error:

| make -f ../gen/Makefile.static.gbak ../gen/firebird/bin/gbak_static
| ../gen/firebird/bin/gpre_current -r -m -z -n ../src/burp/backup.epp
../src/burp/backup.cpp
| gpre version UI-V2.0.7.13318 Firebird 2.0
| Unable to complete network request to host NTY OF ANY KIND, either express
|  * or implied. See the License for the specific language governing
|  * rights and limitations under the License.
|  *
|  * The Original Code was created by Inprise Corporation
|  * and its predecessors. Portions created by Inprise Corporation are
|  * Copyright (C) Inprise Corporation.
|  *
|  * All Rights Reserved.
|  * Contributor(s).
| -Failed to locate host machine.
| -The specified name was not found in the hosts file or Domain Name Services.
| (E) ../src/burp/backup.epp:67: Couldn't access database DB = 'yachts.lnk'
| 1 error, no warnings
| make[3]: *** [../src/burp/backup.cpp] Error 1
| make[2]: *** [../gen/firebird/bin/gbak_static] Error 2
| make[1]: *** [../gen/firebird/security2.fdb] Error 2
| make: *** [firebird] Error 2

I get the same error... so something has changed in the Mac environment 
(OS/XCode etc), because 
2.0.7 built fine in April. I guess I can do some investigation...

Paul

--
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Build firebird 2.0.7 on Mac OS X 10.8.2

[Paul Beach]

Its bizarre, but it looks like a format problem with epp files under the 
updated installation of
the Darwin development tools - to get this to compile, when you get an .epp 
file error, just find
the file, edit it with vi, and then save it(write/quit)
Eventually all will compile.

Whats annoying is that my test wasn't on a fresh checkout, but I was using the 
tree I used to build
2.0.7 originally that was still on my hard drive.

Paul


--
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Database dialect and BIGINT in metadata

[Paul Beach]

 I have no idea what to do (well, actually I have a very easy and good
 one, you know, it's to wipe dialect 1/2). I'd hate to split a single
 field in two to support something which should be removed +10 years ago.

Dialect 1/2 logic was for supporting migration of interbase 5 to firebird 1.0
I hope that clients had the time to migrate

They haven't

Paul

--
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_sfd2d_oct
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Firebird 2.5.3?

[Paul Beach]

,current snapshot builds are prefixed with 2.5.3, and there is no sign 
regarding 2.5.2. What's the most recent strategy regarding the next 
stable post 2.5.1 release?

I would have thought that snapshot = 2.5.3 might give you a clue about 
2.5.2 - It just passed Q/A and RC1 will be available very shortly. 

Paul 

--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Can someone add info how to backtrace core-3740

[Paul Beach]

The question was when it will be increased the stack and if he can have a 
patch/build to try it
http://firebird.1100200.n4.nabble.com/Firebird-bug-on-Mac-crashes-when-using-quot-IN-quot-lists-with-417-or-more-elements-td3001784.
html

On Wed, Aug 8, 2012 at 7:58 AM, marius adrian popa map...@gmail.com wrote:
http://tracker.firebirdsql.org/browse/CORE-3740 

Unable to reproduce using 2.5.2 debug/normal build.

Paul


--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Can someone add info how to backtrace core-3740

[Paul Beach]

 The question was when it will be increased the stack and if he can
have
 a patch/build to try it

http://firebird.1100200.n4.nabble.com/Firebird-bug-on-Mac-crashes-when-using-quot-IN-quot-lists-with-417-or-more-elements-td3001784.
 html

 On Wed, Aug 8, 2012 at 7:58 AM, marius adrian popa map...@gmail.com
 wrote:
 http://tracker.firebirdsql.org/browse/CORE-3740 

 Unable to reproduce using 2.5.2 debug/normal build.

Did someone fix it without updating the ticket, or is the error dependent
on some other unknown factor?

I didn't fix anything specific or am directly aware of anything,
so at the moment its still an unknown factor but I have finally
managed to reproduce it.

Tested now on
2.5.2 32bit Debug/Normal
2.5.2 64bit Debug

But it fails on 2.5.2 64bit... normal build.
(I do wish people would be more specific when they report bugs)

Which gives me a hint as to the problem.
Seems its a gcc optimisation issue, removing the -O3 from the
build means this now works. I will update the tracker.



Paul


--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] incomplete crash report

[Paul Beach]

The instructions I see for getting stack-traces all involve 
Dr. Watson, which isn't available anymore. I've found other apps, but they're 
finnicky and only seem useful to me if I'm diagnosing a reproducible, short-
term crash in FB (I think I've submitted at least one stack-trace from that in 
the recent past, it was a known issue, and the reason for switching to the 
current build we use?) Do we have updated documentation on capturing useful 
crash dumps from W2k8+, on a continuous basis?

http://www.ibphoenix.com/resources/documents/development/doc_35

Please read.

Regards
Paul

--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] SF.net SVN: firebird:[54042]firebird/trunk/builds/posix

[Paul Beach]

Adriano,

It was me who added these sed usages to makefiles, to let build work 
after header files removal.

Some time later, I discovered gcc -MP:

-
This option instructs CPP to add a phony target for each dependency 
other than the main file, causing each to depend on nothing. These dummy 
rules work around errors make gives if you remove header files without 
updating the Makefile to match.
This is typical output:

   test.o: test.c test.h

   test.h:
-

AFAIR it does the needed thing. I'm just not sure since when this option 
is present.

Sed in itself is not a problem, unfortunately as Alex and I have just discovered
sed on linux v's sed on MacOSX are slightly different beasties.

Via Alex.

-i switch differs from GNU syntax

Mac:
-i extension
 Edit files in-place, saving backups with the specified
extension.  If a zero-length extension
 is given, no backup will be saved.  It is not recommended
to give a zero-length extension when
 in-place editing files, as you risk corruption or partial
content in situations where disk
 space is exhausted, etc.

GNU:
-i[extension]
  edit files in place (makes backup if extension supplied)

Currently we have the following command line:
sed -i -e command1 -e command2 somefile.d

Looks like Mac's sed does the follwoing:
- treats first -e switch as extension;
- treats command1 as single command (OK when missing -e switch on Mac)
- treats second -e switch as first file to be processed.

The commit now allows this work properly on the Mac.

Paul

--
Virtualization  Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing 
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] url from headers

[Paul Beach]

  It would not be appropriate for the project to change the 
 License header, in any way.
 
 Which would be fine if the link actually went to Embarcadero 
 but it seems that 
 the inprise domains are now owned by advertising scammers? I 
 think in this case 
 changing it is appropriate as long as the target actually has 
 license information.

I seem to remember that Inprise/Borland created a second version of the
license but we chose to stick to the original, so we would have to check the
Embarcadero text word by word.

We keep as is - thats how they were released - thats how they stay.

My 2c.

Paul

--
Get a FREE DOWNLOAD! and learn more about uberSVN rich system, 
user administration capabilities and model configuration. Take 
the hassle out of deploying and managing Subversion and the 
tools developers use with it. http://p.sf.net/sfu/wandisco-d2d-2
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] url from headers

[Paul Beach]

Paul Beach wrote:
 It would not be appropriate for the project to change the
   License header, in any way.
 
   Which would be fine if the link actually went to Embarcadero
   but it seems that
   the inprise domains are now owned by advertising scammers? I
   think in this case
   changing it is appropriate as long as the target actually has
   license information.
 I seem to remember that Inprise/Borland created a second version of the
 license but we chose to stick to the original, so we would have to check the
 Embarcadero text word by word.

 We keep as is - thats how they were released - thats how they stay.

Did Inprise exist when the files were originally released? That was changed 
later already wasn't it?

Borland was Inprise at that time... hence the url. Dale Fuller was in the 
process of trying
to change the name back from Inprise to Borland. 

Paul


--
Get a FREE DOWNLOAD! and learn more about uberSVN rich system, 
user administration capabilities and model configuration. Take 
the hassle out of deploying and managing Subversion and the 
tools developers use with it. http://p.sf.net/sfu/wandisco-d2d-2
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] nbackup during TPC-H database generation(scale: 1GB)

[Paul Beach]

TS I ran a quick test of nbackup with Firebird 2.1.4 Classic 32-bit during
TS The next
TS level 1 backup hangs now, the delta file fills up and any other database
TS attachments to the database hang as well, so no additional database
TS attachments possible.

 2.1.4 is old, use higher version.
 And, you may also look at tracker for the keyword nbackup.
 Have fun.

And use a 2.5.x snapshot - a number of fixes re. hangs, performance etc 
regarding
nbackup have been this. I suspect his is what Dimitry is alluding to.

Paul

--
AppSumo Presents a FREE Video for the SourceForge Community by Eric 
Ries, the creator of the Lean Startup Methodology on Lean Startup 
Secrets Revealed. This video shows you how to validate your ideas, 
optimize your ideas and identify your business strategy.
http://p.sf.net/sfu/appsumosfdev2dev
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel