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

2017-08-03 Thread Alex via Firebird-devel
On 02.08.2017 18:13, Paul Beach wrote: 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 I.e. we already have native client for iphone. Nice :)

Re: [Firebird-devel] Detecting connection is using wire encryption

2017-08-16 Thread Alex via Firebird-devel
On 15.08.2017 18:33, Mark Rotteveel wrote: On 15-8-2017 15:59, Alex via Firebird-devel wrote: On 16.07.2017 16:08, Dmitry Yemanov wrote: 16.07.2017 13:31, Mark Rotteveel wrote: That said, I would still like to know if there is a specific info item I can use as well. There's

Re: [Firebird-devel] Detecting connection is using wire encryption

2017-08-15 Thread Alex via Firebird-devel
On 16.07.2017 16:08, Dmitry Yemanov wrote: 16.07.2017 13:31, Mark Rotteveel wrote: That said, I would still like to know if there is a specific info item I can use as well. There's no such an item, AFAIK. Mark, now there is such item - fb_info_conn_flags. It returns bitmask, bit

[Firebird-devel] Using non-default BLOBs in Batch interface

2017-08-11 Thread Alex via Firebird-devel
Currently implemented in batches (https://github.com/FirebirdSQL/firebird/tree/batch) BLOBs have hard-coded BPB which makes all BLOBs have stream type. Certainly this is not what we want in release version. I suggest the following: - current hard-coded BPB remains as default for all BLOBs

Re: [Firebird-devel] Using non-default BLOBs in Batch interface

2017-08-11 Thread Alex via Firebird-devel
On 11.08.2017 12:29, Dimitry Sibiryakov wrote: 11.08.2017 11:21, Alex via Firebird-devel wrote: BLOBs have hard-coded BPB which makes all BLOBs have stream type. What is advantage of stream BLOBs? No disadvantages :-) Comments? BPB is not only about BLOB type, but also for using

Re: [Firebird-devel] Useful SQL Stored Procedures as part of standard firebird installation

2017-08-14 Thread Alex via Firebird-devel
On 14.08.2017 15:21, Slavomir Skopalik wrote: Hi Adriano, we have serious problems with FB3 with stability. What problems? They are to be discussed here if one wants them to be solved. -- Check out the vibrant tech

Re: [Firebird-devel] Useful SQL Stored Procedures as part of standard firebird installation

2017-08-14 Thread Alex via Firebird-devel
On 14.08.2017 18:08, Slavomir Skopalik wrote: May be we can start new topic about bug fixing and release strategy. Two examples: 1. Database corruption (http://tracker.firebirdsql.org/browse/CORE-5392) that I was reported 06/Nov/16, release contain this fix was available 22-Mar-2017 2.

Re: [Firebird-devel] Useful SQL Stored Procedures as part of standard firebird installation

2017-08-14 Thread Alex via Firebird-devel
Discussion was about naming convention. Not only. We have reasonable suggestion from Adriano to create package instead artificial prefixes. -- Check out the vibrant tech community on one of the world's most

Re: [Firebird-devel] sse3 host x64 linux

2017-07-07 Thread Alex via Firebird-devel
On 07.07.2017 17:06, marius adrian popa wrote: It doesn't work , the same Marius did you try fresh B3_0_Release? Checked out after 23 of May? I've made a change fixing non-SSE operation, and emulated use of non-SSE machine, and it worked for me. But I need your confirmation that issue is

Re: [Firebird-devel] Detecting connection is using wire encryption

2017-07-16 Thread Alex via Firebird-devel
On 16.07.2017 13:23, Vlad Khorsun via Firebird-devel wrote: 16.07.2017 12:59, Mark Rotteveel wrote: Is there a way to programmatically detect a connection is using wire encryption (eg in a monitoring table or the service API)? I'm writing a test to check if Jaybird is correctly (not) using

[Firebird-devel] PHP bug 72175 - was Re: ADO.NET provider 5.9.0.0

2017-07-07 Thread Alex via Firebird-devel
On 07.07.2017 21:24, NetVicious via Firebird-devel wrote: HI! I don't know if this it's thegood place to send this message. We have a bug on PHP from version 7.0 to today related to multiple connections to a firebird database. I don't know if here it's any developer who can help all the

Re: [Firebird-devel] sse3 host x64 linux

2017-07-10 Thread Alex via Firebird-devel
On 10.07.2017 19:08, marius adrian popa wrote: It's weird that package from ppa (3.0.2) works LI-V3.0.2.32703 Firebird 3.0 https://launchpad.net/~mapopa/+archive/ubuntu/firebird3.0/+build/12568442 What version

Re: [Firebird-devel] sse3 host x64 linux

2017-07-10 Thread Alex via Firebird-devel
gcc version 6.3.0 20170406 (Ubuntu 6.3.0-12ubuntu2) That looks first of all as a known but still not fixed issue with gcc6. -- Check out the vibrant tech community on one of the world's most engaging tech sites,

Re: [Firebird-devel] HASH function (CORE-4436)

2017-07-21 Thread Alex via Firebird-devel
On 21.07.2017 13:38, Adriano dos Santos Fernandes wrote: On 19/07/2017 15:51, Mark Rotteveel wrote: In most cases original string (password) is not even stored and hashes are used to check if a password matches a previously one. The proposed hashes are **not** suitable for passwords; you

Re: [Firebird-devel] HASH function (CORE-4436)

2017-07-21 Thread Alex via Firebird-devel
On 21.07.2017 14:43, Adriano dos Santos Fernandes wrote: On 21/07/2017 08:00, Alex via Firebird-devel wrote: Mark, this is interesting. I know bcrypt is very used by nodejs/expess people and I even used it myself. But what is more interesting, isn't Firebird still using these "not sui

Re: [Firebird-devel] HASH function (CORE-4436)

2017-07-19 Thread Alex via Firebird-devel
On 19.07.2017 14:07, Adriano dos Santos Fernandes wrote: On 19/07/2017 02:29, Dmitry Yemanov wrote: 19.07.2017 01:32, Adriano dos Santos Fernandes wrote: Algorithm name could define result length. Yes, for constants. We need to decide whether the algorithm name can be passed

Re: [Firebird-devel] HASH function (CORE-4436)

2017-07-24 Thread Alex via Firebird-devel
On 22.07.2017 11:54, Mark Rotteveel wrote: On 21-7-2017 13:00, Alex via Firebird-devel wrote: Yes, but SHA1 weakness becomes important only when password becomes as long as hash, i.e. 20 bytes for sha1. Without enforcing users to have long passwords replacing hash makes no sense

Re: [Firebird-devel] Getting attachment_id from IAttachment

2017-07-21 Thread Alex via Firebird-devel
On 21.07.2017 11:08, Jiří Činčura wrote: Hi *, is there a way to get attachement_id (the same as in mon$attachments) from IAttachment isntance? Certainly. Use isc_info_attachment_id in IAttachment::getInfo(). --

Re: [Firebird-devel] udrcpp_example

2017-07-04 Thread Alex via Firebird-devel
On 04.07.2017 17:33, Paul Reeves wrote: Building udrcpp_example fails under windows, and has done since at least the final release of Firebird 3.0. Unfortunately the build process doesn't detect the error. That's a pity. Very interesting feature but people fail to use a sample. I shall

Re: [Firebird-devel] udrcpp_example

2017-07-04 Thread Alex via Firebird-devel
On 04.07.2017 18:43, Dimitry Sibiryakov wrote: 04.07.2017 17:39, Alex via Firebird-devel wrote: That's a pity. Very interesting feature but people fail to use a sample. BTW, this feature also could have wider usage in server as well. For example, SEC$USERS can be an UDR, gathering list

Re: [Firebird-devel] hello world example of gpre requested

2017-07-05 Thread Alex via Firebird-devel
On 05.07.2017 02:59, U-BLASTER-6000\mtdew wrote: Hi- I looked everywhere for docs on using gpre. I am interested in either a c, c++, or cobol example for gpre compiled with gcc,g++, or cobc for gnucobol. Can anyone include a link or file with some pointers? e.g. c file with embedded sql and

Re: [Firebird-devel] andorid deployment

2017-06-22 Thread Alex via Firebird-devel
On 22.06.2017 12:18, P-Soft - Fabio Codebue wrote: Where can I find useful information to deploy and test android version? Is there any howto? As far as I know there are no specific docs re subj. Some years ago I've used to write small doc how to install it (there are some specifics in

Re: [Firebird-devel] andorid deployment

2017-06-22 Thread Alex via Firebird-devel
On 22.06.2017 13:23, P-Soft - Fabio Codebue wrote: Yes I already downloaded it time ago.. .but how to install it? I have to copy all the files into smartphone? Yes. After copying (to have full functionality) you should create security database from backup using gbak, create firebird.msg in

Re: [Firebird-devel] Intel Skylake/Kaby Lake processors: broken hyper-threading

2017-06-26 Thread Alex via Firebird-devel
On 26.06.2017 18:48, marius adrian popa wrote: https://lists.debian.org/debian-devel/2017/06/msg00308.html Great - installed upgrade on my notebook. But must say I've never used to meet this bug though HT is always on.

Re: [Firebird-devel] Effect of DST on current_timestamp values

2017-06-13 Thread Alex via Firebird-devel
On 13.06.2017 11:12, Leyne, Sean wrote: A post to the Firebird support list pointed out that current_timestamp values do not correctly reflect the effect of DST time changes while the server is running. In order for current_timestamp to reflect the correct local time values, the server needs

[Firebird-devel] Internet connection problems

2017-06-13 Thread Alex via Firebird-devel
Hi all, I have network problem (connection is dropped periodically) therefore can't use icq/slack currently. If problem does not go away I will have to change provider, meantime please use email to contact me when needed (it badly but works). Alex.

Re: [Firebird-devel] DECFLOAT documentation unclear

2017-06-17 Thread Alex via Firebird-devel
On 17.06.2017 13:45, Mark Rotteveel wrote: You mailed this to me directly instead of the list, was that intentional? Use laptop to answer, pressed something wrong I think. On 17-6-2017 11:20, Alex wrote: On 17.06.2017 11:21, Mark Rotteveel wrote: /doc/sql.extensions/README.data_types

Re: [Firebird-devel] gpre cobol can't access memory segfault with trace

2017-06-19 Thread Alex via Firebird-devel
On 18.06.2017 04:41, U-BLASTER-6000\mtdew wrote: #3 0x764fb754 in isc_attach_database ( user_status=, file_length=60, file_name=, public_handle=0x602190 , dpb_length=, dpb=0xf7ff24a0 ) at ../src/jrd/why.cpp:1422 #4 0x00400f77 in Moon_ (entry=0) at

Re: [Firebird-devel] Firebird.pas is missing

2017-08-30 Thread Alex via Firebird-devel
Paul - FYI, part of fb4 posix build log: cat /buildroot/src/misc/pascal/fb_get_master_interface.pas >/buildroot/temp/Debug/func.pas awk -f /buildroot/src/misc/pascal/Pascal.Constants.awk >/buildroot/temp/Debug/func.pas grep '[[:space:]]isc_' /buildroot/lang_helpers/gds_codes.pas

Re: [Firebird-devel] fbclient - Event call back is called after isc_cancel_events

2017-08-28 Thread Alex via Firebird-devel
On 28.08.2017 04:15, Slavomir Skopalik wrote: Should I create ticket for this? No. Removing that call will break old code. From programing theory, no call back after successful cancel event is allowed. To be precise - it happens during event cancellation. Slavek Hi all, I'm testing

Re: [Firebird-devel] Crypt key callback on Embedded

2017-08-28 Thread Alex via Firebird-devel
On 28.08.2017 17:18, Jiří Činčura wrote: Jiri, please take a look at the sample provided with FB3 - it works with both embedded & remote. I'm looking at that. But I don't know why the loading is failing (while the same setup work in server mode). It would be nice to have bit more verbosity,

Re: [Firebird-devel] Crypt key callback on Embedded

2017-08-28 Thread Alex via Firebird-devel
On 28.08.2017 17:47, Jiří Činčura wrote: Ahh - agreed, the reason why lib failed to load is missing in diags. Bad luck for me. The Callback.dll is actually loaded fine (at least from OS perspective): 16:41:38,1377272ConsoleApp1.exe 7240Load Image

Re: [Firebird-devel] fbclient - Event call back is called after isc_cancel_events

2017-08-25 Thread Alex via Firebird-devel
On 25.08.2017 13:36, Slavomir Skopalik wrote: Hi all, I'm testing Firebird-3.0.3.32798-0_Win32 client and I found strange behavior when I canceling event by isc_cancel_events. I supposed that after that call, no call back happen, but in reality it is happen. Is it correct? One

Re: [Firebird-devel] Firebird.pas is missing

2017-08-30 Thread Alex via Firebird-devel
On 30.08.2017 14:07, Paul Reeves wrote: It looks as if a physical copy of Firebird.pas never got added to HEAD. Adding it to FB3 was temporal solution - did not want to add more problems to windows build right before FB3 release (.pas file was added not long before final release). So it