From: Tim B. <tim...@wc...> - 2002-01-17 19:07:52
|
Additional info ...here's a copy of the database section of my index.php // This array holds the parameters which select the database to use. // // Not all of these parameters are used by any particular DB backend. // $DBParams = array( // Select the database type: //'dbtype' => 'SQL', 'dbtype' => 'SQL', // For SQL based backends, specify the database as a DSN // The most general form of a DSN looks like: // // phptype(dbsyntax)://username:password@protocol+hostspec/database // // For a MySQL database, the following should work: // // mysql://user:password@host/databasename // // FIXME: My version Pear::DB seems to be broken enough that there is // no way to connect to a mysql server over a socket right now. //'dsn' => 'mysql://guest@:/var/lib/mysql/mysql.sock/test', //'dsn' => 'mysql://guest@localhost/test', 'dsn' => 'pgsql -h 166.32.201.228 -W wiki tim', // Used by all DB types: // prefix for filenames or table names /* * currently you MUST EDIT THE SQL file too (in the schemas/ directory * because we aren't doing on the fly sql generation during the * installation. */ // 'prefix' => 'phpwiki_' // Used by 'dba' 'directory' => "/tmp", 'dba_handler' => 'gdbm', // Either of 'gdbm' or 'db2' work great for me //'dba_handler' => 'db2', //dba_handler' => 'db3', 'timeout' => 20, //'timeout' => 5 ); Thanks, Tim B. ----------------------------------------------- On Thursday 17 January 2002 01:42 pm, Tim Bogart wrote: > okay...that made a difference. Changed the symptom to something a little > less clear to me. Here it is... > > --------------------- > > DB Error: not found > > WikiFatalError > > lib/WikiDB/backend/PearDB.php:27: Fatal[256]: Can't connect to database: > wikidb_backend_peardb: fatal database error > > DB Error: not found > () > ------------------------------ > > More suggestions are encouraged and wildly anticipated. > > TIA > > Tim B. > > On Thursday 17 January 2002 01:07 pm, Jeff Dairiki wrote: > > Tim Bogart said: > > > I did copy the wiki_pagedb.gdbm to a pages > > > dir that I created and did a chmod 777 on them. > > > > (Of course, that's only used by the DBA backend, > > and so has nothing to do with postgres...) > > > > > The complete error goes like this... > > > > > > lib/WikiDB/backend/PearDB.php:27: Fatal[256]: Can't connect to > > > database: wikidb_backend_pgsql: fatal database error > > > > > > DB Error: connect failed > > > (pgsql://tim:********@xxx.xxx.xxx.xxx/wiki) > > > > Hmmm. Can you connect from the command line? > > > > I'm not a postgres expert, but I think the command for that would be: > > > > psql -h xxx.xxx.xxx.xxx -W wiki tim > > > > > > > > > > _______________________________________________ > > Phpwiki-talk mailing list > > Php...@li... > > https://lists.sourceforge.net/lists/listinfo/phpwiki-talk > > _______________________________________________ > Phpwiki-talk mailing list > Php...@li... > https://lists.sourceforge.net/lists/listinfo/phpwiki-talk |