Re: [firebird-support] How to protect database Firebird in client side

2014-01-07 Thread Mark Rotteveel
On 06 Jan 2014 02:12:50 -0800, rudyhuan...@ymail.com wrote: I installed on a client machine, the ERP.FDB file and the application. Now, I came to know that, one guy in the client place, stole the ERP.FDB and tried several passwords and did not get it, so, he installed a FIREBIRD on his

Re: [firebird-support] Garbage collection / sweep not happening on super classic

2014-01-07 Thread Alexey Kovyazin
Hi, Oldest transaction 15230691 Oldest active 15230692 Oldest snapshot 15230692 Next transaction16644907 You have long-running active transaction. Use MON$ tables to identify who is holding it and stop. Regards, Alexey Kovyazin

Re: [firebird-support] Garbage collection / sweep not happening on super classic

2014-01-07 Thread marcus
Hej, rmcgi...@oceris.com wrote: Sweep interval: 0 IIRC a Sweep interval of 0 disables automatic sweeping?

[firebird-support] Embedded on MacosX

2014-01-07 Thread Elmar Haneke
How can I setup an embedded database on MacOSX to ignore username and password on login. On Windows security2.fdb is not required, how can I reach that on MacOSX Elmar ++ Visit

[firebird-support] Embedded on MacosX

2014-01-07 Thread Paul Beach
How can I setup an embedded database on MacOSX to ignore username and password on login. On Windows security2.fdb is not required, how can I reach that on MacOSX by trying to pass -EMBEDDED to the compile line - No guarentees it will compile though. Paul

[firebird-support] FreeUDFLib.dll 64-bit

2014-01-07 Thread Steve Faleiro
I'm looking for the 64-bit converted Delphi source for FreeUDFLib.dll. If anyone has it, I'd appreciate if you can post it to the group or send it to me direct via email. I tried compiling the source to 64-bit with Delphi XE2, but it did not work in Firebird 64-bit, I keep getting Invalid

Re: [firebird-support] Garbage collection / sweep not happening on super classic

2014-01-07 Thread Thomas Steinmaurer
Hej, rmcgi...@oceris.com wrote: Sweep interval: 0 IIRC a Sweep interval of 0 disables automatic sweeping? Yes. -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check,

Re: [firebird-support] How to protect database Firebird in client side

2014-01-07 Thread Thomas Steinmaurer
Hello Team Support, I installed on a client machine, the ERP.FDB file and the application. Now, I came to know that, one guy in the client place, stole the ERP.FDB and tried several passwords and did not get it, so, he installed a FIREBIRD on his computer and copied the ERP.FDB and opened

[firebird-support] RE: Garbage collection / sweep not happening on super classic

2014-01-07 Thread rmcginty
This is Classic, so yes, automatic sweep is disabled. My understanding is that gbak does a sweep while doing a backup, which happens nightly, so sweep should be happening then (if I understand it correctly that is). Also, running a manual sweep hangs indefinitely. As for the active

Re: [firebird-support] RE: Garbage collection / sweep not happening on super classic

2014-01-07 Thread fabianoaspro
Are you sure gfix hangs? Maybe is a hdd slowdown in the process. We had this same issue. Gbak does not clean all the mess on only one of our clients. The sollution is run a gfix and wait. Em 07/01/2014 18:22, rmcgi...@oceris.com escreveu: This is Classic, so yes, automatic sweep is disabled.

Re: [firebird-support] RE: Garbage collection / sweep not happening on super classic

2014-01-07 Thread Alexey Kovyazin
Hi Ryan, My understanding is that gbak does a sweep while doing a backup, which happens nightly, so sweep should be happening then (if I understand it correctly that is). You are wrong. Gbak does not do sweep, it runs snapshot transaction and reads all records in all tables - and, with some

Re: [firebird-support] RE: Garbage collection / sweep not happening on super classic

2014-01-07 Thread fabianoaspro
I forget to say that you must disconnect all clients before run gfix Em 07/01/2014 18:35, Alexey Kovyazin a...@ib-aid.com escreveu: Hi Ryan, My understanding is that gbak does a sweep while doing a backup, which happens nightly, so sweep should be happening then (if I understand it

Re: [firebird-support] RE: Garbage collection / sweep not happening on super classic

2014-01-07 Thread rmcginty
You are wrong. Gbak does not do sweep, it runs snapshot transaction and reads all records in all tables - and, with some conditions, it can clear some garbage versions. Ah I see - the documentation simply mentioned something like garbage collection maybe done during backup - now I see that

[firebird-support] RE: Garbage collection / sweep not happening on super classic

2014-01-07 Thread rmcginty
Last time I tried it, the gfix process hung and sat at 0% CPU for hours. I had to terminate it. A backup only takes about 20 minutes, so I figured gfix should take several hours. I will try to run it again and get more detailed information to report back here (with everyone logged out).

[firebird-support] Cannot edit fdb content.

2014-01-07 Thread dice_in_trouble
Hi we were encoding data yesterday on our fdb database, and after resting for the day we tried connecting again now but everytime we put a new entry it doesn't enter. We are using a delphi application and zeos as driver for it. What could be the problem here? Thanks.

Re: [firebird-support] How to protect database Firebird in client side

2014-01-07 Thread Virna Constantin
http://www.firebirdfaq.org/faq344/  can not be a solution? On Monday, January 6, 2014 7:31 PM, rudyhuan...@ymail.com rudyhuan...@ymail.com wrote: Hello Team Support, I installed on a client machine, the ERP.FDB file and the application. Now, I came to know that, one guy in the client

Odp: [firebird-support] How to protect database Firebird in client side

2014-01-07 Thread liviusliv...@poczta.onet.pl
Hi, Your design is wrong from security POV If you need to protect db from copy - put it on server where only admin have access. Then noone can copy your db. If you put it on client computer you accept that risk at start Regards, Karol Bieniaszewski - Reply message - Od: Virna