Experiences running wiki on Zaurii

[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...  

[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: [Select]

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

Code: [Select]

ERROR 1064: You have an error in your SQL syntax near 'lock tables on wiki.* to wiki@localhost identified by 'password'' at line 1so tried to overcome it with

Code: [Select]

grant usage on *.* to 'wiki'@'localhost' identified by 'password';to which it responds

Code: [Select]

ERROR 1036: Table 'user' is read onlyWhat'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: [Select]

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

Code: [Select]

ERROR 1064: You have an error in your SQL syntax near 'lock tables on wiki.* to wiki@localhost identified by 'password'' at line 1so tried to overcome it with

Code: [Select]

grant usage on *.* to 'wiki'@'localhost' identified by 'password';to which it responds

Code: [Select]

ERROR 1036: Table 'user' is read onlyWhat'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: [Select]

/usr/local/mysql/bin/mysql -uroot -p[password you just set in mysql] wiki < mysql.sqlwhich 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]

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: [Select]

GRANT select, insert, update, delete ON phpwiki.* TO wikiuser@localhost IDENTIFIED BY 'password'I get the error

ERROR 1036: Table 'user' is read only

Why?

How do I overcome this?

And is the step two necessary? In the guide it says

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:

apachectl start
#safe_mysqld &
mysqlstart

then in /mnt/cf/phpwiki-1.3.7

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:

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.  

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?