Re: TOFU db corruption detected

[MFPA]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA512



On Monday 7 August 2017 at 11:06:45 AM, in
, Neal H. Walfield wrote:-


> Hi,

> Unfortunately, there isn't enough information in this
> report to
> reproduce your issue.  If you feel comfortable
> sending me your TOFU db
> and your pubring.gpg / pubring.kbx per private mail,
> as well as
> telling me which key that is causing the problem,
> then I will take a
> look.

Thanks for the offer. I dumped the tofu.db to a text file, deleted the
bindings relating the the problem key and to a revoked key from the
same user, deleted the signature and encryption entries relating to
those bindings, then restored from the dump file. I don't know what
issues this may introduce but I no longer get the "TOFU db corruption
detected" messages.


- --
Best regards

MFPA  

My mind works like lightning... one brilliant flash and it's gone
-BEGIN PGP SIGNATURE-

iNUEARYKAH0WIQQzrO1O6RNO695qhQYXErxGGvd45AUCWYpHS18UgAAuAChp
c3N1ZXItZnByQG5vdGF0aW9ucy5vcGVucGdwLmZpZnRoaG9yc2VtYW4ubmV0MzNB
Q0VENEVFOTEzNEVFQkRFNkE4NTA2MTcxMkJDNDYxQUY3NzhFNAAKCRAXErxGGvd4
5JcIAP4n5i+77g5bvkCysEatCgHB9THHiCChInhfyr96Xg01kAD/Q3YcPezGmi1+
rALQunLa7xPNuwJVnuCYihUr2swQDw6JAZMEAQEKAH0WIQSzrn7KmoyLMCaloPVr
fHTOsx8l8AUCWYpHVV8UgAAuAChpc3N1ZXItZnByQG5vdGF0aW9ucy5vcGVu
cGdwLmZpZnRoaG9yc2VtYW4ubmV0QjNBRTdFQ0E5QThDOEIzMDI2QTVBMEY1NkI3
Qzc0Q0VCMzFGMjVGMAAKCRBrfHTOsx8l8GkhCACSL74xfkv0uH3BSQ7X3+TdeaUf
RJqQ0BaU6wraCV0+YBZZQlLWQxjZGLyKR09FZBVNz9OJUcV+fUVh4rbeETr4h5+f
TGw358W2rVzohdWdz+IoPQhLpUMwtzSIWZ3+mus8CXokh1N/aOUL9oPUiUgkhhO3
+AX372Nd//mRQ8naCDj/HH8XILGjqp10njCUZYtIZfy9zlRaYsLvrY/UxfCKWAZu
xojN0UAayoCXukxnssECVPLkHRYGFGzT85NfLgNrgcp++GWTW6B1v8F89X+sAx11
C51W7AxLQTYGNyNcCK5k0Az+l1bCWc5oErTmFuD2h0uE+hYDhedWYh/6YCsc
=ZVN0
-END PGP SIGNATURE-


___
Gnupg-users mailing list
Gnupg-users@gnupg.org
http://lists.gnupg.org/mailman/listinfo/gnupg-users

Re: TOFU db corruption detected

[Neal H. Walfield]

Hi,

Unfortunately, there isn't enough information in this report to
reproduce your issue.  If you feel comfortable sending me your TOFU db
and your pubring.gpg / pubring.kbx per private mail, as well as
telling me which key that is causing the problem, then I will take a
look.

Key: 8F17 7771 18A3 3DDA 9BA4  8E62 AACB 3243 6300 52D9

Thanks,

:) Neal

On Sat, 05 Aug 2017 16:56:02 +0200,
MFPA wrote:
>
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA512
> gpg: TOFU db corruption detected.
> gpg: (further info: user id '[jpeg image of size 24800]' not on key
> block 'Fingerprint')
>
>
> I see the above message when encrypting to the key whose fingerprint I
> have redacted above. The copy of that key on my keyring does contain
> an image, which I can view by
> gpg --list-options show-photos --list-keys Fingerptint.
>
>
> How do I "rebuild" the TOFU database to get rid of the corruption?
>
>
> - --
> Best regards
>
> MFPA  

Re: TOFU db corruption detected

[MFPA]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA512



On Sunday 6 August 2017 at 1:32:09 AM, in
, Daniel
Villarreal wrote:-



> "... run sqlite3 with vacuum, reindex and analyze

Reindex and analyze shrunk my tofu.db by a further 4 KB but GnuPG
unfortunately still reports the same issue.

- --
Best regards

MFPA  

Day-old pastry is hollow succour to a man who is bereft of ostrich.
-BEGIN PGP SIGNATURE-

iNUEARYKAH0WIQQzrO1O6RNO695qhQYXErxGGvd45AUCWYb+Ol8UgAAuAChp
c3N1ZXItZnByQG5vdGF0aW9ucy5vcGVucGdwLmZpZnRoaG9yc2VtYW4ubmV0MzNB
Q0VENEVFOTEzNEVFQkRFNkE4NTA2MTcxMkJDNDYxQUY3NzhFNAAKCRAXErxGGvd4
5NWTAP9irQI4bwxuaova0nX6neWUs2V7qsDTII+cgjq4XElw8AD9F48t5Sq4Gyxt
p+OXUAvj5sxGoDduYlsM9z5pKcmuTQmJAZMEAQEKAH0WIQSzrn7KmoyLMCaloPVr
fHTOsx8l8AUCWYb+Ol8UgAAuAChpc3N1ZXItZnByQG5vdGF0aW9ucy5vcGVu
cGdwLmZpZnRoaG9yc2VtYW4ubmV0QjNBRTdFQ0E5QThDOEIzMDI2QTVBMEY1NkI3
Qzc0Q0VCMzFGMjVGMAAKCRBrfHTOsx8l8FjxCACq6PgcIGo1N96nwDlzegXRCUWU
HcyMRYkpoRSVfeod0dLvRd+0gIafj2gI6b2eUr/WYq1Gic3f3QcnSf6MOFzYqwNG
nHZ5GMI8W+zT49+jRm+n0VXdnygb6KLYUTB4Ci1J1fJyW1u+j8kH8krv81d6Xb6P
mx6K47GXgVYmZSHp6j6E1/J2L9VgQ02bhNS3k2sAbr60oFca6Ftn3qw29ZjwC2yo
TyOy+HIn9VP/nDNVAYAn2+CxLwoe6EJI5NLcHSUJ77Kw9bN9tqfTkKLNZS3v54Rr
i6VgLJqqYHMwiZjaxgVZW2YqO9wy3Vd0GLC9hxbsn45wIxjkzWYWCHpxzRq0
=zo4J
-END PGP SIGNATURE-


___
Gnupg-users mailing list
Gnupg-users@gnupg.org
http://lists.gnupg.org/mailman/listinfo/gnupg-users

Re: TOFU db corruption detected

[MFPA]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA512



On Saturday 5 August 2017 at 4:30:12 PM, in
, Teemu Likonen wrote:-


> Before the developers give you more educated answers
> I'll point out that
> the tofu database is a regular Sqlite database file.
> So you can do:

> $ sqlite3 ~/.gnupg/tofu.db

> and then execute any SQL commands. Interesting SQL
> command could be
> "vacuum" which, in Sqlite, basically dumps the the
> database as SQL text
> commands, then deletes the database and finally reads
> the SQL dump
> again. If you want to try that, make a copy of your
> tofu.db file first.
> Then start Sqlite like the example line above and:

> sqlite> vacuum;

> https://www.sqlite.org/lang_vacuum.html


Thanks for replying. I downloaded Sqlite and tried that. It reduced
the size of my tofu.db from 1532 to 1432 KB but unfortunately GnuPG
still reports the same issue.

- --
Best regards

MFPA  

Beware the deadly donkey falling slowly from the sky
-BEGIN PGP SIGNATURE-

iNUEARYKAH0WIQQzrO1O6RNO695qhQYXErxGGvd45AUCWYb9a18UgAAuAChp
c3N1ZXItZnByQG5vdGF0aW9ucy5vcGVucGdwLmZpZnRoaG9yc2VtYW4ubmV0MzNB
Q0VENEVFOTEzNEVFQkRFNkE4NTA2MTcxMkJDNDYxQUY3NzhFNAAKCRAXErxGGvd4
5BVrAQCDiwNBDNPN9AtQUd92U5hQkTiXCCFyDrQhSSsNDtDocgEA3lxrSm0oFBrp
8os/BV2NqI7772dSVa8omLB6IkiDzQWJAZMEAQEKAH0WIQSzrn7KmoyLMCaloPVr
fHTOsx8l8AUCWYb9a18UgAAuAChpc3N1ZXItZnByQG5vdGF0aW9ucy5vcGVu
cGdwLmZpZnRoaG9yc2VtYW4ubmV0QjNBRTdFQ0E5QThDOEIzMDI2QTVBMEY1NkI3
Qzc0Q0VCMzFGMjVGMAAKCRBrfHTOsx8l8DkGB/oDmSfN/uPAeI+SGZOwPVOjrMSN
o/vm9urtqTMRfjv3xCU9qY9P8Lv3WEt6nCPWK3yCH1DOujjR1dis1muyI5aGAzvI
Pm7MjDTZhhawBVX3zc3JywIxPBxc3ZO+L2S6zMfywAjOQP5Zx0vKijj6PMptBRi+
jVAyfyBs403wGFyo7PWrACylJVP1tnNXBMUGhaN4Zlg+bGu8Il2voBK6DXuV1Vkz
YwtcgmAWUOF+AUIp/d09BVHGs9rWRywDFlTsPCoZZOfmHRUzHboTpAYqBljY1RJh
sPE7VFBLejJSSg39jj3VcC9cm+Sj2C8fVWo5YsWw9u33l8u1Jpq52VMwHVSS
=s6Fh
-END PGP SIGNATURE-


___
Gnupg-users mailing list
Gnupg-users@gnupg.org
http://lists.gnupg.org/mailman/listinfo/gnupg-users

Re: TOFU db corruption detected

[Daniel Villarreal]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256

On 08/05/17 11:30, Teemu Likonen wrote:
> MFPA [2017-08-05 15:56:02+01] wrote:
> 
>> ... "rebuild" the TOFU database to get rid of the corruption?
> 
> ... tofu [db] is a regular Sqlite [db] file. So you can do:
> 
> $ sqlite3 ~/.gnupg/tofu.db
> 
> and ... SQL commands. Interesting SQL command could be "vacuum". 
> [Backup] tofu.db file first. Then start Sqlite ...
> 
> sqlite> vacuum; https://www.sqlite.org/lang_vacuum.html



Thanks to Jason L. Froebe...

"... run sqlite3 with vacuum, reindex and analyze on each of the
*.sqlite databases."

I use this script with sqlite2 also.

http://froebe.net/blog/2013/01/27/optimizing-the-firefox-sqlite-database
s/

and then for all my different Firefox profiles, I change
for profile in *.default; do
to
# for profile in *; do

- -- 
Daniel Villarreal
http://www.youcanlinux.org
youcanlinux at gmail.com
PGP key 2F6E 0DC3 85E2 5EC0 DA03  3F5B F251 8938 A83E 7B49
https://pgp.mit.edu/pks/lookup?op=get=0xF2518938A83E7B49
-BEGIN PGP SIGNATURE-

iQEcBAEBCAAGBQJZhmOBAAoJEPJRiTioPntJxy4H/1SQBA9SyyBXc95XB75xKJGE
7cz1kHjIjplTOn2z3WLK9z41/qZuQVdo8nfefUtowLXegEozgK5kt00Qfmd8yf85
qN53eea9dZfZLe6dYZMtRlgRPY+kkuJoZY4uMylzHG6i8DRjrUU+nTlYy3BxYvFH
pOZHzmeoIdFYrRIcYaJKQTzjf6eZJYSEEOKdxf7bTAtDs6h+kg7t8Bm2NDxtBg+/
+K2Dxg/Zq7PulEcxPeBinU4eWKXf0Xkmdm0yfBpKlE5y6y/c+px9EVwGpE/pr/l/
nFjnK5vknc+/MAqzbnrkEiAY0/y3QnJRVoS1B/NSSBL/I/UnL+Bi0dfL1XVv+pg=
=QfmK
-END PGP SIGNATURE-

___
Gnupg-users mailing list
Gnupg-users@gnupg.org
http://lists.gnupg.org/mailman/listinfo/gnupg-users

Re: TOFU db corruption detected

[Teemu Likonen]

MFPA [2017-08-05 15:56:02+01] wrote:

> How do I "rebuild" the TOFU database to get rid of the corruption?

Before the developers give you more educated answers I'll point out that
the tofu database is a regular Sqlite database file. So you can do:

$ sqlite3 ~/.gnupg/tofu.db

and then execute any SQL commands. Interesting SQL command could be
"vacuum" which, in Sqlite, basically dumps the the database as SQL text
commands, then deletes the database and finally reads the SQL dump
again. If you want to try that, make a copy of your tofu.db file first.
Then start Sqlite like the example line above and:

sqlite> vacuum;

https://www.sqlite.org/lang_vacuum.html

-- 
/// Teemu Likonen   - .-..    //
// PGP: 4E10 55DC 84E9 DFF6 13D7 8557 719D 69D3 2453 9450 ///


signature.asc
Description: PGP signature
___
Gnupg-users mailing list
Gnupg-users@gnupg.org
http://lists.gnupg.org/mailman/listinfo/gnupg-users