Notes on getting Kiwi up and running

These are my rough notes on getting the Kiwi source up and running.

Prerequisites

I'm using ACL 8.0 (Enterprise) on an OS X system. I'm not sure whether the free version of ACL will work. (See Carl Shapiro's message to CL-Gardeners on this topic.)

I'm using mysql 5.0.

Grab a version of the source with my patches

I'm patching the source to work in my environment, which mostly means standalone web server, mysql database named "kwidev", no captchas, etc. The patches are not yet stable.

It might be best to ask Carl Shapiro if you're interested in the source.

Create and setup the Kiwi database.

I hadn't used mysql until yesterday, so I'm sure someone who knows what they're doing could improve this part.

1. Create the Kiwi database

Start the mysql shell and create the kiwidev DB:

  dhcp106:~/src/kiwi/tables wiseman$ mysql --user=root --password=mypassword

  Welcome to the MySQL monitor.  Commands end with ; or \g.
  Your MySQL connection id is 110 to server version: 4.1.10

  Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

  mysql> CREATE DATABASE kiwidev;
  Query OK, 1 row affected (0.03 sec)

2. Setup schema

In Kiwi's tables directory you should find a number of *.sql files containing the commands to create the Kiwi schema.

You might think something like this would work:

  for i in *.sql
  do
    echo $i
    mysql --user=root --password=mypassword kiwidev < $i
  done

But when I try it, I get a lot of errors and end up missing a lot of tables. So, instead, I manually source all the *.sql files in the tables directory.

  mysql> use kiwidev;
  Reading table information for completion of table and column names
  You can turn off this feature to get a quicker startup with -A

  Database changed
  mysql> source blowfish-key.sql
  Query OK, 0 rows affected (0.07 sec)

  mysql> source captcha.sql
  ERROR 1051 (42S02): Unknown table 'captcha'
  Query OK, 0 rows affected (0.07 sec)

  Query OK, 0 rows affected (0.13 sec)
  Records: 0  Duplicates: 0  Warnings: 0

  mysql> ...

And so on.

3. Add kiwi user

Following the instructions in the myqsl manual, we'll add a user named "kiwi", with password "kiwi":

  mysql> GRANT ALL PRIVILEGES ON *.* TO 'kiwi'@'localhost'
      ->     IDENTIFIED BY 'kiwi' WITH GRANT OPTION;
  Query OK, 0 rows affected (0.06 sec)

4. Add a blowfish key

I don't know yet what Kiwi uses this for [encrypts cookie values, at least -alanr], but it won't run without it. For now I just fake it out:

  mysql> insert into blowfish_key (bf_id, bf_key) values (1, '0');
  Query OK, 1 row affected (0.67 sec)

Start Kiwi

Load kiwi's startup.lisp, which should start a Kiwi HTTP listener at http://localhost:8080/.

You're done! For now...

This should be enough to get a basic Kiwi running, one which will let you view, create and edit pages.

---

This page is presently Uncategorized: please add appropriate category markers? and remove this text.