AddThis Social Bookmark Button


Installing a Wiki on Your iBook

by Giles Turnbull

The following conversation between Mac DevCenter writer Giles Turnbull and software developer Matt Hunt (a FreeBSD fan who's very happy with the way Mac OS X turned out) walks you through a Wiki installation on Mac OS X. It's really easy to follow, and we hope you'll give it whirl.

Giles: Hi, Matt. I've been researching how to install a Wiki on my iBook. I thought there'd be a bunch of how-to documents online somewhere, but I searched all over the place and came up with not much. Could you help me out?

Matt: Yeah OK. Had you thought about which one you'd like to install? There are literally several to choose from.

Giles: Well, I've used PHPwiki before and I quite liked it. Plus the documentation says that installation is a snap.

Matt: The documentation would say that, but it is worth trying out. The first step is to download the source package. The latest source download is probably the best thing to get.

Giles: OK, I've got that, what's next?

Matt: Unpack it in the Sites directory of your home directory, tar zxf phpwiki-1.3.4.tar.gz, and enter the newly create directory.

Giles: I did that, and went to http://localhost/~myusername/phpwiki/, and Safari just downloaded a file. What went wrong?

Matt: Whoa, there! Nothing's ever quite that simple. You need to make sure that your web server is loading the PHP module and that it will use PHP documents as index pages. You'll need to edit your Apache configuration.

Giles: That's just a text editor job, right?

Matt: Right. Edit /etc/httpd/httpd.conf in your normal command-line text editor (vi, emacs, pico, whatever).

Giles: I tend to use vi.

Matt: Fine, you'll have to edit the file with an administrator account or with the root account; try sudo vi /etc/httpd/httpd.conf and make sure that you uncomment (remove the # symbol from the start of the line) these lines:

LoadModule php4_module        libexec/httpd/

AddModule mod_php4.c

They're not together in the file so you'll have to search for them. Whilst you're in there editing the httpd.conf, find the line that specifies:

DirectoryIndex index.html

and add a few more entries to it. Mine reads:

DirectoryIndex index.html index.php index.htm index.php3 index.cgi

and finally, you'll also need to tell Apache how to identify PHP files; add these lines:

AddType application/x-httpd-php .php 
AddType application/x-httpd-php-source .phps

Add them just after the comment about AddType (# AddType allows you to tweak...) That ought to do the trick.

Giles: Hmm, OK, that wasn't too hard.

Matt: Don't forget to restart Apache when you're done. You can start and stop it from the "Sharing" panel in "System Preferences", but that would also automatically open the firewall to the outside world, which you might not want at the moment. If Apache's running already you can run:

sudo apachectl restart

from the terminal; if not you'll have to run:

sudo apachectl start

Giles: So now I'll go see my shiny new Wiki in my browser at .... oh. It doesn't work. I'm getting an error. It says

Fatal error: Call to undefined function: dba_open() in /Users/gilestur/Sites/phpwiki/lib/DbaDatabase.php on line 32

Related Reading

Learning Unix for Mac OS X
By Dave Taylor, Brian Jepson

Matt: Oh, that's just a fatal error. You need to store the content somewhere. The default is to use DBM files, but I find it's better to use MySQL as a datastore. It's more flexible. Do you have MySQL installed?

Giles: Nope. Tell me it's not complicated.

Matt: It's not complicated. You can download a package for it from the Apple downloads site. MySQL version 4 should do the job admirably, so get that and install it.

Giles: This is more like it. A nice easy package that I can just double-click on ... I've downloaded and installed it, and everything seems to have gone smoothly. It's put itself in /usr/local/mysql, which I suspect is a good place for it.

Matt: Yeah, did it start the database server?

Giles: How would I know that it had?

Matt: You can ask it: /usr/local/mysql/bin/mysqladmin status

Giles: Ah right. I've asked it and it says that various things are happening--one thread, 34 questions, 6 open tables, and so on.

Matt: That sounds just fine, if it hadn't you'd have had to start the server, that is, sudo /usr/local/mysql/bin/safe_mysqld &.

Giles: Figures. So, I've got MySQL working ... now I guess I need to tell it to start a database for the Wiki.

Matt: You're getting the hang of this now. But first you have to set a password for the "root" account on your database server. /usr/local/mysql/bin/mysqladmin -u root password sniggle will do that, but you should choose a different password to "sniggle". As an aside, that MySQL package also contains a directory called MySQL.prefPane. If you drag that into /Library/PreferencePanes you'll get a MySQL entry on your System Preferences, which will let you start and stop the server as well as setting the master (root) password.

Screen shot.
The CompleteMySQL preferences panel.

Once you've done that, you can set up a user in MySQL for your Wiki--do this in your terminal:

/usr/local/mysql/bin/mysql -uroot -p mysql

This starts up the MySQL command line client. Now, do this in the client:

> grant select, insert, update, delete, lock tables on wiki.* to wiki@localhost identified by 'password';
> create database wiki;
> \q

You should probably choose a different password to "password" there as well. Once you've done that, you have an empty database in MySQL just ready for your Wiki content, and a new user with permission to access and change the database.

Giles: Cool. After each of those commands, the MySQL client responded with some simple information about what had happened. Nothing too frightening. What's the next step? Something to do with PHP?

Matt: Not quite yet. There's a little bit more database stuff to do, and then a bit of PHPwiki stuff, and then it should work. First, for the database, in the PHPwiki distribution that you unpacked there's a directory called "schemas". Go there and issue this command: /usr/local/mysql/bin/mysql -uroot -p[password you just set in mysql] wiki < mysql.sql.

That sets up the database structure for the Wiki so that it's ready for the content, make sure you specify the password you set for the root account here.

Giles: Yikes, I'm getting confused about all these passwords. There's the sniggle one, and the password one--which one do I use when?

Matt: OK, the first thing to be clear on is that these accounts are just MySQL accounts, they're not related to the Mac OS X accounts. They have passwords stored in the database server and their permissions relate to what they can do on the database server. We're just concentrating on two accounts here, the "root" account has privileges to alter all parts of all databases that MySQL knows about: it's the "superuser". The "wiki" account that we just created has very limited privileges, it can select, update, delete, and insert data only in the Wiki database. So it can't create the tables, nor delete (in SQL terms, drop) them.

Giles: Aha, so in terms of the examples we've been using so far, the "root" account password was the "sniggle" one, and the "wiki" account password was the "password" one, right?

Matt: Right.

Giles: Now I get it. Things are getting clearer. We must be nearly done now.

Matt: Yes, we're on the last lap. You can connect to the Wiki database as the Wiki user and check that your tables are there if you like:

/usr/local/mysql/bin/mysql -uwiki -ppassword wiki
> show tables;

It should show something like this:

Screen shot.
The CompleteMySQL preferences panel.

Giles: Yes, that's exactly what I get.

Matt: Great, now we just need to get PHPwiki to connect to it and we're away. There's a configuration program provided with PHPwiki--you could try http://localhost/~yourusername/phpwiki/configurator.php, but it didn't work when I tried it.

Giles: Hmm, so there's another way?

Matt: Yes, you can edit the index.php file directly.

Giles: Fine. Which bits do I need to change and where?

Matt: All these changes are to the index.php file in the directory of PHPwiki source that you unpacked. You have to set the admin username and password options, otherwise your Wiki will give you a warning to set them when you view pages. Set them to something convenient to you (sorry, that's yet another password to remember). The lines that you're looking for are:

if (!defined('ADMIN_USER')) define('ADMIN_USER', "");
if (!defined('ADMIN_PASSWD')) define('ADMIN_PASSWD', "");

just add the username and password between the quote marks at the end of the lines. For example,

if (!defined('ADMIN_USER')) define('ADMIN_USER', "wikiadm");
if (!defined('ADMIN_PASSWD')) define('ADMIN_PASSWD', "admpassword");

The other important thing to do is to let the Wiki know where it can find the database. Find these two lines in the file:

    //'dbtype' => 'SQL',
    'dbtype'   => 'dba',

and change them to:

    //'dbtype' => 'dba',
    'dbtype'   => 'SQL',

Finally, find:

//'dsn' => 'mysql://guest@:/var/lib/mysql/mysql.sock/test',

and add this line below it:

'dsn' => 'mysql://wiki:password@localhost/wiki',

Change that to match the details of the user that you created earlier. For example, replace the first "wiki" with the username, "password" with that user's password and the final "wiki" with the name of the database, if you changed it.

And that should be all you need. You can find the line containing define('THEME', 'default'); and change 'default' to 'MacOSX', if you'd like your Wiki to blend in a little.

Giles: Great. So having made all those changes, my Wiki will now work?

Matt: Yes, it should. Try it.

Giles: OK, so all I need to do is start up my browser--I'll use Safari--and send it to http://localhost/~myusername/phpwiki ... and it works! I've got myself a wiki home page (see below).

Screen shot.
A brand new wiki, ready for use.

Matt: Phew! Remind me why you wanted one again?

Giles: After all that, I've forgotten. No, only kidding. I wanted to investigate using a Wiki for all sorts of things. There's a lot of discussion on the original wiki about using the Wiki concept for knowledge management (and more) on a local disk.

Matt: I've used Wiki to support collaboration before, for instance to support discussion on programming projects and share documentation on a company Intranet, but I never really thought to use it as my personal data store.

Giles: There's been talk about the idea of a personal wiki and various contributors have added their own suggested uses: recipe storage, journal writing, even as a private weblogging system. You can put a Wiki to use as a to-do list, and there are calendar plug-ins available for those who see the Wiki as a replacement for their normal PIM software.

Matt: I like that, maybe I'll use one on my desktop at work to replace the battered collection of notepads I have to search through when I need to remember something.

Giles: Yes, I can sympathize with that. One thing I'm interested in doing with my Wiki is using it as a bookmark manager. Although Safari remains my default browser, I still use Camino, Phoenix, and Mozilla quite regularly, and it would be good to be able to reach my bookmarks from within any of them.

Another possibility is keeping a journal, not just a personal diary but a record of everything I write. Because the Wiki is searchable, I can throw pieces of text into it and I don't have to worry too much about categorizing them or sorting them into any kind of hierarchy. As long as I know roughly what the text was about, I'll always be able to find it again.

Of course, it's worth pointing out that there are simpler alternatives to the process we've just outlined. One of the simplest is VoodooPad, a simple-to-install app for Mac OS X 10.2 and later, which operates just like a Wiki, but without the need for setting up any databases or meddling with MySQL and PHP.

Personally speaking, I'm a big fan of the whole Wiki concept. The idea of having a web page that anyone can edit sounds pretty strange when you first encounter it, but Wikis do work well as collaborative environments. The simplicity of their interface--edit, save, that's all there is to it--is what makes me want to use it on my own computer too.

Matt: Yes, you've given me some ideas there too.

Giles: Couldn't have done it without your help. Thanks!

Matt: No problem, well, apart from the problems. You can buy me a beer when I see you next. Cheers.

Giles: It's a deal. Bye.

Giles Turnbull is a freelance writer and editor. He has been writing on and about the Internet since 1997. He has a web site at

Return to the Mac DevCenter.

  • mysql setup error: mysql.sql
    2004-09-13 09:03:56 [View]

    I'm trying to install mysql on panther, and when I get to this point:

    /user/local/mysql/bin/mysql -uroot -p[my password] wiki < mysql.sql

    I get the following error:

    -bash: mysql.sql: No such file or directory

    There is no "mysql.sql" in the schemas directory. What am I doing wrong?
    • mysql setup error: mysql.sql
      2004-09-14 11:58:19 [View]

      The name of mysql.sql has been changes to schema.mysql

      This article is a little out of date. The config info is no longer kept in index.php, for example.
      • Giles Turnbull photo mysql setup error: mysql.sql
        2004-09-14 13:31:51  Giles Turnbull | O'Reilly AuthorO'Reilly Blogger [View]

        You're absolutely right; this article is now showing its age. There are now many other, often easier ways to get all wiki-ed up on your Mac.

        Personally, I think VoodooPad is an excellent choice for most people. If you don't want to pay the shareware fee, PersonalWiki is another option.

        The latest version of Instiki apparently comes with everything you need for a working, double-click-and-run setup.

        There's lots of other options to try.
  • Installing phpwiki v1.3.10?
    2004-09-08 10:05:19  jhchou [View]

    I was able to successfully install phpwiki v1.3.4 on a Powerbook 1.5 GHz running Mac OS X v10.3.5, as described in the great tutorial above, with just minor bumps. I wanted to upgrade to 1.3.10, as authentication support doesn't seem to work in 1.3.4.

    However, I have been having problems installing phpwiki v1.3.10. It comes with a shortened index.php file, so I generated a more complete one with configurator.php. After trying to edit it by comparing it with the v1.3.4 index.php, I still have problems.

    When trying to access the phpwiki, I get a fatal error from line 29 of WikiGroup.php regarding calling an undefined function.

    Anyone successfully install phpwiki v1.3.10?
    • Installing phpwiki v1.3.10?
      2004-09-14 11:56:39 [View]

      The name of mysql.sql has been changes to schema.mysql

      This article is a little out of date. The config info is no longer kept in index.php, for example.
  • local links are not relative
    2004-03-08 06:30:18  alananonymous [View]

    Thanks for the good instructions. First problem I have is that internal links are using absolute URLs (e.g.: "http://myMac.local/~myUserName/phpwiki-1.3.7/index.php/PhpWikiDocumentation" when it should really just be "PHPWikiDocumentation"). Of course, "myMac.local" doesn't show up in any DNS entries, so links break when browsing the wiki from another computer.
    Sadly, I'm a bit too tech-illiterate to interpret the config files' in-line documentation.
    • local links are not relative
      2004-08-03 14:48:04  rikahlberg [View]

      You can fix this.

      Open httpd.conf with a text editor and locate the ServerName entry. Put your IP address or fully qualified domain name in as servername:


      Restart apache and you should be all set.
  • mysql not working with Panther???
    2003-11-19 15:03:13  anonymous2 [View]

    Hello. I tried your tutorial and everything went well except that after installing Completemysql (v.4.0.15) I create the root and some users but when I tried to upload some info from out file using ...load data local inflie... I always get the same error 1148 blah blah. I tried to solve this by following the instructions on the mysql manual and trying some other ideas I found in the web mainly about adding --local-infile... when starting mysql but none of the solutions seems to work. Anyone had the same problem???? So advice on how to solve it?? Maybe a step by step solution tutorial???. Thanks a lot. Very good article
  • phpwiki is rocking - we added full DocBook pdf's
    2003-10-27 16:59:41  mickazoid [View]

    see for more info.

    We also have multilingual, shared db's, multiple wikis for different groups, etc. PhpWiki is great stuff.

    Wish it worked with VoodooPad (which I love), but alas...!
  • Any Ideas: follow up
    2003-08-27 20:47:37  anonymous2 [View]

    Figured it out, I took the formatting example for the -p[password] example too literally, there should not have been brackets. Amazing how much time I spend messing around by missing the details.

    Now, In Safari, I'm up against:

    Could not open the page “http://mycomputer-computer.local/phpwiki/index.php/HomePage?action=edit” because Safari could not load any data for this location.

    All the other buttons across the bottom work...oh well, back to it.
  • Any ideas
    2003-08-27 19:56:59  anonymous2 [View]

    When I run show tables, I get:

    mysql> show tables;
    Empty set (0.00 sec)

    When I go to my index.php page, I get:

    ib/WikiDB/backend/PearDB.php:681: Fatal[256]: wikidb_backend_mysql: fatal database error

    DB Error: no such table

    (LOCK TABLES page WRITE,version WRITE,link WRITE,recent WRITE,nonempty WRITE [nativecode=1146 ** Table '' doesn't exist])

    It seems that I haven't created the tables correctly, but I seem to be getting all the correct responses up to this point. Any ideas would be appreciated.
  • The Simplest Wiki You Can Set Up...
    2003-08-13 14:19:26  anonymous2 [View] the QuickiWiki from Leuf and Cunningham's book. You can make it work by dumping all the files (yes, including the template.html and logo.gif) into /Library/WebServer/CGI-Executables. But that solution is *inelegant*. Better to set it up in your own account, in your Sites folder (or that of a dedicated alternate identity).

    1. Copy the necessary files into the folder of your choice. I opted to drag the whole BaseQuicki folder into ~/Sites (after treating the .cgi files with PerlConvertEolScript to change the line termination).

    2. Get into folder /private/etc/httpd/users and sudo-edit <username>.conf. Where you see a line beginning AllowOverride, replace the stuff after it with "All" (or whatever you feel comfortable allowing if you know Apache configuration settings). Save that one line change.

    That enables:

    3. Create a file in your wiki folder named .htaccess which contains the following:

    Options ExecCGI
    <Files "*.cgi">
    SetHandler cgi-script

    This will tell Apache to (a) enable CGI access in that particular folder, and (b) treat files with the .cgi extension as executables, the *output* of which should be sent to the browser.

    If there are any problems with that setup, I'd like to hear them. I'm just trying to use Apache and the Unix underpinnings of Mac OS X to fullest effect. Oh yes, and experimenting with my wiki.
  • Definitely the wrong choice
    2003-07-01 05:27:44  anonymous2 [View]

    PhpWiki has plenty of neat features, but if you're trying to get started, thinking that you need MySQL as a back end is ridiculous.

    There are even versions that don't need Apache or any other web server.

    --Bill Seitz , ,
  • MYSQL Problem
    2003-06-22 09:56:23  rberg [View]


    I installed MySQL in /usr/local/mysql using the pkg you recommended.

    However, running:

    /usr/local/mysql/bin/mysqladmin status

    results in:

    /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
    error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'

    at /tmp/ I see three files, none of which are named mysql.sock

    so (1) what does this error message really mean?
    (2) what went wrong?
    (3) how do I fix it?


    • MYSQL Problem
      2003-12-30 11:30:46  anonymous2 [View]

      It seems that MySQL daemon isn't running
  • 3rd time's the charm
    2003-06-20 17:50:59  dparmet1 [View]

    I deleted everything and did it one more time and now.. it works.

    I get this line at the bottom under PHP warnings though..

    lib/config.php:276: Notice[8]: Undefined variable: SCRIPT_NAME

    Can't be too bad, it works.

    david parmet
  • Or....
    2003-06-20 03:31:36  anonymous2 [View]

    $ cd Sites
    $ sudo perl -MCPAN -e 'install CGI::Kwiki'
    $ /usr/local/bin/kwiki-install
    $ /usr/local/bin/kwiki-install --privacy (optional)

    Open http://localhost/~your_user_name

    Took me all of 15 seconds.
  • still trying
    2003-06-19 04:37:52  dparmet1 [View]

    gotta give me credit for that...

    anyway... I deleted everything and started from scratch. And now when I open phpwiki/index.php I get this messge...

    Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting ')' in /Library/Apache2/htdocs/phpwiki/index.php on line 190

    There's nothing on line 190 that would indicate I'm missing a ')"....

    any thoughts? thanks

    david parmet
  • got all the way through and made the changes to the index.php
    2003-06-18 19:33:49  anonymous2 [View]

    and I'm still getting this message when I go to localhost/phpwiki/index.php

    Fatal error: Call to undefined function: dba_open() in /Library/Apache2/htdocs/phpwiki/lib/DbaDatabase.php on line 32

    I know the database is there, I've checked in MySQL and I get exactly what you show in the article. But I'm still getting that message.

    Any thoughts? I'm using Apache2, PHP4 and MySQL4


    david parmet
    • got all the way through and made the changes to the index.php
      2003-07-24 15:05:05  anonymous2 [View]

      i had the same problem here, just go in index.php and change the dbtype to SQL
    • It just got even more interesting
      2003-06-18 19:43:58  dparmet1 [View]

      I just tried opening index.php via Safari once again and this time I got..

      lib/WikiDB/backend/PearDB.php:32: Fatal[256]: Can't connect to database: wikidb_backend_mysql: fatal database error

      DB Error: connect failed

      ( [nativecode=Access denied for user: 'wiki@localhost' (Using password: YES)] ** mysql://wiki:XXXXXXXX@localhost/wiki)

      lib/config.php:276: Notice[8]: Undefined variable: SCRIPT_NAME

      Is this a MySQL problem?


      david parmet
      • It just got even more interesting
        2004-01-17 15:14:10  anonymous2 [View]

        I was getting this error too:

        ( [nativecode=Access denied for user: 'wiki@localhost' (Using password: YES)] ** mysql://wiki:XXXXXXXX@localhost/wiki)

        It's just that we missed something. Like in the tutorial, make sure the following line is uncommented, and make sure the username and password can access the database (the DB name in this case is 'phpwiki')

        'dsn' => 'mysql://username:password@localhost/phpwiki'

        I hope this helps someone, as I was scratching my head for much too long on this simple mistake ;)
      • It just got even more interesting
        2003-06-19 04:38:02  dparmet1 [View]

        gotta give me credit for that...

        anyway... I deleted everything and started from scratch. And now when I open phpwiki/index.php I get this messge...

        Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting ')' in /Library/Apache2/htdocs/phpwiki/index.php on line 190

        There's nothing on line 190 that would indicate I'm missing a ')"....

        any thoughts? thanks

        david parmet
  • Wiki: php warnings
    2003-06-17 00:09:09  adam_alexander [View]

    Awesome article, thanks for the learning experience!

    I have everything up and running, but in the footer of my Wiki there is a php warnings box with these alerts:

    PHP Warnings
    lib/config.php:145: Notice[8]: Object to string conversion
    lib/config.php:145: Notice[1024]: Object

    They do not seem to be serious errors affecting the wiki - how can i fix these up?

    I am running OS X 10.2.6 and have followed all steps above. TIA for any advice.
    • Wiki: php warnings
      2003-06-17 13:15:03  matt_hunt [View]

      The messages you're seeing are caused by PHPwiki's locale handling. I suspect it's down to the fact that this is, strictly speaking, a development release- it's pretty good all the same.

      I assume that you're running with a locale set so you could fix up the messages by starting Apache in the C locale, e.g. if you log in as the root user using the bash shell, you can use the command:

      LC_ALL=C apachectl start

      to start Apache. This will set the default locale in Apache's environment. That should get rid of the messages, but it's a bit of a bind. You can also get rid of them by commenting out line 145 of lib/config.php in the installed PHPwiki directory. i.e. change this:

      if (!$newlocale) {
      trigger_error(fmt("Can't set locale: '%s'", $loc), E_USER_NOTICE);
      $loc = setlocale(LC_ALL, ''); // pull locale from environment.

      to this:

      if (!$newlocale) {
      // trigger_error(fmt("Can't set locale: '%s'", $loc), E_USER_NOTICE);
      $loc = setlocale(LC_ALL, ''); // pull locale from environment.
  • No graphics on external network
    2003-06-13 12:59:50  anonymous2 [View]

    The install when without a hitch except for one small thing. In my internal network, everything looks great, but when I access the server from the internet, none of the graphics come through (little red x). Any clues as to why this would happen?
    • No graphics on external network
      2003-06-28 19:18:53  anonymous2 [View]

      I think something similar is happening to me. If I try to access from another machine to my ip (say all the page link still show something like (localhost/phpwiki/index.php) and they can't be found. How do I get phpwiki to rebuild these? I think the graphics problem is probably the same!

      • re: No graphics on external network
        2003-07-05 19:55:41  anonymous2 [View]

        This probably has to do with hostname settings. I haven't set up wiki yet but I've seen this often with other web apps (like gallery, Somewhere in a wiki configuration file is a place to specify the hostname that is probably used as part of absolute URLs--the page will say 'img src="http://whatever.hostname/phpwiki/logo.gif"' or something like that. You can set it up so it works as localhost, for example, but when you access it via an IP address or domain name from another box, it'll fail--for example, if you tell it the host name is, other boxes will not see that. Or if you tell it, then when you access it over your LAN at, it'll also fail. Hint: load the page up on a machine where the graphics fail, then view the source of that page. I bet you'll see images referenced by absolute URLs.
  • Desktop Wiki
    2003-06-11 15:13:39  anonymous2 [View]

    A little bit of advertising, i am working on a simple desktop application that enables you to do similar things you do with wikis. It is called PersonalWiki another app that does something similar is VoodooPad

    Harald Scheirich hscheirich )AT(
  • installation
    2003-06-08 14:49:29  anonymous2 [View]

    I followed your very helpful installation guide for phpwiki and everything works except that I get Php warnings:

    lib/config.php:145: Notice[8]: Object to string conversion

    lib/config.php:145: Notice[1024]: Object

    when I go to http://daaa.local/~giusseppe/phpwiki/

    these are in a box at the bottom of the Home Page and if I try to edit a page I get the message that :

    Could not open the page ?http://daaa.local/~giusseppe/phpwiki/index.php/HomePage?action=edit? because Safari could not load any data for this location.

    Can you please tell me what I have got to do ?


    • installation
      2003-06-17 13:23:16  matt_hunt [View]

      I don't think that the two problems - the error messages and the page loading failure - are necessarily connected. You can get rid of the messages in the way I have detailed in another response to this article, but I doubt if this will help with the other problem. You need to find out why Safari is failing to load, it might be a temporary failure, so if you try to reload or try with another browser it might work. If not, I'm afraid that your best bet is to take a look in Apache's error log to see if there are any clues in there as to what went wrong.

      Good luck.
      • installation
        2003-06-25 09:43:47  keith_veleba [View]


        The page has no data error happens on my TiBook with Safari, Camino, Mozilla, and IE. At first I thought it might be a permissions problem, but I was wrong; everything seemed to be in order.

        I did not have any of the PHP problems like the person at the start of this thread, but I do have the page contains no data error. Apache's error log has not recorded anything that could be the issue.

        Keith Veleba
  • So Wiki is . . . ?
    2003-06-08 02:11:25  anonymous2 [View]

    Great linux-like article that in no way informs the user what Wiki is. I suppose that anyone daring to follow the described installation procedure will a) know what Wiki is all about and b) will thus have it installed - or gave up trying. I found it absolutely horrible that this installation procedure doesn't even come documented. This article should be on a linux site. Maybe not, I am missing the key phrases "this is better" " this is much faster" " you should always use this" etc.
    I love this site, but when I read this article I really thought "What is this?" - you can figure out the emphasize.
    • So Wiki is . . . ?
      2004-03-12 12:10:01  sans [View]

      I disagree...this article hits the nail on the head for me. I switched to development on the mac because of it's ability to easily run apache, mysql, and php in a unix-like environment. I'd like more like this...just enough detail to get moving and figure it out. Thanks for the article!
    • So Wiki is . . . ?
      2003-06-10 08:08:16  salamon [View]

      While it is true that a brief description of the whole WIki concept would have been a good idea, a search for 'wiki' on Google brought up 'about 2,500,000' results. A bit intimidating, but the very first link on the very first page had a brief blurb about what a Wiki is, along with links to more detailed descriptions.
      So as not to stress anyone out, here is my one line definition of a Wiki:
      A web editable, dynamic web site, with a unique syntax for entering simple markup, providing a tool for community or knowledge building.
      • So Wiki is . . . ?
        2003-06-17 13:28:32  matt_hunt [View]

        It really didn't occur to me that there were people that didn't know what a Wiki was. I've been a bit too close to the web industry to miss it. Recently, however, in talking to friends working even in other parts of the computing industry I have found that it's not as widely known as I had imagined.

        This being the case, might I recommend the original WikiWikiWeb as a good place to start learning about Wiki:
  • grant lock?
    2003-06-07 14:15:54  anonymous2 [View]

    This line...
    > grant select, insert, update, delete, lock tables on wiki.* to wiki@localhost identified by 'password';

    results in an error:

    You have an error in your SQL syntax near 'lock tables on wiki.* to wiki@localhost identified by 'password'' at line 1

    I already had MySQL installed from a long time back, and I checked the manual, there is no LOCK priv_type. I left out that part of the line and everyting else seemed to go fine.
    I don't know if it's connected but I cannot edit any pages. Whenever I click on an edit link I get an error on my browser saying the document contained no data or it just hangs with no results at all.
    I should also mention I'm not using the Apple installed version of PHP but the package from Are any of these things affecting my wiki installation?
    • grant lock?
      2003-06-08 12:36:26  matt_hunt [View]

      We used MySQL 4 for the article but it looks like you're probably using MySQL 3. If you leave out the "lock tables" part of the grant line everything should be just fine.

      Greater locking control is one of the improvements (depending on how you look at it) of the latest MySQL version. In general it is a great improvement but it can cause problems when you move from one version to the other without reading the upgrade documents (that was my experience, at least).

      • grant lock?
        2003-06-08 15:13:07  anonymous2 [View]

        Thanks for the reassurance that what I did was okay.
        Now, about the editing issues...
        I checked over at sourceforge and it seems phpwiki DOES NOT WORK with php 4.3.0 on Mac OSX. So it's my non-apple PHP installation causing the problems (which I need for GD stuff).
        The workaround suggested is way beyond my capabilities as a moderate php programmer so I guess I'll have to wait to get my wiki up and running.
  • wiki and mysql
    2003-06-06 23:02:53  anonymous2 [View]

    installing phpwiki and mysql the first time on my PB was not so wiki, but the second time on my imac server was very easy (took about 15 minutes, including breaks)...i also changed some of the pictures in the hawaiian theme to some of my own hawaii pictures...and now some of my friends actually think i built the whole page!! thanks for the i just have to figure out what to use the damn thing for...
  • Wiki on Your iBook
    2003-06-06 19:17:29  ddp [View]

    Nice job gentlemen. I have an iBook, never used MySQL until I read this article. It took me a couple of read throughs and I'm now up and running. Thanks.
  • Snipsnap
    2003-06-06 11:08:09  anonymous2 [View]

    Snipsnap ( is even easier to install (runs in java, no mysql or php) and more powerful- it combines a wiki with a blog, so you get the advantages of both.
  • Bookmarks
    2003-06-06 08:05:32  salamon [View]

    > One thing I'm interested in doing with my Wiki is using it as a
    > bookmark manager. Although Safari remains my default browser, I
    > still use Camino, Phoenix, and Mozilla quite regularly, and it would
    > be good to be able to reach my bookmarks from within any of them.

    If you just want to store bookmarks and have them accessible in any browser check out my software at It shouldn't be any more complicated to install than PHPWiki was, but my directions aren't as explicit as those you got.

    • Bookmarks
      2003-08-14 22:15:07  anonymous2 [View]

      I only use one browser regularly, but Launchbar keeps track of bookmarks... You can't exactly browse your bookmarks, but you can certainly use it to launch bookmarks... Even if this doesn't work for your bookmarks everyone with an apple notebook should use this app. great for desktops too...
  • JSPWiki a snap to install in iBook
    2003-06-06 05:24:28  szpak [View]

    A few days ago I installed JSPWiki ( on my iBook - really just a matter of dropping the WAR file into Tomcat's webapps directory, telling it where the wiki fiiles will live (it uses the file system rather than a database), and restarting Tomcat: bingo, in business. As the name implies, this uses JSP and Java; it's also open source, and actively supported.
  • Not all Wikis are this horrid to install!
    2003-06-06 03:12:20  anonymous2 [View]

    Have a look at ProjectForum...

    Download the disk image, copy the application to your Applications folder, double click it and you're done.
    • Not all Wikis are this horrid to install!
      2003-06-12 14:15:44  anonymous2 [View]

      Seconded... PF is excellent. And ah-bsolutely trivial to set up.
  • CGI::Kwiki
    2003-06-05 17:09:40  anonymous2 [View]

    For maybe the simplest Wiki install readers might like to try Brian Ingerson's CGI::Kwiki, which was described in a recent article on

    Lots of fun in that module, and installation is utterly trivial.
    • CGI::Kwiki
      2003-06-06 07:43:23  Dunx [View]

      Yes, very easy. And it can be made to work on Windows too, if you override the CGI::Kwiki::Search module to specify a grep executable with an explicit path. I've also customised it with some noddy simulpost protection (that is, to alert you if someone else has changed the page you're editing while you've been editing it) for collaborative purposes.
      • CGI::Kwiki
        2003-06-07 19:09:45  anonymous2 [View]

        Even if the simulpost protection patch doesn't get accepted, I am sure many (like me) would like to see it at