[R-sig-DB] [R-SIG-Mac] R, RMySQL and OSX

[Louis Springer]

I've got at least a partial resolution and workaround to my issue.

The default unix.socket parameter on the dbConnect call is "/opt/ 
local/var/run/mysql5/mysqld.sock" if unix.sock is not specified. I'm  
not sure where this unix.socket is coming from, but it doesn't work  
for me.

The correct unix.sock parameter for my case is  "/tmp/mysql.sock".

This works:

con <- dbConnect(dbDriver("MySQL"), username="myuser",  
host="localhost", dbname="mydb", password="secret", unix.sock="/tmp/ 
mysql.sock")

This does not:

con <- dbConnect(dbDriver("MySQL"), username="myuser",  
host="localhost", dbname="mydb", password="secret")

I also have a patch to RS-MySQL.c to display the error message  
returned by MySQL on a connect error. What should I do with this? Who  
is the current maintainer for this code?

The bit around the "my_sql_real_connect" should read something like:

   if(!mysql_real_connect(my_connection, host, user, passwd, dbname,
		       port, unix_socket, client_flags)){
     char buf[2048];
     sprintf(buf, "could not connect %s@%s on dbname \"%s\"\nError:%s 
\n",
	    user, host, dbname, mysql_error(my_connection));
     RS_DBI_errorMessage(buf, RS_DBI_ERROR);
   }

The current version clobbers "my_connection" on a failed connection  
rendering any call to "mysql_error(my_connection)" useless. My hacked  
RS-MySQL.c returns:

Error in mysqlNewConnection(drv, ...) : RS-DBI driver: (could not  
connect myuser using localhost on dbname "mydb"
Error:Can't connect to local MySQL server through socket '/opt/local/ 
var/run/mysql5/mysqld.sock' (2)

for the error I was having, returning an informative mysql error  
message on the failed connection.


Lou

On Jun 7, 2006, at 9:58 PM, Louis Springer wrote:

> In reference to a meesage from "jhorn at bu.edu", installation and
> build problems on OSX Tiger for R and RMySQL, "RMySQL Error Messages,
> crashing R" (https://stat.ethz.ch/pipermail/r-sig-mac/2006-February/
> 002686.html), was Jason ever able to resolve the issues? I'm not
> getting any of the compile issues referred to, but am unable to
> connect, getting:
>
> RS-DBI driver: (could not connect xxx using localhost on dbname "dbname"
>
> My R version is R for Mac OS X Aqua GUI, 1.16 (3198), R 2.3.1  
> Framework
> RMySQL version RMySQL_0.5-7
> MySQL version mysql  Ver 14.12 Distrib 5.0.13-rc, for apple-
> darwin8.2.0 (powerpc) using readline 5.0
>
> Thanks,
> Lou
>
> _______________________________________________
> R-SIG-Mac mailing list
> R-SIG-Mac using stat.math.ethz.ch
> https://stat.ethz.ch/mailman/listinfo/r-sig-mac
>


	[[alternative HTML version deleted]]