I want to move the sql database from an offsite host onto our dedicated server. I've installed the LAMP server succesfully, including phpmyadmin. I've transferred the database (at least as far as I can see it all went ok).
I've changed the configuration in the databases.cfg file to:
Code:
"war3source"
{
"driver" "mysql"
"host" "localhost"
"database" "war3source"
"user" "root"
"pass" "blahblahpwhere"
//"timeout" "0"
}
{
"driver" "mysql"
"host" "localhost"
"database" "war3source"
"user" "root"
"pass" "blahblahpwhere"
//"timeout" "0"
}
I've also tried with a specific user rather than root.
The server loads ok, and seems to work fine, however in game there are no levels/ etc. There's a warning on the changerace menu that says can't connect to server.
Is there a debug option that allows me to see what's going on when war3source tries to connect to the database? I've had this same server working fine with both local sqlite and remote mysql.
Any further suggestions?
edit: as far as I can tell mysql is working fine on the machine...
Code:
remy@ds:~$ mysql -u war3source -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 144
Server version: 5.5.38-0ubuntu0.14.04.1 (Ubuntu)
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| war3source |
+--------------------+
2 rows in set (0.00 sec)
mysql> use war3source;
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
mysql> show tables;
+----------------------+
| Tables_in_war3source |
+----------------------+
| war3source |
| war3source_item2 |
| war3source_racedata1 |
| war3sourceraces |
+----------------------+
4 rows in set (0.00 sec)
mysql>
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 144
Server version: 5.5.38-0ubuntu0.14.04.1 (Ubuntu)
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| war3source |
+--------------------+
2 rows in set (0.00 sec)
mysql> use war3source;
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
mysql> show tables;
+----------------------+
| Tables_in_war3source |
+----------------------+
| war3source |
| war3source_item2 |
| war3source_racedata1 |
| war3sourceraces |
+----------------------+
4 rows in set (0.00 sec)
mysql>
Logged
