can not connect ruby to mysql

General support questions
Post Reply
kiransharma755
Posts: 46
Joined: 2015/02/27 14:30:54

can not connect ruby to mysql

Post by kiransharma755 » 2015/05/17 04:09:55

I am trying to connect ruby to mysql. mysql is up and running. But I could not get ruby module ( not sure what exact does it need) install.

Here is my code

bash-4.1# cat db2.rb
-----------code---------------
require 'rubygems'
require 'dbi'
require 'pp'

datasource = 'student'
usr = 'root'
password=
conn =
DBI.connect("DBI:ODBC:#{datasource}", "#{usr}","#{pwd}")

execute_sql = "select top 10 id from table"
puts "\n*****Following sql will be run!********"
puts execute_sql
sth = conn.prepare(execute_sql)
sth.execute
puts "***************Result***************"
while row=sth.fetch do
p row
end
puts "\n***************Result***************"

when I run, I am getting following errors.

compiling mysql.c
mysql.c:6:25: error: mysql/mysql.h: No such file or directory
mysql.c:7:26: error: mysql/errmsg.h: No such file or directory
mysql.c:45: error: expected specifier-qualifier-list before ‘MYSQL’
mysql.c: In function ‘free_mysql’:
mysql.c:53: error: ‘struct mysql’ has no member named ‘connection’
mysql.c:54: error: ‘struct mysql’ has no member named ‘handler’
mysql.c: At top level:
mysql.c:58: error: expected ‘)’ before ‘*’ token
mysql.c: In function ‘real_connect’:
mysql.c:75: error: ‘MYSQL’ undeclared (first use in this function)
mysql.c:75: error: (Each undeclared identifier is reported only once
mysql.c:75: error: for each function it appears in.)
mysql.c:75: error: expected ‘;’ before ‘my’
mysql.c:88: warning: pointer/integer type mismatch in conditional expression
mysql.c:89: warning: pointer/integer type mismatch in conditional expression
mysql.c:90: warning: pointer/integer type mismatch in conditional expression
mysql.c:92: warning: pointer/integer type mismatch in conditional expression
mysql.c:100: error: ‘my’ undeclared (first use in this function)
mysql.c:105: error: ‘struct mysql’ has no member named ‘handler’
mysql.c:106: error: ‘struct mysql’ has no member named ‘connection’
mysql.c:106: error: ‘TRUE’ undeclared (first use in this function)
mysql.c:107: error: ‘struct mysql’ has no member named ‘query_with_result’
mysql.c: In function ‘escape_string’:
mysql.c:116: error: ‘struct RString’ has no member named ‘len’
mysql.c:117: error: ‘struct RString’ has no member named ‘len’
mysql.c:117: error: ‘struct RString’ has no member named ‘ptr’
mysql.c:117: error: ‘struct RString’ has no member named ‘ptr’
mysql.c:117: error: ‘struct RString’ has no member named ‘len’
mysql.c: In function ‘affected_rows’:
mysql.c:134: error: ‘struct mysql’ has no member named ‘handler’
mysql.c: In function ‘my_close’:
mysql.c:140: error: ‘MYSQL’ undeclared (first use in this function)
mysql.c:140: error: ‘m’ undeclared (first use in this function)
mysql.c:140: error: ‘struct mysql’ has no member named ‘handler’
mysql.c:144: error: ‘struct mysql’ has no member named ‘connection’
mysql.c:144: error: ‘FALSE’ undeclared (first use in this function)
mysql.c:145: error: ‘TRUE’ undeclared (first use in this function)
mysql.c: In function ‘create_db’:
mysql.c:151: error: ‘MYSQL’ undeclared (first use in this function)
mysql.c:151: error: ‘m’ undeclared (first use in this function)
mysql.c:151: error: ‘struct mysql’ has no member named ‘handler’
mysql.c:154: error: ‘TRUE’ undeclared (first use in this function)
mysql.c: In function ‘drop_db’:
mysql.c:160: error: ‘MYSQL’ undeclared (first use in this function)
mysql.c:160: error: ‘m’ undeclared (first use in this function)
mysql.c:160: error: ‘struct mysql’ has no member named ‘handler’
mysql.c:163: error: ‘TRUE’ undeclared (first use in this function)
mysql.c: In function ‘my_errno’:
mysql.c:169: error: ‘struct mysql’ has no member named ‘handler’
mysql.c: In function ‘my_error’:
mysql.c:175: error: ‘struct mysql’ has no member named ‘handler’
mysql.c: In function ‘host_info’:
mysql.c:181: error: ‘struct mysql’ has no member named ‘handler’
mysql.c: In function ‘proto_info’:
mysql.c:187: error: ‘struct mysql’ has no member named ‘handler’
mysql.c: In function ‘server_info’:
mysql.c:193: error: ‘struct mysql’ has no member named ‘handler’
mysql.c: In function ‘info’:
mysql.c:199: error: ‘struct mysql’ has no member named ‘handler’
mysql.c: In function ‘insert_id’:
mysql.c:206: error: ‘struct mysql’ has no member named ‘handler’
mysql.c: In function ‘my_kill’:
mysql.c:213: error: ‘MYSQL’ undeclared (first use in this function)
mysql.c:213: error: ‘m’ undeclared (first use in this function)
mysql.c:213: error: ‘struct mysql’ has no member named ‘handler’
mysql.c:216: error: ‘TRUE’ undeclared (first use in this function)
mysql.c: In function ‘list_dbs’:
mysql.c:224: error: ‘MYSQL’ undeclared (first use in this function)
mysql.c:224: error: ‘m’ undeclared (first use in this function)
mysql.c:224: error: ‘struct mysql’ has no member named ‘handler’
mysql.c:225: error: ‘MYSQL_RES’ undeclared (first use in this function)
mysql.c:225: error: ‘res’ undeclared (first use in this function)
mysql.c:228: warning: pointer/integer type mismatch in conditional expression
mysql.c: In function ‘list_fields’:
mysql.c:244: error: ‘MYSQL’ undeclared (first use in this function)
mysql.c:244: error: ‘m’ undeclared (first use in this function)
mysql.c:244: error: ‘struct mysql’ has no member named ‘handler’
mysql.c:245: error: ‘MYSQL_RES’ undeclared (first use in this function)
mysql.c:245: error: ‘res’ undeclared (first use in this function)
mysql.c:247: warning: pointer/integer type mismatch in conditional expression
mysql.c:250: error: ‘mysql_free_result’ undeclared (first use in this function)
mysql.c: In function ‘list_processes’:
mysql.c:256: error: ‘MYSQL’ undeclared (first use in this function)
mysql.c:256: error: ‘m’ undeclared (first use in this function)
mysql.c:256: error: ‘struct mysql’ has no member named ‘handler’
mysql.c:257: error: ‘MYSQL_RES’ undeclared (first use in this function)
mysql.c:257: error: ‘res’ undeclared (first use in this function)
mysql.c:260: error: ‘mysql_free_result’ undeclared (first use in this function)
mysql.c: In function ‘list_tables’:
mysql.c:267: error: ‘MYSQL’ undeclared (first use in this function)
mysql.c:267: error: ‘m’ undeclared (first use in this function)
mysql.c:267: error: ‘struct mysql’ has no member named ‘handler’
mysql.c:268: error: ‘MYSQL_RES’ undeclared (first use in this function)
mysql.c:268: error: ‘res’ undeclared (first use in this function)
mysql.c:273: warning: pointer/integer type mismatch in conditional expression
mysql.c: In function ‘ping’:
mysql.c:288: error: ‘MYSQL’ undeclared (first use in this function)
mysql.c:288: error: ‘m’ undeclared (first use in this function)
mysql.c:288: error: ‘struct mysql’ has no member named ‘handler’
mysql.c:291: error: ‘TRUE’ undeclared (first use in this function)
mysql.c: In function ‘refresh’:
mysql.c:297: error: ‘MYSQL’ undeclared (first use in this function)
mysql.c:297: error: ‘m’ undeclared (first use in this function)
mysql.c:297: error: ‘struct mysql’ has no member named ‘handler’
mysql.c:300: error: ‘TRUE’ undeclared (first use in this function)
mysql.c: In function ‘reload’:
mysql.c:306: error: ‘MYSQL’ undeclared (first use in this function)
mysql.c:306: error: ‘m’ undeclared (first use in this function)
mysql.c:306: error: ‘struct mysql’ has no member named ‘handler’
mysql.c:309: error: ‘TRUE’ undeclared (first use in this function)
mysql.c: In function ‘select_db’:
mysql.c:315: error: ‘MYSQL’ undeclared (first use in this function)
mysql.c:315: error: ‘m’ undeclared (first use in this function)
mysql.c:315: error: ‘struct mysql’ has no member named ‘handler’
mysql.c:318: error: ‘TRUE’ undeclared (first use in this function)
mysql.c: In function ‘my_shutdown’:
mysql.c:324: error: ‘MYSQL’ undeclared (first use in this function)
mysql.c:324: error: ‘m’ undeclared (first use in this function)
mysql.c:324: error: ‘struct mysql’ has no member named ‘handler’
mysql.c:327: error: ‘TRUE’ undeclared (first use in this function)
mysql.c: In function ‘my_stat’:
mysql.c:333: error: ‘MYSQL’ undeclared (first use in this function)
mysql.c:333: error: ‘m’ undeclared (first use in this function)
mysql.c:333: error: ‘struct mysql’ has no member named ‘handler’
mysql.c: In function ‘store_result’:
mysql.c:343: error: ‘MYSQL’ undeclared (first use in this function)
mysql.c:343: error: ‘m’ undeclared (first use in this function)
mysql.c:343: error: ‘struct mysql’ has no member named ‘handler’
mysql.c:344: error: ‘MYSQL_RES’ undeclared (first use in this function)
mysql.c:344: error: ‘res’ undeclared (first use in this function)
mysql.c:347: error: ‘mysql_free_result’ undeclared (first use in this function)
mysql.c: In function ‘thread_id’:
mysql.c:353: error: ‘struct mysql’ has no member named ‘handler’
mysql.c: In function ‘use_result’:
mysql.c:359: error: ‘MYSQL’ undeclared (first use in this function)
mysql.c:359: error: ‘m’ undeclared (first use in this function)
mysql.c:359: error: ‘struct mysql’ has no member named ‘handler’
mysql.c:360: error: ‘MYSQL_RES’ undeclared (first use in this function)
mysql.c:360: error: ‘res’ undeclared (first use in this function)
mysql.c:363: error: ‘mysql_free_result’ undeclared (first use in this function)
mysql.c: In function ‘query’:
mysql.c:369: error: ‘MYSQL’ undeclared (first use in this function)
mysql.c:369: error: ‘m’ undeclared (first use in this function)
mysql.c:369: error: ‘struct mysql’ has no member named ‘handler’
mysql.c:371: error: ‘struct RString’ has no member named ‘ptr’
mysql.c:371: error: ‘struct RString’ has no member named ‘len’
mysql.c:373: error: ‘struct mysql’ has no member named ‘query_with_result’
mysql.c:373: error: ‘FALSE’ undeclared (first use in this function)
mysql.c:374: error: ‘TRUE’ undeclared (first use in this function)
mysql.c: In function ‘query_with_result’:
mysql.c:383: error: ‘struct mysql’ has no member named ‘query_with_result’
mysql.c:383: error: ‘TRUE’ undeclared (first use in this function)
mysql.c:383: error: ‘FALSE’ undeclared (first use in this function)
mysql.c: In function ‘query_with_result_set’:
mysql.c:391: error: ‘struct mysql’ has no member named ‘query_with_result’
mysql.c: In function ‘data_seek’:
mysql.c:402: error: ‘MYSQL_RES’ undeclared (first use in this function)
mysql.c:402: error: expected expression before ‘)’ token
mysql.c:403: error: ‘TRUE’ undeclared (first use in this function)
mysql.c: At top level:
mysql.c:407: error: expected ‘)’ before ‘*’ token
mysql.c: In function ‘fetch_field’:
mysql.c:430: error: ‘MYSQL_RES’ undeclared (first use in this function)
mysql.c:430: error: expected expression before ‘)’ token
mysql.c: In function ‘fetch_fields’:
mysql.c:436: error: ‘MYSQL_RES’ undeclared (first use in this function)
mysql.c:436: error: ‘res’ undeclared (first use in this function)
mysql.c:436: error: expected expression before ‘)’ token
mysql.c:437: error: ‘MYSQL_FIELD’ undeclared (first use in this function)
mysql.c:437: error: ‘f’ undeclared (first use in this function)
mysql.c: In function ‘fetch_field_direct’:
mysql.c:449: error: ‘MYSQL_RES’ undeclared (first use in this function)
mysql.c:449: error: ‘res’ undeclared (first use in this function)
mysql.c:449: error: expected expression before ‘)’ token
mysql.c: In function ‘fetch_lengths’:
mysql.c:460: error: ‘MYSQL_RES’ undeclared (first use in this function)
mysql.c:460: error: ‘res’ undeclared (first use in this function)
mysql.c:460: error: expected expression before ‘)’ token
mysql.c: In function ‘fetch_row’:
mysql.c:476: error: ‘MYSQL_RES’ undeclared (first use in this function)
mysql.c:476: error: ‘res’ undeclared (first use in this function)
mysql.c:476: error: expected expression before ‘)’ token
mysql.c:478: error: ‘MYSQL_ROW’ undeclared (first use in this function)
mysql.c:478: error: expected ‘;’ before ‘row’
mysql.c:482: error: ‘row’ undeclared (first use in this function)
mysql.c: In function ‘fetch_hash2’:
mysql.c:493: error: ‘MYSQL_RES’ undeclared (first use in this function)
mysql.c:493: error: ‘res’ undeclared (first use in this function)
mysql.c:493: error: expected expression before ‘)’ token
mysql.c:495: error: ‘MYSQL_ROW’ undeclared (first use in this function)
mysql.c:495: error: expected ‘;’ before ‘row’
mysql.c:497: error: ‘MYSQL_FIELD’ undeclared (first use in this function)
mysql.c:497: error: ‘fields’ undeclared (first use in this function)
mysql.c:500: error: ‘row’ undeclared (first use in this function)
mysql.c:507: error: ‘FALSE’ undeclared (first use in this function)
mysql.c:511: error: ‘struct RString’ has no member named ‘ptr’
mysql.c:512: error: ‘struct RString’ has no member named ‘ptr’
mysql.c: In function ‘fetch_hash’:
mysql.c:525: error: ‘FALSE’ undeclared (first use in this function)
mysql.c: In function ‘field_seek’:
mysql.c:532: error: ‘MYSQL_RES’ undeclared (first use in this function)
mysql.c:532: error: expected expression before ‘)’ token
mysql.c: In function ‘field_tell’:
mysql.c:538: error: ‘MYSQL_RES’ undeclared (first use in this function)
mysql.c:538: error: expected expression before ‘)’ token
mysql.c: In function ‘num_fields’:
mysql.c:544: error: ‘MYSQL_RES’ undeclared (first use in this function)
mysql.c:544: error: expected expression before ‘)’ token
mysql.c: In function ‘num_rows’:
mysql.c:550: error: ‘MYSQL_RES’ undeclared (first use in this function)
mysql.c:550: error: expected expression before ‘)’ token
mysql.c: In function ‘row_seek’:
mysql.c:556: error: ‘MYSQL_RES’ undeclared (first use in this function)
mysql.c:556: error: expected expression before ‘)’ token
mysql.c:556: error: ‘MYSQL_ROWS’ undeclared (first use in this function)
mysql.c:556: error: expected ‘)’ before ‘rb_num2int_inline’
mysql.c: In function ‘row_tell’:
mysql.c:562: error: ‘MYSQL_RES’ undeclared (first use in this function)
mysql.c:562: error: expected expression before ‘)’ token
mysql.c: In function ‘each’:
mysql.c:571: error: ‘TRUE’ undeclared (first use in this function)
mysql.c: In function ‘each_hash’:
mysql.c:581: error: ‘FALSE’ undeclared (first use in this function)
mysql.c:584: error: ‘TRUE’ undeclared (first use in this function)
mysql.c: In function ‘Init_mysql’:
mysql.c:632: error: ‘cObject’ undeclared (first use in this function)
mysql.c:686: error: ‘REFRESH_GRANT’ undeclared (first use in this function)
mysql.c:687: error: ‘REFRESH_LOG’ undeclared (first use in this function)
mysql.c:688: error: ‘REFRESH_TABLES’ undeclared (first use in this function)
mysql.c:737: error: ‘FIELD_TYPE_TINY’ undeclared (first use in this function)
mysql.c:741: error: ‘FIELD_TYPE_DECIMAL’ undeclared (first use in this function)
mysql.c:742: error: ‘FIELD_TYPE_SHORT’ undeclared (first use in this function)
mysql.c:743: error: ‘FIELD_TYPE_LONG’ undeclared (first use in this function)
mysql.c:744: error: ‘FIELD_TYPE_FLOAT’ undeclared (first use in this function)
mysql.c:745: error: ‘FIELD_TYPE_DOUBLE’ undeclared (first use in this function)
mysql.c:746: error: ‘FIELD_TYPE_NULL’ undeclared (first use in this function)
mysql.c:747: error: ‘FIELD_TYPE_TIMESTAMP’ undeclared (first use in this function)
mysql.c:748: error: ‘FIELD_TYPE_LONGLONG’ undeclared (first use in this function)
mysql.c:749: error: ‘FIELD_TYPE_INT24’ undeclared (first use in this function)
mysql.c:750: error: ‘FIELD_TYPE_DATE’ undeclared (first use in this function)
mysql.c:751: error: ‘FIELD_TYPE_TIME’ undeclared (first use in this function)
mysql.c:752: error: ‘FIELD_TYPE_DATETIME’ undeclared (first use in this function)
mysql.c:756: error: ‘FIELD_TYPE_SET’ undeclared (first use in this function)
mysql.c:757: error: ‘FIELD_TYPE_BLOB’ undeclared (first use in this function)
mysql.c:758: error: ‘FIELD_TYPE_STRING’ undeclared (first use in this function)
mysql.c:759: error: ‘FIELD_TYPE_CHAR’ undeclared (first use in this function)
mysql.c:762: error: ‘NOT_NULL_FLAG’ undeclared (first use in this function)
mysql.c:763: error: ‘PRI_KEY_FLAG’ undeclared (first use in this function)
mysql.c:764: error: ‘UNIQUE_KEY_FLAG’ undeclared (first use in this function)
mysql.c:765: error: ‘MULTIPLE_KEY_FLAG’ undeclared (first use in this function)
mysql.c:766: error: ‘BLOB_FLAG’ undeclared (first use in this function)
mysql.c:767: error: ‘UNSIGNED_FLAG’ undeclared (first use in this function)
mysql.c:768: error: ‘ZEROFILL_FLAG’ undeclared (first use in this function)
mysql.c:769: error: ‘BINARY_FLAG’ undeclared (first use in this function)
mysql.c:785: error: ‘CR_UNKNOWN_ERROR’ undeclared (first use in this function)
mysql.c:786: error: ‘CR_SOCKET_CREATE_ERROR’ undeclared (first use in this function)
mysql.c:787: error: ‘CR_CONNECTION_ERROR’ undeclared (first use in this function)
mysql.c:788: error: ‘CR_CONN_HOST_ERROR’ undeclared (first use in this function)
mysql.c:789: error: ‘CR_IPSOCK_ERROR’ undeclared (first use in this function)
mysql.c:790: error: ‘CR_UNKNOWN_HOST’ undeclared (first use in this function)
mysql.c:791: error: ‘CR_SERVER_GONE_ERROR’ undeclared (first use in this function)
mysql.c:792: error: ‘CR_VERSION_ERROR’ undeclared (first use in this function)
mysql.c:793: error: ‘CR_OUT_OF_MEMORY’ undeclared (first use in this function)
mysql.c:794: error: ‘CR_WRONG_HOST_INFO’ undeclared (first use in this function)
make: *** [mysql.o] Error 1


So it seems that I am missing mysql module for ruby, I followed following link and did it, but still failing.

link
http://www.kitebird.com/articles/ruby-mysql.html

User avatar
TrevorH
Site Admin
Posts: 33202
Joined: 2009/09/24 10:40:56
Location: Brighton, UK

Re: can not connect ruby to mysql

Post by TrevorH » 2015/05/17 13:28:01

yum install ruby-mysql
The future appears to be RHEL or Debian. I think I'm going Debian.
Info for USB installs on http://wiki.centos.org/HowTos/InstallFromUSBkey
CentOS 5 and 6 are deadest, do not use them.
Use the FAQ Luke

kiransharma755
Posts: 46
Joined: 2015/02/27 14:30:54

Re: can not connect ruby to mysql

Post by kiransharma755 » 2015/05/17 14:23:11

TrevorH wrote:yum install ruby-mysql
Do I need to do anything else?
I am still getting same error after installing ruby-mysql.

1. Installing ruby-mysql

bash-4.1# yum install ruby-mysql
Loaded plugins: fastestmirror, refresh-packagekit, replace
Setting up Install Process
Loading mirror speeds from cached hostfile
epel/metalink | 13 kB 00:00
* base: www.gtlib.gatech.edu
* epel: www.gtlib.gatech.edu
* extras: mirrors.rit.edu
* updates: mirror.ash.fastserv.com
* webtatic: us-east.repo.webtatic.com
base | 3.7 kB 00:00
epel-apache-maven | 2.4 kB 00:00
extras | 3.4 kB 00:00
updates | 3.4 kB 00:00
webtatic | 3.6 kB 00:00
Resolving Dependencies
--> Running transaction check
---> Package ruby-mysql.x86_64 0:2.8.2-1.el6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

=============================================================================================================================
Package Arch Version Repository Size
=============================================================================================================================
Installing:
ruby-mysql x86_64 2.8.2-1.el6 epel 45 k

Transaction Summary
=============================================================================================================================
Install 1 Package(s)

Total download size: 45 k
Installed size: 143 k
Is this ok [y/N]: y
Downloading Packages:
ruby-mysql-2.8.2-1.el6.x86_64.rpm | 45 kB 00:00
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : ruby-mysql-2.8.2-1.el6.x86_64 1/1
Verifying : ruby-mysql-2.8.2-1.el6.x86_64 1/1

Installed:
ruby-mysql.x86_64 0:2.8.2-1.el6

Complete!
bash-4.1# clear

bash-4.1# pwd
/ruby
2. Running the ruby db connect script

bash-4.1# ruby db2.rb
/usr/local/rvm/gems/ruby-2.1.0/gems/dbi-0.4.5/lib/dbi.rb:300:in `block in load_driver': Unable to load driver 'ODBC' (underlying error: uninitialized constant DBI::DBD::ODBC) (DBI::InterfaceError)
from /usr/local/rvm/rubies/ruby-2.1.0/lib/ruby/2.1.0/monitor.rb:211:in `mon_synchronize'
from /usr/local/rvm/gems/ruby-2.1.0/gems/dbi-0.4.5/lib/dbi.rb:242:in `load_driver'
from /usr/local/rvm/gems/ruby-2.1.0/gems/dbi-0.4.5/lib/dbi.rb:160:in `_get_full_driver'
from /usr/local/rvm/gems/ruby-2.1.0/gems/dbi-0.4.5/lib/dbi.rb:145:in `connect'
from db2.rb:10:in `<main>'


3. the ruby code is here

require 'rubygems'
require 'dbi'
require 'pp'

datasource = 'student'
usr = 'root'
pwd = 'temp1119'

conn =
DBI.connect("DBI:ODBC:#{datasource}", "#{usr}","#{pwd}")

execute_sql = "select top 10 id from table"
puts "\n*****Following sql will be run!********"
puts execute_sql
sth = conn.prepare(execute_sql)
sth.execute
puts "***************Result***************"
while row=sth.fetch do
p row
end
puts "\n***************Result***************"

Anythings else?

gerald_clark
Posts: 10642
Joined: 2005/08/05 15:19:54
Location: Northern Illinois, USA

Re: can not connect ruby to mysql

Post by gerald_clark » 2015/05/17 14:35:55

Looks like you trashed your ruby installation with all your compiling.
CentOS ships Ruby 1.8.7 and you are running 2.1.0.

What does "rpm -q ruby" show?

kiransharma755
Posts: 46
Joined: 2015/02/27 14:30:54

Re: can not connect ruby to mysql

Post by kiransharma755 » 2015/05/17 15:48:54

bash-4.1# rpm -qa |grep ruby
ruby-mysql-2.8.2-1.el6.x86_64
ruby-libs-1.8.7.374-4.el6_6.x86_64
ruby-devel-1.8.7.374-4.el6_6.x86_64
bash-4.1# rpm -qa ruby

seems i messed up. I am not sure how can i delete all the stuff I compile and install. I do not even rem which which site did I follow.

thanks for any help.

kiransharma755
Posts: 46
Joined: 2015/02/27 14:30:54

Re: can not connect ruby to mysql

Post by kiransharma755 » 2015/05/17 18:41:47

I removed rvm from my system. now it looks like this

1. yum list |grep ruby - one packages.

bash-4.1# yum list ruby
Loaded plugins: fastestmirror, refresh-packagekit, replace
Loading mirror speeds from cached hostfile
* base: www.gtlib.gatech.edu
* epel: www.gtlib.gatech.edu
* extras: mirror.linux.duke.edu
* updates: mirror.ash.fastserv.com
* webtatic: us-east.repo.webtatic.com
Available Packages
ruby.x86_64 1.8.7.374-4.el6_6 updates

2. rpm -qa -------nothing related to ruby

bash-4.1# rpm -qa|grep ruby


But when I go yum list ruby* I have these packages

Available Packages
ruby.x86_64 1.8.7.374-4.el6_6 updates
ruby-RMagick.x86_64 2.13.1-6.el6.1 epel
ruby-RMagick-doc.noarch 2.13.1-6.el6.1 epel
ruby-augeas.x86_64 0.4.1-1.el6 epel
ruby-devel.i686 1.8.7.374-4.el6_6 updates
ruby-devel.x86_64 1.8.7.374-4.el6_6 updates
ruby-docs.x86_64 1.8.7.374-4.el6_6 updates
ruby-extlib.noarch 0.9.13-5.el6 epel
ruby-flexmock.noarch 0.8.6-1.1.el6 base
ruby-gettext-package.noarch 2.1.0-1.el6.1 epel
ruby-gofer.noarch 0.74-1.el6 epel
ruby-irb.x86_64 1.8.7.374-4.el6_6 updates
ruby-json.x86_64 1.4.6-1.el6 epel
ruby-ldap.x86_64 0.9.7-10.el6 epel
ruby-libdmtx.x86_64 0.7.2-3.el6 epel
ruby-libguestfs.x86_64 1:1.20.11-11.el6 base
ruby-libs.i686 1.8.7.374-4.el6_6 updates
ruby-libs.x86_64 1.8.7.374-4.el6_6 updates
ruby-libvirt.x86_64 0.5.2-2.el6 epel
ruby-locale.noarch 2.0.5-1.el6.1 epel
ruby-mysql.x86_64 2.8.2-1.el6 epel
ruby-ncurses.x86_64 1.3.1-2.el6 epel
ruby-nokogiri.x86_64 1.4.3.1-1.el6 epel
ruby-openbabel.x86_64 2.2.3-1.el6 epel
ruby-qpid.x86_64 0.7.946106-2.el6 base
ruby-qpid-qmf.x86_64 0.14-14.el6_3 base
ruby-rdoc.x86_64 1.8.7.374-4.el6_6 updates
ruby-redland.x86_64 1.0.7.1-1.el6 epel
ruby-ri.x86_64 1.8.7.374-4.el6_6 updates
ruby-saslwrapper.x86_64 0.14-1.el6 base
ruby-shadow.x86_64 1.4.1-13.el6 epel
ruby-solv.x86_64 0.0.0-1.git857fe28.el6 epel
ruby-sqlite3.x86_64 1.2.4-5.el6 epel
ruby-static.x86_64 1.8.7.374-4.el6_6 updates
ruby-systemu.noarch 1.2.0-3.el6 epel
ruby-tcltk.x86_64 1.8.7.374-4.el6_6 updates
rubygem-Ascii85.noarch 1.0.1-7.el6 epel
rubygem-Ascii85-doc.noarch 1.0.1-7.el6 epel
rubygem-RedCloth.x86_64 4.2.3-1.el6 epel
rubygem-ZenTest.noarch 4.3.3-1.el6 epel
rubygem-ZenTest-doc.noarch 4.3.3-1.el6 epel
rubygem-abstract.noarch 1.0.0-2.el6 epel
rubygem-abstract-doc.noarch 1.0.0-2.el6 epel
rubygem-activesupport.noarch 1:2.3.8-2.el6 epel
rubygem-amqp.noarch 0.6.7-2.el6 epel
rubygem-amqp-doc.noarch 0.6.7-2.el6 epel
rubygem-ansi.noarch 1.4.3-2.el6 epel
rubygem-ansi-doc.noarch 1.4.3-2.el6 epel
rubygem-archive-tar-minitar.noarch 0.5.2-2.el6 epel
rubygem-archive-tar-minitar-doc.noarch 0.5.2-2.el6 epel
rubygem-asciidoctor.noarch 0.1.3-2.el6 epel
rubygem-asciidoctor-doc.noarch 0.1.3-2.el6 epel
rubygem-aws-sdk.noarch 1.40.3-1.el6 epel
rubygem-aws-sdk-doc.noarch 1.40.3-1.el6 epel
rubygem-bacon.noarch 1.1.0-3.el6 epel
rubygem-bunny.noarch 0.6.0-1.el6 epel
rubygem-bunny-doc.noarch 0.6.0-1.el6 epel
rubygem-color.noarch 1.4.1-2.el6 epel
rubygem-color-doc.noarch 1.4.1-2.el6 epel
rubygem-configuration.noarch 1.1.0-1.el6 epel
rubygem-configuration-doc.noarch 1.1.0-1.el6 epel
rubygem-crack.noarch 0.1.8-1.el6 epel
rubygem-crack-doc.noarch 0.1.8-1.el6 epel
rubygem-curb.x86_64 0.8.4-2.el6 epel
rubygem-curb-doc.x86_64 0.8.4-2.el6 epel
rubygem-daemon_controller.noarch 1.1.5-1.el6 epel
rubygem-daemon_controller-doc.noarch 1.1.5-1.el6 epel
rubygem-daemons.noarch 1.0.10-2.el6 epel
rubygem-deep_merge.noarch 1.0.1-5.el6 epel
rubygem-deep_merge-doc.noarch 1.0.1-5.el6 epel
rubygem-diff-lcs.noarch 1.1.2-4.el6 epel
rubygem-dnsruby.noarch 1.53-1.el6 epel
rubygem-dnsruby-doc.noarch 1.53-1.el6 epel
rubygem-dynect_rest.noarch 0.4.3-7.el6 epel
rubygem-dynect_rest-doc.noarch 0.4.3-7.el6 epel
rubygem-erubis.noarch 2.6.5-2.el6 epel
rubygem-erubis-doc.noarch 2.6.5-2.el6 epel
rubygem-eventmachine.x86_64 0.12.10-4.el6 epel
rubygem-eventmachine-doc.x86_64 0.12.10-4.el6 epel
rubygem-extlib.noarch 0.9.13-5.el6 epel
rubygem-extlib-doc.noarch 0.9.13-5.el6 epel
rubygem-facon.noarch 0.4.1-2.el6 epel
rubygem-facon-doc.noarch 0.4.1-2.el6 epel
rubygem-fakeweb.noarch 1.3.0-5.el6 epel
rubygem-fakeweb-doc.noarch 1.3.0-5.el6 epel
rubygem-fastercsv.noarch 1.5.4-1.el6 epel
rubygem-fastthread.x86_64 1.0.7-2.el6 epel
rubygem-fattr.noarch 1.0.3-3.el6 epel
rubygem-ffi.x86_64 1.0.9-10.el6 epel
rubygem-flexmock.noarch 0.8.6-1.1.el6 base
rubygem-flexmock-doc.noarch 0.8.6-1.1.el6 base
rubygem-gem2rpm.noarch 0.10.1-1.el6 epel
rubygem-gem2rpm-doc.noarch 0.10.1-1.el6 epel
rubygem-gettext.noarch 2.1.0-1.el6.1 epel
rubygem-gettext-doc.noarch 2.1.0-1.el6.1 epel
rubygem-git.noarch 1.2.5-1.el6 epel
rubygem-gssapi.noarch 1.1.2-2.el6 epel
rubygem-gssapi-doc.noarch 1.1.2-2.el6 epel
rubygem-hashr.noarch 0.0.21-3.el6 epel
rubygem-hashr-doc.noarch 0.0.21-3.el6 epel
rubygem-http_connection.noarch 1.4.1-2.el6 epel
rubygem-httparty.noarch 0.6.1-2.el6 epel
rubygem-httparty-doc.noarch 0.6.1-2.el6 epel
rubygem-httpclient.noarch 2.4.0-2.el6 epel
rubygem-httpclient-doc.noarch 2.4.0-2.el6 epel
rubygem-hydra.noarch 0.24.0-1.el6 epel
rubygem-hydra-doc.noarch 0.24.0-1.el6 epel
rubygem-icalendar.noarch 1.1.0-3.el6 epel
rubygem-ipaddress.noarch 0.8.0-3.el6 epel
rubygem-ipaddress-doc.noarch 0.8.0-3.el6 epel
rubygem-jnunemaker-matchy.noarch 0.4.0-3.el6 epel
rubygem-jnunemaker-matchy-doc.noarch 0.4.0-3.el6 epel
rubygem-json.x86_64 1.4.6-1.el6 epel
rubygem-json-doc.x86_64 1.4.6-1.el6 epel
rubygem-json_pure.noarch 1.6.3-2.el6 epel
rubygem-json_pure-doc.noarch 1.6.3-2.el6 epel
rubygem-kgio.x86_64 2.8.0-1.el6 epel
rubygem-kgio-doc.x86_64 2.8.0-1.el6 epel
rubygem-kwalify.noarch 0.7.2-3.el6 epel
rubygem-kwalify-doc.noarch 0.7.2-3.el6 epel
rubygem-launchy.noarch 0.3.7-1.el6 epel
rubygem-locale.noarch 2.0.5-1.el6.1 epel
rubygem-locale-doc.noarch 2.0.5-1.el6.1 epel
rubygem-mime-types.noarch 1.16-3.el6 epel
rubygem-mime-types-doc.noarch 1.16-3.el6 epel
rubygem-minitest.noarch 1.6.0-2.el6 epel
rubygem-minitest-doc.noarch 1.6.0-2.el6 epel
rubygem-mixlib-log.noarch 1.6.0-1.el6 epel
rubygem-mixlib-log-doc.noarch 1.6.0-1.el6 epel
rubygem-mixlib-shellout.noarch 1.3.0-1.el6 epel
rubygem-mixlib-shellout-doc.noarch 1.3.0-1.el6 epel
rubygem-mizuho.noarch 0.9.20-5.el6 epel
rubygem-mizuho-doc.noarch 0.9.20-5.el6 epel
rubygem-mkrf.noarch 0.2.3-5.el6 epel
rubygem-mkrf-doc.noarch 0.2.3-5.el6 epel
rubygem-mocha.noarch 0.9.8-1.el6 epel
rubygem-mocha-doc.noarch 0.9.8-1.el6 epel
rubygem-moneta.noarch 0.6.0-1.el6 epel
rubygem-moneta-doc.noarch 0.6.0-1.el6 epel
rubygem-mongrel.x86_64 1.1.5-3.el6 epel
rubygem-mongrel_cluster.noarch 1.0.5-5.el6 epel
rubygem-mustache.noarch 0.99.4-4.el6 epel
rubygem-mustache-doc.noarch 0.99.4-4.el6 epel
rubygem-narray.i686 0.6.1.1-1.el6 epel
rubygem-narray.x86_64 0.6.1.1-1.el6 epel
rubygem-narray-devel.i686 0.6.1.1-1.el6 epel
rubygem-narray-devel.x86_64 0.6.1.1-1.el6 epel
rubygem-net-http-persistent.noarch 2.9.4-2.el6 epel
rubygem-net-http-persistent-doc.noarch 2.9.4-2.el6 epel
rubygem-net-ldap.noarch 0.6.1-2.el6.1 epel
rubygem-net-ldap-doc.noarch 0.6.1-2.el6.1 epel
rubygem-nokogiri.x86_64 1.4.3.1-1.el6 epel
rubygem-nokogiri-doc.x86_64 1.4.3.1-1.el6 epel
rubygem-openstack-quantum-client.noarch 0.1.5-3.el6 epel
rubygem-openstack-quantum-client-doc.noarch 0.1.5-3.el6 epel
rubygem-parallel.noarch 0.9.2-3.el6 epel
rubygem-parallel-doc.noarch 0.9.2-3.el6 epel
rubygem-parseconfig.noarch 0.5.2-3.el6 epel
rubygem-passenger.x86_64 3.0.21-11.el6 epel
rubygem-passenger-devel.i686 3.0.21-11.el6 epel
rubygem-passenger-devel.x86_64 3.0.21-11.el6 epel
rubygem-passenger-doc.x86_64 3.0.21-11.el6 epel
rubygem-passenger-native.x86_64 3.0.21-11.el6 epel
rubygem-passenger-native-libs.x86_64 3.0.21-11.el6 epel
rubygem-pdf-reader.noarch 1.1.1-6.el6 epel
rubygem-pdf-reader-doc.noarch 1.1.1-6.el6 epel
rubygem-pg.x86_64 0.12.2-2.el6 epel
rubygem-pg-doc.x86_64 0.12.2-2.el6 epel
rubygem-polyglot.noarch 0.3.3-4.el6 epel
rubygem-polyglot-doc.noarch 0.3.3-4.el6 epel
rubygem-puppet-lint.noarch 1.1.0-1.el6 epel
rubygem-puppet-lint-doc.noarch 1.1.0-1.el6 epel
rubygem-qpid_proton.x86_64 0.8-1.el6 epel
rubygem-qpid_proton-doc.x86_64 0.8-1.el6 epel
rubygem-rack.noarch 1:1.1.0-2.el6 epel
rubygem-rack-cors.noarch 0.2.9-1.el6 epel
rubygem-rack-cors-doc.noarch 0.2.9-1.el6 epel
rubygem-rack-test.noarch 0.5.4-1.el6 epel
rubygem-raindrops.x86_64 0.10.0-1.el6 epel
rubygem-raindrops-doc.x86_64 0.10.0-1.el6 epel
rubygem-rake.noarch 0.8.7-2.1.el6 base
rubygem-rake-compiler.noarch 0.9.3-2.el6 epel
rubygem-rake-compiler-doc.noarch 0.9.3-2.el6 epel
rubygem-rbovirt.noarch 0.0.6-2.el6 epel
rubygem-rbovirt-doc.noarch 0.0.6-2.el6 epel
rubygem-recaptcha.noarch 0.3.1-1.el6 epel
rubygem-recaptcha-doc.noarch 0.3.1-1.el6 epel
rubygem-redcarpet.x86_64 2.1.1-5.el6 epel
rubygem-redcarpet-doc.x86_64 2.1.1-5.el6 epel
rubygem-rest-client.noarch 1.6.1-2.el6 epel
rubygem-rgen.noarch 0.6.6-2.el6 epel
rubygem-rgen-doc.noarch 0.6.6-2.el6 epel
rubygem-rhc.noarch 0.92.11-1.el6 epel
rubygem-rspec.noarch 1.3.0-2.el6 epel
rubygem-rspec-core.noarch 2.6.4-1.el6 epel
rubygem-rspec-core-doc.noarch 2.6.4-1.el6 epel
rubygem-rspec-expectations.noarch 2.6.0-1.el6 epel
rubygem-rspec-expectations-doc.noarch 2.6.0-1.el6 epel
rubygem-rspec-mocks.noarch 2.6.0-1.el6 epel
rubygem-rspec-mocks-doc.noarch 2.6.0-1.el6 epel
rubygem-ruby-ole.noarch 1.2.11.2-1.el6 epel
rubygem-ruby-ole-doc.noarch 1.2.11.2-1.el6 epel
rubygem-ruby-rc4.noarch 0.1.5-4.el6 epel
rubygem-ruby-rc4-doc.noarch 0.1.5-4.el6 epel
rubygem-ruby2ruby.noarch 1.2.4-2.el6 epel
rubygem-ruby2ruby-doc.noarch 1.2.4-2.el6 epel
rubygem-ruby_parser.noarch 2.0.4-3.el6 epel
rubygem-ruby_parser-doc.noarch 2.0.4-3.el6 epel
rubygem-rubyforge.noarch 2.0.4-1.el6 epel
rubygem-safe_yaml.noarch 0.9.4-2.el6 epel
rubygem-safe_yaml-doc.noarch 0.9.4-2.el6 epel
rubygem-sequel.noarch 4.13.0-9.el6 epel
rubygem-sequel-doc.noarch 4.13.0-9.el6 epel
rubygem-serialport.x86_64 1.3.1-3.el6 epel
rubygem-serialport-doc.noarch 1.3.1-3.el6 epel
rubygem-session.noarch 3.1.0-2.el6 epel
rubygem-session-doc.noarch 3.1.0-2.el6 epel
rubygem-settingslogic.noarch 2.0.9-3.el6 epel
rubygem-settingslogic-doc.noarch 2.0.9-3.el6 epel
rubygem-sexp_processor.noarch 3.0.4-1.el6 epel
rubygem-sexp_processor-doc.noarch 3.0.4-1.el6 epel
rubygem-shotgun.noarch 0.8-1.el6 epel
rubygem-shotgun-doc.noarch 0.8-1.el6 epel
rubygem-shoulda.noarch 2.11.3-1.el6 epel
rubygem-shoulda-doc.noarch 2.11.3-1.el6 epel
rubygem-simple-rss.noarch 1.2.3-1.el6 epel
rubygem-sinatra.noarch 1:1.0-2.el6 epel
rubygem-snmp.noarch 1.1.0-2.el6 epel
rubygem-sqlite3-ruby.x86_64 1.2.4-5.el6 epel
rubygem-state_machine.noarch 1.1.2-2.el6 epel
rubygem-state_machine-doc.noarch 1.1.2-2.el6 epel
rubygem-stomp.noarch 1.2.2-1.el6 epel
rubygem-stomp-doc.noarch 1.2.2-1.el6 epel
rubygem-systemu.noarch 1.2.0-3.el6 epel
rubygem-systemu-doc.noarch 1.2.0-3.el6 epel
rubygem-term-ansicolor.noarch 1.0.7-1.el6 epel
rubygem-test-spec.noarch 0.10.0-2.el6 epel
rubygem-thin.x86_64 1.2.8-4.el6 epel
rubygem-thin-doc.x86_64 1.2.8-4.el6 epel
rubygem-transaction-simple.noarch 1.4.0.2-3.el6 epel
rubygem-transaction-simple-doc.noarch 1.4.0.2-3.el6 epel
rubygem-treetop.noarch 1.4.10-1.el6 epel
rubygem-ttfunk.noarch 1.0.3-4.el6 epel
rubygem-ttfunk-doc.noarch 1.0.3-4.el6 epel
rubygem-uuidtools.noarch 2.1.1-1.el6 epel
rubygem-uuidtools-doc.noarch 2.1.1-1.el6 epel
rubygem-whiskey_disk.noarch 0.6.24-1.el6 epel
rubygem-whiskey_disk-doc.noarch 0.6.24-1.el6 epel
rubygem-wirble.noarch 0.1.3-1.el6 epel
rubygem-wirble-doc.noarch 0.1.3-1.el6 epel
rubygem-xmlparser.x86_64 0.6.81-10.el6 epel
rubygem-xmpp4r.noarch 0.5-3.el6 epel
rubygem-xmpp4r-doc.noarch 0.5-3.el6 epel
rubygems.noarch 1.3.7-5.el6 base
rubygems-devel.noarch

These packages seem only available but not installed.

How can I remove these pacakges or are they part of linux os?

gerald_clark
Posts: 10642
Joined: 2005/08/05 15:19:54
Location: Northern Illinois, USA

Re: can not connect ruby to mysql

Post by gerald_clark » 2015/05/17 18:48:03

Those available packages are packages you have not loaded.
Notice the ruby listed there?
You have not installed ruby.

Webtatic repo is NOT recommended, as it will hose your system.
I recommend you remove it and any packages you installed from it.

kiransharma755
Posts: 46
Joined: 2015/02/27 14:30:54

Re: can not connect ruby to mysql

Post by kiransharma755 » 2015/05/17 19:13:15

Those available packages are packages you have not loaded.
Notice the ruby listed there?
You have not installed ruby.

Webtatic repo is NOT recommended, as it will hose your system.
I recommend you remove it and any packages you installed from it.

--I removeWebstatic repo
bash-4.1# pwd
/etc/yum.repos.d
bash-4.1# ls -l
total 36
-rw-r--r--. 1 root root 1991 Oct 23 2014 CentOS-Base.repo
-rw-r--r--. 1 root root 647 Oct 23 2014 CentOS-Debuginfo.repo
-rw-r--r--. 1 root root 289 Oct 23 2014 CentOS-fasttrack.repo
-rw-r--r--. 1 root root 630 Oct 23 2014 CentOS-Media.repo
-rw-r--r--. 1 root root 5394 Oct 23 2014 CentOS-Vault.repo
-rw-r--r-- 1 root root 445 Mar 4 2014 epel-apache-maven.repo
-rw-r--r--. 1 root root 957 Nov 4 2012 epel.repo
-rw-r--r--. 1 root root 1056 Nov 4 2012 epel-testing.repo


---------------
I installed ruby and mysql from scratch again
ash-4.1# ruby db.rb
db.rb:6: undefined local variable or method `mysql' for main:Object (NameError)
bash-4.1# cat db.rb
#!/usr/bin/ruby

require 'mysql'

#my = Mysql.new(localhost, root, temp1119, databasename)
con = mysql.new('localhost', '', '', 'ruby')
rs = con.query('select * from student')
rs.each_hash { |h| puts h['name']}
con.close
bash-4.1# vi db.rb

--------mysql
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| ruby |
+--------------------+

advice I need is how can I remove Webstatic repo
what is nex to fix the database issue with ruby, as it is till not connecting ? it error out at reqquire 'mysql'

thanks
Kiran

gerald_clark
Posts: 10642
Joined: 2005/08/05 15:19:54
Location: Northern Illinois, USA

Re: can not connect ruby to mysql

Post by gerald_clark » 2015/05/17 19:27:27

post the output of:
rpm -q mysql mysql-server ruby

kiransharma755
Posts: 46
Joined: 2015/02/27 14:30:54

Re: can not connect ruby to mysql

Post by kiransharma755 » 2015/05/17 22:46:21

post the output of:
rpm -q mysql mysql-server ruby


-------------Here you are
bash-4.1# rpm -q mysql mysql-server ruby
mysql-5.1.73-3.el6_5.x86_64
mysql-server-5.1.73-3.el6_5.x86_64
ruby-1.8.7.374-4.el6_6.x86_64

Post Reply