Remote Database Question

[xpservers]

Ok so currently we have a dedicated box running as our master server with tcadmin web and sql database currently running along with some game servers.

 

I would like to use a remote database with a generic webhosting company were currently using. I created the database via cpanel and have a hostname username and password bla bla. Can I use this database for both master and remote servers. ? The webportion will stay on my master server cause its iis and my remote webhosting is linux.

 

A concern I have is everytime a user logs into the game panel it queries the sql database which may cause cpu spikes.

 

another problem is on the remote connection settings in tcadmin I cannot connect to this database either.

There was an error testing the connection. Tested from Chicago. Error: Can't connect to MySQL server on 'db1413.perfora.net' (10061)

 

Can this be an acl or firewall issue on the webhosting side maybee not allowing remote connections to database ?

[RackGaming]

I am getting a very similar error like this also.

Error: Can't connect to MySQL server on 'localhost' (10061) (even though i have tried our domain and also webserver dedicated ip)

[ECF]

Most hosting account MYSql databases have outside access turned off by default.

 

You will need to enable outside access to it.

[swish]

I went and ran the config on the master but i get error:

 

username@myhost. TC.SERVERS does not exist...

 

However its there in the database just listed as tc.servers

 

would the upper/lowercase be the issue?

[RackGaming]

Well a bigger issue for us is the fact that we backup the mysql from tcadmin

last night, and logged into our cpanel control panel, created the DB & User & Password

we then assigned privilages etc, We then connected to phpmyadmin and "imported"

the mysql, after 10 min it said it had exeeded the time allocated blabla so I saw that the

database was 12.5meg, So the only thing I could do was to zipup the mysql.sql database

and try again, Yet again it failed even though the zise was now only 1meg.

 

Furthermore I added the "outside remote connection" thing with everything I could think of I.E direct IP, domain,even a standalone % wildcard.

 

I then filled in info, her eis what i put:

 

Remote Connection Settings:

 

Enable Direct DB Connection - Check

DB Server: rackgaming.co.uk (also tried dedicated IP)

Database Name: rackgame_tcadmin

user: rackgame_tcadmin

Database Password: ******

 

Result:

"There was an error testing the connection. Tested from RG-DS2. Error: Can't connect to MySQL server on 'localhost' (10061)"

[swish]

You have to add your servers IP's (all of them, main box ips) in cPanel to the allowed hosts.

[JasonF]

In WHM

 

Main >> SQL Services >> Additional MySQL Access Hosts

 

Enter the box's IP address so WHM/cPanel will allow a remote mysql connection.

[LFA]

I went and ran the config on the master but i get error:

 

username@myhost. TC.SERVERS does not exist...

 

However its there in the database just listed as tc.servers

 

would the upper/lowercase be the issue?

 

If you created the database with the TCAmin installer it should create it in uppercase on linux servers. If you move your database from Windows to Linux you have to change the table names to uppercase because mysql on windows uses lowercase table names by default.

[swish]

Ahh oki dokie ill do that and post back tonight if it works

[swish]

Well...i manually changed all the tables to uppercase..worked fine...and the error was gone..

 

however if i login its a blank page....i see the header/footer but no content....its only when using the remote DB

 

So I ran the Configuration Setup on the master again and put it back to the local...ideas?

[LFA]

This is because TC_HOMEPAGE_ICONS was not restored or renamed correctly.

[swish]

Luis....You so smaaaaaart

 

I typed it TC_HOMEPAGES_ICONS

 

pesky extra S

 

Works like a charm now.

[swish]

Well now im seeing other erros

 

4/30/2008 4:01:18 PM : StandardPlugins.Database.ManagerMySQLNet.Connect: Can't connect to MySQL server on 'XX.XX.XXX.XX' (10061)

4/30/2008 4:01:18 PM : StandardPlugins.Database.Manager.Execute: Connection must be opened. SQL Command: (INSERT SQL QUERY HERE)

 

Basicly anytime a server is installed uninstalled ect...however the info is still added into the database...which is odd

 

Any other ideas?

 

The connection is made...works fine....just errors in the monitors...

[datalect]

We also just had this problem, but luckily the solution presented itself when we saw TCAdmin was looking for the uppercase table names, but it would have been a pain to rename them all manually, so.. For those people who installed initially on Windows then decide to move to a Linux MYSQL export the tcadmin sql database (MySQL.sql) and jump into 'vi' and do:

 

:1,$s/tc_bandwidth_type/\U&/g
:1,$s/tc_billing_pending_setups/\U&/g
:1,$s/tc_cmdline_config/\U&/g
:1,$s/tc_config_editor_data/\U&/g
:1,$s/tc_countries/\U&/g
:1,$s/tc_datacenters/\U&/g
:1,$s/tc_file_servers/\U&/g
:1,$s/tc_fileman_config/\U&/g
:1,$s/tc_fileserver_reports/\U&/g
:1,$s/tc_game_cmdline/\U&/g
:1,$s/tc_game_config_editor/\U&/g
:1,$s/tc_game_configs/\U&/g
:1,$s/tc_game_keys/\U&/g
:1,$s/tc_game_map_packs/\U&/g
:1,$s/tc_game_mods/\U&/g
:1,$s/tc_game_monitor_setup/\U&/g
:1,$s/tc_game_patches/\U&/g
:1,$s/tc_game_secondary_services/\U&/g
:1,$s/tc_games/\U&/g
:1,$s/tc_gsauto_config/\U&/g
:1,$s/tc_gsw_games/\U&/g
:1,$s/tc_gsw_rcon_commands/\U&/g
:1,$s/tc_homepage_icons/\U&/g
:1,$s/tc_homepages/\U&/g
:1,$s/tc_info/\U&/g
:1,$s/tc_master_voice_servers/\U&/g
:1,$s/tc_news/\U&/g
:1,$s/tc_news_inbox/\U&/g
:1,$s/tc_news_inbox_other/\U&/g
:1,$s/tc_page_navigation/\U&/g
:1,$s/tc_plugins/\U&/g
:1,$s/tc_server_ips/\U&/g
:1,$s/tc_server_perf_category/\U&/g
:1,$s/tc_server_performance/\U&/g
:1,$s/tc_servers/\U&/g
:1,$s/tc_service_performance/\U&/g
:1,$s/tc_services/\U&/g
:1,$s/tc_steam_settings/\U&/g
:1,$s/tc_subadmin_group_permissions/\U&/g
:1,$s/tc_subadmin_groups/\U&/g
:1,$s/tc_subuser_icon_security/\U&/g
:1,$s/tc_subuser_svc_security/\U&/g
:1,$s/tc_subuser_vvs_security/\U&/g
:1,$s/tc_support_categories/\U&/g
:1,$s/tc_support_config/\U&/g
:1,$s/tc_support_details/\U&/g
:1,$s/tc_support_tickets/\U&/g
:1,$s/tc_system_monitor_setup/\U&/g
:1,$s/tc_user_daily_bandwidth/\U&/g
:1,$s/tc_users/\U&/g
:1,$s/tc_virtual_voice_servers/\U&/g

 

It'll save you about 30 minutes of changing the names manually.

 

(Edit) Oh, and then import that sql to your Linux TCAdmin Database.