Hi, Running a query got the rfollowing:
ODBC Error Code = () Unsupported ODBC data source MYSQL for ColdFusion Professional Edition. Turned out it was a known bug in cfodbc.45. I got fix for it at http://www.macromedia.com/v1/handlers/index.cfm?id=21338 Also upgraded mysql with .55 pkg from mysql. This was a bit of a mystery as though I uninstalled using make uninstall the previous version .23 for MySQL, I found I could still connect on the old mySQL and there were no error messages from the rpm -i newpkg upgrade. Anyhow, main thing is the Merant MySQL driver is connecting once again on the ip MySQL is loaded on, note not 127.0.0.1 or localhost, appears I had forgotten the bug above. Regards Colm -----Original Message----- From: Colm Brazel [mailto:[EMAIL PROTECTED]] Sent: 11 February 2003 14:36 To: CF-Linux Subject: RE: CF5, Mysql, Red Hat >I think you misunderstand. You need to check that you have user@localhost >set up. >Really you shouldn't have root@% set up at all, other than in the initial >set up phase to make life a little easier. No, I understand it allright and had configured manually localhost with a username and password which does not work in Cold Fusion having thought this was the problem already. However, checking with your suggestion I notice a user was not set up for localhost, so once again to check CF connection to the database, tried the following: mysql> grant all on *.* to root@localhost identified by "" with grant option; Query OK, 0 rows affected (0.00 sec) mysql> mysql -h localhost test -> -> -> q -> quit But still the connection on localhost fails, [root@www admin]# mysql -h localhost test ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) [root@www admin]# mysql -h www.cbweb.net test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 96 to server version: 3.22.32 Type 'help' for help. mysql> It's not the socket as it can connect on the domain name and has been configured toi look for the socket in the right place. What I suspect is there is a problem with the generic dns and domain raq***etc setup on the raq, I`ll let you know if this is the case. thanks Colm -----Original Message----- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: 11 February 2003 13:25 To: CF-Linux Subject: Re: CF5, Mysql, Red Hat Colm, > 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. > I think you misunderstand. You need to check that you have user@localhost set up. Really you shouldn't have root@% set up at all, other than in the initial set up phase to make life a little easier. When you're setting up users in mySQL you have to specify where they are accessing the database from. joebloggs@localhost means that a user called "joebloggs" can access the database from localhost (ie. the same machine as the dbms). joebloggs@% means that user "joebloggs" can access the database from anywhere. So from your connection session where you issue the command line "mysql -h 127.0.0.1 test" and get the error "ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)" This means that the user "root" has been denied access to the database "test" from the address "localhost". Two reasons this could be happening : 1) "root" has not been given permission to access the database from "localhost" 2) "root" may have a password, which you haven't specified in the command line. I suspect that in this case the problem is that root does not have permission to access the database from "localhost" as your third command line "mysql -h www.domain test" is working. I suspect that mysql thinks that user root is connecting from www.domain as well as to www.domain in this instance. Hope this helps Regards Stephen ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=14 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=14 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.14
