Skip to main content

Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)

Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’  (2) ?



Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) or /tmp/mysql.sock doesn't exist

You might have came across this error when you tried development of Ruby on Rails project with MySQL as your development database.

What is the Error '/tmp/mysql.sock'?

This file is required for your application to get connected to your MySQL database.

Basically Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) this error can come when your MySQL server is not started.

You can start you MySQL server by using following command:
Command to start MySQL Server

mysql.server start

This will start your MySQL server and it will create the file'/tmp/mysql.sock' which is required for your application to get connected to the MySQL server.

The output after you hit enter by above command is:

Starting MySQL
.≈ SUCCESS!

which indicates successful start of your MySQL server.

This will solve the error Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2). Then you just have to restart your application.
Command to Stop MySQL Server:

mysql.server stop

The result of above operation:

Shutting down MySQL
.. SUCCESS!

Comments

Popular posts from this blog

Gem::LoadError (Specified 'mysql2' for database adapter, but the gem is not loaded. Add `gem 'mysql2'` to your Gemfile (and ensure its version is at the minimum required by ActiveRecord).?

Gem::LoadError (Specified 'mysql2' for database adapter, but the gem is not loaded. Add `gem 'mysql2'` to your Gemfile (and ensure its version is at the minimum required by ActiveRecord).) In rails?


1)change the gemfile in mysql version
 gem 'mysql2'

2)Change to mysql2 version
 gem 'mysql2','0.3.20'

Get user accessing ip address in rails?

Get user accessing ip address rails?

request.ip ->returns the ip, whether is is a local proxy ip (localhost address) or not.
*request.remote_ip -> is smarter and gets the ip address of the client outside of local proxies.
3)If you are using apache in front of a mongrel, then remote_ip will return the source address of the request, which in this case will be local host because the Apache web server is making the request, so instead put this in your controller:

@remote_ip = request.env["HTTP_X_FORWARDED_FOR"]

PayUMoney Integration in Ruby on Rails

PayUMoney Integration in Ruby on Rails


Generating Cheksum in Payu
   Hash or Checksum
= sha512(key|txnid|amount|productinfo|firstname|email|u
df1|udf2|udf3|udf4|udf5||||||salt)



Controller Code Will be
def payumoney
  @key = "gtKFFx"
  @salt =  "eCwWELxi"
  val = "#{key|txnid|amount|productinfo|firstname|email|u
df1|udf2|udf3|udf4|udf5||||||#{@salt}"
 @checksum = Digest::SHA512.hexdigest("#{val}")
end

<form action="https://test.payu.in/_payment" method='post' id='sub'  >
    <input type="hidden" name="key" value="<%=@key%>">
    <input type="hidden" name="hash" value="<%=@checksum%>">
    <input type="hidden" name="txnid" value="TXN1234">
    <input type="hidden" name="amount" value="200">
    <input type="hidden" name="firstname" value=&quo…