Remote Control

(imported topic written by tshambrey)

I am trying to install and configure TRC. When I install TRC using the darby DB I can launch the web browser but I cant login with the sa acount. When I tried installing TRC connecting to my existing SQL Server by using the " IBM Endpoint Manager for Remote Control Server Installer Wilard" that seens to work but only through the console, I have no web access. "http://localhost:1433. I get 404 errors

I read that I might need a utility called “IEM_Rem_Ctrl_V90_Image_1.zip” which will give me the database files that are located in c:/sqldata/trcdb/rc

My SQL database is in mix mode authentication, I can login the DB as sa using the CLI “osql -U sa”

Which way should I configure TRC,

(imported comment written by Pati_Gall)

Hi,

I am not sure what could be going wrong but, to clarify:

  • Derby should really only be used for poof of concept deployments. Once installed however, to authenticate against the remote control server interface you need to use the default userid and password (Admin/password). You will be prompted to change it after the first log in.

  • You can find instructions on how to deploy the server using MS SQL in this section of the documentation:

http://pic.dhe.ibm.com/infocenter/tivihelp/v26r1/topic/com.ibm.tem.doc_9.1/Remote_Control/RC_TEMUser_Guide/rcusrmssqlservertask.html

RC uses sa authentication, but you should also ensure you use the version of JDBC drivers specified in the section of the documentation I pasted the link for. The drivers must be copied to the server machine and the path specified in the installation wizard correctly.

Hope this helps.

Regards,

Pati

(imported comment written by tshambrey)

I am still having problems installing remote control that connect to my SQL server 2005 here are the things that I’ve done/checked

  1. create sql database from SQL server manager studio Express TRCDB (also tried install without manually creating dbdata)

  2. set .sql database is in mix mode authentication

  3. sa is the owner of the database

  4. download and installed the jdbc driver (location c:\sqljdbc_30\enu\sqljdbc.jar)

  5. create empty folder c:\sqldata\ trcdb

  6. changed WEBSITE Port from 80 to 9080 and 442 to 9443 (tried both ways)

  7. create task (see below)

  8. see error from task run

fixlet tast

delete __createfile

createfile until __ENDCREATE

INSTALLER_UI=SILENT

AdvancedWeb=NO

DATABASE_CHOICE=MSSQL_2005

DB2_DATABASE_CREATE_ON=

DB2_DATABASE_NAME=TRCDB

DB2_DROP_DATABASE=NO

DB2_JDBC_DRIVERS_PATH=

DB2_LIB_DIRECTORY=

DB2_LOCAL=NO

DB2_PASSWORD=db2pass

DB2_PORT=50000

DB2_PROFILE_PATH=

DB2_SERVER_ADDRESS=127.0.0.1

DB2_USERID=db2admin

DERBY_DB_NAME=TRCDB

FIPS_ON=NO

MSSQL_DATABASE_CREATE_DIR=C:\sqldata\trcdb\rc

MSSQL_DATABASE_NAME=TRCDB

MSSQL_DROP_DATABASE=YES

MSSQL_JDBC_DRIVER=C:\sqljdbc_3.0\enu\sqljdbc4.jar

MSSQL_LOCAL=YES

MSSQL_PASSWORD=12deffd@ts

MSSQL_PORT=1433

MSSQL_SERVER_ADDRESS=127.0.0.1

MSSQL_USERID=sa

OperatingSystem=Windows

ORA_DATABASE_NAME=TRCDB

ORA_JDBC_DRIVER=

ORA_PASSWORD=sys

ORA_PORT=1521

ORA_SERVER_ADDRESS=127.0.0.1

ORA_USERID=sys

SP800131A_ON=NO

USER_INSTALL_DIR=C:\Program Files\IBM\Tivoli\TRC\server

WAS_ADMIN_PORT=

WAS_ADMIN_SSL_PORT=

WAS_IPC_CONNECTOR_PORT=

WAS_RMI_PORT=

WAS_SOAP_PORT=

WEBSITE_ADDRESS=localhost

WEBSITE_ADMIN_EMAIL=admin@sdfsfd.com

WEBSITE_HTTPPORT=9080

WEBSITE_HTTPSPORT=9443

WEBSITE_SUBDIR=trc

WEBSITE_TARGET_DEFAULT_HTTP_OR_HTTPS=1

WizDownload_Location=

__ENDCREATE

copy __createfile __Download\TRC.properties

prefetch TRC_win.bfa sha1:0cac9a488297602a492c8cdfc941bc3960985dec size:428090371
http://software.bigfix.com/download/TRC/910_0303/TRC_win_0303.bfa
sha256:1282beebdb6f743f4c0c6bfe6d019fdf7ca916ff2ff69dcd751e6814e12a5c95

dos mkdir C:\sqldata\trcdb\rc

extract TRC_win.bfa

waithidden __Download\TRC.exe

continue if {exit code of action = 0}

dos rmdir C:\sqldata\trcdb\rc

delete __createfile

Error from task

The action failed.

This action has been applied 1 time and will not be applied again.

Status Failed

Start Time 8/22/2014 9:39:29 PM

End Time 8/22/2014 9:40:12 PM

Exit Code -1

Action Script Execution Detail

Completed delete __createfile

Completed createfile until __ENDCREATE

Completed INSTALLER_UI=SILENT

Completed AdvancedWeb=NO

Completed DATABASE_CHOICE=MSSQL_2005

Completed DB2_DATABASE_CREATE_ON=

Completed DB2_DATABASE_NAME=TRCDB

Completed DB2_DROP_DATABASE=NO

Completed DB2_JDBC_DRIVERS_PATH=

Completed DB2_LIB_DIRECTORY=

Completed DB2_LOCAL=NO

Completed DB2_PASSWORD=db2pass

Completed DB2_PORT=50000

Completed DB2_PROFILE_PATH=

Completed DB2_SERVER_ADDRESS=127.0.0.1

Completed DB2_USERID=db2admin

Completed DERBY_DB_NAME=TRCDB

Completed FIPS_ON=NO

Completed MSSQL_DATABASE_CREATE_DIR=C:\sqldata\trcdb\rc

Completed MSSQL_DATABASE_NAME=TRCDB

Completed MSSQL_DROP_DATABASE=YES

Completed MSSQL_JDBC_DRIVER=C:\sqljdbc_3.0\enu\sqljdbc4.jar

Completed MSSQL_LOCAL=YES

Completed MSSQL_PASSWORD=12deffd@ts

Completed MSSQL_PORT=1433

Completed MSSQL_SERVER_ADDRESS=127.0.0.1

Completed MSSQL_USERID=sa

Completed OperatingSystem=Windows

Completed ORA_DATABASE_NAME=TRCDB

Completed ORA_JDBC_DRIVER=

Completed ORA_PASSWORD=sys

Completed ORA_PORT=1521

Completed ORA_SERVER_ADDRESS=127.0.0.1

Completed ORA_USERID=sys

Completed SP800131A_ON=NO

Completed USER_INSTALL_DIR=C:\Program Files\IBM\Tivoli\TRC\server

Completed WAS_ADMIN_PORT=

Completed WAS_ADMIN_SSL_PORT=

Completed WAS_IPC_CONNECTOR_PORT=

Completed WAS_RMI_PORT=

Completed WAS_SOAP_PORT=

Completed WEBSITE_ADDRESS=localhost

Completed WEBSITE_ADMIN_EMAIL=admin@sdfsfd.com

Completed WEBSITE_HTTPPORT=9080

Completed WEBSITE_HTTPSPORT=9443

Completed WEBSITE_SUBDIR=trc

Completed WEBSITE_TARGET_DEFAULT_HTTP_OR_HTTPS=1

Completed WizDownload_Location=

Completed __ENDCREATE

Completed copy __createfile __Download\TRC.properties

Completed prefetch TRC_win.bfa sha1:0cac9a488297602a492c8cdfc941bc3960985dec size:428090371
http://software.bigfix.com/download/TRC/910_0303/TRC_win_0303.bfa
sha256:1282beebdb6f743f4c0c6bfe6d019fdf7ca916ff2ff69dcd751e6814e12a5c95

Completed dos mkdir C:\sqldata\trcdb\rc

Completed extract TRC_win.bfa

Completed waithidden __Download\TRC.exe

Failed continue if {exit code of action = 0}

dos rmdir C:\sqldata\trcdb\rc

delete __createfile

(imported comment written by tshambrey)

Okay I got it to install however now I am getting “A Database connection error has occurred” I saw a thread on this forum in which the person had this exact same problem but no solution was given. Can any one help.

checked:

SA owns the database

database is in mix mode

I am using 9443 and 8090 ports - both site bring up the web site but cant login to neither.

(imported comment written by Luallan)

Hi There ,

Can I ask you to restart your instance of TRC and then open the trc.log file on the system. The log file should list an attemt to connect to the trcdb database instance on SQL Server. There you can see the error. Then hopefully I can help you

regards

Lu.

P.S.

Some instructions that I wrote in the past on how to install TRC against SQL Server via TEM.

===========================================================================================================

nstalling TRC with an SQL Server Backend via TEM

Assumptions:

The system will be deployed on one server that hosts both TRC Application Server and SQL Server.

We are using SQL Server 2005 or 2008 R2

this is a clean installation with no previous TRC data

Server Backend:

The server onto which the TRC Server software will be deployed must have SQL Server already installed on it and it must be installed with mixed mode authentication.

We are going to use the sa account to establish the data connection between the TRC Server software and the SQL Server software. Ensure that the sa account is active and the password is set. The sa account has all granted privileges by default over all databases created in SQL Server.

JDBC Driver:

you need to downlaod the jdbc driver software from Microsoft that will be used as a means of connecting the TRC Server software to the SQL Server software. At this point in time Microsoft provide the following:

Microsoft SQL Server JDBC Driver 3.0 - sqljdbc_3.0.1301.101_enu.exe

Microsoft JDBC Driver 4.0 for SQL Server - sqljdbc_4.0.2206.100_enu.exe

You can use either, but we have used version 3.0 extensively and we recommend you do so.

Download the SQL Server jdbc driver, copy it to the C:\ drive of the Server and Extract it. you should get the following Directory Structure:

C:\sqljdbc_3.0\enu\

We are interested in sqljdbc4.jar so the full path to the jdbc driver would be

C:\sqljdbc_3.0\enu\sqljdbc4.jar

TRC Database location:

We need to create a location where ther TRC databse will reside. Create a driectory structure C:\sqldata\trcdb

TEM:

Log into TEM and locate the “Tivoli Endpoint Manager for Remote control Server Installer Wizard”

Fill in the following values:

Windows radio button selected

Installation Directory c:\Program files\IBM\Tivoli\TRC\server

MSSQL 2005/2008 radio button selected

Database server address 127.0.0.1

Port on which to connect to the database 1433

Name of database to use TRCDB

Database Administrator Userid sa

Database Administrator Password put the sa password here

Path to the JDBC drivers C:\sqljdbc_3.0\enu\sqljdbc4.jar

if Local, create the database checked

if Local, drop and existing database checked

New database location (existing directory required) c:\sqldata\trcdb

HTTPS as Default for Target URL unchecked

Address of Websphere server localhost

Web path of URL trc

HTTP port 80

HTTPS port 443

Administrator email put email here

Enable FIPS unchecked

Adjust some advanced web parameters unchecked

Click Create Server installation task. the task is now ready to be used to deploy to the designated Windows Server of your choice

=======================================================================================================

(imported comment written by tshambrey)

I am also able to log into the TRCDB via CLI

sqlcmd -U “sa” -d “TRCDB”

I am able to check the owner of the database

1>select suser_sname(owner_sid) from sys.databases where name = ‘TRCDB’

go


sa

(1 rows affected)