********************** Macromedia Representative **********************
John,
Run a simple <cfquery> tag against the data source (doesn't matter what the
SQL is) and check the error messaged returned when you run the template.
The verify function in the admin doesn't return any error info, so you are
shooting in the dark until you find out why the connection to MySQL is
failing. The query error message should get you pointed in the right
direction.
--
Tom Jordahl
MacroMedia Server Development
-----Original Message-----
From: John Petraitis [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 01, 2001 9:38 AM
To: CF-Linux
Subject: RE: Cant get MYSQL database to verify in CF administrator
Did a CHMOD 777 on it, made no difference, still does not verify.
Database is in default location /usr/local/mysql/data/. Should I try
throwing it in /opt/coldfusion/database?
Tried with and without login + password, no verify.
Anybody got a small simple datafile in MYSQL that you know verifies that I
could grab to see if my main issue is my datafile?
Thanks!
>From: "Mark Mathis" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Linux <[EMAIL PROTECTED]>
>Subject: RE: Cant get MYSQL database to verify in CF administrator
>Date: Mon, 30 Apr 2001 17:18:17 -0400
>
>You can do a chmod 777 on your database, if it then verifies, the problem
>is
>rights.
>
>Mark Mathis
>TeraTech, Inc. Behind every successful cat
>12221 Parklawn Dr., Suite 200
>Rockville, MD 20852 is an obedient owner.
>(301) 881-1440
>[EMAIL PROTECTED]
>
>
>-----Original Message-----
>From: John Petraitis [mailto:[EMAIL PROTECTED]]
>Sent: Monday, April 30, 2001 5:04 PM
>To: CF-Linux
>Subject: Cant get MYSQL database to verify in CF administrator
>
>
>(Not only a dumb question, but my finger slipped and I send the previous
>message before I finished.)
>
>I'm having trouble setting up a MYSQL database in CF administrator.
>I have a RH 6.2 PC with CF 4.5.2 and MYSQL 3.23.37. MYSQL is alive,
>database
>has no data, but has several tables.
>CF is set up with default login (nobody) and MYSQL is set up according to
>the install documentation
>
>Question: I suspect I'm having some sort of rights issue. Please let me
>know what to check for, and how.
>
>Thank you
>John P
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
