As far as i know i've done everything properly, followed the tutorials. I may of gone wrong somewhere on the IP settings but again don't think i have.
Can anyone take a look at my logs and tell me what the problem is?
As far as i know i've done everything properly, followed the tutorials. I may of gone wrong somewhere on the IP settings but again don't think i have.
Can anyone take a look at my logs and tell me what the problem is?
It looks like you have permissions pronlems in MSSQL.
Originally Posted by GlobalDBAgent.log
The siplest solution is to use your "sa" user and pass in the server config as you can't have permissions problems using that login. It is certainly simpler than adding all the correct priviledges to your cabal1 user.
Also i did notice that your worldsvr is listening on the server LAN IP. That will work as long as you only want LAN players and have the centos LAN IP internal.txt but it won't work for external players. The worldsvr should have the WAN IP and so shoud internal.txt, but then i do recommend testing LAN-only to begin with and then switching to WAN so you can be sure of your config before finding out if your router supports loopback or not.
I just have to change the settings in the config.sh file on CentOS to use the SA user instead of cabal1 then?
Don't edit cabal_config.sh unless you are very sure. The script will ask you for the user pass but you can manually specify it at the top of the script and it won't ask (not many people have spotted that little feature!) when you re-run it.
Right, Managed to login. Now i can't create a character due to unknown DB errors. Also i have no idea how to change drop rates ect yet. Will be fun lol.
Confused now, had to restart the server because of my PC freezing up. Didn't change a thing and now i can't connect again? Nothing in the config has changed it's still using SA.
New logs if anyone can figure anything out?
http://www.mediafire.com/?sharekey=d...eada0a1ae8665a
[Edit] It's just let me login again. I've read somewhere this could be to do with a gameserver link error?
Check the "ifconfig" command on the centos machine as it's IP address has probably changed.
Unknown DB errors are usually down to linked server settings.
http://forum.ragezone.com/f460/setti...2005-a-503557/
As i can login again it was the IP changing that was the problem.
As for the link server, everything there appears to be correct i just can't create a character still.
Clean logs please.
It's my most used phrase lol.
Something is wrong with your linked server settings. Can you post screenshots of your settings?
http://img16.imageshack.us/img16/1820/29172819.jpg
http://img18.imageshack.us/img18/1130/gs2v.jpg
That all you need right?
I've tried 'MATT' & 'localhost' neither work.
Another thing, on the 'cabal' account rather than using sa i had to grant permissions to the account DB. On SA i can't do this..
"Security" section at the top left. Set "Be made without using a security context".
"Server Options". Set all true.
Page 16 of my guide - http://www.mediafire.com/download.php?mr5dlj8scbt
Also i prefer to use the windows lan ip or 127.0.0.1 rather than hostname (MATT).
That's the guide i followed. I'll try the other bit 127.0.0.1 then get back to you.
Still getting the same error using 127.0.0.1.
Reply With Quote