Jump to content

Fizo

Donator Member
  • Posts

    912
  • Credits

  • Joined

  • Last visited

  • Feedback

    0%

Posts posted by Fizo

  1. 2 hours ago, alexandrosdkk said:

    multiskill no (if it means that every char can take others actives or passives ) now for the subs personaly am fine with all 0,1,2,3,4 no matter but not skillsharing merry xmas

    Thanks for your reply .. But i dont talk about multi skill server i talk about stuck sub server that you can make your combo with your main class and you have to pick one sub .. Thanks for your time !

  2. Hello guys and also before you start reading i wanna thanks you for your time.
     

    2 Month's now i am thinking to make a server , But all idea's was like PvP server with some cusom's feaure's and etc . I am thinking to make something new .

    Right now i am using one h5 pack ( not a shared one ) and i am thinking about x50 server with stuck sub system ( 1 main + 1 sub ) with Moirai and Vesper not buyable from merchant's but craftable . With some custom bosse's and all big area's will be boosted to make fair the stuck sub system . I Know what community thinks when read a Stuck Sub or Multi Skill's , But this is the reason why i ask your Advice before i make it public .
     

    My idea was to make a Beta Period to see how it work's . 

    i will be grateful if you right your opinion about this , for sure i can write all the server feature's and i am not lazy but my problem now it's about Stuck sub system on a H5 x50 server . 

    Feel free to write and please let this thread be clean !

     

    Thanks for your Time ! 

  3. 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

  4. 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 ! 

  5. any way to fix this error ? 

    Quote

    596 [BoneCP-pool-watch-thread] ERROR com.jolbox.bonecp.ConnectionHandle - Failed to acquire connection. Sleeping for 3000ms. Attempts left: 5
    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"
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
        at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1116)
        at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2338)
        at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371)
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)
        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
        at java.sql.DriverManager.getConnection(DriverManager.java:664)
        at java.sql.DriverManager.getConnection(DriverManager.java:247)
        at com.jolbox.bonecp.BoneCP.obtainRawInternalConnection(BoneCP.java:230)
        at com.jolbox.bonecp.ConnectionHandle.obtainInternalConnection(ConnectionHandle.java:197)
        at com.jolbox.bonecp.ConnectionHandle.<init>(ConnectionHandle.java:154)
        at com.jolbox.bonecp.PoolWatchThread.fillConnections(PoolWatchThread.java:121)
        at com.jolbox.bonecp.PoolWatchThread.run(PoolWatchThread.java:102)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at java.lang.Thread.run(Thread.java:745)

     

  6. 10 minutes ago, Nightw0lf said:

    in the first post it says

    After that search in facebook settings to change the url-name of your page to www.facebook.com/L2Tests and not www.facebook.com/HAW#$A#@

    actually you only need to add the green https://www.facebook.com/L2Tests/ in config maybe this helps

    I've got this error when i try to use facebook system !

     

     

    EDIT: Works Perfect Thanks Nightwolf for suggestion !!! 

×
×
  • Create New...