Hiyas, Matt, Stephen Don,t have local access to box and dont want hassle of relaod, reinstall of patches, etc.
>>Looking back at your other email : I'm not sure what you mean by "loading mysql on to www.domain". When we've loaded mySQL onto the boxes we've got, it just installs without a reference to a domain or even localhost. I had no problem with installing mysql, just connecting to it with user@localhost, see connection example, I`ll try your suggestion re setting up root@% but not too sure this will work. Can connect though with user@% or username from individual ip's as well. Before .pkg upgrade then I'll run "Uninstalling MySQL To uninstall MySQL, connect to your Virtual Server and run: % vuninstall mysql" Meanwhile I take your suggestions not to mess with CF looking for localhost. What maybe will work is fixing the raq so that it does not default to localhost. I`ve put up the following question on the raq usergroup as I believe it may solve it, I need to do this fast as I have some CF work to do asap on the box: ............................................................................ ......... my disappearing localhost and its replacement with a domainaddress so localhost has become www.mydomain.com causing a problem for MySQL and other programmes. I have to ask to solve this could somebody give me the typical info for their raqXXX.uk2net.com as they have it set up in virtual site info, also same for the dns info. Sorry to bother you with this, but I'm sure if I can verify that my own info for raq527.uk2net.com is correct and the dns info is correct and I remove the site currently allocating itself to localhost and set it up correctly again later, this problem can be easily fixed and I can return to raqXXX.uk2net.com (localhost [127.0.0.1]). Hope the above explains the problem anyway. > The following connection session may show something, problem is it wont allow connections on localhost: > > [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 thanks Colm -----Original Message----- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: 11 February 2003 11:16 To: CF-Linux Subject: Re: CF5, Mysql, Red Hat Colm, Looking back at your other email : I'm not sure what you mean by "loading mysql on to www.domain". When we've loaded mySQL onto the boxes we've got, it just installs without a reference to a domain or even localhost. Looking at the command line stuff at the bottom of the other email : Have you got a root@localhost user set up on the server? It looks like the mysql user "root" doesn't have access to the dbms from the host "localhost" or the password is not the same as [EMAIL PROTECTED] If you have root@% set up, we've found that often you need to have both root@localhost and root@% in order for root@% to work correctly. I know it shouldn't be this way, but its just seems to sort the problem out. As for the pkg upgrading or whether you need to uninstall : I think if you do the install by hand at the command line from an rpm it'll upgrade ok, but looking at http://pkgmaster.com/packages/raq/4/ and the notes below the link to the mySQL package, this seem to indicate that you may need to uninstall the old version first when installing the pkg. Hope this helps Regards Stephen ----- Original Message ----- From: "Colm Brazel" <[EMAIL PROTECTED]> To: "CF-Linux" <[EMAIL PROTECTED]> Sent: Tuesday, February 11, 2003 10: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? > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=14 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=14 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.14
