Re: [firebird-support] permissions nbackup

The default linux tar install has the following for security2.fdb amongst others MakeFileFirebirdWritable() { FileName=$1 chown $RunUser:$RunGroup $FileName if [ "$RunUser" = "root" ] # In that case we must open databases, locks, etc. to the world... # That's a

Re: [firebird-support] permissions nbackup

Apologies, it does get changed, I was looking in the wrong place in the MacOS installer... SuperServer chmod 600 security2.fdb Classic chmod 660 security2.fdb Regards Paul

Re: [firebird-support] permissions nbackup

<<# ls -lart /var/lib/firebird/system/security2.fdb -rw--- 1 firebird firebird 1171456 Aug 14 14:25 /var/lib/firebird/system/security2.fdb>> Is this a distro specific install or the more generic Firebird one from SourceForge? I ask, because on MacOS the default security is the following

[firebird-support] Re: nbackup : Error assessing database due a missing delta file

The Chequered Career of nBackup By Helen Borrie http://www.ibphoenix.com/resources/documents/search/doc_394 Regards Paul Beach

[firebird-support] internal firebird consistency check

<<1. I got following error reported Firebird-3.0.2.32703_0_Win32 : "internal firebird consistency check (cannot find record back version (291), file: vio.cpp line: 4676)">> Try a gbak using something like the following gbak -b -v -i -g copy1.fdb{path}copy1a.fbk using the –g switch to signify

RE: [firebird-support] Ask : firebird 1.5 to firebird 2.5

> If our software running on firebird 1.5 and now going to move over to > firebird 2.5, > technical-wise, what are the points we can convince people to change over? > Can you kindly advise? Have you tried reading the release notes? https://www.firebirdsql.org/en/release-notes/ Regards Paul

AW: [firebird-support] RE: Firebird SuperClassic hangs

<> Thats what a lock print is for - when it "hangs the next time" get a lock print fb_lock_print -a -d

RE: [firebird-support] RE: Firebird SuperClassic hangs

> Deadlock scans:289, Deadlocks: 1, Scan interval: 10 Is probably the culprit, 289 deadlock scans, one actual deadlock found "Deadlock scans. The number of times that the lock manager walked a chain of locks and owners looking for deadlocks. The lock manager initiates a deadlock

[firebird-support] Potential Causes for Query to Slow Down

<> Garbage collection usually. Regards Paul Beach

[firebird-support] Re: FB3 - Limbo and consistency check

> Do you have reproducible example ? Could you send it to me (or regiser at > tracker), please ? http://tracker.firebirdsql.org/browse/CORE-3679 Regards Paul

Re: [firebird-support] Help: firebird and apache Processes doesn't die

<> The pseudo table MON$ATTACHMENTS will tell you. Regards Paul

Re: [firebird-support] Help: firebird and apache Processes doesn't die

<> SuperServer wil hold cached data as long as any connections exist. Only when the last "real" user disconnects from the database will the cache be cleared. Which two users are still connected to the database? CACHE WRITER and GARBAGE COLLECTOR? If so then these should also finish with the

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

<> gbak -nodbtriggers - Suppresses Database Triggers from running [Firebird 2.1] Regards Paul Beach

[firebird-support] Encryption on FB3

<<2) Use the new FB 3 encrytion, we do not have any idea how to, is there any document we can read to start testing?>> IBPhoenix have a working plugin thats available for use. http://www.ibphoenix.com/products/software/encryptionplugin Regards Paul

RE: [firebird-support] Incorrect values within SQLDA structure SQLDA version expected between 1 and 1, found 0 when using Firebird 3.0 client with older (BDE) programa

> The problem there would be that the BDE has reached its end of life for > some years now. The BDE was put on death row when IBX was made available, the same time Interbase 6.0 became available and Firebird was open sourced. Some 16 years ago... Paul Beach Tel (France): +33 (0) 2 47 58 30 43

RE: [firebird-support] FOR UPDATE [OF ...]] WITH LOCK

<> "The clause can take an optional OF to target updates at specific cursor columns" The Firebird Book Vol 2 p220 Regards Paul

[firebird-support] Problem Firebird 2.5

<> Usually caused (AFAIK) by a restore done with Firebird 2.1 or an earlier gbak, or if a Firebird 2.5 backup was restored to Firebird 2.1, backed up and then restored on Firebird 2.5 On the original database you can do DROP ROLE RDB$ADMIN; COMMIT; When you restore, gbak.exe should recreate

AW: [firebird-support] Support for OS X 10.11 El Capitan

<> And are now available for download. http://sourceforge.net/projects/firebird/files/firebird-MacOS-X_darwin/2.5.4-Release/ Regards Paul

AW: [firebird-support] Support for OS X 10.11 El Capitan

Having identified and fixed a problem in file_params.h and Info.plist, we now have a working prototype installer via pkgbuild, albeit very alpha, but its installing and working OK for me on El Capitan. Hopefully I should have something constructive early next week. Regards Paul

[firebird-support] Support for OS X 10.11 El Capitan

How to manually install Firebird on El Capitan, for those who need to know. http://paulbeachsblog.blogspot.fr/2015/10/how-to-installupgrade-firebird-manually.html Paul

RE: [firebird-support] Support for OS X 10.11 El Capitan

Timo, <>. Thanks - that tells me where to look and try and fix the problem. Regards Paul Beach Tel (France): +33 (0) 2 47 58 30 43 Mob (France): +33 (0) 6 79 24 32 32

RE: [firebird-support] Support for OS X 10.11 El Capitan

<> I suspect its not SIP, but the fact that we use an outdated package format. Looks like El Capitan has finally deprecated it. I found this https://forums.developer.apple.com/thread/8676 Note the error message, they then switched from /var to /Applications and all was ok. While we use

RE: [firebird-support] Support for OS X 10.11 El Capitan

[firebird-support] Need Help

If by QBICSYSTEMS you mean QBIC III Systems Inc. then the database will be Firebird. Regards Paul

RE: [firebird-support] Re: FB 2.1 CS High FBLockPrint Mutex wait figure

Hopefully Dmitry will come up with some answers. He seems to be the man that knows. I’m sure he was one of the IBSurgeon guys at the recent Prague seminar on performance tuning etc. Just as an FYI - Dimitry is *not* one of the IBSurgeon guys - he happens to be the Firebird project's lead

[firebird-support] Re: How do I uninstall Firebird on Mac Yosemite?

I tried it out and it said the following: Ryans-MacBook-Pro:~ ryanashton1$ ./remove.sh Launchctl /Library/LaunchDaemons/org.firebird.gds.plist: Could not find specified service Remove Framework Remove Receipt Remove /tmp/firebird Then the sh file has done nearly all its job... the comments

[firebird-support] Re: How do I uninstall Firebird on Mac Yosemite?

Type 'sudo ./remove.sh' [Enter] If you are in the same directory as the shell file. Regards Paul

[firebird-support] Re: How do I uninstall Firebird on Mac Yosemite?

Ryans-MBP:~ ryanashton1$ sudo ./remove.sh Launchctl /Library/LaunchDaemons/org.firebird.gds.plist: Could not find specified service Remove Framework Remove Receipt Remove /tmp/firebird Ryans-MBP:~ ryanashton1$ Is that correct? Did it all work? Yes. Also, under Users and Groups in

[firebird-support] Re: How do I uninstall Firebird on Mac Yosemite?

Must I type vi remove.sh into the Terminal window first? yes, you are in effect creating a shell file that can be excuted later. before you paste the commands you will probably need to change vi into insert mode :i should do it. Regards Paul

[firebird-support] Re: How do I uninstall Firebird on Mac Yosemite?

And then do I hit Enter/Return when I have pasted that info into the Terminal window? No, you exit vi using the command :wq Regards Paul

RE: [firebird-support] Firebird SQL Classic-Server 2.5.3 in OSX 10.10.2

other suggestions for osx 10.10. ? regards rené Am 03.03.2015 um 11:47 schrieb 'Paul Beach' pabe...@waitrose.com [firebird-support] firebird-support@yahoogroups.com: The following will work. cd /etc vi services change gds_db 3051/udp gds_db 3051/tcp for example. cd /Library

[firebird-support] Accessing/repairing embedded server database file

When I try to connect to it using Maestro, I get engine error 335544745 Your login SYSDBA is same as one of the SQL role name. Ask your database administrator to set up a valid Firebird login. I can't say whether this comes due to the file damage or this is the way how embedded server should

Re: [firebird-support] Accessing/repairing embedded server database file

Have you got any suggestions how to try to access/fix that file? I am not a Firebird expert, so I may have missed something (but I studied a lot of docs how to try to fix my problem). Nothing simple and straightforward comes to mind. If you want to acess the database using Firebird's own

[firebird-support] TCP connection issue

The firebird log file on a newly installed machine shows the following messages MAIN-PCFri Jan 09 15:01:03 2015 INET/inet_error: read errno = 10054 MAIN-PCFri Jan 09 15:01:04 2015 Unable to complete network request to host Main-PC. Error reading data from the connection.