Windows could not stop the TCAdmin 2.0 monitor service on local computer

[Xelatyper]

I have run through the set up with no problems and I went to do the restart at the end and it looks like the monitor did not restart. I have tried it in services, but still not having any luck.

 

Thanks in advance

[LFA]

Check TCAdmin2\Logs\Monitor\console.log and check for any errors.

 

You should be able to kill the process named TCAdminMonitor.exe in windows task manager.

[Xelatyper]

This is the log.

 

 

TCAdmin - The Game Hosting Control Panel

Table 'tcadmin2.tc_servers' doesn't exist - Parameters: SELECT 'Connection Test' FROM tc_servers WHERE server_id=1

Table 'tcadmin2.tc_servers' doesn't exist - Parameters: SELECT tc_servers.*, tc_datacenters.display_name AS datacenter_name FROM tc_servers, tc_datacenters WHERE (tc_servers.server_id = 1 AND tc_servers.datacenter_id = tc_datacenters.datacenter_id)

Table 'tcadmin2.tc_servers' doesn't exist

Table 'tcadmin2.tc_servers' doesn't exist - Parameters: SELECT tc_servers.*, tc_datacenters.display_name AS datacenter_name FROM tc_servers, tc_datacenters WHERE (tc_servers.server_id = 1 AND tc_servers.datacenter_id = tc_datacenters.datacenter_id)

Table 'tcadmin2.tc_servers' doesn't exist

Table 'tcadmin2.tc_servers' doesn't exist - Parameters: SELECT tc_servers.*, tc_datacenters.display_name AS datacenter_name FROM tc_servers, tc_datacenters WHERE (tc_servers.server_id = 1 AND tc_servers.datacenter_id = tc_datacenters.datacenter_id)

 

I guess it is todo with the MySQL?

[Goran]

This is the log.

 

 

TCAdmin - The Game Hosting Control Panel

Table 'tcadmin2.tc_servers' doesn't exist - Parameters: SELECT 'Connection Test' FROM tc_servers WHERE server_id=1

Table 'tcadmin2.tc_servers' doesn't exist - Parameters: SELECT tc_servers.*, tc_datacenters.display_name AS datacenter_name FROM tc_servers, tc_datacenters WHERE (tc_servers.server_id = 1 AND tc_servers.datacenter_id = tc_datacenters.datacenter_id)

Table 'tcadmin2.tc_servers' doesn't exist

Table 'tcadmin2.tc_servers' doesn't exist - Parameters: SELECT tc_servers.*, tc_datacenters.display_name AS datacenter_name FROM tc_servers, tc_datacenters WHERE (tc_servers.server_id = 1 AND tc_servers.datacenter_id = tc_datacenters.datacenter_id)

Table 'tcadmin2.tc_servers' doesn't exist

Table 'tcadmin2.tc_servers' doesn't exist - Parameters: SELECT tc_servers.*, tc_datacenters.display_name AS datacenter_name FROM tc_servers, tc_datacenters WHERE (tc_servers.server_id = 1 AND tc_servers.datacenter_id = tc_datacenters.datacenter_id)

 

did you import the sql file?

[Xelatyper]

did you import the sql file?

 

No it was from scratch... Should I?

[Goran]

What did you choose under "Database" when you were configuring tcadmin for the first time?

If you choose mysql then you need to create the database, user and import the MySQL.sql located in Database folder of tcadmin installation.

 

After, you need to enter the db user, db password, db host when configuring tcadmin.

[Xelatyper]

What did you choose under "Database" when you were configuring tcadmin for the first time?

If you choose mysql then you need to create the database, user and import the MySQL.sql located in Database folder of tcadmin installation.

 

After, you need to enter the db user, db password, db host when configuring tcadmin.

 

Yes, Sorry I have just noticed that. I dont know how I missed it. Guess the rush off excitement lol.

 

I need to reinstall then I guess.

[Xelatyper]

Need to work out how to install the script as I use phpmyadmin.

[LFA]

mysql -utcadmin2 -ptcadminpass --database=tcadmin2 < "C:\Program Files\TCAdmin2\Database\MySQL.sql"

[Xelatyper]

mysql -utcadmin2 -ptcadminpass --database=tcadmin2 < "C:\Program Files\TCAdmin2\Database\MySQL.sql"

 

Do I run that from command if I am right?

And what should the username and pass be?

 

Thanks

[LFA]

You need to create the database and user before executing the script.

 

mysql.exe is in the mysql\bin folder. Run it from a command prompt like this:

c:\path\to\mysql.exe -utcadmin2 -ptcadminpass --database=tcadmin2 < "C:\Program Files\TCAdmin2\Database\MySQL.sql"

[Xelatyper]

You need to create the database and user before executing the script.

 

mysql.exe is in the mysql\bin folder. Run it from a command prompt like this:

c:\path\to\mysql.exe -utcadmin2 -ptcadminpass --database=tcadmin2 < "C:\Program Files\TCAdmin2\Database\MySQL.sql"

 

I get this error

 

 

ERROR 1064 (42000) at line 18: You have an error in your SQL syntax; check the m

anual that corresponds to your MySQL server version for the right syntax to use

near 'TYPE=MyISAM' at line 7

[LFA]

open mysql.sql in notepad and replace TYPE=MyISAM with ENGINE=MyISAM

[Xelatyper]

open mysql.sql in notepad and replace TYPE=MyISAM with ENGINE=MyISAM

 

Ok that worked now I get this when I start the monitor

 

The Task Scheduler has been started.

The Game Monitor Service has been started.

System.TypeLoadException: A null or zero length string does not represent a vali

d Type.

at System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError,

Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark)

at System.RuntimeType.PrivateGetType(String typeName, Boolean throwOnError, B

oolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark)

at System.Type.GetType(String typeName, Boolean throwOnError)

at TCAdmin.SDK.Database.XmlField.GetValue(String key, Object defaultValue)

at TCAdmin.SDK.Objects.ObjectBase.GetModuleSettings(String appKey)

at TCAdmin.SDK.Objects.ServerEnabledComponent.?()

at TCAdmin.SDK.Objects.ServerEnabledComponent.Start()

[LFA]

Delete ConfigUtility.config. Restart the monitor and open the configuration utility again. Configure it to connect to the mysql server and follow the rest of the steps.

[Xelatyper]

Delete ConfigUtility.config. Restart the monitor and open the configuration utility again. Configure it to connect to the mysql server and follow the rest of the steps.

 

I couldnt get it to run the config again for some reason. I got it all going but in services I cant seem to see TCAdmin2monitor.exe I only see the service manager. Is there any way I can start from scratch with everything? cause uninstalling does not help.

[LFA]

Uninstall. Delete the tcadmin2 folder and reinstall. Then you should be able to run the configuration utility and configure the connection correctly.

[Xelatyper]

Uninstall. Delete the tcadmin2 folder and reinstall. Then you should be able to run the configuration utility and configure the connection correctly.

 

Is it a smart Idea to go with SQLite or is MySQL a much better idea. As all I get are errors. Is there anyone who can log in and check. or maybe run the install as I get so many errors and Im doing everything needed. Never had a problem with V1 lol

[LFA]

If you know how to use mysql use mysql. If not you can use sqlite. Create a support ticket with the remote desktop login for your server and I will take a look.

[Xelatyper]

If you know how to use mysql use mysql. If not you can use sqlite. Create a support ticket with the remote desktop login for your server and I will take a look.

 

I have sent a support ticket.

 

Thanks again

[JakkFrosted]

Username and pass would be the database username and password. I think (not sure been a while) setup asks you to choose this info. Anyway, use this tool and create a user to access said db, or create a db. http://wb.mysql.com/

[Goran]

I assume you installed mysql from somewhere ( http://www.mysql.com ), in the installation process you need to set the root password for the mysql server.

 

When installation is done follow these steps:

 

1. Open command prompt

2. Execute

mysql -u root -p

Enter password:

enter your root password

3. Execute

create database tcadmindb;

4. Execute

grant usage on *.* to tcadmin_user@localhost identified by 'somerandompassword';

5. Execute

grant all privileges on tcadmindb.* to tcadmin_user@localhost ;

6. Exit the mysql by typing quit and pressing enter.

 

Import the db as LFA said, you are done!

[icekohl]

You get everything sorted Xela? I might actually have some free time to get on skype this weekend if your still needing some help. Then again it is the 4th weekend so I may get caught in BBQs and fun with things that explode.