Re: [Newbie] MySQL "PASSWORD" in WO?
Re: [Newbie] MySQL "PASSWORD" in WO?
- Subject: Re: [Newbie] MySQL "PASSWORD" in WO?
- From: Ray Ackland <email@hidden>
- Date: Sat, 1 May 2004 10:29:17 +1200
Lucas,
You specify the user name and password in the EOModel (in EOModeler)
either at the time you create the model, or afterwards using the
inspector on the top level node of the model. I believe it is normally
set to be user:mysql & password being blank. Of course the only
requirement is that it matches what you have set the db to be.
Just think of WO being one user (which then passes data onto everyone
accessing your apps). You just need one account for this user.
I don't *believe* there will be a normal time you need to worry about
creating users and passwords (for accessing the db) from within your WO
app. If you are thinking along the lines of creating users and
passwords to use your app (as opposed to MySQL) then there are several
approaches depending on what level of security you desire.
Personally, I just have a table called users or similar, which is based
on three fields - name, password, and obligatory primary key. When a
user wishes to log in to the app, they enter their user name and
password, and I do a fetch on this mentioned table (through WO - not
directly to MySQL) with a qualifier specifying those details. If the
number of returned results is 1, then this is the record for that user.
Knowing only a little about php, and twice as much about WO, my only
advice would be to try and forget that you are dealing with databases
at all. Just concentrate on entities and relationships and have faith
that WO will be your highly trained assistant who will do the hard
tasks (well, as soon as you figure out how to speak its language :).
R.
On 1/05/2004, at 7:56, Lucas Haley wrote:
So, once again, I'm coming from a PHP background. When creating logins
and members, I have used the MySQL method PASSWORD() to encrypt the
passwords in the database. Is there a convenient way of doing this in
WO? I've tried making a FetchSpecification in EOModeler, but had to
end up using the raw SQL panel to add the PASSWORD() call.
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.