|
You last visited: Today at 16:55
Advertisement
Problem wih DB connection
Discussion on Problem wih DB connection within the Shaiya PServer Development forum part of the Shaiya Private Server category.
11/06/2015, 19:24
|
#16
|
elite*gold: 0 
Join Date: May 2012
Posts: 394
Received Thanks: 392
|
As snick says, still not entirely sure what you are asking. Thought you already managed to get the server on-line with a virtual machine, just do the same for the VPS, but with their IP.
Screen, or more detail will help us 
|
|
|
|
11/08/2015, 09:05
|
#17
|
elite*gold: 0
Join Date: Apr 2012
Posts: 46
Received Thanks: 2
|
Sql config:
session:
dbagent:
login:
gamelog:
userlog:
game:
gamewar:
|
|
|
|
|
11/08/2015, 09:26
|
#18
|
elite*gold: 0
Join Date: May 2012
Posts: 394
Received Thanks: 392
|
What server files are you using? Some of your config files look completely different to mine, or any i've seen.
Also, you can uninstall the GameWar service from SPC. It's not working/needed
|
|
|
|
|
11/08/2015, 09:32
|
#19
|
elite*gold: 0
Join Date: Apr 2012
Posts: 46
Received Thanks: 2
|
Quote:
Originally Posted by Truth1010
What server files are you using? Some of your config files look completely different to mine, or any i've seen.
Also, you can uninstall the GameWar service from SPC. It's not working/needed
|
I'm using shaiya omega files (ep 4.5)
|
|
|
|
|
11/08/2015, 18:35
|
#20
|
elite*gold: 0
Join Date: Apr 2015
Posts: 424
Received Thanks: 113
|
Shaiya login created ? ^.^
|
|
|
|
|
11/08/2015, 18:43
|
#21
|
elite*gold: 0
Join Date: Apr 2012
Posts: 46
Received Thanks: 2
|
Quote:
Originally Posted by SkuulCandy
Shaiya login created ? ^.^
|
Yes, created and configured but nothing
|
|
|
|
|
11/08/2015, 20:00
|
#22
|
elite*gold: 0
Join Date: May 2012
Posts: 394
Received Thanks: 392
|
Best to try run the server and post here each log file for us to see the results.
If they match the first you posted, then the server files aren't connecting to your DB properly.
|
|
|
|
|
11/08/2015, 20:57
|
#23
|
elite*gold: 260
Join Date: Sep 2011
Posts: 487
Received Thanks: 360
|
Change all IP adreses in sql to 127.0.0.1 and check SQL Server Service. You should have Local Service
|
|
|
|
|
11/09/2015, 06:30
|
#24
|
elite*gold: 0
Join Date: Apr 2012
Posts: 46
Received Thanks: 2
|
Quote:
Originally Posted by Truth1010
Best to try run the server and post here each log file for us to see the results.
If they match the first you posted, then the server files aren't connecting to your DB properly.
|
PS_DBAGENT__system
2015-11-09 06:16:27 PS_DBAGENT__system log start (DBAgent01)
2015-11-09 06:16:44 DB gamedata connect error
2015-11-09 06:16:44 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()
2015-11-09 06:16:44 DBKillCountSave db alloc failed
2015-11-09 06:16:44 SAVE kill count ERROR
2015-11-09 06:16:44 CKeepObeliskMgr:  BSave db alloc failed
2015-11-09 06:16:44 SAVE g_KeepObeliskMgr ERROR
2015-11-09 06:16:44 GuildMgrSave: BSave db alloc failed
2015-11-09 06:16:44 SAVE g_GuildMgrSave ERROR
2015-11-09 06:16:44 PS_DBAGENT__system log end (DBAgent01)
2015-11-09 06:16:44 3 1 SService::ServiceCtrlDispatcher(): service shutdown
PS_GAME__system
2015-11-09 06:16:30 PS_GAME__system log start (Game01) [KR]
2015-11-09 06:16:30 Loaded Behavior In Factory : data/ai/sorp1
2015-11-09 06:16:30 Loaded Behavior In Factory : data/ai/croco1
2015-11-09 06:16:30 Loaded Behavior In Factory : data/ai/croco2
2015-11-09 06:16:30 Loaded Behavior In Factory : data/ai/Troll1
2015-11-09 06:16:30 Loaded Behavior In Factory : data/ai/Spink1
2015-11-09 06:16:30 Loaded Behavior In Factory : data/ai/GoldenPig
2015-11-09 06:16:30 Loaded Behavior In Factory : data/ai/Sorp3
2015-11-09 06:16:30 Loaded Behavior In Factory : data/ai/SorpNamed1
2015-11-09 06:16:30 Loaded Behavior In Factory : data/ai/SorpNamed2
2015-11-09 06:16:30 Loaded Behavior In Factory : data/ai/Sorp2
2015-11-09 06:16:30 Loaded Behavior In Factory : data/ai/CrocoNamed1
2015-11-09 06:16:30 Loaded Behavior In Factory : data/ai/CrocoNamed2
2015-11-09 06:16:30 Loaded Behavior In Factory : data/ai/CrocoNamed3
2015-11-09 06:16:30 Loaded Behavior In Factory : data/ai/OrcNamed1
2015-11-09 06:16:30 Loaded Behavior In Factory : data/ai/OrcNamed2
2015-11-09 06:16:30 Loaded Behavior In Factory : data/ai/OrcNamed3
2015-11-09 06:16:30 Loaded Behavior In Factory : data/ai/TrollNamed1
2015-11-09 06:16:30 Loaded Behavior In Factory : data/ai/HellTouthNamed1
2015-11-09 06:16:30 Loaded Behavior In Factory : data/ai/Deinos
2015-11-09 06:16:30 Loaded Behavior In Factory : data/ai/Parridalis
2015-11-09 06:16:30 Loaded Behavior In Factory : data/ai/Alcarian
2015-11-09 06:16:30 Loaded Behavior In Factory : data/ai/ZinAlcaria
2015-11-09 06:16:30 Loaded Behavior In Factory : data/ai/Belizabeth
2015-11-09 06:16:30 Loaded Behavior In Factory : data/ai/Kirhiross
2015-11-09 06:16:30 Loaded Behavior In Factory : data/ai/CrypticOne
2015-11-09 06:16:30 Loaded Behavior In Factory : data/ai/Haruhion
2015-11-09 06:16:30 Loaded Behavior In Factory : data/ai/Freezing
2015-11-09 06:16:46 DB gamedef connect error
2015-11-09 06:16:46 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()
2015-11-09 06:16:46 Call save all waiting...
2015-11-09 06:16:46 Call save all failed dbagent disconnected(user count = 0)...
2015-11-09 06:16:46 server shutdown Connection INFO : T=000:00:00:000, NumC=0,CMin=0,CMax=0,CAvg=0.00, CAva=0,CReq=0,CCnt=0,DCCnt=0, CTimeT=000:00:00:000,CTimeAvg=000:00:00:000, RBT=0,RBS=0,RBSC=0,SBT=0,SBS=0,SBSC=0
2015-11-09 06:16:46 Save Shaiya.SData 0
2015-11-09 06:16:46 PS_GAME__system log end (Game01)
2015-11-09 06:16:46 3 1 SService::ServiceCtrlDispatcher(): service shutdown
PS_GAMELOG__system
2015-11-09 06:16:27 PS_GAMELOG__system log start (GameLog01)
2015-11-09 06:16:44 DB gamelog connect error
2015-11-09 06:16:44 init db error
2015-11-09 06:16:44 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()
2015-11-09 06:16:44 PS_GAMELOG__system log end (GameLog01)
2015-11-09 06:16:44 3 1 SService::ServiceCtrlDispatcher(): service shutdown
PS_LOGIN__system
2015-11-09 06:16:32 PS_LOGIN__system log start (Login01)
2015-11-09 06:16:48 DB userdata connect error, id=Shaiya, pass=Shaiya123
2015-11-09 06:16:48 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()
2015-11-09 06:16:48 PS_LOGIN__system log end (Login01)
2015-11-09 06:16:48 3 1 SService::ServiceCtrlDispatcher(): service shutdown
PS_SESSION__system
2015-11-09 06:16:24 PS_SESSION__system log start (Session)
2015-11-09 06:16:25 userlog connect failed
2015-11-09 06:16:25 initserver() failed
2015-11-09 06:16:25 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()
2015-11-09 06:16:25 PS_SESSION__system log end (Session)
2015-11-09 06:16:25 3 1 SService::ServiceCtrlDispatcher(): service shutdown
PS_USERLOG__system
2015-11-09 06:16:22 PS_USERLOG__system log start (UserLog)
2015-11-09 06:16:39 DB userlog connect error, Server=127.0.0.1, DBName=PS_UserData, User=Shaiya, Pass=Shaiya123
2015-11-09 06:16:39 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()
2015-11-09 06:16:39 PS_USERLOG__system log end (UserLog)
2015-11-09 06:16:39 3 1 SService::ServiceCtrlDispatcher(): service shutdown
Same logs
Quote:
Originally Posted by SnickQ
Change all IP adreses in sql to 127.0.0.1 and check SQL Server Service. You should have Local Service
|
Changed all IP to 127.0.0.1, in sql server service i've selected local service but still nothing, same error
|
|
|
|
|
11/09/2015, 09:04
|
#25
|
elite*gold: 0
Join Date: May 2012
Posts: 394
Received Thanks: 392
|
Well, the logs show it's not connecting to your Database with user Shaiya and pass Shaiya123.
Check/confirm you have that account/credentials in your SQL (under security tab)
If all are set to 127.0.0.1 then it's a local connection only as well, so only the host pc will be able to connect (with a local ip game.exe)
From what i said before though, your config ini files are slightly different to what i've usually seen. You have extra lines of data there compared to mine. I used Omega's files, but that was years ago, however i don't remember the configs looking like that.
Add me on Skype sometime and i'll try see where/what your problem is, as you seem to have everything set as it should be to your eyes, probably just missing something small
|
|
|
|
|
11/13/2015, 17:29
|
#26
|
elite*gold: 0
Join Date: Apr 2012
Posts: 46
Received Thanks: 2
|
#UP i've still same problem, i've contacted my host for know if was a their problem but they confirmed me that it wasn't. Any other ideas?
|
|
|
|
|
11/13/2015, 23:09
|
#27
|
elite*gold: 0
Join Date: Jan 2010
Posts: 525
Received Thanks: 805
|
His problem was that the SQL Server was installed with a named instance and the server IP was set to whatismyip.com, i have reinstalled it for him with the default instance, set the right server ip and it started.
|
|
|
|
|
12/04/2016, 15:53
|
#28
|
elite*gold: 0
Join Date: Jan 2010
Posts: 1
Received Thanks: 0
|
Here is the solution
Quote:
Originally Posted by Truth1010
Oh i see now. In that case...
Check TCP port 1433. That needs to be open for remote access to SQL. TCP port 1434 may also be needed, that's for the SQL Browser.
And when connecting remotely, if you are set to have named instances, other than default. Then you must connect like
Code:
12.34.56.78\SQLINSTANCENAME
The logs you originally posted show that the server is failing to connect to the DB though, that's why the confusion. It looks like your asking 1 question, but showing problems linked to another |
I also had same problem, I choose default instance setting while installing MSSQL Server 2008 Express Edition, but instance name was SQLEXPRESS instead of MSSQLSERVER. So I just updated all db ip (in ini files and Server Patch Config to "127.0.0.1\SQLEXPRESS"
|
|
|
|
|
12/05/2016, 21:23
|
#29
|
elite*gold: 0
Join Date: Apr 2012
Posts: 46
Received Thanks: 2
|
Quote:
Originally Posted by dkaswan
I also had same problem, I choose default instance setting while installing MSSQL Server 2008 Express Edition, but instance name was SQLEXPRESS instead of MSSQLSERVER. So I just updated all db ip (in ini files and Server Patch Config to "127.0.0.1\SQLEXPRESS"
|
Solution already given about one year ago thanks for necroposting!
Please close this thread
|
|
|
|
 |
|
Similar Threads
|
Need Help in Connection Problem
09/02/2014 - CO2 Private Server - 2 Replies
Guys got a Problem in my source can connect, this what happens when i use hamachi server i can log in to the game, when i use static ip or vps i cant log in to the game its look frozen no bar loading and sometime it say wrong password or account it look like its not public source it only private where to find and fixed the connection in client source. please need help just this one.
|
[Help Me]Connection problem
07/12/2011 - Rappelz - 1 Replies
Hi,
When I want to connect it gets stuck at the login page how should it be please
http://img684.imageshack.us/img684/7664/rappelzsc reen00000002u.jpg
|
Connection Problem
06/04/2011 - Flyff Private Server - 2 Replies
Hai Elitepvpers,
Ich hab Änderungen an meiner Resource vorgenommen und wollte dann den Server starten. Nun gut das geht alles, nur wenn sich dann User einlogen wollen crashed bei ihnen der Client sobald sie in die World connecten wollen Habe vorsichthalber mal neue .res Dateien patchen lassen und die neuz.exe in den Patcher getan, doch die hilft auch nicht weiter. Habe sogar da ich dachte das meine Änderungen einfach fail sind, ein Resource Backup draufgespielt als noch alles ohne Probleme...
|
Connection problem
06/04/2011 - DarkOrbit - 7 Replies
Hi,
I would need help with DarkOrbit.
If the menu, click Start, begins to run as the star map.
When you click on START in the startup window begins to create a connection that never forms a take I can not play at all. Is not so only in DarkOrbit but in all games like him. :mad:
Help me please. How can it be? :confused:
Thank you. :handsdown:
|
Connection Problem
03/06/2010 - WoW Private Server - 4 Replies
Mein Kumpel und ich haben uns entschlossen einen WoW pserver zu machen was uns auch gelung, er kann von sich zu hause drauf über hamachi connecten , alles top ...
Aber wie kommt er auf meine Navicat Datenbank rauf?
Ich habe eine "Novo" server also ein Server der leicht zu erstellen geht ..
Danke im Vorraus ;)
|
All times are GMT +1. The time now is 16:55.
|
|
