From: Wookey <wo...@al...> - 2005-06-24 20:33:32
|
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 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? Does PHPwiki have authentication options to stop this sort of spammer abuse in the future? Thanx for any help you can provide. THis happened just before I wnt on holiday for a month so it's now been broken for nearly two months and I really must fix it! 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/ |
From: Joel U. <uck...@no...> - 2005-06-25 00:59:48
|
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 > > 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? > 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. |
From: Wookey <wo...@al...> - 2005-06-25 01:33:42
|
+++ 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/ |
From: Reini U. <ru...@x-...> - 2005-06-25 06:31:41
|
> +++ 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/ |