Re: [Firebird-devel] Crash in boot build, VC9

2011-04-05 Thread Alex Peshkoff
On 04/04/11 23:56, Claudio Valderrama C. wrote: Claudio, please try this patch. It should fix this bug. And can you please also provide full stacktrace for this case? For me cleanup member was never left uninitialized cause all modules were doing setCleanup(). I wonder what module caused

Re: [Firebird-devel] Performance after CREATE DATABASE

2011-04-07 Thread Alex Peshkoff
On 04/07/11 14:39, Dmitry Yemanov wrote: 07.04.2011 14:15, Vlad Khorsun wrote: So, i think, this is the bug. Agreed. +1 We can fix engine (make PIO_create to create files in FW=ON mode, or add new parameter to it) I think we must take isc_dpb_gbak_attach into an account. When it is set,

Re: [Firebird-devel] SF.net SVN: firebird:[52693] firebird/trunk/src

2011-04-11 Thread Alex Peshkoff
On 04/11/11 19:53, Adriano dos Santos Fernandes wrote: On 11-04-2011 07:28, Alex Peshkoff wrote: PS Alex will explain you why struct or class with data members is bad for *portable* code. Taking into an account Dmirty's sample with XSQLDA I must say that may be not everything SO bad

Re: [Firebird-devel] SF.net SVN: firebird:[52693] firebird/trunk/src

2011-04-12 Thread Alex Peshkoff
On 04/11/11 21:00, Adriano dos Santos Fernandes wrote: On 11-04-2011 13:25, Alex Peshkoff wrote: On 04/11/11 20:19, Adriano dos Santos Fernandes wrote: On 11-04-2011 13:15, Alex Peshkoff wrote: On 04/11/11 19:53, Adriano dos Santos Fernandes wrote: On 11-04-2011 07:28, Alex Peshkoff wrote

Re: [Firebird-devel] Feature request: database registration via aliases.conf, databases system table support

2011-04-13 Thread Alex Peshkoff
On 04/13/11 12:02, Geoff Worboys wrote: Why: developers/end users can more easily choose and connect to a database on a Firebird server, even point and click. Point and click should be implemented by client, not by server. I cannot speak for the original author, but it seems to me the one

Re: [Firebird-devel] Feature request: database registration via aliases.conf, databases system table support

2011-04-13 Thread Alex Peshkoff
On 04/13/11 14:55, Kjell Rilbe wrote: But, all things considered, I feel that the feature is too complicated and has too many security implications to be worth it. If anything, I might suggest that the alias config that's already present could be augmented with a flag for each alias

Re: [Firebird-devel] Feature request: database registration via aliases.conf, databases system table support

2011-04-13 Thread Alex Peshkoff
On 04/13/11 16:02, Kjell Rilbe wrote: Den 2011-04-13 12:55 skrev Kjell Rilbe såhär: I might suggest that the alias config that's already present could be augmented with a flag for each alias specifying if it should be available for browsing or not (default = no). Those marked as available

Re: [Firebird-devel] Aliases

2011-04-15 Thread Alex Peshkoff
On 03/17/11 18:29, Woody wrote: Just curious, has there been any discussion about expanding aliases to allow defining just a path to a directory where multiple database reside? The reason I'm asking is that in some situations, my apps are designed to allow the users to archive fiscal data.

Re: [Firebird-devel] The boot build again

2011-04-18 Thread Alex Peshkoff
Believe me or not, but there is not tricks known to me. It just works :) Vlad, looks like FIREBIRD_BOOT_BUILD env variable is not set during windows build. I do not say that it's too much important, but it helps to avoid UDF dependencies (we do not UDF during boot build), set correct owner

Re: [Firebird-devel] ICU. VS2010 project files

2011-04-20 Thread Alex Peshkoff
On 04/19/11 22:47, Adriano dos Santos Fernandes wrote: On 19-04-2011 13:02, Paul Reeves wrote: However, if it hasn't been changed it would require a ton of work for each icu version, which is one of the reasons why we haven't upgraded icu. No, it's surely not. I've done a patch for a

Re: [Firebird-devel] The boot build again

2011-04-21 Thread Alex Peshkoff
On 04/21/11 09:14, Claudio Valderrama C. wrote: -Original Message- From: Alex Peshkoff [mailto:peshk...@mail.ru] Sent: Martes, 19 de Abril de 2011 4:38 Do you have file \builds\win32\defs\plugin.def ? Yes and besides the license, it says EXPORTS firebird_plugin

Re: [Firebird-devel] Error building trunk (posix, SyncObject.h:65)

2011-04-29 Thread Alex Peshkoff
On 04/29/11 12:11, Damyan Ivanov wrote: Sorry if I am impatient :) I wanted to try the new synchronization code on the Debian build daemons (3.0 so far supported only x86/amd64). Should build now - revision 52840.

Re: [Firebird-devel] Repeatable crash in Firebird Embedded 2.1.4 Windows x64

2011-05-04 Thread Alex Peshkoff
On 05/03/11 13:34, Antti Nivala wrote: (Reposting, because the HTML message was distorted in the archives.) Hi, Does the following look like a Firebird 2.1.4 bug, or are we doing something wrong? We are upgrading from Firebird 2.1.2.18118 to Firebird 2.1.4.18393. We use Firebird Embedded

Re: [Firebird-devel] Shared page cache

2011-05-10 Thread Alex Peshkoff
On 05/09/11 21:15, Dimitry Sibiryakov wrote: 09.05.2011 18:48, Leyne, Sean wrote: I disagree. Shadow is the only method for synchronous replication in Firebird now. Synchronous replication on a single server is not replication. Don't forget about NFS and iSCSI(?). Why _only_ NFS?

Re: [Firebird-devel] Shared page cache

2011-05-10 Thread Alex Peshkoff
On 05/09/11 14:06, Vlad Khorsun wrote: To run SuperClassic you should use switch -m in command line of firebird.exe (on Windows) or run fb_smp_server (on Posix, here i'm not sure and Alex will correct me) Small correction. There is no more fb_smp_server on posix. There is also single

Re: [Firebird-devel] ERROR firebird.msg not found, when build Firebird 2.1.3 or 2.1.4

2011-05-10 Thread Alex Peshkoff
On 05/10/11 07:36, wuu wrote: hi, all. I need help, when build Firebird 2.1.3 or 2.1.4. CPU info : freescale P2020 QorIQ, powerpc e500v2 core .. Any ideas how to fix it? First of all provide full build log.

Re: [Firebird-devel] Error building trunk (posix, SyncObject.h:65)

2011-05-11 Thread Alex Peshkoff
On 05/07/11 21:14, Damyan Ivanov wrote: -=| Damyan Ivanov, Sat, Apr 30, 2011 at 05:40:12PM +0300 |=- -=| Alex Peshkoff, Fri, Apr 29, 2011 at 01:26:28PM +0400 |=- On 04/29/11 12:11, Damyan Ivanov wrote: Sorry if I am impatient :) I wanted to try the new synchronization code on the Debian

Re: [Firebird-devel] ERROR firebird.msg not found, when build Firebird 2.1.3 or 2.1.4

2011-05-11 Thread Alex Peshkoff
On 05/11/11 13:11, wuu wrote: thank you, I'll enable debug to get more info. And 2.5 also can't compile : http://firebird.1100200.n4.nabble.com/file/n3514200/build_2.5.log build_2.5.log error info : in src/common/classes/fb_atomic.h, line 518, #error AtomicCounter: implement appropriate

Re: [Firebird-devel] Segmentation Fault in libfbclient-2.5 (RedHat6.0)

2011-05-12 Thread Alex Peshkoff
On 05/11/11 17:02, Pawel Sawicki wrote: Hi All, We are running application which has dedicated signal handler. It uses libfbclient-2.5 to connect to Firebird database. When it receives signal 15 it tries first to shutdown active database connections with help of detach_or_drop_database

Re: [Firebird-devel] Firebird backup fails to restore

2011-05-13 Thread Alex Peshkoff
On 05/13/11 09:43, Russell R wrote: This post is related to the following 2 reported incidents: http://tracker.firebirdsql.org/browse/CORE-3121 http://tracker.firebirdsql.org/browse/CORE-3121 http://firebird.1100200.n4.nabble.com/Error-Restoring-v2-1-Database-to-v2-5-td2994314.html

Re: [Firebird-devel] Semantics of release

2011-05-16 Thread Alex Peshkoff
On 05/16/11 20:33, Vlad Khorsun wrote: Could you explain, please, semantics of addRef/release on public provider interfaces? The issue was discussed on this list with two possibilities: - when refCount = 1, release does things like detach, rollback, free, etc. It's what was implemented so

Re: [Firebird-devel] Semantics of release

2011-05-17 Thread Alex Peshkoff
Speaking about documentation i'd said we must document usage of every public interface and specify explicitly how instance is constructed and destroyed. Well - with this adjustment I can agree with every style. (Though must say that addRef/release pair in our interfaces is already

Re: [Firebird-devel] Semantics of release

2011-05-17 Thread Alex Peshkoff
On 05/17/11 16:07, Vlad Khorsun wrote: To support wrong code and solve nothing. With the cost of all this mess, all this otherwise unneeded discussion, all the global/local pool mess. ...only emotions and offence... Agreed - nothing except emotions ...

Re: [Firebird-devel] Semantics of release

2011-05-18 Thread Alex Peshkoff
On 05/16/11 21:00, Vlad Khorsun wrote: We can introduce some special mode to report such errors using exceptions, or write message into log, or even provide callback for debugging purposes. But Adriano's question was about *semantics*. So, do you agree with me that explicit

Re: [Firebird-devel] [pkg-firebird-general] Bug#626931: Bug#626931: Bug#626931: FTBFS on GNU/Hurd

2011-05-18 Thread Alex Peshkoff
Hi, Marius! We need a new define for hurd Do you need help in creating prefix.hurd_i386 file? afther we undefine LINUX that part compiles but i hit another issues that i found it to be in haikuos too g++ -I../src/include/gen -I../src/include -I../src/vulcan -DNAMESPACE=Vulcan -gg

Re: [Firebird-devel] Semantics of release

2011-05-18 Thread Alex Peshkoff
On 05/17/11 19:34, Adriano dos Santos Fernandes wrote: On 17/05/2011 04:05, Alex Peshkoff wrote: In FB2.5 yValve did not need any more MT-safeness except provided by atomic counters and some helper locks like hanlers' map RwLock. Initially I've planned to keep same approach for FB3. But I did

Re: [Firebird-devel] Cannot connect (errors on firebird.log)

2011-05-18 Thread Alex Peshkoff
On 05/18/11 16:07, Leonardo M. Ramé wrote: Sorry for cross posting, I asked this in firebird-support but I got no answer so far. I recently installed Firebird 2.5 on a FreeBSD, it was running ok until this moring when suddendly it stopped accepting connections. The server runs via inetd.

Re: [Firebird-devel] Problems in upgradeInterface

2011-05-24 Thread Alex Peshkoff
Not responding you directly, but anyway... I'd want to say again that user should not pass a function to upgradeInterface. Every function (except some ones from base-core classes / IStatus) should consistently use a first parameter of type IStatus. The upgradeInterface should point

[Firebird-devel] CORE-3462

2011-05-31 Thread Alex Peshkoff
Hi all, I ask you to take a look at http://tracker.firebirdsql.org/browse/CORE-3462 and suggested solution. Is it OK for 2.5? I ask cause formally this is API change, though very small and 100% backward compatible. --

Re: [Firebird-devel] Interesting article about scalability of MySQL in Amazon (?) RDS

2011-06-22 Thread Alex Peshkoff
On 06/22/11 11:13, Roman Rokytskyy wrote: Would be interesting to check how does Firebird behaves. Roman, we have some implementation of tpc-c, which works with firebird. I often use it to check firebird stability under load. But telling true it seems that it measures using some other tpmC. I

Re: [Firebird-devel] Interesting article about scalability of MySQL in Amazon (?) RDS

2011-06-22 Thread Alex Peshkoff
On 06/22/11 13:35, marius adrian popa wrote: Could you publish the sources in github/sourceforge for tpc Sorry - no. License issues. -- Simplify data backup and recovery for your virtual environment with vRanger.

Re: [Firebird-devel] FreePascal as an embedded language in Firebird: possible and desirable?

2011-07-27 Thread Alex Peshkoff
On 07/27/11 13:40, Roman Rokytskyy wrote: So, considering this all, there should be (theoretically) no problem of compiling the code in Free Pascal as long as it will produce binaries with appropriate entry points. That should be possible out-of-the-box (at least it was discussed that

Re: [Firebird-devel] FreePascal as an embedded language in Firebird: possible and desirable?

2011-07-27 Thread Alex Peshkoff
On 07/27/11 15:45, Dimitry Sibiryakov wrote: 27.07.2011 13:40, Alex Peshkoff wrote: Before doing JIT, we must think about related security issues. How can we prevent pascal procedure from doing bad things with firebird runuser access rights? Leave it to DBA/sysdmin? In trade-off security

Re: [Firebird-devel] FreePascal as an embedded language in Firebird: possible and desirable?

2011-07-27 Thread Alex Peshkoff
On 07/27/11 16:05, Roman Rokytskyy wrote: 6. Just in time compilation of the embedded procedure on first use (after create/alter) into a shared library/DLL which is then effectively a dynamically generated UDF library. A JIT approach is important because the database can be moved between

Re: [Firebird-devel] FreePascal as an embedded language in Firebird: possible and desirable?

2011-07-27 Thread Alex Peshkoff
On 07/27/11 16:42, ik wrote: On Wed, Jul 27, 2011 at 15:35, Tony Whyman tony.why...@mccallumwhyman.comwrote: This is really a general UDF problem and another reason why you need to be very careful about deploying them. The only difference between an embedded function and UDF one is that

Re: [Firebird-devel] FreePascal as an embedded language in Firebird: possible and desirable?

2011-07-27 Thread Alex Peshkoff
On 07/27/11 16:05, marius adrian popa wrote: On Wed, Jul 27, 2011 at 2:40 PM, Alex Peshkoff peshk...@mail.ru wrote: On 07/27/11 15:11, Tony Whyman wrote: 6. Just in time compilation of the embedded procedure on first use (after create/alter) into a shared library/DLL which

Re: [Firebird-devel] fb3 build problem regarding ISC_expand_filename

2011-07-28 Thread Alex Peshkoff
On 07/27/11 23:07, Treeve Jelbert wrote: I am trying to build the latest checkout of fb3 on amd64 linux-2.6.39.3 , using gcc-4.6.1 and glibc-2.13 Treeve, I can't confirm problems from both your letters. I've built today fbs2 / # gcc --version gcc (GCC) 4.6.1 fbs2 / # as --version GNU

Re: [Firebird-devel] thd_priority

2011-08-08 Thread Alex Peshkoff
On 08/06/11 09:47, Claudio Valderrama C. wrote: -Original Message- From: Alex Peshkoff [mailto:peshk...@mail.ru] Sent: Lunes, 01 de Agosto de 2011 2:56 On 07/30/11 11:04, Claudio Valderrama C. wrote: Hello, each time I compile, I get thd_priority.obj : warning LNK4221: no public

Re: [Firebird-devel] Shadow files

2011-08-09 Thread Alex Peshkoff
On 08/08/11 19:10, Dimitry Sibiryakov wrote: 08.08.2011 16:57, Kjell Rilbe wrote: So, I ask you in the devel team: is the shadow file feature going to go away or will you make sure it stays functional? If discussion about dropping of shadow is ever raised I will vote against. +1

Re: [Firebird-devel] url from headers

2011-08-23 Thread Alex Peshkoff
It would not be appropriate for the project to change the License header, in any way. Which would be fine if the link actually went to Embarcadero but it seems that the inprise domains are now owned by advertising scammers? I think in this case changing it is appropriate as

Re: [Firebird-devel] Firebird 2.5.1 release candidate kits

2011-08-25 Thread Alex Peshkoff
В Чт., 25/08/2011 в 05:04 +, Maya Opperman пишет: The Firebird Project team is happy to announce that the v.2.5.1 release candidate kits for Linux and Windows 32-bit and 64-bit platforms are ready for testing. http://firebirdsql.org/en/firebird-2-5-1-rc1 Yippee!!! What

Re: [Firebird-devel] Association of transactions, connections, and two-phase commit

2011-08-28 Thread Alex Peshkoff
Wouldn't it be better to join a new attachment to an existing distributed transaction? No. Attachment *itself* can't participate in distributed transaction. At least not directly. Transaction of this attachment - can. Just understand: attachment *is not a* transaction.

Re: [Firebird-devel] Firebird terribly slow on Ubuntu 10.04 - ext4

2011-08-31 Thread Alex Peshkoff
On 08/31/11 12:25, Fulvio Senore wrote: I must admit that I was executing each query in its own transaction. Since I was only executing SELECT statements I was thinking that there was no problem in working this way. I never had performance problems with Windows and Linux in virtual

Re: [Firebird-devel] Stored procedures in other languages interface

2011-09-19 Thread Alex Peshkoff
On 09/13/11 17:23, Jiri Cincura wrote: Hi *, is there some high level description of how the %subj% works and is defined [1]? I'd like to think about it from .NET/CLR POV. Looks like not. Not sure about other languages interface specifics, but general plugin certainly has [1] interface.

Re: [Firebird-devel] Error compiling Firebird-2.5.1.26358-0

2011-09-19 Thread Alex Peshkoff
On 09/19/11 15:34, Laszlo KAROLYI wrote: Any suggestions? I googled for this error, but it seems like mutex usage is already fixed in FreeBSD. You should read ~/doc/README.build.posix.html and tune your kernel before using FB on freebsd.

Re: [Firebird-devel] Segfault in libfbclient 2.5.1 RC1 when usilg alarm()

2011-09-20 Thread Alex Peshkoff
On 09/20/11 12:17, Damyan Ivanov wrote: Hi, I have a Perl script that used IBPerl for connecting to Firebird. The script is used for some mass data processing, and uses alarm() to provide feedback (prints number of processed input lines). That same script used to work just fine until I

Re: [Firebird-devel] Segfault in libfbclient 2.5.1 RC1 when usilg alarm()

2011-09-20 Thread Alex Peshkoff
On 09/20/11 12:59, Damyan Ivanov wrote: perl alarm.pl db.fdb Well, now I see 20665817 on the screen. Must say that this is DEV_BUILD. I will try with release one now. -- All the data continuously generated in your IT

Re: [Firebird-devel] Segfault in libfbclient 2.5.1 RC1 when usilg alarm()

2011-09-20 Thread Alex Peshkoff
On 09/20/11 14:08, Alex Peshkoff wrote: On 09/20/11 12:59, Damyan Ivanov wrote: perl alarm.pl db.fdb Well, now I see 20665817 on the screen. Must say that this is DEV_BUILD. I will try with release one now. With release build I confirm segfault

Re: [Firebird-devel] Error compiling Firebird-2.5.1.26358-0

2011-09-22 Thread Alex Peshkoff
On 09/20/11 20:08, Laszlo KAROLYI wrote: Thank you, I tuned my FreeBSD according to the settings in the page, and now it works. Please keep supporting FreeBSD, our work depends on it :) Thanks, we'll do. Did you consider to support Firebird by joining Firebird Foundation?

Re: [Firebird-devel] Avoid memory waste per record

2011-10-01 Thread Alex Peshkoff
On 09/30/11 20:19, Adriano dos Santos Fernandes wrote: Hi! Look at this piece. The original code wastes 8 bytes per Record variable in 64-bits. Do you see any problem with this change? diff --git a/src/jrd/req.h b/src/jrd/req.h index 8271b3e..7db0f39 100644 ---

Re: [Firebird-devel] Avoid memory waste per record

2011-10-04 Thread Alex Peshkoff
On 10/01/11 18:54, Adriano dos Santos Fernandes wrote: On 01-10-2011 03:22, Alex Peshkoff wrote: Also look in ProcedureScan.cpp on the usage of irsb_message. The VaryingString could be replaced by a UCHAR[], and since the memory is dynamic allocated, it must be surely aligned even

Re: [Firebird-devel] Support conditional trigger firing (WHEN clause ala Oracle)

2011-10-10 Thread Alex Peshkoff
On 10/10/11 11:24, Mark Rotteveel wrote: On Mon, 10 Oct 2011 09:11:40 +0200, Thomas Steinmaurer t...@iblogmanager.com wrote: I think that the Oracle WHEN-clause is simply syntactic sugar for wrapping the entire body in an IF-condition. I don't think there would be much difference

Re: [Firebird-devel] Support conditional trigger firing (WHEN clause ala Oracle)

2011-10-10 Thread Alex Peshkoff
On 10/10/11 11:47, Dimitry Sibiryakov wrote: 10.10.2011 9:41, Alex Peshkoff wrote: But telling true I do not think that such game is worth playing - too many conditions should be met. It is worth for Oracle because a) condition is evaluated in SQL machine and let it avoid switching to PL

Re: [Firebird-devel] Support conditional trigger firing (WHEN clause ala Oracle)

2011-10-10 Thread Alex Peshkoff
On 10/10/11 13:48, Vlad Khorsun wrote: 10.10.2011 12:26, Vlad Khorsun wrote: If such clause is inside trigger code then it not affects security checks and *whole* trigger code is checked. SQL standard says something about security checks for conditional triggers ? I believe the rules are

Re: [Firebird-devel] Support conditional trigger firing (WHEN clause ala Oracle)

2011-10-10 Thread Alex Peshkoff
On 10/10/11 14:36, Adriano dos Santos Fernandes wrote: On 10/10/2011 04:47, Dimitry Sibiryakov wrote: b) trigger body can be in Java. Firebird don't have both these problems. Wrong reason, as Oracle doesn't support external triggers. You would just need to code a PL/SQL trigger that calls

Re: [Firebird-devel] Firebird 2.5.1 Winx64 Trace problem - crash dumpavailable

2011-10-14 Thread Alex Peshkoff
On 10/13/11 18:00, Thomas Steinmaurer wrote: A crash dump is available here: http://www.iblogmanager.com/download/misc/fb251_x64_crashdump.zip I see why it is crashed (during error reporting about failed read from config file) and i can fix it. But i don't see why read was failed. And

Re: [Firebird-devel] Firebird 2.5.1 Winx64 Trace problem - crash dumpavailable

2011-10-14 Thread Alex Peshkoff
On 10/14/11 11:18, Thomas Steinmaurer wrote: On 10/13/11 18:00, Thomas Steinmaurer wrote: A crash dump is available here: http://www.iblogmanager.com/download/misc/fb251_x64_crashdump.zip I see why it is crashed (during error reporting about failed read from config file) and i can

Re: [Firebird-devel] Trace data for unauthorized attach database event

2011-10-20 Thread Alex Peshkoff
On 10/19/11 17:41, Thomas Steinmaurer wrote: Hello Alex, there is a minor difference for the trace data output for an unauthorized vs. authorized attach database event. Successful: 2011-10-19T14:32:05.9090 (1760:05F47F48) ATTACH_DATABASE tourism.fdb (ATT_1772, HIC:NONE,

Re: [Firebird-devel] news from kernel 3.1

2011-10-25 Thread Alex Peshkoff
On 10/25/11 13:56, Paul Reeves wrote: On Tuesday 25 October 2011 at 11:12 marius adrian popa wrote: In other words: if you use Ext3 and you note performance regressions with this release, try disabling barriers (barriers=0 mount option). I can understand doing this for routine desktop work.

Re: [Firebird-devel] news from kernel 3.1

2011-10-25 Thread Alex Peshkoff
On 10/25/11 14:03, Adriano dos Santos Fernandes wrote: On 25/10/2011 07:56, Paul Reeves wrote: On Tuesday 25 October 2011 at 11:12 marius adrian popa wrote: In other words: if you use Ext3 and you note performance regressions with this release, try disabling barriers (barriers=0 mount

Re: [Firebird-devel] news from kernel 3.1

2011-10-26 Thread Alex Peshkoff
On 10/26/11 14:26, Lester Caine wrote: Paul Reeves wrote: Everything really depends on the manufactures claims that the capacitors can flush the cache successfully. Can we trust them? It's not just the drives capacity that matters here. Most of the machines I've checked will continue to

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-3659) Іncrease table name and field name size above 32 symbols

2011-11-13 Thread Alex Peshkoff
On 11/14/11 02:59, Adriano dos Santos Fernandes wrote: On 13-11-2011 19:48, Alexandre Benson Smith wrote: I understand that such improvement could be hard to implement because of the changes on the API and that the access libraries must be recoded for such change, this could be a reason to

Re: [Firebird-devel] second embedded connect hangs on armel, ia64, kfreebsd and s390

2011-11-16 Thread Alex Peshkoff
On 11/17/11 00:38, Damyan Ivanov wrote: Is user, running that script, a member of group firebird? No and I can't make it. I am a mere user on the porter machines :) That's a pity and can be even a reason not to deliver ASTs between processes. On the other hand we have 2 processes started by

Re: [Firebird-devel] second embedded connect hangs on armel, ia64, kfreebsd and s390

2011-11-17 Thread Alex Peshkoff
On 11/17/11 11:37, Dmitry Yemanov wrote: 17.11.2011 11:26, Alex Peshkoff wrote: And one more interesting line: open(./fb_init, O_RDWR|O_CREAT|O_LARGEFILE, 0600) = 7 Why is _SHARED_ file opened in CWD? It should go to /tmp/firebird. Because he explicitly sets FIREBIRD_LOCK to CWD before

Re: [Firebird-devel] news from kernel 3.1

2011-11-17 Thread Alex Peshkoff
On 11/17/11 14:14, Adriano dos Santos Fernandes wrote: On 17/11/2011 07:52, Dmitry Yemanov wrote: The only way to guarantee ordered writes is to flush individual pages and this is what FW=ON does. Or to flush group of independent pages at once, like I proposed. I think this can be a great

Re: [Firebird-devel] news from kernel 3.1

2011-11-17 Thread Alex Peshkoff
On 11/17/11 15:37, Vlad Khorsun wrote: On 11/17/11 14:14, Adriano dos Santos Fernandes wrote: On 17/11/2011 07:52, Dmitry Yemanov wrote: The only way to guarantee ordered writes is to flush individual pages and this is what FW=ON does. Or to flush group of independent pages at once, like I

Re: [Firebird-devel] news from kernel 3.1

2011-11-17 Thread Alex Peshkoff
On 11/17/11 15:23, Adriano dos Santos Fernandes wrote: On 17/11/2011 09:19, Alex Peshkoff wrote: On 11/17/11 14:14, Adriano dos Santos Fernandes wrote: On 17/11/2011 07:52, Dmitry Yemanov wrote: The only way to guarantee ordered writes is to flush individual pages and this is what FW

Re: [Firebird-devel] FB 3: Use cases for updating system tables directly

2011-11-28 Thread Alex Peshkoff
On 11/28/11 17:03, Thomas Steinmaurer wrote: - Support for the inserting SYSDBA role trick, although I'm not sure if this is still important due to the new authentication plugin mechanism This will become not needed not due to authentication plugins, but due to mapping server logins (names we

Re: [Firebird-devel] The new Firebird OO API

2011-11-28 Thread Alex Peshkoff
On 11/29/11 02:53, Pierre Y. wrote: Alex, I think I found the problem : -lfbclient can't find libfbclient.so I added /opt/fb3cs/lib to ldconfig.conf.d but it don't changes anything. Finally I changed the compile command to : $ LC_ALL=C g++ -Wall -I../firebird/src/include -o firetest -fPIC

Re: [Firebird-devel] The new Firebird OO API

2011-11-29 Thread Alex Peshkoff
On 11/29/11 12:23, Mark Rotteveel wrote: On Tue, 29 Nov 2011 11:19:27 +0400, Alex Peshkoff peshk...@mail.ru wrote: I think very strange to still have to build DPB by hand... Can you expose something that may give access to the ClumpletWriter to ease that ? Probably it's worth thinking about

Re: [Firebird-devel] Created: (CORE-3672) computed index by substring function for long columns

2011-11-29 Thread Alex Peshkoff
On 11/29/11 13:37, Adriano dos Santos Fernandes wrote: On 29/11/2011 05:49, Alex Peshkoff wrote: May be we can think about builting function like index_expr. That's just raw idea, but may be something like INDEX_EXPR(ALIAS.indexName) is better than This is up to the user to create

Re: [Firebird-devel] FB 3: Use cases for updating system tablesdirectly

2011-11-29 Thread Alex Peshkoff
On 11/30/11 02:42, Frank Ingermann wrote: DROP SOURCE OF [procedure name|trigger name|*] or CHANGE OWNER OF [db object|*] TO new_owner This approach looks much better than use of system package. -- All the data

Re: [Firebird-devel] soureforge.net

2011-11-29 Thread Alex Peshkoff
On 11/30/11 11:16, Dmitry Kuzmenko wrote: Hello, All! I'm sorry writing this question here, bit I have not access to firebird-admins. Is it normal that SF alway suggesting to download .Net driver? For example, when I open https://sourceforge.net/projects/firebird/ I see huge green

Re: [Firebird-devel] soureforge.net

2011-11-30 Thread Alex Peshkoff
On 11/30/11 12:33, Dmitry Yemanov wrote: 30.11.2011 12:24, Mark Rotteveel wrote: Is it able to discern between 32 and 64 bit? Unfortunately, not. On Windows Vista 64 bit (using Firefox 32 bit though) I get the suggestion to download the Firebird 32 bit package. This is the lesser evil.

Re: [Firebird-devel] FB 3: Use cases for updating system tables directly

2011-11-30 Thread Alex Peshkoff
On 11/30/11 14:39, Dimitry Sibiryakov wrote: 30.11.2011 9:08, Thomas Steinmaurer wrote: Or more object type bound, e.g.: ALTER TABLE ... CHANGE OWNER TO ... ALTER VIEW ... CHANGE OWNER TO ... etc.. ALTER PROCEDURE ... DROP SOURCE; I have no idea if the SQL standard suggests here

Re: [Firebird-devel] FB 3: Use cases for updating system tablesdirectly

2011-11-30 Thread Alex Peshkoff
On 11/30/11 13:50, Adriano dos Santos Fernandes wrote: On 30/11/2011 03:53, Alex Peshkoff wrote: On 11/30/11 02:42, Frank Ingermann wrote: DROP SOURCE OF [procedure name|trigger name|*] or CHANGE OWNER OF [db object|*] TOnew_owner This approach looks much better than use of system package

Re: [Firebird-devel] UDR triggers, identify transaction

2011-12-01 Thread Alex Peshkoff
On 12/01/11 14:34, Dimitry Sibiryakov wrote: Hello, All. Let's say I defined few UDR triggers and I need to keep rather big array of shared information bound to a transaction. What is the best (fastest) way to do it? If I have to organize my own storage, I need to identify the

Re: [Firebird-devel] The new Firebird OO API

2011-12-02 Thread Alex Peshkoff
On 12/02/11 11:26, Pierre Y. wrote: Hi, I advanced a bit more with this new API but I just absolutely don't see how to deal with FbMessage. What is it ? How do I have to use it to access (or send ?) data ? Thank you for your help, Regards, There is a way to create FbMessage, using boost

Re: [Firebird-devel] Database shutdown when udf raises an exception

2011-12-07 Thread Alex Peshkoff
On 12/05/11 04:23, Geoff Worboys wrote: So the power example would become: declare external function dPower double precision by descriptor, double precision by descriptor, double precision by descriptor, integer by descriptor returns parameter 3 returns exception 4 entry_point 'power'

Re: [Firebird-devel] Database shutdown when udf raises an exception

2011-12-07 Thread Alex Peshkoff
On 12/07/11 13:39, Adriano dos Santos Fernandes wrote: On 07/12/2011 07:31, Alex Peshkoff wrote: On 12/05/11 04:23, Geoff Worboys wrote: So the power example would become: declare external function dPower double precision by descriptor, double precision by descriptor, double precision

Re: [Firebird-devel] Database shutdown when udf raises an exception

2011-12-07 Thread Alex Peshkoff
On 12/07/11 14:54, Pierre Y. wrote: I expect the Delphi people will work on it. No way, I'm afraid. I'm quite good in Delphi, but I have no idea how to convert C++ classes to Delphi classes. I can help. I'm very interrested in seeing how to use the new Firebird OO API in Delphi. We

Re: [Firebird-devel] second embedded connect hangs on armel, ia64, kfreebsd and s390

2011-12-09 Thread Alex Peshkoff
On 12/08/11 22:33, Damyan Ivanov wrote: -=| Damyan Ivanov, 18.11.2011 21:27:26 +0200 |=- Maybe it's libedit interfering with libfbembed. I'll try the same thing using the perl driver and see if strace will give any hints. No luck. I wrote a primitive isql-like tool that is able to create

Re: [Firebird-devel] Using the Firebird 3.0 API with Delphi

2011-12-12 Thread Alex Peshkoff
On 12/12/11 15:43, Pierre Y. wrote: Hi All, Thanks to Vlad, we achieved the translation of the FB3 OO API in UIB Components for Delphi. You can checkout the code from SourceForge repository : https://uib.svn.sourceforge.net/svnroot/uib/trunk Now, we only miss hints to deal with

Re: [Firebird-devel] New API? What about protocol enhancements?

2011-12-15 Thread Alex Peshkoff
On 12/14/11 20:02, Carlos H. Cantu wrote: One year ago, when I was discussing this with Vlad, I did small Delphi app using ZeosDB components to measure speed between FB and MySQL similar databases with same data, hosted on remote computer and acessing by adsl connection. Results proved that

Re: [Firebird-devel] FB 3 still crashing when canceling TCS with Ctrl+C

2011-12-15 Thread Alex Peshkoff
(gdb) print *attachment Não é possível acessar a memória no endereço 0x732b9040 Does such dirty attachment arrive in any test or only in some specific? -- 10 Tips for Better Server Consolidation Server

Re: [Firebird-devel] New API? What about protocol enhancements?

2011-12-15 Thread Alex Peshkoff
On 12/15/11 15:54, Carlos H. Cantu wrote: Yes, but note that now my link is 20Mbits/s download: 1 *** Esgotado o tempo limite do pedido. 210 ms11 ms 7 ms bd232401.virtua.com.br [189.35.36.1] 3 8 ms11 ms11 ms bd07980b.virtua.com.br

Re: [Firebird-devel] New API? What about protocol enhancements?

2011-12-16 Thread Alex Peshkoff
On 12/16/11 14:39, Carlos H. Cantu wrote: AP With 14 nodes between client and server that's known that we have AP problems. We perform too many roundtrips between client and server AP compared with MySQL. Possible solutions are: AP - modify API to have big calls (like attach database, start

Re: [Firebird-devel] New API? What about protocol enhancements?

2011-12-16 Thread Alex Peshkoff
On 12/16/11 15:58, Carlos H. Cantu wrote: AP Hmm... AP Did we have it in FB3 roadmap? I doubt that. But afaik, FB 3 is not feature freeze yet ;) Certainly not. But there is Q1-2012 as alpha release date. If we do not plan to touch API, there are no big problems to change protocol before

Re: [Firebird-devel] New API? What about protocol enhancements?

2011-12-16 Thread Alex Peshkoff
On 12/16/11 16:45, Dimitry Sibiryakov wrote: 16.12.2011 13:40, Carlos H. Cantu wrote: there is plenty of time for testing. It is not actually about testing, but rather practical usability. API can work without any glitch, but don't provide some functions that are required for real

Re: [Firebird-devel] New API? What about protocol enhancements?

2011-12-16 Thread Alex Peshkoff
On 12/16/11 17:30, Adriano dos Santos Fernandes wrote: On 16/12/2011 11:25, Alex Peshkoff wrote: On 12/16/11 16:45, Dimitry Sibiryakov wrote: 16.12.2011 13:40, Carlos H. Cantu wrote: there is plenty of time for testing. It is not actually about testing, but rather practical usability

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

2011-12-19 Thread Alex Peshkoff
On 12/19/11 15:48, Tony Whyman wrote: I am responsible for some servers that are still running the LTS Release Ubuntu 8.04 and which I want to upgrade to Firebird 2.5.1, preferable using a Debian package rather than building each one from source - the production servers don't normally have

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

2011-12-19 Thread Alex Peshkoff
On 12/19/11 17:08, Tony Whyman wrote: Oops - a typo - meant kernel 2.6.24! glibc 2.7 is OK, what about kernel 2.4.24 - not sure, I've started development with 2.6.27 Does kernel 2.4 support NPTL correctly? That should be sooner of all OK. But telling true I'd prefer something newer - it's

Re: [Firebird-devel] Default setting for legacy secure plugin in firebird3

2011-12-19 Thread Alex Peshkoff
On 12/19/11 21:43, Dimitry Sibiryakov wrote: 19.12.2011 17:58, Alex Peshkoff wrote: but here security problem comes. User will not know, does he work with new server (using secure channel) or with old one (insecure channel). Make isc_attach_database() to return warning if insecure channel

Re: [Firebird-devel] Default setting for legacy secure plugin in firebird3

2011-12-19 Thread Alex Peshkoff
On 12/19/11 21:43, Dimitry Sibiryakov wrote: 19.12.2011 17:58, Alex Peshkoff wrote: but here security problem comes. User will not know, does he work with new server (using secure channel) or with old one (insecure channel). Make isc_attach_database() to return warning if insecure channel

Re: [Firebird-devel] Default setting for legacy secure plugin in firebird3

2011-12-20 Thread Alex Peshkoff
On 12/20/11 14:06, Dimitry Sibiryakov wrote: 20.12.2011 7:30, Alex Peshkoff wrote: Returning to that useful idea - the problem is that when the warning can be returned password was already passed to the net in legacy unsafe form. But here you are saying that legacy form is unsafe. AFAIR

Re: [Firebird-devel] Default setting for legacy secure plugin in firebird3

2011-12-20 Thread Alex Peshkoff
On 12/20/11 14:19, Dimitry Sibiryakov wrote: 20.12.2011 11:16, Dmitry Yemanov wrote: The new auth protocol will not truncate the longer password but the legacy one will, AFAIU. In this case there is no security breath: if a malefactor has got truncated password by bruteforcing legacy

Re: [Firebird-devel] Default setting for legacy secure plugin in firebird3

2011-12-20 Thread Alex Peshkoff
On 12/20/11 14:38, Adriano dos Santos Fernandes wrote: On 20/12/2011 08:19, Alex Peshkoff wrote: On 12/20/11 13:54, Adriano dos Santos Fernandes wrote: On 20/12/2011 06:57, Alex Peshkoff wrote: connect: client's public key, login and database name = server accept: server's public key

[Firebird-devel] Initializing security database for first use

2011-12-20 Thread Alex Peshkoff
Till today we always used to provide security database pre-configured for use with single record for SYSDBA with masterke(y) password. In FB3 we have at least two reasons to stop use that schema: - having masterkey as default preset-ted SYSDBA's password is security vulnerability cause people are

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

2011-12-20 Thread Alex Peshkoff
On 12/20/11 17:26, Adriano dos Santos Fernandes wrote: On 20/12/2011 11:20, Alex Peshkoff wrote: I wonder is it possible to change windows installer to initialize security database. Next, for ZIP install people will have to run gsec first time manually. Are this changes OK for us? I don't

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

2011-12-21 Thread Alex Peshkoff
On 12/20/11 22:04, Dmitry Yemanov wrote: 20.12.2011 18:22, Paul Reeves wrote: o Add a checkbox that allows a user to keep SYSDBA/masterkey. Default will be unchecked. If unchecked then next screen will ask user to enter new password. This gets my vote. Just one idea. May be not

  1   2   3   4   5   6   7   8   9   10   >