Okay, so when I used the $root/wiki/config/index.php file to install the MediaWiki software on my G4, it didn't recognize that I have MySQL installed (I have 5.0.24.) So I decided to just go with postgresql, which is also installed. I entered the correct db info, and under "database host" put localhost. I get the following: PHP 5.0.5 installed Found database drivers for: PostgreSQL PHP server API is apache; ok, using pretty URLs (index.php/Page_Title) Have XML / Latin1-UTF-8 conversion support. PHP is configured with no memory_limit. No zlib support. Neither Turck MMCache nor eAccelerator nor APC are installed, can't use object caching functions Found GNU diff3: /usr/bin/diff3. Couldn't find GD library or ImageMagick; image thumbnailing disabled. Installation directory: /Library/WebServer/Documents/wiki Script URI path: /wiki Environment checked. You can install MediaWiki. Generating configuration file... Database type: PostgreSQL Loading class: DatabasePostgres Attempting to connect to database server as xxxxx... error: No database connection What am I doing wrong?
Thanks, ElAmericano
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Attempting to connect to database server as xxxxx... error: No database connection What am I doing wrong?
(Please indicate which version you are using - Postgres support is much further along in the 1.8 svn version than 1.7)
The connection to the database is not being made, due to one of the settings being wrong (or the database not being started or not existing). See if you can connect via the "psql" program from the command line, using the same port and user (or superuser) and password you are trying with the install. For example, the default config settings would lead you to try this:
psql -h localhost -p 5432 -U wikiuser wikidb
That should give you a clearer error message as to why the connection is failing. You may also prefer to connect as a superuser, so that MediaWiki can create the accounts needed for you. Don't forget you can ask on irc at freenode.net on the channels #postgresql or #mediawiki for possibly quicker help.
- -- Greg Sabino Mullane greg@turnstep.com PGP Key: 0x14964AC8 200609031100 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
Okay, I got past that problem. Now, I get the following:
PHP 5.0.5 installed Found database drivers for: PostgreSQL PHP server API is apache; ok, using pretty URLs (index.php/Page_Title) Have XML / Latin1-UTF-8 conversion support. PHP is configured with no memory_limit. No zlib support. Neither Turck MMCache nor eAccelerator nor APC are installed, can't use object caching functions Found GNU diff3: /usr/bin/diff3. Couldn't find GD library or ImageMagick; image thumbnailing disabled. Installation directory: /Library/WebServer/Documents/wiki Script URI path: /wiki Environment checked. You can install MediaWiki. Generating configuration file... Database type: PostgreSQL Loading class: DatabasePostgres Attempting to connect to database server as xxxx... Checking for tsearch2 ...OK Checking for plpgsql ...OK
Warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "pg_catalog.pg_roles" does not exist in /Library/WebServer/ Documents/wiki/includes/DatabasePostgres.php on line 171 A database error has occurred Query: SELECT rolname FROM pg_catalog.pg_namespace n, pg_catalog.pg_roles r WHERE n.nspowner=r.oid AND n.nspname = 'mediawiki' Function: Error: 1 ERROR: relation "pg_catalog.pg_roles" does not exist Backtrace: #0 / Library/WebServer/Documents/wiki/includes/Database.php(604): DatabasePostgres->reportQueryError('ERROR: relatio...', 1, 'SELECT rolname ...', '', false) #1 /Library/WebServer/Documents/wiki/ includes/DatabasePostgres.php(518): Database->query('SELECT rolname ...') #2 /Library/WebServer/Documents/wiki/includes/ DatabasePostgres.php(113): DatabasePostgres->schemaExists ('mediawiki') #3 /Library/WebServer/Documents/wiki/includes/ DatabasePostgres.php(35): DatabasePostgres->open('localhost', 'xxxxx', 'password', 'wikidb') #4 /Library/WebServer/Documents/wiki/ includes/DatabasePostgres.php(42): DatabasePostgres->DatabasePostgres ('localhost', 'xxxxx', 'password', 'wikidb', 1, 0) #5 /Library/ WebServer/Documents/wiki/config/index.php(684): DatabasePostgres::newFromParams('localhost', 'xxxxx', 'password', 'wikidb', 1) #6 {main}
And I still don't understand why it can't see my mysql installation.
Thanks, ElAmericano
On Sep 3, 2006, at 11:08 AM, Greg Sabino Mullane wrote:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Attempting to connect to database server as xxxxx... error: No database connection What am I doing wrong?
(Please indicate which version you are using - Postgres support is much further along in the 1.8 svn version than 1.7)
The connection to the database is not being made, due to one of the settings being wrong (or the database not being started or not existing). See if you can connect via the "psql" program from the command line, using the same port and user (or superuser) and password you are trying with the install. For example, the default config settings would lead you to try this:
psql -h localhost -p 5432 -U wikiuser wikidb
That should give you a clearer error message as to why the connection is failing. You may also prefer to connect as a superuser, so that MediaWiki can create the accounts needed for you. Don't forget you can ask on irc at freenode.net on the channels #postgresql or #mediawiki for possibly quicker help.
Greg Sabino Mullane greg@turnstep.com PGP Key: 0x14964AC8 200609031100 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE-----
iD8DBQFE+u9tvJuQZxSWSsgRAplfAJoCh1PfbdqPYNtRPp3Q/NR53Ql6ygCggGaS nS+7en5+B/QB1ZAvm6mAOHA= =BrmP -----END PGP SIGNATURE-----
MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "pg_catalog.pg_roles" does not exist in /Library/WebServer/
Sounds like you don't have a recent version of Postgres installed. Make sure you are running at least 8.0. To anticipate further problems, you'll also need tsearch2 and plpgsql installed as well. Both should be simple installs if you are using rpm/yum/etc.
- -- Greg Sabino Mullane greg@turnstep.com PGP Key: 0x14964AC8 200609031209 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
According to the documentation and to psql --version, I have postgresql 8.0.3. As far as installing tsearch2 and plpgsql, I had never heard of them until now, but I did install them before running index.php.
On Sep 3, 2006, at 12:12 PM, Greg Sabino Mullane wrote:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "pg_catalog.pg_roles" does not exist in /Library/WebServer/
Sounds like you don't have a recent version of Postgres installed. Make sure you are running at least 8.0. To anticipate further problems, you'll also need tsearch2 and plpgsql installed as well. Both should be simple installs if you are using rpm/yum/etc.
Greg Sabino Mullane greg@turnstep.com PGP Key: 0x14964AC8 200609031209 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE-----
iD8DBQFE+v5VvJuQZxSWSsgRAofUAKCwvyiXdhthwDWrDIT7k09ULSPchwCgtCHO d8dnIiyNoFcYzFp5UjxG9Tc= =E/UN -----END PGP SIGNATURE-----
MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
According to the documentation and to psql --version, I have postgresql 8.0.3. As far as installing tsearch2 and plpgsql, I had never heard of them until now, but I did install them before running index.php.
Oops, I apologize - the release notes and I were wrong, the required version is actually 8.1, which is also the first version that has the pg_roles view. I've updated the RELEASE-NOTES file: if you know of any other places that still says 8.0, please let me know. I'll add in some more graceful version detection to the installer as well.
- -- Greg Sabino Mullane greg@turnstep.com End Point Corporation PGP Key: 0x14964AC8 200609031832 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
mediawiki-l@lists.wikimedia.org