Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #9703 > unrolled thread
| Started by | SteveMcNaughton <stevemcnaughton@auditron.com> |
|---|---|
| First post | 2016-09-03 09:56 -0700 |
| Last post | 2016-09-06 07:12 +0000 |
| Articles | 13 — 5 participants |
Back to article view | Back to comp.lang.clipper.visual-objects
Has anyone used any bulk (file, directory, disk) encryption methods successfully? SteveMcNaughton <stevemcnaughton@auditron.com> - 2016-09-03 09:56 -0700
Re: Has anyone used any bulk (file, directory, disk) encryption methods successfully? "Jamal" <noooospam@example.com> - 2016-09-03 19:05 -0400
Re: Has anyone used any bulk (file, directory, disk) encryption methods successfully? SteveMcNaughton <stevemcnaughton@auditron.com> - 2016-09-03 19:29 -0700
Re: Has anyone used any bulk (file, directory, disk) encryption methods successfully? "Jamal" <noooospam@example.com> - 2016-09-04 02:16 -0400
Re: Has anyone used any bulk (file, directory, disk) encryptionmethods successfully? "Wolfgang Riedmann" <wriedmann@gmail.com> - 2016-09-05 05:11 +0200
Re: Has anyone used any bulk (file, directory, disk) encryption methods successfully? sherlocksoftware@gmail.com - 2016-09-03 16:33 -0700
Re: Has anyone used any bulk (file, directory, disk) encryption methods successfully? SteveMcNaughton <stevemcnaughton@auditron.com> - 2016-09-03 19:34 -0700
Re: Has anyone used any bulk (file, directory, disk) encryption methods successfully? "Jamal" <noooospam@example.com> - 2016-09-04 02:35 -0400
Re: Has anyone used any bulk (file, directory, disk) encryption methods successfully? sherlocksoftware@gmail.com - 2016-09-04 04:40 -0700
Re: Has anyone used any bulk (file, directory, disk) encryption methods successfully? "Wolfgang Riedmann" <wriedmann@gmail.com> - 2016-09-05 05:07 +0200
Re: Has anyone used any bulk (file, directory, disk) encryption methods successfully? SteveMcNaughton <stevemcnaughton@auditron.com> - 2016-09-11 07:43 -0700
Re: Has anyone used any bulk (file, directory, disk) encryptionmethods successfully? "Wolfgang Riedmann" <wriedmann@gmail.com> - 2016-09-12 07:29 +0200
Re: Has anyone used any bulk (file, directory, disk) encryption methods successfully? "Dirk (Belgium)" <dirk.dot.herijgers@pbprojects.dot.be> - 2016-09-06 07:12 +0000
| From | SteveMcNaughton <stevemcnaughton@auditron.com> |
|---|---|
| Date | 2016-09-03 09:56 -0700 |
| Subject | Has anyone used any bulk (file, directory, disk) encryption methods successfully? |
| Message-ID | <69f01469-469a-4799-b440-265867c5fdbb@googlegroups.com> |
I'm looking for a way to encrypt the data files so that the data is not readable by simple things like Notepad, but is readable by my VO programming. I've mulled over using field based encryption, but then indexing them would be an issue. I goofed around with a windows method, but then other network users could not read the files. It's like there has to be an encryption key that is able to be shared with others. Anybody been to this mountain already? thanks. Steve.
[toc] | [next] | [standalone]
| From | "Jamal" <noooospam@example.com> |
|---|---|
| Date | 2016-09-03 19:05 -0400 |
| Message-ID | <nqfl0j$6fm$1@news.albasani.net> |
| In reply to | #9703 |
Advantage Databaser Server may be your only option: https://devzone.advantagedatabase.com/dz/webhelp/Advantage9.0/server1/encryption.htm Jamal "SteveMcNaughton" wrote in message news:69f01469-469a-4799-b440-265867c5fdbb@googlegroups.com... I'm looking for a way to encrypt the data files so that the data is not readable by simple things like Notepad, but is readable by my VO programming. I've mulled over using field based encryption, but then indexing them would be an issue. I goofed around with a windows method, but then other network users could not read the files. It's like there has to be an encryption key that is able to be shared with others. Anybody been to this mountain already? thanks. Steve.
[toc] | [prev] | [next] | [standalone]
| From | SteveMcNaughton <stevemcnaughton@auditron.com> |
|---|---|
| Date | 2016-09-03 19:29 -0700 |
| Message-ID | <01e3e0ab-8686-464e-b1df-774219f05eb4@googlegroups.com> |
| In reply to | #9704 |
Jamal, Looks like that will work, but OMG, they have no information on pricing or licensing without talking to someone! I thought that crap ended in the last millenium. I will have to investigate it further, but it does look like an option as long as they don't price it out of reach. steve
[toc] | [prev] | [next] | [standalone]
| From | "Jamal" <noooospam@example.com> |
|---|---|
| Date | 2016-09-04 02:16 -0400 |
| Message-ID | <nqge7s$p4t$1@news.albasani.net> |
| In reply to | #9706 |
Steve, Actually, many companies still practice this crap! They think are smart by hiding their prices and if you call you believe won't the sales pitch and excuses for not being upfront. Jamal "SteveMcNaughton" wrote in message news:01e3e0ab-8686-464e-b1df-774219f05eb4@googlegroups.com... Jamal, Looks like that will work, but OMG, they have no information on pricing or licensing without talking to someone! I thought that crap ended in the last millenium. I will have to investigate it further, but it does look like an option as long as they don't price it out of reach. steve
[toc] | [prev] | [next] | [standalone]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2016-09-05 05:11 +0200 |
| Subject | Re: Has anyone used any bulk (file, directory, disk) encryptionmethods successfully? |
| Message-ID | <e3463oF40hcU1@mid.individual.net> |
| In reply to | #9706 |
Hi Steve, > Looks like that will work, but OMG, they have no information on > pricing or licensing without talking to someone! I thought that crap > ended in the last millenium. unfortunately, no pricing information normally is a sign of high prices. ADS is not cheap, but saved one of my largest projects. With more than 15 or 20 users I had data corruption problems with DBFCDX, but now with ADS is works very well with 60 users. As other goodie, you access your data with both DBF and SQL methods (both sequential access and wie SQL select). (I could not afford to rewrite this project to adapt to SQL - new projects using X# will be use only SQL). Wolfgang --
[toc] | [prev] | [next] | [standalone]
| From | sherlocksoftware@gmail.com |
|---|---|
| Date | 2016-09-03 16:33 -0700 |
| Message-ID | <6d8d85a8-1397-45d5-ad4e-a485a98c6039@googlegroups.com> |
| In reply to | #9703 |
snip[ I'm looking for a way to encrypt the data files so that the data is not readable by simple things like Notepad, but is readable by my VO programming.] SQL in the cloud or Application in VM in cloud.. Phil
[toc] | [prev] | [next] | [standalone]
| From | SteveMcNaughton <stevemcnaughton@auditron.com> |
|---|---|
| Date | 2016-09-03 19:34 -0700 |
| Message-ID | <3883c193-94c5-4867-acd5-e9e6aea47cd2@googlegroups.com> |
| In reply to | #9705 |
Phil, I don't think SQL is an option since everything is in DBF/BLOB files. the application in VM is intriguing. Can you elaborate a bit on how that might work? Are you thinking to encrypt the VM disk and mandate the connections be encrypted to connect? Most of my clients use terminal services so their connections are already encrypted, it's the fact the data is sitting in an unencrypted state on the disk and that leaves them vulnerable. If someone exports the database file or steals the disk, they're in deep do-do. I need to protect against that somehow. I should add others are on a client-server structure and they're the ones that are making it harder. Thanks. steve. On Saturday, September 3, 2016 at 7:33:58 PM UTC-4, sherlock...@gmail.com wrote: > snip[ I'm looking for a way to encrypt the data files so that the data is not readable by simple things like Notepad, but is readable by my VO programming.] > > SQL in the cloud or Application in VM in cloud.. > > Phil
[toc] | [prev] | [next] | [standalone]
| From | "Jamal" <noooospam@example.com> |
|---|---|
| Date | 2016-09-04 02:35 -0400 |
| Message-ID | <nqgfb5$qpv$1@news.albasani.net> |
| In reply to | #9707 |
Steve, If you do not to go with Advantage Server or SQL, you may want to consider a AES encryption of important fields in your database. Remember when you encrypt fields, you will have to almost double the size of the fields to accommodate the encrypted result. You may have to experiment to see optimal field size increase. You can probably write a COM visible in C# with 2 functions to encrypt and decrypt functions (web search them), and use them in VO by generating an Automation Sever Class. Just make sure the C# DLL is obfuscated for obvious reasons. Search this NG for more info. Maybe this link helps: https://groups.google.com/forum/#!msg/comp.lang.clipper.visual-objects/5At1ZLz5CAY/Fs9YiMb-Y3oJ;context-place=searchin/comp.lang.clipper.visual-objects/consume$20C$23%7Csort:relevance Jamal "SteveMcNaughton" wrote in message news:3883c193-94c5-4867-acd5-e9e6aea47cd2@googlegroups.com... Phil, I don't think SQL is an option since everything is in DBF/BLOB files. the application in VM is intriguing. Can you elaborate a bit on how that might work? Are you thinking to encrypt the VM disk and mandate the connections be encrypted to connect? Most of my clients use terminal services so their connections are already encrypted, it's the fact the data is sitting in an unencrypted state on the disk and that leaves them vulnerable. If someone exports the database file or steals the disk, they're in deep do-do. I need to protect against that somehow. I should add others are on a client-server structure and they're the ones that are making it harder. Thanks. steve. On Saturday, September 3, 2016 at 7:33:58 PM UTC-4, sherlock...@gmail.com wrote: > snip[ I'm looking for a way to encrypt the data files so that the data is > not readable by simple things like Notepad, but is readable by my VO > programming.] > > SQL in the cloud or Application in VM in cloud.. > > Phil
[toc] | [prev] | [next] | [standalone]
| From | sherlocksoftware@gmail.com |
|---|---|
| Date | 2016-09-04 04:40 -0700 |
| Message-ID | <f0ef54c9-5bab-4269-8e44-64b89d560b21@googlegroups.com> |
| In reply to | #9707 |
snip[ > the application in VM is intriguing. Can you elaborate a bit on how that might work? Are you thinking to encrypt the VM disk and mandate the connections be encrypted to connect? You do not have to.. Terminal Server has been around since 2000 server and available in Windows 10.. easily with VPN available and changing 1 DLL you can make it full terminal server. We have just finished this as an option with Amazon and Azure.. Install all our systems and they use it via TS on Apple or PC.. No need to encrypt as data/systems you have total control and nothing local. We have also completed the DBF/FTP to PostGRES and all working but not released to VO market yet. More testing and looking at how to distribute. By next year all our DBF stuff will be end of life. Phil
[toc] | [prev] | [next] | [standalone]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2016-09-05 05:07 +0200 |
| Message-ID | <e345r5F3us8U1@mid.individual.net> |
| In reply to | #9703 |
Hi Steve, this is easily doable with several possibilities: you can encrypt single fields and crypt/decrypt on FieldGet/FieldPut level of your DBServer (the following code is from a now 10 years old project): method FieldGet( uField ) class AppCDBServer local uValue as usual local nLen as dword local cValue as string local cBuffer as string uValue := super:FieldGet( uField ) if IsString( uValue ) if self:IsFieldToCrypt( uField ) .and. ! AllTrim( uValue ) == "" cValue := uValue if SLen( cValue ) > 2 nLen := Bin2W( Left( cValue, 2 ) ) if nLen == 0 uValue := Space( nLen ) else cBuffer := SubStr2( cValue, 3 ) cValue := JPMCrypt( cBuffer ) uValue := Left( cValue, nLen ) endif endif endif endif return uValue method FieldPut( uField, uValue ) class AppCDBServer if IsString( uValue ) .and. self:IsFieldToCrypt( uField ) uValue := AllTrim( uValue ) uValue := W2Bin( word( SLen( uValue ) ) ) + AllTrim( JPMCrypt( uValue ) ) endif return super:FieldPut( uField, uValue ) Or you can use a crypting RDD (there was a sample by someone, Robert v.d.H. I think). But beware: my method seems to have issues with the Vulcan RDDs. Wolfgang SteveMcNaughton wrote: > I'm looking for a way to encrypt the data files so that the data is > not readable by simple things like Notepad, but is readable by my VO > programming. I've mulled over using field based encryption, but then > indexing them would be an issue. > > I goofed around with a windows method, but then other network users > could not read the files. > > It's like there has to be an encryption key that is able to be shared > with others. > Anybody been to this mountain already? > > thanks. > > Steve. --
[toc] | [prev] | [next] | [standalone]
| From | SteveMcNaughton <stevemcnaughton@auditron.com> |
|---|---|
| Date | 2016-09-11 07:43 -0700 |
| Message-ID | <d7a8bd8c-e11d-48af-b04d-2b43ec8d7c6c@googlegroups.com> |
| In reply to | #9712 |
My apologies to everyone who responded. I have been dealing with a family crisis and have not been around and just checking in quickly as things are ongoing.... Wolfgang, you code references a function JPMCrypt( cBuffer ) Can you post that or send in private email? It seems like that's where the magic happens. Thanks. Steve. stevem at auditron dot com On Sunday, September 4, 2016 at 11:07:20 PM UTC-4, Wolfgang Riedmann wrote: > Hi Steve, > > this is easily doable with several possibilities: you can encrypt > single fields and crypt/decrypt on FieldGet/FieldPut level of your > DBServer (the following code is from a now 10 years old project): > > method FieldGet( uField ) class AppCDBServer > local uValue as usual > local nLen as dword > local cValue as string > local cBuffer as string > > uValue := super:FieldGet( uField ) > if IsString( uValue ) > if self:IsFieldToCrypt( uField ) .and. ! AllTrim( uValue ) == "" > cValue := uValue > if SLen( cValue ) > 2 > nLen := Bin2W( Left( cValue, 2 ) ) > if nLen == 0 > uValue := Space( nLen ) > else > cBuffer := SubStr2( cValue, 3 ) > cValue := JPMCrypt( cBuffer ) > uValue := Left( cValue, nLen ) > endif > endif > endif > endif > > return uValue > > method FieldPut( uField, uValue ) class AppCDBServer > > if IsString( uValue ) .and. self:IsFieldToCrypt( uField ) > uValue := AllTrim( uValue ) > uValue := W2Bin( word( SLen( uValue ) ) ) + AllTrim( JPMCrypt( uValue > ) ) > endif > > return super:FieldPut( uField, uValue ) > > > Or you can use a crypting RDD (there was a sample by someone, Robert > v.d.H. I think). > > But beware: my method seems to have issues with the Vulcan RDDs. > > Wolfgang > > > > SteveMcNaughton wrote: > > > I'm looking for a way to encrypt the data files so that the data is > > not readable by simple things like Notepad, but is readable by my VO > > programming. I've mulled over using field based encryption, but then > > indexing them would be an issue. > > > > I goofed around with a windows method, but then other network users > > could not read the files. > > > > It's like there has to be an encryption key that is able to be shared > > with others. > > Anybody been to this mountain already? > > > > thanks. > > > > Steve. > > > > --
[toc] | [prev] | [next] | [standalone]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2016-09-12 07:29 +0200 |
| Subject | Re: Has anyone used any bulk (file, directory, disk) encryptionmethods successfully? |
| Message-ID | <e3msq1FgugiU1@mid.individual.net> |
| In reply to | #9724 |
Hi Steve, > Wolfgang, you code references a function JPMCrypt( cBuffer ) > > Can you post that or send in private email? It seems like that's > where the magic happens. It's not magic at all: function JPMCrypt( cString as string ) as string pascal local cBuffer as string if SLen( cString ) > 0 cBuffer := Crypt( cString, "tHiSiSmYsEcReTpAsS" ) else cBuffer := "" endif return cBuffer (the passphrase is not the one I'm using, of course). HTH Wolfgang --
[toc] | [prev] | [next] | [standalone]
| From | "Dirk (Belgium)" <dirk.dot.herijgers@pbprojects.dot.be> |
|---|---|
| Date | 2016-09-06 07:12 +0000 |
| Message-ID | <nqlq93$71n$1@dont-email.me> |
| In reply to | #9703 |
Hi Steve, I use encrypted DBF (CDX or NTX) for years! Also index-fields can be encrypted. The encryption is not field-based, but record based. If you are interested, please send a private e-mail, and I send you back an example DBF "dirk at triviant dot be" Cheers, Dirk SteveMcNaughton wrote: > I'm looking for a way to encrypt the data files so that the data is > not readable by simple things like Notepad, but is readable by my VO > programming. I've mulled over using field based encryption, but then > indexing them would be an issue. > > I goofed around with a windows method, but then other network users > could not read the files. > > It's like there has to be an encryption key that is able to be shared > with others. > Anybody been to this mountain already? > > thanks. > > Steve.
[toc] | [prev] | [standalone]
Back to top | Article view | comp.lang.clipper.visual-objects
csiph-web