Joinutility seperatorLogin utility separator Infobright.com
Loading
   
 
Infobright connection issue
 
sureshteen
Posted: 12 October 2009 08:23 AM   [ Ignore ]  
Newbie
Rank
Total Posts:  10
Joined  2009-07-14

I am trying to connect infobright server from client and getting the below error message.

ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mys
ql-ib.sock’ (2)

How to resolve the issue? please help me.

Profile
 
Mahib
Posted: 12 October 2009 08:32 AM   [ Ignore ]   [ # 1 ]  
Member
RankRankRank
Total Posts:  223
Joined  2008-08-18

Hi

Do you see any mysqld process running in your system? If not then you need to run it. But if it is running then check if there is sock file in the /tmp folder. There should be a sock file if the server runs ok.

cheers

Signature 

Mahib

Profile
 
sureshteen
Posted: 12 October 2009 12:13 PM   [ Ignore ]   [ # 2 ]  
Newbie
Rank
Total Posts:  10
Joined  2009-07-14

I don’t see any socket file in /tmp folder. How to create the socket file. Please reply with possible solution.

Profile
 
David Lutz
Posted: 12 October 2009 12:39 PM   [ Ignore ]   [ # 3 ]  
Sr. Member
Avatar
RankRankRankRank
Total Posts:  738
Joined  2008-08-18

The socket file is created when the engine is started.  One starts the engine (in Linux/Unix) as such:

$ /etc/init.d/mysqld-ib start 

The socket name is specified during installation with the

--socket=/tmp/mysql-ib.sock 

parameter (default).  It is also persisted in the /etc/my-ib.cnf file -

# The following options will be passed to all MySQL clients
[client]
#password       = your_password
port            = 5029
socket          = /tmp/mysql-ib.sock 

I would suggest attempting to start the engine as described above.

[ Edited: 12 October 2009 12:42 PM by David Lutz]
Signature 
Profile
 
   
 
 
‹‹ searching for numerical value in large tables      Table storage engine doesn’t have this option error ››