getting mysql to work with wakaba (11)

1 Name: Aiwa-Nei 2004-11-26 05:53 ID:Heaven [Del]

how do I get wakaba to use mySQL instead of SQLite? Is it even possible yet? as far as I can see... at this point you can't? am I missing something? please let me know ^^;

2 Name: Albright!LC/IWhc3yc 2004-11-26 09:35 ID:7VsfeokA [Del]

Are you sure you downloaded Wakaba and not Wakaba Zero?

3 Name: Aiwa-Nei 2004-11-26 15:20 ID:Heaven [Del]

yes I am 100% sure, what I'm not sure of is how to edit the config.pl because it is setup for SQLite, I tried changing the DBI:SQLite to DBI:mysql...since that is the DBI command for mysql ^^;; but it didn't seem to work.

4 Name: Albright!LC/IWhc3yc 2004-11-26 22:46 ID:YWk3l6UQ [Del]

Are you sure you're not looking at the line that's prefixed by ## ?

The line should look something like this:

use constant SQL_DBI_SOURCE => 'DBI:mysql:database=dbname;host=localhost';

5 Name: !WAHa.06x36 2004-11-26 22:56 ID:e9Y9yFQw [Del]

Er, there's example lines in there for both mysql and SQLite. There are just three SQL_* config options, and I've put in examples for both databases.

6 Name: !WAHa.06x36 2004-11-27 03:19 ID:0Gu6c9rA [Del]

Gaah, the wrong config.pl got included with this release. I'll fix it and upload a new version.

7 Name: !WAHa.06x36 2004-11-27 03:31 ID:0Gu6c9rA [Del]

http://wakaba.c3.cx/releases/wakaba_20041127.zip

Fixed the messed up config file, and a big bug with the thumbnailer.

8 Name: genao!!/k5wjhF8 2004-11-27 05:13 ID:jnOhLM2Q [Del]

I'm testing wakaba on a local server (JWin98SE2, Apache 2.0.52, ActivePerl 5.8.4 Build 810, SQLite 3.0.8), and while I was about to post that I couldn't get thumbnailing to work in wakaba_20041123, with the new wakaba_20041127 release I'm getting a full on software error;

Software error:

Undefined subroutine &main::make_error called at config_defaults.pl line 18.
BEGIN failed--compilation aborted at config_defaults.pl line 102.
Compilation failed in require at x:/x/wakaba/wakaba.pl line 17.
BEGIN failed--compilation aborted at x:/x/wakaba/wakaba.pl line 17.

For help, please send mail to the webmaster (local@host), giving this error message and the time and date of the error.

I've only configured ADMIN_PASS, NUKE_PASS, SECRET, and SQL_DBI_SOURCE (though SQL_TABLE and SQL_ADMIN_TABLE don't make a difference, either). Did I miss something in there?

9 Name: !WAHa.06x36 2004-11-28 00:13 ID:hcX7lmwA [Del]

Ah. What is happening is that Wakaba is trying to report a more useful error message and failing. That will be fixed in a future version, but the problem is essentially that it wants you to configure the SQL_USERNAME and SQL_PASSWORD options too. However, since you're using SQLite you should just set oth of those to '', so having the script complain about is a bit stupid. I'll probably change that in a future version too...

10 Name: Aiwa-Nei 2004-11-28 05:06 ID:Heaven [Del]

ok just glad to know I wasn't crazy... and missing the whole thing ^^;; thanks for creating such a great script, you are an asset to programming ^_^

11 Name: Albright!LC/IWhc3yc 2004-11-28 12:23 ID:crrZlx1A [Del]

>What is happening is that Wakaba is trying to report a more useful error message and failing.

i lol'd

Name: Link:
Leave these fields empty (spam trap):
More options...
Verification: