On Saturday 15 December 2007, Prof Brian Ripley wrote: > On Sat, 15 Dec 2007, Adrian Dusa wrote: > > Indeed, I noticed the "host" argument but the server demands an username > > and a password for the machine first, > > But you said 'connect to', not 'log in to', so how were we to know that? > > > and only after that for the MySQL server. > > Those were the arguments I was looking for. > > I will study the RODBC package then, if it solves the problem. > > I am afraid I don't understand your setup. MySQL works by listening on > port 3306: user accounts don't come into that. With our bastion servers > all such ports are blocked and can only be accessed via tunnels > (implemented by stunnel). I think you need to discuss this with your > sysadmins: if it works under mysql or for ODBC (isql) it will work with > the corresponding R packages.
Of course, most definitely. I usually log in to the external machine using ssh, then access the MySQL server using the MySQL username and password. I probably asked for too much from R, since logging to an external machine needs a secure connection. I'll talk to our sysadmin for local advice, thanks again. Adrian -- Adrian Dusa Romanian Social Data Archive 1, Schitu Magureanu Bd 050025 Bucharest sector 5 Romania Tel./Fax: +40 21 3126618 \ +40 21 3120210 / int.101 ______________________________________________ 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.