Problem

amnael1 · 08/07/2012, 20:43

Wenn ich den Server starten will kommt in PuTTY das hier:

Code:

PROT_EXEC|PROT_WRITE failed.
PUBLIC_IP: 192.168.1.110 interface em0
PUBLIC_IP: 28.28.0.0 interface lo0
PUBLIC_IP: 28.28.0.0 interface lo0
hostname game1_1
PLAYER_SQL: localhost mt2 mt2!@# player
COMMON_SQL: localhost mt2 mt2!@# common
LOG_SQL: localhost mt2 mt2!@# log
Init english
Setting Locale ="english"
locale/english
Set Locale = english
[SetLocale]
PlayerSQL.Connect(localhost mt2 mt2!@# player)
metin2# PUBLIC_IP: 192.168.1.110 interface em0
PUBLIC_IP: 28.28.0.0 interface lo0
PUBLIC_IP: 28.28.0.0 interface lo0
hostname game1_2
PLAYER_SQL: localhost mt2 mt2!@# player
COMMON_SQL: localhost mt2 mt2!@# common
LOG_SQL: localhost mt2 mt2!@# log
Init english
Setting Locale ="english"
locale/english
Set Locale = english
[SetLocale]
PlayerSQL.Connect(localhost mt2 mt2!@# player)
PUBLIC_IP: 192.168.1.110 interface em0
PUBLIC_IP: 28.28.0.0 interface lo0
PUBLIC_IP: 28.28.0.0 interface lo0
hostname game1_3
PLAYER_SQL: localhost mt2 mt2!@# player
COMMON_SQL: localhost mt2 mt2!@# common
LOG_SQL: localhost mt2 mt2!@# log
Init english
Setting Locale ="english"
locale/english
Set Locale = english
[SetLocale]
PlayerSQL.Connect(localhost mt2 mt2!@# player)
PROT_EXEC|PROT_WRITE failed.
PUBLIC_IP: 192.168.1.110 interface em0
PUBLIC_IP: 28.28.0.0 interface lo0
PUBLIC_IP: 28.28.0.0 interface lo0
hostname game2
COMMON_SQL: localhost mt2 mt2!@# common
PLAYER_SQL: localhost mt2 mt2!@# player
LOG_SQL: localhost mt2 mt2!@# log
Init english
Setting Locale ="english"
locale/english
Set Locale = english
[SetLocale]
PlayerSQL.Connect(localhost mt2 mt2!@# player)
PUBLIC_IP: 192.168.1.110 interface em0
PUBLIC_IP: 28.28.0.0 interface lo0
PUBLIC_IP: 28.28.0.0 interface lo0
hostname game61
PLAYER_SQL: localhost mt2 mt2!@# player
COMMON_SQL: localhost mt2 mt2!@# common
LOG_SQL: localhost mt2 mt2!@# log
Init english
Setting Locale ="english"
locale/english
Set Locale = english
[SetLocale]
PlayerSQL.Connect(localhost mt2 mt2!@# player)
PUBLIC_IP: 192.168.1.110 interface em0
PUBLIC_IP: 28.28.0.0 interface lo0
PUBLIC_IP: 28.28.0.0 interface lo0
hostname game99
PLAYER_SQL: localhost mt2 mt2!@# player
COMMON_SQL: localhost mt2 mt2!@# common
LOG_SQL: localhost mt2 mt2!@# log
Init english
Setting Locale ="english"
locale/english
Set Locale = english
[SetLocale]
PlayerSQL.Connect(localhost mt2 mt2!@# player)
PUBLIC_IP: 192.168.1.110 interface em0
PUBLIC_IP: 28.28.0.0 interface lo0
PUBLIC_IP: 28.28.0.0 interface lo0
hostname first
PLAYER_SQL: localhost mt2 mt2!@# player
COMMON_SQL: localhost mt2 mt2!@# common
LOG_SQL: localhost mt2 mt2!@# log
Init english
Setting Locale ="english"
locale/english
Set Locale = english
[SetLocale]
PlayerSQL.Connect(localhost mt2 mt2!@# player)

In der syserr-Dateien steht das hier:

Code:

SYSERR: Aug  7 19:00:24 :: QueryLocaleSet: m_stLocale == 0
SYSERR: Aug  7 19:00:24 :: QueryLocaleSet: m_stLocale == 0
SYSERR: Aug  7 19:00:24 :: socket_bind: bind: Can't assign requested address

Habe FreeBSD 9 (64-bit).

theo1990 · 08/07/2012, 21:49

hast du was in der player , common oder log datenbank was verändert? Überprüf mal deine abellen auf fehler...

und such mal nach dem feld

m_stLocale == 0

anscheindend ist dieses feld 0 und es darf nicht null sein

amnael1 · 08/08/2012, 07:03

Ne, habe nichts verändert.

Habe das hier in der DB information_schema gefunden:

Code:

SELECT
	*
FROM
	`information_schema`.`PROCESSLIST`
WHERE
	CAST(
		`information_schema`.`PROCESSLIST`.`USER` AS CHAR CHARACTER
		SET utf8
	) COLLATE utf8_general_ci LIKE '%m_stLocale == 0%'
OR CAST(
	`information_schema`.`PROCESSLIST`.`HOST` AS CHAR CHARACTER
	SET utf8
) COLLATE utf8_general_ci LIKE '%m_stLocale == 0%'
OR CAST(
	`information_schema`.`PROCESSLIST`.`DB` AS CHAR CHARACTER
	SET utf8
) COLLATE utf8_general_ci LIKE '%m_stLocale == 0%'
OR CAST(
	`information_schema`.`PROCESSLIST`.`COMMAND` AS CHAR CHARACTER
	SET utf8
) COLLATE utf8_general_ci LIKE '%m_stLocale == 0%'
OR CAST(
	`information_schema`.`PROCESSLIST`.`STATE` AS CHAR CHARACTER
	SET utf8
) COLLATE utf8_general_ci LIKE '%m_stLocale == 0%'
OR CAST(
	`information_schema`.`PROCESSLIST`.`INFO` AS CHAR CHARACTER
	SET utf8
) COLLATE utf8_general_ci LIKE '%m_stLocale == 0%';

theo1990 · 08/08/2012, 12:21

Steht da was mit dme select dann gemacht wird? weil der sucht ja nur nach dem muster
%m_stLocale == 0%?

was steht denn alles in der Tabelle USER und Prozesslist. Und voallem wo hast dud en server stehen? oder ist der nur lokal

vorallem wo hast du denn das query her? hast du das ausgeführt oder war das irgendwo gespeichert?

amnael1 · 08/08/2012, 17:04

Der Server ist im meinem Lokalen Netzwerk.

Als ich nach m_stLocale == 0 suchte, erschien halt dieses Query. Wenn ich es auführe findet er diesen Datensatz:

Code:

ID: 50
USER: root
HOST: 192.168.1.101:51973
DB: information_schema
COMMAND: Query
TIME: 0
STATE: executing
INFO: ) COLLATE utf8_general_ci LIKE '%m_stLocale == 0%'

Tabelle: PROCESSLIST

Code:

52	root	192.168.1.101:52073	information_schema	Query	0	executing	SELECT * FROM `PROCESSLIST` LIMIT 0, 1000
47	root	192.168.1.101:51950	information_schema	Sleep	0		
46	root	192.168.1.101:51949	NULL     Sleep    282		
7	mt2	localhost	common	Sleep	1723		
6	mt2	localhost	common	Sleep	1726		
5	mt2	localhost	common	Sleep	1729		
4	mt2	localhost	common	Sleep	1732		
3	mt2	localhost	common	Sleep	1735		
2	mt2	localhost	common	Sleep	1738		
1	mt2	localhost	common	Sleep	1741