xpservers Posted March 1, 2008 Share Posted March 1, 2008 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 ? Link to comment Share on other sites More sharing options...
RackGaming Posted April 28, 2008 Share Posted April 28, 2008 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) Link to comment Share on other sites More sharing options...
ECF Posted April 28, 2008 Share Posted April 28, 2008 Most hosting account MYSql databases have outside access turned off by default. You will need to enable outside access to it. Link to comment Share on other sites More sharing options...
swish Posted April 29, 2008 Share Posted April 29, 2008 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? Link to comment Share on other sites More sharing options...
RackGaming Posted April 29, 2008 Share Posted April 29, 2008 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)" Link to comment Share on other sites More sharing options...
swish Posted April 29, 2008 Share Posted April 29, 2008 You have to add your servers IP's (all of them, main box ips) in cPanel to the allowed hosts. Link to comment Share on other sites More sharing options...
JasonF Posted April 29, 2008 Share Posted April 29, 2008 In WHM Main >> SQL Services >> Additional MySQL Access Hosts Enter the box's IP address so WHM/cPanel will allow a remote mysql connection. Link to comment Share on other sites More sharing options...
LFA Posted April 29, 2008 Share Posted April 29, 2008 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. Link to comment Share on other sites More sharing options...
swish Posted April 29, 2008 Share Posted April 29, 2008 Ahh oki dokie ill do that and post back tonight if it works Link to comment Share on other sites More sharing options...
swish Posted April 30, 2008 Share Posted April 30, 2008 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? Link to comment Share on other sites More sharing options...
LFA Posted April 30, 2008 Share Posted April 30, 2008 This is because TC_HOMEPAGE_ICONS was not restored or renamed correctly. Link to comment Share on other sites More sharing options...
swish Posted April 30, 2008 Share Posted April 30, 2008 Luis....You so smaaaaaart I typed it TC_HOMEPAGES_ICONS pesky extra S Works like a charm now. Link to comment Share on other sites More sharing options...
swish Posted April 30, 2008 Share Posted April 30, 2008 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... Link to comment Share on other sites More sharing options...
datalect Posted August 29, 2009 Share Posted August 29, 2009 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.