Re: [firebird-support] Re: Inssuficient rights for operation....
I find the error... It is not a FIREBIRD problem..it's BDE (Borland database engine) alias problem connection to database. When I install BDEINfoSetup, the INTRBASE alias have not the ROLE NAME attribute. From my application i provide to BDE alias username, password and role, but because ROLE NAME attribute not exist in BDE alias, the connection is made...without role...and the error appear!!! The solution: in key [HKEY_LOCAL_MACHINE\SOFTWARE\Borland\Database Engine\Settings\DRIVERS\INTRBASE\DB OPEN] append ROLE NAME= and the application work fine!
Re: [firebird-support] Re: Memory usage excess / leak in FBServer 2.5.4
Hello Vlad, is there a location where I can download a win64 installer package of a nightly build including the fix, or when will 2.5.5 be released officially? Would need this for automatic installation. -- Joja Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Gesendet: Dienstag, 9. Juni 2015 10:01 An: firebird-support@yahoogroups.com Betreff: Re: AW: AW: AW: AW: [firebird-support] Re: Memory usage excess / leak in FBServer 2.5.4 ---In firebird-support@yahoogroups.com, joja.lists@... wrote : The production system is running till yesterday 14h00 (UTC+2) with no increase in memory consumption. Problem solved. Well done. Thanks a lot. Thank you ! Vlad hi, http://www.firebirdsql.org/en/snapshot-builds/ regards, Karol Bieniaszewski
AW: [firebird-support] Re: Memory usage excess / leak in FBServer 2.5.4
is there a location where I can download a win64 installer package of a nightly build including the fix, or when will 2.5.5 be released officially? http://www.firebirdsql.org/en/snapshot-builds/ There are only zip packages, no installer packages. -- Joja
Re: AW: [firebird-support] Re: Memory usage excess / leak in FBServer 2.5.4
W dniu 2015-06-10 14:30:52 użytkownik 'Jojakim Stahl' joja.li...@jojakim.de [firebird-support] firebird-support@yahoogroups.com napisał: is there a location where I can download a win64 installer package of a nightly build including the fix, or when will 2.5.5 be released officially? http://www.firebirdsql.org/en/snapshot-builds/ There are only zip packages, no installer packages. -- Joja Hi, you mean - exe file installer? For snapshot it not exists But if this is single installation then you can replace folder already contained files For new installation- unzip file and there is install bat files regards, Karol Bieniaszewski
[firebird-support] GROUP BY optional with constants?
I did a mistake with a query I wrote (Fb 2.5.3 or 2.5.4), but to my surprise Firebird did not complain and gave me the desired result. What I found was that whilst Firebird complains about missing GROUP BY if writing something like SELECT 'This does not work', RDB$RELATION_ID, list(RDB$CHARACTER_SET_NAME) FROM RDB$DATABASE It does not complain if constants are used: SELECT 'This works', list(RDB$CHARACTER_SET_NAME) FROM RDB$DATABASE or even SELECT 'This works', RDB$RELATION_ID, list(RDB$CHARACTER_SET_NAME) FROM RDB$DATABASE GROUP BY 2 Now, I do not object to not having to write GROUP BY - I'm just very surprised that it seems to be optional with constants. Is there any particular reason, or is this a 'bug to be appreciated rather than fixed'? Set
[firebird-support] Re: Memory usage excess / leak in FBServer 2.5.4
Hello Vlad, is there a location where I can download a win64 installer package of a nightly build including the fix, or when will 2.5.5 be released officially? Would need this for automatic installation. -- Joja Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Gesendet: Dienstag, 9. Juni 2015 10:01 An: firebird-support@yahoogroups.com Betreff: Re: AW: AW: AW: AW: [firebird-support] Re: Memory usage excess / leak in FBServer 2.5.4 ---In firebird-support@yahoogroups.com, joja.lists@... wrote : The production system is running till yesterday 14h00 (UTC+2) with no increase in memory consumption. Problem solved. Well done. Thanks a lot. Thank you ! Vlad
RE: [firebird-support] C:\Program Files\Firebird\Firebird_2_0\bin\fbserver.exe: terminated abnormally (4294967295)
Manny, Since I haven’t seen any responses to your question I figure I’d submit my experience with that error. This is probably a shot in the dark, be we had an issue with our Firebird Superserver restarting in Linux repeatedly. The cause if the issues were our UDFs. Whenever a user tried to run a process that tried to access the bad UDFs, the server crashed. In Our case we moved to a new server and had to recompile the UDFs and it was recompiled incorrectly. The server started successfully, but crashed as soon as we tried to access the UDF. The Firebird log didn’t record anything other than that “Abnormal Termination” message. In our Linux environment I had to use the strace command to capture additional debug info and saw that the server was trying to access a DLL which should have been compiled into the UDFs. If this doesn’t help, maybe you’d want to run a similar tracing utility on the Database server instance. Below is a link to Stackoverflow site for strace equivalents for the windows OS. http://stackoverflow.com/questions/3847745/systrace-for-windows I hope this is useful. Ed Mendez From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Monday, June 8, 2015 6:36 PM To: firebird-support@yahoogroups.com Subject: [firebird-support] C:\Program Files\Firebird\Firebird_2_0\bin\fbserver.exe: terminated abnormally (4294967295) About 2 months ago we are having multiple clients report issues with firebird restarting overnight or during the day randomly. For some this happens about 10 time a week and others 10 a day. We use Firebird 2.0 and 2.5 and this issue is happening on both versions, but it is only happening to about 5% of our clients. I have verified the power settings are correct, firewalls are open and anti-virus have exceptions to firebird. Any direction and or help will be greatly appreciated. Log Name: Application Source:FirebirdGuardianDefaultInstance Date: 6/8/2015 11:40:47 AM Event ID: 281 Task Category: None Level: Error Keywords: Classic User: N/A Computer: PC Description: The description for Event ID 281 from source FirebirdGuardianDefaultInstance cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer. If the event originated on another computer, the display information had to be saved with the event. The following information was included with the event: Abnormal Termination: C:\Program Files\Firebird\Firebird_2_0\bin\fbserver.exe: terminated abnormally (4294967295) Event Xml: Event xmlns=http://schemas.microsoft.com/win/2004/08/events/event; System Provider Name=FirebirdGuardianDefaultInstance / EventID Qualifiers=0281/EventID Level2/Level Task0/Task Keywords0x80/Keywords TimeCreated SystemTime=2015-06-08T15:40:47.0Z / EventRecordID299675/EventRecordID ChannelApplication/Channel ComputerPC/Computer Security / /System EventData DataAbnormal Termination: C:\Program Files\Firebird\Firebird_2_0\bin\fbserver.exe: terminated abnormally (4294967295)/Data /EventData /Event [Non-text portions of this message have been removed]
Re: [firebird-support] Re: Firebird 2.5.4 - CentOS - mon$remote_address 0.0.0.0
Hello , So Dmitry suggested it , we have disabled IPV6 on our server CentOS 7 (Firebird 2.5.4 Classic server (I forgot to mention it in my first mail)). By following the centos FAQ : http://wiki.centos.org/FAQ/CentOS7#head-8984faf811faccca74c7bcdd74de7467f2fcd8ee Rebooting the server. But even after this modification the mon$remote_address is still giving 0.0.0.0 Any ideas are welcome. Is this a real remote connection from a remote client or an attachment locally on the server? -- With regards, Thomas Steinmaurer http://www.upscene.com Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. Marianne De : firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Envoyé : lundi 8 juin 2015 12:47 À : firebird-support@yahoogroups.com Objet : [firebird-support] Re: Firebird 2.5.4 - CentOS - mon$remote_address 0.0.0.0 08.06.2015 10:02, Marianne Castel wrote: We were working with Firebird 2.5.2 on Debian . At that time, in the monitoring table MON$ATTACHEMENTS I could see the IP address of the client connected to a database. Now our administrators have decided to work with CentOS and the last available packages thus Firebird 2.5.4, and now in the databases on that server in the table MON$ATTACHEMENTS table the field mon$remote_address always contains : 0.0.0.0 May be that the server is different too (network connection?) … Any idea why the IP address is no more reported ? How could we have the IP address again in the monitoring table ? Interesting. One possible explanation can be found here: http://stackoverflow.com/questions/17220006/in-what-conditions-getpeername-returns-ipport-0-0-0-00 Firebird 2.x does not support IPv6 and always listens on a AF_INET (i.e. v4) socket, but maybe it could be related somehow. Have you tried to disable IPv6 on the new server box? Dmitry
Re: [firebird-support] Re: Inssuficient rights for operation....
Hello. I used Firebird 1.5.6 on server on WIN7, a database with a role with full rights, and a user defined in ROLE, USER. I have a problem. In the network with a application, on different client station, login with the USER, all functions work OK. From server or another WIN7 station, with USER login, a have one error, with insufficient sql rights for operation, no permission to read/select acces to TABLE. All different functions work OK. ROLE with GRANTS in all tables. The solution from win7 is to give rights on USER for table CONFIG_BALANTA, the rights from the ROLE give this error WHY THE DIFFERENT functionality? Same user, same rights on database. Is the user is providing the role name at connect time? -- With regards, Thomas Steinmaurer http://www.upscene.com Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
[firebird-support] Dragging things up to date ...
OK just been going around in circles trying to find notes on converting from NONE to UTF8 and not getting anywhere ... Historically I've always been happy with NONE, but these days all the web site traffic is UTF8 so I think it's time to start tidying up, and so I THINK I need to switch the default to UTF8. Although the UTF8 data seems to be getting stored fine under NONE ... or has that just been luck until now. All the metadata is simple 7 bit ASCII, so it's only text content that matters. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk Rainbow Digital Media - http://rainbowdigitalmedia.co.uk
[firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)
We have backed up our databases daily for two years using Firebird 2.52 Superserver and its associated gbak. We now need to restore one of the databases and gbak fails to do the restore, giving the following error: gbak:restoring column DISCOUNT gbak:restoring column DEPOSIT gbak:restoring column MAXPRICE gbak:restoring column COST gbak:restoring column SHIPPING gbak:restoring column REFID gbak:restoring column PAID_DOWN gbak:restoring column PAID_LAST gbak:restoring column INVOICE gbak:restoring column SOURCE gbak:restoring column NAME gbak:restoring column STOCKID gbak:restoring column STOCKNO gbak:restoring column HOME gbak:restoring column OFFICE gbak:restoring column OFCLABEL gbak:restoring column BEEPER gbak:restoring column BEEPERLABEL gbak:restoring column QTY gbak:restoring column QTY_REC gbak:restoring column QTY_PRI gbak:restoring column QTY_SEC gbak:restoring column QTY_BO gbak:restoring column ORDERED_FROM gbak:restoring column ORDER_FROM gbak:restoring column STATUS gbak:restoring column AVAILABLE gbak:restoring column NOTES gbak:restoring column EMAIL gbak:restoring column THIRDSRC gbak:restoring column HOW_NOTIFIED gbak:restoring column PREV_NOTIFY gbak:restoring column EDITION gbak:restoring column FORMAT gbak:restoring column CONDITION gbak:restoring column SIGNED gbak:restoring column BINDING gbak:restoring column WAITCHECK gbak:restoring column STOCKTYPE gbak:restoring column GIFT gbak:restoring column CREDITCARD gbak:restoring column NON_TAXABLE gbak:restoring column DONT_COUNT gbak:restoring column REORDER gbak:restoring column RECTYPE gbak:restoring column SPECIAL gbak:restoring column LOGGED gbak:restoring table REQUESTS gbak:restoring column WHO_ENTERED gbak:restoring column DATE_ENTERED gbak:restoring column ISBN gbak:restoring column NEW_ID gbak:restoring column STOCKNO gbak:restoring column NOTES gbak:restoring column STATUS gbak:restoring column PRICE_RANGE gbak:restoring column ISSUED gbak:restoring column PUBLISHER gbak:restoring column ID gbak:restoring column AUTHOR gbak:restoring column TITLE gbak:restoring column SOFTWARE gbak:restoring column GAME gbak:restoring column PAPERBACK gbak:restoring column HARDBACK gbak:restoring column CASSETTE gbak:restoring column VIDEO gbak:restoring column DVD gbak:restoring column CDROM gbak:restoring column DISKFIVE gbak:restoring column DISKTHREE gbak:restoring column READINGCOPY gbak:restoring column BOOKCLUB gbak:restoring column FIRST_ED gbak:restoring table STANDING gbak:restoring column WHO_ENTERED gbak:restoring column LASTONE gbak:restoring column TITLE gbak:restoring column AUTHOR gbak:restoring column NAME gbak:restoring table INVOICES gbak:restoring column PAID gbak:restoring column INVOICEDATE gbak:restoring column AMOUNT gbak:restoring column NUMBER gbak:restoring column CUSTOMER_ID gbak:restoring table ON_ORDER gbak:restoring column DATE_TO_SHIPPING gbak:restoring column WHO_TO_SHIPPING gbak:restoring column DATE_EMAILEDSHIP gbak:restoring column WHO_EMAILEDSHIP gbak:restoring column WHO_SHIPPED gbak:restoring column TOSHIPPING gbak:restoring column DATE_RECEIVED gbak:restoring column DATE_ORDERED gbak:restoring column DATE_MODIFIED gbak:restoring column DATE_ENTERED gbak:restoring column DATE_CANCELLED gbak:restoring column PONUM gbak:restoring column WHO_PAID gbak:restoring column DATE_LAST_PAID gbak:restoring column SKIP_NOTIFY gbak:restoring column WHO_WAITCHECK gbak:restoring column WHO_LAST_NOTIFIED gbak:restoring column WHO_NOTIFIED gbak:restoring column WHO_RECEIVED gbak:restoring column WHO_ORDERED gbak:restoring column WHO_MODIFIED gbak:restoring column WHO_ENTERED gbak:restoring column DATE_WAITCHECK gbak:restoring column DATE_LAST_NOTIFIED gbak:restoring column DATE_NOTIFIED gbak:restoring column DATE_EXPECTED gbak:restoring column WEBORDER gbak:restoring column REFID gbak:restoring column SHIPPING gbak:restoring column COST gbak:restoring column MAXPRICE gbak:restoring column DEPOSIT gbak:restoring column DISCOUNT gbak:restoring column SELLPRICE gbak:restoring column LISTPRICE gbak:restoring column AUTHOR gbak:restoring column SOURCE gbak:restoring column INVOICE gbak:restoring column PAID_LAST gbak:restoring column PAID_DOWN gbak:restoring column PICKINGUP gbak:restoring column CODE gbak:restoring column SHIPPING_STATUS gbak:restoring column DIGITS gbak:restoring column TRACKING gbak:restoring column WAITCHECK gbak:restoring column BINDING gbak:restoring column SIGNED gbak:restoring