Connection Refused

~~.Gravita~~ · 10/28/2010, 20:44

So, einige haben bestimmt mitbekommen, dass ich einige
Probleme, bei der Einrichtung unseres Roots hatte, nun mein
nächstes Problem :
Mir ist es gelungen den Root halbwegs gescheit zu konfiguieren,
leider krieg ich jetzt dauernd die Fehlermeldung:
Connect: Connection Refused

Und das ziemlich lange.
Ich habe mir mal die syserr bei ./db angeschaut und dort stand folgendes drinne:

Code:

SYSERR: May 11 19:58:13 :: Start: TABLE_POSTFIX not configured use default SYSERR: May 11 19:58:14 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous query: SELECT empire,pid,name,money,windate FROM monarch a,player b where a.pid=b.id SYSERR: May 11 19:58:14 :: LoadMonarch: DirectQuery failed( SELECT empire,pid,name,money,windate FROM monarch a,player b where a.pid=b.id ) SYSERR: May 11 19:58:14 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous query: SELECT pid,name,windate FROM monarch_candidacy a,player b where a.pid = b.id SYSERR: May 11 19:58:14 :: LoadMonarchCandidacy: DirectQuery failed( SELECT pid,name,windate FROM monarch_candidacy a,player b where a.pid = b.id ) SYSERR: May 11 19:58:14 :: LoadMonarchElection: DirectQuery failed( SELECT pid,selectedpid,electiondata FROM monarch_election ) SYSERR: May 11 19:59:28 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down. SYSERR: May 11 20:00:26 :: Start: TABLE_POSTFIX not configured use default SYSERR: May 11 20:00:27 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous query: SELECT empire,pid,name,money,windate FROM monarch a,player b where a.pid=b.id SYSERR: May 11 20:00:27 :: LoadMonarch: DirectQuery failed( SELECT empire,pid,name,money,windate FROM monarch a,player b where a.pid=b.id ) SYSERR: May 11 20:00:27 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous query: SELECT pid,name,windate FROM monarch_candidacy a,player b where a.pid = b.id SYSERR: May 11 20:00:27 :: LoadMonarchCandidacy: DirectQuery failed( SELECT pid,name,windate FROM monarch_candidacy a,player b where a.pid = b.id ) SYSERR: May 11 20:00:27 :: LoadMonarchElection: DirectQuery failed( SELECT pid,selectedpid,electiondata FROM monarch_election ) SYSERR: May 11 20:20:47 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down. SYSERR: May 12 12:57:08 :: Start: TABLE_POSTFIX not configured use default SYSERR: May 12 12:57:09 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous query: SELECT empire,pid,name,money,windate FROM monarch a,player b where a.pid=b.id SYSERR: May 12 12:57:09 :: LoadMonarch: DirectQuery failed( SELECT empire,pid,name,money,windate FROM monarch a,player b where a.pid=b.id ) SYSERR: May 12 12:57:09 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous query: SELECT pid,name,windate FROM monarch_candidacy a,player b where a.pid = b.id SYSERR: May 12 12:57:09 :: LoadMonarchCandidacy: DirectQuery failed( SELECT pid,name,windate FROM monarch_candidacy a,player b where a.pid = b.id ) SYSERR: May 12 12:57:09 :: LoadMonarchElection: DirectQuery failed( SELECT pid,selectedpid,electiondata FROM monarch_election ) SYSERR: May 12 13:43:53 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down. SYSERR: May 12 13:44:27 :: Start: TABLE_POSTFIX not configured use default SYSERR: May 12 13:44:28 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous query: SELECT empire,pid,name,money,windate FROM monarch a,player b where a.pid=b.id SYSERR: May 12 13:44:28 :: LoadMonarch: DirectQuery failed( SELECT empire,pid,name,money,windate FROM monarch a,player b where a.pid=b.id ) SYSERR: May 12 13:44:28 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous query: SELECT pid,name,windate FROM monarch_candidacy a,player b where a.pid = b.id SYSERR: May 12 13:44:28 :: LoadMonarchCandidacy: DirectQuery failed( SELECT pid,name,windate FROM monarch_candidacy a,player b where a.pid = b.id ) SYSERR: May 12 13:44:28 :: LoadMonarchElection: DirectQuery failed( SELECT pid,selectedpid,electiondata FROM monarch_election ) SYSERR: May 12 16:03:45 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down. SYSERR: May 12 16:03:58 :: Start: TABLE_POSTFIX not configured use default SYSERR: May 12 16:03:58 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous query: SELECT empire,pid,name,money,windate FROM monarch a,player b where a.pid=b.id SYSERR: May 12 16:03:58 :: LoadMonarch: DirectQuery failed( SELECT empire,pid,name,money,windate FROM monarch a,player b where a.pid=b.id ) SYSERR: May 12 16:03:58 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous query: SELECT pid,name,windate FROM monarch_candidacy a,player b where a.pid = b.id SYSERR: May 12 16:03:58 :: LoadMonarchCandidacy: DirectQuery failed( SELECT pid,name,windate FROM monarch_candidacy a,player b where a.pid = b.id ) SYSERR: May 12 16:03:58 :: LoadMonarchElection: DirectQuery failed( SELECT pid,selectedpid,electiondata FROM monarch_election ) SYSERR: May 14 14:51:42 :: Start: TABLE_POSTFIX not configured use default SYSERR: May 14 14:51:43 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous query: SELECT empire,pid,name,money,windate FROM monarch a,player b where a.pid=b.id SYSERR: May 14 14:51:43 :: LoadMonarch: DirectQuery failed( SELECT empire,pid,name,money,windate FROM monarch a,player b where a.pid=b.id ) SYSERR: May 14 14:51:43 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous query: SELECT pid,name,windate FROM monarch_candidacy a,player b where a.pid = b.id SYSERR: May 14 14:51:43 :: LoadMonarchCandidacy: DirectQuery failed( SELECT pid,name,windate FROM monarch_candidacy a,player b where a.pid = b.id ) SYSERR: May 14 14:51:43 :: LoadMonarchElection: DirectQuery failed( SELECT pid,selectedpid,electiondata FROM monarch_election ) SYSERR: May 14 16:00:21 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down. SYSERR: May 14 16:00:33 :: Start: TABLE_POSTFIX not configured use default SYSERR: May 14 16:00:33 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous query: SELECT empire,pid,name,money,windate FROM monarch a,player b where a.pid=b.id SYSERR: May 14 16:00:33 :: LoadMonarch: DirectQuery failed( SELECT empire,pid,name,money,windate FROM monarch a,player b where a.pid=b.id ) SYSERR: May 14 16:00:33 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous query: SELECT pid,name,windate FROM monarch_candidacy a,player b where a.pid = b.id SYSERR: May 14 16:00:33 :: LoadMonarchCandidacy: DirectQuery failed( SELECT pid,name,windate FROM monarch_candidacy a,player b where a.pid = b.id ) SYSERR: May 14 16:00:33 :: LoadMonarchElection: DirectQuery failed( SELECT pid,selectedpid,electiondata FROM monarch_election ) SYSERR: May 14 18:16:40 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down. SYSERR: May 14 18:16:49 :: Start: TABLE_POSTFIX not configured use default SYSERR: May 14 18:16:49 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous query: SELECT empire,pid,name,money,windate FROM monarch a,player b where a.pid=b.id SYSERR: May 14 18:16:49 :: LoadMonarch: DirectQuery failed( SELECT empire,pid,name,money,windate FROM monarch a,player b where a.pid=b.id ) SYSERR: May 14 18:16:49 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous query: SELECT pid,name,windate FROM monarch_candidacy a,player b where a.pid = b.id SYSERR: May 14 18:16:49 :: LoadMonarchCandidacy: DirectQuery failed( SELECT pid,name,windate FROM monarch_candidacy a,player b where a.pid = b.id ) SYSERR: May 14 18:16:49 :: LoadMonarchElection: DirectQuery failed( SELECT pid,selectedpid,electiondata FROM monarch_election ) SYSERR: May 14 18:18:11 :: Process: FDWATCH: peer null in event: ident 22 SYSERR: May 14 18:18:19 :: Process: FDWATCH: peer null in event: ident 23 SYSERR: May 14 18:18:23 :: Process: FDWATCH: peer null in event: ident 24 SYSERR: May 14 18:18:24 :: Process: FDWATCH: peer null in event: ident 25 SYSERR: May 14 18:18:24 :: Process: FDWATCH: peer null in event: ident 25 SYSERR: May 14 18:18:24 :: Process: FDWATCH: peer null in event: ident 25 SYSERR: May 14 18:18:26 :: Process: FDWATCH: peer null in event: ident 26 SYSERR: May 14 18:18:29 :: Process: FDWATCH: peer null in event: ident 27 SYSERR: May 14 18:18:33 :: Process: FDWATCH: peer null in event: ident 28 SYSERR: May 14 18:19:37 :: Process: FDWATCH: peer null in event: ident 29 SYSERR: May 14 18:19:44 :: Process: FDWATCH: peer null in event: ident 23 SYSERR: May 14 18:19:55 :: Process: FDWATCH: peer null in event: ident 25 SYSERR: May 14 18:19:56 :: Process: FDWATCH: peer null in event: ident 24 SYSERR: May 14 18:19:56 :: Process: FDWATCH: peer null in event: ident 26 SYSERR: May 14 18:19:57 :: Process: FDWATCH: peer null in event: ident 27 SYSERR: May 14 18:19:58 :: Process: FDWATCH: peer null in event: ident 28 SYSERR: May 14 18:20:58 :: Process: FDWATCH: peer null in event: ident 29 SYSERR: May 14 18:21:08 :: Process: FDWATCH: peer null in event: ident 23 SYSERR: May 14 18:21:30 :: Process: FDWATCH: peer null in event: ident 28 SYSERR: May 14 18:21:30 :: Process: FDWATCH: peer null in event: ident 24 SYSERR: May 14 18:21:30 :: Process: FDWATCH: peer null in event: ident 26 SYSERR: May 14 18:21:30 :: Process: FDWATCH: peer null in event: ident 25 SYSERR: May 14 18:21:31 :: Process: FDWATCH: peer null in event: ident 27 SYSERR: May 14 18:22:20 :: Process: FDWATCH: peer null in event: ident 29 SYSERR: May 14 18:22:30 :: Process: FDWATCH: peer null in event: ident 23 SYSERR: May 14 18:23:05 :: Process: FDWATCH: peer null in event: ident 26 SYSERR: May 14 18:23:05 :: Process: FDWATCH: peer null in event: ident 27 SYSERR: May 14 18:23:06 :: Process: FDWATCH: peer null in event: ident 28 SYSERR: May 14 18:23:06 :: Process: FDWATCH: peer null in event: ident 24 SYSERR: May 14 18:23:07 :: Process: FDWATCH: peer null in event: ident 25 SYSERR: May 14 18:23:35 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down. SYSERR: May 14 18:23:02 :: Start: TABLE_POSTFIX not configured use default SYSERR: May 14 18:23:03 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous query: SELECT empire,pid,name,money,windate FROM monarch a,player b where a.pid=b.id SYSERR: May 14 18:23:03 :: LoadMonarch: DirectQuery failed( SELECT empire,pid,name,money,windate FROM monarch a,player b where a.pid=b.id ) SYSERR: May 14 18:23:03 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous query: SELECT pid,name,windate FROM monarch_candidacy a,player b where a.pid = b.id SYSERR: May 14 18:23:03 :: LoadMonarchCandidacy: DirectQuery failed( SELECT pid,name,windate FROM monarch_candidacy a,player b where a.pid = b.id ) SYSERR: May 14 18:23:03 :: LoadMonarchElection: DirectQuery failed( SELECT pid,selectedpid,electiondata FROM monarch_election ) SYSERR: May 14 18:24:48 :: Process: FDWATCH: peer null in event: ident 25 SYSERR: May 14 18:24:48 :: Process: FDWATCH: peer null in event: ident 22 SYSERR: May 14 18:24:48 :: Process: FDWATCH: peer null in event: ident 26 SYSERR: May 14 18:24:48 :: Process: FDWATCH: peer null in event: ident 24 SYSERR: May 14 18:24:48 :: Process: FDWATCH: peer null in event: ident 23 SYSERR: May 14 18:24:50 :: Process: FDWATCH: peer null in event: ident 27 SYSERR: May 14 18:24:51 :: Process: FDWATCH: peer null in event: ident 28 SYSERR: May 14 18:25:33 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down. SYSERR: May 14 18:26:33 :: Start: TABLE_POSTFIX not configured use default SYSERR: May 14 18:26:34 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous query: SELECT empire,pid,name,money,windate FROM monarch a,player b where a.pid=b.id SYSERR: May 14 18:26:34 :: LoadMonarch: DirectQuery failed( SELECT empire,pid,name,money,windate FROM monarch a,player b where a.pid=b.id ) SYSERR: May 14 18:26:34 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous query: SELECT pid,name,windate FROM monarch_candidacy a,player b where a.pid = b.id SYSERR: May 14 18:26:34 :: LoadMonarchCandidacy: DirectQuery failed( SELECT pid,name,windate FROM monarch_candidacy a,player b where a.pid = b.id ) SYSERR: May 14 18:26:34 :: LoadMonarchElection: DirectQuery failed( SELECT pid,selectedpid,electiondata FROM monarch_election ) SYSERR: May 14 18:27:55 :: Process: FDWATCH: peer null in event: ident 22 SYSERR: May 14 18:27:58 :: Process: FDWATCH: peer null in event: ident 23 SYSERR: May 14 18:28:01 :: Process: FDWATCH: peer null in event: ident 24 SYSERR: May 14 18:28:04 :: Process: FDWATCH: peer null in event: ident 25 SYSERR: May 14 18:28:07 :: Process: FDWATCH: peer null in event: ident 26 SYSERR: May 14 18:28:10 :: Process: FDWATCH: peer null in event: ident 27 SYSERR: May 14 18:28:13 :: Process: FDWATCH: peer null in event: ident 28 SYSERR: May 14 18:29:00 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.

Hat jemand eine Ahnung woran das liegen könnte? Ist einfach die Datenbank fehlerhaft, oder ist das irgendein Fehler, den ich bei der Einrichtung gemacht habe, oder beides?

Muchas regards,
.Gravita

~~Dusselchen~~ · 10/28/2010, 20:47

Kannst du dich überhaupt in die Datenbank einloggen?

~~.Gravita~~ · 10/28/2010, 20:48

Ja kann ich.

~~Dusselchen~~ · 10/28/2010, 20:50

Das sieht aus als könnte er die DB nicht einmal laden. Der failed ja immer wenn die Datenbank anfängt zu laden.

~~.Gravita~~ · 10/28/2010, 20:51

Jo woran kann das liegen?
CONFIGS falsch eingestellt?

~~Dusselchen~~ · 10/28/2010, 20:54

Liegt glaub ich eher weniger an den Configs. Was für Files benutzt du den?

~~.Gravita~~ · 10/28/2010, 21:00

Speedys(game0910.tar.gz).

//EDIT: Anzumerken sei: Ich kriege außerdem folgenden Fehler

Code:

PROT EXEC |PROT WRITE failed

~~.Gravita~~ · 10/29/2010, 20:45

#PUSH Hoffe jemand kann helfen ;(
Ich habe Root nochmal neu installiert(8.1), jetzt krieg ich kein Connection
Refused mehr, sondern immer noch dieses

Code:

PROT_EXEC | PROT_WRITE FAILED

außerdem stoppt der Server an einer bestimmten Stelle zu laden.
Login etc. sind down.
Das Problem mit dem PROT_EXEC hängt anscheinend mit der Datenank zusammen, da ich den Fehler kriege, wenn ich die /home/game/db_auth.sh ausführe.
Hier ein Screen:

Muchas Regards,
.Gravita

.Yacki · 10/29/2010, 20:50

Datenbanken reparieren. Meistens sind das die Player DBs.

Geh in die Player DB also haupt-player-db.

Dann STRG+A das alles markiert wird, dann rechtsklick auf eine und dann maintain tables oder so dann repair tables -> extendet oder sow

~~.KKS~~ · 10/29/2010, 20:56

Sicher das es ne 32 bit Architektur ist?

~~.Gravita~~ · 10/29/2010, 21:06

Ja, sicher. Und an der DB an sich liegts nicht, hab das schon 1000mal gemacht .Yacki^^
Naja hab mir jetzt noch nen zweiten Root bei Worldstream bestellt, mal sehn ob's da klappt, muss irgendwie den ersten finanzieren, an dieser Stelle, danke an meinen Sponsor.