MySQL Forums - Ruby

Using rails comparison operator in dev/production (no replies)

Simon Boyd — Mon, 06 May 2013 12:22:28 +0000

We had a production error using MySQL with latest rails 3.2 ruby 1.9.3 and MySQL fork.
In some cases we used in ActiveRecord (by mistake) statements the "==" comparison operator.

The problem is that it did work in development.
Using it in production would not be translated by rails active record to the correct SQL statement. (Occured in http://www.tipter.com/blogmytrip)

differences between prepare(stmt) and query(stmt) results (no replies)

Donald Leslie — Mon, 13 Aug 2012 16:48:39 +0000

I wanted to run a query where tested values changed in a loop.

Code was as follows:

query = 'SELECT meetings.meetings_key, meetings.meetings_date, meetings.title ' +
'FROM meetings, meeting_types ' +
'WHERE meetings.type_key = meeting_types.meeting_types_key ' +
"and meeting_types.meeting_type = ? " +
" AND year(meetings.meetings_date) >= ? " +
'ORDER BY meetings.meetings_key'

sth = @dbh.prepare(query)
type = 'Board'
year = '2012'
sth.execute(type,year)
row = sth.fetch
puts "#{sth} , #{row.class} - #{row}"
puts "#{row[0].class} , #{row[1].class} , #{row[2].class}"

This resulted in the following result:

# , Array - [6, #, "Jan board meeting"]
Fixnum , Mysql::Time , String

The result has the data typed as it will be used.
I wanted to be able to get the result as a hash, but fetch_hash was not available.
Looking further I found that fetch_hash is only available if I used query(stmt).

Running the following works:

query = 'SELECT meetings.meetings_key, meetings.meetings_date, meetings.title ' +
'FROM meetings, meeting_types ' +
'WHERE meetings.type_key = meeting_types.meeting_types_key ' +
"and meeting_types.meeting_type = \'Board\' " +
" AND year(meetings.meetings_date) >= \'2012\' " +
'ORDER BY meetings.meetings_key'

sth = @dbh.query(query)
row = sth.fetch_row
puts "#{sth} , #{row.class} - #{row}"
puts "#{row[0].class} , #{row[1].class} , #{row[2].class}"

But this returns :

# , Array - ["6", "2012-01-11", "Jan board meeting"]
String , String , String

Why the difference? I would really like to ba able to use fetch_hash with a
prepared statement or get the data in the form of the prepare results.

Google imap error (no replies)

Kristen Morey — Mon, 25 Jun 2012 12:37:04 +0000

I have created an application in PHP. I have also create a script in this application which reads inbox messages from my Gmail account. It is successfully executing at localhost but giving error on remote. I have tried almost every possible alternate as I understand but not succeed. It gives me following error at remote

imap_open() [function.imap-open]: Couldn't open stream {imap.gmail.com:993/imap/ssl}INBOX

I have used alternate imap's address from different forum discussion but not it not working.

My remote information as following:
Apache version 2.2.15
PHP version 5.2.9
MySQL version 5.0.95-community-log
Operating system linux

and having dedicated IP.

On the other hand, Localhost information as following:

Appache 2.2.17
PHP 5.3.5
MYSQL 5.5.8

Is this because of this difference??? or any other reason?

Thanks in advance
Kristen
http://www.seomanualsubmit.com

Error with MySQL and Rails 3.1.0 (no replies)

Gianna Bosanquet — Mon, 12 Mar 2012 09:36:41 +0000

I am getting this error during the instalation of an application Rails:

Gem files will remain installed in /home/mark/.bundler/tmp/28288/gems/mysql2-0.2.17 for inspection. Results logged to /home/mark/.bundler/tmp/28288/gems/mysql2-0.2.17/ext/mysql2/gem_make.out An error occured while installing mysql2 (0.2.17), and Bundler cannot continue. Make sure that gem install mysql2 -v '0.2.17' succeeds before bundling.

Can you help me to resolved the problem.

Ruby on Rails Developer - Why Ruby its a technology to really consider? (no replies)

Daniel Jackson — Thu, 09 Feb 2012 10:31:29 +0000

Hi,

Why Ruby on Rails is a technology to really consider?

Really its the replacement for Java?

http://innoppl.com/ruby-on-rails

store the image path in MySQL w/ Ruby API (no replies)

Jeny Joshi — Mon, 06 Feb 2012 15:06:17 +0000

Background: Ruby API is used to retrieve data from MySQL. This Ruby API is being used in Google SketchUp for some project.

Query:
I need to know how to store the image path using Ruby API not PHP in MySQl.

Is it possible to store the image path in MySQL without using any programming language?

Mysql connection with rails (no replies)

Mario Nikolaou — Fri, 20 Jan 2012 18:17:33 +0000

I have a problem connecting mysql with rails.I have by default connection to sqlite3.Please help because i have a project on ruby on rails and the connection with the database is the most important part.I have also consider to download sqlite3 gui(like workbench in mysql) and work with the current server.
I have spent days on that issue and i haven't found a solution.

table field information returning wrong length in 5.5.16 (no replies)

Donald Leslie — Tue, 27 Dec 2011 19:49:06 +0000

I have an application where I use the table field sizes to set widths in a gtk form.

After doing updating my system to opensuse 12.1 the forms no longer had the correct sizes. MySQL had been updated to V14.14 Distrib 5.5.16 x86_64. I do not know what it had been previously.

The code which was failing had the following:

info = dbh.list_fields
info.fetch_fields.each do |fields|
field_info = field.hash

For example a field with the type varchar(40) field_info['length'] had the value 120. I had another system where I had also updated opensuse but I had installed
V14.14 Distrib 5.5.19 x86_64. As a result I removed mysql and installed the later
version and the problem went away.

5.5.16 is the version available from the suse repository. To get 5.5.19 I had to go to your web site.

Xml Problem (no replies)

Get Big — Tue, 13 Dec 2011 14:11:44 +0000

Hellow!
I have a site : http://get-big.info and i get a problem!
I have a error between header and content!
Who can t help me to take this error out?pls

Launching Server for Rails (no replies)

Pedro Guedes — Wed, 02 Nov 2011 21:18:17 +0000

I have seen some people have the same problem, but haven't been able to apply their solution to solve my problem. I have Ruaby and rails set to start but when I attempt to launch the mysql server I get the following error:

/Library/Ruby/Gems/1.8/gems/mysql2-0.3.7/lib/mysql2/mysql2.bundle: dlopen(/Library/Ruby/Gems/1.8/gems/mysql2-0.3.7/lib/mysql2/mysql2.bundle, 9): Library not loaded: libmysqlclient.18.dylib (LoadError)
Referenced from: /Library/Ruby/Gems/1.8/gems/mysql2-0.3.7/lib/mysql2/mysql2.bundle
Reason: image not found - /Library/Ruby/Gems/1.8/gems/mysql2-0.3.7/lib/mysql2/mysql2.bundle

Does anyone have a solution for this?

RoR not pulling data from table (no replies)

david taylor — Thu, 27 Oct 2011 01:23:26 +0000

hey i'm new to RoR with mysql and i'm having a problem.

i set up a rails app with mysql, created a database in mysql in the terminal, created a table in the database. when i display the data in my browser after further configuring, it would seem as if the table is empty because the table data isn't displaying. i know it's not an issue with configuration as the table name shows up, just not the contents within it. i'm pretty baffled with why this is happeneing...any advice would be welcome

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (no replies)

vartika singh — Thu, 20 Oct 2011 23:30:31 +0000

Since yesterday I am trying to set up mysql on my Lion. I am not able to start mysql client through terminal. I have tried a lot of things as I found on google. Can someone please have a look and let me know if I am doing a blunder or similar?

➜ expertiza git:(master) ✗ bundle install
Using rake (0.9.2)
Using RedCloth (4.2.8)
Using activesupport (2.3.14)
Using rack (1.1.2)
Using actionpack (2.3.14)
Using actionmailer (2.3.14)
Using activerecord (2.3.14)
Using activeresource (2.3.14)
Using builder (2.1.2)
Using highline (1.6.2)
Using net-ssh (2.2.1)
Using net-scp (1.0.4)
Using net-sftp (2.0.5)
Using net-ssh-gateway (1.1.0)
Using capistrano (2.9.0)
Using culerity (0.2.15)
Using mime-types (1.16)
Using nokogiri (1.5.0)
Using rack-test (0.6.1)
Using ffi (1.0.10)
Using childprocess (0.2.2)
Using json_pure (1.6.1)
Using rubyzip (0.9.4)
Using selenium-webdriver (2.8.0)
Using capybara (0.3.9)
Using cgi_multipart_eof_fix (2.5.0)
Using columnize (0.3.4)
Using diff-lcs (1.1.3)
Using json (1.4.6)
Using term-ansicolor (1.0.7)
Using gherkin (2.2.9)
Using cucumber (0.9.4)
Using cucumber-rails (0.3.2)
Using daemons (1.1.4)
Using database_cleaner (0.6.7)
Using expertiza-authlogic (2.1.6.1)
Using fastercsv (1.5.4)
Using fastthread (1.0.7)
Using gdata (1.1.2)
Using gem_plugin (0.2.3)
Using hoptoad_notifier (2.4.11)
Using rbx-require-relative (0.0.5)
Using linecache (0.46)
Using mongrel (1.1.5)
Using mysql (2.8.1)
Using rails (2.3.14)
Using rdoc (3.11)
Using stream (0.5)
Using rgl (0.4.0)
Using ruby-debug-base (0.10.4)
Using ruby-debug (0.10.4)
Using bundler (1.0.21)
Your bundle is complete! Use `bundle show [gemname]` to see where a bundled gem is installed.

➜ sockets git:(master) ✗ brew upgrade mysql
==> Upgrading mysql
==> Downloading http://downloads.mysql.com/archives/mysql-5.5/mysql-5.5.15.tar.g
File already downloaded in /Users/vsingh3/Library/Caches/Homebrew
Error: MD5 mismatch
Expected: 306b5549c7bd72e8e705a890db0da82b
Got: d41d8cd98f00b204e9800998ecf8427e
Archive: /Users/vsingh3/Library/Caches/Homebrew/mysql-5.5.15.tar.gz
(To retry an incomplete download, remove the file above.)

➜ expertiza git:(master) ✗ mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

➜ expertiza git:(master) ✗ cd tmp

➜ tmp git:(master) ✗ cd sockets

➜ sockets git:(master) ✗ ls
mysql.sock

➜ sockets git:(master) ✗ vim mysql.sock
mysql.default_socket =/expertiza/tmp/sockets/mysql.sock --- I wrote this in mysql.sock file.

Connecting MySQL to Ruby problem (no replies)

amir ef — Sat, 03 Sep 2011 21:26:56 +0000

Hi
I read this link :
http://forums.mysql.com/read.php?116,431198,432706#msg-432706
and from it I go this link :
http://blog.mmediasys.com/2009/07/06/getting-started-with-rails-and-mysql/

and did same things that author said but when I type

rails mysqlapp --database=mysql

nothing happen but author said that in this step ruby connect to MySQL.
If someone can , exactly explain me after that I go install rail and mysql , what should I do ?
thanks

gem install mysql error on Windows7 (1 reply)

Hosam Adel — Thu, 01 Sep 2011 22:21:05 +0000

Hi.
I'm trying to install mysql on my machine and when I type gem install mysql or even gem install mysql2 I got an error, check this image:

http://d.pr/gpJl
Windows 7 32-bit

How can I solve this problem?

gem install mysql2 :: Error cannot find -lmysqlclient_r (no replies)

Bernardino Lopez — Tue, 09 Aug 2011 21:27:46 +0000

I install rvm in Fedora 15. like listed in the post:
https://plus.google.com/106336405206268952858/posts/g1URhoYF3qk

Also like to use MySQL, but when I try to install the gem for mysql2:

gem install mysql2

Script started on Mon 08 Aug 2011 12:48:23 PM CDT
?]0;myredhat@myfedora15:~/rails??[?1034h[myredhat@myfedora15 rails]$ su -?????[2Pll??clear?????df -h?????clear??[K??[K??[K??[K??[K?gem install mysql2

Building native extensions. This could take a while...

ERROR: Error installing mysql2:

ERROR: Failed to build gem native extension.

/usr/local/rvm/rubies/ruby-1.9.2-p290/bin/ruby extconf.rb

checking for rb_thread_blocking_region()... yes

checking for mysql.h... yes

checking for errmsg.h... yes

checking for mysqld_error.h... yes

creating Makefile

make

gcc -I. -I/usr/local/rvm/rubies/ruby-1.9.2-p290/include/ruby-1.9.1/i686-linux -I/usr/local/rvm/rubies/ruby-1.9.2-p290/include/ruby-1.9.1/ruby/backward -I/usr/local/rvm/rubies/ruby-1.9.2-p290/include/ruby-1.9.1 -I. -DHAVE_RB_THREAD_BLOCKING_REGION -DHAVE_MYSQL_H -DHAVE_ERRMSG_H -DHAVE_MYSQLD_ERROR_H -D_FILE_OFFSET_BITS=64 -I/usr/include/mysql -g -pipe -m32 -fPIC -g -static-libgcc -fno-omit-frame-pointer -fno-strict-aliasing -DMY_PTHREAD_FASTMUTEX=1 -fPIC -O3 -ggdb -Wextra -Wno-unused-parameter -Wno-parentheses -Wpointer-arith -Wwrite-strings -Wno-missing-field-initializers -Wno-long-long -fPIC -Wall -funroll-loops -o mysql2_ext.o -c mysql2_ext.c

gcc -I. -I/usr/local/rvm/rubies/ruby-1.9.2-p290/include/ruby-1.9.1/i686-linux -I/usr/local/rvm/rubies/ruby-1.9.2-p290/include/ruby-1.9.1/ruby/backward -I/usr/local/rvm/rubies/ruby-1.9.2-p290/include/ruby-1.9.1 -I. -DHAVE_RB_THREAD_BLOCKING_REGION -DHAVE_MYSQL_H -DHAVE_ERRMSG_H -DHAVE_MYSQLD_ERROR_H -D_FILE_OFFSET_BITS=64 -I/usr/include/mysql -g -pipe -m32 -fPIC -g -static-libgcc -fno-omit-frame-pointer -fno-strict-aliasing -DMY_PTHREAD_FASTMUTEX=1 -fPIC -O3 -ggdb -Wextra -Wno-unused-parameter -Wno-parentheses -Wpointer-arith -Wwrite-strings -Wno-missing-field-initializers -Wno-long-long -fPIC -Wall -funroll-loops -o client.o -c client.c

gcc -I. -I/usr/local/rvm/rubies/ruby-1.9.2-p290/include/ruby-1.9.1/i686-linux -I/usr/local/rvm/rubies/ruby-1.9.2-p290/include/ruby-1.9.1/ruby/backward -I/usr/local/rvm/rubies/ruby-1.9.2-p290/include/ruby-1.9.1 -I. -DHAVE_RB_THREAD_BLOCKING_REGION -DHAVE_MYSQL_H -DHAVE_ERRMSG_H -DHAVE_MYSQLD_ERROR_H -D_FILE_OFFSET_BITS=64 -I/usr/include/mysql -g -pipe -m32 -fPIC -g -static-libgcc -fno-omit-frame-pointer -fno-strict-aliasing -DMY_PTHREAD_FASTMUTEX=1 -fPIC -O3 -ggdb -Wextra -Wno-unused-parameter -Wno-parentheses -Wpointer-arith -Wwrite-strings -Wno-missing-field-initializers -Wno-long-long -fPIC -Wall -funroll-loops -o result.o -c result.c

result.c: In function ‘rb_mysql_result_fetch_row’:

result.c:253:31: warning: variable ‘tokens’ set but not used [-Wunused-but-set-variable]

result.c:267:58: warning: variable ‘tokens’ set but not used [-Wunused-but-set-variable]

result.c:310:33: warning: variable ‘tokens’ set but not used [-Wunused-but-set-variable]

result.c: In function ‘rb_mysql_result_fetch_fields’:

result.c:376:35: warning: comparison between signed and unsigned integer expressions [-Wsign-compare]

gcc -shared -o mysql2.so mysql2_ext.o client.o result.o -L. -L/usr/local/rvm/rubies/ruby-1.9.2-p290/lib -Wl,-R/usr/local/rvm/rubies/ruby-1.9.2-p290/lib -L. -rdynamic -Wl,-export-dynamic -Wl,-rpath,/usr/lib -Wl,-R -Wl,/usr/local/rvm/rubies/ruby-1.9.2-p290/lib -L/usr/local/rvm/rubies/ruby-1.9.2-p290/lib -lruby -L/usr/lib -lmysqlclient_r -lpthread -lm -lrt -ldl -lpthread -lrt -ldl -lcrypt -lm -lc

/usr/bin/ld: cannot find -lmysqlclient_r

collect2: ld returned 1 exit status

make: *** [mysql2.so] Error 1

Gem files will remain installed in /usr/local/rvm/gems/ruby-1.9.2-p290/gems/mysql2-0.3.6 for inspection.

Results logged to /usr/local/rvm/gems/ruby-1.9.2-p290/gems/mysql2-0.3.6/ext/mysql2/gem_make.out

?]0;myredhat@myfedora15:~/rails?[myredhat@myfedora15 rails]$ rpm -qa |grep MySQL

?[01;31m?[KMySQL?[m?[K-server-5.5.15-1.linux2.6.i386

?[01;31m?[KMySQL?[m?[K-devel-5.5.15-1.linux2.6.i386

?[01;31m?[KMySQL?[m?[K-shared-compat-5.5.15-1.linux2.6.i386

?[01;31m?[KMySQL?[m?[K-client-5.5.15-1.linux2.6.i386

?]0;myredhat@myfedora15:~/rails?[myredhat@myfedora15 rails]$ uname -a

Linux myfedora15 2.6.38.8-32.fc15.i686 #1 SMP Mon Jun 13 20:01:50 UTC 2011 i686 i686 i386 GNU/Linux

?]0;myredhat@myfedora15:~/rails?[myredhat@myfedora15 rails]$ exit

exit

Script done on Mon 08 Aug 2011 12:49:05 PM CDT

I try to upgrade but nothing seems to work... I wonder if this is a ruby/gem issue or some missing library in the mysql client. !!!.

THX in advance for the heads up.

Ruby on Rails (no replies)

sreeni nivas — Thu, 23 Jun 2011 11:00:11 +0000

Ruby on rails is a new technology, and easy to learn
Learners use this tutorials it superb

http://innoppl.com/ruby-on-rails/ download & try

Ruby on Rails expert (no replies)

sreeni nivas — Thu, 23 Jun 2011 10:58:28 +0000

Free tutorial about ruby on rail try this http://innoppl.com/ruby-on-rails/

initial password (no replies)

dreuzel dreuzel — Tue, 15 Feb 2011 15:59:02 +0000

I always wipe out my sql data for each instalation
using 5.5.8 I was never able to use any password (patch seemed to fail )

I need a simple proper working procedure to set the initial configuration wizard
password it failed for the last 10 jears or is mysql a piece of crapp ???

App issue running SSL and MySQL (no replies)

Jason Milian — Thu, 03 Feb 2011 20:27:19 +0000

Hello All -

This is my first post into this forum and I'm hoping someone can help. I currently have a RoR app that runs on Ubuntu with Apache, Passenger and Mysql. The issue is causing me to bang my head against the wall. Suffice to say however I don't know if this is a Apache/SSL issue or a Apache/MySQL issue or a RoR issue so any help is appreciated.

For all of our development, we have been running the
app via port 80 and all has worked fine. Now I need to implement SSL so
I got a certificate from a CA and installed it without any problems.
However when I bring up the application in a browser, the application
doesn't seem like it connects to MySQL. The page loads and I see the
security lock but the menue (which is derived from MySQL) doesn't load.
I have successfully made sure that the rails app can connect to MySQL
via command line by running ActiveRecord::Base.connection via the
console and it connects using the mysql socket. The MySQL is running on
the same server as the app so no outside connection is needed. If I
change my VHost back to port 80, everything runs correctly and it
connects to the db. I've looked into the logs for the app and notice
that even though I connect using https:// the app logs show http:. I
know SSL is working correctly in Apache because I can put up a plain
jane webiste using SSL and it comes up but when using this app
connecting to MySQL and https I get errors in the app and menus don't load.

SSLEngine On
SSLCertificateFile /etc/apache2/ssl/domain.com.crt
SSLCertificateKeyFile /etc/apache2/ssl/domain.key

ServerAdmin admin@localhost
ServerName test.domain.com
DocumentRoot /home/sysadmin/projects/App/public

Options FollowSymLinks
AllowOverride None
RAILSENV production

ScriptAlias /cgi-bin/ /usr/lib/cgi-bin/

AllowOverride None
Options ExecCGI -MultiViews +SymLinksIfOwnerMatch
Order allow,deny
Allow from all

ErrorLog /var/log/apache2/error.log

# Possible values include: debug, info, notice, warn, error, crit,
# alert, emerg.
LogLevel warn

CustomLog /var/log/apache2/access.log combined
ServerSignature On

Alias /doc/ "/usr/share/doc/"

Options Indexes MultiViews FollowSymLinks
AllowOverride None
Order deny,allow
Deny from all
Allow from 127.0.0.0/255.0.0.0 ::1/128

sequel gem and segfault - mysql gem line 343 (no replies)

dave lilley — Tue, 14 Dec 2010 09:55:39 +0000

hi there,

using 1.8.7 p302 via rubyinstaller

I can connect to a remote MYSQL server fine via mysql - trouble is i'm converting a linux app to windows and I have sequel code embedded throughout my project.

I have 1 script that handles the sql calls below is a sample of what the class initialization method does and the errors generated.

anyone able to help? (prefer to use sequel gem to save LOTS of recoding/debugging).

converting on WINXP virtual machine end OS is going to be W2K pro - win XP systems.

Doesn't seem to matter where i have the line - get_all_acccodes.each{|c| puts c}
it will segfault anyway.

the version of LIBmysql.dll is one I got from http://instantrails.rubyforge.org/svn/trunk/InstantRails-win/InstantRails/mysql/bin/libmySQL.dll
that file is 1.484Kb large and i have another that is like 242Kb this one also segfaults too.

sample code being used...

require 'sequel'
require 'logger'
# require 'mysql'

class Dopen

def initialize(*arg)
@path = "/logs"
@log = Logger.new("#{@path}DB - info.log")
@log.level = Logger::DEBUG

@log.debug('initialing the DB access!')

if arg[0] == 'local'
#was only used for test via my local server - i want to connect to the remote server only now!
else
puts 'in remote side'
@db = Sequel.mysql(:host => 'remote.co.nz', :user => "user", :password => "p/word", :database => "database", :logger => Logger.new( STDOUT ))

# test.each{|r| puts r} <<< 1st errors belong to this line - line 22

get_all_acccodes.each{|c| puts c} <<< 2nd errors belong to this line

# this connection code works fine below!!!
# @db = Mysql.new('remote.co.nz', "user", "p/word",'database')
# remote
end

rescue Sequel::Error
@log.debug("An error occurred\nError code: #{Sequel}\nError message: #{Sequel.to_s}")
ensure
@log.debug("DB closed!")
# @db.close if @db

end

def get_all_acccodes
@log.debug('getting all account codes')
@db[:cust_data].filter(:closed => 0, :contract => 0) # 1 = true account is CLOSED, 0 means it's OPEN

#line below works with mysql direct
# @db.query("select * from cust_data where closed = 0 and contract = 0")
end

end

a = Dopen.new 'remote' << allows for quick switching when i was developing locally

*** end of teh script file ****

Now if I change the connect line from Sequel.mysql(...) to Sequel.mysql.connect(...) i get a reference to as per error 3 - No user or password for Dave @ localhost!!!

I'm not conecting to a local host.

I do have Mysql community installed but will need to remove it to gain disk space back, I only did this because originally i couldn't even connect to the remote Mysql server and I thought i might need it locally.

any pointers on what I'm doing wrong?

many thanks for any - all help.

dave.

1st errors for simple show version of server being run....

C:\monitoring screen>ruby -rubygems sequel1.rb
in remote side
I, [2010-12-14T22:54:15.335004 #2740] INFO -- : (0.190273s) SET @@wait_timeout
= 2147483
I, [2010-12-14T22:54:15.535292 #2740] INFO -- : (0.200288s) SET SQL_AUTO_IS_NUL
L=0
I, [2010-12-14T22:54:15.715552 #2740] INFO -- : (0.180260s) SELECT VERSION()
VERSION()5.1.52
#
#
sequel1.rb:22:in `initialize': undefined method `each' for nil:NilClass (NoMetho
dError)
from sequel1.rb:159:in `new'
from sequel1.rb:159

C:\monitoring screen>

2nd error

C:\monitoring screen>ruby -rubygems sequel1.rb
in remote side
I, [2010-12-14T22:55:11.310100 #2776] INFO -- : (0.190273s) SET @@wait_timeout
= 2147483
I, [2010-12-14T22:55:11.500374 #2776] INFO -- : (0.190274s) SET SQL_AUTO_IS_NUL
L=0
I, [2010-12-14T22:55:11.710676 #2776] INFO -- : (0.210302s) SELECT * FROM `cust
_data` WHERE ((`closed` = 0) AND (`contract` = 0))
C:/Ruby187/lib/ruby/gems/1.8/gems/sequel-3.18.0/lib/sequel/adapters/mysql.rb:343
: [BUG] Segmentation fault
ruby 1.8.7 (2010-08-16 patchlevel 302) [i386-mingw32]

This application has requested the Runtime to terminate it in an unusual way.
Please contact the application's support team for more information.

C:\monitoring screen>

3rd error output...

C:\monitoring screen>ruby -rubygems sequel1.rb
in remote side
C:/Ruby187/lib/ruby/gems/1.8/gems/sequel-3.18.0/lib/sequel/adapters/mysql.rb:112
:in `real_connect': Access denied for user 'dave'@'localhost' (using password: N
O) (Mysql::Error)
from C:/Ruby187/lib/ruby/gems/1.8/gems/sequel-3.18.0/lib/sequel/adapters
/mysql.rb:112:in `connect'
from sequel1.rb:20:in `initialize'
from sequel1.rb:160:in `new'
from sequel1.rb:160

C:\monitoring screen>

Scripting the cutover from slave to master and back? (no replies)

Forrest Aldrich — Mon, 25 Oct 2010 20:40:22 +0000

We have an internal process by which we replicate our production data to a remote location (effectively a mirror of our production content). From time to time, we will change that slave to a master and test our code at that location, with the old /var/lib/mysql directory backed up first.

After we're done, the my.cnf is switched back along with the backup of /var/lib/mysql and it resumes replication where it left off.

This method works, but it's manually tedious. I know we can (and probably should) be using another method, but this is what we have to work with now.

My question is if there is some clever way through the Ruby scripting and API to facilitate this. I guess the simple answer would be to write a dumb shell script that just does the manual tasks and then report the result so that non-technical staff can trigger the change. It still doesn't feel right.... and I wanted some objective feedback.

We already use Ruby with Puppet for management and so it makes sense that we might consider this route.

Thanks!

libssl 1.0.0a_0 and mysql gem (no replies)

Piotr Szal — Tue, 17 Aug 2010 07:43:09 +0000

Hallo,

im use mysql gem version (2.8.1) and openssl @1.0.0a_0 (installed from MacPorts).

when im use mysql gem in my projects i have this error:

dyld: NSLinkModule() error
dyld: Library not loaded: /opt/local/lib/libssl.0.9.8.dylib
Referenced from: /Users/pisz/.multiruby/install/1.8.6-p114/lib/ruby/gems/1.8/gems/mysql-2.8.1/lib/mysql_api.bundle
Reason: image not found
Trace/BPT trap

because i have 1.0.0 version installed.

My svn and ssh works with the 1.0.0 version and i have to switch between this version of openssl to work with mysql
and ssh/svn.

Greets,
Piotr Szal

mysql ruby gems installation (1 reply)

ben reinhart — Mon, 26 Jul 2010 20:00:26 +0000

Alright I've seen some other peoples problems with installing the mysql gem but I had some other questions about it as well.

I'm on Mac OS X 10.6.4 Snow Leopard
First off, I am using mysql Ver 14.14 Distrib 5.1.49, for apple-darwin10.3.0 (i386) using readline 5.1

It's the 32 bit version.

I tried installing the gem with a multitude of commands. I tried the directory option, specifying the directory, I tried the --with-mysql-config=' option, specifying the correct mysql_config path, as well as the ARCHFLAGS command. None of them work. I also tried installing the 2.8.1 mysql gem version, but I think that's 64 bit and I have mysql 32 bit installed? Installing the 2.8.1 version works and it installs, but when I cd to my app, change my database.yml file, and type rake db:migrate I get this error:

rake db:migrate --trace
(in /Users/benreinhart/Rails/rails_app)
** Invoke db:migrate (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db:migrate
rake aborted!
uninitialized constant MysqlCompat::MysqlRes
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/activesupport-2.3.5/lib/active_support/dependencies.rb:440:in `load_missing_constant'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/activesupport-2.3.5/lib/active_support/dependencies.rb:80:in `const_missing'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/mysql_adapter.rb:9:in `define_all_hashes_method!'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/mysql_adapter.rb:68:in `mysql_connection'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:223:in `send'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:223:in `new_connection'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:245:in `checkout_new_connection'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:188:in `checkout'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:in `loop'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:in `checkout'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/monitor.rb:242:in `synchronize'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:183:in `checkout'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:98:in `connection'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:326:in `retrieve_connection'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_specification.rb:123:in `retrieve_connection'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_specification.rb:115:in `connection'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/migration.rb:435:in `initialize'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/migration.rb:400:in `new'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/migration.rb:400:in `up'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/migration.rb:383:in `migrate'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/rails-2.3.5/lib/tasks/databases.rake:116
/Users/benreinhart/.gem/ruby/1.8/gems/rake-0.8.7/lib/rake.rb:636:in `call'
/Users/benreinhart/.gem/ruby/1.8/gems/rake-0.8.7/lib/rake.rb:636:in `execute'
/Users/benreinhart/.gem/ruby/1.8/gems/rake-0.8.7/lib/rake.rb:631:in `each'
/Users/benreinhart/.gem/ruby/1.8/gems/rake-0.8.7/lib/rake.rb:631:in `execute'
/Users/benreinhart/.gem/ruby/1.8/gems/rake-0.8.7/lib/rake.rb:597:in `invoke_with_call_chain'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/monitor.rb:242:in `synchronize'
/Users/benreinhart/.gem/ruby/1.8/gems/rake-0.8.7/lib/rake.rb:590:in `invoke_with_call_chain'
/Users/benreinhart/.gem/ruby/1.8/gems/rake-0.8.7/lib/rake.rb:583:in `invoke'
/Users/benreinhart/.gem/ruby/1.8/gems/rake-0.8.7/lib/rake.rb:2051:in `invoke_task'
/Users/benreinhart/.gem/ruby/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `top_level'
/Users/benreinhart/.gem/ruby/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `each'
/Users/benreinhart/.gem/ruby/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `top_level'
/Users/benreinhart/.gem/ruby/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling'
/Users/benreinhart/.gem/ruby/1.8/gems/rake-0.8.7/lib/rake.rb:2023:in `top_level'
/Users/benreinhart/.gem/ruby/1.8/gems/rake-0.8.7/lib/rake.rb:2001:in `run'
/Users/benreinhart/.gem/ruby/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling'
/Users/benreinhart/.gem/ruby/1.8/gems/rake-0.8.7/lib/rake.rb:1998:in `run'
/Users/benreinhart/.gem/ruby/1.8/gems/rake-0.8.7/bin/rake:31
/usr/bin/rake:19:in `load'
/usr/bin/rake:19

I read in a bunch of places that installing the older version (2.7) works. So I did this:

bash-3.2# gem install mysql -v 2.7 -- --with-mysql-config=/usr/local/mysql/bin/mysql_config
Building native extensions. This could take a while...
Successfully installed mysql-2.7
1 gem installed
Installing ri documentation for mysql-2.7...
Installing RDoc documentation for mysql-2.7...
bash-3.2#

Then I cd to my app, (which has database.yml configured properly) and typed rake db:migrate and now I get this error:

rake db:migrate
(in /Users/benreinhart/Rails/rails_app)
dyld: lazy symbol binding failed: Symbol not found: _mysql_init
Referenced from: /Library/Ruby/Gems/1.8/gems/mysql-2.7/lib/mysql.bundle
Expected in: flat namespace

dyld: Symbol not found: _mysql_init
Referenced from: /Library/Ruby/Gems/1.8/gems/mysql-2.7/lib/mysql.bundle
Expected in: flat namespace

Trace/BPT trap

Anyone know? Please help!

Thank you so much...

Convert ruby file to c#.net - I will pay for it (no replies)

Rupendra Bensh — Sun, 25 Jul 2010 19:58:40 +0000

Convert simple ruby file to c#.net.

I will pay for it

undefined method `init' for Mysql:Class error (1 reply)

Ankit Desai — Fri, 30 Jul 2010 13:00:28 +0000

Hi,

I'm trying to set up just a basic blog on my webhost so I can just get everything working before I do more but I keep getting this error when I go add tables to the database via command line:

Ankit-Desais-MacBook-Pro:mogo ankit$ rake db:migrate --trace
(in /Users/ankit/Sites/mogo)
** Invoke db:migrate (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db:migrate
rake aborted!
undefined method `init' for Mysql:Class
/Users/ankit/.bundle/ruby/1.8/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/mysql_adapter.rb:30:in `mysql_connection'
/Users/ankit/.bundle/ruby/1.8/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connection_pool.rb:226:in `send'
/Users/ankit/.bundle/ruby/1.8/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connection_pool.rb:226:in `new_connection'
/Users/ankit/.bundle/ruby/1.8/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connection_pool.rb:248:in `checkout_new_connection'
/Users/ankit/.bundle/ruby/1.8/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connection_pool.rb:190:in `checkout'
/Users/ankit/.bundle/ruby/1.8/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connection_pool.rb:186:in `loop'
/Users/ankit/.bundle/ruby/1.8/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connection_pool.rb:186:in `checkout'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/monitor.rb:242:in `synchronize'
/Users/ankit/.bundle/ruby/1.8/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connection_pool.rb:185:in `checkout'
/Users/ankit/.bundle/ruby/1.8/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connection_pool.rb:99:in `connection'
/Users/ankit/.bundle/ruby/1.8/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connection_pool.rb:330:in `retrieve_connection'
/Users/ankit/.bundle/ruby/1.8/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connection_specification.rb:103:in `retrieve_connection'
/Users/ankit/.bundle/ruby/1.8/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connection_specification.rb:95:in `connection'
/Users/ankit/.bundle/ruby/1.8/gems/activerecord-3.0.0.beta4/lib/active_record/migration.rb:459:in `initialize'
/Users/ankit/.bundle/ruby/1.8/gems/activerecord-3.0.0.beta4/lib/active_record/migration.rb:406:in `new'
/Users/ankit/.bundle/ruby/1.8/gems/activerecord-3.0.0.beta4/lib/active_record/migration.rb:406:in `up'
/Users/ankit/.bundle/ruby/1.8/gems/activerecord-3.0.0.beta4/lib/active_record/migration.rb:388:in `migrate'
/Users/ankit/.bundle/ruby/1.8/gems/activerecord-3.0.0.beta4/lib/active_record/railties/databases.rake:140
/Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:636:in `call'
/Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:636:in `execute'
/Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:631:in `each'
/Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:631:in `execute'
/Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:597:in `invoke_with_call_chain'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/monitor.rb:242:in `synchronize'
/Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:590:in `invoke_with_call_chain'
/Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:583:in `invoke'
/Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:2051:in `invoke_task'
/Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `top_level'
/Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `each'
/Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `top_level'
/Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling'
/Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:2023:in `top_level'
/Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:2001:in `run'
/Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling'
/Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:1998:in `run'
/Library/Ruby/Gems/1.8/gems/rake-0.8.7/bin/rake:31
/usr/local/bin/rake:19:in `load'
/usr/local/bin/rake:19

Anyone faced this issue before? There was another thread about this but no one answered it and it's been closed.

Thanks in advance,
Ankit

Merge al Databases from 2 into one mysql-DBMS (no replies)

T. Schulz — Wed, 30 Jun 2010 11:18:35 +0000

I have Ruby on Rails and in Fact mysql 2 times installed
on my Windows XP.
Now Rails do not work witout trouble and MySql don't work right, too.
What ist my wish:
I want, to merge the 2 installations of Rails and both installations
of MySql, because I don't want to loose my Projekts.
After that, I want to install Hobo and I want to continue with Hobo.
The first Rails was instrails and the second Rails-installation was
bitnami. both I have extended with an own mysql-installation on
different drives, because after the bitnami-installation, the
aplikations won't run with mysql.
I know, that it was addlebrained, but now it is the status quo.
But, which steps I have to do for save my databases into one and path without loosing my work? which files I must move to other directorys and which files I have to edit and write in the new pathes for the correct mysql-instance?
May I have to edit the regedit, too?
Thanks
Torsten

mysql.so isn't found (no replies)

Z E — Wed, 30 Jun 2010 04:24:41 +0000

I am trying to use the taps gem to push my database to Heroku, however, whenever I do the command:

$heroku db:push

I get the following error:

Failed to connect to database:
Sequel::AdapterNotFound -> LoadError: require 'mysql' did not define Mysql::CLIENT_MULTI_RESULTS!
You are probably using the pure ruby mysql.rb driver,
which Sequel does not support. You need to install
the C based adapter, and make sure that the mysql.so
file is loaded instead of the mysql.rb file.

How do I fix this? I am unable to find this mysql.so driver.

mysql installation errors (no replies)

Nivedita Chamarthy — Wed, 16 Jun 2010 21:59:53 +0000

Hey I am a newbie to mysql and ruby on rails frame work. I have installed mysql 5.1.47. it worked properly. But when I wanted to use it in rails frame work, by running rails command rake db:migrate,after setting up the database, I am not able to execute it. The error I got was
rake aborted!
Access denied for user 'root'@'localhost' (using password : NO)

But I had set the password while installing and accessed mysql database without connecting to rails.

And also, after running the rails command "rake db:migrate", I am not able to access even the mysql database alone. When i attempted to run mysql from command prompt, I was not able to get access. The error I got was
ERROR 1045 (28000) : Access denied for user 'ODBC'@'localhost' (using password : NO)
I tried starting mysql with mysql -u root -p
then I got the prompt to enter password
after entering the password, i got the error
"Access denied for user 'ODBC'@'localhost' (using password : Yes)"

I dont know y this error is coming still, after the password is been set.
Please help me out. I am so confused and no idea of fixing this error. And moreover I have to rush in getting rails frame work with mysql installed, as my project due is coming soon.
Any help is appreciated.

Thanks in Advance !!

Ruby APIs (no replies)

Gjermund Lunder — Thu, 10 Jun 2010 15:28:41 +0000

Hi, Sorry if this is a wrong forum to post this. I'm new with MySql.

I've a simple question.
I have mysql version: 5.1.47-community
Ruby version 1.8.6-p398

Both on Windows XP. Our environment does not permit linux og cygwin (I'm used to work on these platfoms).

I've applied mysql gem with gem install mysql.

Do I need to add something more to ruby or mysql to do siple selects and insert to the database from ruby.

I've tried insert and get 0 (number zero) into the table, and ruby have problems with :

get '/' do
my = Mysql.new('localhost', 'root', 'sadmin', 'mysql')
st = my.prepare("SELECT VERSION()")
st.execute
# Get the result set
result= st.fetch

# Print out the result
puts result.to_s
st.close

haml :index
end

can anyone help me? Please. With only Windows I have problems with solving this. As far as I know all API's are allready installed with the default installation of ruby and mysql as described above. Just my code that is bad :-)

Thanks!

Best regards
Gjermund (DBA - Oracle)

avg () and Joins in mysql (no replies)

Erfan anjum — Mon, 24 May 2010 18:22:30 +0000

hi,

i am using following query to fetch data from multiple tables now i want to get the average of fetched records.
like i want to get the average marks of IRFAN.

CAN ANYONE PLS TELL ME HOW TO USE AVG() IN THIS QUERY

$QUERY = "SELECT subject,FirstName,marks FROM subject,all_members,marks WHERE all_members.mid = marks.mid and subject.subjectid = marks.subjectid and marks>=40 and all_members.FirstName='irfan'";
$rs = mysql_query($QUERY);