Page 1 of 1

Registering GS / HexID

Posted: Sun Aug 09, 2009 11:22 am
by Scub
heya
i hope it s the right place to ask some help in connection with setting up a server

the guide is awesome, everything was smooth till step 7
i installed all the programs freshly and the possible latest versions
using vista

as soon as i want to start RegisterGameServer.bat it gives an error message, says:
Error when importing the list of registered GameServers
Access denied for user "root"@localhost (Password: YES)

on the attached pic u can see it, besides the registering tool and some folders etc
i got mysql running (5.1), easyphp 3 running, servername.xml is there too
ah and ofc java is installed too

i have tried few possible solutions but none of them worked
one was to reinstall everything, multiple times, but couldn t find the mistake (proves that guide is cool)
other option was trying to find which password is missing / exists without any point
mainly used the same pass everywhere, except the screened server.prop file where i used no pass (maybe in other irrevelant txt s i left it blank)
as 3rd i googled the hexid file and downloaded from a forum, but when i copied to the right folder and started the servers, i got a long error and terminated the program

so question is: what i missed / misunderstood?
on the pic u can see the txt, the line with: DB connection pass, should i write here smth?
or is the DP root directory important? do i have to give the proper place?

pic:
http://img7.imageshack.us/img7/6153/errorozx.jpg

thanks in advance, hope u can help to solve this (even possible that answer is trivial just i missed)

Re: Registering GS / HexID

Posted: Mon Aug 10, 2009 12:31 pm
by lishawj
You NEED a password set in both loginserver.properties and gameserver.properties file. You are clearly missing the password entry in the screen shot your provided. You can not connect to the database if you do not provide a password to authenticate into the L2JDB.

Step 7: (you overlooked this part)

# 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= <---- HERE PUT YOUR MYSQL PASSWORD
MaximumDbConnections=10