Rails - Oct 2005 - Re: mySQL command line within rails - access denied? [solved]

--- Alex Young <alex-qV/boFbD8Meu8LGVeLuP/g@public.gmane.org>
wrote:
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
> Have you installed MySQL on top of an old installation?  There was a
> change in password formats between version 4.0 and 4.1 that could cause
> that.
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
Ah, yes I have - I used to have 4 installed on here. Then I saw I had 2
instances of 4.1 running
as well (I had some installation issues). I removed both of them and now things
are screwy, not
surprisingly. I will remove all and reinstall.
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
> mysql -u dave depot_development < db/create.sql
> 
> If I''ve read what you''ve done correctly, that should do
it.
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
I tried that before uninstalling old installs of mysql and it worked perfectly
:). Thanks so much
for the help Alex, I think once I re-install 4.1 I''ll be able to get
this running correctly!

Tom



http://www.pixelmech.com/

A man spoke frantically into the phone: "My wife is pregnant and her
contractions are only two minutes apart"! "Is this her first
child?" the doctor asked. "No, you idiot!" the man shouted.
"This is her husband!"

Q: What do you call a muddy chicken who crossed the road two times?
A: A dirty double crosser...

Tom Dell''Aringa wrote:
> I tried that before uninstalling old installs of mysql and it worked
perfectly :). Thanks so much
> for the help Alex, I think once I re-install 4.1 I''ll be able to
get this running correctly!
Tom,

  Nice to see one of the old-school Evolters on the Rails list :) Your 
issue sounds like the mysql old_password incompatibility with pre 4.1 
clients.  You can try running this for the user you''re trying to
connect
with:

SET PASSWORD FOR ''my_user''@''localhost'' =
OLD_PASSWORD(''my_pass'');

Now that I think about it, I haven''t run into that problem since
I''ve
been developing in rails.  Not sure if it''s connected or not, but
that''s
solved the same problem for me numerous times doing PHP dev.

Cheers,
Stephen

--- Stephen Caudill <vox-rUtwbJCiuDxWk0Htik3J/w@public.gmane.org>
wrote:
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
> Nice to see one of the old-school Evolters on the Rails list :) Your 
> issue sounds like the mysql old_password incompatibility with pre 4.1 
> clients.  You can try running this for the user you''re trying to
connect
> with:
> 
> SET PASSWORD FOR ''my_user''@''localhost''
= OLD_PASSWORD(''my_pass'');
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
Hey Stephen :) It truly is a small world sometimes! You and Alex both mention
this, and I wonder
if this is part of my new problem or something else.

I uninstalled ALL mySQL''s from my machine. Restarted. Re-installed 4.1.
I had to run it on port
3307 since something is already running on 3306, but I think I was already doing
that. In order to
get mySQL to execute and run as a service, I had to change the name of the
service from the
default ''mySQL'' to something else.[1]

I re-did the grant statements and successfully ran the create.sql script. When I
hit the server I
get the following message:

"No connection could be made because the target machine actively refused
it. - connect(2)"
The server log shows:
127.0.0.1 - - [13/Oct/2005:08:59:41 Central Daylight Time] "GET /admin
HTTP/1.1" 500 5184
- -> /admin

I also got this when I tried to redo my scaffolding

Other errors on the admin page are:

/app/controllers/admin_controller.rb:8:in `list''
/app/controllers/admin_controller.rb:3:in `index''
script/server:49

So, something got ''disconnected'' or something during the
reinstall..I''m wondering if it has
something to do with the mysql service name? I''ve dug around, tried to
redo as much of the process
as possible (I think I''ve basically redone it all...) but
can''t seem to resolve this.

All in all though..loving rails!


[1] http://www.faqts.com/knowledge_base/view.phtml/aid/33006/fid/185


http://www.pixelmech.com/

A man spoke frantically into the phone: "My wife is pregnant and her
contractions are only two minutes apart"! "Is this her first
child?" the doctor asked. "No, you idiot!" the man shouted.
"This is her husband!"

Q: What do you call a muddy chicken who crossed the road two times?
A: A dirty double crosser...