Where is the config file for mariadb?

HI, Hope everyone is well.

We are trying to find and edit the mariadb config file for a virtual server to allow yetiforce. Here is what we need. Plus we are missing ioncubeloader. I’ve installed it into the server via commandline but it does not seem to pick up on php -m or php -v.

  • SQL_MODE should not contain STRICT_TRANS_TABLE and ONLY_FULL_GROUP_BY
  • ENGINE = InnoDB should be available and enabled by default (disable --skip-innodb)
  • innodb_default_row_format = 'dynamic’
  • character-set-server = utf8
  • default-character-set = utf8
  • collation-server = utf8_general_ci
  • character_set_system = utf8
  • table_open_cache = 1000
  • table_definition_cache = 1400
  • innodb_lock_wait_timeout = 600
  • wait_timeout = 600
  • interactive_timeout = 600
  • max_allowed_packet = 10M (minimum value, preferably 128M)
  • innodb_file_per_table = ON
  • innodb_stats_on_metadata = OFF
  • ft_min_word_len = 2
SYSTEM INFORMATION
OS type and version Ubuntu 22.04 with php 8.1
Virtualmin version V7.2

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.