Getting error while installing erpnext app on site

I keep getting

[Errno 61] Connection refused

while installing erpnext in the new site. Looks like database connection issue, tried login into mysql using command line, able to login. Any idea what could be the issue ?

@shreyasp please check.

@ravilakhotia

Would appreciate, if you can post full traceback, so anyone else taking a look might be able to help you in solving it.

Here it is:

afla:frappe-bench ravi$ bench --site nest7 install-app erpnext
Installing erpnext...
[Errno 61] Connection refused
[Errno 61] Connection refused
[Errno 61] Connection refused
[Errno 61] Connection refused
[Errno 61] Connection refused
[Errno 61] Connection refused
[Errno 61] Connection refused
[Errno 61] Connection refused
Unserializable object <frappe.core.doctype.user.user.User object at 0x10c28aed0> of type <class 'frappe.core.doctype.user.user.User'> 
Unserializable object <frappe.core.doctype.userrole.userrole.UserRole object at 0x10c28aa90> of type <class 'frappe.core.doctype.userrole.userrole.UserRole'>
[Errno 61] Connection refused
 Unserializable object <frappe.core.doctype.user.user.User object at 0x10c298650> of type <class 'frappe.core.doctype.user.user.User'>
 Unserializable object <frappe.core.doctype.userrole.userrole.UserRole object at 0x10c298750> of type <class 'frappe.core.doctype.userrole.userrole.UserRole'>
 [Errno 61] Connection refused
 Unserializable object <frappe.core.doctype.docperm.docperm.DocPerm object at 0x10c221490> of type <class 'frappe.core.doctype.docperm.docperm.DocPerm'>
 Updating erpnext                    : [                                        ]Unserializable object <frappe.core.doctype.docperm.docperm.DocPerm object at 0x10c298a90> of type <class 'frappe.core.doctype.docperm.docperm.DocPerm'>
 Updating erpnext                    : [                                        ]Unserializable object <frappe.core.doctype.docperm.docperm.DocPerm object at 0x10c298e10> of type <class 'frappe.core.doctype.docperm.docperm.DocPerm'> 
 Updating erpnext                    : [                                        ]Unserializable object <frappe.core.doctype.docperm.docperm.DocPerm object at 0x10c336550> of type <class 'frappe.core.doctype.docperm.docperm.DocPerm'>
 Updating erpnext                    : [                                        ]Unserializable object <frappe.core.doctype.docfield.docfield.DocField object at 0x10c343b50> of type <class 'frappe.core.doctype.docfield.docfield.DocField'>
 Updating erpnext                    : [                                        ]Unserializable object <frappe.core.doctype.user.user.User object at 0x10c343d10> of type <class 'frappe.core.doctype.user.user.User'>
 Unserializable object <frappe.core.doctype.userrole.userrole.UserRole object at 0x10c343f50> of type <class 'frappe.core.doctype.userrole.userrole.UserRole'>
 [Errno 61] Connection refused
 Unserializable object <frappe.core.doctype.docperm.docperm.DocPerm object at 0x10c336450> of type <class 'frappe.core.doctype.docperm.docperm.DocPerm'>
 Updating erpnext                    : [                                        ]Unserializable object <frappe.core.doctype.docperm.docperm.DocPerm object at 0x10c2df310> of type <class 'frappe.core.doctype.docperm.docperm.DocPerm'>
 Updating erpnext                    : [                                        ]Unserializable object <frappe.core.doctype.docfield.docfield.DocField object at 0x10c2dfa90> of type <class 'frappe.core.doctype.docfield.docfield.DocField'>
 Updating erpnext                    : [                                        ]Unserializable object <frappe.core.doctype.docperm.docperm.DocPerm object at 0x10c2df350> of type <class 'frappe.core.doctype.docperm.docperm.DocPerm'>0x10c71a650> of type <class 'frappe.core.doctype.docperm.docperm.DocPerm'>

Lots of similar logsā€¦

Updating erpnext                    : [=====================                   ]Unserializable object <frappe.core.doctype.docperm.docperm.DocPerm object at 0x10c78bbd0> of type <class 'frappe.core.doctype.docperm.docperm.DocPerm'>
Updating erpnext                    : [=====================                   ]Unserializable object <frappe.core.doctype.docfield.docfield.DocField object at 0x10c65b6d0> of type <class 'frappe.core.doctype.docfield.docfield.DocField'>
Updating erpnext                    : [=====================                   ]Unserializable object <frappe.core.doctype.docfield.docfield.DocField object at 0x10c802d90> of type <class 'frappe.core.doctype.docfield.docfield.DocField'> 
Updating erpnext                    : [=====================                   ]Unserializable object <frappe.core.doctype.docperm.docperm.DocPerm object at 0x10c802e50> of type <class 'frappe.core.doctype.docperm.docperm.DocPerm'>
Updating erpnext                    : [=====================                   ]Unserializable object <frappe.core.doctype.docperm.docperm.DocPerm object at 0x10c78b450> of type <class 'frappe.core.doctype.docperm.docperm.DocPerm'>
Updating erpnext                    : [======================                  ]Unserializable object <frappe.core.doctype.docperm.docperm.DocPerm object at 0x10c78b610> of type <class 'frappe.core.doctype.docperm.docperm.DocPerm'>
Updating erpnext                    : [======================                  ]Unserializable object <frappe.core.doctype.docfield.docfield.DocField object at 0x10c78ba10> of type <class 'frappe.core.doctype.docfield.docfield.DocField'>
Updating erpnext                    : [======================                  ]Unserializable object <frappe.core.doctype.docperm.docperm.DocPerm object at 0x10c5f1f10> of type <class 'frappe.core.doctype.docperm.docperm.DocPerm'>
Updating erpnext                    : [======================                  ]Unserializable object <frappe.core.doctype.docperm.docperm.DocPerm object at 0x10c78b650> of type <class 'frappe.core.doctype.docperm.docperm.DocPerm'>
Updating erpnext                    : [======================                  ]Unserializable object <frappe.core.doctype.docperm.docperm.DocPerm object at 0x10c802fd0> of type <class 'frappe.core.doctype.docperm.docperm.DocPerm'>
Updating erpnext                    : [======================                  ]Unserializable object <frappe.core.doctype.docfield.docfield.DocField object at 0x10c802c50> of type <class 'frappe.core.doctype.docfield.docfield.DocField'>
Updating erpnext                    : [======================                  ]Unserializable object <frappe.core.doctype.docperm.docperm.DocPerm object at 0x10c65b710> of type <class 'frappe.core.doctype.docperm.docperm.DocPerm'>
Updating erpnext                    : [=========================               ][Errno 61] Connection refused
Updating erpnext                    : [==========================              ][Errno 61] Connection refused
Updating erpnext                    : [==========================              ][Errno 61] Connection refused
Updating erpnext                    : [==========================              ][Errno 61] Connection refused
Updating erpnext                    : [==========================              ]Unserializable object <frappe.core.doctype.docperm.docperm.DocPerm object at 0x10c75da50> of type <class 'frappe.core.doctype.docperm.docperm.DocPerm'>
Updating erpnext                    : [==========================              ]Unserializable object <frappe.core.doctype.docperm.docperm.DocPerm object at 0x10c398050> of type <class 'frappe.core.doctype.docperm.docperm.DocPerm'> 
Updating erpnext                    : [==========================              ]Unserializable object <frappe.core.doctype.docperm.docperm.DocPerm object at 0x10c64a2d0> of type <class 'frappe.core.doctype.docperm.docperm.DocPerm'>
Updating erpnext                    : [==========================              ]Unserializable object <frappe.core.doctype.docfield.docfield.DocField object at 0x10c6f7a10> of type <class 'frappe.core.doctype.docfield.docfield.DocField'>
Updating erpnext                    : [==========================              ]Unserializable object <frappe.core.doctype.docperm.docperm.DocPerm object at 0x10c6f7190> of type <class 'frappe.core.doctype.docperm.docperm.DocPerm'>
Updating erpnext                    : [==========================              ]Unserializable object <frappe.core.doctype.docperm.docperm.DocPerm object at 0x10c398d50> of type <class 'frappe.core.doctype.docperm.docperm.DocPerm'>
Updating erpnext                    : [============================            ]Unserializable object <frappe.core.doctype.docfield.docfield.DocField object at 0x10c6eaed0> of type <class 'frappe.core.doctype.docfield.docfield.DocField'>
Updating erpnext                    : [=============================           ]Unserializable object <frappe.core.doctype.docperm.docperm.DocPerm object at 0x10c6c5690> of type <class 'frappe.core.doctype.docperm.docperm.DocPerm'>
Updating erpnext                    : [=============================           ]Unserializable object <frappe.core.doctype.docfield.docfield.DocField object at 0x10c6ea990> of type <class 'frappe.core.doctype.docfield.docfield.DocField'>
Updating erpnext                    : [=============================           ]Unserializable object <frappe.core.doctype.docperm.docperm.DocPerm object at 0x10c67a5d0> of type <class 'frappe.core.doctype.docperm.docperm.DocPerm'>
Updating erpnext                    : [==============================          ][Errno 61] Connection refused
Updating erpnext                    : [==============================          ][Errno 61] Connection refused
Updating erpnext                    : [==============================          ][Errno 61] Connection refused 
Updating erpnext                    : [==============================          ][Errno 61] Connection refused
Updating erpnext                    : [==============================          ][Errno 61] Connection refused
Unserializable object <frappe.core.doctype.user.user.User object at 0x10c97fa10> of type <class 'frappe.core.doctype.user.user.User'>
Unserializable object <frappe.core.doctype.userrole.userrole.UserRole object at 0x10c97fad0> of type <class 'frappe.core.doctype.userrole.userrole.UserRole'>
[Errno 61] Connection refused
[Errno 61] Connection refused
[Errno 61] Connection refused
[Errno 61] Connection refused
[Errno 61] Connection refused
[Errno 61] Connection refused
[Errno 61] Connection refused
[Errno 61] Connection refused
[Errno 61] Connection refused
[Errno 61] Connection refused
[Errno 61] Connection refused
[Errno 61] Connection refused
[Errno 61] Connection refused
[Errno 61] Connection refused
[Errno 61] Connection refused
Unserializable object <frappe.core.doctype.user.user.User object at 0x10cca2d10> of type <class 'frappe.core.doctype.user.user.User'>
Unserializable object <frappe.core.doctype.userrole.userrole.UserRole object at 0x10c9b7a10> of type <class 'frappe.core.doctype.userrole.userrole.UserRole'>
Installing fixtures...

These errors are repeating.

This is when installing on site.

afla:frappe-bench ravi$ bench --site nest install-app erpnext
Traceback (most recent call last):
 File "/usr/local/Cellar/python/2.7.12/Frameworks/Python.framework/Versions/2.7/lib/python2.7/runpy.py", line 174, in _run_module_as_main
"__main__", fname, loader, pkg_name)
 File "/usr/local/Cellar/python/2.7.12/Frameworks/Python.framework/Versions/2.7/lib/python2.7/runpy.py", line 72, in _run_code
exec code in run_globals
File "/Users/ravi/Documents/nestaway/frappe-bench/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 79, in <module>
main()
 File "/Users/ravi/Documents/nestaway/frappe-bench/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 16, in main
click.Group(commands=commands)(prog_name='bench')
 File "/Users/ravi/Documents/nestaway/frappe-bench/frappe-bench/env/lib/python2.7/site-packages/click/core.py", line 716, in __call__
return self.main(*args, **kwargs)
File "/Users/ravi/Documents/nestaway/frappe-bench/frappe-bench/env/lib/python2.7/site-packages/click/core.py", line 696, in main
rv = self.invoke(ctx)
File "/Users/ravi/Documents/nestaway/frappe-bench/frappe-bench/env/lib/python2.7/site-packages/click/core.py", line 1060, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/Users/ravi/Documents/nestaway/frappe-bench/frappe-bench/env/lib/python2.7/site-packages/click/core.py", line 1060, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/Users/ravi/Documents/nestaway/frappe-bench/frappe-bench/env/lib/python2.7/site-packages/click/core.py", line 889, in invoke
return ctx.invoke(self.callback, **ctx.params)
File "/Users/ravi/Documents/nestaway/frappe-bench/frappe-bench/env/lib/python2.7/site-packages/click/core.py", line 534, in invoke
return callback(*args, **kwargs)
File "/Users/ravi/Documents/nestaway/frappe-bench/frappe-bench/env/lib/python2.7/site-packages/click/decorators.py", line 17, in new_func
return f(get_current_context(), *args, **kwargs)
File "/Users/ravi/Documents/nestaway/frappe-bench/frappe-bench/apps/frappe/frappe/commands/__init__.py", line 24, in _func
ret = f(frappe._dict(ctx.obj), *args, **kwargs)
File "/Users/ravi/Documents/nestaway/frappe-bench/frappe-bench/apps/frappe/frappe/commands/site.py", line 152, in install_app
_install_app(app, verbose=context.verbose)
File "/Users/ravi/Documents/nestaway/frappe-bench/frappe-bench/apps/frappe/frappe/installer.py", line 99, in install_app
frappe.clear_cache()
File "/Users/ravi/Documents/nestaway/frappe-bench/frappe-bench/apps/frappe/frappe/__init__.py", line 467, in clear_cache
for fn in get_hooks("clear_cache"):
File "/Users/ravi/Documents/nestaway/frappe-bench/frappe-bench/apps/frappe/frappe/__init__.py", line 776, in get_hooks
hooks = _dict(cache().get_value("app_hooks", load_app_hooks))
 File "/Users/ravi/Documents/nestaway/frappe-bench/frappe-bench/apps/frappe/frappe/utils/redis_wrapper.py", line 68, in get_value
val = generator()
File "/Users/ravi/Documents/nestaway/frappe-bench/frappe-bench/apps/frappe/frappe/__init__.py", line 754, in load_app_hooks
for app in [app_name] if app_name else get_installed_apps(sort=True):
File "/Users/ravi/Documents/nestaway/frappe-bench/frappe-bench/apps/frappe/frappe/__init__.py", line 718, in get_installed_apps
installed = json.loads(db.get_global("installed_apps") or "[]")
File "/Users/ravi/Documents/nestaway/frappe-bench/frappe-bench/apps/frappe/frappe/database.py", line 655, in get_global
return self.get_default(key, user)
File "/Users/ravi/Documents/nestaway/frappe-bench/frappe-bench/apps/frappe/frappe/database.py", line 667, in get_default
d = self.get_defaults(key, parent)
File "/Users/ravi/Documents/nestaway/frappe-bench/frappe-bench/apps/frappe/frappe/database.py", line 673, in get_defaults
defaults = frappe.defaults.get_defaults(parent)
File "/Users/ravi/Documents/nestaway/frappe-bench/frappe-bench/apps/frappe/frappe/defaults.py", line 72, in get_defaults
globald = get_defaults_for()
File "/Users/ravi/Documents/nestaway/frappe-bench/frappe-bench/apps/frappe/frappe/defaults.py", line 180, in get_defaults_for
where parent = %s order by creation""", (parent,), as_dict=1)
File "/Users/ravi/Documents/nestaway/frappe-bench/frappe-bench/apps/frappe/frappe/database.py", line 106, in sql
self.connect()
File "/Users/ravi/Documents/nestaway/frappe-bench/frappe-bench/apps/frappe/frappe/database.py", line 52, in connect
use_unicode=True, charset='utf8')
File "/Users/ravi/Documents/nestaway/frappe-bench/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/__init__.py", line 81, in Connect
return Connection(*args, **kwargs)
File "/Users/ravi/Documents/nestaway/frappe-bench/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/connections.py", line 193, in __init__
super(Connection, self).__init__(*args, **kwargs2)


_mysql_exceptions.OperationalError: (1045, "Access denied for user '10eff6288cedaa3e'@'localhost' (using password: YES)")

Hi @shreyasp, does the logs help ?

@umair @rushabh_mehta Can you guys please take a look at this ? thanks!

hi @ravilakhotia,
which operating system to use?
you are trying to install fresh setup of erpnext & frappe?
try to reinstall site.

Thanks

installing on mac. did fresh installation of the entire setup 4-5 times. Does not work.
Frappe gets installed. my custom app gets installed. But while installing erpnext on site, I get this error. Have tried fresh install / re-install both.

The setup did work once before my mysql crashed. After that I have done complete setup few times including mysql. Does not work. Error comes only on erpnext installation in site.

hi @ravilakhotia,
please check the my.cnf file in your /etc/my.cnf.
after try to bench reinstall the error message shows the add in my.cnf.
just to add in my.cnf and check it.

Thanks

I already have the my.cnf file. Did the fresh installation of everything. not working. Same errors.

I did a installation on AWS EC2 instance using easy installation steps mentioned in the bench doc, I get the same errors. This was a different environment, Ubuntu 14.04 LTS.