Skip to Content
avatar image
Former Member

Possible to change temp folder for dbisql on linux?

I have dbisql installed on an AWS Linux AMI EC2 instance. I am calling it from inside a PHP script using the exec command. The script is run from the command line.

It works perfectly, but I can only get it to work if I change the owner of the /tmp directory to the username that PHP is running under. I get permissions errors otherwise.

  • Will I run into any problems by changing the owner of the /tmp folder? I'm not a Linux expert and I don't know what all uses it.
  • Is it possible to change the temp folder that dbisql uses to something else?

Thank you!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 13, 2017 at 01:13 AM

    I think that you can change TEMP folder by the SATMP environment variable.

    For detail, Please see the following document.
    http://dcx.sap.com/index.html#sa160/en/dbadmin/astmp-environment-variables.html

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 13, 2017 at 06:33 PM

    I'm not sure if there are different good practice suggestions for AWS, but generally /tmp should allow writes from all users, so it is a matter of access rights rather than one of ownership. I just checked one sample where I know I didn't change this setting and "ls -l /" returned attributes drwxrwxrwt for /tmp. drwxrwxrwx might be possible as well. These mean that every user con do everything in /tmp. Can you check if this is different in your AWS session, and if so, did you change it or is it a common setting for this environment?

    HTH

    Volker

    Add comment
    10|10000 characters needed characters exceeded