Cannot connect to Specify IT login

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.

image

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

image

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

It sounds like you need a bit more assistance with setup than the instructions offer. Members can contact us at support@specifysoftware.org.