The Wakaba and Kareha support thread, part 2 (1000)

1 Name: !WAHa.06x36 : 2007-10-11 06:19 ID:K4vOYfq0 [Del]

This thread is for all your simple questions about installing and running Wakaba or Kareha, that just require quick answers. Please don't create new threads for issues like that, post them in here instead.

Before posting, check that the question has not already been answered in this thread, or in the previous thread: http://wakaba.c3.cx/sup/kareha.pl/1141929669/

Questions about "500 Internal Server Errors" go in this thread: http://wakaba.c3.cx/sup/kareha.pl/1109033191/

201 Post deleted by moderator.

202 Post deleted by moderator.

203 Name: Anonymous : 2008-04-12 17:28 ID:lpemlo1D [Del]

Everything else works, image posts and replies.. so on. But when I put in my password at the [Manage] panel, it says it's wrong.

use constant ADMIN_PASS => 'password'

has been changed and everything... Dreamhost, permissions and everything else right/working

204 Name: !WAHa.06x36 : 2008-04-12 17:28 ID:lpemlo1D [Del]

>>203

Are there any special characters in the password?

205 Name: Anonymous : 2008-04-12 17:42 ID:M8UtrbXC [Del]

>>25

I'm getting the same problem. I've tried changing the password, using only numbers... it won't let me access the management panel.

206 Name: Anonymous : 2008-04-12 17:43 ID:M8UtrbXC [Del]

>>204

ha, I'm a retard, didn't even notice that first one posted. No special characters, only numbers

207 Name: Anonymous : 2008-04-12 17:45 ID:M8UtrbXC [Del]

Oh weird, I changed the URL to have my password on the end and it suddenly started working... um, do I just have to keep doing this? Actually, I don't mind... but if anybody knows what's going on..

208 Name: Anonymous : 2008-04-12 18:53 ID:3hOzvvWU [Del]

I was wondering how hard it would be to set up on a wakaba board a spoiler/censor system like some boards, noteably 4chan's /a/ and /co/, have to replace the thumbnail with a black box or something. Is this something that would take a lot of work? Has already done it and if so would the mind sharing how to set it up?

209 Name: Anonymous : 2008-04-13 00:12 ID:Heaven [Del]

>>207 it's not hashing, then? That's very odd.

210 Name: !WAHa.06x36 : 2008-04-13 08:25 ID:lpemlo1D [Del]

>>207

Sounds like something is very strange with your server, maybe?

211 Name: TheStupidOne!36Pr0Wdt4A : 2008-04-15 04:14 ID:LO7hlnjJ [Del]

I've discovered a denial of service flaw in Kareha, and I've been the victim of these attacks for the past few weeks. I dunno if it's intentional or just some sort of bizarre bug, but if you send a specially formed string in the call to kareha.pl, it will cause the process to hang, forcing lighttpd to spawn another one in a neverending race condition.

It's completely crashed my server twice, and just today I barely caught it in time by noticing the telltale studdering in my ssh connection and killing lighttpd before it got too far.

212 Name: !WAHa.06x36 : 2008-04-15 10:41 ID:Heaven [Del]

Sounds sort of like a lighttpd bug. I don't think a CGI process should ever be respawned under any circumstances.

213 Name: Anonymous : 2008-04-15 13:05 ID:Heaven [Del]

>>212
FastCGI, maybe?

214 Name: Anonymous : 2008-04-15 17:43 ID:znEncqz+ [Del]

I'm using mode_message and:
use constant PAGE_GENERATION => 'paged';
on my board and I see that kareha is indeed generating cached thread pages (1.html, 2.html, etc) but it doesn't create a page list on any of them. Basically the only way to get at threads that fell off the front page is to view the All Threads page and pick one from there.
Did I miss an option to have it stick a page list somewhere?

215 Name: Anonymous : 2008-04-15 21:51 ID:Heaven [Del]

>>214
paged and mode_message aren't so great together.

You can hack the template and add that stuff...

216 Name: TheStupidOne!36Pr0Wdt4A : 2008-04-16 06:42 ID:LO7hlnjJ [Del]

I'm not using fastcgi, just the standard cgi caller, and it's spawning multiple perl processes because the "attacker" will make multiple calls, and since the perl process is hung, the old ones will never die, eventually leading into an out of memory condition.

I guess I misworded it, lighttpd itself isn't spawning new perl processes, but the old ones won't expire so every call to kareha with that malformed string creates a new perl process that hangs.

217 Post deleted by moderator.

218 Name: !WAHa.06x36 : 2008-04-16 09:41 ID:lpemlo1D [Del]

>>214

I think the Kareha templates don't implement support for paged mode. You'll have to hack them to do so.

>>216

Well, there's nothing anybody can do until you figure out what exact request is being sent.

219 Name: TheStupidOne!36Pr0Wdt4A : 2008-04-16 10:23 ID:LO7hlnjJ [Del]

Well I have it in my logs, I just don't want to openly post it.

220 Name: !WAHa.06x36 : 2008-04-16 10:27 ID:Heaven [Del]

Then mail it. See the front page for address.

221 Name: TheStupidOne!36Pr0Wdt4A : 2008-04-16 10:37 ID:Heaven [Del]

Access.log entries sent.

222 Name: BigStiffy : 2008-04-22 06:56 ID:Hk2/a1RE [Del]

I have a problem when setting up kareha (using a free hosting service), I have all the permissions set to 777, and the config.pl file configured for mode_message, but when I try to access kareha.pl from a browser it doesn't assemble the board, instead I get sent to my service's default 404 link. Any ideas what I'm doing wrong?

223 Name: !WAHa.06x36 : 2008-04-22 10:00 ID:Heaven [Del]

>>222

Not unless you are more specific. Do you get forwarded when you go to kareha.pl? Is index.html created on the server?

224 Name: Anonymous : 2008-04-22 12:54 ID:Heaven [Del]

>>222

> (using a free hosting service)

There's your problem.

225 Name: Anonymous : 2008-04-26 15:28 ID:00J53KPE [Del]

How can i run kareha.pl if I only have ssh access to my webserver? Using perl kareha.pl creates an index.html file, but its broken(Can't post anything on the board).

Thanks for your help!

226 Name: Anonymous : 2008-04-26 15:29 ID:00J53KPE [Del]

How can i run kareha.pl if I only have ssh access to my webserver? Using perl kareha.pl creates an index.html file, but its broken(Can't post anything on the board).

Thanks for your help!

228 Name: Anonymous : 2008-04-27 13:38 ID:00J53KPE [Del]

225 here

>>227

"Access wakaba.pl through a web browser. This should create the HTML pages and forward you to them if everything worked."

I'm working on my site from home through ssh. I've got everything setup the way it should, BUT I heard that I should NOT run kareha.pl via command "perl kareha.pl", i must use a web browser.

The thing is....I ONLY have access to my webserver via SSH. How am I supposed to launch kareha.pl without having access to a web browser on the server? Is there a way to open a web browser in ssh?

I'm a newbie to linux, so let me know. Thanks!

229 Name: !WAHa.06x36 : 2008-04-27 13:46 ID:Heaven [Del]

>>228

Read about CGI scripting.

230 Name: Anonymous : 2008-04-27 14:12 ID:00J53KPE [Del]

>>229

How is reading about CGI scripting going to solve my problem?

When I run the command "perl kareha.pl", it creates a index.html. When I go to http://"webhost ip" (I dont have a Domain name yet), I CAN see the kareha board fine and everything looks good, but when I create a new thread and click submit. The page refreshes, but the thread doesn't show up.

From what I read here, someone said NOT to run kareha.pl from command because it will create a broken index.html. So, I'm assuming THIS is the broken index.html he was talking about.

231 Name: Anonymous : 2008-04-27 16:23 ID:Heaven [Del]

>>230
Don't run kareha.pl directly. How hard is that to understand?

232 Name: Anonymous : 2008-04-27 16:25 ID:00J53KPE [Del]

>>231
if I run http://webhostip/kareha.pl it just opens up as txt.

How else am I supposed to execute it?

233 Name: !WAHa.06x36 : 2008-04-27 16:54 ID:Heaven [Del]

> How is reading about CGI scripting going to solve my problem?

Because Kareha is a CGI script. Read up on how to make those run on your web server.

234 Name: Anonymous : 2008-04-27 19:26 ID:00J53KPE [Del]

ok i figured it out i think...

I was putting my kareha files in /var/www/html/ I can't execute perl scripts from that directory. SO I moved my kareha files to /usr/local/apache2/cgi-bin/ and I was able to execute the perl script from my browser, but I get a 500 Internal Error.

What do I have to do to Apache's httpd.conf file to enable me to run scripts in /var/www/html/ ??

235 Name: Anonymous : 2008-04-28 03:46 ID:Heaven [Del]

CHMOD kareha.pl and admin.pl to 755

236 Name: Anonymous : 2008-04-28 05:34 ID:Heaven [Del]

>>234
http://wakaba.c3.cx/sup/subback.html
Ctrl-F, "500", Enter.

Also, it would help to read the Apache documentation before blindly running ahead and making a complete mess of everything. That's a fantastic way to end up with a completely insecure setup.

Don't put it in your cgi-bin, either; it's not meant to run that way and it won't work.

You really should take some time to learn what you're doing -- don't expect to be constantly spoon-fed. If you can't put any amount of effort toward solving your problems, why should you expect others to do so for you?

237 Name: Anonymous : 2008-04-30 00:23 ID:NZs3bbdN [Del]

Short question: I'm setting up a site with multiple boards (similar to Desuchan, for example). Do I need a separate SQL database for each board, or will they all share the same database?

238 Name: Anonymous : 2008-04-30 06:18 ID:Heaven [Del]

>>237
You need different tables for each board, but apart from that they can all use the same database.

239 Name: Anonymous : 2008-04-30 15:26 ID:CTi9NJZW [Del]

Ah yes, I forgot I could change the tables. Thanks a lot :)

240 Name: Anonymous : 2008-05-04 08:38 ID:G0S4q6A1 [Del]

how can i make more boards like tv,photography,movies,games etc?

241 Name: Anonymous : 2008-05-04 08:48 ID:G0S4q6A1 [Del]

>>240

and im using kareha

242 Name: !WAHa.06x36 : 2008-05-04 09:24 ID:Heaven [Del]

Just install more copies.

But before you do, put some thought to into whether you really need any more boards.

243 Name: Anonymous : 2008-05-11 21:33 ID:hH1hSKS5 [Del]

>>237
Desuchan's version of wakaba is a unified "server" structure.

244 Name: R!ozOtJW9BFA : 2008-05-12 18:01 ID:/3TiKogu (Image: 353x216 jpg, 10 kb) [Del]

src/1210640517825.jpg: 353x216, 10 kb

Can't get passed this.
The last thread implied that this means DBD might not be installed, but it is. Can anyone help?

245 Name: R!LQz4LF5yKE : 2008-05-12 23:01 ID:lbDpegX1 [Del]

Checked my error log. I get...

[2008-05-13 00:54:50]: error: directory is writable by others: (/home/junkmanx/public_html/level1/LV1)
[2008-05-13 00:48:30]: error: directory is writable by others: (/home/junkmanx/public_html/level1/LV1)
[2008-05-13 00:26:09]: error: file is writable by others: (/home/junkmanx/public_html/level1/LV1/wakaba.pl)
[2008-05-13 00:25:41]: error: file is writable by others: (/home/junkmanx/public_html/level1/LV1/wakaba.pl)
[2008-05-13 00:25:13]: error: file is writable by others: (/home/junkmanx/public_html/level1/LV1/wakaba.pl)
[2008-05-13 00:21:58]: error: file is writable by others: (/home/junkmanx/public_html/level1/LV1/wakaba.pl)
[2008-05-13 00:21:42]: error: file is writable by others: (/home/junkmanx/public_html/level1/LV1/wakaba.pl)
[2008-05-13 00:21:25]: error: file has no execute permission: (/home/junkmanx/public_html/level1/LV1/wakaba.pl)
[2008-05-13 00:21:05]: error: file is writable by others: (/home/junkmanx/public_html/level1/LV1/wakaba.pl)
[2008-05-13 00:20:07]: error: file is writable by others: (/home/junkmanx/public_html/level1/LV1/wakaba.pl)
[2008-05-13 00:15:23]: error: file is writable by others: (/home/junkmanx/public_html/level1/LV1/wakaba.pl)
[2008-05-13 00:15:02]: error: file is writable by others: (/home/junkmanx/public_html/level1/LV1/wakaba.pl)
[2008-05-12 19:53:37]: error: file is writable by others: (/home/junkmanx/public_html/level1/LV1/wakaba.pl)
[2008-05-12 19:52:36]: error: file is writable by others: (/home/junkmanx/public_html/level1/LV1/wakaba.pl)
[2008-05-12 19:26:10]: error: directory is writable by others: (/home/junkmanx/public_html/level1/LV1)
[2008-05-12 19:26:03]: error: directory is writable by others: (/home/junkmanx/public_html/level1/LV1)
[2008-05-12 19:06:57]: error: directory is writable by others: (/home/junkmanx/public_html/level1/LV1)
[2008-05-11 19:45:22]: error: directory is writable by others: (/home/junkmanx/public_html/level1)

246 Name: !WAHa.06x36 : 2008-05-13 09:08 ID:Heaven [Del]

>>244

It means your SQL configuration is wrong.

247 Name: R!ozOtJW9BFA : 2008-05-13 15:31 ID:bccawtev [Del]

Well what do you suggest I do to fix it? I posted my errors in 245.

248 Name: !WAHa.06x36 : 2008-05-13 15:46 ID:Heaven [Del]

>>246

None of those errors have anything to do with it. Also, none of us know what your SQL setup is, so it's not like we can do anything about it. You pretty much have to figure it out yourself.

249 Name: Anonymous : 2008-05-14 13:00 ID:2vbzzEho [Del]

Curious as to why when I made a board it copied everything from the first one I made onto it. Also, more importantly, why aren't my things located at img.(hostname).net/(boardname)? it's just (hostname).net/(boardname). I used img as the thing in mysql.

250 Name: !WAHa.06x36 : 2008-05-14 14:37 ID:Heaven [Del]

>>249

Because you used the same table in the SQL database? Also, SQL has nothing to do with where your things appear on the web. That's all up to the Apache setup.

251 Name: Anonymous : 2008-05-14 15:06 ID:2vbzzEho [Del]

>>250
Fair enough, I don't know much about databases (blatantly). Is there any way I can set this up? Will this happen every time I make a new board?

Also, how do I make it so you don't have to post an image with every reply?

252 Name: Anonymous : 2008-05-15 00:17 ID:LOgzZE8w [Del]

>>251 just change what the tables are named in wakaba's config.pl file.

And you don't have to post an image with every reply...?

253 Name: Anonymous : 2008-05-15 01:27 ID:USUb8UEg [Del]

>>252
Yeah, I figured that out this morning, thanks.

I meant, so you don't have to check the box every time.

254 Name: Anonymous : 2008-05-15 08:53 ID:2vbzzEho [Del]

How does one give people moderator access?

255 Name: R!ozOtJW9BFA : 2008-05-15 15:26 ID:cd4jhGow [Del]

>>248
Do I have to create tables myself?

256 Name: Anonymous : 2008-05-15 15:32 ID:Heaven [Del]

>>254
Give them the password

>>255
No

257 Name: hina : 2008-05-21 03:33 ID:1Ael6+GC [Del]

In kareha, there was an INCLUDE_DIR option where I could set a 'global' header, footer, and rules page for all my boards. Yes, sorry, boards.

I can't seem to find this option in wakaba. Could someone point me in the right direction, please?

258 Name: johnny : 2008-05-21 23:18 ID:94oMzZqt [Del]

My kareha imageboard index loads and seems to be working fine, but when someone tries to make a post, nothing is added. Hitting the submit button seems to do nothing other than refresh the page. Help?

259 Name: mike : 2008-05-22 09:09 ID:6qpk9T9Z [Del]

i thought i got everything right but apparently i didn't.. would anyone know what to do when this comes up?

[error] Bareword "DEFAULT_STYLE" not allowed while "strict subs" in use at

                 /usr/home/me/public_html/wakaba/futaba_style.pl line 642.\nCompilation failed in require at /home/me/public_html/wakaba/wakaba.pl line
19.\nBEGIN failed--compilation aborted at /home/me/public_html/waka

thanks!

260 Name: Anonymous : 2008-05-22 10:20 ID:2vbzzEho [Del]

Uh oh, one of my boards now only shows as a blank white page and the file size is 0 of wakaba.html. I've tried running wakaba.pl but to no luck-- any help? It worked fine before.

261 Name: Anonymous : 2008-05-22 15:35 ID:Heaven [Del]

>>260
Check your error logs.

262 Name: !WAHa.06x36 : 2008-05-22 18:10 ID:Heaven [Del]

>>257

Sorry, never implemented it there. You can either change the paths in futaba_style.pl, or you can make the include/ directory a softlink to some central directory.

>>258

You probably ran kareha.pl on the command line. Delete index.html and then go to kareha.pl through the browser.

>>259

You messed up the files somehow, probably config_defaults.pl.

>>260

Go to admin.pl?action=admin and rebuild caches.

263 Name: Anonymous (moved from other thread) : 2008-05-26 13:37 ID:Heaven [Del]

hi i would like to remove the image verification process from my wakaba board. how do i do this while keeping the board clean and functional? thanks.

264 Name: !WAHa.06x36 : 2008-05-26 13:39 ID:lpemlo1D [Del]

>>263

use constant ENABLE_CAPTCHA => 0;

265 Name: Anonymous : 2008-05-26 14:33 ID:eho4jHIG [Del]

>>263

When did moving posts get implemented (sorry if I'm slowpoking)

266 Name: !WAHa.06x36 : 2008-05-26 16:53 ID:Heaven [Del]

>>265

It didn't.

267 Name: Anonymous : 2008-05-26 18:43 ID:eho4jHIG [Del]

>>266
It should.

268 Name: Anonymous : 2008-05-27 12:13 ID:G2Yt5Xc+ [Del]

I have a wakaba setup with multiple boards and was wondering how
people handle ip bans across multiple boards. Every so often I get
an asshat or two that want to spam crap on a board and a day or
two later after i have removed it hit another board and so on. Do
you use a script to transfer the ip's from board to board ro do
you just deal with them one a a time??

269 Name: Anonymous (moved from other thread) : 2008-05-28 07:26 ID:Heaven [Del]

getting
"SQL connection failure"

Other wise the board seems to load up fine.

270 Name: !WAHa.06x36 : 2008-05-28 07:27 ID:K4vOYfq0 [Del]

>>268

You can use the same admin table for all your boards, if you want. That makes all bans global. That's a pretty common setup.

>>269

Fix your SQL settings and/or SQL server.

271 Name: Anonymous : 2008-05-28 13:04 ID:JPEG70Jy [Del]

>>270

That got it, bans show up across all boards now, Tnaks

272 Name: Anonymous : 2008-05-28 20:51 ID:Heaven [Del]

> ID:**JPEG**70Jy

273 Name: Anonymous : 2008-05-28 22:39 ID:+2TBumzq [Del]

Alright, I'm sorry but I just have a few questions. First off, how do I set up multiple boards. I understand HTML directories and etc, but I don't understand what files need to reside where. Do I need ALL the files for each board? Right now I have a working install, can I just duplicate this, dropping it in folders (one dir down from where it is now) and then create an index.html linking to each of these? Or can I have one copy of some files in the / and duplicates of others? I have no idea why each board would need its own config, CSS, and etc if they are going to be the same. Thanks for your time.

274 Name: Anonymous : 2008-05-29 03:09 ID:Heaven [Del]

>>273

use constant CSS_DIR => '../css/';

The configs won't all be the same; at the very least you need to change the table name, unless you really want all of the boards to share the same posts as well for some perverse reason. Also, symlinks are your friend.

275 Name: Anonymous : 2008-05-29 12:26 ID:Heaven [Del]

> The configs won't all be the same; at the very least you need to change the table name

unless you're using kareha, >>273 didn't say if he's using wakaba or kareha.
you'd still probably want to change the board title, tho. so you'll probably still have separate configs for each board.

276 Name: Anonymous : 2008-05-29 13:43 ID:+2TBumzq [Del]

Thanks! I'm sorry that I forgot to mention that I am using Kareha. One more questions, what about the scripts? Do I need duplicate scripts each folder? Do I need the scripts in the root folder? I'm sorry for not understanding much of this. From googling symlinks I found out that they are similar to an alias, which I do understand with my mac background, but I'm not sure how to create one on my server. Thanks for all your help.

277 Name: Anonymous : 2008-05-29 17:21 ID:Heaven [Del]

Ah. If you have shell access you can make a link with ln -s existing_file new_name. Don't know if it's possible with ftp though.

Barring that, basically just make a complete installation for each board, and move all the stylesheets and spam.txt up a level. No harm in making complete copies of everything, it's just a little more difficult to make changes across the whole site (e.g. upgrade).

278 Name: Anonymous : 2008-05-29 22:15 ID:+2TBumzq [Del]

Thank you, for all your help. I don't have ssh access or anything like that, so while working though FTP I just decided to make duplicate files in my directories. I am only trying to set up one board right now, but it is failing pretty hard. I don't want to use any of those stylesheets, so I made my own. I changed default stylesheet to the filename of mine -.css. and placed it in the correct directory. I honestly don't care if the others are options on the page, but I do want mine to be default. Well, when I browsed to kareha.pl it made my html page, and that seemed to work fine, but when I moved all the files (except /CSS and /spam.txt) down a directory it didn't (from / to /b/). I changed the config to ../CSS and ../spam.txt. After that, my index.html wouldn't display with any stylesheets. I don't understand what I'm doing at all. I know XHTML, but not JS, perl, or PHP. I want to customize the page layout, and have no idea how to do this. I don't want the subject field, or the link field. I can't just edit the HTML, that seems to work, but then it screws something up. I have tried around 10 different installs and they all have some problem.

279 Name: Anonymous : 2008-05-30 22:58 ID:Heaven [Del]

> Well, when I browsed to kareha.pl it made my html page, and that seemed to work fine, but when I moved all the files (except /CSS and /spam.txt) down a directory it didn't (from / to /b/). I changed the config to ../CSS and ../spam.txt. After that, my index.html wouldn't display with any stylesheets.

try deleting index.html and browsing to kareha.pl again after moving the files and changing the config.

> I want to customize the page layout, and have no idea how to do this. I don't want the subject field, or the link field. I can't just edit the HTML, that seems to work, but then it screws something up.

try editing templates.pl.

280 Name: Anonymous : 2008-06-01 09:53 ID:2vbzzEho [Del]

One of my threads (on a wakaba board) isn't bumping and it's important (thus I need it to). What's up with that? It's not even an old thread.

281 Name: !WAHa.06x36 : 2008-06-01 13:21 ID:Heaven [Del]

>>280

Does it have more posts than the bump limit?

282 Name: Anonymous : 2008-06-02 01:10 ID:2vbzzEho [Del]

>>281
Thanks, that was exactly it.

283 Name: Anonymous : 2008-06-03 20:33 ID:Ut7NeexG [Del]

Has anyone written a script to convert from wakaba to kareha and keep the old wakaba message base? Google is not being helpful.

284 Name: Anonymous : 2008-06-03 20:49 ID:Heaven [Del]

>>283
Probably not, Wakaba is superior to Kareha, why would you convert it?

285 Post deleted by user.

286 Name: Anonymous : 2008-06-03 21:06 ID:Ut7NeexG [Del]

>>284
I want to dump the database back end.

While we're at it, does anyone know how to add a "Report" button to either Wakaba or Kareha?

287 Name: Anonymous : 2008-06-04 03:51 ID:Heaven [Del]

>While we're at it, does anyone know how to add a "Report" button to either Wakaba or Kareha?

Do it yourself?

288 Name: Anonymous : 2008-06-04 18:10 ID:AEO3Mwbi [Del]

How would you add noko support to take you back to the thread you posted in when that's in the email field?

289 Name: Anonymous : 2008-06-04 22:51 ID:Heaven [Del]

>>288
click the back button after you post?

290 Post deleted by user.

291 Name: Anonymous : 2008-06-05 02:43 ID:Heaven [Del]

(Note: untested code.)

In wakaba.pl, line 600-ish:

- make_http_forward(HTML_SELF,ALTERNATE_REDIRECT);
+ if ($c_email eq 'noko') {
+ make_http_forward(RES_DIR.($num or $parent).PAGE_EXT,ALTERNATE_REDIRECT);
+ } else {
+ make_http_forward(HTML_SELF,ALTERNATE_REDIRECT);
+ }

Kareha is slightly trickier, but still not difficult.

292 Name: Anonymous : 2008-06-05 18:51 ID:eho4jHIG [Del]

>>291

Doesn't work, however I tried something different based off of what you did (in a way).

Replace (around line 600):

	make_http_forward(HTML_SELF,ALTERNATE_REDIRECT);

With:

	my $noko;
my $noko2;
if($parent)
{
$sth=$dbh->prepare("SELECT num FROM ".SQL_TABLE." WHERE timestamp=? AND comment=?;") or make_error(S_SQLFAIL);
$sth->execute($time,$comment) or make_error(S_SQLFAIL);
$noko = $parent;
$noko2 = '#'.($sth->fetchrow_array())[0];
}
else
{
$sth=$dbh->prepare("SELECT num FROM ".SQL_TABLE." WHERE timestamp=? AND comment=?;") or make_error(S_SQLFAIL);
$sth->execute($time,$comment) or make_error(S_SQLFAIL);
$noko = ($sth->fetchrow_array())[0];
}

if($c_email eq 'noko')
{
make_http_forward(RES_DIR.$noko.PAGE_EXT.$noko2,ALTERNATE_REDIRECT);
}
else
{
make_http_forward(HTML_SELF,ALTERNATE_REDIRECT);
}

It may be bulk and able to be done in less lines of code, but this works perfectly.

293 Name: !WAHa.06x36 : 2008-06-06 03:37 ID:Heaven [Del]

>>292

If you're using MySQL, there should be a function for getting the value of the autoincrementing column of the last update. You could use that instead of the unwieldy SELECTs.

294 Name: Anonymous : 2008-06-06 04:12 ID:eho4jHIG [Del]

	if($parent) { build_thread_cache($parent); }
else # must find out what our new thread number is
{
if($filename)
{
$sth=$dbh->prepare("SELECT num FROM ".SQL_TABLE." WHERE image=?;") or make_error(S_SQLFAIL);
$sth->execute($filename) or make_error(S_SQLFAIL);
}
else
{
$sth=$dbh->prepare("SELECT num FROM ".SQL_TABLE." WHERE timestamp=? AND comment=?;") or make_error(S_SQLFAIL);
$sth->execute($time,$comment) or make_error(S_SQLFAIL);
}
my $num=($sth->fetchrow_array())[0];

if($num)
{
build_thread_cache($num);
}
}

is what I used as a base for it. I'm not very good at Perl, so I'm just happy it works.

295 Name: !WAHa.06x36 : 2008-06-06 04:44 ID:Heaven [Del]

>>294

I had to do that because I don't want to rely on MySQL-only features, but if you're doing something for a specific server, you can get away with it. Read the docs for DBD::mysql to find the function in question.

296 Name: ASef4h5j6k6l (moved from other thread) : 2008-06-06 09:56 ID:Heaven [Del]

I've been having some trouble installing wakaba...
When I try to open up wakaba.pl in the web browser it comes up with this error:

Forbidden

You don't have permission to access /public_html/wakaba.pl on this server.

I am running wakaba under Apache in Ubuntu 8.04 using Perl 5.8.8 and MySql. Wakaba is currently placed in /var/www/public_html and httpd.conf has been edited to add the lines:

Options +ExecCGI
AddHandler cgi-script .cgi .pl

It's clear that Apache has recognised the scripts as CGI perl files as when I click on them(and it comes up with that error) it also shows:

Apache/2.2.8 (Ubuntu) PHP/5.2.4-2ubuntu5.1 with Suhosin-Patch mod_perl/2.0.3 Perl/v5.8.8 Server at localhost Port 8

What should I do about this problem, would you like more information.

This is my first post, and I have looked beforehand for an existing topic, and if I have repeated something, I apologise.

297 Post deleted by user.

298 Name: !WAHa.06x36 : 2008-06-06 09:58 ID:lpemlo1D [Del]

First off, you should not be using mod_perl, if you are. Second, does the webserver have access to those files? Did you set the permissions correctly?

299 Name: Anonymous : 2008-06-06 09:59 ID:Heaven [Del]

>>296
Check your file permissions and error logs.

> I have looked beforehand for an existing topic

Not enough, evidently ;)

300 Name: ASef4h5j6k6l : 2008-06-06 10:30 ID:fzQTe07X [Del]

ok, I'll uninstall mod_perl (via synaptic), and I have chmodded wakaba.pl and captcha.pl to 755.

but the error message persists.

Forbidden

You don't have permission to access /public_html/wakaba.pl on this server.

Apache/2.2.8 (Ubuntu) PHP/5.2.4-2ubuntu5.1 with Suhosin-Patch Server at localhost Port 80

This thread has been closed. You cannot post in this thread any longer.