I’m struggling to implement a remote database server.
When I run:
bench new-site test_04.site --verbose --db-host db1 --db-name frappe_04 --mariadb-user-host-login-scope='%'
I get this error:
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/frappe/frappe-bench/env/lib/python3.11/site-packages/pymysql/connections.py", line 775, in _read_packet
packet.raise_for_error()
File "/home/frappe/frappe-bench/env/lib/python3.11/site-packages/pymysql/protocol.py", line 219, in raise_for_error
err.raise_mysql_exception(self._data)
File "/home/frappe/frappe-bench/env/lib/python3.11/site-packages/pymysql/err.py", line 150, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1044, "Access denied for user 'root'@'%' to database 'frappe_04'")
The remote database server is:
hostname = db1
ip = 10.1.22.40
Frappe server IP = 10.1.22.142
I think the database server is setup correctly:
commented out bind address, and set up root@%.
I can connect to db1 from frappe server like:
mysql -h 10.1.22.40 -uroot -p
or
mysql -h db1 -uroot -p
After logged in, I run:
MariaDB [(none)]> show grants;
+--------------------------------------------------------------------------------------------------------------+
| Grants for root@% |
+--------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO `root`@`%` IDENTIFIED BY PASSWORD '*FEC0B5A39...' |
+--------------------------------------------------------------------------------------------------------------+
1 row in set (0.001 sec)
I don’t understand the error:
pymysql.err.OperationalError: (1044, "Access denied for user 'root'@'%' to database 'frappe_04'")
MariaDB [mysql]> select user,host from user where user like "root";
+------+-----------+
| User | Host |
+------+-----------+
| root | % |
| root | localhost |
+------+-----------+
Is root@localhost causing a conflict? They do have unique passwords.
When I run the create site command, the remote database and user are created, but the database is empty.
MariaDB [mysql]> use frappe_04;
Database changed
MariaDB [frappe_04]> show tables;
Empty set (0.001 sec)
MariaDB [frappe_04]> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
MariaDB [mysql]> show grants for frappe_04@'%';
+----------------------------------------------------------------------------------------------------------+
| Grants for frappe_04@% |
+----------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO `frappe_04`@`%` IDENTIFIED BY PASSWORD '*E7AD2E0B45EC27DF715F168526459E3D06E9DAC2' |
+----------------------------------------------------------------------------------------------------------+
I try:
bench new-site test_05.site --verbose --db-host db1 --db-name frappe_05 --mariadb-user-host-login-scope='%' --db-root-username root@'%'
but get:
(1045, "Access denied for user 'root@%'@'10.1.22.142' (using password: YES)")
Is this a remote database server issue or frappe config issue?