Jump to content

Install MariaDB instead MySQL

iltizio

By iltizio,
in Guides & HowTo

 Share

Recommended Posts

iltizio Community Regular

iltizio 212

Posted
Posted

In this topic I would like to teach you how to install MariaDB instead Oracle MySQL and why.

Why prefer MariaDB instead MySQL?

MariaDB it's a fork of MySQL and it is compatible with MySQL. Forecasts indicate that the MariaDB fork replace Oracle MySQL Server as rdbms. 

MariaDB have more features for performance and data integrity. One of this features is Aria storage engine. Aria is the upgrade of old MyISAM storage engine used on our Metin2 Private server. This old storage engine have some bugs and it isn't ACID like InnoDB. An upgrade of InnoDB is the fork XtraDB, used on MariaDB and Percona. So if you don't want/can't convert your metin2 tables from MyISAM to InnoDB or XtraDB (the best choice) you can use the similar storage engine: Aria. 

 

How to install MariaDB on FreeBSD.

Administrate MariaDB it's like MySQL. The service is mysql-server and the path of MariaDB home directory is /var/db/mysql, like classical Oracle MySQL server.

 

Remove old MySQL server installation.

If you have mysql-server installed you need to deinstall it:

  1. Make a security's backup of your mysql data directory: cd /var/db && tar -cvJf mysql.tar.xz mysql
  2. Make a real backup of your applicative db (metin2, website etc.) with dump. You can use the CLI utility mysqldump or GUI with Navicat (right click on db name->Dump SQL file->Structure and data).
  3. Stop Mysql-server with: service mysql-server stop
  4. Remove mysql directory: rm -rf /var/db/mysql
  5. Find the mysql version: mysql --version
  6. Deinstall mysql from ports: cd /usr/ports/databases/mysqlxx-server && make deinstall clean && cd /usr/ports/databases/mysqlxx-client && make deinstall clean
    Where xx is the version find on previous step.

Install MariaDB

This thread was written when the lastest version of MariaDB was 10.1

  1. update your ports tree: portsnap fetch update
  2. Install MariaDB: cd /usr/ports/databases/mariadb101-server && make install clean
  3. if not present, enable mysql service: echo "mysql_enable=YES" >> /etc/rc.conf
  4. start mysql server: service mysql-server start
  5. Import your application databases (metin2, website etc.) from dump. Do not import from datafile!

If you use navicat, remember to create a new connection for MariaDB instead MySQL

Convert MyISAM to new storage engine

For better performance and security of your data you need to convert all of your table with a new storage engine. You can choose a different storage engine for each table.

I suggest you to choose between Aria (new MyISAM) or XtraDB (new InnoDB).

Choose Aria to read fastest and low write (example item_proto, mob_proto, shop, shop_item) or FULLTEXT index feature (to search fastest on text culomn).

Choose XtraDB to critical table with hight write frequency (example player, item, account).

To convert from one storage engine to another you have two ways:

  1. Via GUI like Navicat (one table at time). Right click on the table -> Design Table->Options->Engine. Change and save.
  2. Via query: ALTER TABLE <table_name> ENGINE=<engine>;

 

This solution don't exclude the necessity of db backups. 

Please scedule frequently backup of your applicative dbs from dump. See mysqldump utility.

For much safety, do also a datafile backup of entire mysql data directory (/var/db/mysql). It's for emergency restore of all mysql if dump import don't work.

Use datafile restore only for whole mysql directory and only if there aren't another solution with dump.

  • Metin2 Dev 9
  • Good 10
  • Love 5
  • Love 17
Link to comment
Share on other sites
  • Replies 11
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

iltizio
iltizio

In this topic I would like to teach you how to install MariaDB instead Oracle MySQL and why. Why prefer MariaDB instead MySQL? MariaDB it's a fork of MySQL and it is compatible with MySQL. F

  • 2 years later...
Mind Rapist Experienced

Mind Rapist 178

Posted
Posted

Hi, I updated my Storage Engine as 'Aria' and now I'm getting this syserr:

Spoiler 

SYSERR: Jan 21 21:56:46 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 187, 959895, 269328, 5, 'GM_LOGIN', '', '192.168.0.105') errno: 1616)
SYSERR: Jan 21 21:56:46 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 187, 959895, 269328, 0, 'LOGIN', '192.168.0.105 1815403194 1 41 209344', '192.168.0.105') errno: 1616)
SYSERR: Jan 21 21:56:52 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 0, 0, 70001430, 'SET_SOCKET', '', '', 114460) errno: 1616)
SYSERR: Jan 21 21:56:52 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 0, 0, 70001435, 'SET_SOCKET', '', '', 144460) errno: 1616)
SYSERR: Jan 21 21:56:52 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 0, 0, 70001433, 'SET_SOCKET', '', '', 164460) errno: 1616)
SYSERR: Jan 21 21:56:59 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 205, 863347, 246523, 0, 'LOGIN', '192.168.0.105 1999157000 1 43 390', '192.168.0.105') errno: 1616)
SYSERR: Jan 21 21:56:59 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 0, 0, 70001777, 'SET_SOCKET', '', '', 72701) errno: 1616)
SYSERR: Jan 21 21:57:03 :: _find_npc_by_vnum: invalid argument
SYSERR: Jan 21 21:57:03 :: _find_npc_by_vnum: invalid argument
SYSERR: Jan 21 21:57:09 :: EscapeString: FATAL ERROR!! not enough buffer size (dstSize 25 srcSize 13 src: dwefgrbt)
SYSERR: Jan 21 21:57:09 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 205, 863347, 246523, 0, 'MAKE_GUILD', 'GUILD_NAME dwefgrbt MASTER DaShit', '192.168.0.105') errno: 1616)
SYSERR: Jan 21 21:57:20 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 205, 863347, 246523, 0, 'LOGOUT', '192.168.0.105 1998957000 1 43 390', '192.168.0.105') errno: 1616)
SYSERR: Jan 21 21:57:20 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 5, 0, 70001777, 'SET_SOCKET', '', '', 72701) errno: 1616)
SYSERR: Jan 21 21:57:46 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 2280, 0, 2500000296, 'SET_SOCKET', '', '', 17509) errno: 1616)
SYSERR: Jan 21 21:57:46 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 2340, 0, 2500000298, 'SET_SOCKET', '', '', 16549) errno: 1616)
SYSERR: Jan 21 21:58:05 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 211, 957002, 255445, 0, 'LOGIN', '192.168.0.105 0 1 41 0', '192.168.0.105') errno: 1616)
SYSERR: Jan 21 21:58:09 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 0, 1, 0, 70001907, 'SET_SOCKET', '', '', 11609) errno: 1616)
SYSERR: Jan 21 21:58:09 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 211, 957002, 255445, 70001907, 'SYSTEM', 'Πανοπλία του Τέλους+9', '192.168.0.105', 11609) errno: 1616)
SYSERR: Jan 21 21:58:09 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 0, 1, 0, 70001908, 'SET_SOCKET', '', '', 19) errno: 1616)
SYSERR: Jan 21 21:58:09 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 211, 957002, 255445, 70001908, 'SYSTEM', 'Σπαθί+9', '192.168.0.105', 19) errno: 1616)
SYSERR: Jan 21 21:58:09 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 0, 48, 1, 70001909, 'SET_ATTR', '', '', 13009) errno: 1616)
SYSERR: Jan 21 21:58:09 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 211, 957002, 255445, 70001909, 'SYSTEM', 'Ασπίδα Μάχης+9', '192.168.0.105', 13009) errno: 1616)
SYSERR: Jan 21 21:58:09 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 211, 957002, 255445, 70001910, 'SYSTEM', 'Ξύλινο Βραχιόλι+9', '192.168.0.105', 14009) errno: 1616)
SYSERR: Jan 21 21:58:09 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 211, 957002, 255445, 70001911, 'SYSTEM', 'Δερμάτινα Παπούτσια+9', '192.168.0.105', 15009) errno: 1616)
SYSERR: Jan 21 21:58:09 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 211, 957002, 255445, 70001912, 'SYSTEM', 'Ξύλινο Περιδέραιο+9', '192.168.0.105', 16009) errno: 1616)
SYSERR: Jan 21 21:58:09 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 211, 957002, 255445, 70001913, 'SYSTEM', 'Ξύλινα Σκουλαρίκια+9', '192.168.0.105', 17009) errno: 1616)
SYSERR: Jan 21 21:58:09 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 211, 957002, 255445, 70001914, 'SYSTEM', 'Κάπα της Γενναιότητας', '192.168.0.105', 70038) errno: 1616)
SYSERR: Jan 21 21:58:09 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 1000000, 0, 70001915, 'SET_SOCKET', '', '', 72723) errno: 1616)
SYSERR: Jan 21 21:58:09 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 211, 957002, 255445, 70001915, 'SYSTEM', 'Ελιξήριο Ήλιου (S)', '192.168.0.105', 72723) errno: 1616)
SYSERR: Jan 21 21:58:09 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 100000, 0, 70001916, 'SET_SOCKET', '', '', 72727) errno: 1616)
SYSERR: Jan 21 21:58:09 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 211, 957002, 255445, 70001916, 'SYSTEM', 'Ελιξήριο Φεγγαριού (S)', '192.168.0.105', 72727) errno: 1616)
SYSERR: Jan 21 21:58:09 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 1800, 0, 70001917, 'SET_SOCKET', '', '', 72701) errno: 1616)
SYSERR: Jan 21 21:58:09 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 211, 957002, 255445, 70001917, 'SYSTEM', 'Παπούτσια του Ανέμου', '192.168.0.105', 72701) errno: 1616)
SYSERR: Jan 21 21:58:09 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 211, 957002, 255445, 70001918, 'SYSTEM', 'Βιβλίο Αλόγου Μάχης', '192.168.0.105', 50053) errno: 1616)
SYSERR: Jan 21 21:58:09 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 211, 957002, 255445, 70001919, 'SYSTEM', 'Δαχτυλίδι Μεταφοράς', '192.168.0.105', 70007) errno: 1616)
SYSERR: Jan 21 21:58:12 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'command_log' (query: INSERT DELAYED INTO command_log (userid, server, ip, port, username, command, date ) VALUES(187, 999, '192.168.0.105', 1, 'Fliegetest', 'set Claniaris gold 2000000000', NOW())  errno: 1616)
SYSERR: Jan 21 21:58:17 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 0, 0, 70001917, 'SET_SOCKET', '', '', 72701) errno: 1616)
SYSERR: Jan 21 21:58:46 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 2220, 0, 2500000296, 'SET_SOCKET', '', '', 17509) errno: 1616)
SYSERR: Jan 21 21:58:46 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 2280, 0, 2500000298, 'SET_SOCKET', '', '', 16549) errno: 1616)
SYSERR: Jan 21 21:58:51 :: _find_npc_by_vnum: invalid argument
SYSERR: Jan 21 21:58:51 :: _find_npc_by_vnum: invalid argument
SYSERR: Jan 21 21:58:51 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 211, 959517, 268224, 0, 'RESET_POINT', '', '192.168.0.105') errno: 1616)
SYSERR: Jan 21 21:58:51 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'command_log' (query: INSERT DELAYED INTO command_log (userid, server, ip, port, username, command, date ) VALUES(187, 999, '192.168.0.105', 1, 'Fliegetest', 'a Claniaris 40', NOW())  errno: 1616)
SYSERR: Jan 21 21:58:57 :: EscapeString: FATAL ERROR!! not enough buffer size (dstSize 25 srcSize 13 src: dfgrthny)
SYSERR: Jan 21 21:58:57 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 211, 959735, 268298, 0, 'MAKE_GUILD', 'GUILD_NAME dfgrthny MASTER Claniaris', '192.168.0.105') errno: 1616)
SYSERR: Jan 21 21:59:06 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 187, 959816, 267758, 0, 'LOGOUT', '192.168.0.105 1815403194 1 41 209344', '192.168.0.105') errno: 1616)
SYSERR: Jan 21 21:59:06 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 2259, 0, 2500000298, 'SET_SOCKET', '', '', 16549) errno: 1616)
SYSERR: Jan 21 21:59:06 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 2199, 0, 2500000296, 'SET_SOCKET', '', '', 17509) errno: 1616)
SYSERR: Jan 21 21:59:17 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 1799, 0, 70001917, 'SET_SOCKET', '', '', 72701) errno: 1616)
SYSERR: Jan 21 21:59:21 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 208, 962216, 264795, 0, 'LOGIN', '192.168.0.105 1998800000 1 41 879', '192.168.0.105') errno: 1616)
SYSERR: Jan 21 21:59:21 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 0, 0, 70001219, 'SET_SOCKET', '', '', 72701) errno: 1616)
SYSERR: Jan 21 22:00:11 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 1637, 0, 70001219, 'SET_SOCKET', '', '', 72701) errno: 1616)
SYSERR: Jan 21 22:00:17 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 1798, 0, 70001917, 'SET_SOCKET', '', '', 72701) errno: 1616)
SYSERR: Jan 21 22:01:11 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 1636, 0, 70001219, 'SET_SOCKET', '', '', 72701) errno: 1616)
SYSERR: Jan 21 22:01:17 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 1797, 0, 70001917, 'SET_SOCKET', '', '', 72701) errno: 1616)
SYSERR: Jan 21 22:02:11 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 1635, 0, 70001219, 'SET_SOCKET', '', '', 72701) errno: 1616)
SYSERR: Jan 21 22:02:17 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 1796, 0, 70001917, 'SET_SOCKET', '', '', 72701) errno: 1616)
SYSERR: Jan 21 22:03:11 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 1634, 0, 70001219, 'SET_SOCKET', '', '', 72701) errno: 1616)
SYSERR: Jan 21 22:03:17 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 1795, 0, 70001917, 'SET_SOCKET', '', '', 72701) errno: 1616)
SYSERR: Jan 21 22:03:52 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 211, 961848, 267420, 0, 'LOGOUT', '192.168.0.105 1999800000 1 41 15', '192.168.0.105') errno: 1616)
SYSERR: Jan 21 22:03:52 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 24, 0, 70001917, 'SET_SOCKET', '', '', 72701) errno: 1616)
SYSERR: Jan 21 22:04:01 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 211, 961848, 267420, 0, 'LOGIN', '192.168.0.105 1999800000 1 41 25', '192.168.0.105') errno: 1616)
SYSERR: Jan 21 22:04:01 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 0, 0, 70001917, 'SET_SOCKET', '', '', 72701) errno: 1616)
SYSERR: Jan 21 22:04:05 :: _find_npc_by_vnum: invalid argument
SYSERR: Jan 21 22:04:05 :: _find_npc_by_vnum: invalid argument
SYSERR: Jan 21 22:04:11 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 1633, 0, 70001219, 'SET_SOCKET', '', '', 72701) errno: 1616)
SYSERR: Jan 21 22:04:25 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'log' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 1794, 0, 70001917, 'SET_SOCKET', '', '', 72701) errno: 1616)

 

So far, I experience enviromental update problems (the character moves to it's own window, but other people see them sitting in the spot they were before they moved). Is there something missing from the guide? I also followed this thread:

to convert my source.

XtraDB is not available in Navicat->Design table->Options->Storage Engine. Query returns Unknown storage engine 'XtraDB'.

Does someone know how to fix this?

Link to comment
Share on other sites
Mind Rapist Experienced

Mind Rapist 178

Posted
Posted
3 hours ago, iltizio said:

Mariadb from 10.2 hasn't xtradb: https://mariadb.com/kb/en/library/about-xtradb/

Use in innodb instead. 

For insert delayed error, please read this https://mariadb.com/kb/en/library/insert-delayed/

You can update your source or use myisaam for tables that use insert delayed. 

Thanks for the response, the errors are gone! I believe leaving everything at MyISAM will work for the time being.

Link to comment
Share on other sites
  • 2 years later...
  • 2 years later...
Filachilla Community Regular

Filachilla 28

Posted
Posted
1 hour ago, czeqwerty1337 said:

Hello after I installed mariadb and try to run the server, so I have errors like this everytime.. what to do? 

mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
 

Can you login in navicat? 

this

bind-address			= 127.0.0.1

to

# bind-address			= 127.0.0.1

add in [mysqld]

sql_mode = NO_ENGINE_SUBSTITUTION

for some incorrect tables

Link to comment
Share on other sites
czeqwerty1337 Apprentice

czeqwerty1337 0

Posted
Posted

Hello, now i can run the server, but still i cant login to navicat I was trying everything i dont know what to do, mysql is working, firewall is not blocking port 3306
in my.cnf i have:

 


#
# This group is read both by the client and the server
# use it for options that affect everything, see
# https://mariadb.com/kb/en/configuring-mariadb-with-option-files/#option-groups
#
[client-server]
#bind-address = 0.0.0.0
port    = 3306
#socket = /var/run/mysql/mysql.sock

#
# include *.cnf from the config directory
#
!includedir /usr/local/etc/mysql/conf.d/



And still nothing.
When I try to change bind-address to my server address so i cant even log in to my mysql:
mysql: unknown variable 'bind-address=192.168.0.115'
i was trying 0.0.0.0 too but no success.

Here is my version:
Ver 15.1 Distrib 10.5.23-MariaDB, for FreeBSD13.2 (amd64) using  EditLine wrapper
 

Link to comment
Share on other sites
 Share
Go to topic listing

Announcements



×
×
  • 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.