Explenation on how to connect trough router and firewall:
1st:
Make sure that in your windows copy firewall system these ports are in exceptions and ports.
In advanced/localhost open these ports..
2106 login ip if u are using router 192.168.0.1 local 127.0.0.1 external
www.whatsmyip.net
9014 login ip if u are using router 192.168.0.1 local 127.0.0.1 external
www.whatsmyip.net
7777 Gameserver if u are using router 192.168.0.1 local 127.0.0.1 external
www.whatsmyip.net
7778 Telnet ip if u are using router 192.168.0.1 local 127.0.0.1 external
www.whatsmyip.net
3306 Navicat ip if u are using router 192.168.0.1 local 127.0.0.1 external
www.whatsmyip.net
Then u have the option tab exception:
Open these 5 things there to.
2nd:
Now check your router stats:
login to your router at 192.168.0.1 and check your firewall status.
Add these exceptions to your firewall rules.
2106 login set ip to internal ip ussualy when only 1 pc is used it is 192.168.0.2 range to 999 or 1.2
9014 login set ip to internal ip ussualy when only 1 pc is used it is 192.168.0.2 range to 999 or 1.2
7777 gameserver set ip to internal ip ussualy when only 1 pc is used it is 192.168.0.2 range to 999 or 1.2
7778 telnet set ip to internal ip ussualy when only 1 pc is used it is 192.168.0.2 range to 999 or 1.2
3306 navicat and mysql set ip to internal ip ussualy when only 1 pc is used it is 192.168.0.2 range to 999 or 1.2
3th:
Reinstall mysql and navicat:
4th:
Use tools folder and then install your Database with database_installer.exe
If u did this, check your database if it is installed correctly.
Be sure to use either l2jdb or if u have your own name example MijnDb set in the database installer is asked databasename= MijnDb
5th:
When u have done this start 1st your login and see if it connects to your localhost.
Leave this standing if u run login and gameserver at localhost:
URL=jdbc:mysql://localhost/l2jdb
change only the last bit if u have set anothername for your database example MijnDb it becomes:
URL=jdbc:mysql://localhost/MijnDb
Make sure External ip and Internal ip are set correct
Make sure LoginHost is set correct otherwise no servers or login can connect trough firewall or open ports wich u set earlier.
example if u use router:
# This is transmitted to the clients connecting from an external network, so it has to be a public IP or resolvable hostname
# If this ip is resolvable by Login just leave *
ExternalHostname=whatsmyip.net
# This is transmitted to the client from the same network, so it has to be a local IP or resolvable hostname
# If this ip is resolvable by Login just leave *
InternalHostname=192.168.0.2 <---- or whatrever your internal ip is.
# The Loginserver host and port
LoginPort=9014
LoginHost=127.0.0.1 <---- becomes 192.168.0.2 or whatever your internal ip say's
Do the same in loginserver.properties make sure all ip's are set correct.
If u are using a router BEWARE!!!!!! everytime u switch it off it takes another ip when u switch it on again.
So if u had before external ip 83.83.24.24 <-- example ip it will become either 83.83.24.36 or whatever u catch my drift i hope.
So whatever u do if u are wanted to run a server... DO NOT SWITCH OF ROUTER.
Lets see how far u come with this cause my hands are hurting from typing
