Jump to content

Recommended Posts

Posted
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

Posted
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

Posted
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 ! 

Posted

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.

Posted (edited)
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 by Fizo

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.




  • Posts

    • Hello friends, good morning, good afternoon or good evening, depending on the time you are seeing this! I have been trying to decompile and compile again with only the classes that I want LineageEffect.u for a few days now, but I have not been successful. Could someone help me by clearing up some doubts about how I can do this work and be successful?!
    • **INTERLUDE REMASTERED** Moonland is a server that's been running for about three years without wipe, and they don't plan on wiping it anytime soon. I'm selling my items or even the account due to not having much time to play anymore. I'm selling only for $$$. Not going to disclose my nickname in the server, but here are some of the items: Lvl 5 equipment for both mage and fighter +100 mage pvp set 2mastery jewels for fighter, 2 for mage, blessed antharas, blessed queen ant, ring of fallen angel, earring of fafurion. 1k + col, VIP cosmetics for armor, agathion and weapons(duals + mage wep)   I'm only selling for real money via paypal or cs2 skins so don't offer me anything else.
    • ➡ Discount for your purchase: MAY2025 (10% discount) ➡ Our Online Shop: https://socnet.store  ➡ Our SMM-Boosting Panel: https://socnet.pro  ➡ Telegram Shop Bot: https://socnet.shop  ➡ Telegram Support: https://t.me/solomon_bog  ➡ Telegram Channel: https://t.me/accsforyou_shop  ➡ Discord Support: @AllSocialNetworksShop  ➡ Discord Server: https://discord.gg/y9AStFFsrh  ➡ WhatsApp Support: https://wa.me/79051904467 ➡ WhatsApp Channel: https://whatsapp.com/channel/0029Vau0CMX002TGkD4uHa2n  ➡ Email Support: solomonbog@socnet.store 
    • ➡ Discount for your purchase: MAY2025 (10% discount) ➡ Our Online Shop: https://socnet.store  ➡ Our SMM-Boosting Panel: https://socnet.pro  ➡ Telegram Shop Bot: https://socnet.shop  ➡ Telegram Support: https://t.me/solomon_bog  ➡ Telegram Channel: https://t.me/accsforyou_shop  ➡ Discord Support: @AllSocialNetworksShop  ➡ Discord Server: https://discord.gg/y9AStFFsrh  ➡ WhatsApp Support: https://wa.me/79051904467 ➡ WhatsApp Channel: https://whatsapp.com/channel/0029Vau0CMX002TGkD4uHa2n  ➡ Email Support: solomonbog@socnet.store 
  • Topics

×
×
  • Create New...