Can't connect to local MySQL server through socket '/tmp/mysql.sock'

[reyboy97 10]

Hello,

I have the maxmi 4.1 Files and i become in Putty this error:

 Can't connect to local MySQL server through socket '/tmp/mysql.sock'

Ad: Maxmi & CrysisMT2

Versiyon: v.4.1

Tarih: 06.03.2015

Kanal sayisi giriniz

1 - 1 Kanal

2 - 2 Kanal

3 - 3 Kanal

4 - 4 Kanal
1
 Database Ac▒l▒yor ..
Real Server
Log Offmysql_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 secondsReal Server
Log Offmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
   failed, retrying in 5 seconds
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
   failed, retrying in 5 seconds

 Giris Aciliyor ..
Shared object "libcrypto.so.6" not found, required by "libssl.so.6"
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 seconds

 1.Kanal Aciliyor ..
Shared object "libcrypto.so.6" not found, required by "libssl.so.6"
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 seconds

 Game99 Aciliyor ..
Shared object "libcrypto.so.6" not found, required by "libssl.so.6"
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 seconds
root@rivgar3:/usr/game # Real Server
Real: Command not found.
root@rivgar3:/usr/game # Log Offmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Unmatched '.
root@rivgar3:/usr/game #    failed, retrying in 5 seconds
failed,: Command not found.
root@rivgar3:/usr/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 secondsSuccess PLAYER
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
   failed, retrying in 5 secondsSuccess HOTBACKUP
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 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
failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock'
root@rivgar3:/usr/game #
root@rivgar3:/usr/game #

 

 

 

 

 And this is my syslog from db:

SYSERR: Sep  9 13:22:08 :: pid_init: 
Start of pid: 1060

SYSERR: Sep  9 13:22:08 :: Start: TABLE_POSTFIX not configured use default
Sep  9 13:22:08 :: connecting to MySQL server (player)
Sep  9 13:22:08 :: CREATING DIRECT_SQL
Sep  9 13:22:08 :: AsyncSQL: locale euckr
Sep  9 13:22:08 ::    failed, retrying in 5 seconds
Sep  9 13:22:13 :: CREATING DIRECT_SQL
Sep  9 13:22:13 :: AsyncSQL: locale euckr
Sep  9 13:22:13 ::    failed, retrying in 5 seconds
Sep  9 13:22:18 :: CREATING DIRECT_SQL
Sep  9 13:22:18 :: AsyncSQL: locale euckr
Sep  9 13:22:18 ::    failed, retrying in 5 seconds
Sep  9 13:22:23 :: CREATING DIRECT_SQL
Sep  9 13:22:23 :: AsyncSQL: locale euckr
Sep  9 13:22:23 ::    failed, retrying in 5 seconds
Sep  9 13:22:28 :: CREATING DIRECT_SQL
Sep  9 13:22:28 :: AsyncSQL: locale euckr
Sep  9 13:22:28 ::    failed, retrying in 5 seconds
Sep  9 13:22:33 :: CREATING DIRECT_SQL
Sep  9 13:22:33 :: AsyncSQL: locale euckr
Sep  9 13:22:33 ::    failed, retrying in 5 seconds
Sep  9 13:22:38 :: connecting to MySQL server (account)
Sep  9 13:22:38 :: CREATING DIRECT_SQL
Sep  9 13:22:38 :: AsyncSQL: locale euckr
Sep  9 13:22:38 ::    failed, retrying in 5 seconds
Sep  9 13:22:43 :: CREATING DIRECT_SQL
Sep  9 13:22:43 :: AsyncSQL: locale euckr
Sep  9 13:22:43 ::    failed, retrying in 5 seconds
Sep  9 13:22:48 :: CREATING DIRECT_SQL
Sep  9 13:22:48 :: AsyncSQL: locale euckr
Sep  9 13:22:48 ::    failed, retrying in 5 seconds
Sep  9 13:22:53 :: CREATING DIRECT_SQL
Sep  9 13:22:53 :: AsyncSQL: locale euckr
Sep  9 13:22:53 ::    failed, retrying in 5 seconds
Sep  9 13:22:59 :: CREATING DIRECT_SQL
Sep  9 13:22:59 :: AsyncSQL: locale euckr
Sep  9 13:22:59 ::    failed, retrying in 5 seconds
Sep  9 13:23:04 :: CREATING DIRECT_SQL
Sep  9 13:23:04 :: AsyncSQL: locale euckr
Sep  9 13:23:04 ::    failed, retrying in 5 seconds
Sep  9 13:23:09 :: connecting to MySQL server (common)
Sep  9 13:23:09 :: CREATING DIRECT_SQL
Sep  9 13:23:09 :: AsyncSQL: locale euckr
Sep  9 13:23:09 ::    failed, retrying in 5 seconds
Sep  9 13:23:14 :: CREATING DIRECT_SQL
Sep  9 13:23:14 :: AsyncSQL: locale euckr
Sep  9 13:23:14 ::    failed, retrying in 5 seconds
Sep  9 13:23:19 :: CREATING DIRECT_SQL
Sep  9 13:23:19 :: AsyncSQL: locale euckr
Sep  9 13:23:19 ::    failed, retrying in 5 seconds
Sep  9 13:23:24 :: CREATING DIRECT_SQL
Sep  9 13:23:24 :: AsyncSQL: locale euckr
Sep  9 13:23:24 ::    failed, retrying in 5 seconds
Sep  9 13:23:29 :: CREATING DIRECT_SQL
Sep  9 13:23:29 :: AsyncSQL: locale euckr
Sep  9 13:23:29 ::    failed, retrying in 5 seconds
Sep  9 13:23:34 :: CREATING DIRECT_SQL
Sep  9 13:23:34 :: AsyncSQL: locale euckr
Sep  9 13:23:34 ::    failed, retrying in 5 seconds
Sep  9 13:23:39 :: connecting to MySQL server (hotbackup)
Sep  9 13:23:39 :: CREATING DIRECT_SQL
Sep  9 13:23:39 :: AsyncSQL: locale euckr
Sep  9 13:23:39 ::    failed, retrying in 5 seconds
Sep  9 13:23:44 :: CREATING DIRECT_SQL
Sep  9 13:23:44 :: AsyncSQL: locale euckr
Sep  9 13:23:44 ::    failed, retrying in 5 seconds
Sep  9 13:23:49 :: CREATING DIRECT_SQL
Sep  9 13:23:49 :: AsyncSQL: locale euckr
Sep  9 13:23:49 ::    failed, retrying in 5 seconds
Sep  9 13:23:54 :: CREATING DIRECT_SQL
Sep  9 13:23:54 :: AsyncSQL: locale euckr
Sep  9 13:23:54 ::    failed, retrying in 5 seconds
Sep  9 13:23:59 :: CREATING DIRECT_SQL
Sep  9 13:23:59 :: AsyncSQL: locale euckr
Sep  9 13:23:59 ::    failed, retrying in 5 seconds
Sep  9 13:24:04 :: CREATING DIRECT_SQL
Sep  9 13:24:04 :: AsyncSQL: locale euckr
Sep  9 13:24:04 ::    failed, retrying in 5 seconds
Sep  9 13:24:09 :: ClientManager initialization.. 

 

Pls help i don't know what i do now. 

[Night 382]

use :

mysqld_safe

and copy past the output

[reyboy97 10]

Oh now is going right thank you!

Can be closed

Edited September 9, 2015 by reyboy97

[Weix 0]

root@legionmt2:/home # mysql_safe
mysql_safe: Command not found.
root@legionmt2:/home # mysqld_safe
160502 18:20:38 mysqld_safe Logging to '/var/db/mysql/legionmt2.err'.
160502 18:20:38 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
160502 18:20:41 mysqld_safe mysqld restarted
160502 18:20:41 mysqld_safe mysqld restarted

/: write failed, filesystem is full

/: write failed, filesystem is full
160502 18:20:42 mysqld_safe mysqld restarted
160502 18:20:42 mysqld_safe mysqld restarted
160502 18:20:43 mysqld_safe mysqld restarted

/: write failed, filesystem is full
160502 18:20:44 mysqld_safe mysqld restarted
160502 18:20:45 mysqld_safe mysqld restarted
160502 18:20:48 mysqld_safe mysqld restarted

/: write failed, filesystem is full
160502 18:20:48 mysqld_safe mysqld restarted
160502 18:20:49 mysqld_safe mysqld restarted
160502 18:20:50 mysqld_safe mysqld restarted

/: write failed, filesystem is full

/: write failed, filesystem is full
160502 18:20:50 mysqld_safe mysqld restarted
160502 18:20:51 mysqld_safe mysqld restarted
^C160502 18:20:52 mysqld_safe mysqld restarted
160502 18:20:52 mysqld_safe mysqld restarted

/: write failed, filesystem is full
160502 18:20:52 mysqld_safe mysqld restarted

/: write failed, filesystem is full
160502 18:20:53 mysqld_safe mysqld restarted
160502 18:20:53 mysqld_safe mysqld restarted
 

[ZenkoKXO. 39]

@Weix

1. Go to /var/db/mysql (on winscp)
2. Delete all "ib_logfile" files
3. Delete the .err file (there is only one)
4. Delete the log folder
5. Do this on putty: service mysql-server restart

If you didn't understand, here is a screen of what you need to delete: https://metin2.download/picture/bUHG6amSJVMHEgCB2hZ0De4NeIaodmP6/.png

Edited September 2, 2022 by Metin2 Dev
Core X - External 2 Internal

[Weix 0]

Have you skype ? (I'm French)

[ZenkoKXO. 39]

I told you all you have to do and I also gave you a screenshot, you don't need skype

You must use a translator then if you don't understand english

[iltizio 286]

Wait, wait, wait. Don't do that!

If you remove log database and Redo Log you make a disaster!

Remove only the error log and clean the mysql's filesystem.

If you have only one filesystem (root) clean ports, rotate system logs and clean game logs.

Next check filesystem occupation with df -h on a shell

[Kori 557]

Heare is a Shellscript

 

#!/bin/sh
# Copyright (c) 2016 KoriDev Inc.
# All rights reserved

echo -e "Crear the Server...."
Channel=1
Cores=5
cd /home/devusr
for i in `seq 1 $Channel`
	do for f in `seq 1 $Cores`
		do cd /home/devusr/channel${i}/core${f} && rm -R syslog syserr PTS stdout
	done
done
echo -e "Channels Clear"
echo -e "Clear Database..."
cd /var/db/mysql
rm  *.err
echo -e "Cleaning Done"

 

 

https://koridev.eu/code/kzczYDiH.html

 

Change the path and run this script and u have the error fixxed