Re-installing erpnext since my earlier local system installation crashed because I installed “frappe_io app” in ver 4 but getting database privilege issue.
nescode@nccorplap001:~$ wget https://raw.githubusercontent.com/frappe/bench/master/install_scripts/setup_frappe.sh
--2014-12-13 19:58:20-- https://raw.githubusercontent.com/frappe/bench/master/install_scripts/setup_frappe.sh
Resolving raw.githubusercontent.com (raw.githubusercontent.com)... 103.245.222.133
Connecting to raw.githubusercontent.com (raw.githubusercontent.com)|103.245.222.133|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 11777 (12K) [text/plain]
Saving to: ‘setup_frappe.sh’
100%[===============================================================================================>] 11,777 --.-K/s in 0.005s
2014-12-13 19:58:21 (2.05 MB/s) - ‘setup_frappe.sh’ saved [11777/11777]
nescode@nccorplap001:~$ sudo bash setup_frappe.sh
[sudo] password for nescode:
Installing for Ubuntu utopic amd64
In case you encounter an error, you can post on https://discuss.frappe.io
Installing packages for Ubuntu. This might take time...
Installing wkhtmltopdf
Cannot install wkhtmltodpdf. Skipping...
Adding frappe user
Installing frappe-bench
Setting up first site
Traceback (most recent call last):
File "/home/nescode/frappe-bench/env/bin/frappe", line 9, in <module>
load_entry_point('frappe==4.7.1', 'console_scripts', 'frappe')()
File "/home/nescode/frappe-bench/apps/frappe/frappe/cli.py", line 53, in main
return run(fn, parsed_args)
File "/home/nescode/frappe-bench/apps/frappe/frappe/cli.py", line 81, in run
out = globals().get(fn)(*args.get(fn), **args)
File "/home/nescode/frappe-bench/apps/frappe/frappe/cli.py", line 67, in new_fn
return fn(*args, **new_kwargs)
File "/home/nescode/frappe-bench/apps/frappe/frappe/cli.py", line 328, in install
_install(db_name, root_login, root_password, source_sql, admin_password, force, site_config, reinstall, quiet, install_apps)
File "/home/nescode/frappe-bench/apps/frappe/frappe/cli.py", line 309, in _install
admin_password = admin_password, verbose=verbose, force=force, site_config=site_config, reinstall=reinstall)
File "/home/nescode/frappe-bench/apps/frappe/frappe/installer.py", line 31, in install_db
create_database_and_user(force, verbose)
File "/home/nescode/frappe-bench/apps/frappe/frappe/installer.py", line 48, in create_database_and_user
if force or (db_name not in dbman.get_database_list()):
File "/home/nescode/frappe-bench/apps/frappe/frappe/model/db_schema.py", line 359, in get_database_list
return [d[0] for d in self.db.sql("SHOW DATABASES")]
File "/home/nescode/frappe-bench/apps/frappe/frappe/database.py", line 79, in sql
self.connect()
File "/home/nescode/frappe-bench/apps/frappe/frappe/database.py", line 49, in connect
use_unicode=True, charset='utf8')
File "/home/nescode/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/__init__.py", line 81, in Connect
return Connection(*args, **kwargs)
File "/home/nescode/frappe-bench/env/local/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 'root'@'localhost' (using password: YES)")
Error: None
Traceback (most recent call last):
File "/usr/local/bin/bench", line 9, in <module>
load_entry_point('bench==0.1', 'console_scripts', 'bench')()
File "/home/nescode/bench-repo/bench/cli.py", line 38, in cli
return bench()
File "/usr/local/lib/python2.7/dist-packages/click/core.py", line 610, in __call__
return self.main(*args, **kwargs)
File "/usr/local/lib/python2.7/dist-packages/click/core.py", line 590, in main
rv = self.invoke(ctx)
File "/usr/local/lib/python2.7/dist-packages/click/core.py", line 936, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/usr/local/lib/python2.7/dist-packages/click/core.py", line 782, in invoke
return ctx.invoke(self.callback, **ctx.params)
File "/usr/local/lib/python2.7/dist-packages/click/core.py", line 416, in invoke
return callback(*args, **kwargs)
File "/home/nescode/bench-repo/bench/cli.py", line 129, in new_site
_new_site(site, mariadb_root_password=mariadb_root_password, admin_password=admin_password)
File "/home/nescode/bench-repo/bench/utils.py", line 86, in new_site
), cwd=os.path.join(bench, 'sites'))
File "/home/nescode/bench-repo/bench/utils.py", line 61, in exec_cmd
subprocess.check_call(cmd, cwd=cwd, shell=True)
File "/usr/lib/python2.7/subprocess.py", line 540, in check_call
raise CalledProcessError(retcode, cmd)
subprocess.CalledProcessError: Command '/home/nescode/frappe-bench/env/bin/frappe --install site1.local site1.local --root_password 7YHaN4UXuBpbQqyE --admin_password oOYzSevxjpacEKlp' returned non-zero exit status 1
nescode@nccorplap001:~$ cd frappe-bench
nescode@nccorplap001:~/frappe-bench$ bench start
20:06:03 web.1 | started with pid 5674
20:06:03 worker.1 | started with pid 5676
20:06:03 workerbeat.1 | started with pid 5677
20:06:03 web.1 | * Running on http://0.0.0.0:8000/
20:06:03 web.1 | * Restarting with reloader
20:06:03 workerbeat.1 | [2014-12-13 20:06:03,711: INFO/MainProcess] beat: Starting...
20:06:04 worker.1 | [2014-12-13 20:06:04,741: WARNING/MainProcess] celery@nccorplap001 ready.
20:06:10 web.1 | 127.0.0.1 - - [13/Dec/2014 20:06:10] "GET / HTTP/1.1" 404 -
20:06:11 web.1 | 127.0.0.1 - - [13/Dec/2014 20:06:11] "GET /favicon.ico HTTP/1.1" 404 -
20:06:13 web.1 | 127.0.0.1 - - [13/Dec/2014 20:06:13] "GET / HTTP/1.1" 404 -
20:06:14 web.1 | 127.0.0.1 - - [13/Dec/2014 20:06:14] "GET / HTTP/1.1" 404 -
20:11:04 workerbeat.1 | [2014-12-13 20:11:04,110: INFO/MainProcess] Scheduler: Sending due task scheduler (frappe.tasks.enqueue_scheduler_events)
20:11:04 worker.1 | [2014-12-13 20:11:04,227: ERROR/MainProcess] Task frappe.tasks.enqueue_events_for_site[7596f314-ca38-415f-a879-0c71507b9e05] raised unexpected: OperationalError(1045, "Access denied for user 'site1.local'@'localhost' (using password: YES)")
20:11:04 worker.1 | Traceback (most recent call last):
20:11:04 worker.1 | File "/home/nescode/frappe-bench/env/local/lib/python2.7/site-packages/celery/app/trace.py", line 240, in trace_task
20:11:04 worker.1 | R = retval = fun(*args, **kwargs)
20:11:04 worker.1 | File "/home/nescode/frappe-bench/env/local/lib/python2.7/site-packages/celery/app/trace.py", line 438, in __protected_call__
20:11:04 worker.1 | return self.run(*args, **kwargs)
20:11:04 worker.1 | File "/home/nescode/frappe-bench/apps/frappe/frappe/tasks.py", line 108, in enqueue_events_for_site
20:11:04 worker.1 | enqueue_events(site)
20:11:04 worker.1 | File "/home/nescode/frappe-bench/apps/frappe/frappe/utils/scheduler.py", line 21, in enqueue_events
20:11:04 worker.1 | if is_scheduler_disabled():
20:11:04 worker.1 | File "/home/nescode/frappe-bench/apps/frappe/frappe/utils/scheduler.py", line 105, in is_scheduler_disabled
20:11:04 worker.1 | return not frappe.utils.cint(frappe.db.get_default("enable_scheduler"))
20:11:04 worker.1 | File "/home/nescode/frappe-bench/apps/frappe/frappe/database.py", line 459, in get_default
20:11:04 worker.1 | d = frappe.defaults.get_defaults(parent).get(key)
20:11:04 worker.1 | File "/home/nescode/frappe-bench/apps/frappe/frappe/defaults.py", line 52, in get_defaults
20:11:04 worker.1 | userd = get_defaults_for(user)
20:11:04 worker.1 | File "/home/nescode/frappe-bench/apps/frappe/frappe/defaults.py", line 143, in get_defaults_for
20:11:04 worker.1 | where parent = %s order by creation""", (parent,), as_dict=1)
20:11:04 worker.1 | File "/home/nescode/frappe-bench/apps/frappe/frappe/database.py", line 79, in sql
20:11:04 worker.1 | self.connect()
20:11:04 worker.1 | File "/home/nescode/frappe-bench/apps/frappe/frappe/database.py", line 49, in connect
20:11:04 worker.1 | use_unicode=True, charset='utf8')
20:11:04 worker.1 | File "/home/nescode/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/__init__.py", line 81, in Connect
20:11:04 worker.1 | return Connection(*args, **kwargs)
20:11:04 worker.1 | File "/home/nescode/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 193, in __init__
20:11:04 worker.1 | super(Connection, self).__init__(*args, **kwargs2)
20:11:04 worker.1 | OperationalError: (1045, "Access denied for user 'site1.local'@'localhost' (using password: YES)")
20:16:04 workerbeat.1 | [2014-12-13 20:16:04,224: INFO/MainProcess] Scheduler: Sending due task scheduler (frappe.tasks.enqueue_scheduler_events)
20:16:04 worker.1 | [2014-12-13 20:16:04,349: ERROR/MainProcess] Task frappe.tasks.enqueue_events_for_site[e74d5bbf-4e2f-4db7-a300-4b791611f843] raised unexpected: OperationalError(1045, "Access denied for user 'site1.local'@'localhost' (using password: YES)")
20:16:04 worker.1 | Traceback (most recent call last):
20:16:04 worker.1 | File "/home/nescode/frappe-bench/env/local/lib/python2.7/site-packages/celery/app/trace.py", line 240, in trace_task
20:16:04 worker.1 | R = retval = fun(*args, **kwargs)
20:16:04 worker.1 | File "/home/nescode/frappe-bench/env/local/lib/python2.7/site-packages/celery/app/trace.py", line 438, in __protected_call__
20:16:04 worker.1 | return self.run(*args, **kwargs)
20:16:04 worker.1 | File "/home/nescode/frappe-bench/apps/frappe/frappe/tasks.py", line 108, in enqueue_events_for_site
20:16:04 worker.1 | enqueue_events(site)
20:16:04 worker.1 | File "/home/nescode/frappe-bench/apps/frappe/frappe/utils/scheduler.py", line 21, in enqueue_events
20:16:04 worker.1 | if is_scheduler_disabled():
20:16:04 worker.1 | File "/home/nescode/frappe-bench/apps/frappe/frappe/utils/scheduler.py", line 105, in is_scheduler_disabled
20:16:04 worker.1 | return not frappe.utils.cint(frappe.db.get_default("enable_scheduler"))
20:16:04 worker.1 | File "/home/nescode/frappe-bench/apps/frappe/frappe/database.py", line 459, in get_default
20:16:04 worker.1 | d = frappe.defaults.get_defaults(parent).get(key)
20:16:04 worker.1 | File "/home/nescode/frappe-bench/apps/frappe/frappe/defaults.py", line 52, in get_defaults
20:16:04 worker.1 | userd = get_defaults_for(user)
20:16:04 worker.1 | File "/home/nescode/frappe-bench/apps/frappe/frappe/defaults.py", line 143, in get_defaults_for
20:16:04 worker.1 | where parent = %s order by creation""", (parent,), as_dict=1)
20:16:04 worker.1 | File "/home/nescode/frappe-bench/apps/frappe/frappe/database.py", line 79, in sql
20:16:04 worker.1 | self.connect()
20:16:04 worker.1 | File "/home/nescode/frappe-bench/apps/frappe/frappe/database.py", line 49, in connect
20:16:04 worker.1 | use_unicode=True, charset='utf8')
20:16:04 worker.1 | File "/home/nescode/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/__init__.py", line 81, in Connect
20:16:04 worker.1 | return Connection(*args, **kwargs)
20:16:04 worker.1 | File "/home/nescode/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 193, in __init__
20:16:04 worker.1 | super(Connection, self).__init__(*args, **kwargs2)
20:16:04 worker.1 | OperationalError: (1045, "Access denied for user 'site1.local'@'localhost' (using password: YES)")
Sunil