Mailing List Archive: 49091 messages
  • Home
  • Script library
  • AltME Archive
  • Mailing list
  • Articles Index
  • Site search
 

[REBOL] Mysql Driver to REBOL, anyone?

From: carlos:lorenz:gmai:l 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 *:-.,_,.-:*'``'*:-.,_,.-: