nazer

January 10, 2012

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.

January 10, 2012

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!

January 7, 2012

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.

January 5, 2012

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

January 4, 2012

This is the output of it.

auto lo

iface lo inet loopback

January 3, 2012

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.

January 3, 2012

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?

January 3, 2012

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

January 3, 2012

want me to post what happens?

January 3, 2012

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?

January 3, 2012

-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!

January 3, 2012

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"

January 2, 2012

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!

January 2, 2012

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.

January 2, 2012

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.

January 2, 2012

I'm running lubuntu and running WoW with wine. I don't believe I should have a issue with my firewall. They both the realmd and mangosd are set to 127.0.0.1

I'm pretty sure both of of these should be set to 127.0.0.1 for a localhost play.

Maybe I'm not quite understanding your statement. Explain please!

January 2, 2012

It doesn't eat my cpu. It starts up quite fast actually. It sits around 30-40%

January 2, 2012

I made sure of the things you suggested However it did not change anything.

I know there is a website that allows one to upload data files/systemlogs/memory dumps/..etc but after a while of searching I gave up. So here is my start up for the server . There area few errors but they seem little to nothing. It fully completes and says the maps have been loaded and all.

[== english ==]

2012-01-01 20:08:54 MaNGOS Zero/ (* * Revision 1809 - *) for Linux_x64 (little-endian) [world-daemon]

2012-01-01 20:08:54 <Ctrl-C> to stop.

2012-01-01 20:08:54

MM MM MM MM MMMMM MMMM MMMMM

MM MM MM MM MMM MMM MM MM MMM MMM

MMM MMM MMM MM MMM MMM MM MM MMM

MM M MM MMMM MM MMM MM MM MMM

MM M MM MMMMM MM MMMM MMM MM MM MMM

MM M MM M MMM MM MMM MMMMMMM MM MM MMM

MM MM MMM MM MM MM MMM MM MM MMM

MM MM MMMMMMM MM MM MMM MMM MM MM MMM MMM

MM MM MM MMM MM MM MMMMMM MMMM MMMMM

MM MMM http://getmangos.eu

MMMMMM

2012-01-01 20:08:54 Using configuration file /home/naz/Desktop/mangos-zero-server/etc/mangosd.conf.

2012-01-01 20:08:54 World Database total connections: 2