phpwiki-talk

[Phpwiki-talk] Trouble installing with Postgres

[Benjamin S. <be...@ef...>]

Want to install phpwiki 1.3.x and having trouble doing so. 

Server is RH 7.1, PGSQL 7.1, apache 1.3.26. Database user/pw combination has 
been made "ldapwiki/password", database named "ldapwiki". 

I've edited index.php so that array "DBParams" is: 

$DBParams[dbtype]='SQL'; 
$DBParams[dsn]='pgsql://ldapwiki:password@localhost/ldapwiki'; 

And I get the below error message in my browser. Any idea why? 


############################### ERROR 
lib/WikiDB/backend/PearDB.php:680: Fatal[256]: wikidb_backend_pgsql: fatal 
database error

    * DB Error: no such table
    * (LOCK TABLE phpwiki_page [nativecode=ERROR: Relation 'phpwiki_page' 
does not exist
    * ])
*


Fatal PhpWiki Error

lib/WikiDB/backend/PearDB.php:680: Fatal[256]: wikidb_backend_pgsql: fatal 
database error

    * DB Error: no such table
    * (LOCK TABLE phpwiki_page [nativecode=ERROR: Relation 'phpwiki_page' 
does not exist
* ])
############################### /ERROR 

Re: [Phpwiki-talk] Trouble installing with Postgres

[Joby W. <joby@u.washington.edu>]

Hmm... Looks like you are actually connecting...

try:

1) psql -U postgres ldapwiki
2) \d

explanation:
1) Should connect you as the postgres user to your database.
2) \d switch lists all objects.

"phpwiki_page" is not a standard name for a table (normally "page") did 
you make this change?

jbw

Benjamin Smith wrote:
> Want to install phpwiki 1.3.x and having trouble doing so. 
> 
> Server is RH 7.1, PGSQL 7.1, apache 1.3.26. Database user/pw combination has 
> been made "ldapwiki/password", database named "ldapwiki". 
> 
> I've edited index.php so that array "DBParams" is: 
> 
> $DBParams[dbtype]='SQL'; 
> $DBParams[dsn]='pgsql://ldapwiki:password@localhost/ldapwiki'; 
> 
> And I get the below error message in my browser. Any idea why? 
> 
> 
> ############################### ERROR 
> lib/WikiDB/backend/PearDB.php:680: Fatal[256]: wikidb_backend_pgsql: fatal 
> database error
> 
>     * DB Error: no such table
>     * (LOCK TABLE phpwiki_page [nativecode=ERROR: Relation 'phpwiki_page' 
> does not exist
>     * ])
> *
> 
> 
> Fatal PhpWiki Error
> 
> lib/WikiDB/backend/PearDB.php:680: Fatal[256]: wikidb_backend_pgsql: fatal 
> database error
> 
>     * DB Error: no such table
>     * (LOCK TABLE phpwiki_page [nativecode=ERROR: Relation 'phpwiki_page' 
> does not exist
> * ])
> ############################### /ERROR 
> 
> 
> -------------------------------------------------------
> This sf.net email is sponsored by: viaVerio will pay you up to
> $1,000 for every account that you consolidate with us.
> http://ad.doubleclick.net/clk;4749864;7604308;v?
> http://www.viaverio.com/consolidator/osdn.cfm
> _______________________________________________
> Phpwiki-talk mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwiki-talk

Re: [Phpwiki-talk] Trouble installing with Postgres

[Lawrence A. <la...@us...>]

Have you created the database tables using /schemas/pgsql.sql (or whateve=
r its=20
called)?

Lawrence


On Wednesday 16 Oct 2002 9:40 pm, Benjamin Smith wrote:
> Want to install phpwiki 1.3.x and having trouble doing so.
>
> Server is RH 7.1, PGSQL 7.1, apache 1.3.26. Database user/pw combinatio=
n
> has been made "ldapwiki/password", database named "ldapwiki".
>
> I've edited index.php so that array "DBParams" is:
>
> $DBParams[dbtype]=3D'SQL';
> $DBParams[dsn]=3D'pgsql://ldapwiki:password@localhost/ldapwiki';
>
> And I get the below error message in my browser. Any idea why?
>
>
> ############################### ERROR
> lib/WikiDB/backend/PearDB.php:680: Fatal[256]: wikidb_backend_pgsql: fa=
tal
> database error
>
>     * DB Error: no such table
>     * (LOCK TABLE phpwiki_page [nativecode=3DERROR: Relation 'phpwiki_p=
age'
> does not exist
>     * ])
> *
>
>
> Fatal PhpWiki Error
>
> lib/WikiDB/backend/PearDB.php:680: Fatal[256]: wikidb_backend_pgsql: fa=
tal
> database error
>
>     * DB Error: no such table
>     * (LOCK TABLE phpwiki_page [nativecode=3DERROR: Relation 'phpwiki_p=
age'
> does not exist
> * ])
> ############################### /ERROR