Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: Wikipedia: Mediawiki

importing users/passwords from another database into mediawiki mysql db

 

 

Wikipedia mediawiki RSS feed   Index | Next | Previous | View Threaded


youngi at comcast

Dec 8, 2005, 4:13 PM

Post #1 of 2 (1067 views)
Permalink
importing users/passwords from another database into mediawiki mysql db

Hi,

I didn't see anything on the faq of an easy way to do this but here is my
situation:

I would like to import users from another sql database into the mysql
database for one of my wiki sites.

I already have the query that grabs the usernames/password in a txt file
from the sql database, but I'm not sure how to properly insert them into the
wiki db as normal users or sysops. Ideally only a few of these users will
have sysop permissions and the rest will be regular users.

Also when a password is changed in the sql db, I will need to change it in
the wiki db(will have to code the condition that compares passwords of
course). When a user is deactivated in the sql db(another condition I will
have to code to check to see if that user exists in the wiki user table) I
would like to scramble that users password since you can't simply delete a
user. I would also like to automate this process on a nightly basis.

Is this at all possible? We can definitely code this if it is possible since
we have a couple of developers in house.

Thanks in advance for any assistance.

-Isaac
----- Original Message -----
From: "HumanCell .org" <humancell [at] gmail>
To: <mediawiki-l [at] Wikimedia>
Sent: Thursday, December 08, 2005 3:56 PM
Subject: [Mediawiki-l] importing public databases into mediawiki


I'd like to import a public database into my mediawiki, where each
*row* of the database corresponds to a new article.

Here's a simple example to clarify:

ID Name Height Weight
Row1 fred 150 100
Row2 bill 210 55

After importing this DB I'd have two new articles (title: fred and bill)
- the fred article has an infobox with parameters 150 and 100
- the bill article has an infobox with parameters 210 and 55

My databases have thousands of entries...so an automated approach is
necessary. Has this been done before? Anyone got any ideas?

Thanks.
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l [at] Wikimedia
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l

_______________________________________________
MediaWiki-l mailing list
MediaWiki-l [at] Wikimedia
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l


robchur at gmail

Dec 8, 2005, 11:59 PM

Post #2 of 2 (975 views)
Permalink
Re: importing users/passwords from another database into mediawiki mysql db [In reply to]

It's all possible. Users and user rights are in the user and
user_groups tables. Google for "MediaWiki md5 password" to find out
the correct means for hashing up a password and remember group names
in the user_groups table are all lowercase.


Rob Church

On 09/12/05, Isaac Gonzalez <youngi [at] comcast> wrote:
> Hi,
>
> I didn't see anything on the faq of an easy way to do this but here is my
> situation:
>
> I would like to import users from another sql database into the mysql
> database for one of my wiki sites.
>
> I already have the query that grabs the usernames/password in a txt file
> from the sql database, but I'm not sure how to properly insert them into the
> wiki db as normal users or sysops. Ideally only a few of these users will
> have sysop permissions and the rest will be regular users.
>
> Also when a password is changed in the sql db, I will need to change it in
> the wiki db(will have to code the condition that compares passwords of
> course). When a user is deactivated in the sql db(another condition I will
> have to code to check to see if that user exists in the wiki user table) I
> would like to scramble that users password since you can't simply delete a
> user. I would also like to automate this process on a nightly basis.
>
> Is this at all possible? We can definitely code this if it is possible since
> we have a couple of developers in house.
>
> Thanks in advance for any assistance.
>
> -Isaac
> ----- Original Message -----
> From: "HumanCell .org" <humancell [at] gmail>
> To: <mediawiki-l [at] Wikimedia>
> Sent: Thursday, December 08, 2005 3:56 PM
> Subject: [Mediawiki-l] importing public databases into mediawiki
>
>
> I'd like to import a public database into my mediawiki, where each
> *row* of the database corresponds to a new article.
>
> Here's a simple example to clarify:
>
> ID Name Height Weight
> Row1 fred 150 100
> Row2 bill 210 55
>
> After importing this DB I'd have two new articles (title: fred and bill)
> - the fred article has an infobox with parameters 150 and 100
> - the bill article has an infobox with parameters 210 and 55
>
> My databases have thousands of entries...so an automated approach is
> necessary. Has this been done before? Anyone got any ideas?
>
> Thanks.
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-l [at] Wikimedia
> http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
>
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-l [at] Wikimedia
> http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
>
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l [at] Wikimedia
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l

Wikipedia mediawiki RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact Gossamer Threads
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.