The Kamael Login/GS connection to SQL

[klaus]

Hi there, I've been trying to install Mobius Classic and I've came across one issue.

Everytime I am trying to run login/gameserver I am always getting this error messege:

__
[04/01 23:40:44] Database: Problem on initialize. java.sql.SQLSyntaxErrorException: No connection available within the specified time (option 'connectTimeout': 30,000 ms)
__

I've already tried:

- reinstall xampp
- reinstall heidisql
- reinstall mysql
- reinstall navicat
- reconfigure mysql

And nothing so far helped, I even went trough core SQL config and I can't troubleshoot it out. If anyone already had/solved this issue, help would be much appraciate.

Thank you and have a good day all

[G-hamsteR]

Can navicat connect to your mysql? Are you sure that you are using the correct credentials on loginserver? (database name, username, password)

[klaus]

Hi there, yes. I am not a newbie I am running L2 servers for a years, however never anything above H5 Client.

Yes, navicat test connection always go trough. Since I am not going for maria db, I rewrote connection, but they should be all good.

LoginServer.ini

# ---------------------------------------------------------------------------
# Database
# ---------------------------------------------------------------------------

# Specify the appropriate driver and url for your database.
# Default: org.mariadb.jdbc.Driver
Driver = com.mysql.jdbc.Driver

# Database URL
# Default: jdbc:mariadb://localhost/l2jmobiusclassic?useUnicode=true&characterEncoding=utf-8&useSSL=false
URL = jdbc:mysql://localhost/login_server

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

# Database connection password
Password = {hiden}

# Default: 5
MaximumDbConnections = 5

Server.ini

# ---------------------------------------------------------------------------
# Database
# ---------------------------------------------------------------------------

# Specify the appropriate driver and url for the database you're using.
# Default: org.mariadb.jdbc.Driver
Driver = com.mysql.jdbc.Driver

# Database URL
# Default: jdbc:mariadb://localhost/l2jmobiusclassic?useUnicode=true&characterEncoding=utf-8&useSSL=false
URL = jdbc:mysql://localhost/game_server

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

# Database connection password
Password = {hiden}

# Default: 100
MaximumDbConnections = 100


Meantime {hiden} = real password.

[Mobius]

Yes, navicat test connection always go trough. Since I am not going for maria db, I rewrote connection, but they should be all good.

Did you make core support for that?
You should not change what you do not understand.

[prx]

Same problem

[MrSupaStar]

Hi, I had the same issue and I will still post this thinking it will help others in the future.

Long story short, this problem appeared after I've installed other Chronicles ( Fafurion or Master Class ) and I've tried to register the Database_Installer_LS & Database_Installer_GS under a different name than it was already there -> l2jmobius.

I had IL, H5, Essence servers on my machine already so those worked fine with using a different name.

So to fix this, just use the default name  l2jmobius when registering  Database_Installer_LS & Database_Installer_GS.

[Paiplayer]

Hi there, yes. I am not a newbie I am running L2 servers for a years, however never anything above H5 Client.

Yes, navicat test connection always go trough. Since I am not going for maria db, I rewrote connection, but they should be all good.

LoginServer.ini

# ---------------------------------------------------------------------------
# Database
# ---------------------------------------------------------------------------

# Specify the appropriate driver and url for your database.
# Default: org.mariadb.jdbc.Driver
Driver = com.mysql.jdbc.Driver

# Database URL
# Default: jdbc:mariadb://localhost/l2jmobiusclassic?useUnicode=true&characterEncoding=utf-8&useSSL=false
URL = jdbc:mysql://localhost/login_server

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

# Database connection password
Password = {hiden}

# Default: 5
MaximumDbConnections = 5

Server.ini

# ---------------------------------------------------------------------------
# Database
# ---------------------------------------------------------------------------

# Specify the appropriate driver and url for the database you're using.
# Default: org.mariadb.jdbc.Driver
Driver = com.mysql.jdbc.Driver

# Database URL
# Default: jdbc:mariadb://localhost/l2jmobiusclassic?useUnicode=true&characterEncoding=utf-8&useSSL=false
URL = jdbc:mysql://localhost/game_server

You shouldn't change mariadb connector by mysql connector if you hadn't imported it on GS and LS projects.

By the way, MariaDB is based on MySQL and their connector works perfectly even when connecting with other MySQL based databases, for instance, Amazon Aurora.

[donsax]

I have the same problem, I did not modify anything in the connector