So Close: DB Error

[chumpywumpy]

If it's using bridged there isn't any point in changing the others as the adapters aren't being used at all. The port forwarding on the vmnet 8 shouldn't affect vmnet 0 but it can't hurt to remove any forwarding rules if there are any.

I would agree that windows is refusing the connections as everything we have done so far indicates all ports actively refusing connections. Pinging isn't always a good test of conectivity as some firewalls (and routers) can be set to respond to pings (ICMP traffic) whilst blocking all other connections which is why i was suspicious of the sunbelt firewall.

When doing these tests are you using the Windows LAN IP or the Hamachi ones?

[nickmasterinu]

I didn't install Hamachi yet as it seems to be the thing that messes up my general network connection. I'm still using 20 (CentOS) and 116 (Windows) for IPs.

As for Sunbelt, I know it's crazy "good" at blocking everything until you let it through, but I keep it disabled while doing this. Maybe I'll try playing around with it on and completely off and see if I can get it to make a rule or if the connections happen to go through respectively.

[archangel1969]

If you need any help, Im willing to check your setup via TeamViewer.
Ive used it as a tool for 2moons as a VGM.
I setup my server with no issues, except issues with xp 64 bit webserver that Im having.

DL & watch all the setup films from FiX posted here on ragezone. http://forum.ragezone.com/f460/video...by-fix-524857/

If you need any help, Im retired now and home alot due to an injury, So Im working on my own closed private server alot and willing to help people with the knowledge I know from Chumpy & other developers help.

[nickmasterinu]

Well archangel, before jumping to that more desperate solution (forgive me, I'm quite cautious when it comes to things like that), do you happen to know how the windows OS would be completely blocking the CentOS?

[chumpywumpy]

I would probably start by killing everything that you can kill in the processes tab of taskmanager and see if that sorts it. Next i would be hunting through the services shown in the service manager in control panel for anything that looked like it could be affecting things (knowing what should be in that list on a default install helps).

It definitely isn't the behaviour of a default install so it must be either something running to do the blocking. As a last resort i would poke around the vmware network settings but there isn't much you can get wrong in there if it's bridged.

Could you mayve post a list of the process names shown in taskmanager on the processes tab (censoring if need be)?

[archangel1969]

Well archangel, before jumping to that more desperate solution (forgive me, I'm quite cautious when it comes to things like that), do you happen to know how the windows OS would be completely blocking the CentOS?

As Chumpy stated in his post, As long as your Firewall is off and you can ping the Centos machine and SQL you should have no issues with your connection along with the correct ports forwarded. I dont know your setup but there should be no reason you cant connect. There must be somthing else blocking your connection. I understand your conserns with Team Viewer. When I operated my first Knight Online Private Server my complete server os was wiped due to my own fault. I wish you the best and I know you will figure out the problem. On the worst side mabe due a fresh os install and start new. Its got to be somthing simple that is being missed. Make sure your router firewall is off and your DMZ I.P. setting is correct in your router for your Centos machine.

[nickmasterinu]

Processes: I killed what looked pointless/was willing to kill and still nothing. Watched the logs, reran the config; nothing. As for a picture of all running processes, since PB and the attachments didn't seem to work, here it is available on Mediafire...

"Service Manager": I didn't find it. <_< Either I'm blind or it's "deeper" in the Control Panel than I looked.

VMW Network: Already did poke around, nothing. >_>

DMZ: As far as I understand it, DMZ is for WAN connections when we're trying to establish a "better" LAN connection. I tried it ntl and it didn't help at all.

[chumpywumpy]

There are a few things i don't recognize in there but i can see a "SbPFLnch.exe" which i'm guessing is the sunbelt firewall so at least a part of it is still running.

Does your antivirus have any form of fitering/firewall type feature? Probably not but it's one place i've not checked and some a/v softwares do have that.

[nickmasterinu]

Killed that process, still nothing.

As for Avira, I don't think it would interfere with the network. It has a "Scanner" and a "Guard", which seems to be for files on/being written on the hard drive, and since it's the "free version", I doubt it has a firewall bit with it.

Alright, as the solution seems to be evasive, what about trying "Host-only" mode on the VMWare settings? Would that allow for me to connect at the very least and is there any information on setting it up (if it were to work of course)?

[chumpywumpy]

It definitely won't be avira as i use the exact same version. I didn't think it would be a/v but i'm running out of ideas.

Host only might be worth a try but only you will be able to log on. Setting to host only shouldn't need any extra configuration but i've never used it so i can't be sure.

Has centos got a manually specified IP address in it's config or an autoo assigned one using DHCP? If it's auto try manually specifying it (other than ip the other info you need is in "ipconfig /all" on windows).

[nickmasterinu]

I think the answer to this is yes, but will there be "special" IP's is I use Host Only? (I'm desperate to start playing around, so I might use this for awhile until I/we can figure out this other bit).

As for the IP, yes, the CentOS IP is set to a static IP of 192.168.1.20 with the same gateway and DNS settings as the window's computer.

EDIT: Host Only has the same problem as bridged. DB doesn't exist and connection refused.

I also noticed that the VM "networks" aren't on my Sunbelt network list, as if it doesn't exist to the firewall or something...

EDIT2: I remember something...when I was first using Mahi's video guide and got the server set up, the DBAgent log gave me a "DB Success" the first time I checked it. After that (I messed with some files which screwed that installation over), it's never worked...