I manage to install ERPNext using the .ova file and VirtualBox.
As I also use Win7 with Parallels (running on my macOS Sierra), I was wondering if there is anyway to run ERPNext directly on my Mac (without needing a VM) - my Macbook gets a bit slow when I run the macOS + 2 Virtual Machines in it.
I’ve tried frappe/bench instructions on GitHub, but I’m having a hard time understanding how it works and if it would help me installing ERPNext.
Any suggestions, ideas, articles, or anything that could help?
Thanks a lot.
EDIT:
By the way, I get stuck in creating a new bench with command line (in terminal): “bench init frappe-bench && cd frappe-bench”. It gives me a syntax error…
I recently got ERPNext 9.x.x installed on my macbook pro running OSX 10.13 (High Sierra). It took me several days of eliminating/resolving a series of configuration issues including multiple python versions, multiple pip versions, outdated homebrew versions, anaconda-related conflicts, bash $PATH definitions, and mariadb/mysql database incompatibilities.
I initially has mysql running on my macbook. I uninstalled mysql and installed mariadb. That still had issues.
My old /usr/local/var/mysql/lib directory was the issue. This is the directory that holds your old mysql databases among other configuration items. As it turns out the lib directory is not affected by brew uninstall mysql or brew uninstall mariadb actions.
These issues were resolved when I moved the entire /usr/local/var/mysql/lib directory to /usr/local/var/mysql/lib.orig . Then I brew uninstall mariadb and then brew install mariadb. It created a fresh, new, clean /usr/local/var/mysql/lib directory which was compatible with ERPNext.
WARNING: The locate database (/var/db/locate.database) does not exist.
To create the database, run the following command:
sudo launchctl load -w /System/Library/LaunchDaemons/com.apple.locate.plist
Tried loading it with the command provided above and got:
/System/Library/LaunchDaemons/com.apple.locate.plist: service already loaded
Please be aware that the database can take some time to generate; once
the database has been created, this message will no longer appear.
My most recent error while trying to create a site, if anyone is familiar with it:
(the funny thing is that the site is created on Users/MyUser/MYBENCH/Sites)
Traceback (most recent call last):
File “/usr/local/Cellar/python/2.7.14/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.14/Frameworks/Python.framework/Versions/2.7/lib/python2.7/runpy.py”, line 72, in _run_code
exec code in run_globals
File “/Users/Carvalho/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 94, in
main()
File “/Users/Carvalho/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 18, in main
click.Group(commands=commands)(prog_name=‘bench’)
File “/Users/Carvalho/frappe-bench/env/lib/python2.7/site-packages/click/core.py”, line 722, in call
return self.main(*args, **kwargs)
File “/Users/Carvalho/frappe-bench/env/lib/python2.7/site-packages/click/core.py”, line 697, in main
rv = self.invoke(ctx)
File “/Users/Carvalho/frappe-bench/env/lib/python2.7/site-packages/click/core.py”, line 1066, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/Users/Carvalho/frappe-bench/env/lib/python2.7/site-packages/click/core.py”, line 1066, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/Users/Carvalho/frappe-bench/env/lib/python2.7/site-packages/click/core.py”, line 895, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/Users/Carvalho/frappe-bench/env/lib/python2.7/site-packages/click/core.py”, line 535, in invoke
return callback(*args, **kwargs)
File “/Users/Carvalho/frappe-bench/apps/frappe/frappe/commands/site.py”, line 29, in new_site
verbose=verbose, install_apps=install_app, source_sql=source_sql, force=force)
File “/Users/Carvalho/frappe-bench/apps/frappe/frappe/commands/site.py”, line 60, in _new_site
admin_password=admin_password, verbose=verbose, source_sql=source_sql,force=force, reinstall=reinstall)
File “/Users/Carvalho/frappe-bench/apps/frappe/frappe/installer.py”, line 36, in install_db
create_database_and_user(force, verbose)
File “/Users/Carvalho/frappe-bench/apps/frappe/frappe/installer.py”, line 61, in create_database_and_user
dbman.delete_user(db_name)
File “/Users/Carvalho/frappe-bench/apps/frappe/frappe/model/db_schema.py”, line 509, in delete_user
self.db.sql(“DROP USER ‘%s’@‘%s’;” % (target, host))
File “/Users/Carvalho/frappe-bench/apps/frappe/frappe/database.py”, line 163, in sql
self._cursor.execute(query)
File “/Users/Carvalho/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/cursors.py”, line 250, in execute
self.errorhandler(self, exc, value)
File “/Users/Carvalho/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/connections.py”, line 50, in defaulterrorhandler
raise errorvalue
_mysql_exceptions.ProgrammingError: (1146, “Table ‘mysql.user’ doesn’t exist”)
if you can find the mysql/lib directory and move it, the clean install of
$ brew install mariadb
will create a new mysql database which should be properly configured.
15:25 $ bench mysql
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 7419
Server version: 10.2.9-MariaDB Homebrew
Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
In my home directory:
15:32 $ cd
~
15:32 $ bench mysql
Usage: bench [OPTIONS] COMMAND [ARGS]…
Error: No such command “mysql”.
✘-2 ~
While in my frappe-bench directory
15:32 $ cd ERPNext/frappe-bench/
~/ERPNext/frappe-bench
15:32 $ bench mysql
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 7420
Server version: 10.2.9-MariaDB Homebrew
Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
MariaDB [e38492a82d3d42e0]>
EDIT:
regarding honcho:
I had too many honcho’s installed, one by pip, one by brew
Summary:
I had too many pythons installed, too many pip’s installed, too many honcho’s installed, too many databases installed, too many database bindings installed, etc
I simplified everything by uninstalling anaconda and ALL the multiple installations of python, pip, honcho, db, db-bindings, etc and then did clean installs of everything.
ERPNext installation is VERY FINICKY and VERY unforgiving.