I'm wanting to make an article link, much like Wikipedia makes to its own articles, but instead of using [[whatever]] like would be done to an article on the same site, I want to make it be a link over to the real en.wikipedia.org site, for the article there. The <nowiki> tags with HTML to do it just escape the HTML out to be displayed (e.g. its nowiki and nohtml combined).
Example. I have the term Postfix in a local wiki page. If I wrote a page about Postfix on my local wiki, I could just use [[Postfix]] and be done. But I don't want to have to load all the templates from Wikipedia, or maintain that article here. I just want to link over to Wikipedia and let people read it there.
Hello,
You could use interwiki's for that [1] so you can write [[:wikipedia:Article]] and the link will forward you to Wikipedia.
I believe the interwiki Wikipedia is set up by default so [[wikipedia:Article]] will already work
[1] http://www.mediawiki.org/wiki/Interwiki
On Wed, Jul 28, 2010 at 13:10, Huib Laurens sterkebak@gmail.com wrote:
Hello,
You could use interwiki's for that [1] so you can write [[:wikipedia:Article]] and the link will forward you to Wikipedia.
I believe the interwiki Wikipedia is set up by default so [[wikipedia:Article]] will already work
Thanks! This works. I'm using it in the form [[:wikipedia:Article|Article]] so it doesn't show the ":wikipedia:" part in the rendered article the link is in.
Phil Howard wrote:
On Wed, Jul 28, 2010 at 13:10, Huib Laurens sterkebak@gmail.com wrote:
Hello,
You could use interwiki's for that [1] so you can write [[:wikipedia:Article]] and the link will forward you to Wikipedia.
I believe the interwiki Wikipedia is set up by default so [[wikipedia:Article]] will already work
Thanks! This works. I'm using it in the form [[:wikipedia:Article|Article]] so it doesn't show the ":wikipedia:" part in the rendered article the link is in.
You can use the pipe trick for faster editing. Writing [[wikipedia:Article|]] will save as [[wikipedia:Article|Article]] (the leading colon is not needed for this interwiki).
Hi all,
I have been installing many mediawiki wikis over the past few years using a remote mysql server. I do not use the mysql "root" account but instead use another user, which has had the proper privileges to install the database, until version 1.16.0. When I install the mediawiki version 1.16.0 into my document root directory and run the installation, the installation runs fine up to "Granting user permissions..." at which point I get:
Query "GRANT ALL PRIVILEGES ON 'database_name'.* TO 'database_user'@'%' IDENTIFIED BY 'database_password' " failed with error code "Access denied for user mysql_user@mysql_host to database 'database_name' (database_server)".
Just to make sure all was ok I was able to install version 1.15.2 without error.
Have the privilege requirements for the database user privileges changed from 1.15 to 1.16 for installing mediawiki? I did not see any mention of this in the release notes. I am using mysql version 5.1.16-beta.
Any help appreciated...
-Jim
On 04/08/10 21:40, Sullivan, James (NIH/CIT) [C] wrote:
Hi all,
I have been installing many mediawiki wikis over the past few years using a remote mysql server. I do not use the mysql "root" account but instead use another user, which has had the proper privileges to install the database, until version 1.16.0. When I install the mediawiki version 1.16.0 into my document root directory and run the installation, the installation runs fine up to "Granting user permissions..." at which point I get:
Query "GRANT ALL PRIVILEGES ON 'database_name'.* TO 'database_user'@'%' IDENTIFIED BY 'database_password' " failed with error code "Access denied for user mysql_user@mysql_host to database 'database_name' (database_server)".
Just to make sure all was ok I was able to install version 1.15.2 without error.
Have the privilege requirements for the database user privileges changed from 1.15 to 1.16 for installing mediawiki? I did not see any mention of this in the release notes. I am using mysql version 5.1.16-beta.
Any help appreciated...
-Jim
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-lDid to
Did you try installing MediaWiki 1.15.5 to see if anything changed between then and now. Main Question: What permissions does your other user have? For my installs that I host locally, my MediaWiki db users have: SELECT, INSERT, UPDATE, DELETE, CREATE, INDEX, ALTER, LOCK TABLES
The last is only really for locking the database for maintenance etc.
Lewis Cawte
On Wed, Aug 4, 2010 at 4:40 PM, Sullivan, James (NIH/CIT) [C] sullivan@mail.nih.gov wrote:
Have the privilege requirements for the database user privileges changed from 1.15 to 1.16 for installing mediawiki? I did not see any mention of this in the release notes.
Yes, it's in the release notes (though it's buried pretty deep): (bug 20634) The installer-created database user will now have all rights on the database so that upgrades will go more smoothly.
Benjamin Lees wrote:
On Wed, Aug 4, 2010 at 4:40 PM, Sullivan, James (NIH/CIT) [C] sullivan@mail.nih.gov wrote:
Have the privilege requirements for the database user privileges changed from 1.15 to 1.16 for installing mediawiki? I did not see any mention of this in the release notes.
Yes, it's in the release notes (though it's buried pretty deep): (bug 20634) The installer-created database user will now have all rights on the database so that upgrades will go more smoothly.
That should not be run when the user already exists.
On 4 August 2010 23:01, Platonides Platonides@gmail.com wrote:
Benjamin Lees wrote:
On Wed, Aug 4, 2010 at 4:40 PM, Sullivan, James (NIH/CIT) [C] sullivan@mail.nih.gov wrote:
Have the privilege requirements for the database user privileges changed from 1.15 to 1.16 for installing mediawiki? I did not see any mention of this in the release notes.
Yes, it's in the release notes (though it's buried pretty deep): (bug 20634) The installer-created database user will now have all rights on the database so that upgrades will go more smoothly.
That should not be run when the user already exists.
IME, the user rights for MediaWiki frequently need bludgeoning. I routinely end up doing (something like):
GRANT ALL PRIVILEGES ON wikidb.* TO 'wikiuser'@'localhost'; GRANT ALL PRIVILEGES ON wikidb.* TO 'wikiuser'@'%';
- and it seems I need both.
- d.
David Gerard wrote:
IME, the user rights for MediaWiki frequently need bludgeoning. I routinely end up doing (something like):
GRANT ALL PRIVILEGES ON wikidb.* TO 'wikiuser'@'localhost'; GRANT ALL PRIVILEGES ON wikidb.* TO 'wikiuser'@'%';
- and it seems I need both.
You need the first one because mysql comes with a '%'@'localhost' account which takes precedence to any 'foo'@'%' :(
That bug (20634)is about having privilege to create tables. During my 1.16.0 installation tables were successfully created. It was granting the wiki database user "ALL" privilege that was the problem because my database user does not have privilege to do that. I believe in previous versions it granted only [select,insert,update,delete].
Also, I have successfully upgraded a 1.15.1 wiki I've had for a while to 1.16.0 with no problems. The update.php and refreshlinks.php ran ok. So, it would seem I could install a new wiki using 1.15.1 with my current database user's privilege, then update to 1.16.0. Since I could do this, why is the installation requiring a higher privilege for the new wiki's database user? New installs will have users with higher privilege than those who upgraded from older versions. I assume both new and upgraded wikis at version 1.16.0 will run fine, so why the change for new installations?
-Jim
-----Original Message----- From: Benjamin Lees [mailto:emufarmers@gmail.com] Sent: Wednesday, August 04, 2010 5:39 PM To: MediaWiki announcements and site admin list Subject: Re: [Mediawiki-l] installation issue with 1.16.0 - mysql user privilege
On Wed, Aug 4, 2010 at 4:40 PM, Sullivan, James (NIH/CIT) [C] sullivan@mail.nih.gov wrote:
Have the privilege requirements for the database user privileges changed from 1.15 to 1.16 for installing mediawiki? I did not see any mention of this in the release notes.
Yes, it's in the release notes (though it's buried pretty deep): (bug 20634) The installer-created database user will now have all rights on the database so that upgrades will go more smoothly.
_______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
MediaWiki 1.16.0 requires a new table or two, try giving the db user create.
I mentioned the set of 7 or 8 privallages that have worked for me since 1.15.4 in a previous reply, if you can find that, try all of them as well.
-- Lewis Cawte
On 05/08/10 16:32, Sullivan, James (NIH/CIT) [C] wrote:
That bug (20634)is about having privilege to create tables. During my 1.16.0 installation tables were successfully created. It was granting the wiki database user "ALL" privilege that was the problem because my database user does not have privilege to do that. I believe in previous versions it granted only [select,insert,update,delete].
Also, I have successfully upgraded a 1.15.1 wiki I've had for a while to 1.16.0 with no problems. The update.php and refreshlinks.php ran ok. So, it would seem I could install a new wiki using 1.15.1 with my current database user's privilege, then update to 1.16.0. Since I could do this, why is the installation requiring a higher privilege for the new wiki's database user? New installs will have users with higher privilege than those who upgraded from older versions. I assume both new and upgraded wikis at version 1.16.0 will run fine, so why the change for new installations?
-Jim
-----Original Message----- From: Benjamin Lees [mailto:emufarmers@gmail.com] Sent: Wednesday, August 04, 2010 5:39 PM To: MediaWiki announcements and site admin list Subject: Re: [Mediawiki-l] installation issue with 1.16.0 - mysql user privilege
On Wed, Aug 4, 2010 at 4:40 PM, Sullivan, James (NIH/CIT) [C] sullivan@mail.nih.gov wrote:
Have the privilege requirements for the database user privileges changed from 1.15 to 1.16 for installing mediawiki? I did not see any mention of this in the release notes.
Yes, it's in the release notes (though it's buried pretty deep): (bug 20634) The installer-created database user will now have all rights on the database so that upgrades will go more smoothly.
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
On Thu, Aug 5, 2010 at 11:32 AM, Sullivan, James (NIH/CIT) [C] sullivan@mail.nih.gov wrote:
That bug (20634)is about having privilege to create tables. During my 1.16.0 installation tables were successfully created. It was granting the wiki database user "ALL" privilege that was the problem because my database user does not have privilege to do that. I believe in previous versions it granted only [select,insert,update,delete].
Right. Users created through the installer pre-1.16 only had DELETE,INSERT,SELECT,UPDATE,CREATE TEMPORARY TABLES for the database. This meant that if an update involved the creation of new tables, the update would fail. If you're able to upgrade from 1.15 to 1.16 without any problems, you either already ran into this and granted the rest of the privileges to the user, or else you originally created the database/user before running the install script (or I'm misunderstanding what you're doing).
I assume you're putting your existing user in the "Superuser name" field (I'm pretty sure users.sql is only used if you've checked the "Use superuser account" box). Users can only grant permissions they have; if your existing user doesn't have all rights on the new database, it won't be able to grant them to the new user it's creating. Of course, if it has the necessary rights to create a new database, surely it ought to have all rights on that database: does someone know if there's a quirk in MySQL's behavior here?
From: Benjamin Lees [mailto:emufarmers@gmail.com] Sent: Thursday, August 05, 2010 2:16 PM To: MediaWiki announcements and site admin list Subject: Re: [Mediawiki-l] installation issue with 1.16.0 - mysql user privilege
Right. Users created through the installer pre-1.16 only had DELETE,INSERT,SELECT,UPDATE,CREATE TEMPORARY TABLES for the database. This meant that if an update involved the creation of new tables, the update would fail. If you're able to upgrade from 1.15 to 1.16 without any problems, you either already ran into this and granted the rest of the privileges to the user, or else you originally created the database/user before running the install script (or I'm misunderstanding what you're doing).
I installed the (pre-1.16.0) wikis using a "superuser" account, but it does not have all the privileges of the mysql root account. I installed wikis over many years just fine using that account, until I tried to install a 1.16.0 wiki, when I ran into this issue. Databases were not created in advance. When I update from 1.15.1 to 1.16.0 I have no errors and I use the same superuser account used to install the wiki. I have checked my logs, which I keep when I run update.php and refreshlinks.php, and no errors are seen. I also see many tables being created, like "user_properties" table and "log_search" table, so its not an issue of the superuser account creating tables.
I assume you're putting your existing user in the "Superuser name"
field (I'm pretty sure users.sql is only used if you've checked the "Use superuser account" box).
Right, checking superuser and using my mysql account, which has almost all privileges as root.
Users can only grant permissions they
have; if your existing user doesn't have all rights on the new database, it won't be able to grant them to the new user it's creating.
Yes, I think this is the problem, that my superuser is missing a privilege or two. Since the error is trying to add "ALL" privilege to the database_user, you would pretty much have to use the mysql root account to do the installation, which is likely the way most if not all installers do it. I have a security conscious mysql admin so the superuser account I have does not have ALL privilege.
But it seems strange that the 1.16.0 installation wants to give ALL privilege to the database_user it creates when it does not need ALL privilege, as proved by my ability to run update.php to upgrade from 1.15.1 to 1.16.0. I'm guessing they are planning for the future since it is not necessary now.
-Jim
Sullivan, James (NIH/CIT) [C] wrote:
Yes, I think this is the problem, that my superuser is missing a privilege or two. Since the error is trying to add "ALL" privilege to the database_user, you would pretty much have to use the mysql root account to do the installation, which is likely the way most if not all installers do it. I have a security conscious mysql admin so the superuser account I have does not have ALL privilege.
But it seems strange that the 1.16.0 installation wants to give ALL privilege to the database_user it creates when it does not need ALL privilege, as proved by my ability to run update.php to upgrade from 1.15.1 to 1.16.0. I'm guessing they are planning for the future since it is not necessary now.
-Jim
That's what bug 20634. In some cases there were problems in updates due to not being able to CREATE/ALTER tables, thus what r56285 does.
Give the installer-created database user CREATE TABLE and ALTER TABLE rights so that upgrades will go more smoothly
-----Original Message----- From: Platonides [mailto:Platonides@gmail.com] Sent: Thursday, August 05, 2010 7:25 PM To: mediawiki-l@lists.wikimedia.org Subject: Re: [Mediawiki-l] installation issue with 1.16.0 - mysql user privilege
That's what bug 20634. In some cases there were problems in updates due to not being able to CREATE/ALTER tables, thus what r56285 does.
Give the installer-created database user CREATE TABLE and ALTER TABLE rights so that upgrades will go more smoothly
================================
I understand that part. What I don't understand is when I upgrade a wiki, for example from 1.15.1 to 1.16.0, the wiki's database user is not granted ALL privilege during the upgrade process as is done during a fresh 1.16.0 install. I know this because I was able to update a wiki to 1.16.0 successfully, including running update.php, using my mysql user account, which is not the root account and does not have permission to grant a database user "ALL" privilege, which is why I get the error during a fresh i.16.0 install.
So if I have two wikis, one upgraded to 1.16.0 from an old version, and a 1.16.0 that was freshly installed, their database users have different privileges, with the freshly installed wiki's database user having ALL privileges and the upgraded wiki's database user having whatever privileges were given it during its creation with an older version of mediawiki, presumably less than ALL. The question I have is whether this will lead to problems in the future, such as upgrade to version 1.17.0, where the database user may be assumed to have ALL privileges.
In other words, during the upgrade of a wiki to version 1.16.0, should update.php grant the database user ALL privileges as part of its update of the database, so that the database user has the same privileges as a newly installed wiki's database user? Or am I missing something and both upgraded and freshly created database users do have the same privileges?
-Jim
Sullivan, James (NIH/CIT) [C] wrote:
The question I have is whether this will lead to problems in the future, such as upgrade to version 1.17.0, where the database user may be assumed to have ALL privileges.
Depends on what is needed on upgrade to that future version. It's just a safeguard for the future.
In other words, during the upgrade of a wiki to version 1.16.0, should update.php grant the database user ALL privileges as part of its update of the
database,
so that the database user has the same privileges as a newly installed
wiki's
database user? Or am I missing something and both upgraded and freshly
created
database users do have the same privileges?
Giving extra rights on 1.16 upgrade would be no easier than doing it in that future version, if it was allowed. Thus, the upgrade doesn't unnecesarily try to enlarge the user rights, which are not currently needed.
On 10-08-04 04:40 PM, Sullivan, James (NIH/CIT) [C] wrote:
Query "GRANT ALL PRIVILEGES ON 'database_name'.* TO 'database_user'@'%' IDENTIFIED BY 'database_password' " failed with error code "Access denied for user mysql_user@mysql_host to database 'database_name' (database_server)".
To avoid this situation -- which is kinda weird IMHO.. I wouldn't expect a web app user to be able to grant privileges.. -- you should create the user 'database_user' in your database before running the installer
mediawiki-l@lists.wikimedia.org