Mailing List Archive: Mysql Driver to REBOL, anyone?

[REBOL] Mysql Driver to REBOL, anyone?

From: carlos:lorenz:gm:ail at: 4-Feb-2005 16:34


Hi list,

I am experiencing some trouble using mysql driver from SoftInnov
(http://softinnov.org/rebol/mysql.shtml)

Here is what I get when try to connect my REBOL script to the MySQL
host at localhost (127.0.0.1):

** Access Error: Cannot connect to localhost ** Where: open-proto **
Near: db: open mysql://root:[pass--localhost]/test insert db

I had the same trouble with PHP scripts but I have solved it based on
the following information extract from www.php.net:

User Contributed Notes
mysql_connect
20-Jan-2005 03:38

---------------------------------------------------------------
Debian (and "flavors" of Debain such as Ubuntu Linux) installations of
mysqld place the socket file on a directory OTHER than /tmp/mysql.sock
causing php connection problems.  A quick workaround, as described in
the docs above, is to specify ":/path/to/socket in the server
parameter in db_connect.  Here is an example where mysql socket is
located at /var/run/mysqld/mysqld.sock:

function open_connection() {
  $host = "localhost:/var/run/mysqld/mysqld.sock";
  $user = "root";
  $passwd = NULL;
  $db_name = "ipd";
  return db_connect($host, $user, $password, $db_name);
}
--------------------------------------------------------------

I would like to have some advice on how to fix this inside MySQL
scheme from SoftInnov

Thanks

--
*:-.,_,.-:*'``'*:-.,_,.-:
Carlos Lorenz
*:-.,_,.-:*'``'*:-.,_,.-: