ERPNext Foundation ERPNext Cloud Chat Blog Discuss Frappé* Donate

Guide: Manual Install ERPNext on Ubuntu 17.xx & 18.xx

installation

#21

Hi,

I also had the problem of accessing the database with a permissions error.

at the command line,
mysql -u root -p
would not login but
sudo mysql -u root -p
would so to fix it

If you could login with sudo but not without sudo then do:

$ sudo mysql -u root -p

[mysql] use mysql;
[mysql] update user set plugin=’’ where User=‘root’;
[mysql] flush privileges;
[mysql] \q

Once done, open a new shell, and then:

$ mysql -u root -p without sudo will work just fine.


#22

Hi,

I am not able to go further from here. Please advice on next step…

sudo bench new-site site1.local
MySQL root password:
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 “/etc/opt/bench/erpnext/apps/frappe/frappe/utils/bench_helper.py”, line 97, in
main()
File “/etc/opt/bench/erpnext/apps/frappe/frappe/utils/bench_helper.py”, line 18, in main
click.Group(commands=commands)(prog_name=‘bench’)
File “/etc/opt/bench/erpnext/env/local/lib/python2.7/site-packages/click/core.py”, line 722, in call
return self.main(*args, **kwargs)
File “/etc/opt/bench/erpnext/env/local/lib/python2.7/site-packages/click/core.py”, line 697, in main
rv = self.invoke(ctx)
File “/etc/opt/bench/erpnext/env/local/lib/python2.7/site-packages/click/core.py”, line 1066, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/etc/opt/bench/erpnext/env/local/lib/python2.7/site-packages/click/core.py”, line 1066, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/etc/opt/bench/erpnext/env/local/lib/python2.7/site-packages/click/core.py”, line 895, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/etc/opt/bench/erpnext/env/local/lib/python2.7/site-packages/click/core.py”, line 535, in invoke
return callback(*args, **kwargs)
File “/etc/opt/bench/erpnext/apps/frappe/frappe/commands/site.py”, line 34, in new_site
verbose=verbose, install_apps=install_app, source_sql=source_sql, force=force)
File “/etc/opt/bench/erpnext/apps/frappe/frappe/commands/site.py”, line 65, in _new_site
admin_password=admin_password, verbose=verbose, source_sql=source_sql,force=force, reinstall=reinstall)
File “/etc/opt/bench/erpnext/apps/frappe/frappe/installer.py”, line 38, in install_db
create_database_and_user(force, verbose)
File “/etc/opt/bench/erpnext/apps/frappe/frappe/installer.py”, line 62, in create_database_and_user
if force or (db_name not in dbman.get_database_list()):
File “/etc/opt/bench/erpnext/apps/frappe/frappe/model/db_schema.py”, line 554, in get_database_list
return [d[0] for d in self.db.sql(“SHOW DATABASES”)]
File “/etc/opt/bench/erpnext/apps/frappe/frappe/database.py”, line 166, in sql
self.connect()
File “/etc/opt/bench/erpnext/apps/frappe/frappe/database.py”, line 116, in connect
charset=‘utf8mb4’, use_unicode = True, conv = conversions, local_infile = self.local_infile)
File “/etc/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/init.py”, line 94, in Connect
return Connection(*args, **kwargs)
File “/etc/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/connections.py”, line 327, in init
self.connect()
File “/etc/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/connections.py”, line 598, in connect
self._request_authentication()
File “/etc/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/connections.py”, line 852, in _request_authentication
auth_packet = self._read_packet()
File “/etc/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/connections.py”, line 683, in _read_packet
packet.check_error()
File “/etc/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/protocol.py”, line 220, in check_error
err.raise_mysql_exception(self._data)
File “/etc/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/err.py”, line 109, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.InternalError: (1698, u"Access denied for user ‘root’@‘localhost’")


#23

Check login in MySQL from command follow the steps from
above for mysql commands


#24

kinda not clear , is “erp.example.com " i can name it up to me , by replace “example” by what i want
and Isn’t it related to Frappe site we created " site1.local” ?


#25

just note

I tried to install frappe with this lines but it makes MariaDB servers failed and down ,
when i just put these lines:

character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci 

It worked fine and the servers kept active


#26

Welcome to ERPNext Ahmed_K_A_Awwad

Please start a new thread that describes what it is you wish to do, and gives what steps you are following that arecausing your problems.

thanks


#27

Thanks
and okay Mr Clarkej


#28

its for the example if you have created the site for domain access
bench new-site erp.netstaronline.com then you have to install the app on the site


#29

okay , i got it