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

**naphy** · 16-02-13

I have issue with wrong password.. Now I know why Because the SQL is not connected with my server.. What I do is Close and the SQL and stop SQL server manager.. And I open my server connect to the game and still get the wrong password.. / Then I open the compatau.exe and connect to game and what a miracle I can connect to the game and play EVEN the SQL is turn off..

what I am asking for is how can I connect my SQL to my server?? I already edit the Table.xml and put the SQL by username: sa and password: to my SQL password.. But still the same..

Help please :D

1 more thing what about the MySql??? I did not use it but I install it what is the purpose for that??

**MentaL**

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

**Dataim** · 16-02-13

First check the 1433 port is open then go to MSSQL > right click on localhost and activity monitor, and check if something is connecting to your passportboi db.

**naphy** · 16-02-13

Where Is that Localhost?? I open SQL and did not see the Localhost. All I see is my SQL. for example: NAPHY-PC\NAPHY that is my SQL server if I open the I see database, Security etc...

**xtreme17** · 16-02-13

u make in your life 1 server with mssql ?

**xirod1** · 16-02-13

NAPHY-PC/NAPHY is your MSSQL server. Localhost is your MySQL server on Linux. To open MySQL on Linux:

>> Applications > Programming > MySQL Workbench

**naphy0** · 17-02-13

Originally Posted by xirod1

NAPHY-PC/NAPHY is your MSSQL server. Localhost is your MySQL server on Linux. To open MySQL on Linux:

>> Applications > Programming > MySQL Workbench

Okay thanks I will check it later when I got home..

**naphy** · 17-02-13

Is this normal???

**naphy** · 17-02-13

Originally Posted by xirod1

NAPHY-PC/NAPHY is your MSSQL server. Localhost is your MySQL server on Linux. To open MySQL on Linux:

>> Applications > Programming > MySQL Workbench

Hi this is my MSSQL and PORT 1433!! I thinks MSSQL is not connected to the server right>>>???? Everything is running and still get wrong password..

**xtreme17** · 17-02-13

Originally Posted by naphy

Is this normal???

passowrd : reverse

**JordieLOL** · 17-02-13

Originally Posted by naphy

Hi this is my MSSQL and PORT 1433!! I thinks MSSQL is not connected to the server right>>>???? Everything is running and still get wrong password..

I might have the same problem as you do, do you get a 'timeout error' when trying to login to BOI?

**naphy** · 17-02-13

Help my MSSQL is not connecting to my Server Everything is running in LINUX and WINDOWS.. But in SQL activity monitor the PassportBOI is not connected..
This the message.. That means no one use the PassportBOI.

But If I open the Account Manager This the message.. That means someone is connected to PassportBOI

**JordieLOL** · 17-02-13

I do believe mine is the same...

--Edit--

After following this (change sa password, and login mode)

I managed to get some form of activity:

However, i still haven't fixed -Time out error in doing so.

**xtreme17** · 17-02-13

Originally Posted by JordieLOL

I do believe mine is the same...

--Edit--

After following this (change sa password, and login mode)

I managed to get some form of activity:

However, i still haven't fixed -Time out error in doing so.

u using pre-gof client ? :)) nerver working :)

**JordieLOL** · 17-02-13

Originally Posted by xtreme17

u using pre-gof client ? :)) nerver working :)

Im using the one from the BOI Files and Guide thread? - this one
If its not the correct one, can you provide us with a new link? would be much appreciated :D

**naphy** · 17-02-13

Originally Posted by JordieLOL

Im using the one from the BOI Files and Guide thread? - this one
If its not the correct one, can you provide us with a new link? would be much appreciated :D

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

**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.

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

Thread Tools

Search Thread