Okay @anebi , My first installation was successful but I can’t login to ERPNext; after entering admin user and pass it showing verifying and it never ends. So, I tried again the installation, and this time changed my.cnf’s socket and pid file directory as per setting.cnf. This gives me this error message.
TASK [Install erpnext app] *********************************************************************************************************************************************
fatal: [localhost]: FAILED! => {“changed”: true, “cmd”: [“bench”, “–site”, “site1.local”, “install-app”, “erpnext”], “delta”: “0:00:01.152170”, “end”: “2018-01-12 13:35:00.898443”, “failed”: true, “rc”: 1, “start”: “2018-01-12 13:34:59.746273”, “stderr”: “Traceback (most recent call last):\n File "/usr/lib/python2.7/runpy.py", line 174, in _run_module_as_main\n "main", fname, loader, pkg_name)\n File "/usr/lib/python2.7/runpy.py", line 72, in _run_code\n exec code in run_globals\n File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 94, in \n main()\n File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 18, in main\n click.Group(commands=commands)(prog_name=‘bench’)\n File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 722, in call\n return self.main(*args, **kwargs)\n File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 697, in main\n rv = self.invoke(ctx)\n File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 1066, in invoke\n return _process_result(sub_ctx.command.invoke(sub_ctx))\n File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 1066, in invoke\n return _process_result(sub_ctx.command.invoke(sub_ctx))\n File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 895, in invoke\n return ctx.invoke(self.callback, **ctx.params)\n File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 535, in invoke\n return callback(*args, **kwargs)\n File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/decorators.py", line 17, in new_func\n return f(get_current_context(), *args, **kwargs)\n File "/home/frappe/frappe-bench/apps/frappe/frappe/commands/init.py", line 24, in _func\n ret = f(frappe._dict(ctx.obj), *args, **kwargs)\n File "/home/frappe/frappe-bench/apps/frappe/frappe/commands/site.py", line 165, in install_app\n _install_app(app, verbose=context.verbose)\n File "/home/frappe/frappe-bench/apps/frappe/frappe/installer.py", line 109, in install_app\n frappe.clear_cache()\n File "/home/frappe/frappe-bench/apps/frappe/frappe/init.py", line 516, in clear_cache\n for fn in get_hooks("clear_cache"):\n File "/home/frappe/frappe-bench/apps/frappe/frappe/init.py", line 832, in get_hooks\n hooks = _dict(cache().get_value("app_hooks", load_app_hooks))\n File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/redis_wrapper.py", line 72, in get_value\n val = generator()\n File "/home/frappe/frappe-bench/apps/frappe/frappe/init.py", line 810, in load_app_hooks\n for app in [app_name] if app_name else get_installed_apps(sort=True):\n File "/home/frappe/frappe-bench/apps/frappe/frappe/init.py", line 774, in get_installed_apps\n installed = json.loads(db.get_global("installed_apps") or "[]")\n File "/home/frappe/frappe-bench/apps/frappe/frappe/database.py", line 719, in get_global\n return self.get_default(key, user)\n File "/home/frappe/frappe-bench/apps/frappe/frappe/database.py", line 731, in get_default\n d = self.get_defaults(key, parent)\n File "/home/frappe/frappe-bench/apps/frappe/frappe/database.py", line 737, in get_defaults\n defaults = frappe.defaults.get_defaults(parent)\n File "/home/frappe/frappe-bench/apps/frappe/frappe/defaults.py", line 57, in get_defaults\n globald = get_defaults_for()\n File "/home/frappe/frappe-bench/apps/frappe/frappe/defaults.py", line 177, in get_defaults_for\n where parent = %s order by creation""", (parent,), as_dict=1)\n File "/home/frappe/frappe-bench/apps/frappe/frappe/database.py", line 166, in sql\n self._cursor.execute(query, values)\n File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/cursors.py", line 165, in execute\n result = self._query(query)\n File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/cursors.py", line 321, in _query\n conn.query(q)\n File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 860, in query\n self._affected_rows = self._read_query_result(unbuffered=unbuffered)\n File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 1061, in _read_query_result\n result.read()\n File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 1349, in read\n first_packet = self.connection._read_packet()\n File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 1018, in _read_packet\n packet.check_error()\n File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 384, in check_error\n err.raise_mysql_exception(self._data)\n File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception\n raise errorclass(errno, errval)\npymysql.err.ProgrammingError: (1146, u"Table ‘1bd3e0294da19198.tabDefaultValue’ doesn’t exist")”, “stderr_lines”: [“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 "/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 94, 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/local/lib/python2.7/site-packages/click/core.py", line 722, in call”, " return self.main(*args, **kwargs)“, " File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 697, in main”, " rv = self.invoke(ctx)“, " File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 1066, in invoke”, " return _process_result(sub_ctx.command.invoke(sub_ctx))“, " File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 1066, in invoke”, " return _process_result(sub_ctx.command.invoke(sub_ctx))“, " File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 895, in invoke”, " return ctx.invoke(self.callback, **ctx.params)“, " File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 535, in invoke”, " return callback(*args, **kwargs)“, " File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/decorators.py", line 17, in new_func”, " return f(get_current_context(), *args, **kwargs)“, " File "/home/frappe/frappe-bench/apps/frappe/frappe/commands/init.py", line 24, in _func”, " ret = f(frappe._dict(ctx.obj), *args, **kwargs)“, " File "/home/frappe/frappe-bench/apps/frappe/frappe/commands/site.py", line 165, in install_app”, " _install_app(app, verbose=context.verbose)“, " File "/home/frappe/frappe-bench/apps/frappe/frappe/installer.py", line 109, in install_app”, " frappe.clear_cache()“, " File "/home/frappe/frappe-bench/apps/frappe/frappe/init.py", line 516, in clear_cache”, " for fn in get_hooks("clear_cache"):“, " File "/home/frappe/frappe-bench/apps/frappe/frappe/init.py", line 832, 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 72, in get_value”, " val = generator()“, " File "/home/frappe/frappe-bench/apps/frappe/frappe/init.py", line 810, in load_app_hooks”, " for app in [app_name] if app_name else get_installed_apps(sort=True):“, " File "/home/frappe/frappe-bench/apps/frappe/frappe/init.py", line 774, in get_installed_apps”, " installed = json.loads(db.get_global("installed_apps") or "[]")“, " File "/home/frappe/frappe-bench/apps/frappe/frappe/database.py", line 719, in get_global”, " return self.get_default(key, user)“, " File "/home/frappe/frappe-bench/apps/frappe/frappe/database.py", line 731, in get_default”, " d = self.get_defaults(key, parent)“, " File "/home/frappe/frappe-bench/apps/frappe/frappe/database.py", line 737, in get_defaults”, " defaults = frappe.defaults.get_defaults(parent)“, " File "/home/frappe/frappe-bench/apps/frappe/frappe/defaults.py", line 57, in get_defaults”, " globald = get_defaults_for()“, " File "/home/frappe/frappe-bench/apps/frappe/frappe/defaults.py", line 177, in get_defaults_for”, " where parent = %s order by creation""", (parent,), as_dict=1)“, " File "/home/frappe/frappe-bench/apps/frappe/frappe/database.py", line 166, in sql”, " self._cursor.execute(query, values)“, " File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/cursors.py", line 165, in execute”, " result = self._query(query)“, " File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/cursors.py", line 321, in _query”, " conn.query(q)“, " File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 860, in query”, " self._affected_rows = self._read_query_result(unbuffered=unbuffered)“, " File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 1061, in _read_query_result”, " result.read()“, " File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 1349, in read”, " first_packet = self.connection._read_packet()“, " File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 1018, in _read_packet”, " packet.check_error()“, " File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 384, in check_error”, " err.raise_mysql_exception(self._data)“, " File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception”, " raise errorclass(errno, errval)", “pymysql.err.ProgrammingError: (1146, u"Table ‘1bd3e0294da19198.tabDefaultValue’ doesn’t exist")”], “stdout”: “”, “stdout_lines”: []}
to retry, use: --limit @/tmp/.bench/playbooks/production/install.retry
PLAY RECAP *************************************************************************************************************************************************************
localhost : ok=64 changed=9 unreachable=0 failed=1