I want to install ERPNext on my Local host

Install / Update Deployment
7

Hi anil_thakur
You find and open. file : /“user using install”/frappe_password.txt
Using firefox : localhost
then.
login with
User : Administrator
Pass:" from file frappe_password.txt "
Then setup ERPNext

8

Thanks,my localhost is working now.
How to restore my cloud database backup in my localhost. ???

9

I think you need backup OS System before you delete config everything.
you should login with root user.
You can use: Backup and Restore of MySql database with phpMyAdmin
if It do not success. I think you need to use PHPmyadmin

  1. http://www.howtoforge.com/ubuntu-lamp-server-with-apache2-php5-mysql-on-14.04-lts
    when you install phpmyadmin you using password MariaDB from file /“user using install”/frappe_password.txt
    download phpmyadmin form : http://www.phpmyadmin.net/
    unzip and rename to phpmyadmin folder.
    then: copy phpmyadmin folder to /var/www/
  2. Then. You find file /etc/apache2/ports.conf
    change port : 81
    Open Terminal: Service apache2 restart
    Open Firefox: localhost:81/phpmyadmin
    login with
    user: root
    pass: MariaDB
  3. I think you need backup OS System before you delete Database, You can restore if It error.
    Delete site1.local and create site1.local and retore your cloud database backup in site1.local.
10

i have received two zip file from cloud database backup
1.20141215_47448665_files - RAR
2.20141215_47448665_database.sql - RAR
I am working Ubuntu 14.04 LTS.
Please tell me the step on Terminal command for restore databases.

11
12

@anil_thakur @JackLe
Slightly offtopic, but your described problems are the perfect reason, why I rised the following discussion: How SHOULD partners manage a cloud? :: mesosphere :: docker

pdvyas I think there is no better point about containerization and repeatable / versioned /optimized dockerfile instructions :wink:

13

I have try to restore backup on my local database using following terminal command on ubuntu 14.04
Please help me this matter

MariaDB [(none)]> show databases;
±-------------------+
| Database |
±-------------------+
| information_schema |
| 1bd3e0294d |
| mysql |
| performance_schema |
±-------------------+
4 rows in set (0.00 sec)

erpadmin@ERPNEXT:~$ cd frappe-bench
erpadmin@ERPNEXT:~/frappe-bench$ bench frappe --restore ACROS 20150212_71442855_database.sql
MySQL root password:
Traceback (most recent call last):
File “/home/erpadmin/frappe-bench/env/bin/frappe”, line 9, in
load_entry_point(‘frappe==4.11.4’, ‘console_scripts’, ‘frappe’)()
File “/home/erpadmin/frappe-bench/apps/frappe/frappe/cli.py”, line 53, in main
return run(fn, parsed_args)
File “/home/erpadmin/frappe-bench/apps/frappe/frappe/cli.py”, line 81, in run
out = globals().get(fn)(*args.get(fn), **args)
File “/home/erpadmin/frappe-bench/apps/frappe/frappe/cli.py”, line 67, in new_fn
return fn(*args, **new_kwargs)
File “/home/erpadmin/frappe-bench/apps/frappe/frappe/cli.py”, line 386, in restore
_install(db_name, source_sql=source_sql, quiet=quiet, force=force)
File “/home/erpadmin/frappe-bench/apps/frappe/frappe/cli.py”, line 317, in _install
admin_password = admin_password, verbose=verbose, force=force, site_config=site_config, reinstall=reinstall)
File “/home/erpadmin/frappe-bench/apps/frappe/frappe/installer.py”, line 31, in install_db
create_database_and_user(force, verbose)
File “/home/erpadmin/frappe-bench/apps/frappe/frappe/installer.py”, line 52, in create_database_and_user
raise Exception(“Database %s already exists” % (db_name,))
Exception: Database 1bd3e0294d already exists
erpadmin@ERPNEXT:~/frappe-bench$ bench frappe --restore 1bd3e0294d 20150212_71442855_database.sql
MySQL root password:
Traceback (most recent call last):
File “/home/erpadmin/frappe-bench/env/bin/frappe”, line 9, in
load_entry_point(‘frappe==4.11.4’, ‘console_scripts’, ‘frappe’)()
File “/home/erpadmin/frappe-bench/apps/frappe/frappe/cli.py”, line 53, in main
return run(fn, parsed_args)
File “/home/erpadmin/frappe-bench/apps/frappe/frappe/cli.py”, line 81, in run
out = globals().get(fn)(*args.get(fn), **args)
File “/home/erpadmin/frappe-bench/apps/frappe/frappe/cli.py”, line 67, in new_fn
return fn(*args, **new_kwargs)
File “/home/erpadmin/frappe-bench/apps/frappe/frappe/cli.py”, line 386, in restore
_install(db_name, source_sql=source_sql, quiet=quiet, force=force)
File “/home/erpadmin/frappe-bench/apps/frappe/frappe/cli.py”, line 317, in _install
admin_password = admin_password, verbose=verbose, force=force, site_config=site_config, reinstall=reinstall)
File “/home/erpadmin/frappe-bench/apps/frappe/frappe/installer.py”, line 31, in install_db
create_database_and_user(force, verbose)
File “/home/erpadmin/frappe-bench/apps/frappe/frappe/installer.py”, line 52, in create_database_and_user
raise Exception(“Database %s already exists” % (db_name,))
Exception: Database 1bd3e0294d already exists
erpadmin@ERPNEXT:~/frappe-bench$ ^C
erpadmin@ERPNEXT:~/frappe-bench$

14

our dbname is 1bd3e0294d

The command would be,

bench frappe --restore 1bd3e0294d 20150212_71442855_database.sql -f
15

Thanks i will use this command on ubuntu terminal.

16

Hello i am using provided commond but there is also error found please …

root@ERPNEXT:/home/erpadmin/frappe-bench# sudo bench frappe --restore 1bd3e0294d 20150212_71442855_database.sql -fMySQL root password:
Created user 1bd3e0294d
Created database 1bd3e0294d
Granted privileges to user 1bd3e0294d and database 1bd3e0294d
Starting database import…
sh: 1: cannot open 20150212_71442855_database.sql: No such file
Imported from database 20150212_71442855_database.sql
Traceback (most recent call last):
File “/home/erpadmin/frappe-bench/env/bin/frappe”, line 9, in
load_entry_point(‘frappe==4.11.4’, ‘console_scripts’, ‘frappe’)()
File “/home/erpadmin/frappe-bench/apps/frappe/frappe/cli.py”, line 53, in main
return run(fn, parsed_args)
File “/home/erpadmin/frappe-bench/apps/frappe/frappe/cli.py”, line 81, in run
out = globals().get(fn)(*args.get(fn), **args)
File “/home/erpadmin/frappe-bench/apps/frappe/frappe/cli.py”, line 67, in new_fn
return fn(*args, **new_kwargs)
File “/home/erpadmin/frappe-bench/apps/frappe/frappe/cli.py”, line 386, in restore
_install(db_name, source_sql=source_sql, quiet=quiet, force=force)
File “/home/erpadmin/frappe-bench/apps/frappe/frappe/cli.py”, line 319, in _install
install_app(“frappe”, verbose=verbose, set_as_patched=not source_sql)
File “/home/erpadmin/frappe-bench/apps/frappe/frappe/installer.py”, line 92, in install_app
frappe.clear_cache()
File “/home/erpadmin/frappe-bench/apps/frappe/frappe/init.py”, line 287, in clear_cache
frappe.sessions.clear_cache()
File “/home/erpadmin/frappe-bench/apps/frappe/frappe/sessions.py”, line 49, in clear_cache
for sess in frappe.db.sql(“”“select user, sid from tabSessions”“”, as_dict=1):
File “/home/erpadmin/frappe-bench/apps/frappe/frappe/database.py”, line 121, in sql
self._cursor.execute(query)
File “/home/erpadmin/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py”, line 205, in execute
self.errorhandler(self, exc, value)
File “/home/erpadmin/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py”, line 36, in defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.ProgrammingError: (1146, “Table ‘1bd3e0294d.tabSessions’ doesn’t exist”)
root@ERPNEXT:/home/erpadmin/frappe-bench#

17

I think backup database path is not found using following restore command.

bench frappe --restore 1bd3e0294d 20150212_71442855_database.sql -f

anybody say where is my backup file & where is our installed erpnext database location i.e. 1bd3e0294

18

I have restore the backup then…
on local host found ----------- Internal Server Error
means local host not found why its happend & how it is solved???

19

Try,

bench frappe --reinstall
ls -la /home/erpadmin/frappe-bench/1bd3e0294d 20150212_71442855_database.sql
bench frappe --restore /home/erpadmin/frappe-bench/20150212_71442855_database.sql -f

Assuming that the backup file path is /home/erpadmin/frappe-bench/20150212_71442855_database.sql

20

using bench frappe --restore /home/erpadmin/frappe-bench/20150212_71442855_database.sql -f
command following errort found & local host stack(not working)
http://localhost Error is Internal server error

[–admin_password ADMIN-PASSWD] [–root_password ROOT-PASSWD]
[–sites_path SITES_PATH] [–install_app APP-NAME]
[–add_to_installed_apps [APP-NAME [APP-NAME …]]]
[–reinstall] [–restore DB-NAME SQL-FILE]
[–with_scheduler_enabled]
[–add_system_manager EMAIL [[FIRST-NAME] [LAST-NAME] …]]
[–port PORT] [–use] [-u [REMOTE [BRANCH …]]]
[–reload_gunicorn] [–patch PATCH-MODULE] [-l] [–sync_all]
[–update_all_sites [REMOTE [BRANCH …]]]
[–reload_doc “MODULE” “DOCTYPE” “DOCNAME”] [-b] [–make_copy]
[-w] [–backup] [–move] [–dest_dir DEST-DIR] [–with_files]
[–domain [DOMAIN [DOMAIN …]]]
[–make_conf [DB-NAME [DB-PASSWORD …]]]
[–make_custom_server_script DOCTYPE] [–init_list DOCTYPE]
[–set_admin_password [ADMIN-PASSWORD [ADMIN-PASSWORD …]]]
[–request URL-ARGS] [–mysql] [–serve] [–profile] [–smtp]
[–python] [–flush_memcache] [–ipython] [–execute FUNCTION]
[–get_site_status] [–update_site_config site-CONFIG-JSON]
[–resize_images PATH] [–clear_web] [–build_website]
[–sync_statics] [–clear_cache] [–reset_perms]
[–clear_all_sessions] [–run_scheduler]
[–celery [CELERY [CELERY …]]]
[–run_scheduler_event all | daily | weekly | monthly]
[–enable_scheduler] [–disable_scheduler]
[–replace SEARCH-REGEX REPLACE-BY FILE-EXTN]
[–export_doc “DOCTYPE” “DOCNAME”]
[–export_doclist DOCTYPE NAME PATH] [–export_csv DOCTYPE PATH]
[–export_fixtures] [–import_doc PATH] [–doctor]
[–purge_all_tasks] [–dump_queue_status]
[–build_message_files]
[–get_untranslated LANG-CODE TARGET-FILE-PATH]
[–update_translations LANG-CODE UNTRANSLATED-FILE-PATH TRANSLATED-FILE-PATH]
[–run_tests] [–app APP-NAME] [-d DOCTYPE] [-m MODULE]
[–tests [TEST FUNCTION [TEST FUNCTION …]]] [–serve_test]
[–driver [DRIVER]] [-f] [–all] [–verbose] [–quiet]
[site]
frappe: error: argument --restore: expected 2 argument(s)

21

Sorry, the command is

bench frappe --restore 1bd3e0294d /home/erpadmin/frappe-bench/20150212_71442855_database.sql -f
22

i have to apply:

bench frappe --restore 1bd3e0294d /home/erpadmin/frappe-bench/20150212_71442855_database.sql -f

Again found on 127.0.0.1(localhost) : Internal server error
& ternminal status is given below:

erpadmin@ERPNEXT:~$ bench frappe --restore 1bd3e0294d /home/erpadmin/frappe-bench/20150212_71442855_database.sql -f
MySQL root password:
Created user 1bd3e0294d
Created database 1bd3e0294d
Granted privileges to user 1bd3e0294d and database 1bd3e0294d
Starting database import…
Imported from database /home/erpadmin/frappe-bench/20150212_71442855_database.sql
Traceback (most recent call last):
File “/home/erpadmin/frappe-bench/env/bin/frappe”, line 9, in
load_entry_point(‘frappe==4.12.1’, ‘console_scripts’, ‘frappe’)()
File “/home/erpadmin/frappe-bench/apps/frappe/frappe/cli.py”, line 53, in main
return run(fn, parsed_args)
File “/home/erpadmin/frappe-bench/apps/frappe/frappe/cli.py”, line 81, in run
out = globals().get(fn)(*args.get(fn), **args)
File “/home/erpadmin/frappe-bench/apps/frappe/frappe/cli.py”, line 67, in new_fn
return fn(*args, **new_kwargs)
File “/home/erpadmin/frappe-bench/apps/frappe/frappe/cli.py”, line 386, in restore
_install(db_name, source_sql=source_sql, quiet=quiet, force=force)
File “/home/erpadmin/frappe-bench/apps/frappe/frappe/cli.py”, line 319, in _install
install_app(“frappe”, verbose=verbose, set_as_patched=not source_sql)
File “/home/erpadmin/frappe-bench/apps/frappe/frappe/installer.py”, line 92, in install_app
frappe.clear_cache()
File “/home/erpadmin/frappe-bench/apps/frappe/frappe/init.py”, line 291, in clear_cache
for fn in frappe.get_hooks(“clear_cache”):
File “/home/erpadmin/frappe-bench/apps/frappe/frappe/init.py”, line 464, in get_hooks
hooks = _dict(cache().get_value(“app_hooks”, load_app_hooks))
File “/home/erpadmin/frappe-bench/apps/frappe/frappe/memc.py”, line 21, in get_value
val = builder()
File “/home/erpadmin/frappe-bench/apps/frappe/frappe/init.py”, line 441, in load_app_hooks
app_hooks = get_module(app + “.hooks”)
File “/home/erpadmin/frappe-bench/apps/frappe/frappe/init.py”, line 379, in get_module
return importlib.import_module(modulename)
File “/usr/lib/python2.7/importlib/init.py”, line 37, in import_module
import(name)
ImportError: No module named frappe_subscription.hooks
erpadmin@ERPNEXT:~$

23

The command is correct!

However the “ImportError: No module named frappe_subscription.hooks” was a bug we fixed a while back.
Do,

Run,

bench update --pull
bench frappe --restore 1bd3e0294d /home/erpadmin/frappe-bench/20150212_71442855_database.sql -f
24

Gr8 again thanks you very much. – provided command finished the all my database restoreing problem. Thanks again.

1 Like
25

hi Gurus !
I 'm doing the same , i have downloaded the virtual machine from erpnext.com/download imported in virtual box … now try to restore by .sql file taken from cloud . but getting following error …

erpnext@erpnext-vm:~/frappe-bench$ bench frappe --restore yh2hwev8eelhxa7o /home/test/database.sql -f
Traceback (most recent call last):
File “/home/erpnext/frappe-bench/env/bin/frappe”, line 5, in
from pkg_resources import load_entry_point
File “/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/pkg_resources.py”, line 2701, in
parse_requirements(requires), Environment()
File “/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/pkg_resources.py”, line 572, in resolve
raise DistributionNotFound(req)
pkg_resources.DistributionNotFound: frappe==4.0.0

Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 36
Server version: 5.5.40-MariaDB-1~wheezy-log mariadb.org binary distribution

Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

MariaDB [(none)]> show databases;
±-------------------+
| Database |
±-------------------+
| information_schema |
| erpnext |
| mysql |
| performance_schema |
±-------------------+
4 rows in set (0.02 sec)

MariaDB [(none)]>

26

pkg_resources.DistributionNotFound: frappe==4.0.0 , I think this is the major problem … please help !