Mysql Driver to REBOL, anyone?

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 *:-.,_,.-:*'``'*:-.,_,.-:

* Carlos Lorenz <carlos.lorenz-gmail.com> [050204 09:49]:

> Hi list, > I am experiencing some trouble using mysql driver from SoftInnov > ** 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: > To unsubscribe from the list, just send an email to rebol-request > at rebol.com with unsubscribe as the subject.

Tim,

> Just some thoughts ... what port is your MySQL console on? Doc's is > defaulting to 3306. See no reference to mysql.sock in Doc's code. > Have you tried connecting as other than 'root'?

> Funny, you got my personal email, but I don't see copy in ML.

Try this: db: open mysql://root:[pass--127--0--0--1]/test insert db Sometimes localhost doesn't get resolved. -- Jaime On Feb 4, 2005, at 1:34 PM, Carlos Lorenz wrote:

Hi Carlos, On Friday, February 4, 2005, 7:34:59 PM, you wrote: CL> Here is what I get when try to connect my REBOL script to the MySQL CL> host at localhost (127.0.0.1): CL> ** Access Error: Cannot connect to localhost ** Where: open-proto ** CL> Near: db: open mysql://root:[pass--localhost]/test insert db Most likely the problem is that MySQL is set up to only listen to the Unix socket and not to TCP connections. Regards, Gabriele. -- Gabriele Santilli <[g--santilli--tiscalinet--it]> -- REBOL Programmer Amiga Group Italia sez. L'Aquila --- SOON: http://www.rebol.it/

Gabriele, Is this something to be configured at MySQL? How can I check for this? thanks Carlos On Sat, 5 Feb 2005 10:37:55 +0100, Gabriele Santilli <[gabriele--colellachiara--com]> wrote:

> Hi Carlos, > On Friday, February 4, 2005, 7:34:59 PM, you wrote: > To unsubscribe from the list, just send an email to rebol-request > at rebol.com with unsubscribe as the subject.

Hi Carlos, On Saturday, February 5, 2005, 12:26:00 PM, you wrote: CL> Is this something to be configured at MySQL? How can I check for this? I don't recall the name of the config option, you should check your my.cnf configuration file. Regards, Gabriele. -- Gabriele Santilli <[g--santilli--tiscalinet--it]> -- REBOL Programmer Amiga Group Italia sez. L'Aquila --- SOON: http://www.rebol.it/

Wich is the full path to "my.cnf" file at your Red Hat 9.0?

/etc/my.cnf -Mj. ----- Original Message ----- From: Carlos Lorenz To: Tim Johnson ; [rebolist--rebol--com] Sent: Thursday, February 10, 2005 6:55 AM Subject: [REBOL] Re: Mysql Driver to REBOL, anyone? Wich is the full path to "my.cnf" file at your Red Hat 9.0?

> I am the blind leading the blind, but I have below my my.cnf file. > I am using red hat 9.0, and I am sure that if you are using debian, > that you will need to 'locate' the files and see if they are on > different paths. >

Wich is the full path to my.cnf" file at your Red Hat 9.0?" /etc/my.cnf ----- Original Message ----- From: Carlos Lorenz To: Tim Johnson ; [rebolist--rebol--com] Sent: Thursday, February 10, 2005 6:55 AM Subject: [REBOL] Re: Mysql Driver to REBOL, anyone? Wich is the full path to "my.cnf" file at your Red Hat 9.0?

> I am the blind leading the blind, but I have below my my.cnf file. > I am using red hat 9.0, and I am sure that if you are using debian, > that you will need to 'locate' the files and see if they are on > different paths. >