Problem with Navicate

[KpyT]

Hi
Guys plz help >.<

I cant open conections in navicate :S
Can u explain how to do it?
Problem with Wampserver?
Screenshot

Ty

[GodKratos]

You trying to access that from a remote location or from the localhost?

If remote you will need to open the database from the local source and set up access permissions for remote accounts that do not specify a host.

ie create user@ instead of user@localhost

[MELERIX]

Wampserve does not use password (by default), you need define the password manually

[KpyT]

thnx


Fixed it^^
Navicate working now.
But still have a problem...

When i try to registr game server get this



Fllowed steps from here http://forum.l2jdp.com.com/f324/guide-sp ... 2j-350127/


Dunno what i'm doing wrong, but it saying that db doest exist :S

Maybe someone know how to fix it?

Thnx
KpyT

[GodKratos]

settings wrong in server.properties maybe?
Or DP SQL not installed right?

[CyberAdmin]

Nederlands:

Neem de tijd om alles te bekijken, en goed te zetten

Code: Select all

# This is the server configuration file. Here you can set up the connection for your server.
# Usually you have to change the ExternalHostname option to
# - 127.0.0.1 (if you want to play alone / testing purpose)
# - LAN IP* (if you want to play from another computer in the network)
# - WAN IP** (if you want to play with friends over internet)
# - Questions? => http://l2jserver.com
#
# * = If you want to get your LAN IP, simply choose "Start" => "Run..." then type "cmd" => "ipconfig"
# **= If you want to get you WAN IP, visit http://www.whatismyip.com
# ===================================================================================================
 
# ================================================================
# General server setting !!! REQUIRED to configure to everyone !!!
# ================================================================

# Bind ip of the gameserver, use * to bind on all available IPs
GameserverHostname=*
GameserverPort=7777

# 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=*

# 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=*

# The Loginserver host and port
LoginPort=9014
LoginHost=127.0.0.1

# This is the server id that the gameserver will request (i.e. 1 is Bartz)
RequestServerID = 3
# If set to true, the login will give an other id to the server  if the requested id is allready reserved
AcceptAlternateID = True

# Database info
Driver=com.mysql.jdbc.Driver
#Driver=org.hsqldb.jdbcDriver
#Driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
URL=jdbc:mysql://localhost/l2jdb
#URL=jdbc:hsqldb:hsql://localhost/l2jdb
#URL=jdbc:sqlserver://localhost/database=l2jdb/user=sa/password=
Login=root
Password=
MaximumDbConnections=100

# Datapack root directory, defaults to current directory from which the server is started
# DatapackRoot = C:/Work/tmp/DataPack

# Define character name template
# Example to use only : CnameTemplate=[A-Z][a-z]{3,3}[A-Za-z0-9]*
# will allow names with first capital letter, next three small letters,
# and any (capital or not) letter or number, like ZbigN1eW
# Most rational to have CnameTemplate=[A-Z][a-z]*
# meaning names only of letters with first one capital, like Zbigniew
# Default .* - any namy of any symbols
CnameTemplate=.*
PetNameTemplate=.*

# Maximum number of chars per account - Default 7 (0 = unlimited [7 is the client limit])
CharMaxNumber = 7

# Define how many players are allowed to play simultaneously on your server.
MaximumOnlineUsers=100


# Minimum and maximum protocol revision that server allow to connect.
# You must keep MinProtocolRevision <= MaxProtocolRevision.
MinProtocolRevision = 828
MaxProtocolRevision = 828

Zet hier als je het publiek wilt laten connecten jou ip:

Code: Select all

GameserverHostname=whatsmyip.net External ip

ExternalHostname=whatsmyip.net External ip

InternalHostname=127.0.0.1 of 192.168.0.1 of je external ip als je geen router hebt.

LoginHost=127.0.0.1 of 192.168.0.1 of je external ip als je geen router hebt.

URL=jdbc:mysql://localhost/l2jdb <----- erg belangrijk waar l2jdb staat dat is je database en of hoe je je db hebt genoemd bv MijnDb dan zet je dit:
URL=jdbc:mysql://localhost/MijnDb

Password= <----- meestal is dit root maar als je je mysql anders heb gezet met ander paswoord dan zet je pass van mysql.

je login precies hetzelfde....

Externalip is externe ip

Internal ip = 127.0.0.1 of 192.168.0.1 of je external ip

loginhost 127.0.0.1 192.168.0.1 of je external ip

je komt er nu wel uit denk ik.

How to install navicat:
Instaleer je navicat als volgt...

eenmaal geinstalleerd moet je connectie maken...

1ste blok leeg
2de blok = localhost
3de blok = meestal pass

zet je poort op 3306 en weet zeker dat je dit ook op je mysql heb gezet and neem poort van mysql.

als je router hebt open deze poorten in je router

2106 login
9014 login
7777 gameserver
7778 telnet
3306 navicat en mysql

Ik hoop dat je hier ff genoeg aan heb....

Greets
CyberAdmin

Now in english is much to translate so i leave it all to your imagination what i just told him

Basicly in dutch how to set properties and navicat so dont worry i am rude or something ^^

Ciao Ciao

[KpyT]

Ty Cyber,

Huh still doestn work :S

Code: Select all

# This is the server configuration file. Here you can set up the connection for your server.
# Usually you have to change the ExternalHostname option to
# - 127.0.0.1 (if you want to play alone / testing purpose)
# - LAN IP* (if you want to play from another computer in the network)
# - WAN IP** (if you want to play with friends over internet)
# - Questions? => http://l2jserver.com
#
# * = If you want to get your LAN IP, simply choose "Start" => "Run..." then type "cmd" => "ipconfig"
# **= If you want to get you WAN IP, visit http://www.whatismyip.com
# ===================================================================================================

# ================================================================
# General server setting !!! REQUIRED to configure to everyone !!!
# ================================================================

# This is transmitted to the clients connecting from an external network, so it has to be a public IP or resolvable hostname
ExternalHostname=(sample just my ip=84.108.***.**)

# This is transmitted to the client from the same network, so it has to be a local IP or resolvable hostname
InternalHostname=127.0.0.1

# Bind ip of the LoginServer, use * to bind on all available IPs
LoginserverHostname=127.0.0.1
LoginserverPort=2106
# How many times you can provide an invalid account/pass before the IP gets banned
LoginTryBeforeBan=10
# Time you won't be able to login back again after LoginTryBeforeBan tries to login. Provide a value in seconds. Default 10min. (600)
LoginBlockAfterBan=600
GMMinLevel=100

# The address on which login will listen for GameServers, use * to bind on all available IPs
LoginHostname=127.0.0.1

# The port on which login will listen for GameServers
LoginPort=9014

# If set to true any GameServer can register on your login's free slots
AcceptNewGameServer = False

# If false, the licence (after the login) will not be shown
# It is highly recomended for Account Security to leave this option as defalut (True)
ShowLicence = True

# Database info
Driver=com.mysql.jdbc.Driver
#Driver=org.hsqldb.jdbcDriver
#Driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
URL=jdbc:mysql://127.0.0.1/l2jdb
#URL=jdbc:hsqldb:hsql://1207.0.0.1/l2jdb
#URL=jdbc:sqlserver://127.0.0.1/database=l2jdb/user=sa/password=
Login=root
Password=(MY PASSWORD)
MaximumDbConnections=10

# Useable values: "true" - "false", use this option to choose whether accounts will be created
# automatically or not.
AutoCreateAccounts=true

# The delay in minutes after which the login updates the gameservers IP's (usefull when their ip is dynamic)
IpUpdateTime=15


# ==============================================================
# Test server setting, shoudnt be touched in online game server
# ==============================================================

Debug = False
Assert = False
Developer = False

# Enforce GG Authorization from client
# Login server will kick client if client bypassed GameGuard authentication
ForceGGAuth=True

#FloodProtection. time in ms
EnableFloodProtection=True
FastConnectionLimit=15
NormalConnectionTime=700
FastConnectionTime=350
MaxConnectionPerIP=50

That right? loginserver...

Get the same :S




Do u maybe know a good guid for instalation?

Can u plz set full example of loginserver and server prop.

Ty,
KpyT

[CyberAdmin]

Gameserver.properties

Code: Select all

# This is the server configuration file. Here you can set up the connection for your server.
# Usually you have to change the ExternalHostname option to
# - 127.0.0.1 (if you want to play alone / testing purpose)
# - LAN IP* (if you want to play from another computer in the network)
# - WAN IP** (if you want to play with friends over internet)
# - Questions? => http://l2jserver.com
#
# * = If you want to get your LAN IP, simply choose "Start" => "Run..." then type "cmd" => "ipconfig"
# **= If you want to get you WAN IP, visit http://www.whatismyip.com
# ===================================================================================================
 
# ================================================================
# General server setting !!! REQUIRED to configure to everyone !!!
# ================================================================

# Bind ip of the gameserver, use * to bind on all available IPs
GameserverHostname=*
GameserverPort=7777

# 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=*

# 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=*

# The Loginserver host and port
LoginPort=9014
LoginHost=127.0.0.1

# This is the server id that the gameserver will request (i.e. 1 is Bartz)
RequestServerID = 3
# If set to true, the login will give an other id to the server  if the requested id is allready reserved
AcceptAlternateID = True

# Database info
Driver=com.mysql.jdbc.Driver
#Driver=org.hsqldb.jdbcDriver
#Driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
URL=jdbc:mysql://localhost/l2jdb
#URL=jdbc:hsqldb:hsql://localhost/l2jdb
#URL=jdbc:sqlserver://localhost/database=l2jdb/user=sa/password=
Login=root
Password=root
MaximumDbConnections=100

# Datapack root directory, defaults to current directory from which the server is started
# DatapackRoot = C:/Work/tmp/DataPack

# Define character name template
# Example to use only : CnameTemplate=[A-Z][a-z]{3,3}[A-Za-z0-9]*
# will allow names with first capital letter, next three small letters,
# and any (capital or not) letter or number, like ZbigN1eW
# Most rational to have CnameTemplate=[A-Z][a-z]*
# meaning names only of letters with first one capital, like Zbigniew
# Default .* - any namy of any symbols
CnameTemplate=.*
PetNameTemplate=.*

# Maximum number of chars per account - Default 7 (0 = unlimited [7 is the client limit])
CharMaxNumber = 7

# Define how many players are allowed to play simultaneously on your server.
MaximumOnlineUsers=100


# Minimum and maximum protocol revision that server allow to connect.
# You must keep MinProtocolRevision <= MaxProtocolRevision.
MinProtocolRevision = 828
MaxProtocolRevision = 828

Loginserver.properties

Code: Select all

# This is the server configuration file. Here you can set up the connection for your server.
# Usually you have to change the ExternalHostname option to
# - 127.0.0.1 (if you want to play alone / testing purpose)
# - LAN IP* (if you want to play from another computer in the network)
# - WAN IP** (if you want to play with friends over internet)
# - Questions? => http://l2jserver.com
#
# * = If you want to get your LAN IP, simply choose "Start" => "Run..." then type "cmd" => "ipconfig"
# **= If you want to get you WAN IP, visit http://www.whatismyip.com
# ===================================================================================================

# ================================================================
# General server setting !!! REQUIRED to configure to everyone !!!
# ================================================================

# This is transmitted to the clients connecting from an external network, so it has to be a public IP or resolvable hostname
ExternalHostname=127.0.0.1

# This is transmitted to the client from the same network, so it has to be a local IP or resolvable hostname
InternalHostname=127.0.0.1

# Bind ip of the LoginServer, use * to bind on all available IPs
LoginserverHostname=*
LoginserverPort=2106
# How many times you can provide an invalid account/pass before the IP gets banned
LoginTryBeforeBan=10
# Time you won't be able to login back again after LoginTryBeforeBan tries to login. Provide a value in seconds. Default 10min. (600)
LoginBlockAfterBan=600
GMMinLevel=100

# The address on which login will listen for GameServers, use * to bind on all available IPs
LoginHostname=*

# The port on which login will listen for GameServers
LoginPort=9014

# If set to true any GameServer can register on your login's free slots
AcceptNewGameServer = True

# If false, the licence (after the login) will not be shown
# It is highly recomended for Account Security to leave this option as defalut (True)
ShowLicence = True

# Database info
Driver=com.mysql.jdbc.Driver
#Driver=org.hsqldb.jdbcDriver
#Driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
URL=jdbc:mysql://localhost/l2jdb
#URL=jdbc:hsqldb:hsql://localhost/l2jdb
#URL=jdbc:sqlserver://localhost/database=l2jdb/user=sa/password=
Login=root
Password=root
MaximumDbConnections=10

# Useable values: "true" - "false", use this option to choose whether accounts will be created
# automatically or not.
AutoCreateAccounts=true

# The delay in minutes after which the login updates the gameservers IP's (usefull when their ip is dynamic)
IpUpdateTime=15


# ==============================================================
# Test server setting, shoudnt be touched in online game server
# ==============================================================

Debug = False
Assert = False
Developer = False

# Enforce GG Authorization from client
# Login server will kick client if client bypassed GameGuard authentication
ForceGGAuth=True

#FloodProtection. time in ms
EnableFloodProtection=True
FastConnectionLimit=15
NormalConnectionTime=700
FastConnectionTime=350
MaxConnectionPerIP=50

I hope this will help u out.

[KpyT]

Realy thnx,

looking better now it didnt ask for database >.<

But now i get this :S



Tried to change ports numbers :S still nothing ....


Any ideas?

[GodKratos]

Delete the space after the port number in your server properties files

[CyberAdmin]

What kind of pack are u using cause these kind of trouble starts when u begin to use custom packs.

I suggest download fresh copy of Nightly and start again.

i am running multiple servers here and that is for now on 1 crappy pc, but before i had 4 servers running.

1: Gameserver Gameserver
2: gameserver gameserver
3: gameserver gameserver
4: login database website

And this was trough an router.

So as u can see u can manage to run as much as u can as long as your connection holds it

[CyberAdmin]

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

[KpyT]

OK thnx for your sort guid

I will try it.

I'm using Wampserver is that ok?

BTW: I'm not using router!

Ty

Kpyt

[KpyT]

Thank you Cyberadmin ))

My server is up ^^




TY


KpyT

[CyberAdmin]

yw m8