[TriLUG] Migrating Gallery (was mysql question)
Lance A. Brown
lance at bearcircle.net
Mon Aug 20 08:31:09 EDT 2007
Somewhere in the development of MySQL, I'm not sure which exact version,
they changed up the encryption of passwords in the mysql user table.
Migrating a mysql install from an older version to a new/current version
of MySQL requires you to update the passwords using the new encryption
technology or use the old_password function to re-enter the passwords
using the old technology properly stored in the "new" tables.
I've had to make this correction several times over the last year or so.
Roy Vestal said the following on 8/19/2007 8:28 PM:
> I want to ammend my previous email. I'm migrating a website that uses
> Gallery 2 and MySQL to a new server. I was not able to solve the problem
> below, so I archived the gallery and started a new one using gallery. I
> told it to use the existing tables. It was able to find the layout but
> the pics aren't showing up.
> Anyone run into this with Gallery?
Celebrate The Circle http://www.celebratethecircle.org/
Carolina Spirit Quest http://www.carolinaspiritquest.org/
My LiveJournal http://www.livejournal.com/users/labrown/
GPG Fingerprint: 409B A409 A38D 92BF 15D9 6EEE 9A82 F2AC 69AC 07B9
More information about the TriLUG