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

Mysql Driver to REBOL, anyone?

 [1/10] from: carlos:lorenz::gmail 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 *:-.,_,.-:*'``'*:-.,_,.-:

 [2/10] from: tim-johnsons::web::com at: 4-Feb-2005 10:15


* Carlos Lorenz <carlos.lorenz-gmail.com> [050204 09:49]:
> Hi list, > I am experiencing some trouble using mysql driver from SoftInnov
<<quoted lines omitted: 3>>
> ** Access Error: Cannot connect to localhost ** Where: open-proto ** > Near: db: open mysql://root:pass-localhost/test insert db
You will likely get a better explanation from DocKimbel, but in the meantime: With Linux: ----------- I have in my mysql table a host entry the same as my computer alias and a host entry the same as my machine's hostname. I'm not inclined to use root from a script. Not being a linux expert, I just play it safe and avoid it. I hope this helps in the interim .... regards tim
> I had the same trouble with PHP scripts but I have solved it based on > the following information extract from www.php.net:
<<quoted lines omitted: 26>>
> To unsubscribe from the list, just send an email to rebol-request > at rebol.com with unsubscribe as the subject.
-- Tim Johnson <tim-johnsons-web.com> http://www.alaska-internet-solutions.com

 [3/10] from: carlos::lorenz::gmail::com at: 4-Feb-2005 22:39


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'?
Yes I have
> Funny, you got my personal email, but I don't see copy in ML.
i am new to gmail interface and I guess I have cliked "reply" botton instead of "reply all" so the list did not get a copy *:-.,_,.-:*'``'*:-.,_,.-: Carlos Lorenz *:-.,_,.-:*'``'*:-.,_,.-:

 [4/10] from: jvargas::whywire::net at: 4-Feb-2005 21:16


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:

 [5/10] from: gabriele::colellachiara::com at: 5-Feb-2005 10:37


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/

 [6/10] from: carlos::lorenz::gmail::com at: 5-Feb-2005 9:26


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:
<<quoted lines omitted: 12>>
> To unsubscribe from the list, just send an email to rebol-request > at rebol.com with unsubscribe as the subject.
-- *:-.,_,.-:*'``'*:-.,_,.-: Carlos Lorenz *:-.,_,.-:*'``'*:-.,_,.-:

 [7/10] from: gabriele::colellachiara::com at: 5-Feb-2005 12:33


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/

 [8/10] from: carlos::lorenz::gmail::com at: 10-Feb-2005 10:55


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

 [9/10] from: mjfox::5149::com at: 14-Feb-2005 15:51


/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. >
Carlos -- To unsubscribe from the list, just send an email to rebol-request at rebol.com with unsubscribe as the subject.

 [10/10] from: mail:defiantpc at: 14-Feb-2005 0:49


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. >
Carlos -- To unsubscribe from the list, just send an email to rebol-request at rebol.com with unsubscribe as the subject.

Notes
  • Quoted lines have been omitted from some messages.
    View the message alone to see the lines that have been omitted