[R] RODBC, Apache, Linux

[Dirk Eddelbuettel]

On Fri, Jan 25, 2002 at 09:40:42AM -0700, Andrew Schuh wrote:
> This may be as much of a Linux Newbie question as an RODBC question.  I've
> managed to get iODBC working on my RedHat 7.2 system.  I can load the
> library and run it as root.  However, I would like to be able to run it via

I'd try smaller steps, i.e. make sure it works as you.

> Perl and Apache over the web.  I'm not sure what I need to change in order
> to let "nobody" (the user running the scripts off of Apache) load the
> library.  I can log in as "nobody" to run R but can't seem to load the
> library.  I imagine there might be an access issue?  Has anybody done this
> and can you tell me how?  

On my (Debian) system, "cd ~nobody" goes into /home/. [1] So that's where
I placed the .odbc.ini, which is in fact a soft link to ~edd/.iodbc.ini.
With that, Perl cgi scripts (which call R) work just fine. 

The usual caveat applies about security of cgi scripts etc. For me, the setup
is at work behind fairly extensive firewalls.

Dirk

[1] This is defined in /etc/passwd, see "man 5 passwd".

-- 
Good judgment comes from experience; experience comes from bad judgment. 
							    -- F. Brooks
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._