Creating a Proxy Server database to support iPhone clients after installing Interim FeatureRelease 1 

---

If you plan to support iPhone clients with Sametime® 8.5.2 Interim Feature Release 1, you must have a DB2 server. After you update the Proxy Server to Interim Feature Release 1, you will create a database for the Sametime Proxy Server and configure JNDI Resources for database access.

About this task

First create a database and then configure JNDI resources to provide access to the database.

Procedure

1. On the DB2® server, log in to the system as the DB2 administrator created during DB2 installation.
2. From the folder where you extracted STProxyHotFix.zip, copy the DatabaseScripts folder to a local directory.
3. Open a command prompt and navigate to the folder where you copied the DatabaseScripts folder.
4. Create the database by entering one of the following commands from the DatabaseScripts folder. Wait until you see confirmation that the database has been created and the command has finished.
   AIX®, Linux™, or Solaris
   
   • ./createProxyDB.sh STPROXY dbadmin
     Windows™
     
   • createProxyDB.bat STPROXY dbadmin
     
   Replace STPROXY in the command if you want to choose a different database name. Names can be from 1 - 8 characters, but cannot contain special or multibyte characters.
   
   Replace dbadmin with the DB2 Application User ID you created when you installed DB2. This user has database administration authority.
   
   When naming DB2 objects, follow the rules for your operating system.
   
5. Close the command window.
6. Open the DB2 control center.
   AIX, Linux, or Solaris
   
   Open the IBM® DB2 folder on the desktop and click Control Center.
   
   Windows
   
   Click Start -> Programs -> IBM DB2 -> General Administration Tools -> Control Center.
   
7. Find the database name to verify that the new database was created.
8. Verify that the Deployment Manager and node agent have been started.
9. On the server being updated, copy proxyDbSetup.py from the DatabaseScripts folder to:

Network Install:

Primary Node: was_install_root\STPServerPN

Secondary Nodes: was_install_root\STPServerSN

Cell Deployment: was_install_root\STPServerCell

where was_install_root is the file path to the WebSphere root directory.

10. In a text editor, open the proxy.properties file stored in:

Network Install:

Primary Node: was_install_root\STPServerPN\SametimeProxyServerOffering\SametimeServer\STProxy\proxy\

Secondary Nodes: was_install_root\STPServerSN\SametimeProxyServerOffering\SametimeServer\STProxy\proxy\

Cell Deployment: was_install_root\STPServerCell\SametimeProxyServerOffering\SametimeServer\STProxy\proxy\

where was_install_root is the file path to the WebSphere root directory.

 

11. Edit the following values:

• • proxy.DbAppUser (db2admin)
  • proxy.DbAppUserPassword (db2admin password)
  • proxy.DataBaseServerName (host name of the DB2 server)
  • proxy.DataBaseServerPort (default port for DB2)
  • proxy.DbName (database name created earlier)
    
    
12. From the cell directory, run the following command:

Network Install:

Primary Node:
..\AppServer\profiles\proxyProfileName\bin wsadmin.bat -lang jython -user wasUser -password wasPwd -f "script_location/proxyDBSetup.py" "was_install_root\proxyPNprofile\SametimeProxyServerOffering\SametimeServer\STProxy\proxy\proxy.properties"

Secondary Node:
..\AppServer\profiles\proxyProfileName\bin wsadmin.bat -lang jython -user wasUser -password wasPwd -f "script_location/proxyDBSetup.py" "was_install_root\proxySNprofile\SametimeProxyServerOffering\SametimeServer\STProxy\proxy\proxy.properties"

Cell Deployment:
..\AppServer\profiles\proxyProfileName\bin wsadmin.bat -lang jython -user wasUser -password wasPwd -f "script_location/proxyDBSetup.py" "was_install_root\STPServerCell\SametimeProxyServerOffering\SametimeServer\STProxy\proxy\proxy.properties"

where was_install_root is the file path to the WebSphere root directory.

13. After the script completes, verify the JNDI resources.
• 1. Log in to the Integrated Solutions Console.
     
  2. Click Resources -> JDBC -> JDBC Providers and review the provider named DB2 Using IBM JCC Driver.
     
  3. Click Resources -> JDBC -> Data sources and review the data source named STProxyDataSource.
     
  You cannot test the data source until you update the Proxy Server with Interim Feature Release 1, which installs the required DB2 .jar and license files.
  

Parent topic: Installing Sametime 8.5.2 Interim Feature Release 1
Previous topic: Installing Sametime 8.5.2 Interim Feature Release 1 on servers running on WebSphere Application Server
Next topic: Installing Sametime 8.5.2 Interim Feature Release 1 on a Gateway server