It would be better if you can provide us with more details on the issue you are encountering right now.

I tried and I keep getting the same error.

I search everywhere but can’t find a way to fix it.

Any ideas?

Hello all,

collation_server = utf8mb4_unipre_ci

is not correct, change to:

collation_server = utf8mb4_unicode_ci

you see the error if you start mysql dirctly with

/usr/sbin/mysqld

2022-03-29 19:30:08 0 [Note] /usr/sbin/mysqld (mysqld 10.3.34-MariaDB-0ubuntu0.20.04.1) starting as process 21087 …
2022-03-29 19:30:08 0 [ERROR] Unknown collation: ‘utf8mb4_unipre_ci’
2022-03-29 19:30:08 0 [ERROR] Aborting

You can try adding the user for this cron job in crontab.

Site erp.alsus.in assigned port: 80
ERROR: “getpwnam(): name not found: ‘bench'”
Traceback (most recent call last):
File “/usr/local/bin/bench”, line 8, in
sys.exit(cli())
File “/usr/local/lib/python3.8/dist-packages/bench/cli.py”, line 121, in cli
raise e
File “/usr/local/lib/python3.8/dist-packages/bench/cli.py”, line 111, in cli
bench_command()
File “/usr/lib/python3/dist-packages/click/core.py”, line 764, in __call__
return self.main(*args, **kwargs)
File “/usr/lib/python3/dist-packages/click/core.py”, line 717, in main
rv = self.invoke(ctx)
File “/usr/lib/python3/dist-packages/click/core.py”, line 1137, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/usr/lib/python3/dist-packages/click/core.py”, line 1137, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/usr/lib/python3/dist-packages/click/core.py”, line 956, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/usr/lib/python3/dist-packages/click/core.py”, line 555, in invoke
return callback(*args, **kwargs)
File “/usr/local/lib/python3.8/dist-packages/bench/commands/setup.py”, line 67, in setup_production
setup_production(user=user, yes=yes)
File “/usr/local/lib/python3.8/dist-packages/bench/config/production_setup.py”, line 50, in setup_production
fix_prod_setup_perms(bench_path, frappe_user=user)
File “/usr/local/lib/python3.8/dist-packages/bench/utils/system.py”, line 184, in fix_prod_setup_perms
uid = pwd.getpwnam(frappe_user).pw_uid
KeyError: “getpwnam(): name not found: ‘bench'”
erpnext@ip-172-31-95-175:/opt/bench/erpnext$

Did you encounter issues when setting up the production? You should check /etc/nginx/conf.d/ if the configuration file “frappe-bench.conf” is present.