The wiki image & file uploads being pulled off of NFS have been
dominating load on zwinger for a while. Uploads have now been moved to
albert, which doesn't seem to be as badly bogged down (and which
doesn't break mail and other things when it's bogged!)
Since we did the file synchronization while the wikis were live it's
possible some individual files on albert are missing or out of date.
Missing files are being automatically checked for and pulled off of
zwinger transparently for the web server, but the wikis won't find them
internally. Should do a smoother final sync run at some point.
With any luck, a much lighter zwinger load will mean that mail keeps
going through at a regular pace, and the wikis ought to keep pace
better.
-- brion vibber (brion @ pobox.com)
I now have a first version ***ready*** for download for those, who want
to test
(up-to-date with CVS 1.5 14.12.2004 about 00:00 UTC)
- Email notification for page changes see
http://bugzilla.wikipedia.org/show_bug.cgi?id=454
- Email address authentication see
http://bugzilla.wikipedia.org/show_bug.cgi?id=866
Please let me know if you can test it soon, then I mail you the URL
immediately.
Tom
I changed the DNS servers for mediawiki.org to zwinger/gunther. At
the moment, they answer with the same IP that the old servers
answerred with (an IP we don't control). At the moment, the IP serves
a "302 found" and sends the browser to the sourceforge page.
It would be ideal if someone would set up the redirect on the
wikimedia servers, and change the /var/named/master/mediawiki.zone
file accordingly.
--
"Jason C. Richey" <jasonr(a)bomis.com>
I am new in that list and I am not proud about my english. There are
many things that I don't know so I am asking.
I don't have enough spaces on hard drive so I ask:
There is any compression technology for wikipedia database that allow
to use database without decompress it ?
At this moment I only want a static version of wikipedia to help me in
my work.
I am not sure which one will rise faster, wikipedia or hard drive size.
Anyway at this moment I can' buy a bigger hard drive.
I have 2 hard drives 60 GB and 80 GB and 2 OS Windows XP and Fedora. I
have a database downloaded in August 14.
Old.sql English is about 10G bat I understand that after decompression
it will be about 40 GB or more.
Thank a lot for any information,
Mircea
>
> Domas, can you write up the manual install instructions? I'd like to
> try adding support to the installer but I'm pretty fuzzy on what needs
> to be done first.
Hey, the master document is still at http://ph3.defau.lt/index.php?title=PostgreSQL_Install
--
Domas
---------------------------------------cut here---------------------------------------------------------------------------------
Hereby I, humble developer of mediawiki, try to document the HEAD install process on my FreeBSD/PostgreSQL box.
Files are taken from my dev cf.net CVS account,
cvs co phase3
mv phase3 pgwiki.defau.lt
What I try to do next is creating database and users.
* Database and users should not be created before
* I should be able to supply admin credentials
$ psql -U superuser template1
Welcome to psql 7.4.1, the PostgreSQL interactive terminal.
...
template1=# CREATE USER mediawikiadmin PASSWORD 'someadminpassword';
CREATE USER
template1=# CREATE USER mediawikiuser PASSWORD 'someuserpassword';
CREATE USER
template1=# CREATE DATABASE mediawiki WITH OWNER=mediawikiadmin ENCODING='UNICODE';
CREATE DATABASE
...
Then I have to load the database schema as mediawikiadmin:
$ psql -U mediawikiadmin mediawiki < maintenance/postgresql/pg_tables.sql
There are two meanings of schemas in PG, one as, well, database structure. Another is a logical domain for grouping same kinds of objects. In order to allow many MW instances with shared or not-so-shared tables I made that logical domain by default called "mediawiki", but changable by $wgDBschema. Some additional modules (like search) might use other schemas. That's nice for not mixing everything up.
Command names and some notices on implicit indexes would be provided.
Then, if it is desired to use lower-security user (the mediawikiuser), we should grant him access as in maintenance/postgresql/pg_users.sql (there we have {$wgDBuser}):
$ psql -U mediawikiadmin -h dammit.lt mediawiki
mediawiki=> set search_path=mediawiki,public;
SET
mediawiki=> GRANT SELECT,INSERT,UPDATE,DELETE ON
mediawiki-> archive,brokenlinks,categorylinks,cur,
mediawiki-> cur_cur_id_seq,"group",hitcounter,image,imagelinks,
mediawiki-> interwiki,ipblocks,ipblocks_ipb_id_seq,links,
mediawiki-> linkscc,"logging",math,objectcache,"old",old_old_id_seq,
mediawiki-> oldimage,profiling,querycache,recentchanges,
mediawiki-> recentchanges_rc_id_seq,searchindex,site_stats,
mediawiki-> site_stats_ss_row_id_seq,"user",user_groups,user_newtalk,
mediawiki-> user_rights,user_user_id_seq,validate,watchlist
mediawiki-> TO mediawikiuser;
GRANT
As database is prepared, here we might need to load some initial data. I do set up AdminSettings.php:
$wgDBadminuser='mediawikiadmin';
$wgDBadminpassword='someadminpassword';
I take a reference LocalSettings.php from another site and start walking through it:
$IP = "/home/midom/www/pgwiki.defau.lt";
PG!
$wgDBtype = "PostgreSQL";
$wgDBserver = "localhost";
$wgDBname = "mediawiki";
$wgDBuser = "mediawikiuser";
$wgDBpassword = "someuserpassword";
# There's a simple bug to fix, but this is required now:
$wgPutIPinRC=true;
As I am not a liar:
$wgDBmysql4 = false;
I've got to load initial group data as well, I've got to change `->" from group and load the data into correct schema:
SET search_path=mediawiki,public;
INSERT INTO "group" (group_id,group_name,group_description,group_rights)
VALUES (1,'Anonymous','Anonymous users','read,edit,createaccount');
INSERT INTO "group" (group_id,group_name,group_description,group_rights)
VALUES (2,'Loggedin','General logged in users','read,edit,move,upload');
INSERT INTO "group" (group_id,group_name,group_description,group_rights)
VALUES (3,'Sysops','Operators of this site',
'read,edit,move,delete,undelete,protect,block,upload,asksql,rollback,patrol,editinterface,sysop');
INSERT INTO "group" (group_id,group_name,group_description,group_rights)
VALUES (4,'Bureaucrat','The bureaucrat group is able to make sysops for example.
They have no other rights.',
'read,edit,move,delete,undelete,protect,block,userrights,createaccount,upload,asksql,rollback,patrol,editinterface,siteadmin,sysop');
Mhm, it could load some defaults in case it does not find default groups... That's for owner of Hashar's cat :)
Ah, and next thing is of course - message loading.
$ php rebuildMessages.php --rebuild
Initialising "MediaWiki" namespace...
Clearing message cache...Done.
Ah, right, search. This is a bit trickier. You've got to have PostgreSQL contrib installed. There you've got /usr/local/share/postgresql/contrib/tsearch2.sql file. You should edit one of first lines in this file from
-- Adjust this setting to control where the objects get CREATEd.
SET search_path = public;
to
-- Adjust this setting to control where the objects get CREATEd.
SET search_path = tsearch;
This code uses external functions for your PG, therefore, you must be a PG superuser to do this. You should create schema tsearch as user mediawikiadmin, and then load the tsearch schema from pg contrib.
Moreover, as database superuser you'll have to make this:
GRANT ALL ON TABLE pg_ts_cfg,pg_ts_cfgmap,pg_ts_dict,pg_ts_parser to mediawikiadmin;
GRANT SELECT ON TABLE pg_ts_cfg,pg_ts_cfgmap,pg_ts_dict,pg_ts_parser to mediawikiuser;
Then again, as mediawikiadmin:
SET search_path=mediawiki,tsearch,public;
CREATE TABLE searchindex (
si_page integer PRIMARY KEY,
si_title tsvector,
si_text tsvector
);
CREATE INDEX si_text_idx ON searchindex USING gist (si_text);
CREATE INDEX si_title_idx ON searchindex USING gist (si_title);
GRANT USAGE ON SCHEMA tsearch to mediawikiuser;
GRANT INSERT,UPDATE,SELECT,DELETE ON searchindex to mediawikiuser;
Search is working. Or should be. The wiki - as well.
In message <EB323D2D-4C8E-11D9-BE8F-000A95DAA284(a)pobox.com>, Brion
Vibber <brion(a)pobox.com> writes
>On Dec 12, 2004, at 2:17 PM, Arwel Parry wrote:
>> Could someone confirm whether or not images are displaying OK from
>>Commons?
>>
>> For example, when I look at
>>[[en:Ukrainian_presidential_election,_2004]] under "Preliminary vote"
>>there's an image captioned "First-round voters in
>>Kamyanets'-Podils'kyi, 31 October, 2004" which does not display when I
>>look at it with Firefox and IE. The image does exist at
>>http://commons.wikimedia.org/wiki/Image:
Ukrainian_election_2004_1_ubt.JPG >
>Looks fine in Safari and Firefox.
>
>-- brion vibber (brion @ pobox.com)
Hmm, I wonder why it doesn't show up on my Firefox browser -- surely not
a Mac/Windows difference?
--
Arwel Parry
http://www.cartref.demon.co.uk/
MediaWiki 1.3.9 is a security and bug fix release.
A flaw in upload handling has been found which may allow upload and
execution of arbitrary scripts with the permissions of the web server.
Only wikis that have enabled uploads and have a vulnerable Apache
configuration will be affected, but to be safe all wikis should
upgrade.
Wikis with uploads available should either disable uploads or upgrade
to 1.3.9 immediately; if other files are customized and require merging
changes, includes/SpecialUpload.php may be replaced individually to add
the fix.
(It is also recommended to configure your web server to disable script
execution in the 'images' subdirectory where uploads are placed, which
prevents most attacks even if the wiki fails.)
Changes from 1.3.8:
* Backported "Templates used in this page"-feature of EditPage
* Allow "MySkin" as a default skin.
* (bug 938) Parse namespaces correctly on self-interwiki links
* (bug 1010) fix broken Commons image link on Classic & Cologne Blue
* (bug 1004) Norsk language names for interwiki links changed,
Nauruan language name changed
* Fix upload extension blacklist to protect against vulnerable
Apache configurations
Release notes:
http://sourceforge.net/project/shownotes.php?release_id=289468
Download:
http://prdownloads.sf.net/wikipedia/mediawiki-1.3.9.tar.gz?download
Wiki admin help mailing list:
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
Low-traffic release announcements mailing list:
http://mail.wikipedia.org/mailman/listinfo/mediawiki-announce
Bug report system:
http://bugzilla.wikipedia.org/
Play "stump the developers" live on IRC:
#mediawiki on irc.freenode.net
- -- brion vibber (brion @ pobox.com)
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
MediaWiki 1.4beta3 is an experimental release, to help flush out
remaining major problems in the code prior to a final public 1.4.0
release. It is not recommended to use this beta on a public site unless
you're familiar with MediaWiki innards and are willing and able to help
diagnose and fix problems that come up.
Users of the earlier beta releases should upgrade as soon as possible,
particularly if uploads are enabled. A security vulnerability with
uploads on some Apache configurations has been fixed in this release.
=== Beta 3 fixes ===
* Hide RC patrol markers when patrol is disabled or not allowed to
patrol.
* Fix language selection for upgraded accounts
* (bug 1076) navigation links in QueryPage should be translated by
wgContLang.
* (bug 922) bogus DOS line endings in LanguageEl.php
* Fix index usage in contribs
* Caching and load limiting options for Recentchanges RSS/Atom feed
* (bug 1074) Add stock icons for non-image files in gallery/Newimages
* Add width and height attributes on thumbs in gallery/Newimages
* Enhance upload extension blacklist to protect against vulnerable
Apache configurations
Release notes:
http://sourceforge.net/project/shownotes.php?release_id=289469
Download:
http://prdownloads.sf.net/wikipedia/mediawiki-1.4beta3.tar.gz?download
Wiki admin help mailing list:
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
Low-traffic release announcements mailing list:
http://mail.wikipedia.org/mailman/listinfo/mediawiki-announce
Bug report system:
http://bugzilla.wikipedia.org/
Play "stump the developers" live on IRC:
#mediawiki on irc.freenode.net
- - -- brion vibber (brion @ pobox.com)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.6 (Darwin)
iD8DBQFBvNsRwRnhpk1wk44RAq4OAJ97aILWDHXV8b4jMbJNrHWvbsiG6wCfQjVS
Y3FFGLESXFkLUfmHsDK8J4Q=
=g/qo
-----END PGP SIGNATURE-----
Could someone confirm whether or not images are displaying OK from
Commons?
For example, when I look at [[en:Ukrainian_presidential_election,_2004]]
under "Preliminary vote" there's an image captioned "First-round voters
in Kamyanets'-Podils'kyi, 31 October, 2004" which does not display when
I look at it with Firefox and IE. The image does exist at
http://commons.wikimedia.org/wiki/Image:Ukrainian_election_2004_1_ubt.JPG
--
Arwel Parry
http://www.cartref.demon.co.uk/