Thread: os-scape 171 server

Page 9 of 10 FirstFirst ... 78910 LastLast
Results 81 to 90 of 96
  1. #81  
    Be the change you wanna see!

    Nozemi's Avatar
    Join Date
    Jul 2010
    Posts
    401
    Thanks given
    199
    Thanks received
    204
    Discord
    View profile
    Rep Power
    949
    Quote Originally Posted by Slam Way View Post
    error:
    The authentication type 10 is not supported. Check that you have configured the pg_hba.conf file to include the client's IP address or subnet, and that it is using an authentication scheme supported by the driver.

    does this have anything related to the version of the PgSql I am using if its later or before v10?

    thanks


    Edit:
    I have changed methods to md5 didnt work
    I have changed methods to trust didnt work
    Quote Originally Posted by cellulite View Post
    All steps followed, then on run/execute I receive this error:

    Code:
    Caused by: org.postgresql.util.PSQLException: The authentication type 10 is not supported. Check that you have configured the pg_hba.conf file to include the client's IP address or subnet, and that it is using an authentication scheme supported by the driver.
    I saw someone had got that before and downgraded to postgre10 but when I try to run 10 it doesn't even load up lol so that's not an option for me. I also uninstalled it all and tried from scratch, same error. Please advise?
    I had the same issue. I did a quick Google search, and discovered that upgrading postgres version fixes it. It's done in the build.gradle file. I just used 42.2.23.


    Working on a custom OSRS base for Dodian. I've chosen to keep it open source.
    Click Signature to Check it Out


    Dodian is where my RSPS passion started, so I intend to keep it alive, even considering how dead it is.
    Reply With Quote  
     

  2. Thankful user:


  3. #82  
    Skotos Founder


    Join Date
    Jan 2017
    Age
    22
    Posts
    914
    Thanks given
    151
    Thanks received
    182
    Discord
    View profile
    Rep Power
    124
    Thank you my g
    Reply With Quote  
     

  4. #83  
    Registered Member
    Join Date
    Aug 2021
    Posts
    2
    Thanks given
    0
    Thanks received
    0
    Rep Power
    0
    I have postgresql set up & redis and no matter what I play around with config & source wise, I cannot log in. The server acknowledges the connection attempt but I just can't log in no matter what. Anyone have a reduced version that doesn't use a million services or a fix to this?
    Reply With Quote  
     

  5. #84  
    Registered Member
    Join Date
    Jun 2017
    Posts
    7
    Thanks given
    0
    Thanks received
    0
    Discord
    View profile
    Rep Power
    0
    3,000 errors. Holy shit. Good luck
    Reply With Quote  
     

  6. #85  
    Be the change you wanna see!

    Nozemi's Avatar
    Join Date
    Jul 2010
    Posts
    401
    Thanks given
    199
    Thanks received
    204
    Discord
    View profile
    Rep Power
    949
    Quote Originally Posted by K120 View Post
    3,000 errors. Holy shit. Good luck
    Sounds like a you-problem, worked fine for me. Setup was smooth as butter.


    Working on a custom OSRS base for Dodian. I've chosen to keep it open source.
    Click Signature to Check it Out


    Dodian is where my RSPS passion started, so I intend to keep it alive, even considering how dead it is.
    Reply With Quote  
     

  7. #86  
    Wut can u say when theres nothin to tell

    Tyrant's Avatar
    Join Date
    Jul 2013
    Age
    22
    Posts
    1,548
    Thanks given
    677
    Thanks received
    411
    Discord
    View profile
    Rep Power
    1004
    Has anybody integrated it with RuneLite and be kind enough to share their client?
    Reply With Quote  
     

  8. #87  
    Registered Member
    Join Date
    Aug 2021
    Posts
    2
    Thanks given
    0
    Thanks received
    0
    Rep Power
    0
    Quote Originally Posted by Tyrant View Post
    Has anybody integrated it with RuneLite and be kind enough to share their client?
    second this, that would be nutty
    Reply With Quote  
     

  9. #88  
    Registered Member
    Join Date
    Jun 2019
    Posts
    10
    Thanks given
    0
    Thanks received
    0
    Rep Power
    11
    Looks amazing
    Reply With Quote  
     

  10. #89  
    Wut can u say when theres nothin to tell

    Tyrant's Avatar
    Join Date
    Jul 2013
    Age
    22
    Posts
    1,548
    Thanks given
    677
    Thanks received
    411
    Discord
    View profile
    Rep Power
    1004
    For those who cant login, seems like the client initializer comes in after is being called by the trafficcounter, thus terminating the logic service which makes login request to not queue,
    simply add a check if the client initializer is instanced and only then proceed with the check.
    Reply With Quote  
     

  11. #90  
    Donator
    Chappie's Avatar
    Join Date
    Jun 2016
    Posts
    175
    Thanks given
    63
    Thanks received
    6
    Rep Power
    32
    Quote Originally Posted by Spock View Post




    we bought this from Velocity

    https://mega.nz/file/YKh0WSbA#-Vx-dA...aT0uOmC7wCXuNs
    https://mega.nz/file/YexmDYJC#tGHOEN...tEkQquqhm-x1Oo

    these are the original files given to us by Velocity himself, not single a thing has been changed or edited, do as you please with it, I will not help with setting it up or anything as such so don't expect any guides. Hopefully with the release of this and the way more updated Kronos(runite), people will move away from 317 junk!

    Credits:
    Situations
    Velocity
    Savions
    Shadowy


    Edit

    Spoiler for Click here for additional instructions:

    Disconnection fix: https://www.rune-server.ee/runescape...ml#post5734883

    UTF-8 encoding fix: https://www.rune-server.ee/runescape...ml#post5731833

    Only thing you need to do is set

    Code:
    public static boolean disableIngameCreation = true;
    to false

    For the friends part of the game to work correctly, these following postgres functions need importing with the schema.
    Code:
    create function canprivatemessage(my_id integer, their_name citext)
      returns TABLE(target_id integer, result boolean)
    language plpgsql
    as $$
    DECLARE their_id INTEGER;
    BEGIN
    
    
        SELECT id
        INTO their_id
        FROM accounts
        WHERE displayname ILIKE their_name;
    
    
        RETURN QUERY SELECT their_id as target_id, (CASE
                                                    --Couldn't find player
                                                    WHEN (their_id IS NULL)
                                                        THEN FALSE
    
    
                                                    --They aren't even online
                                                    WHEN (SELECT count(*)
                                                          FROM online_characters oc
                                                          WHERE oc.account_id = their_id) <= 0
                                                        THEN FALSE
    
    
                                                    --On their ignore list
                                                    WHEN (SELECT count(*)
                                                          FROM ignores
                                                          WHERE account_id = their_id AND friend_id = my_id) > 0
                                                        THEN FALSE
    
    
                                                    -- PMStatus Offline
                                                    WHEN (SELECT pmstatus
                                                          FROM characters c
                                                          WHERE c.account_id = their_id AND c.id = (SELECT oc.character_id
                                                                                                    FROM online_characters oc
                                                                                                    WHERE oc.account_id = their_id)) =
                                                         2
                                                        THEN FALSE
    
    
                                                    -- PMStatus Friends only
                                                    WHEN (SELECT pmstatus
                                                          FROM characters c
                                                          WHERE c.account_id = their_id AND c.id = (SELECT oc.character_id
                                                                                                    FROM online_characters oc
                                                                                                    WHERE oc.account_id = their_id)) =
                                                         1
                                                        THEN (CASE WHEN (SELECT count(*)
                                                                         FROM friends f2
                                                                         WHERE f2.account_id = their_id AND f2.friend_id = my_id) > 0
                                                            THEN TRUE
                                                              ELSE FALSE END)
    
    
                                                    -- Otherwise we can pm them :)
                                                    ELSE TRUE
                                                    END) AS result;
    END;
    $$;
    
    
    create function getfriendsfor(my_id integer)
      returns TABLE(accout_id integer, friend_id integer, world_id integer, service_id integer, character_id integer, displayname character varying, lastname character varying, rights smallint, clanrank integer)
    language plpgsql
    as $$
    BEGIN
        RETURN QUERY SELECT
                         f1.account_id,
                         f1.friend_id,
                         (CASE
                          WHEN ch.pmstatus = 2 --Offline
                              THEN 0
                          WHEN ch.pmstatus = 1 --Friends only
                              THEN (CASE WHEN (SELECT count(*)
                                               FROM friends f2
                                               WHERE f2.account_id = f1.friend_id AND f2.friend_id = f1.account_id) > 0
                                  THEN oc.world_id
                                    ELSE 0 END)
                          ELSE oc.world_id --Normal
                          END) AS world_id,
                         oc.service_id,
                         oc.character_id,
                         a.displayname,
                         a.lastname,
                         a.rights,
                         f1.clanrank
                     FROM friends AS f1
                         LEFT JOIN online_characters AS oc
                             ON oc.account_id = f1.friend_id
                         LEFT JOIN accounts AS a
                             ON f1.friend_id = a.id
                         LEFT JOIN characters AS ch
                             ON ch.id = oc.character_id
                     WHERE f1.account_id = my_id;
    END;
    $$;
    
    
    create function getfriendsfor(my_id integer, pmstatus integer)
      returns TABLE(accout_id integer, friend_id integer, world_id integer, service_id integer, character_id integer, displayname character varying, lastname character varying, rights smallint, clanrank integer)
    language plpgsql
    as $$
    BEGIN
        RETURN QUERY SELECT
                         f1.account_id,
                         f1.friend_id,
                         CASE
                         WHEN oc.world_id IS NULL OR oc.world_id = 0
                             THEN oc.world_id --If their world is null or 0 they are offline already
    
    
                         WHEN pmstatus = 1 AND (SELECT count(*)
                                                FROM friends AS f2
                                                WHERE f2.friend_id = f1.account_id AND f2.account_id = f1.friend_id) > 0
                             THEN oc.world_id --If other person is friends only and we are on their friends list then show the real world
    
    
                         WHEN pmstatus != 1
                             THEN oc.world_id --Other person isn't on friends only, we all good :)
    
    
                         ELSE 0 --Other person is friends only and we are no on their friends list. make them appear offline
    
    
                         END AS world_id,
                         oc.service_id,
                         oc.character_id,
                         a.displayname,
                         a.lastname,
                         a.rights,
                         f1.clanrank
                     FROM friends AS f1
                         LEFT JOIN online_characters AS oc
                             ON oc.account_id = f1.friend_id
                         LEFT JOIN accounts AS a
                             ON f1.friend_id = a.id
                     WHERE f1.account_id = my_id;
    END;
    $$;



    Could you help with setting it up, would love to use this as project base to learn more about this revision as im a huge osrs fan.
    Reply With Quote  
     

Page 9 of 10 FirstFirst ... 78910 LastLast

Thread Information
Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


User Tag List

Similar Threads

  1. Replies: 100
    Last Post: 12-28-2019, 01:13 AM
  2. OS-Scape ECO server gp for sale!! 150m!!
    By lary_30 in forum Selling
    Replies: 13
    Last Post: 06-20-2016, 05:19 PM
  3. OS-Scape Blood Money (PvP Server)
    By Affliction in forum Buying
    Replies: 6
    Last Post: 03-19-2016, 03:55 AM
  4. Maulzz-Scape 508 Server Release !
    By Lenin in forum Downloads
    Replies: 47
    Last Post: 08-17-2009, 11:28 PM
  5. Legend-Scape - ::Pickup Server -
    By Smithy in forum Advertise
    Replies: 1
    Last Post: 05-15-2009, 09:53 PM
Posting Permissions
  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •