Rumor 578 Report post Posted February 15, 2014 For years now we've relied on various file leaks which were usually in some Asian language, up until 2010 when someone (nico_w?) released the SG database. Even after this date, we continued to use our old file structures and methods, and old bash scripts to manage our servers. In 2013, some files were released which came from a private server that was based off the SG files. This isn't a thread to talk about who's right or wrong, or who did what work or anything like that... just a place to release files. The reason this release is beneficial is we've never really had a full release of "clean" and "untouched" files. Every time someone releases files they have some stupid backdoor added or are heavily modified from the original. The goal of this release is to get the files to be as close as possible to an official server, and remove things like Xtrap which none of us are using anyway. Official files is what all the pservers are based off of, so having the official structure just makes sense. There are several threads online with files that have been modified by some person but I never see threads with the files the way they originally came. These files in the game folder are from July, 2013 and the game/db cores are fully unmodified and straight from YMIR. That includes lack of modification to make them compatible with certain clients or anything like that. Garbage files like old logs are removed and ready to be generated when you launch your server. These are meant to be a "base server" for the one you want to create. For this reason, there are no customized quests or new items and stuff like that. It's only what SG had in 2013 of July. The database structure is the one from this thread: http://metin2dev.org/board/topic/174-complete-34k-db-structure/#entry950 The item_proto and mob_proto is the one from SG in July 2013. I've included a tool in the download as well used to dump the server proto to the client. Since the goal is purity of files, but some files had to be slightly modified for simplicity (and so they run at all) here's the list of things changed/removed:- Removed panama folder. - Removed old log files and pid files, etc.. - Removed Xcrap stuff - Removed all traces to the above (Symlinks) from install.sh. - Removed cshybridcrypt files. - Modified CONFIG file to guide you into configuration for your own usage. - The quests are from the leak of pserver files based off SG. Some of these may or may not work fully. - Timebomb fix applied (Updated: March 13th, 2014) Now in order to use these files: 1. Upload and untar the database and server files. "untouched_34083_db.tar.gz" goes in "/var/db". 2. Navigate with PuTTy to the game folder as a root user and run this command: "chown -R metin2 .". 3. Navigate to the game folder as the metin2 user and run install.sh. This will setup all the permissions and symlinks correctly. 4. Restart your database with the command "service mysql-server restart". The server can be started and stopped by executing "run.sh" and "shutdown.sh" and logs can be cleared by executing "clear.sh". All of these are found in the game folder. Make sure to "/shutdown" ingame before using "shutdown.sh" or you may have data loss. Don't be alarmed when running the shutdown script, it's normal for PuTTy to not give you a prompt for a while (you haven't disconnected from SSH). How to convert the database proto to a perfect client-side proto: 1. Grab the following files from the conf folder in the server files: mob_proto.txt mob_names.txt item_proto.txt item_names.txt 2. Put those files in a folder with the "dump_proto.exe" tool and run it. It will automatically generate the protos for your client assuming you have followed the correct structure of the txt files.Download:https://mega.co.nz/#!aNp3CJCa!UYpjfJvzWPDejhOTysXTqa-o0bQ_JsC5Q6emudCCQc4 (Updated: March 13th, 2014)- No password (I don't believe in putting passwords on archives released to the public). 34 1 Share this post Link to post Share on other sites
Mehti 47 Report post Posted February 15, 2014 Your shares always clearly. Who want make new server, choose this file. Share this post Link to post Share on other sites
HITRON 45 Report post Posted February 15, 2014 What client i can use? Share this post Link to post Share on other sites
Sanchez 934 Report post Posted February 15, 2014 I think 36071 binary is good, you should try it. Share this post Link to post Share on other sites
Rumor 578 Report post Posted February 15, 2014 I haven't tried that one but I know that 34669 and 36469 work. I don't have 34669 on hand but I have these 36469 ones working with 34083. hackshield edition: https://mega.co.nz/#!WURm1QCY!v2d9s6KVBEtKYl21JQe1GtcHoQVe3KId8r9PpK3Rnlc (just copy hshield from official client) non-hs edition: https://mega.co.nz/#!uQ5RhD5A!KkCCyZdrBtQdotuinVHbGze8odc6gqaOfO2yMRPCJjA Share this post Link to post Share on other sites
ATAG 111 Report post Posted February 15, 2014 r34669 was the official binary for this release... https://mega.co.nz/#!jgAzmRYY!aT014TGBswD_PvPiDsvHJi5E--RxXtFX7ODlqWUuDFM Share this post Link to post Share on other sites
Rumor 578 Report post Posted February 15, 2014 Updated link, one of the CONFIG files was missing. Share this post Link to post Share on other sites
Maslovicz 69 Report post Posted February 16, 2014 Can you help me please? I try install this file and this is my error: Share this post Link to post Share on other sites
Shogun 1,565 Report post Posted February 17, 2014 Can you help me please? I try install this file and this is my error:Which error? This loos fine to me 1 Share this post Link to post Share on other sites
Rumor 578 Report post Posted February 17, 2014 yeah looks normal by the way, cd means change directory, you don't need to do it every time you want to stay in the same folder before doing another command. 1 Share this post Link to post Share on other sites
Maslovicz 69 Report post Posted February 17, 2014 Server not start, when i open config file from channel, config files haven't set map-allow and etc... sorry for my english Share this post Link to post Share on other sites
SøηGøku® 0 Report post Posted February 17, 2014 How do i move the files to cd /usr/home? Best Regards. Share this post Link to post Share on other sites
Maslovicz 69 Report post Posted February 17, 2014 I use freebsd 8.3 32bit and in /usr/locale/lib/metin2 i dont have any libs... can you upload libs? Thank you, and thank you for files and great support! Share this post Link to post Share on other sites
Rumor 578 Report post Posted February 17, 2014 Server not start, when i open config file from channel, config files haven't set map-allow and etc... sorry for my english When you start with this script, it doesn't show you all the start data like how most admins of pservers are used to. The cores are launched in vrunner. Type "ps" to see what's running. How do i move the files to cd /usr/home?Best Regards. Here's an example of how to move the files in PuTTy, assuming that /home/metin2 is the directory where your files currently are.mv /home/metin2 /usr/homemv = move/home/metin2 = current directory you wish to move/usr/home = directory you want to move the entire "metin2" folder to I use freebsd 8.3 32bit and in /usr/locale/lib/metin2 i dont have any libs... can you upload libs?Thank you, and thank you for files and great support! The libs don't belong in that directory. For a 32-bit system they belong in /usr/lib32. https://mega.co.nz/#!gJZ3WKLA!Idqx_SYE4cqQ_wPfcj-ObWvdsCYEv0SSoBViyVUDIOY 2 Share this post Link to post Share on other sites
Maslovicz 69 Report post Posted February 17, 2014 Ok, i start server and type "ps" with root user: (server started by metin2 user) This is first file when i have a problem Share this post Link to post Share on other sites
Rumor 578 Report post Posted February 17, 2014 It looks like something is missing that allows the game to be launched at all.You could try this..1) go to where your metin channels are..2)cd channel1/first && ./game &3) After it's done sending text in PuTTy do CTRL+C.You should see some output when starting the server this way. Share this post Link to post Share on other sites
Maslovicz 69 Report post Posted February 17, 2014 root# cd /home/game root# cd channel1/first && ./game & [1] 1649 root# /libexec/ld-elf.so.1: Shared object "libmd.so.4" not found, required by "game" I wrote it right? Share this post Link to post Share on other sites
Rumor 578 Report post Posted February 17, 2014 Yes, you're missing the libs. Try this:fetch http://176.31.181.168/libs.tar.gz tar Jxpvf lib.tar.gz -C / rm lib.tar.gzThen try starting the server Share this post Link to post Share on other sites
Maslovicz 69 Report post Posted February 17, 2014 root# cd auth && ./auth & [1] 2097 Dexter# PUBLIC_IP: MY IP interface em0 HOSTNAME: Auth01 AsyncSQL: connected to 127.0.0.1 (reconnect 1) CommonSQL connected COMMON_SQL: DirectQuery failed : SELECT mKey, mValue FROM locale And this is new error Libs working perfectly! Share this post Link to post Share on other sites
Rumor 578 Report post Posted February 17, 2014 root# cd auth && ./auth & [1] 2097 Dexter# PUBLIC_IP: MY IP interface em0 HOSTNAME: Auth01 AsyncSQL: connected to 127.0.0.1 (reconnect 1) CommonSQL connected COMMON_SQL: DirectQuery failed : SELECT mKey, mValue FROM locale And this is new error Libs working perfectly!Take a look in your files for the country name in the locale folder:Make sure this is the same name when you check the database: 1 Share this post Link to post Share on other sites
Maslovicz 69 Report post Posted February 17, 2014 I have empty locale in common... Share this post Link to post Share on other sites
Rumor 578 Report post Posted February 17, 2014 /* Navicat MySQL Data Transfer Source Server : Metin2Nirvana@CloudCom Source Server Version : 50616 Source Host : Source Database : common Target Server Type : MYSQL Target Server Version : 50616 File Encoding : 65001 Date: 2014-02-17 07:54:27 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `locale` -- ---------------------------- DROP TABLE IF EXISTS `locale`; CREATE TABLE `locale` ( `mKey` varchar(255) NOT NULL DEFAULT '', `mValue` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`mKey`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- ---------------------------- -- Records of locale -- ---------------------------- INSERT INTO `locale` VALUES ('SKILL_POWER_BY_LEVEL_TYPE0', '0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125'); INSERT INTO `locale` VALUES ('SKILL_POWER_BY_LEVEL_TYPE1', '0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125'); INSERT INTO `locale` VALUES ('SKILL_POWER_BY_LEVEL_TYPE2', '0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125'); INSERT INTO `locale` VALUES ('SKILL_POWER_BY_LEVEL_TYPE3', '0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125'); INSERT INTO `locale` VALUES ('SKILL_POWER_BY_LEVEL_TYPE4', '0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125'); INSERT INTO `locale` VALUES ('SKILL_POWER_BY_LEVEL_TYPE5', '0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125'); INSERT INTO `locale` VALUES ('SKILL_POWER_BY_LEVEL_TYPE6', '0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125'); INSERT INTO `locale` VALUES ('SKILL_POWER_BY_LEVEL_TYPE7', '0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125'); INSERT INTO `locale` VALUES ('LOCALE', 'singapore'); INSERT INTO `locale` VALUES ('DB_NAME_COLUMN', 'locale_name'); INSERT INTO `locale` VALUES ('SKILL_DAMAGE_BY_LEVEL_UNDER_90', '0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0'); INSERT INTO `locale` VALUES ('SKILL_DAMAGE_BY_LEVEL_UNDER_45', '0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0'); INSERT INTO `locale` VALUES ('SKILL_POWER_BY_LEVEL', '0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125'); Run this query 2 Share this post Link to post Share on other sites
Maslovicz 69 Report post Posted February 17, 2014 Thank you, server started. And finish question: Ports: CH1: 13001 Auth: 11000 Its okey? SYSERR: Feb 17 16:26:56 :: pid_init: Start of pid: 1419 SYSERR: Feb 17 16:26:56 :: socket_connect: HOST 127.0.0.1:15000, could not connect. SYSERR: Feb 17 16:26:59 :: socket_connect: HOST 127.0.0.1:15000, could not connect. SYSERR: Feb 17 16:27:02 :: socket_connect: HOST 127.0.0.1:15000, could not connect. SYSERR: Feb 17 16:27:05 :: socket_connect: HOST 127.0.0.1:15000, could not connect. SYSERR: Feb 17 16:27:08 :: socket_connect: HOST 127.0.0.1:15000, could not connect. SYSERR: Feb 17 16:27:11 :: socket_connect: HOST 127.0.0.1:15000, could not connect. SYSERR: Feb 17 16:27:14 :: socket_connect: HOST 127.0.0.1:15000, could not connect. ;( EDIT: OK, fixed and work great, thank you for support! Have a nice day Share this post Link to post Share on other sites
Rumor 578 Report post Posted February 17, 2014 check if mysql is running: service mysql-server status If it isn't running, start it: service mysql-server start Did you make sure the CONFIG files have the correct username/password to connect to the database? Also have you granted privileges to the user? Share this post Link to post Share on other sites
Maslovicz 69 Report post Posted February 17, 2014 SYSERR: Feb 17 20:03:46 :: Start: TABLE_POSTFIX not configured use default SYSERR: Feb 17 20:04:01 :: socket_bind: bind: Address already in use SYSERR: Feb 17 20:04:01 :: Process: FDWATCH: peer null in event: ident 20 SYSERR: Feb 17 20:04:02 :: pid_deinit: End of pid SYSERR: Feb 17 20:04:02 :: Process: FDWATCH: peer null in event: ident 21 SYSERR: Feb 17 20:04:09 :: pid_init: Start of pid: 1992 SYSERR: Feb 17 20:04:09 :: Start: TABLE_POSTFIX not configured use default SYSERR: Feb 17 20:04:20 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='IP.IP.IP.IP') SYSERR: Feb 17 20:04:20 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='IP.IP.IP.IP') SYSERR: Feb 17 20:04:38 :: Process: FDWATCH: peer null in event: ident 24 SYSERR: Feb 17 20:04:39 :: Process: FDWATCH: peer null in event: ident 23 SYSERR: Feb 17 20:04:42 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='IP.IP.IP.IP') SYSERR: Feb 17 20:04:42 :: socket_bind: bind: Address already in use SYSERR: Feb 17 20:04:42 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='IP.IP.IP.IP') SYSERR: Feb 17 20:04:46 :: Process: FDWATCH: peer null in event: ident 21 SYSERR: Feb 17 20:04:47 :: Process: FDWATCH: peer null in event: ident 20 SYSERR: Feb 17 20:04:48 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='IP.IP.IP.IP') SYSERR: Feb 17 20:04:49 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='IP.IP.IP.IP') This is DB syserr... When i try to login, klient only flash and kick to login screen... (Sorry for my crap english)... Share this post Link to post Share on other sites
