pt3agents not picking up credentials from .pf



  • I've set up a test server with a couple of application databases. The _file can-read permissions are locked down so I can't run PT as blank user. I've added the DBs to dblist.cfg and created <friendly name>.pf in $PROTOP/etc for each of the two DBs. The PFs contain -db, -U, and -P params.

    If I am reading bin/protop correctly, the existence of etc/<friendly name>.pf takes precedence over a <friendly name> line item in dblist.cfg, at least for interactive PT. I am able to launch PT interactively against both DBs, successfully.

    I've set these as monitored DBs in dblist.cfg and they show up in the portal, though with no data. The problem is that the pt3agent sessions appear to be lacking credentials, based on the errors in log/pt3agent.<friendlyname>.log:

    ** Insufficient access privilege for table _Db. (234)
    ** /opt/protop/lib/vstlib.p Could not understand line 72. (196)
    

    I've looked through the setup and help docs and I don't see this addressed: how do I pass client startup parameters to a pt3agent? It doesn't seem to be reading the .pf in etc. I need it to run with -U and -P.


  • administrators

    Hi Rob,

    Are you using the same -U & -P for all your DBs? If so, you can add these parameters in $PROTOP/etc/protop.pf.

    Regards,
    Nectar



  • Hi Nectar,

    In this particular case, I am; at least so far. So I can take that approach for now to allow me to move forward.

    But other applications could be added to this server/PT instance where there would be different credentials. At that point I would want to have a .pf per database, in addition to protop.pf. How should it be configured in that case?

    Thanks,

    Rob


  • administrators

    In that case, I would recommend creating a common "pt3agent" or "protop" user ID, that has read access to your VSTs, for all your databases and specify it in etc/protop.pf.


  • administrators

    That's an interesting scenario. The old approach of a dedicated .pf for each db still works for the interactive ProTop but (so far) has not been adopted for pt3agent. I think it perhaps could be but I'm not sure if there might be any problems with that.

    Thinking about it a bit maybe a better approach would be to use multiple .pf files so that the startup would be something like:

    pt3agent dbName -pf protop.pf -pf custid.pf -pf server.pf -pf type.pf -pf friendlyname.pf ...

    (obviously with "etc/" added and skipping .pf file that don't exist)

    That seems like it might be a nicely flexible approach.


  • administrators

    Done.


 

Looks like your connection to ProTop Community was lost, please wait while we try to reconnect.