Re: [R] RODBC: missing files? (Re: RODBC: how to set the data-source?)

2009-08-29 Thread Oliver Bandel 
Oliver Bandel  first.in-berlin.de> writes:

[...]
> I assume for each entry in /etc/passwd until the one that os looked for,
> /etc/odbc.ini is opened once...
> ...maybe I should test this hypothesis... looks strange.
[...]

No, my loginname is in line 31 of /etc/passwd.

oli...@siouxsie:~$ grep -n "etc\/odbc.ini" LOG 
4006:open("/etc/odbc.ini", O_WRONLY|O_CREAT|O_APPEND, 0666) = -1 EACCES
(Permission denied)
4024:open("/etc/odbc.ini", O_WRONLY|O_CREAT|O_APPEND, 0666) = -1 EACCES
(Permission denied)
4042:open("/etc/odbc.ini", O_WRONLY|O_CREAT|O_APPEND, 0666) = -1 EACCES
(Permission denied)
4310:open("/etc/odbc.ini", O_WRONLY|O_CREAT|O_APPEND, 0666) = -1 EACCES
(Permission denied)
4311:open("/etc/odbc.ini", O_RDONLY) = 3
4326:open("/etc/odbc.ini", O_WRONLY|O_CREAT|O_APPEND, 0666) = -1 EACCES
(Permission denied)
4327:open("/etc/odbc.ini", O_RDONLY) = 3
4342:open("/etc/odbc.ini", O_WRONLY|O_CREAT|O_APPEND, 0666) = -1 EACCES
(Permission denied)
4343:open("/etc/odbc.ini", O_RDONLY) = 3
4358:open("/etc/odbc.ini", O_WRONLY|O_CREAT|O_APPEND, 0666) = -1 EACCES
(Permission denied)
4359:open("/etc/odbc.ini", O_RDONLY) = 3
4374:open("/etc/odbc.ini", O_WRONLY|O_CREAT|O_APPEND, 0666) = -1 EACCES
(Permission denied)
4375:open("/etc/odbc.ini", O_RDONLY) = 3
4390:open("/etc/odbc.ini", O_WRONLY|O_CREAT|O_APPEND, 0666) = -1 EACCES
(Permission denied)
4391:open("/etc/odbc.ini", O_RDONLY) = 3
4406:open("/etc/odbc.ini", O_WRONLY|O_CREAT|O_APPEND, 0666) = -1 EACCES
(Permission denied)
4407:open("/etc/odbc.ini", O_RDONLY) = 3
oli...@siouxsie:~$ grep -c "etc\/odbc.ini" LOG 
17


Looks nevertheless quite strange.

Ciao,
   Oliver

__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

[R] RODBC: missing files? (Re: RODBC: how to set the data-source?)

2009-08-29 Thread Oliver Bandel 
Hello,


I "strace"t the R session when trying to connect to the database.


Strange, that /etc/odbc.ini first should be opened with Append-mode:


open("/etc/odbc.ini", O_WRONLY|O_CREAT|O_APPEND, 0666) = -1 EACCES (Permission
denied)
open("/etc/odbc.ini", O_RDONLY) = 3
fstat(3, {st_mode=S_IFREG|0644, st_size=259, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) =
0x7f305ae91000
read(3, "[rtestdb]\nDescription = rtest"..., 4096) = 259


also strange: the file will be read many, many times.
I did not pasted it here, but /etc/odbc.ini and /etc/passwd
are read very often.

I assume for each entry in /etc/passwd until the one that os looked for,
/etc/odbc.ini is opened once...
...maybe I should test this hypothesis... looks strange.





The next stuff also looks strange: as if there is a problem because of a missing
locale-stuff?


mprotect(0x7f30565eb000, 4096, PROT_READ) = 0
open("/usr/share/locale/de_DE.UTF-8/LC_MESSAGES/libc.mo", O_RDONLY) = -1 ENOENT
(No such file or directory)
open("/usr/share/locale/de_DE.utf8/LC_MESSAGES/libc.mo", O_RDONLY) = -1 ENOENT
(No such file or directory)
open("/usr/share/locale/de_DE/LC_MESSAGES/libc.mo", O_RDONLY) = -1 ENOENT (No
such file or directory)
open("/usr/share/locale/de.UTF-8/LC_MESSAGES/libc.mo", O_RDONLY) = -1 ENOENT (No
such file or directory)
open("/usr/share/locale/de.utf8/LC_MESSAGES/libc.mo", O_RDONLY) = -1 ENOENT (No
such file or directory)
open("/usr/share/locale/de/LC_MESSAGES/libc.mo", O_RDONLY) = -1 ENOENT (No such
file or directory)
open("/usr/share/locale-langpack/de_DE.UTF-8/LC_MESSAGES/libc.mo", O_RDONLY) =
-1 ENOENT (No such file or directory)
open("/usr/share/locale-langpack/de_DE.utf8/LC_MESSAGES/libc.mo", O_RDONLY) = -1
ENOENT (No such file or directory)
open("/usr/share/locale-langpack/de_DE/LC_MESSAGES/libc.mo", O_RDONLY) = -1
ENOENT (No such file or directory)
open("/usr/share/locale-langpack/de.UTF-8/LC_MESSAGES/libc.mo", O_RDONLY) = -1
ENOENT (No such file or directory)
open("/usr/share/locale-langpack/de.utf8/LC_MESSAGES/libc.mo", O_RDONLY) = -1
ENOENT (No such file or directory)
open("/usr/share/locale-langpack/de/LC_MESSAGES/libc.mo", O_RDONLY) = -1 ENOENT
(No such file or directory)
open("/usr/share/locale/de_DE.UTF-8/LC_MESSAGES/RODBC.mo", O_RDONLY) = -1 ENOENT
(No such file or directory)
open("/usr/share/locale/de_DE.utf8/LC_MESSAGES/RODBC.mo", O_RDONLY) = -1 ENOENT
(No such file or directory)
open("/usr/share/locale/de_DE/LC_MESSAGES/RODBC.mo", O_RDONLY) = -1 ENOENT (No
such file or directory)
open("/usr/share/locale/de.UTF-8/LC_MESSAGES/RODBC.mo", O_RDONLY) = -1 ENOENT
(No such file or directory)
open("/usr/share/locale/de.utf8/LC_MESSAGES/RODBC.mo", O_RDONLY) = -1 ENOENT (No
such file or directory)
open("/usr/share/locale/de/LC_MESSAGES/RODBC.mo", O_RDONLY) = -1 ENOENT (No such
file or directory)
open("/usr/share/locale-langpack/de_DE.UTF-8/LC_MESSAGES/RODBC.mo", O_RDONLY) =
-1 ENOENT (No such file or directory)
open("/usr/share/locale-langpack/de_DE.utf8/LC_MESSAGES/RODBC.mo", O_RDONLY) =
-1 ENOENT (No such file or directory)
open("/usr/share/locale-langpack/de_DE/LC_MESSAGES/RODBC.mo", O_RDONLY) = -1
ENOENT (No such file or directory)
open("/usr/share/locale-langpack/de.UTF-8/LC_MESSAGES/RODBC.mo", O_RDONLY) = -1
ENOENT (No such file or directory)
open("/usr/share/locale-langpack/de.utf8/LC_MESSAGES/RODBC.mo", O_RDONLY) = -1
ENOENT (No such file or directory)
open("/usr/share/locale-langpack/de/LC_MESSAGES/RODBC.mo", O_RDONLY) = -1 ENOENT
(No such file or directory)
semop(294920, 0x7fff62e9c110, 2)= 0
semop(294920, 0x7fff62e9c130, 1)= 0
open("/usr/share/locale/de_DE.UTF-8/LC_MESSAGES/R-RODBC.mo", O_RDONLY) = -1
ENOENT (No such file or directory)
open("/usr/share/locale/de_DE.utf8/LC_MESSAGES/R-RODBC.mo", O_RDONLY) = -1
ENOENT (No such file or directory)
open("/usr/share/locale/de_DE/LC_MESSAGES/R-RODBC.mo", O_RDONLY) = -1 ENOENT (No
such file or directory)
open("/usr/share/locale/de.UTF-8/LC_MESSAGES/R-RODBC.mo", O_RDONLY) = -1 ENOENT
(No such file or directory)
open("/usr/share/locale/de.utf8/LC_MESSAGES/R-RODBC.mo", O_RDONLY) = -1 ENOENT
(No such file or directory)
open("/usr/share/locale/de/LC_MESSAGES/R-RODBC.mo", O_RDONLY) = -1 ENOENT (No
such file or directory)
open("/usr/share/locale-langpack/de_DE.UTF-8/LC_MESSAGES/R-RODBC.mo", O_RDONLY)
= -1 ENOENT (No such file or directory)
open("/usr/share/locale-langpack/de_DE.utf8/LC_MESSAGES/R-RODBC.mo", O_RDONLY) =
-1 ENOENT (No such file or directory)
open("/usr/share/locale-langpack/de_DE/LC_MESSAGES/R-RODBC.mo", O_RDONLY) = -1
ENOENT (No such file or directory)
open("/usr/share/locale-langpack/de.UTF-8/LC_MESSAGES/R-RODBC.mo", O_RDONLY) =
-1 ENOENT (No such file or directory)
open("/usr/share/locale-langpack/de.utf8/LC_MESSAGES/R-RODBC.mo", O_RDONLY) = -1
ENOENT (No such file or directory)
open("/usr/share/locale-langpack/de/LC_MESSAGES/R-RODBC.mo", O_RDONLY) = -1
ENOENT (No such file or directory)
open("/usr/share/l