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
_______________________________________________
MediaWiki-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
