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

[Reini U. <ru...@x-...>]

> +++ 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.

we don't care about berkeley versions. php does this for us. one person
even used the flatfile handler for dba, though this is explicitly
recommended
NOT ti use. so db4 just works.

> 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?

yes.
from time to time I despam some wiki's.
see  e.g. http://netznetz.net/wiki/index.php/Spam/148.244.150.58
to get rid of spam from this ip.

>> > 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?

debian phpwiki-1.3.7 I assume.
better antispam is only since 1.3.11_rc3 or cvs HEAD.
password auth since about 1.3.8
-- 
Reini Urban
http://phpwiki.org/   http://xarch.tu-graz.ac.at/home/rurban/