MySQL Forums - Ruby

MySql connection error localhost 10061 (2 replies)

Peter Mooney — Tue, 06 Oct 2020 15:27:30 +0000

Hello.
I cant connet to localhost:3000 I get the following error.

Mysql2::Error::ConnectionError

Can't connect to MySQL server on 'localhost' (10061)

conn_attrs = parse_connect_attrs(opts[:connect_attrs])

connect user, pass, host, port, database, socket, flags, conn_attrs
end

def parse_ssl_mode(mode)

I'm creating a ruby on rails application. When I create the app and create a dummy page it works, I can also connect to the your on rails page. But when I close it and open it again I get this message.

Can you help.

Peter.

Permission denied (no replies)

Sadrac Torres — Thu, 25 Jan 2018 05:17:27 +0000

Fetching mysql2 0.4.10
Installing mysql2 0.4.10 with native extensions
Errno::EACCES: Permission denied @ rb_sysopen -
/Users/escorpion/.rbenv/versions/2.5.0/lib/ruby/gems/2.5.0/gems/mysql2-0.4.10/CHANGELOG.md
An error occurred while installing mysql2 (0.4.10), and Bundler
cannot continue.
Make sure that `gem install mysql2 -v '0.4.10'` succeeds before bundling.

In Gemfile:
mysql2
run bundle exec spring binstub --all
rbenv: spring: command not found

The `spring' command exists in these Ruby versions:
2.4.1
2.4.3

MySQL Evolution - From 5.6 to 8.0 -- plus Ruby on Rails (no replies)

Edwin Desouza — Fri, 05 May 2017 16:46:43 +0000

MySQL Evolution - From 5.6 to 8.0 -- plus Ruby on Rails
https://drivy.engineering/mysql-evolution/

ruby to Mysql Cluster/multi-master (no replies)

Lucas Jackson — Mon, 30 Nov 2015 18:37:51 +0000

Still looking for a gem that can connect to 2 masters, i.e. the sql access nodes in Mysql Cluster.
Right now the only options are: use jruby with connector/j or install haproxy+keepalived.
Is there simply no interest in ruby to have enterprise features like this?
This seems like a pretty big one if you want to hang out at the grown-ups table.

-Tony

Ruby with Mysql (1 reply)

Ram jaganathan — Sat, 26 Sep 2015 17:22:22 +0000

1,What are the software needed for connecting RUBY with MYSQL?.

I installed ruby.

2,And steps to connect ruby with mysql for insertion and updation.

Thanks in Advance.

How to manage ruby code (no replies)

BZ Testv — Sat, 04 Jul 2015 15:13:16 +0000

How to manage ruby code

ruby app and MySQL server has gone away error (no replies)

Piotr Kirklewski — Wed, 03 Dec 2014 19:36:23 +0000

Hi there,

I'm running a ruby - multi-threaded application that collects data over the internet and then connects to MySQL to do a simple insert.

insert into churches.us values('','NULL','XYZ Christian Church','43.268158','-99.731361','0011111111111','200 N XYZ Ave','Shmack City','Shmack%2CCity','IA',NOW())

Everything works great until there is around 2600 records in the database.
Then some (not all) of the attempts to insert end up in the error: "MySQL server has gone away". The query that fails looks normal and works if I run them manually. Also no slow queries are being logged to the file configured in my.cnf. No errors appear in mysql.err

I can't figure out why the error.

There is plenty of memory on the server:

free -lmh
total used free shared buffers cached
Mem: 8.8G 1.1G 7.7G 6.4M 94M 162M
Low: 8.8G 1.1G 7.7G
High: 0B 0B 0B
-/+ buffers/cache: 863M 7.9G
Swap: 2.0G 0B 2.0G

select count(*) from churches.us

+----------+
| count(*) |
+----------+
| 2527 |
+----------+

root@fd001:~/test# mysql -u root -p'bleeeeep' -e "show variables like '%wait%';show variables like '%errors%'"
+---------------------------------------------------+----------+
| Variable_name | Value |
+---------------------------------------------------+----------+
| innodb_lock_wait_timeout | 3600 |
| innodb_spin_wait_delay | 6 |
| lock_wait_timeout | 31536000 |
| performance_schema_events_waits_history_long_size | 10000 |
| performance_schema_events_waits_history_size | 10 |
| wait_timeout | 28800 |
+---------------------------------------------------+----------+
+--------------------+---------+
| Variable_name | Value |
+--------------------+---------+
| max_connect_errors | 1000000 |
| slave_skip_errors | OFF |
+--------------------+---------+

root@fd001:~/test# mysql -u root -p'bleeep' -e "show status like '%conn%'; show status like '%thread%'"
+--------------------------+-------+
| Variable_name | Value |
+--------------------------+-------+
| Aborted_connects | 0 |
| Connections | 3105 |
| Max_used_connections | 25 |
| Ssl_client_connects | 0 |
| Ssl_connect_renegotiates | 0 |
| Ssl_finished_connects | 0 |
| Threads_connected | 8 |
+--------------------------+-------+
+------------------------------------------+-------+
| Variable_name | Value |
+------------------------------------------+-------+
| Delayed_insert_threads | 0 |
| Performance_schema_thread_classes_lost | 0 |
| Performance_schema_thread_instances_lost | 0 |
| Slow_launch_threads | 0 |
| Threads_cached | 8 |
| Threads_connected | 8 |
| Threads_created | 83 |
| Threads_running | 2 |
+------------------------------------------+-------+

key_buffer = 128M
max_allowed_packet = 256M
max_connect_errors = 1000000
thread_stack = 192K
thread_cache_size = 16
max_connections = 1024
table_cache = 256
thread_concurrency = 1024

root@fd001:~/test# cat /proc/version
Linux version 3.13.0-40-generic (buildd@comet) (gcc version 4.8.2 (Ubuntu 4.8.2-19ubuntu1) ) #69-Ubuntu SMP Thu Nov 13 17:53:56 UTC 2014

root@fd001:~/test# ruby -v
ruby 2.1.4p265 (2014-10-27 revision 48166) [x86_64-linux]

To MySQL or NoSQL (no replies)

Tabish Naeem — Sun, 05 Oct 2014 11:42:09 +0000

Hello,

I'm torn in between choosing to use MySQL & NoSQL for a crowd sourcing platform to be developed using Ruby on Rails.

Will value you guys input on this.

A complicated query? (no replies)

Grace Xue — Wed, 28 May 2014 11:17:46 +0000

Hi all, I'm really new to programming, so appologise in advance if any of my questions seems silly. :) I'm playing with an webapp for internal use, however having trouble completing a query. below are the table structure.

Children
ID, LID, Network_id, status (active or archived), longitude, latitude

Visit
ID, date

Visit_histories
ID, visit_id, child_id, cancelled

Each children get visited once a month, and I want to have a google map that can display the locations for all active children whose last visit is xx days ago. (e.g. 30 days ago)

I'm thinking creating a view that returns the followings:
child_id, network_id, last_visit_days, longitude, latitude

Other notes:
- Some children who just joined the program, so there wouldn't be a record in the visit_histories table. the returned value in this case can be nil.

- Some booked visits are cancelled because of one reason or another.

- the last_visit_days in the view is a calculated field using the last_visit_day in the visit_histories (only the ones that havnt been cancelled)

I have this query
Select vh.child_id, max(v.date) from visits v, visit_histories vh where v.id = vh.visit_id and cancelled <> 1 group by vh.child_id

which displays the last visit date for each child in the visit histories table. But this does not display new child who just joined. I then need to combine this result with the children table to get all the children, however I cant get the outter jion query to work properly.

Many thanks in advance.

Why does my checkout button not work all of a sudden? (no replies)

Roland Rock — Wed, 22 May 2013 07:32:17 +0000

Have an app that I have been developing, that uses to work up until some recent changes. I ran a bundle update, and a bunch of gems updated. Since then my checkout process..!!

ROR

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>