MySQL trigger UDF execution rights

  • Posted:
  • Proposals: 2
  • Remote
  • #2587124
  • OPPORTUNITY
  • Awarded
Kamaldeep Singh K.
Sabbir Mahmud R. have already sent a proposal.
  • 0

Description

Experience Level: Expert
We have triggers run via UDF
the UDF files have root rights

We have several other files in the structure that must be executed so we do not want to move it to a folder and execute all with root. If we add root:root it works to execute from trigger/UDF

We have located the mysql to run the trigger (completely unexpected ;-) )
And we suspect it is also the mysql who executes the script

We execute PHP files in a folder /../../importdata
they have a localadmin and belongs to a psaadm group

when we check what user is executing our script it does not

We can execute the exactly same files from the cron job without any problems. the the user psaadm is executing them

we added the mysqluser to the psaadm group -> does not execute
we added the mysqluser to the psacln group(folder admin ownergroup) -> does not execute
we added the mysqluser to the sudo group -> does not execute
we added the mysqluser to the root group -> does not execute

PLEASE NOTE: this is a trigger job execution that we must have to work.

What are we missing here?

New Proposal

Create an account now and send a proposal now to get this project.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.