[Guide] Server 6.0.7 installation steps

Page 4 of 31 FirstFirst 12345678910111214 ... LastLast
Results 46 to 60 of 464
  1. #46

    Re: [Guide] Server 6.0.7 installation steps

    While it's not so easy, go here http://www.rom-welten.de/database/ and just search for GM.. You will have to scan every page, but most GM items will start with GM.. haha.. (This is pretty close to having all items for Chap 6)

    mochi... On your romuser account for MSSQL, click properties for romuser, and make sure it has dbread and dbwrite privileges for all databases.. If you choose all db's, and dbread/dbwrite, it's only active for one DB.. You may need to uncheck each db, re-check and select dbread/dbwrite/dbowner for each database seperately.

  2. #47
    Account Upgraded | Title Enabled! mochi is offline
    MemberRank
    Sep 2008 Join Date
    244Posts

    Re: [Guide] Server 6.0.7 installation steps

    Quote Originally Posted by wannagame View Post
    While it's not so easy, go here http://www.rom-welten.de/database/ and just search for GM.. You will have to scan every page, but most GM items will start with GM.. haha.. (This is pretty close to having all items for Chap 6)

    mochi... On your romuser account for MSSQL, click properties for romuser, and make sure it has dbread and dbwrite privileges for all databases.. If you choose all db's, and dbread/dbwrite, it's only active for one DB.. You may need to uncheck each db, re-check and select dbread/dbwrite/dbowner for each database seperately.
    Thank you. I set romuser to sysaccount. It's can read-write db. I don't know why server have problem level rollback only ,item or char location not rollback.

  3. #48
    Valued Member kalle101 is offline
    MemberRank
    Jun 2014 Join Date
    133Posts

    Re: [Guide] Server 6.0.7 installation steps

    Quote Originally Posted by wannagame View Post
    While it's not so easy, go here http://www.rom-welten.de/database/ and just search for GM.. You will have to scan every page, but most GM items will start with GM.. haha.. (This is pretty close to having all items for Chap 6)
    I didn't find anything GM related except for this useless GM Helmet with no stats.
    Are there really no items gear weapons etc. for GM?
    Also the GM Skills are pretty lame and boring.

    How can I play a little bit more fun and exciting?
    I want to build the ultimate solo class which can beat all bosses in the game without Command setvalue for changing abilities
    Any suggestions?

  4. #49
    Banned bRUZZ is offline
    BannedRank
    Jul 2014 Join Date
    62Posts

    Re: [Guide] Server 6.0.7 installation steps

    Quote Originally Posted by kalle101 View Post
    I didn't find anything GM related except for this useless GM Helmet with no stats.
    Are there really no items gear weapons etc. for GM?
    Also the GM Skills are pretty lame and boring.

    How can I play a little bit more fun and exciting?
    I want to build the ultimate solo class which can beat all bosses in the game without Command setvalue for changing abilities
    Any suggestions?
    why don't you just edit an item in the fdbs using the editor I've sent to you :)
    Also you could edit the stats like changing +182 dex to something higher. That would make you possible to solo some shit without abusing the gm commands ^^
    Or you could just create your own GM items by adding rows to specific tables inside of the data.fdb.

  5. #50
    Account Upgraded | Title Enabled! Elssair is offline
    MemberRank
    Dec 2013 Join Date
    334Posts

    Re: [Guide] Server 6.0.7 installation steps

    Hi :)

    What editor @bRUZZ? fdbextractor2?

    Regards,
    Elssair.

  6. #51
    Banned bRUZZ is offline
    BannedRank
    Jul 2014 Join Date
    62Posts

    Re: [Guide] Server 6.0.7 installation steps

    Quote Originally Posted by Elssair View Post
    Hi :)

    What editor @bRUZZ? fdbextractor2?

    Regards,
    Elssair.
    sorry but it isn't public as for now. Also I promised not to share it.

  7. #52
    Enthusiast baba55 is offline
    MemberRank
    Dec 2014 Join Date
    32Posts

    Re: [Guide] Server 6.0.7 installation steps

    Ini File (argc ! = 2 )
    How to solve this problem


    - - - Updated - - -

    Quote Originally Posted by baba55 View Post
    Ini File (argc ! = 2 )
    How to solve this problem
    you want paid support
    you want paid support
    you want paid support
    you want paid support
    you want paid support


  8. #53
    Apprentice Hangkuro is offline
    MemberRank
    Apr 2015 Join Date
    10Posts

    Re: [Guide] Server 6.0.7 installation steps

    Edit: I´ve got some help, and my problem is solved. Thanks.

    original Post:
    Hey, can anyone help me to start these server ?
    I am not a native english, so i use the german version of SQL.
    I do all points like you say, but i don´t know how i can do this:
    3.2. Use "romuser" account to login to the SQL server again.
    I made a new user „romuser“ here:
    1.jpg

    Is it right to use these „SQL Server-Authentifizierung“ or should i use „Windows-Autentifizierung“ when i create the „romuser“ ?


    But how I can log in in SQL Server ?
    3.jpg


    When i start the Server there is a romuser problem:
    2.jpg
    Last edited by Hangkuro; 14-04-15 at 07:37 PM.

  9. #54
    Novice carrotus is offline
    MemberRank
    Apr 2015 Join Date
    3Posts

    Re: [Guide] Server 6.0.7 installation steps

    thanks for guide and links

  10. #55
    Novice rommaster is offline
    MemberRank
    Apr 2015 Join Date
    3Posts

    Re: [Guide] Server 6.0.7 installation steps

    can someone plz send link for sql management studio becuz it seems to be so many and also if could post a little tuto for sql use would be very appricated thats the only step i am missing ty in advance!

  11. #56
    Founder of EvilSource the1Domo is offline
    [VIP] MemberRank
    Jun 2010 Join Date
    280Posts

    Re: [Guide] Server 6.0.7 installation steps

    I apologize to everyone is trying to use these files without the proper SQL databases these files are useless you're better off trying to use the source code

  12. #57
    Proficient Member Drewww is offline
    MemberRank
    Apr 2015 Join Date
    164Posts

    Re: [Guide] Server 6.0.7 installation steps

    Someone give me some idea how long I have to wait for DataCenter to change status from 'Starting' to 'Online'

    I've noticed sections in 'Common' and 'Service' can take a fair amount of time to come online.

    The log window shows this repeating over and over:

    (1)CNet_ServerList_Child:SendToServer Cant find server [ DATACENTER ][ -1 ]
    Last edited by Drewww; 01-05-15 at 12:43 AM.

  13. #58
    Proficient Member Ness199X is offline
    MemberRank
    Jul 2013 Join Date
    185Posts

    Re: [Guide] Server 6.0.7 installation steps

    Quote Originally Posted by Drewww View Post
    Someone give me some idea how long I have to wait for DataCenter to change status from 'Starting' to 'Online'

    I've noticed sections in 'Common' and 'Service' can take a fair amount of time to come online.

    The log window shows this repeating over and over:

    (1)CNet_ServerList_Child:SendToServer Cant find server [ DATACENTER ][ -1 ]
    Datacenter usually takes about 5-7 minutes to start up, if you set up some sort of clustering it will be much faster.

  14. #59
    Proficient Member Drewww is offline
    MemberRank
    Apr 2015 Join Date
    164Posts

    Re: [Guide] Server 6.0.7 installation steps

    I have no experience with SQL at all, I am not even sure I made the romuser account correctly, and I must admit that I had a bit of trouble with the password generator, I do have a feeling I havn't understood it and made some goofy mistake there. As for the Server Monitor all but DataCenter is online. Not realy sure where to go from here. Ive gone cross eye'd reading so many forum posts now.

  15. #60
    Proficient Member Drewww is offline
    MemberRank
    Apr 2015 Join Date
    164Posts

    Re: [Guide] Server 6.0.7 installation steps

    Finaly got the Server running, Client connects and I can do stuff in game. I was stuck at a few places in this guide, so I will explain it and maybe it can help someone else.

    Step 2 Since I am using MSSQLserver Express you have to change each global.ini file. Change all (local) to (local)\SQLEXPRESS else Datacenter will not connect when running the RA Service Monitor.

    Step 2.3 did not work for me. Searching the forums I saw a solution that worked for me, make a batch file in C:\Runewaker\Server\Realm_01_Service and call it whatever (i did xyz.bat) in that batch file put Start PlayerCenter.exe PlayerCenter.ini then from windows can just double click to start, and you get the Expected error message (long string of letters and numbers seperated with full stops). Can't copy and paste so careful when you type it into the pass generator and yes include the full stops as well.

    Step 3. Don't know much about SQL, most of my time was spent on this step. I used Microsoft SQL Server Express 2012 64bit. and Microsoft SQL Management Studio 64bit. http://www.microsoft.com/en-au/downl....aspx?id=29062 (or google those names). The files I selected were: SQLEXPR_x64_ENU.exe and SQLManagementStudio_x64_ENU.exe
    During the SQL server install the only option I selected was a Local Server and rest i left default. I also chose to not run any updates offered.
    Management studio was a straight install.
    First time running Studio it asked to connect to a server, I connected to the server " .\SqlExpress " with windows login.
    Made a user "romuser" by navigating to Security/Logins, right clicked folder Logins and create new login. Here I selected SQL Server Authentication and made login name as ' romuser ' untick enforce password expiration, untick user must change password. As for password make something you can remember. In other option for Server Roles, User Mapping, Securables I ticked all boxes (not sure if it was needed but I did anyhow). Click OK, and go back in and check Tick Boxes if any are new).
    Disconnected from the server then logged in with new login I made using SQL Server Authentication
    I was then able to go back to the guide and import the schema files one by one and used the Execute option in Studio after each one.
    At step 3.3.4 I chose the slow option (for me was only a couple of minutes). I took slow method cause did not want hidden information.

    When I made my 1st account it did not have GM rights, I then had to go back to SQL Studio, log in as romuser, navigate to databases/ROM_World/Tables/dbo.roledata_account right click it and select TOP 200 ROWS. then in the ManageLv column change the number to 12 and saved that by pressing the arrow button at the bottom of the window (can also give yourself Dias [AccountMoney] and Ruby [BonusMoney] while you are there)
    After that change I logged in that toon and was able to issue the command /gm ? 2013RuneWaker_Rom0628 and almost all of the GM commands I tried worked.

    I get a lot of errors about missing GMTOOLS showing in the RA Serer Controller. I still have not found a working link for them, maybe someone can repost them and info where to put those files.

    I hope my experience helps others.



Advertisement