Actually i tried hitchhiker guide and still got errors, but i tried this guide Install Erpnext on ubuntu 16.04 LTS server · frappe/bench Wiki · GitHub
and it was completely straight forward and got the job done, hope it helps
just check also if this is a fresh server install, and does it have LAMP by default installed as it makes conflict with setup procedures
@a.elhaidary thanks but i have already tried this but couldn’t get success,
Thanks @clarkej i’ll try this.
One caution with those instructions: Step 1 suggests to install as root is an option when in fact that is not a best practice nor advisable.
To avoid issues be sure to run install with sudo from non-root user account, for example create a frappe user and assign the account sudo privileges.
@clarkej thanks, as per your instructions i ran all the setup,
i added required lines in my.cnf but i am unable to restart mariadb service.
& i am also unable to create site because of this.
please take a look.
frappe@localhost:~$ cd frappe-bench/
frappe@localhost:~/frappe-bench$ bench new-site site1.local
MySQL root password:
================================================================================
Creation of your site - site1.local failed because MariaDB is not properly
configured to use the Barracuda storage engine.
Please add the settings below to MariaDB's my.cnf, restart MariaDB then
run `bench new-site site1.local` again.
[mysqld]
innodb-file-format=barracuda
innodb-file-per-table=1
innodb-large-prefix=1
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
[mysql]
default-character-set = utf8mb4
================================================================================
frappe@localhost:~/frappe-bench$ cd ..
frappe@localhost:~$ sudo service mysql restart
[sudo] password for frappe:
Job for mariadb.service failed because a timeout was exceeded. See "systemctl status mariadb.service" and "journalctl -xe" for details.
frappe@localhost:~$ sudo systemctl status mariadb.service
● mariadb.service - MariaDB 10.2.15 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset:
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: failed (Result: timeout) since Tue 2018-05-22 03:30:59 UTC; 53s ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 4020 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WS
Process: 3615 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR
Process: 3608 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START
Process: 3604 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/ru
Main PID: 4020 (code=exited, status=0/SUCCESS)
May 22 03:29:26 localhost.localdomain systemd[1]: Starting MariaDB 10.2.15 datab
May 22 03:29:27 localhost.localdomain mysqld[4020]: 2018-05-22 3:29:27 14062503
May 22 03:30:57 localhost.localdomain systemd[1]: mariadb.service: Start operati
May 22 03:30:59 localhost.localdomain systemd[1]: Failed to start MariaDB 10.2.1
May 22 03:30:59 localhost.localdomain systemd[1]: mariadb.service: Unit entered
May 22 03:30:59 localhost.localdomain systemd[1]: mariadb.service: Failed with r
lines 1-19/19 (END)
“Job for mariadb.service failed because a timeout was exceeded.”
This refers to a failed connection, a timeout typically is due to a closed port.
This should give you details to confirm that?
mariadb expects port 3306 to be open - to check for that run this:
frappe@ubuntu:~/frappe-bench$ sudo ufw status | grep 3306
3306/tcp ALLOW Anywhere
3306/tcp (v6) ALLOW Anywhere (v6)
To open it do this:
sudo ufw allow 3306/tcp
frappe@localhost:~$ cd frappe-bench
frappe@localhost:~/frappe-bench$ sudo ufw status | grep 3306
[sudo] password for frappe:
Sorry, try again.
[sudo] password for frappe:
sudo: ufw: command not found
frappe@localhost:~/frappe-bench$ sudo ufw allow 3306/tcp
sudo: ufw: command not found
frappe@localhost:~/frappe-bench$
@clarkej hi,
i’ve success fully installed ERPNext,
i switched it to Master,
then i ran bench update – patch
i got this
Branch master does not exist in Upstream for erpnext
Successfully switched branches for:
frappe
()
Switched to master
Please run bench update --patch
to be safe from any differences in database schema
frappe@localhost:~/frappe-bench$ bench update --patch
Backing up sites…
Patching sites…
Migrating site2.local
Executing execute:frappe.reload_doc(‘core’, ‘doctype’, ‘docfield’, force=True) #2017-03-03 in site2.local (a46003081c220c38)
Success
Updating DocTypes for frappe : [ ]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/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 94, in
main()
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 18, in main
click.Group(commands=commands)(prog_name=‘bench’)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 722, in call
return self.main(*args, **kwargs)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 697, in main
rv = self.invoke(ctx)
File “/home/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/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/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/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 535, in invoke
return callback(*args, **kwargs)
File “/home/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/frappe/frappe-bench/apps/frappe/frappe/commands/init.py”, line 24, in _func
ret = f(frappe._dict(ctx.obj), *args, **kwargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/commands/site.py”, line 222, in migrate
migrate(context.verbose, rebuild_website=rebuild_website)
File “/home/frappe/frappe-bench/apps/frappe/frappe/migrate.py”, line 33, in migrate
frappe.model.sync.sync_all(verbose=verbose)
File “/home/frappe/frappe-bench/apps/frappe/frappe/model/sync.py”, line 19, in sync_all
sync_for(app, force, verbose=verbose, reset_permissions=reset_permissions)
File “/home/frappe/frappe-bench/apps/frappe/frappe/model/sync.py”, line 45, in sync_for
reset_permissions=reset_permissions, for_sync=True)
File “/home/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py”, line 58, in import_file_by_path
ignore_version=ignore_version, reset_permissions=reset_permissions)
File “/home/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py”, line 132, in import_doc
doc.insert()
File “/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py”, line 240, in insert
d.db_insert()
File “/home/frappe/frappe-bench/apps/frappe/frappe/model/base_document.py”, line 303, in db_insert
), list(d.values()))
File “/home/frappe/frappe-bench/apps/frappe/frappe/database.py”, line 166, in sql
self._cursor.execute(query, values)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/cursors.py”, line 170, in execute
result = self._query(query)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/cursors.py”, line 328, in _query
conn.query(q)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py”, line 893, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py”, line 1103, in _read_query_result
result.read()
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py”, line 1396, in read
first_packet = self.connection._read_packet()
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py”, line 1059, in _read_packet
packet.check_error()
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py”, line 384, in check_error
err.raise_mysql_exception(self._data)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/err.py”, line 109, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.IntegrityError: (1048, u"Column ‘translatable’ cannot be null")
frappe@localhost:~/frappe-bench$
and getting this on my browser
Updating
Your system is being updated. Please refresh again after a few moments
Status: 503
ok a search turned up this that might offer clues and options to try!?
fixed column ‘translatable’ cannot be null,
now getting this
Column ‘allow_in_quick_entry’ cannot be null
why installing ERPNext is so hard?
i am stuck in just installing it over a week ago but yet no luck.
“why installing ERPNext is so hard?”
I think for various reasons:
- code is fast evolving
- install process is not subject to automated testing
- lots of environments and moving parts to support
- etc
Ok @clarkej Now what should i do?
I am new in this community and i am glad because you’re helping me,
i request you to take me to a clean road, it will take your some time but i’ll appreciate your efforts.
please as i told that i am stuck even installing it over a week ago.
“i request you to take me to a clean road,”
ok in that case how about just skip the install?
Instead simply download and run the VM version.
That saves a lot of frustration I find
My cloud won’t allow me to import OVA file, it orders VMDK file,
how can i get VMDK file of Production (Master) version?
Sorry google that so we will both know
i did but not find anything,
i’ve download ERPNext ova file, and virtualbox on my Cloud server linux 16.04 64bit,
now when i am running the server its giving me,
VT-x/AMD-V hardware acceleration is not available on your system. Your 64-bit guest will fail to detect a 64-bit CPU and will not be able to boot.
So then your vps prvider does not support hardware virtualization.
You must find one that does…really google is your friend here