[Phpwiki-talk] Re: My wiki has been corrupted by spammers

[Wookey <wo...@al...>]

+++ Joel Uckelman [05-06-24 19:59 -0500]:
> Thus spake Wookey:
> > I used to have a nice wiki at http://balloonboard.org/wiki but it got filled
> > up with wikispam :-(
> > 
> > You can see the old wiki at http://balloonboard.org/wikitest (which now just
> > produces:
> > lib/DbaDatabase.php:32: Fatal[256]:
> > dba_open(/var/lib/phpwiki/phpwiki_pagedb.db2,c-): No such handler: db2

Whilst I am here can someone give me clues on fixing this? I have upgraded
the server from Debian 3.0 to 3.1 and I think the libdb default version has
changed from 2 to 4. phpwiki seems to support db2 and 3 formats.

Do I need to db_dump and db_load my database file in order to convert it
from v2 to 3. I don't see anything in the man pages saying how to specify
the format when generating the file with db_load.

> > I tried to just revert the spammed changes but it didn't work as the
> > database appeared to be corrupt. 
> > 
> > I eventually worked out that the content of the wiki is in a file called
> > phpwiki_pagedb.db2
> > 
> > Is there any way I can extract the original wiki content form this dtaabase,
> > preferably as formatted HTML, but as wikitext would also be fine.
> > 
> > How might I go about uncorrupting the database so I can put the wiki back?
> 
> Have you tried going to the Admin page and dumping the wiki from there?

Nope - where is the admin page and how do I do that - I searched for some
mechanism for dumping the contents but failed to find it - is there some doc
I missed?

> > Does PHPwiki have authentication options to stop this sort of spammer abuse
> > in the future?
> 
> Yes, lots. There are a half-dozen different ways you can authenticate users
> in the current version.

OK - looking in /etc/phpwiki I see a number of things which look like
authentication mechanisms. Again are there docs explaining these options, or
do I just read the comment sin the config file and try and work it out?

Wookey
-- 
Aleph One Ltd, Bottisham, CAMBRIDGE, CB5 9BA, UK  Tel +44 (0) 1223 811679
work: http://www.aleph1.co.uk/     play: http://www.chaos.org.uk/~wookey/