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

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

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

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

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.

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] 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 you appraise

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

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

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

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

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

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

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

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

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

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

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.

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

<    4   5   6   7   8   9