[firebird-support] Invalid BLOB ID
Hi all, i have this error repeated about 20 times when backing up my database: gbak:error accessing BLOB column EXPLICATIE -- continuing gbak: ERROR:invalid BLOB ID What should i do? Thank you, Szilveszter
Re: [firebird-support] Invalid BLOB ID
Hi, It's missed BLOBs, good that you have this, not critical errors. Perform backup and restore. Regards, Alexey Kovyazin www.ibsurgeon.com Hi all, i have this error repeated about 20 times when backing up my database: gbak:error accessing BLOB column EXPLICATIE -- continuing gbak: ERROR:invalid BLOB ID What should i do? Thank you, Szilveszter
RE: [firebird-support] Invalid BLOB ID
Hi, It's missed BLOBs, good that you have this, not critical errors. Perform backup and restore. Regards, Alexey Kovyazin www.ibsurgeon.com What's a 'missed' BLOB? Alan Hi all, i have this error repeated about 20 times when backing up my database: gbak:error accessing BLOB column EXPLICATIE -- continuing gbak: ERROR:invalid BLOB ID What should i do? Thank you, Szilveszter [Non-text portions of this message have been removed]
Re: [firebird-support] Invalid BLOB ID
Hi Alan, Missed, orphaned, slightly corrupted - the is no strict term. There will be error while trying to fetch such BLOB field, but gbak [sometimes] can workaround it. Regards, Alexey Kovyazin www.ibsurgeon.com Hi, It's missed BLOBs, good that you have this, not critical errors. Perform backup and restore. Regards, Alexey Kovyazin www.ibsurgeon.com What's a 'missed' BLOB? Alan Hi all, i have this error repeated about 20 times when backing up my database: gbak:error accessing BLOB column EXPLICATIE -- continuing gbak: ERROR:invalid BLOB ID What should i do? Thank you, Szilveszter [Non-text portions of this message have been removed]
[Ticket #14] [firebird-support] Re: Firebird 2.5 crashing after calling UDF
This is a notification from the Help Desk. On Mar 07, 2014 @ 03:24 pm, fr...@schlottmann-goedde.de wrote: On 26.10.2011 02:49, sir_wally_lewis wrote: Thanks for the fixes to my C library Tomasz and for your help. All my C Library is originally extracted from FreeUDFLibC and I added extra functions. There were errors in the C Code that I was unaware of. Amazing that the same unaltered code works under CenTos 64 bit in 2.1 though. Still do not understand why my freepascal UDF is crashing. Appears to be another bug similar to http://tracker.firebirdsql.org/browse/CORE-3646 Even simple ppc64 generated udfs triggers the fb server process to end on disconnecting the client. I will create a simplified testcase and add it to the tracker asap. mit freundlichen Grüßen Frank Schlottmann-Gödde -- Fascinating creatures, phoenixes, they can carry immensely heavy loads, their tears have healing powers and they make highly faithful pets. - J.K. Rowling -- This is an automated response. Your issue has been noted. We'll be in touch soon. Please reply to this email or visit the URL below with any additional details. http://DANTOIN:9675/portal/view-help-request/14 [Non-text portions of this message have been removed]
[Ticket #51] [firebird-support] classic server used as embedded server in linux with database ...
This is a notification from the Help Desk. On Mar 07, 2014 @ 03:25 pm, b...@benshort.co.uk wrote: Hi, I am using Firebird-2.1.3.18185-0 in the following configuration: Classic Server Embedded Linux On a raw device I have been using the isc_database_info interface to query the database info. The values I'm particularly interested in are isc_info_allocation and isc_info_db_size_in_pages but they always return 0. Can anyone help me out with this? Regards Ben [Non-text portions of this message have been removed] -- This is an automated response. Your issue has been noted. We'll be in touch soon. Please reply to this email or visit the URL below with any additional details. http://DANTOIN:9675/portal/view-help-request/51 [Non-text portions of this message have been removed]
[Ticket #70] [firebird-support] Detecting default values
This is a notification from the Help Desk. On Mar 07, 2014 @ 03:25 pm, d...@tetram.org wrote: Hi, I have a table with a field for which i need a default value. My problem is the default value can change at any time. So the solution I found is to use a before insert trigger. But now, i'm facing a new challenge: how to detect if the null status I received in new.myfield is because the field was not in the insert statement or because the insert statement set it to null ? well, from insert into mytable (field1) values (:field1) or from insert into mytable (field1, myfield) values (:field1, null) -- This is an automated response. Your issue has been noted. We'll be in touch soon. Please reply to this email or visit the URL below with any additional details. http://DANTOIN:9675/portal/view-help-request/70 [Non-text portions of this message have been removed]
[Ticket #73] [firebird-support] Detecting default values
This is a notification from the Help Desk. On Mar 07, 2014 @ 03:26 pm, mil...@panonnet.net wrote: Tetram Corp wrote: I thought about this solution but hoped there was a better one because of, you're right, in my case the field has a restricted range but i've an other similar case where there's no limit in value range too bad. I will use this trick for my first case, and think again about app design for the second one Do you have a complete control over database and application? What is the datatype of column? Here are some ideas: If you have a varchar column, you can solve it by increasing the column size by 1 character and make sure default uses all characters. For example, if your field is normally char(3), you can increase it to char(4) and set '' as default. Restrict the data entry in application to only allow 3 characters. -- Milan Babuskov == The easiest way to import XML, CSV and textual files into Firebird: http://www.guacosoft.com/xmlwizard == ==Ticket History== On Mar 07, 2014 @ 03:25 pm, d...@tetram.org wrote: I thought about this solution but hoped there was a better one because of, you're right, in my case the field has a restricted range but i've an other similar case where there's no limit in value range too bad. I will use this trick for my first case, and think again about app design for the second one thx all Le 03/11/2011 21:39, Leyne, Sean a écrit : Ismael, In the trigger: if (new.myfield is null) then This will not be able to distinguish the condition: But now, i'm facing a new challenge: how to detect if the null status I received in new.myfield is because the field was not in the insert statement or because the insert statement set it to null ? well, from insert into mytable (field1) values (:field1) or from insert into mytable (field1, myfield) values (:field1, null) Doug Chamberlin's solution is the right one, though with a possible problem if the full range of values for the field are valid within an INSERT statement (in which case no dummy default value could be defined). Sean [Non-text portions of this message have been removed] -- On Mar 07, 2014 @ 03:25 pm, s...@broadviewsoftware.com wrote: Ismael, In the trigger: if (new.myfield is null) then This will not be able to distinguish the condition: But now, i'm facing a new challenge: how to detect if the null status I received in new.myfield is because the field was not in the insert statement or because the insert statement set it to null ? well, from insert into mytable (field1) values (:field1) or from insert into mytable (field1, myfield) values (:field1, null) Doug Chamberlin's solution is the right one, though with a possible problem if the full range of values for the field are valid within an INSERT statement (in which case no dummy default value could be defined). Sean -- This is an automated response. Your issue has been noted. We'll be in touch soon. Please reply to this email or visit the URL below with any additional details. http://DANTOIN:9675/portal/view-help-request/73 [Non-text portions of this message have been removed]
[Ticket #70] [firebird-support] Detecting default values
This is a notification from the Help Desk. On Mar 07, 2014 @ 03:25 pm, ism...@citricos.co.cu wrote: In the trigger: if (new.myfield is null) then Best Regards = || ISMAEL || = ==Ticket History== On Mar 07, 2014 @ 03:25 pm, chamberlin.d...@gmail.com wrote: No Comment. -- On Mar 07, 2014 @ 03:25 pm, d...@tetram.org wrote: Hi, I have a table with a field for which i need a default value. My problem is the default value can change at any time. So the solution I found is to use a before insert trigger. But now, i'm facing a new challenge: how to detect if the null status I received in new.myfield is because the field was not in the insert statement or because the insert statement set it to null ? well, from insert into mytable (field1) values (:field1) or from insert into mytable (field1, myfield) values (:field1, null) -- This is an automated response. Your issue has been noted. We'll be in touch soon. Please reply to this email or visit the URL below with any additional details. http://DANTOIN:9675/portal/view-help-request/70 [Non-text portions of this message have been removed]
[Ticket #93] [firebird-support] Re: Firebird 2.5 crashing after calling UDF
This is a notification from the Help Desk. On Mar 07, 2014 @ 03:26 pm, fr...@schlottmann-goedde.de wrote: Am 26.10.2011 02:49, schrieb sir_wally_lewis: the same unaltered code works under CenTos 64 bit in 2.1 though. Still do not understand why my freepascal UDF is crashing. I have added an issue to the tracker http://tracker.firebirdsql.org/browse/CORE-3651 cheers FSG -- Fascinating creatures, phoenixes, they can carry immensely heavy loads, their tears have healing powers and they make highly faithful pets. - J.K. Rowling -- This is an automated response. Your issue has been noted. We'll be in touch soon. Please reply to this email or visit the URL below with any additional details. http://DANTOIN:9675/portal/view-help-request/93 [Non-text portions of this message have been removed]
[Ticket #111] [firebird-support] Getting only as many records for given qty.
This is a notification from the Help Desk. On Mar 07, 2014 @ 03:26 pm, m...@lawinegevaar.nl wrote: No Comment. ==Ticket History== On Mar 07, 2014 @ 03:26 pm, venussof...@gmail.com wrote: Hi all I know a qty. for a particular item purchased. This item though has been purchased over a long period only the last few purchase bills are now of concern (FIFO method). I have the following tables tPurchaseBill iID PK iNo Bill No. etc. sPurchaseBillItems iID PK iPID FK to tPurchaseBill table iItemID FK to mItems table bQty qty. in this purchase etc. so if I am to provide an iItemID and a bStock qty. can I bring out only those last few tPurchaseBill records. Is there any way I can do this in pure SQL? Please advise Thanks and regards Bhavbhuti -- This is an automated response. Your issue has been noted. We'll be in touch soon. Please reply to this email or visit the URL below with any additional details. http://DANTOIN:9675/portal/view-help-request/111 [Non-text portions of this message have been removed]
[Ticket #83] [firebird-support] firebird 2.5.1 on Lion Server 10.7.2
This is a notification from the Help Desk. On Mar 07, 2014 @ 03:25 pm, as...@yahoo.com wrote: Hi all, I am trying to run Firebird on a Mac. (OSX Lion Server 10.27.2, Filebird 2.5.1). Actually, I tried CS and SS and both of them behave unstable. The server can run for awhile (several hours) before crash. Interesting thing is that after the first crash the server does not work. Does anybody knows how to make the thing work? Thanks, Alexander [Non-text portions of this message have been removed] -- This is an automated response. Your issue has been noted. We'll be in touch soon. Please reply to this email or visit the URL below with any additional details. http://DANTOIN:9675/portal/view-help-request/83 [Non-text portions of this message have been removed]
[Ticket #118] [firebird-support] Best Practice re null
This is a notification from the Help Desk. On Mar 07, 2014 @ 03:27 pm, ho...@agencybusys.com wrote: In certain queries I wish nulls to be treated as empty strings. For example: Select Field1 || ' ' || Field2 AS MyOutputValue; In this example, I want the value for Field1 to be returned even if Field2 is null. My first thought is to define a default of '' for the Domains that govern all such fields. At the moment, I can't think of a case where null values would ever be needed in those fields, but my crystal ball is not always accurate. So: 1. Is assigning a default of '' an acceptable practice? 2. Is there a better way to handle this, perhaps within the query SQL? -- This is an automated response. Your issue has been noted. We'll be in touch soon. Please reply to this email or visit the URL below with any additional details. http://DANTOIN:9675/portal/view-help-request/118 [Non-text portions of this message have been removed]
[Ticket #115] [firebird-support] Re: Getting only as many records for given qty.
This is a notification from the Help Desk. On Mar 07, 2014 @ 03:27 pm, venussof...@gmail.com wrote: --- In firebird-support@yahoogroups.com, Mark Rotteveel mark@... wrote: On 5-11-2011 8:53, venussoftop wrote: Hi all I know a qty. for a particular item purchased. This item though has been purchased over a long period only the last few purchase bills are now of concern (FIFO method). I have the following tables tPurchaseBill iID PK iNo Bill No. etc. sPurchaseBillItems iID PK iPID FK to tPurchaseBill table iItemID FK to mItems table bQty qty. in this purchase etc. so if I am to provide an iItemID and a bStock qty. can I bring out only those last few tPurchaseBill records. Is there any way I can do this in pure SQL? Sort by the purchase date descending and use the ROWS clause to limit the amount of rows returned: http://www.firebirdsql.org/file/documentation/reference_manuals/reference_material/html/langrefupd25-select.html#langrefupd25-select-rows -- Mark Rotteveel Thanks Mark for your response. Yes, I can limit the number of rows to something that is practical and not the whole set. But I do not think I will be able to convert the bStock qty. into number of rows as the qty. would be different in each purchase bill. Any suggestions on this front. Thanks and regards Bhavbhuti -- This is an automated response. Your issue has been noted. We'll be in touch soon. Please reply to this email or visit the URL below with any additional details. http://DANTOIN:9675/portal/view-help-request/115 [Non-text portions of this message have been removed]
[Ticket #87] [firebird-support] firebird 2.5.1 on Lion Server 10.7.2
This is a notification from the Help Desk. On Mar 07, 2014 @ 03:27 pm, as...@yahoo.com wrote: Thank you, Paul for the quick reply and for the script for uninstallation of the firebird. It seems that my problem was related with UDF, compiled using Free Pascal which was described inFirebird 2.5 crashing after calling UDF Am 26.10.2011 02:49, schrieb sir_wally_lewis: the same unaltered code works under CenTos 64 bit in 2.1 though. Still do not understand why my freepascal UDF is crashing. I have added an issue to the tracker http://tracker.firebirdsql.org/browse/CORE-3651 cheers FSG So, I went back to the 2.1.4 CS, x64 and if works well with UDF compiled by fpc Regards, Alexander ==Ticket History== On Mar 07, 2014 @ 03:26 pm, pabe...@waitrose.com wrote: Hi all, I am trying to run Firebird on a Mac. (OSX Lion Server 10.27.2, Filebird 2.5.1). Actually, I tried CS and SS and both of them behave unstable. The server can run for awhile (several hours) before crash. Interesting thing is that after the first crash the server does not work. Does anybody knows how to make the thing work? This is a pretty unhelpful posting. Define crash? What happens? What are you doing? Is there any info via the CrashReporter... Did you have any earlier version of Firebird installed before installing 2.5.1? How did you remove it or did you upgrade in place? Paul -- This is an automated response. Your issue has been noted. We'll be in touch soon. Please reply to this email or visit the URL below with any additional details. http://DANTOIN:9675/portal/view-help-request/87 [Non-text portions of this message have been removed]
[Ticket #126] [firebird-support] Performance in Firebird 2.5
This is a notification from the Help Desk. On Mar 07, 2014 @ 03:27 pm, mahesh.pratih...@sonata-software.com wrote: Hi ALL, Could you please let me know how I can do with the Performance in Firebird 2.5? Application is getting slower and slower as data is entered. Thanks, Mahesh Pratihari Sonata Software Limited Phone : +91 80 3097 1570 Mobile : +91 99808 37446 www.sonata-software.com Please don't print this email unless you really need to. This will preserve trees on our planet. [Non-text portions of this message have been removed] -- This is an automated response. Your issue has been noted. We'll be in touch soon. Please reply to this email or visit the URL below with any additional details. http://DANTOIN:9675/portal/view-help-request/126 [Non-text portions of this message have been removed]
[Ticket #124] [firebird-support] 2.5 embedded on Win7
This is a notification from the Help Desk. On Mar 07, 2014 @ 03:27 pm, t...@iblogmanager.com wrote: I am using Firebird 2.5.1 embedded on a Windows 7 machine. Due to its superclassic architecture, it is normally possible to have many simultaneous connections from different applications to the same database. There is also an apache 2.2 server running on the same machine, but it can't connect to the database when any other application is already connected... as far as I can remember, this used to work fine on XP, so I suspect something of Win7's security features kicks in here. I tried to run the apache server using my own account, but it didn't help. Could anyone give some advice or at least explain what exactly is happening here? If this is a mix of embedded and regular server connections, then be aware that you can't mix 32-bit and 64-bit embedded and regular server connections to the same database. -- With regards, Thomas Steinmaurer * Firebird Foundation Committee Member http://www.firebirdsql.org/en/firebird-foundation/ * Upscene Productions - Database Tools for Developers http://www.upscene.com/ * My Blog http://blog.upscene.com/thomas/index.php ==Ticket History== On Mar 07, 2014 @ 03:27 pm, em...@tot-consult.com wrote: Hi I am using Firebird 2.5.1 embedded on a Windows 7 machine. Due to its superclassic architecture, it is normally possible to have many simultaneous connections from different applications to the same database. There is also an apache 2.2 server running on the same machine, but it can't connect to the database when any other application is already connected... as far as I can remember, this used to work fine on XP, so I suspect something of Win7's security features kicks in here. I tried to run the apache server using my own account, but it didn't help. Could anyone give some advice or at least explain what exactly is happening here? Thanks in advance Emil -- This is an automated response. Your issue has been noted. We'll be in touch soon. Please reply to this email or visit the URL below with any additional details. http://DANTOIN:9675/portal/view-help-request/124 [Non-text portions of this message have been removed]
[Ticket #173] [firebird-support] Re: Connect to a Database on the Internet
This is a notification from the Help Desk. On Mar 07, 2014 @ 03:28 pm, sistemas2000profesio...@gmail.com wrote: Hello Karol 1. (connect by IP address) works well 2. (connect by domain name) doesn't work Greetings. Walter. But what not work 1. connect by IP adress 2. connect by domain name if first - then you have not port forwarding on your router set properly or your firewall block port default is 3050 Karol Bieniaszewski [Non-text portions of this message have been removed] ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links ==Ticket History== On Mar 07, 2014 @ 03:28 pm, sistemas2000profesio...@gmail.com wrote: Hello Lester Well, writing the URL it works, but writing the domain name, not. Greetings. Walter. -- On Mar 07, 2014 @ 03:28 pm, liviusliv...@poczta.onet.pl wrote: --- In firebird-support@yahoogroups.com, W O sistemas2000profesional@... wrote: Hello Mark I think so, but doesn't work. Greetings. Walter. But what not work 1. connect by IP adress 2. connect by domain name if first - then you have not port forwarding on your router set properly or your firewall block port default is 3050 Karol Bieniaszewski -- This is an automated response. Your issue has been noted. We'll be in touch soon. Please reply to this email or visit the URL below with any additional details. http://DANTOIN:9675/portal/view-help-request/173 [Non-text portions of this message have been removed]
[Ticket #235] [firebird-support] Re: Problems selecting on Timestamp.
This is a notification from the Help Desk. On Mar 07, 2014 @ 03:29 pm, m...@lawinegevaar.nl wrote: No Comment. ==Ticket History== On Mar 07, 2014 @ 03:29 pm, tomconl...@gmail.com wrote: --- In firebird-support@yahoogroups.com, Mark Rotteveel mark@... wrote: On Wed, 9 Nov 2011 10:35:18 +0100, Kjell Rilbe kjell.rilbe@... wrote: Den 2011-11-09 10:31 skrev canacourse såhär: Kjell, Doesn’t using the dot separator imply that non us date formats are being used? i.e. 07/11/2011 is interpreted as MM/DD/ while 07.11.2011 is interpreted as DD/MM/? Sorry, I don't know. I just wanted to point out that there are different ways to interpret a date string and that you should make sure that your date string is actually interpreted the way you intend. How you choose to do this is up to you: try it out in your DB (recommended), read docs, ask here, ... You could for example try this: select cast ('6.11.2011 08:35:26' as timestamp) from rdb$database select cast ('6.30.2011 08:35:26' as timestamp) from rdb$database select cast ('30.6.2011 08:35:26' as timestamp) from rdb$database Better just use timestamp '2011-06-30 08:35:26' or cast('2011-06-30 08:35:26' as timestamp), which should always work independent of the locale of the server. Mark Also, '30-Jun-2011 08:35:26' is explicit and unambiguous. Tom -- This is an automated response. Your issue has been noted. We'll be in touch soon. Please reply to this email or visit the URL below with any additional details. http://DANTOIN:9675/portal/view-help-request/235 [Non-text portions of this message have been removed]
[Ticket #200] [firebird-support] Update Issue with FB 2.5.1 (severe)
This is a notification from the Help Desk. On Mar 07, 2014 @ 03:28 pm, alan.dav...@aldis-systems.co.uk wrote: Hi, I have a major issue with 2.5.1.26351 running on W7 64bit, W2003 server, W2008 server, W7 32 bit and so on. Basically I cannot get an update to work if a value is calculated within the same update procedure, as follows: This gives InvoiceVal of 0.00 Update Orditems SetComplete='Y',Invoice_It='Y', Inv_Qty1=Ord_Qty1-Del_Qty1, Inv_Qty2=Ord_Qty2-Del_Qty2, /* there are many more */ INV_TOT=Ord_Tot-Del_Tot,/* see next line */ InvoiceVal=(Sell_Price*(100-Discount)*INV_TOT)/100 Where Acno=:Account_Nmbr AndOrdno=:Order_Nmbr; this double version works and gives InvoiceVal of 123.45 (or whatever) Update Orditems SetComplete='Y',Invoice_It='Y', Inv_Qty1=Ord_Qty1-Del_Qty1, Inv_Qty2=Ord_Qty2-Del_Qty2, /* there are many more */ INV_TOT=Ord_Tot-Del_Tot /* see next update */ Where Acno=:Account_Nmbr AndOrdno=:Order_Nmbr; Update Orditems SetInvoiceVal=(Sell_Price*(100-Discount)*INV_TOT)/100 Where Acno=:Account_Nmbr AndOrdno=:Order_Nmbr; All similar procedures fail and they all have been running for several years on previous versions of FB from 1.5 on. My question is - why? 2 parts. Why do they fail now, and why did they work previously? I have 2 machines running side-by-side one works - 2.1.3.18185 and one fails - 2.5.1.26351 Have I missed a vital piece of information in the documentation or should I be reporting this as a severe bug? Regards Alan -- Alan J Davies Aldis -- This is an automated response. Your issue has been noted. We'll be in touch soon. Please reply to this email or visit the URL below with any additional details. http://DANTOIN:9675/portal/view-help-request/200 [Non-text portions of this message have been removed]
[Ticket #139] [firebird-support] Re: 2.5 embedded on Win7
This is a notification from the Help Desk. On Mar 07, 2014 @ 03:27 pm, em...@tot-consult.com wrote: --- In firebird-support@yahoogroups.com, Thomas Steinmaurer ts@... wrote: I am using Firebird 2.5.1 embedded on a Windows 7 machine. Due to its superclassic architecture, it is normally possible to have many simultaneous connections from different applications to the same database. There is also an apache 2.2 server running on the same machine, but it can't connect to the database when any other application is already connected... as far as I can remember, this used to work fine on XP, so I suspect something of Win7's security features kicks in here. I tried to run the apache server using my own account, but it didn't help. Could anyone give some advice or at least explain what exactly is happening here? If this is a mix of embedded and regular server connections, then be aware that you can't mix 32-bit and 64-bit embedded and regular server connections to the same database. -- With regards, Thomas Steinmaurer No, this is only embedded on a 32-bit system. I guess there is something different in the context of the dll run interactively and by the apache server (even under the same user account). -- This is an automated response. Your issue has been noted. We'll be in touch soon. Please reply to this email or visit the URL below with any additional details. http://DANTOIN:9675/portal/view-help-request/139 [Non-text portions of this message have been removed]
[Ticket #234] [firebird-support] Re: Problems selecting on Timestamp.
This is a notification from the Help Desk. On Mar 07, 2014 @ 03:29 pm, kjell.ri...@datadia.se wrote: Den 2011-11-09 10:39 skrev Mark Rotteveel såhär: On Wed, 9 Nov 2011 10:35:18 +0100, Kjell Rilbe kjell.ri...@datadia.se mailto:kjell.rilbe%40datadia.se wrote: Den 2011-11-09 10:31 skrev canacourse såhär: Kjell, Doesn’t using the dot separator imply that non us date formats are being used? i.e. 07/11/2011 is interpreted as MM/DD/ while 07.11.2011 is interpreted as DD/MM/? Sorry, I don't know. I just wanted to point out that there are different ways to interpret a date string and that you should make sure that your date string is actually interpreted the way you intend. How you choose to do this is up to you: try it out in your DB (recommended), read docs, ask here, ... You could for example try this: select cast ('6.11.2011 08:35:26' as timestamp) from rdb$database select cast ('6.30.2011 08:35:26' as timestamp) from rdb$database select cast ('30.6.2011 08:35:26' as timestamp) from rdb$database Better just use timestamp '2011-06-30 08:35:26' or cast('2011-06-30 08:35:26' as timestamp), which should always work independent of the locale of the server. And this is... *drumroll* ISO 8601! Yeehaaaw! :-) Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 [Non-text portions of this message have been removed] ==Ticket History== On Mar 07, 2014 @ 03:29 pm, m...@lawinegevaar.nl wrote: No Comment. -- On Mar 07, 2014 @ 03:29 pm, kjell.ri...@datadia.se wrote: Den 2011-11-09 10:31 skrev canacourse såhär: Kjell, Doesn’t using the dot separator imply that non us date formats are being used? i.e. 07/11/2011 is interpreted as MM/DD/ while 07.11.2011 is interpreted as DD/MM/? Sorry, I don't know. I just wanted to point out that there are different ways to interpret a date string and that you should make sure that your date string is actually interpreted the way you intend. How you choose to do this is up to you: try it out in your DB (recommended), read docs, ask here, ... You could for example try this: select cast ('6.11.2011 08:35:26' as timestamp) from rdb$database select cast ('6.30.2011 08:35:26' as timestamp) from rdb$database select cast ('30.6.2011 08:35:26' as timestamp) from rdb$database Kjell [Non-text portions of this message have been removed] ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links -- On Mar 07, 2014 @ 03:29 pm, canacou...@gmail.com wrote: Kjell, Doesn’t using the dot separator imply that non us date formats are being used? i.e. 07/11/2011 is interpreted as MM/DD/ while 07.11.2011 is interpreted as DD/MM/? --- In firebird-support@yahoogroups.com, Kjell Rilbe kjell.rilbe@... wrote: Den 2011-11-09 09:49 skrev canacourse s�h�r: I assume you meant cast ('6.11.2011 08:35:26' as timestamp);? I have tried that but still no records are returned in Ibexpert or ISQL. Make sure your string literal is interpreted the way you think. If only people would come to their senses and adopt the ISO 8601 standard. *sigh* For example, does '6.11.2011 08:35:26' result in Nov 6 or June 11? Kjell [Non-text portions of this message have been removed] -- This is an automated response. Your issue has been noted. We'll be in touch soon. Please reply to this email or visit the URL below with any additional details. http://DANTOIN:9675/portal/view-help-request/234 [Non-text portions of this message have been removed]
[Ticket #235] [firebird-support] Re: Problems selecting on Timestamp.
This is a notification from the Help Desk. On Mar 07, 2014 @ 03:29 pm, hele...@iinet.net.au wrote: At 11:04 PM 9/11/2011, Mark Rotteveel wrote: ==Ticket History== On Mar 07, 2014 @ 03:29 pm, m...@lawinegevaar.nl wrote: No Comment. -- On Mar 07, 2014 @ 03:29 pm, tomconl...@gmail.com wrote: --- In firebird-support@yahoogroups.com, Mark Rotteveel mark@... wrote: On Wed, 9 Nov 2011 10:35:18 +0100, Kjell Rilbe kjell.rilbe@... wrote: Den 2011-11-09 10:31 skrev canacourse såhär: Kjell, Doesn’t using the dot separator imply that non us date formats are being used? i.e. 07/11/2011 is interpreted as MM/DD/ while 07.11.2011 is interpreted as DD/MM/? Sorry, I don't know. I just wanted to point out that there are different ways to interpret a date string and that you should make sure that your date string is actually interpreted the way you intend. How you choose to do this is up to you: try it out in your DB (recommended), read docs, ask here, ... You could for example try this: select cast ('6.11.2011 08:35:26' as timestamp) from rdb$database select cast ('6.30.2011 08:35:26' as timestamp) from rdb$database select cast ('30.6.2011 08:35:26' as timestamp) from rdb$database Better just use timestamp '2011-06-30 08:35:26' or cast('2011-06-30 08:35:26' as timestamp), which should always work independent of the locale of the server. Mark Also, '30-Jun-2011 08:35:26' is explicit and unambiguous. Tom -- This is an automated response. Your issue has been noted. We'll be in touch soon. Please reply to this email or visit the URL below with any additional details. http://DANTOIN:9675/portal/view-help-request/235 [Non-text portions of this message have been removed]
[Ticket #220] [firebird-support] Re: Firebird on WIndows 2008 R2
This is a notification from the Help Desk. On Mar 07, 2014 @ 03:29 pm, m...@lawinegevaar.nl wrote: No Comment. ==Ticket History== On Mar 07, 2014 @ 03:29 pm, m...@omniaccounts.co.za wrote: Another observation that we made is with transactions. Tae following example - 1 insert hundred records in a table 2 after each record is inserted, commit the transaction. Now these steps give different output on different machines. On Windows 7 and XP they give results in 1.5 seconds. But on Windows 2008 R2 this takes 22 seconds. Now when we changed the application to commit at the end or hundred inserts then output was almost same on both the machines. Any thoughts on this? If you do the same test, but with READING instead of writing does it also behave the same way? It might be your network card rather than your OS. AFAIK for every transaction started, it need to renegotiate the network speed, so if you have a network consisting of a mix of 100 base and 1000 base (Gigabit) cards then the network controller is constantly having to decide at what speed to run for each new transaction. Try setting all PC's on the network to run at 100 base, and see if it improves the speed. Also, check you have the correct cabling, and hubs for the network speed you are running. In addition, some cards have a throttling setting that deliberately slow down the network if to many packets are thrown at it. (supposed to be a security thing I think) We've only really come across that once or twice though. Lately though, I've just started analysing all my code where I have to fire off a whole lot of read queries in a row, and am now making sure I start one single shared read-only transaction before starting my load routine, and it's made a good difference even on PC's that didn't seem to be experiencing this problem. If reading is fine, and it's only writing that's slow, then I'd guess the problem is elsewhere though.. maybe that's when it's writing to disk. Just my 2c, hope it helps. I must say though, that when we get reports of speed issues, Windows 2008 usually is usually mentioned a lot, so I'm also watching this thread with interest ;-) Maya -- On Mar 07, 2014 @ 03:29 pm, sparas...@lutron.com wrote: --- In firebird-support@yahoogroups.com, Leyne, Sean Sean@... wrote: If it is HP, then you will probably have to enable HDD caching on RAID driver ... even if you do not use RAID there is this option in HDD driver. As long as you are referring to activating READ caching, then that's fine. Activating WRITE caching without a protected controller cache will result in **data loss** if the system loses power, abends or is not shutdown properly. Sean Thanks guys for your prompt response. I doubled checked and these particular machines are not HP. Also it's a single HDD with no RAID and does not support either read or write caching. I mean this particular model does not support this. Another observation that we made is with transactions. Tae following example - 1 insert hundred records in a table 2 after each record is inserted, commit the transaction. Now these steps give different output on different machines. On Windows 7 and XP they give results in 1.5 seconds. But on Windows 2008 R2 this takes 22 seconds. Now when we changed the application to commit at the end or hundred inserts then output was almost same on both the machines. Any thoughts on this? Thanks, Siddharth Parashar -- This is an automated response. Your issue has been noted. We'll be in touch soon. Please reply to this email or visit the URL below with any additional details. http://DANTOIN:9675/portal/view-help-request/220 [Non-text portions of this message have been removed]
[Ticket #237] [firebird-support] Re: selecting a field by name (using a var)
This is a notification from the Help Desk. On Mar 07, 2014 @ 03:29 pm, shg_siste...@yahoo.com.ar wrote: Hi Karol! Sorry bat I don't know how to do it with a normal select... how would it be? -s [Non-text portions of this message have been removed] -- This is an automated response. Your issue has been noted. We'll be in touch soon. Please reply to this email or visit the URL below with any additional details. http://DANTOIN:9675/portal/view-help-request/237 [Non-text portions of this message have been removed]
[Ticket #234] [firebird-support] Re: Problems selecting on Timestamp.
This is a notification from the Help Desk. On Mar 07, 2014 @ 03:29 pm, canacou...@gmail.com wrote: Kjell, Doesn’t using the dot separator imply that non us date formats are being used? i.e. 07/11/2011 is interpreted as MM/DD/ while 07.11.2011 is interpreted as DD/MM/? --- In firebird-support@yahoogroups.com, Kjell Rilbe kjell.rilbe@... wrote: Den 2011-11-09 09:49 skrev canacourse s�h�r: I assume you meant cast ('6.11.2011 08:35:26' as timestamp);? I have tried that but still no records are returned in Ibexpert or ISQL. Make sure your string literal is interpreted the way you think. If only people would come to their senses and adopt the ISO 8601 standard. *sigh* For example, does '6.11.2011 08:35:26' result in Nov 6 or June 11? Kjell [Non-text portions of this message have been removed] -- This is an automated response. Your issue has been noted. We'll be in touch soon. Please reply to this email or visit the URL below with any additional details. http://DANTOIN:9675/portal/view-help-request/234 [Non-text portions of this message have been removed]
[Ticket #287] [firebird-support] Slow Database
This is a notification from the Help Desk. On Mar 07, 2014 @ 03:30 pm, ch.kaufm...@splash-software.ch wrote: Hi, I have a website with PHP and a Firebird database. It looks like the Firebird database becomes very slow and I don't know, how to find where and why. My database is 15GB, the biggest table has about 30 million records. Right now I try to create the statistics, but it takes for ever. At the same time I try to monitor the database with the Sinatica tool. OAT and Next transaction are close, no GC pending. What I see is a lot warnings like invalid char set, but I think, this has nothing to do with performance. I'm also not aware of any statement not using indexes or so. What can I do? How do I find the bottle necks? It must be in Firebird, but I don't know, what I do wrong. cu Christian -- This is an automated response. Your issue has been noted. We'll be in touch soon. Please reply to this email or visit the URL below with any additional details. http://DANTOIN:9675/portal/view-help-request/287 [Non-text portions of this message have been removed]
[Ticket #218] [firebird-support] Re: Install problems
This is a notification from the Help Desk. On Mar 07, 2014 @ 03:29 pm, pre...@technisoft-online.com wrote: --- In firebird-support@yahoogroups.com, Alan J Davies Alan.Davies@... wrote: Hi Peter, a few things to check, from what you say you are familiar with FB and Delphi: localhosts is not needed, its part of the setup of dns Aliases.conf examples fibrominn=e:\apps\fibrosys\fibrominn\fibrosys.fdb pjsmouldings=e:\apps\pjsmould\orders.fdb miracle=e:\apps\miracle\ordproc\miracle.fdb These are from a similar setup to your's - windows 7 64bit with Fb 2.5.1 32 bit. Could use 64bit but Udfs don't work well. Can you run the Delphi app on the machine itself Is IPV4 running or IPV6 - has been/is a problem on some systems Hope this helps a bit. Alan J Davies Aldis Hi Alan, I saw in the hosts file that the localhost is not needed but as it didn't work I thought I would make an specific entry. I know how to set up the aliases.conf file. The only difference is that I usually leave a space on both side of the = sign. This has never been a problem. I can run any of the apps provided I connect using the XNET protocol. Anyway, IB_SQL also can't connect to the DB when using TCP/IP so it definitely not the app. Both IPV4 and IPV6 are installed, how can I know which one is running or used? Thanks Peter -- This is an automated response. Your issue has been noted. We'll be in touch soon. Please reply to this email or visit the URL below with any additional details. http://DANTOIN:9675/portal/view-help-request/218 [Non-text portions of this message have been removed]
[Ticket #290] [firebird-support] Re: Firebird ODBC driver: connection to an embedded server by ...
This is a notification from the Help Desk. On Mar 07, 2014 @ 03:30 pm, patrick_mar...@yahoo.com wrote: Thanks for your reply, creation of a ODBC connection to an embedded server works with SYSDBA only, is that correct? I was not able to create one with another user. If that's not correct: what can be the reason for the problem I have when trying to create a connection with a different user. If that's correct: the only way would be to grant SYSDBA read only rights, correct? Is that possible at all? --- In firebird-support@yahoogroups.com, Thomas Steinmaurer ts@... wrote: how can I get Firebird ODBC driver to connect to an embedded server by using the security2.fdb? Is there any reason, why the security2.fdb is being ignored in that case at least by default? That way the ODBC connection can only be created with SYSDBA as user and there is no way to make the connection read only. I mean yes, you can check the checkbox read when creating the connection, but the end user can uncheck it at any time and gat a write access to the DB... For the ODBC connection to a normal server he could do the same of course, but since in that case the connection cen be created with a user, who has read rights only, it doesn't matter if the checkbox gets unchecked. Why can't it work the same with embedded server? That doesn't make sense to me... Can I accomplish it in any way? Embedded works that way: The provided user/password combination isn't checked against the security database, but SQL privileges are checked for the provided user when it comes to accessing tables, views etc ... -- With regards, Thomas Steinmaurer * Upscene Productions - Database Tools for Developers http://www.upscene.com/ * My Blog http://blog.upscene.com/thomas/index.php * Firebird Foundation Committee Member http://www.firebirdsql.org/en/firebird-foundation/ -- This is an automated response. Your issue has been noted. We'll be in touch soon. Please reply to this email or visit the URL below with any additional details. http://DANTOIN:9675/portal/view-help-request/290 [Non-text portions of this message have been removed]
[Ticket #289] [firebird-support] Firebird ODBC driver: connection to an embedded server by usin...
This is a notification from the Help Desk. On Mar 07, 2014 @ 03:30 pm, patrick_mar...@yahoo.com wrote: Hello, how can I get Firebird ODBC driver to connect to an embedded server by using the security2.fdb? Is there any reason, why the security2.fdb is being ignored in that case at least by default? That way the ODBC connection can only be created with SYSDBA as user and there is no way to make the connection read only. I mean yes, you can check the checkbox read when creating the connection, but the end user can uncheck it at any time and gat a write access to the DB... For the ODBC connection to a normal server he could do the same of course, but since in that case the connection cen be created with a user, who has read rights only, it doesn't matter if the checkbox gets unchecked. Why can't it work the same with embedded server? That doesn't make sense to me... Can I accomplish it in any way? Kind regards, Patrick -- This is an automated response. Your issue has been noted. We'll be in touch soon. Please reply to this email or visit the URL below with any additional details. http://DANTOIN:9675/portal/view-help-request/289 [Non-text portions of this message have been removed]
[Ticket #290] [firebird-support] Re: Firebird ODBC driver: connection to an embedded server by ...
This is a notification from the Help Desk. On Mar 07, 2014 @ 03:30 pm, t...@iblogmanager.com wrote: creation of a ODBC connection to an embedded server works with SYSDBA only, is that correct? I was not able to create one with another user. No. You should be able to connect with a different user as well. It might fail for some reason because the specified user doesn't have sufficient privileges on database objects ... If that's not correct: what can be the reason for the problem I have when trying to create a connection with a different user. Don't know without telling us the error message you get. If that's correct: the only way would be to grant SYSDBA read only rights, correct? Is that possible at all? No. -- With regards, Thomas Steinmaurer * Upscene Productions - Database Tools for Developers http://www.upscene.com/ * My Blog http://blog.upscene.com/thomas/index.php * Firebird Foundation Committee Member http://www.firebirdsql.org/en/firebird-foundation/ --- In firebird-support@yahoogroups.com, Thomas Steinmaurerts@... wrote: how can I get Firebird ODBC driver to connect to an embedded server by using the security2.fdb? Is there any reason, why the security2.fdb is being ignored in that case at least by default? That way the ODBC connection can only be created with SYSDBA as user and there is no way to make the connection read only. I mean yes, you can check the checkbox read when creating the connection, but the end user can uncheck it at any time and gat a write access to the DB... For the ODBC connection to a normal server he could do the same of course, but since in that case the connection cen be created with a user, who has read rights only, it doesn't matter if the checkbox gets unchecked. Why can't it work the same with embedded server? That doesn't make sense to me... Can I accomplish it in any way? Embedded works that way: The provided user/password combination isn't checked against the security database, but SQL privileges are checked for the provided user when it comes to accessing tables, views etc ... -- With regards, Thomas Steinmaurer * Upscene Productions - Database Tools for Developers http://www.upscene.com/ * My Blog http://blog.upscene.com/thomas/index.php * Firebird Foundation Committee Member http://www.firebirdsql.org/en/firebird-foundation/ ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links ==Ticket History== On Mar 07, 2014 @ 03:30 pm, patrick_mar...@yahoo.com wrote: Thanks for your reply, creation of a ODBC connection to an embedded server works with SYSDBA only, is that correct? I was not able to create one with another user. If that's not correct: what can be the reason for the problem I have when trying to create a connection with a different user. If that's correct: the only way would be to grant SYSDBA read only rights, correct? Is that possible at all? --- In firebird-support@yahoogroups.com, Thomas Steinmaurer ts@... wrote: how can I get Firebird ODBC driver to connect to an embedded server by using the security2.fdb? Is there any reason, why the security2.fdb is being ignored in that case at least by default? That way the ODBC connection can only be created with SYSDBA as user and there is no way to make the connection read only. I mean yes, you can check the checkbox read when creating the connection, but the end user can uncheck it at any time and gat a write access to the DB... For the ODBC connection to a normal server he could do the same of course, but since in that case the connection cen be created with a user, who has read rights only, it doesn't matter if the checkbox gets unchecked. Why can't it work the same with embedded server? That doesn't make sense to me... Can I accomplish it in any way? Embedded works that way: The provided user/password combination isn't checked against the security database, but SQL privileges are checked for the provided user when it comes to accessing tables, views etc ... -- With regards, Thomas Steinmaurer * Upscene Productions - Database Tools for Developers http://www.upscene.com/ * My Blog http://blog.upscene.com/thomas/index.php * Firebird Foundation Committee Member http://www.firebirdsql.org/en/firebird-foundation/ -- This is an automated response. Your issue has been noted. We'll be in touch soon. Please reply to this email or visit the URL below with any additional details. http://DANTOIN:9675/portal/view-help-request/290 [Non-text portions of this message have been removed]
[Ticket #287] [firebird-support] Slow Database
This is a notification from the Help Desk. On Mar 07, 2014 @ 03:30 pm, t...@iblogmanager.com wrote: I have a website with PHP and a Firebird database. It looks like the Firebird database becomes very slow and I don't know, how to find where and why. My database is 15GB, the biggest table has about 30 million records. Right now I try to create the statistics, but it takes for ever. At the same time I try to monitor the database with the Sinatica tool. OAT and Next transaction are close, no GC pending. I would run gstat -h anyway. What I see is a lot warnings like invalid char set, but I think, this has nothing to do with performance. I'm also not aware of any statement not using indexes or so. Hmm, pretty dangerous. Although it won't help with what happened in the past, but use the Trace API, if you are using Firebird 2.5, to detect natural scan statements, long execution time etc ... What can I do? How do I find the bottle necks? It must be in Firebird, but I don't know, what I do wrong. 1) gstat -h 2) MON$ tables 3) Firebir 2.5 Trace API -- With regards, Thomas Steinmaurer * Upscene Productions - Database Tools for Developers http://www.upscene.com/ * My Blog http://blog.upscene.com/thomas/index.php * Firebird Foundation Committee Member http://www.firebirdsql.org/en/firebird-foundation/ ==Ticket History== On Mar 07, 2014 @ 03:30 pm, ch.kaufm...@splash-software.ch wrote: Hi, I have a website with PHP and a Firebird database. It looks like the Firebird database becomes very slow and I don't know, how to find where and why. My database is 15GB, the biggest table has about 30 million records. Right now I try to create the statistics, but it takes for ever. At the same time I try to monitor the database with the Sinatica tool. OAT and Next transaction are close, no GC pending. What I see is a lot warnings like invalid char set, but I think, this has nothing to do with performance. I'm also not aware of any statement not using indexes or so. What can I do? How do I find the bottle necks? It must be in Firebird, but I don't know, what I do wrong. cu Christian -- This is an automated response. Your issue has been noted. We'll be in touch soon. Please reply to this email or visit the URL below with any additional details. http://DANTOIN:9675/portal/view-help-request/287 [Non-text portions of this message have been removed]
[Ticket #347] [firebird-support] Feature not supported on ODS version older than 11.1 - how to ...
This is a notification from the Help Desk. On Mar 07, 2014 @ 03:31 pm, t...@iblogmanager.com wrote: I am trying to create the following SP but am receiving the message Feature not supported on ODS version older than 11.1 but I cannot work out what it is that it doesn't like about the SP. For information this is a Firebird 2.1 database but it is an ODS v10 SET AUTODDL OFF; SET TERM ^ ; CREATE PROCEDURE SP_LATEST_VACANCY_STATUS ( VACID INTEGER ) RETURNS ( STAUSNAME VARCHAR(500), LASTUPDATE DATETIME ) AS BEGIN FOR SELECT FIRST 1 VST.STATUSNAME, VCH.LASTUPDATE FROM VACCONT VCO, VACSTATUS VST, VACCONTHIST VCH WHERE VCO.VACID = :VACID AND VCO.STATUS = VST.STATUSID AND VCH.VACID = VCO.VACID AND VCO.CONTID = VCH.CONTID AND VCO.STATUS = VCH.STATUS ORDER BY VCO.STATUS DESC INTO :STATUSNAME, :LASTUPDATE DO SUSPEND; END ^ SET TERM ; ^ COMMIT WORK; Your user-defined domain DATETIME in the output parameter list? -- With regards, Thomas Steinmaurer * Firebird Foundation Committee Member http://www.firebirdsql.org/en/firebird-foundation/ * Upscene Productions - Database Tools for Developers http://www.upscene.com/ * My Blog http://blog.upscene.com/thomas/index.php ==Ticket History== On Mar 07, 2014 @ 03:31 pm, li...@2ls.com wrote: Hi I am trying to create the following SP but am receiving the message Feature not supported on ODS version older than 11.1 but I cannot work out what it is that it doesn't like about the SP. For information this is a Firebird 2.1 database but it is an ODS v10 SET AUTODDL OFF; SET TERM ^ ; CREATE PROCEDURE SP_LATEST_VACANCY_STATUS ( VACID INTEGER ) RETURNS ( STAUSNAME VARCHAR(500), LASTUPDATE DATETIME ) AS BEGIN FOR SELECT FIRST 1 VST.STATUSNAME, VCH.LASTUPDATE FROM VACCONT VCO, VACSTATUS VST, VACCONTHIST VCH WHERE VCO.VACID = :VACID AND VCO.STATUS = VST.STATUSID AND VCH.VACID = VCO.VACID AND VCO.CONTID = VCH.CONTID AND VCO.STATUS = VCH.STATUS ORDER BY VCO.STATUS DESC INTO :STATUSNAME, :LASTUPDATE DO SUSPEND; END ^ SET TERM ; ^ COMMIT WORK; -- This is an automated response. Your issue has been noted. We'll be in touch soon. Please reply to this email or visit the URL below with any additional details. http://DANTOIN:9675/portal/view-help-request/347 [Non-text portions of this message have been removed]
[Ticket #233] [firebird-support] Re: Problems selecting on Timestamp.
This is a notification from the Help Desk. On Mar 07, 2014 @ 03:29 pm, kjell.ri...@datadia.se wrote: Den 2011-11-09 09:49 skrev canacourse såhär: I assume you meant cast ('6.11.2011 08:35:26' as timestamp);? I have tried that but still no records are returned in Ibexpert or ISQL. Make sure your string literal is interpreted the way you think. If only people would come to their senses and adopt the ISO 8601 standard. *sigh* For example, does '6.11.2011 08:35:26' result in Nov 6 or June 11? Kjell [Non-text portions of this message have been removed] ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links ==Ticket History== On Mar 07, 2014 @ 03:29 pm, canacou...@gmail.com wrote: Thanks Helen, I assume you meant cast ('6.11.2011 08:35:26' as timestamp);? I have tried that but still no records are returned in Ibexpert or ISQL. TIA --- In firebird-support@yahoogroups.com, Helen Borrie helebor@... wrote: At 07:45 AM 9/11/2011, canacourse wrote: How may I select items older than a certain epoch from a timestamp column? For example I have many records in a column using timestamp as the type and containing records such as:- '5.11.2011 23:34:21' '5.11.2011 08:34:00' '6.11.2011 19:55:45' '7.11.2011 15:23:26' However these queries produce no results even thought I can see records older then I'm looking for in the table select * FROM ENTRIES WHERE ENTRYTIME '6/11/2011 08:34:26'; or select * FROM ENTRIES WHERE ENTRYTIME '6.11.2011 08:34:26'; Firebird 2.6.5 Dialect 3 You need a cast expression or a hint to ensure that the conversion from the literal occurs: select * FROM ENTRIES WHERE ENTRYTIME (cast '6/11/2011 08:34:26 as timestamp)'; or select * FROM ENTRIES WHERE ENTRYTIME timestamp '6/11/2011 08:34:26'; ./hb -- This is an automated response. Your issue has been noted. We'll be in touch soon. Please reply to this email or visit the URL below with any additional details. http://DANTOIN:9675/portal/view-help-request/233 [Non-text portions of this message have been removed]
[Ticket #348] [firebird-support] Re: Feature not supported on ODS version older than 11.1 - how...
This is a notification from the Help Desk. On Mar 07, 2014 @ 03:31 pm, li...@2ls.com wrote: Is the correct answer! Thanks Thomas. Neil --- In firebird-support@yahoogroups.com, Thomas Steinmaurer ts@... wrote: I am trying to create the following SP but am receiving the message Feature not supported on ODS version older than 11.1 but I cannot work out what it is that it doesn't like about the SP. For information this is a Firebird 2.1 database but it is an ODS v10 SET AUTODDL OFF; SET TERM ^ ; CREATE PROCEDURE SP_LATEST_VACANCY_STATUS ( VACID INTEGER ) RETURNS ( STAUSNAME VARCHAR(500), LASTUPDATE DATETIME ) AS BEGIN FOR SELECT FIRST 1 VST.STATUSNAME, VCH.LASTUPDATE FROM VACCONT VCO, VACSTATUS VST, VACCONTHIST VCH WHERE VCO.VACID = :VACID AND VCO.STATUS = VST.STATUSID AND VCH.VACID = VCO.VACID AND VCO.CONTID = VCH.CONTID AND VCO.STATUS = VCH.STATUS ORDER BY VCO.STATUS DESC INTO :STATUSNAME, :LASTUPDATE DO SUSPEND; END ^ SET TERM ; ^ COMMIT WORK; Your user-defined domain DATETIME in the output parameter list? -- With regards, Thomas Steinmaurer * Firebird Foundation Committee Member http://www.firebirdsql.org/en/firebird-foundation/ * Upscene Productions - Database Tools for Developers http://www.upscene.com/ * My Blog http://blog.upscene.com/thomas/index.php -- This is an automated response. Your issue has been noted. We'll be in touch soon. Please reply to this email or visit the URL below with any additional details. http://DANTOIN:9675/portal/view-help-request/348 [Non-text portions of this message have been removed]
[Ticket #234] [firebird-support] Re: Problems selecting on Timestamp.
This is a notification from the Help Desk. On Mar 07, 2014 @ 03:29 pm, kjell.ri...@datadia.se wrote: Den 2011-11-09 10:31 skrev canacourse såhär: Kjell, Doesn’t using the dot separator imply that non us date formats are being used? i.e. 07/11/2011 is interpreted as MM/DD/ while 07.11.2011 is interpreted as DD/MM/? Sorry, I don't know. I just wanted to point out that there are different ways to interpret a date string and that you should make sure that your date string is actually interpreted the way you intend. How you choose to do this is up to you: try it out in your DB (recommended), read docs, ask here, ... You could for example try this: select cast ('6.11.2011 08:35:26' as timestamp) from rdb$database select cast ('6.30.2011 08:35:26' as timestamp) from rdb$database select cast ('30.6.2011 08:35:26' as timestamp) from rdb$database Kjell [Non-text portions of this message have been removed] ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links ==Ticket History== On Mar 07, 2014 @ 03:29 pm, canacou...@gmail.com wrote: Kjell, Doesn’t using the dot separator imply that non us date formats are being used? i.e. 07/11/2011 is interpreted as MM/DD/ while 07.11.2011 is interpreted as DD/MM/? --- In firebird-support@yahoogroups.com, Kjell Rilbe kjell.rilbe@... wrote: Den 2011-11-09 09:49 skrev canacourse s�h�r: I assume you meant cast ('6.11.2011 08:35:26' as timestamp);? I have tried that but still no records are returned in Ibexpert or ISQL. Make sure your string literal is interpreted the way you think. If only people would come to their senses and adopt the ISO 8601 standard. *sigh* For example, does '6.11.2011 08:35:26' result in Nov 6 or June 11? Kjell [Non-text portions of this message have been removed] -- This is an automated response. Your issue has been noted. We'll be in touch soon. Please reply to this email or visit the URL below with any additional details. http://DANTOIN:9675/portal/view-help-request/234 [Non-text portions of this message have been removed]
[Ticket #403] [firebird-support] Deploy firebird with another password for sysdba user
This is a notification from the Help Desk. On Mar 07, 2014 @ 03:32 pm, hele...@iinet.net.au wrote: At 08:37 PM 14/11/2011, Mr. John wrote: Hi ! We need to deploy firebird server with another password for sysdba user. One solution is replacing security2.fdb during install of our application+server. Is it good solution ? It's not a solution. Change the SYSDBA password on the installation of the server at the site where you deploy it. Or, if you have regular users in *your* copy of security2.fdb that have permissions in the database (as you SHOULD have) then back up yours and restore it as sometempname.fdb on the new site. Then, shut down Firebird, delete the installation copy of security2.fdb, rename the sometempname.fdb version to security2.fdb and then change the SYSDBA password *before* doing anything else. ./hb -- This is an automated response. Your issue has been noted. We'll be in touch soon. Please reply to this email or visit the URL below with any additional details. http://DANTOIN:9675/portal/view-help-request/403 [Non-text portions of this message have been removed]
[Ticket #347] [firebird-support] Feature not supported on ODS version older than 11.1 - how to ...
This is a notification from the Help Desk. On Mar 07, 2014 @ 03:31 pm, li...@2ls.com wrote: Hi I am trying to create the following SP but am receiving the message Feature not supported on ODS version older than 11.1 but I cannot work out what it is that it doesn't like about the SP. For information this is a Firebird 2.1 database but it is an ODS v10 SET AUTODDL OFF; SET TERM ^ ; CREATE PROCEDURE SP_LATEST_VACANCY_STATUS ( VACID INTEGER ) RETURNS ( STAUSNAME VARCHAR(500), LASTUPDATE DATETIME ) AS BEGIN FOR SELECT FIRST 1 VST.STATUSNAME, VCH.LASTUPDATE FROM VACCONT VCO, VACSTATUS VST, VACCONTHIST VCH WHERE VCO.VACID = :VACID AND VCO.STATUS = VST.STATUSID AND VCH.VACID = VCO.VACID AND VCO.CONTID = VCH.CONTID AND VCO.STATUS = VCH.STATUS ORDER BY VCO.STATUS DESC INTO :STATUSNAME, :LASTUPDATE DO SUSPEND; END ^ SET TERM ; ^ COMMIT WORK; -- This is an automated response. Your issue has been noted. We'll be in touch soon. Please reply to this email or visit the URL below with any additional details. http://DANTOIN:9675/portal/view-help-request/347 [Non-text portions of this message have been removed]
[Ticket #388] [firebird-support] Re: Foreign key reference target does not exist. [FB 2.5 beta ...
This is a notification from the Help Desk. On Mar 07, 2014 @ 03:32 pm, adam.cir...@ri.t-com.hr wrote: Do you make FK over existing records?You probably already have old records in second table which refer to nonexistent PK in first table.Delete all old orphan records in second table, and then make FK. --- In firebird-support@yahoogroups.com, Isaac Bekheit isaac_cm@... wrote: hello, I tried to create a foreign key but I always get this error: violation of FOREIGN KEY constraint . violation of FOREIGN KEY constraint FK_RES_TREEVIEW_1 on table RES_TREEVIEW. Foreign key reference target does not exist. here is my two tables DDL: CREATE TABLE STYLES ( STYLE_ID INTEGER DEFAULT -1 NOT NULL, STYLE_NAMEVARCHAR(80) NOT NULL, BACK_COLORVARCHAR(35), BACK_COLOR_ENABLEDSMALLINT DEFAULT 0, FONT_STYLE_IS_UNDER SMALLINT DEFAULT 0, FONT_STYLE_IS_STRIKE SMALLINT DEFAULT 0, BITMAP_IMAGE BLOB SUB_TYPE 0 SEGMENT SIZE 80 ); ALTER TABLE STYLES ADD CONSTRAINT PK_STYLES1 PRIMARY KEY (STYLE_ID); === CREATE TABLE RES_TREEVIEW ( FOLDER_ID BIGINT NOT NULL, FOLDER_PARENT_IDBIGINT NOT NULL, FOLDER_NAME VARCHAR(100) NOT NULL, FOLDER_POSITION BIGINT NOT NULL, FOLDER_IMAGE_INDEX SMALLINT, FOLDER_FLAG BLOB SUB_TYPE 0 SEGMENT SIZE 80, FOLDER_ICON BLOB SUB_TYPE 0 SEGMENT SIZE 80, IS_FOLDER_CUSTOM_ICON SMALLINT DEFAULT 0, STYLE_IDINTEGER DEFAULT -1 ); ALTER TABLE RES_TREEVIEW ADD CONSTRAINT PK_RES_TREEVIEW PRIMARY KEY (FOLDER_ID); alter table RES_TREEVIEW add constraint FK_RES_TREEVIEW_1 foreign key (STYLE_ID) references STYLES(STYLE_ID) on delete SET DEFAULT on update CASCADE any advice ? Thanks -- This is an automated response. Your issue has been noted. We'll be in touch soon. Please reply to this email or visit the URL below with any additional details. http://DANTOIN:9675/portal/view-help-request/388 [Non-text portions of this message have been removed]
[Ticket #402] [firebird-support] Deploy firebird with another password for sysdba user
This is a notification from the Help Desk. On Mar 07, 2014 @ 03:32 pm, mr_joh...@yahoo.com wrote: That is working from inside NSIS installer: ExecWait 'gsec -user sysdba -password masterkey -modify SYSDBA -pw mypassword' ==Ticket History== On Mar 07, 2014 @ 03:32 pm, mr_joh...@yahoo.com wrote: Thank you,it is a fine solution ! -- On Mar 07, 2014 @ 03:32 pm, t...@iblogmanager.com wrote: Thanks Helen and Thomas for answers. Is it a way to change the password automatically,not manually,that I should do with my application install. Yes, automatically in a sense to run Firebird's 'gsec' utility during the installation (in the background). Check out the gsec manual here: http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/gsec.html -- With regards, Thomas Steinmaurer * Upscene Productions - Database Tools for Developers http://www.upscene.com/ * My Blog http://blog.upscene.com/thomas/index.php * Firebird Foundation Committee Member http://www.firebirdsql.org/en/firebird-foundation/ Thanks From: Helen Borriehele...@iinet.net.au To: firebird-support@yahoogroups.com Sent: Monday, November 14, 2011 10:22 AM Subject: Re: [firebird-support] Deploy firebird with another password for sysdba user At 08:37 PM 14/11/2011, Mr. John wrote: Hi ! We need to deploy firebird server with another password for sysdba user. One solution is replacing security2.fdb during install of our application+server. Is it good solution ? It's not a solution. Change the SYSDBA password on the installation of the server at the site where you deploy it. Or, if you have regular users in *your* copy of security2.fdb that have permissions in the database (as you SHOULD have) then back up yours and restore it as sometempname.fdb on the new site. Then, shut down Firebird, delete the installation copy of security2.fdb, rename the sometempname.fdb version to security2.fdb and then change the SYSDBA password *before* doing anything else. ./hb [Non-text portions of this message have been removed] ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links -- On Mar 07, 2014 @ 03:32 pm, mr_joh...@yahoo.com wrote: Thanks Helen and Thomas for answers. Is it a way to change the password automatically,not manually,that I should do with my application install. Thanks -- On Mar 07, 2014 @ 03:32 pm, t...@iblogmanager.com wrote: Hi ! We need to deploy firebird server with another password for sysdba user. One solution is replacing security2.fdb during install of our application+server. Is it good solution ? Thanks ! In addition what Helen said. Also don't use SYSDBA as owner for databases, database objects like tables, views etc ... Use your own Firebird user for that. Makes it much easier when deploying at an existing server installation with possibly no permission for getting SYSDBA-like information. -- With regards, Thomas Steinmaurer * Upscene Productions - Database Tools for Developers http://www.upscene.com/ * My Blog http://blog.upscene.com/thomas/index.php * Firebird Foundation Committee Member http://www.firebirdsql.org/en/firebird-foundation/ -- On Mar 07, 2014 @ 03:32 pm, mr_joh...@yahoo.com wrote: Hi ! We need to deploy firebird server with another password for sysdba user. One solution is replacing security2.fdb during install of our application+server. Is it good solution ? Thanks ! [Non-text portions of this message have been removed] -- This is an automated response. Your issue has been noted. We'll be in touch soon. Please reply to this email or visit the URL below with any additional details. http://DANTOIN:9675/portal/view-help-request/402 [Non-text portions of this message have been removed]
[Ticket #402] [firebird-support] Deploy firebird with another password for sysdba user
This is a notification from the Help Desk. On Mar 07, 2014 @ 03:32 pm, mr_joh...@yahoo.com wrote: Thanks Helen and Thomas for answers. Is it a way to change the password automatically,not manually,that I should do with my application install. Thanks ==Ticket History== On Mar 07, 2014 @ 03:32 pm, t...@iblogmanager.com wrote: Hi ! We need to deploy firebird server with another password for sysdba user. One solution is replacing security2.fdb during install of our application+server. Is it good solution ? Thanks ! In addition what Helen said. Also don't use SYSDBA as owner for databases, database objects like tables, views etc ... Use your own Firebird user for that. Makes it much easier when deploying at an existing server installation with possibly no permission for getting SYSDBA-like information. -- With regards, Thomas Steinmaurer * Upscene Productions - Database Tools for Developers http://www.upscene.com/ * My Blog http://blog.upscene.com/thomas/index.php * Firebird Foundation Committee Member http://www.firebirdsql.org/en/firebird-foundation/ -- On Mar 07, 2014 @ 03:32 pm, mr_joh...@yahoo.com wrote: Hi ! We need to deploy firebird server with another password for sysdba user. One solution is replacing security2.fdb during install of our application+server. Is it good solution ? Thanks ! [Non-text portions of this message have been removed] -- This is an automated response. Your issue has been noted. We'll be in touch soon. Please reply to this email or visit the URL below with any additional details. http://DANTOIN:9675/portal/view-help-request/402 [Non-text portions of this message have been removed]
[Ticket #404] [firebird-support] FIFO Valuation SP code help
This is a notification from the Help Desk. On Mar 07, 2014 @ 03:32 pm, venussof...@gmail.com wrote: Hi all I have a Stored Procedure as below. I know it is my handling of the calculated field bQtyOut which is wrong and that is where the error in the returned data set is. Can someone kindly point out to me where I am going wrong here? This is the line executed SELECT * FROM FIFOVALUATIONTRANSACTIONS(2759, 36) This is the returned set ITPBID ITPBNO TTPBDT ISPBIID TBQTY TBRATE TBQTYOUT 732 468 00:00:00.00025561.0035.63 0.00 712 445 00:00:00.00024205.0035.63 1.00 708 412 00:00:00.000237430.00 35.63 6.00 In the last row TBQTY should have been 29 (as that is the max. qty of that purchasebill) instead of 30, so the set should have been as below, also note the expected tbQtyOut values ITPBID ITPBNO TTPBDT ISPBIID TBQTY TBRATE TBQTYOUT 732 468 00:00:00.00025561.0035.63 1.00 712 445 00:00:00.00024205.0035.63 6.00 708 412 00:00:00.000237429.00 35.63 35.00 705 353 00:00:00.00023391.0035.63 36.00 Please advise Thanks and regards Bhavbhuti SET TERM ^ ; ALTER PROCEDURE FIFOVALUATIONTRANSACTIONS ( TIITEMID Integer, TBCURRSTOCK Double precision ) RETURNS ( ITPBID Integer, ITPBNO Integer, TTPBDT Time, ISPBIID Integer, TBQTY Double precision, TBRATE Double precision, TBQTYOUT Double precision ) AS --DECLARE VARIABLE variable_name datatype; BEGIN FOR SELECT itPBID , itPBNo , ttPBDt , isPBIID , bQty , bRate , bQtyOut FROM (SELECT itPBID , itPBNo , ttPBDt , isPBIID , IIF(bQty + bQtyOut = :tbCurrStock /*current stock */ , (:tbCurrStock /*current stock */ - bQtyOut) , bQty) as bQty , bRate , bQtyOut FROM (SELECT tPurchaseBill.iID AS itPBID , tPurchaseBill.iNo AS itPBNo , tPurchaseBill.tDt AS ttPBDt , sPurchaseBillItem.iID AS isPBIID , sPurchaseBillItem.bQty , sPurchaseBillItem.bRate , COALESCE((SELECT SUM(PurchaseBillItemInner.bQty) FROM sPurchaseBillItem AS PurchaseBillItemInner JOIN tPurchaseBill AS PurchaseBillInner ON PurchaseBillInner.iID = PurchaseBillItemInner.iPID WHERE (PurchaseBillInner.tDt tPurchaseBill.tDt AND PurchaseBillItemInner.iItemID = :tiItemID /* item id */)) , 0) AS bQtyOut FROM tPurchaseBill JOIN sPurchaseBillItem ON sPurchaseBillItem.iPID = tPurchaseBill.iID AND sPurchaseBillItem.iItemID = :tiItemID /* item id */ ORDER BY tPurchaseBill.tDt DESCENDING, tPurchaseBill.cBk DESCENDING, tPurchaseBill.iNo DESCENDING) AS PurchaseBillsIntermediate WHERE (bQtyOut = :tbCurrStock /*current stock */)) AS PurchaseBillsFIFO INTO :itPBID, :itPBNo, :ttPBDt, :isPBIID, :tbQty, :tbRate, :tbQtyOut DO SUSPEND; END^ SET TERM ; ^ GRANT EXECUTE ON PROCEDURE FIFOVALUATIONTRANSACTIONS TO SYSDBA; -- This is an automated response. Your issue has been noted. We'll be in touch soon. Please reply to this email or visit the URL below with any additional details. http://DANTOIN:9675/portal/view-help-request/404 [Non-text portions of this message have been removed]
[Ticket #402] [firebird-support] Deploy firebird with another password for sysdba user
This is a notification from the Help Desk. On Mar 07, 2014 @ 03:32 pm, mr_joh...@yahoo.com wrote: Thank you,it is a fine solution ! ==Ticket History== On Mar 07, 2014 @ 03:32 pm, t...@iblogmanager.com wrote: Thanks Helen and Thomas for answers. Is it a way to change the password automatically,not manually,that I should do with my application install. Yes, automatically in a sense to run Firebird's 'gsec' utility during the installation (in the background). Check out the gsec manual here: http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/gsec.html -- With regards, Thomas Steinmaurer * Upscene Productions - Database Tools for Developers http://www.upscene.com/ * My Blog http://blog.upscene.com/thomas/index.php * Firebird Foundation Committee Member http://www.firebirdsql.org/en/firebird-foundation/ Thanks From: Helen Borriehele...@iinet.net.au To: firebird-support@yahoogroups.com Sent: Monday, November 14, 2011 10:22 AM Subject: Re: [firebird-support] Deploy firebird with another password for sysdba user At 08:37 PM 14/11/2011, Mr. John wrote: Hi ! We need to deploy firebird server with another password for sysdba user. One solution is replacing security2.fdb during install of our application+server. Is it good solution ? It's not a solution. Change the SYSDBA password on the installation of the server at the site where you deploy it. Or, if you have regular users in *your* copy of security2.fdb that have permissions in the database (as you SHOULD have) then back up yours and restore it as sometempname.fdb on the new site. Then, shut down Firebird, delete the installation copy of security2.fdb, rename the sometempname.fdb version to security2.fdb and then change the SYSDBA password *before* doing anything else. ./hb [Non-text portions of this message have been removed] ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links -- On Mar 07, 2014 @ 03:32 pm, mr_joh...@yahoo.com wrote: Thanks Helen and Thomas for answers. Is it a way to change the password automatically,not manually,that I should do with my application install. Thanks -- On Mar 07, 2014 @ 03:32 pm, t...@iblogmanager.com wrote: Hi ! We need to deploy firebird server with another password for sysdba user. One solution is replacing security2.fdb during install of our application+server. Is it good solution ? Thanks ! In addition what Helen said. Also don't use SYSDBA as owner for databases, database objects like tables, views etc ... Use your own Firebird user for that. Makes it much easier when deploying at an existing server installation with possibly no permission for getting SYSDBA-like information. -- With regards, Thomas Steinmaurer * Upscene Productions - Database Tools for Developers http://www.upscene.com/ * My Blog http://blog.upscene.com/thomas/index.php * Firebird Foundation Committee Member http://www.firebirdsql.org/en/firebird-foundation/ -- On Mar 07, 2014 @ 03:32 pm, mr_joh...@yahoo.com wrote: Hi ! We need to deploy firebird server with another password for sysdba user. One solution is replacing security2.fdb during install of our application+server. Is it good solution ? Thanks ! [Non-text portions of this message have been removed] -- This is an automated response. Your issue has been noted. We'll be in touch soon. Please reply to this email or visit the URL below with any additional details. http://DANTOIN:9675/portal/view-help-request/402 [Non-text portions of this message have been removed]
[Ticket #390] [firebird-support] Buffer Overflow on Gentoo Linux Kernel 3.0.6
This is a notification from the Help Desk. On Mar 07, 2014 @ 03:32 pm, peshk...@mail.ru wrote: --- In firebird-support@yahoogroups.com, Matthias Hanft mh@... wrote: Hi, since many years, I've been using Firebird with Gentoo Linux kernels up to 2.6.38 without any problems - currently FB 2.0.3.12981.0-r6 (the newest stable version which is available as a Gentoo package). First of all I have to say (looking at this version) that gentoo currently does not support firebird packaging :-( You are _highly_recommended to use latest subrelease from SF. Now, I have built a new Gentoo system from scratch, of course with kernel 3.0.6 (different hardware, slightly different Linux .config). First, Firebird runs just normal, but when calling some special functions (for example, user rights management from IBExpert), it crashes because of a buffer overflow. I even do not remember - may be there was really BOF in that 2.0.3 dinosaurus:) And I do not know what method of user management is used in proprietary software like IBExpert. Can you try to reproduce using flamerobin if you prefer GUI tools? syslog says: Nov 13 18:43:41 n *** buffer overflow detected ***: fbserver - terminated Nov 13 18:43:41 n fbserver: buffer overflow attack in function unknown - terminated Nov 13 18:43:41 n Report to http://bugs.gentoo.org/ I did report to bugs.gentoo.org - https://bugs.gentoo.org/show_bug.cgi?id=390429 - but I'm not quite sure if this is a Gentoo or a Firebird issue. In addition, on the new system, in firebird.log, there are two messages at server start which I have never seen on the old system: n (Server) Sun Nov 13 18:43:41 2011 64 bit i/o support is on. Yes, 64 bit mode was something new 6 years ago. I do not remember details of this message .. n (Server) Sun Nov 13 18:43:41 2011 Open file limit increased from 1024 to 4096 .. and this too. But IMHO nothing bad happened. Perhaps this is a result of the slightly different Linux .config? There must be some more differences because starting FB (with /etc/init.d/ firebird start) on the old server says: * Starting Firebird server ... * WARNING: -o/--oknodo is deprecated and will be removed in the future * WARNING: -c/--chuid is deprecated and will be removed in the future, please use -u/--user instead * WARNING: -a/--startas is deprecated and will be removed in the future, please use -x/--exec or -n/--name instead server has been successfully started [ ok ] and on the new server * Starting Firebird server ... * WARNING: -o/--oknodo is deprecated and will be removed in the future * WARNING: -c/--chuid is deprecated and will be removed in the future, please use -u/--user instead * WARNING: -a/--startas is deprecated and will be removed in the future, please use -x/--exec or -n/--name instead check /var/log/firebird/firebird.log file for errors can not start server [ ok ] but the server is started anyway (sometimes the start scripts even hangs); in firebird.log, there is n (Client) Sun Nov 13 19:15:39 2011 INET/inet_error: connect errno = 111 (but only if the server is not listening on localhost; as it seems) While it's just uncomfortable not using IBExpert's rights management (GRANT etc. with fbsql *does* work), I'm afraid to put that FB installation into a production environment - what if those buffer overflows would also happen just in normal operation? This would be _real_bad_ ... Any hints? Try with 2.5.1. Or if you prefer 2.0 - 2.0.6. If BOF still persists - try to follow http://www.ibphoenix.com/resources/documents/search/doc_36 ==Ticket History== On Mar 07, 2014 @ 03:32 pm, m...@hanft.de wrote: Hi, since many years, I've been using Firebird with Gentoo Linux kernels up to 2.6.38 without any problems - currently FB 2.0.3.12981.0-r6 (the newest stable version which is available as a Gentoo package). Now, I have built a new Gentoo system from scratch, of course with kernel 3.0.6 (different hardware, slightly different Linux .config). First, Firebird runs just normal, but when calling some special functions (for example, user rights management from IBExpert), it crashes because of a buffer overflow. syslog says: Nov 13 18:43:41 n *** buffer overflow detected ***: fbserver - terminated Nov 13 18:43:41 n fbserver: buffer overflow attack in function unknown - terminated Nov 13 18:43:41 n Report to http://bugs.gentoo.org/ I did report to bugs.gentoo.org - https://bugs.gentoo.org/show_bug.cgi?id=390429 - but I'm not quite sure if this is a Gentoo or a Firebird issue. In addition, on the new system, in firebird.log, there are two messages at server start which I have never seen on the old system: n (Server) Sun Nov 13 18:43:41 2011 64 bit i/o support is on. n (Server) Sun Nov 13 18:43:41 2011 Open file
[Ticket #402] [firebird-support] Deploy firebird with another password for sysdba user
This is a notification from the Help Desk. On Mar 07, 2014 @ 03:32 pm, m...@lawinegevaar.nl wrote: No Comment. ==Ticket History== On Mar 07, 2014 @ 03:32 pm, mr_joh...@yahoo.com wrote: added,thanks ! -- On Mar 07, 2014 @ 03:32 pm, l...@frred.de wrote: Am 14.11.2011 10:05, schrieb Mr. John: That is working from inside NSIS installer: ExecWait 'gsec -user sysdba -password masterkey -modify SYSDBA -pw mypassword' Remember to check this with different OS. Under 2003/2008 you usually also have to add the security database as a parameter (local protocol won't work). Something like: gsec -database localhost:C:\Program Files\Firebird\security.fdb Luc. -- On Mar 07, 2014 @ 03:32 pm, t...@iblogmanager.com wrote: That is working from inside NSIS installer: ExecWait 'gsec -user sysdba -password masterkey -modify SYSDBA -pw mypassword' Good! ;-) -- With regards, Thomas Steinmaurer * Upscene Productions - Database Tools for Developers http://www.upscene.com/ * My Blog http://blog.upscene.com/thomas/index.php * Firebird Foundation Committee Member http://www.firebirdsql.org/en/firebird-foundation/ -- On Mar 07, 2014 @ 03:32 pm, mr_joh...@yahoo.com wrote: That is working from inside NSIS installer: ExecWait 'gsec -user sysdba -password masterkey -modify SYSDBA -pw mypassword' -- On Mar 07, 2014 @ 03:32 pm, mr_joh...@yahoo.com wrote: Thank you,it is a fine solution ! -- On Mar 07, 2014 @ 03:32 pm, t...@iblogmanager.com wrote: Thanks Helen and Thomas for answers. Is it a way to change the password automatically,not manually,that I should do with my application install. Yes, automatically in a sense to run Firebird's 'gsec' utility during the installation (in the background). Check out the gsec manual here: http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/gsec.html -- With regards, Thomas Steinmaurer * Upscene Productions - Database Tools for Developers http://www.upscene.com/ * My Blog http://blog.upscene.com/thomas/index.php * Firebird Foundation Committee Member http://www.firebirdsql.org/en/firebird-foundation/ Thanks From: Helen Borriehele...@iinet.net.au To: firebird-support@yahoogroups.com Sent: Monday, November 14, 2011 10:22 AM Subject: Re: [firebird-support] Deploy firebird with another password for sysdba user At 08:37 PM 14/11/2011, Mr. John wrote: Hi ! We need to deploy firebird server with another password for sysdba user. One solution is replacing security2.fdb during install of our application+server. Is it good solution ? It's not a solution. Change the SYSDBA password on the installation of the server at the site where you deploy it. Or, if you have regular users in *your* copy of security2.fdb that have permissions in the database (as you SHOULD have) then back up yours and restore it as sometempname.fdb on the new site. Then, shut down Firebird, delete the installation copy of security2.fdb, rename the sometempname.fdb version to security2.fdb and then change the SYSDBA password *before* doing anything else. ./hb [Non-text portions of this message have been removed] ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links -- On Mar 07, 2014 @ 03:32 pm, mr_joh...@yahoo.com wrote: Thanks Helen and Thomas for answers. Is it a way to change the password automatically,not manually,that I should do with my application install. Thanks -- On Mar 07, 2014 @ 03:32 pm, t...@iblogmanager.com wrote: Hi ! We need to deploy firebird server with another password for sysdba user. One solution is replacing security2.fdb during install of our application+server. Is it good solution ? Thanks ! In addition what Helen said. Also don't use SYSDBA as owner for databases, database objects like tables, views etc ... Use your own Firebird user for that. Makes it much easier when deploying at an existing server installation with possibly no permission for getting SYSDBA-like information. -- With regards, Thomas Steinmaurer * Upscene Productions - Database Tools for Developers http://www.upscene.com/ * My Blog http://blog.upscene.com/thomas/index.php * Firebird Foundation Committee Member http://www.firebirdsql.org/en/firebird-foundation/ -- On Mar 07, 2014 @ 03:32 pm, mr_joh...@yahoo.com wrote: Hi ! We need to deploy firebird server with another password for sysdba user. One solution is replacing security2.fdb during install of our application+server. Is it good solution ? Thanks ! [Non-text portions of this message have been removed] -- This is an automated response.
[Ticket #402] [firebird-support] Deploy firebird with another password for sysdba user
This is a notification from the Help Desk. On Mar 07, 2014 @ 03:32 pm, l...@frred.de wrote: Am 14.11.2011 10:05, schrieb Mr. John: That is working from inside NSIS installer: ExecWait 'gsec -user sysdba -password masterkey -modify SYSDBA -pw mypassword' Remember to check this with different OS. Under 2003/2008 you usually also have to add the security database as a parameter (local protocol won't work). Something like: gsec -database localhost:C:\Program Files\Firebird\security.fdb Luc. ==Ticket History== On Mar 07, 2014 @ 03:32 pm, t...@iblogmanager.com wrote: That is working from inside NSIS installer: ExecWait 'gsec -user sysdba -password masterkey -modify SYSDBA -pw mypassword' Good! ;-) -- With regards, Thomas Steinmaurer * Upscene Productions - Database Tools for Developers http://www.upscene.com/ * My Blog http://blog.upscene.com/thomas/index.php * Firebird Foundation Committee Member http://www.firebirdsql.org/en/firebird-foundation/ -- On Mar 07, 2014 @ 03:32 pm, mr_joh...@yahoo.com wrote: That is working from inside NSIS installer: ExecWait 'gsec -user sysdba -password masterkey -modify SYSDBA -pw mypassword' -- On Mar 07, 2014 @ 03:32 pm, mr_joh...@yahoo.com wrote: Thank you,it is a fine solution ! -- On Mar 07, 2014 @ 03:32 pm, t...@iblogmanager.com wrote: Thanks Helen and Thomas for answers. Is it a way to change the password automatically,not manually,that I should do with my application install. Yes, automatically in a sense to run Firebird's 'gsec' utility during the installation (in the background). Check out the gsec manual here: http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/gsec.html -- With regards, Thomas Steinmaurer * Upscene Productions - Database Tools for Developers http://www.upscene.com/ * My Blog http://blog.upscene.com/thomas/index.php * Firebird Foundation Committee Member http://www.firebirdsql.org/en/firebird-foundation/ Thanks From: Helen Borriehele...@iinet.net.au To: firebird-support@yahoogroups.com Sent: Monday, November 14, 2011 10:22 AM Subject: Re: [firebird-support] Deploy firebird with another password for sysdba user At 08:37 PM 14/11/2011, Mr. John wrote: Hi ! We need to deploy firebird server with another password for sysdba user. One solution is replacing security2.fdb during install of our application+server. Is it good solution ? It's not a solution. Change the SYSDBA password on the installation of the server at the site where you deploy it. Or, if you have regular users in *your* copy of security2.fdb that have permissions in the database (as you SHOULD have) then back up yours and restore it as sometempname.fdb on the new site. Then, shut down Firebird, delete the installation copy of security2.fdb, rename the sometempname.fdb version to security2.fdb and then change the SYSDBA password *before* doing anything else. ./hb [Non-text portions of this message have been removed] ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links -- On Mar 07, 2014 @ 03:32 pm, mr_joh...@yahoo.com wrote: Thanks Helen and Thomas for answers. Is it a way to change the password automatically,not manually,that I should do with my application install. Thanks -- On Mar 07, 2014 @ 03:32 pm, t...@iblogmanager.com wrote: Hi ! We need to deploy firebird server with another password for sysdba user. One solution is replacing security2.fdb during install of our application+server. Is it good solution ? Thanks ! In addition what Helen said. Also don't use SYSDBA as owner for databases, database objects like tables, views etc ... Use your own Firebird user for that. Makes it much easier when deploying at an existing server installation with possibly no permission for getting SYSDBA-like information. -- With regards, Thomas Steinmaurer * Upscene Productions - Database Tools for Developers http://www.upscene.com/ * My Blog http://blog.upscene.com/thomas/index.php * Firebird Foundation Committee Member http://www.firebirdsql.org/en/firebird-foundation/ -- On Mar 07, 2014 @ 03:32 pm, mr_joh...@yahoo.com wrote: Hi ! We need to deploy firebird server with another password for sysdba user. One solution is replacing security2.fdb during install of our application+server. Is it good solution ? Thanks ! [Non-text portions of this message have been removed] -- This is an automated response. Your issue has been noted. We'll be in touch soon. Please reply to this email or visit the URL below with any additional details.
[Ticket #402] [firebird-support] Deploy firebird with another password for sysdba user
This is a notification from the Help Desk. On Mar 07, 2014 @ 03:32 pm, t...@iblogmanager.com wrote: Hi ! We need to deploy firebird server with another password for sysdba user. One solution is replacing security2.fdb during install of our application+server. Is it good solution ? Thanks ! In addition what Helen said. Also don't use SYSDBA as owner for databases, database objects like tables, views etc ... Use your own Firebird user for that. Makes it much easier when deploying at an existing server installation with possibly no permission for getting SYSDBA-like information. -- With regards, Thomas Steinmaurer * Upscene Productions - Database Tools for Developers http://www.upscene.com/ * My Blog http://blog.upscene.com/thomas/index.php * Firebird Foundation Committee Member http://www.firebirdsql.org/en/firebird-foundation/ ==Ticket History== On Mar 07, 2014 @ 03:32 pm, mr_joh...@yahoo.com wrote: Hi ! We need to deploy firebird server with another password for sysdba user. One solution is replacing security2.fdb during install of our application+server. Is it good solution ? Thanks ! [Non-text portions of this message have been removed] -- This is an automated response. Your issue has been noted. We'll be in touch soon. Please reply to this email or visit the URL below with any additional details. http://DANTOIN:9675/portal/view-help-request/402 [Non-text portions of this message have been removed]
[Ticket #390] [firebird-support] Buffer Overflow on Gentoo Linux Kernel 3.0.6
This is a notification from the Help Desk. On Mar 07, 2014 @ 03:32 pm, m...@hanft.de wrote: Hi, since many years, I've been using Firebird with Gentoo Linux kernels up to 2.6.38 without any problems - currently FB 2.0.3.12981.0-r6 (the newest stable version which is available as a Gentoo package). Now, I have built a new Gentoo system from scratch, of course with kernel 3.0.6 (different hardware, slightly different Linux .config). First, Firebird runs just normal, but when calling some special functions (for example, user rights management from IBExpert), it crashes because of a buffer overflow. syslog says: Nov 13 18:43:41 n *** buffer overflow detected ***: fbserver - terminated Nov 13 18:43:41 n fbserver: buffer overflow attack in function unknown - terminated Nov 13 18:43:41 n Report to http://bugs.gentoo.org/ I did report to bugs.gentoo.org - https://bugs.gentoo.org/show_bug.cgi?id=390429 - but I'm not quite sure if this is a Gentoo or a Firebird issue. In addition, on the new system, in firebird.log, there are two messages at server start which I have never seen on the old system: n (Server) Sun Nov 13 18:43:41 2011 64 bit i/o support is on. n (Server) Sun Nov 13 18:43:41 2011 Open file limit increased from 1024 to 4096 Perhaps this is a result of the slightly different Linux .config? There must be some more differences because starting FB (with /etc/init.d/ firebird start) on the old server says: * Starting Firebird server ... * WARNING: -o/--oknodo is deprecated and will be removed in the future * WARNING: -c/--chuid is deprecated and will be removed in the future, please use -u/--user instead * WARNING: -a/--startas is deprecated and will be removed in the future, please use -x/--exec or -n/--name instead server has been successfully started [ ok ] and on the new server * Starting Firebird server ... * WARNING: -o/--oknodo is deprecated and will be removed in the future * WARNING: -c/--chuid is deprecated and will be removed in the future, please use -u/--user instead * WARNING: -a/--startas is deprecated and will be removed in the future, please use -x/--exec or -n/--name instead check /var/log/firebird/firebird.log file for errors can not start server [ ok ] but the server is started anyway (sometimes the start scripts even hangs); in firebird.log, there is n (Client) Sun Nov 13 19:15:39 2011 INET/inet_error: connect errno = 111 (but only if the server is not listening on localhost; as it seems) While it's just uncomfortable not using IBExpert's rights management (GRANT etc. with fbsql *does* work), I'm afraid to put that FB installation into a production environment - what if those buffer overflows would also happen just in normal operation? This would be _real_bad_ ... Any hints? Thank you, -Matt ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links -- This is an automated response. Your issue has been noted. We'll be in touch soon. Please reply to this email or visit the URL below with any additional details. http://DANTOIN:9675/portal/view-help-request/390 [Non-text portions of this message have been removed]
[firebird-support] Backup
I am trying to make a backup of our database that is on a Unix box, from my windows computer. I have used: Firebird Maestro, IP Firebird Database Manager, Firebird SQL Studio. I am not sure if I am doing something wrong, or just not possible. When I run the backup from these tools, and select the database and final location and press start, it looks like it is going thru a backup process, but the fbk file is not created on my computer. I am new to firebird and the GUI Tools that may be available. Any assistance is appreciated. Art
Re: [firebird-support] Backup
Em 7/3/2014 14:13, Art McCabe escreveu: I am trying to make a backup of our database that is on a Unix box, from my windows computer. I have used: Firebird Maestro, IP Firebird Database Manager, Firebird SQL Studio. I am not sure if I am doing something wrong, or just not possible. When I run the backup from these tools, and select the database and final location and press start, it looks like it is going thru a backup process, but the fbk file is not created on my computer. I am new to firebird and the GUI Tools that may be available. Any assistance is appreciated. Art I don't know any of these tools... But I strongly suggest that you use the native firebird applications use gbak for back-up (it's on the installation directory under the bin folder) the most simple way is: gbak IP_OF_THE_SERVER:NAME_OF_YOUR_DATABASE NAME_OF_BACKUP_FILE -user sysdba -password masterkey -v of course change the password for the one you defined. the -v switch is optional, but I think it will hep you once it will show the progress see you !
[firebird-support] Firebird - Any way to query between databases
I have a growing number of databases with essentially the same table structures that must remain as separate entities. However, a large number of the tables in these databases house exactly the same valid values (Lookup Tables). If I add a new valid value, I migrate through each database to update the tables as needed. I would love to have a single valid value database that only held these tables and have all my other databases query the valid value database for the information. As I understand it, this is not possible at this point in time. Are there any plans that will permit this in future versions of Firebird?
Re: [firebird-support] Backup
Thank you, I used the gbak to run the backup and that worked. Art From: Alexandre Benson Smith Sent: Friday, March 7, 2014 2:09 PM To: firebird-support@yahoogroups.com Em 7/3/2014 14:13, Art McCabe escreveu: I am trying to make a backup of our database that is on a Unix box, from my windows computer. I have used: Firebird Maestro, IP Firebird Database Manager, Firebird SQL Studio. I am not sure if I am doing something wrong, or just not possible. When I run the backup from these tools, and select the database and final location and press start, it looks like it is going thru a backup process, but the fbk file is not created on my computer. I am new to firebird and the GUI Tools that may be available. Any assistance is appreciated. Art I don't know any of these tools... But I strongly suggest that you use the native firebird applications use gbak for back-up (it's on the installation directory under the bin folder) the most simple way is: gbak IP_OF_THE_SERVER:NAME_OF_YOUR_DATABASE NAME_OF_BACKUP_FILE -user sysdba -password masterkey -v of course change the password for the one you defined. the -v switch is optional, but I think it will hep you once it will show the progress see you !
[firebird-support] Changing Classic server LockHashSlots setting
Hey guys! I want to ask this question (even though I know the answer) in case someone else might want to know in the future. Can/should the Firebird.conf LockHashSlots value be changed while databases are open/engine is running? I think the answer is No but I want to ask this question in case someone else might want to know in the future (ie. Want to google it). Sean
RE: [firebird-support] Windows firewall and multi-user access.
We have an application using Delphi, IBObjects and Firebird, which is being run in both a single-user and multi-user basis. The multi-user version has users on separate PCs operating against a single Firebird DB on a server. Lately, after releasing an updated version (in which the Firebird server is changed from V2.1 to v2.5), some users have noticed that on one form, if two users are using the form on two PCs, one user's changes can cause the other user's cursor (the selected item) to change. That is impossible. Firebird cursors tied to statements, statements are tied to a database connection, each application would open separate connection(s). Now here's the zinger. One of the users had been running Windows Firewall in public mode. When he changed to work mode, the problem went away. Does this seem counter-intuitive? Is there a Windows issue underlying, or with Firebird 2.5? Again, makes no sense. Sean
Re: [firebird-support] Windows firewall and multi-user access.
From: Leyne, Sean We have an application using Delphi, IBObjects and Firebird, which is being run in both a single-user and multi-user basis. The multi-user version has users on separate PCs operating against a single Firebird DB on a server. Lately, after releasing an updated version (in which the Firebird server is changed from V2.1 to v2.5), some users have noticed that on one form, if two users are using the form on two PCs, one user's changes can cause the other user's cursor (the selected item) to change. That is impossible. Not necessarily. If he is using events, it could be causing the program to respond to the event by reloading the listing or something which wouldn't happen if the firewall is blocking the port. (I think, anyway.) Woody (TMW)
RE: [firebird-support] Windows firewall and multi-user access.
Woody, We have an application using Delphi, IBObjects and Firebird, which is being run in both a single-user and multi-user basis. The multi-user version has users on separate PCs operating against a single Firebird DB on a server. Lately, after releasing an updated version (in which the Firebird server is changed from V2.1 to v2.5), some users have noticed that on one form, if two users are using the form on two PCs, one user's changes can cause the other user's cursor (the selected item) to change. That is impossible. Not necessarily. If he is using events, it could be causing the program to respond to the event by reloading the listing or something which wouldn't happen if the firewall is blocking the port. (I think, anyway.) OK, you are correct, that is a possibility but one which unusual/very specific to the application. Under normal operations (no db events logic) it is impossible. Sean
Re: [firebird-support] Windows firewall and multi-user access.
We have an application using Delphi, IBObjects and Firebird, which is being run in both a single-user and multi-user basis. The multi-user version has users on separate PCs operating against a single Firebird DB on a server. Lately, after releasing an updated version (in which the Firebird server is changed from V2.1 to v2.5), Coincidence re the change of server version. some users have noticed that on one form, if two users are using the form on two PCs, one user's changes can cause the other user's cursor (the selected item) to change. From: Leyne, Sean That is impossible. At 12:00 p.m. 8/03/2014, Woody wrote: Not necessarily. If he is using events, it could be causing the program to respond to the event by reloading the listing or something which wouldn't happen if the firewall is blocking the port. (I think, anyway.) I agree with that. The way the auxiliary port for events (RemoteAuxPort in firebird.conf) is configured will matter here. If you don't configure it explicitly, events will just use the first available open port. If no port is available, events just don't happen. Same if you don't open the configured port in the firewall. And if the user's transaction is running in ReadCommitted, any refresh of the dataset will reflect changes committed since the last open or refresh, even if events are not involved. I think another crucial issue here might be developer amnesia about an IBO feature called DML Caching, that can keep individual connections informed of changes by other connections, in ways that are transparent to the human user. If you can find DMLCache or anything related to it in your source code, you'll be able to trace what has been set up to happen at each client. Further questions on the application side should go the IBO list, not here. Helen Borrie, Support Consultant, IBPhoenix (Pacific) Author of The Firebird Book and The Firebird Book Second Edition http://www.firebird-books.net __
[firebird-support] Re: Changing Classic server LockHashSlots setting
08.03.2014 02:39, Leyne, Sean wrote: I want to ask this question (even though I know the answer) in case someone else might want to know in the future. Can/should the Firebird.conf LockHashSlots value be changed while databases are open/engine is running? I think the answer is “No” but I want to ask this question in case someone else might want to know in the future (ie. Want to google it). All lock manager settings can be changed at runtime, but the new values will be used only after everybody disconnects (thus destroying the lock table). Dmitry ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ * Your email settings: Individual Email | Traditional * To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) * To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com * To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com * Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/