Re: [Firebird-devel] IPluginModule::doClean() call point

2021-07-14 Thread Alex Peshkoff via Firebird-devel
On 7/14/21 2:13 PM, Dimitry Sibiryakov wrote: 14.07.2021 13:06, Alex Peshkoff via Firebird-devel wrote: Without a kind of UnloadDetector in your plugin PluginManager is not aware that your plugin was unloaded on exit(). But if all that chain was called from fb_shutdown() it does not matter

Re: [Firebird-devel] IPluginModule::doClean() call point

2021-07-14 Thread Alex Peshkoff via Firebird-devel
On 7/14/21 12:38 PM, Dimitry Sibiryakov wrote: 14.07.2021 11:27, Alex Peshkoff via Firebird-devel wrote:   I'll do a couple more experiments to determine if the problem is with thread races or library unloading order by OS because I suspect that on exit they are unloaded in reverse order

Re: [Firebird-devel] IPluginModule::doClean() call point

2021-07-14 Thread Alex Peshkoff via Firebird-devel
On 7/14/21 12:19 PM, Dimitry Sibiryakov wrote: 14.07.2021 10:51, Alex Peshkoff via Firebird-devel wrote: What does hex value mean?   "this". Used to identify source object for the line.   I'll do a couple more experiments to determine if the problem is with thread races or library

Re: [Firebird-devel] IPluginModule::doClean() call point

2021-07-14 Thread Alex Peshkoff via Firebird-devel
On 7/13/21 7:22 PM, Dimitry Sibiryakov wrote: 13.07.2021 17:48, Alex Peshkoff via Firebird-devel wrote: - your process called exit() and due to it plugin is going to be unloaded, this fact is detected by dtor of UnloadDetectorHelper, which also calls doClean, but in this case some globals may

Re: [Firebird-devel] IPluginModule::doClean() call point

2021-07-13 Thread Alex Peshkoff via Firebird-devel
On 7/13/21 6:32 PM, Dimitry Sibiryakov wrote: Hello All.   Is doClean() supposed to be guaranteed to be called before plugin library unloading process?   For Firebird 4 (current snapshot) in embedded I see that it is called after some global variables of the library are already destructed,

Re: [Firebird-devel] Ubuntu Firebird built from sources uninstall

2021-07-07 Thread Alex Peshkoff via Firebird-devel
On 7/7/21 6:40 PM, Dimitry Sibiryakov wrote: Hello All.   If I installed into Ubuntu 18.04 Firebird built from sources using "make install", how to uninstall it correctly? Is there script FirebirdUninstall.sh? Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] 64 bit arm buildx/qemu issues for docker

2021-07-07 Thread Alex Peshkoff via Firebird-devel
On 7/7/21 10:40 AM, marius adrian popa wrote: Seems that there are still issues with ubuntu 20.04 on arm64 https://github.com/jacobalberty/firebird-docker/issues/67#issuecomment-875220239 I've updated libtool

Re: [Firebird-devel] Response to op_accept_data

2021-07-07 Thread Alex Peshkoff via Firebird-devel
On 7/6/21 3:43 PM, Jiří Činčura wrote: I would almost say, I'll remove it then. :) But fbclient is sending it too, so I'll probably stick with tried and true behavior. Yes, certainly it should stay in place. (It's present since fb 1.0, and I have no idea who used network opcode in wrong way

Re: [Firebird-devel] Response to op_accept_data

2021-07-06 Thread Alex Peshkoff via Firebird-devel
On 7/6/21 2:23 PM, Mark Rotteveel wrote: On 2021-07-06 12:12, Alex Peshkoff via Firebird-devel wrote: Not understand your question. 4 packets were sent: 1. op_connect 2. op_attach 3. op_cont_auth 4. op_cont_auth What is op_connect + op_attach? The op_connect packet has a secondary op_attach

Re: [Firebird-devel] Response to op_accept_data

2021-07-06 Thread Alex Peshkoff via Firebird-devel
On 7/6/21 12:44 PM, Jiří Činčura wrote: Made config match yours. During connect/auth/attach fbclient send 4 packets to server: op_connect, op_attach, op_cont_auth: (gdb) print packet->p_auth_cont $7 = {p_data = {cstr_length = 256, cstr_allocated = 0, cstr_address = 0x77accd90

Re: [Firebird-devel] Response to op_accept_data

2021-07-06 Thread Alex Peshkoff via Firebird-devel
On 7/6/21 12:20 PM, Jiří Činčura wrote: data from plugin to server, net op is op_cont_auth. That's the case for WireCrypt != Disabled. Else it just continues to op_attach and the rest of the auth is done there. Made config match yours. During connect/auth/attach fbclient send 4 packets to

Re: [Firebird-devel] Response to op_accept_data

2021-07-06 Thread Alex Peshkoff via Firebird-devel
On 7/6/21 12:22 PM, Jiří Činčura wrote: And be not able to connect to default FB3? FB3 has Srp256 included starting something like 3.0.4, no? Supports - but not active in default config. Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Response to op_accept_data

2021-07-06 Thread Alex Peshkoff via Firebird-devel
On 7/6/21 12:13 PM, Jiří Činčura wrote: Or maybe I'll just support Srp256 only and ignore Srp forever. :D And be not able to connect to default FB3? Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Response to op_accept_data

2021-07-06 Thread Alex Peshkoff via Firebird-devel
On 7/6/21 8:45 AM, Jiří Činčura wrote: This is the order of operations. Compression is disabled. FB3 server has only Srp and Win_Sspi enabled, WireCrypt is Enabled. op_connect + op_attach CNCT_user, ... CNCT_host, ... CNCT_user_verification, CNCT_login, ... CNCT_plugin_name,

Re: [Firebird-devel] Response to op_accept_data

2021-07-05 Thread Alex Peshkoff via Firebird-devel
On 7/5/21 7:17 PM, Jiří Činčura wrote: unavailable database What's the setting of WireCrypt on the server? For a mode you check it should be Enabled or Disabled, not Required default. For Required you get quite correct error. (sorry, sooner of all will next answer only tomorrow)

Re: [Firebird-devel] Response to op_accept_data

2021-07-05 Thread Alex Peshkoff via Firebird-devel
On 7/5/21 6:30 PM, Jiří Činčura wrote: next - attach(create) database or attach service You mean op_attach? Like again? Because that was sent in the first place (op_connect + op_attach). I have not known that's non-default client config. Certainly, no need to repeat op_attach. You just

Re: [Firebird-devel] Response to op_accept_data

2021-07-05 Thread Alex Peshkoff via Firebird-devel
On 7/5/21 6:28 PM, Jiří Činčura wrote: What's the expected response to server from client after client receives op_accept_data? It's a weird combination I'm doing and something is missing from my implementation here. Client: Srp256, Srp WireCrypt: Disabled CNCT_specific_data sent for

Re: [Firebird-devel] Response to op_accept_data

2021-07-05 Thread Alex Peshkoff via Firebird-devel
On 7/5/21 5:55 PM, Jiří Činčura wrote: HI, What's the expected response to server from client after client receives op_accept_data? if needed - initialize channel compression, next - attach(create) database or attach service Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Multiple CNCT_specific_data

2021-07-05 Thread Alex Peshkoff via Firebird-devel
On 7/5/21 4:18 PM, Jiří Činčura wrote: Never tried and doubt that would work. Does not work on my side. Hence, I take that as that it doesn't work. I suppose the extra op_cont_auth round-trip is going to be needed in case the first auth plugin is not matched. You must also send

Re: [Firebird-devel] Multiple CNCT_specific_data

2021-07-05 Thread Alex Peshkoff via Firebird-devel
On 7/5/21 2:27 PM, Jiří Činčura wrote: Hi, Is it possible to sent multiple CNCT_specific_data, basically for each CNCT_plugin_name right away (saving roundtrip)? Never tried and doubt that would work. Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] FB4.0: Operating system call access failed. Error code 20

2021-07-01 Thread Alex Peshkoff via Firebird-devel
On 7/1/21 4:27 PM, Pro Turm wrote: If you use UID/GID in docker with same number as firebird group in host, probably you will not have problem. No, I dont set/use anything explicitly in the docker regarding UID/GID. If docker is using install script for linux distro, different

Re: [Firebird-devel] FB4.0: Operating system call access failed. Error code 20

2021-06-30 Thread Alex Peshkoff via Firebird-devel
Jun 28 11:07 fb_rename_guard/ Am Mi., 30. Juni 2021 um 10:40 Uhr schrieb Alex Peshkoff via Firebird-devel <mailto:firebird-devel@lists.sourceforge.net>>: On 6/30/21 11:21 AM, Pro Turm wrote: > Hi, > Does anyone know the reason for the following? > > /

Re: [Firebird-devel] FB4.0: Operating system call access failed. Error code 20

2021-06-30 Thread Alex Peshkoff via Firebird-devel
On 6/30/21 11:21 AM, Pro Turm wrote: Hi, Does anyone know the reason for the following? /Operating system call access failed. Error code 20/ / / /ConfigStorage: Cannot initialize the shared memory region         operating system directive access failed         Not a directory/ / /

Re: [Firebird-devel] Authentication error connection shutdown

2021-06-07 Thread Alex Peshkoff via Firebird-devel
On 6/6/21 7:39 PM, Jiří Činčura wrote: Hi *, What the error "Authentication error connection shutdown" in firebird.log means? May be something gone wrong with sec-db attachments cache. Can you please check - if you wait a minute or 2 w/o restart will it help? Sometimes this happens after

Re: [Firebird-devel] IBlob::putSegment

2021-06-03 Thread Alex Peshkoff via Firebird-devel
On 6/2/21 11:06 PM, Vlad Khorsun wrote: 02.06.2021 20:39, Jiří Činčura wrote:   IXpbBuilder* pb = utl->getXpbBuilder(, IXpbBuilder::BPB, NULL, 0); Looks like FB3 does not have BPB (https://github.com/FirebirdSQL/firebird/blob/R3_0_7/src/include/firebird/IdlFbInterfaces.h#L3827).

Re: [Firebird-devel] CALL statement

2021-06-01 Thread Alex Peshkoff via Firebird-devel
On 6/1/21 12:51 PM, Dimitry Sibiryakov wrote: 31.05.2021 21:21, Adriano dos Santos Fernandes wrote: [ | ( ) ] [ RETURNING_VALUES |    RETURNING_VALUES ( ) |   RETURNING [ INTO ]  ] This does not support ignore all output in DSQL.   There can be syntax "RETURNING

Re: [Firebird-devel] CALL statement

2021-06-01 Thread Alex Peshkoff via Firebird-devel
On 5/31/21 10:21 PM, Adriano dos Santos Fernandes wrote: As the second, unrelated change, shorten EXECUTE PROCEDURE/STATEMENT/what-else OBJECT to EXEC OBJECT and decide about object type from context - provided it will not raise the hell in btyacc. I do not understood what you mean. Now:

Re: [Firebird-devel] CALL statement

2021-05-31 Thread Alex Peshkoff via Firebird-devel
On 5/31/21 4:19 PM, Adriano dos Santos Fernandes wrote: Hi! EXECUTE PROCEDURE is full of weirdness... May be keep old syntax and add some new, not related with SQL-standard CALL: EXECUTE PROCEDURE [ . ]     [ | ( ) ]     [ RETURNING_VALUES |   RETURNING_VALUES ( ) |       RETURNING

Re: [Firebird-devel] IBlob::putSegment

2021-05-27 Thread Alex Peshkoff via Firebird-devel
On 5/27/21 4:34 PM, Jiří Činčura wrote: a) user stream (not segmented) blobs Is there some docs for that? What I found in "Using_OO_API.html" is just "Last two parameters are required only if you want to use blob filters or use stream blob, that's out of scope here.". That parameters are

Re: [Firebird-devel] IBlob::putSegment

2021-05-27 Thread Alex Peshkoff via Firebird-devel
On 5/27/21 12:13 PM, Jiří Činčura wrote: Hi, Is there a sweet spot for the buffer size/length when using IBlob::putSegment? a) user stream (not segmented) blobs b) use bigger buffers Or is it fine to put even 1 byte segments? It depends upon goals:) May be recommended as an efficient way

Re: [Firebird-devel] Increasing CHAR/VARCHAR max. length to 64KB

2021-05-24 Thread Alex Peshkoff via Firebird-devel
On 5/22/21 12:03 AM, Adriano dos Santos Fernandes wrote: On 21/05/2021 17:53, Alex Peshkoff via Firebird-devel wrote: On 5/21/21 9:19 PM, Adriano dos Santos Fernandes wrote: And if we do change SQLDA_VERSION it's worth changing something else in it. For example - make all sizes uint32, add

Re: [Firebird-devel] Fwd: FB4 RC installation errors ?

2021-05-24 Thread Alex Peshkoff via Firebird-devel
There were some fixed issues with tomcrypt & linux install. Can you try with current snapshot http://web.firebirdsql.org/download/snapshot_builds/linux/fb4.0/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Increasing CHAR/VARCHAR max. length to 64KB

2021-05-21 Thread Alex Peshkoff via Firebird-devel
On 5/21/21 9:19 PM, Adriano dos Santos Fernandes wrote: And if we do change SQLDA_VERSION it's worth changing something else in it. For example - make all sizes uint32, add separate field for charset, may be something else? My aim is to increase CHAR/VARCHAR lengths. I think there is no real

Re: [Firebird-devel] Increasing CHAR/VARCHAR max. length to 64KB

2021-05-21 Thread Alex Peshkoff via Firebird-devel
On 5/21/21 9:06 PM, Mark Rotteveel wrote: On 2021-05-21 16:51, Alex Peshkoff via Firebird-devel wrote: We have one more unused value for size - zero, we do not support characters with length == 0. We may store logical data length - 1, this will make it possible to have exactly 64Kb fields

Re: [Firebird-devel] Increasing CHAR/VARCHAR max. length to 64KB

2021-05-21 Thread Alex Peshkoff via Firebird-devel
On 5/21/21 3:49 PM, Adriano dos Santos Fernandes wrote: On 21/05/2021 08:33, Dimitry Sibiryakov wrote: 21.05.2021 09:38, Alex Peshkoff via Firebird-devel wrote: Any idea how to avoid that?   Redeclare it as unsigned right now. Yes. But would be very bad to see not recompiled programs just

Re: [Firebird-devel] Increasing CHAR/VARCHAR max. length to 64KB

2021-05-21 Thread Alex Peshkoff via Firebird-devel
On 5/20/21 5:32 PM, Adriano dos Santos Fernandes wrote: Hi! Currently max. CHAR length is limited to 32767 and max. VARCHAR to 32765. I didn't found any blocker prevent raising that limits to 65535 and 65533 respectively. Even not going into details agraid I see one serious problem - ISC API

Re: [Firebird-devel] Deprecations

2021-05-19 Thread Alex Peshkoff via Firebird-devel
On 5/19/21 12:42 AM, Adriano dos Santos Fernandes wrote: Hi! UDF was been deprecated in FB 4. Could we remove them from master for v5? Doubt that. UDF is too actively used feature, lot of users will not be happy. Also QLI, I believe nobody uses it and there should be no good reason to

Re: [Firebird-devel] fb 5.0.0.40 ?

2021-05-18 Thread Alex Peshkoff via Firebird-devel
On 5/18/21 3:57 PM, Norbert Saint Georges wrote: Hello, I just compiled Firebird via git and he pulls me out the version Firebird 5.0.0.40-Initial.amd64 . Normal? Yes. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Numeric literals and INT128 (including numeric types) vs DECFLOAT

2021-05-13 Thread Alex Peshkoff via Firebird-devel
On 5/13/21 3:47 PM, Mark Rotteveel wrote: I'm in the process of writing the Firebird 4.0 Language Reference, and I'm noticing some odd things with numeric literals and INT128 (including numeric types) and DECFLOAT. 2. Exact numeric literals with 30 or more digits are handled as

Re: [Firebird-devel] Examples of RSA_SIGN and RSA_VERIFY in the release notes

2021-05-11 Thread Alex Peshkoff via Firebird-devel
On 5/11/21 6:41 PM, Mark Rotteveel wrote: On 11-05-2021 17:33, Alex Peshkoff via Firebird-devel wrote: On 5/11/21 6:24 PM, Mark Rotteveel wrote: And I repeat: given RSA_SIGN has a HASH parameter, and applies PSS, I assume it hashes the message using the supplied (or default) hash algorithm

Re: [Firebird-devel] Examples of RSA_SIGN and RSA_VERIFY in the release notes

2021-05-11 Thread Alex Peshkoff via Firebird-devel
On 5/11/21 6:31 PM, Dimitry Sibiryakov wrote: 11.05.2021 17:26, Alex Peshkoff via Firebird-devel wrote: To be precise - signature is a decrypted hash of a message, verify means encrypt it bak - and get same hash.  To be more precise verify is comparison of a hash of the message

Re: [Firebird-devel] Examples of RSA_SIGN and RSA_VERIFY in the release notes

2021-05-11 Thread Alex Peshkoff via Firebird-devel
On 5/11/21 6:24 PM, Mark Rotteveel wrote: And I repeat: given RSA_SIGN has a HASH parameter, and applies PSS, I assume it hashes the message using the supplied (or default) hash algorithm, and then signs the resulting hash. Having to hash this yourself makes no sense to me. It _might_ be

Re: [Firebird-devel] Examples of RSA_SIGN and RSA_VERIFY in the release notes

2021-05-11 Thread Alex Peshkoff via Firebird-devel
On 5/11/21 6:18 PM, Dimitry Sibiryakov wrote: 11.05.2021 17:13, Alex Peshkoff via Firebird-devel wrote: Stop-stop. You are mixing crypt and hash in single mix.  No, I don't. I just know what a "signature" is. All of sudden it is an encrypted hash of the message (and some inte

Re: [Firebird-devel] Examples of RSA_SIGN and RSA_VERIFY in the release notes

2021-05-11 Thread Alex Peshkoff via Firebird-devel
On 5/11/21 5:54 PM, Dimitry Sibiryakov wrote: 11.05.2021 16:38, Alex Peshkoff via Firebird-devel wrote: In tomcrypt rsa_sign_hash() signs message digests (hashes)  Because it is supposed to have hash on input (and this fact is reflected in its name). Tomcrypt is low-level library and its

Re: [Firebird-devel] Examples of RSA_SIGN and RSA_VERIFY in the release notes

2021-05-11 Thread Alex Peshkoff via Firebird-devel
On 5/11/21 3:49 PM, Dimitry Sibiryakov wrote: 11.05.2021 14:39, Mark Rotteveel wrote: On 2021-05-11 11:51, Alex Peshkoff via Firebird-devel wrote: That may work only for very short (like in a sample) 'Test message'- for real-size messages hash is used for signing. rsa_sign just would not work

Re: [Firebird-devel] Sizing of RSA_PRIVATE and RSA_PUBLIC

2021-05-11 Thread Alex Peshkoff via Firebird-devel
On 5/11/21 3:36 PM, Mark Rotteveel wrote: On 2021-05-11 11:44, Alex Peshkoff via Firebird-devel wrote: On 5/10/21 12:48 PM, Mark Rotteveel wrote: How was the maximum size of the result of RSA_PRIVATE and RSA_PUBLIC determined? To have solid reserve. A reserve of a factor 3+ for private

Re: [Firebird-devel] Examples of RSA_SIGN and RSA_VERIFY in the release notes

2021-05-11 Thread Alex Peshkoff via Firebird-devel
On 5/10/21 2:02 PM, Mark Rotteveel wrote: The example for RSA_SIGN in the release notes is: ``` select rdb$set_context('USER_SESSION', 'msg',  rsa_sign(crypt_hash('Test message' using sha256)    key rdb$get_context('USER_SESSION', 'private_key'))) from rdb$database; ``` The use of

Re: [Firebird-devel] Sizing of RSA_PRIVATE and RSA_PUBLIC

2021-05-11 Thread Alex Peshkoff via Firebird-devel
On 5/10/21 12:48 PM, Mark Rotteveel wrote: How was the maximum size of the result of RSA_PRIVATE and RSA_PUBLIC determined? To have solid reserve. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] DefaultTimeZone config

2021-05-11 Thread Alex Peshkoff via Firebird-devel
On 5/9/21 8:20 PM, Adriano dos Santos Fernandes wrote: On 07/05/2021 12:23, Alex Peshkoff via Firebird-devel wrote: On 5/6/21 9:23 PM, Adriano dos Santos Fernandes wrote: What I want to ask about if it's clear/good is that DefaultTimeZone set in client does not implicitly pass

Re: [Firebird-devel] Values of RDB$ROLES.RDB$SYSTEM_PRIVILEGES

2021-05-08 Thread Alex Peshkoff via Firebird-devel
On 5/8/21 3:10 PM, Mark Rotteveel wrote: On 08-05-2021 13:55, Mark Rotteveel wrote: Where can I find the values of RDB$ROLES.RDB$SYSTEM_PRIVILEGES. I assume it's a bitset, so which bits map to which privilege? After some experimentation, it looks like the bit positions map to the RDB$TYPE

Re: [Firebird-devel] Linux installer and system library directory

2021-05-08 Thread Alex Peshkoff via Firebird-devel
Does all that mean that we have problems finding a directory where to create soft link to fbclient? If yes - do you have suggestion how to find that (primary lib) directory better? If yes - why not just fix installer? Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] DefaultTimeZone config

2021-05-07 Thread Alex Peshkoff via Firebird-devel
On 5/6/21 9:23 PM, Adriano dos Santos Fernandes wrote: What I want to ask about if it's clear/good is that DefaultTimeZone set in client does not implicitly pass isc_dpb_session_time_zone in the attachment. For me such behavior looks suspicious (i.e. a bug to be precise). DefaultTimeZone set

Re: [Firebird-devel] Plugin release delay

2021-05-04 Thread Alex Peshkoff via Firebird-devel
On 5/4/21 6:25 PM, Dimitry Sibiryakov wrote:  Hello All.  Is it safe to set subj to infinity or server may misbehave? Never tried - but at the first glance do not see any problems. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Plugin used by trace session

2021-05-03 Thread Alex Peshkoff via Firebird-devel
On 5/3/21 7:08 PM, Dimitry Sibiryakov wrote:  Hello All.  In description of isc_action_svc_trace_start I see no way to set trace plugin used for this session. Does it mean that "there can be only one"? On my mind that means that services API should be expanded here. Firebird-Devel

Re: [Firebird-devel] Dispatcher release point

2021-04-22 Thread Alex Peshkoff via Firebird-devel
On 4/22/21 6:22 PM, Dimitry Sibiryakov wrote:  Hello All.  In all examples interface got from getDispatcher() is kept until end of program. I wonder if it is correct to release it right after attachDatabase() call or something may crash? Never tried but see no problems with releasing it

Re: [Firebird-devel] Charset of plugin configuration parameters

2021-04-19 Thread Alex Peshkoff via Firebird-devel
On 4/19/21 6:59 PM, Dimitry Sibiryakov wrote: 19.04.2021 17:52, Alex Peshkoff via Firebird-devel wrote: Telling true I doubt that separating ANSI from UTF8 is actual - noone (well, almost noone) will use utf8 on windows or ANSI on linux. What may be interesting (and does cause troubles

Re: [Firebird-devel] Charset of plugin configuration parameters

2021-04-19 Thread Alex Peshkoff via Firebird-devel
On 4/19/21 6:43 PM, Dimitry Sibiryakov wrote:  In my own recent config parsers I separate ANSI files from UTF-8 files by BOM and handle them accordingly but I use Unicode for internal processing which Firebird doesn't. Telling true I doubt that separating ANSI from UTF8 is actual - noone

Re: [Firebird-devel] Charset of plugin configuration parameters

2021-04-19 Thread Alex Peshkoff via Firebird-devel
On 4/15/21 8:30 PM, Dimitry Sibiryakov wrote: 15.04.2021 18:28, Alex Peshkoff via Firebird-devel wrote: It transfers data from config file 'as is', I suppose that matches charset none.  If parameter's value is a connection string or an user name it would cause troubles for using them

Re: [Firebird-devel] travis-ci.org => travis-ci.com

2021-04-16 Thread Alex Peshkoff via Firebird-devel
On 16.04.2021 17:23, Mark Rotteveel wrote: https://github.com/FirebirdSQL/firebird currently uses travis-ci.org for the build, but this must be migrated to travis-ci.com, as travis-ci.org will shutdown soon. See also https://docs.travis-ci.com/user/migrate/open-source-repository-migration

Re: [Firebird-devel] Memory manager cleanup / external libraries

2021-04-15 Thread Alex Peshkoff via Firebird-devel
On 4/15/21 8:21 PM, Adriano dos Santos Fernandes wrote: Can you send me full test (or patch)? I want ot test on Android. Attached test. Here is results (init.cpp is showed many times because it's included in many libraries): Same result on android: eneric_arm64:/data/firebird #

Re: [Firebird-devel] Memory manager cleanup / external libraries

2021-04-15 Thread Alex Peshkoff via Firebird-devel
On 4/15/21 8:27 PM, Dimitry Sibiryakov wrote: 15.04.2021 19:21, Adriano dos Santos Fernandes wrote: CtorDtorDebug::CtorDtorDebug - utl.cpp 6000 CtorDtorDebug::CtorDtorDebug - init.cpp 6000 CtorDtorDebug::CtorDtorDebug - init.cpp 5000 CtorDtorDebug::CtorDtorDebug - init.cpp 5400  This piece

Re: [Firebird-devel] Charset of plugin configuration parameters

2021-04-15 Thread Alex Peshkoff via Firebird-devel
On 4/15/21 6:49 PM, Dimitry Sibiryakov wrote:  Hello All.  Is there a way to know the charset of a string returned by IConfigEntry::getValue()? It transfers data from config file 'as is', I suppose that matches charset none. Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Memory manager cleanup / external libraries

2021-04-15 Thread Alex Peshkoff via Firebird-devel
On 4/15/21 2:33 PM, Adriano dos Santos Fernandes wrote: I have tested with common/classes/init.cpp and this solved the specific problem I had with Boost.Test: Cleanup global __attribute__ ((init_priority (2000))); As far as I can see from documentation init_priority works only inside simgle

Re: [Firebird-devel] Memory manager cleanup / external libraries

2021-04-15 Thread Alex Peshkoff via Firebird-devel
On 4/14/21 8:25 PM, Adriano dos Santos Fernandes wrote: Hi! C++ guarantees the execution order of constructors only inside the same translation unit (say, a .cpp file) for global objects. It also guarantees inverse order of destructors in relation to constructors order. But constructor order

Re: [Firebird-devel] Help appreciated about BlobId

2021-04-06 Thread Alex Peshkoff via Firebird-devel
On 4/6/21 4:25 PM, Bert Herngreen via Firebird-devel wrote: Hi, I do understand that this is not a NOT a user support forum, however I hope to find some support by being pointed out in a direction by you devs about the IB and FB file format. I have an Interbase XE3 database with 'Blob not

Re: [Firebird-devel] Fix mingw build

2021-04-02 Thread Alex Peshkoff via Firebird-devel
On 4/2/21 6:09 PM, Dimitry Sibiryakov wrote: 02.04.2021 15:19, Biswapriyo Nath wrote: How can I fix the build?   In short - you cannot. It is my experience as a mingw build maintaner before 15 years. Not sure long term, may Dimitry is right. I did not support that build. What about this

Re: [Firebird-devel] Reason for isc_nothing_to_cancel

2021-03-23 Thread Alex Peshkoff via Firebird-devel
On 3/23/21 5:37 PM, Jiří Činčura wrote: Hi, I found small difference in behavior regarding cancellation (fb_cancel_raise). When working over the wire I can send cancellation whenever I want it is "just fine". But doing the same when using Embedded results in isc_nothing_to_cancel being

Re: [Firebird-devel] RDB$USER_PRIVILEGES of 4.0

2021-03-04 Thread Alex Peshkoff via Firebird-devel
On 3/4/21 1:00 PM, Gabor Boros wrote: Hi All, In ISQL with a brand new 4.0 database: SQL> select distinct rdb$user, rdb$user_type from rdb$user_privileges where rdb$user not in ('SYSDBA','PUBLIC') order by rdb$user; RDB$USER    RDB$USER_TYPE = 22    20 3  

Re: [Firebird-devel] fb_cancel_raise for prepare

2021-03-04 Thread Alex Peshkoff via Firebird-devel
On 3/4/21 11:47 AM, Jiří Činčura wrote: Hi *, does fb_cancel_raise cancel also currently running prepare (op_prepare_statement)? Yes, it should. It's able to cancel any operation except attach/detach. But must say never used to test it explicitly. Firebird-Devel mailing list, web

Re: [Firebird-devel] Interface versions

2021-02-17 Thread Alex Peshkoff via Firebird-devel
On 2/17/21 8:15 PM, Dimitry Sibiryakov wrote: 17.02.2021 18:06, Tony Whyman wrote: For Firebird 4 RC1, the version number gets reset to 4   Only as a bugfix for wrong Pascal files generation. Just to be explicit - later you may rely on a fact that next version will be >4.

Re: [Firebird-devel] Interface versions

2021-02-17 Thread Alex Peshkoff via Firebird-devel
On 2/17/21 6:33 PM, Adriano dos Santos Fernandes wrote: 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. So it does not make sense to me to have

Re: [Firebird-devel] Effect of positioning the cursor beyond the result set with ABSOLUTE

2021-02-15 Thread Alex Peshkoff via Firebird-devel
On 2/15/21 7:39 PM, Mark Rotteveel wrote: On 15-02-2021 16:21, Alex Peshkoff via Firebird-devel wrote: On 2/14/21 4:01 PM, Mark Rotteveel wrote: For documentation purposes, I was wondering if this was intended behaviour, both the ability to position beyond the bounds of the result set using

Re: [Firebird-devel] Effect of positioning the cursor beyond the result set with ABSOLUTE

2021-02-15 Thread Alex Peshkoff via Firebird-devel
On 2/14/21 4:01 PM, Mark Rotteveel wrote: For documentation purposes, I was wondering if this was intended behaviour, both the ability to position beyond the bounds of the result set using ABSOLUTE, and the remembering of the actual position for subsequent fetches. Or if this is just an

Re: [Firebird-devel] What does SET TRUSTED ROLE do?

2021-02-09 Thread Alex Peshkoff via Firebird-devel
On 2/9/21 6:23 PM, Mark Rotteveel wrote: CREATE MAPPING WIN_ADMINS   USING PLUGIN WIN_SSPI   FROM Predefined_Group DOMAIN_ANY_RID_ADMINS   TO ROLE RDB$ADMIN ``` While SET AUTO ADMIN MAPPING will apply RDB$ADMIN automatically if no explicit role is specified on connect. In other words, does

Re: [Firebird-devel] What does SET TRUSTED ROLE do?

2021-02-09 Thread Alex Peshkoff via Firebird-devel
On 2/9/21 7:01 PM, Mark Rotteveel wrote: On 09-02-2021 16:23, Mark Rotteveel wrote: In other words, does my confusion derive from the fact the Firebird 3 release notes say that CREATE MAPPING ... TO ROLE ... updates the CURRENT_ROLE, while in fact it does no such thing? Having done some

Re: [Firebird-devel] What does SET TRUSTED ROLE do?

2021-02-09 Thread Alex Peshkoff via Firebird-devel
On 2/9/21 5:42 PM, Mark Rotteveel wrote: I'm working on the Firebird 3 Language Reference, and I'm currently writing documentation for SET TRUSTED ROLE. I have tried reading the Firebird 3 release notes, and a Google-translated version of the Russian Firebird 3 Language Reference, but the

Re: [Firebird-devel] Firebird 4, new int128 problem

2021-02-08 Thread Alex Peshkoff via Firebird-devel
On 2/8/21 5:44 PM, Lucas Schatz wrote: Hi, I'm beginning my tests with Fb4 RC1, successfully converted my database, but I'm having problems with the new int128 data type, where my component access doesn't support it yet, is it possible to disable somehow INT128,DECFLOAT(16) DECFLOAT(34) #

Re: [Firebird-devel] blr 31 & 30

2021-02-04 Thread Alex Peshkoff via Firebird-devel
On 2/4/21 7:29 PM, Mark Rotteveel wrote: On 2021-02-04 15:55, Norbert Saint Georges wrote: Mark Rotteveel a écrit : On 2021-02-04 09:39, Norbert Saint Georges wrote: yes, this is what I found but there is no definition RDB $ FIELD_TYPE = 30 or 31 in rdb $ types in FB4, what is it for? The

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

2021-02-02 Thread Alex Peshkoff via Firebird-devel
On 2/2/21 3:33 PM, Jiří Činčura wrote: Yes, good point :) Onli some new feature need new client. But It is rather rare, but happen as e.g compression as i remember. Basically whenever a new protocol version is created. Not all features make sense for old apps. What sense in having statement

Re: [Firebird-devel] Producing isc_arg_warning

2021-02-02 Thread Alex Peshkoff via Firebird-devel
On 2/2/21 1:59 PM, Jiří Činčura wrote: Hi *, what action should I do to get isc_arg_warning? Revoke non-existing grant. In employee: SQL> revoke EXECUTE ON PROCEDURE ADD_EMP_PROJ from john; Warning: EXECUTE on ADD_EMP_PROJ is not granted to JOHN. Firebird-Devel mailing list, web

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

2021-02-02 Thread Alex Peshkoff via Firebird-devel
On 2/2/21 12:16 PM, Paul Reeves wrote: On Tue, 2 Feb 2021 11:32:42 +0300 Alex Peshkoff via Firebird-devel wrote: On 2/1/21 10:24 PM, marius adrian popa wrote: My guess old cpus or installs Example got laptop with Windows 10 32 that is still supported by > Microsoft also have an old lap

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

2021-02-02 Thread Alex Peshkoff via Firebird-devel
On 2/1/21 10:24 PM, marius adrian popa wrote: My guess old cpus or installs Example got laptop with Windows 10 32 that is still supported by Microsoft also have an old laptop with Ubuntu 32bit also another old raspberry pi that is 32 bit only I doubt all that list is worth having _new_

Re: [Firebird-devel] Restore service with stdin parameter

2021-02-01 Thread Alex Peshkoff via Firebird-devel
On 2/1/21 8:03 PM, Dimitry Sibiryakov wrote: Hello, All.   Server used to request from client 262144 bytes. There were plans to expand limits in INFO calls (something like new DPB version, but for INFO calls). That's why bigger buffer is transfered. Does in means that data buffer for

Re: [Firebird-devel] Blob filters and UDF deprecation

2021-01-31 Thread Alex Peshkoff via Firebird-devel
On 1/31/21 4:03 PM, Mark Rotteveel wrote: For me this is primarily academic curiosity, I don't actually use blob filters myself. That's definite reason why blob filters were not given much attention. Next: Ok, but deprecation of UDF implies the eventual removal of UDF related code. I do

Re: [Firebird-devel] ODP: Blob filters and UDF deprecation

2021-01-31 Thread Alex Peshkoff via Firebird-devel
On 1/31/21 8:23 PM, Karol Bieniaszewski wrote: As Udf’s are depricated, are somwhere all current udfs rewriten in udr form? I mean about fbudf.dll and ib_udf.dll and with source code to look at it as a sample for self written „udr_udf” ? See misc/upgrade/udf in linux distro. Sorry, do

Re: [Firebird-devel] RDB$CONFIG.RDB$CONFIG_NAME datatype

2021-01-20 Thread Alex Peshkoff via Firebird-devel
On 1/20/21 3:41 PM, Vlad Khorsun wrote: Hi, all   I'll speak about new table RDB$CONFIG introduced with implementation of CORE-3708.   The field RDB$CONFIG_NAME has datatype defined as VARCHAR(63) CHARACTER SET UTF8. The original reasons behind this choice was: - UTF8 as charset for most

Re: [Firebird-devel] ibase.h vs interface.h

2021-01-08 Thread Alex Peshkoff via Firebird-devel
On 1/7/21 8:25 PM, Scott Morgan via Firebird-devel wrote: Just looking for some clarification: When writing c and C++ apps, what is the recommended API? For new projects - definitely API in interface.h. Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] fbclient.dll 4.0.0.2308 can't connect to FB2.5

2020-12-30 Thread Alex Peshkoff via Firebird-devel
On 12/30/20 5:28 PM, Ivan Přenosil wrote: I tested the latest snapshot Firebird-4.0.0.2308 (both 32 and 64) and it can't connect to FB2.5 database, the error is   Statement failed, SQLSTATE = 28000   Your user name and password are not defined. Ask your database administrator to set up a

Re: [Firebird-devel] How to build for Android 64 bit

2020-12-11 Thread Alex Peshkoff via Firebird-devel
On 12/11/20 9:17 PM, marius adrian popa wrote: Hello Alex , For android i see that firebird 3.0.7 builds ok (there are arm binaries on firebirdsql) What ndk do you recommend? I've used r10d - for FB3 it's ok, not for FB4. Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] IStatus::setErrors() to "no errors"

2020-12-09 Thread Alex Peshkoff via Firebird-devel
On 12/9/20 2:31 PM, Dimitry Sibiryakov wrote: 09.12.2020 12:23, Alex Peshkoff via Firebird-devel wrote: That depends upon getState() internals, is not it? :)   Yes. Firebird implementation recognizes zero error code in getState() so I wonder if it is a specs' requirement or such recognition

Re: [Firebird-devel] Errors vector lifetime

2020-12-09 Thread Alex Peshkoff via Firebird-devel
On 12/9/20 2:28 PM, Dimitry Sibiryakov wrote: 09.12.2020 12:21, Alex Peshkoff via Firebird-devel wrote:   During such self assignment returned pointer can be invalidated by setErrors() code before using input parameter which may cause crash or wrong result. Builtin implementation works

Re: [Firebird-devel] IStatus::setErrors() to "no errors"

2020-12-09 Thread Alex Peshkoff via Firebird-devel
On 12/8/20 8:20 PM, Dimitry Sibiryakov wrote: 08.12.2020 17:36, Alex Peshkoff via Firebird-devel wrote:   Should a custom implementation of IStatus recognize and ignore a special case when GDS error code is set to zero using parameter ( isc_arg_gds, 0, isc_arg_end } or error with zero code

Re: [Firebird-devel] Errors vector lifetime

2020-12-09 Thread Alex Peshkoff via Firebird-devel
On 12/9/20 2:03 PM, Dimitry Sibiryakov wrote: 18.11.2020 17:49, Dimitry Sibiryakov wrote:    How long pointer returned from IStatus::getErrors() is supposed to be valid?   I think I found a weird case. In Y-valve there is code like this:   status.setErrors(status.getErrors());   During such

Re: [Firebird-devel] IStatus::setErrors() to "no errors"

2020-12-08 Thread Alex Peshkoff via Firebird-devel
On 12/8/20 6:55 PM, Dimitry Sibiryakov wrote: Hello All.   Should a custom implementation of IStatus recognize and ignore a special case when GDS error code is set to zero using parameter ( isc_arg_gds, 0, isc_arg_end } or error with zero code is also an error? From IStatus POV - also an

Re: [Firebird-devel] Jaybird Srp authentication issue

2020-12-04 Thread Alex Peshkoff via Firebird-devel
On 12/4/20 4:38 PM, Mark Rotteveel wrote: A bug was reported today against Jaybird (http://tracker.firebirdsql.org/browse/JDBC-635), that certain Srp users cannot authenticate against Firebird 3 when using Jaybird. The issue is not reproducible with fbclient. This obviously means that there

Re: [Firebird-devel] Reserving a new error code facility

2020-11-27 Thread Alex Peshkoff via Firebird-devel
On 11/26/20 10:46 PM, Mark Rotteveel wrote: I'm currently writing a driver for the R2DBC specification (a new Java specification for reactive database drivers). Is it OK if I reserve a new facility code for R2DBC driver errors (similar like I did in the past for Jaybird)? OK for me.

Re: [Firebird-devel] Builds with USE_VALGRIND fail

2020-11-26 Thread Alex Peshkoff via Firebird-devel
On 11/26/20 12:05 PM, Alex Peshkoff via Firebird-devel wrote: Useally we do not log DEV_BUILD problems (first of all not to confuse users I think), I will take a look what's wrong. fixed Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird

Re: [Firebird-devel] Builds with USE_VALGRIND fail

2020-11-26 Thread Alex Peshkoff via Firebird-devel
On 11/26/20 11:15 AM, Paul Reeves wrote: When I build HEAD with --enable-developer and -DUSE_VALGRIND I get these errors: alloc.cpp:2182:79: error: invalid conversion from ‘size_t (*)(size_t) {aka long unsigned int (*)(long unsigned int)}’ to ‘unsigned int’ [-fpermissive] common.h:772:51:

Re: [Firebird-devel] use applications with new firebird server

2020-11-24 Thread Alex Peshkoff via Firebird-devel
On 11/24/20 5:13 PM, Ismael L. Donis Garcia wrote: Are those adjustments documented somewhere? Yes, mostly in FB3 release notes - there is no big difference between FB3 & 4 from this POV. But read also about backwards compatibility in FB4 release notes too. Firebird-Devel mailing list,

Re: [Firebird-devel] IStatus::setErrors2() and malformed input

2020-11-20 Thread Alex Peshkoff via Firebird-devel
On 11/20/20 6:35 PM, Dimitry Sibiryakov wrote: Hello All.   What setErrors2() is supposed to do on malformed input? For example if received length of input buffer is mistakenly small and the last isc_arg_xxx missing its value. setErrors2() is should trust passed arguments, it's added for

<    1   2   3   4   5   6   7   8   9   10   >