Tideway Community Forum

search within lists?

2008-12-03T19:47:07+00:00

Hi. I’d like to be able to search for specific items within a list variable, in order to create a sub-list. In the below example, the goal is to create a list called dev_hosts containing only those hosts from all_hosts that have “dev” in the string.

all_hosts := ["db_dev1",
              "db_dev2",
              "db_prd1",
              "db_prd2",
              "db_uat1",
              "db_uat2"];

where the goal is to wind up with a list like this:

dev_hosts :=             ["db_dev1",
                          "db_dev2"];

The only smart way to do this, that I know of, is to iterate through each item in the main list and add it to the sub-list if it matches that regex, thusly:

dev_hosts := [];

for host in all_hosts do
    if regex.extract(host, regex "dev") then
        dev_hosts := dev_hosts + [host];
    end if;
end for;

Is there a quicker way to do this with the “search” function? i.e. something like this:


dev_hosts := search(in all_hosts ... something);

I tried regex.extractAll on the main list, in the hopes that it would return another list, but I got an ECA error. :( regex.extractAll appears to want only a string input.

Not finding CPU and Memory information during HPUX discoveries

2008-12-01T15:28:50+00:00

Hi, I am running the Community Edition 7.1.7 and I have been unable to get the discoveries to find CPU and Memory information for these HPUX Integrity servers. The models include HP RX5670, RX4640, RX7620, RX7640 and RX8640. Has anyone come across this ? Thanks !

Credential slaves

2008-12-02T13:08:00+00:00

Hi,

I’m trying Tideway foundation community edition in my lab, for the moment.
Discovery is ok for Linux boxes.
I set up a windows credential slave. Its status is connected in the slave management page. There is no firewall on the windows server, neither between the tideway appliance and the windows.
I’ve created a credential “administrator” (administrateur, in fact. I’m french.) in the credentials list with only “windows” access. I tested it with the IP of my slave, it is ok. I have no other windows boxes for the moment but I guess the slave should be able to discover itself.

All discovery status for this windows box are “No Access”.
There must be something I did wrong, but what ?

Worked example for discovering the structure of an Oracle database

2008-11-26T16:37:44+00:00

The following example describes how to extract schema and table information from an Oracle 10g database, and corresponds to the “Discovery mechanism” component of the SQL Discovery feature (referred to in the 7.2 Pre-release 24-11-2008 notes at:

http://www.tideway.com/configipedia/Tideway_Foundation_7.2_Pre-release_24-11-2008 )

In order to carry out the steps below, the following details are required, to enable the database instance to be discovered:

- IP no.

- username and password, with sufficient permissions to run these queries:

SELECT * FROM DBA_DATA_FILES WHERE TABLESPACE_NAME = <tablespace name>
 SELECT username FROM all_users ORDER BY username
 SELECT table_name FROM all_tables WHERE owner = <schema>
 SELECT * FROM dba_tablespaces

- A login credential for the server running the database instance

Follow these steps:

1. Download the Oracle Database 10g Release 2 (10.2.0.4) ojdbc14.jar driver file from the following URL (note there are different versions of the same driver on this page - the one used in this example has size 1,555,682 bytes):

http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_10201.html

2. Copy ojdbc14.jar to /usr/tideway/data/custom/jdbcdrivers

3. Log in as the tideway user and run the following commands:

cd ~/data/custom/jdbcdrivers
ln -s ojdbc14.jar oracleSID.jar

4. The foundation_pre.zip prerelease package itself contains ExtendedDatabasePatterns.zip, which in turn contains two pattern files. Unzip foundation_pre.zip then ExtendedDatabasePatterns.zip, and copy this pattern file to a temporary directory:

OracleExtended.tpl

5. Log in to Foundation, and navigate to the Pattern Management Browse Packages page. Follow the prompts to upload and activate OracleExtended.tpl.

6. The previous step will have created a Software Credential Group called Oracle (containing the four Oracle-specific SQL queries shown above). Navigate to this group from the top-level Discovery tab, by clicking the 2nd-level Credentials tab, then the Software Credentials 3rd-level tab. Click the Oracle group, then the Credentials tab that appears. Create a new credential with the following attributes:

Name                     Oracle10g_SID 
Description 
Username                 <Oracle userid> 
Password                 <password for above user>
Database Driver          Oracle 10g Driver (SID) 
Database IP Address      .*    Match as regular expression 
Port                     .*    Match as regular expression 
System ID (SID)          .*    Match as regex

(Note that arbitrary text can be entered for the name – if more than one credential exists for the Software Credential Group, the one at the top of the list on the Credential Group page is the one tried first by the pattern. The pattern finds the Software Credential Group via this assignment to the new group attribute:

group := “Oracle”;

)

7. Create an OS login credential for the server hosting the database instance (Discovery -> Credentials -> Login Credentials)

8. Perform a discovery of the Oracle server (remember to click the Start all Scans button first)

9. To see the database structure captured by the discovery, perform the following steps:

a. From the Recent Runs list under the Discovery Status tab, click the entry corresponding to the last discovery
b. Click the link corresponding to the number of hosts discovered (1 in this case)
c. Click the Software Instances link
d. Click the Oracle Database Server link to see the schema and table information retrieved

The following are useful sources of information for further investigation of this feature:

- the SQL Discovery section (new in this prerelease), in the Configuration Guide
- the text of the patterns referred to above, which are heavily commented to explain the new SQL Discovery syntax

Server Reference Data: Need to Identify Server Consolidation Opportunities?

2008-02-08T15:53:24+00:00

Tideway is exploring the feasibility of releasing server reference data to augment discovered data in order to help customers analyze server consolidation opportunities more effectively.

The specification attributes that we have identified as being required are:
- Total Power (Watts)
- Power (VA)
- BTU/hr
- Rack Space (RU)

Please tell us if these additional attributes will be of value to you and whether there is additional reference data required to enable analysis of server consolidation opportunities

Problem getting regkey (NoAccessMethod)

2008-11-18T14:27:27+00:00

Hello,

I have a pattern that should extract a regkey, but for some reason it doesn’t.
In the discovery log I see that the credential slave is not able to perform the operation (NoAccessMethod).
Does anyone know what this means and how I can fix this?

triggers
    on hostinfo := HostInfo created, modified, confirmed;
  end triggers;
 
  body
 
    host := model.host(hostinfo);
    if not host then
      stop;
    end if;
 
    if host.os_type <> "Windows" then
      stop;
        end if;
 
    // ING Update Version
    regkey := raw "HKEY_LOCAL_MACHINESOFTWAREINGOperatingSystemUpdateVersion";
    regqry := discovery.registryKey(host, regkey);
    if regqry then
        build_ver := regqry[0].Caption;
        if build_ver then
            host.build_version := build_ver;
        else
            model.withdraw(host,"build_version");
        end if;
    end if;

Here’s a bit of the log:

1262557504: 2008-11-18 14:38:08,248: discovery.servants: DEBUG: Main_i::getOptions() called
1262557504: 2008-11-18 14:38:08,250: security.api: DEBUG: Authorize user ‘[eca_engine]’, operation ‘discovery/options/read’
1262557504: 2008-11-18 14:38:08,251: discovery.device: INFO: Host::getRegistryValue() for 10.243.52.115, recordName 0ab8a4142ad96c0909b43024ad7ef4dd
1262557504: 2008-11-18 14:38:08,251: discovery.hosts: DEBUG: getRegistryValue() - running query HKEY_LOCAL_MACHINESOFTWAREINGOperatingSystemUpdateVersion
1262557504: 2008-11-18 14:38:08,251: api.audit: DEBUG: 10.243.52.115: getRegistryValue(): omniORB-1262557504: Try pool
1262557504: 2008-11-18 14:38:08,251: api.audit: DEBUG: 10.243.52.115: getRegistryValue(): omniORB-1262557504: Try to query via AD slave
1262557504: 2008-11-18 14:38:08,251: api.audit: DEBUG: 10.243.52.115: getRegistryValue(): omniORB-1262557504: Try to query via slave
1262557504: 2008-11-18 14:38:08,252: discovery.slavecred.getSlave: DEBUG: No entry for Slave in the naming service.
1262557504: 2008-11-18 14:38:08,253: discovery.slavecred.getSlave: DEBUG: Testing Slave connectivity
1262557504: 2008-11-18 14:38:08,259: discovery.slavecred.getSlave: DEBUG: Slave contacted
1262557504: 2008-11-18 14:38:08,265: common.utils: DEBUG: slave:credential slave is newer than min_version
1262557504: 2008-11-18 14:38:08,265: common.utils: DEBUG: slave:credential slave isValidVersion min_version=’6.1’ min_revision=’0.0’ result=0
1262557504: 2008-11-18 14:38:08,265: discovery.slavecred.isValidSlaveVersion: DEBUG: isValidSlaveVersion min_version=’6.1’ min_release=’0.0’ result=True
1262557504: 2008-11-18 14:38:08,273: api.audit: DEBUG: 10.243.52.115: getRegistryValue(): omniORB-1262557504: Slave cannot perform operation
1262557504: 2008-11-18 14:38:08,273: discovery.hosts: DEBUG: getRegistryValue() - raising NoAccessMethod()
1262557504: 2008-11-18 14:38:08,273: discovery.device: INFO: finished Host::getRegistryValue() for 10.243.52.115

discovery runs not starting

2008-11-19T21:10:15+00:00

I entered a discovery run and it has not started for a few minutes.

the discovery run screen just hangs without displaying status information.

Parsing UNIX Filesystem Information

2008-11-10T21:51:55+00:00

Has anyone attempted to parse Unix and Linux filesystem information, as returned by df, to separate it into separate drives/mount points?

This has come from a client request.

download community edition

2008-11-18T09:46:18+00:00

Dear all

I cant! get 403 error

is there a problem with the zip?

Can someone shed some light please?

regards

How do I assign a host to a software instance?

2008-10-29T19:02:54+00:00

How do I assign a host to a software instance? I keep seeing patterns where SIs are created but I don’t understand how the SI knows which host it belongs to.

si := model.SoftwareInstance(
        key := key,
        type := type,
        name := name,
        version := full_version,
        product_version := product_version,
        edition := edition);

Where does the host get linked to the si?