AWS RDS (Engine Version 10.11.10) for Frappe in EKS

Hello,
I am encountering issues when I try using RDS 10.11.10. When I am trying to create a New Site, it is failing with the below error. Most of these parameters are depreciated and hence updated Added “collation_server = utf8mb4_unicode_ci”, "innodb_default_row_format = dynamic
", “character_set_server utf8mb4”, and “collation-server utf8mb4_unicode_ci” but still the below issue/error exists. I was referring to the following to update the RDS Parameter Group “https://github.com/frappe/frappe/wiki/Using-Frappe-with-Amazon-RDS-(or-any-other-DBaaS)”. Is there any updated information on setting up parameter group for RDS with version more than 10.11.10 or more?

" For key innodb_file_format. Expected value Barracuda, found value None
For key innodb_large_prefix. Expected value ON, found value None
================================================================================
**Creation of your site - mysite.staging.site.ai failed because MariaDB is not properly **
**configured. If using version 10.2.x or earlier, make sure you use the **
**the Barracuda storage engine. **
**Please verify the settings above in MariaDB’s my.cnf. Restart MariaDB. And **
then run bench new-site mysite.staging.site.ai again.
=
**Creation of your site - mysite.staging.site.ai failed because MariaDB is not properly **
**configured. If using version 10.2.x or earlier, make sure you use the **
**the Barracuda storage engine. **
**Please verify the settings above in MariaDB’s my.cnf. Restart MariaDB. And **
then run bench new-site mysite.staging.site.ai again.
=
**Creation of your site - mysite.staging.site.ai failed because MariaDB is not properly **
**configured. If using version 10.2.x or earlier, make sure you use the **
**the Barracuda storage engine. **
**Please verify the settings above in MariaDB’s my.cnf. Restart MariaDB. And **
then run bench new-site mysite.staging.site.ai again.
=
**Creation of your site - mysite.staging.site.ai failed because MariaDB is not properly **
**configured. If using version 10.2.x or earlier, make sure you use the **
**the Barracuda storage engine. **
**Please verify the settings above in MariaDB’s my.cnf. Restart MariaDB. And **
then run bench new-site mysite.staging.site.ai again.
=
**Creation of your site - mysite.staging.site.ai failed because MariaDB is not properly **
**configured. If using version 10.2.x or earlier, make sure you use the **
**the Barracuda storage engine. **
**Please verify the settings above in MariaDB’s my.cnf. Restart MariaDB. And **
then run bench new-site mysite.staging.site.ai again.
=
**Creation of your site - mysite.staging.site.ai failed because MariaDB is not properly **
**configured. If using version 10.2.x or earlier, make sure you use the **
**the Barracuda storage engine. **
**Please verify the settings above in MariaDB’s my.cnf. Restart MariaDB. And **
then run bench new-site mysite.staging.site.ai again.
=
**Creation of your site - mysite.staging.site.ai failed because MariaDB is not properly **
**configured. If using version 10.2.x or earlier, make sure you use the **
**the Barracuda storage engine. **
**Please verify the settings above in MariaDB’s my.cnf. Restart MariaDB. And **
then run bench new-site mysite.staging.site.ai again.
=
**Creation of your site - mysite.staging.site.ai failed because MariaDB is not properly **
**configured. If using version 10.2.x or earlier, make sure you use the **
**the Barracuda storage engine. **
**Please verify the settings above in MariaDB’s my.cnf. Restart MariaDB. And **
then run bench new-site mysite.staging.site.ai again.
=
**Creation of your site - mysite.staging.site.ai failed because MariaDB is not properly **
**configured. If using version 10.2.x or earlier, make sure you use the **
**the Barracuda storage engine. **
**Please verify the settings above in MariaDB’s my.cnf. Restart MariaDB. And **
then run bench new-site mysite.staging.site.ai again.
=
**Creation of your site - mysite.staging.site.ai failed because MariaDB is not properly **
**configured. If using version 10.2.x or earlier, make sure you use the **
**the Barracuda storage engine. **
**Please verify the settings above in MariaDB’s my.cnf. Restart MariaDB. And **
then run bench new-site mysite.staging.site.ai again.
=
**Creation of your site - mysite.staging.site.ai failed because MariaDB is not properly **
**configured. If using version 10.2.x or earlier, make sure you use the **
**the Barracuda storage engine. **
**Please verify the settings above in MariaDB’s my.cnf. Restart MariaDB. And **
then run bench new-site mysite.staging.site.ai again.
=
**Creation of your site - mysite.staging.site.ai failed because MariaDB is not properly **
**configured. If using version 10.2.x or earlier, make sure you use the **
**the Barracuda storage engine. **
**Please verify the settings above in MariaDB’s my.cnf. Restart MariaDB. And **
then run bench new-site mysite.staging.site.ai again.
=
**Creation of your site - mysite.staging.site.ai failed because MariaDB is not properly **
**configured. If using version 10.2.x or earlier, make sure you use the **
**the Barracuda storage engine. **
**Please verify the settings above in MariaDB’s my.cnf. Restart MariaDB. And **
then run bench new-site mysite.staging.site.ai again.
=
**Creation of your site - mysite.staging.site.ai failed because MariaDB is not properly **
**configured. If using version 10.2.x or earlier, make sure you use the **
**the Barracuda storage engine. **
**Please verify the settings above in MariaDB’s my.cnf. Restart MariaDB. And **
then run bench new-site mysite.staging.site.ai again.
=
**Creation of your site - mysite.staging.site.ai failed because MariaDB is not properly **
**configured. If using version 10.2.x or earlier, make sure you use the **
**the Barracuda storage engine. **
**Please verify the settings above in MariaDB’s my.cnf. Restart MariaDB. And **
then run bench new-site mysite.staging.site.ai again.
=
**Creation of your site - mysite.staging.site.ai failed because MariaDB is not properly **
**configured. If using version 10.2.x or earlier, make sure you use the **
**the Barracuda storage engine. **
**Please verify the settings above in MariaDB’s my.cnf. Restart MariaDB. And **
then run bench new-site mysite.staging.site.ai again.
=
**Creation of your site - mysite.staging.site.ai failed because MariaDB is not properly **
**configured. If using version 10.2.x or earlier, make sure you use the **
**the Barracuda storage engine. **
**Please verify the settings above in MariaDB’s my.cnf. Restart MariaDB. And **
then run bench new-site mysite.staging.site.ai again.
=
**Creation of your site - mysite.staging.site.ai failed because MariaDB is not properly **
**configured. If using version 10.2.x or earlier, make sure you use the **
**the Barracuda storage engine. **
**Please verify the settings above in MariaDB’s my.cnf. Restart MariaDB. And **
then run bench new-site mysite.staging.site.ai again.
=
**Creation of your site - mysite.staging.site.ai failed because MariaDB is not properly **
**configured. If using version 10.2.x or earlier, make sure you use the **
**the Barracuda storage engine. **
**Please verify the settings above in MariaDB’s my.cnf. Restart MariaDB. And **
then run bench new-site mysite.staging.site.ai again.
=
**Creation of your site - mysite.staging.site.ai failed because MariaDB is not properly **
**configured. If using version 10.2.x or earlier, make sure you use the **
**the Barracuda storage engine. **
**Please verify the settings above in MariaDB’s my.cnf. Restart MariaDB. And **
then run bench new-site mysite.staging.site.ai again.
=
**Creation of your site - mysite.staging.site.ai failed because MariaDB is not properly **
**configured. If using version 10.2.x or earlier, make sure you use the **
**the Barracuda storage engine. **
**Please verify the settings above in MariaDB’s my.cnf. Restart MariaDB. And **
then run bench new-site mysite.staging.site.ai again.
=
**Creation of your site - mysite.staging.site.ai failed because MariaDB is not properly **
**configured. If using version 10.2.x or earlier, make sure you use the **
**the Barracuda storage engine. **
**Please verify the settings above in MariaDB’s my.cnf. Restart MariaDB. And **
then run bench new-site mysite.staging.site.ai again.
=
**Creation of your site - mysite.staging.site.ai failed because MariaDB is not properly **
**configured. If using version 10.2.x or earlier, make sure you use the **
**the Barracuda storage engine. **
**Please verify the settings above in MariaDB’s my.cnf. Restart MariaDB. And **
then run bench new-site mysite.staging.site.ai again.
=
**Creation of your site - mysite.staging.site.ai failed because MariaDB is not properly **
**configured. If using version 10.2.x or earlier, make sure you use the **
**the Barracuda storage engine. **
**Please verify the settings above in MariaDB’s my.cnf. Restart MariaDB. And **
then run bench new-site mysite.staging.site.ai again.
=
**Creation of your site - mysite.staging.site.ai failed because MariaDB is not properly **
**configured. If using version 10.2.x or earlier, make sure you use the **


** File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/pymysql/cursors.py”, line 153, in execute**
** result = self._query(query)**
** File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/pymysql/cursors.py”, line 322, in _query**
** conn.query(q)**
** File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/pymysql/connections.py”, line 563, in query**
** self._affected_rows = self._read_query_result(unbuffered=unbuffered)**
** File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/pymysql/connections.py”, line 825, in _read_query_result**
** result.read()**
** File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/pymysql/connections.py”, line 1199, in read**
** first_packet = self.connection._read_packet()**
** File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/pymysql/connections.py”, line 775, in _read_packet**
** packet.raise_for_error()**
** File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/pymysql/protocol.py”, line 219, in raise_for_error**
** err.raise_mysql_exception(self._data)**
** File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/pymysql/err.py”, line 150, in raise_mysql_exception**
** raise errorclass(errno, errval)**
pymysql.err.ProgrammingError: (1146, “Table ‘_01a6c3a37c661239.tabDefaultValue’ doesn’t exist”)
Migrating mysite.staging.site.ai
Traceback (most recent call last):
** File “/usr/local/lib/python3.10/runpy.py”, line 196, in _run_module_as_main**
** return _run_code(code, main_globals, None,**
** File “/usr/local/lib/python3.10/runpy.py”, line 86, in _run_code**
** exec(code, run_globals)**
** File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 109, in **
** main()**
** File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 18, in main**
** click.Group(commands=commands)(prog_name=“bench”)**
** File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/click/core.py”, line 829, in call**
** return self.main(args, kwargs)
** File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/click/core.py”, line 782, in main
*
** rv = self.invoke(ctx)**
** File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/click/core.py”, line 1259, in invoke**
** return _process_result(sub_ctx.command.invoke(sub_ctx))**
** File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/click/core.py”, line 1259, in invoke**
** return _process_result(sub_ctx.command.invoke(sub_ctx))**
** File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/click/core.py”, line 1066, in invoke**
** return ctx.invoke(self.callback, ctx.params)
** File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/click/core.py”, line 610, in invoke**
** return callback(args, kwargs)
** File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/click/decorators.py”, line 21, in new_func
*
** return f(get_current_context(), args, kwargs)
** File “/home/frappe/frappe-bench/apps/frappe/frappe/commands/init.py”, line 29, in _func
*
** ret = f(frappe._dict(ctx.obj), args, kwargs)
** File “/home/frappe/frappe-bench/apps/frappe/frappe/commands/site.py”, line 552, in migrate
*
** SiteMigration(**
** File “/home/frappe/frappe-bench/apps/frappe/frappe/migrate.py”, line 172, in run**
** self.setUp()**
** File “/home/frappe/frappe-bench/apps/frappe/frappe/migrate.py”, line 73, in setUp**
** add_column(doctype=“DocType”, column_name=“migration_hash”, fieldtype=“Data”)**
** File “/home/frappe/frappe-bench/apps/frappe/frappe/database/schema.py”, line 363, in add_column**
** if column_name in frappe.db.get_table_columns(doctype):**
** File “/home/frappe/frappe-bench/apps/frappe/frappe/database/database.py”, line 1163, in get_table_columns**
** raise self.TableMissingError(“DocType”, doctype)**
pymysql.err.ProgrammingError: (‘DocType’, ‘DocType’)
Traceback (most recent call last):
** File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/caching.py”, line 55, in wrapper**
** return frappe.local.request_cache[func][args_key]**
KeyError: 5740354900026072187
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
** File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/caching.py”, line 55, in wrapper**
** return frappe.local.request_cache[func][args_key]**
KeyError: 3007735582391768130
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
** File “/home/frappe/frappe-bench/apps/stanch/stanch/commands.py”, line 27, in create_company_and_user**
** company_and_user_creation(json.loads(lead_details), site)**
** File “/home/frappe/frappe-bench/apps/stanch/stanch/api.py”, line 1319, in company_and_user_creation**
** f = open(frappe.get_hooks(“bench_path”)[0] + “error_log.text”, “a”)**
** File “/home/frappe/frappe-bench/apps/frappe/frappe/init.py”, line 1486, in get_hooks**
** hooks = _dict(cache().get_value(“app_hooks”, load_app_hooks))**
** File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/redis_wrapper.py”, line 81, in get_value**
** val = generator()**
** File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/caching.py”, line 57, in wrapper**
** return_val = func(args, kwargs)
** File “/home/frappe/frappe-bench/apps/frappe/frappe/init.py”, line 1447, in _load_app_hooks
*
** apps = [app_name] if app_name else get_installed_apps(sort=True)**
** File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/caching.py”, line 57, in wrapper**
** return_val = func(args, kwargs)
** File “/home/frappe/frappe-bench/apps/frappe/frappe/init.py”, line 1412, in get_installed_apps
*
** installed = json.loads(db.get_global(“installed_apps”) or “[]”)**
** File “/home/frappe/frappe-bench/apps/frappe/frappe/database/database.py”, line 960, in get_global**
** return self.get_default(key, user)**
** File “/home/frappe/frappe-bench/apps/frappe/frappe/database/database.py”, line 964, in get_default**
** d = self.get_defaults(key, parent)**
** File “/home/frappe/frappe-bench/apps/frappe/frappe/database/database.py”, line 980, in get_defaults**
** defaults = frappe.defaults.get_defaults_for(parent)**
** File “/home/frappe/frappe-bench/apps/frappe/frappe/defaults.py”, line 218, in get_defaults_for**
** frappe.qb.from
(table)**
** File “/home/frappe/frappe-bench/apps/frappe/frappe/query_builder/utils.py”, line 76, in execute_query**
** return frappe.db.sql(query, params, args, kwargs) # nosemgrep
** File “/home/frappe/frappe-bench/apps/frappe/frappe/database/database.py”, line 218, in sql
*
** self._cursor.execute(query, values)**
** File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/pymysql/cursors.py”, line 153, in execute**
** result = self._query(query)**
** File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/pymysql/cursors.py”, line 322, in _query**
** conn.query(q)**
** File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/pymysql/connections.py”, line 563, in query**
** self._affected_rows = self._read_query_result(unbuffered=unbuffered)**
** File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/pymysql/connections.py”, line 825, in _read_query_result**
** result.read()**
** File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/pymysql/connections.py”, line 1199, in read**
** first_packet = self.connection._read_packet()**
** File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/pymysql/connections.py”, line 775, in _read_packet**
** packet.raise_for_error()**
** File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/pymysql/protocol.py”, line 219, in raise_for_error**
** err.raise_mysql_exception(self._data)**
** File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/pymysql/err.py”, line 150, in raise_mysql_exception**
** raise errorclass(errno, errval)**
pymysql.err.ProgrammingError: (1146, “Table ‘_01a6c3a37c661239.tabDefaultValue’ doesn’t exist”)
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
** File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/caching.py”, line 55, in wrapper**
** return frappe.local.request_cache[func][args_key]**
KeyError: 5740354900026072187
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
** File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/caching.py”, line 55, in wrapper**
** return frappe.local.request_cache[func][args_key]**
KeyError: 3007735582391768130
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
** File “/usr/local/lib/python3.10/runpy.py”, line 196, in _run_module_as_main**
** return _run_code(code, main_globals, None,**
** File “/usr/local/lib/python3.10/runpy.py”, line 86, in _run_code**
** exec(code, run_globals)**
** File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 109, in **
** main()**
** File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 18, in main**
** click.Group(commands=commands)(prog_name=“bench”)**
** File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/click/core.py”, line 829, in call**
** return self.main(args, kwargs)
** File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/click/core.py”, line 782, in main
*
** rv = self.invoke(ctx)**
** File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/click/core.py”, line 1259, in invoke**
** return _process_result(sub_ctx.command.invoke(sub_ctx))**
** File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/click/core.py”, line 1259, in invoke**
** return _process_result(sub_ctx.command.invoke(sub_ctx))**
** File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/click/core.py”, line 1066, in invoke**
** return ctx.invoke(self.callback, ctx.params)
** File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/click/core.py”, line 610, in invoke**
** return callback(args, kwargs)
** File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/click/decorators.py”, line 21, in new_func
*
** return f(get_current_context(), args, kwargs)
** File “/home/frappe/frappe-bench/apps/frappe/frappe/commands/init.py”, line 29, in _func
*
** ret = f(frappe._dict(ctx.obj), args, kwargs)
** File “/home/frappe/frappe-bench/apps/stanch/stanch/commands.py”, line 31, in create_company_and_user
*
** f = open(frappe.get_hooks(“bench_path”)[0] + “error_log.text”, “a”)**
** File “/home/frappe/frappe-bench/apps/frappe/frappe/init.py”, line 1486, in get_hooks**
** hooks = _dict(cache().get_value(“app_hooks”, load_app_hooks))**
** File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/redis_wrapper.py”, line 81, in get_value**
** val = generator()**
** File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/caching.py”, line 57, in wrapper**
** return_val = func(args, kwargs)
** File “/home/frappe/frappe-bench/apps/frappe/frappe/init.py”, line 1447, in _load_app_hooks
*
** apps = [app_name] if app_name else get_installed_apps(sort=True)**
** File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/caching.py”, line 57, in wrapper**
** return_val = func(args, kwargs)
** File “/home/frappe/frappe-bench/apps/frappe/frappe/init.py”, line 1412, in get_installed_apps
*
** installed = json.loads(db.get_global(“installed_apps”) or “[]”)**
** File “/home/frappe/frappe-bench/apps/frappe/frappe/database/database.py”, line 960, in get_global**
** return self.get_default(key, user)**
** File “/home/frappe/frappe-bench/apps/frappe/frappe/database/database.py”, line 964, in get_default**
** d = self.get_defaults(key, parent)**
** File “/home/frappe/frappe-bench/apps/frappe/frappe/database/database.py”, line 980, in get_defaults**
** defaults = frappe.defaults.get_defaults_for(parent)**
** File “/home/frappe/frappe-bench/apps/frappe/frappe/defaults.py”, line 218, in get_defaults_for**
** frappe.qb.from
(table)**
** File “/home/frappe/frappe-bench/apps/frappe/frappe/query_builder/utils.py”, line 76, in execute_query**
** return frappe.db.sql(query, params, args, kwargs) # nosemgrep
** File “/home/frappe/frappe-bench/apps/frappe/frappe/database/database.py”, line 218, in sql
*
** self._cursor.execute(query, values)**
** File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/pymysql/cursors.py”, line 153, in execute**
** result = self._query(query)**
** File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/pymysql/cursors.py”, line 322, in _query**
** conn.query(q)**
** File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/pymysql/connections.py”, line 563, in query**
** self._affected_rows = self._read_query_result(unbuffered=unbuffered)**
** File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/pymysql/connections.py”, line 825, in _read_query_result**
** result.read()**
** File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/pymysql/connections.py”, line 1199, in read**
** first_packet = self.connection._read_packet()**
** File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/pymysql/connections.py”, line 775, in _read_packet**
** packet.raise_for_error()**
** File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/pymysql/protocol.py”, line 219, in raise_for_error**
** err.raise_mysql_exception(self._data)**
** File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/pymysql/err.py”, line 150, in raise_mysql_exception**
** raise errorclass(errno, errval)**
**pymysql.err.ProgrammingError: (1146, “Table ‘_01a6c3a37c661239.tabDefaultValue’ doesn’t exist”)**strong text"

These parameters (innodb_file_format and innodb_large_prefix) are not available in the Parameter Group Families for MariiaDB 10.11. **
The only parameters identified and modified were:
** character-set-server → changed to character_set_server=utf8mb4

** collation-server → changed to collation-server=utf8mb4_unicode_ci**

Later attempted to drop the site manually inside a Gunicorn Pod using “bench drop-site mysite.staging.site.ai --force” but, the was an error “Access denied for user ‘root’@‘192.16.10.226’ (using password: YES)”

Tried Using Admin Instead of Root: “bench drop-site mysite.staging.site.ai --db-root-username admin --force” but, Failed again with another error.
“File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/pymysql/connections.py”, line 957, in _request_authentication
auth_packet = self._read_packet()
File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/pymysql/connections.py”, line 775, in _read_packet
packet.raise_for_error()
File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/pymysql/protocol.py”, line 219, in raise_for_error
err.raise_mysql_exception(self._data)
File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/pymysql/err.py”, line 150, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1049, “Unknown database ‘admin’”)”

We are using ERPNext Version 14.* and RDS Engine version 10.11.10 and would like to understand what the parameters are that require attention. Any updated information or inputs are very much appreciated.

Also, do let us know if ERPNext Version 14.* compatible with RDS Version 10.11.10?

version-14 is using mariadb 10.3 erpnext/.github/workflows/server-tests-mariadb.yml at 19604e91c6ca7a5e7632015f0aebba00578d50fe · frappe/erpnext · GitHub in Tests.

develop branch is using mariadb 10.6 erpnext/.github/workflows/server-tests-mariadb.yml at 0d44b5d3ce9d93792879d386b4144143206a6201 · frappe/erpnext · GitHub

If you manage to move version-14 to Mariadb 10.11 do send a PR.

1 Like