Can't install ERPNext on Ubuntu 16.04 LTS (neither manually nor with easy install)

Install / Update
1

Hello, ERPNext World! :slight_smile:

I’m trying to install ERPNext for the first time, and I’ve run into problems. I’m using a Ubuntu 16.04 LTS virtual machine, with Python 2.7.12.

I first tried a manual setup. Bench was installed fine, but bench init frappe-bench failed.

("bench init frappe-bench" error)

[…]
installing frappe
INFO:bench.app:installing frappe
Command “python setup.py egg_info” failed with error code 1 in /tmp/pip-build-1rHjoD/mysql-python/
Traceback (most recent call last):
File “/usr/local/bin/bench”, line 9, in
load_entry_point(‘bench’, ‘console_scripts’, ‘bench’)()
[…]
File “/home/ric/frappe/bench-repo/bench/app.py”, line 103, in install_app
find_links=find_links))
File “/home/ric/frappe/bench-repo/bench/utils.py”, line 127, in exec_cmd
raise CommandFailedError(cmd)
bench.utils.CommandFailedError: frappe-bench/env/bin/pip install -q -e frappe-bench/apps/frappe

Then I tried the easy install. After a sudo python install.py --develop, the Ansible playbook develop/install.yml failed.

("sudo python install.py --develop" errors)

TASK [apt-get install] *********************************************************
failed: [localhost] (item=[u’mariadb-server’, u’mariadb-client’, u’mariadb-common’, u’libmariadbclient-dev’]) => {“cache_update_time”: 1486668416, “cache_updated”: true, “failed”: true, “item”: [“mariadb-server”, “mariadb-client”, “mariadb-common”, “libmariadbclient-dev”], “msg”: “‘/usr/bin/apt-get -y -o "Dpkg::Options::=–force-confdef" -o "Dpkg::Options::=–force-confold" install ‘mariadb-server’ ‘mariadb-client’ ‘mariadb-common’ ‘libmariadbclient-dev’’ failed: No apport report written because the error message indicates its a followup error from a previous failure.\nE: Sub-process /usr/bin/dpkg returned an error code (1)\n”, “stderr”: “No apport report written because the error message indicates its a followup error from a previous failure.\nE: Sub-process /usr/bin/dpkg returned an error code (1)\n”, “stdout”: “Reading package lists…\nBuilding dependency tree…\nReading state information…\nThe following package was automatically installed and is no longer required:\n libevent-core-2.0-5\nUse ‘sudo apt autoremove’ to remove it.\nThe following additional packages will be installed:\n libmariadbclient18 libmysqlclient18 mariadb-client-10.1\n mariadb-client-core-10.1 mariadb-server-10.1 mariadb-server-core-10.1\nSuggested packages:\n libterm-readkey-perl mailx mariadb-test tinyca\nThe following NEW packages will be installed:\n libmariadbclient-dev libmariadbclient18 libmysqlclient18 mariadb-client\n mariadb-client-10.1 mariadb-client-core-10.1 mariadb-common mariadb-server\n mariadb-server-10.1 mariadb-server-core-10.1\n0 upgraded, 10 newly installed, 0 to remove and 0 not upgraded.\nNeed to get 14.7 MB of archives.\nAfter this operation, 152 MB of additional disk space will be used.\nGet:1 ://nyc2.mirrors.digitalocean.com/mariadb/repo/10.1/ubuntu xenial/main amd64 mariadb-common all 10.1.21+maria-1~xenial [3196 B]\nGet:2 ://nyc2.mirrors.digitalocean.com/mariadb/repo/10.1/ubuntu xenial/main amd64 libmysqlclient18 amd64 10.1.21+maria-1~xenial [2894 B]\nGet:3 ://nyc2.mirrors.digitalocean.com/mariadb/repo/10.1/ubuntu xenial/main amd64 libmariadbclient18 amd64 10.1.21+maria-1~xenial [586 kB]\nGet:4 ://nyc2.mirrors.digitalocean.com/mariadb/repo/10.1/ubuntu xenial/main amd64 mariadb-client-core-10.1 amd64 10.1.21+maria-1~xenial [688 kB]\nGet:5 ://nyc2.mirrors.digitalocean.com/mariadb/repo/10.1/ubuntu xenial/main amd64 mariadb-client-10.1 amd64 10.1.21+maria-1~xenial [1109 kB]\nGet:6 ://nyc2.mirrors.digitalocean.com/mariadb/repo/10.1/ubuntu xenial/main amd64 mariadb-server-core-10.1 amd64 10.1.21+maria-1~xenial [4410 kB]\nGet:7 ://nyc2.mirrors.digitalocean.com/mariadb/repo/10.1/ubuntu xenial/main amd64 mariadb-server-10.1 amd64 10.1.21+maria-1~xenial [6470 kB]\nGet:8 ://nyc2.mirrors.digitalocean.com/mariadb/repo/10.1/ubuntu xenial/main amd64 libmariadbclient-dev amd64 10.1.21+maria-1~xenial [1460 kB]\nGet:9 ://nyc2.mirrors.digitalocean.com/mariadb/repo/10.1/ubuntu xenial/main amd64 mariadb-client all 10.1.21+maria-1~xenial [2802 B]\nGet:10 ://nyc2.mirrors.digitalocean.com/mariadb/repo/10.1/ubuntu xenial/main amd64 mariadb-server all 10.1.21+maria-1~xenial [2930 B]\nPreconfiguring packages …\nFetched 14.7 MB in 9s (1600 kB/s)\nSelecting previously unselected package mariadb-common.\r\n(Reading database … \r(Reading database … 5%\r(Reading database … 10%\r(Reading database … 15%\r(Reading database … 20%\r(Reading database … 25%\r(Reading database … 30%\r(Reading database … 35%\r(Reading database … 40%\r(Reading database … 45%\r(Reading database … 50%\r(Reading database … 55%\r(Reading database … 60%\r(Reading database … 65%\r(Reading database … 70%\r(Reading database … 75%\r(Reading database … 80%\r(Reading database … 85%\r(Reading database … 90%\r(Reading database … 95%\r(Reading database … 100%\r(Reading database … 235391 files and directories currently installed.)\r\nPreparing to unpack …/mariadb-common_10.1.21+maria-1~xenial_all.deb …\r\nUnpacking mariadb-common (10.1.21+maria-1~xenial) …\r\nSelecting previously unselected package libmysqlclient18.\r\nPreparing to unpack …/libmysqlclient18_10.1.21+maria-1~xenial_amd64.deb …\r\nUnpacking libmysqlclient18 (10.1.21+maria-1~xenial) …\r\nSelecting previously unselected package libmariadbclient18.\r\nPreparing to unpack …/libmariadbclient18_10.1.21+maria-1~xenial_amd64.deb …\r\nUnpacking libmariadbclient18 (10.1.21+maria-1~xenial) …\r\nSelecting previously unselected package mariadb-client-core-10.1.\r\nPreparing to unpack …/mariadb-client-core-10.1_10.1.21+maria-1~xenial_amd64.deb …\r\nUnpacking mariadb-client-core-10.1 (10.1.21+maria-1~xenial) …\r\nSelecting previously unselected package mariadb-client-10.1.\r\nPreparing to unpack …/mariadb-client-10.1_10.1.21+maria-1~xenial_amd64.deb …\r\nUnpacking mariadb-client-10.1 (10.1.21+maria-1~xenial) …\r\nSelecting previously unselected package mariadb-server-core-10.1.\r\nPreparing to unpack …/mariadb-server-core-10.1_10.1.21+maria-1~xenial_amd64.deb …\r\nUnpacking mariadb-server-core-10.1 (10.1.21+maria-1~xenial) …\r\nProcessing triggers for libc-bin (2.23-0ubuntu5) …\r\nProcessing triggers for man-db (2.7.5-1) …\r\nSetting up mariadb-common (10.1.21+maria-1~xenial) …\r\nSelecting previously unselected package mariadb-server-10.1.\r\n(Reading database … \r(Reading database … 5%\r(Reading database … 10%\r(Reading database … 15%\r(Reading database … 20%\r(Reading database … 25%\r(Reading database … 30%\r(Reading database … 35%\r(Reading database … 40%\r(Reading database … 45%\r(Reading database … 50%\r(Reading database … 55%\r(Reading database … 60%\r(Reading database … 65%\r(Reading database … 70%\r(Reading database … 75%\r(Reading database … 80%\r(Reading database … 85%\r(Reading database … 90%\r(Reading database … 95%\r(Reading database … 100%\r(Reading database … 235535 files and directories currently installed.)\r\nPreparing to unpack …/mariadb-server-10.1_10.1.21+maria-1~xenial_amd64.deb …\r\nUnpacking mariadb-server-10.1 (10.1.21+maria-1~xenial) …\r\nSelecting previously unselected package libmariadbclient-dev.\r\nPreparing to unpack …/libmariadbclient-dev_10.1.21+maria-1~xenial_amd64.deb …\r\nUnpacking libmariadbclient-dev (10.1.21+maria-1~xenial) …\r\nSelecting previously unselected package mariadb-client.\r\nPreparing to unpack …/mariadb-client_10.1.21+maria-1~xenial_all.deb …\r\nUnpacking mariadb-client (10.1.21+maria-1~xenial) …\r\nSelecting previously unselected package mariadb-server.\r\nPreparing to unpack …/mariadb-server_10.1.21+maria-1~xenial_all.deb …\r\nUnpacking mariadb-server (10.1.21+maria-1~xenial) …\r\nProcessing triggers for man-db (2.7.5-1) …\r\nProcessing triggers for systemd (229-4ubuntu16) …\r\nProcessing triggers for ureadahead (0.100.0-19) …\r\nSetting up libmysqlclient18 (10.1.21+maria-1~xenial) …\r\nSetting up libmariadbclient18 (10.1.21+maria-1~xenial) …\r\nSetting up mariadb-client-core-10.1 (10.1.21+maria-1~xenial) …\r\nSetting up mariadb-client-10.1 (10.1.21+maria-1~xenial) …\r\nSetting up mariadb-server-core-10.1 (10.1.21+maria-1~xenial) …\r\nSetting up mariadb-server-10.1 (10.1.21+maria-1~xenial) …\r\nJob for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.\r\ninvoke-rc.d: initscript mysql, action "start" failed.\r\ndpkg: error processing package mariadb-server-10.1 (–configure):\r\n subprocess installed post-installation script returned error exit status 1\r\nSetting up libmariadbclient-dev (10.1.21+maria-1~xenial) …\r\nSetting up mariadb-client (10.1.21+maria-1~xenial) …\r\ndpkg: dependency problems prevent configuration of mariadb-server:\r\n mariadb-server depends on mariadb-server-10.1 (= 10.1.21+maria-1~xenial); however:\r\n Package mariadb-server-10.1 is not configured yet.\r\n\r\ndpkg: error processing package mariadb-server (–configure):\r\n dependency problems - leaving unconfigured\r\nProcessing triggers for libc-bin (2.23-0ubuntu5) …\r\nErrors were encountered while processing:\r\n mariadb-server-10.1\r\n mariadb-server\r\n”, “stdout_lines”: [“Reading package lists…”, “Building dependency tree…”, “Reading state information…”, “The following package was automatically installed and is no longer required:”, " libevent-core-2.0-5", “Use ‘sudo apt autoremove’ to remove it.”, “The following additional packages will be installed:”, " libmariadbclient18 libmysqlclient18 mariadb-client-10.1", " mariadb-client-core-10.1 mariadb-server-10.1 mariadb-server-core-10.1", “Suggested packages:”, " libterm-readkey-perl mailx mariadb-test tinyca", “The following NEW packages will be installed:”, " libmariadbclient-dev libmariadbclient18 libmysqlclient18 mariadb-client", " mariadb-client-10.1 mariadb-client-core-10.1 mariadb-common mariadb-server", " mariadb-server-10.1 mariadb-server-core-10.1", “0 upgraded, 10 newly installed, 0 to remove and 0 not upgraded.”, “Need to get 14.7 MB of archives.”, “After this operation, 152 MB of additional disk space will be used.”, “Get:1 ://nyc2.mirrors.digitalocean.com/mariadb/repo/10.1/ubuntu xenial/main amd64 mariadb-common all 10.1.21+maria-1~xenial [3196 B]”, “Get:2 ://nyc2.mirrors.digitalocean.com/mariadb/repo/10.1/ubuntu xenial/main amd64 libmysqlclient18 amd64 10.1.21+maria-1~xenial [2894 B]”, “Get:3 ://nyc2.mirrors.digitalocean.com/mariadb/repo/10.1/ubuntu xenial/main amd64 libmariadbclient18 amd64 10.1.21+maria-1~xenial [586 kB]”, “Get:4 ://nyc2.mirrors.digitalocean.com/mariadb/repo/10.1/ubuntu xenial/main amd64 mariadb-client-core-10.1 amd64 10.1.21+maria-1~xenial [688 kB]”, “Get:5 ://nyc2.mirrors.digitalocean.com/mariadb/repo/10.1/ubuntu xenial/main amd64 mariadb-client-10.1 amd64 10.1.21+maria-1~xenial [1109 kB]”, “Get:6 ://nyc2.mirrors.digitalocean.com/mariadb/repo/10.1/ubuntu xenial/main amd64 mariadb-server-core-10.1 amd64 10.1.21+maria-1~xenial [4410 kB]”, “Get:7 ://nyc2.mirrors.digitalocean.com/mariadb/repo/10.1/ubuntu xenial/main amd64 mariadb-server-10.1 amd64 10.1.21+maria-1~xenial [6470 kB]”, “Get:8 ://nyc2.mirrors.digitalocean.com/mariadb/repo/10.1/ubuntu xenial/main amd64 libmariadbclient-dev amd64 10.1.21+maria-1~xenial [1460 kB]”, “Get:9 ://nyc2.mirrors.digitalocean.com/mariadb/repo/10.1/ubuntu xenial/main amd64 mariadb-client all 10.1.21+maria-1~xenial [2802 B]”, “Get:10 ://nyc2.mirrors.digitalocean.com/mariadb/repo/10.1/ubuntu xenial/main amd64 mariadb-server all 10.1.21+maria-1~xenial [2930 B]”, “Preconfiguring packages …”, “Fetched 14.7 MB in 9s (1600 kB/s)”, “Selecting previously unselected package mariadb-common.”, “(Reading database … “, “(Reading database … 5%”, “(Reading database … 10%”, “(Reading database … 15%”, “(Reading database … 20%”, “(Reading database … 25%”, “(Reading database … 30%”, “(Reading database … 35%”, “(Reading database … 40%”, “(Reading database … 45%”, “(Reading database … 50%”, “(Reading database … 55%”, “(Reading database … 60%”, “(Reading database … 65%”, “(Reading database … 70%”, “(Reading database … 75%”, “(Reading database … 80%”, “(Reading database … 85%”, “(Reading database … 90%”, “(Reading database … 95%”, “(Reading database … 100%”, “(Reading database … 235391 files and directories currently installed.)”, “Preparing to unpack …/mariadb-common_10.1.21+maria-1~xenial_all.deb …”, “Unpacking mariadb-common (10.1.21+maria-1~xenial) …”, “Selecting previously unselected package libmysqlclient18.”, “Preparing to unpack …/libmysqlclient18_10.1.21+maria-1~xenial_amd64.deb …”, “Unpacking libmysqlclient18 (10.1.21+maria-1~xenial) …”, “Selecting previously unselected package libmariadbclient18.”, “Preparing to unpack …/libmariadbclient18_10.1.21+maria-1~xenial_amd64.deb …”, “Unpacking libmariadbclient18 (10.1.21+maria-1~xenial) …”, “Selecting previously unselected package mariadb-client-core-10.1.”, “Preparing to unpack …/mariadb-client-core-10.1_10.1.21+maria-1~xenial_amd64.deb …”, “Unpacking mariadb-client-core-10.1 (10.1.21+maria-1~xenial) …”, “Selecting previously unselected package mariadb-client-10.1.”, “Preparing to unpack …/mariadb-client-10.1_10.1.21+maria-1~xenial_amd64.deb …”, “Unpacking mariadb-client-10.1 (10.1.21+maria-1~xenial) …”, “Selecting previously unselected package mariadb-server-core-10.1.”, “Preparing to unpack …/mariadb-server-core-10.1_10.1.21+maria-1~xenial_amd64.deb …”, “Unpacking mariadb-server-core-10.1 (10.1.21+maria-1~xenial) …”, “Processing triggers for libc-bin (2.23-0ubuntu5) …”, “Processing triggers for man-db (2.7.5-1) …”, “Setting up mariadb-common (10.1.21+maria-1~xenial) …”, “Selecting previously unselected package mariadb-server-10.1.”, “(Reading database … “, “(Reading database … 5%”, “(Reading database … 10%”, “(Reading database … 15%”, “(Reading database … 20%”, “(Reading database … 25%”, “(Reading database … 30%”, “(Reading database … 35%”, “(Reading database … 40%”, “(Reading database … 45%”, “(Reading database … 50%”, “(Reading database … 55%”, “(Reading database … 60%”, “(Reading database … 65%”, “(Reading database … 70%”, “(Reading database … 75%”, “(Reading database … 80%”, “(Reading database … 85%”, “(Reading database … 90%”, “(Reading database … 95%”, “(Reading database … 100%”, “(Reading database … 235535 files and directories currently installed.)”, “Preparing to unpack …/mariadb-server-10.1_10.1.21+maria-1~xenial_amd64.deb …”, “Unpacking mariadb-server-10.1 (10.1.21+maria-1~xenial) …”, “Selecting previously unselected package libmariadbclient-dev.”, “Preparing to unpack …/libmariadbclient-dev_10.1.21+maria-1~xenial_amd64.deb …”, “Unpacking libmariadbclient-dev (10.1.21+maria-1~xenial) …”, “Selecting previously unselected package mariadb-client.”, “Preparing to unpack …/mariadb-client_10.1.21+maria-1~xenial_all.deb …”, “Unpacking mariadb-client (10.1.21+maria-1~xenial) …”, “Selecting previously unselected package mariadb-server.”, “Preparing to unpack …/mariadb-server_10.1.21+maria-1~xenial_all.deb …”, “Unpacking mariadb-server (10.1.21+maria-1~xenial) …”, “Processing triggers for man-db (2.7.5-1) …”, “Processing triggers for systemd (229-4ubuntu16) …”, “Processing triggers for ureadahead (0.100.0-19) …”, “Setting up libmysqlclient18 (10.1.21+maria-1~xenial) …”, “Setting up libmariadbclient18 (10.1.21+maria-1~xenial) …”, “Setting up mariadb-client-core-10.1 (10.1.21+maria-1~xenial) …”, “Setting up mariadb-client-10.1 (10.1.21+maria-1~xenial) …”, “Setting up mariadb-server-core-10.1 (10.1.21+maria-1~xenial) …”, “Setting up mariadb-server-10.1 (10.1.21+maria-1~xenial) …”, “Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.”, “invoke-rc.d: initscript mysql, action "start" failed.”, “dpkg: error processing package mariadb-server-10.1 (–configure):”, " subprocess installed post-installation script returned error exit status 1”, “Setting up libmariadbclient-dev (10.1.21+maria-1~xenial) …”, “Setting up mariadb-client (10.1.21+maria-1~xenial) …”, “dpkg: dependency problems prevent configuration of mariadb-server:”, " mariadb-server depends on mariadb-server-10.1 (= 10.1.21+maria-1~xenial); however:”, " Package mariadb-server-10.1 is not configured yet.”, “”, “dpkg: error processing package mariadb-server (–configure):”, " dependency problems - leaving unconfigured”, “Processing triggers for libc-bin (2.23-0ubuntu5) …”, “Errors were encountered while processing:”, " mariadb-server-10.1", " mariadb-server"]}
to retry, use: --limit @develop/install.retry

PLAY RECAP *********************************************************************
localhost : ok=12 changed=1 unreachable=0 failed=1

Traceback (most recent call last):
File “install.py”, line 351, in
install_bench(args)
File “install.py”, line 108, in install_bench
run_playbook(‘develop/install.yml’, sudo=True, extra_vars=extra_vars)
File “install.py”, line 301, in run_playbook
success = subprocess.check_call(args, cwd=os.path.join(cwd, ‘playbooks’))
File “/usr/lib/python2.7/subprocess.py”, line 541, in check_call
raise CalledProcessError(retcode, cmd)
subprocess.CalledProcessError: Command ‘[‘ansible-playbook’, ‘-c’, ‘local’, ‘develop/install.yml’, ‘-e’, ‘@/tmp/extra_vars.json’, ‘–become’, ‘–become-user=ric’]’ returned non-zero exit status 2

(systemctl status mariadb.service)

● mariadb.service - MariaDB database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: failed (Result: exit-code) since Qui 2017-02-09 16:31:56 BRT; 4min 25s ago
Main PID: 16024 (code=exited, status=1/FAILURE)
Status: “MariaDB server is down”

Fev 09 16:31:56 ric-VirtualBox mysqld[16024]: 2017-02-09 16:31:56 140061627975936 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.
Fev 09 16:31:56 ric-VirtualBox mysqld[16024]: 2017-02-09 16:31:56 140061627975936 [Note] Plugin ‘FEEDBACK’ is disabled.
Fev 09 16:31:56 ric-VirtualBox mysqld[16024]: 2017-02-09 16:31:56 140061627975936 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
Fev 09 16:31:56 ric-VirtualBox mysqld[16024]: 2017-02-09 16:31:56 140061627975936 [ERROR] Unknown/unsupported storage engine: InnoDB
Fev 09 16:31:56 ric-VirtualBox mysqld[16024]: 2017-02-09 16:31:56 140061627975936 [ERROR] Aborting
Fev 09 16:31:56 ric-VirtualBox systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Fev 09 16:31:56 ric-VirtualBox systemd[1]: Failed to start MariaDB database server.
Fev 09 16:31:56 ric-VirtualBox systemd[1]: mariadb.service: Unit entered failed state.
Fev 09 16:31:56 ric-VirtualBox systemd[1]: mariadb.service: Failed with result ‘exit-code’.
Fev 09 16:33:39 ric-VirtualBox systemd[1]: Stopped MariaDB database server.

(journalctl -xe)

Fev 09 16:31:55 ric-VirtualBox mysqld[16024]: 2017-02-09 16:31:55 14006162797593
6 [Note] /usr/sbin/mysqld (mysqld 10.1.21-MariaDB-1~xenial) starting as process 16024 …
Fev 09 16:31:56 ric-VirtualBox mysqld[16024]: 2017-02-09 16:31:56 140061627975936 [Note] InnoDB: Using mutexes to ref count buffer pool pages
Fev 09 16:31:56 ric-VirtualBox mysqld[16024]: 2017-02-09 16:31:56 140061627975936 [Note] InnoDB: The InnoDB memory heap is disabled
Fev 09 16:31:56 ric-VirtualBox mysqld[16024]: 2017-02-09 16:31:56 140061627975936 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
Fev 09 16:31:56 ric-VirtualBox mysqld[16024]: 2017-02-09 16:31:56 140061627975936 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
Fev 09 16:31:56 ric-VirtualBox mysqld[16024]: 2017-02-09 16:31:56 140061627975936 [Note] InnoDB: Compressed tables use zlib 1.2.8
Fev 09 16:31:56 ric-VirtualBox mysqld[16024]: 2017-02-09 16:31:56 140061627975936 [Note] InnoDB: Using Linux native AIO
Fev 09 16:31:56 ric-VirtualBox mysqld[16024]: 2017-02-09 16:31:56 140061627975936 [Note] InnoDB: Using SSE crc32 instructions
Fev 09 16:31:56 ric-VirtualBox mysqld[16024]: 2017-02-09 16:31:56 140061627975936 [Note] InnoDB: Initializing buffer pool, size = 128.0M
Fev 09 16:31:56 ric-VirtualBox mysqld[16024]: 2017-02-09 16:31:56 140061627975936 [Note] InnoDB: Completed initialization of buffer pool
Fev 09 16:31:56 ric-VirtualBox mysqld[16024]: 2017-02-09 16:31:56 140061627975936 [Note] InnoDB: Highest supported file format is Barracuda.
Fev 09 16:31:56 ric-VirtualBox mysqld[16024]: InnoDB: No valid checkpoint found.
Fev 09 16:31:56 ric-VirtualBox mysqld[16024]: InnoDB: If you are attempting downgrade from MySQL 5.7.9 or later,
Fev 09 16:31:56 ric-VirtualBox mysqld[16024]: InnoDB: please refer to ://dev.mysql.com/doc/refman/5.6/en/upgrading-downgrading.html
Fev 09 16:31:56 ric-VirtualBox mysqld[16024]: InnoDB: If this error appears when you are creating an InnoDB database,
Fev 09 16:31:56 ric-VirtualBox mysqld[16024]: InnoDB: the problem may be that during an earlier attempt you managed
Fev 09 16:31:56 ric-VirtualBox mysqld[16024]: InnoDB: to create the InnoDB data files, but log file creation failed.
Fev 09 16:31:56 ric-VirtualBox mysqld[16024]: InnoDB: If that is the case, please refer to
Fev 09 16:31:56 ric-VirtualBox mysqld[16024]: InnoDB: ://dev.mysql.com/doc/refman/5.6/en/error-creating-innodb.html
Fev 09 16:31:56 ric-VirtualBox mysqld[16024]: 2017-02-09 16:31:56 140061627975936 [ERROR] Plugin ‘InnoDB’ init function returned error.
Fev 09 16:31:56 ric-VirtualBox mysqld[16024]: 2017-02-09 16:31:56 140061627975936 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.
Fev 09 16:31:56 ric-VirtualBox mysqld[16024]: 2017-02-09 16:31:56 140061627975936 [Note] Plugin ‘FEEDBACK’ is disabled.
Fev 09 16:31:56 ric-VirtualBox mysqld[16024]: 2017-02-09 16:31:56 140061627975936 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
Fev 09 16:31:56 ric-VirtualBox mysqld[16024]: 2017-02-09 16:31:56 140061627975936 [ERROR] Unknown/unsupported storage engine: InnoDB
Fev 09 16:31:56 ric-VirtualBox mysqld[16024]: 2017-02-09 16:31:56 140061627975936 [ERROR] Aborting
Fev 09 16:31:56 ric-VirtualBox systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Fev 09 16:31:56 ric-VirtualBox systemd[1]: Failed to start MariaDB database server.
– Subject: Unit mariadb.service has failed
– Defined-By: systemd
– Support: ://lists.freedesktop.org/mailman/listinfo/systemd-devel

– Unit mariadb.service has failed.

– The result is failed.
Fev 09 16:31:56 ric-VirtualBox systemd[1]: mariadb.service: Unit entered failed state.
Fev 09 16:31:56 ric-VirtualBox systemd[1]: mariadb.service: Failed with result ‘exit-code’.
Fev 09 16:31:57 ric-VirtualBox sudo[15829]: pam_unix(sudo:session): session closed for user root

Any ideas of what is the problem, and how to solve it?

Thanks! :smiley:

2

Hello!

I’m also installing ERPNext for the first time. I’m trying the manual setup. This afternoon, I encountered a very similar error to yours. I’m using an Ubuntu 14.04 environment, Python 2.7.6.

This isn’t my first error; there have been others. But I’m starting to understand them. Our Ubuntu environments have Python already installed. But are missing packages/versions that Bench expects. Sometimes they are caught when validating prerequisites. Sometimes not.

Regarding the error message. I focused on the “mysql-python” section of the error message. I discovered I did not have mysql-python installed. So I tried this:

> pip install mysql-python

This didn’t work either. More errors, but specific to mysql-python. I did more research, and discovered I was missing other software. I did the following:

apt-get install libmariadbclient-dev
apt-get install libssl-dev
pip install mysql-python

Success installing mysql-python. So tried bench again:

bench init frappe-bench && cd frappe-bench

And it worked successfully. Now, I am not sure this helps you. The reason for your error could be different. But perhaps verify that those 3 packages are installed in your environment.

Good luck; hopefully we can both figure this out! :slight_smile:

3

hi #brian_pond
i have similar issues, im trying to install erpnext on my macbook and the error is related to mysql-python, i ran
pip install mysql-python and it says
Requirement already satisfied: mysql-python in /usr/local/lib/python2.7/site-packages

not sure what to do next? can u tell me how to install
apt-get install libmariadbclient-dev
apt-get install libssl-dev
on macbook

here is the post where i have explained the error

4

Thanks, @brian_pond! Before trying your suggestion I followed another route.

I removed everything related to ERPNext and tried again from the start, this time manually verifying the pre-requisites:

  • Python 2.7 (I already have 2.7.12)
  • MariaDB 10+
  • Nginx
  • Nodejs (I already have v6.9.5)
  • Redis (I already have 3.0.6)
  • wkhtmltopdf with patched Qt

The wkhtmltopdf from the universe repository is “not using wkhtmltopdf patched qt”, so instead of using apt-get one can download wkhtmltopdf from its official site . The Linux 0.12.4 64-bit binaries seem to work fine for me:

$ ./wkhtmltopdf --version
wkhtmltopdf 0.12.4 (with patched qt)

… but if anyone prefer to use the easy install, it will automatically install it for you.

Anyway, I found out that mariadb was not being installed correctly and nginx was not starting. I completely removed both as well as any mysql related package I could find, stopped Apache2 (duh! ) and tried again, installing the packages in this order:

sudo apt-get install mariadb-server
sudo apt-get install nginx

Now it worked!

sudo python install.py --develop

Well, kind of… I can start the test server with:

bench start

… and despite some Redis warnings, everything seems fine - that is, until I try to open http://localhost:8000/ or http://127.0.0.1:8000/

11:41:41 web.1 | * Running on http://0.0.0.0:8000/ (Press CTRL+C to quit)
11:45:17 web.1 | localhost does not exist
11:45:52 web.1 | 127.0.0.1 does not exist

I found this thread, stating that “easy install does not create the default site”. So I followed the instructions:

bench new-site localhost

So far, so good. Now, finally:

bench --site localhost install-app erpnext

… but it didn’t work as expected!

[details=“Table ‘334389048b872a53.tabDefaultValue’ doesn’t exist”]Traceback (most recent call last):
File “/usr/lib/python2.7/runpy.py”, line 174, in _run_module_as_main
“main”, fname, loader, pkg_name)
File “/usr/lib/python2.7/runpy.py”, line 72, in _run_code
exec code in run_globals
File “/home/ric/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 79, in
main()
File “/home/ric/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 16, in main
click.Group(commands=commands)(prog_name=‘bench’)
File “/home/ric/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 722, in call
return self.main(*args, **kwargs)
File “/home/ric/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 697, in main
rv = self.invoke(ctx)
File “/home/ric/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 1066, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/ric/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 1066, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/ric/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 895, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/home/ric/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 535, in invoke
return callback(*args, **kwargs)
File “/home/ric/frappe-bench/env/local/lib/python2.7/site-packages/click/decorators.py”, line 17, in new_func
return f(get_current_context(), *args, **kwargs)
File “/home/ric/frappe-bench/apps/frappe/frappe/commands/init.py”, line 24, in _func
ret = f(frappe._dict(ctx.obj), *args, **kwargs)
File “/home/ric/frappe-bench/apps/frappe/frappe/commands/site.py”, line 152, in install_app
_install_app(app, verbose=context.verbose)
File “/home/ric/frappe-bench/apps/frappe/frappe/installer.py”, line 100, in install_app
frappe.clear_cache()
File “/home/ric/frappe-bench/apps/frappe/frappe/init.py”, line 480, in clear_cache
for fn in get_hooks(“clear_cache”):
File “/home/ric/frappe-bench/apps/frappe/frappe/init.py”, line 796, in get_hooks
hooks = _dict(cache().get_value(“app_hooks”, load_app_hooks))
File “/home/ric/frappe-bench/apps/frappe/frappe/utils/redis_wrapper.py”, line 70, in get_value
val = generator()
File “/home/ric/frappe-bench/apps/frappe/frappe/init.py”, line 774, in load_app_hooks
for app in [app_name] if app_name else get_installed_apps(sort=True):
File “/home/ric/frappe-bench/apps/frappe/frappe/init.py”, line 738, in get_installed_apps
installed = json.loads(db.get_global(“installed_apps”) or “”)
File “/home/ric/frappe-bench/apps/frappe/frappe/database.py”, line 691, in get_global
return self.get_default(key, user)
File “/home/ric/frappe-bench/apps/frappe/frappe/database.py”, line 703, in get_default
d = self.get_defaults(key, parent)
File “/home/ric/frappe-bench/apps/frappe/frappe/database.py”, line 709, in get_defaults
defaults = frappe.defaults.get_defaults(parent)
File “/home/ric/frappe-bench/apps/frappe/frappe/defaults.py”, line 72, in get_defaults
globald = get_defaults_for()
File “/home/ric/frappe-bench/apps/frappe/frappe/defaults.py”, line 180, in get_defaults_for
where parent = %s order by creation"“”, (parent,), as_dict=1)
File “/home/ric/frappe-bench/apps/frappe/frappe/database.py”, line 137, in sql
self._cursor.execute(query, values)
File “/home/ric/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py”, line 205, in execute
self.errorhandler(self, exc, value)
File “/home/ric/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py”, line 36, in defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.ProgrammingError: (1146, “Table ‘334389048b872a53.tabDefaultValue’ doesn’t exist”)
[/details]

OK, this is not working… So I removed ~/frappe-bench and tried the manual approach:

bench init frappe-bench && cd frappe-bench/
bench get-app erpnext GitHub - frappe/erpnext: Free and Open Source Enterprise Resource Planning (ERP)
bench new-site site1.local
bench start

I try again to open localhost:8000 and… it is still not working (“localhost does not exist”).

Well, I could not find a bench command to “delete” a site, so I removed the frappe-bench/sites/ folder to create a new one again, but it looks like it was a bad move:

OSError: [Errno 2] No such file or directory: ‘./sites’

So I nuked the frappe-bench/ and started again, this time creating the site “localhost” instead of “site1.local”. The result:

Exception: Database 334389048b872a53 already exists

If I try to access it with the browser anyway:

OperationalError: (1045, “Access denied for user ‘334389048b872a53’@‘localhost’ (using password: YES)”)

Sigh… This seems like a very brittle system. No matter which install instructions I follow, I’m finding problems at every corner.

I dropped the bench tables from mariadb, created the site again:

bench new-site localhost

And was received in the browser with the message:

ProgrammingError: (1146, “Table ‘334389048b872a53.tabDefaultValue’ doesn’t exist”)

I nuked everything - again. :unamused:
Let me give it one more try:

bench init frappe-bench && cd frappe-bench/
bench get-app erpnext GitHub - frappe/erpnext: Free and Open Source Enterprise Resource Planning (ERP)
bench new-site localhost
bench start

Same problem:

ProgrammingError: (1146, “Table ‘334389048b872a53.tabDefaultValue’ doesn’t exist”)

This thread recommends the command:

bench migrate

[details=but it fails!]Traceback (most recent call last):
File “/usr/lib/python2.7/runpy.py”, line 174, in _run_module_as_main
“main”, fname, loader, pkg_name)
File “/usr/lib/python2.7/runpy.py”, line 72, in _run_code
exec code in run_globals
File “/home/ric/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 79, in
main()
File “/home/ric/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 16, in main
click.Group(commands=commands)(prog_name=‘bench’)
File “/home/ric/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 722, in call
return self.main(*args, **kwargs)
File “/home/ric/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 697, in main
rv = self.invoke(ctx)
File “/home/ric/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 1066, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/ric/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 1066, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/ric/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 895, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/home/ric/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 535, in invoke
return callback(*args, **kwargs)
File “/home/ric/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/decorators.py”, line 17, in new_func
return f(get_current_context(), *args, **kwargs)
File “/home/ric/frappe/frappe-bench/apps/frappe/frappe/commands/init.py”, line 24, in _func
ret = f(frappe._dict(ctx.obj), *args, **kwargs)
File “/home/ric/frappe/frappe-bench/apps/frappe/frappe/commands/site.py”, line 204, in migrate
for site in context.sites:
TypeError: ‘NoneType’ object is not iterable
[/details]

Now, for something completely different:

bench set-default-site localhost

[details=“frappe app is not installed”! Why?]frappe app is not installed. Run the following command to install frappe
bench get-app GitHub - frappe/frappe: Low code web framework for real world applications, in Python and Javascript
/bin/sh: 1: /home/ric/frappe/frappe-bench/env/bin/frappe: not found
Traceback (most recent call last):
File “/usr/local/bin/bench”, line 11, in
load_entry_point(‘bench’, ‘console_scripts’, ‘bench’)()
File “/home/ric/.bench/bench/cli.py”, line 40, in cli
bench_command()
File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 722, in call
return self.main(*args, **kwargs)
File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 697, in main
rv = self.invoke(ctx)
File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 1066, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 895, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 535, in invoke
return callback(*args, **kwargs)
File “/home/ric/.bench/bench/commands/utils.py”, line 71, in set_default_site
set_default_site(site)
File “/home/ric/.bench/bench/utils.py”, line 364, in set_default_site
cwd=os.path.join(bench_path, ‘sites’))
File “/home/ric/.bench/bench/utils.py”, line 127, in exec_cmd
raise CommandFailedError(cmd)
bench.utils.CommandFailedError: /home/ric/frappe/frappe-bench/env/bin/frappe --use localhost
[/details]

OK, I thought it was installed by any of the commands before… but let’s do it again:

bench get-app GitHub - frappe/frappe: Low code web framework for real world applications, in Python and Javascript

[details=“fatal: destination path ‘frappe’ already exists and is not an empty directory”]INFO:bench.app:getting app frappe
fatal: destination path ‘frappe’ already exists and is not an empty directory.
Traceback (most recent call last):
File “/usr/local/bin/bench”, line 11, in
load_entry_point(‘bench’, ‘console_scripts’, ‘bench’)()
File “/home/ric/.bench/bench/cli.py”, line 40, in cli
bench_command()
File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 722, in call
return self.main(*args, **kwargs)
File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 697, in main
rv = self.invoke(ctx)
File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 1066, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 895, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 535, in invoke
return callback(*args, **kwargs)
File “/home/ric/.bench/bench/commands/make.py”, line 30, in get_app
get_app(git_url, branch=branch)
File “/home/ric/.bench/bench/app.py”, line 62, in get_app
cwd=os.path.join(bench_path, ‘apps’))
File “/home/ric/.bench/bench/utils.py”, line 127, in exec_cmd
raise CommandFailedError(cmd)
bench.utils.CommandFailedError: git clone GitHub - frappe/frappe: Low code web framework for real world applications, in Python and Javascript --depth 1 --origin upstream[/details]

Now I’m out of ideas. And tired. And hungry. Sorry for the long rant, but I was really excited about the idea of using ERPNext and contributing to the project, but I feel like the documentation and installation process need an overhaul, to say the least…

1 Like
5

OK, so I ate, rested, took a deep breath and restarted the machine. Mariadb failed to start. From /var/log/syslog I noticed it was due to AppArmor. The /usr/sbin/mysqld profile was listed as an “enforced profile” in:

$ sudo apparmor_status
[…]
24 profiles are in enforce mode.
/usr/sbin/mysqld

To fix this I had to:

sudo ln -s /etc/apparmor.d/usr.sbin.mysqld /etc/apparmor.d/disable/
sudo rm /etc/apparmor.d/cache/usr.sbin.mysqld
sudo apparmor_parser -R /etc/apparmor.d/usr.sbin.mysqld
service apparmor reload

It doesn’t matter what I did, it would not work until I deleted the cache file! Anyway, I run “sudo apparmor_status” again and /usr/sbin/mysqld was now gone.

Finally, it’s alive!

bench new-site localhost
bench start

And I could login as Administrator! :triumph:

1 Like
6

Hey @FunKing,

Apologies for the late reply. Working on ERPNext is still a “free time only” project; I’ve got my day job. January and February are usually busy because of Year End activities with clients.

I’m very glad to hear you got it working! I just reached that point this afternoon. I ran into some issues while creating the new site:

bench new-site site1.local

It instructed me to modify the MariaDB my.cnf file, then restart MariaDB. Okay, no problem. But after restart, I got some messages about failing to create new Tables. This led to me manually dropping the Tables and Users, and eventually rebuilding the site. To make a long story short…I was able to Bench Start. Awesome!

Of course, I’ve now got some new issues, related to the initial Wizard. But that probably belongs in another thread, if I cannot resolve them.

Now that I’ve successfully (I think?) completed my first installation…some thoughts:

  1. I am documenting everything. I have a local wiki where I’ve been writing about each installation step, taking screenshots, etc. I’m very interested to start learning the software, and customizing it. So I don’t want to spend more time on installation…for now. But someday I may need to do this again, or work with a customer. So I need more notes than just the official manual instructions.

  2. Related to the above. As you mentioned, the official documentation and installation process could use some work. Once I’ve reached the point where I know what’s going on, I want to try to contribute to that. It would be nice if the installation did a better job examining pre-requisites. Explaining what it’s doing. When things don’t work, tell us that MariaDB isn’t running. Or cleaning up failed installation steps, like creating the initial DB and User. And I’d love to see a more robust installation guide/manual.

Sure, every person’s environment is a bit different. But I’ve glanced through these forums. And there are a ton of questions about installation. From people that are obviously pretty smart to begin with. So while it’s great to collaborate with others on these issues (like yourself), it would be better if the issues were avoided in the first place, right?

But it does work. Just took some extra research, trial and error.

2 Likes
7

Hey,

I ran into exactly the same issue. I always got stuck during the install of mariadb: “dpkg: error processing package mariadb-server (–configure):”

After a lot of googling I came across this post:

… and indeed, spawning a bigger droplet on digital ocean fixed the issue. (before 512Mb, now 2Gig Memory)

How much RAM do you have?

Cheers
Jonny

8

Hello guys,

Indeed ERPNext is very very very difficult to install. The install notes are not adequate at all and errors popping up all the time. I think I have installed ERPNext about 20 times, and I always run into errors.
Especially the development option seems error prone, and it does not install everything. I am not sure what it is supposed to install and what not.

And although the ERPNext team is great, they work hard and they deliver a terrific product. I have the impression that they are not very interested in install problems, or having better installers and/or documentation.

Finally I was able to get a production install working by trial and error(development still is a problem) , but I am afraid to touch it because I still could not discern why it did work this one time, because subsequent attempts in other VM’s all failed.

So maybe we as a community can work to have at least a decent install guide, with a FAQ in case of problems.

1 Like
9

I know it’s a bit late, but might be useful for newbies. i also faced difficulities in installing ERPNext in the beginning but then I followed the instructions available over here - https://www.virtual-server.org/blog/how-to-install-erpnext-on-ubuntu-16-04/ and it successfully worked for me. Hope this helps. Thanks.