[HELP ME] Can't run server services!

11/10/2010 00:58 godofsnacks#1
Hi, I have been following [Only registered and activated users can see links. Click Here To Register...] guide to set up an EP5 server, and I can't get it to work!

I successfully followed each step of the guide until the last step -- Starting all server services...

When I do "Control Service -> Start All server service", Only a few turn to arrows for a few seconds and then back to paused.
Here is a video of what happens: [Only registered and activated users can see links. Click Here To Register...]
Please notice that my server IP is set to 127.0.0.1, the server is running on a partition of my hard drive.

I am using Microsoft SQL Server Express, and running Win7 Premium.

This is really frustrating because I am so close, yet so far from having my server working.

How do I fix this problem? I am desperate.

Thank you for any information you give me in advance.
11/10/2010 01:28 Andpaur#2
Please check to all *.ini files and sql server configuration, and set up to international ip address (eg. 88.126.54.115)
if you continue problem then pls write log files and *.ini config files

enjoy
11/10/2010 02:01 godofsnacks#3
What do you mean by international IP address? The SQL server configuration settings seem to be fine.

Here are the Log files in PSM_Server/Log and PSM_Client/Log:

---PSM_Server/Log---
PSMSERVER_AGENT__system.log__20101101_171435
Code:
2010-11-01 17:14:35 PSMSERVER_AGENT__system log start (PS_AGENT)

2010-11-01 17:19:16 127.0.0.1 FILE_ERROR_FILELIST ServerAgent\Common

2010-11-01 17:19:16 127.0.0.1 FILE_ERROR_FILELIST ServerAgent\Common

2010-11-01 17:19:16 127.0.0.1 FILE_ERROR_FILELIST ServerAgent\Main
PSMSERVER_AGENT__system.log__20101101_182908

Code:
2010-11-01 18:29:08 PSMSERVER_AGENT__system log start (PS_AGENT)

PSMSERVER_AGENT__system.log__20101107_123722

Code:
2010-11-07 12:37:22 PSMSERVER_AGENT__system log start (PS_AGENT)

---PSM_Client/Log---

PSM_AGENT__system.log__20101101_171431

Code:
2010-11-01 17:14:31 PSM_AGENT__system log start (PS_AGENT)

2010-11-01 17:19:11 Update start 127.0.0.1:40901...

2010-11-01 17:19:16 download error file list

2010-11-01 17:19:16 download error file list

2010-11-01 17:19:16 download error file list

2010-11-01 17:19:16 Update complete...

PSM_AGENT__system.log__20101101_182904

Code:
2010-11-01 18:29:04 PSM_AGENT__system log start (PS_AGENT)

PSM_AGENT__system.log__20101107_123721

Code:
2010-11-07 12:37:21 PSM_AGENT__system log start (PS_AGENT)

PSM_Server/Config and PSM_Client/Config *.ini files:

---PSM_Server/Config---

PSMServer_Config

Code:
[Main]

  <ip_session> = 127.0.0.1

  <ip_userlog> = 127.0.0.1

  <db_user>    = 127.0.0.1, PS_UserData, frankie1, DFF501D92772AA80EA5CC589A31FDEB518B9B29DD5793655A7C6BAF00CAF47F9C43A141BA94BE3DB0B5D059DD10E128EEEC81BB95D64458550EBEF2825F91177FFF60007777FD6ACB710F55140DC2A02EA6DD09131F963EB4B425C05D52D760E70B1715E7373132DB97801E41DF50EFEEE380C67F26CA8E7D18017C8F961366E



[Login_001]

  <sv_maxuser>  = 5000

  <ip_login>    = 127.0.0.1



[GameGroup_001]

  <sv_maxuser>     = 3000

  <sv_gameversion> = 0x09072200

  <sv_gamename>    = Gaia

  <sv_publicip>    = 127.0.0.1

  <ip_game>    = 127.0.0.1

  <ip_dbagent> = 127.0.0.1

  <ip_gamelog> = 127.0.0.1

  <db_game>    = 127.0.0.1, PS_GameData, frankie1, 4CB1E06F1478039C3E3B685D54D5715A84A664AB6C38C3F2947359ED730F652BAAB4AE747ECD0988D426D3EDF25AE1A85845E0CE0C025C59D7CF9F387A286409130DEA06E45761210786AD284302D42E312494149C7CD99C9C875DDBA3DAA6A75D70761212285F521113179EA6FBED497E57D2C4377922AA9957B95485AEA7FE

  <db_gamedef> = 127.0.0.1, PS_GameDefs, frankie1, 92054FD917E7C965FC6A80315D079FAE101AC0E192AB43CD21CE4849758C3E70F43872D893A03441D8D4857A4C744E0398A980DF48D01F2C0A296AC6B04D3C54988DE276D9602CF36A1119083D39CBA28A68FFEDD9F6962E231409E830CCA5305767735D858232F7F1D09842C1C98A040E38C342F8525CB38E3F031F20022A24

  <db_gamelog> = 127.0.0.1, PS_GameLog, frankie1, B9BDE22ADCF28977C4B06EACCDDEDA3688A66E4835F3EEE78CD0AC1859E1DCD8B292CDBF21C7DFAAB8CD22A2F1F3E28F5B8344C1A6648A29987B00FD35EB3643C5418438AFC54FF5B72C73D31720790079C738FAD88E8EEA72D4A3654E74A82328E205F8CD82F315E55E423B6B793D5B819548D20425BEC238974F352F12C10A

  <db_chatlog> = 127.0.0.1, PS_ChatLog, frankie1, 840EAC01388A0166B535D73E8B1686BEB55EFEDA22A2A5A4A8C8F62400AF2D9F6C54AAA44F7A7ECC92EB4B88E42128D497B1A2F957E157A9BC0D6CC1BC5066806570A200DA23C13174BDE4AA70EC37E85AFD1D64E8C2B94B5F0BC6B5999EFBC888454D817330541431F75AA8CA621879F0E35D97287E11C7EA91F0C5AD189BEA

PSMServer_Patch_PatchInfo_Config

Code:
///////////////////////////////////////////////////////////////////
// Game tool

  <file_target_path> = ShaiyaServerPatch/Agent/Update_ForGMTool
    <file_src> = PSGMTool.exe
    <file_src> = PSM_Update.exe
    <file_src> = PSM_StartUpdate.exe

  <file_target_path> = ShaiyaServerPatch/Agent/Update_ForGMTool/Config
    <file_src> = Language.lng
    <file_src> = PSM_Update.ini
    <file_src> = PSM_UpdateExcute.ini
    <file_src> = PS_GMTool.ini
    <file_src> = PSM_UpdateServer.ini

  <file_target_path> = ShaiyaServerPatch/Agent/Update_ForGMTool/Data
    <file_src> = NpcQuest.SData



[PATCH_SQL_DATA_LIST]
  <sql_target_db> = PS_GameDefs
    <sql_src> = *ExpDataExport*.sql;*ExpDataExport*.txt
    <sql_src> = *BaseIemDataExport*.sql;*BaseIemDataExport*.txt
    <sql_src> = *CharHPSPMPDataExport*.sql;*CharHPSPMPDataExport*.txt

    <sql_src> = *ProductList*.sql;*ProductList*.txt;
    <sql_src> = *ItemSellList*DataExport*.sql;*ItemSellList*DataExport*.txt
    <sql_src> = *ItemBuiling*DataExport*.sql;*ItemBuiling*DataExport*.txt
    <sql_src> = *ItemBilling*DataExport*.sql;*ItemBilling*DataExport*.txt
    
    <sql_src> = *ItemDataExport*.sql;*ItemDataExport*.txt
    <sql_src> = *MonsterDataExport*.sql;*MonsterDataExport*.txt
    
    <sql_src> = *SkillDataExportMob.sql;*SkillDataExportMob.txt;
    <sql_src> = *SkillDataExport.sql;*SkillDataExport.txt
    <sql_src> = *SkillDataExportMob_*.sql;*SkillDataExportMob_*.txt;
    <sql_src> = *SkillDataExport_*.sql;*SkillDataExport_*.txt    
    
    //<sql_src> = *SkillDataExportMob*.sql;*SkillDataExportMob*.txt
    //<sql_src> = *SkillDataExport*.sql;*SkillDataExport*.txt


[PATCH_SQL_SCHEMA_LIST]
//  <sql_target_db> = PS_GameDefs
//	<sql_src> = *PS_GameDefs*.sql

 // <sql_target_db> = PS_UserData
//	<sql_src> = *PS_UserData*.sql

 // <sql_target_db> = PS_GameData
//	<sql_src> = *PS_GameData*.sql

 // <sql_target_db> = PS_GameLog
//	<sql_src> = *PS_GameLog*.sql

 // <sql_target_db> = PS_ChatLog
//	<sql_src> = *PS_ChatLog*.sql

 // <sql_target_db> = PS_GMTool
//	<sql_src> = *PS_GMTool*.sql

---PSM_Client/Config---

PSM_Service

Code:
ps_session|Shaiya Session Server|Shaiya Session Server|D:\ShaiyaServer\PSM_Client\Bin\ps_session.exe
ps_userLog|Shaiya User Log Server|Shaiya User Log Server|D:\ShaiyaServer\PSM_Client\Bin\ps_userLog.exe
ps_login|Shaiya Login Server|Shaiya Login Server|D:\ShaiyaServer\PSM_Client\Bin\ps_login.exe
ps_game|Shaiya Game Server|Shaiya Game Server|D:\ShaiyaServer\PSM_Client\Bin\ps_game.exe
ps_dbAgent|Shaiya DBAgent Server|Shaiya DBAgent Server|D:\ShaiyaServer\PSM_Client\Bin\ps_dbAgent.exe
ps_gameLog|Shaiya Game Log Server|Shaiya Game Log Server|D:\ShaiyaServer\PSM_Client\Bin\ps_gameLog.exe

PSM_Update

Code:
Agent1|.|ServerAgent\Main
Agent2|.|ServerAgent\Common
Agent3|Bin|ServerAgent\Common
Session1|Bin|ServerPatch\ServerMain\PS_Session
Session2|Bin\Config|ServerConfig\ServerMain\PS_Session
UserLog1|Bin|ServerPatch\ServerMain\PS_UserLog
UserLog2|Bin\Config|ServerConfig\ServerMain\PS_UserLog
Login1|Bin|ServerPatch\ServerMain\PS_Login
Login2|Bin\Config|ServerConfig\ServerMain\PS_Login01
Game1|Bin|ServerPatch\GameMain\PS_Game
Game2|Bin\Config|ServerConfig\Game01\PS_Game
DBAgent1|Bin|ServerPatch\GameMain\PS_DBAgent
DBAgent2|Bin\Config|ServerConfig\Game01\PS_DBAgent
GameLog1|Bin|ServerPatch\GameMain\PS_GameLog
GameLog2|Bin\Config|ServerConfig\Game01\PS_GameLog
I hope this is sufficient information.

Thank you again.
11/10/2010 02:10 Andpaur#4
1.<sv_gamename> = Your game server name
<sv_publicip> = whatismyip.com

2. Please check the port number is open (40901 and other)
3. Please write here PSM_Client\Bin\Config\*.ini files
11/10/2010 03:05 godofsnacks#5
1. <sv_gamename> and <sv_publicip> is set to what I want it to be.
2. They are all open.
3. Here they are:

ps_dbAgent.ini:

Code:
[SERVER]
ServerName=DBAgent01
ServerPort=
MaxConnection=
[DB]
GameData=127.0.0.1, PS_GameData, frankie1, F54231A7302AD273228BC85D432EEB1454E677798929855337E34A18B129A955EB65B3CEDE13BCC8B320D96D63D7E5291967A5C732F694B22C65593D619E5A6E29FC67D58CA1D75463DF8B6587EC640E3F5FF2BF615372A4984F4F6F4E78E83336B5DC5C2D13053CCEA3406C05B1B62F011A34F7CBB8A2A92231FF6349728A50
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50000
ps_game.ini:

Code:
[SERVER]
ServerName=Game01
ServerPort=
MaxConnection=3000
[CONNECTION]
Session=127.0.0.1
UserLog=127.0.0.1
DBAgent=127.0.0.1
GameLog=127.0.0.1
[DB]
GameDef=127.0.0.1, PS_GameDefs, frankie1, E72E60931EF7E4D9A378274447E762A115DFB45EB13619E2C0994FCE22BAF62862A1497FA2154FDEE5E17E086976D921C63B7F4434288951B0B3F84C3E0F5EEC34BC76E47C88AB9824DA67298A797FFC1FCF8C0627D438B2652E424B55D29FA1F763FDD5415836698C85325BF4347FBB6173B5EAF8F39869672CD806D81EBE29
GameData=127.0.0.1, PS_GameData, frankie1, 1AD9E5CD0167186B585914A9E0E739867A4C50FD41E0BB4EE726ED164E7144287B1D08031FC5D33608C566791C9AE643D221B5870AB4D02A01ED92B7C8E79E2DE951B915B7C462F0CDB660B6F25141AC87C4356DACBB19B6094E124877CB3D3FBBD24AD4BE2A4682C4FD22ACA544FBDDE5A18227456C302AE3D5C8C11CE9B2B6
[GAMEINFO]
GameName=Gaia
GamePublicIP=127.0.0.1
GameVersion=0x09072200
GameLogDBID=1
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50000
ps_gameLog.ini:

Code:
[SERVER]
ServerName=GameLog01
ServerPort=
MaxConnection=
[DB]
DBCount=1
DBGame01=127.0.0.1, PS_GameLog, frankie1, 8F19A14B91DD3DDA74CB1DF10C98A4D5C81D622DA26A3A23F6EB2657E064C0342A4E00F9EC5598DBDFBAC57995E87FABA970F6166F67FD3BBBBC6013BFB3F90869D0E2D7DFAFA0AF037AADC9BC0B6BE50C8F1DD07B60F1D2564E2863669561D3BABE4871512611F032D5658B0CC60AB126E7DF44D34E1CC9C20B0D713F835BBA
DBChat01=127.0.0.1, PS_ChatLog, frankie1, 8D2560547EED89B66E67B5F7C93A6CE9F78106D5C46E4F8E3EC87953E578C5F3B072A6DE9A6D6E1C0EA4089A4EC882E27F96A438D2B8FC3F01A03C2C7C76E9092B1EBB9BEFACF5198AAF1C172BA446EDF87BE4B30661C4D2DF6CBCDCD7357015A7795EDD4A2315D20F6369C650F3117BEDAC2F8263E9635715FACF1B21E28142
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50001
ps_login.ini:

Code:
[SERVER]
ServerName=Login01
ServerPort=
MaxConnection=5000
[CONNECTION]
Session=127.0.0.1
UserLog=127.0.0.1
[DB]
UserData=127.0.0.1, PS_UserData, frankie1, 7773B0DD7C3DF0A72529BDCF61B21B1BC4EA5E0EF656CDD76A4A9291BAF01D9334296ACB68572B3A0F9653EACEE3ADF625BD7731F07E717E4CA58736E019F964C55D7931D264518525594ADF84A8A6F1ACDFAB0C51D0DD34A55D108AE3F0419230F15DCFB35A60888B1C7FBCD36D4DC6DEF3AD2594590300C008C9D26AE2C37A
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50000
ps_session.ini:

Code:
[SERVER]
ServerName=Session
ServerPort=
MaxConnection=
[CONNECTION]
UserLog=127.0.0.1
[GAMESERVERS]
GameServerCount=1
Game01=Gaia
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50000
ps_userlog.ini:

Code:
[SERVER]
ServerName=UserLog
ServerPort=
MaxConnection=
[DB]
UserLog=127.0.0.1, PS_UserData, frankie1, 20ED3096F4B426094BB97772626E96C661CC9683E2ECC0AEFAAEF217525162D202248C65C0E808C73C5DD104118AC0ACC145A1C1B09FA3B30FED86A26B47B7394B6F9C8FA78FB287492EC4ADA74B3A6E5EA609A3890243B70598D7E5540DDE9C8180DF12861A9F2305EA514E1CD7B38AC489C1F7012BE66191AF554FA96EDC09
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50001

Thanks again for helping me :)
11/10/2010 08:04 Andpaur#6
1. Edit to the PSMServer_Config.ini file
1a. <sv_gamename> = Gaia
1b. <sv_publicip> = whatismyip.com (eg. 84.125.156.55)

2. Edit to the Ps_Game.ini file GamePublicIP = whatismyip.com (eg. 84.125.156.55)

3. Your sql user name is frankiel? (check pls)

4. Shutdown all service and clear all log files

5. Start all service and if you problem persists pls write here in log files again

6. Sorry for my bad english :)
12/20/2010 23:42 smokevl#7
same problem and on me and not work