Jump to content

CjMt2

Inactive Member
  • Posts

    51
  • Joined

  • Last visited

  • Feedback

    0%

Everything posted by CjMt2

  1. 1. connect to mysql server with putty in standard console 2. create user from any host in mysql console 3. create rigts for user in mysql console 4. make sure the user has active privileges in mysql console 5. exit from mysql server in mysql console 6. back to standard putty console Be careful: 'databasename' is the name of your database, repeat this for account, common, hotbackup, log, metin2_runup, player, etc. 'username' is the username of your MySQL or MariaDB user account 'password' is the password required for that username 1. $ mysql -u root -p 2. mysql> CREATE USER 'username'@'%' IDENTIFIED BY 'password'; 3. mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES ON databasename.* TO 'username'@'%' IDENTIFIED BY 'password'; 4. mysql> FLUSH PRIVILEGES; 5. mysql> QUIT; 6. $
  2. Open settings for your machine in VirtualBox with (wm must be close) Go to Network see this (remove spaces) : Replace with your network card and Save Start virtual machine and enjoy.
  3. mysqlcheck -u root -p --auto-repair -c -o --all-databases
  4. Simply make deinstall all mysql ports. reboot portsnap fetch update cd /usr/ports/databases/mysql57-server/ && make install clean Last command do any necessary job for your working copy of mysql server. Learn from correct source: [Hidden Content]
  5. After years I realized that what you find for free on the internet is usually broken or inoperative in most cases. As for how general the question is, I can only say that from the lack of permission to write on the file or permission to read on the way to the file to the broken source code can be anything.
  6. $ gcc -v Using built-in specs. COLLECT_GCC=gcc COLLECT_LTO_WRAPPER=/usr/local/libexec/gcc9/gcc/i386-portbld-freebsd12.2/9.3.0/lto-wrapper Target: i386-portbld-freebsd12.2 Configured with: /wrkdirs/usr/ports/lang/gcc9/work/gcc-9.3.0/configure --disable-multilib --with-build-config=bootstrap-debug --disable-nls --enable-gnu-indirect-function --enable-plugin --libdir=/usr/local/lib/gcc9 --libexecdir=/usr/local/libexec/gcc9 --program-suffix=9 --with-as=/usr/local/bin/as --with-gmp=/usr/local --with-gxx-include-dir=/usr/local/lib/gcc9/include/c++/ --with-ld=/usr/local/bin/ld --with-pkgversion='FreeBSD Ports Collection' --with-system-zlib --without-zstd --enable-languages=c,c++,objc,fortran --prefix=/usr/local --localstatedir=/var --mandir=/usr/local/man --infodir=/usr/local/share/info/gcc9 --build=i386-portbld-freebsd12.2 Thread model: posix gcc version 9.3.0 (FreeBSD Ports Collection) warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. $ gcc --version gcc (FreeBSD Ports Collection) 9.3.0 Copyright (C) 2019 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
  7. Replace in your all Makefile(s) g++7 with result of gcc --version returned in FreeBSD console Use ee filename not windows editor because encoding incompatibility.
  8. I downloaded FreeBSD black.code 12.0-RELEASE FreeBSD 12.0-RELEASE r341666 GENERIC i386 After cd /usr/src/example/game/src, gmake clean and gmake my compilation fail with What can I do to solve this problem? Thanks
  9. Classic Metin2 is rain version not this.
  10. 0123 03:55:00403 :: importing from pack debugInfo 0123 03:55:00406 :: name '__COMMAND_LINE__' is not defined 0123 03:55:08291 :: Traceback: Call: File "<string>", line 1, in <module> Call: File "system.py", line 1, in <module> Error: name '__COMMAND_LINE__' is not defined 0123 03:55:08317 :: SYSERR: RunMain Error This is from my log.txt
  11. The file you are trying to download is no longer available.
  12. Go to cd cores/db && ./db& ==> db.core ok cd /db/src && gmake -j12 ==> error: template <typename T> T MIN(T a, T b) uname -a --> FreeBSD 11.2-RELEASE-p8, gcc49 from FreeBSD ports, same result with cryptopp from ports or your Extern Now your files is unusable
  13. I'm now going to make a virtual machine vmv with FreeBSD 11 and the ones needed to compile and run the server. The problem is I do not know the client so anyone can help me or we can never test what we did.
  14. Why not <code> mv /usr/home/metin2/metin2/dev/Srcs/Extern/lib/libmysqlclient.a /usr/home/metin2/metin2/dev/Srcs/Extern/lib/libmysqlclient.a.BACKUP ln -s /usr/local/lib/mysql/libmysqlclient.a /usr/home/metin2/metin2/dev/Srcs/Extern/lib/libmysqlclient.a </code> For my this is the simplest solution.
  15. Do you have user/gropup mysql? If not, create manualy user and group mysql (nologin) and try to start mysql safe first.
  16. If is possible please post source of this server. I have this files on dedicated (PowerEdge) server but is necesary to fix some bugs before can be playable online. If someone know one website script with lycan please post here and save me from hours of work in php (hen cms) TankYou in advance.
  17. CREATE TABLE IF NOT EXISTS `mob_proto` ( `vnum` int(11) NOT NULL DEFAULT '0', `name` varbinary(48) NOT NULL DEFAULT 'Noname ', `locale_name` varbinary(48) NOT NULL DEFAULT 'Noname ', `type` tinyint(2) NOT NULL DEFAULT '0', `rank` tinyint(2) NOT NULL DEFAULT '0', `battle_type` tinyint(1) NOT NULL DEFAULT '0', `level` smallint(3) NOT NULL DEFAULT '1', `size` set('SMALL','MEDIUM','BIG') DEFAULT 'SMALL', `ai_flag` set('AGGR','NOMOVE','COWARD','NOATTSHINSU','NOATTCHUNJO','NOATTJINNO','ATTMOB','BERSERK','STONESKIN','GODSPEED','DEATHBLOW','REVIVE') NOT NULL DEFAULT 'NOMOVE', `setRaceFlag` set('ANIMAL','UNDEAD','DEVIL','HUMAN','ORC','MILGYO','INSECT','FIRE','ICE','DESERT') NOT NULL DEFAULT 'ANIMAL', `setImmuneFlag` set('STUN','SLOW','FALL','CURSE','POISON','TERROR','') DEFAULT NULL, `on_click` tinyint(4) NOT NULL DEFAULT '0', `empire` tinyint(4) NOT NULL DEFAULT '0', `drop_item` int(10) unsigned NOT NULL DEFAULT '0', `resurrection_vnum` int(10) unsigned NOT NULL DEFAULT '0', `folder` varchar(100) NOT NULL DEFAULT 'stray_dog', `st` smallint(5) unsigned NOT NULL DEFAULT '0', `dx` smallint(5) unsigned NOT NULL DEFAULT '0', `ht` smallint(5) unsigned NOT NULL DEFAULT '0', `iq` smallint(5) unsigned NOT NULL DEFAULT '0', `damage_min` smallint(5) unsigned NOT NULL DEFAULT '0', `damage_max` smallint(5) unsigned NOT NULL DEFAULT '0', `max_hp` int(10) unsigned NOT NULL DEFAULT '0', `regen_cycle` tinyint(3) unsigned NOT NULL DEFAULT '0', `regen_percent` tinyint(3) unsigned NOT NULL DEFAULT '0', `exp` int(10) unsigned NOT NULL DEFAULT '0', `gold_min` int(11) NOT NULL DEFAULT '0', `gold_max` int(11) NOT NULL DEFAULT '0', `def` smallint(5) unsigned NOT NULL DEFAULT '0', `attack_speed` smallint(6) unsigned NOT NULL DEFAULT '1', `move_speed` smallint(6) unsigned NOT NULL DEFAULT '1', `aggressive_hp_pct` tinyint(3) unsigned NOT NULL DEFAULT '0', `aggressive_sight` smallint(10) unsigned NOT NULL DEFAULT '0', `attack_range` smallint(5) unsigned NOT NULL DEFAULT '0', `polymorph_item` int(10) unsigned NOT NULL DEFAULT '0', `enchant_curse` tinyint(4) unsigned NOT NULL DEFAULT '0', `enchant_slow` tinyint(4) unsigned NOT NULL DEFAULT '0', `enchant_poison` tinyint(4) unsigned NOT NULL DEFAULT '0', `enchant_stun` tinyint(3) unsigned NOT NULL DEFAULT '0', `enchant_critical` tinyint(3) unsigned NOT NULL DEFAULT '0', `enchant_penetrate` tinyint(3) unsigned NOT NULL DEFAULT '0', `resist_sword` tinyint(4) NOT NULL DEFAULT '0', `resist_twohand` tinyint(4) NOT NULL DEFAULT '0', `resist_dagger` tinyint(4) NOT NULL DEFAULT '0', `resist_bell` tinyint(4) NOT NULL DEFAULT '0', `resist_fan` tinyint(4) NOT NULL DEFAULT '0', `resist_bow` tinyint(4) NOT NULL DEFAULT '0', `resist_fire` tinyint(4) NOT NULL DEFAULT '0', `resist_elect` tinyint(4) NOT NULL DEFAULT '0', `resist_magic` tinyint(4) NOT NULL DEFAULT '0', `resist_wind` tinyint(4) NOT NULL DEFAULT '0', `resist_poison` tinyint(4) NOT NULL DEFAULT '0', `resist_claw` tinyint(4) DEFAULT NULL, `dam_multiply` float DEFAULT NULL, `summon` int(11) DEFAULT NULL, `drain_sp` int(11) DEFAULT NULL, `skill_vnum0` int(10) unsigned DEFAULT NULL, `skill_level0` tinyint(3) unsigned DEFAULT NULL, `skill_vnum1` int(10) unsigned DEFAULT NULL, `skill_level1` tinyint(3) unsigned DEFAULT NULL, `skill_vnum2` int(10) unsigned DEFAULT NULL, `skill_level2` tinyint(3) unsigned DEFAULT NULL, `skill_vnum3` int(10) unsigned DEFAULT NULL, `skill_level3` tinyint(3) unsigned DEFAULT NULL, `skill_vnum4` int(10) unsigned DEFAULT NULL, `skill_level4` tinyint(3) unsigned DEFAULT NULL, `sp_berserk` tinyint(4) NOT NULL DEFAULT '0', `sp_stoneskin` tinyint(4) NOT NULL DEFAULT '0', `sp_godspeed` tinyint(4) NOT NULL DEFAULT '0', `sp_deathblow` tinyint(4) NOT NULL DEFAULT '0', `sp_revive` tinyint(4) NOT NULL DEFAULT '0', `mount_capacity` tinyint(2) NOT NULL DEFAULT '0', `mob_color` int(10) unsigned DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  18. Later edit: In FreeBSD 10 after install gcc48 must do as root: cd /usr/local/bin ln -s /usr/local/bin/gcc /usr/local/bin/gcc48 ln -s /usr/local/bin/g++ /usr/local/bin/gcc48 After that, if your source is free of errors (especialy in Makefiles) you can build your own server. Tested with novaline today on FreeBSD 10.1-RELEASE-p10 32 bit root@:/usr/src/novaline/Srcs/Server # gmake Makefile:47: warning: overriding recipe for target 'libserverkey' Makefile:13: warning: ignoring old recipe for target 'libserverkey' gmake -C libthecore/src dep gmake[1]: Entering directory '/usr/src/novaline/Srcs/Server/libthecore/src' g++ -Wall -O2 -pipe -mcpu=i686 -g -I../include -MM *.c > Depend g++: not found Makefile:33: recipe for target 'dep' failed gmake[1]: *** [dep] Error 127 gmake[1]: Leaving directory '/usr/src/novaline/Srcs/Server/libthecore/src' Makefile:41: recipe for target 'libthecore' failed gmake: *** [libthecore] Error 2 uname -a FreeBSD .localhost 10.1-RELEASE-p10 FreeBSD 10.1-RELEASE-p10 pkg info | grep gcc gcc-4.8.4_3 GNU Compiler Collection 4.8 gcc-ecj-4.5 Eclipse Java Compiler used to build GCC Java Machine is one PowerEdge with hardware (include here memory) ok. Source of mt2 is from kraizy.tgz If any other info is necesary please ask about. Any advice is welcome. Thank you in advance.
  19. First please run scandisk in windows. Next, run netstat -na | grep LISTEN and find port of programs running on FreeBSD machine. Maybe you find port 22 LISTEN for example, try ping from windows to vbox bsd and diagnose if communication is possible with this method. Next run ps -waux on your vbox console and find if your metin2 server is up and running. Because is poor detail about malfunction my answer is just a small indication about how to find where is problem.
  20. Thanks. That saved me some hours of work. With few changes specific to my server works well. Congratulations! A tiny question: How to get there TAB char not SPACE char in results writted in files between vnum and locale_name for example?
  21. Rumor: Just one question ... why not use www/apache24 port? Is simple, stable, work ok. For i386 exist small difference like "/usr/lib" not "/usr/lib32" for example. Read carefuly first post and finaly you have working FreeBSD server.
  22. In FreeBSD 10 use: pkg install lang/gcc48 or pkg install lang/gcc5 pkg_add is for older pkg sistem
  23. Maybee you espect some wow, is great tool but where is download to try this?
×
×
  • 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.