I want to install ERPNext on my Local host

Q.1.- I have ERPNext ENTERPRISE License & i want to put all setup of ERPnext on my local host for my user.

Q.2.- If once installed ERPNext system on my local host then whenever how can update next version of erp in local host.

@anil_thakur - there is no Enterprise “License” in ERPNext (unlike some other open source ERP)

Read this for installation help:

i have try to installing erpnext apps - but following error found on ubuntu terminal

The following packages have unmet dependencies:
mariadb-server : Depends: mariadb-server-5.5 (= 5.5.40+maria-1~trusty) but it is not going to be installed
E: Unable to correct problems, you have held broken packages.
root@anilpc:/home/anil#

You only use:
"
wget https://raw.githubusercontent.com/frappe/bench/master/install_scripts/setup_frappe.sh
sudo bash setup_frappe.sh --setup-production
"
if it dont have Error with internet you could install Erpnext.
this is my experience.

1 Like

again error with supply link. i have using ubuntu 14.04 LTS & internet is ok

Reading state information… Done
git is already the newest version.
libxrender1 is already the newest version.
libxslt1.1 is already the newest version.
fontconfig is already the newest version.
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
mariadb-server : Depends: mariadb-server-5.5 (= 5.5.40+maria-1~trusty) but it is not going to be installed
E: Unable to correct problems, you have held broken packages.
anil@anilpc:~$

yes, got the password & successfully installed. Please say me the next step
1.how to use frappe & how to restore database.

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

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

I think you need backup OS System before you delete config everything.
you should login with root user.
You can use: http://fragments.turtlemeat.com/mysql-database-backup-restore-phpmyadmin.php
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.

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.

@anil_thakur @JackLe
Slightly offtopic, but your described problems are the perfect reason, why I rised the following discussion: https://discuss.frappe.io/t/how-should-partners-manage-a-cloud-mesosphere-docker/4240

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

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$

our dbname is 1bd3e0294d

The command would be,

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

Thanks i will use this command on ubuntu terminal.

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#

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

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???

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

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)