Jump to content

raihan3

Member
  • Posts

    226
  • Joined

  • Last visited

  • Feedback

    0%

Posts posted by raihan3

  1. Hi folks!

    I see no longer sell so I share it with you.

    Source come with yang max changed.

    DOWNLOAD:

    https://mega.co.nz/#!hNtTzZaI!62SdlWJn4LJXFzh8t8RizCo1wbXR2Hww5Nq-SyGBMkM
    https://mega.co.nz/#!QEd3GZDZ!A6V-bUgm38JY-bYLrN2duodPGSimMiE-XR7nPGmgZ2g
    https://mega.co.nz/#!9MNgVIIS!b_lH-clYf1rRtvpa-By9e92fdS4blFwrSN00TBK44Lg
    Archive password:
    morphe_just4metin.ro

    3rd link is not available

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

    rumor do you have 40k serverfile

  3. Hi guys,

    We are going to open a  server SerenMT2
    It will be an international server .so if a good team can be get earning and player amount will be too good and well populated .

    server will be

    max lvl :250
    game : PVP

    Max PV: 25k

    Max PM: 15k

    Aparare Sabie: 20
    Aparare Pumnal: 20
    Aparare 2Maini: 20
    Aparare Magie: 20
    Aparare Sageti: 20
    Semi-om: 100
    Critica: 100
    Patrunzatoare: 100
    STR: 100
    DEX: 100
    INT: 100
    VIT: 100


    Staff  will be :
    CM  ( we are in search of 1 Community Manager)
    BA  ( We are in search of 1 Board Administrator)
    QA  (we are searching 1 Quality assurance officer)
    GA  ( we are searching 2 Game administrator)
    SGM  ( we are searcing 2Super Game Master)
    MOD ( we are searching 3 Moderator)
    GM ( we are searching 5  game master of different country)
    JGM ( 2 junior game masters of different country)

    DEV ( 2 developer 1 must be romaninan)

    For Apply contact skype : umor.raihan
     

  4. the mysql problem happen to me many time (more then 20 time last week) i think thats because the orginal mysql

    This is the hidden content, please
    has been changed

    the best solution is to rebuilt it as Shogun said and give it a other user and pass

    to installarrow-10x10.png the mysql server 56:

    cd /usr/ports/databases/mysql56-server
    make BUILD_OPTIMIZED=yes BUILD_STATIC=yes
    make WITH_XCHARSET=all install clean

    then

    ee /etc/rc.conf

    make sure that this line is written

    mysql_enable="YES"

    to give root it password

    service mysql-server start
    /usr/local/bin/mysqladmin -uroot password 'enterpassword'

    change 'enterpassword' by your pass word it should look like this

    
    /usr/local/bin/mysqladmin -uroot password metin2dev

    in this case metin2dev is the pass for mysql-server

    then

    mysql -p
    GRANT ALL PRIVILEGES ON *.* TO 'rumor'@'%'
    IDENTIFIED BY 'password' WITH GRANT OPTION;
    GRANT ALL PRIVILEGES ON *.* TO 'metin2'@'localhost'
    IDENTIFIED BY 'password' WITH GRANT OPTION;
    quit

    here rumor is the accountarrow-10x10.png you should use if you have a root server

    some may have the question why not using root

    well its highly recommended not to use root nor for mysql nor sftp nor ftp nor ssh

    ah and change 'password' with your 'passwordhere'

    and good luck

    thanks to Rumor for his topic here

    night i have problem on mysql too i followed this but say

    /usr/local/bin/mysqladmin: connect to server at 'localhost' failed
    error: 'Access denied for user 'root'@'localhost' (using password: NO)'

     

     
    • Metin2 Dev 1
    • Love 1
  5. Is MYSQL working? Do you have an OVH server? There may be an issue with mysql where it won't even run.

    pwd_mkdb -p /etc/master.passwd
    chown -R mysql /var/db/mysql && chgrp -R mysql /var/db/mysql
    service mysql-server start
    /usr/local/bin/mysqladmin -uroot password 'enterpassword'

    i also followed this but same it say

    /usr/local/bin/mysqladmin: connect to server at 'localhost' failed
    error: 'Access denied for user 'root'@'localhost' (using password: NO)'
    root@localhost:~ #

     

     
  6. Your MYSQL server is down for some reason, check /var/db/mysql/[hostname].err

    shougun in my hostname.err i see it can you see where is error

     

    150714 18:47:28 mysqld_safe mysqld from pid

    This is the hidden content, please
    /var/db/mysql/localhost.pid ended
    150714 18:48:24 mysqld_safe Startingarrow-10x10.png mysqld daemon with databases from /var/db/mysql
    2015-07-14 18:48:26 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
    2015-07-14 18:48:26 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.24) starting as process 798 ...
    2015-07-14 18:48:26 798 [Note] Plugin 'FEDERATED' is disabled.
    2015-07-14 18:48:26 798 [Note] InnoDB: Using atomics to ref count buffer pool pages
    2015-07-14 18:48:26 798 [Note] InnoDB: The InnoDB memory heap is disabled
    2015-07-14 18:48:26 798 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    2015-07-14 18:48:26 798 [Note] InnoDB: Memory barrier is not used
    2015-07-14 18:48:26 798 [Note] InnoDB: Compressed tables use zlib 1.2.3
    2015-07-14 18:48:26 798 [Note] InnoDB: Not using CPU crc32 instructions
    2015-07-14 18:48:26 798 [Note] InnoDB: Initializing buffer pool, size = 128.0M
    2015-07-14 18:48:26 798 [Note] InnoDB: Completed initialization of buffer pool
    2015-07-14 18:48:26 798 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
    2015-07-14 18:48:26 798 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
    2015-07-14 18:48:26 798 [Note] InnoDB: Database physically writes the file full: wait...
    2015-07-14 18:48:27 798 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
    2015-07-14 18:48:29 798 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
    2015-07-14 18:48:30 798 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
    2015-07-14 18:48:30 798 [Warning] InnoDB: New log files created, LSN=45781
    2015-07-14 18:48:30 798 [Note] InnoDB: Doublewrite buffer not found: creating new
    2015-07-14 18:48:31 798 [Note] InnoDB: Doublewrite buffer created
    2015-07-14 18:48:31 798 [Note] InnoDB: 128 rollback segment(s) are active.
    2015-07-14 18:48:31 798 [Warning] InnoDB: Creating foreign key constraint system tables.
    2015-07-14 18:48:31 798 [Note] InnoDB: Foreign key constraint system tables created
    2015-07-14 18:48:31 798 [Note] InnoDB: Creating tablespace and datafile system tables.
    2015-07-14 18:48:31 798 [Note] InnoDB: Tablespace and datafile system tables created.
    2015-07-14 18:48:31 798 [Note] InnoDB: Waiting for purge to start
    2015-07-14 18:48:31 798 [Note] InnoDB: 5.6.24 started; log sequence number 0
    /usr/local/libexec/mysqld: Error on delete of './auto.cnf' (Errcode: 2 - No such file or directory)
    2015-07-14 18:48:31 798 [Warning] World-writable config file './auto.cnf' has been removed.

    2015-07-14 18:48:31 798 [Warning] No existing UUID has been found, so we assume that this is the first timearrow-10x10.png that this server has been started. Generating a new UUID: 28da7a29-2a48-11e5-a13d-0200003be049.
    2015-07-14 18:48:31 798 [Note] Server hostname (bind-address): '*'; port: 3306
    2015-07-14 18:48:31 798 [Note] IPv6 is available.
    2015-07-14 18:48:31 798 [Note]   - '::' resolves to '::';
    2015-07-14 18:48:31 798 [Note] Server socket created on IP: '::'.
    2015-07-14 18:48:31 798 [ERROR] Column count of mysql.events_waits_current is wrong. Expected 19, found 16. Created with MySQL 50537, now running 50624. Please use mysql_upgrade to fix this error.
    2015-07-14 18:48:31 798 [ERROR] Column count of mysql.events_waits_history is wrong. Expected 19, found 16. Created with MySQL 50537, now running 50624. Please use mysql_upgrade to fix this error.
    2015-07-14 18:48:31 798 [ERROR] Column count of mysql.events_waits_history_long is wrong. Expected 19, found 16. Created with MySQL 50537, now running 50624. Please use mysql_upgrade to fix this error.
    2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure
    2015-07-14 18:48:31 798 [ERROR] Incorrect definition of table performance_schema.events_waits_summary_by_thread_by_event_name: expected column 'THREAD_ID' at position 0 to have type bigint(20), found type int(11).
    2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure
    2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure
    2015-07-14 18:48:31 798 [ERROR] Column count of mysql.file_summary_by_event_name is wrong. Expected 23, found 5. Created with MySQL 50537, now running 50624. Please use mysql_upgrade to fix this error.
    2015-07-14 18:48:31 798 [ERROR] Column count of mysql.file_summary_by_instance is wrong. Expected 25, found 6. Created with MySQL 50537, now running 50624. Please use mysql_upgrade to fix this error.
    2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'host_cache' has the wrong structure
    2015-07-14 18:48:31 798 [ERROR] Incorrect definition of table performance_schema.mutex_instances: expected column 'LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11).
    2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'objects_summary_global_by_type' has the wrong structure
    2015-07-14 18:48:31 798 [ERROR] Incorrect definition of table performance_schema.rwlock_instances: expected column 'WRITE_LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11).
    2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'setup_actors' has the wrong structure
    2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'setup_objects' has the wrong structure
    2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_index_usage' has the wrong structure
    2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_table' has the wrong structure
    2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'table_lock_waits_summary_by_table' has the wrong structure
    2015-07-14 18:48:31 798 [ERROR] Column count of mysql.threads is wrong. Expected 14, found 3. Created with MySQL 50537, now running 50624. Please use mysql_upgrade to fix this error.
    2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_stages_current' has the wrong structure
    2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_stages_history' has the wrong structure
    2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_stages_history_long' has the wrong structure
    2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_thread_by_event_name' has the wrong structure
    2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_account_by_event_name' has the wrong structure
    2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_user_by_event_name' has the wrong structure
    2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_host_by_event_name' has the wrong structure
    2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_stages_summary_global_by_event_name' has the wrong structure
    2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_statements_current' has the wrong structure
    2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_statements_history' has the wrong structure
    2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_statements_history_long' has the wrong structure
    2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_thread_by_event_name' has the wrong structure
    2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure
    2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure
    2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure
    2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure
    2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure
    2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'users' has the wrong structure
    2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema' 'accounts'arrow-10x10.png has the wrong structure
    2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure
    2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure
    2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure
    2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure
    2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure
    2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure
    2015-07-14 18:48:31 798 [Note] Event Scheduler: Loaded 0 events
    2015-07-14 18:48:31 798 [Note] /usr/local/libexec/mysqld: ready for connections.
    Version: '5.6.24'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
    2015-07-15 05:36:02 798 [Warning] IP address '198.13.107.123' could not be resolved: hostname nor servname provided, or not known

     

     

     

    /usr/local/bin/mysqladmin: connect to server at 'localhost' failed
    error: 'Access denied for user 'root'@'localhost' (using password: NO)'

     

     

    Wrong password / host, Check mysql.user table

    Shogun where i find /host for check mysql.user table

     
×
×
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.