[cfaussie] Re: MySQL permissions issue

Tony Stratford Tue, 16 Dec 2003 14:48:55 -0800

Steve, I had a similar problem with a RH8 box, fixed by manually editing the hosts file.

My file:
/etc/hosts
127.0.0.1       localhost localhost.localdomain
172.x.x.x       machine.somewhere.org.au

Hope this helps

Tony Stratford

Collins, Steve wrote:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I have a Red Hat 9/Apache 2.0.40/MySQL 4.0.16 server which I have just
installed CFMX 6.1 on.  All my PHP apps and their DB connections work
just fine, but I can't get a MySQL DSN to verify, even using the MySQL
root user and password in the CF DSN settings.  The error I get from CF
Admin is:

Connection verification failed for data source: farcry_webdevteam
[]java.sql.SQLException: Server configuration denies access to data
source
The root cause was that: java.sql.SQLException: Server configuration
denies access to data source

A simple test page which does a SELECT * and the tries to <cfdump> the
query result gets similar:

Error Occurred While Processing Request Error Executing Database Query. Server configuration denies access to data source The error occurred in /var/www/html/cfmysqltest.cfm: line 23

21 : 22 :  23 : <cfquery name="qTestDSN" datasource="farcry_webdevteam" username="root" password="[EMAIL PROTECTED]" > 24 : SELECT * 25 : </cfquery>

SQL        SELECT *
DATASOURCE        farcry_webdevteam
SQLSTATE          08001
Please try the following:

    * Check the ColdFusion documentation to verify that you are using
the correct syntax.
    * Search the Knowledge Base to find a solution to your problem.

Browser         Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.5)
Gecko/20031007 Firebird/0.7
Remote Address          10.192.18.176
Referrer        
Date/Time       12-Dec-03 12:57 PM
Stack Trace
at
cfcfmysqltest2ecfm1013855561.runPage(/var/www/html/cfmysqltest.cfm:23)

java.sql.SQLException: Server configuration denies access to data source
        at org.gjt.mm.mysql.MysqlIO.init(Unknown Source)
        at org.gjt.mm.mysql.Connection.connectionInit(Unknown Source)
        at org.gjt.mm.mysql.jdbc2.Connection.connectionInit(Unknown
Source)
        at org.gjt.mm.mysql.Driver.connect(Unknown Source)
        at
coldfusion.server.j2ee.sql.pool.JDBCPool.createPhysicalConnection(JDBCPo
ol.java:511)
        at
coldfusion.server.j2ee.sql.pool.ConnectionRunner$RunnableConnection.run(
ConnectionRunner.java:64)
        at java.lang.Thread.run(Thread.java:534)

I am pretty sure this is a CF user to MySQL user permissions problem,
but I'm not sure where to look.  Any ides welcome.

Steve - -- Stephen Collins Online Services eBusiness Division __________________________________________________ Department of Industry, Tourism and Resources Level 12, 20 Allara Street, Canberra City ACT 2600 GPO Box 9839, Canberra ACT 2601

E [EMAIL PROTECTED]
P +61 2 62137193
C +61 410 680722
F +61 2 62136227
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (MingW32)
Comment: For info see http://www.gnupg.org

iEYEARECAAYFAj/ZKDIACgkQB6K6hSCnql566QCcDJ0PkaLIBOnyRCWajgiI8iKP
Jb4Ani6k3itKV34sCDm0nZC012u6OyAK
=XddS
-----END PGP SIGNATURE-----


--
Tony Stratford            |Voice: +61 3 9345 4997
Royal Children's Hospital |Fax:   +61 3 9345 7166
Flemington Road           |Mobile: 0402 216 211
Parkville VIC 3052        |email: [EMAIL PROTECTED]
AUSTRALIA

---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]

MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004

[cfaussie] Re: MySQL permissions issue

Reply via email to