Re: [sqlite] Error File is Encrypted or is not a database

[Simon Slavin]

On 18 Aug 2016, at 6:24pm, Matias Badin  wrote:

> Thanks  you very much! The information was very usefull.
> I can recover the database info now, overwritting the header array.

Once you have the header array 'correct' and SQLite no longer refuses to open 
the database, use the SQLite command-line tool to run

PRAGMA integrity_check

and note the results.  It may be that the header isn't the only part of the 
database which was corrupted.

> Have you any information about how the header is corrupted?

Usually a bug in the program which writes it, overwriting files or memory which 
are meant to be private to SQLite.  Sometimes it is instead a sign of a 
hardware fault, which will gradually get worse until it is corrupting more 
files on the storage medium.

Simon.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Error File is Encrypted or is not a database

[Adam Devita]

You are welcome.I was worried about the infinite loop I wrote. ;)

Hopefully you can track down the reason, I don't know anything about your
file but what you tell us. There are some things that you can do to help
track it down.

You didn't mention what version of sqlite you were using, programming
language, dev or target platform etc. This may be helpful to track it down,
or attract the interest of other list members more versed in an
implementation similar to  yours.

Also, if you have some sort of way of knowing the time the error was
written, if the file was exposed to users  etc. it may be helpful. If
you have a copy of the corrupt header and look at it from the point of view
of "what program would write such a thing to my file?"For example
"another program's" known file header, or (if the program was supposed to
append but didn't seek to the end before writing), some other stuff.

Have you ruled out your disk starting to fail?
Does corruption time co-relate to a power failure?  (Not all hard drives
tell the truth that the data is safely in the file.)
Is there a chance a user or other process opened the file, then closed it
saving its header over top of the sqlite one?

regards,
Adam





On Thu, Aug 18, 2016 at 1:24 PM, Matias Badin  wrote:

> Thanks  you very much! The information was very usefull.
> I can recover the database info now, overwritting the header array.
> Have you any information about how the header is corrupted? I would like to
> know the reason to resolve it.
> Thanks again!
>
> 2016-08-18 10:14 GMT-03:00 Adam Devita :
>
> > Good day,
> >
> > A few things that you can try
> > 1) One could download a hex editor and review the beginning of the file
> and
> > compare to https://www.sqlite.org/fileformat2.html . If some other
> program
> > has over-written the header,  you should be able to observe that,
> hopefully
> > identifying a program with a problem.
> >
> > 2) Back up you hard drive. Run hardware diagnostics.
> >
> > 3) Review https://www.sqlite.org/howtocorrupt.html
> >
> > 4) Do this list in reverse order. :)
> >
> >
> > regards,
> > Adam
> >
> >
> > On Thu, Aug 18, 2016 at 8:56 AM, Matias Badin 
> wrote:
> >
> > > Hi Everyone;
> > > I have a problem with a sqlite database that was working very good but
> > > suddenly started to give the message "File is encrypted or is not a
> > > database". Then I can´t access it and i have to replace it with a new
> > one.
> > >
> > > Can anyone help me with this problem?
> > > I don´t know how to re-open the database. I can´t access to the
> > information
> > > saved in it
> > > Thanks all;
> > > ___
> > > sqlite-users mailing list
> > > sqlite-users@mailinglists.sqlite.org
> > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> > >
> >
> >
> >
> > --
> > --
> > VerifEye Technologies Inc.
> > 151 Whitehall Dr. Unit 2
> > Markham, ON
> > L3R 9T1
> > ___
> > sqlite-users mailing list
> > sqlite-users@mailinglists.sqlite.org
> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> >
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
--
VerifEye Technologies Inc.
151 Whitehall Dr. Unit 2
Markham, ON
L3R 9T1
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Error File is Encrypted or is not a database

[Matias Badin]

Thanks  you very much! The information was very usefull.
I can recover the database info now, overwritting the header array.
Have you any information about how the header is corrupted? I would like to
know the reason to resolve it.
Thanks again!

2016-08-18 10:14 GMT-03:00 Adam Devita :

> Good day,
>
> A few things that you can try
> 1) One could download a hex editor and review the beginning of the file and
> compare to https://www.sqlite.org/fileformat2.html . If some other program
> has over-written the header,  you should be able to observe that, hopefully
> identifying a program with a problem.
>
> 2) Back up you hard drive. Run hardware diagnostics.
>
> 3) Review https://www.sqlite.org/howtocorrupt.html
>
> 4) Do this list in reverse order. :)
>
>
> regards,
> Adam
>
>
> On Thu, Aug 18, 2016 at 8:56 AM, Matias Badin  wrote:
>
> > Hi Everyone;
> > I have a problem with a sqlite database that was working very good but
> > suddenly started to give the message "File is encrypted or is not a
> > database". Then I can´t access it and i have to replace it with a new
> one.
> >
> > Can anyone help me with this problem?
> > I don´t know how to re-open the database. I can´t access to the
> information
> > saved in it
> > Thanks all;
> > ___
> > sqlite-users mailing list
> > sqlite-users@mailinglists.sqlite.org
> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> >
>
>
>
> --
> --
> VerifEye Technologies Inc.
> 151 Whitehall Dr. Unit 2
> Markham, ON
> L3R 9T1
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Error File is Encrypted or is not a database

[David Raymond]

1) One could download a hex editor and review the beginning of the file and
compare to https://www.sqlite.org/fileformat2.html . If some other program
has over-written the header,  you should be able to observe that, hopefully
identifying a program with a problem.

2) Back up you hard drive. Run hardware diagnostics.

3) Review https://www.sqlite.org/howtocorrupt.html

4) Do this list in reverse order. :)





4) Do this list in reverse order. :)





1) Do this list in reverse order. :)

2) Review https://www.sqlite.org/howtocorrupt.html

3) Back up you hard drive. Run hardware diagnostics.

4) One could download a hex editor and review the beginning of the file and
compare to https://www.sqlite.org/fileformat2.html . If some other program
has over-written the header,  you should be able to observe that, hopefully
identifying a program with a problem.





1) Do this list in reverse order. :)





1) One could download a hex editor and review the beginning of the file and
compare to https://www.sqlite.org/fileformat2.html . If some other program
has over-written the header,  you should be able to observe that, hopefully
identifying a program with a problem.

2) ...

:p
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Error File is Encrypted or is not a database

[Adam Devita]

Good day,

A few things that you can try
1) One could download a hex editor and review the beginning of the file and
compare to https://www.sqlite.org/fileformat2.html . If some other program
has over-written the header,  you should be able to observe that, hopefully
identifying a program with a problem.

2) Back up you hard drive. Run hardware diagnostics.

3) Review https://www.sqlite.org/howtocorrupt.html

4) Do this list in reverse order. :)


regards,
Adam


On Thu, Aug 18, 2016 at 8:56 AM, Matias Badin  wrote:

> Hi Everyone;
> I have a problem with a sqlite database that was working very good but
> suddenly started to give the message "File is encrypted or is not a
> database". Then I can´t access it and i have to replace it with a new one.
>
> Can anyone help me with this problem?
> I don´t know how to re-open the database. I can´t access to the information
> saved in it
> Thanks all;
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
--
VerifEye Technologies Inc.
151 Whitehall Dr. Unit 2
Markham, ON
L3R 9T1
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Error: "File is encrypted or is not a database"

[Simon Slavin]

On 7 Feb 2014, at 10:49am, Iksanov Husain  wrote:

> We have an encrypted SQLite database with a password which is set 
> programmatically in .NET interface. 

Can you tell us which encryption system you used to encrypt your database ?

Did you change anything in the last day or two: updated operating system, or 
new DLL ?

If you put a copy of the SQLite shell tool on that computer, will it open the 
file ?

If you move the database to a different computer can you open it ?

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Error: file is encrypted or is not a database

[Dmitri Priimak]

Schrum, Allan wrote:
>> -Original Message-
>> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
>> boun...@sqlite.org] On Behalf Of Dmitri Priimak
>> Sent: Wednesday, November 25, 2009 11:39 AM
>> To: General Discussion of SQLite Database
>> Subject: Re: [sqlite] Error: file is encrypted or is not a database
>>
>> Simon Slavin wrote:
>> 
>>> On 25 Nov 2009, at 6:19pm, Dmitri Priimak wrote:
>>>
>>>
>>>   
>>>> Simon Slavin wrote:
>>>>
>>>> 
>>>>> On 25 Nov 2009, at 6:09pm, Dmitri Priimak wrote:
>>>>>
>>>>>
>>>>>   
>>>>>> 000 6166 6c69 6465 7420 206f 706f 6e65 6420
>>>>>> 010 7461 6261 7361 2065 7274 6e61 6173 7463
>>>>>> 020 6f69 206e 3632 3a20 6620 6c69 2065 7369
>>>>>> 030 6520 636e 7972 7470 6465 6f20 2072 7369
>>>>>> 040 6e20 746f 6120 6420 7461 6261 7361 2065
>>>>>> 050 684f 6d20 2e79 5720 2065 6166 6c69 6465
>>>>>> 060 7420 206f 6f72 6c6c 6162 6b63 7420 6172
>>>>>>
>>>>>> 
>>>>> That is the text
>>>>>
>>>>> aflidet  oponed tabasa ertnaastcoi n62: f li esie cnyrtpdeo  rsin
>>>>>   
>> toa d tabasa ehOm .yW  eaflidet oorllabkct ar
>> 
>>>>> You are writing text over your database file.
>>>>>
>>>>>
>>>>>   
>>>> I do not remember doing it.
>>>>
>>>> 
>>> Okay, rather than you yourself, I mean something in your computer.
>>>   
>> Whatever that text is, it's not a SQLite database file and it's not
>> even a slight modification of the database file format.  It's just
>> something that looks very like corrupted text.  The word 'cnyrtpdeo'
>> looks a bit like 'crypto' and 'oponed' looks like 'opened' and I think
>> it's corrupted text.
>> Yes. You are right. :(
>>
>> --
>> Dmitri Priimak
>> 
>
> Byte swap problems. The message is:
>
> "failed to open database transaction 26 = file is encrypted or is not a 
> database Oh my. We failed to rollback tra"
>   
Yes. I can see it now. Something is indeed writing into this file.

--
Dmitri Priimak

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Error: file is encrypted or is not a database

[Schrum, Allan]

> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of Dmitri Priimak
> Sent: Wednesday, November 25, 2009 11:39 AM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] Error: file is encrypted or is not a database
> 
> Simon Slavin wrote:
> > On 25 Nov 2009, at 6:19pm, Dmitri Priimak wrote:
> >
> >
> >> Simon Slavin wrote:
> >>
> >>> On 25 Nov 2009, at 6:09pm, Dmitri Priimak wrote:
> >>>
> >>>
> >>>> 000 6166 6c69 6465 7420 206f 706f 6e65 6420
> >>>> 010 7461 6261 7361 2065 7274 6e61 6173 7463
> >>>> 020 6f69 206e 3632 3a20 6620 6c69 2065 7369
> >>>> 030 6520 636e 7972 7470 6465 6f20 2072 7369
> >>>> 040 6e20 746f 6120 6420 7461 6261 7361 2065
> >>>> 050 684f 6d20 2e79 5720 2065 6166 6c69 6465
> >>>> 060 7420 206f 6f72 6c6c 6162 6b63 7420 6172
> >>>>
> >>> That is the text
> >>>
> >>> aflidet  oponed tabasa ertnaastcoi n62: f li esie cnyrtpdeo  rsin
> toa d tabasa ehOm .yW  eaflidet oorllabkct ar
> >>>
> >>> You are writing text over your database file.
> >>>
> >>>
> >> I do not remember doing it.
> >>
> >
> > Okay, rather than you yourself, I mean something in your computer.
> Whatever that text is, it's not a SQLite database file and it's not
> even a slight modification of the database file format.  It's just
> something that looks very like corrupted text.  The word 'cnyrtpdeo'
> looks a bit like 'crypto' and 'oponed' looks like 'opened' and I think
> it's corrupted text.
> Yes. You are right. :(
> 
> --
> Dmitri Priimak

Byte swap problems. The message is:

"failed to open database transaction 26 = file is encrypted or is not a 
database Oh my. We failed to rollback tra"

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Error: file is encrypted or is not a database

[Dmitri Priimak]

Simon Slavin wrote:
> On 25 Nov 2009, at 6:19pm, Dmitri Priimak wrote:
>
>   
>> Simon Slavin wrote:
>> 
>>> On 25 Nov 2009, at 6:09pm, Dmitri Priimak wrote:
>>>
>>>   
 000 6166 6c69 6465 7420 206f 706f 6e65 6420
 010 7461 6261 7361 2065 7274 6e61 6173 7463
 020 6f69 206e 3632 3a20 6620 6c69 2065 7369
 030 6520 636e 7972 7470 6465 6f20 2072 7369
 040 6e20 746f 6120 6420 7461 6261 7361 2065
 050 684f 6d20 2e79 5720 2065 6166 6c69 6465
 060 7420 206f 6f72 6c6c 6162 6b63 7420 6172
 
>>> That is the text
>>>
>>> aflidet  oponed tabasa ertnaastcoi n62: f li esie cnyrtpdeo  rsin toa d 
>>> tabasa ehOm .yW  eaflidet oorllabkct ar
>>>
>>> You are writing text over your database file.
>>>
>>>   
>> I do not remember doing it.
>> 
>
> Okay, rather than you yourself, I mean something in your computer.  Whatever 
> that text is, it's not a SQLite database file and it's not even a slight 
> modification of the database file format.  It's just something that looks 
> very like corrupted text.  The word 'cnyrtpdeo' looks a bit like 'crypto' and 
> 'oponed' looks like 'opened' and I think it's corrupted text.
Yes. You are right. :(

--
Dmitri Priimak

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Error: file is encrypted or is not a database

[Simon Slavin]

On 25 Nov 2009, at 6:19pm, Dmitri Priimak wrote:

> Simon Slavin wrote:
>> On 25 Nov 2009, at 6:09pm, Dmitri Priimak wrote:
>> 
>>> 000 6166 6c69 6465 7420 206f 706f 6e65 6420
>>> 010 7461 6261 7361 2065 7274 6e61 6173 7463
>>> 020 6f69 206e 3632 3a20 6620 6c69 2065 7369
>>> 030 6520 636e 7972 7470 6465 6f20 2072 7369
>>> 040 6e20 746f 6120 6420 7461 6261 7361 2065
>>> 050 684f 6d20 2e79 5720 2065 6166 6c69 6465
>>> 060 7420 206f 6f72 6c6c 6162 6b63 7420 6172
>> 
>> That is the text
>> 
>> aflidet  oponed tabasa ertnaastcoi n62: f li esie cnyrtpdeo  rsin toa d 
>> tabasa ehOm .yW  eaflidet oorllabkct ar
>> 
>> You are writing text over your database file.
>> 
> I do not remember doing it.

Okay, rather than you yourself, I mean something in your computer.  Whatever 
that text is, it's not a SQLite database file and it's not even a slight 
modification of the database file format.  It's just something that looks very 
like corrupted text.  The word 'cnyrtpdeo' looks a bit like 'crypto' and 
'oponed' looks like 'opened' and I think it's corrupted text.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Error: file is encrypted or is not a database

[Dmitri Priimak]

Simon Slavin wrote:
> On 25 Nov 2009, at 6:09pm, Dmitri Priimak wrote:
>
>   
>> 000 6166 6c69 6465 7420 206f 706f 6e65 6420
>> 010 7461 6261 7361 2065 7274 6e61 6173 7463
>> 020 6f69 206e 3632 3a20 6620 6c69 2065 7369
>> 030 6520 636e 7972 7470 6465 6f20 2072 7369
>> 040 6e20 746f 6120 6420 7461 6261 7361 2065
>> 050 684f 6d20 2e79 5720 2065 6166 6c69 6465
>> 060 7420 206f 6f72 6c6c 6162 6b63 7420 6172
>> 
>
> That is the text
>
> aflidet  oponed tabasa ertnaastcoi n62: f li esie cnyrtpdeo  rsin toa d 
> tabasa ehOm .yW  eaflidet  oorllabkct ar
>
> You are writing text over your database file.
>   
I do not remember doing it.

--
Dmitri Priimak

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Error: file is encrypted or is not a database

[Simon Slavin]

On 25 Nov 2009, at 6:09pm, Dmitri Priimak wrote:

> 000 6166 6c69 6465 7420 206f 706f 6e65 6420
> 010 7461 6261 7361 2065 7274 6e61 6173 7463
> 020 6f69 206e 3632 3a20 6620 6c69 2065 7369
> 030 6520 636e 7972 7470 6465 6f20 2072 7369
> 040 6e20 746f 6120 6420 7461 6261 7361 2065
> 050 684f 6d20 2e79 5720 2065 6166 6c69 6465
> 060 7420 206f 6f72 6c6c 6162 6b63 7420 6172

That is the text

aflidet  oponed tabasa ertnaastcoi n62: f li esie cnyrtpdeo  rsin toa d tabasa 
ehOm .yW  eaflidet  oorllabkct ar

You are writing text over your database file.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Error: file is encrypted or is not a database

[Gerald Dachs]

On Tue, 12 Sep 2006 14:29:12 -0400
<[EMAIL PROTECTED]> wrote:

>  files on your computer and this database file accidently got snagged?>
> 
> Thanks, but this application resides on a PDA and my customer is
> reporting this issue on several PDA's. No search/replace operations are
> being performed at a file level on these devices.

They didn't open the database file with something like pocketword and an
auto correction has done its work?

Gerald

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] Error: file is encrypted or is not a database

[Dennis Jenkins]

Will Leshner wrote:

Ah. Ok. It was just a shot in the dark. I've never seen SQLite itself
change its header like that, so I suspect the culprit lies elsewhere.


Most likely, the following is not the cause of your problem, but it's 
funny:  There was once a virus that did a search and replace across the 
user's hard-drive (back in the DOS days of 20M drives) that changed all 
occurrences of "Microsoft" to "Macrosoft" or something like that.  I 
wish I remembered the details and/or the virus name.  I guess you had to 
be there.



-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: RE: [sqlite] Error: file is encrypted or is not a database

[Will Leshner]

On 9/12/06, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:



Thanks, but this application resides on a PDA and my customer is
reporting this issue on several PDA's. No search/replace operations are
being performed at a file level on these devices.


Ah. Ok. It was just a shot in the dark. I've never seen SQLite itself
change its header like that, so I suspect the culprit lies elsewhere.

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

RE: [sqlite] Error: file is encrypted or is not a database

[Richard.Murphy]

Thanks, but this application resides on a PDA and my customer is
reporting this issue on several PDA's. No search/replace operations are
being performed at a file level on these devices.

Richard

-Original Message-
From: Will Leshner [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 12, 2006 1:26 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Error: file is encrypted or is not a database

On 9/12/06, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:

> What in the world could have caused this??

Is it possible that you did some kind of global search and replace on
files on your computer and this database file accidently got snagged?


-
To unsubscribe, send email to [EMAIL PROTECTED]

-


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] Error: file is encrypted or is not a database

[Will Leshner]

On 9/12/06, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:


What in the world could have caused this??


Is it possible that you did some kind of global search and replace on
files on your computer and this database file accidently got snagged?

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] Error: file is encrypted or is not a database

[Karl Sinn]

Hi Gerard,

Am Sonntag, 17. Juli 2005 14:44 schrieb Dr Gerard Hammond:
> I wrote one app for MacOS and Win32 clients called 'SyBrowser'
> (It was originally written to query Sybase db's but now does others as
> well) It is currently restricted to SQlite 2 db's
>
> http://www.macsos.com.au

Did I say Linux? :-)

Thanks
Karl

Re: [sqlite] Error: file is encrypted or is not a database

[D. Richard Hipp]

The Philips MP3 players use SQLite version 2.x.  You probably
downloaded version 3.x.  Version 3.x will not read or write
version 2.x database files.  Try using version 2.8.16 instead
of whatever version it is you downloaded.

On Sun, 2005-07-17 at 12:08 +0200, Karl Sinn wrote:
> Hi,
> 
> I am completely new with SQLite. My friend has a mp3-Player (I think it was a 
> Phillips iPod like device) and asked me if I can put him some music on. 
> Unfortunately I discovered, that you can do it only with the Windows-Program 
> belonging to the device, because they have a database-file in which they 
> write all the information about the musicfiles stored on it.
> 
> Curious, I looked inside the the databasefile with an editor an I found that 
> line:
> ** This file contains an SQLite 2.1 database **
> 
> So I downloaded the file on my Linux-computer.
> 
> Today I downloaded SQLite and I tried to open the file with the 
> commandline-tool.
> 
> When I do .tables or .databases I get this error:
> Error: file is encrypted or is not a database
> 
> I searched the mailing-list -archive, but did not find any hint.
> What is the problem?
> May it be that I copied the file from the device to my computer? 
> 
> Thanks for any hint
> Karl Sinn
>