Several Problem Connect Server To DB SQL 1.5

[Iam Juan Carlos]

I have a serious problem starting the server on a vps and installed normally ...

I have the sql 2005 good the problem is this ..



MatchServer the logs here ...

Load XML from memory : strings.xml(0x0052) - SUCCESS
Load XML from memory : cserror.xml(0x0052) - SUCCESS
[08/08/13 21:34:05] DBMS connected

[08/08/13 21:34:05] Command registeration completed

Start GambleItem Init.
End GambleItem Init.

Start shop GItem list log.
GambleItemCount : 0.
End shop GItem list log.


=== Dump GambleItem Info. ===
Gamble item list.

Send shop gamble item list.
Shop gamble item count : 0
=== Completed Dump GambleItem Info. ===

init GameOn success.
success init security.
FILE PATH : C:\Files 1.5\Server\MD5HashValue.txt
MD5 Hash Value => a1 a8 f5 e8 15 e9 72 30 80 5f a6 4e f2 96 77 d7 
================================== Ranking Updater Info ======================================

CLEAN : Release Date : Aug  1 2013 20:42:51
Limpiador de Rankings Iniciado!

CLEAN : Failed to connect to the database.
CLEAN : Clan cleaning - FAILED.
CLEAN : Clans cleaned successfully successfully.
CLEAN : Character ranking updated - FAILED.
CLEAN : Character Ranking Updated successfully.
CLEAN : Clan ranking updated - FAILED.
CLEAN : Clan Ranking Updated successfully.
CLEAN : Survival ranking updated - FAILED.
CLEAN : Survival Ranking Updated successfully.
CLEAN : Process duel tournament ranking - FAILED.
CLEAN : Duel Tournament Ranking Updated successfully.

=============================== All Rankings Updated Successfully ======================================


================================== Server configure info ==================================
[08/08/13 21:34:06] Release Date : Aug  1 2013
[08/08/13 21:34:06] X-Trap Off
[08/08/13 21:34:06] MD5 Check Off
[08/08/13 21:34:06] Loop Log Save Off
[08/08/13 21:34:06] Server Country : KOREA
[08/08/13 21:34:06] Command version : (58)
[08/08/13 21:34:06] Event usable state : (true)
[08/08/13 21:34:06] Load event size : (0)
[08/08/13 21:34:06] FileCRCCheckSum usable state : (false)
[08/08/13 21:34:06] FileCRC size : (0)
[08/08/13 21:34:06] Country Code Filter usalbe state : (false)
[08/08/13 21:34:06] Accept Invalied IP state : (false)
[08/08/13 21:34:06] Keeper IP : (37.59.178.59)
[08/08/13 21:34:06] Monitor IP : (127.0.0.1)
[08/08/13 21:34:06] Ticket use : 0

===========================================================================================

[08/08/13 21:34:06] Match Server Created (Port:6000)

Dueltournament Service Open(2013-8-8 Hour21, Min34) 
Daily Survival Ranking Request [month8 day8 hour21 min34]
MDatabase::Connect - Finished waiting time

MDatabase::Connect - There is no SQL Server or is denied access.
ConnectionOpen (Connect()).

MDatabase::Connect - There is no SQL Server or is denied access.
ConnectionOpen (Connect()).

MDatabase::Connect - Finished waiting time

RealCPNet> SessionCreated=1, SessionDestroyed=0 
RealCPNet> Begin Destroy 
RealCPNet> Destroy Process 1/4 
RealCPNet> Destroy Process 2/4 
RealCPNet> Destroy Process 3/4 
RealCPNet> Destroy Process 4/4 
RealCPNet> Destroy End 
[08/08/13 21:36:03] Match Server Destoryed

because this is so? if everything is properly configured?

also I have a problem with appserv I get Call to undefined function mssql_connect () and this whole dll fix with apache and the extension in php.ini


someone help me please.!

[MentaL]

[MAJ]

Post ur server.ini

[Anju]

You can fix your problem from the logs.

[Iam Juan Carlos]

[DB]
DNS="GunzDB"
USERNAME="sa"
PASSWORD="pw"

[SERVER]
MAXUSER=200
SERVERID=1
SERVERNAME="InterGunz"
SERVERPORT=6000
SERVERUDPPORT=7777
FREELOGINIP="37.59.178.59"
KEEPERIP="37.59.178.59"
DEBUGIP="127.0.0.1"
MONITORIP="127.0.0.1"
MONITORPORT=9000
DEBUG="0"
MODE=quest
COUNTRY="KOR"
LANGUAGE="KOR"
USETICKET="0"
GAMEGUARD="1"
;Survival Mode : 1 for enable, 0 for disable (works only when MODE=test)
SURVIVALENABLE="1"
;Daily request time for survival ranking list(hour:0~23, minute:0~59)
SURVIVALRANKING_DAILY_REQUEST_HOUR="5"
SURVIVALRANKING_DAILY_REQUEST_MINUTE="0"

;DuelTournament Mode : 1 for enable
DUELTOURNAMENT_ENABLE="1"
;DuelTournament MatchMaker run every this time interval (in positive millisec)
DUELTOURNAMENT_MATCHMAKING_INTERVAL = 1000
;DuelTournament MatchMaker match users have TP diffenrence less than this value. (must be positive)
DUELTOURNAMENT_MATCHMAKING_ACCEPTABLE_TP_GAP = 30
;DuelTournament MatchMaker match a user waiting over this time with users have the most nearest TP (ignore TP GAP, value in positive millisec)
DUELTOURNAMENT_MATCHMAKING_WAIT_LIMIT = 15000
;DuelTournament Service Time
;CAUTION! if END_TIME is n then this mode will opened until n:59.
;ex) all day open -> 0, 23
;ex) from 3 to 6 o'clock -> 3, 5
;ex) from 22 to next day 3 o'clock -> 22, 2
DUELTOURNAMENT_SERVICE_START_TIME = 0
DUELTOURNAMENT_SERVICE_END_TIME = 23

SEND_LOGINUSER_TO_DUELTOURNAMENT_CHANNEL ="0"

[BATTLETIMEREWARD]
BATTLETIMEREWARD_REFRESH_INTERVAL="1"

[FILTER]
;0:»ç¿ëÇÏÁö ¾ÊÀ½. 1:»ç¿ë.
USE="0" 
;0:Çã¿ëÇÏÁö ¾ÊÀ½. 1:Çã¿ë.
ACCEPT_INVALID_IP="0"

[ENVIRONMENT]
;0:»ç¿ëÇÏÁö ¾ÊÀ½. 1:»ç¿ë.
USE_HSHIELD="0"
;0:»ç¿ëÇÏÁö ¾ÊÀ½. 1:»ç¿ë.
USE_XTRAP="0"
;0:»ç¿ëÇÏÁö ¾ÊÀ½. 1:»ç¿ë.
USE_EVENT="1"
;0:»ç¿ëÇÏÁö ¾ÊÀ½. 1:»ç¿ë.
USE_FILECRC="0"
;0:»ç¿ëÇÏÁö ¾ÊÀ½. 1:»ç¿ë.
USE_MD5="0"
USE_RESOURCECRC32CACHECKECK="0"
;Flooding°ø°Ý µðºñ¿¡ ¼³Á¤ À¯¹«.
BLOCK_FLOODING="1"
;À§ ¸ñ·Ï¿¡ °ËÃâµÈ À¯Àú¸¦ ºí·¯Å· À¯¹«.
USE_BLOCKHACKING="1" 
USE_ITEM_CONSISTENCY="0"



[KILLTRACKER]
;ºÐ´ÜÀ§
;0:»ç¿ëÇÏÁö ¾ÊÀ½. 1:»ç¿ë.
USE_KILLTRACKER="1"
MAXKILLCOUNT_ON_TRACETIME="30"
KILLCOUNT_TRACETIME="5"

[POWERLEVELING]
USE_POWERLEVELING_DB_BLOCK="1"
POWERLEVELING_DB_BLOCKTIME="1"

[LOOPLOG]
;0:»ç¿ëÇÏÁö ¾ÊÀ½. 1:»ç¿ë.
USE_LOOPLOG="0"
;1ÃÊ(sec)¸¦ 1000 À¸·Î Ç¥±â
MAX_LOOP_TIME_GAP=100

[MAJ]

Change MONITORIP to 0.0.0.0
and Debug IP to ur wan ip.

check ur dbo. serverstatus

[Iam Juan Carlos]

Server status... 1

0

1000

06/08/2013 13:49:03

37.59.178.59

6000

InterGunz

1

4

37.59.178.59

[MAJ]

Well, try with the changes on the server.ini

[Iam Juan Carlos]

You can fix your problem from the logs.

but if there says that but everything is configured well ... and formatting the vps and it just keeps coming ... and when I enter the Configuration Manager I get SQL Server could not establish connexion with the target computer time ...

Well, try with the changes on the server.ini

same problem

[trunksx]

things that you can check:
-Enable TCP/IP Network Protocol Enable TCP/IP Network Protocol for SQL Server
-Using an ODBC 32-bit driver in Window 2003 (64-bit)Using an ODBC 32-bit driver in Window 2003 (64-bit)

[Iam Juan Carlos]

Edit: I do not get the error ... Thanks trunksx