Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #9703 > unrolled thread

Has anyone used any bulk (file, directory, disk) encryption methods successfully?

Started bySteveMcNaughton <stevemcnaughton@auditron.com>
First post2016-09-03 09:56 -0700
Last post2016-09-06 07:12 +0000
Articles 13 — 5 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  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

#9703 — Has anyone used any bulk (file, directory, disk) encryption methods successfully?

FromSteveMcNaughton <stevemcnaughton@auditron.com>
Date2016-09-03 09:56 -0700
SubjectHas 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]


#9704

From"Jamal" <noooospam@example.com>
Date2016-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]


#9706

FromSteveMcNaughton <stevemcnaughton@auditron.com>
Date2016-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]


#9708

From"Jamal" <noooospam@example.com>
Date2016-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]


#9713 — Re: Has anyone used any bulk (file, directory, disk) encryptionmethods successfully?

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2016-09-05 05:11 +0200
SubjectRe: 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]


#9705

Fromsherlocksoftware@gmail.com
Date2016-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]


#9707

FromSteveMcNaughton <stevemcnaughton@auditron.com>
Date2016-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]


#9709

From"Jamal" <noooospam@example.com>
Date2016-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]


#9710

Fromsherlocksoftware@gmail.com
Date2016-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]


#9712

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2016-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]


#9724

FromSteveMcNaughton <stevemcnaughton@auditron.com>
Date2016-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]


#9727 — Re: Has anyone used any bulk (file, directory, disk) encryptionmethods successfully?

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2016-09-12 07:29 +0200
SubjectRe: 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]


#9719

From"Dirk (Belgium)" <dirk.dot.herijgers@pbprojects.dot.be>
Date2016-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