I'm trying to use MediaWiki with PostgreSQL 8.4.4 - however, it fails miserably.
It installs fine:
PHP 5.3.2-1ubuntu4.2 installed
Found database drivers for: PostgreSQL
PHP server API is cgi-fcgi; using ugly URLs (index.php?title=Page_Title)
Have XML / Latin1-UTF-8 conversion support.
Session save path (/var/lib/php5) appears to be valid.
PHP's memory_limit is 128M bytes.
Couldn't find eAccelerator, APC or XCache; cannot use these for object caching.
Found GNU diff3: /usr/bin/diff3.
Couldn't find GD library or ImageMagick; image thumbnailing disabled.
Installation directory: /shared/sites/intra.dooster.net/wiki
Script URI path: /wiki
Installing MediaWiki with php file extensions
Environment checked. You can install MediaWiki.
Generating configuration file...
Database type: PostgreSQL
Loading class: DatabasePostgres
Attempting to connect to database "intrawikidb" as "intrawikiuser"...
Checking the version of Postgres...version 8.4.4 is OK.
Checking for Pl/Pgsql ...not installed. Attempting to install Pl/Pgsql ...OK
Creating schema mediawiki ...OK
Setting the timezone to GMT for user "intrawikiuser" ...OK
Setting the datestyle to ISO, YMD for user "intrawikiuser" ...OK
Setting the search path for user "intrawikiuser" ...OK
Connected to postgres 8.4.4
Creating tables... done.
Populating interwiki table... successfully populated.
Initializing statistics...
Created sysop account WikiSysop.
Creating LocalSettings.php...
-----------------------------------------------
However as I try to use the wiki, all I see is:
A database error has occurred
Query: INSERT INTO l10n_cache (lc_lang,lc_key,lc_value) VALUES
('en','messages:clearyourcache','s:438:"''''''Note:
After saving, you may have to bypass your browser''s cache to see the
changes.''''''
''''''Mozilla / Firefox / Safari:''''''
hold ''''Shift'''' while clicking
''''Reload'''', or press either
''''Ctrl-F5'''' or
''''Ctrl-R''''
(''''Command-R'''' on a Macintosh);
''''''Konqueror: ''''''click
''''Reload'''' or press
''''F5'''';
''''''Opera:'''''' clear the cache in
''''Tools → Preferences'''';
''''''Internet Explorer:'''''' hold
''''Ctrl'''' while clicking
''''Refresh,'''' or press
''''Ctrl-F5''''.";'),('en','messages:usercssyoucanpreview','s:83:"''''''Tip:''''''
Use the "{{int:showpreview}}" button to test your new CSS before
saving.";'),('en','messages:userjsyoucanpreview','s:90:"''''''Tip:''''''
Use the "{{int:showpreview}}" button to test your new JavaScript before
saving.";'),('en','messages:usercsspreview','s:91:"''''''Remember
that you are only previewing your user CSS.''''''
''''''It has not yet been
saved!''''''";'),('en','messages:userjspreview','s:106:"''''''Remember
that you are only testing/previewing your user JavaScript.''''''
''''''It has not yet been
saved!''''''";'),('en','messages:userinvalidcssjstitle','s:178:"''''''Warning:''''''
There is no skin "$1".
Remember that custom .css and .js pages use a lowercase title, e.g.
{{ns:user}}:Foo/monobook.css as opposed to
{{ns:user}}:Foo/Monobook.css.";'),('en','messages:updated','s:9:"(Updated)";'),('en','messages:note','s:11:"''''''Note:''''''";'),('en','messages:previewnote','s:81:"''''''Remember
that this is only a preview.''''''
Your changes have not yet been
saved!";'),('en','messages:previewconflict','s:102:"This
preview reflects the text in the upper text editing area as it will appear if you choose
to
save.";'),('en','messages:session_fail_preview','s:179:"''''''Sorry!
We could not process your edit due to a loss of session
data.''''''
Please try again.
If it still does not work, try [[Special:UserLogout|logging out]] and logging back
in.";'),('en','messages:session_fail_previe
PostgreSQL reports this in the log:
2010-09-14 00:23:47 CEST WARNING: nonstandard use of \\ in a string literal at character
113
2010-09-14 00:23:47 CEST HINT: Use the escape string syntax for backslashes, e.g.,
E'\\'.
2010-09-14 00:23:47 CEST WARNING: nonstandard use of \\ in a string literal at character
115
2010-09-14 00:23:47 CEST HINT: Use the escape string syntax for backslashes, e.g.,
E'\\'.
2010-09-14 00:23:47 CEST WARNING: nonstandard use of \\ in a string literal at character
108
2010-09-14 00:23:47 CEST HINT: Use the escape string syntax for backslashes, e.g.,
E'\\'.
2010-09-14 00:23:47 CEST WARNING: nonstandard use of \\ in a string literal at character
2307
2010-09-14 00:23:47 CEST HINT: Use the escape string syntax for backslashes, e.g.,
E'\\'.
2010-09-14 00:23:47 CEST ERROR: character 0xe28692 of encoding "UTF8" has no
equivalent in "LATIN1"
2010-09-14 00:24:02 CEST LOG: could not receive data from client: Connection reset by
peer
2010-09-14 00:24:02 CEST LOG: unexpected EOF within message length word
2010-09-14 00:24:05 CEST WARNING: nonstandard use of \\ in a string literal at character
2307
2010-09-14 00:24:05 CEST HINT: Use the escape string syntax for backslashes, e.g.,
E'\\'.
2010-09-14 00:24:05 CEST ERROR: character 0xe28692 of encoding "UTF8" has no
equivalent in "LATIN1"
Is the newest MediaWiki usable with PostgreSQL, or is it something wrong with my setup (I
tried MediaWiki 1.15.5, but it didn't even install, as it detected PostgreSQL 8.4.4 as
7.x)?
--
Tomasz Chmielewski
http://wpkg.org