Hope this isn't off-topic here.
I prefer playing with things to reading documentation, but I can't play with mediawiki just now for reasons given in another thread, so I've been looking at the docs and it seems it might be difficult to get it to do what I want.
That is: have a site a bit like a blog, in that anonymous users can read anything, people can comment on articles (ie add to talk pages) -- though maybe requiring registration/login -- but nobody can edit articles except the owner. I found the Preventing Access page on Meta but that doesn't seem to cover my case. I'm willing to copy hacks that others have developed and tested but not to do experimental hacking myself. Do I need to look elsewhere for this functionality?
(My site is actually setup as a blog just now, see the link in the sig, but I'm not entirely happy with that because most of the content will be static, with most posts being just announcements of changes to the static content. Also, static pages can't be commented on right now, though I think that's fairly easy to fix, in the theme.)
Maybe the standard "protect" feature will do what you want. Only sysops can edit the article, but the users can edit the talk page.
Or maybe you should look at "blog" software instead of "wiki" software. Something like WordPress.
Monday, January 8, 2007, 7:09:14 PM, Fernando wrote:
Maybe the standard "protect" feature will do what you want. Only sysops can edit the article, but the users can edit the talk page.
That might do it, though I'd need to prevent anon users from creating articles too. I've now found GroupWikiBase, which looks like it might be what I need.
2007/1/8, Robin Faichney robin@robinfaichney.org:
Monday, January 8, 2007, 7:09:14 PM, Fernando wrote:
Maybe the standard "protect" feature will do what you want. Only sysops can edit the article, but the users can edit the talk page.
That might do it, though I'd need to prevent anon users from creating articles too. I've now found GroupWikiBase, which looks like it might be what I need.
# require that users log in to edit $wgGroupPermissions['*']['edit'] = false;
Robin Faichney wrote:
Hope this isn't off-topic here.
I prefer playing with things to reading documentation, but I can't play with mediawiki just now for reasons given in another thread, so I've been looking at the docs and it seems it might be difficult to get it to do what I want.
That is: have a site a bit like a blog, in that anonymous users can read anything, people can comment on articles (ie add to talk pages) -- though maybe requiring registration/login -- but nobody can edit articles except the owner. I found the Preventing Access page on Meta but that doesn't seem to cover my case. I'm willing to copy hacks that others have developed and tested but not to do experimental hacking myself. Do I need to look elsewhere for this functionality?
check the talkright extension.
also, i posted code that lets users easily post comments (instead of editing the discussion page). search for the 'discussions questions' thread
to add a form to the page itself, i changed skins/Monobook.php. add the following just before the </div> that is before the <div id="column-one">: <div id="post-comment"> Comment on this page: <form name="commentForm" method="post" action="/mediawiki/index.php/Special:Postcomment"> <input name="target" value="<?php $this->text('title') ?>" type="hidden"/> <textarea tabindex="3" rows="5" cols="25" name="comment"></textarea> <input tabindex="4" name="do" value="Post" class="btn" type="submit"/> </form>
</div>
and in skins/monobook/main.css add the style you want mine is: #post-comment { margin: 2.8em 0 0 12.2em; padding: 1em 1em 1.5em 1em; background: white; color: black; border: 1px solid #aaa; /* border-right: none;*/ line-height: 1.5em; position: relative; z-index: 2; }
(My site is actually setup as a blog just now, see the link in the sig, but I'm not entirely happy with that because most of the content will be static, with most posts being just announcements of changes to the static content. Also, static pages can't be commented on right now, though I think that's fairly easy to fix, in the theme.)
All,
Everything looks pretty good on my update from 1.7.1 to 1.8.2, except when I run update.php I get the following error: Adding ipb_anon_only field to table ipblocks...Query "DROP TABLE IF EXISTS 'ipblocks_newunique'" failed with error code "DROP command denied to user 'wikiuser'@localhost' for table 'ipblocks_newunique' (localhost)".
Up until that point the update appears to be going normally.
Thanks, Dave
-----Original Message----- From: mediawiki-l-bounces@lists.wikimedia.org [mailto:mediawiki-l-bounces@lists.wikimedia.org] On Behalf Of Ittay Dror Sent: Monday, January 08, 2007 2:17 PM To: MediaWiki announcements and site admin list Subject: Re: [Mediawiki-l] Access restrictions
Robin Faichney wrote:
Hope this isn't off-topic here.
I prefer playing with things to reading documentation, but I can't play with mediawiki just now for reasons given in another thread, so I've been looking at the docs and it seems it might be difficult to get it to do what I want.
That is: have a site a bit like a blog, in that anonymous users can read anything, people can comment on articles (ie add to talk pages) -- though maybe requiring registration/login -- but nobody can edit articles except the owner. I found the Preventing Access page on Meta but that doesn't seem to cover my case. I'm willing to copy hacks that others have developed and tested but not to do experimental hacking myself. Do I need to look elsewhere for this functionality?
check the talkright extension.
also, i posted code that lets users easily post comments (instead of editing the discussion page). search for the 'discussions questions' thread
to add a form to the page itself, i changed skins/Monobook.php. add the following just before the </div> that is before the <div id="column-one">: <div id="post-comment"> Comment on this page: <form name="commentForm" method="post" action="/mediawiki/index.php/Special:Postcomment"> <input name="target" value="<?php $this->text('title') ?>" type="hidden"/> <textarea tabindex="3" rows="5" cols="25" name="comment"></textarea> <input tabindex="4" name="do" value="Post" class="btn" type="submit"/> </form>
</div>
and in skins/monobook/main.css add the style you want mine is: #post-comment { margin: 2.8em 0 0 12.2em; padding: 1em 1em 1.5em 1em; background: white; color: black; border: 1px solid #aaa; /* border-right: none;*/ line-height: 1.5em; position: relative; z-index: 2; }
(My site is actually setup as a blog just now, see the link in the sig, but I'm not entirely happy with that because most of the content will be static, with most posts being just announcements of changes to the static content. Also, static pages can't be commented on right now, though I think that's fairly easy to fix, in the theme.)
On 08/01/07, David_S_Green@dell.com David_S_Green@dell.com wrote:
Everything looks pretty good on my update from 1.7.1 to 1.8.2, except when I run update.php I get the following error: Adding ipb_anon_only field to table ipblocks...Query "DROP TABLE IF EXISTS 'ipblocks_newunique'" failed with error code "DROP command denied to user 'wikiuser'@localhost' for table 'ipblocks_newunique' (localhost)".
The user specified in AdminSettings.php will need appropriate permissions to create, drop, and alter tables.
Rob Church
I have the correct username and password in that file. Do I need additional info?
-----Original Message----- From: mediawiki-l-bounces@lists.wikimedia.org [mailto:mediawiki-l-bounces@lists.wikimedia.org] On Behalf Of Rob Church Sent: Monday, January 08, 2007 2:38 PM To: MediaWiki announcements and site admin list Subject: Re: [Mediawiki-l] Error Updating to 1.8.2
On 08/01/07, David_S_Green@dell.com David_S_Green@dell.com wrote:
Everything looks pretty good on my update from 1.7.1 to 1.8.2, except when I run update.php I get the following error: Adding ipb_anon_only field to table ipblocks...Query "DROP TABLE IF EXISTS 'ipblocks_newunique'" failed with error code "DROP command
denied
to user 'wikiuser'@localhost' for table 'ipblocks_newunique' (localhost)".
The user specified in AdminSettings.php will need appropriate permissions to create, drop, and alter tables.
Rob Church
_______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l
On 08/01/07, David_S_Green@dell.com David_S_Green@dell.com wrote:
I have the correct username and password in that file. Do I need additional info?
*Which* username and password?
Most wikis will need MediaWiki set up to operate based on two sets of MySQL credentials; the normal use user and the maintenance user.
The first requires INSERT, SELECT, UPDATE and DELETE permissions on the database; it's specified using $wgDBuser and $wgDBpassword in LocalSettings.php, and MediaWiki uses it for non-maintenance tasks (although some maintenance scripts which don't do anything fancy will also use it).
The second is set up in AdminSettings.php and *additionally* requires CREATE, ALTER and DROP permissions on the database (and possibly INDEX).
(The other credentials come into play in replication scenarios, external storage, common repositories and all manner of other goodies.)
Rob Church
I have these 2 in adminsettings.php: $wgDBadminuser $wgDBadminpassword
And in localsettings.php: $wgDBuser $wgDBpassword
These both have the same username and password. Not sure what else to change. When I changed the password (just for kicks), it immediately gave me a bad username password error. With them correct, the update.php script runs with no error until the error I mentioned below. To me, that means it is initially accepting the username and password.
Why is it failing further in the update?
Thanks again, Dave
-----Original Message----- From: mediawiki-l-bounces@lists.wikimedia.org [mailto:mediawiki-l-bounces@lists.wikimedia.org] On Behalf Of Rob Church Sent: Monday, January 08, 2007 2:46 PM To: MediaWiki announcements and site admin list Subject: Re: [Mediawiki-l] Error Updating to 1.8.2
On 08/01/07, David_S_Green@dell.com David_S_Green@dell.com wrote:
I have the correct username and password in that file. Do I need additional info?
*Which* username and password?
Most wikis will need MediaWiki set up to operate based on two sets of MySQL credentials; the normal use user and the maintenance user.
The first requires INSERT, SELECT, UPDATE and DELETE permissions on the database; it's specified using $wgDBuser and $wgDBpassword in LocalSettings.php, and MediaWiki uses it for non-maintenance tasks (although some maintenance scripts which don't do anything fancy will also use it).
The second is set up in AdminSettings.php and *additionally* requires CREATE, ALTER and DROP permissions on the database (and possibly INDEX).
(The other credentials come into play in replication scenarios, external storage, common repositories and all manner of other goodies.)
Rob Church
_______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l
On 08/01/07, David_S_Green@dell.com David_S_Green@dell.com wrote:
I have these 2 in adminsettings.php: $wgDBadminuser $wgDBadminpassword
The user these refer to MUST have the appropriate *MySQL permissions* as explained in the previous email. See http://www.mysql.org/doc/refman/4.1/en/grant.html and related documentation.
Rob Church
OK, sorry for this noob MYSQL question now...but I have very little experience with it. I'm learning on the fly here.
I am at the MYSQL prompt. What is the easiest way for me to ensure the MySQL permissions are set correctly from this point?
Thank you very much for hanging with me. Dave
-----Original Message----- From: mediawiki-l-bounces@lists.wikimedia.org [mailto:mediawiki-l-bounces@lists.wikimedia.org] On Behalf Of Rob Church Sent: Monday, January 08, 2007 2:59 PM To: MediaWiki announcements and site admin list Subject: Re: [Mediawiki-l] Error Updating to 1.8.2
On 08/01/07, David_S_Green@dell.com David_S_Green@dell.com wrote:
I have these 2 in adminsettings.php: $wgDBadminuser $wgDBadminpassword
The user these refer to MUST have the appropriate *MySQL permissions* as explained in the previous email. See http://www.mysql.org/doc/refman/4.1/en/grant.html and related documentation.
Rob Church
_______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l
On 08/01/07, David_S_Green@dell.com David_S_Green@dell.com wrote:
OK, sorry for this noob MYSQL question now...but I have very little experience with it. I'm learning on the fly here.
I am at the MYSQL prompt. What is the easiest way for me to ensure the MySQL permissions are set correctly from this point?
(I'll provide instructions for creating a new MySQL user for maintenance purposes...)
GRANT ALL ON wikidb.* TO "wikiadmin"@"localhost" IDENTIFIED BY "password";
Replace "wikidb" with the database name, "wikiadmin" with the username to be used for the maintenance user, and "password" with a suitable password.
If the web server is not the same machine as the database server, then replace "localhost" with the host name of the application server.
You can then insert these credentials into AdminSettings.php.
Rob Church
Rob,
Thank you so much, that did the trick!
Again, many thanks! Dave
-----Original Message----- From: mediawiki-l-bounces@lists.wikimedia.org [mailto:mediawiki-l-bounces@lists.wikimedia.org] On Behalf Of Rob Church Sent: Monday, January 08, 2007 3:30 PM To: MediaWiki announcements and site admin list Subject: Re: [Mediawiki-l] Error Updating to 1.8.2
On 08/01/07, David_S_Green@dell.com David_S_Green@dell.com wrote:
OK, sorry for this noob MYSQL question now...but I have very little experience with it. I'm learning on the fly here.
I am at the MYSQL prompt. What is the easiest way for me to ensure the MySQL permissions are set correctly from this point?
(I'll provide instructions for creating a new MySQL user for maintenance purposes...)
GRANT ALL ON wikidb.* TO "wikiadmin"@"localhost" IDENTIFIED BY "password";
Replace "wikidb" with the database name, "wikiadmin" with the username to be used for the maintenance user, and "password" with a suitable password.
If the web server is not the same machine as the database server, then replace "localhost" with the host name of the application server.
You can then insert these credentials into AdminSettings.php.
Rob Church
_______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Monday, January 8, 2007, 8:16:37 PM, Ittay wrote:
Robin Faichney wrote:
Hope this isn't off-topic here.
I prefer playing with things to reading documentation, but I can't play with mediawiki just now for reasons given in another thread, so I've been looking at the docs and it seems it might be difficult to get it to do what I want.
That is: have a site a bit like a blog, in that anonymous users can read anything, people can comment on articles (ie add to talk pages) -- though maybe requiring registration/login -- but nobody can edit articles except the owner. I found the Preventing Access page on Meta but that doesn't seem to cover my case. I'm willing to copy hacks that others have developed and tested but not to do experimental hacking myself. Do I need to look elsewhere for this functionality?
check the talkright extension.
Will do.
also, i posted code that lets users easily post comments (instead of editing the discussion page). search for the 'discussions questions' thread
There's just 2 messages in that thread in the archives, a question from you and an answer from Rob Church.
I'll have a look at the code you posted here. Thanks very much.
mediawiki-l@lists.wikimedia.org