Re: [Firebird-devel] Building the Debian Firebird 2.5.1 Package for Ubuntu 8.04 (Hardy)

2011-12-19 Thread Tony Whyman
Oops - a typo - meant kernel 2.6.24! glibc 2.7 is OK, what about kernel 2.4.24 - not sure, I've started development with 2.6.27 Does kernel 2.4 support NPTL correctly? -- Learn Windows Azure Live! Tuesday, Dec 13,

Re: [Firebird-devel] Building the Debian Firebird 2.5.1 Package for Ubuntu 8.04 (Hardy)

2011-12-19 Thread Tony Whyman
the dynamically loaded libraries. The warning would then go away. Tony Whyman MWA On 19/12/11 12:12, Alex Peshkoff wrote: ony, on my mind that's something worth fixing. Build goes wrong at some step, looks like you use h-file from one version of ICU, but have libraries from other version

[Firebird-devel] Firebird Merge Modules - Can someone take this over

2012-05-30 Thread Tony Whyman
=doc_downloadgid=60Itemid=82 Tony Whyman MWA Software -- 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

[Firebird-devel] libfbembed and Debian/Ubuntu Builds

2014-03-25 Thread Tony Whyman
that this is correct and that setting this macro would not have undesirable consequences for the classic or super classic servers. Tony Whyman MWA -- Learn Graph Databases - Download FREE O'Reilly Book Graph Databases is the definitive new

Re: [Firebird-devel] libfbembed and Debian/Ubuntu Builds

2014-03-26 Thread Tony Whyman
to be a serious disbenefit resulting from the change in behaviour. On 26/03/14 06:31, Alex Peshkoff wrote: On 03/25/14 18:13, Tony Whyman wrote: Talk of libfbembed has reminded me of a problem I have been having with the debian/ubuntu builds for Firebird 2.5. It seems that the embeded server for this build

Re: [Firebird-devel] libfbembed and Debian/Ubuntu Builds

2014-03-26 Thread Tony Whyman
as the embedded server. Tony Whyman MWA On 26/03/14 09:36, Dimitry Sibiryakov wrote: 26.03.2014 10:23, Tony Whyman wrote: 1, Requiring access to the security database is a change in behaviour from Firebird 2.1 and breaks any implementation that relied on this. You badly mix up Firebird

Re: [Firebird-devel] libfbembed and Debian/Ubuntu Builds

2014-03-26 Thread Tony Whyman
for the security database. Tony Whyman MWA On 26/03/14 10:29, Alex Peshkoff wrote: On 03/26/14 13:23, Tony Whyman wrote: 1, Requiring access to the security database is a change in behaviour from Firebird 2.1 and breaks any implementation that relied on this. If you do not use -user switch in isql

Re: [Firebird-devel] libfbembed and Debian/Ubuntu Builds

2014-03-26 Thread Tony Whyman
database was in the directory given by the FIREBIRD environment variable. Under Firebird 2.5 there seems to be no workaround. I have already posted a bug report on the IBPP list about this. The FIREBIRD environment variable issue probably needs to be progressed separately. Tony Whyman MWA On 26/03

Re: [Firebird-devel] libfbembed and Debian/Ubuntu Builds

2014-03-26 Thread Tony Whyman
Fluvio, It looks like the patch I submitted was stripped off before the post was copied to the list. If you want to test it then I can send to you by direct EMail. Regards Tony Whyman MWA On 26/03/14 15:21, Fulvio Senore wrote: Tony, thank you for your clarification. I am using IBPP too

[Firebird-devel] The Firebird 3 API and programming language independence

2014-07-13 Thread Tony Whyman
will be off limits. May I humbly suggest that a language independent version of the new API is also made available - perhaps by defining tables of function pointers. Tony Whyman MWA -- Firebird-Devel mailing list, web

Re: [Firebird-devel] The Firebird 3 API and programming language independence

2014-07-13 Thread Tony Whyman
Sorry - what is UIB and where do I find it? On 13/07/14 15:12, Dimitry Sibiryakov wrote: Take interface unit from UIB. -- Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] The Firebird 3 API and programming language independence

2014-07-13 Thread Tony Whyman
Thanks - I'll take a look On 13/07/14 15:43, Dmitry Yemanov wrote: 13.07.2014 18:36, Dimitry Sibiryakov wrote: http://sourceforge.net/projects/uib/ And the module he supposedly refers to is: https://sourceforge.net/p/uib/code/HEAD/tree/trunk/source/uibfblib.pas Dmitry

Re: [Firebird-devel] The Firebird 3 API and programming language independence

2014-07-13 Thread Tony Whyman
). Is there a true platform, compiler and language independent means of accessing the new API or is it limited to C++ and special cases where the vtable is the same? Tony Whyman MWA On 13/07/14 15:43, Dmitry Yemanov wrote: 13.07.2014 18:36, Dimitry Sibiryakov wrote: http://sourceforge.net/projects/uib

Re: [Firebird-devel] The Firebird 3 API and programming language independence

2014-07-13 Thread Tony Whyman
that should be complier neutral on the same platform? Tony Whyman MWA On 13/07/14 17:54, Tony Whyman wrote: Well, I downloaded uibfblib.pas. and merged it into my test program. Compiled it using FPC 2.6.4 under 64-bit Linux and the same problem. Fails with a SIGSEGV. Again, I am not surprised

[Firebird-devel] Problems with the Firebird 3 API

2014-07-14 Thread Tony Whyman
does not meet that requirement. Tony Whyman MWA -- Want fast and easy access to all the code in your enterprise? Index and search up to 200,000 lines of code with a free copy of Black Duck#174; Code Sight#153; - the same

Re: [Firebird-devel] C++ and the API

2014-07-15 Thread Tony Whyman
'fb_get_master_interface' as a C++ function may well be the easiest way to protect the innocent. Tony Whyman MWA On 15/07/14 13:56, James Starkey wrote: There appears to be an impass: The desire to define an interface in C++ and the problems of cross compiler and cross language access to the API. Here are some

Re: [Firebird-devel] C++ and the API

2014-07-15 Thread Tony Whyman
and probably the best approach is a set of 'C' wrappers. As Jim indicated, this should not be a difficult problem to solve. Tony Whyman MWA On 15/07/14 14:13, Dimitry Sibiryakov wrote: 15.07.2014 15:08, Tony Whyman wrote: I agree with Jim is probably the easiest way to respond to this. I have

Re: [Firebird-devel] Problems with the Firebird 3 API

2014-07-21 Thread Tony Whyman
will need to be checked to make sure that it hasn't changed. This is asking too much of the Firebird user, especially when the solution is so straightforward. Tony Whyman MWA On 21/07/14 15:04, Alex Peshkoff wrote: On 07/21/14 17:09, Dmitry Yemanov wrote: 21.07.2014 16:32, Alex Peshkoff wrote

Re: [Firebird-devel] Problems with the Firebird 3 API

2014-07-22 Thread Tony Whyman
++ program to attempt to use an implicit and invisible vtable. Crazy, nuts, insane, bonkers. Totally agree. As for what new features are in the interface - that is a separate discussion. Let's first agree that any new interface should be platform and language independent. Tony Whyman MWA

Re: [Firebird-devel] New Interface

2014-07-30 Thread Tony Whyman
Well, if there is any conclusion you can get from this is that 87% of respondents are working in Pascal and hence the importance of ensuring that a suitable language binding is available for Pascal. But, even though I am a strong advocate of Pascal, I also use PHP and C++ with Firebird, and I

Re: [Firebird-devel] New Interface

2014-07-30 Thread Tony Whyman
next? On Jul 30, 2014, at 6:11 PM, Tony Whyman wrote: Well, if there is any conclusion you can get from this is that 87% of respondents are working in Pascal and hence the importance of ensuring that a suitable language binding is available for Pascal. But, even though I am a strong advocate

Re: [Firebird-devel] New Interface

2014-07-31 Thread Tony Whyman
, 2014, at 11:59 AM, marius adrian popa wrote: There are a few directions for interfaces What is needed is cleaner c++ interface that can be used from other languages : Delphi or with a easy wrapper around and it should be workable state in the examples area On Jul 29, 2014, at 6:08 PM, Tony

Re: [Firebird-devel] New Interface

2014-08-08 Thread Tony Whyman
Hey guys - someone would also like to get this discussion back on track. If there is anything that has come out of these discussions is the importance of the Delphi/Free Pascal user base and the first requirement for the FB3 API has to be to ensure that these users have an efficient and easy to

Re: [Firebird-devel] New Interface

2014-08-09 Thread Tony Whyman
All this heat is not useful. Yes, of course Delphi and Free Pascal use a non-standard ABI. That's because there is no standard. Likewise, C++ compilers also have a non-standard ABI. In the absence of standards all we can do is default to the lowest common denominator and, in practice, that

[Firebird-devel] So, What's wrong with IBPP?

2014-08-11 Thread Tony Whyman
Firebird already has a C++ Interface that is widely if not universally used by C++ Developers (including myself) to access the Firebird API. This is IBPP. IMHO, it is well designed, stable and fit for purpose. It compares well with similar libraries such as MySQL++ and Oracle OCCI. On the other

Re: [Firebird-devel] So, What's wrong with IBPP?

2014-08-11 Thread Tony Whyman
, Mark Rotteveel wrote: On Mon, 11 Aug 2014 09:18:58 +0100, Tony Whyman tony.why...@mccallumwhyman.com wrote: I think this discussion is getting a bit out of control. I for one still have tens of unread messages on this subject, but I get the feeling people are talking past each other instead

Re: [Firebird-devel] New Interface

2014-08-11 Thread Tony Whyman
Before this goes much further, can someone confirm that COM is compatible with Linux. I was always under the impression that it was a Windows only technology. Googling the subject does not come up anything other than DCOM and a lot of negative comments on COM. COM is full of problems: - UTF16

Re: [Firebird-devel] New Interface

2014-08-12 Thread Tony Whyman
Mark, A good post as this sums up the issue. I only hope that the core team are listening as what happens to a project when the developers ignore the users? On 12/08/14 09:13, Mark Rotteveel wrote: The main point of an API is to allow developers to*use* Firebird, so please do not alienate

Re: [Firebird-devel] New Interface

2014-08-14 Thread Tony Whyman
I'm not quite sure what you think is wrong with this code (from the fpc viewpoint): # [31] WriteLn(master.getVersion()); callfpc_get_output movq%rax,%rbx movqU_P$CREATE_MASTER,%rdi movqU_P$CREATE_MASTER,%rax movq(%rax),%rax call*(%rax) movl

Re: [Firebird-devel] New Interface

2014-08-14 Thread Tony Whyman
, and the parameters are passed in right-to-left order. The difference is the addition of the //*this* pointer http://en.wikipedia.org/wiki/This_%28computer_programming%29//, which is pushed onto the stack last, as if it were the first parameter in the function prototype./ On 14/08/14 13:08, Tony

Re: [Firebird-devel] New Interface

2014-08-14 Thread Tony Whyman
to GetMaster - or at least the internal call that validates the interface - so there really is something different between the two structures. On 14/08/14 14:56, Dimitry Sibiryakov wrote: 14.08.2014 14:08, Tony Whyman wrote: I'm not quite sure what you think is wrong with this code (from the fpc

Re: [Firebird-devel] New Interface

2014-08-14 Thread Tony Whyman
I was using the Alpha 2 source On 14/08/14 15:23, Adriano dos Santos Fernandes wrote: On 14/08/2014 11:04, Tony Whyman wrote: master := IMaster(GetMaster()); The program now does complete without an error, but returns 15 as the version. My reading of the Firebird code is that the correct

Re: [Firebird-devel] New Interface

2014-08-15 Thread Tony Whyman
On 15/08/14 08:48, Dimitry Sibiryakov wrote: Integers are ok, pointers are ok, interfaces are in trouble This should probably be written in stone somewhere. Even simple external calls such as fb_get_master_interface are difficult enough. You have carefully define each data type used and ensure

Re: [Firebird-devel] Roadmap for a Distributed Firebird

2015-03-23 Thread Tony Whyman
Just out of interest, is OCFS2/DRBD any use as a page/lock server? On 23/03/15 13:01, James Starkey wrote: The major new piece is a separate component, the page server. By phase 5, it will be necessary to integrate page change and lock manager traffic, so perhaps a better name would be

Re: [Firebird-devel] optional SET TERM

2015-10-15 Thread Tony Whyman
available. My recollection is that it was more complicated adding ISQL set term compatibility (i.e. having to parse a set term statement) than it was to count begin/end block nesting and ignore semi-colons except in the outer block. Anyway, the parser worked regardless of whether set term was u

Re: [Firebird-devel] optional SET TERM

2015-10-16 Thread Tony Whyman
Yes, the number of times I have caught out by that little oddity. On 16/10/15 14:29, Alex Peshkoff wrote: > Which must be present in the end of struct or class The underlying point is that an sql script parser doesn't have to do a complete analysis but does have to break up the text into blocks

Re: [Firebird-devel] optional SET TERM

2015-10-16 Thread Tony Whyman
Except that there is no more reason for a separator after the final PSQL END statement than there is in 'C' for a semi-colon after a closing brace. On 16/10/15 14:01, Ivan Přenosil wrote: > There are actually two separators/terminators - one to be used in scripts > to separate commands, one to

[Firebird-devel] Slice Description Language

2016-08-25 Thread Tony Whyman
. Is there any documentation or examples on using this interface? Tony Whyman MWA -- Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Compiling Firebird.pas on Free Pascal

2016-09-05 Thread Tony Whyman
I put it at the beginning On 05/09/16 10:22, Alex Peshkoff wrote: > On 09/04/2016 06:26 PM, Tony Whyman wrote: >> {$ifdef fpc} {$mode delphi} {$endif} > Yes -Mdelphi is required switch. > > And where should be that line added? In the most beginni

Re: [Firebird-devel] Compiling Firebird.pas on Free Pascal

2016-09-04 Thread Tony Whyman
Martin, I had the same problem. You have to add {$ifdef fpc} {$mode delphi} {$endif} in order to compile with FPC. Tony Whyman MWA On 04/09/16 14:29, Martin Schreiber wrote: > On Sunday 04 September 2016 10:34:05 Martin Schreiber wrote: >> Hi, >> Currently I am implementi

[Firebird-devel] Reliably Determining whether Engine12 is available as a Provider

2016-11-22 Thread Tony Whyman
e and repeated calls to IPluginSet.next get you nowhere but an unending loop. Any ideas? Tony Whyman MWA -- Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Reliably Determining whether Engine12 is available as a Provider

2016-11-22 Thread Tony Whyman
On 22/11/16 16:56, Alex Peshkoff wrote: > On 11/22/16 16:42, Tony Whyman wrote: >> I am trying to find a way of determining whether Engine12 is available >> as a provider when using the FIrebird 3 API. >> >> Enumerating the list of Providers in firebird.conf tells

[Firebird-devel] Firebird 3 Debian Packages

2016-11-21 Thread Tony Whyman
istributed" firebird.conf and include "Engine12" in the list of providers. However, libengine12 is not installed. You need also to install the firebird3.0-server-core to get this installed. Is this a problem? Would it be better if the firebird.conf file correctly reflected

Re: [Firebird-devel] Firebird 3 Debian Packages

2016-11-21 Thread Tony Whyman
Of course what this does seem to imply is that you can't scan the list of providers in the configuration file (e.g. using the Firebird API) to reliably determine which providers are available. On 21/11/16 16:01, Alex Peshkoff wrote: Missing providers are ignored. >Would it be better if

[Firebird-devel] IBX2 is now available with full support for the FIrebird 3 API

2016-12-07 Thread Tony Whyman
For those interested in using Firebird from Pascal/Lazarus, I've copied the following announcement to this list. Tony Whyman MWA Software Announcement follows: MWA Software is pleased to announce the release of IBX2 for Lazarus. This is formally a pre-release. Although the software has been

Re: [Firebird-devel] Authentication plugin mismatch not clearly reported to client

2018-06-25 Thread Tony Whyman
On 25/06/18 11:17, Dimitry Sibiryakov wrote: 25.06.2018 11:29, Tony Whyman wrote: Even if it were still computationally infeasible to break Srp today, it is probably that in the next few years it will be totally broken.   You missed my words "non-theoretical". There is nothing t

Re: [Firebird-devel] Authentication plugin mismatch not clearly reported to client

2018-06-25 Thread Tony Whyman
On 25/06/18 10:02, Dimitry Sibiryakov wrote: 25.06.2018 10:35, Alex Peshkoff via Firebird-devel wrote: Afraid you are wrong here. It helps an attacker to detect what plugin is actually used by server (for example - srp or srp256) and use that info to attack particular plugin later.   Does

Re: [Firebird-devel] Authentication plugin mismatch not clearly reported to client

2018-06-25 Thread Tony Whyman
On 25/06/18 10:14, Alex Peshkoff via Firebird-devel wrote: On 25.06.2018 12:02, Dimitry Sibiryakov wrote: 25.06.2018 10:35, Alex Peshkoff via Firebird-devel wrote: Afraid you are wrong here. It helps an attacker to detect what plugin is actually used by server (for example - srp or srp256)

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

2018-05-03 Thread Tony Whyman
Perhaps worth noting that the version of Firebird.pas distributed with IBX for Lazarus is patched with many changes. See https://svn.mwasoftware.co.uk/viewvc/public/ibx/trunk/fbintf/client/3.0/firebird/Firebird.pas?revision=209=markup This is: 1. To comment out all exception handling. This is

Re: [Firebird-devel] isc_database_info and current database user

2019-03-01 Thread Tony Whyman
I am just wondering if the requested feature is not already present. A quick test with isc_database_info, with SYSDBA and a normal user logged in shows: - SYSDBA connection: only SYSDBA appears to be returned. - User connection: only user name is returned. From the security viewpoint, only

Re: [Firebird-devel] Query statistics

2019-08-01 Thread Tony Whyman
There's also the isc_dsql_sql_info() API call (see chapter 6 of the API Guide). This gives statistics on a per SQL statement basis, and allows you to get the number of inserts, updates, deletes, etc. performed by the statement. Note that in the Firebird 3 API this is implemented as the

Re: [Firebird-devel] IResultSet and IStatement releasing

2019-12-05 Thread Tony Whyman
". In all cases, you should null the pointer to the interface after disposing of it. The Firebird Pascal API is object oriented and more than one copy of an object can reference the same underlying Firebird interface, hence it always uses reference counter interfaces to dispose of objects. Regards T

Re: [Firebird-devel] IResultSet and IStatement releasing

2019-12-05 Thread Tony Whyman
IBX's Firebird Pascal API uses the IProvider interface to get an attachment. It uses IAttachment to get a transaction (single database) or IDtc/IDtcStart for a multi-database transaction. On 05/12/2019 10:31, Jiří Činčura wrote: 3. A transaction (ITransaction) is disposed of with a "release"

Re: [Firebird-devel] Firebird UDF compiled with Lazarus 2.0.0 and FPC 3.0.4

2020-02-26 Thread Tony Whyman
My guess is that you are using the wrong calling convention for Linux. Note: IBX uses "stdcall" when accessing the Firebird API under Windows, but changes to using "cdecl" under Linux. On 26/02/2020 13:30, Massimo Fazzolari wrote: Hi, I compiled a Firebird UDF library written in object

Re: [Firebird-devel] Introduction of EXTENDED TIME/TIMESTAMP WITH TIME ZONE?

2020-03-06 Thread Tony Whyman
This is all post Beta 1 stuff. When will there be a Beta 2 release incorporating EXTENDED TIME(STAMP) WITH TIME ZONE? On 06/03/2020 09:48, Alex Peshkoff via Firebird-devel wrote: On 2020-03-06 12:43, Mark Rotteveel wrote: I'll grudgingly implement support in Jaybird by handling it identical

Re: [Firebird-devel] PGP keys, software security, and much more threatened by new SHA1 exploit

2020-01-10 Thread Tony Whyman
Hence why I reported http://tracker.firebirdsql.org/browse/CORE-5788 and why SRP256 has been available from Firebird 3.0.4 onwards. On 09/01/2020 17:25, marius adrian popa wrote:

Re: [Firebird-devel] Introduction of EXTENDED TIME/TIMESTAMP WITH TIME ZONE?

2020-03-11 Thread Tony Whyman
On 10/03/2020 10:34, Dimitry Sibiryakov wrote: 10.03.2020 09:48, Alex Peshkoff via Firebird-devel wrote: May be for old windows versions - yes, some problems. All the others upgrade ICU as a part of regular OS upgrade. I.e. if one already has local ICU extended format is definitely useless

Re: [Firebird-devel] Introduction of EXTENDED TIME/TIMESTAMP WITH TIME ZONE?

2020-03-09 Thread Tony Whyman
On 04/03/2020 17:16, Alex Peshkoff via Firebird-devel wrote: On 2020-03-04 20:01, Mark Rotteveel wrote: What is the purpose of introducing yet another datatype called EXTENDED TIME/TIMESTAMP WITH TIME ZONE? Help users missing ICU on the client work with time zones. I am still trying to

[Firebird-devel] Installing the ICU Files under Windows

2020-04-28 Thread Tony Whyman
I have noticed that the FB4 snapshot builds for Windows include the icu files icudt52.dll, etc. They probably should not be installed for Windows 10 Version 1703 (Creators Update) onwards. Does the Windows installer make such a check and only install the icu files for older versions of

Re: [Firebird-devel] Installing the ICU Files under Windows

2020-04-28 Thread Tony Whyman
On 28/04/2020 14:47, Mark Rotteveel wrote: On 28-04-2020 15:43, Tony Whyman wrote: Apologies. I forgot to mention that I was worrying about using the ICU for the time zone database rather than character sets. Why does that worry you? Mark Because my understanding is that the ICU

Re: [Firebird-devel] Installing the ICU Files under Windows

2020-04-28 Thread Tony Whyman
On 28/04/2020 14:22, Adriano dos Santos Fernandes wrote: I advise not to do that same thing in Windows as done in Linux, using the OS ICU. In Linux situation is less complex, it's a server OS. I also think it was an incorrect thing started without notice by the distro people. So is the ICU

Re: [Firebird-devel] Installing the ICU Files under Windows

2020-04-28 Thread Tony Whyman
On 28/04/2020 14:22, Adriano dos Santos Fernandes wrote: Databases (indexes) depends on ICU being the same (same sort key version) or they need to be backed-up and restored (with gbak) to be fully functional. That surprises me, as I thought that a TIMESTAMP WITH TIME ZONE was stored as a GMT

Re: [Firebird-devel] Installing the ICU Files under Windows

2020-04-28 Thread Tony Whyman
Apologies. I forgot to mention that I was worrying about using the ICU for the time zone database rather than character sets. On 28/04/2020 14:39, Mark Rotteveel wrote: On 28-04-2020 15:28, Tony Whyman wrote: On 28/04/2020 14:22, Adriano dos Santos Fernandes wrote: Databases (indexes

Re: [Firebird-devel] Installing the ICU Files under Windows

2020-04-28 Thread Tony Whyman
On 28/04/2020 15:11, Adriano dos Santos Fernandes wrote: On 28/04/2020 11:05, Tony Whyman wrote: On 28/04/2020 14:59, Adriano dos Santos Fernandes wrote: https://github.com/FirebirdSQL/firebird/blob/master/doc/sql.extensions/README.time_zone.md#updating-the-time-zone-database This text

Re: [Firebird-devel] Installing the ICU Files under Windows

2020-04-28 Thread Tony Whyman
On 28/04/2020 14:59, Adriano dos Santos Fernandes wrote: https://github.com/FirebirdSQL/firebird/blob/master/doc/sql.extensions/README.time_zone.md#updating-the-time-zone-database This text applies to building firebird. I am worrying about the end user's strategy. My point is that there

Re: [Firebird-devel] Installing the ICU Files under Windows

2020-04-28 Thread Tony Whyman
So, I guess this has been added since beta 1. I can see it in the latest Windows snapshot, but not in the latest Linux snapshot. So the README should make clear that the tzdata directory only applies to the Windows builds? Back to my original concern. While the README file gives an outline

Re: [Firebird-devel] FB 3 & 4, new API and the ARRAY type

2020-04-22 Thread Tony Whyman
Well, it comes as news to me that the array type is unsupported in the new API. IBX supports the array type with the new FB3 api and it all seems to work fine. The example demos work with both Firebird 2.5 and Firebird 3.0.To do this, I had to reverse engineer the FB 2.5 code in order to

[Firebird-devel] Firebird API Incompleteness

2020-04-22 Thread Tony Whyman
While on the subject of incompleteness in the Firebird 3 API, I never found any alternative to the following utility functions from the legacy API. isc_sqlcode isc_sql_interprete isc_interprete isc_event_counts isc_event_block isc_free This is not a big deal as these are all local functions

Re: [Firebird-devel] ICU File Deployment Guidance

2020-04-29 Thread Tony Whyman
On 29/04/2020 13:59, Adriano dos Santos Fernandes wrote: There probably should thus be a firebird-tzdata package as part of the set of (deb/rpm) Firebird packages containing the latest tzdata files. It should then be easy enough for the package maintainer to roll out updates to the time zone

[Firebird-devel] FB4 linux snapshot build appears to be broken

2020-04-30 Thread Tony Whyman
All I get when trying to use the current snapshot and opening a database is the error message "Invalid Clumplet buffer structure: path length doesn't match with clumplet". I am using a test program that works with all previous versions of Firebird. If I try to use ISQL with the example

[Firebird-devel] SET BIND OF TIME ZONE TO EXTENDED and Data Input

2020-04-30 Thread Tony Whyman
In the README.time_zone, the SET BIND OF TIME ZONE TO EXTENDED is described as being intended to "solve a problem of representing correct time on clients missing ICU library". All the text I can find, discusses how this is used when reading a TIMESTAMP WITH TIME ZONE data type from a

Re: [Firebird-devel] ICU File Deployment Guidance

2020-04-29 Thread Tony Whyman
On 29/04/2020 13:22, Adriano dos Santos Fernandes wrote: This has nothing to do with ICU. There is no ICU tz data package in Ubuntu. The data is with the libicu package inside the libraries. OK. That seems to be supported by the ICU documentation. There probably should thus be a

Re: [Firebird-devel] ICU File Deployment Guidance

2020-04-29 Thread Tony Whyman
On 29/04/2020 13:27, Adriano dos Santos Fernandes wrote: On 29/04/2020 08:37, Paul Reeves wrote: On Wed, 29 Apr 2020 11:59:43 +0100 Tony Whyman wrote: Hopefully, an installer package will eventually be made available to automate the process. However, the above manual procedure is all

Re: [Firebird-devel] ICU File Deployment Guidance

2020-04-29 Thread Tony Whyman
On 29/04/2020 12:12, Adriano dos Santos Fernandes wrote: In Linux (Ubuntu as least) and probably MacOS, the ICU time zone database is not maintained updated in an Ubuntu release. I guess even if they rebuild and update the library, it still comes with the original tz database. So the process of

[Firebird-devel] ICU File Deployment Guidance

2020-04-29 Thread Tony Whyman
Many thanks to those who responded yesterday to my question on ICU library file installation under Windows. I am in the process of updating the IBX User Manual to include the Firebird 4 extensions and this question arose when updating the deployment guidelines. Specifically, giving IBX users

[Firebird-devel] Investigating Array types and Firebird 4

2020-05-12 Thread Tony Whyman
I have been investigating how the current development snapshot works with arrays and the new Firebird 4 data types. So far, the I have the following results: 1. DECFLOAT(16): works fine. Able to declare an array (e.g. Float16 DecFloat(16) [0:16]), write to array elements, save the row and

Re: [Firebird-devel] FB4 linux snapshot build appears to be broken

2020-05-08 Thread Tony Whyman
 /opt/firebird4b2/plugins/libChaCha.so: undefined symbol: chacha_setup On 08/05/2020 13:54, Alex Peshkoff via Firebird-devel wrote: On 2020-05-08 15:43, Tony Whyman wrote: Finally got round to working out why there was a problem. If I change the Wirecrypt setting in firebird.conf

Re: [Firebird-devel] FB4 linux snapshot build appears to be broken

2020-05-08 Thread Tony Whyman
On 08/05/2020 14:07, Alex Peshkoff via Firebird-devel wrote: On 2020-05-08 16:00, Tony Whyman wrote:  /opt/firebird4b2/plugins/libChaCha.so: undefined symbol: chacha_setup On 08/05/2020 13:54, Alex Peshkoff via Firebird-devel wrote: On 2020-05-08 15:43, Tony Whyman wrote: Finally got round

Re: [Firebird-devel] FB4 linux snapshot build appears to be broken

2020-05-08 Thread Tony Whyman
Panic over. I had libtomcrypt0 installed and masquerading as libtomcrypt1. Correct version now installed and FB4 snapshot working. On 08/05/2020 14:16, Tony Whyman wrote: On 08/05/2020 14:07, Alex Peshkoff via Firebird-devel wrote: On 2020-05-08 16:00, Tony Whyman wrote:  /opt/firebird4b2

Re: [Firebird-devel] FB4 linux snapshot build appears to be broken

2020-05-08 Thread Tony Whyman
ia Firebird-devel wrote: On 2020-04-30 12:10, Tony Whyman wrote: All I get when trying to use the current snapshot and opening a database is the error message "Invalid Clumplet buffer structure: path length doesn't match with clumplet". I am using a test program that works with all

Re: [Firebird-devel] Usage of 2020-01-01 as date for some of the time with time zone conversions

2020-05-18 Thread Tony Whyman
I have also been having problems with the use of the TIME WITH TIME ZONE type and have been holding back on posting on the issue until I came up with a suitable proposal. I wrote down my thoughts on the issue a few weeks ago and have appended them to the end of this EMail - at the time of

[Firebird-devel] IUtile API Version numbering

2020-03-19 Thread Tony Whyman
I have been paying attention recently to the VERSION number for the IUtil API, and I can't see the logic behind the version numbering scheme. I am looking at the Firebird.pas file. In Firebird 3, I see "const VERSION = 13;" In Firebird 4 Beta 1, I see "const VERSION = 21;" In the most recent

Re: [Firebird-devel] IUtile API Version numbering

2020-03-19 Thread Tony Whyman
See http://tracker.firebirdsql.org/browse/CORE-6207 On 19/03/2020 15:27, Norbert Saint Georges wrote: for information, the differential from yesterday's "firebird.pas" 139c139,140 < ISC_USHORT = word; { 16 bit unsigned } --- ISC_USHORT = word;    { 16 bit unsigned } ISC_SHORT

Re: [Firebird-devel] IUtile API Version numbering

2020-03-19 Thread Tony Whyman
Yes, the "missing types" problem was fixed earlier today.  ISC_TIMESTAMP_TZ_EX  ISC_SHORT  ISC_TIME_TZ_EX were all missing from Firebird.pas. It should now compile correctly. On 19/03/2020 15:38, Norbert Saint Georges wrote: Tony Whyman a écrit : See http://tracker.firebirdsql.

Re: [Firebird-devel] OO API examples for Object Pascal

2020-08-18 Thread Tony Whyman
of these issues. You will probably end up concentrating on opening an example database using a basic DPB and reading/writing a limited set of data types. Regards Tony Whyman MWA On 17/08/2020 16:25, Paul Reeves wrote: I thought I would port the OO API examples to Object Pascal. After all, they

[Firebird-devel] Does Firebird 4 Beta 2 really need libncurses6?

2020-05-29 Thread Tony Whyman
Just tried to check out Beta 2 on Linux Mint 19.3 (= ubuntu bionic 18.04) and found that the binaries have been compiled to use libncurses6. Ubuntu 18.04 uses libncurses5. You need ubuntu 19.10 if you don't want to go through the bother of backporting libncurses6. By contrast the most recent

Re: [Firebird-devel] Does Firebird 4 Beta 2 really need libncurses6?

2020-05-29 Thread Tony Whyman
On 29/05/2020 14:33, Alex Peshkoff via Firebird-devel wrote: On 29.05.2020 16:22, Tony Whyman wrote: Just tried to check out Beta 2 on Linux Mint 19.3 (= ubuntu bionic 18.04) and found that the binaries have been compiled to use libncurses6. Ubuntu 18.04 uses libncurses5. You need ubuntu 19.10

Re: [Firebird-devel] Crazy about time/timestamp with timezone

2020-07-08 Thread Tony Whyman
On 08/07/2020 14:00, Pavel Cisar wrote: TIME WITH TIMEZONE is pointless. It sort off works for "naive" TZ that does not have things like summer time and other time shifts based on date. The pytz library does not even allow you to create time with such tz. The dateutil does, but the usability

Re: [Firebird-devel] FB 4, iUtil and new interface in general

2020-06-16 Thread Tony Whyman
On 15/06/2020 15:37, Alex Peshkoff via Firebird-devel wrote: On 2020-06-11 18:30, Tony Whyman wrote: On 11/06/2020 11:18, Pavel Cisar wrote: This is not a problem for languages like Python, Java and .NET that don't use these files at all, but C++ & Pascal are still important languages an

Re: [Firebird-devel] FB 4, iUtil and new interface in general

2020-06-11 Thread Tony Whyman
clear scheme for version numbering as consistent version numbers are really important when it comes to backwards compatibility. Tony Whyman MWA Software Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Jaybird Srp authentication issue

2020-12-04 Thread Tony Whyman
On 04/12/2020 16:03, Dimitry Sibiryakov wrote: 04.12.2020 16:20, Mark Rotteveel wrote: After closer inspection, I found the issue. The SHA-1 hash of DAVIDS is 00AD377F8297F04FD83DFDBF48AABF316850862F. Seeing that leading zero, I guessed that might be part of the problem. After stripping the

Re: [Firebird-devel] Jaybird Srp authentication issue

2020-12-04 Thread Tony Whyman
On 04/12/2020 14:55, Adriano dos Santos Fernandes wrote: On 04/12/2020 11:48, Mark Rotteveel wrote: This behaviour is a security issue, it leaks existence or non-existence of the user. Is it a security issue in any website that if I try to create an account and it says the user already

Re: [Firebird-devel] Jaybird Srp authentication issue

2020-12-04 Thread Tony Whyman
Is this a character case problem? A quick look at the Firebird SRP code suggests that the username/password hash is generated using the actual character string without any transformation to all upper case. On 04/12/2020 13:38, Mark Rotteveel wrote: A bug was reported today against Jaybird

Re: [Firebird-devel] Usage of 32b version of Firebird

2021-02-02 Thread Tony Whyman
There is an important point sitting here for support of legacy applications. While a standalone x86 Firebird Server is likely to be of increasingly little interest, an x86 client library may need to be supported for much longer. This then gives rise to the question: what about the embedded

Re: [Firebird-devel] Interface versions

2021-02-17 Thread Tony Whyman
Hi! We previously decided that we does not need to maintain API compatibility within mistakes done in alpha/beta versions. So interfaces does not need to be versioned between unstable releases. Well, you may not need to maintain API compatibility, but there does need to be a clear and

[Firebird-devel] The IBatch Interface and Buffer Overflow

2021-08-20 Thread Tony Whyman
suggestions are welcome. I believe that a solution is necessary because you cannot use IBatch for any large scale use without knowing what you need to do to recover from a buffer overflow error without losing user data. Tony Whyman MWA Firebird-Devel mailing list, web interface at https

Re: [Firebird-devel] The IBatch Interface and Buffer Overflow

2021-08-23 Thread Tony Whyman
On 23/08/2021 13:03, Alex Peshkoff via Firebird-devel wrote: The minor bug is that if TAG_BUFFER_BYTES_SIZE is set to > 256MB no error status is reported on a call to createBatch. Instead, you only know you have a problem when an error is returned from IBatch::add - looks like the buffer size

Re: [Firebird-devel] The IBatch Interface and Buffer Overflow

2021-08-21 Thread Tony Whyman
On 20/08/2021 16:18, Alex Peshkoff via Firebird-devel wrote: On 8/20/21 4:01 PM, Tony Whyman wrote: You can specify such limit - use IBatch::TAG_BUFFER_BYTES_SIZE parameter in batch parameters block when creating a batch, default is 16Mb, hard limit - 256Mb. Ywo such buffers

Re: [Firebird-devel] The IBatch Interface and Buffer Overflow

2021-08-21 Thread Tony Whyman
ted on a call to createBatch. Instead, you only know you have a problem when an error is returned from IBatch::add - looks like the buffer size is simply limited to 256MB. On 21/08/2021 12:35, Tony Whyman wrote: On 20/08/2021 16:18, Alex Peshkoff via Firebird-devel wrote: On 8/20/21 4:01 PM, Tony Whyman

Re: [Firebird-devel] Firebird 5 and Update...Returning

2021-11-26 Thread Tony Whyman
On 26/11/2021 14:16, Dimitry Sibiryakov wrote: Tony Whyman wrote 26.11.2021 15:10: This caused an error message to be generated because only a singleton row was expected and not a cursor. Well, all I can say is that "existing connectivity drivers do not support this feature automagi

  1   2   >