-----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 : <!--- default query --->
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-----
---
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
