Can't connect to your server? Read this.

[cypher]

did you install sql 2005 as a named instance?

 

[chumpywumpy]

i'm braking my head trying to config the wmware nat connection, i fowarded the ports, ports are responding using the port tester, but my internet conection crashes, mmm is there any way to foward the ports using a bridged connection??
when i try to connect the nat to the VMware Network Adapter VMnet8 i got a message, imcompatible with your subnet mask
my ip es 200.119.201.250
i have 2 network addapters one with the lan ip 192.168.0.1 ( used for share internet to other machines)
the wan ip 200.119.201.250
centos ip 192.168.0.100 with bridge connection works.
but when i create a nat it connects with the 192.168.0.1 and not the VMware Network Adapter VMnet8

how can i fix it? or configure ??

On a bridged connection there is no need to forward ports as a bridged connection is only used on a LAN and the router handles the port forwarding. If that 192.168.0.1 ip is not one of the vmware adaptors then you are on a lan and should use a bridged connection. Make sure you read the vmware networking guide in my sig for the notes about routers as there are some things you will need to know.

I have done everything i possibly can to connect to my server, I just cannot seem to make it work. I have read everything on this forum all the guides and still nothing. I have no errors or anything all the db's load and checked the logs and no errors. No idea what I am doing wrong.

The key is whether the loginsvr log shows the login attempts. If it doesn't then you need to start checking the various things that could stop your connection getting to the server such as internal.txt being correct and using the batch file to launch the client not cabalmain itself. If you have a router and are trying to connect to the WAN ip is port forwarding working (check with an online port scanner) and if you only have a modem is your vmware port forwarding set correctly. Remember that some routers won't let LAN connections use the WAN address no matter what you do. Read the networking guide i mentioned above as this is definitely going to be networking somewhere.

hello
I can not login
software used:
SQLEXPR_ADV (sql 2005 advanced services sp3)
vista sp2 x64
CentOS 4.5
VMware 6.5.2 build 156735

i used chumpywumpy install guides (all of them)
and router


logs and some screens

You must be registered to see links

This is going to be an incorrect sql install as Cypher says. The server cannot connect to the db and the reason for that is always the same. A default install of any express edition will not work. Check my sql2005 guide at

You must be registered to see links

and reinstall SQL.

 

[gujda1]

And i cannot connect to WinSCP, i get "Connection timed out"
And i don't know what IP i should set in CentOS?
i tried my routers and my windows one.but it doesn't work.

Please help!

 

[optimus0]

I have already check your guide step by step.
Could you give some querry or something to confirm it is installed properly?

 

[Cath22]

just check logs it should say

[Sun Jun 28 2009 15:00:01.988276 4159620816]: accept success 19(127.0.0.1:60606)
[Sun Jun 28 2009 21:00:01.445902 4159620816]: accept success 18(127.0.0.1:41938)
[Sun Jun 28 2009 21:00:01.448983 4159620816]: accept success 19(127.0.0.1:41942)
[Mon Jun 29 2009 03:00:02.009223 4159620816]: accept success 18(127.0.0.1:42230)
[Mon Jun 29 2009 03:00:02.012121 4159620816]: accept success 19(127.0.0.1:42234)

tt1:

 

[optimus0]

i am traying to execute the querry of chumpywumpy but i got this error

Msg **** Level 15, State 1, Line 25
Unclosed quotation mark after the character string 'Remote connections enabled?
'.
Msg 102, Level 15, State 1, Line 25
Incorrect syntax near 'Remote connections enabled?
'.

 

[chumpywumpy]

Yes there is one missing. Not sure it it was me messing up a copy/paste or the forums doing something odd. Check the very last line

select @inspath as 'Instance path',@tcpremote as 'Remote connections enabled?

It should be:

select @inspath as 'Instance path',@tcpremote as 'Remote connections enabled?'

 

[carlos666]

me again
well now i got no message errors when i start the server
but i got some errors when i try to log

the services are ok in after starts the server, 10 minutes, 20 minutes and all ok
windows pings centos
centos pings windows
firewalls are off


here are my logs

 

[optimus0]

thanks chumpywumpy to traying to help me
my herror was really stupid i forgot to add the por 1433 on vista x64 sp2 firewall
sorry
(any way... it dont apear on any guide that i see)
thanks

 

[chumpywumpy]

me again
well now i got no message errors when i start the server
but i got some errors when i try to log

the services are ok in after starts the server, 10 minutes, 20 minutes and all ok
windows pings centos
centos pings windows
firewalls are off


here are my logs

It is having problems converting a date according to the error. What timezone did you install centos as?

 

[carlos666]

It is having problems converting a date according to the error. What timezone did you install centos as?

-4 gmt, i'm in bolivia
my windows and centos are in the same hour and gmt


im using the centos ip in the internal.txt
it's the only way to get a response from the server
i remember that are 2 files that need the ip in the client
one is the internal.txt that goes to the /data
but the other, can you please post it? or tell me the name for search?



now i connect to the server
but when i choose the 1st channel at mercury server the connection bar never stops and a message appears disconnecting me

in the world_svr_01_01.log a message appears when i try to connect

[Tue Jun 30 2009 19:16:54.338169 9562608]: try listening 38111 port
[Tue Jun 30 2009 19:17:13.459648 9562608]: sock 5 ->LinkHandler close
[Tue Jun 30 2009 19:17:18.460304 9562608]: [##ERROR##] remoteAddr(127.0.0.1), connectRetryNum_(9,0), serverAddr(127.0.0.1:38170)
[Tue Jun 30 2009 19:17:18.461329 9562608]: try connect 127.0.0.1:38170, Sync
[Tue Jun 30 2009 19:17:18.469350 9562608]: sock 5 ->LinkHandler Open
[Tue Jun 30 2009 19:17:18.469578 9562608]: SendIPSConnect2Svr (161:01:01:00)
[Tue Jun 30 2009 19:17:18.518012 26868624]: ChannelType not changed. this(0), fromGMS(0)

 

[Squarebob]

Followed all of Chumpy's guides and still can not connect. Awfully sure I've configured everything right.

 

[chumpywumpy]

-4 gmt, i'm in bolivia
my windows and centos are in the same hour and gmt


im using the centos ip in the internal.txt
it's the only way to get a response from the server
i remember that are 2 files that need the ip in the client
one is the internal.txt that goes to the /data
but the other, can you please post it? or tell me the name for search?



now i connect to the server
but when i choose the 1st channel at mercury server the connection bar never stops and a message appears disconnecting me

in the world_svr_01_01.log a message appears when i try to connect

[Tue Jun 30 2009 19:16:54.338169 9562608]: try listening 38111 port
[Tue Jun 30 2009 19:17:13.459648 9562608]: sock 5 ->LinkHandler close
[Tue Jun 30 2009 19:17:18.460304 9562608]: [##ERROR##] remoteAddr(127.0.0.1), connectRetryNum_(9,0), serverAddr(127.0.0.1:38170)
[Tue Jun 30 2009 19:17:18.461329 9562608]: try connect 127.0.0.1:38170, Sync
[Tue Jun 30 2009 19:17:18.469350 9562608]: sock 5 ->LinkHandler Open
[Tue Jun 30 2009 19:17:18.469578 9562608]: SendIPSConnect2Svr (161:01:01:00)
[Tue Jun 30 2009 19:17:18.518012 26868624]: ChannelType not changed. this(0), fromGMS(0)

The only other spot the IP should be in is the worldsvr ini files but cabal_config takes care of those.

The error there just measn the server took a little time to start. It tried connecting to the globalmgrsvr and failed, then tried again and connected ok so the worldsvr started up a little quicker than globalmgrsvr.

Try setting the centos timezone and time/date format to US/UK as that is what i have used for all of my servers. I know mssql can get very confused when trying to work out some date formats and ends up using the wrong values. If i give it a date of 01/01/09 it can't tell which is the month and which is the day which wouldn't matter for that, but if i give it 31/01/09 and it fails to work out that 31 is the day not the month (it sounds stupid but this can happen) it fails to convert the date to SQL format.

Followed all of Chumpy's guides and still can not connect. Awfully sure I've configured everything right.

I can see 1 connection attempt in the loginsvr log but it didn't get as far as either accepting it as a valid user/pass or rejecting it. I think you took the logs before it managed to save the error. Try a few login attempts and zip the logs again. This will be an "sql server unavailable" i think so also let me know if you use sql 2005 express or not as well.

 

[sheyianne1022]

hi, i was wondering if is it possible to run the server and play the actual game in just one machine?
i mean to use one pc as the centos server mssql database server and at the same time run cabal game and connect to your own server, and if it is possible what would be the setting for such a setup?

 

[Squarebob]

I can connect to the server now, however when I try to make a character I get "Cannot proceed with the command due to unknown DB Errors. Please try again"

EDIT: Sorry, forgot the server logs . I'm using SQL Server 2005

 

[carlos666]

hi, i was wondering if is it possible to run the server and play the actual game in just one machine?
I mean to use one pc as the centos server mssql database server and at the same time run cabal game and connect to your own server, and if it is possible what would be the setting for such a setup?

omg u need a super pc to do that,

centos timezone and time/date format to US/UK
the timezone changed but the time/ date format?? how can i change it?

 

[chumpywumpy]

I can connect to the server now, however when I try to make a character I get "Cannot proceed with the command due to unknown DB Errors. Please try again"

EDIT: Sorry, forgot the server logs . I'm using SQL Server 2005

Your linked server settings are bad. Follow the guide below and you won't need the setting anyway.
http://forum.ragezone.com/f460/how-to-remove-the-need-for-a-linked-server-576629/

 

[sheyianne1022]

hi,

well i finally managed to make my private server work, the database and linux server plus the cabal game is running quite smoothly in my pc, im using cabal ph client though it took me quite a while to find a work around for it to function properly, theres one problem though i already did the Useworlddrop=1 thingy that i read somewhere from this forum but still mobs are only droping orbs, if its not orbs its daikatanas, what do you think is wrong with my configurations sir chumpy?

 

[chumpywumpy]

This will be the drop rate in const.scp. If the rate is over 5x (500) it is known to break drops like that so you only every get the same items. Simply drop it to 5x and it should be fine.

 

[sheyianne1022]

sir chummpy the server and game is running smoothly but im having problems still with the drops. my drop rate is only 5 and in my UseworldDrop=1, still it is droping orbs or daikatanas sometimes katanas, and why is it my character doesnt gain exp? it only gains sword skill and magic skill exp?