API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 14th, 2019
449
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.49 KB | None | 0 0
raw download clone embed print report
  1. THESE ARE NOT BEST PRACTICES. THESE ARE TO GET YOUR SERVER RUNNING IN SQL MODE. TUNING OF PERMISSIONS AND ACCESS ARE RECOMENDED BUT ARE NOT IN THE SCOPE OF THIS GUIDE.
  2. Installing the Database instance and SQL management studio:
  3. 1. Grab Sql Server Express 2017 from microsoft https://www.microsoft.com/en-us/download/details.aspx?id=55994
  4. 2. Install. Basic or custom is OK. Custom will allow you to choose where it is installed to and not much else. This installs the install media.
  5. 3. SQL Server Installation Center should open after download. Click New SQL Server Standalone installation n or add features to an existing installataion.
  6. 4. SQL Server 2017 Setup will start. Accept the license terms. click Next.
  7. 5. You may get a warning about windows firewall for the rules check. Firewall setup is outside the scope of this tutorial.
  8. 6. Feature selection: Uncheck Machine Learning services- we won't need them. Take other defaults and click next.
  9. 7. Name your instance. Mabinogi for the instance is reccomended. Click next.
  10. 8. Take defaults. click next.
  11. 9. Database engine configuration : Take defaults.Specify your user account if it isn't already in the SQL admins. click next
  12. 10. Wait for install to complete and all items should say Succeeded. Click close. If anything messed up you're on your own buddy.
  13. 11. In the installation center menu click install SQL server management Tools. It'll just take you to the webpage to download and install the management center. https://go.microsoft.com/fwlink/?linkid=2043154 if you're lazy for the link.
  14. 12. Run installer. Click Install.
  15.  
  16.  
  17. Loading the database backups:
  18. Open SQl Server configuration manager from start menu.
  19. Open Sql Server network config from the side bar. select Protocols for MABINOGI
  20. Double click TCP/IP
  21. change enable to Yes. Go to IP addresses tab
  22. find your IP address in the list (number changes depending on number of network adapters) set enabled to Yes and TCP port to 1433
  23. Go to SQL server Services in the side bar. Right click SQL Server (MABINOGI) and select restart
  24. Open SQL Management Studio
  25. connect to server .\Mabinogi.
  26. Right click databases then select restore: In general change radio button to device. click ... to the right
  27. Click Add and browse to extracted database backups.
  28. Click Ok click OK. Wait for restore. Repeat with all databases. Shop is an older database format - you can ignore this one. Authenitcator uses it I believe? Outside scope of this guide.
  29. Expand Security and logins
  30. Right click logins and create a new login
  31. user : mabi_admin
  32. Select radio button to create a SQL server authenticated user. put in password
  33. Go to user mapping on the side bar. check mark all the databases you imported earlier. select each of those databases and assign the db admin role down below.
  34. click OK
  35. Go to your DB_XML server directory on your mabiserver files. Open config.xml
  36. Refer to exmaple config.xml below for structure. In short under each connection line specify the connection, server, database name, user name and password you created earlier. connection strings for some databases have been omitted as I hadn't worked them all out yet.
  37. save and run your server.
  38.  
  39. You'll have to add accounts in your SQL database. Accounts are stored in the mabinogi database in the account table. Password is stored as an MD5 hash. Example SQL for inserting an account. In the db leak were a handful of pre-made accounts.
  40.  
  41. use mabinogi
  42. insert into account (id, password, name, serialnumber, email, flag, blocking_date, blocking_duration, authority, provider_code, machineids) VALUES
  43. ('test', '098F6BCD4621D373CADE4E832627B4F6', 'test', '111111-1111111','na' ,'-1', getdate(), '0', '0', NULL, '')
  44.  
  45. Example config.xml
  46.  
  47. <?xml version="1.0" encoding="utf-16"?>
  48. <configration xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  49. <sql>
  50. <connections>
  51. <account server="10.0.0.10\MABINOGI" database="mabinogi" user="mabi_admin" password="mabinogi" />
  52. <accountref server="10.0.0.10\MABINOGI" database="mabinogi" user="mabi_admin" password="mabinogi" />
  53. <character server="10.0.0.10\MABINOGI" database="mabinogi" user="mabi_admin" password="mabinogi" />
  54. <prop server="10.0.0.10\MABINOGI" database="mabinogi" user="mabi_admin" password="mabinogi" />
  55. <bank server="10.0.0.10\MABINOGI" database="mabinogi" user="mabi_admin" password="mabinogi" />
  56. <itemidpool server="10.0.0.10\MABINOGI" database="mabinogi" user="mabi_admin" password="mabinogi" />
  57. <charidpool server="10.0.0.10\MABINOGI" database="mabinogi" user="mabi_admin" password="mabinogi" />
  58. <propidpool server="10.0.0.10\MABINOGI" database="mabinogi" user="mabi_admin" password="mabinogi" />
  59. <guild server="10.0.0.10\MABINOGI" database="mabi_guild" user="mabi_admin" password="mabinogi" />
  60. <guildidpool server="10.0.0.10\MABINOGI" database="mabi_guild" user="mabi_admin" password="mabinogi" />
  61. <websynch server="10.0.0.10\MABINOGI" database="mabinogi" user="mabi_admin" password="mabinogi" />
  62. <castle server="10.0.0.10\MABINOGI" database="mabinogi" user="mabi_admin" password="mabinogi" />
  63. <house server="10.0.0.10\MABINOGI" database="mabinogi" user="mabi_admin" password="mabinogi" />
  64. <memo server="10.0.0.10\MABINOGI" database="mabinogi" user="mabi_admin" password="mabinogi" />
  65. <chronicle server="10.0.0.10\MABINOGI" database="mabi_Chronicle" user="mabi_admin" password="mabinogi" />
  66. <ruin server="10.0.0.10\MABINOGI" database="mabinogi" user="mabi_admin" password="mabinogi" />
  67. <houseguestbook server="10.0.0.10\MABINOGI" database="mabinogi" user="mabi_admin" password="mabinogi" />
  68. <shopadvertise server="10.0.0.10\MABINOGI" database="shopadvertise" user="mabi_admin" password="mabinogi" />
  69. <dungeonrank server="10.0.0.10\MABINOGI" database="mabi_charPVP" user="mabi_admin" password="mabinogi" />
  70. <channelingkeypool server="10.0.0.10\MABINOGI" database="mabinogi" user="mabi_admin" password="mabinogi" />
  71. <promotionrank server="10.0.0.10\MABINOGI" database="mabinogi" user="mabi_admin" password="mabinogi" />
  72. <mailbox server="10.0.0.10\MABINOGI" database="mabinogi" user="mabi_admin" password="mabinogi" />
  73. <farm server="10.0.0.10\MABINOGI" database="mabinogi" user="mabi_admin" password="mabinogi" />
  74. <bid server="10.0.0.10\MABINOGI" database="mabinogi" user="mabi_admin" password="mabinogi" />
  75. <bididpool server="10.0.0.10\MABINOGI" database="mabinogi" user="mabi_admin" password="mabinogi" />
  76. <event server="10.0.0.10\MABINOGI" database="mabinogi" user="mabi_admin" password="mabinogi" />
  77. <worldmeta server="10.0.0.10\MABINOGI" database="mabinogi" user="mabi_admin" password="mabinogi" />
  78. <wine server="10.0.0.10\MABINOGI" database="mabinogi" user="mabi_admin" password="mabinogi" />
  79. <royalalchemist server="10.0.0.10\MABINOGI" database="mabinogi" user="mabi_admin" password="mabinogi" />
  80. <husky server="211.39.128.170,1433" database="petcity" user="mabi_event" password="mabi_event" />
  81. <event server="10.0.0.10\MABINOGI" database="mabinogi" user="mabi_admin" password="mabinogi" />
  82. <privatefarm server="10.0.0.10\MABINOGI" database="mabinogi" user="mabi_admin" password="mabinogi" />
  83. <facilityidpool server="10.0.0.10\MABINOGI" database="mabinogi" user="mabi_admin" password="mabinogi" />
  84. <scrapbook server="10.0.0.10\MABINOGI" database="mabinogi" user="mabi_admin" password="mabinogi" />
  85. <commerce server="10.0.0.10\MABINOGI" database="mabinogi" user="mabi_admin" password="mabinogi" />
  86. <commercesystem server="10.0.0.10\MABINOGI" database="mabinogi" user="mabi_admin" password="mabinogi" />
  87. <commercecriminal server="10.0.0.10\MABINOGI" database="mabinogi" user="mabi_admin" password="mabinogi" />
  88. <recommend server="10.0.0.10\MABINOGI" database="mabinogi" user="mabi_admin" password="mabinogi" />
  89. <setinfo server="10.0.0.10\MABINOGI" database="mabinogi" user="mabi_admin" password="mabinogi" />
  90. <equipmentcollection server="10.0.0.10\MABINOGI" database="mabinogi" user="mabi_admin" password="mabinogi" />
  91. <linkedapcharacter server="10.0.0.10\MABINOGI" database="mabinogi" user="mabi_admin" password="mabinogi" />
  92. <soulmate server="10.0.0.10\MABINOGI" database="mabinogi" user="mabi_admin" password="mabinogi" />
  93. <personalranking server="10.0.0.10\MABINOGI" database="mabinogi" user="mabi_admin" password="mabinogi" />
  94. <mabinovel server="10.0.0.10\MABINOGI" database="mabi_novel" user="mabi_admin" password="mabinogi" />
  95. <mabinovelboard server="10.0.0.10\MABINOGI" database="mabi_novel" user="mabi_admin" password="mabinogi" />
  96. </connections>
  97. </sql>
  98. </configration>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!