Tasho 243 Posted April 24, 2014 Share Posted April 24, 2014 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 More sharing options...
Premium Shogun 4588 Posted April 24, 2014 Premium Share Posted April 24, 2014 Is your mysql server actually running? Check in top. If yes, show what's in /etc/my.cnf Link to comment Share on other sites More sharing options...
Tasho 243 Posted April 24, 2014 Author Share Posted April 24, 2014 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 More sharing options...
Premium Shogun 4588 Posted April 24, 2014 Premium Share Posted April 24, 2014 check /var/db/mysql/hostname.err your mysql server is not running for some reason Link to comment Share on other sites More sharing options...
Tasho 243 Posted April 24, 2014 Author Share Posted April 24, 2014 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 More sharing options...
Premium Shogun 4588 Posted April 24, 2014 Premium Share Posted April 24, 2014 upgrade to mysql51-server that version is not supported in FreeBSD 9 Link to comment Share on other sites More sharing options...
Tasho 243 Posted April 24, 2014 Author Share Posted April 24, 2014 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 Link to comment Share on other sites More sharing options...
Premium Shogun 4588 Posted April 24, 2014 Premium Share Posted April 24, 2014 Then install mysql56-server Link to comment Share on other sites More sharing options...
Tasho 243 Posted April 24, 2014 Author Share Posted April 24, 2014 I fallowd this tutorial : Install MySQL7. Go to the port for the MySQL server:cd /usr/ports/databases/mysql56-server make install clean8. Add the following line to /etc/rc.conf:echo 'mysql_enable="YES"' >> /etc/rc.conf9. And start the mysql server:/usr/local/etc/rc.d/mysql-server start10. 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 More sharing options...
.Devil. 28 Posted April 24, 2014 Share Posted April 24, 2014 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. 2 Link to comment Share on other sites More sharing options...
Tasho 243 Posted April 24, 2014 Author Share Posted April 24, 2014 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 More sharing options...
.Devil. 28 Posted April 24, 2014 Share Posted April 24, 2014 Check with top if mysqld is now started, if not, start it with 'service mysql-server start'. Link to comment Share on other sites More sharing options...
Tasho 243 Posted April 30, 2014 Author Share Posted April 30, 2014 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 More sharing options...
RoxaLyssa 311 Posted April 30, 2014 Share Posted April 30, 2014 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. Link to comment Share on other sites More sharing options...
Tasho 243 Posted April 30, 2014 Author Share Posted April 30, 2014 I have plenty of space ... the strange part is that it works on 5.1 and not on 5.6 Link to comment Share on other sites More sharing options...
.Devil. 28 Posted April 30, 2014 Share Posted April 30, 2014 Try this: ALTER TABLE `player` MODIFY COLUMN `part_main` smallint(6) UNSIGNED NOT NULL DEFAULT 0 AFTER `ip`; Link to comment Share on other sites More sharing options...
Kigris 0 Posted July 11, 2014 Share Posted July 11, 2014 (edited) 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: Please help me... Edited August 16, 2022 by Metin2 Dev Core X - External 2 Internal Link to comment Share on other sites More sharing options...
Kigris 0 Posted July 11, 2014 Share Posted July 11, 2014 (edited) 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: Please help me... It also says me this when i boot the serverfile: 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 August 16, 2022 by Metin2 Dev Core X - External 2 Internal Link to comment Share on other sites More sharing options...
Night 366 Posted July 11, 2014 Share Posted July 11, 2014 did you add a metin2 mysql full backup without deleating the other file? Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now