Matt,
127.0.0.1 worked, i can't believe it, that's pretty much the only thing i
hadn't tried. i'll try to lay off the crack.
thanks,
dennis
-----Original Message-----
From: Matt Southall [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 25, 2001 1:23 PM
To: CF-Linux
Subject: Re: CF and MySQL
Thursday, January 25, 2001 - dennis wrote:
> Can anyone give me some pointers on creating datasources with CF 4.5 on
> Slackware? They're both running on the same machine and I can connect to
> the MySQL server through command line. I just can't create a datasource
> through CF Admin. I keep getting a failed connection when I test the
> datasource.
I've had this sort of problem, and it turned out to be problems with
usernames/hosts for MySQL. i.e. there are probably at least four
different ways to identify your machine:-
127.0.0.1
It's IP
localhost
Its hostname
The problems tended to be because connections to MySQL from the
commandline resolved to one of these (for which there WAS a valid
entry in the MySQL admin tables) and connections from ColdFusion
resolved to another. I managed to find out what I was attempting to
connect as by running MySQL verbosely and watching the output... I'm
sorry I can't remember the command line for doing this... but it's
VERY useful for debugging connections.
Matt
------------------------------------
Broadband Communications Ltd.
+44 (0)115 924 7150
http://www.broadband.co.uk/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
