Re: [Firebird-devel] Changing wire encryption keys?

2017-06-10 Thread Alex Peshkoff via Firebird-devel
On 06/10/17 11:42, Mark Rotteveel wrote: Is there something in the wire encryption implementation that changes wire encryption keys while the connection is already encrypted? No. -- Check out the vibrant tech communit

Re: [Firebird-devel] SEC$USERS and indices

2017-09-19 Thread Alex Peshkoff via Firebird-devel
On 09/18/17 23:39, Magnus Johansson wrote: Hello, I'm looking on FB 3.0 and doing some thinking comparing with FB 2.5. In 2.5 there is an index on RDB$USERS.RDB$USER_NAME and that field is defined as VARCHAR. In 3.0 there is no index on SEC$USERS.SEC$USER_NAME and it is defined as CHAR. Looki

Re: [Firebird-devel] FB4 fetches

2017-09-19 Thread Alex Peshkoff via Firebird-devel
On 09/18/17 19:37, liviuslivius wrote: Hi, i do not know if message reach the group, or it was wrong place to ask about FB4? I asked about fetches because on previous versions of FB this not occure. Maybe not really. on FB3 fetches fluctuate by only 1. But under FB4 it fluctuate by 14 or even

Re: [Firebird-devel] SEC$USERS and indices

2017-09-20 Thread Alex Peshkoff via Firebird-devel
On 09/19/17 20:45, Magnus Johansson wrote: -Original Message- From: Alex Peshkoff via Firebird-devel [mailto:firebird- de...@lists.sourceforge.net] Sent: Tuesday, September 19, 2017 10:19 AM I'm curious about why there is no index on SEC$USERS.SEC$USER_NAME (*) You are right - be

Re: [Firebird-devel] Unload of fbclient.dll (v3)

2017-10-02 Thread Alex Peshkoff via Firebird-devel
On 10/02/17 13:49, Kovalenko Dmitry wrote: Hello, fbclient.dll (from FB3) not unload when I call ::FreeLibrary. fbclient.dll (from FB2.5) unloads without problems. Could anybody confirm this behavior of FB3 client library? Yes - in a test with FB4 on linux. BTW, ::dlclose does not return

Re: [Firebird-devel] Unload of fbclient.dll (v3)

2017-10-02 Thread Alex Peshkoff via Firebird-devel
On 10/02/17 13:49, Kovalenko Dmitry wrote: Could anybody confirm this behavior of FB3 client library? Please add big delay (120 sec should be enough) after last attachment closed before unloading client library. Does it unload in such case? --

Re: [Firebird-devel] isc_info_svc_timeout incompatibility between Interbase and Firebird

2017-10-04 Thread Alex Peshkoff via Firebird-devel
On 10/04/17 17:48, Dimitry Sibiryakov wrote: Hello.   In Interbase isc_info_svc_timeout is used like this: *spb++ = isc_info_svc_timeout; ADD_SPB_NUMERIC(spb, 60); /* 1 minute timeout */   In Firebird it is used like this: *p++ = isc_info_svc_timeout; ADD_SPB_LENGTH(p, 4); ADD_SPB_NUMERIC(

Re: [Firebird-devel] isc_info_svc_timeout incompatibility between Interbase and Firebird

2017-10-04 Thread Alex Peshkoff via Firebird-devel
On 10/04/17 18:17, Dimitry Sibiryakov wrote: 04.10.2017 17:03, Dmitry Yemanov wrote: Different SPB version perhaps?   No, in both cases isc_spb_current_version is defined as 2. But, perhaps, examples in documentation for Interbase XE are outdated and comply to spb verion 1. Sooner of al

Re: [Firebird-devel] [FB-Tracker] Commented: (CORE-5631) Allow isc_info_svc_to_eof be used for sending binary stream to service

2017-10-06 Thread Alex Peshkoff via Firebird-devel
On 10/06/17 19:28, Leyne, Sean wrote: It's clear that choice to use isc_info_svc_line to mark chunk of stdin sent to service via SPB was not wise choice (to say it mildly). Both isc_info_svc_to_eof and isc_info_svc_line are normally used for service output (query items) and they were created jus

Re: [Firebird-devel] [FB-Tracker] Commented: (CORE-5631) Allow isc_info_svc_to_eof be used for sending binary stream to service

2017-10-06 Thread Alex Peshkoff via Firebird-devel
On 10/06/17 19:40, Leyne, Sean wrote: A general question about the idea of "streaming" fbk file to a remote server for restore. There would need to be a proper protocol to handle the stream, no? It would be impossible to send the fbk in a single operation, so sending the fbk in blocks would

Re: [Firebird-devel] [FB-Tracker] Commented: (CORE-5631) Allow isc_info_svc_to_eof be used for sending binary stream to service

2017-10-06 Thread Alex Peshkoff via Firebird-devel
On 10/06/17 19:59, Dimitry Sibiryakov wrote: 06.10.2017 18:50, Alex Peshkoff via Firebird-devel wrote: Unfortunately no support in gbak   That's pity. Stream transfer from service is faster than using queries as it is done now, right? Certainly faster. That was main reason t

Re: [Firebird-devel] Using ordinary database connection string in isc_service_attach() call

2017-10-11 Thread Alex Peshkoff via Firebird-devel
On 10/11/17 22:22, Dimitry Sibiryakov wrote: 11.10.2017 20:57, Vlad Khorsun via Firebird-devel wrote:   I don't understand your speculations   Ok, turn your imagination on: Performance of gbak must be improved by feeding of backup stream from server using services instead of sending queries.

Re: [Firebird-devel] Using ordinary database connection string in isc_service_attach() call

2017-10-12 Thread Alex Peshkoff via Firebird-devel
Well Dmitry (and please briefly) - what problem do you want to solve with this change? -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Fireb

Re: [Firebird-devel] Using ordinary database connection string in isc_service_attach() call

2017-10-12 Thread Alex Peshkoff via Firebird-devel
On 10/12/17 12:02, Dimitry Sibiryakov wrote: 12.10.2017 10:24, Alex Peshkoff via Firebird-devel wrote: what problem do you want to solve with this change?   No problem to solve. It is not bug fix, it is an improvement. It open new possibilities for app developers, nothing more. That

Re: [Firebird-devel] Using ordinary database connection string in isc_service_attach() call

2017-10-12 Thread Alex Peshkoff via Firebird-devel
On 10/12/17 13:06, Dimitry Sibiryakov wrote: 12.10.2017 11:55, Alex Peshkoff via Firebird-devel wrote: Suggested implementation of that possibilities is also bad - it's supposed to have different behavior depending upon text in parameter.   You didn't see implementation, how can yo

Re: [Firebird-devel] rpmbuild is still used in 2.5 branch

2017-10-26 Thread Alex Peshkoff via Firebird-devel
On 10/26/17 18:00, marius adrian popa wrote: i have seen that is deprecated in 3.0/4.0 so i wanted to cleanup also in 2.5 branch Bad and wrong desire. If feature XXX is removed from version N it does not mean that it should be removed from N-1 too.

Re: [Firebird-devel] rpmbuild is still used in 2.5 branch

2017-10-26 Thread Alex Peshkoff via Firebird-devel
On 10/26/17 18:13, marius adrian popa wrote: rpm build failed on travis when doing make dist so I will redo the pull request Marius, just please do not try to place a cart in front of a horse. Changing FB built order, specially for version that people use for many years, is not good idea. C

Re: [Firebird-devel] libtool used for libtomcrypt is not using the defined LIBTOOL

2017-11-06 Thread Alex Peshkoff via Firebird-devel
On 11/06/17 17:17, marius adrian popa wrote: Ok i installed libtomcrypt from source , i will create a pull request with new version of it for firebird git clone https://github.com/libtom/libtomcrypt.git cd libtomcrypt git checkout tags/1.18 make make install cd .. https://travis-ci.org/mariuz/f

Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-27 Thread Alex Peshkoff via Firebird-devel
On 11/27/17 17:17, Jiří Činčura wrote: Hi, I have a weird behavior here. Database after b&r, no errors. I try to insert non-unique value into table with unique constraint and it fails as it should. I encrypt it (AES128 from IBPhoenix) and the same statement does not fail. Only the next one will

Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-27 Thread Alex Peshkoff via Firebird-devel
On 11/27/17 17:43, Alex Peshkoff via Firebird-devel wrote: Wierd - I could not reproduce it with . plugin. To be precise - it's IBSurgeon plugin. -- Check out the vibrant tech community on one o

Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-27 Thread Alex Peshkoff via Firebird-devel
On 11/27/17 17:55, Jiří Činčura wrote: To be precise - it's IBSurgeon plugin. Hmm. Of course, could be. Wondering why it fails only on this database? Even more. Test table on this database works fine. What is the size of compressed database backup? --

Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-27 Thread Alex Peshkoff via Firebird-devel
On 11/27/17 17:17, Jiří Činčura wrote: Any ideas what could be wrong and where to look at? AES128 plugin also works fine for me: localhost bin # localhost bin # ./isql e1.fdb Database: e1.fdb, User: SYSDBA SQL> alter database encrypt with AES128; SQL> insert into country values('Russia', 'Ru

Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-27 Thread Alex Peshkoff via Firebird-devel
On 11/27/17 18:08, Jiří Činčura wrote: What is the size of compressed database backup? 52 264 210 bytes, why? Will not fit into email (32M limit on mail.ru), please put it to some reasonable share. -- Check out t

Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-27 Thread Alex Peshkoff via Firebird-devel
On 11/27/17 17:17, Jiří Činčura wrote: Any ideas what could be wrong and where to look at? I've reproduced an issue. Somewhere between catching error in looper and rethrowing it again when leaving looper tdbb_status_vector is cleaned up. BTW, for me it's reproduced each time I logoff/logon

Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-28 Thread Alex Peshkoff via Firebird-devel
On 11/27/17 20:39, Jiří Činčura wrote: I've reproduced an issue. Somewhere between catching error in looper and rethrowing it again when leaving looper tdbb_status_vector is cleaned Great to know, you found it. Jiří, can you try with this patch? I'm 99% sure it will help you to but if you ca

Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-28 Thread Alex Peshkoff via Firebird-devel
On 11/28/17 17:03, Jiří Činčura wrote: Jiří, can you try with this patch? I'm 99% sure it will help you to but if you can check it will be great. Can you maybe commit it to some branch/master and I'll get the fresh build from CI/nightly when it's done? I'm currently not in front of a computer wi

Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-29 Thread Alex Peshkoff via Firebird-devel
On 11/29/17 10:57, Jiří Činčura wrote: OK, the Firebird-4.0.0.816-0_Win32 behaves correctly. Will this go into 3.0.3 as well? As you can already see it's fixed in FB3 branch too. -- Check out the vibrant tech commun

Re: [Firebird-devel] Present state of cmake build system

2017-12-03 Thread Alex Peshkoff via Firebird-devel
On 12/02/17 22:05, William L. Thomson Jr. wrote: Initial feedback, per another post of mine. I am looking to separate out the stuff in extern and package that on its own. I already had btyacc and libtommath. I packaged libtomcrypt. I think the system btyacc no longer works as its from upstream an

Re: [Firebird-devel] Double in clumplets

2017-12-06 Thread Alex Peshkoff via Firebird-devel
On 12/06/17 00:04, Dimitry Sibiryakov wrote: Hello, All.   Can someone explain why double in clumplets is handled as two LONGs, instead of single INT64? Sooner of all due to historical reasons - see xdr_double. And compare it in master and FB1.0. --

Re: [Firebird-devel] Present state of cmake build system

2017-12-07 Thread Alex Peshkoff via Firebird-devel
On 12/03/17 20:16, William L. Thomson Jr. wrote: In a case of regular linux build of FB that sources from extern are not used. One can build with builtin libtom* but this is not recommended way to go. A lot of how Firebird on Gentoo has always been against the recommended way. Gentoo has its ow

Re: [Firebird-devel] Support for timed-zones datatypes

2017-12-12 Thread Alex Peshkoff via Firebird-devel
On 12/12/17 17:57, Adriano dos Santos Fernandes wrote: Oracle also mentions inconsistency that may happen when the time zone database is updated. If user had previously entered a time in a moment that subsequently has updated by the time zone db, it may become inconsistent. So it should be update

Re: [Firebird-devel] Firebird 4 snapshots missing employee example DB

2018-01-06 Thread Alex Peshkoff via Firebird-devel
On 01/06/18 18:15, Mark Rotteveel wrote: The employee database is missing from the Firebird 4 snapshot builds (at least on Windows). Is this a known problem? FYI - present on linux. -- Check out the vibrant tech co

Re: [Firebird-devel] Error compiling FB for android

2018-01-18 Thread Alex Peshkoff via Firebird-devel
On 01/18/18 12:47, Jorge Gonçalves wrote: Hi, I want to make some tests with FB embedded on android, and I'm getting the follow error compiling the source. /home/jgoncalves/dev/android/android-ndk-r16b/toolchains/arm-linux-androideabi-4.9/prebuilt/linux-x86_64/bin/arm-linux-androideabi-g

Re: [Firebird-devel] Database restore problem with 3.0(.3.32882)

2018-01-18 Thread Alex Peshkoff via Firebird-devel
On 01/18/18 15:17, Gabor Boros wrote: Hi All, I have a very minimal database, just created it and added some SQL users into it. After execute the script which create tables, etc. make a backup with gbak. At restore the below error message appears. I found an issue on the tracker which have sa

Re: [Firebird-devel] Weird date/time literals

2018-01-18 Thread Alex Peshkoff via Firebird-devel
On 01/18/18 16:28, liviuslivius wrote: Hi, I see only one usage case. To know when proc eas compiled. But i do not know if this can be usefull. I do not know how this is documented, but if as warning than it can be changed without problem. And as Adriano this looks more like bug then feature

Re: [Firebird-devel] Database restore problem with 3.0(.3.32882)

2018-01-18 Thread Alex Peshkoff via Firebird-devel
On 01/18/18 16:01, Gabor Boros wrote: 2018. 01. 18. 13:41 keltezéssel, Alex Peshkoff via Firebird-devel írta: Send them to me please. Done. Sorry -  did not reproduce, restore log for: ./gbak -v -c BSP2018_20180118_121408.fbk /mnt/db/BSP2018_20180118_121408.FDB >log is attached.

Re: [Firebird-devel] Firebird 3 and ICU

2018-01-19 Thread Alex Peshkoff via Firebird-devel
On 01/19/18 14:03, Roman Simakov wrote: 2018-01-19 12:54 GMT+03:00 Vlad Khorsun via Firebird-devel : 19.01.2018 11:41, Adriano dos Santos Fernandes wrote: On 19/01/2018 07:14, Roman Simakov wrote: it search for ICU library using versions numbers such as 5.19 ... 5.0, 4.19 ... 4.0 etc. But,

Re: [Firebird-devel] SKD_time / SKD_timestamp

2018-01-19 Thread Alex Peshkoff via Firebird-devel
On 01/18/18 18:20, Adriano dos Santos Fernandes wrote: Hi! In little endian version of Sort::diddleKey:         case SKD_timestamp:         case SKD_sql_time:         case SKD_sql_date:             p[3] ^= 1 << 7;             break; How can this be correct for time or timestamp? As a tim

Re: [Firebird-devel] Database restore problem with 3.0(.3.32882)

2018-01-20 Thread Alex Peshkoff via Firebird-devel
On 01/18/18 22:18, Gabor Boros wrote: 2018. 01. 18. 17:50 keltezéssel, Alex Peshkoff via Firebird-devel írta: Sorry -  did not reproduce, restore log for: ./gbak -v -c BSP2018_20180118_121408.fbk /mnt/db/BSP2018_20180118_121408.FDB >log I use "gbak -v -c -user BSPOWNER BSP2018.

Re: [Firebird-devel] DEC_FIXED implementation, Decimal128 is unscaled?

2018-01-29 Thread Alex Peshkoff via Firebird-devel
On 01/27/18 20:18, Mark Rotteveel wrote: I'm implementing the new precision 34 decimal/numeric support in Jaybird, and I notice that the underlying Decimal128 is used as just an integer container, instead of already applying an appropriate exponent for the scale. This was a bit of a surprise to

Re: [Firebird-devel] Unknown tag value - missing in the list of possible

2018-01-30 Thread Alex Peshkoff via Firebird-devel
On 01/29/18 21:26, paul reeves wrote: While debugging a an api call I got the error message in which obviously means I need to check the dpb in this case but I'm intrigued about this error message... What is it actually trying to say? - Is it just saying the same thing twice - because the tag

Re: [Firebird-devel] DEC_FIXED implementation, Decimal128 is unscaled?

2018-02-01 Thread Alex Peshkoff via Firebird-devel
On 02/01/18 15:31, Mark Rotteveel wrote: On 29-1-2018 10:45, Alex Peshkoff via Firebird-devel wrote: May be taken standalone your suggestion is simpler but in conjunction with existing logic for numerics based on bigint and smaller integer values and need to cast between them use of existing

Re: [Firebird-devel] DEC_FIXED implementation, Decimal128 is unscaled?

2018-02-02 Thread Alex Peshkoff via Firebird-devel
On 02/02/18 10:57, Dmitry Yemanov wrote: 01.02.2018 20:24, Mark Rotteveel wrote: Point taken, but my suggestion was more that we now don't utilize the Decimal128 to its fullest for decimal, and users of the direct API now need to handle decfloat and decimal(19+, x) in a very different manner

Re: [Firebird-devel] DEC_FIXED implementation, Decimal128 is unscaled?

2018-02-03 Thread Alex Peshkoff via Firebird-devel
On 02/02/18 22:19, Dimitry Sibiryakov wrote: 02.02.2018 20:03, Mark Rotteveel wrote: I have the feeling I'm missing part of the discussion here   Thunderbird used to reply to author of message directly instead of sending reply to list. It can be changed in settings. That's my fault - two

[Firebird-devel] Fwd: Re: DEC_FIXED implementation, Decimal128 is unscaled?

2018-02-03 Thread Alex Peshkoff via Firebird-devel
rote: 02.02.2018 19:08, Alex Peshkoff wrote: On 02/02/18 19:40, Dimitry Sibiryakov wrote: 02.02.2018 17:25, Alex Peshkoff via Firebird-devel wrote: I.e. to represent NUMERIC/DECIMAL(M, N) where M > 18 will be used SQL_DEC34 with sqlsubtype 1/2? But what should be the value of sql_scale? On

Re: [Firebird-devel] Error compiling FB for android

2018-02-08 Thread Alex Peshkoff via Firebird-devel
On 01/21/18 14:18, Jorge Gonçalves wrote: After some progress I'm blocked... What is missing? Did you choose master branch with knowledge that it is highly experimental or stable B3_0_Release (firebird-3) may be better for you? Anyway - I've fixed android build in master, new features req

Re: [Firebird-devel] Existing a subject of privileges and refactoring

2018-02-20 Thread Alex Peshkoff via Firebird-devel
  I don't know if in currently user's existence can be checked via SEC$USERS. Sooner of all no. SEC$USERS shows only users in security database, we can't check for win_sspi. And even if we learn all plugins to list users that check does not make big sense - we can't ensure that user grante

Re: [Firebird-devel] Existing a subject of privileges and refactoring

2018-02-20 Thread Alex Peshkoff via Firebird-devel
On 02/20/18 14:55, Roman Simakov wrote: Hello! I fixed several bugs related to GRANT operator and investigated a couple of issues I'd like to discuss: 1) Replace RDB$TRIGGER_9 (trigger1 in trig.h) by code in DdlNodes.epp with the same functions. I already did it in CORE-5747 to check grant optio

Re: [Firebird-devel] Existing a subject of privileges and refactoring

2018-02-20 Thread Alex Peshkoff via Firebird-devel
On 02/20/18 15:19, Dimitry Sibiryakov wrote: 20.02.2018 13:14, Alex Peshkoff via Firebird-devel wrote: 2) We have no check of existance a subjects of privileges. I.e. SQL> create table t(i integer); SQL> grant select on t to wrong_func; SQL> show function wrong_func; There is no use

Re: [Firebird-devel] Existing a subject of privileges and refactoring

2018-02-20 Thread Alex Peshkoff via Firebird-devel
On 02/20/18 15:39, Roman Simakov wrote: 2018-02-20 15:27 GMT+03:00 Alex Peshkoff via Firebird-devel : Always requiring object type is best of possible solutions but I'm afraid that's unreal. I've supposed missing keyword, i.e. real failing statement is: grant select o

Re: [Firebird-devel] Valid date or not

2018-02-22 Thread Alex Peshkoff via Firebird-devel
On 02/22/18 16:33, Adriano dos Santos Fernandes wrote: Hi! As part of CORE-5750 problems, I found that Firebird considers '12Mar92' as a valid date (1992-03-12). Should this be considered a bug, i.e., separators should be necessary in this case (12-Mar-92, 12/Mar/92, 12.Mar.92)? Let's better

Re: [Firebird-devel] Firebird 3.0.3 build on Fedora rawhide icu 60.2

2018-02-27 Thread Alex Peshkoff via Firebird-devel
On 02/21/18 13:46, Philippe Makowski wrote: Hi, 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'? This should help: https:

Re: [Firebird-devel] DEC_FIXED implementation, Decimal128 is unscaled?

2018-03-11 Thread Alex Peshkoff via Firebird-devel
On 03/11/18 18:12, Mark Rotteveel wrote: I some changes were made in https://github.com/FirebirdSQL/firebird/commit/1636227d401f3c7e9678dc8cd317af5fae9a56bc I'm observing something odd. It is my understanding it would be possible to drop use of blr_dec_fixed, and use blr_dec128 instead. If I

Re: [Firebird-devel] GDS_EPOCH_START constant

2018-03-19 Thread Alex Peshkoff via Firebird-devel
On 03/18/18 23:16, Adriano dos Santos Fernandes wrote: Is this constant correct? // Number of the first day of UNIX epoch in GDS counting enum { GDS_EPOCH_START = 40617 }; I see that for date 1970-01-01, Firebird stores it as 40587. When counting days and month it's very easy to mix first day

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

2018-03-22 Thread Alex Peshkoff via Firebird-devel
On 03/22/18 15:52, marius adrian popa wrote: It reached somewhere (Could not find acceptable ICU library) Is any ICU installed or not on travis build machine? If not try to install please. -- Check out the vibrant t

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

2018-03-23 Thread Alex Peshkoff via Firebird-devel
On 03/22/18 20:31, marius adrian popa wrote: icu is installed ls /usr/local/opt/icu4c/lib icu libicuio.59.1.dylib libicutu.59.dylib libicudata.59.1.dylib libicuio.59.dylib libicutu.a libicudata.59.dylib libicuio.a libicutu.dylib libicudata.a libicuio.dylib libicuuc.59.1.dylib libicudata.dylib l

Re: [Firebird-devel] Updating README.keywords

2018-03-26 Thread Alex Peshkoff via Firebird-devel
On 03/26/18 18:37, Mark Rotteveel wrote: I just noticed that I should also have updated README.keywords in https://github.com/FirebirdSQL/firebird/pull/150 But as I need to update it anyway, is it OK if I do a slightly more thorough overhaul? I noticed that some of the words marked with * are

Re: [Firebird-devel] Win1252 Charset on MacOS

2018-03-27 Thread Alex Peshkoff via Firebird-devel
On 03/27/18 16:47, Elmar Haneke wrote: It will build, but deprecated implies that you might have an issue trying to run it on 10.7 or 10.8... In any event without the fix for the _clock_gettime function in configure.in your code will only run on 10.12 and no OS version below it. By default the

Re: [Firebird-devel] Updating README.keywords

2018-03-27 Thread Alex Peshkoff via Firebird-devel
On 03/27/18 14:32, Mark Rotteveel wrote: On 26-3-2018 18:03, Alex Peshkoff via Firebird-devel wrote: On 03/26/18 18:37, Mark Rotteveel wrote: I just noticed that I should also have updated README.keywords in https://github.com/FirebirdSQL/firebird/pull/150 But as I need to update it anyway

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

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

[Firebird-devel] ICU loader

2018-03-28 Thread Alex Peshkoff via Firebird-devel
To all interested in it... Fixing CORE-5764 I've changed a bit process of ICU loading yo make it more universal. That changed may be tested in master branch, FB4 snapshots aready contain modified ICU loader. Please check does your favorite version(s) of ICU loads successfully with fb4 snapshot

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

2018-03-29 Thread Alex Peshkoff via Firebird-devel
On 03/27/18 20:08, Mark Rotteveel wrote: I increased the TcpRemoteBufferSize to 32767 (the documented maximum value) in my firebird.conf, and when I run the full test suite of Jaybird Is it that set of tests which is started in the end of $JAYBIRD/build.sh execution? , the tests hang consist

Re: [Firebird-devel] Database encryption

2018-04-02 Thread Alex Peshkoff via Firebird-devel
On 03/31/18 16:45, Dimitry Sibiryakov wrote: Hello, All.   Is it intentional that database cannot be encrypted via remote connection if encryption plugin requires key obtained from application callback?   I'm getting following error: Statement failed, SQLSTATE = 42000 unsuccessful metadata

Re: [Firebird-devel] Sequence of key holder's methods calls

2018-04-02 Thread Alex Peshkoff via Firebird-devel
On 04/02/18 17:58, Dimitry Sibiryakov wrote: Hello, All.   Firebird 3.0.4.32939. Default configuration. Key holder is set in databases.conf for single database.   When I use "alter database encrypt" within embedded connection I see following sequence of calls to my key holder plugin: crea

Re: [Firebird-devel] Database encryption

2018-04-02 Thread Alex Peshkoff via Firebird-devel
On 04/02/18 18:31, Dimitry Sibiryakov wrote: 02.04.2018 17:25, Alex Peshkoff via Firebird-devel wrote: Encryption of database using key passed from application over the wire works well in at least 2 known to me plugins: - DbCrypt_example/KeyHolder_example present in firebird distro   This

Re: [Firebird-devel] Database encryption

2018-04-02 Thread Alex Peshkoff via Firebird-devel
On 04/02/18 18:57, Dimitry Sibiryakov wrote: 02.04.2018 17:43, Alex Peshkoff via Firebird-devel wrote: - one more closed-source plugin I've used to deal with   Perhaps, it has the same limitations. No.   Could you reveal the secret then: how application callback receives name of

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

2018-04-03 Thread Alex Peshkoff via Firebird-devel
On 03/29/18 18:45, Mark Rotteveel wrote: On 29-3-2018 13:19, Alex Peshkoff via Firebird-devel wrote: On 03/27/18 20:08, Mark Rotteveel wrote: I increased the TcpRemoteBufferSize to 32767 (the documented maximum value) in my firebird.conf, and when I run the full test suite of Jaybird Is it

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

2018-04-03 Thread Alex Peshkoff via Firebird-devel
On 04/03/18 14:43, Mark Rotteveel wrote: On 2018-04-03 12:54, Alex Peshkoff via Firebird-devel wrote: On 03/29/18 18:45, Mark Rotteveel wrote: On 29-3-2018 13:19, Alex Peshkoff via Firebird-devel wrote: On 03/27/18 20:08, Mark Rotteveel wrote: I increased the TcpRemoteBufferSize to 32767 (the

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

2018-04-03 Thread Alex Peshkoff via Firebird-devel
On 04/03/18 16:32, Mark Rotteveel wrote: On 2018-04-03 14:45, Alex Peshkoff via Firebird-devel wrote: I've executed it 100 times. Each time in the end I get: one-test-pure-java:     [junit] Running org.firebirdsql.jdbc.TestReproHang     [junit] Tests run: 46, Failures: 0, Errors: 131, Sk

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

2018-04-03 Thread Alex Peshkoff via Firebird-devel
On 04/03/18 16:39, Alex Peshkoff via Firebird-devel wrote: On 04/03/18 16:32, Mark Rotteveel wrote: On 2018-04-03 14:45, Alex Peshkoff via Firebird-devel wrote: I've executed it 100 times. Each time in the end I get: one-test-pure-java:     [junit] Running org.firebirdsql.jdbc.TestRepr

Re: [Firebird-devel] Update ICU in Windows

2018-04-09 Thread Alex Peshkoff via Firebird-devel
On 04/09/18 18:26, Adriano dos Santos Fernandes wrote: Hi! I'm looking for a way to update ICU in Windows. I also think we should just stop to save few megabytes customizing ICU. +1 -- Check out the vibrant tech

Re: [Firebird-devel] Question about XDR protocol and BLOB

2018-04-09 Thread Alex Peshkoff via Firebird-devel
On 04/09/18 15:55, Arnaud Le-roy wrote: Hi, I contribute to node-firebird provider and I have question about the way to retrieve blob. First it works well, but I think the way is not good and could cause future problems (hang connection). An exemple a request retrieve 2000 rows with two blob

Re: [Firebird-devel] Firebird fbudf Module Authenticated Remote Code Execution

2018-04-12 Thread Alex Peshkoff via Firebird-devel
On 04/12/18 10:37, marius adrian popa wrote: https://www.tenable.com/security/research/tra-2017-36 That's fixed in FB4 - loading UDFs is denied by default configuration, use of them is deprecated, replacement is UDRs which are nt affected by mentioned vulnerability. In FB3 one should be sysdb

Re: [Firebird-devel] Protocol for database encryption callback

2018-04-12 Thread Alex Peshkoff via Firebird-devel
On 04/12/18 15:18, Mark Rotteveel wrote: How does the protocol for the database encryption callback work? If I look at the implementation in Firebird ADO.net, it just tries and keep sending the same key in a while loop until Firebird responds with something other than op_crypt_key_callback, whi

Re: [Firebird-devel] Protocol for database encryption callback

2018-04-12 Thread Alex Peshkoff via Firebird-devel
On 04/12/18 16:51, Mark Rotteveel wrote: On 12-4-2018 15:31, Alex Peshkoff via Firebird-devel wrote: On 04/12/18 15:18, Mark Rotteveel wrote: How does the protocol for the database encryption callback work? If I look at the implementation in Firebird ADO.net, it just tries and keep sending

Re: [Firebird-devel] Protocol for database encryption callback

2018-04-12 Thread Alex Peshkoff via Firebird-devel
On 04/12/18 18:20, Mark Rotteveel wrote: On 12-4-2018 16:51, Alex Peshkoff via Firebird-devel wrote: On 04/12/18 16:51, Mark Rotteveel wrote: On 12-4-2018 15:31, Alex Peshkoff via Firebird-devel wrote: On 04/12/18 15:18, Mark Rotteveel wrote: How does the protocol for the database encryption

Re: [Firebird-devel] alloc.h global operator new replacement violating alignment requirements

2018-04-16 Thread Alex Peshkoff via Firebird-devel
On 04/16/18 15:08, Stephan Bergmann wrote: On 17/02/17 11:48, Alex Peshkoff wrote: On 02/16/17 15:52, Stephan Bergmann wrote: Forgive me if this has already been discussed or even fixed in later versions:  At least the Firebird 3.0 we build as part of LibreOffice defines global operator new rep

Re: [Firebird-devel] Legacy API functions for new features?

2018-04-16 Thread Alex Peshkoff via Firebird-devel
On 04/16/18 18:52, Adriano dos Santos Fernandes wrote: Hi! Should exist isc encode/decode time/timestamp tz (with time zone) API functions? Or could this be only in IUtil? I suggest to have them initially only in IUtil. If ISC functions will be actually requested we can always add them late

Re: [Firebird-devel] "Postfix for CORE-5791. Sorry to snapshot builds users..."

2018-04-17 Thread Alex Peshkoff via Firebird-devel
On 04/17/18 13:19, liviuslivius wrote: Hi Alex what does comment : ""Postfix for CORE-5791. Sorry to snapshot builds users - had to change ODS minor once again. If someone was using snapshots with ODS 12.1 please backup with old snapshot code and restore using current one. " in commit https://

Re: [Firebird-devel] Protocol for database encryption callback

2018-04-17 Thread Alex Peshkoff via Firebird-devel
On 04/17/18 16:21, Mark Rotteveel wrote: On 12-4-2018 16:51, Alex Peshkoff via Firebird-devel wrote: There was a bug in v.13 - size of respond buffer was not passed over the wire. Ok, so in V13 one would only need to read the data buffer, and in v14 and higher, one would also need to read

Re: [Firebird-devel] encoding of result strings

2018-04-18 Thread Alex Peshkoff via Firebird-devel
On 04/18/18 10:01, Dev wrote: What encoding is used for in/out strings in: function IProvider.attachDatabase(status: IStatus; fileName: PAnsiChar; dpbLength: Cardinal; dpb: BytePtr): IAttachment; function IProvider.createDatabase(status: IStatus; fileName: PAnsiChar; dpbLength: Cardinal; dpb: B

Re: [Firebird-devel] Handling of database encryption callback for service operations

2018-04-24 Thread Alex Peshkoff via Firebird-devel
On 04/24/18 11:35, Mark Rotteveel wrote: Does anyone know? On 21-4-2018 17:10, Mark Rotteveel wrote: How and when are database encryption callbacks performed for service operations that involve an encrypted callback? For example retrieving statistics like isc_spb_sts_sys_relations. During se

Re: [Firebird-devel] Handling of database encryption callback for service operations

2018-04-26 Thread Alex Peshkoff via Firebird-devel
On 04/26/18 10:31, Mark Rotteveel wrote: On 24-4-2018 12:03, Alex Peshkoff via Firebird-devel wrote: Mark sorry but looks like I've already answered this many times - the only 2 gstat functions that will currently work with encrypted database are print header (-h) and print crypt stati

Re: [Firebird-devel] Handling of database encryption callback for service operations

2018-04-26 Thread Alex Peshkoff via Firebird-devel
On 04/26/18 11:34, Mark Rotteveel wrote: On 26-4-2018 10:11, Alex Peshkoff via Firebird-devel wrote: On 04/26/18 10:31, Mark Rotteveel wrote: On 24-4-2018 12:03, Alex Peshkoff via Firebird-devel wrote: Mark sorry but looks like I've already answered this many times - the only 2

Re: [Firebird-devel] Handling of database encryption callback for service operations

2018-04-26 Thread Alex Peshkoff via Firebird-devel
On 04/26/18 14:11, Mark Rotteveel wrote: On 26-4-2018 12:28, Alex Peshkoff via Firebird-devel wrote: You understood me wrong - database encryption callback is supported in services connections. _UTILITY_ gstat supports only -h and -e switches. It is not related with protocol but has some

Re: [Firebird-devel] Handling of database encryption callback for service operations

2018-04-26 Thread Alex Peshkoff via Firebird-devel
On 04/26/18 15:09, Mark Rotteveel wrote: On 26-4-2018 13:45, Alex Peshkoff via Firebird-devel wrote: On 04/26/18 14:11, Mark Rotteveel wrote: On 26-4-2018 12:28, Alex Peshkoff via Firebird-devel wrote: You understood me wrong - database encryption callback is supported in services connections

Re: [Firebird-devel] Handling of database encryption callback for service operations

2018-04-26 Thread Alex Peshkoff via Firebird-devel
On 04/26/18 15:23, Mark Rotteveel wrote: I don't receive a callback from Firebird for service operations involving an encrypted database, so I can't respond to it. That's very strange. Is protocol version correct? You should receive it during service attach call. ---

Re: [Firebird-devel] CHAR fields in system tables

2018-04-28 Thread Alex Peshkoff via Firebird-devel
On 04/28/18 12:22, fbbt wrote: For example: CREATE TABLE SEC$USERS ( SEC$USER_NAMECHAR(63), SEC$FIRST_NAME SEC$NAME_PART /* SEC$NAME_PART = VARCHAR(32) NOT NULL */, SEC$MIDDLE_NAME SEC$NAME_PART /* SEC$NAME_PART = VARCHAR(32) NOT NULL */, SEC$LAST_NAMESEC$NAME_PART

Re: [Firebird-devel] exception handling in firebird.pas

2018-05-03 Thread Alex Peshkoff via Firebird-devel
On 04/30/18 11:20, Mark Rotteveel wrote: On 30-4-2018 09:52, fbbt wrote: 3. Maybe we need to put a sample of firebird.pas at github. It will allow other developers to patch it in more productive way than now. As I understand it, firebird.pas is generated by Cloop, so allowing people to patch

Re: [Firebird-devel] SET DECFLOAT command

2018-05-03 Thread Alex Peshkoff via Firebird-devel
On 05/03/18 13:12, Dimitry Sibiryakov wrote: Hello, All.   Is subj allowed in ON CONNECT triggers? Directly not - but one can run it via EXECUTE STATEMENT. -- Check out the vibrant tech community on one of the world

Re: [Firebird-devel] SET DECFLOAT command

2018-05-03 Thread Alex Peshkoff via Firebird-devel
On 05/03/18 13:31, Dimitry Sibiryakov wrote: 03.05.2018 12:29, Alex Peshkoff via Firebird-devel wrote:   Is subj allowed in ON CONNECT triggers? Directly not - but one can run it via EXECUTE STATEMENT.   What's the point for such complication? It is not a DDL. The decision shou

Re: [Firebird-devel] Firebird v3.0.x support for External Functions plug-in

2018-05-08 Thread Alex Peshkoff via Firebird-devel
On 05/08/18 01:18, Leyne, Sean wrote: The Firebird v3.0.x release notes outlines that plug-ins support has been added, and mentions that it will be extended to supporting SP, Functions and Triggers. Was this ever implemented/completed? Ardiano (specially about Java) will answer better - I jus

Re: [Firebird-devel] Key holder is not used if keyCallback() returned 0

2018-05-10 Thread Alex Peshkoff via Firebird-devel
On 04/14/18 13:14, Dimitry Sibiryakov wrote: Hello, All.   What is a meaning of return value of keyCallback() routine?   It is declared as int, not FB_BOOLEAN, so I guess it is not a flag "use me". But it looks like the engine give up if zero is returned even if no error is set in status.   D

Re: [Firebird-devel] Virtual table for time zones

2018-05-10 Thread Alex Peshkoff via Firebird-devel
On 05/10/18 18:21, Adriano dos Santos Fernandes wrote: Hi! I want to create a virtual table that lists available time zones. For now there is RDB$ (non-virtual), MON$ (virtual, but all about monitoring), SEC$ (security plugin). What prefix should TIME_ZONES have? Can you provide a small samp

Re: [Firebird-devel] Key holder is not used if keyCallback() returned 0

2018-05-14 Thread Alex Peshkoff via Firebird-devel
On 05/10/18 18:36, Dimitry Sibiryakov wrote: 10.05.2018 17:20, Alex Peshkoff via Firebird-devel wrote:   BTW, is there a way to distinguish cases when a) ICryptKeyCallback::callback() returned zero because application key not needed b) Application callback is not set Both cases are normal

Re: [Firebird-devel] Key holder is not used if keyCallback() returned 0

2018-05-14 Thread Alex Peshkoff via Firebird-devel
On 05/14/18 12:52, Dimitry Sibiryakov wrote: 14.05.2018 11:42, Alex Peshkoff via Firebird-devel wrote: Returning to your cases: a) ICryptKeyCallback::callback() returned zero because application key not needed Well written key holder will not try to talk to client at all if it already has

Re: [Firebird-devel] Key holder is not used if keyCallback() returned 0

2018-05-14 Thread Alex Peshkoff via Firebird-devel
On 05/14/18 13:15, Dimitry Sibiryakov wrote: 14.05.2018 11:57, Alex Peshkoff via Firebird-devel wrote: If key holder is expected to work with both types of keys secrtainly it should try to talk to client. One written only for use of non-client keys should not. Wjat a problem?   Number of

Re: [Firebird-devel] Key holder is not used if keyCallback() returned 0

2018-05-14 Thread Alex Peshkoff via Firebird-devel
On 05/14/18 15:58, Dimitry Sibiryakov wrote: 14.05.2018 14:28, Alex Peshkoff via Firebird-devel wrote:   Number of combination growth as N^2 at least. Writing of separate plugins for each possible use case is... boring. What combinations? Key holder may need to establish connection to client

Re: [Firebird-devel] Virtual table for time zones

2018-05-15 Thread Alex Peshkoff via Firebird-devel
On 05/10/18 19:40, Vlad Khorsun via Firebird-devel wrote: 10.05.2018 19:23, Adriano dos Santos Fernandes wrote: On 10/05/2018 13:12, Vlad Khorsun via Firebird-devel wrote:    I guess the question is about the case when users have historical data and need to apply old time zone rule to the ol

Re: [Firebird-devel] MessageBuffer vs C struct alignment

2018-05-15 Thread Alex Peshkoff via Firebird-devel
On 05/15/18 12:55, Dimitry Sibiryakov wrote: Hello, All.   Do alignment of fields in C struct matches alignment of the same fields in MessageBuffer?   If at compile/preprocess time construct a struct to be used directly in OO API, will it be reliable? Not always.  For example, on 32-bit li

  1   2   3   4   5   6   7   8   9   >