Team Pro Setup Instructions for MySQL 5.0

Using Team Pro with MySQL 5.0

 

This page contains Team Pro setup instructions for MySQL 5.0.

 

Instructions for other databases can be found here:

 

MS SQL 7.0
MS SQL 2000
MS SQL 2005
MySQL 4.1.x
MySQL 5.0
 
Oracle 8, 8i, 9i and 10g

 

 

General Instructions

 

Once you have your MySQL Server in place, and have the MySQL client software installed on all Team Client PCs, you are ready to set up your Team-SQL database.

 

The following basic steps are required for setting up your SQL Server and SQL Database:

Create the SQL Database and Set Permissions

 

To create the SQL Database:

  1. Run MySQL Command Line Client
  2. From the mysql> prompt, enter:
    create database team;

 

Create the SQL Database User and Set Permissions

 

To create your SQL database user and set permissions:

 

  1. Run MySQL Administrator.
  2. Select User Administration.
  3. Select the New User button below the User Information Tab.
  4. Enter the following information in the User Information Tab:

    MySQL User = team

    Password = <enter a password>

    Confirm Password = <enter password again>

  5. Select Apply Changes.
  6. Select the Schema Privileges Tab.
  7. Select your team Schemata.
  8. Select << to grant full access for the team user.
  9. Select Apply Changes.

 

 

Test Your Connection using the ODBC Data Source Administrator

 

To test your connection:

  1. Use the Windows Control Panel and select Administrative Tools.
  2. Select Data Sources (ODBC) to run the ODBC Data Source Administrator.
  3. Select the Drivers tab and confirm that MySQL ODBC Driver is there. (If not, you will have to download and install the latest ODBC driver from http://www.mysql.com/products)
  4. Select the User DSN tab.
  5. Select Add.
  6. Select MySQL ODBC Driver.
  7. Select Finish and enter the following:

    Database Name = team
    User = team
    Password = <enter a password>

  8. Select Test and if you see information similar to:

    Success; connection was made!

Your connection is good.

 

Connect Team to Your SQL Database and Upload Your Data

 

To connect Team to your SQL Database:

 

  1. Select TEAM Database Utility from the Alexsys Team Program Group or run TeamAdm.exe in the Alexsys Team server directory to open the Alexsys Team Database Utility.
  2. Login using the Team ADMIN User ID and password.
  3. Select the SQL Setup category.
  4. Select the Server Type (i.e. MySQL via ADO).
  5. Enter the Host Name.
  6. Enter the Server Name.
  7. Enter the User Name.
  8. Enter the Password.
  9. Select the Connect button.
  10. Once connected, select Upload to SQL to upload your existing standard Team database to your SQL database.
  11. Once uploaded, select Close to close the Alexsys Team Database Utility.

    Tip: You must be running with the Standard database as the active database in order to upload your database to SQL. You do not want to make SQL your active database at this time.

     

    Note: When uploading your Standard Team database to your MySQL database, if the upload fails while uploading any table that includes BLOBs (i.e. the LogAtt table) try increasing the Max Allowed Packet settings to 16MB.

     

    If you have to change these settings, remember to Restart your MySQL Service.

 

Test Your Connection to Team-SQL

 

Once you have uploaded your SQL database using the SQL Setup Utility, you can perform another test using Team without forcing all users to run SQL:

 

  1. Alter the Team shortcut on your desktop by adding an /SQL parameter to the Target in the shortcut properties. (i.e. "C:\Program Files\Alexsys\Team\Team.exe" /SQL)
  2. Start Team.
  3. Verify that Team is accessing the SQL database by selecting Help | System Information from the TeamView menu and selecting the Database Tab. You should see information for the SQL server you are accessing.

 

Make SQL the Active Database

 

Once your database has been uploaded to your SQL database and you have tested your connection to your SQL database using Team-SQL, you can make SQL the active database to force all users to use Team-SQL.

 

To make SQL the active database:

 

  1. Select TEAM Database Utility from the Alexsys Team Program Group or run TeamAdm.exe in the Alexsys Team server directory to open the Alexsys Team Database Utility.
  2. Login using the Team ADMIN User ID and password.
  3. Select the SQL Setup category.
  4. Connect to the SQL database by selecting the Connect button.
  5. Once connected, select SQL as the Active Database.
  6. Select Close to close the Alexsys Team Database Utility.
  7. Since SQL is now the active database, you can remove the /SQL argument from any Team shortcuts.