Page 1 of 1
Cryptowall or similar
Posted: Tue Aug 25, 2015 5:19 pm
by MarcoBoschi
Hi to all,
So many our customer are victims of cryptowall or similar **virus** that
crypts many many files in so few minutes.
This time also dbf tables.
The tables "in use" are non affected by this tremendous and diabolic program.
So why do not open for instance in the server all dbf tables? I think to do so.
King regards
Marco
Re: Cryptowall or similar
Posted: Tue Aug 25, 2015 5:58 pm
by Rick Lipkin
Marco
I have seen the destruction the crypto virus causes and it also hits .mdb ( access ) files. Back when I worked for state gov, I used advantage database server and I created a task that started in the morning before staff got in til just before the server backup started in the evening. That task went through and opened every .dbf I had effectively locking out anyone using the FoxPro interpreter from making any ( back door ) changes to my files, but it would still allow staff to use FoxPro to make queries.
With that said .. I was not worried too much about having ALL my tables opened because Advantage was server based and my servers all had battery backup and ( hopefully ) would never lose power and crash.
I will say this, it is dangerous to have all .dbf's open in a traditional DBfCdx application, just because workstations ( especially in a network environment ) tend to hang or lock up intermittently and wrecking havoc with your indexes.
No good answer here .. On one hand you have potential virus corruption ( for non opened tables ) .. on the other hand you could have index corruption with badly mis-behaving workstations. If it were me, the customer needs to understand they were a victim of their own 'self infliction' and should bear the brunt and your 'paid' services to put their business application back together... and hopefully they kept a decent off-site backup to restore their data from or ... 'shame on them'.
I did not mean to be ugly, Just my 2 cents worth.
Rick Lipkin
Re: Cryptowall or similar
Posted: Wed Aug 26, 2015 11:20 am
by sambomb
Maybe if you change the extension of the DBF files will solve this
Re: Cryptowall or similar
Posted: Wed Aug 26, 2015 12:53 pm
by MarcoBoschi
Rick,
my idea is to launch this program on the server
table indici contains all dbf of my program.
Code: Select all
...
...
SELECT 1
USE indici
SET INDEX TO indici
GO TOP
DO WHILE !EOF()
cDbf := ALLTRIM( indici->rdbf )
SELECT 0
?? cDbf , ","
USE &cDbf
SELECT indici
SKIP
ENDDO
inkey(0)
...
...
sambomb,
It might be a good idea
King regards
Marco
Re: Cryptowall or similar
Posted: Wed Aug 26, 2015 6:21 pm
by Rick Lipkin
Marco
Crypto is brutal .. if you re-name the files you will need to go through your program and enter the name and extension of the table you wish to open. That may be a lot of re-coding :
Select 1
Use ( "\\server\App\MyTable.Dat" ) via "DBFCDX" SHARED
If you want to make a name change to your tables .. now may be the time to think about SQL and Ado .. get those tables on Sql Server, MySql or even Advantage Database Server and you can bundle those changes to your customer and sell it .. might just be a new opportunity!
Rick Lipkin
ps -- .Dat is not immune to Crypto
Re: Cryptowall or similar
Posted: Wed Aug 26, 2015 9:53 pm
by nnicanor
Do not use network maps to open files use UNC path format.
Regards