Fred, Tried that, didn't fix it, I think the problem resides in cahnges I made to the original site configuration that came with the box ie virtual server info for raq***.uk2net.com or dns for the same, the dns for which sets up hostname for localhost on the raq and points to 127.0.0.1. I`m checking that out anyway and trying to verify this at the moment. now.
thanks Colm -----Original Message----- From: Fred T. Sanders [mailto:[EMAIL PROTECTED]] Sent: 11 February 2003 13:46 To: CF-Linux Subject: Re: CF5, Mysql, Red Hat have you thought about just adding locahost back to your hosts file? I don't know much about RAQ and Cobalt, but this sounds like it might fix the problem you just described Fred ----- Original Message ----- From: "Colm Brazel" <[EMAIL PROTECTED]> To: "CF-Linux" <[EMAIL PROTECTED]> Sent: Tuesday, February 11, 2003 5:31 AM Subject: RE: CF5, Mysql, Red Hat Hi Matt, Thanks for the url for pkgmaster as for some security issue maybe it seems impossible to use wget on the raq ( it is a raq) to download latest pkg from mysql.com. I`m afraid the problem though is not with mysql or CF 5 but with the way I have inadvertently configured the raq following a reload so that the raq has allocated www.mydomain.com to localhost and replaced localhost with this address. Trouble is I dont immediately see the way to reconfigure the raq to return it to localhost, I`ll have to have another look at this aspect. That's why both CF and mysql won't allow connections I guess onto localhost in the connection example below. If you know the parameters or setup on the raq required to support allocation on raq of localhost and 127.0.0.1, let me know. Will the .pkg upgrade a previous version of MySQL or should previous ver be removed first? thanks Colm -----Original Message----- From: Matthew Smith [mailto:[EMAIL PROTECTED]] Sent: 11 February 2003 00:00 To: CF-Linux Subject: RE: CF5, Mysql, Red Hat Hi Colm, I wouldn't mess with trying to get CF to not look at 'localhost' - just remove MySQL and reinstall. If when you say that you are using 'cobalt linux Red Hat' you mean RaQ (rather than LX50) then I would use the PKG installer for MySQL from http://pkgmaster.com/ - can go wrong with this one - just remember to reset the root password! Either way, it looks like you are using version 3.22.32 - PKG Master has 3.23.54 which is a far more recent version. No doubt there is a way to do what you are asking but a reinstall would surely be quicker. HTH, Matt. > Hi, > > Following a reload on a cobalt linux Red Hat machine I inadvertently loaded > mysql onto www.domainname and not localhost though the CF 5 I have is > professional version and not enterprise version. Problem is I can't connect > with the Merant MySQL driver to MySQL databases through ODBC datasource > administrator. I can connect remotely to MySQL allright using Front and even > using webmin and have setup users with permissions that work for all remote > connections except this local connection the CF5 ODBC admin is trying to > make. I have restarted/stopped the server and setup users for localhost and > 127.0.0.1 and applied all in > http://www.macromedia.com/v1/handlers/index.cfm?id=20755 including > mysql.sock suggestions, but still the Merant driver won`t connect, anybody > got a fix for this? I suppose the question could be is there a way for this > professional ver of CF5 I use to instead of looking for default 127.0.01 or > localhost, can it be configured to look instead for www.mydomain as default > as I imagine this could fix this problem, if fo how or can this be done? > > The following connection session may show something: > > [root@www bin]# mysql -h localhost test > ERROR 2002: Can't connect to local MySQL server through socket > '/var/lib/mysql/mysql.sock' (111) > [root@www bin]# mysql -h 127.0.0.1 test > ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) > [root@www bin]# mysql -h www.domainname test > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 89 to server version: 3.22.32 > > Type 'help' for help. > > mysql> > > TIA > > Colm > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=14 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=14 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.14
