Server Problem....

.Bloodseeker · 12/07/2011, 19:17

Tagchen und hier bin ich malwieder mit einem Problem...

Also ich habe gestern haben den server on gehauen und maps bearbeitet,
dann hab ich metin_test aus dem Map Ordner gelöscht und der server ging nicht mehr, habe dann die index bearbeitet und es funktionierte immer noch nicht. Jetzt habe ich die alte index wieder drinne und den map Ordner auch wieder rein gemacht aber es funktzioniert einfach nicht mehr...

Code:

 Starte DB-Server...
 Starte Auth-Server...
Real Server
Log Off Starte Channel 1 ...
PUBLIC_IP: 192.***.178.37 interface em0
AsyncSQL: connected to localhost (reconnect 1)
HOSTNAME: auth
Success PLAYER
AsyncSQL: connected to localhost (reconnect 1)
CommonSQL connected
AsyncSQL: connected to localhost (reconnect 1)
Setting Locale "germany" (Path: locale/germany)
AsyncSQL: connected to localhost (reconnect 1)
Setting DB to locale latin1
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)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
PlayerSQL connected
AsyncSQL: connected to localhost (reconnect 1)
LogSQL connected
Success COMMON
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
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
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
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
Success HOTBACKUP
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
AsyncSQL: connected to localhost (reconnect 1)
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
AsyncSQL: connected to localhost (reconnect 1)
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
connect: Connection refused
MasterAuth 6PUBLIC_IP: 192.***.178.37 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
AsyncSQL: connected to localhost (reconnect 1)
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
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 4
MAP ALLOW 5
MAP ALLOW 21
MAP ALLOW 23
MAP ALLOW 24
MAP ALLOW 25
MAP ALLOW 41
MAP ALLOW 43
MAP ALLOW 44
MAP ALLOW 45
MAP ALLOW 61
MAP ALLOW 62
MAP ALLOW 63
MAP ALLOW 64
MAP ALLOW 65
MAP ALLOW 66
MAP ALLOW 69
MAP ALLOW 70
MAP ALLOW 71
MAP ALLOW 72
MAP ALLOW 73
MAP ALLOW 104
MAP ALLOW 108
MAP ALLOW 109
MAP ALLOW 67
MAP ALLOW 68
MAP ALLOW 80
MAP ALLOW 199
MAP ALLOW 205
MAP ALLOW 207
MAP ALLOW 712
MAP ALLOW 713
MAP ALLOW 714
MAP ALLOW 715
LocaleService locale/germany/locale_string.txt
 Starte Channel 99...
PUBLIC_IP: 192.***.178.37 interface em0
HOSTNAME: game99
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
AsyncSQL: connected to localhost (reconnect 1)
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
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
-----------------------------------------------
TEST_SERVER
-----------------------------------------------
MAP ALLOW 113
MAP ALLOW 184
MAP ALLOW 185
MAP ALLOW 186
MAP ALLOW 187
MAP ALLOW 188
MAP ALLOW 189
MAP ALLOW 193
MAP ALLOW 179
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
MAP ALLOW 712
MAP ALLOW 713
MAP ALLOW 714
MAP ALLOW 715
LocaleService locale/germany/locale_string.txt
 Server erfolgreich gestartet!

Und nach dem ich dann den Server wieder ausgeschaltet habe kommt das.

Code:

Stoppe Channel 4 ...
kill: 1407: No such process
 Stoppe Channel 3 ...
kill: 1411: No such process
 Stoppe Channel 2 ...
kill: 1415: No such process
 Stoppe Channel 1 ...
kill: 1480: No such process
 Stoppe Channel 99...
kill: 1485: No such process
 Stoppe Auth-Server...
 Stoppe DB-Server...

(wenn es was nützt)

auth syserr:

Code:

SYSERR: Dec  7 19:02:46 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Dec  7 19:03:47 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Dec  7 19:05:55 :: SetBilling: cannot find login key 0
SYSERR: Dec  7 19:09:53 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Dec  7 19:09:58 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Dec  7 19:10:18 :: SetBilling: cannot find login key 0
SYSERR: Dec  7 19:11:16 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.

db syserr:

Code:

SYSERR: Dec  7 19:02:44 :: ChildLoop: AsyncSQL: query failed: Query execution was interrupted (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL errno: 1317)
SYSERR: Dec  7 19:02:46 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Dec  7 19:03:47 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Dec  7 19:03:48 :: 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: Dec  7 19:03:48 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)
SYSERR: Dec  7 19:04:23 :: Process: FDWATCH: peer null in event: ident 25
SYSERR: Dec  7 19:05:55 :: Process: FDWATCH: peer null in event: ident 21
SYSERR: Dec  7 19:05:57 :: Process: FDWATCH: peer null in event: ident 22
SYSERR: Dec  7 19:05:59 :: Process: FDWATCH: peer null in event: ident 23
SYSERR: Dec  7 19:06:00 :: Process: FDWATCH: peer null in event: ident 24
SYSERR: Dec  7 19:09:53 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Dec  7 19:09:58 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Dec  7 19:09:58 :: 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: Dec  7 19:09:58 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)
SYSERR: Dec  7 19:10:11 :: Process: FDWATCH: peer null in event: ident 22
SYSERR: Dec  7 19:10:18 :: Process: FDWATCH: peer null in event: ident 20
SYSERR: Dec  7 19:11:16 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.

Ich benutze die "2011er Files 1678 *Mega-Edition* " Serverfiles und eigendlich hat auch alles gut funktioniert ohne lagg ohne alles...

Die Syserr im channel1 ist leer... und es kommt auch nichts neues rein wenn ich den server starte oder ausschalte.

Wenn ich mich auf den Server einloggen möchte, bleibt permanent : "Du wirst mit dem Server verbunden"

Hoffe mir kann jemand weiterhelfen...

~~.Restince~~ · 12/07/2011, 21:52

PHP Code:


			
SYSERR: Dec  7 19:03:47 :: socket_connect: HOST localhost:15000, could not connect.

Guck mal bitte in jeder CONFIG/conf.txt nach ob der DB_Port gleich ist in diesem Fall 15000 den wen er unterschiedlich ist passiert genau dieser Fehler und der Core startet nicht

.Bloodseeker · 12/07/2011, 22:13

Und was hat das mit dem :SetBilling: cannot find login key 0

auf sich ? Wie kann ich das wegbekommen?

Edit: alle Configs und conf.txt haben 15000 als db port

~~RumorUS~~ · 12/08/2011, 09:41

chmod 777 your files?

.iXream. · 12/08/2011, 13:23

Quote:

SYSERR: Dec 7 19:02:44 :: ChildLoop: AsyncSQL: query failed: Query execution was interrupted (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,w hy FROM item_award WHERE taken_time IS NULL errno: 1317)
SYSERR: Dec 7 19:02:46 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Dec 7 19:03:47 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Dec 7 19:03:48 :: DirectQuery: AsyncSQL:irectQuery : 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: Dec 7 19:03:48 :: Load: DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)
SYSERR: Dec 7 19:04:23 :: Process: FDWATCH: peer null in event: ident 25
SYSERR: Dec 7 19:05:55 :: Process: FDWATCH: peer null in event: ident 21
SYSERR: Dec 7 19:05:57 :: Process: FDWATCH: peer null in event: ident 22
SYSERR: Dec 7 19:05:59 :: Process: FDWATCH: peer null in event: ident 23
SYSERR: Dec 7 19:06:00 :: Process: FDWATCH: peer null in event: ident 24
SYSERR: Dec 7 19:09:53 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Dec 7 19:09:58 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Dec 7 19:09:58 :: DirectQuery: AsyncSQL:irectQuery : 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: Dec 7 19:09:58 :: Load: DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)
SYSERR: Dec 7 19:10:11 :: Process: FDWATCH: peer null in event: ident 22
SYSERR: Dec 7 19:10:18 :: Process: FDWATCH: peer null in event: ident 20
SYSERR: Dec 7 19:11:16 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.

Dort werden die Fehler liegen.
Versuch mal ne entbuggter DB zu bekommen.

Quote:

item_award
monarch_candidacy
TABLE_POSTFIX

Die Sachen sind schrott.

am besten durch neue ersetzen