Dear All,
I have configured my MariaDB server externally, and instructed Frappé via common_sites_config.json accordingly:
--------------------------------------------------------%<--------------------------------------------------
{
“db_host”: “[mariadb server name]”,
“db_port”: “3306”
}
--------------------------------------------------------%<--------------------------------------------------
I wish to keep control over the name of the MySQL/MariaDB database, and therefore used this command to create the new site:
bench new-site --db-name frappe_[site_name] --mariadb-root-username admin [site_name]
As you can see, I use a dedicated admin user instead of the default root user to administer MySQL/MariaDB. The option --mariadb-root-username is meant to accommodate this situation, but I cannot connect to the database as superuser admin, using the correct password. Instead, I get:
--------------------------------------------------------%<--------------------------------------------------
Traceback (most recent call last):
File “/usr/local/lib/python2.7/runpy.py”, line 162, in _run_module_as_main
“main”, fname, loader, pkg_name)
File “/usr/local/lib/python2.7/runpy.py”, line 72, in _run_code
exec code in run_globals
File “/usr/local/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 79, in
main()
File “/usr/local/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 16, in main
click.Group(commands=commands)(prog_name=‘bench’)
File “/usr/local/frappe/frappe-bench/env/lib/python2.7/site-packages/click/core.py”, line 716, in call
return self.main(*args, **kwargs)
File “/usr/local/frappe/frappe-bench/env/lib/python2.7/site-packages/click/core.py”, line 696, in main
rv = self.invoke(ctx)
File “/usr/local/frappe/frappe-bench/env/lib/python2.7/site-packages/click/core.py”, line 1060, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/usr/local/frappe/frappe-bench/env/lib/python2.7/site-packages/click/core.py”, line 1060, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/usr/local/frappe/frappe-bench/env/lib/python2.7/site-packages/click/core.py”, line 889, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/usr/local/frappe/frappe-bench/env/lib/python2.7/site-packages/click/core.py”, line 534, in invoke
return callback(*args, **kwargs)
File “/usr/local/frappe/frappe-bench/apps/frappe/frappe/commands.py”, line 69, in new_site
_new_site(db_name, site, mariadb_root_username=mariadb_root_username, mariadb_root_password=mariadb_root_password, admin_password=admin_password, verbose=verbose, install_apps=install_app, source_sql=source_sql, force=force)
File “/usr/local/frappe/frappe-bench/apps/frappe/frappe/commands.py”, line 87, in _new_site
install_db(root_login=mariadb_root_username, root_password=mariadb_root_password, db_name=db_name, admin_password=admin_password, verbose=verbose, source_sql=source_sql,force=force, reinstall=reinstall)
File “/usr/local/frappe/frappe-bench/apps/frappe/frappe/installer.py”, line 31, in install_db
create_database_and_user(force, verbose)
File “/usr/local/frappe/frappe-bench/apps/frappe/frappe/installer.py”, line 49, in create_database_and_user
if force or (db_name not in dbman.get_database_list()):
File “/usr/local/frappe/frappe-bench/apps/frappe/frappe/model/db_schema.py”, line 519, in get_database_list
return [d[0] for d in self.db.sql(“SHOW DATABASES”)]
File “/usr/local/frappe/frappe-bench/apps/frappe/frappe/database.py”, line 106, in sql
self.connect()
File “/usr/local/frappe/frappe-bench/apps/frappe/frappe/database.py”, line 63, in connect
self.use(self.user)
File “/usr/local/frappe/frappe-bench/apps/frappe/frappe/database.py”, line 68, in use
self._conn.select_db(db_name)
_mysql_exceptions.OperationalError: (1044, “Access denied for user ‘admin’@‘127.0.1.0/255.255.255.0’ to database ‘admin’”)
--------------------------------------------------------%<--------------------------------------------------
Using the root server with its password works with the above command.
Using mysql -u admin -p -h [mariadb server name] works, too!
So, there must be something wring with how the Frappé setup script processes my password entry.
Any ideas?
Thanks a lot,
Chris