Re: [Rails] Intermittent Mysql Connection error in ROR app

Ruby on Rails Wednesday, April 10, 2019

Hi, 

I get this error in Homebrew sometimes. I think it means it doesn't recognize you as a local user, not sure! 
This workflow for me always fixes it. Maybe it will help you figure out how to fix it using the MYSQL Community Server, they have similar issues:

$ mysql.server stop

// unset the tmp directory
$ echo $TMPDIR
$ unset TMPDIR
$ echo $TMPDIR

// validate this using echo then set it
$ echo mysqld -initialize --verbose --user=$(whoami) --basedir="$(brew --prefix mysql)" --datadir=/usr/local/var/mysql --tmpdir=/tmp
$ mysqld -initialize --verbose --user=$(whoami) --basedir="$(brew --prefix mysql)" --datadir=/usr/local/var/mysql --tmpdir=/tmp

$ mysql.server restart
$ mysql -u root -p

From there I access the mysql command line shell, set myself as root, run $flush privileges, exit mysql command line, run the login command, and error goes away


On Thu, Apr 11, 2019 at 1:20 AM Loganathan Sellappa <loganathan.ms@gmail.com> wrote:
Hi Everyone, 

I'm getting the below error randomly in my Ruby On Rails application whenever the number of requests increases to the server.

Mysql2::Error::ConnectionError (Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)):

I'm not sure whether it is because of my server memory or is it something to do with mysql2 gem. Any help would be really appreciated, thanks in advance.

Ruby '2.5.0'  Rails '5.2.0  Mysql2 0.5.2  Phusion Passenger 5.3.4  Server version: Apache/2.4.6 (CentOS)  RAM SIZE: 1.5GB  MySQL Community Server (GPL): 5.6.41
Regards,
Loganathan

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/3f2416a7-1ba8-44c3-81e6-17384309af43%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


--
Sasha Boginsky
BBA Class of 2017
Emory Goizueta Business School
646.241.5756

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/CALD0ZKmN3Ysb5u78GKorbkRkoo_b7xjJobTv5m2A-UEybQ6rXA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Posted by Ruby on Rails at 11:57 PM

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)