Domanda [Dedicato]Non logga , errore collegamento al server

[astinasti]

Stesso problema : http://www.inforge.net/community/metin2-help-modding/320039-processi-del-server.html

Spoiler

131020 22:46:20 mysqld_safe mysqld from pid file /var/db/mysql/ciao.com.pid ended
131020 22:47:21 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
131020 22:47:21 InnoDB: The InnoDB memory heap is disabled
131020 22:47:21 InnoDB: Mutexes and rw_locks use GCC atomic builtins
131020 22:47:21 InnoDB: Compressed tables use zlib 1.2.7
131020 22:47:21 InnoDB: Initializing buffer pool, size = 128.0M
131020 22:47:21 InnoDB: Completed initialization of buffer pool
131020 22:47:21 InnoDB: highest supported file format is Barracuda.
131020 22:47:22 InnoDB: Waiting for the background threads to start
131020 22:47:23 InnoDB: 5.5.34 started; log sequence number 1595675
131020 22:47:23 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
131020 22:47:23 [Note] - '0.0.0.0' resolves to '0.0.0.0';
131020 22:47:23 [Note] Server socket created on IP: '0.0.0.0'.
131020 22:47:23 [Note] Event Scheduler: Loaded 0 events
131020 22:47:23 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.5.34' socket: '/tmp/mysql.sock' port: 3306 Source distribution

salve , ieri ho configurato tutto il dedicato , un FreddBsD 9.2 64bit seguendo questa guida : http://www.inforge.net/community/me...-freebsd-start-primi-passi-guide-di-base.html e dopo ho modificato tutti i CONFIG nei vari core , uso i file di Franzi 2011 opportunamente modificati da me , utilizzavo un no-ip prima , ho preso il Mysql e il Game e l'ho trasformati in .tar.gz e l'ho messi nel dedicato ed estratti , dopo di che ho creato tutti i collegamenti nelle cartelle ,
fatto ciò vado a fare il comando cd /usr/home/game && sh start.sh e su Putty mi da :

Spoiler

Starting Database ..
Real Server
Log Offlog_file_delete_old: stat: No such file or directory
AsyncSQL: connected to localhost (reconnect 1)
Success PLAYER
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
Success ACCOUNT
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
Success COMMON
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
Success HOTBACKUP
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)

Starting Auth ..
PUBLIC_IP: localhost interface em0
HOSTNAME: auth
AsyncSQL: connected to localhost (reconnect 1)
CommonSQL connected
Setting Locale "germany" (Path: locale/germany)
Setting DB to locale latin1
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
PlayerSQL connected
LogSQL connected
SKILL_POWER_BY_LEVEL 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125
SKILL_POWER_BY_JOB 0 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125
SKILL_POWER_BY_JOB 1 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125
AsyncSQL: connected to localhost (reconnect 1)
SKILL_POWER_BY_JOB 2 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125
SKILL_POWER_BY_JOB 3 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125
SKILL_POWER_BY_JOB 4 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125
SKILL_POWER_BY_JOB 5 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125
SKILL_POWER_BY_JOB 6 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125
SKILL_POWER_BY_JOB 7 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125
AUTH_SERVER: I am the master
MasterAuth 6

Starting CH 1 ..
PUBLIC_IP: localhost interface em0
HOSTNAME: channel1
AsyncSQL: connected to localhost (reconnect 1)
CommonSQL connected
Setting Locale "germany" (Path: locale/germany)
Setting DB to locale latin1
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
PlayerSQL connected
LogSQL connected
SKILL_POWER_BY_LEVEL 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125
SKILL_POWER_BY_JOB 0 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125
AsyncSQL: connected to localhost (reconnect 1)
SKILL_POWER_BY_JOB 1 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125
SKILL_POWER_BY_JOB 2 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125
SKILL_POWER_BY_JOB 3 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125
SKILL_POWER_BY_JOB 4 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125
SKILL_POWER_BY_JOB 5 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125
SKILL_POWER_BY_JOB 6 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125
SKILL_POWER_BY_JOB 7 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125
MAP ALLOW 1
MAP ALLOW 3
MAP ALLOW 21
MAP ALLOW 23
MAP ALLOW 41
MAP ALLOW 43
MAP ALLOW 61
MAP ALLOW 62
MAP ALLOW 63
MAP ALLOW 81
MAP ALLOW 64
MAP ALLOW 65
MAP ALLOW 67
MAP ALLOW 68
MAP ALLOW 69
MAP ALLOW 70
MAP ALLOW 194
MAP ALLOW 200
MAP ALLOW 201
MAP ALLOW 202
MAP ALLOW 207
MAP ALLOW 73
MAP ALLOW 72
MAP ALLOW 10
MAP ALLOW 71
MAP ALLOW 208
MAP ALLOW 2
MAP ALLOW 193
LocaleService locale/germany/locale_string.txt

Starting CH 99 ..
PUBLIC_IP: localhost interface em0
HOSTNAME: channel99
AsyncSQL: connected to localhost (reconnect 1)
CommonSQL connected
Setting Locale "germany" (Path: locale/germany)
Setting DB to locale latin1
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
PlayerSQL connected
LogSQL connected
SKILL_POWER_BY_LEVEL 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125
SKILL_POWER_BY_JOB 0 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125
AsyncSQL: connected to localhost (reconnect 1)
SKILL_POWER_BY_JOB 1 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125
SKILL_POWER_BY_JOB 2 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125
SKILL_POWER_BY_JOB 3 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125
SKILL_POWER_BY_JOB 4 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125
SKILL_POWER_BY_JOB 5 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125
SKILL_POWER_BY_JOB 6 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125
SKILL_POWER_BY_JOB 7 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125
MAP ALLOW 113
MAP ALLOW 184
MAP ALLOW 185
MAP ALLOW 186
MAP ALLOW 187
MAP ALLOW 188
MAP ALLOW 189
MAP ALLOW 81
MAP ALLOW 181
MAP ALLOW 182
MAP ALLOW 183
MAP ALLOW 114
MAP ALLOW 118
MAP ALLOW 119
MAP ALLOW 120
MAP ALLOW 121
MAP ALLOW 122
MAP ALLOW 123
MAP ALLOW 124
MAP ALLOW 125
MAP ALLOW 126
MAP ALLOW 127
MAP ALLOW 128
LocaleService locale/germany/locale_string.txt

CH1 wurde gestartet!
root@ciao:/usr/home/game #

A vedere da quà pare tutto ok , ma in game non logga , allora vado a vedere i Syserr :

Channel 1 :

SYSERR: Oct 20 18:01:12 :: LoadStateScript: invalid QUEST STATE index [locale/germany/quest/object/20001/chat/EnergySystem.start.arg] [EnergySystem.start.arg]
SYSERR: Oct 20 18:01:12 :: LoadStateScript: invalid QUEST STATE index [locale/germany/quest/object/20001/chat/EnergySystem.start.script] [EnergySystem.start.script]
SYSERR: Oct 20 18:01:12 :: LoadStateScript: invalid QUEST STATE index [locale/germany/quest/object/20001/chat/EnergySystem.start.when] [EnergySystem.start.when]
SYSERR: Oct 20 18:01:13 :: SetShopItems: not enough shop window

A quanto sò non sono errori che influenzano il game sicchè dovrebbe partire (li ho anche sul no.ip e va tutto)

Auth: Niente

db :

SYSERR: Oct 20 18:01:07 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Oct 20 18:01:08 :: DirectQuery: AsyncSQL:: DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id
SYSERR: Oct 20 18:01:08 :: Load: DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)

anche qua a quanto sò non sono errori che influenzano il game sicchè dovrebbe partire (li ho anche sul no.ip e va tutto)

Game99:

SYSERR: Oct 20 18:01:14 :: LoadStateScript: invalid QUEST STATE index [locale/germany/quest/object/20001/chat/EnergySystem.start.arg] [EnergySystem.start.arg]
SYSERR: Oct 20 18:01:14 :: LoadStateScript: invalid QUEST STATE index [locale/germany/quest/object/20001/chat/EnergySystem.start.script] [EnergySystem.start.script]
SYSERR: Oct 20 18:01:14 :: LoadStateScript: invalid QUEST STATE index [locale/germany/quest/object/20001/chat/EnergySystem.start.when] [EnergySystem.start.when]
SYSERR: Oct 20 18:01:14 :: SetShopItems: not enough shop window

Il problema potrebbe venire dal client ? eppure l'ip nel serverinfo.py l'ho messo corretto
help
skype : hoeplimetin2

 

[TimeToRelax91]

Se leggi errori la maggior parte delle volte dicono che c'è un errore alla quest Energy System...
Prova a cancellare tutte le cose riguardanti energy system, poi reboot e vedi se va

 

[astinasti]

No è dato da quello il problem , grazie comunque della risposta

- - - Updated - - -

Risolto : Installando mysql 5.6

http://www.inforge.net/community/me...odo-alternativo-per-risolvere-mysql-sock.html