-
SQL is not connected with the game (HELP) Wrong password!!
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??
-
Re: SQL is not connected with the game (HELP) Wrong password!!
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.
-
Re: SQL is not connected with the game (HELP) Wrong password!!
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...
-
Re: SQL is not connected with the game (HELP) Wrong password!!
u make in your life 1 server with mssql ?
-
SQL is not connected with the game (HELP) Wrong password!!
NAPHY-PC/NAPHY is your MSSQL server. Localhost is your MySQL server on Linux. To open MySQL on Linux:
>> Applications > Programming > MySQL Workbench
-
Re: SQL is not connected with the game (HELP) Wrong password!!
Quote:
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..
-
1 Attachment(s)
Re: SQL is not connected with the game (HELP) Wrong password!!
-
2 Attachment(s)
Re: SQL is not connected with the game (HELP) Wrong password!!
Quote:
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..
Attachment 123887Attachment 123888
-
Re: SQL is not connected with the game (HELP) Wrong password!!
Quote:
Originally Posted by
naphy
Is this normal???
passowrd : reverse
-
Re: SQL is not connected with the game (HELP) Wrong password!!
Quote:
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..
Attachment 123887Attachment 123888
I might have the same problem as you do, do you get a 'timeout error' when trying to login to BOI?
-
3 Attachment(s)
Re: SQL is not connected with the game (HELP) Wrong password!!
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.
Attachment 123900Attachment 123901
But If I open the Account Manager This the message.. That means someone is connected to PassportBOI
Attachment 123902
-
3 Attachment(s)
Re: SQL is not connected with the game (HELP) Wrong password!!
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:
Attachment 123908
However, i still haven't fixed -Time out error in doing so.
Attachment 123909
-
Re: SQL is not connected with the game (HELP) Wrong password!!
Quote:
Originally Posted by
JordieLOL
u using pre-gof client ? :)) nerver working :)
-
Re: SQL is not connected with the game (HELP) Wrong password!!
Quote:
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
-
Re: SQL is not connected with the game (HELP) Wrong password!!
Quote:
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
-
Re: SQL is not connected with the game (HELP) Wrong password!!
Quote:
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 :'(
-
Re: SQL is not connected with the game (HELP) Wrong password!!
-
Re: SQL is not connected with the game (HELP) Wrong password!!
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
-
1 Attachment(s)
Re: SQL is not connected with the game (HELP) Wrong password!!
Attachment 123914
So why does mine appear like this?
BTW- Ill try your ini's xtreme, thanks for your help
-
Re: SQL is not connected with the game (HELP) Wrong password!!
Quote:
Originally Posted by
Dataim
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..
-
SQL is not connected with the game (HELP) Wrong password!!
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.
-
Re: SQL is not connected with the game (HELP) Wrong password!!
-
Re: SQL is not connected with the game (HELP) Wrong password!!
-
1 Attachment(s)
Re: SQL is not connected with the game (HELP) Wrong password!!
Attachment 124128
All right ? 192.168.1.2 is my WINDOWS IP. and sa pass is 123456
-
SQL is not connected with the game (HELP) Wrong password!!
Only the SQL server part is the windows IP. You need to set all the local_ip ones to your Linux IP, not windows.
-
1 Attachment(s)
Re: SQL is not connected with the game (HELP) Wrong password!!
-
Re: SQL is not connected with the game (HELP) Wrong password!!
Quote:
Originally Posted by
palamon123
im not sure but your linux ip is not 192.168.56.1
-
Re: SQL is not connected with the game (HELP) Wrong password!!
Quote:
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 @@
-
Re: SQL is not connected with the game (HELP) Wrong password!!
Quote:
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 :)
-
Re: SQL is not connected with the game (HELP) Wrong password!!
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: For example you are using linux. Your IP addresses are: Windows: 192.168.1.1 Linux: 192.168.1.2. Your filter is: Then start ONLY authd and check out the connections. U will see if linux is connected to mssql!
