search www.xcnetwork.com
Simplifying group collaboration...
 
Product Category Optional Search Text  
Article ID:
42
Categories:
General Information
Installation
Configuration
Products:
XC Vault (Linux Server)
XC Vault (Windows Server)
XC Connect (Linux Server)
XC Connect (Windows Server)
Date Created:
09/12/2003 04:50 PM
Date Updated:
09/12/2003 04:50 PM
Rating:
3.666
Responses:
3
Integrating with an existing instance of MySQL
 
Question:
What are the steps for integrating with an existing version of MySQL?
 
Answer:
If you already are running MySQL, we can use your existing instance (version should not matter as we do not use any MySQL specific database features) quite easily.  It just requires a few additional steps on your part to create the required user and tables, as well as to prevent the Xchange Network Server from trying to start it's own instance.

Please select the link below that matches your Xchange Network Server operating system:

Linux  Windows  OS X


For Linux:

All installation instructions are part of the download tar file in the mysql_integration subdirectory, i.e. xcnetwork_[version]/mysql_integration/.  Simply follow the instructions in the mysql_integration.txt file.


For Windows:

1.  Download the MySQL integration zip file from here and unzip it to a temporary location.

2.  Make sure MySQL is running on your server.

3.  Install the Xchange Network Server per the instructions (It will tell you that something is running on port 3306 due to the fact that MySQL is already installed and running).

4.  Copy the install_xcnetwork_database.sql  file provided to you from Support to the c:/xcnetwork/common directory.

5.  Change your working directory to be c:/xcnetwork/common
cd c:/xcnetwork/common.

6.  Login to MySQL as root (or a user that has permission to create users and databases) c:/mysql/bin/mysql -u root -p.

7.  Execute the command "source install_xcnetwork_database.sql".

8.  Assuming there were no error messages, exit from the MySQL command prompt: "exit".  Reload mysql's permissions by executing the command:
c:/mysql/bin/mysqladmin -u root -p reload.

9.  Start the Xchange Network Server services:
Control Panel -> Administrative Tools -> Services
Double-click on each of the following services and change "Start-up Type" to be: "Automatic" and then right-click on each and select "Start" XCNetworkApp and XCConnect.

10.  Assuming all went well you should be able to login to the URL: http://[server]/xcnetwork/admin/ with the username: "admin@xcnetwork.com" and the password "1234".  

At this point, the Xchange Network Server will connect to your database and will store all of its data there.  Please make sure that your MySQL installation is set to startup when the system boots.


For OS X:

1.  Install the Xchange Network Server per the standard instructions.  It will likely report in an error during installation, this is okay continue to step 2.

2.  In a Terminal window (Applications -> Utilities -> Terminal), change your working directory to be /usr/xcnetwork/scripts
cd /usr/local/xcnetwork/scripts/
      
3.  Make sure that your installation of MySQL is up and running
  
4.  Login to MySQL as root (or a user that has permission to create users and databases)
mysql -u root -p
      
5.  Execute the command:
source install_xcnetwork_database.sql
  
6.  Assuming there were no error messages, exit from the MySQL command prompt:
exit
  
7.  Reload mysql?s permissions by executing the command:
mysqladmin -u root -p reload
      
8.  Create the file /Applications/Xchange Network Server/mysql.conf either manually or with the command:
sudo touch /Applications/Xchange\ Network\ Server/mysql.conf
      
9.  Restart the Xchange Network Server by executing the Restart Server.command file in the /Applications/Xchange Network Server/ folder.
  
10. Assuming all went well you should be able to access the URL:
http://[server]/xcnetwork/admin/
and start the 'Getting Started' first-run procedure.
  
If you encounter trouble, do not hesitate to contact our support group for further assistance.
 
Please rate this article (1 being worst, 5 being best):
1  2  3  4  5  
 
Click here to send specific feedback about this article.
home    products    buy now    try now    xc bridge    partners    support    contact    about us    knowledge base    site map    privacy
Copyright© 2002-2008 Xchange Network LLC. All rights reserved.