Re: [Phpwiki-talk] Install: postgresql and config file

[Reini U. <ru...@x-...>]

Jean-Christian Imbeault schrieb:
> Reini Urban wrote:
> 
>>
>> phpwiki does not create the database and does not create any tables.
> 
> 
> Huh? If phpwiki does not create the tables, who does? The install docs 
> don't mention the need to create any tables ...

see the appropriate INSTALL.<database> files.

>> The rest of your questions are not phpwiki specific at all.
> 
> Sure they are, without it I can't get phpwiki up and running :) I'm 
> trying to install phpwiki and the installation documentation doesn't 
> cover my specific installation platform very well and I need help.

Before you can run install you have to install and configure some 
prerequisites. If you choose postgres be sure you understand the 
configuration of your database and PHP database backend (Pear::Db or 
ADODB). In both cases the DSN is the same.

>> You have to make your own decisions, based on other (external) 
>> libraries and modules.
>> If not, use the default gdbm.
> 
> 
> gdbm not installed and I don't have root access.
> 
>> Please google for any database documentation on DSN strings. This is 
>> not phpwiki specific. See esp. the Pear::DB documentation.
>>
>>      *  + phptype:  Database backend used in PHP (mysql, odbc etc.)
>>      *  + dbsyntax: Database used with regards to SQL syntax etc.
>>      *  + protocol: Communication protocol to use (tcp, unix etc.)
>>      *  + hostspec: Host specification (hostname[:port])
>>      *  + database: Database to use on the DBMS server
>>      *  + username: User name for login
>>      *  + password: Password for login
> 
> Ah ... much better. Now *that* (or a link to it) in the installation 
> docs would be of great help to future new users.

admitted.

>>> #3 From the above example for a DSN I assume that I need to create the
>>> DB myself? I didn't see anywhere in the documentation that said I needed
>>> to create a DB ... why can't phpwiki create the DB itself?
>>
>> Because we have no installer yet.
>> And we didn't want to store the DB root password anywhere.
> 
> Couldn't phpwiki ask for the password once, just to create the DB and 
> necessary tables?

Because we have no installer yet.

>> There's a Makefile which you might find useful.
>> You need to set the root name and password though.
> 
> I assume that's a Makefile for creating the db stuff? I'll try and find 
> it and see what I can make of it.

See the targets. make install-database is a good tip, but it needs some 
Makefile settings.
I would advise to read before writing, though I have to admit that 
asking is quite easy.

> Unfortunately phpwiki won't run on my php5 installation b/c of some 
> fatal errors.
> 
> I'll check to make sure I have the most recent version of phpwiki but if 
> it won't run on php5 getting a connection to postgresql might be moot :( 
> That would be a shame as we were hoping to use it as our internal wiki

Only the latest CVS version will run unpatched with php5-RC2.
Other versions need some fixes in the errorhandler (make E_STRICT 
non-fatal) or need a patch for lib/WikiUserNew.php.

I know of one other wikiengine which runs (only) on php5: "cowiki"
-- 
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/