Error in installation Ubuntu 16.04 64bit

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

1 Like

@a.elhaidary thanks but i have already tried this but couldn’t get success,

Thanks @clarkej i’ll try this.

https://tech.heliconia.in/erpnext/install-erpnext-in-ubuntu/
follow this guide , it will be good .

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.

1 Like

@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

@clarkej

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

Column 'translatable' cannot be null

fixed column ‘translatable’ cannot be null,
now getting this :confused:
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. :frowning:

“why installing ERPNext is so hard?”

I think for various reasons:

  1. code is fast evolving
  2. install process is not subject to automated testing
  3. lots of environments and moving parts to support
  4. 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. :confused:

“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 :slight_smile:

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 :slight_smile:

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