Fully untouched 34083 server files & DB

[Rumor 578]

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

[Mehti 47]

Your shares always clearly. Who want make new server,  choose this file.

[HITRON 45]

What client i can use?

[Sanchez 933]

I think 36071 binary is good, you should try it.

[Rumor 578]

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

[ATAG 111]

r34669 was the official binary for this release...

 

https://mega.co.nz/#!jgAzmRYY!aT014TGBswD_PvPiDsvHJi5E--RxXtFX7ODlqWUuDFM

[Rumor 578]

Updated link, one of the CONFIG files was missing.

[Maslovicz 69]

Can you help me please? I try install this file and this is my error:

[Shogun 1,561]

Can you help me please? I try install this file and this is my error:

Which error? This loos fine to me

[Rumor 578]

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.

[Maslovicz 69]

Server not start, when i open config file from channel, config files haven't set map-allow and etc... sorry for my english

[SøηGøku® 0]

How do i move the files to cd /usr/home?

 

 

 

Best Regards.

[Maslovicz 69]

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!

[Rumor 578]

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/home

mv = 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

[Maslovicz 69]

Ok, i start server and type "ps" with root user: (server started by metin2 user)

This is first file when i have a problem 

[Rumor 578]

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.

[Maslovicz 69]

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?

[Rumor 578]

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

Then try starting the server

[Maslovicz 69]

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!

[Rumor 578]

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:

[Maslovicz 69]

I have empty locale in common...

[Rumor 578]

/*
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

[Maslovicz 69]

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

[Rumor 578]

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?

[Maslovicz 69]

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