Connection Refused

10/28/2010 20:44 .Gravita#1
So, einige haben bestimmt mitbekommen, dass ich einige
Probleme, bei der Einrichtung unseres Roots hatte, nun mein
nächstes Problem :D :
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
10/28/2010 20:47 Dusselchen#2
Kannst du dich überhaupt in die Datenbank einloggen?
10/28/2010 20:48 .Gravita#3
Ja kann ich.
10/28/2010 20:50 Dusselchen#4
Das sieht aus als könnte er die DB nicht einmal laden. Der failed ja immer wenn die Datenbank anfängt zu laden.
10/28/2010 20:51 .Gravita#5
Jo woran kann das liegen?
CONFIGS falsch eingestellt?
10/28/2010 20:54 Dusselchen#6
Liegt glaub ich eher weniger an den Configs. Was für Files benutzt du den?
10/28/2010 21:00 .Gravita#7
Speedys(game0910.tar.gz).

//EDIT: Anzumerken sei: Ich kriege außerdem folgenden Fehler
Code:
PROT EXEC |PROT WRITE failed
10/29/2010 20:45 .Gravita#8
#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:
[Only registered and activated users can see links. Click Here To Register...]

Muchas Regards,
.Gravita
10/29/2010 20:50 .Yacki#9
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 :D
10/29/2010 20:56 .KKS#10
Sicher das es ne 32 bit Architektur ist?
10/29/2010 21:06 .Gravita#11
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.