Help - Search - Members - Calendar
Full Version: Experiences running wiki on Zaurii
OESF Forums > General Forums > General Support and Discussion > Software
LadyBug
We have been experimenting with different SW combinations for getting
a personal Wiki running on our family Zaurii (my C760, my husband's SL-5500). My need was also to find a Wiki that I could run both in my
Zaurus and also on a group server and the just sync the data with
unison.

Here are the various server/wiki combinations we tried:

- thttpd & AwkiAwki: small, fast.
Beware of thttpd with a broken POST.
- boa & AwkiAwki: needs tweaks to work
Boa runs CGIs from the boa config directory etc.
- thttpd and QuickiWiki: works, fast
Needs perl. My husband liked this.
- Apache+PHP and PhpWiki: works OK
From the performance point of view,
PhpWiki 1.2.2 is much faster than 1.3.7.
The latter version has much more functionality,
though. BTW, 1.2.2 requires
"php_flag register_globals on" in httpd.conf.
- Apache+PHP and MoinMoin: works, slow.
MoinMoin uses Python and loads of
python modules, so you have to install
half a dozen or so python packages to
get all the necessary stuff.
- boa and MoinMoin: Works, still slow.
Front page takes about 7 seconds.
The problem is the python execution,
not the web server speed/size.
- perl + Zwiki: works, fast.
Zaurus Wiki, not Zwiki as in Zope
Wiki. Only text content, no pictures.

Other options that we did not try:
- Zope
- http://digit.que.ne.jp/visit/file/WalWiki2...wal.4.3_arm.ipk

Summary:

If you want just a small fast personal wiki easily and don't care
about pictures or major functionality, do the Zwiki.

If you want real functionality or to run the same SW in Zaurus
and in a real server somewhere, I'd suggest PhpWiki. On my
760 the first phpWiki Home Page execution takes about 3.5
seconds measured from the phpWiki debug mode display. It gets
down to 2.5secs afterwards. I'm running phpWiki 1.3.7.

QuickiWiki is a good compromise between those two approaches.
In a 5500 home page load times are about 4 seconds when
outswapped, and it gets to 1-2 seconds afterwards.

Any other experiences?
totaln00b
Hi Ladybug,

I found your discussion of the various wikis really interesting. I have decided to try phpwiki out, and seem to be having a few problems getting it working correctly, so I wonder if you could clear a few things up for me.

Version 1.2.x requires register_globals to be ON, but in my version of apache and php (the one packaged for zaurii in the software index) I don't have a php.ini file to set this in. Did you use .htaccess files, or add it to httpd.conf? Neither of these approaches seem to have made any difference to me ( I can get the index page that creates all the additional pages, but clicking on the links sends me straight back to the index page again).

I couldn't get anywhere with Version 1.3.9 (the earliest version that I could find).

If you have any suggestions, or instructions aimed at complete beginners I'd be very grateful.

Thanks

Jo
totaln00b
(Blush)
Answered my own question in the end by reading ladybug's post properly!
Phpwiki 1.2.4 seems to work very well though I'm only learning...

Jo
kopsis
Note that you can speed up MoinMoin dramatically by using it's built in Python based HTTP server instead of Apache or Boa. Python itself is pretty speedy on the Zaurus, it's just the initial loading of all the various modules when a Python process starts that takes forever.

To do this you need to copy moin_config.py from your moin data dir (usually /usr/share/moin) into $PYTHON_DIR/site-packages/MoinMoin. Edit moin_config.py to make sure all the paths are set up correctly. Then just kick off $PYTHON_DIR/site-packages/MoinMoin/httpdmain.py as a background process.

The MoinMoin Python CGI scripts will execute in the context of the server which conveniently keeps all of the various Python modules cached up. Using that technique MoinMoin page loads (after the very first) usually happen in under 3 seconds.

--
Dave Kessler
JohnKiniston
I'd suggest trying MiniRubyWiki

I used it on my Zaurus before my SD card started to go bad, It was quick and seemed to have a lot of features, has its own webserver built in.

You need to install Ruby on the Zaurus to use it.
iamasmith
Wow, this is so useful!

I set up phpWiki 1.2.4 on a couple of systems and unison to sync, it's a really useful thing to be able to sync a knowlege base like this and Apache-PHP +phpWiki is PDQ on my SL-C860 w'Cacko.

Has anyone noticed though that the Z version of unison screws up the date/timestamp - I think this may be a byte ordering issue and I will take a look when I get the time.

Thanks for the pointers and all the legwork LadyBug.
iamasmith
BTW: if anyone did want to get hold of phpWiki 1.3.7 you can get it from...

http://prdownloads.sourceforge.net/phpwiki....7.tgz?download

It has dropped from the SF index but it's still on the mirrors.
fpp
Although not technically a Wiki, ELOG is a very versatile tool that can be useful on a Z (esp. if synchronization with another instance on a server is required). It is its own http server, requires no database engine, and consists of only one C source file, which makes it easy to compile, install and run, and quite lightweight in terms of system resources.

For the curious, the ELOG homepage is here : http://midas.psi.ch/elog/

and a ready-made binary of the server (elogd) for the Zaurus can be found on this page : http://fredp.lautre.net/Z/
ShiroiKuma
Hi:

I've searched all over the web, but can't find it.

Where can I get phpwiki 1.3.7 for the zaurus?
w14
There is no specific version for the Zaurus. Install apache+php and mysql, both available via www.killefiz.de/zaurus, download phpwiki from the phpwiki site and follow the installation instructions.

Mike.
ShiroiKuma
QUOTE(JohnKiniston @ Jul 23 2004, 07:41 PM)
I'd suggest trying MiniRubyWiki

I used it on my Zaurus before my SD card started to go bad, It was quick and seemed to have a lot of features, has its own webserver built in.

You need to install Ruby on the Zaurus to use it.

Where can you download MiniRubyWiki for the Z?

I found this page but the link to How To Set It Up is dead.

Any pointers?
ShiroiKuma
QUOTE(w14 @ Oct 29 2004, 12:03 PM)
There is no specific version for the Zaurus. Install apache+php and mysql, both available via www.killefiz.de/zaurus, download phpwiki from the phpwiki site and follow the installation instructions.

Mike.

OK, I installed apache with php and mysql.

Downloaded the phpwiki, untarred it to a directory on a CF card.

And what do I do now?

I've never done this.

How do I go about creating and editing pages in wiki now? What do I open?

This might seem elemental/ but I've never worked with wiki/ wanna learn.

Thanks.
zenyatta
In general, you need to:

1. look for a file named 'httpd.conf' where you
2. indicate where your phpwiki code is located and other parameters; then you
3. look for a file named 'apachectl', run 'apachectl start' and
4. try connecting to http://localhost/ with some browser.

All of this must be elaborated in the phpwiki documentation, I'm sure. Just check their website.

z.
ShiroiKuma
QUOTE(zenyatta @ Oct 30 2004, 11:16 AM)
1. look for a file named 'httpd.conf' where you
2. indicate where your phpwiki code is located and other parameters; then you
3. look for a file named 'apachectl', run 'apachectl start' and
4. try connecting to http://localhost/ with some browser.

Hi:

I did all the above steps. but I must've gone wrong somehow in step two, since I can check that mysql is running, and it is, but when I open http://localhost/ in the browser I only get the standard apache page, saying: Index of /
and it's empty, i.e. no sql error, nothing.

I changed:
DocumentRoot "/home/www/htdocs"
to:
DocumentRoot "/mnt/cf/phpwiki-1.3.7"

and further down:
<Directory "/home/www/htdocs">
to:
<Directory "/mnt/cf/phpwiki-1.3.7">

but this is probably not it.

Where am I going wrong?
ShiroiKuma
OK, I think the problem is with Apache, or something that I've done.

When I isntalled Apache and tried to run, I got
CODE
/home/www/bin/apachectl: /usr/local/apache/src/httpd: not found /home/www/bin/apachectl start: httpd could not be started
So I created the /usr/local/apache/src/ directory and in tlaced a symlink to /home/www/bin/httpd

Now httpd start gives
CODE
/home/www/bin/apachectl start: httpd started
however if I run httpd restart right away after this, I get:
CODE
/home/www/bin/apachectl restart: httpd not running, trying to start
/home/www/bin/apachectl restart: httpd started
So obviously, it's not running.

What's the problem?
ShiroiKuma
OK, figured this out.

Actually, after installing Apache on the Z the following symlinking should be done:

make a synlink in /usr/local called apache to /home/www and make a symlink in /home/www called src to bin.

Don't link like I say in the above post.

Now it seems to work/ since when I open localhost I get an sql error.

So on to the next steps in configuring wiki... rolleyes.gif
ShiroiKuma
Well, now I think I need help with mysql.

I've been proceding according to this guide. I realize it's for Macs/ but found nothing else on setting up phpWiki.

Anyhow I'm at the point where I'm creating a new database in mysql. I input:
CODE
grant select, insert, update, delete, lock tables on wiki.* to wiki@localhost identified by 'password';
but get
CODE
ERROR 1064: You have an error in your SQL syntax near 'lock tables on wiki.* to wiki@localhost identified by 'password'' at line 1
so tried to overcome it with
CODE
grant usage on *.* to 'wiki'@'localhost' identified by 'password';
to which it responds
CODE
ERROR 1036: Table 'user' is read only
What's the problem?
ShiroiKuma
Well, now I think I need help with mysql.

I've been proceding according to this guide. I realize it's for Macs/ but found nothing else on setting up phpWiki.

Anyhow I'm at the point where I'm creating a new database in mysql. I input:
CODE
grant select, insert, update, delete, lock tables on wiki.* to wiki@localhost identified by 'password';
but get
CODE
ERROR 1064: You have an error in your SQL syntax near 'lock tables on wiki.* to wiki@localhost identified by 'password'' at line 1
so tried to overcome it with
CODE
grant usage on *.* to 'wiki'@'localhost' identified by 'password';
to which it responds
CODE
ERROR 1036: Table 'user' is read only

What's the problem?

Basically I don't know how to create a database in mysql ready for wiki use now. Since the above mentioned site also as the next step then mentions you should do:
CODE
/usr/local/mysql/bin/mysql -uroot -p[password you just set in mysql] wiki < mysql.sql
which however is not possible because there is no mysql.sql file anywhere on the Zaurus.

So what should I do now?
zenyatta
The mysql.sql file should contain SQL commands necessary to set up the phpwiki database.So it should be somewhere among phpwiki files. Due to differences between versions, it might not be named exactly "mysql.sql". If you installed phpwiki from an .ipk file, try "ipkg files phpwiki | grep -i sql" and see what you come up with.
weasel123
I personally use didiwick <http://didiwiki.org/> for all my wiki needs its only 25k in size and it has its own webserver etc everything.
ShiroiKuma
QUOTE(zenyatta @ Oct 30 2004, 10:17 PM)
The mysql.sql file should contain SQL commands necessary to set up the phpwiki database.So it should be somewhere among phpwiki files. Due to differences between versions, it might not be named exactly "mysql.sql". If you installed phpwiki from an .ipk file, try "ipkg files phpwiki | grep -i sql" and see what you come up with.

OK, but how do I create the tables in MySql for phpWiki?

What is this 1036 Error?

I found this guide

But when I try like it says in step 2
CODE
GRANT select, insert, update, delete ON phpwiki.* TO wikiuser@localhost IDENTIFIED BY 'password'
I get the error
QUOTE
ERROR 1036: Table 'user' is read only
Why?

How do I overcome this?

And is the step two necessary? In the guide it says
QUOTE
if neccessary
Should I skip it?
ShiroiKuma
OK, I've gotten further by fiddling with it.

I feel I'm close, but need someone experienced with this just to correct me slightly.

I did:
QUOTE
apachectl start
#safe_mysqld &
mysqlstart
then in /mnt/cf/phpwiki-1.3.7
QUOTE
mysqladmin -u -p create phpwiki
mysql -u -p phpwiki <schemas/mysql.sql
then vi /mnt/cf/phpwiki-1.3.7/index.htm and changed the $DBParams['dbtype' should to 'SQL'
and changed the 'dns' to 'dsn' => 'mysql://localhost/phpwiki'

So now when I open http://localhost/ in a browser, I get:
QUOTE
lib/pear/DB.php:264: Warning[2]: Failed opening 'lib/pear/DB/mysql.php' for inclusion (include_path='.:/home/www/php/lib/php')
lib/WikiDB/backend/PearDB.php:32: Fatal[256]: Can't connect to database: wikidb_backend_mysql: fatal database error
DB Error: not found
(Unable to include the DB/mysql.php file for `mysql://localhost/phpwiki')


lib/config.php:404: Notice[1024]: The admin password cannot be empty. Please update your /index.php
Did I go wrong by not creating the mysql with a username and password?

Or what do I need to change?

I am close, ain't I?

Thank you very much for any help you can give me, I don't really know what I'm doing with it at this point, just fiddlin' with it.
zenyatta
Where do you give PHP credentials for accessing the database? Sometimes this is done in the url - username:password@mysql://localhost/phpwiki - but you may have separate credential fields in the same place where you have the connection URL.
ShiroiKuma
Figured it out.

Had to do two things:

1. Edit /home/www/lib/pear/DB.php

and in line 264 change DB to db

2. Edit /mnt/cf/phpwiki-1.3.7/lib/pear/db/mysql.php

and in line 36 change DB to db

Both things are because the wiki files are stored on a CF card, which is FAT formatted, and there strangely, if a filename is all in caps, it's actually lowercase. No idea why. But that's why it wasn't working.

It is now. biggrin.gif

Now if I could figure how to use the RawHtml plugin, so I could at least in a roundabout way use Unicode in the Wiki, it would be great.

Anyone know?
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.