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.
On Wed, 2006-03-29 at 11:20 -0500, Roberto Mason wrote:> 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?---- 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
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:> On Wed, 2006-03-29 at 11:20 -0500, Roberto Mason wrote: > > 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? > ---- > 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 > > _______________________________________________ > 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.