error to connect sql

**reymartbello** · 13-10-11

Service Provider:CHINA
INFO:nProtect GameGuard server DLL load failed
CreateIoCompletionPort OK
INFO:SQL_ATTR_CONNECTION_POOLING OK
INFO:SQLAllocHandle OK
User DB Open OK
Game DB Open OK
Log DB Open OK
Shop DB Open OK
Database Thread Create OK
Log Database Thread Create OK
User Database Thread Create OK
--------------- System Information -------------------
Unknown OS
Pentium III processor 2699 Mhz
2 System Processor Detected
------------------------------------------------------
2 Worker Thread
1 st Worker Thread Create OK
2 st Worker Thread Create OK
[Gaea Server] Start
PK MODE : 1
[Gaea Server] Start Succeeded
[Gaea Server] ---------------
Server Update Thread Create OK
WSASocket OK
Bind OK
127.0.0.1:5502
Server Accept Thread Create OK
(Client ID:99) (127.0.0.1:5503)
============================
Session Server Connection OK
============================
SessionSndSvrInfo 127.0.0.1 CH:2
(Client ID:0) (127.0.0.1:5502)
INFO:Field Server CH(0) FIELD(0) ID(0) Connection OK
(Client ID:10) (127.0.0.1:5502)
INFO:Field Server CH(1) FIELD(0) ID(10) Connection OK
NET_MSG_BASE 1019
=======================================================
Server Start OK
=======================================================
CNetUser::Client invalid Msg!! Channel -1, IP 127.0.0.1, UserNum -1, ID
CNetUser::Client invalid Msg!! Channel -1, IP 127.0.0.1, UserNum -1, ID
CNetUser::Client invalid Msg!! Channel -1, IP 127.0.0.1, UserNum -1, ID
CNetUser::Client invalid Msg!! Channel -1, IP 127.0.0.1, UserNum -1, ID
CNetUser::Client invalid Msg!! Channel -1, IP 127.0.0.1, UserNum -1, ID
CNetUser::Client invalid Msg!! Channel -1, IP 127.0.0.1, UserNum -1, ID
CNetUser::Client invalid Msg!! Channel -1, IP 127.0.0.1, UserNum -1, ID
CNetUser::Client invalid Msg!! Channel -1, IP 127.0.0.1, UserNum -1, ID
CNetUser::Client invalid Msg!! Channel -1, IP 127.0.0.1, UserNum -1, ID
INFO:Field Server Connection was closed. try to reconect 0
INFO:Field Server Connection was closed. try to reconect 10
ERROR:DecreaseChannelUser Channel Number Wrong(-1)
ERROR:CNetUser::CloseClient client already closed 0
ERROR:DecreaseChannelUser Channel Number Wrong(-1)
ERROR:CNetUser::CloseClient client already closed 1
(Client ID:102) (127.0.0.1:8013)
ERROR:SQLConnect Failed
CAgentUserCheck result -1
CAgentUserCheck result 0
CAgentUserCheck result 0
ERROR:CNetUser::CloseClient client already closed 2

**MentaL**

**tearhear18** · 13-10-11

@TS take a look

INFO:SQL_ATTR_CONNECTION_POOLING OK
INFO:SQLAllocHandle OK
User DB Open OK
Game DB Open OK
Log DB Open OK
Shop DB Open OK
Database Thread Create OK
Log Database Thread Create OK
User Database Thread Create OK

no problem with your SQL,...

**dunhill2901** · 13-10-11

Add me in YM!
Marklopez24299@yahoo.com
I`ll Help U To Ur problem And If u Want I`ll Make U A Server!

**ytters** · 13-10-11

analyze first ur problem ...
as what tearhear said ... ur SQl is working fine and nothing seems to be the problem ....

ur problem is about the AgentServer ... ur configuration of FieldServer port is same ....
i mean ur FieldServer0 and FieldServer1 ports are the same .. change it with ur choice to make it work...

**reymartbello** · 13-10-11

Why did not operate to account

my sql is working but why?

**ytters** · 13-10-11

in screenshot #2 ..... Userpass and userpass2 is MD5 ...
convert it first then place it in corresponding column ...

---------- Post added at 02:10 PM ---------- Previous post was at 02:09 PM ----------

if u have ranCP .. better register using it ...
if wanted to use SQL .. better use search button for the steps in registering in SQL ...

**reymartbello** · 13-10-11

im not get you
i cant see in your pc the screenshot

---------- Post added at 07:16 AM ---------- Previous post was at 07:10 AM ----------

my first request in you plzzzz

**ytters** · 13-10-11

nah.... in ur screenshot #2 .. ur userpass and userpass2 must be MD5 ...
it shows the u edit ur userpass and userpass2 by ur own....

next is .. edit ports of ur fieldserver0 and fieldserver1 see to it that both have different or unique ports....
and edit it also in ur AgentServer..

**reymartbello** · 13-10-11

like thisss
reymart19-86B8C955AEDC0576AA0
reymart19-86B8C955AEDC0576AA0
5402557-5402557
5402557123-24596B601A89F101479

---------- Post added at 07:27 AM ---------- Previous post was at 07:24 AM ----------

im hard to undestand english

**nomairyali** · 13-10-11

Originally Posted by reymartbello

like thisss
reymart19-86B8C955AEDC0576AA0
reymart19-86B8C955AEDC0576AA0
5402557-5402557
5402557123-24596B601A89F101479

MD5 is something like that

**ytters** · 13-10-11

MD5 looks like this ... >>> 00B34AF495F396G

and it should be in ur userpass and userpass2

**reymartbello** · 13-10-11

AGENT
//

///////////////////////////////////////////////////////////////////

/////////
// Agent server Reconfigured By IaNz
//
//

///////////////////////////////////////////////////////////////////

/////////
// server setting value
server_version 1
patch_version 1
server_name SpiritAgent
server_max_client 400
server_max_channel_client 200
server_channel_number 2
server_ip 127.0.0.1 //IP
server_service_port 5502
server_control_port 6502
//
service_provider 3
heartbeat 1
max_thread 5
//
// server type [type]
// [type]
// 1 : login server
// 2 : session server
// 3 : field server
// 4 : agent server
server_type 4
server_group 0 // game server group
server_number 0 // game server number
//
//

///////////////////////////////////////////////////////////////////

/////////
// Session server
// session_server [server_name] [ip] [port] [userid] [userpass]
session_server SpiritSession 127.0.0.1 5503 sa 1234
//
//

///////////////////////////////////////////////////////////////////

/////////
// Channel Setting
// channel [number] [pk on/off]
// 1 on
// 0 off
channel 0 1
channel 1 0
//channel 2 0
//channel 3 0
//channel 4 0
//
//

///////////////////////////////////////////////////////////////////

/////////
// Field server list
// field_server [channel] [field num] [server_name] [ip] [port]
field_server 0 0 SpiritServer0 127.0.0.1 5513
field_server 1 0 SpiritServer1 127.0.0.1 5516
//field_server 2 0 SpiritField2 127.0.0.1 5119
//field_server 3 0 SpiritField3 127.0.0.1 5119
//field_server 4 0 SpiritField4 127.0.0.1 5123
//
//

///////////////////////////////////////////////////////////////////

/////////
// user database setting value
user_odbc_name RanUser
user_odbc_user sa
user_odbc_pass 1234
user_odbc_database RanUser
user_odbc_pool_size 5
user_odbc_response_time 10
//
//

///////////////////////////////////////////////////////////////////

/////////
// game database setting value
game_odbc_name RanGame1
game_odbc_user sa
game_odbc_pass 1234
game_odbc_database RanGame1
game_odbc_pool_size 5
game_odbc_response_time 10
//
//

///////////////////////////////////////////////////////////////////

/////////
// log database setting value
log_odbc_name RanLog
log_odbc_user sa
log_odbc_pass 1234
log_odbc_database RanLog
log_odbc_pool_size 5
log_odbc_response_time 10
//
//

///////////////////////////////////////////////////////////////////

/////////
// Shop database setting value
shop_odbc_name RanShop
shop_odbc_user sa
shop_odbc_pass 1234
shop_odbc_database RanShop
shop_odbc_pool_size 5
shop_odbc_response_time 10
//
//

///////////////////////////////////////////////////////////////////

/////////

FIELD0
// ////////////////////////////////////////////////////////////////////////////
// Field server 1 Reconfigured By IaNz
//
// ////////////////////////////////////////////////////////////////////////////
// server setting value
server_version 1
patch_version 1
server_name SpiritServer0
server_max_client 400
server_ip 127.0.0.1
server_service_port 5513
server_control_port 6502
// ////////////////////////////////////////////////////////////////////////////
// Field Server PK Setting
// pk [on/off]
// 1 on
// 0 off
pk 1
gameguard 1
//
service_provider 3
heartbeat 1
max_thread 5
// server type [type]
// [type]
// 1 : login server
// 2 : session server
// 3 : field server
// 4 : agent server
server_type 3
server_group 0 // game server group
server_number 0 // game server number
server_channel 0 // Channel number
server_field 0 // field number
//
// ////////////////////////////////////////////////////////////////////////////
// Session server
// session_server [server_name] [ip] [port] [userid] [userpass]
session_server SpiritSession 127.0.0.1 5503 sa 1234
//
// ////////////////////////////////////////////////////////////////////////////
// Agent server
// agent_server [server_name] [ip]
agent_server SpiritAgent 127.0.0.1
//
// ////////////////////////////////////////////////////////////////////////////
// user database setting value
user_odbc_name RanUser
user_odbc_user sa
user_odbc_pass 1234
user_odbc_database RanUser
user_odbc_pool_size 5
user_odbc_response_time 10
//
// ////////////////////////////////////////////////////////////////////////////
// game database setting value
game_odbc_name RanGame1
game_odbc_user sa
game_odbc_pass 1234
game_odbc_database RanGame1
game_odbc_pool_size 5
game_odbc_response_time 10
//
// ////////////////////////////////////////////////////////////////////////////
// log database setting value
log_odbc_name RanLog
log_odbc_user sa
log_odbc_pass 1234
log_odbc_database RanLog
log_odbc_pool_size 5
log_odbc_response_time 10
//
// ////////////////////////////////////////////////////////////////////////////
// Shop database setting value
shop_odbc_name RanShop
shop_odbc_user sa
shop_odbc_pass 1234
shop_odbc_database RanShop
shop_odbc_pool_size 5
shop_odbc_response_time 10
//
// ////////////////////////////////////////////////////////////////////////////

FIELD1
// ////////////////////////////////////////////////////////////////////////////
// Field server 1 Reconfigured By IaNz
//
// ////////////////////////////////////////////////////////////////////////////
// server setting value
server_version 1
patch_version 1
server_name SpiritServer1
server_max_client 400
server_ip 127.0.0.1
server_service_port 5516
server_control_port 6505
// ////////////////////////////////////////////////////////////////////////////
// Field Server PK Setting
// pk [on/off]
// 1 on
// 0 off
pk 0
//
service_provider 3
heartbeat 1
max_thread 5
// server type [type]
// [type]
// 1 : login server
// 2 : session server
// 3 : field server
// 4 : agent server
server_type 3
server_group 0 // game server group
server_number 0 // game server number
server_channel 1 // Channel number
server_field 0 // field number
//
// ////////////////////////////////////////////////////////////////////////////
// Session server
// session_server [server_name] [ip] [port] [userid] [userpass]
session_server SpiritSession 127.0.0.1 5503 sa 1234
//
// ////////////////////////////////////////////////////////////////////////////
// Agent server
// agent_server [server_name] [ip]
agent_server SpiritAgent 127.0.0.1
//
// user database setting value
user_odbc_name RanUser
user_odbc_user sa
user_odbc_pass 1234
user_odbc_database RanUser
user_odbc_pool_size 5
user_odbc_response_time 10
//
// ////////////////////////////////////////////////////////////////////////////
// game database setting value
game_odbc_name RanGame1
game_odbc_user sa
game_odbc_pass 1234
game_odbc_database RanGame1
game_odbc_pool_size 5
game_odbc_response_time 10
//
// ////////////////////////////////////////////////////////////////////////////
// log database setting value
log_odbc_name RanLog
log_odbc_user sa
log_odbc_pass 1234
log_odbc_database RanLog
log_odbc_pool_size 5
log_odbc_response_time 10
//
// ////////////////////////////////////////////////////////////////////////////
// Shop database setting value
shop_odbc_name RanShop
shop_odbc_user sa
shop_odbc_pass 1234
shop_odbc_database RanShop
shop_odbc_pool_size 5
shop_odbc_response_time 10
//
// ////////////////////////////////////////////////////////////////////////////

**tearhear18** · 13-10-11

try to eat a banana :D

**ytters** · 13-10-11

is it spoonfeed again @tearhear ??

**reymartbello** · 13-10-11

like this

**ytters** · 13-10-11

test and test until u succeed ...
dont forget to press execute button ..

---------- Post added at 03:52 PM ---------- Previous post was at 03:52 PM ----------

make new username ...... T_T

**reymartbello** · 13-10-11

i made it thank you

**ytters** · 13-10-11

why dont u press LIKE instead of posting it .. :D

by the way,
a reminder only ...

**reymartbello** · 13-10-11

opssss what is this

**ytters** · 13-10-11

obviously .. the user IP is blocked ...
remove it ... then u can now proceed...

**reymartbello** · 13-10-11

from cfg or param or sql

**ytters** · 13-10-11

SQL rather ... or if u have GMC .. then make it possible in GMC. .

**AutoK!LL** · 13-10-11

its Better to make Ran CP ..Like Ytters Said
But Ep6 and ep3 is Same..In SQL database..
in ep6 its not MD5 ..

**reymartbello** · 14-10-11

Im Try But same again
user ip is block

---------- Post added at 11:55 AM ---------- Previous post was at 10:35 AM ----------

WHY MY USER IP IS BLOCKED PLEASE INQUIRED WITH OUR COSTUMER SERVICE

**AutoK!LL** · 20-10-11

try this bro..

try to not open the Agent Sesion Login Field1 and 2

and then Open the game.. If the game is not
internet connection field ..
it means the PARAM is IN THE GAME.EXE in short it Pack by mOlebox
or something.. packer

if that is the problem
try to use Fresh GAME.exe

i hope it helps..

error to connect sql

Thread Tools

Search Thread

error to connect sql

Re: error to connect sql

Re: error to connect sql

Re: error to connect sql

Re: error to connect sql

Re: error to connect sql

Re: error to connect sql

Re: error to connect sql

Re: error to connect sql

Re: error to connect sql

Re: error to connect sql

Re: error to connect sql

Re: error to connect sql

Re: error to connect sql

Re: error to connect sql

Re: error to connect sql

Re: error to connect sql

Re: error to connect sql

Re: error to connect sql

Re: error to connect sql

Re: error to connect sql

Re: error to connect sql

Re: error to connect sql

Re: error to connect sql

Re: error to connect sql

Advertisement