Mysql Driver to REBOL, anyone?
[1/10] from: carlos:lorenz:gma:il 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