SQL connect

[aster1985]

hi everyone i'v got a problem whit my sql setting.
I'v build my server on mine pc and i'll try to connect my server to my sql server hostet on my webhost ( aruba ) i'v opened all port to connect but l2server dosn't whant connect to it... so wath's wrong?

# Database info
Driver=com.mysql.jdbc.Driver
#Driver=org.hsqldb.jdbcDriver
#Driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
URL=jdbc:mysql://myIp of sql server/Sql255910_2
#URL=jdbc:hsqldb:hsql://myIp of sql server/Sql255910_2
#URL=jdbc:sqlserver://myIp of sql server/database=Sql255910_2/user=sa/password=
Login=my login
Password=my pass
MaximumDbConnections=1000


It's my database setting...

Thk to all

[MentaL]

[Rin4a]

you shouldn't do this:

URL=jdbc:mysql://myIp of sql server/Sql255910_2

just leave it like that:

URL = jdbc:mysql://localhost/Sql255910_2

and a note - everything that starts with dash (#) is commented out and it won't matter if you change it or not...
besides that, do you get any other errors, while server is loading?

[aster1985]

you shouldn't do this:

URL=jdbc:mysql://myIp of sql server/Sql255910_2

just leave it like that:

URL = jdbc:mysql://localhost/Sql255910_2

and a note - everything that starts with dash (#) is commented out and it won't matter if you change it or not...
besides that, do you get any other errors, while server is loading?

I'v got ur point...but the real problem it's the server hosted by my pc the sql server hostet on an web host like aruba..so i can leave localhost at

URL = jdbc:mysql://localhost/Sql255910_2

so I should put my ip on it like:

 URL=jdbc:mysql://62.149.150.93/Sql255910_2  
#URL=jdbc:hsqldb:hsql://62.149.150.93/Sql255910_2
#URL=jdbc:sqlserver://62.149.150.93/database=Sql255910_2/user=sa/password=

this is my sql configuration now with the ip of my sql server by aruba

[Rin4a]

I don't suggest you to use a web host as a MySQL host, because it will cause major lags... Just host it on your PC... it won't cause noticeable performance spikes..

[aster1985]

I don't suggest you to use a web host as a MySQL host, because it will cause major lags... Just host it on your PC... it won't cause noticeable performance spikes..

So u tell me to use my pc as a server and sql server too? The problem is to finde a mysql version compatible with the server! I'll remember the 4th edition was good isn't it? or there is something better? PS: i'v a windos 64bit edition with dual quad core 3.0ghz ( intel xeon ) with 32giga of ram!! It's enogh? the problem meabe was the interent connection...10g/s ( not real... italian internet connection was realy socks... ) the only good news was that i'v a static IP!
Another quastion it's how to bild a luncer for gracia or helbound l2 server...without fix the host file...

[Rin4a]

you have that kind of a PC and you don't want to host a MySQL server? that's stupid... what I do is, I get the latest MySQL version, install it and I use it, and everything seems fine...
to build a launcher you need some skills in Delphi/C++ or any that kind of programming language.
last thing: why are you using 64 bit windows? it doesn't allow you to use all 32 GB of ram, only some part of it... Windows Server is the best choice..

[aster1985]

you have that kind of a PC and you don't want to host a MySQL server? that's stupid... what I do is, I get the latest MySQL version, install it and I use it, and everything seems fine...
to build a launcher you need some skills in Delphi/C++ or any that kind of programming language.
last thing: why are you using 64 bit windows? it doesn't allow you to use all 32 GB of ram, only some part of it... Windows Server is the best choice..

U have reason about everythink....but windows vista 64bit it's only the one that reconais all my pc part becouse i'v have the MacPro..if u think that windws server ( 2008 ) whorks great...I can buy it ( download isn't a good idea )

[aster1985]

Ok i'll installed mysql enterprice edition but culd start the server becouse it's steel give me an erroro: "culd start server ecc" and I was looking around the web for solution but nothing. I reinstal every thing to meny times but noitng to. sombody can helm me for this other problem? In case, if it's possible, someone can try to use remote acces to help me!
Thenks for all!