Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #11  
Old 26th March 2013, 18:21
roe74979 roe74979 is offline
Junior Member
 
Join Date: Mar 2013
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Code:
ls: cannot access /tmp/mysql.sock: No such file or directory
after running

Code:
touch /tmp/mysql.sock
nothing happened, a new line came up to type in. not sure if that's supposed happen or not

I then ran

Code:
service mysql restart
and getting this

Code:
stop: Rejected send message, 1 matched rules; type="method_call", sender=":1.78" (uid=1000 pid=11023 comm="stop mysql ") interface="com.ubuntu.Upstart0_6.Job" member="Stop" error name="(unset)" requested_reply="0" destination="com.ubuntu.Upstart" (uid=0 pid=1 comm="/sbin/init")
start: Rejected send message, 1 matched rules; type="method_call", sender=":1.79" (uid=1000 pid=11020 comm="start mysql ") interface="com.ubuntu.Upstart0_6.Job" member="Start" error name="(unset)" requested_reply="0" destination="com.ubuntu.Upstart" (uid=0 pid=1 comm="/sbin/init")
I stopped there but I did go to the location to see if I could see it. It opened and says this

Code:
socket		= /var/run/mysqld/mysqld.sock
before changing anything, you want me to change it to

Code:
socket      = /tmp/mysqld.sock
? just making sure before doing so... thanks
Reply With Quote
Sponsored Links
  #12  
Old 26th March 2013, 18:26
researcher7 researcher7 is offline
Junior Member
 
Join Date: Mar 2013
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
Default

As mentioned in the previous reply.
The general rule is the [client] section to match what the [mysqld] section has for the socket file location, so if [mysqld] shows

socket = /tmp/mysqld.sock,

then [client] section should have
/tmp/mysqld.sock

If [mysqld] has something else, like socket = /var/run/mysqld/mysqld.sock then [client] should have the same.

Note: Make sure to back up your my.cnf file before applying any changes.

Code:
cp /etc/mysql/my.cnf /etc/mysql/my.cnf.bak
Or

Code:
cp /etc/my.cnf /etc/my.cnf.bak

Last edited by researcher7; 26th March 2013 at 18:30.
Reply With Quote
  #13  
Old 26th March 2013, 18:44
roe74979 roe74979 is offline
Junior Member
 
Join Date: Mar 2013
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Default

ok sorry, missed the part about client needing same thing. I did double check, and they are the same.
Reply With Quote
  #14  
Old 26th March 2013, 18:48
researcher7 researcher7 is offline
Junior Member
 
Join Date: Mar 2013
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
Default

So the client and the server both showing the same location for the socket file?

In your my.cnf, you should see.

Code:
[mysqld]
socket = /tmp/mysqld.sock

.....

[client]
socket      = /tmp/mysqld.sock
Is this what you see right now?

Also, please check if you are using mysql for anything else on your server.
Reply With Quote
  #15  
Old 26th March 2013, 19:31
roe74979 roe74979 is offline
Junior Member
 
Join Date: Mar 2013
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Default

yes they both say the same thing. posting what they say to make sure i'm not missing something

Code:
[client]
port		= 3306
socket 		= /tmp/mysqld.sock

[mysqld]
#
# * Basic Settings
#
user		= mysql
pid-file	= /var/run/mysqld/mysqld.pid
socket 		= /tmp/mysqld.sock
as for checking that MYSQL is used for anything else, sorry... I don't know how to do that.
Reply With Quote
  #16  
Old 26th March 2013, 20:17
researcher7 researcher7 is offline
Junior Member
 
Join Date: Mar 2013
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for the update.

OK. That looks good but you still can't connect to the server from your local client.
The reason I asked for mysql being used for other applications, is that you may need, as a last resort to remove and then re-install mysql and mysql client.

Before going that far, let's see what your logs show.
Is logging enabled by any chance in your config?

Check by running.

Code:
grep -i "log_" /etc/mysql/my.cnf
Look for:
general_log_file
log_error

Please post what are the values and if they are enabled (uncommented) or not.
Reply With Quote
  #17  
Old 26th March 2013, 20:20
roe74979 roe74979 is offline
Junior Member
 
Join Date: Mar 2013
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for the response. This is what it spit out.


Code:
#general_log_file        = /var/log/mysql/mysql.log
log_error = /var/log/mysql/error.log
Reply With Quote
  #18  
Old 26th March 2013, 20:27
researcher7 researcher7 is offline
Junior Member
 
Join Date: Mar 2013
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
Default

That should be enough to get us some info.
Please provide the output of:

Code:
tail -30 /var/log/mysql/error.log
Thanks.
Reply With Quote
  #19  
Old 26th March 2013, 20:29
roe74979 roe74979 is offline
Junior Member
 
Join Date: Mar 2013
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks,

its a lot of info.

Code:
student@student-desktop:~$ tail -30 /var/log/mysql/error.log
130326 10:16:36 InnoDB: Compressed tables use zlib 1.2.7
130326 10:16:36 InnoDB: Using Linux native AIO
130326 10:16:36 InnoDB: Initializing buffer pool, size = 128.0M
130326 10:16:36 InnoDB: Completed initialization of buffer pool
130326 10:16:36 InnoDB: highest supported file format is Barracuda.
130326 10:16:37  InnoDB: Waiting for the background threads to start
130326 10:16:38 InnoDB: 1.1.8 started; log sequence number 1595675
ERROR: 1050  Table 'plugin' already exists
130326 10:16:38 [ERROR] Aborting

130326 10:16:38  InnoDB: Starting shutdown...
130326 10:16:38  InnoDB: Shutdown completed; log sequence number 1595675
130326 10:16:38 [Note] /usr/sbin/mysqld: Shutdown complete

130326 10:16:39 [Note] Plugin 'FEDERATED' is disabled.
130326 10:16:39 InnoDB: The InnoDB memory heap is disabled
130326 10:16:39 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130326 10:16:39 InnoDB: Compressed tables use zlib 1.2.7
130326 10:16:39 InnoDB: Using Linux native AIO
130326 10:16:39 InnoDB: Initializing buffer pool, size = 128.0M
130326 10:16:39 InnoDB: Completed initialization of buffer pool
130326 10:16:39 InnoDB: highest supported file format is Barracuda.
130326 10:16:39  InnoDB: Waiting for the background threads to start
130326 10:16:40 InnoDB: 1.1.8 started; log sequence number 1595675
130326 10:16:40 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
130326 10:16:40 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
130326 10:16:40 [Note] Server socket created on IP: '127.0.0.1'.
130326 10:16:40 [Note] Event Scheduler: Loaded 0 events
130326 10:16:40 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.29-0ubuntu0.12.10.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
Reply With Quote
  #20  
Old 26th March 2013, 20:38
researcher7 researcher7 is offline
Junior Member
 
Join Date: Mar 2013
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

Quote:
Originally Posted by roe74979 View Post
Code:
Version: '5.5.29-0ubuntu0.12.10.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
There's the problem right there.

Your mysql client is looking for /tmp/mysql.sock while the actual file exist at
/var/run/mysqld/mysqld.sock

You need to modify your my.cnf (backup the file first) and change the [client] section to

Code:
socket = /var/lib/mysql/mysql.sock
Save, restart mysql server and then try to connect again.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Relay access denied when using SMTP to external recipients Kamran Shah Installation/Configuration 111 14th May 2014 19:10
Version 1.3 of the ISPConfig 3 Manual is finally available! falko General 44 2nd December 2011 13:04
PHP warnings after upgrade to ISP config 3.03 stevegjacobs Installation/Configuration 5 30th October 2010 15:31
Error installing ISPConfig on debian omniware Installation/Configuration 3 10th September 2008 16:36
Can I avoid installing the clamav etc. coming with ISPConfig bolero Installation/Configuration 1 28th April 2008 16:23


All times are GMT +2. The time now is 04:33.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.