Re: [firebird-support] How to protect database Firebird in client side
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 computer and copied the ERP.FDB and opened it with FIREBIRD default password, and stole the entire db design. How to protect from this kind of things ? How to make sure, that the database cannot be copied? As soon as someone has physical access to the database file, there is nothing you can do to prevent this. The only 'protection' you have is the legal protection of copyright and intellectual property rights, and the contract with your client. Mark
Re: [firebird-support] Garbage collection / sweep not happening on super classic
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 www.IBSurgeon.com
Re: [firebird-support] Garbage collection / sweep not happening on super classic
Hej, rmcgi...@oceris.com wrote: Sweep interval: 0 IIRC a Sweep interval of 0 disables automatic sweeping?
[firebird-support] Embedded on MacosX
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 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: http://info.yahoo.com/legal/us/yahoo/utos/terms/
[firebird-support] Embedded on MacosX
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
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 offset at BLR errors when trying to use any functions. Regards, Steve Faleiro
Re: [firebird-support] Garbage collection / sweep not happening on super classic
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, Tuning etc.
Re: [firebird-support] How to protect database Firebird in client side
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 it with FIREBIRD default password, and stole the entire db design. How to protect from this kind of things ? How to make sure, that the database cannot be copied? Additional to the other comments. Firebird 3 will have support for optionally login credentials being embedded in the regular database and IIRC optional data and/or over-the-wire encryption. But V3 is in Alpha stage and not recommended for production usage. Although being far away from bullet-proof, but you could at least lock out SYSDBA from logging in by creating an equally named role, but then SYSDBA must not be an owner of the database and any database object (table, view etc.). Not bullet-proof, because knowledgeable people could open the database in a HEX editor and change the role name. But I found that as a first countermeasure quite ok in the past, especially when customers have initially no idea about Firebird, but then rather quickly found out the SYSDBA/masterkey combination via Google. -- 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] RE: Garbage collection / sweep not happening on super classic
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 transaction, restarting Firebird doesn't fix the problem. The ONLY thing that fixes the problem is restoring from a backup file to create a fresh file. According to Sinatica, there are no active transactions while the problem is being exhibited. I will check the raw MON tables, but would restarting the Firebird service not terminate any active transactions? Thanks for all the quick responses! Ryan
Re: [firebird-support] RE: Garbage collection / sweep not happening on super classic
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. 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 transaction, restarting Firebird doesn't fix the problem. The ONLY thing that fixes the problem is restoring from a backup file to create a fresh file. According to Sinatica, there are no active transactions while the problem is being exhibited. I will check the raw MON tables, but would restarting the Firebird service not terminate any active transactions? Thanks for all the quick responses! Ryan
Re: [firebird-support] RE: Garbage collection / sweep not happening on super classic
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 conditions, it can clear some garbage versions. Restart should fix oldest active stuck - if it's a real restart (Classic processes sometimes remain active). Did you check that all processes are down? Or did you restart hardware? And it also could be another problem, more complex... I can't say more without detailed investigation. Regards, Alexey Kovyazin www.ibsurgeon.com 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 transaction, restarting Firebird doesn't fix the problem. The ONLY thing that fixes the problem is restoring from a backup file to create a fresh file. According to Sinatica, there are no active transactions while the problem is being exhibited. I will check the raw MON tables, but would restarting the Firebird service not terminate any active transactions? Thanks for all the quick responses! Ryan
Re: [firebird-support] RE: Garbage collection / sweep not happening on super classic
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 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 conditions, it can clear some garbage versions. Restart should fix oldest active stuck - if it's a real restart (Classic processes sometimes remain active). Did you check that all processes are down? Or did you restart hardware? And it also could be another problem, more complex... I can't say more without detailed investigation. Regards, Alexey Kovyazin www.ibsurgeon.com 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 transaction, restarting Firebird doesn't fix the problem. The ONLY thing that fixes the problem is restoring from a backup file to create a fresh file. According to Sinatica, there are no active transactions while the problem is being exhibited. I will check the raw MON tables, but would restarting the Firebird service not terminate any active transactions? Thanks for all the quick responses! Ryan
Re: [firebird-support] RE: Garbage collection / sweep not happening on super classic
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 doesn't mean the same thing as a sweep. Restart should fix oldest active stuck - if it's a real restart (Classic processes sometimes remain active). Did you check that all processes are down? Or did you restart hardware? It is super classic (with only the one process), so I shut it down, verified processes were no longer running, and verified that the file was no longer in use. On top of that, the server hardware reboots each week. Nothing, so far, has released the oldest transaction. I will try gfix making sure no one is attached to the database and see what happens, then report here. Ryan
[firebird-support] RE: Garbage collection / sweep not happening on super classic
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). Ryan ---In firebird-support@yahoogroups.com, fabianoaspro@... wrote: 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, rmcginty@... mailto:rmcginty@... escreveu: 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 transaction, restarting Firebird doesn't fix the problem. The ONLY thing that fixes the problem is restoring from a backup file to create a fresh file. According to Sinatica, there are no active transactions while the problem is being exhibited. I will check the raw MON tables, but would restarting the Firebird service not terminate any active transactions? Thanks for all the quick responses! Ryan
[firebird-support] Cannot edit fdb content.
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
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 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 it with FIREBIRD default password, and stole the entire db design. How to protect from this kind of things ? How to make sure, that the database cannot be copied? Regards Thanks, Rudy Huang
Odp: [firebird-support] How to protect database Firebird in client side
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 Constantin costel...@yahoo.com Do: firebird-support@yahoogroups.com firebird-support@yahoogroups.com Temat: [firebird-support] How to protect database Firebird in client side Data: śr., sty 8, 2014 07:43 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 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 it with FIREBIRD default password, and stole the entire db design. How to protect from this kind of things ?How to make sure, that the database cannot be copied? Regards Thanks, Rudy Huang
