COMPLETE PUBLIC SERVER SETUP - Jan-2011

[dranovir45]

Now lets say i did miss something (cus i did ><) is it easy fix to just do it and a fix will happens or what exactly?

[dranovir45]

Ok, i typed my IP into the internet browser ( im with AT&T ) anyone work with them that knows how to forwards ports on the page, if so plesae let me know.

[Zandig]

Compiling with MySQL Server 5.5.9 will fail as it's not supported.
I use 5.1.56 (32 bit version) which works fine.

[Bamzal]

Thank you Zandig and lerxst2112.

I now have a legit looking zlib but still running into the same errors:
"mysqlclient.lib(inflate.obj) : error LNK2005: _inflate already defined in zlib.lib(zlib1.dll)"

My thought is that MySQL is now the problem, and Zandig you just confirmed my assumption.

I will try downgrading right now and report back.

[dranovir45]

Can someone dummy down this part for me please ;; i use AT&T 2wire router and such and watching guides, it makes sense (none of these guides are about eqemu making but for other games and the general idea on how to open ports and such) but the numbers posted here make no sense on where they are supposed to go " Log in to your router and you need to forward the following ports to the internal
ip of your server computer : (These are the ones that worked for me)

5998, 5999
7000 to 7100 (Port Range Forwarding is essential for this)
9000

[Bamzal]

Originally Posted by dranovir45

Can someone dummy down this part for me please ;; i use AT&T 2wire router and such and watching guides, it makes sense (none of these guides are about eqemu making but for other games and the general idea on how to open ports and such) but the numbers posted here make no sense on where they are supposed to go " Log in to your router and you need to forward the following ports to the internal
ip of your server computer : (These are the ones that worked for me)

5998, 5999
7000 to 7100 (Port Range Forwarding is essential for this)
9000

Those are the TCP and UDP port numbers that you should allow pass-through from your router to your server's local IP address.

You need to log onto your routers configuration page - a webpage. You type the local IP address of your router into a web browser to access it.

Find the local IP address of your router by going start>run>cmd then command prompt opens then type "ipconfig /all" and look for the IP associated with "Default Gateway" and that is the local IP address of your router (the one you type into your web browser). *unless you are not using a router but directly connecting your PC to a modem*


When I log in to my router's configuration page it has a section to specify port ranges and local IP addresses to allow the port open for.

Ie:
Allow / Enabled
192.168.1.1 BOTH (as in TCP and UDP) 7000 - 7100
and repeat for the others.

Hope that helps.


Edit: I just saw your picture...

Application Name is just a name for those saved settings on your router. Since you need multiple I just call mine Eq1, Eq2, etc. They have no bearing.

Looks like you cannot select "Both" so you need to repeat the process to open TCP and UDP, I am not sure which is required exactly.

Timeout I suggest using the default, same with Port Mapping. The router does not need to do any source/destination mapping.

5998 would go in the "From" Port(or Range) field, and 5999 would go in the "To" field.

Save the settings, then repeat the setup but with a different name and put 9000 into both "From" and "To" fields.

Keep repeating that process until all ports you need are open.

[dranovir45]

What am i supposed to do with the 7000-7100 thing though, i dont see anywhere for me to tweak those anywhere

[Bamzal]

Got it working... 5/5 successful.

Uninstalled MySQL 5.5 and installed 5.1. Right off the bat things were looking much better - MySQL actually came with that "/lib/opt/" folder.

However then I ran into errors using the zlib that I was recently suggested trying.

I had to go back to the original zlib download from the original post, download that package even though it only contains a "zdll.lib" and not a "zlib.lib". Then I just renamed "zdll.lib" to "zlib.lib" and it started working fine. Using that other zlib that you suggested lerxst2112 was causing errors in zconf.h while compiling.


So my understanding is that part of my problem was that I accidentally downloaded a newer version of MySQL.

But another part of the problem is that the suggested zlib download has since changed and you actually need to rename the "zdll.lib" to "zlib.lib" in the lib folder, in order for it to work.

Thanks for all the help again.
-Bamzal