I have got stuck following the instructions left at /usr/share/doc/phpwiki-1.3.10/INSTALL.mysql (which does admit that: FIXME: these instructions are slightly broken.) in Section 3, where the command to enter is specified as mysql -uuser -ppassword phpwiki < schemas/mysql.sql I cannot find the file schemas/mysql.sql Neither can I find anything that would do the trick. More importantly, I cannot find any source of documentation/HOWTO for phpWiki and Gentoo. Grateful for any advice. Is there a better choice of Wiki on Gentoo? Though MediaWiki and MoinMoin seem also to have much support, phpWiki is consistently praised on the forums. Reproducible: Always Steps to Reproduce: 1. emerge phpWiki 2. Locate docs in /usr/share/doc 3. Follow instructions Actual Results: Could not continue past Section 3 Expected Results: Probably the ebuild should have installed a directory of schemas, and possibly the work around is to use db/dba
It is possible that the file concerned is located at /usr/share/doc/phpwiki-1.3.10/mysql.sql.gz Whilst this might work around my immediate problem, I don't think that it is a particularly good thing
Also the MySQL wikiuser may need DROP and CREATE privileges (at least temporarily), videlicet: mysql> SHOW GRANTS FOR wikiuser@localhost; +----------------------------------------------------------------------------------------------------------+ | Grants for wikiuser@localhost | +----------------------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'wikiuser'@'localhost' IDENTIFIED BY PASSWORD '74c221f946bc8d9a' | | GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, LOCK TABLES ON `phpwiki`.* TO 'wikiuser'@'localhost' | +----------------------------------------------------------------------------------------------------------+ 2 rows in set (0.00 sec)
1. post-install instructions now mention the location of db schemas 2. Regarding DROP and CREATE privileges - please file a bug upstream
