|
 Team
Pro Setup Instructions for MySQL 4.1.x
Using Team Pro with MySQL 4.1.x
This page contains Team Pro setup instructions for MySQL 4.1.x.
Instructions for other databases can be found
here:
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:
- Run mysql by running C:\mysql\bin\mysql.exe
- From the mysql> prompt, enter:
create database team;
- From the mysql> prompt, enter:
grant all on team.* to 'team'@'%' identified by 'team';
- From the mysql> prompt, enter:
flush privileges;
Test Your Connection using the ODBC Data Source
Administrator
To test your connection:
- Use the Windows Control Panel and select Administrative
Tools.
- Select Data Sources (ODBC) to run the ODBC Data Source
Administrator.
- 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)
- Select the User DSN tab.
- Select Add.
- Select MySQL ODBC Driver.
- Select Finish and enter the following:
Database Name = team
User = team
Password = <enter a password>
- Select Test Data Source and if you see information similar
to:
Data Source "Connected Successfully to 'mysqld-4.1.2-alpha-nt'
!!!
Your connection is good.
Connect Team to Your SQL Database and Upload Your Data
To connect Team to your SQL Database:
- 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.
- Login using the Team ADMIN User ID and password.
- Select the SQL Setup category.
- Select the Server Type (i.e. MySQL via ADO).
- Enter the Host Name.
- Enter the Server Name.
- Enter the User Name.
- Enter the Password.
- Select the Connect button.
- Once connected, select Upload to SQL to upload your
existing standard Team database to your SQL database.
- 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:
- 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)
- Start Team.
- 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:
- 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.
- Login using the Team ADMIN User ID and password.
- Select the SQL Setup category.
- Connect to the SQL database by selecting the Connect
button.
- Once connected, select SQL as the Active
Database.
- Select Close to close the Alexsys Team Database
Utility.
- Since SQL is now the active database, you can remove the
/SQL argument from any Team shortcuts.
|
EULA Agreement