Phail's 2 Oct 2008 files...

[superspud77]

Hi there,


I and Diosz are having similar problems with Phail's 2 Oct 2008 files. I have made a post on the topic where it was released but I got no help.

Here is the error...

I run all the match server and so on and then if I wait a bit I get a error that says "DBCONNECT FAIL ThreadID=2838" (I get it with different numbers sometimes)

If I ignore this error and I run the launcher I get the "Cannot access server" error when I try to log in.

I'm using the database that was given in the package but when I execute it I get 2 warning errors...


Warning! The maximum key length is 900 bytes. The index 'IX_IPtoCountryCode_IPRange_060612' has maximum length of 24000 bytes. For some combination of large values, the insert/update operation will fail.

Warning: The maximum length of the row exceeds the permissible limit of 8060 bytes. For some combination of large values, the insert/update operation will fail.

Would that of caused the problem?

Please help.

Thank You,
Zack.

[MentaL]

[superspud77]

Can anyone help me?

Sorry i dont like to bump posts up but i really do need the help ;D

Thanks.

[Touchwise]

If i were right phail recoded some packets so you need to use the proper runnable wich he didn't included..

[superspud77]

If i were right phail recoded some packets so you need to use the proper runnable wich he didn't included..

Yes, you are correct and them packets are the one's im using (http://forum.ragezone.com/f245/phails-2-oct-2008-fixes-modded-files-663378)

I still get the error. Il post all my configurations on here just incase i have miss understood something even though i have looked through and stuff...

Server.ini

[DB]
DNS="gunzdb"
USERNAME="sa"
PASSWORD="DB Password"

[SERVER]
MAXUSER=1500
SERVERID=1
SERVERNAME="Test Server"
KEEPERIP="127.0.0.1"
MONITORIP="127.0.0.1"
MONITORPORT=9000
MODE="test"
COUNTRY="brz"
LANGUAGE="brz"
USETICKET="0"

[LANGUAGE]
LANG_TYPE="brz"

[FILTER]
USE="1"
ACCEPT_INVALID_IP="0"

[ENVIRONMENT]
USE_HSHIELD="0"
USE_XTRAP="1"
USE_EVENT="0"
USE_FILECRC="1"
USE_MD5="1"


Locator.ini

;Debug¸ðµå¿¡¼­¸¸ »ç¿ëÇÔ. Release¸ðµåµµ °°Àº Çü½ÄÀ¸·Î ±¸¼ºµÊ.

[DB]
DNS="Gunzdb"
USERNAME="sa"
PASSWORD="DB Password"

[NETWORK]
IP="127.0.0.1"
PORT="8900"

[ENV]
ID="1"
LOCATOR_UID_HIGH="0"
LOCATOR_UID_LOW="4"
*/ms ¼­¹öÀÇ Á¤º¸¸¦ DB¿¡¼­ °¡Á®¿À´Â °£°Ý.
MAX_ELAPSED_UPDATE_SERVER_STATUS_TIME="30000"
*/ms UDPÅ¥¿¡ ÀúÀåµÇÀÖÀ»¼ö ÀÖ´Â ½Ã°£.
UDP_LIVE_TIME="1000"
*Å¥¿¡ ÀúÀåµÇ Àִµ¿¾È ¹ÞÀ»¼ö ÀÖ´Â ÃÖ´ë °ª. ³Ñ¾î¼­¸é °ø°ÝÀÚ·Î

Ãë±Þ. Å×½ºÆ®¿ë. Á¤»ó ¼öÄ¡´Â 9/s¹ø.
MAX_FREE_RECV_COUNT_PER_LIVE_TIME="9"
*/ms Block¸®½ºÆ®¿¡ µî·ÏµÇÀÖ´Â ½Ã°£.
BLOCK_TIME="30000"
*UDPÅ¥ ¾÷µ¥ÀÌÆ® °£°Ý. Recv,Send,BlockÅ¥°¡ ¸ðµÎ °°ÀÌ ¾÷µ¥ÀÌÆ®

µÊ.
UPDATE_UDP_MANAGER_ELAPSED_TIME="2000"
*¼­¹öÁ¤º¸ ¸¶Áö¸· ¾÷µ¥ÀÌÆ® ½Ã°£Áß °¡Àå Å«°ª°ú ºñ±³ÇÏ¿©
* ÀÌ°ªÀÌ»ó Â÷ÀÌ°¡ ³ª¸é Á×Àº¼­¹ö·Î °£ÁÖ.
* °Ë»çÇÏ°í ½ÍÀº °ªº¸´Ù +1ÇØÁà¾ß ÇÔ.
MARGIN_OF_ERROR_MIN="2"
*'yes' or 'no'
USE_COUNTRY_CODE_FILTER="yes"
GMT_DIFF="9"
ELAPSED_TIME_UPDATE_LOCATOR_LOG="3600000"
ELAPSED_TIME_UPDATE_COUNTRYCODEFILTER_LOG="0"

AgentConfig.xml

<?xml version="1.0" encoding="euc-kr"?>
<XML>
<AGENTCONFIG>
<NAME>Test</NAME>
<MAXCLIENT>500</MAXCLIENT>
<MATCHSERVERADDRESS ip="127.0.0.1" tcpport="6000"/>
<ADDRESS ip="127.0.0.1" tcpport="7777" udpport="5100"/>
</AGENTCONFIG>
</XML>


dbo.ServerStatus




dbo.LocatorStatus



Thank You,
Zack.

[Touchwise]

You don't get me you also need the correct runnable

[superspud77]

Sorry for late reply.

I do get you ;D the runnable is included in [Release] Phail's 2 Oct 2008 Fixes & Modded Files - RaGEZONE - MMORPG server development forums and i am using that runnable.

If i use the wrong runnable it just dont show any servers but i have got the servers showing it is just saying cannot access server.