Home

A Single Interface Remote Administration Tool

1. 8 2 7 Limitations and Restrictions sua a seen 8 3 SIRAT Performance Requirements 4 9 SER Vene Naeh 9 3 2 Description of Reliability Measures nnns 9 33 Erfor Fail re Detectlolice aco uscire sin 10 SA SOCUIEIEU ti a ee a lo upset Ona ah Copa fot Dici eu RR ten 10 32 Maintainability esner ea 10 4 SIRAT Design Overview ai Ee eo rta n vo eee Doe 10 4 1 SIRAT Design Architecture au 10 4 2 SIRAT User Interface Terminology 13 4 3 SIRAT Data How Diagramm ae sen ne D set iN PO UP ERU 13 4 4 SIRAT Database Tables niic er aaa a aa ea 15 5 SIRAT Installation and Configuration Overview 15 5 1 Software Packages used in building SIRAT essere 15 5 2 Installatons es 16 5 3 Config rati retira ere Ue 16 SL conngure MysOL 5 5 0 5 s een 16 5 3 2 Configure JBoss Application Server sese 18 5 3 3 Windows Batch File Customization case 21 6 SIRAT User Interface Overview 22 GT EBEN
2. A X convert Pseler dX Favorites i B eBay Sony Reader Library E SonyStyle f Upgrade Your Browser Suggested Sites Header 5 Doe sey Tons Qe Project Name Middle Ware Name of the Service Description of the Service Type of Request Name Batch Windows Service Service Type Click to Run Click to Delete Service StatAdmin Start the Weblogic Admin Server wbatch C Oracle AdminScriptsRemoteAdminScripts StartAdmincmd N A T 4 dmin cmd NA gt D javascriptrunService 6 Internet Protected Mode On 3 gt 100 The screenshot below indicates that the command is executed and will ask you to click on Get Status button to get the status on the command executed 49 x Google 2 Search More WW Favorites gap B eBay B Sony Reader Library 3 SonyStyle F Upgrade Your Browser T Suggested Sites Header Project Name MiddleWare Name of the Service Description of the Service Type of Request Name Batch Windows Service Service Type Click to Run Click to Delete Service StatAdmin Start the Weblogic Admin Server wbach C Oracle AdminScripts RemoteAdminScriptsStartAdmincmd NIA StopAdminServer Stop the Weblogic Admin Server mbach C Oracle AdminScripts RemoteAdminScripts StopAdmincmd NA i Internet Protected Mode On 100 The screenshot below shows the output of the batch exec
3. A Single Interface Remote Administration Tool SIRAT CSCI 8960 Thesis Equivalent Project in Computer Science Submitted to the Computer Science Department University of Nebraska at Omaha Mentoring Chaired by Dr Azad Azadmanesh Professor at University of Nebraska Department of Computer Science aaad unomaha edu Supervisory Committee Dr Parvathi Chundi Professor at University of Nebraska Department of Computer Science pchundi mail unomaha edu Dr Deepak Khazanchi Professor at University of Nebraska Department of ISQA khazanchi unomaha edu Submitted by Rajesh Ratnala July 2011 Table of Contents 1 Statement of Problem Area wscccscisiecsesiesinesscninicecunssneeciacacnestesestnssateunecucsdeeeersseauentaeeds 4 1 1 Birth of the Idea and its Incentives 5 2 SIRAT Functional Specifications reca beri acide kae eite o EL Ide dx e een nennen 6 2 1 Functions Performed o ee eed PIE tc E ei ba M i esate EI VARI 6 2 2 T SUMS a opea com E iS eA Beau REN ERR er 6 22 Windows Batch Piles inodo ios ae 6 2 2 User nterface Design tan re HP e b idv E eie 7 2 3 Integration with other Technologies 7 2 4 Error Conditions and System Messages 8 2 5 Additional Functionalities a ed Tur dh aaa 8 2 6 Help Material and User
4. 57 8 t S0mmaly senri a na oet spss lace Ei es Pe eee Pelei ise eviter isst evecta 57 8 2 Problems Encountered and Solved anne a anion maison 57 8 3 Suggestions for Future Extensions to Project 58 Appendix A Remote Administration 60 Appendix B Required Support Software to build SIRAT 60 Appendix C PsTools Suite 5 2 5 cic rper ed cenae ecu ve end Rx dE ya Eo a dora e Xx a rob aeos Tesi Aen OUS 61 Appendix D JBoss Application Server eee ecce eese eee eene eene nnn enne nnne nnn 65 Appendix E JRockit JVM ioi dro nean rro nn enu 66 Appendix F MySQL Database niodo rona else 69 Appendix G Oracle Weblogic Application Server 70 Appendix H MySQL 5 5 9 5 0 73 Appendix I Installing the JRockit 1 6 0 20 81 Appendix J Installing the JBoss 5 1 0 GA 85 Appendix K Installing PSTools Suite 88 S Referentes M LP 89 1 Statement of Problem Area Remote administration refers to
5. Status 3 When executing start for MySQLDev the State turned to START_PENDING Query the service again to confirm if the service has started or not 7 5 5 Run a Windows Service with Incorrect Information Created a windows service MySQOLDev Wrong with giving wrong information incorrect IP Address of the remote machine and see what could be the output Project Name Test Name of the Service Deiner Type of Name Batch W indows Service Click to Click to Delete Request Service Type Run Service MySQLDev Dev MySQL Server wservice MySQL559 v Run Delete MySQLDev_Wrong Dev MySQL Server wrong info wservice MySQL559 Query v Run Delete RunIPconfig Example to run a batch command wbatch c RemoteAdmin Testrun cmd N A v Run Delete men SERPS See aeg BEE 0 ches C RemoteAdmin Testruncmd NA v Run Delete Unable to connect to 10 243 213 93 Exited with error code 1 Status 4 In the Command Status Console it shows that SIRAT was unable to connect to the IP Address supplied 7 5 6 Run a Windows Batch File with correct Information To test the functionality of SIRAT with respect to a batch file RunlPconfig service is created and executed Note that the batch file needs to reside on the remote machine On running the batch file the results show the IP address on the remote box There are some customizations for running a batch file which is explained in 5 3 3 section
6. res 76 MySQL Server Instance Configuration Configure the MySQL Server 5 5 server instance Please set the networking options V Enable TCP IP Networking Enable this to allow TCP IP connections When disabled only local connections through named pipes are allowed Port Number E5155 Add firewall exception for this port Please set the server SQL mode V Enable Strict Mode This option forces the server to behave more like a traditional database server It is recommended to enable this option ma res MySQL Server Instance Configuration Configure the MySQL Server 5 5 server instance Please select the default character set reno Makes Latini the default charset This character set is suited for English and other West European languages C Best Support For Multilingualism Make UTFS the default character set This is the recommended character set for storing text in many different languages C Manual Selected Default Character Set Collation Please specify the character set to use Character Set ma res cmn TI Configure the MySQL Server 5 5 server instance Please set the Windows options V Install As Windows Service This is the recommended way to run the MySQL server on Windows M Launch the MySQL Server automatically Include Bin Directory in Windows PATH Check this option to include the directory containing MyS
7. 0 1 lt lt Welcome This installer will guide you through the installation of OR AC Le Oracle JRockit IDK R28 1 for Java SE 6 with IRMC 4 0 1 Instructions Click the Next button to proceed to the next screen If you want to change entries in a previous screen click the Previous button You may quit the installer at any time by clicking the Exit button Rename the directory where you want to install the product 82 oc Oracle JRockit Installer Oracle JRockit JDK R28 1 for Java SE 6 with JRMC 4 0 1 Choose Product Installation Directories Provide the directories where you wish to install OR AC Le Oracle JRockit JDK R28 1 For Java SE 6 with JRMC 4 0 1 Discard Changes Product Installation Directory Product Installation Directory C Program Files Javaljrockit jdk1 6 0_20 R28 1 0 4 0 1 CR g Oracle JRockit Installer Oracle JRockit JDK R28 1 for Java SE 6 with JRMC 4 0 1 EN 4 3 Optional Components Please select which of the Following optional components you want to install OR AC LE Optional Components C Demos and Samples O Source Code Description of Figure B 3 f 83 Dd R ee Install Public JRE ORACLE Install Copy of Public JRE for this computer S Oracle JRockit Installer Oracle JRockit JDK R28 1 for Java SE 6 with JRMC 4 0 1 Install Pu
8. 1to 3 0 3 Previous New Clone Delete Name 2 AdminServer admin ManagedServeri ManagedServer2 i Showing 1to 3of 3 Previous Delete Clone The above screen is the Weblogic Administration console where it shows that the Admin Server and the two managed servers have started successfully by using SIRAT 22 Initializing WebLogic Scripting Tool WLST Welcome to WebLogic Server Administration Scripting Shell Type help for help on available commands Connecting to t3 localhost7000 with userid weblogic Successfully connected to Admin Server AdminServer that belongs to domain TestDomain Warning An insecure protocol was used to connect to the server To ensure on the wire security the SSL port or Admin port should be used instead Shutting down the cluster with name Cluster Shutdown of cluster Cluster1 has been issued please refer to the logs to check if the cluster shutdown is successful Use the state server name or state cluster name Cluster to check the status of the server or cluster Disconnected from weblogic server AdminServer Exiting WebLogic Scripting Tool Home Log Out Preferences zx Record Help Q Welcome weblogic Connected to TestDomain Home gt Summary of Servers Summary of Servers Configuration Control A server is an instance of WebLogic Server that runs in its own Java Virtual Machine JVM and has its own configur
9. 42 Upgrade Your Browser Suggested Sites 5 Header te am Paver Safety Tons QC Select what you want DO Box Memory Usage User Name RajPC Admin Internet Protected Mode On 10 gt 44 Output ofthe Memory Usage ofthe Remote Machine X f 28 Googie x Google 3D Search More Signin amp X Convert M Sele Je Favorites p EP eBay E Sony Reader Library 3 SonyStyle Upgrade Your Browser Suggested Sites lt Header ME Safety Tons ir Process memory detail for 169 254 250 143 Name Pid VM WS Priv Priv Pk Faults NonP Page Idle 002400000 System 4 8556 3096 0 0 25079 0 0 smss 396 4472 764 288 332 27508 csrss 464 105292 5272 1748 1748 3423 5 230 508 46644 4088 1432 1476 1997 4 94 carss 520 112504 8888 2148 12560 21437 6 244 services 552 44332 7404 2948 4528 4667 8 95 Isass 568 53488 8168 3256 3340 2996 9 107 Ism 580 34836 5188 2472 2476 1686 4 65 winlogon 692 43904 5576 2136 3036 2608 3 81 svchost 764 42176 6540 2968 3348 56947 4 75 svchost 824 47304 7704 4136 4360 3035 8 96 svchost 868 145088 35992 67272 99884 87658 12 123 svchost 968 71496 11696 14196 16012 4907 11 111 svchost 1012 162868 73404 68892 104840 60934 15 156 svchost 1024 135640 31684 22500 28596 27083 44 227 audiodg 1136 46612 14620 12816 13512 463 372 svchost 1160 33192 4736 1968 2084 1273 3 61 SLsvc 1184 2196 11612 6136 13
10. Choose the Allow a program through Windows Firewall option and click the Add port button e Enter MySQL into the Name text box and 3306 or the port of your choice into the Port number text box e Also ensure that the TCP protocol radio button is selected If you wish you can also limit access to the MySQL server by choosing the Change scope button e Confirm your choices by clicking the OK button 80 Additionally when running the MySQL Installation Wizard on Windows Vista or newer ensure that you are logged in as a user with administrative rights Appendix I Installing the JRockit 1 6 0 20 You can download the JRockit version used while building SIRAT or the latest version from the Oracle JRockit page Get the correct version with respect the OS you are using Note JDK for the JVM should be decided while developing the Java code On whatever JDK the Java code is developed we need to use that particular JVM for the application Server Platform Use Windows 32 bit x86 product name version windows ia32 exe Windows 64 bit Xeon AMD64 product name version windows x64 exe Download the appropriate file and install in C RemoteAdmin Jrockit lt version name gt On your local drive locate the installer for the version of the product you want to install Run the installer and follow the screen instructions shown 81 e S Oracle JRockit Installer Oracle JRockit JDK R28 1 for Java SE 6 with JRMC 4
11. Note web xml file contains the default settings for all web applications deployed in JBoss server This file needs some to be modified if you want to incorporate something the application needs This file will be used to let the application know where the PsTools Suite is installed xml versionz 1 0 encoding UTF 8 gt web ap xmins xsi http www w3 org 2001 XMLSchema instance xmins http java sun com xml ns javaee xmiIns web http java sun com xmi ns javaee web app 2 5 xsd xsi sschemalocation http java sun com xmi ns javaee http java sun com xml ns javaee web app 2 5 xsd id WebApp ID version 2 5 gt lt display name gt RemoteAdmin lt display name gt lt servlet gt lt servlet name gt RemoteProjAdminBusinessBean lt servlet name gt lt servlet class gt com remoteadmin businessbean RemoteProjAdminBusinessBean lt servlet class gt lt load on startup gt 0 lt load on startup gt lt servlet gt lt context param gt lt description gt Path of window execute files lt description gt lt param name gt exe_folder lt param name gt lt param value gt C RemoteAdmin Tools PSTools lt param value gt lt context param gt lt welcome file list gt lt welcome file gt Login jsp lt welcome file gt lt welcome file list gt lt web app gt 20 5 Make sure that the PSTools are placed in the folder mentioned in the web xml file Also run and register all the exe files used inside the folder Double
12. Page Enter the required information and select Box Memory Usage Click on submit button Test case 22 Test Box Memory Usage with wrong information Open the Interface Enter login credentials Click Reachability Test Page 34 23 24 25 26 27 Enter the required information with some wrong input and select Box Memory Usage Click on submit button Test case 23 Test Box Disk Usage Open the Interface Enter login credentials Click Reachability Test Page Enter the required information and select Box Disk Usage Click on submit button Test case 24 Test Box Disk Usage with wrong information Open the Interface Enter login credentials Click Reachability Test Page Enter the required information with some wrong input and select Box Disk Usage Click on submit button Test case 25 Test Task Manager Open the Interface Enter login credentials Click Reachability Test Page Enter the required information and select Box Task Manager Click on submit button Test case 26 Test Task Manager with wrong information Open the Interface Enter login credentials Click Reachability Test Page Enter the required information with some wrong input and select Box Task Manager Click on submit button Test case 27 Test the integrated Weblogic Application Server Admin Scripts Open the Interface Enter login credentials Create new Project and new Services for integrating with Weblogic Application Se
13. Page do celle narco sco see bes E ER PR RI ERN a SUR HA pA 23 6 2 Register Pag anne 23 6 3 Home Page uot De DRIED BR i UD eise 24 GA Project LISt Page a ode e t e edi dita fue acte o s Re du 24 6 5 Create Service Page niet 25 6 6 Reachability Paga cios actos ee 26 6 7 About and Log Out Pages a aan Du ond 27 7 SIRAT Verification m 28 7 1 Test Bed Environmental el Ag dure ipta feud 28 7 1 1 Simple Home Netwolk otio ea 28 7 1 2 Office NetwoFl ue ea ran tn each 30 7 2 tems Functions to be 185 60 eerte inen eene ne eo adea ene nee 31 7 3 Description of Test Cases u anal al 31 36 7 5 1 Login and Log out functionality antenne ae 36 7 5 2 Replstration autark ein 36 7 5 3 Create Project and Service acsi ceret ease baie eee ead a anna 37 7 5 4 Run a Windows Service with Correct Information Query Start Stop 37 7 5 5 Run a Windows Service with Incorrect 10 39 7 5 6 Run a Windows Batch File with correct 10 39 7 5 7 Run a Windows Batch File with Incorrect Information 40 7 5 8 Reachability Test 41 7 6 Example SIRAT Integration with Oracle Weblogic Application Server 47 7 TAO E E E 55 8 CONCIUSIONS e
14. Password This element specifies the default password used when creating a new connection The actual password may be overridden by the application code getConnection parameters or the connection creation context JAAS Subject Appendix K Installing PSTools Suite You can download the latest version of PSTools Suite from the website or you can find it in C RemoteAdmin Installables PSTools folder In order to install these tools you need to double click each executable file so that it can get registered in the machine When executing these commands the application launches itself and installs a Windows service on the remote machine This Windows service performs the task you requested using the credentials you provided at launch time If an end user UI on the client system is required by the specific tool this service then launches an additional binary in the user s context Remember that services can t throw direct interactive Uls The service communicates any necessary information back to the console that launched it And finally the service uninstalls itself 88 9 References http www mysql com about http www mysql com why mysql http en wikipedia org wiki MySQL http en wikipedia org wiki JRockit http en wikipedia org wiki Test_case http en wikipedia org wiki Batch_file http en wikipedia org wiki Software_testing http en wikipedia org wiki Windows_service http en wikipedia org wiki User_interface_de
15. being copied is newer Displays Ul on the Winlogon secure desktop only works on the local system Runs the command on all computers specified in the text file PsInfo is used to provide detailed system information This obviously would be the most useful when scripted against multiple remote systems with the output sent to a file such as an Excel and database friendly CSV file Note that this utility operates via an important concept that is different from most of the other tools if you don t provide a computer name PsInfo will by default attempt to query all computers in the domain PsInfo s usage is as follows 63 Copy Code PsInfo computer u username p password While the syntax is simple additional switches and parameters are also available as shown below PsInfo Switches Switch Description h Shows all Windows updates 5 Shows all applications installed on the system d Shows disk volume information for the system C Outputs the results in CSV format t Specifies another delimiter for the CSV file other than the default value of t Filter Shows only data that matches a given filter file Runs the command on all computers listed in the specified text file PsList PsList is able to capture the list of one or more processes running on a remote system Usage for PsList is pretty simple Copy Code PsList computer u username p password account As with the other tools the account pa
16. freedom from platform lock in MySQL was originally founded and developed in Sweden by two Swedes and a Finn David Axmark Allan Larsson and Michael Monty Widenius who had worked together since the 1980 s The MySQL database has become the world s most popular open source database because of its high performance high reliability and ease of use It is also the database of choice for a new generation of applications built on the LAMP stack Linux Apache MySQL PHP Perl Python Many of the world s largest and fastest growing organizations including Facebook Google Adobe Alcatel Lucent and Zappos rely on MySQL to save time and money powering their high volume Web sites business critical systems and packaged software MySQL runs on more than 20 platforms including Linux Windows Mac OS Solaris HP UX IBM AIX giving you the kind of flexibility that puts you in control Whether you re new to database technology or an experienced developer or DBA MySQL offers a 69 comprehensive range of database tools support training and consulting services to make you successful Appendix G Oracle Weblogic Application Server Note This section is an amalgamation from various websites referenced in the Reference section Allthe material discussed here will help us better understand the concepts used in building SIRAT We will be using this Middleware Application Server to integrate the Remote Admin Tool We will attempt to u
17. if the request is to run a windows service or to run a batch file on the remote machine SERVICE TYPE NAME if Request Type is batch it stores the full path of the batch file and if Request Type is Windows service then it stores the name of the Windows service on the remote machine 17 e Remote Projects This table is used to store the Projects created information CREATE TABLE myproject remote_projects PROJ ID INT AUTO INCREMENT NOT NULL PRIMARY KEY PROJ NAME varchar 128 PROJ DISC varchar 300 PROJ ID For each project created in SIRAT an ID is associated with it This ID will be used by the Java Code PROJ NAME is used to store the name of the project created in SIRAT PROJ DISC is used to store the description about the project e Users This table is created to store all the user information Apart from user information it also stores the user credentials CREATE TABLE myproject users USER ID INT AUTO INCREMENT NOT NULL PRIMARY KEY USER NAME varchar 32 USER PASSWORD varchar 64 FIRST NAME varchar 64 LAST NAME varchar 64 USER ID USER NAME USER PASSWORD FIRST NAME and LAST NAME As the variables used here are self explanatory All are related to user information 5 Oncethe four tables are created the configuration of the Database is complete Note In JBoss configuration section you should be ready with the drivers used to make connection from the application server to
18. into as the project develops 2 SIRAT Functional Specifications 2 1 Functions Performed As the scope of the topic is very vast this project will be limited to windows operating system only In windows operating system everything can be done using a batch file or as a windows service 2 2 1 Windows Service On Microsoft Windows operating systems a Windows service is a long running executable task that performs specific functions which is designed not to require user intervention Windows services can be configured to start when the operating system is booted and run in the background as long as Windows is running or they can be started manually when required They are similar in concept to a UNIX daemon Many of such services appear in the processes list in the Windows Task Manager most often with a username of SYSTEM LOCAL SERVICE or NETWORK SERVICE though not all processes with the SYSTEM username are services The remaining services run through svchost exe as Dynamic Link Libraries DLLs loaded into memory Once a service is installed it can be managed by launching Services from the Windows Control Panel Administrative Tools or typing Services msc in the Run command on Start menu In Windows Vista and later it can be started or stopped in the Services tab in Windows Task Manager and its process can also be found The Services management console provides a brief description of the service functions and displays the path to the
19. or DBA Create all the services which belong to middleware category under project Middleware At the same time all the services which come under Database Administration will come under the project DBA You can create a project with whatever name you want but it should make sense to the services under it The main purpose is to categorize all the services in a manageable form 4 3 SIRAT Data Flow Diagram The flowchart in Figure 3 describes the current SIRAT user interface usage 13 Register to get Login ID Homepage and Click on Projects Page see your Create Project Project Click on your Project POOR No Service Create Service see your Service Run your Service Did it run Check for the successfull Error Exception and make y the necessary changes Figure 3 SIRAT Flow Chart Diagram 14 4 4 SIRAT Database Tables SIRAT has mainly four database tables The four tables are listed below e Users e Remote_Projects e Remote_Service e Remote Project Admin Users table is created to store all the user information of SIRAT Apart from user information it also stores the user credentials Remote Projects is created to store all the project names and its details Remote Service is used to store the information while creating a service The information can be later used to run the service Remote Project Admin table stores the information needed while navigating through SIRAT It is also used wh
20. protocol was used to connect to the server To ensure on the wire security the SSL port or Admin port should be used instead ing the following servers in Cluster Cluster1 ManagedServer1 ManagedServer All servers in the cluster Cluster are started successfully Disconnected from weblogic server AdminServer Exiting WebLogic Scripting Tool WeblogicMonitor project was created to keep all the weblogic monitoring scripts Here two services have been created the screenshot shown below to monitor JVM Runtime metrics on server1 and server2 Project Name Weblogic Monitor ya Name of the Service Description ofthe Service Type of Request Name Batch Windows Service Service Type Click to Run Click to Delete Service WebMonServerl JVM Run Time Metrics of Server wbatch C OracleAdminScsipts RemoteAdminScripts WebMoaServerlcmd N A v Eus Delete E WebMonServer2 JVM Run Time Metrics of Server wbatch C Oracle AdminScripts RemoteAdminScripts WebMonServer2 cmd NIA Bun Delete Test Weblog Monstor 54 The result shown below is what you see when the service WebMonServer1 was executed from SIRAT It shows all the JVM Runtime parameters of Server1 For more help use help serverRuntime 1 AllProcessorsAverageLoad 0 09578447706532843 r Concurrent false r FreeHeap 3828400 1 FreePhysicalMemory 1128620032 r GCHandlesCompaction true 1 GcAlgorithm Dynamic GC current stra
21. s context The service communicates any necessary information back to the console that launched it And finally the service uninstalls itself In order to use the tools you must have the following prerequisites either Windows NT Windows 2000 Windows XP Windows Vista Windows 7 or Windows Server 2003 x86 or x64 versions of Windows are supported but Itanium versions are not The Pre Conditions to make the PsTool Suite work In order to make PsTools work the below are pre conditions which should be implemented on the servers e Ping The Remote machine should give positive response when you ping it That means all the Remote Machines should in a reachable network e Net share ADMINS share should be enabled Means all the Remote Machine CNWINDOWS folder should be accessible e Remote Registry service PsTools suite makes use of RPC calls via port 445 Make sure that the port 445 is opened in the firewall e Administrator Rights Make sure that you have Administrator rights on the Remote Machines SIRAT does not use all the tools in suite It mainly uses PsExec Psinfo and PsList PsExec PsExec is a light weight telnet replacement that lets you execute processes on other systems complete with full interactivity for console applications without having to manually install client software PsExec s most powerful uses include launching interactive command prompts on remote systems and remote enabling tools like IpConfig that
22. service executable its current status startup type dependencies and the account under which the service is running 2 2 2 Windows Batch Files In DOS OS 2 and Microsoft Windows a batch file is a text file containing a series of commands intended to be executed by the command interpreter Similar to job control language and other systems on mainframe and minicomputer systems batch files were added to ease the work required for certain regular tasks by allowing the user to set up a batch script to automate many commands When a batch file is run the shell program usually command com or cmd exe reads the file and executes its commands normally line by line Batch files are useful for running a sequence of executables automatically and are often used to automate repetitive or tedious processes Unix like operating systems such as Linux have a similar type of file called a shell script DOS batch files have the filename extension bat Batch files for other environments may have different extensions e g cmd or bat in the Microsoft Windows NT family of operating systems and OS 2 or btm in 4DOS and ANT related shells The Windows 9x family of operating systems only recognizes the bat extension In OS 2 a file with a cmd extension can also be a Rexx file In MS DOS a batch file can be started from the command line by typing its name along with any required parameters and pressing the enter key When MS DOS loads the fil
23. the database 5 3 2 Configure JBoss Application Server This section will describe the JBoss configuration required for deploying SIRAT By this time we should be ready with the final java code RemoteAdmin war Follow the instructions for deploying SIRAT 1 Copy the JDBC driver required for the JBoss datasource Download MySQL driver for JBoss version you are using and copy it in C RemoteAdmin jboss 5 1 0 GA server default lib folder The name of the file will be mysql connector java 5 1 10 jar 18 Note A JDBC driver is a software component enabling a Java application to interact with a database To connect with individual databases JDBC the Java Database Connectivity API requires drivers for each database 2 Now copy the DataSource xml file which has required information of the database The name of the file given here is rpa jboss ds xml Copy this in C RemoteAdmin jboss 5 1 0 GA server default deploy folder Note rpa jboss ds xml file is used by the JBoss application server to get the information about the database which it needs to connect The content of the file is lt xml versionz 1 0 encoding UTF 8 gt datasources lt local tx datasource gt lt jndi name gt jdbc rpads lt jndi name gt lt connection url gt jdbc mysql localhost 3306 myproject autoReconnect true amp amp autoReconnectFo rPools true lt connection url gt lt driver class gt com mysql jdbc Driver lt driver c
24. 284 9932 2 88 svchost 1236 89872 13448 7524 8240 4194 26 157 svchost 1384 104504 15624 16060 16492 7187 19 150 spoolsv 1668 97756 11556 6192 6756 5071 9 155 svchost 1692 69724 16024 11664 66396 33778 22 86 taskeng 1876 58200 5828 2084 2152 2032 4 110 taskeng 440 88832 10092 9120 9184 3 158 dwm 472 104920 39504 38012 42368 135157 5 127 explorer 772 186816 43008 27624 37372 75297 18 328 taskeng 1400 60948 4716 1528 1660 1439 3 116 MSASCui 1296 97244 9440 6232 6864 4213 9 173 LI Internet Protected Mode On gt K10 gt x Google 2 Search More Sign A X iConvert lt see 3 Favorites gap eBay Sony Reader Library B SonyStyle Upgrade Your Browser Suggested Sites Header A am Paver Mey Tons Qe C Select what you want DO 169254 250 153 BoxDiskUsage User Name RajPCAdmin Internet Protected Mode On gt K10 gt 45 Output of the Disk usage of the Remote machine x Googk f Search More Signin amp X Convert P Sele Je Favorites jap EP eBay Sony Reader Library 3 SonyStyle f Upgrade Your Browser Suggested Sites Header ME am Pager safety Tools e C Reachabilty Test information for 1169 254 250 153 O days 0 hours 51 minutes 30 seconds Processor type InteKR Core TM 2 Duo CPU T5550 Physical memory 3062 MB Video driver Mobde Intel R 965 Express Chipset Family Volume Type Format Label Size Free Free
25. Admin jboss 5 1 0 GA Once the archive is extracted JBoss is fully installed and ready for use You can see the folder structure in the diagram below 85 Name Size Type bin File Folder cient File Folder common File Folder O docs File Folder lib File Folder server File Folder openlogic yarl 1KB YAML File E copyright txt 6KB Text Document jar versions xmil 105 KB XML Document JBossORG EULA txt 8KB Text Document 8 html 33KB HTML Document iB readme html 36 KB HTML Document Some Important JBoss Install Directory Structure The binary distribution unpacks into a top level JBoss install directory often referred to as the JBOSS DIST directory There are four sub directories immediately below this NOTE Some directories are dynamically created when you start JBoss Some directories may not exist in older versions bin contains various scripts and associated files This is where the run and shutdown scripts which start and stop JBoss reside client stores configuration and jar files which may be needed by a Java client application or an external web container You can select archives as required or use jbossall client jar docs contains useful information lib jar files which are needed to run the JBoss microkernel You should never add any of your own jar files here server each of the subdirectories in here is a different Server Configuration The configuration is selected by
26. C Fixed NTFS 227 04 GB 22 29 GB 9 8 D Removable 0 0 E Removable 0 0 F CD ROM 0 0 im Internet Protected Mode On gt 100 gt Ping Output Given Wrong Destination Ping Result Pinging 10 253 213 93 with 32 bytes of data Request timed out Reply from 192 168 36 252 Destination host unreachable Reply from 192 168 36 252 Destination host unreachable Reply from 192 168 36 252 Destination host unreachable Ping statistics for 10 253 213 93 Packets Sent 4 Received 3 Lost 1 25 loss Approximate round trip times in milli seconds Minimum Oms Maximum Oms Average Oms Output of Remote Machine Memory When Given Wrong Destination IP Address Box Memory Usage Failed to take process snapshot on 10 253 213 93 Make sure that the Remote Registry service is running on the remote system that you havefirewall ports allow RPC access and vour account has read access the following key on the remote system HKLM Software Microsoft Windows NT CurrentVersion Perflib 46 7 6 Example SIRAT Integration with Oracle Weblogic Application Server The main purpose of building a tool such as SIRAT is to assist administrators in their daily work In real world IT administrators have to work on different technologies and they are required to do repetitive tasks on different remote machines As indicated this tool is prepared so that it can integrate with thes
27. IRAT can be developed to be multifunctional It can span various topics and functionalities covering all aspects of administrative needs This can be infeasible within the time allocated for this project Therefore SIRAT has been created as a plug in or add on tasks However SIRAT can be customized to include enhanced functionalities and be integrated with other technologies 1 Operating System SIRAT is mainly developed for Windows operating System The third party tools used will only work with windows OS 2 Authorization SIRAT is limited to authentication facility only It does not have the facility for authorization For the purpose of this project the focus has been on developing the tool s framework and main functionalities rather than concentrating on other probable enhancements 3 Look and Feel Overall the look and feel of SIRAT can be improved Currently the tool has met the standard design specifications 4 Password Encryption All the passwords entered in the portal are stored in the database tables The stored passwords in the database are in plain text format They are not encrypted 3 SIRAT Performance Requirements 3 1 Efficiency Efficiency might have varying meanings in different disciplines Efficiency in general describes the extent to which time or effort is well used for the intended task or purpose It is often used with the specific purpose of relaying the capability of a specific appl
28. Please read this section for further clarification on how to create a batch file on the remote machine 39 The above screen is provided to the user when a batch file is run To check on the status of the batch file click on Get Status button Windows IP Configuration Wireless LAN adapter Wireless Network Connection Connection specific DNS Suffix Tunnel adapter Local Area Connection 10 Connection specific DNS Suffix Status 5 The above screenshot is showing the contents of the log output of RunIPConfig batch file which was executed on the remote machine 7 5 7 Run a Windows Batch File with Incorrect Information To show what happens when incorrect information is given like giving incorrect password or incorrect IP address of the remote box A service is created called RunlPconfig Wrong with IP Address of the remote machine Cassius J m ee om c RemoteA dmin Test run cmd is executed Please click GetStatus button to check the status 40 The above screen is what you see when you run RunlPconfig Wrong In order to see the Status if the batch file ran successfully or not you need to click on Get Status button 110 243 213 93 sharedfolder run log The network path was not found The above message says that the network path is not found That means SIRAT is unable to reach the remote machine SIRAT was unable to get to the remote machine as the IP Address
29. QL the server client executables in the Windows PATH variable so they can be called from the command line MySQL Server Instance Configuration Configure the MySQL Server 5 5 server instance Please set the security options V Modify Security Settings New root password Enter the root password Lroot Confirm Retype the password Create An Anonymous Account This option will create an anonymous account on this server Please note that this can lead to an insecure system res 78 MySQL Server Instance Configuration Configure the MySQL Server 5 5 server instance Ready to execute Prepare configuration C Write configuration file C Start service Apply security settings Please press Execute to start the configuration Note You can avoid the security settings to avoid below Connection Error Even though it fails with below error the windows service is still created and the installation works The security settings could not be applied to the database because the connection has failed with the following error Error Nr 1364 Field authentication string doesn t have a default value If a personal firewall is running on your machine please make sure you have opened the TCP port 3306 for connections Otherwise no client application can connect to the server After you have opened the port please press Retry to apply the security sett
30. X_NAME is the DNS name or the IP address ifthe remote Machine DISCRIPTION is used to describe what the service does USERNAME and PASSWORD is used to store the username and password of the remote machine OS is the operating system of the remote machine REQUEST_TYPE is used to know if the request is to run a windows service or to run a batch file on the remote machine SERVICE_TYPE_NAME if Request_Type is batch it stores the full path of the batch file and if Request_Type is Windows service than it store the name of the Windows service on the remote machine Remote Service This table will store the information when the user inputs the service information data for the first time in the Create Service Page CREATE TABLE myproject remote service id INT AUTO INCREMENT NOT NULL PRIMARY KEY PROJ ID varchar 32 SERVICENAME varchar 128 BOX NAME varchar 30 DISCRIPTION varchar 300 USERNAME varchar 64 USER PASSWORD varchar 64 OS varchar 32 REQUEST TYPE varchar 32 SERVICE TYPE NAME varchar 300 ID and PROJ ID are used internally by the java code to maintain the session SERVICENAME is the name given to the service by the user BOX NAME is the DNS name or the IP address if the remote Machine DISCRIPTION is used to describe what the service does USERNAME and PASSWORD is used to store the username and password of the remote machine OS is the operating system of the remote machine REQUEST TYPE is used to know
31. ability just described is a critical feature of SIRAT 2 5 Additional Functionalities A tool such as SIRAT will be of great benefit if some of the most commonly used administrative tasks are embedded in the tool Within this perspective the following functionalities come to mind Ping a remote Machine Obtain the configuration of a remote machine Gather memory related information of a remote machine Find disk usage of a remote machine Observe the Task Manager of a remote machine Ur dS Ww DER These functionalities will prove useful for troubleshooting For example SIRAT can be used to determine whether the reason behind the failure of a batch file execution is due to lack of sufficient memory storage or lack of disk storage 2 6 Help Material and User Manual As a beginner one should not have to suffer through a lot of guesswork to become familiar with a tool The portal should have simple and concise instructions to make using the tool a layman s job Users should be able to understand the functionalities and navigation through the tool The user manual should cover all aspects about the tool At the same time the material should be short and precise so that less time need be spent on reading and assimilating it Such needed documentation is kept in mind while developing SIRAT 2 7 Limitations and Restrictions This section is written to outline some of the features functionalities of SIRAT that are not covered in this project S
32. any method of controlling a computer from a remote location Remote administration is becoming increasingly common and is often used when it is difficult or impractical to be physically near a system in order to use it or in order to access web material that is not available in one s location Any computer with an Internet connection TCP IP or on a Local Area Network LAN can be remotely administered Remote administration can be used for any cluster of activities and can span multiple categories of servers such as database servers middleware servers etc In general a middleware is an interface that mediates between the application programs and the computing system The application programs are often referred to as users or clients requesting services and the computing system is the entity providing the services In an analogy this is similar to client server systems where the middleware acts as glue or the conduit to provide communication between the clients and the server Middleware is also similar to the middle layer of three tier single system architecture except that it is stretched across multiple systems or applications Some examples of middleware server technologies are JBoss and IBM Websphere With many administrators in the IT world each one may have different needs and daily tasks There may be some tasks that an administrator has to repeat daily on a frequent basis this becomes a time consuming and unproductive activity To quo
33. ation This page summarizes each server that has been configured in the current WebLogic Server domain Q D Customize this table Servers Filtered More Columns Exist Click the Look amp Editbutton in the Change Center to activate all the buttons on this page Delete Showing 1 to 30f3 Previous Next ls AdminServer admin Machine 1 RUNNING OK 7000 ManagedServer 1 Cluster1 Machine1 SHUTDOWN 7001 E 7002 J ManagedServer2 Cluster1 Machine1 SHUTDOWN Showing 1to 30f3 Previous Next The above screen is the Weblogic Administration console where it shows that the two managed servers have been stopped by executing StopAllServersInCluster1 batch file on the remote machine using SIRAT This has stopped the two weblogic managed servers 53 Initializing WebLogic Scripting Tool WLST Welcome to WebLogic Server Administration Scripting Shell Type help for help on available commands The screenshot shown below is the result of running StopAllServersInCluster1 service It stops all the servers in cluster1 i e Server1 and Server2 Initializing WebLogic Scripting Tool WLST Welcome to WebLogic Server Administration Scripting Shell Type help for help on available commands Connecting to t3 localhost 7000 with userid weblogic Successfully connected to Admin Server AdminServer that belongs to domain TestDomain Warning An insecure
34. ation is successful 36 Enter User ID Enter Password Confirm Password First Name Last Name Backto Login 7 5 3 Create Project and Service The following window shows when a project is successfully created Once the project is created a link to the project bearing its name is shown on the left hand side It also shows when a windows service and a windows batch file with correct and wrong information are created respectively the name of the Project is Test and the names of the services are MySQLDev MySQLDev Wrong Run PConfig and RunIPConfig_Wrong Project Name Test M 5 S 2 Type of Name Batch Windows Service Click to Click to Delete E Name of the Service Description of the Service CERES Type Run puto DBA MySQLDev Dev MySQL Server wservice MySQL559 gt Run Delete Delete MiddlewarePRD 1 O Middleware MySQLDev_Wrong Dev MySQL Server wrong info wservice MySQLSS9 y Run Delete O MiddlewareQA RunlPconfig Example to run a batch command whatch c RemoteAdmin Testirun cmd NA Run Delete Test i miosan ores Saapa wbatch C RemoteAdmin Testrun cmd NAM Delete 7 5 4 Run a Windows Service with Correct Information Query Start Stop Clicked on the Windo
35. bit Documents gt Search Y v Help and Support au Microsoft Silverlight 7N Ig HTML Kit Undork compar Oracle JRockit Real Time 3 1 2 for Java SE 6 32 bit G Shut Down Iron FE Works Windows Media Player Google Earth Y Y Windows XP Professional MySQL Server Instance Configuration Configure the MySQL Server 5 5 server instance Please select a configuration type Choose this configuration type to create the optimal server setup for this machine C Standard Configuration Use this only on machines that do not already have a MySQL server installation This will use a general purpose configuration forthe server that can be tuned manually Net Cancel 74 is is a development machine and many other applications will be run on it MySQL Server should only use a minimal amount of memory Several server applications will be running on this machine Choose this option for web application servers MySQL will have medium memory usage C Dedicated MySQL Server Machine This machine is dedicated to run the MySQL Database Server No other servers such as a web or mail server will be run MySQL will utilize up to all available memory Configure the MySQL Server 5 5 server instance Please select the database usage General purpose databases This will optimi
36. blic JRE Do you want to install JRockit as the public JRE For this computer e Yes Install Public JRE O No Don t install Public JRE The Oracle JRockit Installer screen appears and the installation process continues as indicated on the progress meter in the lower right corner of the screen 84 o Oracle JRockit Installer Oracle JRockit JDK R28 1 for Java SE 6 with JRMC 4 0 1 Oracle JRockit Real Time Gain unparalleled performance with industry leading Deterministic Garbage Collector 4 Millisecond response times with Five Nines reliability Improve application performance and latencies with unique tools 4 Integrated zero overhead real time monitoring 4 Quickly understand and fix performance and latency Issues Benefit from the industry s fastest JVM Oracle JRockit JVM ORACLE Installing JRE to C Program Files Jayaljrockit jdk1 6 0_20 R28 1 0 4 0 1ljre When the installation is complete the Installation Complete screen appears Click Done Appendix J Installing the JBoss 5 1 0 GA The JBoss installer can be downloaded from JBoss website or the file placed under C RemoteAdmin Installables JBoss 5 1 0 GA can be used The current version of Jboss Installer will work for Windows XP Vista and 7 It is in zip format and does not have an installation file All you have to do is unzip it where ever you want to In here we will be unzipping in C Remote
37. cause of flexibility of SIRAT it is expected that the tool can be expanded to control the entire production QA and Development environments from a single interface SIRAT can be installed as a standalone tool or can be hosted so that all the departments can use it from a single installation Numerous tests have been performed on SIRAT to test the reliability of SIRAT SIRAT is a very reliable tool Finally the technologies used to build SIRAT are licensed freeware so there is no concern about being charged for license fees 8 2 Problems Encountered and Solved While working on building SIRAT a number of issues and challenges were encountered By the help of advisors and with some research these issues have been resolved Some of the initial challenges are highlighted below e Howto communicate with a remote machine e Are there any free tools that can be used to communicate between two remote machines e f there are tools which can be used for remote commutation then on what ports will they run to avoid any firewall issues e What sort of test bed environment is needed to test SIRAT e What sort of user interface is required for such tools e Whatare the reliability issues that one needs to be concerned for such tools 57 e What sort of data dictionary might be needed and which technology needs to be used as a database e One of the major problems was how to execute a batch file on the remote machine and how to get t
38. ce e Enter login credentials e Click Project List Page e Click on the desired project link e Click on Run link of the Batch file selected which has correct information 33 16 17 18 19 20 21 22 Test case 16 Test Windows Batch File with wrong information Open the Interface Enter login credentials Click Project List Page Click on the desired project link Click on Run link of the Batch file selected which has wrong information Test case 17 Test Ping the Box Open the Interface Enter login credentials Click Reachability Test Page Enter the required information and select Ping the Box Click on submit button Test case 18 Test Ping the Box with wrong information Open the Interface Enter login credentials Click Reachability Test Page Enter the required information with some wrong input and select Ping the Box Click on submit button Test case 19 Test Box Configuration Open the Interface Enter login credentials Click Reachability Test Page Enter the required information and select Box Configuration Click on submit button Test case 20 Test Box Configuration with wrong information Open the Interface Enter login credentials Click Reachability Test Page Enter the required information with some wrong input and select Box Configuration Click on submit button Test case 21 Test Box Memory Usage Open the Interface Enter login credentials Click Reachability Test
39. click the exe files and it should automatically register for you Figure 5 shows all the executable tools of PsTools Suite Eulatxt pdh dll PsExec exe Text Document a 5 0 2195 1600 Execute pro ely EJ 7 KB Windows Performance Data H Sysinternals terna psfile exe PsGetsid exe PsInfo exe psfile Translates SIDs to names and Local and remote system infor Sysinternals Sysinternals www sysinterna Sysinternals www sysinterna pskill exe PsList exe PsLoggedon exe Terminates Sysinternals PsList ho s ogged on Sysinternals www sysinterna Sysinternals ernals www sysinterna psloglist exe psp Description Sysinternals PsList B PsService exe local and remote event log vie Loc Company Sysinternals service information and config Sysinternals v svsinterna 5v4 File Version 1 29 0 0 Sysinternals www sysinterna Date Created 6 9 2011 2 06 PM psshutdown exe pss Size 225 KB Pstools chm Shutdown logoff and power Process suspender Compiled HTML Help File Sysinternals www sysinterna Sysinternals 63 KB Psversion txt Text Document 1 KB Figure 5 PsTools Suite Now the application server is ready to be started In order to run the application server go to C RemoteAdmin jboss 5 1 0 GA bin folder and double click run bat file In order to open the login page of SIRAT type the URL http localhost 8080 Rem
40. d advantage if this feature is implemented There are other ideas that come to mind that are not so major in comparison to the items listed above Some of these are Right now some customization on the remote batch file is needed so that it can output the result to a log file and then be able to find out the status of the batch file by reading the log file There might be another approach to improve upon this procedure There might be other approaches to improve the overall design of the portal 58 Restart of remote machine facility could be implemented This can be of help in situations such as updating installations or resetting boxes With more experience in these kinds of projects there is room for better coding of SIRAT 59 Appendix A Remote Administration Note This section is an amalgamation from various websites referenced in the Reference section Allthe material discussed here will help us better understand the concepts used in building SIRAT Description about Remote Administration Remote administration refers to any method of controlling a computer from a remote location Software that allows remote administration is becoming increasingly common and is often used when it is difficult or impractical to be physically near a system in order to use it or in order to access web material that is not available in one s location for example viewing the BBC iPlayer from outside the United Kingdom A
41. display the SID of a computer or a user e Psinfo list information about a system e PskKill kill processes by name or process ID e PsList list detailed information about processes e PsLoggedOn see who s logged on locally and via resource sharing full source is included e PsLogList dump event log records e PsPasswd changes account passwords e PsService view and control services e PsShutdown shuts down and optionally reboots a computer e PsSuspend suspends processes e PsUptime shows you how long a system has been running since its last reboot PsUptime s functionality has been incorporated into Ps nfo 61 The tools all generally work in the same manner On the host system you launch the desired PsTool Though many can be run locally you ll find that these tools typically provide their utmost utility when run against a remote system or several systems at once Using the command line argument you provide the utility the tool itself copies itself to the remote system s administrative share which is the same as SystemRoot C windows directory on the remote system Once copied into the remote directory the application launches itself and installs a Windows service This Windows service performs the task you requested using the credentials you provided at launch time If an end user UI on the client system is required by the specific tool this service then launches an additional binary in the user
42. e AUTOEXEC BAT is automatically executed so any commands that need to be run to set up the MS DOS environment could be placed in this file Computer users would have the autoexec file set up the system date and time initialize the MS DOS environment load any resident programs or device drivers or initialize network connections and assignments So a remote administrative tool should be able to handle both Windows batch files and Windows Services on the remote boxes For example if you have a MySQL database server running on a remote machine as Windows Service then the administrator through SIRAT should be able to Start or Stop or Query the Windows service remotely In the same way if a Websphere Server can be started and stopped by using a batch file then SIRAT should be able to execute the batch file and should be able to get the status of the commands executed in the batch file 2 2 User Interface Design The goal of user interface design is to make the user s interaction as simple and efficient as possible and accomplish user goals this is often called user centered design Good user interface design facilitates finishing the task at hand without drawing unnecessary attention to it Graphic design may be utilized to support its usability The design process must balance technical functionality and visual elements to create a system that is not only operational but also usable and adaptable to changing user needs To enable restart and thus r
43. e technologies to perform repetitive tasks in an efficient and timely manner As an example a project is created in SIRAT where all the services of Weblogic to be administered are provided The screen shots below show some of the output when the services are run from SIRAT The output shows successful start and stop of a domain The output also shows successful gathering of Weblogic metrics to check on the status ofthe domain StartAdmin and StopAdminServer services in Middleware project are used to start and stop Weblogic Admin Server This is a simple showcase scenario on how to integrate SIRAT with Weblogic Administration Project Name MiddieWare Name of the Service Description of the Service Type of Request Name Batch Windows Service Service Type Click to Run Click to Delete Service lt 5555 StartAckin Start the Weblogic Admin Server whatch C Oracle Admin Scripts RemoteA dminScripts StartA dein cmd NA Rum Delete TUS StastAllServersioChuster Starts all the servers in the Cluster batch C Oracle AdeminScripts RemoteAdminScripts StrtAliServersiuClusterl cmd NA Ram Delete DBA QA StartServer Weblogic Start Server wbatch Oracle AdminScripts Remote Adnan Scripts StartServer cmd NA gt Bun Delete Start erver Start Weblogic Managed Server watch C Oracle AdminScripts RemoteA dminScripts StartServer2 cmd NA gt Run Delete NT Admin StopAdminServer Stop the Weblogic Admin Server wbatch C Oracle AdminScripts RemoteAdminScript
44. efects 7 1 Test Bed Environment In order to test SIRAT a network with specification mentioned in the design chapter is needed As SIRAT uses a third party utility called PSTools Suite the network should comply with the specifications that are necessary by PSTools Suite Two networks have been used for the testing one the office network where work which is very huge and the second network is a small home network with no more than two remote machines connected to a switch Testing has been completed on both the networks The office network is used to show case that the tool can be used in real world situations The home network is used to give demonstrations whenever necessary The two network diagrams are shown below 7 1 1 Simple Home Network Figure 6 below shows the design of a simple network at my home This home network will also be used during the demonstration at the time of defense of this project 28 Netgear Switch 10 MB Ethernet Laptopl Laptop2 Configured with Configured with SIRAT Middleware Servers and other Windows Services notebook pc Figure 6 Simple Home Network for testing SIRAT 29 7 1 2 Office Network The Figure 7 below exhibits the setup in the office network firewall E 3 u Ft E firewall firewall firewall User Desktop where SIRAT is configured Figure 7 Office Network 30 7 2 Items Functions to be Tested The followin
45. ete MySQLDev_Wrong Dev MySQL Server wrong info wservice MySQLS59 Run Delete RunlPconfig Example to run a batch command wbatch c RemoteAdmin Test run cmd N A v Run Delete RunlPConfig Wrong M a cim CiRemoteAdminTestmancmd NAM Rai Delete SERVICE NAME MySQL559 DISPLAY NAME MySQL559 TYPE 10 WIN32 OWN PROCESS STATE 3 STOP PENDING STOPPABLE PAUSABLE ACCEPTS_SHUTDOWN WIN32_EXIT_CODE 0 0x0 SERVICE_EXIT_CODE 0 0x0 CHECKPOINT 0x1 WAIT HINT 86400000 ms Status 2 When executing stop for MySQLDev the State turned to STOP PENDING Query the service again to confirm if the service has stopped or not 38 Project Name Test E 5 5 5 Name of the Service Drinnen Type of Name Batch W indows Service Click to Click to Delete Request Service Type Run Service MySQLDev Dev MySQL Server wservice MySQL559 Star v Run Delete MySQLDev_Wrong Dev MySQL Server wrong info wservice MySQL559 Run Delete RunIPconfig Example to run a batch command wbatch c RemoteAdmin Testirun cmd NIA v Run Delete RunlPConfig Wrong wbatch C RemoteAdmin Test run cmd NIA vj Run Delete SERVICE NAME MySQL559 DISPLAY NAME MySQL559 TYPE 10 WIN32 OWN PROCESS STATE 2 START_PENDING NOT_STOPPABLE NOT_PAUSABLE IGNORES_SHUTDOWN WIN32_EXIT_CODE 0 0x0 SERVICE_EXIT_CODE 0 0x0 CHECKPOINT 0x3 WAIT HINT 15000 ms
46. etter understand the concepts used in building SIRAT As indicated several software packages will be used to build SIRAT This section will give a brief knowledge of those packages listed below 60 e PsTools Suite e JBoss e JRockit e MySQL Appendix C PsTools Suite Note This section is an amalgamation from various websites referenced in the Reference section All the material discussed here will help us better understand the concepts used in building SIRAT PsTools Suite is the most important set of tools that will be used to build SIRAT These tools are used to communicate between the Remote Machines PsTools Suite is developed by Sysinternals This software is a freeware but it cannot be distributed to others Consequently if SIRAT is given to some vendor or a client it is necessary to make sure this software is not bundled with SIRAT PSTools Suite should be downloaded and installed separately at the location where SIRAT is installed The first tool in the suite was PsList a tool that lets you view detailed information about processes and the suite is continually growing The Ps prefix in PsList relates to the Ps command in UNIX that provides a list of processes belonging to users PsTools Suite is a bundle of set of tools used for similar kind of tasks This list of tools bundled in PsTools Suite is mentioned below e PsExec execute processes remotely e PsFile shows files opened remotely e PsGetSid
47. euse of the same services the interface should be able to collect and store the data in a database Furthermore a secure authentication system is needed to limit access to the trusted few personnel only SIRAT attempts to achieve these demands 2 3 Integration with other Technologies The design and development of SIRAT involves its integration with several technologies One such technology is Oracle Weblogic It will be demonstrated how SIRAT can be used in administrating Weblogic In a real multinational IT firm there are several Weblogic Domains to control In each domain one might have several servers where the applications are deployed It is assumed that the reader is familiar with rudimentary Weblogic administration Some batch scripts need to be customized to observe the status of the script s output This customization and other details will be explained in the design section 2 4 Error Conditions and System Messages Every tool or system developed should be in a position to handle exceptions Not only these tools need to handle exceptions but also a good user friendly tool should give a proper explanation of the error on the interface It is essential for the administrator to be aware of the status of the task executed i e whether the task executed successfully or failed This monitoring capability is of extreme importance as in real world situations such tools will be used in production environments The error handling cap
48. find the IP Address of the remote machine call C Windows system32 ipconfig exe gt C SharedFolder IPAddress log exit IPAddress cmd This is the wrapper script that we need to create to call the main batch file Myfile bat in minimized mode ECHO OFF REM Name of the file IPAddess cmd REM This script is used to find the IP Address of the remote machine start min lt fullpath gt Myfile bat exit This completes the installation and configuration of SIRAT Now the next chapter describes about the user interface of SIRAT 6 SIRAT User Interface Overview This section will discuss SIRAT s user interface and will use screenshots and an explanation of the various functionalities When SIRAT starts the portal shows six buttons at the top for most activities Home Projects Created Create Service Reachability Test About and Logout When a user clicks on Home it will take the user to the Home Page Home page contains some description about the tool and the user interface The second button is Projects Created when one clicks on it it will take one to the page where list of projects created in SIRAT is displayed In the same page there is an option to create new projects The third button is Create Service when a 22 user clicks on it it takes the user to the page where he needs to key in all necessary information to create a service The Fourth Button is Reachability Test When a user selects this butto
49. for the rest of the document You can download the installation file from the website or you can use the file kept in C RemoteAdmin Installables MySQL 5 5 9 folder The MySQL install file has msi extention MSI is similar to EXE extention Installing the msi file is simple Double click the file and go through the screens During installation the name of the windows service is provided It can be what ever you want In SIRAT case the name is given as MySQL Once installation is complete now it is required to start the configuration wizard and configure the database 73 Start the configuration wizard by going into program files through start button Lotus applications x M c Microsoft Office ES Adobe Reader 9 IM Broadcom gt Set Program Access and Defaults I Intel PROSet Wireless v Windows Catalog IM Check Point VPN 1 SecureClient gt Cisco Systems VPN Client gt Windows Update Intervideo WinDVD gt New Office Document e Internet Explorer Q Outlook Express es Open Office Document Aw Remote Assistance ur I SourceGear DiffMerge id Google Chrome WinRAR IM Apache HTTP Server 2 2 I ieHTTPHeaders IBM WebSphere Settings gt Filezilla FTP Client IM Microsoft Office Live Meeting 2007 Oracle JRockit Mission Control 3 1 2 for Java SE 6 32 bit Oracle JRockit JDK R28 1 for Java SE 6 with JRMC 4 0 1 32
50. g is a complete list of items and functionalities to be tested on SIRAT Registration Process Create a testuser ID Login Logout to the Tool Create Project Create a Windows Service to a particular Project Create a Batch Service to a particular Project Test the Windows Service created to a particular Project Test the Batch Service created to a particular Project Test Ping the Remote Machine functionality Test Box Configuration of the Remote Machine functionality 10 Test Box Memory Usage of the Remote Machine functionality 11 Test Box Disk Usage of the Remote Machine functionality 12 Test Task Manager of the Remote Machine functionality 13 Test Weblogic Integration with SIRAT DO E YU SS 7 3 Description of Test Cases A test case in software engineering is a set of conditions or variables under which a tester will determine whether an application or software system is working correctly or not It may take many test cases to determine that a software program or system is considered sufficiently scrutinized to be released In order to fully test that all the requirements of an application are met there must be at least two test cases for each requirement one positive test and one negative test The test cases prepared for testing the items 1 13 listed in section 7 2 are 1 Test Case 1 Test Registration e Openthe Interface e Click of Register Button e Fillin the required data e Click Register Button e Click Bac
51. gible 900 800 700 600 500 CPU 400 Memory 300 200 100 0 Ti T2 T3 T4 T5 Figure 9 MySQL Server resource utilization chart In Figure 9 T1 are specific time intervals Memory is in bytes For a similar reason to find the memory usage 12000 bytes need to be added to the memory values The 56 CPU percentage is the value of mysgl exe process at that particular event If average CPU is considered than again it is negligible 8 Conclusions 8 1 Summary The overall effect of SIRAT is to reduce cost and increase productivity One important benefit of SIRAT is to make daily real world IT administrative activities easier It has been shown that SIRAT is capable of executing activities on remote boxes from a single machine In real world IT there are usually a large number of administrative activities such as Middleware Administration System Administration Network Administration etc For each of these responsibilities there are normally some daily repetitive activities Therefore SIRAT can be of great practical use Once the setup of the commands is done anyone with little technical experience ought to be able to use the tool thus enabling people with limited technical skills to use SIRAT efficiently The tool can also be used for monitoring metrics of technologies such as Weblogic Application Server This is a great advantage showing that SIRAT can be integrated with various technologies Be
52. he status once the batch file is executed e Howto get the authentication system working 8 3 Suggestions for Future Extensions to Project The scope for this tool is very vast This tool is mainly developed with a mind set to help Middleware Administrators Most of the administrative capabilities are placed in SIRAT But when suggestions are taken from other administrators like network or system administrators then it is realized that there is a very high potential for improvement for this tool Some of the major topics that SIRAT can be improved upon in the future are Authentication SIRAT does not have a proper authentication method in place Currently it allows anyone to register and use the tool So an approval process to register and create an account is needed Authorization is not enabled in SIRAT Currently the project owners can see each other s projects and can also execute the services of other projects This will be a problem if the tool is in hosted mode Operating systems To enhance SIRAT to work for any operating system Right now it is implemented only for Windows With more operating systems there will be more issues dealing with the reachability test page as well Password Encryption Currently the passwords that are stored in the database are not encrypted So this can be improved in future Task scheduling Currently SIRAT does not have the functionality to execute a service at a scheduled time It will be an adde
53. ials Click Project List Page Click on the desired project link Select Query on Service Type which has correct information 32 e Click on Run link 10 Test case 10 Test Start Windows Service e Openthe Interface e Enter login credentials e Click Project List Page e Click on the desired project link e Select Start on Service Type which has correct information e Click on Run link 11 Test case 11 Test Stop Windows Service e Openthe Interface e Enter login credentials e Click Project List Page e Click on the desired project link e Select Stop on Service Type which has correct information e Click on Run link 12 Test case 12 Test Query Windows Service with wrong information e Openthe Interface e Enter login credentials e Click Project List Page e Click on the desired project link e Select Query on Service Type which has wrong information e Click on Run link 13 Test case 13 Test Start Windows Service with wrong information e Openthe Interface e Enter login credentials e Click Project List Page e Click on the desired project link e Select Start on Service Type which has wrong information e Click on Run link 14 Test case 14 Test Stop Windows Service with wrong information e Openthe Interface e Enter login credentials e Click Project List Page e Click on the desired project link e Select Stop on Service Type which has wrong information e Click on Run link 15 Test case 15 Test Windows Batch File e Openthe Interfa
54. ication of effort to produce a specific outcome effectively with a minimum amount or quantity of waste expense or unnecessary effort Proper care should be taken while building a tool to have its efficiency at an acceptable level When it comes to SIRAT the efficiency is measured with respect to the end user How the end user can do his daily administrative tasks with and without SIRAT We expect that the administrator s efficiency will be improved when he or she uses SIRAT 3 2 Description of Reliability Measures Proper care has been taken while building SIRAT for reliability When a Windows service is started on a remote machine SIRAT has an option to query the status of the service For example when a command is executed to start a Windows Service on a remote machine SIRAT has the option to run a query command to find out the status of the service executed In this manner it can be determined whether the service executed successfully For a Windows Batch File the result of the batch file can be routed to a log file so that the status of each command in the batch file can be checked by reading the log file 3 3 Error Failure Detection SIRAT has a good capability of handling errors and failures It is assumed that the errors and failures are not from the software s used to build this tool If there is any failure while using SIRAT the error log is output in the portal with the self explanatory error messages or exception mes
55. ile running a service 5 SIRAT Installation and Configuration Overview 5 1 Software Packages used in building SIRAT SIRAT is built using software packages with freeware license As indicated the communication among remote machines is done by PsTools suite The web portal is developed on Eclipse and deployed on JBoss version 5 1 0 GA The database is created and managed on MySQL 5 5 9 The list of software packages utilized to build SIRAT is given below MySQL 5 5 9 JRockit 1 6 0 20 JBoss 5 1 0 GA PsTools Suite gt Allthese technologies are well discussed in the appendix section SIRAT can be installed on a user desktop laptop or on a server A firm can decide to deploy SIRAT on a server and host the URL to all its users thereby enabling the administrator of the firm to see all the several services on a single portal This scenario is well suited for small firms with limited number of services and with few people handling most of the administrative activities Hosting is not recommended at this point as 15 authorization and session handling is not enabled in this version of SIRAT SIRAT deployment does not require highly configured laptops or servers It uses minimum resources so it can be deployed on any machines with minimal configuration 5 2 Installations The detailed installations of the packages are described in the appendix section So in Section 5 3 it is assumed that the installations of these package
56. ings If you are re installing after you just uninstalled the MySQL server please note that the data directory was not removed automatically Therefore the old password from your last installation is still needed to connect to the server In this case please select skip now and re run the Configuration Wizard from the start menu 79 Maal Server Instance Coen SAL MySQL Server Instance Configuration Configure the MySQL Server 5 5 server instance Processing configuration Vj Prepare configuration Vj Write configuration file C RemoteAdmin MySQL5 5 9 my ini Vj Start service X Apply security settings The security settings could not be applied Error Number 1364 Field authentication string doesn t have a default value lt Back execute Camel Please note as specified in the note even though it failed at security settings the installation works fine and you can close the screen to complete the process Note Microsoft Windows XP and later include a firewall which specifically blocks ports If you plan on using MySQL through a network port then you should open and create an exception for this port before performing the installation To check and if necessary add an exception to the firewall settings First ensure that you are logged in as an Administrator or a user with Administrator privileges e Go to the Control Panel and double click the Windows Firewall icon e
57. k to Login 2 Test Case 2 Test Login e Openthe Interface e Enter User ID e Enter correct password e Click Login Button 3 Test Case 3 Test with false login credentials 3l Open the Interface Enter User ID Enter incorrect password Click Login Button Test Case 4 Test Create Project Open the Interface Enter login credentials Click Create Project Page Enter new project name and description Click Add Project button Test Case 5 Test Create Windows Service for a project Open the Interface Enter login credentials Click Create Service Page Enter the necessary information for Windows Service Click Submit button Test Case 6 Test Create Windows Batch for a project Open the Interface Enter login credentials Click Create Service Page Enter the necessary information for Windows Batch File Click Submit button Test Case 7 Test Create Windows Service for a project with false information Open the Interface Enter login credentials Click Create Service Page Enter the necessary information for Windows Service with some wrong information Click Submit button Test Case 8 Test Create Windows Batch for a project with false information Open the Interface Enter login credentials Click Create Service Page Enter the necessary information for Windows Batch File with some wrong information Click Submit button Test case 9 Test Query Windows Service Open the Interface Enter login credent
58. l remote and disparately located boxes In a rich IT firm there will be several servers located in different data centres often spanning multiple geographic locations Connecting to each of these disparate boxes individually and performing similar type of administrative activities repetitively is very time consuming and reduces a person and thereby a firm s productivity significantly A utility such as a single interface to connect to all the middleware servers remotely and do most of the common admin or daily routine tasks through one common screen would provide immense value to any IT firm with multiple servers There are mainly five Tabs at the top of every page in this Portal When you click on Home it will always bring you to the current page you are in right now The second button that is Projects Created when you click on it it will take you to the page where it will show you all the list of the Projects created The third button is Create Project when you click on it it will take you to the Page where you are asked all the information to create your soft link The Fourth Button you can see is Reachability Test When you click on it it will take you to the page where you need to enter information to know if you can reach to the remote box or not This test has to be done before you create any projects Also in times of network issues this page will give confirmed results about the reachability of the Remote Box The final and the fifth but
59. lass gt lt user name gt root lt user name gt lt password gt MyProject lt password gt lt min pool size gt 5 lt min pool size gt lt max pool size gt 20 lt max pool size gt lt idle timeout minutes gt 30 lt idle timeout minutes gt lt local tx datasource gt lt datasources gt 3 Create a folder called RemoteAdmin war in C RemoteAdmin jboss 5 1 0 GA server default deploy folder The name of the folder can be anything you want but it should always have the extension war Now unzip the contents from the RemoteAdmin war in this folder Please see the screenshot below with the contents in the folder Note deploy folder is the place where you keep all the applications needed to be deployed on the JBoss server Figure 4 shows all the folders in the application folder RemoteAdmin war which is placed under deploy folder of JBoss 19 JavaScript CJ jsp CJ META INF CZ background page jpg pstools WEB INF 1000 x 800 JPG File dbScript index html psexec exe File HTML Document Execute processes remotely 1 KB 1 KB Sysinternals www sysinterna Figure 4 RemoteAdmin war Folder in the Deploy Folder of JBoss 4 Now in the descriptor file we need to state the place where the PSTools Suite is placed Go to C RemoteAdmin jboss 5 1 0 GA server default deploy RemoteAdmin war WEB INF folder and open the web xml descriptor In the file you need to update as shown in below figure
60. n Get Status button aT i o Google 2 Search More 2Signin Convert Sele iq Favorites gp f eBay B Sony Reader Library B SonyStyle Upgrade Your Browser T Suggested Sites lt Header fe E 2 am Pages Satety Tos Qe Project Name Middle Ware Name of the Service Description of the Service at Name Batch Windows Service Service Type Click to Run StartAdmin Start the Weblogic Admin Server wbatch Oracle AdminScripts RemoteAdminScips Start dmincmd NA StopAdminServer Stop the Weblogic Admin Server wbatch C Oracle AdminScripts RemoteAdminScripts StopAdnin cmd N A Get Stans Command execuated Please click GetStatus button to check the status Done Internet Protected Mode On gt 100 SIRAT will read the log output of the batch file executed on the remote machine and states that it has started the Weblogic Admin Server successfully 48 Initializing WebLogic Scripting Tool WLST Welcome to WebLogic Server Administration Scripting Shell Type help for help on available commands Exiting WebLogic Scripting Tool c c wa Similarly the next three screens shots show how to stop the Weblogic Admin Server followed by the status of the execution that can be checked By clicking on Run SIRAT will stop the Weblogic Admin Server ER e X IM oeste pe x Google 2BSearch More
61. n and 64 bit Xeon Itanium and SPARC architectures at significantly lower costs to the enterprise Furthermore it is the only enterprise class JVM optimized for Intel architectures 66 providing seamless inter operability across running Oracle Weblogic Server Java Code JRockit JVM Figure 10 JRockit JVM as a Black Box multiple hardware and operating configurations The JRockit JVM makes it possible to gain optimal performance for your Java applications when running it on either the Windows or Linux operating platforms on either 32 bit or 64 bit architectures The JRockit JVM is especially well suited for 110001110 67 Java Code Transformations 110001110 Figure 11 Java Code Compilations How the JRockit JVM Compiles Code The code generator in the JRockit JVM runs in the background during the entire run of your Java application automatically adapting the code to run its best The code generator works in three steps as described below Java application 1 JRockit runs JIT 2 JRockit monitors 3 JRockit runs compilation threads optimization Highly optimized machine code Figure 12 How the JRockit JVM Optimizes Code for Your Java Application JRockit runs optimization 68 Appendix F MySQL Database Note This section is an amalgamation from various websites referenced in the Reference section Allthe material discussed here will help us better understand the c
62. n it will take the user to the page where he can enter information to figure out if the remote box is reachable or get some pertinent information about the performance and health of the remote box This test can be carried out whenever there are some problems with the remote machine or network Also during network issues this page will give confirmed results about the reachability of the Remote Box The About button give some information about the tool and provides the user with documentation The Logout button is self explanatory 6 1 Login Page The screenshot below shows the login page of SIRAT If the user doesn t have the login credentials there is a button called Register allowing the user to register and get the login credentials Home Windows Internet Explorer E x 8 7 httpiy localhost 8080 RemoteAdmin jsp 4x a Elle Edit View Favorites Tools Help Links gt RR 2 Hone i gt Bl d eae E Tos Web Portal For Remote Administration Sign in to RemoteAdmin rajeshratnala Welcome to Remote Admin Web Portal Page This utility will enable remote administration of Servers on several remote and disparately located boxes In a rich IT firm there will be several servers located in different data centres often spanning multiple geographic locations Connecting to each of these disparate boxes individually and performing similar type of administrative activities repetitively i
63. nected to Admin Server AdminServer that belongs to domain TestDomain Warming An insecure protocol was used to connect to the server To ensure on the wire security the SSL port or Admin port should be used instead Exiting WebLogic Scripting Tool 51 Initializing WebLogic Scripting Tool WLST Welcome to WebLogic Server Administration Scripting Shell Type help for help on available commands Connecting to t3 localhost 7000 with userid weblogic Successfully connected to Admin Server AdminServer that belongs to domain TestDomain Warning An insecure protocol was used to connect to the server To ensure on the wire security the SSL port or Admin port should be used instead Server with name ManagedServer2 started successfully Disconnected from weblogic server AdminServer Exiting WebLogic Scripting Tool Administration Console ee lt Home Log Out Preferences 4 Record Help lt Welcome weblogic Connected to Te Home gt Summary of Servers Summary of Servers Configuration Control A server is an instance of WebLogic Server that runs in its own Java Virtual Machine JVM and has its own configuration This page summarizes each server that has been configured in the current WebLogic Server domain Q gt Customize this table Servers Filtered More Columns Exist Click the Lock amp Editbutton in the Change Center to activate all the buttons on this page Showing
64. o interoperate with server applications Enterprise Java Bean EJB components resource pooling and connection sharing that make applications very scalable An administration console with a user interface makes management tasks more efficient and features such as Secure Sockets Layer SSL support for the encryption of data transmissions as well as authentication and authorization mechanisms make applications and transactions secure The diagram below will give a high level understanding about the Weblogic domain structure In a domain you have Admin Server and Managed Servers as main 70 components There will be several other components which will be on the managed servers The Admin Servers is mainly responsible for the control of these components Like start stop and other administrative work In this project we will try to integrate our tool to the administration of Weblogic Domain WebLogic Server Domain Administration Console Command Line Interface JMX API SNMP N inu ES Cluster En Semer2 Database Server Load Balancer Firewall Figure 13 The Weblogic Server life cycle is shown in diagram below 71 Shutdown Shutting Down cia Running lt Unknown 5 Figure 14 Weblogic Server life cycle 72 Appendix H MySQL 5 5 9 Installation To run MySQL on Windows the following is needed A Wind
65. oncepts used in building SIRAT This project uses MySQL as the backend database This tool does not use the database intensively but used to store the information of Remote Machines like names of the machines username s and passwords etc MySQL is the world s most popular open source database software with over 100 million copies of its software downloaded or distributed throughout its history With its superior speed reliability and ease of use MySQL has become the preferred choice for Web Web 2 0 SaaS ISV Telecom companies and forward thinking corporate IT Managers because it eliminates the major problems associated with downtime maintenance and administration for modern online applications Many of the world s largest and fastest growing organizations use MySQL to save time and money powering their high volume Web sites critical business systems and packaged software including industry leaders such as Yahoo Alcatel Lucent Google Nokia YouTube Wikipedia and Booking com The flagship MySQL offering is MySQL Enterprise a comprehensive set of production tested software proactive monitoring tools and premium support services available in an affordable annual subscription MySQL is a key part of LAMP Linux Apache MySQL PHP Perl Python the fast growing open source enterprise software stack More and more companies are using LAMP as an alternative to expensive proprietary software stacks because of its lower cost and
66. or example reachability test can be used to check on the remote machine in case something goes wrong in the middle of executing some services This also has the advantage to check on the remote machine without directly login into the remote box 26 The basic functionalities that are attached to the Reachabilty Page are Ping the Box Box Configuration Box Memory Usage Box Disk Usage Box Task Manager Web Portal For Remote Administration Reachability Test About Select what you want DO Windows v Ping the Box Nc ann C08 O 6 7 About and Log Out Pages The About page will have a document attached which will have the complete details about SIRAT This project report will be attached to the About link The Log Out button is self explanatory clicking on the Log Out button will log you out of SIRAT and take you to the Login Page 27 7 SIRAT Verification Software testing is an investigation conducted to provide stakeholders with information about the quality of the product or service under test Software testing can also provide an objective independent view of the software to allow the business to appreciate and understand the risks of software implementation Test techniques include but are not limited to the process of executing a program or application with the intent of finding software bugs errors or other d
67. oteAdmin jsp Note The bin folder is the place where all the configuration files of JBoss application server can be seen 5 3 3 Windows Batch File Customization In order to run a Windows Batch file on a remote machine some customization has to be done on the file The steps below show how that is to be done 1 Create a wrapper batch file to the main batch file which should always end with cmd extension 2 The wrapper script should be in the below format start min C lt fullpath gt myfile bat Note where myfile bat is the actual batch file we need to start on the remote machine The option min minimized will start the wrapper batch file in minimized mode 21 3 On all the remote machines where SIRAT is used create a shared folder in C drive named SharedFolder This folder should be shared to all the users who have administrator s rights on the remote machine and with the User ID used to login to the laptop desktop where the SIRAT is installed This folder is used to output the batch file logs 4 The output statements should be logged in the main batch file That is it should be in myfile bat file 5 The output file should always have the same name as the actual file In this case it should be myfile log 5 3 3 1 Example Batch files Myfile bat This file is used to find the IP Address of the remote machine ECHO OFF REM Name of the file Myfile bat REM This script is used to
68. otherwise do not have the ability to show information about remote systems Here is a simplified usage for PsExec 62 PsExec computer u username p password command PsExec switches Switch a se n priority X file Psinfo Description Specifies processor affinity Indicates whether the application should be copied to the remote system Specifies not to wait for the process to finish before exiting it won t wait for a success or failure message Loads using the specified account s profile Copies the application even if it exists on the remote system Ensures that you are running the current or a specific version Runs the application interactively on the remote system required if you want an end user to see any user interface from the application Runs the application as a limited user Removes the Administrators group token and strips process privileges to the level they would be for a member of the Users group Handy to run high risk Internet facing applications with minimal privileges Specifies the timeout to wait before failing to connect to remote computers Runs the process at the specified priority That is specifies how Windows should set the process priority for a given task low below normal above normal high or realtime Runs the process using the System account handy to run Regedit to access privileged registry keys Copies the application only if the one
69. ows operating system such as Windows 2000 Windows XP Windows Vista Windows 7 Windows Server 2003 or Windows Server 2008 Both 32 bit and 64 bit versions are supported Generally MySQL is installed using an account that has administrator rights Otherwise some problems might be encountered such as editing the PATH environment variable or accessing the Service Control Manager Once installed MySQL does not need to be executed using a user with Administrator privileges MySQL for Windows is available in several distribution formats Binary distributions are available that contain a setup program that installs everything needed to start the server immediately Another binary distribution format contains an archive that can be unpacked in the installation location and then configured After installing MySQL Server it is recommended to disable virus scanning on the main directory datadir being used to store the MySQL table data There is usually a system built into the virus scanning software to enable certain directories to be specifically ignored during virus scanning Another alternative is the MSI package designed to install and configure MySQL quickly The MySQL Installation Wizard and MySQL Configuration Wizard are available in the complete install package of MySQL 5 5 9 Note All the installable files are placed in C RemoteAdmin Installables of SIRAT or it can be downloaded from the corresponding websites Please keep this in mind
70. oyed the same as other deployable components The descriptor must be named using a ds xml pattern in order to be recognized by the XSLSubDeployer The schema for the datasource descriptor is docs dtd jboss ds 1 O dtd Place the JDBC driver classes in the lib directory of your server server default lib for example Jars placed in the lib directory are NOT hot deployable so you will need to restart JBoss if it is already running Copy the most appropriate sample datasource file into your deploy directory You can change the name if you like but the file must end with ds xml to be recognized as a datasource descriptor Edit the datasource definition to match your database connection parameters The most relevant parameters are Jndi name The JNDI name under which the Datasource wrapper will be bound Note that this name is relative to the java prefix The full JNDI name of the DataSource will 87 be java jndi name DataSource wrappers are bound under the java prefix since they are not usable outside of the server VM Connection url The JDBC driver connection URL string for your driver Make sure that the database name host and port are correct for the database you are trying to connect to Username This element specifies the default username used when creating a new connection The actual username may be overridden by the application code getConnection parameters or the connection creation context JAAS Subject
71. p X comet sele jg Favorites B eBay B Sony Reader Library E SonyStyle Upgrade Your Browser gt E Suggested Sites Page Safety Toosv Qv Header 169 254 250 153 y iw ere carte at Password can t be blank mcm Internet Protected Mode On x Googie 2B Search More Signin A Convert Esee ip Favorites gp f eBay 3 Sony Reader Library E SonyStyle 4 Upgrade Your Browser Suggested Sites Header Page Safety Too dr 169254 250153 RajPCAdmin internet Protected Mode On v 10 gt 43 Output ofthe Remote Machine Configuration ovg T iB Search More Sigan A x convert Esel 33 Favorites jp eBay Sony Reader Library f SonyStyle f Upgrade Your Browser Suggested Sites Header th am Pager satety Tons e C Windows User Name System information for 169 254 250 153 Uptime 0 days 0 hours 49 minutes 3 seconds Kemel version Windows Vista TM Home Premium Multiprocessor Free System root C5 Windows Processors 2 Processor speed 1 8 GHz Processor type InteR Core TM 2 Duo CPU T5550 Physical memory 3062 MB Video driver Mob e Intel R 965 Express Chipset Fami Dane Internet Protected Mode On gt K100 gt r X M Google x Googe Search More Signin A Convert Sele 3 Favorites gap eBay Sony Reader Library 3 SonyStyle
72. passing the option c config name to the run script conf configuration files including the bootstrap services in jboss service xml lib static jar files for the services deploy services and applications that are hot deployed 86 data data files that survive reboot tmp temporary files that do not survive reboot work work files for Tomcat default the default configuration does not include clustering or corba JVM and Memory Settings Executing run conf in the bin directory controls the configuration of JBoss application server Little change is needed in run conf In the file change JAVA HOME C VoptVdk1 6 0 13 to JAVA HOME C jrockit jdk1 6 0_20 R28 1 0 4 0 1 The minimum and maximum memory is set to 128MB and 512MB respectively Creating a JDBC Datasource Note Datasource is a name given to the connection set up to a database from a server The name is commonly used when creating a query to the database The syntax for configuring JCA JDBC connection factories has been simplified in 3 2 Rather than configuring the connection manager factory related MBeans via an mbean services deployment descriptor an abbreviated datasource centric descriptor is used This is transformed into the standard jboss service xml mbean services deployment descriptor using a XSL transform applied by the org jboss deployment XSLSubDeployer included in the jboss jca sar deployment The simplified configuration descriptor is depl
73. pports Java JBoss Application Server was developed by JBoss now a division of Red Hat Product Features Aspect Oriented Programming AOP support Clustering Deployment API Distributed caching using JBoss Cache a standalone product Distributed deployment farming Enterprise Java Beans versions 3 and 2 1 Failover including sessions Hibernate integration for persistence programming JPA JAAS Java Authentication and Authorization Service JCA Java Connector Architecture integration Java Management Extensions JMS Java Message Service integration JNDI Java Naming and Directory Interface JTA Java Transaction API JACC Java Authorization Contract for Containers integration JavaMail JavaServer Faces 1 2 Mojarra 65 JSP Servlet 2 1 2 5 Tomcat JBossWS JBoss Web Services for Java EE Web Services like JAX WS JDBC Load balancing Management API OSGi framework RMI IIOP JacORB contraction of Java and CORBA SAAJ SOAP with Attachments API for Java Teiid data virtualization system 4 5 2 2 Licensing and Pricing JBoss itself is open source but Red Hat charges to provide a support subscription for JBoss Enterprise Middleware Before November 2010 JBoss was licensed as annual subscription in bundles of 4 and 32 CPU sockets As of November 2010 the licensing changed and all cores on the system are now counted The new core bundles licensing is now available for 16 and 64 cores The JBoss Enter
74. prise Application Platform EAP with management option 16 core bundle premium support costs 11 250 per year Complete JBoss pricing is available Appendix E JRockit JVM Note This section is an amalgamation from various websites referenced in the Reference section All the material discussed here will help us better understand the concepts used in building SIRAT In this project we have deiced to use JRockit as JVM for the JBoss application server This will be a separate installation and will need to be configured in JBoss JRockit a proprietary Java Virtual Machine JVM originally developed by Appeal Virtual Machines and acquired by BEA Systems in 2002 became part of Oracle Fusion Middleware in 2008 The JRockit code base and the HotSpot virtual machine from Sun Microsystems now Oracle are currently being integrated with the target of releasing a JVM with a combined code base around the release date of JDK 8 JRockit was made free and publicly available in May 2011 Many JRE class files distributed with JRockit exactly replicate those distributed by Sun JRockit overrides class files which relate closely to the JVM therefore retaining API compatibility while enhancing the performance of the JVM The JRockit JVM is a high performance JVM developed to ensure reliability scalability manageability and flexibility for Java applications The JRockit JVM delivers a new level of performance for Java applications deployed on Intel 32 bit Xeo
75. rameter can specify a user computer or group Additional parameters are shown below PsList Switches Switch Description t Shows information at the thread level m Provides detailed memory information for each process X Shows process memory and thread information t Shows information as a process tree think Process Explorer tree view s n Runs in task manager mode for the specified number of seconds This allows for a relatively real time display of remote process information 64 r n Specifies how frequently in seconds to refresh when running in task manager mode Name Shows information about processes that begin with the name specified e Matches the process name exactly Pid Displays information about a specific process Appendix D JBoss Application Server Note This section is an amalgamation from various websites referenced in the Reference section All the material discussed here will help us better understand the concepts used in building SIRAT SIRAT is built on J2EE technology JBoss will be used to host the SIRAT code JBoss Application Server is a free software open source Java EE based application server An important distinction for this class of software is that it not only implements a server that runs on Java but it actually implements the Java EE part of Java Because it is Java based the JBoss application server operates cross platform usable on any operating system that su
76. remote location may refer to a computer in the next room or one on the other side of the world It may also refer to both legal and illegal i e hacking remote administration Any computer with an Internet connection TCP IP or on a Local Area Network can be remotely administered For non malicious administration the user must install or enable server software on the host system in order to be viewed Then the user client can access the host system from another computer using the installed software Usually both systems should be connected to the internet and the IP address of the host server system must be known Remote administration is therefore less practical if the host uses a dial up modem which is not constantly online and often has a Dynamic IP Remote administration has developed and evolved over recent years and is no longer simply about controlling a device over a network being it local or wide area When looking to source a remote administration software solution there are a number of more modern features that really make the difference These features allow you as an administrator to save time reduce energy costs and even track IT assets by automating tasks and administrating any of your IT resources at any time from any place Appendix B Required Support Software to build SIRAT Note This section is an amalgamation from various websites referenced in the Reference section All the material discussed here will help us b
77. rver Run the appropriate services to test the utility 35 7 4 Test Results This section will discuss the results of the Test Cases performed It will elaborate on all the important aspects of the results obtained It will showcase the results in screenshots taken while running the test cases As indicated Test Cases are formed to test both positive and negative aspects of SIRAT This means that you pass the correct information and also wrong information and test the tool to check for the output This is done to check the reliability of the tool 7 5 1 Login and Log out functionality Testing this functionality Login Logout was successful when providing the correct credentials Furthermore SIRAT did not allow the user to login when either username or password was not correct with an alerting message shown below Login failed Please try again 7 5 2 Registration During registration no field can be blank The following shows what happens if a field is left blank Specifically the user is alerted with a dialog box Enter User ID Enter Password Confirm Password First Name Last Name Windows Internet Explorer E Confirm Password can t be blank Register Backto Login First NAme can t be blank y Pr Last Name can t be blank Password doest not match v B SIRAT provides the user with the following window when registr
78. s StopAdmin cmd NA v Run Delete Test StopAlServersinChister Stop all Servers in Cluster wbatch C Oracle AdeinScripts RemoteA deninScripts StopAUServersinChusterl emd N A Rum Delete StopServer Weblogic Stop Server wbatch C Oracle AdminScripts RemoteAdminScripts StopServer cmd NA gt Run Delete StopServer Stop Weblogic Managed Server wbatch C Oracle AdminScripts Remote Admin Scripts StopServer2 cmd NA gt Run Delete Delele Project In the screenshot above when we click on Run to start the service StartAdmin SIRAT will ask you for confirmation as shown in below screenshot Once confirmed SIRAT will execute the remote batch file which starts the Weblogic Admin server on the remote machine 47 lt http nocalnost 2680 RemoteAdmin jsp ProjectTree jsp B x 28 coogie x Google T 2 Search More Sign A X convert B Sele Je Favorites gap fB eBay 3 Sony Reader Library 3 SonyStyle Upgrade Your Browser Suggested Sites lt Header gt 3 Pager Safeyv Toos Qv Project Name Middle Ware Name of the Service Description of the Service Type of Request Name Batch Windows Service Service Type Click to Run Click to Delete Service Start min Stat e Weblogic Admin Server wbah C Oracle AdminScripts RemoteAdmiSciptsStatAdma cmd NA Delet cmd NIA v Delete To check the status of execution click o
79. s are complete 5 3 Configuration 5 3 1 Configure MySQL 5 5 9 Before using SIRAT the database needs to be configured in the following manner 1 Start the MySQL windows service This will start the MySQL Database 2 Connect to the database by mysql u user p Here the user is root and password is MyProject 3 Create a database called myproject Create the database by using the command CREATE DATABASE myproject As MySQL can contain multiple databases to use the myproject database after creating the database the following command must be followed USE myproject Now you can start using the database myproject 4 Create the tables for myproject required for SIRAT SIRAT mainly requires four tables The Data Dictionary on creating the four tables are given below 5 3 1 1 Table Creation e Remote Project Admin This table is used to store the information which is required while executing a service Most of the attributes used here are self explanatory CREATE TABLE myproject remote project admin id INT AUTO INCREMENT NOT NULL PRIMARY KEY PROJ ID varchar 30 SERVICENAME varchar 30 BOX NAME varchar 30 DISCRIPTION varchar 100 USERNAME varchar 30 USER PASSWORD varchar 30 OS varchar 30 REQUEST TYPE varchar 30 16 SERVICE_TYPE_NAME varchar 30 ID and PROJ_ID are used internally by the java code to maintain the session SERVICENAME is the name given to the service by the user BO
80. s very time consuming and reduces a person and thereby a firm s productivity significantly A utility such as a single interface to connect to all the servers remotely and do most of the common admin or daily routine tasks through one common screen would provide immense value to any IT firm with multiple servers In order to access the utility you need to have a username and password Please register to create your usemame and password Along with userID you also need to provide your Last and Fist name for identification Done Local intranet 100 6 2 Register Page This page is used for user registration for SIRAT User needs to provide the desired login ID password confirm password first name and last name Once registration is done the user can go back to Login Page by clicking on the Back to Login button 23 Enter User ID rajeshratnala Enter Password Confirm Password First Name Rajesh Last Name Ratnala Register Backto Login 6 3 Home Page The screenshot below shows the Home Page This page mainly has content describing SIRAT s usage and the user interface Web Portal For Remote Administration Single Interface Remote Administration for Middleware Technologies This page will give you the basic information about this Remote Web Portal This utility will enable remote administration of Middleware Servers on severa
81. sages Even the tool logs can be used for more rigorous investigation 3 4 Security SIRAT s user group is very limited to a few users administrators who are trustworthy to use the tool SIRAT has a simple multilevel security in place Other than the authentication through userid password to get access to SIRAT the tool is designed not to allow access to remote boxes for activities that might be considered a security breach unless the user is given the userid password of the remote box There are other security measures that are left for future implementation For instance one way to minimize malicious behavior or discourage the user from malicious activities is to log the user activities to a separate file to which the user has no access That way the file can be analyzed for suspicious behavior or can be used for debugging in cases of failure 3 5 Maintainability SIRAT can be easily maintained with minimum technical skills It does not use many resources to make it work Once installed and configured the minimum knowledge needed is to learn how to start stop JBoss and MySQL servers Furthermore SIRAT can be installed and configured on a normal laptop or desktop without many resources from the host 4 SIRAT Design Overview This section will explain about SIRAT architecture and how the third party software packages are integrated in building it 4 1 SIRAT Design Architecture SIRAT is a java based application using third party utili
82. se productivity However such a tool must be user friendly and flexible enough to be customized per user specifications 1 1 Birth of the Idea and its Incentives The main aim of this project is to create a tool that enables remote administration of servers on multiple disparately located boxes The tool developed is called Single Interface Remote Administration Tool SIRAT The proposed tool will enable an administrator to login to the administrator tool via a single unified GUI The administrator will be able to perform a wide range of tasks such as routine maintenance and start stop services on any or multiple remote computers The administrator will no longer need to log into several boxes separately to do the routine maintenance work Also the tool can be customisable and scalable to fit each administrator s unique requirements Such a utility with a common GUI interface to connect to any or all the servers remotely to do most of the common administrative or daily routine tasks would provide immense value to any IT firm This in turn will save time and money There are not many tools in the market to meet these demands During research we could see that this utility can be built by using third party remote administration tools available in the market Such tasks as described above can be easily accomplished through the use of scripts however the script language comes with its own pitfalls The primary disadvantage of scripts is the lack of a u
83. se this Admin Tool to do all the administrative task of this application server Weblogic is owned by Oracle Corporation Oracle WebLogic consists of a Java EE platform product family that includes A Java EE application server WebLogic Application Server An enterprise portal WebLogic Portal An Enterprise Application Integration platform A transaction server and infrastructure WebLogic Tuxedo A telecommunication platform WebLogic Communication Platform An HTTP web server WebLogic is a server software application that runs on a middle tier between back end databases and related applications and browser based thin clients WebLogic is a leading e commerce online transaction processing OLTP platform developed to connect users in a distributed computing environment and to facilitate the integration of mainframe applications with distributed corporate data and applications WebLogic server is based on Java 2 Platform Enterprise Edition J2EE the standard platform used to create Java based multi tier enterprise applications J2EE platform technologies were developed through the efforts of BEA Systems and other vendors in collaboration with the main developer Sun Microsystems Because J2EE applications are standardized modules WebLogic can automate many system level tasks that would otherwise have demanded programming time The main features of WebLogic server include connectors that make it possible for any legacy application on any client t
84. ser friendly GUI Graphical User Interface Security can also be a concern with scripting language while using scripts one has to openly mention the passwords in a file These concerns can be solved by designing a user friendly tool to help administrators with their daily tasks This type of tool can be developed to be an interactive tool with a simple yet functional front end Through the use of creative messaging and interfaces a user can view the activities that are taking place after a task is initiated It will provide higher levels of security as the passwords will not be openly exposed in a text file but will be stored in a database and not understandable or visible to the naked eye The boundary of the topic is very vast so for the scope of this project we will be limiting this idea to the middleware world only There are two major technologies that occupy most of the Middleware world One is Dot Net Net and the other is Java Dot net applications can run as services and daemons depending upon the operating system used On the other hand Java world runs on Java virtual machine JVM JVM s are bundled with applications servers Some of the most popular application servers are IBM Websphere Oracle Weblogic JBoss and Tomcat In this project we will consider one of these technologies to showcase how the tool will be used in doing the daily administrative tasks of the application server Additional extra features can be looked
85. sign http en wikipedia org wiki Remote_administration http searchsoa techtarget com definition WebLogic http en wikipedia org wiki JBoss application server http en wikipedia org wiki Oracle WebLogic Server http technet microsoft com en us sysinternals bb896649 http www windowsecurity com articles PsTools Suite Part1 html http psychology about com od researchmethods f reliabilitydef htm http whatis techtarget com definition 0 289893 sid9 gci213140 00 html http technet microsoft com en us magazine 2007 03 desktopfiles aspx http tmcpfs ops fhwa dot gov cfprojects uploaded files Final 6220Q amp A pdf http download oracle com docs cd E13150_01 jrockit_jvm jrockit geninfo diagnos u nderst jit html 89
86. supplied is wrong 7 5 8 Reachability Test Here we will be testing the following cases with respect to positive and negative input data Ping the Box Box Configuration Box Memory Usage Box Disk Usage Box Task Manager Ping the Box J Header Windows Go gie gt Searh More Signh X convert Sele jq Favorites gp f eBay Sony Reader Library B SonyStyle 2 Upgrade Your Browser F Suggested Sites Header o Eje am Paver Safetyr Too r Done Internet Protected Mode On gt 100 gt Ping Output x Googie J Search More Son A X Comet sele ix Favorites gp eBay 3 Sony Reader Library B SonyStyle f Upgrade Your Browser Suggested Sites Header Ac E Pages Satety Tos dr Create Service Password Done Internet Protected Mode On gt 100 gt x Google Search More Signin A X convert Esel iy Favorites jep fj eBay 3 Sony Reader Library 8 SonyStyle P Upgrade Your Browser Suggested Sites lt Header S gt Eje Pager Safety Toole 169 254 250153 b Internet Protected Mode On gt 100 gt Note that to run this function the userid password of the remote box is needed Otherwise a dialogue box will open and it will ask for the needed credentials 42 rtr ocalhos Vise x PR x Goge d Search More Sinn am
87. te as an example a server administrator might need to start and stop the JBoss servers several times a day If there were one or two servers then this would be a simple task What if there were a number of servers like 30 or 40 servers that need to be started at different times Connecting to each of these disparate boxes individually and performing similar type of administrative activities repetitively are very time consuming and reduce a person s and thereby a firm s productivity significantly There exist many tools in the market with the capability of remotely administrating tasks on these servers These cheap and inexpensive tools help a middleware administrator with day to day work by logging into separate interfaces in order to complete the tasks needed The tools can constantly monitor these machines and servers and report any problem if they see any suspicious activity through email or through an interface However these tools are often not able to retain the specific settings required to redo the same or the modified forms of the routine administrative tasks Specially these tools do not have a single unified user interface to manage the entire IT administrative works including controlling the development QA and Production environments 1 i A box is often referred to as a host server or in general a system Therefore a tool that would automate and thus speed up such repetitive tasks in a timely manner can increa
88. teAdmin Testrun cmd NA v Run Delete Test Delete Project Add a New Project Here Project Name Project Description L Add Project Done 5 LLL Santran amp 100 gt 6 5 Create Service Page This page will allow creating the required services for a listed project SIRAT s scope is contained to Windows only In Windows using only two types of functions i e a windows service or a batch file any type of administrative activities can be accomplished The two screens shots below show the fields that are required to create a service 25 Web Portal For Remote Administration ProjectList Create Service Reachability Test Log Out Name of the Project Name of the Service Discription of the Service Name of the Box Username of the Box Password of the Box OS of the Box Type of Request NameQatch Windows Service Name of the Project Test Name of the Service StatMySQL Discription of the Service Name of the Box Usemame of the Box ExcHANGEWamala Password of the Box OS of the Box E of poser u Windows Bonis Name Batch Windows Service MySQL559 6 6 Reachability Page This reachability test gives the opportunity to check the resources and the health of the remote box F
89. tegy Generational Parallel Mark amp Sweep generational true sweep parallel mark parallel r Generational true r HeapFreeCurrent 3828400 1 HeapFreePercent 94 t HeapSizeCurrent 67108864 r HeapSizeMax 1073741824 r Incremental false r JVMDescription Oracle Corporation Oracle JRockit R version R28 1 3 11 141760 1 6 0 24 20110301 1429 windows ia32 r Java VMVendor Oracle Corporation 1 JavaVendor Oracle Corporation 1 JavaVersion 1 6 0 24 r JumProcessorLoad 0 0 r LastGCEnd 1312163894604 r LastGCStart 1312163894582 1 Name ManagedServerl r NumberOfDaemonThreads 39 r NumberOfProcessors 2 r OSName Windows Vista r OSVersion 6 0 r Parallel true r TotalGarbageCollectionCount 33 1 TotalGarbageCollectionTime 1216 r TotalHeap 67108864 t TotalNumberOfThreads 42 r TotalNurservSize 9729512 7 7 Performance Testing Performance testing is the process of determining the speed or effectiveness of a computer network software program or a device This process can involve quantitative tests done in a lab such as measuring the response time or the number of MIPS millions of instructions per second at which a system functions Qualitative and quantitative attributes such as reliability scalability and interoperability may also be evaluated Performance testing is often done in conjunction with stress testing Performance testing can verify that a system meets the specifications claimed b
90. ties to communicate with different remote machines The SIRAT portal is hosted on JBoss application server It uses JRockit 10 as its JVM The back end database is MySQL It uses PsTools suite to communicate between remote machines Figure 1 shows the high level architectural diagram of SIRAT Application Server JBose 5 1 0 GA Max Memory 512MB Min Memory 128MB JRockit JDK 1 6 0_20 R28 1 0 4 0 1 Database Server MySQL 5 5 9 Port 3306 SID MyProject DB Server Tables Used Users Remote Project Admin Remote Projects Remote Service Figure 1 SIRAT Architectural Diagram The PsTools suite includes several individual applications which can be run on command line to get or to do various administrative tasks on the local or the remote machines In order to make PsTools Suite work the below are pre conditions which should be implemented on the network you are running SIRAT 1 Ping The Remote machine should give positive response when you ping it That means all the Remote Machines should in a reachable network 2 Net share ADMINS share should be enabled Means all the Remote Machine s CNWINDOWS folder should be accessible from your work station 11 3 Remote Registry service PsTools suite makes use of RPC calls via port 445 Make sure that the port 445 is opened in the firewall 4 Administrator Rights Make sure that you have Administrator rights on all the Remote Machines yo
91. ton you see will have all the documention about this tool 6 4 Project List Page On the left hand side of Project List page there is list of all the projects created in SIRAT When clicked on each project link on the right side it will display all the services present for that project If it is required to switch a project then click on the desired 24 project name which has the corresponding services This page also provides the option of allowing a user to create a new project At the center bottom provide the project name and project description to create a new project Once the required information is supplied click on Add Project button Once this is done the new project will be added to the list of the projects Header Windows Internet Explorer DAK Go E http flocathost 8080 RemoteAdmin jsp ProjectTree jsp NEN mE u 7 ULSI x tive search fet Ele Edit View Favorites Tools Help Links Se de Birne Q eer Oe SCO Project Name Test R DBA Name of the Service Description of the Service Type of Request Name Batch Windows Service Service Type Click to Run Click to Delete Service MiddlewarePRD MySQLDev Dev MySQL Server wservice MySQLSS9 Run Delete Middle A O MiddlewareQA RunlPconfig Example to run a batch command wbatch ci Remo
92. u are accessing There is more written about PsTools suite in the appendix section Figure 2 explains the communication process of PsTools Suite SIRAT deployed Laptop Desktop and Server notebook desktop pc 1 Su server PsTools suite makes use of RPC calls via port 445 So port 445 should be opened in Firewall to make RPC calls firewall firewall server server server server Figure 2 SIRAT Communication Channel 12 SIRAT can be used as a single user deployed in a personnel laptop desktop or it can be deployed on a server by hosting the URL to different users It is not recommended to host SIRAT for multiple users as authorization is not enabled and session problems might arise 4 2 SIRAT User Interface Terminology SIRAT user interface is made as simple as possible In the context of SIRAT the term service refers to do an activity on the remote server from SIRAT The activity can be anything like starting or stopping a database or an application server on the remote machine As mentioned earlier SIRAT is developed for Windows Operating system So a service can be a start stop query a Windows Service or execute a batch file on the remote machine All the services in SIRAT will be branched under a project The term project refers to a group of services with similar or unique characteristics This can be best explained by quoting an example In SIRAT you create a project called Middleware
93. ution The screen shows that the Weblogic Admin server has successfully stopped hmtpe flocathost 2080 Remoteddmin isp ProyectT ree iso x Google 2 Search More gt Signln iconvert Pseler dX Favorites gap f eBay M Sony Reader Library 3 SonyStyle f Upgrade Your Browser Suggested Sites Header Mr dw v Pager Sale Toosv Qv Project Name MiddleWare Name of the Service Description of the Service Type of Request Name Batch Windows Service Service Type Click to Run Click to Delete Service StatAdmin Start the Weblogic Admin Server whatch C Oracle AdminScripts RemoteAdminScriptsStartAdmincmd NIA Run StopAdminServer Stop the Weblogic Admin Server wbatch C Oracle AdminScripts RemoteAdminScripts StopAdmincmd NIA Run Initializing WebLogic Scripting Tool WLST Welcome to WebLogic Server Administration Scripting Shell Type for help on avadable commands 50 The next eight screen shots shown below are the results of starting the entire Weblogic Domain using SIRAT Initializing WebLogic Scripting Tool WLST Welcome to WebLogic Server Administration Scripting Shell Type help for help on available commands Initializing WebLogic Scripting Tool WLST Welcome to WebLogic Server Administration Scripting Shell Type helpQ for help on available commands Connecting to t3 localhost 7000 with userid weblogic Successfully con
94. ws Service MySQLDev that was created to administer the Dev MySQL database server Started with querying the service and went on to start and stop the service All of them worked as expected In the Command Status Console check the state to know the status of the windows service 37 ject Name Test S EU c Type of Name Batch Windows Service Click to Click to Delete Name of the Service Description of the Service Rees Service Type Ri RER MySQLDev Dev MySQL Server wservice MySQL359 Query Run Delete MySQLDev Wrong Dev MySQL Server wrong info wservice MySQL559 M Run Delete RunlPconfig Example to run a batch command wbatch c RemoteAdmin Testirun cmd N A v Run Delete RunlPConfig Wrong a a CiRemoteAdminTestmncmd nA M Rm Delete SERVICE NAME MySQL559 DISPLAY NAME MySQL559 TYPE 10 WIN32 OWN PROCESS STATE 4 RUNNING STOPPABLE PAUSABLE ACCEPTS_SHUTDOWN WIN32_EXIT_CODE 0 0x0 SERVICE_EXIT_CODE 0 0x0 CHECKPOINT 0x0 WAIT_HINT 0 ms Status 1 When Querying the Status of the MySQLDev we can see that the State as RUNNING Project Name Test ENS Type of Name Batch Windows Service Click to Click to Delete Name of the Service Description of the Service Service Type Ra Seri MySQLDev Dev MySQL Server Wservice MySQL559 Stop Run Del
95. y its manufacturer or vendor The process can compare two or more devices or programs in terms of parameters such as speed data transfer rate bandwidth throughput efficiency or reliability SIRAT was run for several hours under observation the most important parameters such as memory and CPU of the machine were monitored There was no degrading effect on the machine and it used minimal resources for functioning The main components of SIRAT that need review from a performance angle are the utilization of JBOSS and MySQL server To check on the status of the resource usage of these processes memory and CPU usage of JBOSS and MySQL server are recorded periodically 29 The following shows some configuration information for a machine on which SIRAT is installed Hardware Laptop MS Windows XP Professional Intel Core 2 Duo 2 00 GHz 2 GB Ram The following figure shows the resources used during those hours 50 40 20 E Memory 10 0 11 T2 T3 14 T5 T6 Figure 8 JBOSS Application Server resource utilization chart On X axis T1 T2 are specific intervals Memory usage is in bytes To show the actual memory usage 384000 bytes should be added to the Y axis values It is done this way to fit the CPU and memory utilization in one chart and make the chart easier to read The CPU percentage is the value of java exe process at that particular event If average is taken then the average CPU value is very negli
96. ze the server for the use of the fast transactional InnoDB storage engine and the high speed MyISAM storage engine C Transactional Database Only Optimized for application servers and transactional web applications This will make InnoDB the main storage engine Note that the MyISAM engine can still be used C Non Transactional Database Only Suited for simple web applications monitoring or logging applications as well as analysis programs Only the non transactional MyISAM storage engine will be activated lt Back Nets canei 75 Configure the MySQL Server 5 5 server instance Please select the drive for the InnoDB datafile if you do not want to use the default settings InnoDB Tablespace Settings Please choose the drive and directory where the InnoDB tablespace should be placed c RemoteAdmin MySQLS 5 9 DataFiles v Drive Info Volume Name File System NTFS I 28 6 GB Diskspace Used _ 423 3 GB Free Diskspace a high number of concurrent connections A number of 20 3 is option ew database applications that will not require connections will be assumed Online Transaction Processing OLTP Choose this option for highly concurrent applications that may have at any one time up to 500 active connections such as heavily loaded web servers C Manual Setting a Please enter the approximate number of concurrent Concurrent connections v na

A Single Interface Remote Administration Tool

Contents

Download Pdf Manuals

Related Search

Related Contents