Account Manager error

[masashige]

If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision Number:4344
L2JDP Revision Number:7589

Hi all, I followed all the steps to create a l2j server. Login and Gameserver run well but I can login in game only with autocreate account system. In fact the Account manager( startSQLAccountManager.bat ) give me an error when I try to create an account or change the access level. This is the scrren of error:

Code: Select all

[img]http://img689.imageshack.us/img689/549/errorpc.jpg[/img]

Plz help me, I think it is about MySql, but i don't know how to work....

[dinor]

right click > edit
does your startSQLAccountManager.bat looks the same as mine?

Code: Select all

@echo offclstitle L2J - SQL Account Managercolor 17java -Djava.util.logging.config.file=console.cfg -cp ./../libs/*;l2jlogin.jar com.l2jserver.accountmanager.SQLAccountManager 2> NULif %errorlevel% == 0 (echo.echo Execution succesfulecho.) else (echo.echo An error has ocurred while running the L2J Account Manager!echo.echo Possible reasons for this to happen:echo.echo - Missing .jar files or ../libs directory.echo - MySQL server not running or incorrect MySQL settings:echo    check ./config/loginserver.propertiesecho - Wrong data types or values out of range were provided:echo    specify correct values for each required fieldecho.)pause

in case that it does, is the startSQLAccountManager.bat in the login folder?

[masashige]

My file is the same of your.Same text... And it is in Login folder. Other suggestions?

This problem can be linked with an error of database installation from database_installer.bat that I have ignored?

Code: Select all

[img]http://img686.imageshack.us/img686/2296/errordatabaseinstall.jpg[/img]

[dinor]

try post your account manager error log and the database install error log.
It seems to be something wrong with your database.

[masashige]

where can I see the logs?

[dinor]

In folder tools must be a txt which say errors (for the database installation)
and in folder login/log you will find some logs, find out which say about the errors you had and post them here.

[masashige]

There aren't logs of errors.... Looking the screens that I posted u can help me?

[dinor]

Check the vars.txt in tools folder and check all your info if are right.

One more i can see is that you haven't created a database for community board. go in MySQL and create a database called l2jcb.

now try reinstall database with database_installer.bat

[masashige]

I have resolved the Database installer problem... The installation is successful and database server is installed. The account manager error remains... If it is help this is vars.txt file:

Code: Select all

 @echo off set config_version=2 set cmode=cset safe_mode=1 set mysqlPath=C:\Programmi\MySQL\MySQL Server 5.0\bin\mysql.exeset mysqlBinPath=C:\Programmi\MySQL\MySQL Server 5.0\binset mysqldumpPath=C:\Programmi\MySQL\MySQL Server 5.0\bin\mysqldump.exeset lsuser=rootset lspass=*******set lsdb=l2jdbset lshost=localhost set cbuser=rootset cbpass=b*******set cbdb=l2jcbset cbhost=*******set gsuser=rootset gspass=******set gsdb=l2jdbset gshost=localhostset logdir=.set backup=. 

But I think that vars.txt concern only the database installation,right?
I think we must focus on this:

Code: Select all

echo An error has ocurred while running the L2J Account Manager!echo.echo Possible reasons for this to happen:echo.echo - [b]Missing .jar files or ../libs directory.[/b]echo - [b]MySQL server not running or incorrect MySQL settings:[/b]echo    [b]check ./config/loginserver.properties[/b]echo - [b]Wrong data types or values out of range were provided:[/b]echo    [b]specify correct values for each required field[/b] 

I don't understand what's problem in MySql or /libs directory...
Can u post or attach your loginserver.properties plz?

[surskis]

this is mine login.properties

Code: Select all

# ---------------------------------------------------------------------------# Login Server Settings# ---------------------------------------------------------------------------# This is the server configuration file. Here you can set up the connection information for your server.# This was written with the assumption that you are behind a router.# Dumbed Down Definitions...# LAN (LOCAL area network) - typically consists of computers connected to the same router as you.# WAN (WIDE area network) - typically consists of computers OUTSIDE of your router (ie. the internet).# x.x.x.x - Format of an IP address. Do not include the x'es into settings. Must be real numbers.# ---------------------------------------------------------------------------# Networking# ---------------------------------------------------------------------------# This is transmitted to the clients connecting from an external network, so it has to be a public IP or resolvable hostname# Common settings...# 127.0.0.1 - If you are playing alone on a test server# 192.168.x.x - This is if you are on a 192.168.x.x type network (behind a standard consumer router) and want other computers from JUST the internal network to be able to connect# x.x.x.x - WAN IP obtained from http://www.whatismyip.com/. This is if you want people outside your internal network to be able to connect to your server.# ---------------------------------------------------------------------------# Default: 127.0.0.1ExternalHostname = 82.#.#.# # ---------------------------------------------------------------------------# This is transmitted to the client from the same network, so it has to be a local IP or resolvable hostname.# This can be the internal IP such as 127.0.0.1 or the computer's IP such as 192.168.x.x.# ---------------------------------------------------------------------------# Default: 127.0.0.1InternalHostname = 82.#.#.# # ---------------------------------------------------------------------------# If you are behind a router which using its own local IP for Port Forwarding then set this to the routers# local IP if you want people outside your internal network to be able to connect to your server.# ---------------------------------------------------------------------------# RouterHostname = # Bind ip of the LoginServer, use * to bind on all available IPs# Default: *LoginserverHostname = 82.#.#.# # Default: 2106LoginserverPort = 2106 # The address on which login will listen for GameServers, use * to bind on all available IPs# Default: *LoginHostname = 82.#.#.# # The port on which login will listen for GameServers# Default: 9014LoginPort = 9014 # The delay in minutes after which the login updates the gameservers IP's (usefull when their ip is dynamic)# Default: 15IpUpdateTime = 15 # ---------------------------------------------------------------------------# Security# ---------------------------------------------------------------------------# Default: TrueLogLoginController = True # How many times you can provide an invalid account/pass before the IP gets banned.# Default: 10LoginTryBeforeBan = 10 # Time you won't be able to login back again after LoginTryBeforeBan tries to login.# Default: 600 (10 minutes)LoginBlockAfterBan = 600 # If set to True any GameServer can register on your login's free slots# Default: FalseAcceptNewGameServer = False # Enforce GameGuard authorization from client?# If True, login server will kick client if the client bypassed GameGuard authentication.# Default: FalseForceGGAuth = False # Flood Protection. All values are in MILISECONDS.# Default: TrueEnableFloodProtection = True # Default: 15FastConnectionLimit = 15 # Default: 700NormalConnectionTime = 700 # Default: 350FastConnectionTime = 350 # Default: 50MaxConnectionPerIP = 50 # ---------------------------------------------------------------------------# Database# ---------------------------------------------------------------------------# Specify the appropriate driver and url for the database you're using.# Examples:# Driver = com.mysql.jdbc.Driver (default)# Driver = org.hsqldb.jdbcDriver# Driver = com.microsoft.sqlserver.jdbc.SQLServerDriverDriver = com.mysql.jdbc.Driver # Database URL# URL = jdbc:mysql://localhost/l2jdb (default)# URL = jdbc:hsqldb:hsql://localhost/l2jdb# URL = jdbc:sqlserver://localhost/database = l2jdb/user = sa/password =URL = jdbc:mysql://localhost/l2jlogin # Database user info (default is "root" but it's not recommended)Login = root # Database connection passwordPassword = ************ # Default: 10MaximumDbConnections = 10 # Default: 0MaximumDbIdleTime = 0 # ---------------------------------------------------------------------------# Misc.# ---------------------------------------------------------------------------# If False, the license (after the login) will not be shown.# Default: TrueShowLicence = True # Default: TrueAutoCreateAccounts = False # ---------------------------------------------------------------------------# Developer Settings# ---------------------------------------------------------------------------# Default: FalseDebug = False # Default: FalseAssert = False # Default: FalseDeveloper = False  

[masashige]

this is mine login.properties

Thx!I compared with my login.properties and my file have the same data of your... So this is not the problem... Other ideas?

[dinor]

your vars.txt

Code: Select all

lsdb=l2jdb

if your loginserver.properties is like this

Code: Select all

URL = jdbc:mysql://localhost/l2jlogin

Then thats most probably your problem (but your login server shouldn't start... hmm strange)

change it to be like this

Code: Select all

URL = jdbc:mysql://localhost/l2jdb

Else this don't work, then the only possible is for you to have some corrupted jar file.
Try to recompile your server else if you don't know how, just download a nightly build from here http://www.l2jserver.com/nightly/ and try again.

[masashige]

your vars.txt

Code: Select all

lsdb=l2jdb

if your loginserver.properties is like this

Code: Select all

URL = jdbc:mysql://localhost/l2jlogin

Then thats most probably your problem (but your login server shouldn't start... hmm strange)

change it to be like this

Code: Select all

URL = jdbc:mysql://localhost/l2jdb

Yes, I already tried this correction, and the result is an error at the start of login server...
Eventually, whereas gameserver and loginserver run, I will create and change the accounts using Navicat working on database.. I thing it is the only solution...

[dinor]

lets take it from the beggining.

Make these databases with navicat
l2jls
l2jgs
l2jcb

Now edit your loginserver.properties (in login/config)

Code: Select all

URL = jdbc:mysql://localhost/l2jls

the server.properties (in gameserver/config)

Code: Select all

URL = jdbc:mysql://localhost/l2jgs

set the mysql database passwords in both files

Code: Select all

# Database user info (default is "root" but it's not recommended)Login = root# Database connection passwordPassword = *******

Set

Code: Select all

InternalHostname = 192.168.*.*

or

Code: Select all

InternalHostname = 127.0.0.1

If you have't configure forward rules in your router leave the ExternalHostname as is.

now check your vars.txt

Code: Select all

@echo off set config_version=2 set cmode=cset safe_mode=1 set mysqlPath=C:\Program Files\MySQL\MySQL Server 5.1\bin\mysql.exe (or whatever your path is)set mysqlBinPath=C:\Program Files\MySQL\MySQL Server 5.1\bin (or whatever your path is)set mysqldumpPath=C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqldump.exe (or whatever your path is)set lsuser=rootset lspass=passwordset lsdb=l2jlsset lshost=localhost or 127.0.0.1 or 192.168.*.*set cbuser=rootset cbpass=passwordset cbdb=l2jcbset cbhost=localhost or 127.0.0.1 or 192.168.*.*set gsuser=rootset gspass=passwordset gsdb=l2jgsset gshost=localhost or 127.0.0.1 or 192.168.*.*set logdir=.set backup=. 

now try installing again database...
I am sure that you have some config wrong.

If installation goes smoothly then you will not have a problem with the account manager.

[masashige]

what are l2jls and l2jgs?

If installation goes smoothly then you will not have a problem with the account manager.

The database installation was succesful, why i must repeat him?