Welcome Guest Login Register Member List
ExpressionEngine Forums
Advanced Search
Username: Password:
Remember Me? forgot password?
You are here: Forum Home  >  Usage  >  Troubleshooting  >  Thread
   
 
problems on rake during populating of database schema
 
ocho_aces
Posted: 13 March 2009 07:42 PM   [ Ignore ]  
Newbie
Rank
Total Posts:  3
Joined  2009-03-13

Hi,

I’m getting an error at the “rake db:migrat ...” step.  I get the following message:
“client does not support authentication protocol requested by server; consider upgrading mysql client”

Can anyone help?  What is the mysql client?  Can there be more than 1?

I’m completely new to the whole ruby/rails environment.  I’ve spent a good deal of hours (part masochism, part curiousity) trying to get Tracks running.  I’m on Windows using the latest InstantRails, Tracks 1.7, and Firefox.  I had to do a rake install just prior to the ‘rake’ command and so I should also have the latest rake.  I’ve set up the installation to use mysql as well.

I’m following the regular installation procedure pretty much to the letter.  I used phpAdmin to create the tracks database as wells as the user and to set up all the privileges.

Thanks in advance,
Jose

Profile
 
ocho_aces
Posted: 13 March 2009 09:41 PM   [ Ignore ]   [ # 1 ]  
Newbie
Rank
Total Posts:  3
Joined  2009-03-13

It appears that I found a solution that allowed me to get past this problem.  It involves the following steps:

The password for user tracks@localhost needs to be set to pre-4.1 format by doing the following:

1)  modify the database.yml file by modifying the production password.  Set it to ‘pwd’ (no quotes).

2)  from this link http://dev.mysql.com/doc/refman/5.0/en/old-client.html, I tried their suggestion #3 by typing the following exactly at a mysql prompt:

shell > mysql -u root -p
mysql > SET PASSWORD FOR
      -> ‘tracks’@’%’ = OLD_PASSWORD(‘pwd’);
mysql > quit
shell   > rake db:migrate RAILS_ENV=production

This will now work just fine.

Profile
 
ocho_aces
Posted: 13 March 2009 09:55 PM   [ Ignore ]   [ # 2 ]  
Newbie
Rank
Total Posts:  3
Joined  2009-03-13

Thank you Tracks folks!!  My Tracks app works with InstantRails!!

I’ve got the app running in my browser now!  I will copy it over to a USB stick this weekend and it should work on that without any other mods, I think.

I’ll be documenting my notes and what I had to do to make this work.  I couldn’t find any step-by-step instructions like for the UniformServer install.  But I did follow the notes in there as well as the regular Installation instructions on the Tracks site to guide me along.

Do you all want a copy of my notes when I get them polished up?

Profile
 
Reinier Balt
Posted: 14 March 2009 05:26 PM   [ Ignore ]   [ # 3 ]  
Sr. Member
RankRankRankRank
Total Posts:  580
Joined  2006-10-05

nice find! good to see that you were able to get Tracks running.

Yes, please contribute your notes. If you like, you can put them on the Wiki.

Profile
 
   
 
 
‹‹ Email Integration on 1.7 with ActionMailer -- delivery failed      Google Agenda iCal ››

Powered By ExpressionEngine
Template Design By Sonnenvogel.com
Select a theme:

ExpressionEngine Discussion Forum - Version 2.1.2 (20091002)
Script Executed in 0.1095 seconds

Atom Feed
RSS 2.0