MySql and netbeans 6.1

[klusener]

Hello All ,
             I have downloaded netbeans 6.1 on ubuntu hardy ( yes i was initially working with windows , but gave it up ) . I can now successfully run the webrick server. But i had a question while running a application i got the following error.

Errno::ENOENT in ItemController#index
No such file or directory - /tmp/mysql.sock

My question is , do i have to install MYSql on my machine , or does it come with the netbeans 6.1 installation.

Here is the full error trace that i am getting in the browser
"/home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/vendor/mysql.rb:107:in `real_connect'
/home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/mysql_adapter.rb:471:in `connect'
/home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/mysql_adapter.rb:165:in `initialize'
/home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/mysql_adapter.rb:88:in `new'
/home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/mysql_adapter.rb:88:in `mysql_connection'
/home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:291:in `connection='
/home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:259:in `retrieve_connection'
/home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:78:in `connection'
/home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/query_cache.rb:8:in `cache'
/home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/caching.rb:677:in `perform_action_with_caching'
/home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/base.rb:524:in `process'
/home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/filters.rb:685:in `process_with_filters'
/home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/session_management.rb:123:in `process_with_session_management_support'
/home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/base.rb:388:in `process'
/home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/dispatcher.rb:171:in `handle_request'
/home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/dispatcher.rb:115:in `dispatch'
/home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/dispatcher.rb:126:in `dispatch_cgi'
/home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/dispatcher.rb:9:in `dispatch'
/home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/rails-2.0.2/lib/webrick_server.rb:112:in `handle_dispatch'
/home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/rails-2.0.2/lib/webrick_server.rb:78:in `service'
/home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/1.8/webrick/httpserver.rb:104:in `service'
/home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/1.8/webrick/httpserver.rb:65:in `run'
/home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/1.8/webrick/server.rb:173:in `start_thread'
:1:in `start'
"

thanks in advance.

[Amit k. Saha]

On Sun, Aug 10, 2008 at 7:00 PM, klusener <bhanushali.b@...> wrote:

>
> Hello All ,
>             I have downloaded netbeans 6.1 on ubuntu hardy ( yes i was
> initially working with windows , but gave it up ) . I can now successfully
> run the webrick server. But i had a question while running a application i
> got the following error.
>
> Errno::ENOENT in ItemController#index
> No such file or directory - /tmp/mysql.sock
>
> My question is , do i have to install MYSql on my machine , or does it come
> with the netbeans 6.1 installation.

If the NetBeans 6.1 that you are using is not the one at
http://dlc.sun.com.edgesuite.net/netbeans/6.1/mysql_bundle/, then you
will need to have a MySQL installation.

HTH,
Amit


--
Amit Kumar Saha
http://blogs.sun.com/amitsaha/
http://amitksaha.blogspot.com
Skype: amitkumarsaha

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[klusener]

thanks mate , i think i had a different version of netbeans installed . I am now downloading the link that you gave me . I will update you with the results and further queries.

[Amit k. Saha]

On Sun, Aug 10, 2008 at 11:37 PM, klusener <bhanushali.b@...> wrote:
>
> thanks mate , i think i had a different version of netbeans installed . I am
> now downloading the link that you gave me . I will update you with the
> results and further queries.

Good Luck! BTW, I am no Ruby expert. Just lurking around here :-)


--
Amit Kumar Saha
http://blogs.sun.com/amitsaha/
http://amitksaha.blogspot.com
Skype: amitkumarsaha

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[klusener]

After downloading the new netbeans 6.1 with glass fish and sql i decided to give netbeans one final try . But i got one more problem

This is the error i am getting

1) Error:
test_truth(ItemControllerTest):
Errno::ECONNREFUSED: Connection refused - Connection refused
    /home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/vendor/mysql.rb:111:in `new'
    /home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/vendor/mysql.rb:111:in `real_connect'
    /home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/mysql_adapter.rb:471:in `connect'
    /home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/mysql_adapter.rb:165:in `initialize'
    /home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/mysql_adapter.rb:88:in `new'
    /home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/mysql_adapter.rb:88:in `mysql_connection'
    /home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:291:in `connection='
    /home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:259:in `retrieve_connection'
    /home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:78:in `connection'
    /home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/fixtures.rb:499:in `create_fixtures'
    /home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/fixtures.rb:1000:in `load_fixtures'
    /home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/fixtures.rb:934:in `setup_with_fixtures'
    /home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/fixtures.rb:978:in `full_setup'
    /home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activesupport-2.0.2/lib/active_support/testing/default.rb:7:in `run'


I have edited the "database.yml" file and changed the localhost entry to 127.0.0.1 . But that didnt help either.

[Erno Mononen]

Hi,

Is the MySQL server running? Can you try connecting to it from the
command line, e.g. 'mysql -u username -p password' -- does that work?

Erno

klusener wrote:

> After downloading the new netbeans 6.1 with glass fish and sql i decided to
> give netbeans one final try . But i got one more problem
>
> This is the error i am getting
>
> 1) Error:
> test_truth(ItemControllerTest):
> Errno::ECONNREFUSED: Connection refused - Connection refused
>    
> /home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/vendor/mysql.rb:111:in
> `new'
>    
> /home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/vendor/mysql.rb:111:in
> `real_connect'
>    
> /home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/mysql_adapter.rb:471:in
> `connect'
>    
> /home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/mysql_adapter.rb:165:in
> `initialize'
>    
> /home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/mysql_adapter.rb:88:in
> `new'
>    
> /home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/mysql_adapter.rb:88:in
> `mysql_connection'
>    
> /home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:291:in
> `connection='
>    
> /home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:259:in
> `retrieve_connection'
>    
> /home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:78:in
> `connection'
>    
> /home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/fixtures.rb:499:in
> `create_fixtures'
>    
> /home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/fixtures.rb:1000:in
> `load_fixtures'
>    
> /home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/fixtures.rb:934:in
> `setup_with_fixtures'
>    
> /home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/fixtures.rb:978:in
> `full_setup'
>    
> /home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activesupport-2.0.2/lib/active_support/testing/default.rb:7:in
> `run'
>
>
> I have edited the "database.yml" file and changed the localhost entry to
> 127.0.0.1 . But that didnt help either.
>  

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Chris Kutler]

Hi,

If you are still working on the sample app from http://www.netbeans.org/kb/61/ruby/getting-started.html, and you are not using a database, then don't forget to uncomment the following line in the environment.rb file.:

  config.frameworks -= [ :active_record, :active_resource, :action_mailer ]

If you don't do this, the app will try to connect with the database in your data.yml file.

Otherwise, if you are using a database in your application, then open up the database.yml file and make sure that the username and password are correct. One way to verify the username and password is to go to a command window and type "mysql -u <username> -p" and when prompted, put in your password. If you are not able to start up mysql from the command line or log in using your username and password, then the problem is with your mysql set up.


If you are using a database, then a good tutorial to start with for 6.1 is http://www.netbeans.org/kb/61/ruby/rapid-ruby-weblog.html


klusener wrote:

After downloading the new netbeans 6.1 with glass fish and sql i decided to
give netbeans one final try . But i got one more problem

This is the error i am getting

1) Error:
test_truth(ItemControllerTest):
Errno::ECONNREFUSED: Connection refused - Connection refused
   
/home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/vendor/mysql.rb:111:in
`new'
   
/home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/vendor/mysql.rb:111:in
`real_connect'
   
/home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/mysql_adapter.rb:471:in
`connect'
   
/home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/mysql_adapter.rb:165:in
`initialize'
   
/home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/mysql_adapter.rb:88:in
`new'
   
/home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/mysql_adapter.rb:88:in
`mysql_connection'
   
/home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:291:in
`connection='
   
/home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:259:in
`retrieve_connection'
   
/home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:78:in
`connection'
   
/home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/fixtures.rb:499:in
`create_fixtures'
   
/home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/fixtures.rb:1000:in
`load_fixtures'
   
/home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/fixtures.rb:934:in
`setup_with_fixtures'
   
/home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/fixtures.rb:978:in
`full_setup'
   
/home/lance/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activesupport-2.0.2/lib/active_support/testing/default.rb:7:in
`run'


I have edited the "database.yml" file and changed the localhost entry to
127.0.0.1 . But that didnt help either.
  

[klusener]

Thanks Chris , i have downloaded the Glassfish and SQL version of netbeans 6.1 , So i should be having the databse present.

I will check the SQL username and password and will try this example again.I like netbeans 6.1 so far and i am sure these are early hich ups that i am facing.

One question i have is which OS is best for ruby on rails development using netbeans , unix or windows ?

[Chris Kutler]

klusener wrote:
> Thanks Chris , i have downloaded the Glassfish and SQL version of netbeans
> 6.1 , So i should be having the databse present.
>  
Having the database server installed and running is the first step if
you are building a Rails application around database tables. The next
step is to configure the rails application to access the specific
databases that the application is built around, in particular, the
development database at the minimum. You do this using the database.yml
file. You also need to create the database, which can be done in many
ways, including the db:create rake command, which is explained in
http://www.netbeans.org/kb/61/ruby/rapid-ruby-weblog.html.

I will leave your last question for someone else to answer. As a
technical writer, I use Kubuntu, Window, Solaris, and Mac so that I can
write to many audiences, but my viewpoint is different from those doing
actual production work.
> I will check the SQL username and password and will try this example again.I
> like netbeans 6.1 so far and i am sure these are early hich ups that i am
> facing.
>
> One question i have is which OS is best for ruby on rails development using
> netbeans , unix or windows ?
>  

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[klusener]

First of all , I am losing hope with netbeans 6.1

I installed the glassfish and mysql server version of netbeans on ubuntu
Now on the services tab i could see mysql server , Now i followed the page http://www.netbeans.org/kb/61/ide/mysql.html to configure the server

The following are the problems or issues i have
1] Why should i use the admin tool that is present in the default mysql installation , why shouldnt i use this one http://dev.mysql.com/downloads/gui-tools/5.0.html 

2] While starting the server i faced the following error

"/home/lance/mysql/bin/safe_mysqld: 199: my_print_defaults: not found
/home/lance/mysql/bin/safe_mysqld: 204: my_print_defaults: not found
The file /usr/local/mysql/bin/mysqld doesn't exist or is not executable
Please do a cd to the mysql installation directory and restart
this script from there as follows:
./bin/mysqld_safe.
See http://dev.mysql.com/doc/mysql/en/mysqld_safe.html for more
information"

3] Now i opened the script "mysqld_safe" and saw that at many places the /usr/local/mysql/bin directory was being refered too , now when i tried searching for this directory i couldnt find it . Is there something amiss here

Has there been any testing done of this installation , or am i being used as a beta tester here.

[David Van Couvering-2]

On Tue, Aug 12, 2008 at 9:20 PM, klusener <bhanushali.b@...> wrote:

First of all , I am losing hope with netbeans 6.1

I installed the glassfish and mysql server version of netbeans on ubuntu
Now on the services tab i could see mysql server , Now i followed the page
http://www.netbeans.org/kb/61/ide/mysql.html to configure the server

The following are the problems or issues i have
1] Why should i use the admin tool that is present in the default mysql
installation , why shouldnt i use this one
http://dev.mysql.com/downloads/gui-tools/5.0.html

It's not a matter of should or shouldn't, it's a matter of  preference.  I like the features in NB because I can quickly view databases, connect to them, and start and stop.  The GUI tool has a lot more features (although you should be aware it is in mothballs - not even getting supported - and will be replaced by MySQL Workbench in the next year or two).  You can also take a look at phpMyAdmin, a lot of people like this, or any number of other tools.

2] While starting the server i faced the following error

"/home/lance/mysql/bin/safe_mysqld: 199: my_print_defaults: not found
/home/lance/mysql/bin/safe_mysqld: 204: my_print_defaults: not found
The file /usr/local/mysql/bin/mysqld doesn't exist or is not executable
Please do a cd to the mysql installation directory and restart
this script from there as follows:
./bin/mysqld_safe.
See http://dev.mysql.com/doc/mysql/en/mysqld_safe.html for more
information"

3] Now i opened the script "mysqld_safe" and saw that at many places the
/usr/local/mysql/bin directory was being refered too , now when i tried
searching for this directory i couldnt find it . Is there something amiss
here

This sounds like an installation problem.  I'm not sure how you installed MySQL (I'm jumping into this discussion late), but I recommend doing a clean install.
 

Has there been any testing done of this installation , or am i being used as
a beta tester here.

What installation are you talking about?  Is this the bundled install?  I haven't personally tested it, but I know a lot of people have. Sounds like you got hosed, very sorry, but these things happen.

I'm copying Dmitry Lipin, he's one of the engineers working on the MySQL/NetBeans bundle.

BTW, just because the MySQL support is  not working for you, don't throw the baby out with the bathwater - NetBeans is a primo tool, especially for Ruby.  Let's see if we can get you out of this rathole.

David

--
View this message in context: http://www.nabble.com/MySql-and-netbeans-6.1-tp18913085p18956764.html
Sent from the NetBeans Ruby - Users mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

--
David W. Van Couvering
http://davidvancouvering.blogspot.com

[Dmitry Lipin-2]

Hi,

bin/safe_mysqld script is configured to work, by default, with MySQL
installed in /usr/local/mysql.
If it is not the case - ant it is not since it is installed in
/home/lance/mysql - then this script should be executed with --basedir
(and likely with --datadir) switches:
/home/lance/mysql/bin/safe_mysqld --basedir /home/lance/mysql --datadir
/home/lance/mysql/data
It is valid both for the standalone MySQL, and MySQL installed using the
NetBeans/MySQL bundle.

Another option - valid if you use NetBeans6.1/GlassFish/MySQL bundle -
is to specify path to the configuration file:
/home/lance/mysql/bin/safe_mysqld --defaults-file=/home/lance/mysql/my.cnf
or just execute the following command if are localed in the
/home/lance/mysql folder:
./bin/safe_mysqld --defaults-file=./my.cnf


Dmitry

David Van Couvering wrote:

>
>
> On Tue, Aug 12, 2008 at 9:20 PM, klusener <bhanushali.b@...
> <mailto:bhanushali.b@...>> wrote:
>
>
>     First of all , I am losing hope with netbeans 6.1
>
>     I installed the glassfish and mysql server version of netbeans on
>     ubuntu
>     Now on the services tab i could see mysql server , Now i followed
>     the page
>     http://www.netbeans.org/kb/61/ide/mysql.html to configure the server
>
>     The following are the problems or issues i have
>     1] Why should i use the admin tool that is present in the default
>     mysql
>     installation , why shouldnt i use this one
>     http://dev.mysql.com/downloads/gui-tools/5.0.html
>
>
> It's not a matter of should or shouldn't, it's a matter of  
> preference.  I like the features in NB because I can quickly view
> databases, connect to them, and start and stop.  The GUI tool has a
> lot more features (although you should be aware it is in mothballs -
> not even getting supported - and will be replaced by MySQL Workbench
> in the next year or two).  You can also take a look at phpMyAdmin, a
> lot of people like this, or any number of other tools.
>
>
>
>     2] While starting the server i faced the following error
>
>     "/home/lance/mysql/bin/safe_mysqld: 199: my_print_defaults: not found
>     /home/lance/mysql/bin/safe_mysqld: 204: my_print_defaults: not found
>     The file /usr/local/mysql/bin/mysqld doesn't exist or is not
>     executable
>     Please do a cd to the mysql installation directory and restart
>     this script from there as follows:
>     ./bin/mysqld_safe.
>     See http://dev.mysql.com/doc/mysql/en/mysqld_safe.html for more
>     information"
>
>     3] Now i opened the script "mysqld_safe" and saw that at many
>     places the
>     /usr/local/mysql/bin directory was being refered too , now when i
>     tried
>     searching for this directory i couldnt find it . Is there
>     something amiss
>     here
>
>
> This sounds like an installation problem.  I'm not sure how you
> installed MySQL (I'm jumping into this discussion late), but I
> recommend doing a clean install.
>  
>
>
>     Has there been any testing done of this installation , or am i
>     being used as
>     a beta tester here.
>
>
> What installation are you talking about?  Is this the bundled
> install?  I haven't personally tested it, but I know a lot of people
> have. Sounds like you got hosed, very sorry, but these things happen.
>
> I'm copying Dmitry Lipin, he's one of the engineers working on the
> MySQL/NetBeans bundle.
>
> BTW, just because the MySQL support is  not working for you, don't
> throw the baby out with the bathwater - NetBeans is a primo tool,
> especially for Ruby.  Let's see if we can get you out of this rathole.
>
> David
>
>
>     --
>     View this message in context:
>     http://www.nabble.com/MySql-and-netbeans-6.1-tp18913085p18956764.html
>     Sent from the NetBeans Ruby - Users mailing list archive at
>     Nabble.com.
>
>
>     ---------------------------------------------------------------------
>     To unsubscribe, e-mail: users-unsubscribe@...
>     <mailto:users-unsubscribe@...>
>     For additional commands, e-mail: users-help@...
>     <mailto:users-help@...>
>
>
>
>
> --
> David W. Van Couvering
> http://davidvancouvering.blogspot.com

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[David Van Couvering-2]

Argh.  You seem to have very bad karma with all this.  Really, it normally works just fine! :(

What platform are you on, Mac or Linux or Solaris?  Linux and Solaris have a program called 'gksu' that allows you to start an application as root.  You might try reconfiguring the start command as follows:

- Get the full path to gksu (try 'which gksu' on the command line)
- Go to Properties from the MySQL node and click on Admin
- Copy the stuff you see under "Start command" and paste that to the beginning of yoru "Start arguments"
- Put the full path to gksu in the "Start command" field
- Say 'OK' and try Start again

Let's see how that goes.  I have no idea why NB can't be started from the menu any more, sorry.

David

On Wed, Aug 13, 2008 at 8:22 PM, klusener <bhanushali.b@...> wrote:

Installing netbeans this time didnt create a desktop short cut and neither
clicking under "Applications --> netbeans" works ( awesome :) )

Now the only way to start this is by doing sh netbeans , this works and i
aint complaining.

Now when i start mysql server by right clicking and then start , this is the
error message

Fatal error: Can't remove the pid file:
/usr/local/mysql/data/lance-desktop.pid
Please remove it manually and start /usr/local/mysql/bin/mysqld_safe again
mysqld daemon not started
cat: /usr/local/mysql/data/lance-desktop.pid: Permission denied
rm: cannot remove `/usr/local/mysql/data/lance-desktop.pid': Permission
denied
/usr/local/mysql/bin/mysqld_safe: 358: cannot create
/usr/local/mysql/data/lance-desktop.err: Permission denied
--
View this message in context: http://www.nabble.com/MySql-and-netbeans-6.1-tp18913085p18975158.html

Sent from the NetBeans Ruby - Users mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

--
David W. Van Couvering
http://davidvancouvering.blogspot.com

[klusener]

OK , so i have the mysql edition now . I Clicked on the services tab and started the MySql server . Inside the database.yml file i removed the localhost entry and replaced it with "127.0.0.1" . Now when i tried running i get the following error

/usr/local/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/mysql_adapter.rb:471:in `connect'
/usr/local/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/mysql_adapter.rb:165:in `initialize'
/usr/local/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/mysql_adapter.rb:88:in `new'
/usr/local/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/mysql_adapter.rb:88:in `mysql_connection'
/usr/local/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:291:in `connection='
/usr/local/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:259:in `retrieve_connection'
/usr/local/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:78:in `connection'
/usr/local/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/query_cache.rb:8:in `cache'
/usr/local/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/caching.rb:677:in `perform_action_with_caching'
/usr/local/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/base.rb:524:in `process'
/usr/local/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/filters.rb:685:in `process_with_filters'
/usr/local/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/session_management.rb:123:in `process_with_session_management_support'
/usr/local/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/base.rb:388:in `process'
/usr/local/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/dispatcher.rb:171:in `handle_request'
/usr/local/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/dispatcher.rb:115:in `dispatch'
/usr/local/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/dispatcher.rb:126:in `dispatch_cgi'
/usr/local/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/dispatcher.rb:9:in `dispatch'
/usr/local/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/rails-2.0.2/lib/webrick_server.rb:112:in `handle_dispatch'
/usr/local/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/rails-2.0.2/lib/webrick_server.rb:78:in `service'
/usr/local/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/1.8/webrick/httpserver.rb:104:in `service'
/usr/local/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/1.8/webrick/httpserver.rb:65:in `run'
/usr/local/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/1.8/webrick/server.rb:173:in `start_thread'


I even tried deleting all the test , production and developement database names , since they didnt exist .
Please help.

[Erno Mononen]

Hi,

Could you please post the contents of your database.yml file here? Note
that it also should not use the socket: syntax, so if you have any
socket: lines in the file, please try commenting them out. Also, are you
able to connect to the specified database using the DB explorer (i.e. in
the services tab)?

Erno

klusener wrote:

> OK , so i have the mysql edition now . I Clicked on the services tab and
> started the MySql server . Inside the database.yml file i removed the
> localhost entry and replaced it with "127.0.0.1" . Now when i tried running
> i get the following error
>
> /usr/local/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/mysql_adapter.rb:471:in
> `connect'
> /usr/local/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/mysql_adapter.rb:165:in
> `initialize'
> /usr/local/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/mysql_adapter.rb:88:in
> `new'
> /usr/local/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/mysql_adapter.rb:88:in
> `mysql_connection'
> /usr/local/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:291:in
> `connection='
> /usr/local/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:259:in
> `retrieve_connection'
> /usr/local/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:78:in
> `connection'
> /usr/local/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/query_cache.rb:8:in
> `cache'
> /usr/local/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/caching.rb:677:in
> `perform_action_with_caching'
> /usr/local/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/base.rb:524:in
> `process'
> /usr/local/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/filters.rb:685:in
> `process_with_filters'
> /usr/local/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/session_management.rb:123:in
> `process_with_session_management_support'
> /usr/local/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/base.rb:388:in
> `process'
> /usr/local/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/dispatcher.rb:171:in
> `handle_request'
> /usr/local/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/dispatcher.rb:115:in
> `dispatch'
> /usr/local/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/dispatcher.rb:126:in
> `dispatch_cgi'
> /usr/local/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/dispatcher.rb:9:in
> `dispatch'
> /usr/local/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/rails-2.0.2/lib/webrick_server.rb:112:in
> `handle_dispatch'
> /usr/local/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/gems/1.8/gems/rails-2.0.2/lib/webrick_server.rb:78:in
> `service'
> /usr/local/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/1.8/webrick/httpserver.rb:104:in
> `service'
> /usr/local/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/1.8/webrick/httpserver.rb:65:in
> `run'
> /usr/local/netbeans-6.1/ruby2/jruby-1.1/lib/ruby/1.8/webrick/server.rb:173:in
> `start_thread'
>
>
> I even tried deleting all the test , production and developement database
> names , since they didnt exist .
> Please help.
>  

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...