Miles Scruggs wrote:
>>> How can I reset the password for the admin user. I'm trying to upgrade
>>
>> an
>>
>>> old database of midgard from an unknown version. I tried using both the
>>> password function within mysql and using just plain text but I can't
>>
>> login
>>
>>> with either of these
>>
>> In older versions that where sitegroup-enabled you would login in with:
>>
>> username: admin*
>> password: password
>>
>> in 1.4, and the later 1.4 beta releases you should use:
>>
>> username: admin
>> password: password
>>
>> so without the * appended. It seems more likely that this is your problem
>> then the change of the password, as it should have remained the same as
>> you had before the upgrade.
>>
>> PLEASE NOTE:
>>
>> With version 1.4 we now are actively using repligard. Repligard uses a
>> table in the database to keep track of changes. Making changes directly
>> to SQL are a sure way to get an out-of-sync repligard table, which may
>> cause hard to track problems in replication later. So if you can at all
>> avoid it, do not manipulate midgard database content directly in MySQL.
>> If you feel you have to, please consult on this list first. Maybe (just
>> maybe) Alexander can give you some hints on keeping the repligard table
>> in sync.
>>
>> Armand.
>>
> Ok well what would be the best practice to restore a old midgard database in
> various stages of upgrade (I have tried at various points to upgrade the
> midgard database so I can't say that it is from version x )? The only data
> that I for one host. Should I just start with a fresh midgard database and
> some how bring in the old data, or can I start with the old database and
> upgrade it? I did try to upgrade it using the upgrade script at install
> time, but it barffed a number of errors about the sitegroup tables being
> there already, since I had tried to previously upgrade it. As of right now
> I cannot tell if the midgard database is working or not because as specified
> in my previous email I cannot login as administrator because I do not
> remember the old admin password and during upgrad it did not reset to
> "password". I would first like to fix this password problem and check to
> see how much of the database made it through the upgrade process, then move
> from there.
OK, at your own risk, you can update the person table:
update person set password='**yourclearpassword' where id=N;
don't forget the **.
If this is an old database with sitegroups enabled, and your sites are
not in SG0, you can try a little script of mine that's in the cds under
the directory midgard/data/xsg
Read the README, set the xsg.conf to your system prefs, and run xsg.
Once you have extracted the sitegroups, you can install a new DB with
the old admin and Asgard, create the sitegroup records with their
admingroups and admin user, and reimport the sitegroups back in the new DB.
This script has not been heavily tested, so USE IT AT YOUR OWN RISK, and
DO BACKUPS before doing anything else...
Good luck ;)
>
> Miles
>
David Guerizec
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
