# Ruby, mysql & NetBeans (6.7.1)

**URL:** <https://www.ruby-forum.com/t/ruby-mysql-netbeans-6-7-1/179461>\
**Category:** Rails\
**Created:** [November 25, 2009, 3:53pm UTC](https://www.ruby-forum.com/t/ruby-mysql-netbeans-6-7-1/179461 "2009-11-25T15:53:50Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![quark](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/q/5e9695/32.png) [@quark](https://www.ruby-forum.com/u/quark)\
**Post date:** [November 25, 2009, 3:53pm UTC](https://www.ruby-forum.com/t/ruby-mysql-netbeans-6-7-1/179461/1 "2009-11-25T15:53:50Z")

</div>

Hello, I’m new on Ruby on NetBeans, I’m working with a windows XP. I’m  
tried to build mysql gem and I’ve got an error message:

JRuby limited openssl loaded. gem install jruby-openssl for full  
support.  
[http://wiki.jruby.org/wiki/JRuby\_Builtin\_OpenSSL](http://wiki.jruby.org/wiki/JRuby_Builtin_OpenSSL)  
Building native extensions. This could take a while…  
ERROR: Error installing mysql:  
ERROR: Failed to build gem native extension.

C:/Archivos de programa/NetBeans 6.7.1/ruby2/jruby-1.2.0/bin/jruby.bat  
extconf.rb install mysql --no-rdoc --no-ri  
El sistema no puede hallar la ruta especificada.

Should somebody help me, plese ? Thanks a lot.

---

<div class="post-metadata">

**Author:** ![quark](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/q/5e9695/32.png) [@quark](https://www.ruby-forum.com/u/quark)\
**Post date:** [November 25, 2009, 4:29pm UTC](https://www.ruby-forum.com/t/ruby-mysql-netbeans-6-7-1/179461/2 "2009-11-25T16:29:10Z")

</div>

Luis Sanmartin wrote:

> Hello, I’m new on Ruby on NetBeans,

I would strongly recommend that you not use NetBeans for Rails  
development. It’s a great IDE for other things, but it’s overkill for  
Rails. Try KomodoEdit or similar.

> I’m working with a windows XP. I’m  
> tried to build mysql gem and I’ve got an error message:
> 
> JRuby limited openssl loaded. gem install jruby-openssl for full  
> support.  
> [http://wiki.jruby.org/wiki/JRuby\_Builtin\_OpenSSL](http://wiki.jruby.org/wiki/JRuby_Builtin_OpenSSL)  
> Building native extensions. This could take a while…  
> ERROR: Error installing mysql:  
> ERROR: Failed to build gem native extension.
> 
> C:/Archivos de programa/NetBeans 6.7.1/ruby2/jruby-1.2.0/bin/jruby.bat  
> extconf.rb install mysql --no-rdoc --no-ri  
> El sistema no puede hallar la ruta especificada.
> 
> Should somebody help me, plese ? Thanks a lot.

Do you have the mySQL DB server installed? You need that – or at least  
the dev headers – for the gem to build, I believe.

(BTW, try PostgreSQL at some point. It’s a better DB.)

## Best,

Marnen Laibow-Koser  
[http://www.marnen.org](http://www.marnen.org)  
removed\_email\_address@domain.invalid

---

<div class="post-metadata">

**Author:** ![quark](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/q/5e9695/32.png) [@quark](https://www.ruby-forum.com/u/quark)\
**Post date:** [November 25, 2009, 5:06pm UTC](https://www.ruby-forum.com/t/ruby-mysql-netbeans-6-7-1/179461/3 "2009-11-25T17:06:40Z")

</div>

Thanks Marnen for response.

yes I have mysql how service and it’s running.

Reviewing the error, I found that the problem is to run jruby.bat,  
because the error message says "The system can not find the path  
specified. I have executed jruby.bat by command line and gives me the  
same error. I’ve open the file but I didn’t understand the variables in  
the code

The only thing I did was add to the Windows system var PATH the  
following path but nothing has changed: “C: \ Program Files \ NetBeans  
6.7.1 \ ruby2 \ jruby-1.2.0 \ bin”

* * *

thanks,  
Luis Fernando

## @echo off rem

rem jruby.bat - Start Script for the JRuby Interpreter  
rem  
rem for info on environment variables, see internal batch script  
\_jrubyvars.bat

setlocal

rem Sometimes, when jruby.bat is being invoked from another BAT file,  
rem %~dp0 is incorrect and points to the current dir, not to JRuby’s bin  
dir,  
rem so we look on the PATH in such cases.  
IF EXIST “%~dp0\_jrubyvars.bat” (set FULL\_PATH=%~dp0) ELSE (set  
FULL\_PATH=%~dp$PATH:0)

call “%FULL\_PATH%\_jrubyvars.bat” %\*

if %JRUBY\_BAT\_ERROR%==0 “%\_STARTJAVA%” %\_VM\_OPTS%  
-Xbootclasspath/a:“%JRUBY\_CP%” -classpath “%CP%;%CLASSPATH%”  
-Djruby.home=“%JRUBY\_HOME%” -Djruby.lib=“%JRUBY\_HOME%\lib”  
-Djruby.shell=“cmd.exe” -Djruby.script=jruby.bat org.jruby.Main  
%JRUBY\_OPTS% %\_RUBY\_OPTS%  
set E=%ERRORLEVEL%

call “%FULL\_PATH%\_jrubycleanup”

rem 1. exit must be on the same line in order to see local %E% variable!  
rem 2. we must use cmd /c in order for the exit code properly returned!  
rem See JRUBY-2094 for more details.  
endlocal & cmd /d /c exit /b %E%

* * *

Marnen Laibow-Koser wrote:

> Luis Sanmartin wrote:
> 
> > Hello, I’m new on Ruby on NetBeans,
> 
> I would strongly recommend that you not use NetBeans for Rails  
> development. It’s a great IDE for other things, but it’s overkill for  
> Rails. Try KomodoEdit or similar.
> 
> > I’m working with a windows XP. I’m  
> > tried to build mysql gem and I’ve got an error message:
> > 
> > JRuby limited openssl loaded. gem install jruby-openssl for full  
> > support.  
> > [http://wiki.jruby.org/wiki/JRuby\_Builtin\_OpenSSL](http://wiki.jruby.org/wiki/JRuby_Builtin_OpenSSL)  
> > Building native extensions. This could take a while…  
> > ERROR: Error installing mysql:  
> > ERROR: Failed to build gem native extension.
> > 
> > C:/Archivos de programa/NetBeans 6.7.1/ruby2/jruby-1.2.0/bin/jruby.bat  
> > extconf.rb install mysql --no-rdoc --no-ri  
> > El sistema no puede hallar la ruta especificada.
> > 
> > Should somebody help me, plese ? Thanks a lot.
> 
> Do you have the mySQL DB server installed? You need that – or at least  
> the dev headers – for the gem to build, I believe.
> 
> (BTW, try PostgreSQL at some point. It’s a better DB.)
> 
> ## Best,
> 
> Marnen Laibow-Koser  
> [http://www.marnen.org](http://www.marnen.org)  
> removed\_email\_address@domain.invalid

---

<div class="post-metadata">

**Author:** ![quark](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/q/5e9695/32.png) [@quark](https://www.ruby-forum.com/u/quark)\
**Post date:** [November 26, 2009, 2:45pm UTC](https://www.ruby-forum.com/t/ruby-mysql-netbeans-6-7-1/179461/4 "2009-11-26T14:45:38Z")

</div>

Sameera G. wrote:

> Luis Sanmartin wrote:
> 
> > Hello, I’m new on Ruby on NetBeans, I’m working with a windows XP. I’m  
> > tried to build mysql gem and I’ve got an error message:
> > 
> > JRuby limited openssl loaded. gem install jruby-openssl for full  
> > support.  
> > [http://wiki.jruby.org/wiki/JRuby\_Builtin\_OpenSSL](http://wiki.jruby.org/wiki/JRuby_Builtin_OpenSSL)  
> > Building native extensions. This could take a while…  
> > ERROR: Error installing mysql:  
> > ERROR: Failed to build gem native extension.
> > 
> > C:/Archivos de programa/NetBeans 6.7.1/ruby2/jruby-1.2.0/bin/jruby.bat  
> > extconf.rb install mysql --no-rdoc --no-ri  
> > El sistema no puede hallar la ruta especificada.
> > 
> > Should somebody help me, plese ? Thanks a lot.
> 
> Hi Sanmartin,
> 
> First of all I agreed with Marnen, I’m using NetBeans for development  
> (on linux) and thinking of going to another editor as its a huge  
> resource hog…
> 
> For your problem you have 3 options,
> 
> 1 - Change your ruby platform from JRuby to Ruby  
> (go to your rails project properties  
> select Rails - from the left hand side  
> change the Ruby Platform (Assuming you dont want to use JRuby)  
> )
> 
> 2 - as Marnen says, you can try PostgreSQL
> 
> 3 - If you are new to rails, why not using sqlite3 which comes default  
> with rails, you dont want to install anything, just create a project  
> go to command line - type rails
> 
> ```
> and sqlite3 is automatically setting for you
> 
> development:
> adapter: sqlite3
> database: db/development.sqlite3
> pool: 5
> timeout: 5000
> 
> ```
> 
> Hope this helps,
> 
> cheers,  
> sameera

Hello Sameera, Marnen.

I’ll be honest, the Marnen council did not convince me, so I kept  
researching and finding information on the Internet but without success.  
In my research I have seen that the problem is not with MySQL and there  
should be some sort of incompatibility between Windows XP and Ruby 1.8,  
then after trying to incorporate into my installed NetBeans other  
“Gems”, I got the same result, so I decided to try for “command line”  
for both JRuby and Ruby, and I’m getting the same error message.  
"invalid gem format”.  
As I read that exists some Gems with “C” code, so I decided to install  
MinGW and set PATH, but without success. Any ideas please?

greetings  
fernando

---

<div class="post-metadata">

**Author:** ![quark](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/q/5e9695/32.png) [@quark](https://www.ruby-forum.com/u/quark)\
**Post date:** [November 26, 2009, 1:59pm UTC](https://www.ruby-forum.com/t/ruby-mysql-netbeans-6-7-1/179461/5 "2009-11-26T13:59:21Z")

</div>

Luis Sanmartin wrote:

> Hello, I’m new on Ruby on NetBeans, I’m working with a windows XP. I’m  
> tried to build mysql gem and I’ve got an error message:
> 
> JRuby limited openssl loaded. gem install jruby-openssl for full  
> support.  
> [http://wiki.jruby.org/wiki/JRuby\_Builtin\_OpenSSL](http://wiki.jruby.org/wiki/JRuby_Builtin_OpenSSL)  
> Building native extensions. This could take a while…  
> ERROR: Error installing mysql:  
> ERROR: Failed to build gem native extension.
> 
> C:/Archivos de programa/NetBeans 6.7.1/ruby2/jruby-1.2.0/bin/jruby.bat  
> extconf.rb install mysql --no-rdoc --no-ri  
> El sistema no puede hallar la ruta especificada.
> 
> Should somebody help me, plese ? Thanks a lot.

Hi Sanmartin,

First of all I agreed with Marnen, I’m using NetBeans for development  
(on linux) and thinking of going to another editor as its a huge  
resource hog…

For your problem you have 3 options,

1 - Change your ruby platform from JRuby to Ruby  
(go to your rails project properties  
select Rails - from the left hand side  
change the Ruby Platform (Assuming you dont want to use JRuby)  
)

2 - as Marnen says, you can try PostgreSQL

3 - If you are new to rails, why not using sqlite3 which comes default  
with rails, you dont want to install anything, just create a project  
go to command line - type rails

```
and sqlite3 is automatically setting for you

development:
  adapter: sqlite3
  database: db/development.sqlite3
  pool: 5
  timeout: 5000

```

Hope this helps,

cheers,  
sameera

---

<div class="post-metadata">

**Author:** ![quark](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/q/5e9695/32.png) [@quark](https://www.ruby-forum.com/u/quark)\
**Post date:** [November 26, 2009, 6:58pm UTC](https://www.ruby-forum.com/t/ruby-mysql-netbeans-6-7-1/179461/6 "2009-11-26T18:58:06Z")

</div>

Hi fernando,

To Be sure I know there is no compatibility with Windows XP and Ruby  
1.8,  
(coz i have used it)

If possible why not try following

uninstall netbeans  
uninstall ruby  
uninstall rails (gem uninstall )

Do everything from the scratch

install ruby ([Download Ruby](http://www.ruby-lang.org/en/downloads/)) (standard ruby not  
jruby)  
install rubygems ([http://docs.rubygems.org/read/chapter/3](http://docs.rubygems.org/read/chapter/3))  
install rails ([http://rubyonrails.org/download](http://rubyonrails.org/download))

and also check this out

> **[Installing Rails on Windows (step-by-step tutorial)](https://allaboutruby.wordpress.com/2006/01/09/installing-rails-on-windows-step-by-step-tutorial/)**
>
> 20 July 09 Note – The new version of the Rails Windows installation guide is there. And the great news is that I even did it on the Rails v.2.3.3, released today! Please follow the instructio…

Hope this helps 😃

---

<div class="post-metadata">

**Author:** ![quark](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/q/5e9695/32.png) [@quark](https://www.ruby-forum.com/u/quark)\
**Post date:** [November 27, 2009, 10:19am UTC](https://www.ruby-forum.com/t/ruby-mysql-netbeans-6-7-1/179461/7 "2009-11-27T10:19:50Z")

</div>

Sameera G. wrote:

> Hi fernando,
> 
> To Be sure I know there is no compatibility with Windows XP and Ruby  
> 1.8,  
> (coz i have used it)
> 
> If possible why not try following
> 
> uninstall netbeans  
> uninstall ruby  
> uninstall rails (gem uninstall )
> 
> Do everything from the scratch
> 
> install ruby ([Download Ruby](http://www.ruby-lang.org/en/downloads/)) (standard ruby not  
> jruby)  
> install rubygems ([http://docs.rubygems.org/read/chapter/3](http://docs.rubygems.org/read/chapter/3))  
> install rails ([http://rubyonrails.org/download](http://rubyonrails.org/download))
> 
> and also check this out
> 
> [Installing Rails on Windows (step-by-step tutorial) | All About Ruby](http://allaboutruby.wordpress.com/2006/01/09/installing-rails-on-windows-step-by-step-tutorial/)
> 
> Hope this helps 😃

thanks I’ll try, I will communicate the result …

Fernando…

---

<div class="post-metadata">

**Author:** ![quark](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/q/5e9695/32.png) [@quark](https://www.ruby-forum.com/u/quark)\
**Post date:** [December 3, 2009, 5:48pm UTC](https://www.ruby-forum.com/t/ruby-mysql-netbeans-6-7-1/179461/8 "2009-12-03T17:48:46Z")

</div>

Sameera G. wrote:

> Hi fernando,
> 
> To Be sure I know there is no compatibility with Windows XP and Ruby  
> 1.8,  
> (coz i have used it)
> 
> If possible why not try following
> 
> uninstall netbeans  
> uninstall ruby  
> uninstall rails (gem uninstall )
> 
> Do everything from the scratch
> 
> install ruby ([Download Ruby](http://www.ruby-lang.org/en/downloads/)) (standard ruby not  
> jruby)  
> install rubygems ([http://docs.rubygems.org/read/chapter/3](http://docs.rubygems.org/read/chapter/3))  
> install rails ([http://rubyonrails.org/download](http://rubyonrails.org/download))
> 
> and also check this out
> 
> [Installing Rails on Windows (step-by-step tutorial) | All About Ruby](http://allaboutruby.wordpress.com/2006/01/09/installing-rails-on-windows-step-by-step-tutorial/)
> 
> Hope this helps 😃

Hello, well, these days I’ve been to Linux, Ubuntu 9.10, with the latest  
updates. I have installed ruby with the command “apt-get install ruby”  
and I noticed that I have version 1.8.7. I wanted to install version 9  
and I have done through the package manager “Synaptic”. when I invoke  
ruby by CLI, I see that version 1.8 is maintained, I conducted a search  
in the system and see that I have 3 versions: 1.8.7, 1.9.0, 1.9.1. And  
do not how to activate the 1.9.1. I have edited the “/ etc / apparmor.d  
/ abstractions / ruby” and I noticed that is a script that expects  
parameters to know which version to run. But until I arrived there, I do  
not know how to continue to make it work for version 1.9. You can help  
me

Thanks  
Fernando