Jump to content
metin2dev
Ekstasia2
  • 0
Sign in to follow this  
Tasho

socket '/tmp/mysql.sock' (2) cannot open

Question

PUBLIC_IP: 46.108.40.162 interface re0
HOSTNAME: channel1_2
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
cannot open direct sql connection to host: localhost user: m2user db: common
cannot start server while no common sql connected

 PORNESC GAME 99 ..
PUBLIC_IP: 46.108.40.162 interface re0
HOSTNAME: channel99
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
cannot open direct sql connection to host: localhost user: m2user db: common
cannot start server while no common sql connected

 CH1 ESTE PORNIT !
root@metin:/usr/home/game # mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
   failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
   failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
   failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
   failed, retrying in 5 secondsSuccess PLAYER
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
   failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
   failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
   failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
   failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
   failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
   failed, retrying in 5 secondsSuccess ACCOUNT
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
   failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
   failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
   failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
   failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
   failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
   failed, retrying in 5 secondsSuccess COMMON
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
   failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
   failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
   failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
   failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
   failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
   failed, retrying in 5 secondsSuccess HOTBACKUP
 

 

Hi, I've updated my frebds to 9.2 and I get the error above.

 

What I did so far to repar the error:

-deleted all .err file from mysql

-777 perm for mysql

-cleard all logs

and other useless thing ... but without any effect, now I'm asking for your help.

 

 

Share this post


Link to post
Share on other sites

18 answers to this question

Recommended Posts

  • 0

top :

 

  PID USERNAME    THR PRI NICE   SIZE    RES STATE    TIME   WCPU COMMAND
  984 root          1  20    0 13096K  4612K select   0:00  0.00% sshd
 1038 root          1  20    0 15852K  5040K select   0:00  0.00% sshd
 1619 root          1  20    0 15852K  5072K select   0:00  0.00% sshd
  609 root          1  20    0  9544K  1564K select   0:00  0.00% syslogd
  987 root          1  20    0 11296K  4132K select   0:00  0.00% sendmail
 1624 root          1  20    0 10864K  2900K pause    0:00  0.00% csh
 1041 root          1  20    0  9852K  2040K ttyin    0:00  0.00% sh
  994 root          1  20    0  9584K  1668K nanslp   0:00  0.00% cron
 2032 root          1  20    0  9872K  2104K RUN      0:00  0.00% top
 1029 root          1  52    0  9544K  1524K ttyin    0:00  0.00% getty
 1030 root          1  52    0  9544K  1524K ttyin    0:00  0.00% getty
 1031 root          1  52    0  9544K  1524K ttyin    0:00  0.00% getty
 1033 root          1  52    0  9544K  1524K ttyin    0:00  0.00% getty
 1028 root          1  52    0  9544K  1524K ttyin    0:00  0.00% getty
  990 smmsp         1  20    0 11296K  4140K pause    0:00  0.00% sendmail
 1034 root          1  52    0  9544K  1524K ttyin    0:00  0.00% getty
 1035 root          1  52    0  9544K  1524K ttyin    0:00  0.00% getty
 

 

my.cnf :

 

#Mysql configuration
[mysqld]
user=root
port=3307
socket=/tmp/mysql.sock
skip-locking
key_buffer=16K
max_allowed_packet=8M
table_cache=4
sort_buffer_size=64K
read_buffer_size=256K
read_rnd_buffer_size=256K
net_buffer_length=2K
thread_stack=128K
language=/usr/local/share/mysql/romanian

Share this post


Link to post
Share on other sites
  • 0

140126 21:31:55  mysqld ended

140126 21:32:34  mysqld started
140126 21:32:35  InnoDB: Started; log sequence number 0 1595695
140126 21:32:35 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.0.92'  socket: '/tmp/mysql.sock'  port: 3306  FreeBSD port: mysql-server-5.0.92
140126 21:42:14 [Note] /usr/local/libexec/mysqld: Normal shutdown

140126 21:42:39  InnoDB: Starting shutdown...
140126 21:42:45  InnoDB: Shutdown completed; log sequence number 0 1595695
140126 21:42:45 [Note] /usr/local/libexec/mysqld: Shutdown complete

140126 21:42:47  mysqld ended

140126 21:42:48  mysqld started
140126 21:42:53  InnoDB: Started; log sequence number 0 1595695
140126 21:42:54 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.0.92'  socket: '/tmp/mysql.sock'  port: 3306  FreeBSD port: mysql-server-5.0.92
140126 21:43:06 [Note] /usr/local/libexec/mysqld: Normal shutdown

140126 21:43:08  InnoDB: Starting shutdown...
140126 21:43:08  InnoDB: Shutdown completed; log sequence number 0 1595695
140126 21:43:08 [Note] /usr/local/libexec/mysqld: Shutdown complete

140126 21:43:08  mysqld ended

 

 

 

Share this post


Link to post
Share on other sites
  • 0
root@metin:~ # cd /usr/ports/databases/mysql51-server
root@metin:/usr/ports/databases/mysql51-server # make install clean
===>  mysql51-server-5.1.73_1 cannot install: MySQL versions mismatch: mysql56-client is installed and wanted version is mysql51-client.
*** [install] Error code 1
 

Share this post


Link to post
Share on other sites
  • 0

I fallowd this tutorial : 

 

Install MySQL

7. Go to the port for the MySQL server:

cd /usr/ports/databases/mysql56-server

make install clean


8. Add the following line to /etc/rc.conf:

echo 'mysql_enable="YES"' >> /etc/rc.conf


9. And start the mysql server:

/usr/local/etc/rc.d/mysql-server start


10. Then set a password for the MySQL root user:

/usr/local/bin/mysqladmin -u root password 'your-password'

 

...

 

but the same result...

Share this post


Link to post
Share on other sites
  • 0

Try with 'pkg_add -r mysql56-server'

If you want to solve socket problem:

delete all files in mysql folder (not folders, files!) and reboot your VM or, if don't work,

start mysql in safe mode with

mysqld_safe start
rehash

,after, try starting mysql.

Ah.. check if the own of mysql folder is mysql[88] in alternative give me your skype and I will try to help you with teamviewer.

  • Like 1

Share this post


Link to post
Share on other sites
  • 0
root@metin:~ # mysqld_safe start
140424 23:43:18 mysqld_safe Logging to '/var/db/mysql/metin.hostpay.ro.err'.
140424 23:43:18 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
140424 23:43:20 mysqld_safe mysqld from pid file /var/db/mysql/metin.hostpay.ro.pid ended
 
 
what I do next?

Share this post


Link to post
Share on other sites
  • 0

the only version who works is 5.1 but it has lost of errors ... when I try to install 5.6 .. the mysql won't start ... could someone please give me a solution

 

this error is deleting players status: 


SYSERR: Apr 30 19:19:00 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'part_main' at row 1 (query: UPDATE player SET job = 0, voice = 0, dir = 0, x = 851101, y = 263856, z = 0, map_index = 43, exit_x = 851101, exit_y = 263856, exit_map_index = 43, hp = 10675, mp = 730, stamina = 1320, random_hp = 636, random_sp = 332, playtime = 28, level = 17, level_step = 3, st = 56, ht = 4, dx = 3, iq = 3, gold = 9533286, exp = 187681, stat_point = 1, skill_point = 0, sub_skill_point = 8, stat_reset_count = 0, ip = '79.118.69.36', part_main = 41123, part_hair = 5026, last_play = NOW(), skill_group = 1, alignment = 3226, horse_level = 0, horse_riding = 0, horse_hp = 0, horse_hp_droptime = 0, horse_stamina = 0, horse_skill_point = 0, skill_level = '00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
SYSERR: Apr 30 19:19:30 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'part_main' at row 1 (query: UPDATE player SET job = 7, voice = 0, dir = 0, x = 63194, y = 167609, z = 0, map_index = 21, exit_x = 63194, exit_y = 167609, exit_map_index = 21, hp = 15064, mp = 4256, stamina = 1250, random_hp = 4264, random_sp = 1976, playtime = 198, level = 105, level_step = 0, st = 90, ht = 90, dx = 40, iq = 90, gold = 999541999, exp = 0, stat_point = 0, skill_point = 104, sub_skill_point = 46, stat_reset_count = 0, ip = '5.14.224.144', part_main = 41117, part_hair = 5005, last_play = NOW(), skill_group = 2, alignment = 405, horse_level = 31, horse_riding = 0, horse_hp = 50, horse_hp_droptime = 1399064067, horse_stamina = 200, horse_skill_point = 0, skill_level = '000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
SYSERR: Apr 30 19:19:55 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'part_main' at row 1 (query: UPDATE player SET job = 0, voice = 0, dir = 0, x = 936639, y = 234547, z = 0, map_index = 41, exit_x = 936639, exit_y = 234547, exit_map_index = 41, hp = 1192, mp = 570, stamina = 1320, random_hp = 432, random_sp = 219, playtime = 7, level = 12, level_step = 0, st = 39, ht = 4, dx = 3, iq = 3, gold = 2911042, exp = 704, stat_point = 0, skill_point = 11, sub_skill_point = 3, stat_reset_count = 0, ip = '93.115.40.87', part_main = 41123, part_hair = 5026, last_play = NOW(), skill_group = 1, alignment = 5777, horse_level = 11, horse_riding = 0, horse_hp = 18, horse_hp_droptime = 1399133624, horse_stamina = 30, horse_skill_point = 0, skill_level = '00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
SYSERR: Apr 30 19:20:19 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'part_main' at row 1 (query: UPDATE player SET job = 0, voice = 0, dir = 0, x = 886565, y = 287425, z = 0, map_index = 43, exit_x = 886565, exit_y = 287425, exit_map_index = 43, hp = 7169, mp = 980, stamina = 1320, random_hp = 1048, random_sp = 512, playtime = 96, level = 27, level_step = 0, st = 83, ht = 4, dx = 3, iq = 4, gold = 7477281, exp = 116726, stat_point = 0, skill_point = 0, sub_skill_point = 18, stat_reset_count = 0, ip = '93.115.41.103', part_main = 41123, part_hair = 5026, last_play = NOW(), skill_group = 1, alignment = 12079, horse_level = 1, horse_riding = 0, horse_hp = 3, horse_hp_droptime = 1399128099, horse_stamina = 4, horse_skill_point = 0, skill_level = '000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
SYSERR: Apr 30 19:20:29 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'part_main' at row 1 (query: UPDATE player SET job = 2, voice = 0, dir = 0, x = 856751, y = 292175, z = 0, map_index = 43, exit_x = 856751, exit_y = 292175, exit_map_index = 43, hp = 9840, mp = 3029, stamina = 1415, random_hp = 930, random_sp = 468, playtime = 55, level = 24, level_step = 1, st = 5, ht = 3, dx = 3, iq = 74, gold = 5565253, exp = 306493, stat_point = 1, skill_point = 0, sub_skill_point = 13, stat_reset_count = 0, ip = '83.88.70.97', part_main = 41123, part_hair = 5026, last_play = NOW(), skill_group = 1, alignment = 8680, horse_level = 11, horse_riding = 0, horse_hp = 18, horse_hp_droptime = 1399131808, horse_stamina = 30, horse_skill_point = 0, skill_level = '000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
SYSERR: Apr 30 19:20:34 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'part_main' at row 1 (query: UPDATE player SET job = 3, voice = 0, dir = 0, x = 63031, y = 166550, z = 0, map_index = 21, exit_x = 63031, exit_y = 166550, exit_map_index = 21, hp = 9032, mp = 384, stamina = 911, random_hp = 0, random_sp = 0, playtime = 36, level = 1, level_step = 0, st = 3, ht = 4, dx = 3, iq = 6, gold = 0, exp = 0, stat_point = 0, skill_point = 0, sub_skill_point = 0, stat_reset_count = 0, ip = '79.118.250.5', part_main = 41124, part_hair = 5026, last_play = NOW(), skill_group = 0, alignment = 20, horse_level = 0, horse_riding = 0, horse_hp = 0, horse_hp_droptime = 0, horse_stamina = 0, horse_skill_point = 0, skill_level = '00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
SYSERR: Apr 30 19:20:53 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'part_main' at row 1 (query: UPDATE player SET job = 0, voice = 0, dir = 0, x = 962212, y = 249251, z = 0, map_index = 41, exit_x = 962212, exit_y = 249251, exit_map_index = 41, hp = 760, mp = 260, stamina = 1320, random_hp = 0, random_sp = 0, playtime = 35, level = 1, level_step = 2, st = 6, ht = 4, dx = 3, iq = 3, gold = 18615, exp = 150, stat_point = 2, skill_point = 0, sub_skill_point = 0, stat_reset_count = 0, ip = '86.125.110.12', part_main = 41123, part_hair = 5026, last_play = NOW(), skill_group = 0, alignment = 185, horse_level = 0, horse_riding = 0, horse_hp = 0, horse_hp_droptime = 0, horse_stamina = 0, horse_skill_point = 0, skill_level = '000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
SYSERR: Apr 30 19:21:00 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'part_main' at row 1 (query: UPDATE player SET job = 0, voice = 0, dir = 0, x = 959600, y = 269700, z = 0, map_index = 41, exit_x = 959600, exit_y = 269700, exit_map_index = 41, hp = 11261, mp = 740, stamina = 1320, random_hp = 708, random_sp = 357, playtime = 35, level = 19, level_step = 2, st = 60, ht = 4, dx = 3, iq = 3, gold = 8259895, exp = 211147, stat_point = 2, skill_point = 0, sub_skill_point = 10, stat_reset_count = 0, ip = '5.61.1.90', part_main = 41123, part_hair = 5026, last_play = NOW(), skill_group = 1, alignment = 8275, horse_level = 11, horse_riding = 0, horse_hp = 18, horse_hp_droptime = 1399131878, horse_stamina = 30, horse_skill_point = 0, skill_level = '0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

Share this post


Link to post
Share on other sites
  • 0

mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

This error usually happens when there isn't enough free space in the hard drive.

Share this post


Link to post
Share on other sites
  • 0

Try this:

ALTER TABLE `player`
MODIFY COLUMN `part_main`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 AFTER `ip`;

I have the same problem. I just updated my FreeBSD and when i try to run my server with start.sh it says me:

6d483642f85a6b288b30e3e3c7561943.png

Please help me...

Share this post


Link to post
Share on other sites
  • 0

 

Try this:

ALTER TABLE `player`
MODIFY COLUMN `part_main`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 AFTER `ip`;

I have the same problem. I just updated my FreeBSD and when i try to run my server with start.sh it says me:

6d483642f85a6b288b30e3e3c7561943.png

Please help me...

 

It also says me this when i boot the serverfile:

c6a8bc51e4063638f49c4e97e3d15be6.png

By the image, i think the libs are missing, but i can't connect to FileZilla to add this libs. Please help me!

Thanks a lot!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

×