Project L2Tenkai - Helios

[Solomun]

3 hours ago, Fizo said:

any way to fix this error ? 

 

 

mysql> CREATE USER 'monty'@'localhost' IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
    ->     WITH GRANT OPTION;
mysql> CREATE USER 'monty'@'%' IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%'
    ->     WITH GRANT OPTION;

 

Source: https://stackoverflow.com/questions/1559955/host-xxx-xx-xxx-xxx-is-not-allowed-to-connect-to-this-mysql-server

[Nightw0lf]

5 hours ago, Fizo said:

any way to fix this error ? 

 

several ways one is to create a user allowing host %home.otenet.gr to connect the other is to create a user with % wildcard as host in general if you dont know whats the ip that your server connects to, you should connect to the same computer though not a remote one to load your database cause the ms delay will be high

[Fizo]

2 hours ago, Nightw0lf said:

several ways one is to create a user allowing host %home.otenet.gr to connect the other is to create a user with % wildcard as host in general if you dont know whats the ip that your server connects to, you should connect to the same computer though not a remote one to load your database cause the ms delay will be high

ofc i dont wont a host ! All iP's in configs and etc was local ! 

[Nightw0lf]

ERROR: java.sql.SQLException: null,  message from server: "Host 'ppp-xx-xx-xx-xxx.home.otenet.gr' is not allowed to connect to this MySQL server"

the error says that the server try from external ip to connect to your local database but you say

4 hours ago, Fizo said:

All iP's in configs and etc was local

 

somebody lies either you or the error, reconfigure your configs and if your user is broken in database this is already answered.

[Fizo]

8 hours ago, Nightw0lf said:

ERROR: java.sql.SQLException: null,  message from server: "Host 'ppp-xx-xx-xx-xxx.home.otenet.gr' is not allowed to connect to this MySQL server"

the error says that the server try from external ip to connect to your local database but you say

 

somebody lies either you or the error, reconfigure your configs and if your user is broken in database this is already answered.

 

 

local.prop

Quote

# Connection
LoginserverHostname=127.0.0.1
LoginserverPort=2106
LoginHostname=*
ListenLoginPort=9014
LoginDbURL=jdbc:mysql://localhost:3306/l2jdb
LoginDbLogin=root
LoginDbPassword=root
GameserverHostname=*
GameserverHosts=127.0.0.1
GameserverSubnets=0.0.0.0/0
GameserverPort=7777
LoginPort=9014
GameDbURL=jdbc:mysql://localhost:3306/l2jdb
GameDbLogin=root
GameDbPassword=root

 

game.xml

Quote

   

    <config name="GameserverHostname" var="GAMESERVER_HOSTNAME" default="*" />

    <config name="GameserverHosts" var="GAME_SERVER_HOSTS" default="127.0.0.1" />

    <config name="GameserverSubnets" var="GAME_SERVER_SUBNETS" default="127.0.0.1" />

    <config name="GameserverPort" var="PORT_GAME" default="7777" />

    <!-- TCP port the login server listen to for gameserver connection requests -->
    <config name="LoginPort" var="GAME_SERVER_LOGIN_PORT" default="9014" />

    <!--
        -
        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
        -
        Note: External/Internal address definitions was moved to the ipconfig.xml
        Where's the Login server this gameserver should connect to
        WARNING: <u><b><font color="red">Please don't change default IPs here if you don't know what are you doing!</font></b></u>
        WARNING: <u><b><font color="red">External/Internal IPs are now inside "ipconfig.xml" file.</font></b></u>
    -->
    <config name="LoginHost" var="GAME_SERVER_LOGIN_HOST" default="localhost" />

    <!--
        -
        Misc Server Settings
        -
        This is the server ID that the Game Server will request.
        Example: 1 = Bartz
    -->
    <config name="RequestServerID" var="REQUEST_ID" default="1" />

    <!-- True = The Login Server will give an other ID to the server if the requested ID is already reserved. -->
    <config name="AcceptAlternateID" var="ACCEPT_ALTERNATE_ID" default="True" />

    <config name="GameDbDriver" var="DATABASE_DRIVER" default="com.mysql.jdbc.Driver" />

    <config name="GameDbURL" var="DATABASE_URL" default="jdbc:mysql://localhost:3306/l2jdb" />

    <config name="GameDbLogin" var="DATABASE_LOGIN" default="root" />

    <config name="GameDbPassword" var="DATABASE_PASSWORD" default="root" />

    <config name="GameMaximumDbConnections" var="DATABASE_MAX_CONNECTIONS" default="100" />

    <config name="GameMaximumDbIdleTime" var="DATABASE_MAX_IDLE_TIME" default="0" />

    <config name="Classic" var="IS_CLASSIC" default="false" />

 

login.xml

Quote

    <!--
        The address on which login will listen for GameServers, use * to bind on all available IPs
        WARNING: <u><b><font color="red">Please don't change default IPs here if you don't know what are you doing!</font></b></u>
        WARNING: <u><b><font color="red">External/Internal IPs are now inside "ipconfig.xml" file.</font></b></u>
    -->
    <config name="LoginHostname" var="GAME_SERVER_LOGIN_HOST" default="*" />

    <!-- The port on which login will listen for GameServers -->
    <config name="ListenLoginPort" var="GAME_SERVER_LOGIN_PORT" default="9014" />

    <!--
        -
        Login 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
        -
        Bind ip of the LoginServer, use * to bind on all available IPs
        WARNING: <u><b><font color="red">Please don't change default IPs here if you don't know what are you doing!</font></b></u>
        WARNING: <u><b><font color="red">External/Internal IPs are now inside "ipconfig.xml" file.</font></b></u>
    -->
    <config name="LoginserverHostname" var="LOGIN_BIND_ADDRESS" default="*" />

    <config name="LoginserverPort" var="PORT_LOGIN" default="2106" />

    <!--
        -
        Developer Settings
        -
    -->
    <config name="LoginDebug" var="DEBUG" default="False" />

    <config name="LoginDeveloper" var="DEVELOPER" default="False" />

    <!-- If set to True any GameServer can register on your login's free slots -->
    <config name="AcceptNewGameServer" var="ACCEPT_NEW_GAMESERVER" default="True" />

    <!-- How many times you can provide an invalid account/pass before the IP gets banned. -->
    <config name="LoginTryBeforeBan" var="LOGIN_TRY_BEFORE_BAN" default="10" />

    <!-- Time you won't be able to login back again after LoginTryBeforeBan tries to login. -->
    <config name="LoginBlockAfterBan" var="LOGIN_BLOCK_AFTER_BAN" default="600" />

    <!--
        -
        Security
        -
    -->
    <config name="LogLoginController" var="LOG_LOGIN_CONTROLLER" default="True" />

    <config name="LoginDbDriver" var="DATABASE_DRIVER" default="com.mysql.jdbc.Driver" />

    <config name="LoginDbURL" var="DATABASE_URL" default="jdbc:mysql://localhost:3306/l2jdb" />

    <config name="LoginDbLogin" var="DATABASE_LOGIN" default="root" />

    <config name="LoginDbPassword" var="DATABASE_PASSWORD" default="root" />

    <config name="LoginMaximumDbConnections" var="DATABASE_MAX_CONNECTIONS" default="10" />

    <config name="LoginMaximumDbIdleTime" var="DATABASE_MAX_IDLE_TIME" default="0" />

i am confused ! :D

Edited June 11, 2018 by Fizo

[Nightw0lf]

i am curious if you want talk private i would like to see via teamviewer that