Take a look..

Chase123 · Mar 13, 2009

Here it goes. For the past 2 days I'vee been working my hands off trying to establish a small LAN Cabal server for my own use. No intention of a public so that rules out WAN problems.

Now for me to get this thing working is .. I just need a logical explanation of how it really works. I mean:

I install MSSQL (which from my understanding is a server,duh!) and add the databases which are needed for the server to have it's "guidelines".. then CentOS which is a virtual OS (Linux) which contains my server files and needs to connect to MSSQL to feed it the server files. My OS (Windows Vista) is just a platform for all of these?

My biggest problem is networking. As I have stated I do not want a public server. So that means I gotta go with LAN. So .. I am in a LAN behind a router. I know my IP adress. 89.114.36.xxx (should i reveal what's behind the x's?) and the part that drives me nuts is: I need to give my virtual OS an IP.. How do I find it? How do I know that's it? I can share my IP so you can tell me how to determine it.

I'm just really tirred and I really wanna get this working. I've tried almost anything. If it's not too much to ask... pointing out an order in which to go.. I mean .. Step 1 install MSSQL, Step 2 Install CentOS (configure,etc)would be greatly apriciated. Another problem is in MSSQL.. After everything works fine I get to this part :

DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;

If I leave it like that, it works, but I don't understand it, so if I run into trouble, I'm unable to solve the problem.

Please just explain if you can. I would like to understand what I am doing, not just do it.. Especially when I keep failling.

Thank you.

chumpywumpy · Mar 14, 2009

Do you have LAN addresses as well or does your PC connect directly to the internet? Try running "ipconfig" in a command prompt on windows and see if your main IP starts with 10.x or 192.x as you have a LAN if so. The LAN addresses are the important ones if you want LAN-only.

You can find the centos IP using the "ifconfig" in a terminal/putty.

DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;

Change that to the Windows LAN IP as that will work better.

If you have a LAN you need to work out your subnetwork so you know what address ranges to use. Normally i would check the IP addresses of a few machines on the LAN if i didn't know how to work it out fron the netmask. You will probably find you have something like this, 192.168.0.2, 192.168.0.3 and 192.168.0.4 which would make your address range 192.168.0.x (the netmask and gateway to use are listed on ipconfig).

Once you know the range pick an address that won't ever get used (they always start assigning from the lowest number first). My centos machines start from 192.168.0.20 as i know my usually assignments don't go that high.

Now you should have the IP, netmask and gateway to use but you still need at least one DNS server (2 is more normal). For those use "ipconfig /all".

Chase123 · Mar 14, 2009

Hey. Thanks for the reply. I understand what you are trying to say and I figured out some stuff. But still have some more questions. Please understand that I want to get this thing done properly.

Now when I run "ipconfig" on the cmd, I get 3 sets of local area connections. One has my IP adress : starts with 89.xxxx, the second : 192.168.96.x and the last : 192.168.149.x (the last ones have both the same subnet mask). So is this normal?

Oh, and yes I have LAN adresses, cuz I do not connect to the Internet directly.

First pic is IPCONFIG in Windows cmd and the second is IFCONFIG in CentOS.

I'm really confused. Don't even know what I have.

chumpywumpy · Mar 14, 2009

Eww, Vista, my eyes burn xP

For your setup your vmware networking should be "nat" instead of bridged. In your connection string use 127.0.0.1 where i marked "localhost" earlier. When running cabal_config use the 89.x when asked for the address players will connect to and also in the client internal.txt files.

You do connect to the internet directly according to that ipconfig

Chase123 · Mar 15, 2009

Haha xD. Thanks. I knew I should go back to XP.

Vista is a major pain.

Late Edit..

After trying it a lot of time's I switched back to XP. I tried to install the server again. But still no dice. I even managed to f-up my internet connection and had to reinstall windows.

Now it's all clean and should work. I'm trying again.

I was thinking today about what to use. Now, for me to give CentOS an IP , when I ping in my 89.x adresses, I should use the one's that don't respond,right? For example, -ping 89.xxx.x.xxx .. And I get a request timed out, is this a valid IP?

Sorry for bumping but editing doesn't refresh it.