Solomun Posted June 11, 2018 Share Posted June 11, 2018 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 Quote Link to comment Share on other sites More sharing options...
Nightw0lf Posted June 11, 2018 Share Posted June 11, 2018 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 Quote Link to comment Share on other sites More sharing options...
Fizo Posted June 11, 2018 Share Posted June 11, 2018 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 ! Quote Link to comment Share on other sites More sharing options...
Nightw0lf Posted June 11, 2018 Share Posted June 11, 2018 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. Quote Link to comment Share on other sites More sharing options...
Fizo Posted June 11, 2018 Share Posted June 11, 2018 (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 June 11, 2018 by Fizo Quote Link to comment Share on other sites More sharing options...
Nightw0lf Posted June 12, 2018 Share Posted June 12, 2018 i am curious if you want talk private i would like to see via teamviewer that Quote Link to comment Share on other sites More sharing options...
Recommended Posts
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.