Database-LF

[iStigma]

is there a way to see a password via the database?

 

for example when im going to "Accounts" table it shows: d0IvxPcplEMspUranhXNhHQtaNs=

 

#2

Ive got a homehosted server for me only,log in-gameserver is on,i cant log..whats the prob?

 

l2ini is 127.0.0.1 413.

[Trance]

  On 8/12/2013 at 8:56 PM, iStigma said:

is there a way to see a password via the database?

 

for example when im going to "Accounts" table it shows: d0IvxPcplEMspUranhXNhHQtaNs=

 

Some of them can be decrypted using this.

[iStigma]

  On 8/12/2013 at 8:58 PM, Tяαnce said:

Some of them can be decrypted using this.

 

TY,#2 Added.

[Intrepid]

  On 8/12/2013 at 9:02 PM, iStigma said:

TY,#2 Added.

 

can be many things, ports doesnt open, firewalls blocks it, wrong ip config

[iStigma]

  On 8/13/2013 at 5:20 AM, Intrepid said:

can be many things, ports doesnt open, firewalls blocks it, wrong ip config

 

ports should be opened for 127.0.0.1 ip?configs are fine,firewall disabled.

[Intrepid]

  On 8/13/2013 at 6:14 AM, iStigma said:

ports should be opened for 127.0.0.1 ip?configs are fine,firewall disabled.

 

You dont use localhost for external communication only for internal. Check every necessary port with an openportchecker and paste here your serverconfigs.

[iStigma]

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

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

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

# If False, the licence (after the login) will not be shown
# It is highly recomended for Account Seciurity 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

# Database Settings
URL=jdbc:mysql://localhost/l2jdb
#URL=jdbc:hsqldb:hsql://localhost/l2jdb
#URL=jdbc:sqlserver://localhost/database=l2jdb/user=sa/password=

# Security Settings
Login = root
Password = 
MaximumDbConnections = 50
MaximumStateMents = 100
MaxPoolSize = 50
MinPoolSize = 10
AquireIncrement = 1
IdleConnectionTest = 10800
MaxIdleTime = 0

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

# ------------------------------------------------ #
#       High Performance for your Database         #
# Auto Analyze, Check, Optimize and Repair tables  #
#        Pack with High Performance        #
# ------------------------------------------------ #
# If True, starting login analyze tables of LS
DatabaseAutoAnalyze = True
# If True, starting login check tables of LS
DatabaseAutoCheck = True
# If True, starting login optimize tables of LS
DatabaseAutoOptimize = True
# If True, starting login repair tables of LS
DatabaseAutoRepair = True

# ==============================================================
# 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 = 250
NormalConnectionTime = 700
FastConnectionTime = 350
MaxConnectionPerIP = 700

[Intrepid]

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

ExternalHostname = *

 

you need your wan ip here.

[iStigma]

  On 8/13/2013 at 7:07 AM, Intrepid said:

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

ExternalHostname = *

 

you need your wan ip here.

my ip?

 

its on my local pc for me and only.

[Intrepid]

  On 8/13/2013 at 7:09 AM, iStigma said:

my ip?

 

yes

[iStigma]

  On 8/13/2013 at 7:10 AM, Intrepid said:

yes

 

still cannot connect.

[Intrepid]

  On 8/13/2013 at 7:11 AM, iStigma said:

still cannot connect.

 

Check your ports.

[iStigma]

Ports should be opened for a local server?with other files i was able to login.

[Intrepid]

  On 8/13/2013 at 7:14 AM, iStigma said:

Ports should be opened for a local server?with other files i was able to login.

 

ports should be open if you want any external ip to connect.

[iStigma]

  On 8/13/2013 at 7:15 AM, Intrepid said:

ports should be open if you want any external ip to connect.

 

i want for me only

[Intrepid]

  On 8/13/2013 at 7:17 AM, iStigma said:

i want for me only

 

ohh than you should be able to connect with the default settings, do you get any error when trying to connect?