Jonas needs to enable host and port communication for mysql.
Victor
On 4/17/06, Matt Kent <[EMAIL PROTECTED]> wrote:
RadRails will not use the socket connection line. It uses host and port with JDBC.On 4/17/06, Steven Ross <[EMAIL PROTECTED] > wrote:So you can connect to mysql through everything but radrails?On 4/17/06, Jonas Rullo < [EMAIL PROTECTED] > wrote:I posted on this as a non user last week, but it hasn't made it through
the moderation process, so I joined up.
My system is Ubuntu 5.10 (Breezy) using Linux kernel 2.6.12-10, MySQL
4.1.12, Ruby 1.8, gem mysql 2.7 module/driver, Java J2RE 1.5 from Sun. I
installed everything with apt-get except for java and radrails. The
java had to be turned into a package and then installed.
I'm having a horrible time using radrails for database work. I have yet
to connect to my local mysql database. I haven't tried a remote one. I
connect fine on the command line with the mysql command line tool. I can
use any other program to connnect to my local database but radrails.
Here is database.yml:
development:
adapter: mysql
database: rtadmin_development
username: root
password: XXXX
host: jdeb
port: 3306
***End YML file***
There are no tabs in the file. I created the database
rtadmin_development with no tables using mysql from the command line. I
have permissions set to allow all within mysql. It doesn't matter if the
host: line is set with localhost, 127.0.0.1, with or without a port
line. Using the socket connection path with a socket: line does not work
either.
I know radrails is working mostly correct because I completed the flickr
library video tutorial with no problems.
I intended to follow the blog tutorial video, but everything stopped at
connecting to a database. I found Sam Ruby's posts about Ubuntu and
radrails and I'm having the same trouble with no solution in sight.
After I updated my hosts file to put localhost.localdomain after
localhost, the error no longer appears. However, the database is still
not reached. Simply nothing happens. No error dialog box, no log
entries. Before editing my /etc/hosts file, I got a dialog box with
"Unable to connect to database, see log for more details.". No error is
logged anywhere, not even system or mysql log files. It's as if radrails
isn't even trying to connect to the database. At least according to any
logs. I'm only trusting that it is and the logging is just broken
somehow. According to Sam Ruby, there may be an eclipse or java logging
problem somewhere. If so is there a solution there?
I'm open to any suggestions. Has anyone had this problem? Can anyone
give any suggestions on how to connect to mysql with radrails? Is this a
Debian problem, an Ubuntu problem, or what?
_______________________________________________
RadRails mailing list
[email protected]
http://lists.radrails.org/mailman/listinfo/radrails
--
Steven Ross
web application & interface developer
http://www.zerium.com
[phone] 404-488-4364
_______________________________________________
RadRails mailing list
[email protected]
http://lists.radrails.org/mailman/listinfo/radrails
_______________________________________________
RadRails mailing list
[email protected]
http://lists.radrails.org/mailman/listinfo/radrails
_______________________________________________ RadRails mailing list [email protected] http://lists.radrails.org/mailman/listinfo/radrails
