Mailing List Archive: Wikipedia: Mediawiki

Use MySQL for User Login

Index | Next | Previous | View Threaded

rossxunix at yahoo

Nov 24, 2009, 2:07 PM

Post #1 of 9 (1204 views)
Permalink

Use MySQL for User Login

Greetings,

I have an existing MySQL database for my customer portal website which includes customers' account info (usernames, and passwords).

Now, I am configuring my MediaWiki on another machine in the same LAN for customers. How could I make use of the existing customer portal MySQL database for my MW user authentication?

It seems the extension "Auth viaMySQL" could do a similar job, but it's for the same website (same machine), requires special login/logout script files for the website, and does NOT tell where/how to connect the existing database.

What's the trick to use this extension for a MW on a different machine? Or, is there another way to do user authentication over MySQL?

Thanks in advance,
Ross

__________________________________________________________________
Looking for the perfect gift? Give the gift of Flickr!

http://www.flickr.com/gift/
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l [at] lists
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l

Platonides at gmail

Nov 24, 2009, 2:59 PM

Post #2 of 9 (1141 views)
Permalink

Re: Use MySQL for User Login [In reply to]

Ross Xu wrote:
> Greetings,
>
> I have an existing MySQL database for my customer portal website which includes customers' account info (usernames, and passwords).
>
> Now, I am configuring my MediaWiki on another machine in the same LAN for customers. How could I make use of the existing customer portal MySQL database for my MW user authentication?
>
> It seems the extension "Auth viaMySQL" could do a similar job, but it's for the same website (same machine), requires special login/logout script files for the website, and does NOT tell where/how to connect the existing database.
>
> What's the trick to use this extension for a MW on a different machine? Or, is there another way to do user authentication over MySQL?
>
> Thanks in advance,
> Ross

Create an auth plugin, it will be easier
http://www.mediawiki.org/wiki/AuthPlugin

_______________________________________________
MediaWiki-l mailing list
MediaWiki-l [at] lists
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l

rossxunix at yahoo

Nov 24, 2009, 8:00 PM

Post #3 of 9 (1143 views)
Permalink

Re: Use MySQL for User Login [In reply to]

Thank you Platonides for your help, but it seems the auth plugin is for a website which already has authentication.
However, my MW is on another machine/website which does NOT have authentication.

MachineA is my customer portal website, and is using a mysql database for user login.
MachineB is my MediaWiki, and its main website does NOT need any authentication.
What I want is to make use of the user account database on MachineA for my MW's authentication on MachineB.

Is the auth plugin used for this kind of scenario?
Thanks again,
Ross

--- On Wed, 11/25/09, Platonides <Platonides [at] gmail> wrote:

From: Platonides <Platonides [at] gmail>
Subject: Re: [Mediawiki-l] Use MySQL for User Login
To: mediawiki-l [at] lists
Received: Wednesday, November 25, 2009, 6:59 AM

Create an auth plugin, it will be easier
http://www.mediawiki.org/wiki/AuthPlugin

__________________________________________________________________
Yahoo! Canada Toolbar: Search from anywhere on the web, and bookmark your favourite sites. Download it now
http://ca.toolbar.yahoo.com.
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l [at] lists
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l

daniel at brightbyte

Nov 25, 2009, 12:08 AM

Post #4 of 9 (1137 views)
Permalink

Re: Use MySQL for User Login [In reply to]

Ross Xu schrieb:
> MachineA is my customer portal website, and is using a mysql database for user login.
> MachineB is my MediaWiki, and its main website does NOT need any authentication.
> What I want is to make use of the user account database on MachineA for my MW's authentication on MachineB.
>
> Is the auth plugin used for this kind of scenario?

yes, that is exactly what it is intended for. it can use pretty much any
authentication mechanism, on any machine.

-- daniel

_______________________________________________
MediaWiki-l mailing list
MediaWiki-l [at] lists
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l

rossxunix at yahoo

Nov 25, 2009, 12:09 PM

Post #5 of 9 (1138 views)
Permalink

Re: Use MySQL for User Login [In reply to]

--- On Wed, 11/25/09, Daniel Kinzler <daniel [at] brightbyte> wrote:

> yes, that is exactly what it is intended for. it can use pretty much any
> authentication mechanism, on any machine.
Sorry, I still don't get it, acctually am more confusing.

On the auth plugin page http://www.mediawiki.org/wiki/AuthPlugin, it tells two kinds of plugins -- one is "Existing authentication plugins", and the other is "Creating new authentication plugins".
The first one directs to Category:User identity extensions, which includes all different kind of extensions (and the Auth viaMySQL extension).
The second one asks people to "write your own plugin", which is obviously not what I could do because I am not good at PHP coding.

So, which one matches my need most?
Thanks,
Ross

__________________________________________________________________
Yahoo! Canada Toolbar: Search from anywhere on the web, and bookmark your favourite sites. Download it now
http://ca.toolbar.yahoo.com.
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l [at] lists
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l

Platonides at gmail

Nov 25, 2009, 2:22 PM

Post #6 of 9 (1137 views)
Permalink

Re: Use MySQL for User Login [In reply to]

Ross Xu wrote:
>> yes, that is exactly what it is intended for. it can use pretty much any
>> authentication mechanism, on any machine.
> Sorry, I still don't get it, acctually am more confusing.
>
> On the auth plugin page http://www.mediawiki.org/wiki/AuthPlugin, it tells two kinds of plugins -- one is "Existing authentication plugins", and the other is "Creating new authentication plugins".
> The first one directs to Category:User identity extensions, which includes all different kind of extensions (and the Auth viaMySQL extension).
> The second one asks people to "write your own plugin", which is obviously not what I could do because I am not good at PHP coding.
>
> So, which one matches my need most?
> Thanks,
> Ross

There doesn't seem to be an existing auth plugin doing what you want, so
you need the second one. If you are not able to make it yourself, you
would need to get someone to make it for you.

_______________________________________________
MediaWiki-l mailing list
MediaWiki-l [at] lists
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l

rossxunix at yahoo

Nov 26, 2009, 8:23 AM

Post #7 of 9 (1122 views)
Permalink

Re: Use MySQL for User Login [In reply to]

--- On Thu, 11/26/09, Platonides <Platonides [at] gmail> wrote:
> There doesn't seem to be an existing auth plugin doing what you want, so
> you need the second one. If you are not able to make it yourself, you
> would need to get someone to make it for you.

Gotcha.
Thank you, Platonides.
Ross

__________________________________________________________________
Yahoo! Canada Toolbar: Search from anywhere on the web, and bookmark your favourite sites. Download it now
http://ca.toolbar.yahoo.com.
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l [at] lists
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l

rossxunix at yahoo

Nov 26, 2009, 5:04 PM

Post #8 of 9 (1117 views)
Permalink

Re: Use MySQL for User Login [In reply to]

Actually, an idea just came to my mind ...

As we all know, MediaWiki uses MySQL ($wgDBname) for authentication by default already.
If we could let user login query go to another database, instead of the default one $wgDBname, that would solve the problem, and it is much easier and simpler than using the Auth viaMySQL extension.

The question is ...
How could we simply redirect the login query to another database?

Thanks again,
Ross

__________________________________________________________________
Make your browsing faster, safer, and easier with the new Internet Explorer® 8. Optimized for Yahoo! Get it Now for Free! at http://downloads.yahoo.com/ca/internetexplorer/
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l [at] lists
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l

Platonides at gmail

Nov 28, 2009, 6:45 AM

Post #9 of 9 (1093 views)
Permalink

Re: Use MySQL for User Login [In reply to]

Ross Xu wrote:
> Actually, an idea just came to my mind ...
>
> As we all know, MediaWiki uses MySQL ($wgDBname) for authentication by default already.
> If we could let user login query go to another database, instead of the default one $wgDBname, that would solve the problem, and it is much easier and simpler than using the Auth viaMySQL extension.
>
> The question is ...
> How could we simply redirect the login query to another database?
>
> Thanks again,
> Ross

http://www.mediawiki.org/wiki/Manual:Configuration_settings#Shared_DB_settings
However, that won't work since your table won't have the data in the
same format as MediaWiki. You need an auth plugin.

_______________________________________________
MediaWiki-l mailing list
MediaWiki-l [at] lists
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads