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 ^^;
Are you sure you downloaded Wakaba and not Wakaba Zero?
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.
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';
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.
Gaah, the wrong config.pl got included with this release. I'll fix it and upload a new version.
http://wakaba.c3.cx/releases/wakaba_20041127.zip
Fixed the messed up config file, and a big bug with the thumbnailer.
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?
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...
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 ^_^
>What is happening is that Wakaba is trying to report a more useful error message and failing.
i lol'd