installed phpwiki 1.31
the instructions for setting up mysql (install.mysql)
does not match up with the php code in index.php
specifically "
4. Edit index.php to reflect your settings.
a) comment out the DBM settings
b) uncomment the mySQL settings
c) set $mysql_user to "wikiuser" as used in step 2
d) set $mysql_pwd to "password" as used in step 2
e) set $mysql_db to "phpwiki" as used in step 1 "
I cant find references to $mysql_user, $mysql_pwd and $mysql_pwd in the index.php file
the instructions on how to set up need to be more specific
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
And the first link of INSTALL.mysql says:
FIXME: these instructions are slightly broken.
That said, I did fix up the instructions a bit yesterday. Here's the relevant bit from the latest version of INSTALL.mysql:
4. Edit $DBParams in index.php to reflect your settings.
a) $DBParams['dbtype'] should be set to 'SQL'.
b) $DBParams['dsn'] should be set to something like 'mysql://username:password@host/phpwiki' (where 'phpwiki' is the mysql database name.)
c) Note that if you set $DBParams['prefix'] to a non-empty string, you will have to edit schemas/schema.mysql before you perform step three (above). (Sorry.)
The latest version of INSTALL.mysql can be viewed at:
I just downloaded version 1.3.0-jeffs-hacks and installed it following the instructions included and the above. I get the following when I try to open index.php.
Ken
-------------
lib/WikiDB/backend/PearDB.php:28: Fatal[256]: Can't connect to database: wikidb_backend_mysql: fatal database error
DB Error: connect failed<\li>
(mysql://ken@localhost/eLists)<\li>
<\li>
(PHPWIKI_VERSION wasn't updated before the release. I suspect you ahve phpwiki version 1.3.1.)
Stupid question: Can you connect manually to the mysql database using those parameters? I.e. this should work from the command line:
mysql -h localhost -u ken eLists
If you need a password to access the database (most often, mysql databases are set up to require passwords, postgres not...), you need to include that in the dsn, too:
mysql://ken:passwd@localhost/eLists
(The sourceforge forum seems to be mangling the dsn's, so. to repeat myself, the above line reads:
mysql[COLON]//ken[COLON]passwd@localhost/eLists
replace [COLON] with :)
If the above doesn't help, tell me what version of PHP you're running.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Can't seem to get it to work
installed phpwiki 1.31
the instructions for setting up mysql (install.mysql)
does not match up with the php code in index.php
specifically "
4. Edit index.php to reflect your settings.
a) comment out the DBM settings
b) uncomment the mySQL settings
c) set $mysql_user to "wikiuser" as used in step 2
d) set $mysql_pwd to "password" as used in step 2
e) set $mysql_db to "phpwiki" as used in step 1 "
I cant find references to $mysql_user, $mysql_pwd and $mysql_pwd in the index.php file
the instructions on how to set up need to be more specific
And the first link of INSTALL.mysql says:
FIXME: these instructions are slightly broken.
That said, I did fix up the instructions a bit yesterday. Here's the relevant bit from the latest version of INSTALL.mysql:
4. Edit $DBParams in index.php to reflect your settings.
a) $DBParams['dbtype'] should be set to 'SQL'.
b) $DBParams['dsn'] should be set to something like 'mysql://username:password@host/phpwiki' (where 'phpwiki' is the mysql database name.)
c) Note that if you set $DBParams['prefix'] to a non-empty string, you will have to edit schemas/schema.mysql before you perform step three (above). (Sorry.)
The latest version of INSTALL.mysql can be viewed at:
http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/phpwiki/phpwiki/INSTALL.mysql?rev=HEAD&content-type=text/vnd.viewcvs-markup
I just downloaded version 1.3.0-jeffs-hacks and installed it following the instructions included and the above. I get the following when I try to open index.php.
Ken
-------------
lib/WikiDB/backend/PearDB.php:28: Fatal[256]: Can't connect to database: wikidb_backend_mysql: fatal database error
DB Error: connect failed<\li>
(mysql://ken@localhost/eLists)<\li>
<\li>
--------------------------------------------------------------------------------
WikiFatalError
lib/WikiDB/backend/PearDB.php:28: Fatal[256]: Can't connect to database: wikidb_backend_mysql: fatal database error
DB Error: connect failed<\li>
(mysql://ken@localhost/eLists)<\li>
<\li>
(PHPWIKI_VERSION wasn't updated before the release. I suspect you ahve phpwiki version 1.3.1.)
Stupid question: Can you connect manually to the mysql database using those parameters? I.e. this should work from the command line:
mysql -h localhost -u ken eLists
If you need a password to access the database (most often, mysql databases are set up to require passwords, postgres not...), you need to include that in the dsn, too:
mysql://ken:passwd@localhost/eLists
(The sourceforge forum seems to be mangling the dsn's, so. to repeat myself, the above line reads:
mysql[COLON]//ken[COLON]passwd@localhost/eLists
replace [COLON] with :)
If the above doesn't help, tell me what version of PHP you're running.
Version is version 1.3.0-jeffs-hacks - as stated in original post. I just downloaded it from SourceForge.
Made the change to include the password and it appears to work. More to come as I play with it.
Thanks!
Ken