Default Ubuntu page shown

Manas_Mehta · February 24, 2024, 6:40pm

I have installed Frappe Bench and then ERP next, however when

I put the IP address, I am shown the default Ubuntu page
When I out IPaddress:8000 - Connection refused happens

Please help.

Manas_Mehta · February 24, 2024, 6:46pm

On local installation getting the MYSQL error

Traceback (most recent call last):
  File "/usr/lib/python3.8/runpy.py", line 194, in _run_module_as_main
    return _run_code(code, main_globals, None,
  File "/usr/lib/python3.8/runpy.py", line 87, in _run_code
    exec(code, run_globals)
  File "/home/frappe/frappe-bench/frappe-bench/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 110, in <module>
    main()
  File "/home/frappe/frappe-bench/frappe-bench/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 20, in main
    click.Group(commands=commands)(prog_name="bench")
  File "/home/frappe/frappe-bench/frappe-bench/frappe-bench/env/lib/python3.8/site-packages/click/core.py", line 829, in __call__
    return self.main(*args, **kwargs)
  File "/home/frappe/frappe-bench/frappe-bench/frappe-bench/env/lib/python3.8/site-packages/click/core.py", line 782, in main
    rv = self.invoke(ctx)
  File "/home/frappe/frappe-bench/frappe-bench/frappe-bench/env/lib/python3.8/site-packages/click/core.py", line 1259, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/home/frappe/frappe-bench/frappe-bench/frappe-bench/env/lib/python3.8/site-packages/click/core.py", line 1259, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/home/frappe/frappe-bench/frappe-bench/frappe-bench/env/lib/python3.8/site-packages/click/core.py", line 1066, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "/home/frappe/frappe-bench/frappe-bench/frappe-bench/env/lib/python3.8/site-packages/click/core.py", line 610, in invoke
    return callback(*args, **kwargs)
  File "/home/frappe/frappe-bench/frappe-bench/frappe-bench/apps/frappe/frappe/commands/site.py", line 74, in new_site
    _new_site(
  File "/home/frappe/frappe-bench/frappe-bench/frappe-bench/apps/frappe/frappe/installer.py", line 62, in _new_site
    install_db(
  File "/home/frappe/frappe-bench/frappe-bench/frappe-bench/apps/frappe/frappe/installer.py", line 132, in install_db
    setup_database(force, source_sql, verbose, no_mariadb_socket)
  File "/home/frappe/frappe-bench/frappe-bench/frappe-bench/apps/frappe/frappe/database/__init__.py", line 20, in setup_database
    return frappe.database.mariadb.setup_db.setup_database(
  File "/home/frappe/frappe-bench/frappe-bench/frappe-bench/apps/frappe/frappe/database/mariadb/setup_db.py", line 34, in setup_database
    if force or (db_name not in dbman.get_database_list()):
  File "/home/frappe/frappe-bench/frappe-bench/frappe-bench/apps/frappe/frappe/database/db_manager.py", line 64, in get_database_list
    return [d[0] for d in self.db.sql("SHOW DATABASES")]
  File "/home/frappe/frappe-bench/frappe-bench/frappe-bench/apps/frappe/frappe/database/database.py", line 161, in sql
    self.connect()
  File "/home/frappe/frappe-bench/frappe-bench/frappe-bench/apps/frappe/frappe/database/database.py", line 85, in connect
    self._conn = self.get_connection()
  File "/home/frappe/frappe-bench/frappe-bench/frappe-bench/apps/frappe/frappe/database/mariadb/database.py", line 76, in get_connection
    conn = pymysql.connect(
  File "/home/frappe/frappe-bench/frappe-bench/frappe-bench/env/lib/python3.8/site-packages/pymysql/connections.py", line 353, in __init__
    self.connect()
  File "/home/frappe/frappe-bench/frappe-bench/frappe-bench/env/lib/python3.8/site-packages/pymysql/connections.py", line 633, in connect
    self._request_authentication()
  File "/home/frappe/frappe-bench/frappe-bench/frappe-bench/env/lib/python3.8/site-packages/pymysql/connections.py", line 907, in _request_authentication
    auth_packet = self._read_packet()
  File "/home/frappe/frappe-bench/frappe-bench/frappe-bench/env/lib/python3.8/site-packages/pymysql/connections.py", line 725, in _read_packet
    packet.raise_for_error()
  File "/home/frappe/frappe-bench/frappe-bench/frappe-bench/env/lib/python3.8/site-packages/pymysql/protocol.py", line 221, in raise_for_error
    err.raise_mysql_exception(self._data)
  File "/home/frappe/frappe-bench/frappe-bench/frappe-bench/env/lib/python3.8/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
    raise errorclass(errno, errval)
pymysql.err.OperationalError: (1698, "Access denied for user 'root'@'localhost'")

NCP · February 26, 2024, 6:05am

Hi @Manas_Mehta,

error indicates that it is unable to connect to the database using the ‘root’ user. This could be due to incorrect credentials or privileges. Ensure that the MySQL server is running, and the root user has appropriate privileges to access the database.

The next important point is this:

For ERPNext version 14 or 15, you need Python version 3.10 or higher. Make sure to check the post for more details.

Thank You!