small problem

[helba]

If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision 3274:
L2JDP Revision 6374:
am not so new to working with l2j

not had much of problem befor but am not useing a locathost for datebase this time on are server

datebase is hosted on are web site i do not know how set it in config were it work from site to server that been giveing me problem of not connecting to db am not sure how go by fixing it

[MetalBlack]

I'm noob for this thing... I never try but I think it u change a "URL" in server.properties file with a ip where u got host a db it should work...
exemple:
URL = jdbc:mysql://localhost/l2jdbfinal

in

URL = jdbc:mysql://xxx.xxx.xxx.xxx:3306/l2j

(I dont know if need a port too)

I repeat,I'm not expert and I never try this and is possible I say a stupid thing

[kotk]

You also need to setup a user in mysql.user table that can connect from your gameserver.

[helba]

*edit* woot fixed it yeah i had spaces in the config am nuts lol

# ---------------------------------------------------------------------------
# Database
# ---------------------------------------------------------------------------
# Specify the appropriate driver and url for the database you're using.
# Examples:
# Database info
Driver=com.mysql.jdbc.Driver
#Driver=org.hsqldb.jdbcDriver
#Driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
# Database URL
# URL = jdbc:mysql://Superflytnt.org/superfly_l2jdb (default)
# URL = jdbc:hsqldb:hsql://Superflytnt.org/superfly_l2jdb
# URL = jdbc:sqlserver://Superflytnt.org/database = superfly_l2jdb/user = sa/password =
URL = jdbc:mysql://Superflytnt.org/superfly_l2jdb
# Database user info (default is "root" but it's not recommended)
Login = superfly_l2jj

# Database connection password
Password = ********