Alex,
something interesting. After I've put the message for op_fetch into
output stream, I also added, just as I'm trying to bisect it, 1k of 0s
at the end (and these will be compressed). Then not only the
op_fetch_response code came, but also the rest of the response.
--
Mgr. Jiří Činčura
> Searching for an open server's window and sending it WM_CLOSE could be
> easier ;-)
How do I know which server I just started? There might be multiple on
different ports (which I actually use, for testing).
--
Mgr. Jiří Činčura
Independent IT Spec
it. But it's a
.NET app, obviously. Not sure you can run it, as I know you're on Linux.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/li
quot;select first(1) JOB_REQUIREMENT from JOB where
JOB_REQUIREMENT is not null;" works as well. I think it needs to be
binary blob of some size.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Firebird-Devel m
e"
works fine. Isn't that kind of weird?
--
Mgr. Jiří Činčura
Independent IT Specialist
On Sun, Aug 21, 2016, at 15:35, Jiří Činčura wrote:
> Maybe surprisingly, when the blob I'm trying to read is all zeros, the
> server responds in expected way. Random bytes make it all fall apart.
Maybe surprisingly, when the blob I'm trying to read is all zeros, the
server responds in expected way. Random bytes make it all fall apart.
I have a simple test app, that surfaces it. If some core devs would like
to have a look from the other side.
--
Mgr. Jiří Činčura
Independent
from server (I get the op_response), aka
flush went fine, server was able to process my request and it was
properly compressed. But why I get only the 4 bytes and nothing more to
get complete response?
I'm running x64 3.0.0.32483.
--
Mgr. Jiří Činčura
Independent IT Specialist
Hi *,
if I start firebird using "firebird.exe -a", is there a way to stop it?
In a scripted way.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Firebird-Devel mailing list, web interface
> yes, till the end of 'firebird' process
I'm testing mostly on SS. I'll try CS and let's see. I want to be sure
my cleanup routines are fine.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
What NetFlow Analyzer
By "engine" you mean server?
--
Mgr. Jiří Činčura
Independent IT Specialist
On Mon, Jul 18, 2016, at 14:15, Alex Peshkoff wrote:
> On 07/13/2016 11:38 AM, Jiří Činčura wrote:
> > I've let it sit idle, with no connections whatsoever, for 5
> > minutes and
> &g
Ahh, bummer. Thanks.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps
; >::cloopreleaseDispatcher(Firebird::IReferenceCounted* self).
After that the counter stays on 1 and I never see the release and hence
the cleanup etc.
What can I check now?
--
Mgr. Jiří Činčura
Independent IT Specialist
--
What
never goes to fetch next row. It goes immediately into dispose.
It doesn't matter whether it's timestamp as result type or i.e. int.
If I add some dummy input parameter then it's suddenly fine. Why is
that?
--
Mgr. Jiří Činčura
Independent IT Specialist
handled by a timer?
--
Mgr. Jiří Činčura
Independent IT Specialist
--
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and proto
return 0;
}
return 1;
}
`getOwner` and `setOwner` are storing and returning whatever was passed.
No logic there.
Something obviously wrong here?
--
Mgr. Jiří Činčura
Independe
Hi *,
can I force Firebird to unload an external engine plugin? Or when it
happens automatically?
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San
IMESTAMP? Just asking, because that
would make my code easier as well.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San
Francisco, CA to explore cuttin
::makeProcedure? Before
Procedure::open is called?
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San
Francisco, CA to explore cutting-edge tech
> You'd better change the message metadata with the help of the builder
> from char to varchar and so plugin and engine exchange correct lengths
> instead of let each part to calculate it for multibyte charsets.
Why? I'm getting the length from metadata, I don't have to compute it.
--
Hi *,
should I pad char values to defined length in external engine plugin?
Currently I'm not doing it and server seems to be doing it for me, but
better to know for sure.
--
Mgr. Jiří Činčura
Independent IT Specialist
> Can it already attach to the caller's current transaction?
Not exactly, yet.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San
Francisco,
yield return Tuple.Create(i, s, @long, @short, @char);
yield return Tuple.Create(i + 1, s + nameof(Demo), @long + 1,
(short?)(@short + 1), @char);
}
--
Mgr. Jiří Činčura
Independent IT Specialist
--
ion(status, statusVector);
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San
Francisco, CA to explore cutting-edge tech and listen to tech luminaries
present th
>It follows SQL naming in part of storage in system tables, but working
>with config
> files has different rules.
Well, in pascal case in config it didn't work. But I don't think it
matters.
--
Mgr. Jiří Činčura
Independent IT S
I suppose it follows SQL naming scheme. I might try to quote it later
when I'm back.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San
Francisco
Ha! It needs to be in upper case in plugins.conf. Solved.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San
Francisco, CA to explore cutting-edge tech
Hi,
When I have a, say, procedure like:
create procedure foo
...
engine bar;
Is the "bar" always the filename (without extension)? Can it be somewhat
"renamed" in plugins.conf? And how is the defaultName in
registerPluginFactory method fits into that?
Thanks.
--
Mgr. Jiří
Thanks for confirmation.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San
Francisco, CA to explore cutting-edge tech and listen to tech luminaries
Hi *,
looking into memory dump for parameters in external engine in OO API is
{ 0xFF 0xFF } for true and anything else (basically 0) for false.
Correct?
Thanks.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Attend
>Oh, c'mon. Inability to read full object name from XSQLDA field
>doesn't mean to loose
> ability to access values.
True. In this case that wouldn't matter for me.
--
Mgr. Jiří Činčura
Independent IT S
example ability to
> access objects with names >31 symbol long.
OK, so I'm not going to go that path. Thanks for letting me know. It
might have been time wasted later.
--
Mgr. Jiří Činčura
Independent IT Specialist
---
0]: 50
[31]: 46
[32]: 53
[33]: 1
[34]: 0
...
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San
Francisco, CA to explore cutting-edg
OK, so it's expected. I was just confused by isc_info_isc_version having
just one.
I'll adjust it in the provider.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Attend Shape: An AT Tech Expo July 15-16. Meet us
/extensions, that I can call based on type from input/output
metadata.
Maybe I can convert the data to XSQLDA/XSQLVAR shape? For these I
already have routines to read/write it.
--
Mgr. Jiří Činčura
Independent IT Specialist
uld be the length of the message and following are the chars for
"WI-V3.0.0.32483 Firebird 3.0"
and so on.
Am I parsing it wrong?
2.5.5 behaves the same way.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
bird_version in
.NET provider needs to be adjusted. :)
Thanks.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San
Francisco, CA to explore cutting-edge tec
A lot of trying (and errors) and still nowhere near, I think. How one
uses the FB_MESSAGE with the void* inMsg (or void* outMsg) in i.e. here
https://github.com/FirebirdSQL/firebird/blob/master/src/include/firebird/FirebirdInterface.idl#L827
?
--
Mgr. Jiří Činčura
Independent IT Specialist
> There is FB_MESSAGE macro - look at sample 06.fb_message.cpp.
Wow. Amesome. Thanks.
And I have no idea what that does. Given my lack of knowledge of C++
magic, I'm completely confused. :) What happened to simple C code that
was the same last hundred years?
--
Mgr. Jiří Činčura
Independ
Can this be somewhat requested also by isc_info_firebird_version or
similar?
--
Mgr. Jiří Činčura
Independent IT Specialist
--
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns
/getNullOffset etc. or set using
memcpy, it seems to me I'm doing it too much raw work. I'm hoping maybe
something like "setXxx(outMsg, , )" or similar exists.
JC
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Wh
Ahh, looks like I found the problem. The DeflateStream in .NET is
producing really raw deflate, while Firebird want's the zlib header.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
What NetFlow Analyzer can do
OK, I'm successfully writing data to server for op_attach - checked on
network level.
Just "for fun" I tried to write uncompressed data, as it would without
compression. In that case the server closes connection with me during
writing of DPB for op_attach.
--
Mgr. Jiří Činčura
I
flag exists.
> Try to make sure std client does work with this server using compressed
> connection.
With the `WireCompression = true` I can connect using isql. So I suppose
it should work. I don't see any flag in MON$ATTACHMENTS to see whether
it really used compression.
--
Mgr. Jiří Č
nually flush the
output data to the server, the server closes the connection with me. So
I think the data might not be in format that server expects.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
What NetFlow Analyzer ca
Done; CORE-5278.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols
> passed to the
> engine as isc_dpb_host_name.
Does it make sense to send both then?
--
Mgr. Jiří Činčura
Independent IT Specialist
--
What NetFlow Analyzer can do for you? Monitors network bandwidth and t
Hi *,
just out of curiosity what the relation between for example
isc_dpb_host_name and CNCT_host?
--
Mgr. Jiří Činčura
Independent IT Specialist
--
What NetFlow Analyzer can do for you? Monitors network bandwidth
> Sorry, the bug was another with SELECT FROM PROCEDURE.
Ahh, now it makes sense. It even works as expected on 3.0.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
What NetFlow Analyzer can do for you? Monit
> And behaves different 3.0, so obvious answer, it was a bug. ;)
On Firebird 3.0 I'm getting:
Statement failed, SQLSTATE = 42000
validation error for variable TEST, value "*** null ***"
-At procedure 'TEST' line: 6, col: 3
Basically the same. So maybe it is still a bug.
--
Mgr.
"*** null ***".
At procedure 'TEST' line: 6, col: 3.
I don't understand why... Why there's validation? The SUSPEND is never
called, so...
--
Mgr. Jiří Činčura
Independent IT Specialist
--
What NetFlow Analyzer can
> It's possible but not too convenient.
> *
> bin # ./fbsvcmgr service_mgr action_db_stats dbname employee
> sts_hdr_pages
Yeah. That's not good. Scraping it from text is not what I should
provide in library. May I create ticket to provide such API?
--
Mgr.
Hi *,
can I ask Service API to get me current shutdown/online mode of given
database? I know with isc_action_svc_properties I can set it. So I hope
there's also other way possible.
--
Mgr. Jiří Činčura
Independent IT Specialist
More info:
http://blog.cincura.net/233561-ado-net-provider-5-0-0-0-for-firebird-is-ready/
.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Mobile security can be enabling, not merely restricting. Employees who
bring
> PS: Theoretical limit of path on Windows is 32k unicode characters.
It's actually 32767. Maybe less, depending what `\\?\` resolves to.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Find and fix applicat
Hi,
the original issue here still remains. The last byte is never asked for.
I suppose Alex is not interested in fixing it so I probably need to find
some dirty workaround, right?
--
Mgr. Jiří Činčura
Independent IT Specialist
One can do something like:
git gc --prune=now --aggressive
git repack
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data
>There is few shutdown mode's. Default one is "multi-user maintenance"
> and it not prevents backup. If you need something non-default - specify
> it explicitly.
I used full shutdown mode. So the gbak not working is kind of expected.
--
Mgr. Jiří Činčura
Indepe
> but you may put db i shutdown before backup and it will be restored in
> the
> same mode.
I can't even backup database in shutdown mode.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Trans
Hi *,
Is there a SPB combination to restore database and keep it in shutdown?
Hence manually requiring to online it?
JC
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Transform Data into Opportunity.
Accelerate
> Sorry - cold not run it:
> Unhandled exception: unimplemented function msvcrt.dll._vscprintf
> called in 32-bit code (0x7bc4d059).
Hmm, the Wine is probably not that good to run it. I suppose you need
Windows machine or some VM.
--
Mgr. Jiří Činčura
Independent IT S
ly unpack and run `test.bat`. It expects Firebird running on
localhost. In case you need my config for Firebird, it's here
http://www.uschovna.cz/zasilka/HUC9BL4NBJ6WHX5I-JF2/ .
--
Mgr. Jiří Činčura
Independent IT S
> git push :branchname
Which is changed for couple of year already.
`git push --delete `
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Transform Data into Opportunity.
Accelerate data analysis in your applicati
> Confirmed.
Should I create tracker item?
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Libr
Nobody from core team?
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn
> is still out there for quick testing from console. Just out of curiosity
> -
> does fbsvcmgr work on your setup?
It does. But it's a different scenario. :(
--
Mgr. Jiří Činčura
Independent IT Specialist
--
I'm just not being asked for more bytes (the last
byte).
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceler
never happened to be only one byte left). I might
be sending isc_info_svc_line as hell, but what data to put in (if server
says 0)?
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Transform Data into Opportunity.
change between these two? Probably it's some lingering stuff
in my protocol implementation, but maybe I'm lucky with "just" change.
I'm still looking where I might be loosing some bytes or whatnot. Some
clues are welcome as well.
--
Mgr. Jiří Činčura
Independent IT
> NOT DISTINCT, don't you?
I swear I tried that before I sent the question. And it didn't work. Now
it works. Maybe I changed something in provider... Confused.
--
Mgr. Jiří Činčura
Independent IT Special
/commit/f8ca7c887c300f289f8a4675a630754c55be312b
[2]:
https://github.com/FirebirdSQL/core/commit/2455f8276e675549567963597bc46ba7573c621a
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Firebird-Devel mailing list, web
cond that. Firebird core developers never considered much how some
changes will impact drivers or how some features might be aligned to fit
other environments.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Site24x7 APM Insi
e math when taking any decision.
Just out of curiosity. Are these systems going to be upgraded to
Firebird 4?
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Site24x7 APM Insight: Get Deep Visibility into Applicati
Firebird 4, then you can still use those systems as
> clients, without encumbering the project.
Or if you really want to run on that platform, you can pay for it.
Simple as that.
Burning our resources on this is just not worth it, IMHO.
--
Mgr. Jiří
>No. And i see no reason to do it (except of old ugly hacks).
> Explain, please
Legacy code. Hardcoded filename to load for FB Embedded.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Site24x7 APM Insigh
Hi *,
is there a way to make fbclient.dll renamed to fbembed.dll work? Because
doing that results in 335545004 and 335545007.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Site24x7 APM Insight: Get Deep Visibility
s good. From time to time I take the file and I convert it to C#
flavor and use it. So eventually it will and up in my code as well.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Site24x7 APM Insight: Get Dee
for FB3?
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web tra
Hi *,
the username in Srp auth is expected to be in UTF8, right?
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor
>IIRC, nbackup can be called via services. Does it include -F?
That's what I'd like to have. But it looks like it doesn't.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Site24x7 APM Insight: Get Deep Visibil
> No.
So the only option left is modify the file manually? Which of course
only works if the file is accessible for .NET provider.
Is it worth adding it to tracker or is it something CORE is not going to
do?
--
Mgr. Jiří Činčura
Independent IT Special
API it's easier to program it.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Mo
Hi *,
is there a way to execute same stuff as `nbackup -F` i.e. via (running)
server? Something that I could call from .NET provider to offer this to
customers.
--
Mgr. Jiří Činčura
Independent IT Specialist
Hi *,
looking at
https://github.com/FirebirdSQL/core/blob/master/src/auth/SecureRemotePassword/srp.cpp#L14
and wondering how was this number selected? Is it a safe prime number
for SRP? Some might not be. Just wondering.
--
Mgr. Jiří Činčura
Independent IT Specialist
> To avoid confusions - we discussed it with Vlad.
So back again to two persons. ;)
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mob
Worth reading.
http://danluu.com/file-consistency/
--
Mgr. Jiří Činčura
Independent IT Specialist--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances
More info:
http://blog.cincura.net/233544-ado-net-provider-4-10-0-0-for-firebird-is-ready/
.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM
Hi *,
is there a way to create a trigger with UDF usage while the library
itself is currently missing?
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Firebird-Devel mailing list, web interface at
https
Hi *,
is there a way to create a trigger with UDF usage while the library
itself is currently missing?
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Firebird-Devel mailing list, web interface at
https
More info
http://blog.cincura.net/233539-ado-net-provider-4-9-0-0-for-firebird-is-ready/
.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net
On Sun, Dec 6, 2015, at 19:00, Leyne, Sean wrote:
> This seems worthy of a Tracker case, no?
I agree.
BTW given it's a set of tests for .NET provider it's extremely easy to
replicate. Something I can help you with to pinpoint the issue?
--
Mgr. Jiří Činčura
Independent IT Special
and executed. No
configuration whatsoever. Any idea what it might be?
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Go from Idea to Many App Stores Faster with Intel(R) XDK
Give your users amazing mobile app experiences
.
Not sure if it's correct (or where I found that information ;)).
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Go from Idea to Many App Stores Faster with Intel(R) XDK
Give your users amazing mobile app experiences with
On Wed, Nov 25, 2015, at 07:39, Jiří Činčura wrote:
> Not sure if it's correct (or where I found that information ;)).
Ha, looks like I was already there:
http://markmail.org/message/skkpcjl3wnnjzqfl.
--
Mgr. Jiří Činčura
Independent IT Special
IC/DECIMAL based on `scale`, but
the `subtype` has confusing value.
All fields in the query's expression are DECIMAL(18,4).
Thanks JC.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Go from Idea to Many App Sto
Hi *,
May I kindly ask why the firebird.conf/databases.conf uses XML-like format
(although it's not XML) but plugins.conf uses different one using curly braces
etc.?
--
Mgr. Jiří Činčura
Independent IT Specialist
I saw `` with some per database settings in
today's presentation on Firebird seminar in Prague. Not sure whether it
was Dmitry or Alexey. Kind of surprised me. :o
--
Mgr. Jiří Činčura
Independent IT Specialist
On Fri, Nov 13, 2015, at 17:06, Alex Peshkoff wrote:
> On 11/13/2015 06:58 PM, J
On Fri, Nov 13, 2015, at 17:51, Alex Peshkoff wrote:
> It's from trace config for FB 2.5. It's really XML-like. In FB3 all
> config files follow { } style.
Interesting. I was really sure it was databases.conf. Never mind. Thanks
for clarifying that up.
--
Mgr. Jiří Činčura
Indep
bly right. :)
What a shame the trace config structure was not changed in FB 3. :(
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo
More info
http://blog.cincura.net/233531-ado-net-provider-4-8-1-0-for-firebird-is-ready/.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net
g indexes manually after. So that should be covered.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
501 - 600 of 647 matches
Mail list logo