Status for Andrew DeFaria

• Sent email to Donna describing how to work with GPDB 2.0
• Implemented Aliases
• Changed project search to go off of new view for project aliases
• Fixed bug in displaying of DesignSync information for projects

Continue reading "GPDB 2.0" »

Posted by Andrew DeFaria at 03:52 PM | Permalink | TrackBacks (0)

• Added CC Defaults Report
• Changed export to export as per the tableName
• Changed export to export some files not listed on the web page

Posted by Andrew DeFaria at 05:29 PM | Permalink | TrackBacks (0)

• Added export to CSV file to reports
• Made DesignSync servers links to the server:port
• Added links to Project names Site names on reports
• Added edit link to screen after you update a Project or Site

Continue reading "GPDB Enhancements" »

Posted by Andrew DeFaria at 03:27 PM | Permalink | TrackBacks (0)

• Change primitives::login and ldap_authenticate to return a user record of user information if we can find it in LDAP, even if we could not authenticate the password, and pass back proper status
• Straightened out new views WRT Synonyms and Grants
• Implemented Users, Clearcase and DesignSync reports

Continue reading "LDAP changes/Synonyms and Grants/Reports" »

Posted by Andrew DeFaria at 02:35 PM | Permalink | TrackBacks (0)

• Added Org/SBE drop down to edit Project
• Integrated LDAP!
• Changed primitive.pm to authenticate with LDAP!

• Added description to Org/SBE and removed password
• Added edit links to showProject and showSite

Posted by Andrew DeFaria at 06:45 PM | Permalink | TrackBacks (0)

• Changed org_sbe.name to link up with parent_project
• Created org_sbe.sql to add org_sbe entries
• Added gpdb_getOrgSBE and gpdb_putOrgSBE to gpdb.pm
• Added Org/SBE menu
• Changed various new tables to to be uniform in width
• Fixed a few bugs regarding adding of sites where no site domains are added
• Added much of Update Project
• Fixed bug with update CCDefaults for Projects
• Added screen for adding CCDefaults when adding a project

Posted by Andrew DeFaria at 09:46 AM | Permalink | TrackBacks (0)

GPDB Login

• Moved to the top.
• Changed wording to be more friendly
• Login with unknown username puts up a warning but grants read only access
• Login with known username but wrong password is properly denoted

Other changes

• In Project display, site defaults are not listed on top of the Project defaults.
• Change width of tables to line up with the menus across the top.
• Updating of project CC defaults still not working correctly
• Added Add Project

Posted by Andrew DeFaria at 07:25 PM | Permalink | TrackBacks (0)

• Implemented gpdb_deleteSiteDomain
• Modify site almost functionally complete
• Looking into how to do what MySQL does with it's limit clause in Oracle
• Changed List Projects at Site to be paged
• Changed how Projects are displayed
• Added most of the Project update page
• Change some of the logic on login/logout
• Change gpdb_putClearcase to set a global as to whether the record was added/updated or nothing changed.
• Changed gpdb_add_vob.pl to:
• Report better the number of Clearcase vob records added or not.
• Add an UNKNOWN project for the site it's running at (if needed)
• Properly select the appropriate UNKNOWN project

Posted by Andrew DeFaria at 02:58 PM | Permalink | TrackBacks (0)

• Modify site almost functionally complete
• Looking into how to do what MySQL does with it's limit clause in Oracle

Continue reading "Oracle limit clause" »

Posted by Andrew DeFaria at 07:04 PM | Permalink | TrackBacks (0)

• Started implementing a login facility for GPDB

Continue reading "GPDB Login" »

Posted by Andrew DeFaria at 04:57 PM | Permalink | TrackBacks (0)

• Decided we need to change the Clearcase ID field from a sequential number to one that better represented an instance of a vob tag uniquely. As such we've now made the VOB Replica UUID the key for both the Clearcase record and it's assorted other tables.

Posted by Andrew DeFaria at 01:27 PM | Permalink

• Checked in recent changes to GPDB and its associated scripts

Continue reading "Checkpoint" »

Posted by Andrew DeFaria at 10:30 AM | Permalink

• Changed gpdb_add_vob.pl to use Rexec.pm in order that it may be able to collect information about vobs from other sites

Continue reading "Nice is not so "nice"" »

Posted by Andrew DeFaria at 08:27 AM | Permalink

• Changed gpdb_getProjectsAtSite to be able to separately return all Clearcase projects, Designsync projects, Clearcase & Designsync projects, projects without Clearcase or Designsync associated with them
• Modified gpdb_add_vob.pl to traverse through all regions of current registry server to collect all vob tags
• Modified clearcase record to include fields for VOB Family uuid and VOB uuid. Also modified gpdb_add_vob.pl to get these uuids
• Investigated Victor's CC Metrics database
• Fixed bug in gpdb_add_vob.pl that was adding clearcase records assigned to the wrong site.

Posted by Andrew DeFaria at 11:20 AM | Permalink

• Changed gpdb_convertuk.pl to properly add mapping records for Site Admins
• Changed Single Site Display to display Site Admins
• Change Single Site Display to include all information from Excel design spreadsheet from Bill. Also tightened up display of cc_defaults
• Added new gpdb_siteForHostname that returns the site for a given hostname. Default is current host. Uses nslookup to retrieve the CNAME for the host

Posted by Andrew DeFaria at 11:27 AM | Permalink

• Pulled out common code from mkview that will be needed for mkvob into Mkcc.pm Perl module
• Re-engineered mkview to use Mkcc.pm
• Started recoding mkvob to use GPDB and the new Mkcc.pm
• Code complete on mkvob - need to test
• Issue: It seems that we have multiple versions of mkview_linked and that UK has continued development of their version of mkview_linked while we've been developing on mkview_linked here in Dallas. IOW there are two versions in separate vobs!

Continue reading "Mkcc.pm and mkvob" »

Posted by Andrew DeFaria at 04:50 PM | Permalink

• Finished gpdb_add_project.pl with new table layout
• With gpdb_getProjectsAtSite I can now return to mkview. Implemented new paging usage listing projects at the site
• Finished coding of mkview such that it is now functional with GPDB and can make views

Posted by Andrew DeFaria at 04:46 PM | Permalink

• Moved convertdb and gpdb_add_vob into Clearcase
• Attempting to standardize which Perl to use, which Oracle.pm to pickup and how to insure that other sites have the proper prerequisites for GPDB
• Discovered that Oracle is not supported on Linux here at TI. This will be a problem for GPDB
• Still working on issues of the new GPDB design and attempting to get gpdb_add_project.pl to work with it
• Got definition of performance problem that Donna is experiencing. She is attempting to populate a pull down with just the project names for a site. Doing so causes lots of transfer of data as the current GPDB API gpdb_getProject effectively transfers all kinds of project information where Donna needs only the project names.
• Developed a new API, gpdb_getProjectsAtSite that returns only the project names in a more efficient manner

Continue reading "GPDB Database performance" »

Posted by Andrew DeFaria at 05:32 PM | Permalink

• Implemented schema changes for GPDB based on previous meetings
• Dropped PDB_ from table names to make them shorter and more understandable
• Created all new tables and mapping tables. Adjusted sequencing
• Changed users table to use AXID for key. Associated changes to other tables
• Added synonyms where required
• Updated drop_all.sql to reflected all new tables, views and sequences
• Reorienting gpdb.pm for new database layout
• Initially dropped the projects_by_site view as the new data structures handle this in a different way. Later added the view back this time gathering information from 3 different tables.
• Got convertdb to be able to add users, sites and projects.
• Got gpdb_add_vobs.pl working again in new structure
• Started getting web pages to reveal data in new structures
• Working on gpdb_add_project.pl to accommodate new schema layout
• Changed gpdb_add_project.pl to use sites table instead of a sites file
• Changed -s parm for gpdb_add_project.pl to instead specify a site to process - default being all sites

Posted by Andrew DeFaria at 03:48 PM | Permalink

• Fixed bug in domain_ranges.sql script
• Finished Create site
• Added replica_name field
• Fixed naming error with snapto_dir and owning_group
• Expanded size of snap_notify to 1024 bytes

Posted by Andrew DeFaria at 11:21 AM | Permalink

• Added CSS class for input fields
• Changed Project names to be drill down links
• Fixed some bugs in add project. Now checking that project name and owning group are not blank
• Added Port Ranges to Sites. As implemented it's just a text field with no real enforcement. I think the plan is to eventually augment the DesignSync creation script to check the port ranges from the GPDB Site table
• Augmented Create Site to accommodate newly added fields. Still need to implement the handling of multiple domains per site. Should a check be implemented to insure that a domain name is not duplicated at any other site?
• Implemented checking of IP Ranges to insure they are valid IP addresses and that the lower range is lower than the upper range. Still need to check that these ranges do not overlap any other IP ranges.
• Changed several drop downs to properly sort the items. For example, user names are not sorted by at least first name, sites are sorted by site name, etc.

Posted by Andrew DeFaria at 08:44 PM | Permalink

• Added PDB_ALIASES and PDB_MIRRORS to GPDB
• Expanded VOB_TAG to accommodate larger VOB_TAGS
• Added more fields to PDB_SITES to hold login information that used to be kept in the gpdb_site_list.txt
• Fixed bug with not displaying/updating phone number

Posted by Andrew DeFaria at 08:11 PM | Permalink

• Added CSS to GPDB and re-oriented the web page to use them. This will allow us to control this much better
• Changed sites page to handle multiple domains per site

Posted by Andrew DeFaria at 08:16 PM | Permalink

• Created gpdb_add_vob.pl. This script combs through the Clearcase registry and then adds the information to GPDB. It uses a heuristic to attempt to determine what project this vob is associated with. There are outstanding issues regarding ownership of DesignSync, Clearcase and Project objects.
• Changed gpdb_add_project.pl to handle multiple domains per site

Posted by Andrew DeFaria at 08:26 PM | Permalink

• Added PDB_SITE_DOMAINS_MAP to GPDB. This is needed as a mapping table to allow multiple domains per site

Posted by Andrew DeFaria at 08:25 PM | Permalink

• Met with Bill and Michael regarding changes to GPDB database. Michael believes we should stick with site codes and change convertdb to do the translation from UK site names to site codes
• Spoke with Larry regarding site codes and he brought up the point that this would not work with the Embassy model and other external partnerships. As such we are back to site names...
• Found that cron has a very limited PATH causing gpdb_add_project.pl to fail under cron

Posted by Andrew DeFaria at 08:58 AM | Permalink

• Looked into sites, site codes and differences between UK projects/domains and the current implementation of GPDB
• Cronned gpdb_add_project

Continue reading "gpdb_add_project cronned" »

Posted by Andrew DeFaria at 10:58 AM | Permalink

• Working on convertdb, a Perl script to read the UK database and convert it into GPDB
• Finished code to convert users. Using de to get info about a user to populate the GPDB fields
• Worked out problems with sites and got sites being added to GPDB from the UK database
• Got adding of PDB_CLEARCASE records preliminarily done

Continue reading "UK -> GPDB" »

Posted by Andrew DeFaria at 12:29 PM | Permalink

• Converted UK Users -> GPDB
• Converted UK Sites -> GPDB

• Checked in new gpdb_add_project.pl
• Created cclic_report.pl and checked it into Clearcase

Continue reading "gpdb_add_projects.pl v1.1" »

Posted by Andrew DeFaria at 12:33 PM | Permalink

• Lots of re-writing of gpdb_add_project.pl to better handle error conditions
• Investigated DB structures some more
• Created cleardb.sql script to clear out the test db

Posted by Andrew DeFaria at 04:22 PM | Permalink

• Changed several gpdb modules to support a db parameter for logging into an alternate database
• Changed gpdb-devel.pl to use new interface

Posted by Andrew DeFaria at 12:29 PM | Permalink

• Learned about sqlplus and how to speak to Oracle databases from Victor
• Re-wrote the section about getting NIS data and managed to get gpdb_add_project to talk to Nice properly
• Checked in working version of gpdb_add_project and the Rexec.pm module
• Discovered that gpdb_add_project stumbles over some no longer existing machines in some DesignSync registries. Need to change this to send email
• Updated my rc scripts to include support for Oracle
• Working with Bill and Mike we determined that there is a test database for gpdb
• Determined how gpdb.pm opens the database in an effort to teach it how to connect to a test database. It's currently an all or nothing thing. This needs to change.

Posted by Andrew DeFaria at 07:31 AM | Permalink

• Attempted to integrate Rexec into gpdb_add_project.pl and have it talk to Nice
• Looked into problem with Cygwin, Samba and ssh

Continue reading "gpdb_add_project.pl using gpdb user and Nice" »

Posted by Andrew DeFaria at 05:31 PM | Permalink

• Checked in improved gpdb_add_project.pl script
• Started investigating Dave Smith's Monthly Matrix

Continue reading "Improved gpdp_add_project" »

Posted by Andrew DeFaria at 03:50 PM | Permalink