Database connection

Rails
1

Hallo to all

Ic have a big problem with my database. I have installed ruby on rails
and the Plug in for Eclipse. I create a database with mysql. But when I
want do use the database in Eclipse for Rails he says that there is no
connection to the databse.

development:
adapter: mysql
database: familie_development
username: root
password: er90di
host: localhost

Do I need a Socket or anything else!

PLease help me!

Thank you

2

Yeah, It’s most likely to specify a socket to the specific location. And
that can be done as easy as the following example:

adapter: mysql
database: familie_development
username: root
password: er90di
host: localhost
socket: /usr/mysql/mysql.sock

So specify your location correctly and see if it works…

Good Luck ! ( en de groeten :wink: )

  • Jermaine

Harald wrote:

Hallo to all

Ic have a big problem with my database. I have installed ruby on rails
and the Plug in for Eclipse. I create a database with mysql. But when I
want do use the database in Eclipse for Rails he says that there is no
connection to the databse.

development:
adapter: mysql
database: familie_development
username: root
password: er90di
host: localhost

Do I need a Socket or anything else!

PLease help me!

Thank you

3

Is nobody here who can help me or had the same problem?

Please I need help!

MFG Harald

4

Sorry but i dont find an file with the ending .sock. I use the mysql for
windows!

is this file in the direction where the special database is or is it an
general file for all databases??

Please for reply!

Sorry for my not correct english! gg
Jermaine wrote:

Yeah, It’s most likely to specify a socket to the specific location. And
that can be done as easy as the following example:

adapter: mysql
database: familie_development
username: root
password: er90di
host: localhost
socket: /usr/mysql/mysql.sock

So specify your location correctly and see if it works…

Good Luck ! ( en de groeten :wink: )

  • Jermaine

Harald wrote:

Hallo to all

Ic have a big problem with my database. I have installed ruby on rails
and the Plug in for Eclipse. I create a database with mysql. But when I
want do use the database in Eclipse for Rails he says that there is no
connection to the databse.

development:
adapter: mysql
database: familie_development
username: root
password: er90di
host: localhost

Do I need a Socket or anything else!

PLease help me!

Thank you

5

Hi Harald,

You might want to try posting your question to an Eclipse list.
Problems
with setting up / debugging an IDE is not something I’ve seen folks get
a
lot of help with here. Sorry I can’t be more help, but I just use a
regular
old text editor for Rails development.

Best regards,
Bill

6

Harald wrote:

Is nobody here who can help me or had the same problem?

Please I need help!

MFG Harald

Connect via a TCP/IP socket, rather than trying to a use a Unix domain
socket (which don’t exist under Windows). E.g.:

host: localhost
port: 3306

–
Michael W.

7

Harald wrote:

Hallo to all

Ic have a big problem with my database. I have installed ruby on rails
and the Plug in for Eclipse. I create a database with mysql. But when I
want do use the database in Eclipse for Rails he says that there is no
connection to the databse.

development:
adapter: mysql
database: familie_development
username: root
password: er90di
host: localhost

Do I need a Socket or anything else!

PLease help me!

Thank you

There is something screwy with passwords and mysql on windows. A quick
test. create a MySQL user named Rails with no password that can log in
only form localhost, and give that user the needed privileges. Then
take out the passworl line in you database.yml file and change the user
to Rails. If this solves the problem there is some configuration thingy
you need to do with MySQL. I’ve just dropped the password for my
development and test databases, so I don’t remember exactly how to solve
it.

John M.