Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[Guide] Fix CreateDB Fail / Server Crash / Port Issues / SQL Connect

Status
Not open for further replies.
Junior Spellweaver
Joined
Jan 2, 2008
Messages
147
Reaction score
21
Part 1 - Solved Fix CreateDB Fail / SQL Connection (Servers/Login ezt Crash)

(You need to be sure you have all the configs/ips fine)
1. Be Sure you give all DB's the DragonNest rights with password qorhvk!@#
2. If you created the account DragonNest, log off from the sql, and log in in (Local) mode and SQL Server auth. With the user DragonNest and password qorhvk!@#
3. If you get any error at login, its because the ports, Put off all Xampp services, skype, or other programs can use any port.

Part 2 - I still cant login in the Sql

1. Go to Start > Execute and type "msconfig" you should get a pop up.
2. Go to Windows Start > And put off all programs starts with windows.
[You can Keep the antivirus or other basic things like audio manager ezt you know]
3. Reboot your pc and Open the SQL Manager, and Log in [Watch part 1]
4. Now you sucesful log in, Open the Xampp, and start the services.

Part 3 - I Log in the sql, but the service apache for xampp dont start [Port 80 Already in use]

1. Click the buttom "Netstat" in the xampp panel. And watch what program is using port 80.
2. Do the Part 2 for fix the Xampp port too.
If you do the part 2 for any reason, but the port 80 still in use, that port can be in use for "System" and cause xampp cant use it.

How to fix it.

Fix 1:
1. Windows > Execute and type "regedit"
2. Go to > HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\HTTP
3. Change key properties to "start" from 3 to 4.
4. Restart your PC.

Fix 2:
Open the “Services.msc” application. Click Windows Logo, then go to run box (on Win 9x and Win XP) or go toSearch Program and Files (on Win Vista and Win 7), then types: services.msc and Enter
Services Panel will appears, and fine World Wide Web Publishing Service on the list (usually at the bottom of services list, see selected service below).

Lg_deluxe - [Guide] Fix CreateDB Fail / Server Crash / Port Issues / SQL Connect - RaGEZONE Forums


Find WWW Publishing Service

If Status of WWW Publishing Service is Started and Startup Type is Automatic. Then please open WWW Publishing Service by double click at the selected service, and the Service Properties box will appears.

Lg_deluxe - [Guide] Fix CreateDB Fail / Server Crash / Port Issues / SQL Connect - RaGEZONE Forums


Set Startup type become Manual and Stop this service

Then check the Services Panel, it should be like this: (whereas WWW Publishing Service status is blank (Stop) and Startup type is Manual)
Lastly, try to start Apache service again! It should be running smoothly.

Now you should be able to start the xampp services.
Watch part 1, and start the server.

(If you still have problem with the ports you can also try disable the firewall and antivirus as well)

Enjoy.

Sorry for my english
:love:
 
Last edited:
Newbie Spellweaver
Joined
Jan 15, 2014
Messages
5
Reaction score
0
I still can't figure out how and where to accomplish step 1... I used to run a private server for wow quite a while back. I don't remember it being this difficult to figure out how and where to create new accounts... Step 1 in this list, I know I haven't done and is most likely my problem. But, every place that mentions it acts like everyone should know exactly how to do it and just forgot to do it. It's probably insanely simple, but could someone point me to where it's explained for us 1st graders?
 
ヽ(#゚Д゚)ノ┌┛)` Д゚)・;'
Joined
Mar 26, 2012
Messages
502
Reaction score
103
I still can't figure out how and where to accomplish step 1... I used to run a private server for wow quite a while back. I don't remember it being this difficult to figure out how and where to create new accounts... Step 1 in this list, I know I haven't done and is most likely my problem. But, every place that mentions it acts like everyone should know exactly how to do it and just forgot to do it. It's probably insanely simple, but could someone point me to where it's explained for us 1st graders?


Got it now ? XD

mfOtSSn - [Guide] Fix CreateDB Fail / Server Crash / Port Issues / SQL Connect - RaGEZONE Forums
 

Attachments

You must be registered for see attachments list
Junior Spellweaver
Joined
Jan 2, 2008
Messages
147
Reaction score
21
I still can't figure out how and where to accomplish step 1... I used to run a private server for wow quite a while back. I don't remember it being this difficult to figure out how and where to create new accounts... Step 1 in this list, I know I haven't done and is most likely my problem. But, every place that mentions it acts like everyone should know exactly how to do it and just forgot to do it. It's probably insanely simple, but could someone point me to where it's explained for us 1st graders?

You should check the guide first for make the files work.
But as melwin answer, you can see how
 
Newbie Spellweaver
Joined
Aug 22, 2013
Messages
37
Reaction score
0
can I know what are the ports to be forwarded? Thank you so much ^_^
 
Junior Spellweaver
Joined
Dec 17, 2012
Messages
119
Reaction score
4
I have tried to follow this thread.
Crash fixed on DNLogServer, ext :mellow:

LogServer
'21:01:21' Application Initialize Success
'21:01:21' ManagedID(SID) [1005]
'21:01:21' ResourcePath [E:\dr\GameRes]
ResourceRevision [157073]
'21:01:21' ServiceManager [IP:127.0.0.1][Port:8501]
'21:01:21' LogServer Port [3000]
'21:01:21' ServerLogDB Connect Info(Ip:127.0.0.1, Port:1433 DBID:DragonNest DBName:DNServerLog) Success
'21:01:21' [Thread-Start] WorkerThread - TID : 2852
'21:01:21' [Thread-Start] WorkerThread - TID : 1944
'21:01:21' [Thread-Start] WorkerThread - TID : 4020
'21:01:21' [Thread-Start] WorkerThread - TID : 3512
'21:01:21' [Thread-Start] WorkerThread - TID : 4896
'21:01:21' ## Iocp Initialize Success(100)
'21:01:21' ## ThreadManager Initialize Success(8)
'21:01:24' DBConnect Error SQLDriverConnect RetCode[-1]
'21:01:24' Not Connect ServerLogDB Ip:127.0.0.1 Port:1433 DBName:DNServerLog DBID:DragonNest
'21:01:24' CreateDB Fail
'21:01:24' ### EventAcceptor Thread Finalize

ServiceManager
'07:34:43' ## LauncherPort:8500, ServicePort:8501 GsmPort:8600 ESMPort:8510 MonitorPort:8650 '07:34:44' DownLoad [
'07:34:44' Notice Has Expired [ID:1] [BeingTime:2013-12-31 00:01]
'07:34:44' [Thread-Start] WorkerThread - TID : 1744
'07:34:44' [Thread-Start] WorkerThread - TID : 1872
'07:34:44' [Thread-Start] WorkerThread - TID : 4536
'07:34:44' [Thread-Start] WorkerThread - TID : 4616
'07:34:44' [Thread-Start] WorkerThread - TID : 4200
'07:34:44' [Thread-Start] WorkerThread - TID : 4120
'07:34:44' Connected NetLauncher IP[127.0.0.1] Port[61866]
'07:34:44' All Launcher Connected
'07:34:45' [Thread-Start] WorkerThread - TID : 4660
'07:34:45' [Thread-Start] WorkerThread - TID : 936
'07:35:17' StartServiceAll OK
'07:35:17' ConsoleCmd [start]
'07:35:19' IP[127.0.0.1],CopyInfo : (Info)[OK](Config)[OK](System)[OK]
'07:35:19' [LauncherReport [NLID:1] [SID:1000]Service Created
'07:35:19' [LauncherReport [NLID:1] [SID:1001]Service Created
'07:35:19' [LauncherReport [NLID:1] [SID:1002]Service Created
'07:35:19' [LauncherReport [NLID:1] [SID:1003]Service Created
'07:35:19' [LauncherReport [NLID:1] [SID:1004]Service Created
'07:35:19' [LauncherReport [NLID:1] [SID:1005]Service Created
'07:35:19' [LauncherReport [NLID:1] [SID:1006]Service Created
'07:35:22' [LauncherReport [NLID:1] [SID:1005] [IP:127.0.0.1]Service Terminated
'07:35:26' [LauncherReport [NLID:1] [SID:1006] [IP:127.0.0.1]Service Terminated
'07:35:31' [LauncherReport [NLID:1] [SID:1004] [IP:127.0.0.1]Service Terminated
'07:35:33' [LauncherReport [NLID:1] [SID:1006] [IP:127.0.0.1]Service Terminated
'07:35:34' [LauncherReport [NLID:1] [SID:1004] [IP:127.0.0.1]Service Terminated
 
Junior Spellweaver
Joined
Jan 2, 2008
Messages
147
Reaction score
21
I have tried to follow this thread.
Crash fixed on DNLogServer, ext :mellow:

LogServer


ServiceManager

You doing something wrong, re-watch the guide, and the lech guide as well, check all again, and btw did you have the C:\xampp\htdocs folders with the files and working?
 
Junior Spellweaver
Joined
Dec 17, 2012
Messages
119
Reaction score
4
You doing something wrong, re-watch the guide, and the lech guide as well, check all again, and btw did you have the C:\xampp\htdocs folders with the files and working?

thank you .. now all be running.
but there is an error .....
Untitled1 - [Guide] Fix CreateDB Fail / Server Crash / Port Issues / SQL Connect - RaGEZONE Forums
 

Attachments

You must be registered for see attachments list
Experienced Elementalist
Joined
Jan 12, 2013
Messages
218
Reaction score
23
help pls , how do i fix this error



nvm fixed it by changing windows authentication to sql authentication , thx for your guide anyway
 

Attachments

You must be registered for see attachments list
Junior Spellweaver
Joined
Jan 2, 2008
Messages
147
Reaction score
21
help pls , how do i fix this error



nvm fixed it by changing windows authentication to sql authentication , thx for your guide anyway

That was the guide says, look carefully.
Part 1 - Solved Fix CreateDB Fail / SQL Connection (Servers/Login ezt Crash)

(You need to be sure you have all the configs/ips fine)
1. Be Sure you give all DB's the DragonNest rights with password qorhvk!@#
2. If you created the account DragonNest, log off from the sql, and log in in (Local) mode and SQL Server auth. With the user DragonNest and password qorhvk!@#
3. If you get any error at login, its because the ports, Put off all Xampp services, skype, or other programs can use any port.
 
Initiate Mage
Joined
Mar 31, 2014
Messages
1
Reaction score
0
Hello im currently having this problem when restoring DNmembership DB and DNworld DB can anyone help ? :(REMOVED
 
Newbie Spellweaver
Joined
Jan 14, 2014
Messages
59
Reaction score
9
What should I do if


Lg_deluxe - [Guide] Fix CreateDB Fail / Server Crash / Port Issues / SQL Connect - RaGEZONE Forums
 
Status
Not open for further replies.
Back
Top