• State Suggested Answer
  • Replies replies
    12
  • Answers answer
    1
  • Subscribers subscribers
    18
  • Views views
    365
  • Users 0 members are here

Tool for editing domain databases

Prindl

Recently I checked the database entries for my MTAs, Internet Agents and POAs, because i saw a path in a log, which does not exist since years.

In this case it was the UNC-path (attribute-ID 59003), which is totally wrong for this agent, because it points to a server, which was removed several years ago. I know, that one could set this attribute via C1 as long as the groupwise system was integrated into eDir, but now, I don't see any tool to change this value. Although that value seems to be not used any more I see this value still popuated in a newly installed internet agent, but it does not show an UNC-path - it simply shows the linux filesystem-path to the internet agent.

How can I get rid of those irritating entries, because if someone has to take over the administration of this system, this will at least lead to unneccessary thoughts. And I hate carrying along wrong entries - even, if they do not harm and apparently are not used.

  • 0  

    I wonder if it shows via the API?  take a look to see if it is showing with an easy link.   then, if we've found it that way, may be able to drill in and fix it.

    https://GW-IP:9710/gwadmin-service/list/gwia.csv    /poa.cvs   /mta/cvs

    in testing, I didn't see any signs, but I had been careful to clear those settings before the 'divorce' from eDir.  Did find a POA that was still set for NetWare that was running just fine, but that is fixed now.

    ________________________

    Andy of KonecnyConsulting.ca in Toronto
    Please use the "Like" and/or "Verified Answers" as appropriate as that helps us all.

  • 0  

    Hmm,

    59003 should be this value (domain, general)

    Nevertheless you can clear it with ReST API I think ...

    Use "Verified Answers" if your problem/issue has been solved!

  • 0  

    What is the record showing when using the REST API?

    https://gwserver:9710/gwadmin-service/domains/DOM_NAME/mta

    As i dont have this i like to see the full record as this probably can be used to make a REST API call using Curl to empty or remove this field

  • 0   in reply to   

    Well, does it cause any problems for starting up the agent or whatever else or is it more or less a cosmetics?

    If you check gwadmin-service: https://<domain-dns>:9710/gwadmin-service/domains/<domainName>/mta

    You will see all MTA fields for that domain, i.e. also logging part, for example:

    <logFilePath>/gwsystem/dom1/logs</logFilePath>
    <logLevel>VERBOSE</logLevel>
    Then use restAPI to modify those fields if needed.
  • 0   in reply to   

    Hello Diethmar,

    I agree with your assessment. Since I use the browser access to the gwadmin service quite a lot for analyzing and understanding a GroupWise system, I can say that I have not yet found the attribute ID 59003 "unc-path" in the GroupWise DB schema. But that doesn't mean anything, it could also be a mistake that I can't find the attribute ID.

    In my GroupWise Life system I have the same problem and so far I can say it is a cosmetic problem. In the lab and also with customers I have solved wrong UNC paths by swapping primary domain with secondary domain and then deleting the primary. However, from field experience I can recommend to recreate and redistribute the internal GroupWise CA. George

    “You can't teach a person anything, you can only help them to discover it within themselves.” Galileo Galilei

  • 0 in reply to   

    The REST API for this Internet agent (the mtas are ok) shows for the url:

    https://GWIAserver.x.x:9710/gwadmin-service/domains/DOM-NAME/gwias/GWIA-NAME

    the line

    "path": "\\\\Pc_burghardt_d\\C\\grpwise\\INETDOM\\WPGATE\\GWINAG", in JSON style
    in XML translation it would be <path>\\Pc_burghardt_d\C\grpwise\INETDOM\WPGATE\GWINAG</path>
    which is completely nonsense as it is a Windows path, for a machine, which was retired more than 10 years ago and the rest of the path is incorrect, too - with the exception of WPGATE.

    the entry for the

    "smtpQueuesDirectory": "/media/nss/VOL03/DOM-directory/wpgate/GWIA-NAME", in JSON sytle,
    which would be in XML <smtpQueuesDirectory>/media/nss/VOL03/DOM-directory/wpgate/GWIA-NAME</smtpQueuesDirectory>
    is correct and seems to be the correct value for the "path" entry, too. At least a newly installed GWIA shows a corresponding value
    The issue is only cosmetic, as everything is working since more than 10 years without problems.
  • 0 in reply to   

    You think, that if I do a GET of https://gwiaserver.x.x:9710/gwadmin-service/domains/DOM-NAME/gwias/GWIA-NAME

    and afterwards change in the body the "path" entry and then do a PUT of the changed body to the same uri as above, the entry is changed accordingly?

    I have no experience with the groupwise RestAPI and how reliable it is. I only use RestAPIs for Databases, where I have the full control over the database itself and use the RestAPI to provide limited access to other users.

    For being on the safe side, which files should i backup before changing anything, so that I can go back to a working configuration, if anything goes wrong? Is it just the wpdomain.db or does it include gwdom.dc and wpdomain.dc and wphost.dc. And is it sufficient to backup this(those) files on the domain server, where the gwia runs, or do I have to backup the primary domain database, too.

    Regards

  • 0   in reply to 

    Yes, it should work in this way.

    ReST Api helps a lot if you have to change some "old" values (because of lacking a C1). But in most cases I have used it for mass operations around GroupWise.

    Use "Verified Answers" if your problem/issue has been solved!

  • 0   in reply to   

    I.e. I did this one a very long time ago: https://ohmag.net/groupwise-2014-using-the-rest-api-to-convert-mailboxes/

    Use "Verified Answers" if your problem/issue has been solved!

  • Suggested Answer

    0   in reply to 

    I did some checking and the field is really old and as you seen no longer used. We used to allow configuring the path where the GWIA would place it’s files but we long since changed it and hard wired it to look at the domain and make it’s path relative to to wpgate and then the field DS_SUB_DIR ( field 50137 ) that has value "gwia" which is combined the full path.

    I tried to empty or remove this but the REST API wont allow this, the below was tried and is correct as any other field other then path with the same line can be changed/updated.

    curl -k --user admin:novell -H "content-type:application/json" -X PUT --data "{\"path\":\"\"}"  https://gwmain.robvk.com:9710/gwadmin-service/domains/MainDom/gwias/GWIA

    So it seems nothing we can do to remove this so just let it be

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.