Erin Spiceland wrote:
I'm using mediawiki on a site that employs three
other web apps that
require authentication. I'm trying to write a register script that will
insert the desired authentication and profile data into all 3 apps'
databases at the same time, so that users won't have to register 3
separate times. I've got it working on both of the other apps, but
mediawiki says that the username doesn't exist when I can clearly see it
in the table.
Can you provide some details of what, exactly, you're putting into the
database and how?
I think it has something to do with my values of
"" that
I'm putting in the user_token and/or user_touched fields.
Unlikely; it should work fine with either blank.
-- This is a timestamp which is updated when a user
-- logs in, logs out, changes preferences, or performs
-- some other action requiring HTML cache invalidation
-- to ensure that the UI is updated.
user_touched char(14) binary NOT NULL default '',
-- A pseudorandomly generated value that is stored in
-- a cookie when the "remember password" feature is
-- used (previously, a hash of the password was used, but
-- this was vulnerable to cookie-stealing attacks)
user_token char(32) binary NOT NULL default '',
It's more likely that you've got a problem with an invalid name in the
user_name field, or perhaps some weird bogus user_id. Note that the
user_name field is stored with spaces, not underscores, and an initial
letter must be capitalized.
I just successfully tested a minimal user addition on my 1.5 test
installation (should be same on all prior release versions):
insert into user (user_name) values('Blargy');
update user set user_password=md5(concat(user_id,'-',md5('wonko')))
where user_name='Blargy';
-- brion vibber (brion @
pobox.com)