SQL is not connected with the game (HELP) Wrong password!!

**JordieLOL** · 17-02-13

Originally Posted by naphy

Jordie Maybe wer need to wait for the Video Tutorial for GOF client.. and for your problem. I really forget how I fix that But I am pretty sure it's in GateServer or GameServer IP Double check it from guide if you IP is correct.. Did you manage to get to pass the incorrect password?? What password did you try to login with that monster username??? and them got an timeout error.

This is the GateServer Settings.

[Default]
ManagerIP=192.168.1.15 <<<<----- WINDOWS IP
ManagerPort=21020
AuAgentIP=192.168.1.15 <<<<----- WINDOWS IP
AuAgentPort=29250
OnlineMax=5000

//±¾µØ¼àÌý¶Ë¿ÚÎª±ÜÃâÓë·þÎñ¶Ë¿Ú³åÍ»£¬Ê¹ÓÃ30000ÒÔÉÏ¶Ë¿Ú
GatePort=30002

[LogServer]
Port = 9008
ServerIP = 192.168.1.50 <<<<----- LINUX IP

Mine is the same as that but with my IP's :'(

**Dataim** · 17-02-13

it should look like this:

**xtreme17** · 17-02-13

dam so many .... this is all config files for win :
192.168.1.2 = win ip
192.168.1.3 = linux ip

Auagent.conf

Code:

[AuAgentServer]
zoneid		=	904
aid			=	9
type			=	tcp		
port			=	29250
address		=	192.168.1.2
so_sndbuf		=	131072
so_rcvbuf		=	131072
ibuffermax		=	409600
obuffermax		=	819200
tcp_nodelay		=	1
listen_backlog		=	10
mtrace			=	/tmp/m_trace.link

[GameDBClient]
type			=	tcp		
port			=	29251
address		=	192.168.1.3
so_sndbuf		=	131072
so_rcvbuf		=	131072
ibuffermax		=	409600
obuffermax		=	819200
tcp_nodelay		=	1
listen_backlog	=	10
mtrace		=	/tmp/m_trace.link
cashfile		=	C:\SERVER\cash_backup.data

[GAuthClient]
type			=	tcp
port			=	29200
address		=	192.168.1.3
so_sndbuf		=	131072
so_rcvbuf		=	131072
ibuffermax		=	819200
obuffermax		=	819200
so_broadcast	=	1
tcp_nodelay		=	1
osec = 2
oseckey 		= 	rdppjtaki1MxoHnsnaltiiwfjszs9l
isec = 2
iseckey 		= 	n1hxpxztozyxnsvk6RaycpmrCnrdds
shared_key        =     4khdwAAcjrg0eqfzazqcemdpgulnje

;if use certverify between au,1:use,0:not use,default use
issupport_cert		= 0
[ThreadPool]
config			=	(1,1)(2,4)(3,2)
max_queuesize		=	1048576
prior_strict		=	0

[SpeedLimit]
window			=	20
high				=	2

[TimeoutLimit]
;window > 60
window 			= 180
high 				= 200

[CouponLimit]
;GetUserCoupon limit
window			= 300
high				= 2

[CouponExchangeLimit]
;CouponExchange limit
window			= 120
high				= 2

DetectCheatServer.ini

Code:

[DetectCheatServer]
ServerIP = 192.168.1.2
ServerPort = 55000

[LogServer]
ServerIP = 192.168.1.3
Port = 9008

Server.ini

Code:

[Default]
Version=0
ManagerServerIP=192.168.1.2
ManagerServerPort=20021
ListenGatePort=40003
LineID=2
ShowLoginIP=1

[LogServer]
ServerIP = 192.168.1.3
Port = 9008

[SharedMem]
SharedMemCount=1
SharedMemName1=Global\ShareMem1
SharedMemSize1=100

Managerserver.ini

Code:

[Default]
LocalIP = 127.0.0.1
OnlineMax=2000
DefWallowOnlineTime = 10800
DefWallowOfflineTime = 18000
LootTimes=99999999.0
ExpTimes=99999999.0

[GameServer]
ServerIP = 192.168.1.2
Port = 20021

[DBServer]
ServerIP = 192.168.1.3
#ListenPort = 21022	TW
#ListenPort = 21032	VN
ListenPort = 21042	US


[GateServer]
ServerIP = 192.168.1.2
Port = 21020

[LocalDBThread]
#DBListenPort = 21024	TW
#DBListenPort = 21034	VN
ServerIP = 192.168.1.3
DBListenPort = 21044	US
LocalListenPort = 21023

[NameServer]
ServerIP = 192.168.1.3
ServerPort = 50050
#ServerPort = 10080

[LogServer]
ServerIP = 192.168.1.3
Port = 9008


[DetectCheatServer]
ServerIP = 192.168.1.2
ServerPort = 55000

[GACD]
ServerIP = 192.168.1.3
ServerPort = 29705

[CardServer]
ServerIP = 192.168.1.3
ServerPort = 10080

Gateserver.ini

Code:

[Default]
ManagerIP=192.168.1.2
ManagerPort=21020
AuAgentIP=192.168.1.2
AuAgentPort=29250
OnlineMax=5000

//±¾µØ¼àÌý¶Ë¿ÚÎª±ÜÃâÓë·þÎñ¶Ë¿Ú³åÍ»£¬Ê¹ÓÃ30000ÒÔÉÏ¶Ë¿Ú
GatePort=30002

[LogServer]
ServerIP = 192.168.1.3
Port = 9008

Localserver.ini

Code:

[Network]
DBServerIP=192.168.1.3
DBServerPort=21021
ManagerIP=192.168.1.2
ManagerPort=21023

[LogServer]
ServerIP = 192.168.1.3
Port = 9008

//ÈÕÖ¾µÈ¼¶
LogLevel=4


//¸÷µÈ¼¶Êä³öÀàÐÍ
Wrong=3
Warning=3
Normal=3
Debug=3




//ÈËÊýÏÞÖÆ
BlockMax=3000

//±£´æ¼ä¸ô
SaveInterval=1000

//GSÏìÓ¦Ê±¼ä
ResponseInterval=1000

//¹²ÏíÄÚ´æ¿éÊýÁ¿
//¹²ÏíÄÚ´æ
[SharedMem]

SharedMemCount=1
SharedMemName1=Global\ShareMem1
SharedMemSize1=100

Sharemembproc.ini

Code:

[Main]
SharedMemName1=Global\ShareMem1
SharedMemSize1=100

**JordieLOL** · 17-02-13

So why does mine appear like this?

BTW- Ill try your ini's xtreme, thanks for your help

**naphy** · 18-02-13

Originally Posted by Dataim

it should look like this:

Damn It I knew it that the PassportBOI is not connected with my game. Any Idea how can it connect?? where should I look? I think the only possibility is in TABLE.XML in LINUX.. But I already mess up everything there and still got the same.. I will try to change all my Ini file to the above INI and I will inform here what happen..

**xirod1** · 18-02-13

Naphy, go to:
>> Start > Microsoft SQL Server 2008 R2 > Configuration Tools > SQL Server Configuration Manager

Click SQL Server Network Configuration > Protocols for (your MSSQL server name)

Right-click and enable TCP/IP. Then right click TCP/IP and click Properties. Go to the IP Addresses tab. Make sure TCP Dynamic Ports is empty on all of them. Set TCP Port to 1433 for all entries. At the bottom, make TCP Dynamic Ports empty and Port 1433 for entry "IP All". You need to have one entry with your Linux SQL Server IP and one with your Windows SQL Server IP. Also, make sure you set Enabled to Yes on all of them. Restart your Windows SQL Server in the Configuration Manager and try your BOI server again.

**gigok** · 20-02-13

TCP Enable All

**xtreme17** · 20-02-13

THIS IS CONFIG FOR MSSQL :) GL

**palamon123** · 20-02-13

All right ? 192.168.1.2 is my WINDOWS IP. and sa pass is 123456

**xirod1** · 20-02-13

Only the SQL server part is the windows IP. You need to set all the local_ip ones to your Linux IP, not windows.

**palamon123** · 21-02-13

Help me pls @@

**xtreme17** · 21-02-13

Originally Posted by palamon123

Help me pls @@

im not sure but your linux ip is not 192.168.56.1

**palamon123** · 21-02-13

Originally Posted by xtreme17

im not sure but your linux ip is not 192.168.56.1

Yes, my ip linux is 192.168.1.3 i put all in my config @@

**xtreme17** · 21-02-13

Originally Posted by palamon123

Yes, my ip linux is 192.168.1.3 i put all in my config @@

use old auth from linux and old Auagent from win :)

**axelcro** · 03-03-13

Guys, install Wireshark on Linux or Windows (what u prefer), then select the network card what u are using for the INTERNET or BOI CONNECTION and add a simple filter:

host IP ADDRESS

For example you are using linux. Your IP addresses are: Windows: 192.168.1.1 Linux: 192.168.1.2. Your filter is:

host 192.168.1.1

Then start ONLY authd and check out the connections. U will see if linux is connected to mssql!

SQL is not connected with the game (HELP) Wrong password!!

Thread Tools

Re: SQL is not connected with the game (HELP) Wrong password!!

Re: SQL is not connected with the game (HELP) Wrong password!!

Re: SQL is not connected with the game (HELP) Wrong password!!

Re: SQL is not connected with the game (HELP) Wrong password!!

Re: SQL is not connected with the game (HELP) Wrong password!!