Re: [Help-gnunet] help with database management

[Benjamin Paul Kay]

On Sunday 12 October 2003 16:52, Christian Grothoff wrote:
> On Saturday 11 October 2003 04:39 pm, Benjamin Paul Kay wrote:
> > I am using GNUnet 0.6.0a with mysql as the DB. The pertinent lines of
> > gnunet.conf look like this:
> >
> > DISKQUOTA = 5120
> > DATABASETYPE = "mysql"
> > DATABASEBUCKETS = 1
> > ACTIVEMIGRATION = YES
> >
> > GNUnet has been stable since upgrading to 0.6.0a. But after indexing
> > numerous files, including an approx. 700 MB file, gnunet-stats shows:
> >
> > # indexed files                     : 1
> > # size of indexed files             : 5360454
> > # blocks afs storage left   : 4284417
> >
> > I can search and download all of my indexed files, but only one of them
> > seems to be showing up under gnunet-stats. What's going on?
>
> Hmm. You do not happen to have an option
> INDEX-CONTENT = YES
> in your gnunet.conf by any chance? Then gnunet-insert would always insert
> and not index.  Given a quota of 5 GB (minus 700 MB) would result in about
> 4.2 GB left (afs storage left), so it would match pretty nicely.

The phrase "INDEX-CONTENT" does not appear in gnunet.conf. Recall that I have 
ACTIVEMIGRATION enabled, so some of the afs storage may be being used by 
migrated content. However with Igor Wronsky's help I have pretty determined 
that the DB is a-ok, so the only plausible explanation left is that the 
content was inserted rather than indexed. I am quite certain that I did not 
insert the content (unless gnunet-gtk is inserting content marked "index 
only") - is there anything else that would cause the content to be inserted?

> > Ideally, I would like to be able to:
> > - see what I have indexed/inserted (names, descriptions, keywords)
> > - edit keywords and descriptions for inserted files
> >
> > Is there any way to actually do this? Or to at least get gnunet-stats to
> > tally all my indexed files? And more importantly, can others download
> > files that gnunet-stats doesn't see?
>
> I've added an entry to the FAQ for this one
> (http://www.ovmj.org/GNUnet/faq.php3#tell

Thanks for the tip - wish I had seen that earlier!