Jump to content

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


Recommended Posts

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.

 

 

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

 

 

 

Link to comment
Share on other sites

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...

Link to comment
Share on other sites

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.

  • Love 2
Link to comment
Share on other sites

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?
Link to comment
Share on other sites

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
Link to comment
Share on other sites

  • 2 months later...

 

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!

Edited by Metin2 Dev
Core X - External 2 Internal
Link to comment
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now

Announcements



  • Similar Content

  • Activity

    1. 0

      I just implemented some costumes and they are not visible

    2. 0

      Skill Tree Problem

    3. 97

      Ulthar SF V2 (TMP4 Base)

    4. 5

      Client Crashes through Offline Shop (Ikarus)

    5. 5

      VIVY-WORLD2 - FARM TO THE TOP

    6. 0

      ToolTip Bug?

    7. 0

      Skill tree build erorr

    8. 0

      Visual Bug | How to fix this visual bug inside the Special Storage feature?

  • Recently Browsing

    • No registered users viewing this page.
×
×
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.