- bluedragon.xml (from the "config" directory)
- bluedragon.log (from the "work" directory)
- the error page that's generated when you try to run a CFML page that
contains a CFQUERY that references your MySQL datasource; you'll be able to
find this in the "work\temp\rtelogs" directory; make sure you don't have
your own error page configured via CFERROR, so that BlueDragon will generate
a complete error page
Vince Bonfanti
v <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED]
New Atlanta Communications, LLC
http://www.newatlanta.com
-----Original Message-----
From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 07, 2004 10:03 AM
To: CF-Talk
Subject: Re: SOT: BD 6.1 and mySQL
Verifying [insert db name here]
General SQL Error
Any help is greatly appreciated.
Cutter
Vince Bonfanti wrote:
> When you do "Verify Datasources" from the BlueDragon admin console, what
is
> the error message you get back?
>
>
> Vince Bonfanti
> New Atlanta Communications, LLC
> http://www.newatlanta.com
>
> -----Original Message-----
> From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, January 06, 2004 3:46 PM
> To: CF-Talk
> Subject: Re: SOT: BD 6.1 and mySQL
>
> OK, but how do I do that. I'm sorry if I sound dumb, but I've had to
> mess with command line utilities 3 times since windows was release so I
> am more than a little rusty (it took me 4.5 hours to get mySQL online).
> As I said before, I am able to connect to the db server from my machine
> using mySQL-Front (graphic db admin tool), so I must have allowed the
> remote access when I did my original install.
>
> Cutter
>
> Steven Erat wrote:
> > MySQL has default security restrictions that typically don't allow
remote
> > hosts to connect. A quick and dirty test would be to modify the mysql
> start
> > script and add an argument for --skip-grant-tables such as:
> > $bindir/safe_mysqld --skip-grant-tables --datadir=$datadir . . . Then
> > restart mysqld.
> >
> > If that works, then the more graceful solution is to first remove that
> > argument then adjust the grant tables on the databases used from the
> remote
> > host.
> >
> > HTH
> >
> >
> >
> > _____
> >
> > From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, January 06, 2004 1:16 PM
> > To: CF-Talk
> > Subject: Re: SOT: BD 6.1 and mySQL
> >
> > Now we're outside my realm of experience. My mySQL db is on a seperate
> > server. I can connect to it via the CF dev server and mySQL Control
> > Center on that same machine, as well as mySQL-Front on my personal
> > system. I have double checked what I thought to be the pertinent
> > variables (mySQL server IP, db name, un & pw), and even
> > uninstalled/reinstalled BD + below said instructions to start over from
> > scratch. No luck as yet.
> >
> > Cutter
> >
> > Jochem van Dieten wrote:
> >
> > > Cutter (CF-Talk) wrote:
> > > > When I set up a mySQL datasource and go to verify that
> connection it
> > > > returns the following error:
> > > >
> > > > verifying (insert db name here)...
> > > > General SQL Error
> > > >
> > > > I followed the instructions from the following BD FAQ file:
> > > >
> > > >
> > >
> >
>
http://www.newatlanta.com/biz/c/products/bluedragon/self_help/faq/detail?faq
> > Id=216
> >
>
<http://www.newatlanta.com/biz/c/products/bluedragon/self_help/faq/detail?fa
> > qId=216>
> > >
> > > Can you connect using the MySQL command line tool from the same
> > > host using the same parameters?
> > >
> > > Jochem
> > >
> > > --
> > > I don't get it
> > > immigrants don't work
> > > and steal our jobs
> > > - Loesje
> > >
> >
> > _____
> >
> _____
>
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
