robchur at gmail
Dec 8, 2005, 11:59 PM
Post #2 of 2
(657 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
|
