Page 1 of 1
small problem
Posted: Thu Jul 09, 2009 3:10 pm
by 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
Re: small problem
Posted: Sat Jul 11, 2009 10:53 am
by 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
Re: small problem
Posted: Sat Jul 11, 2009 1:59 pm
by kotk
You also need to setup a user in mysql.user table that can connect from your gameserver.
Re: small problem
Posted: Sat Jul 11, 2009 2:13 pm
by 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 = ********