|
You last visited: Today at 21:36
Advertisement
SQL problems
Discussion on SQL problems within the Rohan forum part of the MMORPGs category.
03/29/2015, 12:13
|
#1
|
elite*gold: 0 
Join Date: Jul 2014
Posts: 70
Received Thanks: 10
|
SQL problems
Hi guys i need some help connecting to sql server 2014.
I use this guide  for lvl 99 rohan server.
According to the guide you have to change
Quote:
C:\xampp\htdocs\RohanAuth\include\dbconn.php
ServerName = your computer name
uid = sa
pwd = your mssql pass
|
My question is: Do I have to modify the IP to my external IP or to my internal one? Since I`m gonna use this server on the same machine where I plan to use my client.
Also, on the server machine I will connect local to my SQL server. When I configure the files for "pwd" should I put my SQL password or leave it blank since i`m connected to the server machine and use the client on the same machine?
My SQL log are
|
|
|
|
03/29/2015, 18:19
|
#2
|
elite*gold: 0
Join Date: Jul 2014
Posts: 67
Received Thanks: 9
|
I have the same problem hope someone will help us
|
|
|
|
|
03/29/2015, 19:05
|
#3
|
elite*gold: 0
Join Date: Jul 2014
Posts: 70
Received Thanks: 10
|
Now I face the following problem
|
|
|
|
|
03/29/2015, 20:24
|
#4
|
elite*gold: 0
Join Date: May 2013
Posts: 174
Received Thanks: 30
|
Quote:
Originally Posted by sariusmt
Hi guys i need some help connecting to sql server 2014.
I use this guide for lvl 99 rohan server.
According to the guide you have to change
My question is: Do I have to modify the IP to my external IP or to my internal one? Since I`m gonna use this server on the same machine where I plan to use my client.
Also, on the server machine I will connect local to my SQL server. When I configure the files for "pwd" should I put my SQL password or leave it blank since i`m connected to the server machine and use the client on the same machine?
My SQL log are
|
server name = your computer name
uid = sa
pwd = ur mssql password
open cmd, type ipconfig then enter. use ur IPv4 ip for localhost. change the ip on dbserver, regedit and xampp.
|
|
|
|
|
03/29/2015, 21:35
|
#5
|
elite*gold: 0
Join Date: Mar 2014
Posts: 162
Received Thanks: 7
|
Or just use 127.0.0.1
|
|
|
|
|
03/31/2015, 20:50
|
#6
|
elite*gold: 0
Join Date: Jul 2014
Posts: 70
Received Thanks: 10
|
Ok so now SQL seems to be working fine but AI server won`t start, at least it won`t show on my desktop and MapID says "Can`t connect to DB server".
LogServer logs show server started but again it won`t stay on my screen. Any advices?
Ok so i also get this
|
|
|
|
|
04/01/2015, 03:28
|
#7
|
elite*gold: 0
Join Date: May 2013
Posts: 174
Received Thanks: 30
|
you need to do to fix your problem.
|
|
|
|
|
04/01/2015, 08:14
|
#8
|
elite*gold: 0
Join Date: Jul 2014
Posts: 886
Received Thanks: 440
|
Quote:
Originally Posted by sariusmt
Hi guys i need some help connecting to sql server 2014.
I use this guide for lvl 99 rohan server.
According to the guide you have to change
My question is: Do I have to modify the IP to my external IP or to my internal one? Since I`m gonna use this server on the same machine where I plan to use my client.
Also, on the server machine I will connect local to my SQL server. When I configure the files for "pwd" should I put my SQL password or leave it blank since i`m connected to the server machine and use the client on the same machine?
My SQL log are
|
First of all that's really wrong you dont use your computer name you use the SQL server name for the rohan server (SQL can use more then 1 server for multiple game's) The sa is the default username for the database (Witch i recomend you change) next comes the password that you set for the new user.(If you installed the SQL without setting an Simple Account (SA) then you will have to create one.
|
|
|
|
|
04/01/2015, 12:21
|
#9
|
elite*gold: 0
Join Date: Jul 2014
Posts: 70
Received Thanks: 10
|
Quote:
Originally Posted by DretoNEX
First of all that's really wrong you dont use your computer name you use the SQL server name for the rohan server (SQL can use more then 1 server for multiple game's) The sa is the default username for the database (Witch i recomend you change) next comes the password that you set for the new user.(If you installed the SQL without setting an Simple Account (SA) then you will have to create one.
|
If i remember right I did add my current PC username to SQL when I installed the SQL server.
Regarding the use of SQL server and not my computer name, I edited the registry to use my computer name .
I did set up a password for my SQL account like it`s listed in the registry.
|
|
|
|
|
04/01/2015, 12:35
|
#10
|
elite*gold: 0
Join Date: Jul 2014
Posts: 886
Received Thanks: 440
|
Quote:
Originally Posted by sariusmt
If i remember right I did add my current PC username to SQL when I installed the SQL server.
Regarding the use of SQL server and not my computer name, I edited the registry to use my computer name .
I did set up a password for my SQL account like it`s listed in the registry. |
K im gonna give you an advice here STOP dooing any kind of rohan server you wana do right now if you cant even figure out what's the SQL server name and what's your pc name then im pretty sure noone arround here will even try to help you. As for the password it has nothing to do with the registry.
|
|
|
|
|
04/01/2015, 14:57
|
#11
|
elite*gold: 0
Join Date: Jul 2014
Posts: 70
Received Thanks: 10
|
Quote:
Originally Posted by DretoNEX
K im gonna give you an advice here STOP dooing any kind of rohan server you wana do right now if you cant even figure out what's the SQL server name and what's your pc name then im pretty sure noone arround here will even try to help you. As for the password it has nothing to do with the registry.
|
Dreto, I do appreciate the criticism, constructive or otherwise. I won`t stop cuz that`s how I learn new things. As I said I`m looking at this server as a personal project. I`m pretty sure it will take me some time to figure things out. It`s not in my nature to give up when things won`t work. When you said server name I asume you were refering to MSSQLSERVER. Anyway, thanks for the tip.
|
|
|
|
|
04/01/2015, 15:41
|
#12
|
elite*gold: 0
Join Date: May 2013
Posts: 174
Received Thanks: 30
|
try to read all posts (maybe from pages 1 to 20 only) on senzoku thread at another forum. what you want to know and your problems has been explained there. but i believe you need some hard reading all of them. no offense, if you cant start your server after that then I would suggest the same thing as what dreto said. This is just the beginning, you will find a bigger problems later. trust me 
|
|
|
|
|
06/25/2015, 10:14
|
#13
|
elite*gold: 0
Join Date: Oct 2014
Posts: 20
Received Thanks: 0
|
may i humbly ask for help in setting up a local rohan server..i managed to make xampp running..do i need the mysql running too?..dbserver opens but it closes instantly..please help
|
|
|
|
|
06/25/2015, 14:50
|
#14
|
elite*gold: 0
Join Date: Feb 2014
Posts: 396
Received Thanks: 107
|
Quote:
Originally Posted by daingnabangus
may i humbly ask for help in setting up a local rohan server..i managed to make xampp running..do i need the mysql running too?..dbserver opens but it closes instantly..please help
|
This forum is full of answers for every kind of issues. Go make an effort and search for yourself, if you're really interested in succeeding.
|
|
|
|
|
06/25/2015, 15:37
|
#15
|
elite*gold: 0
Join Date: May 2011
Posts: 418
Received Thanks: 239
|
Quote:
Originally Posted by daingnabangus
may i humbly ask for help in setting up a local rohan server..i managed to make xampp running..do i need the mysql running too?..dbserver opens but it closes instantly..please help
|
tbh all you have to do is import db and double check every IP address settings and it should work just fine.
|
|
|
|
 |
|
Similar Threads
|
[PROBLEMS] Server Problems
04/29/2012 - Metin2 Private Server - 0 Replies
Hi I have a little problem on the server metin2.
I put it on the dedication and everything works beautifully, but as I enter the
client of this writing have been connected to the server and still nothing lasts there is no login or anything standing still
|
Roc Mountain Teleport Problems? DC Problems?
12/11/2011 - SRO Private Server - 1 Replies
I have got a problem to the teleport to Roc Mountain? (to aircraft dock and reverse scrool, non of them can teleport me to the Roc mountain inside area)
In my database when Roc Mt. value is (2), i don't teleport here. It is true.
When value is (1), i can teleport. It is true too.
But when I change the value 2 to 1 the DC problem is arises.
When i try to summon a attacker pet or i try to mount a vehicle (all of them can occur same problem) the dc problem is happen. Also some times when i...
|
Roc Mountain Teleport Problems? DC Problems?
12/08/2011 - Silkroad Online - 0 Replies
I have got a problem to the teleport to Roc Mountain? (to aircraft dock and reverse scrool, non of them can teleport me to the Roc mountain inside area)
In my database when Roc Mt. value is (2), i don't teleport here. It is true.
When value is (1), i can teleport. It is true too.
But when I change the value 2 to 1 the DC problem is arises.
When i try to summon a attacker pet or i try to mount a vehicle (all of them can occur same problem) the dc problem is happen. Also some times when i...
|
[Problems] Source 5165 All Problems
11/28/2009 - CO2 Private Server - 7 Replies
Hello Everyone, Ok i will put All my problems here So i hope noone spamming and
Say Go learn C# and w/e
1-RegPage: fixed all by adding to the start of the pass and to the end of the pass.
its working okay and when i create character and try to rejoin the game close with itself
Note: When i make From NewestCOServer Cmd it works fine and the game dont close i mean i want other players to make thier own accounts and dont ask me to make them The Accounts they want.
2-Lottery: Cant...
|
[Problems]Having problems in Cabal Wudijt
07/01/2008 - Cabal Online - 0 Replies
1>im having problems in registering in Wudijt can anyone help me give me working link
2>i cant seem to update my red cabal online is it offline?
3>when i load Cabal.exe the cabal window will just dissapear please help me,i followed everyone's advice but it doesnt work, can anyone tell me what the real problem?
thanks! ^_^
|
All times are GMT +2. The time now is 21:36.
|
|
