Re: [Firebird-devel] Elevation required on Win7?

2011-06-22 Thread Paul Reeves
user with basic permissions and placed all the required files in C:\Users\test\fbtest. After starting fbserver as an application this command: C:\Users\test\fbtestisql -u SYSDBA -p masterkey localhost:employee works fine for me. Paul -- Paul Reeves http://www.ibphoenix.com Specialists

Re: [Firebird-devel] Elevation required on Win7?

2011-06-22 Thread Paul Reeves
On Wednesday 22 June 2011 at 12:21 Paul Reeves wrote: this command: C:\Users\test\fbtestisql -u SYSDBA -p masterkey localhost:employee works fine for me. Oops, I spoke too soon. It worked alright while I had a user with admin rights logged in simultaneously with the test user. When

Re: [Firebird-devel] Elevation required on Win7?

2011-06-22 Thread Paul Reeves
are: - No installation of Firebird. Just copy the zip kit to a public directory. - Make sure that public dir is fully accessible to Everyone. Anyway, as I said before, I think this is a Win7 feature rather than a problem with Firebird. :-) Paul -- Paul Reeves http://www.ibphoenix.com Specialists

Re: [Firebird-devel] page i/o stats

2011-07-05 Thread Paul Reeves
was cumulative for all connections since the start of the server. Paul -- Paul Reeves http://www.ibphoenix.com Specialists in Firebird support -- All of the data generated in your IT infrastructure is seriously valuable. Why

Re: [Firebird-devel] page i/o stats

2011-07-05 Thread Paul Reeves
start before the commit so it cannot influence the perf.h io stats because they are recorded before the commit. GC cannot influence the attachment level mon$ io stats because it is a separate attachment. GC is not an issue here. Paul -- Paul Reeves http://www.ibphoenix.com Specialists

Re: [Firebird-devel] Performance of FW databases on ext4 filesystem

2011-08-29 Thread Paul Reeves
On Monday 29 August 2011 at 12:47 Adriano dos Santos Fernandes wrote: On 29/08/2011 06:27, Paul Reeves wrote: On Monday 29 August 2011 at 11:05 marius adrian popa wrote: you are not the only one that observed db/vm performance issues with ext4 maybe you need to mount it with data=writeback

Re: [Firebird-devel] Performance of FW databases on ext4 filesystem

2011-08-29 Thread Paul Reeves
or something is really clever we usually mean the opposite. This way we avoid actually saying that data=writeback is idiotic and the inventor of this was a moron. Although I have to say that the Torvalds quote made me laugh. Paul -- Paul Reeves http://www.ibphoenix.com Specialists in Firebird support

Re: [Firebird-devel] Performance of FW databases on ext4 filesystem

2011-08-29 Thread Paul Reeves
:-) Paul -- Paul Reeves http://www.ibphoenix.com Specialists in Firebird support -- EMC VNX: the world's simplest storage, starting under $10K The only unified storage solution that offers unified management Up to 160

Re: [Firebird-devel] news from kernel 3.1

2011-10-25 Thread Paul Reeves
. But for a database server? The problem is that the old behaviour was the wrong behaviour. Letting the hard drive re-order page writes completely negates the efforts firebird makes to ensure pages are written in the correct order. Paul -- Paul Reeves http://www.ibphoenix.com Specialists in Firebird

Re: [Firebird-devel] news from kernel 3.1

2011-10-25 Thread Paul Reeves
in order Is this wrong? What's then the advantage of (1), since it's much slower approach? AFAICT, fsync only gets called if FW=ON. Or have I missed something? Paul -- Paul Reeves http://www.ibphoenix.com Specialists in Firebird support

Re: [Firebird-devel] Initializing security database for first use

2011-12-20 Thread Paul Reeves
could be masterkey). If no password is provide then the installation would fail. Paul -- Paul Reeves http://www.ibphoenix.com Specialists in Firebird support -- Write once. Port to many. Get the SDK and tools to simplify

Re: [Firebird-devel] Initializing security database for first use

2011-12-21 Thread Paul Reeves
will not even know there is a command-line. Even then, one of the design goals of the installer is to install a fully working system from the installer itself. Paul -- Paul Reeves http://www.ibphoenix.com Specialists in Firebird support

Re: [Firebird-devel] Initializing security database for first use

2011-12-21 Thread Paul Reeves
. At the moment I would suspect a majority type masterkey because it is the documented default *and* it is a meaningful word. And there is probably a large minority who think they are being clever by only typing eight letters because they know the ninth letter is ignored. Paul -- Paul Reeves http

Re: [Firebird-devel] Fb3 and embedded

2012-06-06 Thread Paul Reeves
On Wednesday 06 Jun 2012 16:48:40 Alex Peshkoff wrote: On 06/06/12 14:43, Paul Reeves wrote: How does embedded work in FB3? I'm wondering because make_examples.bat fails unless fb3 is running. It would be nice to build the employee database using the newly built engine but I can't see

Re: [Firebird-devel] Fb3 and embedded

2012-06-06 Thread Paul Reeves
is that fbembed.dll doesn't exist in Fb 3.0 :-) But that reminded me about Alex's earlier comment - engine12.dll is needed but is not being found,even though the path is set. Paul -- Paul Reeves http://www.ibphoenix.com Specialists in Firebird support

Re: [Firebird-devel] Fb3 and embedded

2012-06-06 Thread Paul Reeves
On Wednesday 06 Jun 2012 16:21:25 Paul Reeves wrote: But that reminded me about Alex's earlier comment - engine12.dll is needed but is not being found,even though the path is set. So, to summarize, I've got empbuild.exe to work by copying fbclient.dll to the empbuild dir, creating

Re: [Firebird-devel] Fb3 and embedded

2012-06-06 Thread Paul Reeves
On Wednesday 06 Jun 2012 17:18:19 Paul Reeves wrote: However, if the files are copied as I mentioned above it all works. (Ie, empbuild.exe builds empbuild.fdb.) Whoops, I meant to write empbuild.exe builds employee.fdb. empbuild.fdb already exists. Paul -- Paul Reeves http

Re: [Firebird-devel] Fb3 and embedded

2012-06-07 Thread Paul Reeves
it to the batch file and test more thoroughly. Thanks, Alex. Paul -- Paul Reeves http://www.ibphoenix.com Specialists in Firebird support -- Live Security Virtual Conference Exclusive live event will cover all the ways

Re: [Firebird-devel] Fb3 and embedded

2012-06-07 Thread Paul Reeves
was not necessary. But at least for now I can get on fixing the packaging for Fb 3 on windows. Paul -- Paul Reeves http://www.ibphoenix.com Specialists in Firebird support -- Live Security Virtual Conference Exclusive

Re: [Firebird-devel] Conversion of CVS to Subversion

2012-07-15 Thread Paul Reeves
, which was not obvious at the beginning. Overall I haven't yet found a compelling need to move my local code from cvs, but if I did I think I would look at git before svn. Interesting that you prefer hg over git. Maybe I should have a look at that someday. Paul -- Paul Reeves http

Re: [Firebird-devel] Restore improvements?

2012-09-11 Thread Paul Reeves
it to 10240? 75 is way too low. I'm not even sure it makes sense as a default for classic these days if server is 64 bit. Paul -- Paul Reeves http://www.ibphoenix.com Specialists in Firebird support-- Live Security Virtual

Re: [Firebird-devel] Firebird 3, time to rename conflict names ?

2012-11-17 Thread Paul Reeves
command completion. Paul -- Paul Reeves http://www.ibphoenix.com Specialists in Firebird support-- Monitor your physical, virtual and cloud infrastructure from a single web console. Get in-depth insight into apps, servers

Re: [Firebird-devel] Firebird should listen on localhost only (secure by default)

2013-03-13 Thread Paul Reeves
the same way from start sudo cat /etc/mysql/my.cnf | grep 127.0.0.1 bind-address = 127.0.0.1 ps: by default firebird in debian/ubuntu is listening on *.gds_db What is the problem that this solves? Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird

Re: [Firebird-devel] Firebird new release is needed

2013-03-14 Thread Paul Reeves
! It can't be allowed - if nothing else firebird stands for prudent version numbering. We must resist this temptation - look where it got firefox. :-) Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird

Re: [Firebird-devel] (Double) Metaphone?

2013-03-30 Thread Paul Reeves
of loading the function according to the character set, otherwise it is limited to data stored in the latin alphabet. But the principal is good. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird

Re: [Firebird-devel] gsec-issues with FB3.0

2013-07-04 Thread Paul Reeves
that error recently. I was trying to access gsec before I had added SYSDBA. Once SYSDBA was added and I managed to login correctly as SYSDBA (not easy) the message went away. Presumably you have set AuthServer correctly? And restarted the server perhaps? Paul -- Paul Reeves http://www.ibphoenix.com

Re: [Firebird-devel] gsec-issues with FB3.0

2013-07-15 Thread Paul Reeves
or not. Users are not against change, they just like to do it at their own pace. Hopefully the feedback we get during alpha/beta will help us make the right decision. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird

Re: [Firebird-devel] gsec-issues with FB3.0

2013-07-17 Thread Paul Reeves
On Tuesday 16 July 2013 15:17:49 Alex Peshkoff wrote: On 07/15/13 18:19, Paul Reeves wrote: One problem I found is that I couldn't log in to an FB3 server on windows from a linux fb2.5 client. How is that done without the legacy authentication? No way. From any client 3.0 from any OS

[Firebird-devel] make packages and rpms

2013-10-21 Thread Paul Reeves
got any ideas? Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird -- October Webinars: Code for Performance Free Intel webinars can help you accelerate application performance. Explore tips for MPI

Re: [Firebird-devel] make packages and rpms

2013-10-21 Thread Paul Reeves
/fb25_private/firebird2/gen/RPM/BUILDROOT/FirebirdCS-2.5.2.26541-0.x86_64 ie, it deletes the directory and re-creates it. so I guess I need to dig around in the %install script. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird

Re: [Firebird-devel] isc_spb_sts_table tag

2013-12-18 Thread Paul Reeves
for more details: http://tracker.firebirdsql.org/browse/CORE-4298 Alex knows what I'm talking about, which is how he discovered that the isc_spb_sts_table is broken. So those info_ tags *should* work. (imo.) Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird

Re: [Firebird-devel] isc_spb_sts_table tag

2013-12-18 Thread Paul Reeves
action_get_fb_log but it ought to. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird -- Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture

Re: [Firebird-devel] isc_spb_sts_table tag

2013-12-18 Thread Paul Reeves
work, what is broken, and what is not meant to work so that it can be documented (and fixed, where relevant.) And also to provide some more examples. fbsvcmgr is quite neat - but it isn't well documented and working out how to use it requires a lot of trial and error. Paul -- Paul Reeves http

[Firebird-devel] fb3 access modes under windows

2014-01-29 Thread Paul Reeves
FB3 on Windows? AFAICT it is not possible. I don't mind - SuperClassic seems to share the worst features of SuperServer and ClassicServer, and we should officially deprecate in FB3 (imo.) But the questions will be asked - how can we run SC under FB3? and does it make any sense? Paul -- Paul

Re: [Firebird-devel] fb3 access modes under windows

2014-01-29 Thread Paul Reeves
with shared access # truefalse - ? # truefalse * Super with exclusive access # truetrue- Super with shared access - illegal in A2 :-) # truetrue* Super with shared access - also illegal Paul -- Paul Reeves http

Re: [Firebird-devel] fb3 access modes under windows

2014-01-29 Thread Paul Reeves
On Wednesday 29 January 2014 17:20:16 Dmitry Yemanov wrote: 29.01.2014 18:37, Paul Reeves wrote: I guess what we really need is to document in firebird.conf how the -m switch affects the other two settings. There would seem to be a total of eight combinations. Lack of -m switch along

Re: [Firebird-devel] fb3 access modes under windows

2014-01-30 Thread Paul Reeves
On Thursday 30 January 2014 09:56:50 Dmitry Yemanov wrote: We introduce a separate (very thin) fblistener.exe (fbremote or whatever) binary that acts similar to xinetd on posix. Or maybe we have finally found a reason to keep the guardian ? (At least on windows.) Paul -- Paul Reeves

Re: [Firebird-devel] fb3 access modes under windows

2014-01-30 Thread Paul Reeves
there. Yes, that would be my preference. No -m switch and remove SharedN options from fb.conf. Users would be able to set default SS or CS at server level and override at database level with SS, CS or exclusive single-user attachment. Paul -- Paul Reeves http://www.ibphoenix.com Supporting

Re: [Firebird-devel] Created: (CORE-4336) Firebird.msg is not installed with client

2014-02-13 Thread Paul Reeves
installation. Have you tried setting FIREBIRD_MSG? Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird -- Android apps run on BlackBerry 10 Introducing the new BlackBerry 10.2.1 Runtime for Android

Re: [Firebird-devel] Update ICU in Windows

2014-02-14 Thread Paul Reeves
a compiler is needed for the build and microsoft don't supply those with the O/S, but neither unixtools nor Inno Setup are necessary to build firebord. They are only used for packaging. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird

Re: [Firebird-devel] Update ICU in Windows

2014-02-17 Thread Paul Reeves
On Monday 17 February 2014 09:38:44 Alex Peshkoff wrote: On 02/15/14 11:45, Paul Reeves wrote: On Friday 14 February 2014 18:24:40 Dimitry Sibiryakov wrote: 14.02.2014 18:16, Adriano dos Santos Fernandes wrote: If not, build will not be simple and may need extra download. It already

Re: [Firebird-devel] ICU Data table customization

2014-02-19 Thread Paul Reeves
, and difficult to maintain. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird -- Managing the Performance of Cloud-Based Applications Take advantage of what the Cloud has to offer - Avoid Common Pitfalls

Re: [Firebird-devel] ICU Data table customization

2014-02-19 Thread Paul Reeves
On Wednesday 19 February 2014 16:23:44 Dimitry Sibiryakov wrote: As said Aleksey Kovazin, Internet traffic today is cheap. Why to care about size and strip anything?.. Just because we can doesn't mean we should. :-) Paul -- Paul Reeves http://www.ibphoenix.com Supporting users

Re: [Firebird-devel] MySQL versus Firebird

2014-03-11 Thread Paul Reeves
from firebird devs has overwhelmed the site. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird -- Learn Graph Databases - Download FREE O'Reilly Book Graph Databases is the definitive new guide

Re: [Firebird-devel] libfbembed.so static for android

2014-03-25 Thread Paul Reeves
cat videos. We need to move on from this idea that they are inferior in some way. If anything they are the future of computing. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird -- Learn Graph

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

2014-07-15 Thread Paul Reeves
-3.0.0_Alph a2-ReleaseNotes.pdf The document may not be a phantom but that web server is. I can get to http://web.firebirdsql.org/download/prerelease/ but all but one of the folders underneath seem to be inaccessible :-( Paul -- Paul Reeves http://www.ibphoenix.com Supporting users

Re: [Firebird-devel] New Interface

2014-08-14 Thread Paul Reeves
On Thursday 14 August 2014 13:28:33 Dimitry Sibiryakov wrote: 14.08.2014 11:34, Alex Peshkoff wrote: HP C/aC++ Version A.06.26 Alpha version?.. More to the point - Itanium? An ARM-based test would be useful. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird

Re: [Firebird-devel] Using Firebird 3, beta 1 - installer report

2014-10-27 Thread Paul Reeves
, but it does mean that we are writing to files such as the log and the security database and these should not be in %ProgramFiles% and this should be a read-only directory. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird

Re: [Firebird-devel] Multiple instances under windows (was Re: UsingFirebird 3, beta 1 - installer report)

2014-10-27 Thread Paul Reeves
. And if the service is not running and it detects that you are installing over an existing v3 install it will assume you are doing an in-place upgrade. I'll look into that a bit more. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird

Re: [Firebird-devel] Multiple instances under windows (was Re:UsingFirebird 3, beta 1 - installer report)

2014-10-28 Thread Paul Reeves
levels. And it is even worse on linux. There, we are planning to move towards distro-specific packages and afaict, multiple installs are just not possible at the moment. I know I've had to do it manually. I don't know what the situation is on other platforms such as the mac. Paul -- Paul

Re: [Firebird-devel] Multiple instances under windows (was Re: UsingFirebird 3, beta 1 - installer report)

2014-10-28 Thread Paul Reeves
having to go through the config files. ;) Yep, that is what I'm thinking about, too. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird -- Firebird-Devel mailing list, web interface at https

Re: [Firebird-devel] Multiple instances under windows (was Re:UsingFirebird 3, beta 1 - installer report)

2014-10-28 Thread Paul Reeves
manager and message file. Something else to add to the 'to do list when I have some spare time'. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird -- Firebird-Devel mailing list, web interface

Re: [Firebird-devel] Multiple instances under windows (was Re:UsingFirebird 3, beta 1 - installer report)

2014-10-28 Thread Paul Reeves
shell script automating procedure, but it does not mean that manual multiinstancing is not possible. Yes, but I'm not sure how I would go about it on opensuse, for example. When I needed to do it recently I just installed the tarball a couple of times. (This was with 2.5). Paul -- Paul Reeves

Re: [Firebird-devel] FB 3.0 Beta 1

2014-12-08 Thread Paul Reeves
to configure firebird 3 manually if you want to keep an existing firebird installation. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird -- Download BIRT iHub F-Type - The Free Enterprise-Grade

Re: [Firebird-devel] FB 3.0 Beta 1

2014-12-08 Thread Paul Reeves
On Monday 08 December 2014 15:43:30 Werner wrote: On 12/8/2014 9:28, Paul Reeves wrote: On Monday 08 December 2014 09:04:16 Werner wrote: I would like to start testing FB 3. Does the installer allow installation side by side with FB 2.5? Not really. The installer has never been

Re: [Firebird-devel] Fixing database to use it with changed ICU version.

2014-12-11 Thread Paul Reeves
or even possible to do that. I think an option to reset the database via gfix would still be useful. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird -- Download BIRT iHub F-Type - The Free

Re: [Firebird-devel] Windows build

2015-01-29 Thread Paul Reeves
files to output_arch but IDE run files from temp\arch\conf\firebird... Do any of you have non-committed script that do the things or I'm missing something? run_all.bat perhaps? Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird

Re: [Firebird-devel] Examples broken in Windows

2015-01-27 Thread Paul Reeves
was derived from the name of the .lib generated by the borland compiler. Try fbclient_ms.lib. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird -- Dive into the World of Parallel Programming. The Go

Re: [Firebird-devel] Commits visible in our main page.

2015-03-10 Thread Paul Reeves
. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird -- Dive into the World of Parallel Programming The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your

Re: [Firebird-devel] Commits visible in our main page.

2015-03-10 Thread Paul Reeves
On Tuesday 10 March 2015 12:24:03 Dimitry Sibiryakov wrote: 10.03.2015 12:12, Paul Reeves wrote: AFAIK, you just need the one copy. You can switch views as much as you want. So, if I want to have clean Firebird copy, modified copy and deeply reworked copy synchronized between main

Re: [Firebird-devel] ANN: BenchmarkSQL

2015-03-12 Thread Paul Reeves
and as there was no CVS tree there wasn't really anywhere for me to send them. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird -- Dive into the World of Parallel Programming The Go Parallel Website

Re: [Firebird-devel] ANN: BenchmarkSQL

2015-03-12 Thread Paul Reeves
On Thursday 12 March 2015 13:39:20 Roman Simakov wrote: 2015-03-12 15:19 GMT+03:00 Paul Reeves pree...@ibphoenix.com: It is quite funny really how many people have latched onto this program, found it 'just works' and made a few modifications to it thinking they have a useful benchmarking

Re: [Firebird-devel] ANN: BenchmarkSQL

2015-03-12 Thread Paul Reeves
of the term TPC-C violates the terms of the Transaction Processing Council's trademark which requires an independent audit. So use the open source alternative, DBT2. Thanks for the correction - I must get into the habit of calling it DBT2. Paul -- Paul Reeves http://www.ibphoenix.com Supporting

Re: [Firebird-devel] ANN: BenchmarkSQL

2015-03-12 Thread Paul Reeves
and put it on github. Then we can take a look at this subject in more detail. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird -- Dive into the World of Parallel Programming The Go Parallel

Re: [Firebird-devel] employee db build broken

2015-06-25 Thread Paul Reeves
On Thursday 25 June 2015 10:56:24 Paul Reeves wrote: I'll do a 32-bit build and compare. OK, it doesn't look as if gpre is the problem. The employee.c generated is identical on 32 and 64-bit. So it must be related to the database that was created. I'll do some more digging. Paul -- Paul

[Firebird-devel] employee db build broken

2015-06-24 Thread Paul Reeves
saw this in empbuild.c: isc_vtov ((char*) job_code, (char*) isc_36.isc_40, 6); isc_vtov ((char*) job_country, (char*) isc_36.isc_37, 16); Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird

Re: [Firebird-devel] employee db build broken

2015-06-24 Thread Paul Reeves
(checkout and build 20 minutes ago). No such luck for me :-( I just did a fresh checkout and the Win64 build still fails with the same errors I reported earlier. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird

Re: [Firebird-devel] employee db build broken

2015-06-25 Thread Paul Reeves
On Wednesday 24 June 2015 19:22:15 Adriano dos Santos Fernandes wrote: On 24/06/2015 13:42, Paul Reeves wrote: No such luck for me :-( I just did a fresh checkout and the Win64 build still fails with the same errors I reported earlier. Please try to remove -r from gpre calls

Re: [Firebird-devel] employee db build broken

2015-07-01 Thread Paul Reeves
On Wednesday 01 July 2015 11:34:08 Dmitry Yemanov wrote: 24.06.2015 11:50, Paul Reeves wrote: The 64-bit windows build of the employee db is broken. Can you confirm that the issue is gone now? Yes. Adriano supplied a fix and tagged it for Beta 2. I've checked that make_examples.bat builds

[Firebird-devel] Parsing fbtrace.conf

2015-07-28 Thread Paul Reeves
values are set last are the values used. For example postfix is specifically designed to allow this: myparam = x snip lots of config myparam = y and the final value used for myparam will be y. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird

Re: [Firebird-devel] windows installer and authentication

2015-07-13 Thread Paul Reeves
. Obviously I am missing something huge here - if we don't provide legacy authentication how and where do we create sysdba? Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird -- Don't Limit Your

Re: [Firebird-devel] windows installer and authentication

2015-07-15 Thread Paul Reeves
On Tuesday 14 July 2015 19:00:59 Dmitry Yemanov wrote: 13.07.2015 16:07, Paul Reeves wrote: Obviously I am missing something huge here - if we don't provide legacy authentication how and where do we create sysdba? The same way (gsec?) and the same location (security3.fdb). Just use the Srp

Re: [Firebird-devel] FB3 & W7E

2015-11-09 Thread Paul Reeves
ploy MSVC10 runtime assemblies? As far as I can tell then are already available on most/all systems that are supported by Microsoft anyway. Feedback is needed. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird

Re: [Firebird-devel] FB3 & W7E

2015-11-09 Thread Paul Reeves
ages, and copy nearby an application. > Yes, perhaps a distributable client package would be a good idea. Or at the very least, some documentation on how to distribute the client with an application. I'll see what I can do. Paul -- Paul Reeves http://www.ibp

Re: [Firebird-devel] FB3 and authentication and security3.fdb

2015-11-05 Thread Paul Reeves
On Thursday 05 Nov 2015 13:49:26 Alex Peshkoff wrote: > On 11/04/2015 11:45 AM, Paul Reeves wrote: > > So the question is this - can the authentication method be switched > > between > > srp and legacy without modifiying security3.fdb? > > Paul, switching authenticat

Re: [Firebird-devel] FB3 and authentication and security3.fdb

2015-11-04 Thread Paul Reeves
On Wednesday 04 Nov 2015 16:25:22 Mark Rotteveel wrote: > On Wed, 04 Nov 2015 09:45:27 +0100, Paul Reeves <pree...@ibphoenix.com> > > So the question is this - can the authentication method be switched > > between > > srp and legacy without modifiying security3.fdb? &

[Firebird-devel] FB3 and authentication and security3.fdb

2015-11-04 Thread Paul Reeves
.fdb? Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird -- Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] ExternalFileAccess in v.2.5.4

2015-10-07 Thread Paul Reeves
On Wednesday 07 Oct 2015 14:57:48 Helen Borrie wrote: > > ExternalFileAccess = Restrict 'H:\externalfiles'; > (tried it with and without the semicolon) > Is h: a mapped networked drive or is it local to the host? Paul -- Paul Reeves http://www.ibphoenix.com Supporting users

[Firebird-devel] firebird.msg

2015-09-16 Thread Paul Reeves
I just noticed the size of firebird.msg in Fb 3 trunk - it seems to be around 550 Mb. In Fb 2.5 it is around 150 Mb and in the previous beta releases of Fb 3 it is also around 150Mb. What's happened? Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird

Re: [Firebird-devel] firebird.msg

2015-09-16 Thread Paul Reeves
s are made by diffing the dev tree to a fresh checkout, and then carefully copying over the changes to the fresh checkout so that each change gets committed separately with correct documentation. Paul -- Paul Reeves http://www.ibphoenix.com Support

Re: [Firebird-devel] firebird.msg

2015-09-16 Thread Paul Reeves
. So I guess as long as I understand the units of measurment I'm using that government economist job might still be open. The pay would have to be an order of magnitude better, mind you, and with a good early retirement package. Paul -- Paul Reeves http:

Re: [Firebird-devel] firebird.msg

2015-09-16 Thread Paul Reeves
On Wednesday 16 September 2015 11:35:02 Dmitry Yemanov wrote: > 16.09.2015 12:04, Paul Reeves пишет: > > I just noticed the size of firebird.msg in Fb 3 trunk - it seems to be > > around 550 Mb. In Fb 2.5 it is around 150 Mb and in the previous beta > > releases of Fb 3 it

[Firebird-devel] instsvc and ServerMode

2015-09-17 Thread Paul Reeves
manager. That way it would be available to instsvc and the cpl applet on Windows as well as being available to other platforms. The third question leads on from this - 'Do we want to add a more generic method of updating any entry in firebird.conf?' Thoughts? Paul -- Paul Reeves http

Re: [Firebird-devel] instsvc and ServerMode

2015-09-17 Thread Paul Reeves
you think the cpl applet must die? > For v3, I'd say that the installer should be the only tool touching > configuration file(s). > OK. But that raises another issue which I will discuss in a new thread - probably tomorrow. Paul -- Paul Reeves http://www.

Re: [Firebird-devel] instsvc and ServerMode

2015-09-17 Thread Paul Reeves
nuing to provide that support. Modifying the config file isn't the most challenging of programming tasks. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird -- Monitor Your Dynamic Infrastruc

Re: [Firebird-devel] Replacing `instsvc`

2015-09-17 Thread Paul Reeves
now if we are losing a feature from instsvc that people rely on and expect. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird -- Monitor Your Dynamic Infrastructure at Any Scale With Datadog!

[Firebird-devel] building FB3 for valgrind

2016-06-17 Thread Paul Reeves
ror perhaps? Should I file a bug report? Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird -- What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic patterns at an interf

[Firebird-devel] Centos7 and FB_CPU

2016-06-29 Thread Paul Reeves
defined as x86_64-unknown-linux-gnu so surely that ought to be enough information to define AMD64 but for some reason that does happen. Anyone got any ideas? Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird

Re: [Firebird-devel] [Firebird-checkins] [FirebirdSQL/firebird] 161500: Deploy fbclient to by default.

2016-04-01 Thread paul reeves
b8a3e89f7765b5c0a557dd0 > Ah, I missed that commit. So we could have started phasing out the guardian since v2.0. :-) I'll roll back that change later today. I've been having internet connection problems and haven't quite recovered. Paul -- Paul Reeves http://www.ibphoe

Re: [Firebird-devel] [Firebird-checkins] [FirebirdSQL/firebird] 161500: Deploy fbclient to by default.

2016-04-01 Thread paul reeves
On Fri, 1 Apr 2016 16:05:17 +0200 Dimitry Sibiryakov <s...@ibphoenix.com> wrote: > 01.04.2016 15:59, paul reeves wrote: > >> >What about firebird.msg ? > > That has always been a problem. Perhaps we could add that to ? > > Although I'm not sure ab

[Firebird-devel] isc_dsql_execute_immediate and FB3

2016-05-18 Thread Paul Reeves
because it allowed misuse of the function. However, if we are going to throw an error I think it should be more explicit. Perhaps something along the lines of: 'Select statements cannot be execute by isc_dsql_execute_immediate' Shall I log this as a bug / enhancement request ? Paul -- Paul

[Firebird-devel] Multiple instances of Firebird 3 on linux

2016-05-09 Thread Paul Reeves
parameter? Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird -- Find and fix application performance issues faster with Applications Manager Applications Manager provides deep performance insights

Re: [Firebird-devel] Centos7 and FB_CPU

2016-06-29 Thread Paul Reeves
On Wed, 29 Jun 2016 13:00:53 +0300 Alex Peshkoff <peshk...@mail.ru> wrote: > On 06/29/2016 12:42 PM, Paul Reeves wrote: > > On Wed, 29 Jun 2016 11:07:06 +0200 > > Paul Reeves <pree...@ibphoenix.com> wrote: > > > > symbol lookup > > error: > &

Re: [Firebird-devel] LibreOffice 5.3.0 is using firebird 3.0

2017-02-09 Thread Paul Reeves
On Thu, 9 Feb 2017 11:38:51 +0200 you wrote > LibreOffice Release notes > > https://wiki.documentfoundation.org/ReleaseNotes/5.3#Base > IIUC, every time you open/close a firebird database in LO it calls gbak to do a restore or a backup. Paul -- Paul Reeves http://www.i

Re: [Firebird-devel] Event Parameter buffer (EPB)

2017-03-28 Thread Paul Reeves
ut still recommended from a performance perspective. (Which is the whole point of using events in the first place.) Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird -- Check out the vibrant te

Re: [Firebird-devel] Event Parameter buffer (EPB)

2017-03-28 Thread Paul Reeves
Anyone ? On Mon, 27 Mar 2017 11:12:47 +0200 Paul Reeves wrote > The EPB is clearly documented as being limited to 15 events. I did a > fairly rough grep of the code and I failed to find where this > limitation is enforced. And I couldn't find anything in the release > notes

[Firebird-devel] Event Parameter buffer (EPB)

2017-03-27 Thread Paul Reeves
without anyone noticing? Or have I missed something while grepping the code? Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird -- Check out the vibrant tech community on one of the world's most

Re: [Firebird-devel] unix2dos

2017-03-23 Thread Paul Reeves
will be in dos format - hence the name. Why the gnuwin32 version doesn't make that assumption is anyone's guess. So the -D (or --unix2dos in the long format ) is required. Paul -- Paul Reeves http://www.ibphoenix.com Supporting us

Re: [Firebird-devel] Useful SQL Stored Procedures as part of standard firebird installation

2017-08-14 Thread Paul Reeves
see the IDPL here: https://www.ibphoenix.com/about/firebird/idpl and the IPL here: https://www.ibphoenix.com/about/firebird/ipl > 2. What prefix do you prefer for this? > > I prefer LIB$, like LIB$CheckTriggerUniquePostion. > > Any other idea? That could work. Does anyone else hav

Re: [Firebird-devel] Optimisation of where afield = coalesce(value1, value2 )

2017-07-10 Thread Paul Reeves
he indexed reads more or less double because of the OR clause. (Again, a subject for another day is why does the optimiser even bother with the second stream when EMP_NO can never be null ? ) Anyway, none of the above is any sort of criticism. I'm just trying to get a better understanding of the rules a

  1   2   >