nazer

Okay after some playing around I finally solved it!! There was a problem with me using the mangos zero realm database. Why? I don't know... Simply put after testing random things it came down to simply importing the realm database that is inside of /sql/ OVER the zp_realm database that was imported with the mysql_import file. So to make the database work simply. cd to zero database folder ./mysql_import cd to /sql/ mysql -u root --password=**** zp_realm < realmd.sql Thank you again for sticking it out with me even though the solution is something so simple. Let me join you with a /facepalm UnkleNuke.

Ok so I reloaded everything and it seems to be working however I did it with the given blank mangos database. So the problem does not lie in the firewall. I am able to connect perfectly and everything! Now I need to figure out how to update the database with the MaNGOS Zero files. Thank you for your help. It is really appreciated!

Alright I just tried that and it still didn't work! I really appreciate all of the help you have given me so far though. I am using lubuntu actually. It doesn't have as much of this bloatware that you speak of plus a beautiful opaque default desktop. I am slowly working towards debian my friend but my knowledge is not at that level yet haha. I tried what you did and it had no effect. Can you explain to me more about what it looked like when you were unable to connect before? Were you stuck on handshaking? or stuck on just connecting to the server in general. I am stuck on -handshaking or connecting to game server-. Maybe being able to recreate the same problem as me might help you a bit? Do you think maybe a picture would better explain the situation? I am not too sure now if it is a firewall issue though. Even if I completely wiped out the iptables I still was not able to connect. No firewall should mean (in theory) all traffic to be sent.

Alright I tried it and nothing! Here is the output of iptables -S: -P INPUT ACCEPT -P FORWARD DROP -P OUTPUT ACCEPT -N INBOUND -N LOG_FILTER -N LSI -N LSO -N NR -N OUTBOUND -A INPUT -s 192.168.0.1/32 -p tcp -m tcp ! --tcp-flags FIN,SYN,RST,ACK SYN -j ACCEPT -A INPUT -s 192.168.0.1/32 -p udp -j ACCEPT -A INPUT -s 205.171.3.25/32 -p tcp -m tcp ! --tcp-flags FIN,SYN,RST,ACK SYN -j ACCEPT -A INPUT -s 205.171.3.25/32 -p udp -j ACCEPT -A INPUT -i lo -j ACCEPT -A INPUT -p icmp -m icmp --icmp-type 8 -m limit --limit 1/sec -j ACCEPT -A INPUT -p icmp -m icmp --icmp-type 0 -m limit --limit 1/sec -j ACCEPT -A INPUT -p udp -m udp --dport 33434 -j ACCEPT -A INPUT -p icmp -m icmp --icmp-type 3 -j ACCEPT -A INPUT -p icmp -j LSI -A INPUT ! -s 192.168.0.0/24 -i wlan0 -j NR -A INPUT -d 255.255.255.255/32 -i wlan0 -j DROP -A INPUT -d 192.168.0.255/32 -j DROP -A INPUT -s 224.0.0.0/8 -j DROP -A INPUT -d 224.0.0.0/8 -j DROP -A INPUT -s 255.255.255.255/32 -j DROP -A INPUT -d 0.0.0.0/32 -j DROP -A INPUT -m state --state INVALID -j DROP -A INPUT -f -m limit --limit 10/min -j LSI -A INPUT -i wlan0 -j INBOUND -A INPUT -j LOG_FILTER -A INPUT -j LOG --log-prefix "Unknown Input" --log-level 6 -A FORWARD -p icmp -m icmp --icmp-type 8 -m limit --limit 1/sec -j ACCEPT -A FORWARD -p icmp -m icmp --icmp-type 0 -m limit --limit 1/sec -j ACCEPT -A FORWARD -p udp -m udp --dport 33434 -j ACCEPT -A FORWARD -p icmp -m icmp --icmp-type 3 -j ACCEPT -A FORWARD -p icmp -j LSI -A FORWARD -j LOG_FILTER -A FORWARD -j LOG --log-prefix "Unknown Forward" --log-level 6 -A OUTPUT -s 192.168.0.7/32 -d 192.168.0.1/32 -p tcp -m tcp --dport 53 -j ACCEPT -A OUTPUT -s 192.168.0.7/32 -d 192.168.0.1/32 -p udp -m udp --dport 53 -j ACCEPT -A OUTPUT -s 192.168.0.7/32 -d 205.171.3.25/32 -p tcp -m tcp --dport 53 -j ACCEPT -A OUTPUT -s 192.168.0.7/32 -d 205.171.3.25/32 -p udp -m udp --dport 53 -j ACCEPT -A OUTPUT -o lo -j ACCEPT -A OUTPUT -s 224.0.0.0/8 -j DROP -A OUTPUT -d 224.0.0.0/8 -j DROP -A OUTPUT -s 255.255.255.255/32 -j DROP -A OUTPUT -d 0.0.0.0/32 -j DROP -A OUTPUT -m state --state INVALID -j DROP -A OUTPUT -o wlan0 -j OUTBOUND -A OUTPUT -j LOG_FILTER -A OUTPUT -j LOG --log-prefix "Unknown Output" --log-level 6 -A INBOUND -p tcp -m state --state RELATED,ESTABLISHED -j ACCEPT -A INBOUND -p udp -m state --state RELATED,ESTABLISHED -j ACCEPT -A INBOUND -j LSI -A LSI -j LOG_FILTER -A LSI -p tcp -m tcp --tcp-flags FIN,SYN,RST,ACK SYN -m limit --limit 1/sec -j LOG --log-prefix "Inbound " --log-level 6 -A LSI -p tcp -m tcp --tcp-flags FIN,SYN,RST,ACK SYN -j DROP -A LSI -p tcp -m tcp --tcp-flags FIN,SYN,RST,ACK RST -m limit --limit 1/sec -j LOG --log-prefix "Inbound " --log-level 6 -A LSI -p tcp -m tcp --tcp-flags FIN,SYN,RST,ACK RST -j DROP -A LSI -p icmp -m icmp --icmp-type 8 -m limit --limit 1/sec -j LOG --log-prefix "Inbound " --log-level 6 -A LSI -p icmp -m icmp --icmp-type 8 -j DROP -A LSI -m limit --limit 5/sec -j LOG --log-prefix "Inbound " --log-level 6 -A LSI -j DROP -A LSO -j LOG_FILTER -A LSO -m limit --limit 5/sec -j LOG --log-prefix "Outbound " --log-level 6 -A LSO -j REJECT --reject-with icmp-port-unreachable -A NR -s 0.0.0.0/8 -d 192.168.0.0/24 -i wlan0 -j LSI -A NR -s 10.0.0.0/8 -d 192.168.0.0/24 -i wlan0 -j LSI -A NR -s 127.0.0.0/8 -d 192.168.0.0/24 -i wlan0 -j LSI -A NR -s 169.254.0.0/16 -d 192.168.0.0/24 -i wlan0 -j LSI -A NR -s 172.16.0.0/12 -d 192.168.0.0/24 -i wlan0 -j LSI -A NR -s 192.0.0.0/24 -d 192.168.0.0/24 -i wlan0 -j LSI -A NR -s 192.0.2.0/24 -d 192.168.0.0/24 -i wlan0 -j LSI -A NR -s 192.168.0.0/16 -d 192.168.0.0/24 -i wlan0 -j LSI -A NR -s 198.18.0.0/15 -d 192.168.0.0/24 -i wlan0 -j LSI -A NR -s 198.51.100.0/24 -d 192.168.0.0/24 -i wlan0 -j LSI -A NR -s 203.0.113.0/24 -d 192.168.0.0/24 -i wlan0 -j LSI -A NR -s 224.0.0.0/4 -d 192.168.0.0/24 -i wlan0 -j LSI -A NR -s 240.0.0.0/4 -d 192.168.0.0/24 -i wlan0 -j LSI -A OUTBOUND -p icmp -j ACCEPT -A OUTBOUND -p tcp -m state --state RELATED,ESTABLISHED -j ACCEPT -A OUTBOUND -p udp -m state --state RELATED,ESTABLISHED -j ACCEPT -A OUTBOUND -j ACCEPT

This is the output of it. auto lo iface lo inet loopback

I just started to use ubuntu a little while ago so I'm not very knowledgeable about it either but I am enjoying the switch to linux very much! After getting my output of iptables -S by using your commands from your last post to look like: -P INPUT ACCEPT -P FORWARD ACCEPT -P OUTPUT ACCEPT It still had the same effect.

I don't think it's an issue with a firewall though. After these changes it seems to not change very much only with connecting to the realmd. Maybe it might be with realmd communicating with mangosd?

Okay just tried it I am having the same problem of connecting to the game server.

want me to post what happens?

When I try this I cannot start my wow, mangosd, realmd sucessfully I tried it several times. What do you think could be the problem?

-P INPUT DROP -P FORWARD DROP -P OUTPUT DROP -N INBOUND -N LOG_FILTER -N LSI -N LSO -N NR -N OUTBOUND -A INPUT -s 192.168.0.1/32 -p tcp -m tcp ! --tcp-flags FIN,SYN,RST,ACK SYN -j ACCEPT -A INPUT -s 192.168.0.1/32 -p udp -j ACCEPT -A INPUT -s 205.171.3.25/32 -p tcp -m tcp ! --tcp-flags FIN,SYN,RST,ACK SYN -j ACCEPT -A INPUT -s 205.171.3.25/32 -p udp -j ACCEPT -A INPUT -i lo -j ACCEPT -A INPUT -p icmp -m icmp --icmp-type 8 -m limit --limit 1/sec -j ACCEPT -A INPUT -p icmp -m icmp --icmp-type 0 -m limit --limit 1/sec -j ACCEPT -A INPUT -p udp -m udp --dport 33434 -j ACCEPT -A INPUT -p icmp -m icmp --icmp-type 3 -j ACCEPT -A INPUT -p icmp -j LSI -A INPUT ! -s 192.168.0.0/24 -i wlan0 -j NR -A INPUT -d 255.255.255.255/32 -i wlan0 -j DROP -A INPUT -d 192.168.0.255/32 -j DROP -A INPUT -s 224.0.0.0/8 -j DROP -A INPUT -d 224.0.0.0/8 -j DROP -A INPUT -s 255.255.255.255/32 -j DROP -A INPUT -d 0.0.0.0/32 -j DROP -A INPUT -m state --state INVALID -j DROP -A INPUT -f -m limit --limit 10/min -j LSI -A INPUT -i wlan0 -j INBOUND -A INPUT -j LOG_FILTER -A INPUT -j LOG --log-prefix "Unknown Input" --log-level 6 -A FORWARD -p icmp -m icmp --icmp-type 8 -m limit --limit 1/sec -j ACCEPT -A FORWARD -p icmp -m icmp --icmp-type 0 -m limit --limit 1/sec -j ACCEPT -A FORWARD -p udp -m udp --dport 33434 -j ACCEPT -A FORWARD -p icmp -m icmp --icmp-type 3 -j ACCEPT -A FORWARD -p icmp -j LSI -A FORWARD -j LOG_FILTER -A FORWARD -j LOG --log-prefix "Unknown Forward" --log-level 6 -A OUTPUT -s 192.168.0.7/32 -d 192.168.0.1/32 -p tcp -m tcp --dport 53 -j ACCEPT -A OUTPUT -s 192.168.0.7/32 -d 192.168.0.1/32 -p udp -m udp --dport 53 -j ACCEPT -A OUTPUT -s 192.168.0.7/32 -d 205.171.3.25/32 -p tcp -m tcp --dport 53 -j ACCEPT -A OUTPUT -s 192.168.0.7/32 -d 205.171.3.25/32 -p udp -m udp --dport 53 -j ACCEPT -A OUTPUT -o lo -j ACCEPT -A OUTPUT -s 224.0.0.0/8 -j DROP -A OUTPUT -d 224.0.0.0/8 -j DROP -A OUTPUT -s 255.255.255.255/32 -j DROP -A OUTPUT -d 0.0.0.0/32 -j DROP -A OUTPUT -m state --state INVALID -j DROP -A OUTPUT -o wlan0 -j OUTBOUND -A OUTPUT -j LOG_FILTER -A OUTPUT -j LOG --log-prefix "Unknown Output" --log-level 6 -A INBOUND -p tcp -m state --state RELATED,ESTABLISHED -j ACCEPT -A INBOUND -p udp -m state --state RELATED,ESTABLISHED -j ACCEPT -A INBOUND -j LSI -A LSI -j LOG_FILTER -A LSI -p tcp -m tcp --tcp-flags FIN,SYN,RST,ACK SYN -m limit --limit 1/sec -j LOG --log-prefix "Inbound " --log-level 6 -A LSI -p tcp -m tcp --tcp-flags FIN,SYN,RST,ACK SYN -j DROP -A LSI -p tcp -m tcp --tcp-flags FIN,SYN,RST,ACK RST -m limit --limit 1/sec -j LOG --log-prefix "Inbound " --log-level 6 -A LSI -p tcp -m tcp --tcp-flags FIN,SYN,RST,ACK RST -j DROP -A LSI -p icmp -m icmp --icmp-type 8 -m limit --limit 1/sec -j LOG --log-prefix "Inbound " --log-level 6 -A LSI -p icmp -m icmp --icmp-type 8 -j DROP -A LSI -m limit --limit 5/sec -j LOG --log-prefix "Inbound " --log-level 6 -A LSI -j DROP -A LSO -j LOG_FILTER -A LSO -m limit --limit 5/sec -j LOG --log-prefix "Outbound " --log-level 6 -A LSO -j REJECT --reject-with icmp-port-unreachable -A NR -s 0.0.0.0/8 -d 192.168.0.0/24 -i wlan0 -j LSI -A NR -s 10.0.0.0/8 -d 192.168.0.0/24 -i wlan0 -j LSI -A NR -s 127.0.0.0/8 -d 192.168.0.0/24 -i wlan0 -j LSI -A NR -s 169.254.0.0/16 -d 192.168.0.0/24 -i wlan0 -j LSI -A NR -s 172.16.0.0/12 -d 192.168.0.0/24 -i wlan0 -j LSI -A NR -s 192.0.0.0/24 -d 192.168.0.0/24 -i wlan0 -j LSI -A NR -s 192.0.2.0/24 -d 192.168.0.0/24 -i wlan0 -j LSI -A NR -s 192.168.0.0/16 -d 192.168.0.0/24 -i wlan0 -j LSI -A NR -s 198.18.0.0/15 -d 192.168.0.0/24 -i wlan0 -j LSI -A NR -s 198.51.100.0/24 -d 192.168.0.0/24 -i wlan0 -j LSI -A NR -s 203.0.113.0/24 -d 192.168.0.0/24 -i wlan0 -j LSI -A NR -s 224.0.0.0/4 -d 192.168.0.0/24 -i wlan0 -j LSI -A NR -s 240.0.0.0/4 -d 192.168.0.0/24 -i wlan0 -j LSI -A OUTBOUND -p icmp -j ACCEPT -A OUTBOUND -p tcp -m state --state RELATED,ESTABLISHED -j ACCEPT -A OUTBOUND -p udp -m state --state RELATED,ESTABLISHED -j ACCEPT -A OUTBOUND -j ACCEPT Well here you go!

Should they be in the root folder? When I changed them from the /etc/ folder I got an error. Also, all three of the conf files are set to the loopback(127.0.0.1). Would you like me to post anymore information on this? Can you tell me if the ports are correct? [mangosd.conf] LoginDatabaseInfo = "127.0.0.1;3306;root;****;zp_realm" WorldDatabaseInfo = "127.0.0.1;3306;root;****;zp_world" CharacterDatabaseInfo = "127.0.0.1;3306;root;***;zp_characters" ... WorldServerPort = 8085 [realmd.conf] LoginDatabaseInfo = "127.0.0.1;3306;root;****;zp_realm" ... RealmServerPort = 3724 [scriptdevzero.conf] ScriptDevZeroDatabaseInfo = "127.0.0.1;3306;root;****;zp_scripts"

Ok, I followed your instructions however it was of no luck. Still the same issue I'm having. I CAN connect to my localhost server but only the realmd. After I connect I'm stuck at "handshaking" and if I click cancel it takes me to the available servers which it lists my server "Argent Dawn" online (if mangosd if running if mangosd is not running than it lists it as offline). After this I am stuck at "connecting to game server." I just can't connect to the actual "game server" which is the mangosd. I hope this explains my situation a bit more. Thank you for all of your help so far. Those ideas are definitely ones that would have never occurred to me and is very helpful! Thank you!

UPDATE: So I noticed that when I start or stop mangosd I am able to see the server online when it's running and offline when it's not. So I know now that realmd and mangosd are communicating but i am just not able to successfully log in.

I have tested running WoW with wine when I connected to a private 1.12 server a little while ago. I was personally surprised on the compatibility of wine with a lot software of today. If it's a popular piece of software (Not brand spanking new) it usually works without a hitch with a update. Oh, did you get yours running well? I saw some of your other posts about making a MaNGOS Zero server as well.