[Firebird-devel] [FB-Tracker] Created: (CORE-3704) add new context variables in USER_TRANSACTION namespace
add new context variables in USER_TRANSACTION namespace --- Key: CORE-3704 URL: http://tracker.firebirdsql.org/browse/CORE-3704 Project: Firebird Core Issue Type: Improvement Reporter: Pavel Zotov it will be useful to get information within current transaction about itself, i.e. it's READ_ONLY, ISOLATION_MODE, LOCK_TIMEOUT and was it run as AUTONOMOUS or as 'normal'. Currently we can get such info only via MON$-tables but this way lead to poor performance in high-loaded systems. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira -- Write once. Port to many. Get the SDK and tools to simplify cross-platform app development. Create new or port existing apps to sell to consumers worldwide. Explore the Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join http://p.sf.net/sfu/intel-appdev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-3705) create MON$ table to get info about GARBAGE COLLECT that currently performs in CS/SC by sessions or sweep.
create MON$ table to get info about GARBAGE COLLECT that currently performs in CS/SC by sessions or sweep. -- Key: CORE-3705 URL: http://tracker.firebirdsql.org/browse/CORE-3705 Project: Firebird Core Issue Type: Improvement Reporter: Pavel Zotov Event of GC (if this is not sweep process) can be detected only by analyzing of trace log. Is it possible to create mon$-table that contain data about attachment(s) that are doing GC at the moment of selection such MON$-table ? -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira -- Write once. Port to many. Get the SDK and tools to simplify cross-platform app development. Create new or port existing apps to sell to consumers worldwide. Explore the Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join http://p.sf.net/sfu/intel-appdev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Initializing security database for first use
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 check box, but radio box with 3 choices - keep masterkey, ask user for password and generate random password (which will be saved into file $FbRoot/SYSDBA.password). Last method is used in silent linux install, and people fill OK with it. Certainly I'm not going to insist, that's not more than suggestion. BTW, will the default be masterkey or masterke? That's different things now. -- Write once. Port to many. Get the SDK and tools to simplify cross-platform app development. Create new or port existing apps to sell to consumers worldwide. Explore the Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join http://p.sf.net/sfu/intel-appdev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Initializing security database for first use
On 12/20/11 18:31, Paul Reeves wrote: On Tuesday 20 December 2011 at 14:20 Alex Peshkoff wrote: Next, for ZIP install people will have to run gsec first time manually. That is not desirable. In fact when I wrote my previous reply I was just thinking about the UI of the installer. Once the information has been collected the installer would need to actually initialise the security database. The best way to do this would be to provide a batch file that takes the uname and pw as params. That way the zip package can share the same mechanism. Writing batch file is not a problem. But I do not know why is it needed when all what you need is to gsec -add sysdba -pw %new_password% -- Write once. Port to many. Get the SDK and tools to simplify cross-platform app development. Create new or port existing apps to sell to consumers worldwide. Explore the Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join http://p.sf.net/sfu/intel-appdev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] cryptdb
For information : http://css.csail.mit.edu/cryptdb/ http://dspace.mit.edu/handle/1721.1/60876 From the front page : Online applications are vulnerable to theft of sensitive information because adversaries can exploit software bugs to gain access to private data, and because curious or malicious administrators may capture and leak data. CryptDB is a system that provides practical and provable confidentiality in the face of these attacks for applications backed by SQL databases. It works by executing SQL queries over encrypted data using a collection of efficient SQL-aware encryption schemes. CryptDB can also chain encryption keys to user passwords, so that a data item can be decrypted only by using the password of one of the users with access to that data. As a result, a database administrator never gets access to decrypted data, and even if all servers are compromised, an adversary cannot decrypt the data of any user who is not logged in. An analysis of a trace of 126 million SQL queries from a production MySQL server shows that CryptDB can support operations over encrypted data for 99.5% of the 128,840 columns seen in the trace. Our evaluation shows that CryptDB has low overhead, reducing throughput by 14.5% for phpBB, a web forum application, and by 26% for queries from TPC-C, compared to unmodified MySQL. Chaining encryption keys to user passwords requires 11-13 unique schema annotations to secure more than 20 sensitive fields and 2-7 lines of source code changes for three multi-user web applications. -- Write once. Port to many. Get the SDK and tools to simplify cross-platform app development. Create new or port existing apps to sell to consumers worldwide. Explore the Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join http://p.sf.net/sfu/intel-appdev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Initializing security database for first use
On Wednesday 21 December 2011 at 12:29 Alex Peshkoff wrote: Writing batch file is not a problem. But I do not know why is it needed when all what you need is to gsec -add sysdba -pw %new_password% Don't forget we are talking about windows users here :-) (g,d r). A lot of them 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 -- Write once. Port to many. Get the SDK and tools to simplify cross-platform app development. Create new or port existing apps to sell to consumers worldwide. Explore the Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join http://p.sf.net/sfu/intel-appdev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Initializing security database for first use
On 12/21/11 15:51, Paul Reeves wrote: On Wednesday 21 December 2011 at 12:29 Alex Peshkoff wrote: Writing batch file is not a problem. But I do not know why is it needed when all what you need is to gsec -add sysdba -pw %new_password% Don't forget we are talking about windows users here :-) (g,d r). A lot of them 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. As far as I understand in case of high-level GUI installer that command will be invoked by installer itself. And what about ZIP - may I ask, how does it work now? I've thought that people at least need to register themselves windows service after opening archive. Am I wrong? -- Write once. Port to many. Get the SDK and tools to simplify cross-platform app development. Create new or port existing apps to sell to consumers worldwide. Explore the Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join http://p.sf.net/sfu/intel-appdev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Initializing security database for first use
21.12.2011 12:59, Alex Peshkoff wrote: And what about ZIP - may I ask, how does it work now? I've thought that people at least need to register themselves windows service after opening archive. Am I wrong? For regular users - no, but developers used to use FB server in application mode. -- SY, SD. -- Write once. Port to many. Get the SDK and tools to simplify cross-platform app development. Create new or port existing apps to sell to consumers worldwide. Explore the Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join http://p.sf.net/sfu/intel-appdev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Initializing security database for first use
On 12/21/11 16:02, Dimitry Sibiryakov wrote: 21.12.2011 12:59, Alex Peshkoff wrote: And what about ZIP - may I ask, how does it work now? I've thought that people at least need to register themselves windows service after opening archive. Am I wrong? For regular users - no, but developers used to use FB server in application mode. Sorry - may be my question was not enough precise. Does our zip archive contains something (batch file) that helps with further install after unzipping files? -- Write once. Port to many. Get the SDK and tools to simplify cross-platform app development. Create new or port existing apps to sell to consumers worldwide. Explore the Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join http://p.sf.net/sfu/intel-appdev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Initializing security database for first use
Alex Peshkoff [2011-12-21 13:07] : Sorry - may be my question was not enough precise. Does our zip archive contains something (batch file) that helps with further install after unzipping files? yes https://firebird.svn.sourceforge.net/svnroot/firebird/firebird/branches/B2_5_Release/builds/install/arch-specific/win32/ install_classic.bat install_super.bat install_superclassic.bat -- Write once. Port to many. Get the SDK and tools to simplify cross-platform app development. Create new or port existing apps to sell to consumers worldwide. Explore the Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join http://p.sf.net/sfu/intel-appdev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Initializing security database for first use
On Wednesday 21 December 2011 at 12:26 Alex Peshkoff wrote: Just one idea. May be not check box, but radio box with 3 choices That is a possibility. I think the final decision will depend partly on the architecture of innosetup and the logic of the order of the screens. BTW, will the default be masterkey or masterke? That's different things now. Are you saying that if the default is set to masterke and the user types masterkey that the login will fail? And the same with typing masterke when the password is masterkey? If that is a case we might have some very confused users. 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://www.ibphoenix.com Specialists in Firebird support -- Write once. Port to many. Get the SDK and tools to simplify cross-platform app development. Create new or port existing apps to sell to consumers worldwide. Explore the Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join http://p.sf.net/sfu/intel-appdev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (PYFB-9) Support for streamed BLOBs
Support for streamed BLOBs -- Key: PYFB-9 URL: http://tracker.firebirdsql.org/browse/PYFB-9 Project: Firebird driver for Python Issue Type: New Feature Reporter: Pavel Cisar Assignee: Pavel Cisar -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira -- Write once. Port to many. Get the SDK and tools to simplify cross-platform app development. Create new or port existing apps to sell to consumers worldwide. Explore the Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join http://p.sf.net/sfu/intel-appdev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (PYFB-11) Support for Firebird ARRAY datatype
Support for Firebird ARRAY datatype --- Key: PYFB-11 URL: http://tracker.firebirdsql.org/browse/PYFB-11 Project: Firebird driver for Python Issue Type: New Feature Reporter: Pavel Cisar Assignee: Pavel Cisar Priority: Minor Should be interface-compatible to KInterbasDB's implementation. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira -- Write once. Port to many. Get the SDK and tools to simplify cross-platform app development. Create new or port existing apps to sell to consumers worldwide. Explore the Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join http://p.sf.net/sfu/intel-appdev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (PYFB-8) Support for Firebird EVENTS
Support for Firebird EVENTS --- Key: PYFB-8 URL: http://tracker.firebirdsql.org/browse/PYFB-8 Project: Firebird driver for Python Issue Type: New Feature Reporter: Pavel Cisar Assignee: Pavel Cisar Should be interface-compatible to KInterbasDB's implementation.. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira -- Write once. Port to many. Get the SDK and tools to simplify cross-platform app development. Create new or port existing apps to sell to consumers worldwide. Explore the Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join http://p.sf.net/sfu/intel-appdev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (PYFB-12) Support for Trace Service
Support for Trace Service - Key: PYFB-12 URL: http://tracker.firebirdsql.org/browse/PYFB-12 Project: Firebird driver for Python Issue Type: Improvement Reporter: Pavel Cisar Assignee: Pavel Cisar -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira -- Write once. Port to many. Get the SDK and tools to simplify cross-platform app development. Create new or port existing apps to sell to consumers worldwide. Explore the Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join http://p.sf.net/sfu/intel-appdev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] New API? What about protocol enhancements?
I ran more tests tonight, and results were very different from the past year test. FIRST TEST (using the same server as last year test) == Last year test: Firebird 2.1.1 (SuperServer - linux) in server and FB 2.1.x Windows in client Tonight test: Firebird 2.5.1 client, and same remote server as last year First run used TcpRemoteBufferSize = 8K (the default), and second run used TcpRemoteBufferSize = 32767 at client. I can't change fb.conf at this server. No difference in the fetchall time! SECOND TEST === Another test, this time connecting to one of my customers server, internet connection by cable modem. Server is 2.5.1 (SuperClassic Linux) and Client is 2.5.1 (Windows). Access by OpenVPN. As I have root access to this server, I was able to change the value of TcpRemoteBufferSize in the server and, of course, in the client. I tested: Server x Client 8K 8K 8K 16K 8K 32K 32K 8K 32K 32K The fetch times were almost identical in all the above configurations :( The number of records returned was about 3.500, and average time was about 11 seconds. I restarted the server after every change at (remote) fb.conf. I also ran the select 2 times before getting the fetchall times, the first run was just to fill FB and disk cache. Is there any chance that FB 2.5.1 is ignoring this parameter? How to explain such different behavior compared to the last year test (FB 2.1) ? PS: Last year test I used ZeosDB app as I wish to compare MySQL to FB. Tonight test I used tool built with FIBPlus. Also, the database used this time was not the same as the last year. Anyway, this doesn't matter, since what is being questioned is the fact that this time, the parameter changing didn't make any difference in the featchall time. I'm also trusting that on Windows, the client library will use the fb.conf located at the directory pointed in the FB registry key. []s Carlos http://www.firebirdnews.org FireBase - http://www.FireBase.com.br DY 14.12.2011 20:02, Carlos H. Cantu wrote: Vlad, 06/12/2010 16:24:51: could you edit firebird.conf at both client and server hosts and set TcpRemoteBufferSize = 32700 ? ok, much better (but still worse than MySQL): [06/12/2010 16:27:47] Opening FB Query and fetching all data () [06/12/2010 16:27:53] End fetching FB data (6,312) [06/12/2010 16:27:53] Opening MySQL Query and fetching all data () [06/12/2010 16:27:56] End fetching MySQL data (2,89) DY This implicitly suggests that a bigger value of the network packet could DY improve the performance even more, perhaps down to the MySQL's almost DY three seconds. DY AFAIK, the default packet size in MySQL is 1MB, the maximum is 1GB. Our DY default is 8KB and maximum is 16KB. DY I would suggest to increase the default and remove the upper limit (or DY make it big enough) and then ask Carlos to re-run the same test with DY bigger settings (64KB, 128KB and so on) and report back the results. DY Dmitry -- Write once. Port to many. Get the SDK and tools to simplify cross-platform app development. Create new or port existing apps to sell to consumers worldwide. Explore the Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join http://p.sf.net/sfu/intel-appdev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
