I have been using Specify on a single workstation and am now setting setting up sharing with other computers. I have granted permissions to the master user and IT user in MariaDB and edited the my.ini file. I made a mysqldump backup of the Specify database. I reinstalled the Specify application. I’m at the first step of the Specify Wizard. I think I should skip the Create Specify Database since I already have a working Specify database. I clicked the Advanced Test IT Login button. I got Login test was NOT successful. My information is correct. What could be the problem?
I am no longer able to connect to the MariaDB server either with my root account or with the new Master account to which I granted privileges to the specify database. I took my IP address out of my.ini. I still can’t connect.
C:\Program Files\MariaDB 10.8\bin>mysql -uroot -p
Enter password: ********
ERROR 2002 (HY000): Can’t connect to server on ‘localhost’ (10061)
Even when I change the bind-address in my.ini to 127.0.0.1 (“localhost”) I still can’t
connect.
On another computer where I also went through the steps for shared access I can still log in at the command prompt but the Wizard says he is unable to connect.
My computer’s IP address is 10.116.115.181/23. The “/23” needs to be left off, otherwise MariaDB gives the error
ERROR 2005 (HY000): Unknown server host ‘10.116.115.181/23’ (11001)
I tried giving the Master User permission for a range of IP addresses. Had problems using the % wildcard. I tried the slash “/”
GRANT SELECT, INSERT, UPDATE, DELETE, LOCK TABLES ON specify.* TO username’@‘10.116.114.160/10.116.115.181’ IDENTIFIED BY ‘password’;
MariaDB accepted it, and show grants for user shows the privileges where granted.
MariaDB [(none)]> show grants for ‘username’@‘10.116.114.160/10.116.115.181’;
±----------------------------------------------------------------------------------------------------------------------------------+
| Grants for username@10.116.114.160/10.116.115.181 |
±----------------------------------------------------------------------------------------------------------------------------------+
| GRANT SELECT, INSERT, UPDATE, DELETE, LOCK TABLES ON specify
.* TO Arundo
@10.116.114.160/10.116.115.181
|
±----------------------------------------------------------------------------------------------------------------------------------+
but when I Test Master Login in the Specify Wizard I get
Granting permissions for one IP address at a time is OK.
I am able to log in to Specify from one other computer. From another I am able to connect using the MySQL client. I can connect whether I have
Bind-address = [the actual IP address of the computer]
or the Bind-address line commented out
#Bind-address = [IP address]
C:\Program Files\MariaDB 10.6\bin>mysql -h10.116.115.181 -uArundo -p sporobolus
Enter password: ************
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 762
Server version: 10.6.9-MariaDB mariadb.org binary distribution
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
MariaDB [sporobolus]>
However when I try to log in with Specify I get
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
Steve