Project

General

Profile

Forums » Help »

Installation...problem installing mysql gem

Added by Kristylee g over 14 years ago

I'm sure there is info on this somewhere but none of what i found seems to be of help. New to Ruby and redmine.

But problem i'm having...

when i get to the step (RAILS_ENV=production rake db:migrate) I get the following error:

!!! The bundled mysql.rb driver has been removed from Rails 2.2. Please install the mysql gem and try again: gem install mysql.
rake aborted!
no such file to load -- mysql

when I run gem install mysql, it says that it is installed with these errors...

Building native extensions. This could take a while...
Successfully installed mysql-2.8.1
1 gem installed
Installing ri documentation for mysql-2.8.1...

No definition for next_result

No definition for field_name

No definition for field_table

(etc)

I assume at this point that it is installed but when i run the previous code again, i get the same error, that the gem is not installed.

any help would be appreciated! I've been searching everywhere for a fix and not getting anywhere. Very much a newbie!


Replies (6)

RE: Installation...problem installing mysql gem - Added by Felix Schäfer over 14 years ago

  1. what distribution, package or source, what ruby, rails, redmine versions?
  2. did you install the gem as root?

(yes, the gem is correctly installed and the bitching about no definition is just documentation related, nothing serious).

RE: Installation...problem installing mysql gem - Added by Kristylee g over 14 years ago

Rails 2.3.5

ruby 1.8.7 (2009-06-08 patchlevel 173) [x86_64-linux]

Redmine 1.0.0 from here...http://rubyforge.org/frs/?group_id=1850

I did not install as a root. My client's hosting service is not the best and I had to appeal for ssh access to begin with. I tried logging in once as "sudo" ( I think this is what you mean by root but if not correct me) and was denied. I would imagine I would need to fight with them for that.

I also ran a command to list the gems installed and did not see the gem on the list. I'm confused why it says that it is installed and then does not seem to be there.

RE: Installation...problem installing mysql gem - Added by Kristylee g over 14 years ago

Correction: It may be on the list.

mysql (2.8.1, 2.7.3)
mysql-inspector (0.0.6)
mysql-xml (0.1.1)
mysql2 (0.1.9)
mysql_backup (0.2.1)
mysql_incremental_query (0.0.2)
mysql_mirror (0.1.3)
mysql_replication_adapter (0.4.0)
mysql_replication_monitor (0.1.6)
mysql_replication_status (0.1.3)
mysql_retry_lost_connection (0.0.1)
mysql_s3_backup (0.0.1)
mysql_schema_bulk_change (0.2.0)
mysql_view_support (0.2.0)
mysql_warmer (0.1.1)
mysqlplus (0.1.2)

The first one is what I am looking for correct? Nonetheless, when I run the rake, it still says it is not installed.

RE: Installation...problem installing mysql gem - Added by Felix Schäfer over 14 years ago

I think that's something you'll have to solve with your hosting service's support. I guess your gempaths or whatever are wrong, but I'm not knowledgeable enough in that field to be able to help you in any meaningful way.

RE: Installation...problem installing mysql gem - Added by Kristylee g over 14 years ago

gempaths? I don't really know what that means.

Anyone else having this issue or have any suggestions? Would it help to get sudo access and install in root?

RE: Installation...problem installing mysql gem - Added by Felix Schäfer over 14 years ago

Again, please contact your hosting provider's support, they should better be able to help you. Anyway, you should install gems as root to make them globally available, so you could try this too.

    (1-6/6)