Opened 14 years ago
Last modified 10 years ago
#1065 new enhancement
IZ124: Adding the global configuration of databases used by ARCo module
Reported by: | aja | Owned by: | |
---|---|---|---|
Priority: | normal | Milestone: | |
Component: | testsuite | Version: | current |
Severity: | Keywords: | Sun framework | |
Cc: |
Description
[Imported from gridengine issuezilla http://gridengine.sunsource.net/issues/show_bug.cgi?id=124]
Issue #: 124 Platform: Sun Reporter: aja (aja) Component: testsuite OS: All Subcomponent: framework Version: current CC: None defined Status: RESOLVED Priority: P3 Resolution: FIXED Issue type: ENHANCEMENT Target milestone: milestone 1 Assigned to: issues@testsuite QA Contact: joga URL: * Summary: Adding the global configuration of databases used by ARCo module Status whiteboard: Attachments: Issue 124 blocks: Votes for issue 124: Vote for this issue Opened: Mon Mar 26 06:43:00 -0700 2007 ------------------------ It would be good to store the information about the installed databases in the global testsuite configuration setup. We can provide the shared information like arco_write user & password, port number, jdbc driver location. We could either add this info into the host configuration, or create a new infrastructure configuration for the databases. ------- Additional comments from aja Wed Jan 30 09:31:28 -0700 2008 ------- This feature is useful for testing ARCo module, and the new parameter - the path to the file with the database configuration - is required. If you don't specify checktree_arco as an additional checktree (testsuite menu - item 4) Additional Testsuite's checktree directories), simply use the default value "none". DB config initialization: ================= I added a new item (13) Testsuite's global database configuration file to the main testsuite menu. The initial file for database configuration will be created by specifying the filename. All the testsuite users should use this file then. Adding database configuration: ======================= From the main testsuite menu choose (26) enter testsuite setup, then (4) Database file configuration First of all you have to specify the database types: 1) Supported database types --------------------------------- the following database types are supported for ARCo: specify the required values (see table) o oracle default port number: 1521 driver: oracle.jdbc.driver.OracleDriver url: jdbc:oracle:thin:@$db_host:$port:$db_name o postgres default port number: 5432 driver: org.postgresql.Driver url: jdbc:postgresql://$db_host:$port/$db_name o mysql default port number: 3306 driver: com.mysql.jdbc.Driver url: jdbc:mysql://$db_host:$port/$db_name Then you can specify the databases in your cluster: 2) Testsuite cluster database list ------------------------------------- choose the unique name for the database (in checktree_arco you will choose the database from the list of configured databases) then specify required parameters: dbtype - choose from the list of supported db types dbhost - host where the database is installed dbport - port used for the connections to the database dbname - database name username - name of the write user password - password of this user driverpath - path to the jdbc driver
Note: See
TracTickets for help on using
tickets.