Re: [firebird-support] Transaction in limbo

2016-07-19 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
19.07.2016 13:33, michael.vilhelm...@microcom.dk [firebird-support] wrote: > I have total access to the code :) > I wrote all of it. But you cannot be sure that they use only your software. -- WBR, SD.

Re: [firebird-support] Transaction in limbo

2016-07-19 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
19.07.2016 12:14, michael.vilhelm...@microcom.dk [firebird-support] wrote: > As I read about 2 phase commits, its about 2 databases. We do not use more > than one There is no other way to get transaction in limbo. -- WBR, SD.

Re: [firebird-support] gfix -shut ? server-klient

2016-07-20 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
19.07.2016 18:44, 'maciej...@gmail.com' maciej...@gmail.com [firebird-support] wrote: > What command to use before taking any remedial action on the database > Firebird to > disconnect a user SYSDBA (client)? You cannot block SYSDBA. Stop using it for ordinary connections. -- WBR, SD.

Re: [firebird-support] Firebird - errors logs

2016-07-20 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
20.07.2016 15:56, 'maciej...@gmail.com' maciej...@gmail.com [firebird-support] wrote: > What could be causing these errors firebird server. I noticed that errors > occur when you > start the second computer (client) ?

Re: [firebird-support] Firebird - errors logs

2016-07-20 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
20.07.2016 17:56, 'maciej...@gmail.com' maciej...@gmail.com [firebird-support] wrote: > The problem is that the server is still working. The last message in your log is telling something different: server was started much later than client had tried to connect. -- WBR, SD.

Re: [firebird-support] Triggers on table MON$ATTACHMENTS

2016-07-12 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
12.07.2016 21:17, 'Ismael L. Donis Garcia' sli...@citricos.co.cu [firebird-support] wrote: > I can create triggers in the MON$ATTACHMENTS table? No, you cannot. -- WBR, SD.

Re: [firebird-support] FDR file in Firebird folder

2016-06-28 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
28.06.2016 20:28, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > My thought as well, but I just want to make sure it isn't some sort of > temporary file or something else ;) Firebird don't use .FDR extension for any internal file. -- WBR, SD.

Re: [firebird-support] FDR file in Firebird folder

2016-06-28 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
28.06.2016 19:46, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > I've never heard of such a file, does anyone have an idea what it could be? I would bet on a database. -- WBR, SD.

Re: [firebird-support] (unknown)

2016-06-29 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
29.06.2016 10:28, Якушев Евгений annino...@yandex.ru [firebird-support] wrote: > So here is the question: is it a Firebird bug or something wrong with the > windows server? > Unfortunatelly we have not found any usefull sollution on the web. http://www.ibase.ru/keepalive/ -- WBR, SD.

Re: [firebird-support] Re: Simple create or alter procedure on Firebrid 3.0 creates "unsuccessful execution caused by system error that precludes successful execution of subsequent statements"

2016-07-07 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
07.07.2016 9:57, jonatan.laurit...@yahoo.dk [firebird-support] wrote: > OK. After Firebird 64 bit installation it was necessary to make Firebird32 > bit client > installation and with Firebird 3.0 32bit fbclient.dll/gds32.dll this > statement can be > executed normally. Execution of

Re: [firebird-support] gstat output about blobs - blob pages 0

2016-07-09 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
08.07.2016 15:41, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: > Blobs: 1976786, total length: 37039763, blob pages: 0 > Level 0: 1976786, All BLOBs are level 0, they are kept on data pages with other record data. No separate BLOB pages. -- WBR, SD.

Re: [firebird-support] Unable to backup production database with gbak and SuperServer 3

2016-07-04 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
04.07.2016 14:31, Köditz, Martin martin.koed...@it-syn.de [firebird-support] wrote: > Is there a restriction with backup on SuperServer? No, unless you are trying to do backup in embedded mode (what exactly you do). -- WBR, SD.

Re: [firebird-support] Migrating a 2.5 server

2017-02-07 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
07.02.2017 9:14, Luke Crooks l...@solentwholesale.com [firebird-support] wrote: > When running the 2.5 server on our Windows DC and having clients access from > the local > network, performance was very slow (almost unusable). System HDD on DC has write cache forcefully disabled. Put database

Re: [firebird-support] Re: Character set of parameter strings

2017-02-07 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
07.02.2017 3:51, Dmitry Yemanov dim...@users.sourceforge.net [firebird-support] wrote: > can be overridden by API user) That's exactly what I wanted to know, thanks. -- WBR, SD.

[firebird-support] Character set of parameter strings

2017-02-06 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
Hello, All. When a string is sent to server via a query parameter, how is its character set determined: from XSQLVAR.sqlsubtype field or from connection's lc_ctype parameter? -- WBR, SD.

Re: [firebird-support] firebird schema changes during backup

2017-01-23 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
23.01.2017 21:36, Helen Borrie hele...@iinet.net.au [firebird-support] wrote: > For all that, I don't think it is a good idea to be changing metadata > during a backup. Changing metadata is a bad idea in general. Continuous development is the worst thing that can happen to a database. --

Re: [firebird-support] Re: firebird schema changes during backup

2017-01-24 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
24.01.2017 13:47, kragh.tho...@yahoo.com [firebird-support] wrote: > To be clear when the change scripts is applied to production they have been > tested on our > CI server and in our pre-prod environment. > We have been using this way of updating our schema for a few years now and it > works

Re: [firebird-support] Re: firebird schema changes during backup

2017-01-24 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
24.01.2017 21:21, kragh.tho...@yahoo.com [firebird-support] wrote: > could you please elaborate on your point of view? > > What can go wrong during this kind of operation? Upgrade script may fail and you database will end up in half-upgraded state. It could be simpler to restore fresh-made

Re: [firebird-support] Re: How to get a list of columns from another select

2017-01-26 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
26.01.2017 0:23, jorg...@yahoo.com [firebird-support] wrote: > How to prepare sentence in Firebird 2.5? It depends on what API you use to access Firebird 2.5. In native ISC API it is done by isc_dsql_prepare() call. -- WBR, SD.

Re: [firebird-support] Re: Firebird 2.5 service turned off but client application is still working.

2017-01-20 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
20.01.2017 14:44, brucedickin...@wp.pl [firebird-support] wrote: > what is listener responsible for? Only for spawning new processes? In Classic architecture - yes. -- WBR, SD.

Re: [firebird-support] How to get a list of columns from another select

2017-01-25 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
25.01.2017 19:53, jorg...@yahoo.com [firebird-support] wrote: > I do not want the query results, I want the names of the columns. Don't execute the query then, just prepare it. -- WBR, SD.

Re: [firebird-support] Firebird web hosting ASP.NET Core

2017-02-17 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
17.02.2017 20:36, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > Our clients ask for mobile/web access of our app,in this case we decided to > rewrite app > with Asp Core.What options are for hosting firebird with asp core? VPS or your own server. -- WBR, SD.

[firebird-support] Partial update

2017-02-13 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
Hello, All. If I use prepared statement like this "update table set field1=?, field2=? where field3=?" for performance reasons, is there a way to update only some fields and leave other untouched without overhead of building separate queries on the fly or selecting old values with

Re: [firebird-support] FIREBIRD PIVOT function or Matrix

2017-02-14 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
14.02.2017 16:31, 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] wrote: > There are times when I would love to be able to pivot data on the server, to > further > process the data an SP. SP cannot process queries with unknown number of fields. Neither client part, BTW. > Also,

Re: [firebird-support] Partial update

2017-02-14 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
14.02.2017 16:21, 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] wrote: > If you are using UPDATE, then is it not reasonable to expect that you would > know what the > original values for of each field? It is not reasonable: I have no way to know them. All I have at hand is new

Re: [firebird-support] FIREBIRD PIVOT function or Matrix

2017-02-14 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
14.02.2017 14:15, 'Stef' s...@autotech.co.za [firebird-support] wrote: > Any suggestions on my DB design and query to display the values in matrix > (pivot) format? Simple client-side code can show you the matrix in any convenient form. There is no point to do that on server. -- WBR,

Re: [firebird-support] Syntax for system environment variables in firebird.conf

2017-01-17 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
17.01.2017 11:52, Arno Peter pe...@jam-software.com [firebird-support] wrote: > Does anyone know how to use Windows environment variables in the > firebird.conf? Currently there is no way to. -- WBR, SD.

Re: [firebird-support] Firebird 2.5 service turned off but client application is still working.

2017-01-20 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
20.01.2017 14:20, brucedickin...@wp.pl [firebird-support] wrote: > Is this a by design behaviour? Yes. Stopping service you only stop listener, working processes still work. -- WBR, SD.

Re: [firebird-support] Firebird 2.5 classic performance issue on linux64

2017-02-26 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
26.02.2017 21:07, Andreas Zeller zel...@lux-medien.com [firebird-support] wrote: > I am still curious about how this might affect performance? Did you monitor resource usage? CPU, RAM, IO? -- WBR, SD.

Re: [firebird-support] Firebird 2.5 classic performance issue on linux64

2017-02-26 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
26.02.2017 12:55, Andreas Zeller zel...@lux-medien.com [firebird-support] wrote: > I encountered a bit of trouble migrating a firebird server from an > ancient w2k SBS to a powerful debian-based DL380 server. > > I'll share my story, so people facing the same problems can scratch > things off

Re: [firebird-support] deploy Windows Application to access Firebird database

2016-08-22 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
22.08.2016 18:26, Alain Bastien alainbast...@gmail.com [firebird-support] wrote: > What;s requred for the Windows app to access a remote Firebird database ? > The minimal installation Run installer, choose "Minimum client install". -- WBR, SD.

Re: [firebird-support] Server crash - guardian restarts permanently

2016-08-25 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
25.08.2016 13:29, Köditz, Martin martin.koed...@it-syn.de [firebird-support] wrote: > So what can I do? First of all - uprgade to current snapshot. -- WBR, SD.

Re: [firebird-support] Server crash - guardian restarts permanently

2016-08-25 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
25.08.2016 14:20, Köditz, Martin martin.koed...@it-syn.de [firebird-support] wrote: > I’ve updated to 3.0.1.32570 x64. Used the OpenSuse repositories. Current snapshot is 32583: http://web.firebirdsql.org/download/snapshot_builds/linux/fb3.0/ > Still the same problem. Seems there is

Re: [firebird-support] How to show current LINGER interval?

2016-09-02 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
02.09.2016 9:57, Köditz, Martin martin.koed...@it-syn.de [firebird-support] wrote: > how can I see the current interval of Firebird’s LINGER option? gstat -h -- WBR, SD.

Re: [firebird-support] Re: Problems after FB3 upgrade

2016-09-07 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
07.09.2016 14:23, fabia...@itbizolutions.com.au [firebird-support] wrote: > Would you recommend installing the latest snapshot, or stay with the released > FB3 version? Yes, use snapshot. > would like to avoid getting my customer into shaky watters Why to jump to a new version at once

Re: [firebird-support] Re: Problems after FB3 upgrade

2016-09-07 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
07.09.2016 11:38, Tony Christiansen t...@adegroup.com.au [firebird-support] wrote: > I cannot find any info on doing a manual install to upgrade to the latest > snapshot of FB3 > on Windows. Just stop Firebird and unpack the archive over existing installation overwriting everything except

Re: [firebird-support] Optimizer request

2016-09-09 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
09.09.2016 14:30, 'Djordje Radovanovic' softsis...@sbb.rs [firebird-support] wrote: > I tried query with subquery in where clause and found big issue for this type > of subquery. That's why using of JOIN instead of IN is recommended whenever possible. -- WBR, SD.

Re: [firebird-support] Optimizer request

2016-09-11 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
11.09.2016 18:39, 'Djordje Radovanovic' softsis...@sbb.rs [firebird-support] wrote: > maybe to teach me how to ask this > kind of question to not bother you with my wrong style. That's exactly what I wrote: whenever you ask for help with SQL queries, post the plan of the queries, not just

Re: [firebird-support] PHP PDO fetch from insert... into... or from stored procedure without suspend clause? Is it possible?

2016-09-12 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
12.09.2016 12:19, jonatan.laurit...@yahoo.dk [firebird-support] wrote: > Is is possible to execute insert... into... and fetch result at all with > Firebird? No. "insert into returning" produce singleton result, not result set. You must threat it the same way as "execute procedure"

Re: [firebird-support] "File Database is not found" error appears while the database is been backup with gbak

2016-09-10 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
10.09.2016 17:10, fabia...@itbizolutions.com.au [firebird-support] wrote: > what can I do to run a 24x7 system and have backups every so often without > shutting down > the system for a few minutes? Don't ever use embedded connection with superserver mode in firebird.conf. -- WBR, SD.

Re: [firebird-support] Include isql command line utility along with my application

2016-09-14 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
14.09.2016 7:36, John Tsioumpris ts.gian...@hotmail.com [firebird-support] wrote: > For various tasks like Database creation i need the *isql *command line > utility so it > would be great if i could include a copy of *isql *along with my Application . MS ACCESS cannot execute "create

Re: [firebird-support] Optimizer request

2016-09-13 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
13.09.2016 12:23, 'Djordje Radovanovic' softsis...@sbb.rs [firebird-support] wrote: > according to your plan I need to switch to firebird 3 as soon as possible. You must check that index on partners.country is active and its statistic is fresh. I also hope that less than 60% of partners are

Re: [firebird-support] Speed of comparing one field to another

2016-09-13 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
13.09.2016 15:26, Maya Opperman m...@omniaccounts.co.za [firebird-support] wrote: > Is there an index I could create to speed up the loading? No. -- WBR, SD.

Re: [firebird-support] Problem querying MON$STATEMENTS table

2016-09-16 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
16.09.2016 8:02, 'Gregor Kobler' g...@gksoft.ch [firebird-support] wrote: > When you querying the MON$STATEMENTS table, the active statements are not > shows a > transaction-id and not a timestamp, These columns are allwas Zero / NULL! Can you prepare isql script that demonstrate the problem?

Re: [firebird-support] Connection pool, trigger and binnacle

2016-09-09 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
09.09.2016 22:48, Carlos Mazariegos carlos.mazarie...@umg.edu.gt [firebird-support] wrote: > There a way to pass the user triggers firebird to recognize them or some > other idea to solve > the problem. Use RDB$SET_CONTEXT() in your web-application and RDB$GET_CONTEXT() in trigger. --

Re: [firebird-support] Optimizer request

2016-09-11 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
11.09.2016 10:29, 'Djordje Radovanovic' softsis...@sbb.rs [firebird-support] wrote: > This time instead of 1 reads of orders and 1 reads of partners I > received exactly > what I was asking for. You'd move to desired result faster if instead of useless stats showed plans of the

Re: [firebird-support] Vulnerability

2016-09-24 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
24.09.2016 18:53, carlosemazarieg...@gmail.com [firebird-support] wrote: > I have problems with firebird Vulnerability, Palo Alto reports the following > error: > > Borland Interbase Database Message Handling Bufer Overflow Vulnerability. Interbase is not Firebird. Firebird is not Interbase.

Re: [firebird-support] High number of NULL attachments

2016-10-04 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
04.10.2016 11:38, 'Tom' tom...@vp44.net [firebird-support] wrote: > fbclient.dll is bundled with the client application. Check client version to be outdated, because PID and process name is reported by client library. -- WBR, SD.

Re: [firebird-support] Firebird 2.5 Linux Red Hat 7 - Permission denied

2016-10-07 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
07.10.2016 17:07, duque.herna...@yahoo.com [firebird-support] wrote: > I can only read databases located on /var/lib/firebird/data. Make sure that you use TCP/IP connection string (localhost:/whatever). -- WBR, SD.

Re: [firebird-support] Re: Firebird 2.5 Linux Red Hat 7 - Permission denied

2016-10-08 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
08.10.2016 17:24, duque.herna...@yahoo.com [firebird-support] wrote: > I'm using this command: > > ./isql -user sysdba -pass masterkey localhost:/data/med6/fdb/mydatabase.fdb > > and get the "Permission denied" Check "ls -a" for every directory on the path and make sure that user account

Re: [firebird-support] large fb_table files

2016-10-07 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
07.10.2016 13:12, r.terschlue...@probat.com [firebird-support] wrote: > If we close the connection, the memory of the file will not be released. Most likely you closed wrong connection, not the one which the table belongs to. -- WBR, SD.

Re: [firebird-support] large fb_table files

2016-10-07 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
07.10.2016 10:40, r.terschlue...@probat.com [firebird-support] wrote: > What could be the reason, that the file is still growing? Inserting more records into a temporary table. > What are we doing wrong? Perhaps, you use GTT with on commit preserve rows in very long connection. --

Re: [firebird-support] High number of NULL attachments

2016-10-05 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
05.10.2016 20:13, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > Could you please stop posting responses like "Perfect", "Thanks" and > "Great, Thanks!", "Hello", etc. It is unnecessary filler that doesn't > contribute anything to the mailing list This is just a stupid

Re: [firebird-support] Re: internal Firebird consistency check (decompression overran buffer (179), file: sqz.cpp line: 239)

2016-10-10 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
10.10.2016 14:45, n6auei4hz6ypittow3d2xkak432y2oszb2gth...@yahoo.com [firebird-support] wrote: > In parallel we were also doing nbackup at some other f ixed times, which is > also through > the server. Stop doing it for a while and see if it makes a difference. -- WBR, SD.

Re: [firebird-support] FB3 returning clause and new API

2016-09-15 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
15.09.2016 7:56, Martin Schreiber mse00...@gmail.com [firebird-support] wrote: > How the values of a returning clause can be fetched with OOP-API? Use IAttachment::execute() for single execution of queries without parameters and IStatement::execute() for the rest. -- WBR, SD.

Re: [firebird-support] FB3 returning clause and new API

2016-09-15 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
15.09.2016 10:16, Martin Schreiber mse00...@gmail.com [firebird-support] wrote: > And then how to get the data? Last two parameter of the methods is an output message where output data is returned in. -- WBR, SD.

Re: [firebird-support] GBAk - Restoring only data

2016-09-21 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
21.09.2016 15:51, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: > Using gbak, Is it possible restoring only data into an existing > database. No, not with gbak. IBBackupSurgeon can do that: http://ib-aid.com/en/ibbackupsurgeon/ -- WBR, SD.

Re: [firebird-support] FB3 returning clause and new API

2016-09-15 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
15.09.2016 11:14, Martin Schreiber mse00...@gmail.com [firebird-support] wrote: > What if one wants to use > IAttachment.execute() where no IStatement is available? (S)he must provide IMetadata built with builder. -- WBR, SD.

Re: [firebird-support] Re: AW: Problem querying MON$STATEMENTS table

2016-09-19 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
19.09.2016 10:45, 'Gregor Kobler' g...@gksoft.ch [firebird-support] wrote: > When i monitor the MON$STATEMENTS table for a while, i didn’t see a state 1 > on any statemens. In single connection workload you won't see any active statements except the current one. -- WBR, SD.

Re: [firebird-support] After update trigger: the same values for new.somefiled and old.somefield

2016-08-27 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
27.08.2016 12:04, patrick_mar...@yahoo.com [firebird-support] wrote: > For some reason they both have the new value and I can't figure out why. Use "IS DISTINCT" instead of "<>". -- WBR, SD.

Re: [firebird-support] Re: After update trigger: the same values for new.somefiled and old.somefield

2016-08-29 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
29.08.2016 10:24, patrick_mar...@yahoo.com [firebird-support] wrote: > Somehow I've thought that an after update trigger only fires once when all > the changes > have been made and comitted. DML triggers are fired on every change of every record. -- WBR, SD.

Re: [firebird-support] Vulnerability

2016-09-27 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
27.09.2016 20:01, Carlos Mazariegos carlosemazarieg...@gmail.com [firebird-support] wrote: > The vulnerability that reported Palo Alto is: "Borland Interbase 2007 Packet Processing Buffer Overflow". Firebird is not Interbase. Do you have a relevant exploit? -- WBR, SD.

Re: [firebird-support] Number of concurrent user connections

2016-10-27 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
27.10.2016 13:48, Alain Bastien alainbast...@gmail.com [firebird-support] wrote: > How many concurrent users can connect to a FireBird database on a Windows > 2003 Std Server > (Pentium III 666Mhz) 2GB RAM ? 1024. -- WBR, SD.

Re: [firebird-support] Number of concurrent user connections

2016-10-29 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
29.10.2016 13:25, Alain Bastien alainbast...@gmail.com [firebird-support] wrote: > WEB application uses a BROWSER that's all No, they don't. Web-applications are executed on web-server. There is no browser on server. -- WBR, SD.

Re: [firebird-support] Number of concurrent user connections

2016-10-29 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
29.10.2016 18:40, Alain Bastien alainbast...@gmail.com [firebird-support] wrote: > I meant client access the (information/Data/Database) Server with a Browser The only protocols supported by browsers are HTTP and FTP. No DBMS can they talk with. -- WBR, SD.

Re: [firebird-support] Trusted authentication for Firebird 2.5 where domain controller and db server are not the same

2016-11-08 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
08.11.2016 10:39, 4j4bogta5o632ee44vvxxvlxfxt6jxbx7ch2x...@yahoo.com [firebird-support] wrote: > Is this possible with FB2.5? If yes how could I do this? All three computers must be in one domain and user must be logged into this domain on the client computer. -- WBR, SD.

Re: [firebird-support] change /tmp/firebird lock dir default value

2016-10-14 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
14.10.2016 5:45, Juan Enrique Ortuzar Elton jeortuz...@editrade.cl [firebird-support] wrote: > How I can change the "lock dir” default value "/tmp/firebird”? Set environment variable FIREBIRD_LOCK. -- WBR, SD.

Re: [firebird-support] How to estimate free space inside database file

2016-10-25 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
25.10.2016 19:03, Bryan Cole bryan.c...@teraview.com [firebird-support] wrote: > > I am trying to figure out the amount of free space within my database, so > that I can > detect when I'm nearing exhausting the disk space. I'm using firebird-v2.5.2. Look at DBInfo:

Re: [firebird-support] Re: Best way to delete millions of rows

2016-11-23 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
23.11.2016 9:06, Norbert Saint Georges n...@tetrasys.eu [firebird-support] wrote: > For tables of several hundred millions of recordings, if we organize > the first eight bytes in a less cahotic way, this will lighten Firebird > by making it faster? Yes, that's why sequential GUID was

Re: [firebird-support] Firebird 2.5.6 Newbee question

2016-11-21 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
21.11.2016 20:48, ratdog1...@msn.com [firebird-support] wrote: > I simply want to try and use the open-source software to create some da > tabases. I am > moderately experienced in SQL, having used both Oracle and Microsoft Access > in the past.

Re: [firebird-support] Re: Best way to delete millions of rows

2016-11-22 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
22.11.2016 21:01, 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] wrote: >> There would be a lot of advantage, for Firebird, in using this kind of guid? > > Yes, Firebird indexes use prefix compression so the leading 14 chars of the > above values > would be stored under a single

Re: [firebird-support] Explicit Transaction + Suspend

2016-11-24 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
24.11.2016 19:59, fabia...@itbizolutions.com.au [firebird-support] wrote: > can my app start a transaction with Begin Transaction and > then call a stored procedure that contains the SUSPEND sentence at the end > while the transaction is still opened? SUSPEND has nothing to do with

Re: [firebird-support] problem - change smallint fields to boolean fields

2016-11-18 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
18.11.2016 8:57, Nico Speleers - Carfac BVBA nico.spele...@carfac.com [firebird-support] wrote: > I want to change my smallint fields made in firebird 2.5.4 to boolean fields > in firebird > 3.0.1. Can someone give me an useful script or another solution ? Drop all dependencies, create a

Re: [firebird-support] problem - change autoincrement fields to identity fields

2016-11-18 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
18.11.2016 8:56, Nico Speleers - Carfac BVBA nico.spele...@carfac.com [firebird-support] wrote: > I want to change my autoincrement fields made in firebird 2.5.4 (with > generator and > trigger) to an identity field in firebird 3.0.1 without the generator and > trigger. Can > someone give me

Re: [firebird-support] Digest Number 9396

2016-11-21 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
21.11.2016 12:08, tiberiu_horv...@yahoo.com [firebird-support] wrote: > My problem is that when I create those tables, this automatic domain > declaration declares > (creates automatically) "huge" domain names (saw these with IBExpert, setting > system > domains visible). Bad application

Re: [firebird-support] Digest Number 9396

2016-11-21 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
21.11.2016 16:22, tiberiu_horv...@yahoo.com [firebird-support] wrote: > Hope this is all right now . No. The idea to create temporary tables on the fly and then drops them is completely wrong for Firebird. -- WBR, SD.

Re: [firebird-support] On Connect triggers are dangerous, aren't they?

2016-11-01 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
01.11.2016 15:59, jonatan.laurit...@yahoo.dk [firebird-support] wrote: > I wonder is there mechanism to prevent this trigger become dangerous. E.g. if > there is the > slightest chance that error will be thrown in the on connect trigger then the > database > will be completely unavailable.

Re: {Disarmed} Re: [firebird-support] Number of concurrent user connections

2016-10-27 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
27.10.2016 16:27, 'Louis van Alphen' lo...@nucleo.co.za [firebird-support] wrote: > It’s a bad idea to keep DB connection permanently open while your app is > open. In this way > your connection is open for a very short period of time and you can service > many user > requests with a relatively

Re: [firebird-support] Number of concurrent user connections

2016-10-27 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
27.10.2016 15:28, Alain Bastien alainbast...@gmail.com [firebird-support] wrote: > I was looking on FaceBook 'sDATA storage and MySQL !!! > > For sure millions simultaneous Users connected !!! There is a definite difference between web site users and database users. -- WBR, SD.

Re: [firebird-support] Number of concurrent user connections

2016-10-27 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
27.10.2016 15:45, Alain Bastien alainbast...@gmail.com [firebird-support] wrote: > Isn't the connection the same ? No, they are completely unrelated. > Behind the WEB PAGE, if there is a login and Password, there is a DATABASE Not necessary. Everything is up to a web site developer. >

Re: [firebird-support] Number of concurrent user connections

2016-10-27 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
27.10.2016 14:57, Alain Bastien alainbast...@gmail.com [firebird-support] wrote: > And in a WAN ? TCP/IP has no difference between LAN and WAN. -- WBR, SD.

Re: [firebird-support] Number of concurrent user connections

2016-10-27 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
27.10.2016 15:11, Alain Bastien alainbast...@gmail.com [firebird-support] wrote: > Is this factor the MAIN difference between DATABASE flavors ? No. Knowledge of application developer is the only valuable factor. -- WBR, SD.

Re: [firebird-support] [EDatabaseError] How to simultaneously connect to a firebird database in elevated and non-elevated mode.

2016-10-28 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
28.10.2016 9:24, Arno Peter pe...@jam-software.com [firebird-support] wrote: > After the installation and the configuration of a database I am able to > connect to the db > with the service. > > I am also able to simultaneously connect to the same db(while the service is > also > connected) if I

Re: [firebird-support] Number of concurrent user connections

2016-10-28 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
27.10.2016 23:03, Helen Borrie hele...@iinet.net.au [firebird-support] wrote: > Actually, in Fb 3, it is 2048. Ok. > That machine > would be seriously under-resourced for Classic and not suitable for SC > at all. That's why I assumed Superserver and old hardcoded limit. -- WBR, SD.

Re: [firebird-support] How to estimate free space inside database file

2016-10-26 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
26.10.2016 11:50, Bryan Cole bryan.c...@teraview.com [firebird-support] wrote: > Sadly, I'm unable to use the ibsurgeon tools. My database is running on a > headless linux > server. I need to estimate the database free space from another > server-application. Use other approach: estimate

Re: [firebird-support] max rows par table in FB3

2016-11-04 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
04.11.2016 9:58, Norbert Saint Georges n...@tetrasys.eu [firebird-support] wrote: > Why ? > > firebird.log > > " > NORPA Thu Nov 03 10:05:12 2016 > I/O error during "ReadFile" operation for file > Error while trying to read from file > Data error (cyclic redundancy check). > "

Re: [firebird-support] Unable to upgrade database to firebird 3.0

2016-10-26 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
26.10.2016 15:33, 'Joje' j...@codework-solutions.com [firebird-support] wrote: > Could someone suggest another method to connect to database. Use TCP/IP connection string or exact XNET prefix. -- WBR, SD.

Re: [firebird-support] Why do i need wifi connection to connect to local host?

2016-10-11 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
11.10.2016 13:12, 'Rjmittendorff (publiek)' publ...@rjmittendorff.nl [firebird-support] wrote: > But I do not understand this, the database is just on the hard drive of my PC > so no internet connection should be needed. With no network connections Windows shut down whole network subsystem.

Re: [firebird-support] Reviving an old firebird database (file conversion/programming hints)

2016-10-13 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
13.10.2016 10:37, Urs Liska fireb...@openlilylib.org [firebird-support] wrote: > So that boils down to having to try out different versions of Firebird until > I find one > that can open the DB? No, you can use gstat from FB 2.5 to see ODS version in database header and derive right FB

Re: [firebird-support] High Availability Firebird

2016-12-14 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
14.12.2016 11:02, Matthew matt...@peregrineit.net [firebird-support] wrote: > I was aware of HQBird, and while it is interesting I was trying to keep the > solution > OpenSource (which was why I mentioned Pacemaker and HAProxy) - our solution > cannot justify > (at the moment) the $1K+ price tag

Re: [firebird-support] Data pages and data page slots

2016-12-13 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
13.12.2016 8:59, 'Walter R. Ojeda Valiente' wrote: > Is there something wrong there? No. > Is possible (and useful) make these numbers equals? Yes: fill database with useful data. -- WBR, SD.

Re: [firebird-support] Dividing one column by another

2016-12-12 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
12.12.2016 12:05, russ...@smxi.com [firebird-support] wrote: > The query does return rows and shows the AMOUNT from Table A and the VALUE > from Table B. > All of which have values. It is the calculated field (A.AMOUNT / B.VALUE) > that returns null. Can you copy-paste some results from

Re: [firebird-support] Commit MON$TRANSACTIONS by TRANSACTION_ID

2016-12-14 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
14.12.2016 17:44, Jaume Llunell Gómez jaumellun...@gmail.com [firebird-support] wrote: > can i do it in any way? No. -- WBR, SD.

Re: [firebird-support] Firebird database size is becoming huge (56Gb)

2017-01-10 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
10.01.2017 16:30, Leandro Melo de Sales leandromsa...@gmail.com [firebird-support] wrote: > The database file size is huge as 56Gb. Is there any limitation of Firebird > as the size of > the database increase? No limitations at this level. 56Gb is quite small database. > any suggestion for

Re: [firebird-support] Re: Time zones

2017-01-13 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
13.01.2017 13:09, Tim Ward t...@telensa.com [firebird-support] wrote: > I just don't believe this. Can anyone make any other suggestion as to > what is going on? Is timezone on your Linux set globally or for each current user environment independently? -- WBR, SD.

Re: [firebird-support] Firebird : join table from two database

2017-01-12 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
12.01.2017 21:44, startx252...@yahoo.fr [firebird-support] wrote: > What is the way to make a join from 2 tables in two respective database (in > same server) ? No. -- WBR, SD.

Re: [firebird-support] Time zones

2017-01-12 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
12.01.2017 15:09, Tim Ward t...@telensa.com [firebird-support] wrote: > Can someone point me in the right direction please? Firebird does not handle time zones at all. CURRENT_TIMESTAMP and CURRENT_TIME return local time. -- WBR, SD.

Re: [firebird-support] How to identify if field of table is identity or not?

2017-01-12 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
12.01.2017 17:22, hamacker sirhamac...@gmail.com [firebird-support] wrote: > I need a method to check if table.field is identity or not. RTFM README.identity_columns.txt -- WBR, SD.

Re: [firebird-support] Re: Time zones

2017-01-13 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
13.01.2017 16:46, Tim Ward t...@telensa.com [firebird-support] wrote: > One thing I've now noticed is that running the trigger by updating a > record via isql gives the correct, Brazilian, answer. If you are running isql and connected to database in embedded mode, your current environment is

Re: [firebird-support] stale statements in MON$STATEMENTS

2016-12-02 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
02.12.2016 8:56, Hamish Moffatt ham...@risingsoftware.com [firebird-support] wrote: > I understand that the idle statement > means they have been prepared but not executed, but this shouldn't be > possible in my application source (prepare has never failed, and I > always execute). Yes, but

<    1   2   3   4   5   6   7   8   >