List:General Discussion« Previous MessageNext Message »
From:Johnny Withers Date:July 19 2009 9:11pm
Subject:Re: Logins, php, legacy, old password
View as plain text  
You should add an account the old software/scripts can use to access the new
MySQL server. Simply add the account then update the password using the
OLD_PASSWORD function.

http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html#function_old-password




On Sun, Jul 19, 2009 at 1:03 PM, Scott Haneda <talklists@stripped> wrote:

> Hello. It is time for some long overdue service consolidation on my end.
>
> I have a production machine ready to go, running the latest MySql 5 series.
>
> I have a legacy machine running MySql 4. As you know, version 4 used an
> older user account password system.
>
> I also will be up against some data import/export changes. Specifically I
> think the timestamp column changed.
>
> I want to move the data from 4 to 5. Here is my problem.
>
> The http server that talks to MySql is ancient, unable to be updated. Http
> will remain on this legacy machine talking to MySql, using an equally
> ancient scripting language that does not, and can not support the new
> password format. This http server does not support MySql, so a local copy is
> not an option.
>
> I believe I will need to set old style passwords. I'm trying to avoid
> multiple machines or multiple instances of MySql on the same database
> server.
>
> What are my options? I'll do the work to convert the data. This means
> scripting code that displays and formats timestamp data is going to break. I
> can dig deep into my long term memory and change the scripting code to solve
> the timestamp issues.
>
> Are there other major issues besides timestamps? All inserts used NOW(), so
> I'm ok there. But display of timestamp to the user needs editing. It's
> controlled by a function so I should have a pretty easy go.
>
> But what about the passwords? I hear php 5 will not do old style passwords
> at all. So I can not just set old style passwords to accomodate my legacy
> systems.  Don't really want to either.
>
> What I would like is to set old style passwords on a per account basis, but
> have the default be new methods. I suspect by nature of how this works that
> is not possible.
>
> I'm really trying to consolidate. Yes, I can run a second server, but I
> would rather manage and maintain one, giving me the ability to retire a
> machine.
> --
> Scott
> Iphone says hello.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>


-- 
-----------------------------
Johnny Withers
601.209.4985
johnny@stripped

Thread
Logins, php, legacy, old passwordScott Haneda19 Jul
  • Re: Logins, php, legacy, old passwordJohnny Withers19 Jul