Unable to create site in app

Hi Team,

Am getting error while installing app in a site attached error message for your reference.

am creating custom app, i have installed all prerequisites but am very much confused with site.config.json where in i have to enter db_name, db_password (can any one suggest which password it is asking for)

  • i had given all privilege to root user in maria db

    shambhavi@DELL1736:~/frappe-bench$ bench --site prgcnc install-app prgcncmon
    Traceback (most recent call last):
    File “/usr/local/lib/python3.7/runpy.py”, line 193, in _run_module_as_main
    main”, mod_spec)
    File “/usr/local/lib/python3.7/runpy.py”, line 85, in _run_code
    exec(code, run_globals)
    File “/home/shambhavi/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 97, in
    main()
    File “/home/shambhavi/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 18, in main
    click.Group(commands=commands)(prog_name=‘bench’)
    File “/home/shambhavi/frappe-bench/env/lib/python3.7/site-packages/click/core.py”, line 764, in call
    return self.main(*args, **kwargs)
    File “/home/shambhavi/frappe-bench/env/lib/python3.7/site-packages/click/core.py”, line 717, in main
    rv = self.invoke(ctx)
    File “/home/shambhavi/frappe-bench/env/lib/python3.7/site-packages/click/core.py”, line 1137, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
    File “/home/shambhavi/frappe-bench/env/lib/python3.7/site-packages/click/core.py”, line 1137, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
    File “/home/shambhavi/frappe-bench/env/lib/python3.7/site-packages/click/core.py”, line 956, in invoke
    return ctx.invoke(self.callback, **ctx.params)
    File “/home/shambhavi/frappe-bench/env/lib/python3.7/site-packages/click/core.py”, line 555, in invoke
    return callback(*args, **kwargs)
    File “/home/shambhavi/frappe-bench/env/lib/python3.7/site-packages/click/decorators.py”, line 17, in new_func
    return f(get_current_context(), *args, **kwargs)
    File “/home/shambhavi/frappe-bench/apps/frappe/frappe/commands/init.py”, line 25, in _func
    ret = f(frappe._dict(ctx.obj), *args, **kwargs)
    File “/home/shambhavi/frappe-bench/apps/frappe/frappe/commands/site.py”, line 173, in install_app
    _install_app(app, verbose=context.verbose)
    File “/home/shambhavi/frappe-bench/apps/frappe/frappe/installer.py”, line 50, in install_app
    frappe.clear_cache()
    File “/home/shambhavi/frappe-bench/apps/frappe/frappe/init.py”, line 564, in clear_cache
    frappe.cache_manager.clear_user_cache()
    File “/home/shambhavi/frappe-bench/apps/frappe/frappe/cache_manager.py”, line 42, in clear_user_cache
    clear_global_cache()
    File “/home/shambhavi/frappe-bench/apps/frappe/frappe/cache_manager.py”, line 48, in clear_global_cache
    clear_website_cache()
    File “/home/shambhavi/frappe-bench/apps/frappe/frappe/website/render.py”, line 301, in clear_cache
    for method in frappe.get_hooks(“website_clear_cache”):
    File “/home/shambhavi/frappe-bench/apps/frappe/frappe/init.py”, line 940, in get_hooks
    hooks = _dict(cache().get_value(“app_hooks”, load_app_hooks))
    File “/home/shambhavi/frappe-bench/apps/frappe/frappe/utils/redis_wrapper.py”, line 79, in get_value
    val = generator()
    File “/home/shambhavi/frappe-bench/apps/frappe/frappe/init.py”, line 914, in load_app_hooks
    for app in [app_name] if app_name else get_installed_apps(sort=True):
    File “/home/shambhavi/frappe-bench/apps/frappe/frappe/init.py”, line 878, in get_installed_apps
    installed = json.loads(db.get_global(“installed_apps”) or “[]”)
    File “/home/shambhavi/frappe-bench/apps/frappe/frappe/database/database.py”, line 701, in get_global
    return self.get_default(key, user)
    File “/home/shambhavi/frappe-bench/apps/frappe/frappe/database/database.py”, line 705, in get_default
    d = self.get_defaults(key, parent)
    File “/home/shambhavi/frappe-bench/apps/frappe/frappe/database/database.py”, line 723, in get_defaults
    defaults = frappe.defaults.get_defaults(parent)
    File “/home/shambhavi/frappe-bench/apps/frappe/frappe/defaults.py”, line 77, in get_defaults
    globald = get_defaults_for()
    File “/home/shambhavi/frappe-bench/apps/frappe/frappe/defaults.py”, line 204, in get_defaults_for
    where parent = %s order by creation"“”, (parent,), as_dict=1)
    File “/home/shambhavi/frappe-bench/apps/frappe/frappe/database/database.py”, line 122, in sql
    self.connect()
    File “/home/shambhavi/frappe-bench/apps/frappe/frappe/database/database.py”, line 75, in connect
    self._conn = self.get_connection()
    File “/home/shambhavi/frappe-bench/apps/frappe/frappe/database/mariadb/database.py”, line 90, in get_connection
    local_infile = frappe.conf.local_infile)
    File “/home/shambhavi/frappe-bench/env/lib/python3.7/site-packages/pymysql/init.py”, line 94, in Connect
    return Connection(*args, **kwargs)
    File “/home/shambhavi/frappe-bench/env/lib/python3.7/site-packages/pymysql/connections.py”, line 325, in init
    self.connect()
    File “/home/shambhavi/frappe-bench/env/lib/python3.7/site-packages/pymysql/connections.py”, line 599, in connect
    self._request_authentication()
    File “/home/shambhavi/frappe-bench/env/lib/python3.7/site-packages/pymysql/connections.py”, line 861, in _request_authentication
    auth_packet = self._read_packet()
    File “/home/shambhavi/frappe-bench/env/lib/python3.7/site-packages/pymysql/connections.py”, line 684, in _read_packet
    packet.check_error()
    File “/home/shambhavi/frappe-bench/env/lib/python3.7/site-packages/pymysql/protocol.py”, line 220, in check_error
    err.raise_mysql_exception(self._data)
    File “/home/shambhavi/frappe-bench/env/lib/python3.7/site-packages/pymysql/err.py”, line 109, in raise_mysql_exception
    raise errorclass(errno, errval)
    pymysql.err.OperationalError: (1045, “Access denied for user ‘pragatitest’@‘localhost’ (using password: YES)”)
    shambhavi@DELL1736:~/frappe-bench$