Re: [Tikiwiki-users] Creating the database

[mose <mo...@ti...>]

le Sun, Jun 04, 2006 at 06:11:41PM -0400 par Peter Jay Salzman :
> Hi all,
> 
> My ultimate goal is to install a tikiwiki as a personal knowledgebase at
> http://www.dirac.org/programming.  Here's what I've done so far:
> 
> 
> 
> =======================================================================
> 0. aptitude install tikiwiki (Debian)

- notice that tikiwiki is only on experimental branch on debian
http://packages.debian.org/experimental/web/tikiwiki
and it's version 1.9.2, we need a new package (current is
1.9.3.2)

> 
> 1.  mkdir /www/programming
> 
> 2a. ln -s /usr/share/tikiwiki/*.php   /www/programming/
> 2b. ln -s /usr/share/tikiwiki/*.txt   /www/programming/
> 2c. ln -s /usr/share/tikiwiki/*.phtml /www/programming/
> 2d. ln -s /usr/share/tikiwiki/*.png   /www/programming/
> 2e. cp -rp /usr/share/tikiwiki/*      /www/programming/

- you don't need to move content into your web tree, apache can handle
that (in the same way it does for phpmyadmin package for exemple).
	

> 
> 3. File:   /www/programming/db/local-dbconfig.php
> 	Change: include_once("/etc/tikiwiki/dbconfig.php");
> 	To:     include_once("/etc/tikiwiki/programming.dbconfig.php");
> 
> 4a. cp /etc/tikiwiki/dbconfig.php /etc/tikiwiki/programming.dbconfig.php
> 4b. Set $dbuser and $dbpass.
> 4c. Set $dbname to "tiki-programming".
> 
> 5a. File:  /etc/apache2/sites-enabled/dirac.org
>     Add:   Include /etc/tikiwiki/apache.programming
> 5b. File:  /etc/tikiwiki/apache.programming
>     Add:
> 
> 		Directory /www/programming>
> 		  php_flag register_globals off
> 		  Options FollowSymLinks
> 
> 		  <FilesMatch "\.(inc|lib|tpl|sh|sql)$">
> 			 order deny,allow
> 			 deny from all
> 		  </FilesMatch>
> 		</Directory>
> 
> 		# These directories should not be accessed directly.
> 		<DirectoryMatch "^/www/programming/(db|lang|modules|temp|templates)">
> 		  order deny,allow
> 		  deny from all
> 		</DirectoryMatch>
> 
> 		# These directories should not contain PHP code.
> 		<DirectoryMatch "^/www/programming/(dump|img|styles)">
> 		  php_flag engine off
> 		  <FilesMatch "\.ph(p(3|4)?|tml)$">
> 			 order deny,allow
> 			 deny from all
> 		  </FilesMatch>
> 		</DirectoryMatch>
> 
> 
> 6. /etc/init.d/apache2 restart
> =======================================================================
> 
> At this point, I was expecting to point my browser to
> http://www.dirac.org/programming and see some kind of link that says "click
> here to create the database".  Instead, the page says:
> 
>    Notice: this site is currently unavailable.
>    Please try again later or contact the admin.
> 
> I guess I should create the database by hand then.  I started to follow the
> directions in /usr/share/doc/tikiwiki.   In README.Debian:
> 
> 
>    In this case you will need the 'tiki-install.php' script mentioned in
>    the documentation. This and other required scripts are provided in the
>    directory /usr/share/doc/tikiwiki/examples.  To use it, you should
>    copy the script to /usr/share/tikiwiki so that your web server can
>    find it.  You should also uncompress the file db.tar.gz in the same
>    directory.
> 
> There are two things that aren't clear to me about this paragraph:
> 
>    1. tiki-install.php is already in /usr/share/tikiwiki

- it shouldn't, that's a bug.

>    2. the directory db/ is already in /usr/share/tikiwiki (but they don't
>       contain the same files).

- exact, and by untaring it would fill up that dir with all the files.

> 
> So perhaps I should go about making the database in another way.

- just tar xzf /usr/share/doc/tikiwiki/examples/db.tar.gz wherever you
are, and mysql -u(user) -p(pass) tiki-programming < db/tiki.sql
	
I hope we'll have a better .deb release very soon. Any volunteer to
help on that ?


cheers,
mose

> 
> 
> Does what I've already done seem reasonable?
> 
> Can someone give me an url that describes how to make the database by hand?
> 
> Thanks,
> Pete
> 
> 
> _______________________________________________
> Tikiwiki-users mailing list
> Tik...@li...
> https://lists.sourceforge.net/lists/listinfo/tikiwiki-users