Forum: Ruby on Rails socket for mysql

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
322b38b83dd957ea13478623d22dbd9e?d=identicon&s=25 Roberto Mason (Guest)
on 2006-03-29 18:29
(Received via mailing list)
I have mysql running on a different machine. I've editted database.yml,
here's the entry

development:
  adapter: mysql
  database: cookbook
  username: root
  password: mypassword
  host: posta.rmasonfamily.info

test:
  adapter: mysql
  database: cookbook
  username: root
  password: mypassword
  host: posta.rmasonfamily.info

production:
  adapter: mysql
  database: cookbook
  username: root
  password: mypassword
  host: posta.rmasonfamily.info

problem seems  to be that I'm missing the socket entry, This is the
message I get

Can't connect to local MySQL server through socket
'/path/to/your/mysql.sock

but I don'thave a mysql.sock. I do have an empty
directory /var/lib/mysql.

do I have anything to install?




--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
C1e5a9e9344b6d31b9df7303e6dc378a?d=identicon&s=25 Craig White (Guest)
on 2006-03-29 18:38
(Received via mailing list)
On Wed, 2006-03-29 at 11:20 -0500, Roberto Mason wrote:
> test:
>   password: mypassword
>
> do I have anything to install?
----
assuming that you did 'gem install mysql' - no, nothing more to install

you need to specify

server: IP_OR_FQDN_OF_MYSQL_SERVER
port:   3306 # or other port if using non-standard

socket is for localhost (same computer) connections only.

Craig
322b38b83dd957ea13478623d22dbd9e?d=identicon&s=25 Roberto Mason (Guest)
on 2006-03-29 19:08
(Received via mailing list)
No I didn't do gem install mysql, since I'm running mysql on separate
server. With that in mind, do I have to do any changes?

On Wed, 2006-03-29 at 09:34 -0700, Craig White wrote:
> >
> >   username: root
> > directory /var/lib/mysql.
> socket is for localhost (same computer) connections only.
>
> Craig
>
> _______________________________________________
> Rails mailing list
> Rails@lists.rubyonrails.org
> http://lists.rubyonrails.org/mailman/listinfo/rails
>


--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
5d15c6821f3c3054c04b85471824ba7c?d=identicon&s=25 Richard Williams (Guest)
on 2006-03-30 15:52
(Received via mailing list)
What OS/version are you using?
This topic is locked and can not be replied to.