Незапускается ГС на сурсах la2mobius C6 interlude

[ludvig 2]

Здравствуйте нужна помощь по запуску сервера в интернет сборка на сурсах L2J Mobius ошибка в логе ГС

[10/01 20:56:13] ------------------------------------------------=[ Database ]
[main] ERROR com.zaxxer.hikari.HikariConfig - Failed to load driver class com.mysql.jdbc.Driver from HikariConfig class classloader sun.misc.Launcher$AppClassLoader@55f96302
Exception in thread "main" java.lang.RuntimeException: Failed to load driver class com.mysql.jdbc.Driver in either of HikariConfig class loader or Thread context classloader
    at com.zaxxer.hikari.HikariConfig.setDriverClassName(HikariConfig.java:497)
    at com.l2jmobius.commons.database.DatabaseFactory.init(DatabaseFactory.java:36)
    at com.l2jmobius.gameserver.GameServer.main(GameServer.java:185)

Лс запускается нормально вродебы

[10/01 20:55:57] Database: Initialized.
[10/01 20:55:58] Cached 10 KeyPairs for RSA communication
[10/01 20:55:58] Stored 20 keys for Blowfish communication
[10/01 20:55:59] Loaded 127 server names
[10/01 20:55:59] Loaded 1 registered Game Servers
[10/01 20:55:59] Cached 10 RSA keys for Game Server communication.
[10/01 20:55:59] Listening for GameServers on 127.0.0.1:9014
[10/01 20:55:59] Login Server ready on (не скажу):2106
[10/01 20:55:59] Loaded 2 IP Bans.

 

 

 

 

 

 

 

 

 

ВОТ КАК ПРОПИСЫВАЛ ЛС 

 

 

# This is the server configuration file. Here you can set up the connection for your server.
# Usually you have to change the ExternalHostname option to
# - 127.0.0.1 (if you want to play alone / testing purpose)
# - LAN IP* (if you want to play from another computer in the network)
# - WAN IP** (if you want to play with friends over internet)
# - Questions? => http://l2jmobius.com
#
# * = If you want to get your LAN IP, simply choose "Start" => "Run..." then type "cmd" => "ipconfig"
# **= If you want to get you WAN IP, visit http://www.whatismyip.com
# ===================================================================================================

# ================================================================
# General server setting !!! REQUIRED to configure to everyone !!!
# ================================================================

# This is transmitted to the clients connecting from an external network, so it has to be a public IP or resolvable hostname
ExternalHostname = ТУТ ВНЕШНИЙ

# This is transmitted to the client from the same network, so it has to be a local IP or resolvable hostname
InternalHostname =ТУТ ВНУТРЕННИЙ

# Bind ip of the loginServer, use * to bind on all available IPs
LoginserverHostname = ТУТ ВНУТРЕННИЙ
LoginserverPort = 2106

# How many times you can provide an invalid account/pass before the IP gets banned
LoginTryBeforeBan = 20

# Time you won't be able to login back again after LoginTryBeforeBan tries to login. Provide a value in seconds. Default 10min. (600)  
LoginBlockAfterBan = 600
GMMinLevel = 100

# The address on which login will listen for GameServers, use * to bind on all available IPs  
LoginHostname = 127.0.0.1

# The port on which login will listen for GameServers
LoginPort = 9014

# If set to True any GameServer can register on your login's free slots
AcceptNewGameServer = True

# If False, the licence (after the login) will not be shown
# It is highly recomended for Account Seciurity to leave this option as defalut (True)
ShowLicence = True

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

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

# Parameters Databases - MYSQL
# Login - Mysql user
Login = ЛОГИН
# Password - Mysql Password
Password = ПАРОЛЬ
# maximum number of simultaneous connecting to the database
MaximumDbConnections = 3000

# Default: 0
MaximumDbIdleTime = 0

# ---------------------------------------------------------------------------
# Automatic Database Backup Settings
# ---------------------------------------------------------------------------
# Generate database backups when server restarts or shuts down. 
BackupDatabase = False

# Path to MySQL bin folder. Only necessary on Windows.
MySqlBinLocation = 

# Path where MySQL backups are stored.
BackupPath = ../backup/

# Maximum number of days that backups will be kept.
# Old backups will be deleted.
# Set to 0 to disable.
BackupDays = 30

# Limit fast connections (input username / password)
FastConnectionLimit = 15
# Time of the normal connection (in ms)
NormalConnectionTime = 700
# Time fast connection (in ms)
FastConnectionTime = 350
# Maximum connections with the 1st IP
MaxConnectionPerIP = 50

# The lifetime of the session with the login server. 
SessionTTL = 25000
MaxSessions = 100

# Choose the option: "true", to create an account when logging in automatically
AutoCreateAccounts = True

# Time to renew the IP address of the server in minutes (for dynamic IP)
IpUpdateTime = 0

# The configuration of the local subnet
# Example : 192.168
# Ppimer : 10.1
NetworkList = 192.168.;10.0.

# ===============================================================
# Test server configuration, not to switch on the game server!  =
# ===============================================================
# Use the GG client authentication
# Login server access let the client without GameGuard
ForceGGAuth = False

# Including protection from flood
# IMPORTANT: Put True for server security.
EnableFloodProtection = True

# Enable mode "debugging"
# With debug you will see more log on console and more messages in game.
Debug = False

# Switched on "development"
Developer = False

# =============================================================
# Anti Bruteforce protection. (credits RT-Interlude)
# =============================================================
#Count of trying connection to server, after which will be made checking IP addres
#for a possible BrutForce
#Reducing this value will increase the likelihood of false positives
#Increasing this value will reduce the effectiveness of security (more chance find passwords for large accounts)
BrutLogonAttempts = 15
#The average time (in seconds) between attempts to connect to the server
#Reducing this value will increase the likelihood of false positives
#Increasing this value will reduce the effectiveness of security (more chance find passwords for large accounts)
BrutAvgTime = 30
#Number of second, for ban IP address, who time BrutAvgTime less specified
#900 second = 15 minute 
BrutBanIpTime = 900
Assert = False
EnableAllExceptionsLog = False
 

 

 

 

ВОТ КАК ПРОПИСЫВАЛ ГС 

 

 

# ===================================#
#   Game Server Settings             #
# ===================================#
# This is the server configuration file. Here you can set up the connection information for your server.
# This was written with the assumption that you are behind a router.
# Dumbed Down Definitions...
# LAN (LOCAL area network) - typically consists of computers connected to the same router as you.
# WAN (WIDE area network) - typically consists of computers OUTSIDE of your router (ie. the internet).
# x.x.x.x - Format of an IP address. Do not include the x'es into settings. Must be real numbers.
# -----------------------------------------------------------------------------------------------------------------------------------------------------------------
# Networking
# -----------------------------------------------------------------------------------------------------------------------------------------------------------------
# This is transmitted to the clients connecting from an external network, so it has to be a public IP or resolvable hostname
# Common settings...
# 127.0.0.1 - If you are playing alone on a test server
# 192.168.x.x - This is if you are on a 192.168.x.x type network (behind a standard consumer router) and want other computers from JUST the internal network to be able to connect
# x.x.x.x - WAN IP obtained from http://www.whatismyip.com/. This is if you want people outside your internal network to be able to connect to your server.
# If this IP is resolvable by the Login Server, just leave *.
# ----------------------------------------------------------------------------------------

# Enter here (ip) address of your game server, or use the symbol *
GameserverHostname = ВНУТРЕНИЙ ИП
GameserverPort = 7777

# Configure your external ip
ExternalHostname = ВНЕШНИЙ ИП

# Configure your internal ip
InternalHostname = ВНУТРЕННИЙ ИП

# Bunch ID and game server. It is better not to change.
LoginPort = 9014
LoginHost = 127.0.0.1

# 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/l2jmobiusc6?useUnicode=true&characterEncoding=utf-8&useSSL=false
URL = jdbc:mysql://localhost/GS

# Login - Mysql user
Login = ЛОГИН
# Password - Mysql Password
Password = ПАРОЛЬ
# Attention: lazy init connections disabled!
# Please, set only real values for your database
# Default: 50
MaximumDbConnections = 3000

# Default: 0
MaximumDbIdleTime = 0

# ---------------------------------------------------------------------------
# Automatic Database Backup Settings
# ---------------------------------------------------------------------------
# Generate database backups when server restarts or shuts down. 
BackupDatabase = False

# Path to MySQL bin folder. Only necessary on Windows.
MySqlBinLocation = 

# Path where MySQL backups are stored.
BackupPath = ../backup/

# Maximum number of days that backups will be kept.
# Old backups will be deleted.
# Set to 0 to disable.
BackupDays = 30

# Setting emulation off the kernel (package SendStatus)
RemoteWhoLog = True
RemoteWhoSendTrash = True
RemoteWhoMaxOnline = 329
RemoteOnlineIncrement = 50
RemoteWhoForceInc = 50
RemotePrivStoreFactor = 12

# Datapack folder
# To exacute the server under debugger with eclipse use:
# DatapackRoot = ../L2jMobius_DataPack
# or point the folder directly to your server.
DatapackRoot = .

 

 

 

Ко всему прочему когда захожу в навикат ,и просто пытаюсь открыть соединение с со своими базами данных то ошибка 1040- to many connections.

Также в этот момент ,момент когда запущен лс гс неработает сайт соответственно с форумом

 

 

ПС . здесь вместо батников Лс ,ГС exe 

Изменено 10 января, 2021 пользователем ludvig

[BleaK 33]

У тебя проблема в конфиге мускуля

Открываем конфигурационный файл mysql:

vi /etc/my.cnf.d/server.cnf (в разных ос может быть в разных местах)

В директиве [mysqld] добавляем или изменяем следующую строку:

[mysqld]
...
max_connections = 500

 

Перезагружаем mysql

Изменено 10 января, 2021 пользователем BleaK