I’m sorry, but even with this there are some warnings and errors.
I tried with a “Minimal” installation of Ubuntu 18.04 and doing the copy paste of your commands.
During the installation of MariaDB the password is not requested, I have to supply it with mysql_secure_installation. I’m sure about password.
With non-root users, such as Bench, the “pip” commands give rights errors to the .config folders. You must use “sudo -H”
At the beginning the 10.0.1 version of pip was installed, but then with the bench command there is the message that you are using version 9.0.3
When I finally run bench new-site and the MySQL Root password request appears, several errors are listed and the process stops.
We have tried 5, FIVE, times from a clean server image and with different MariaDB root passwords and the problem can not be this one.
Frankly speaking, it is the first time that we are in two to work 4 days just to make a first installation of an application. And we have years of experience behind it.
bench@localhost:~/erpnext$ bench new-site SUBDOMAIN.DOMAIN.TLD
MySQL root password:
Traceback (most recent call last):
File "/usr/lib/python2.7/runpy.py", line 174, in _run_module_as_main
"__main__", fname, loader, pkg_name)
File "/usr/lib/python2.7/runpy.py", line 72, in _run_code
exec code in run_globals
File "/opt/bench/erpnext/apps/frappe/frappe/utils/bench_helper.py", line 97, in <module>
main()
File "/opt/bench/erpnext/apps/frappe/frappe/utils/bench_helper.py", line 18, in main
click.Group(commands=commands)(prog_name='bench')
File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/click/core.py", line 722, in __call__
return self.main(*args, **kwargs)
File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/click/core.py", line 697, in main
rv = self.invoke(ctx)
File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/click/core.py", line 1066, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/click/core.py", line 1066, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/click/core.py", line 895, in invoke
return ctx.invoke(self.callback, **ctx.params)
File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/click/core.py", line 535, in invoke
return callback(*args, **kwargs)
File "/opt/bench/erpnext/apps/frappe/frappe/commands/site.py", line 34, in new_site
verbose=verbose, install_apps=install_app, source_sql=source_sql, force=force)
File "/opt/bench/erpnext/apps/frappe/frappe/commands/site.py", line 65, in _new_site
admin_password=admin_password, verbose=verbose, source_sql=source_sql,force=force, reinstall=reinstall)
File "/opt/bench/erpnext/apps/frappe/frappe/installer.py", line 38, in install_db
create_database_and_user(force, verbose)
File "/opt/bench/erpnext/apps/frappe/frappe/installer.py", line 62, in create_database_and_user
if force or (db_name not in dbman.get_database_list()):
File "/opt/bench/erpnext/apps/frappe/frappe/model/db_schema.py", line 554, in get_database_list
return [d[0] for d in self.db.sql("SHOW DATABASES")]
File "/opt/bench/erpnext/apps/frappe/frappe/database.py", line 166, in sql
self.connect()
File "/opt/bench/erpnext/apps/frappe/frappe/database.py", line 116, in connect
charset='utf8mb4', use_unicode = True, conv = conversions, local_infile = self.local_infile)
File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/__init__.py", line 94, in Connect
return Connection(*args, **kwargs)
File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 327, in __init__
self.connect()
File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 598, in connect
self._request_authentication()
File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 852, in _request_authentication
auth_packet = self._read_packet()
File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 683, in _read_packet
packet.check_error()
File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/protocol.py", line 220, in check_error
err.raise_mysql_exception(self._data)
File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/err.py", line 109, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.InternalError: (1698, u"Access denied for user 'root'@'localhost'")