, August 27, 2005 2:22 PM
Subject: Re: MySQL - CF: Access Denied when using password
Thanks Dave, but I have set up a dummy user locally with the same
username
and password as that of the live application, so I don't think that is
the
issue...
It works absolutely great as long as I
Ashenfelter [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Tuesday, August 30, 2005 6:56 AM
Subject: Re: MySQL - CF: Access Denied when using password
On 8/29/05, Bryan Stevenson [EMAIL PROTECTED] wrote:
CF 7 comes with a MySQL 3.1 driverif you're using 4.1, there is a
different
Yup, I posted this originally and got the problem solved by downloading
the
jdbc connector/j from mysql.org - I had to use connector version 3.0
though, maybe because I am on CFMX6.1 -- the 3.1 version (recommended)
didn't work for me.
and for me the JDBC connector works for verifying
it is to dispense wisdom and
abuse at the same time.
From: Bryan Stevenson [EMAIL PROTECTED]
Sent: Tuesday, August 30, 2005 12:51 PM
To: CF-Talk cf-talk@houseoffusion.com
Subject: Re: SOLVED Re: MySQL - CF: Access Denied when using password
Yup, I posted
Thankfully this project will end up on MS SQL Server ;-)
hopefully not!!!
while ms sql server (and as crystal tech likes to call it mysql server
2000, great job of training them techs ct!!! very knowledgable) is a
decent product, some of us and our clients choose to use better platforms
it is to dispense wisdom and
abuse at the same time.
From: Bryan Stevenson [EMAIL PROTECTED]
Sent: Tuesday, August 30, 2005 1:22 PM
To: CF-Talk cf-talk@houseoffusion.com
Subject: Re: SOLVED Re: MySQL - CF: Access Denied when using password
Thankfully this project
LOL...never shoulda named ya the Disruptor...
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com
LOL...never shoulda named ya the Disruptor...
yeah but ya did and now i have an image to uphold and even you as the creator
are not a immune!
~Dave the disruptor~
Some people just don't appreciate how difficult it is to dispense wisdom and
abuse at the same time.
LOL...never shoulda named ya the Disruptor...
I believe it's really the disruptured Bryan.
:)
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours
-talk@houseoffusion.com
Subject: Re: SOLVED Re: MySQL - CF: Access Denied when using password
LOL...never shoulda named ya the Disruptor...
I believe it's really the disruptured Bryan.
:)
~|
Logware (www.logware.us): a new
Message -
From: Josh Nathanson [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Saturday, August 27, 2005 2:22 PM
Subject: Re: MySQL - CF: Access Denied when using password
Thanks Dave, but I have set up a dummy user locally with the same username
and password as that of the live
uh oh now you've done it. Prepare for a wall of fire
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: Monday, August 29, 2005 12:37 PM
To: CF-Talk
Subject: Re: MySQL - CF: Access Denied when using password
CF 7 comes with a MySQL 3.1 driverif you're
I experienced the same kind of problem a long time ago when I was using MySQL.
Ran into it with SQL server I think too.
Don't ask me why, but I believe what I did that worked was to go straight thru
my Windows Control panel to setup the datasource.
Control Panel Administrative Tools Data
Hi Josh,
I just got through going through this myself. There is a tech note
regarding this issue (courtesy of the House of Fusion blog). Once I
followed the instructions it appears to be working fine for me. I am
using CFMX7, but the tech note is for MX, so it should work.
Sorry, meant Fusion Authority blog.
--
v/r,
Jeff Fleitz
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with
The password algorithm was changed in MySQL 4.1. That is why you are having
problems. Go here:
http://dev.mysql.com/doc/mysql/en/old-client.html
or here:
http://rucus.ru.ac.za/docs/mysql/Old-client.html
and you will find your solution.
HTH
Mike
@houseoffusion.com
Sent: Sunday, August 28, 2005 7:05 AM
Subject: Re: MySQL - CF: Access Denied when using password
Sorry, meant Fusion Authority blog.
--
v/r,
Jeff Fleitz
~|
Logware (www.logware.us): a new and convenient web-based
Hello all,
I have set up MySQL on my local box, everything works fine until I try to use a
password when creating a datasource in CF Administrator. I get the 1045
Access Denied error. I am able to create the datasource fine if I don't use a
password, so I know the issue is not caused by
, 2005 1:49 PM
To: CF-Talk cf-talk@houseoffusion.com
Subject: MySQL - CF: Access Denied when using password
Hello all,
I have set up MySQL on my local box, everything works fine until I try to use a
password when creating a datasource in CF Administrator. I get the 1045 Access
Denied error. I am
[EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Saturday, August 27, 2005 1:07 PM
Subject: re: MySQL - CF: Access Denied when using password
that would be because your local MySQL install doesnt have the same pw's
as your live one therefor you are trying to give it a username
Subject: Re: MySQL - CF: Access Denied when using password
Thanks Dave, but I have set up a dummy user locally with the same username
and password as that of the live application, so I don't think that is the
issue...
It works absolutely great as long as I don't try to use a password. For
some
Hello all,
I have set up MySQL on my local box, everything works fine until I try
to use a password when creating a datasource in CF Administrator. I
get the 1045 Access Denied error. I am able to create the
datasource fine if I don't use a password, so I know the issue is not
caused
Hey there,
Is there anyway to connect to MySQL datasources without creating a
datasource name in CF admin?
Thanks,
--
Yves Arsenault
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
Yves Arsenault wrote:
Hey there,
Is there anyway to connect to MySQL datasources without creating a
datasource name in CF admin?
Thanks,
Do you mean like MS Windows ODBC datasources or are you simply trying to
connect to a MySQL DB without using a datasource at all?
--
Warm regards,
Thanks for the reply,
I wanted to know if I could work with a MySQL DB without the datasource.
I know that (at least in CF5) I could create DSN-less connections to
say an Access DB
Is it possible to use CFMX with MySQL without creating a datasource in
the CF admin?
Thanks,
Yves
On
DSNless queries are no longer supported in CFMX and beyond.
- Rick
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message:
That's what I thought
I just wanted to make 100% sure.
Thanks,
Yves
On Wed, 24 Nov 2004 14:54:42 -0500, Rick Root [EMAIL PROTECTED] wrote:
DSNless queries are no longer supported in CFMX and beyond.
- Rick
~|
For Yes and No I use and ENUM field and specify 'Yes','No' as the acceptable
choices.
Luis
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 15, 2002 6:40 PM
To: CF-Talk
Subject: mySQL CF
Hi, all.
I'm learning to use mySQL with CF instead
: RE: mySQL CF
Rick,
I noticed you mention that you use CFINSERT. From your earlier postings I
know you are on CF 4.5x, as I am.
You're likely to discover that CFINSERT and/or CFUPDATE sometimes blow
sky-high on CF 4.5x (at least) when working with mySQL (3.23 for sure, and
maybe 4.0x
Thanks for the tip, Luis...I'll read up on ENUM.
Rick
-Original Message-
From: Luis Lebron [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 16, 2002 9:26 AM
To: CF-Talk
Subject: RE: mySQL CF
For Yes and No I use and ENUM field and specify 'Yes','No' as the acceptable
choices.
Luis
: http://www.epilepsyfoundation.org
email: [EMAIL PROTECTED]
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 16, 2002 11:02 AM
To: CF-Talk
Subject: RE: mySQL CF
Hi, Matt.
I, too, learned about the CFUPDATE problem from personal experience
and from
secure.
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]]
Sent: 16 December 2002 16:02
To: CF-Talk
Subject: RE: mySQL CF
Hi, Matt.
I, too, learned about the CFUPDATE problem from personal experience
and from the Allaire forums when I first started using CF (with Access
11:08 AM
To: CF-Talk
Subject: RE: mySQL CF
For mysql -- or any sql, really -- you code it as follows:
cfquery name=yourName datasource=yourDataSource
INSERT INTO yourTable (field1, field2) VALUES ('value1', 'value2')
/cfquery
With mysql, you need to watch out for illegal characters. That means
11:10 AM
To: CF-Talk
Subject: RE: mySQL CF
Standard SQL inserts will work fine on most if not all RDBMS's
Eg.
insert into tablename
(int_col1,varchar_col2)
values
(cfqueryparam cfsqltype=CF_SQL_INTEGER
value=#form.val1#,cfqueryparam cfsqltype=CF_SQL_VARCHAR
value=#form.val2#)
Do try to use
16, 2002 11:10 AM
To: CF-Talk
Subject: RE: mySQL CF
Standard SQL inserts will work fine on most if not all RDBMS's
Eg.
insert into tablename
(int_col1,varchar_col2)
values
(cfqueryparam cfsqltype=CF_SQL_INTEGER
value=#form.val1#,cfqueryparam cfsqltype=CF_SQL_VARCHAR
value=#form.val2#)
Do try
and other things manually,
which is quite handy too.
Trust me, cfqueryparam is your friend ;-)
Craig.
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]]
Sent: 16 December 2002 16:51
To: CF-Talk
Subject: RE: mySQL CF
Hi, Craig, and thanks for the reply.
When you say they make
Thanks, Cary!
Rick
-Original Message-
From: Cary Gordon [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 16, 2002 12:07 PM
To: CF-Talk
Subject: RE: mySQL CF
CFQueryParam gives you an easy way to validate the query params. Some
clever, bored hackers have figured out how to do things
Thanks, Craig!
Rick
-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 16, 2002 12:05 PM
To: CF-Talk
Subject: RE: mySQL CF
cfqueryparam will escape potentially dangerous characters for you. This
is ESSENTIAL if you don't want to have your database
Cary Gordon wrote:
CFQueryParam gives you an easy way to validate the query params. Some
clever, bored hackers have figured out how to do things like pass a drop
table query through the header. It is an even easier exploit if you are
passing query parameters through the url string.
a
: mySQL CF
cfqueryparam will escape potentially dangerous characters for you. This
is ESSENTIAL if you don't want to have your database dropped by some
nasty hacker type person.
Search through the archives for SQL injection attacks, you'll soon see
why.
It will also negate the need to escape quotes
Thanks for the insights, Mark!
Rick
-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 16, 2002 12:53 PM
To: CF-Talk
Subject: RE: mySQL CF
While it's true that CFQUERYPARAM escapes characters, there's a bit more
going on under the covers
saving overhead. On a busy server this can cause an increase in
performance that is exponential. At least that's been my experience.
-Mark
-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 16, 2002 11:05 AM
To: CF-Talk
Subject: RE: mySQL CF
hehe... maybe - can you post some of your code? How are your catalogs built
and how often?
-Mark
-Original Message-
From: paul smith [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 16, 2002 8:10 PM
To: CF-Talk
Subject: RE: mySQL CF
Thanks!
CFQUERYPARAM enabled me to reduce
Subject: RE: mySQL CF
Thanks!
CFQUERYPARAM enabled me to reduce that pesky overhead using client vars in
a database to maintain state from 32ms to 16ms.
Anything up your sleeve to reduce my SQL7 1,000ms-2,000ms full-text
searches by 50% ?
best, paul
At 11:52 AM 12/16/02 -0600, you wrote
Hi, all.
I'm learning to use mySQL with CF instead of Access...
Access had a yes/no field type...in mySQL, I'm using tinyint...is that
appropriate?
In Access, a value of Yes passed in a checkbox formfield put a 1 value in
the field with a CFINSERT...
Now, the value has been changed to 1 when
Rick,
You should put in a zero in my opinion. 1 = true and 0 = false. Using
tinyint in this way is fairly common on most DB platforms.
-Mark
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 15, 2002 6:40 PM
To: CF-Talk
Subject: mySQL CF
Hi
Thanks, Mark.
I guess the zerofill option is there to prevent a null, if desired?
Rick
-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 15, 2002 8:37 PM
To: CF-Talk
Subject: RE: mySQL CF
Rick,
You should put in a zero in my opinion. 1
That's the way I do it.
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 15, 2002 8:15 PM
To: CF-Talk
Subject: RE: mySQL CF
Thanks, Mark.
I guess the zerofill option is there to prevent a null, if desired?
Rick
-Original Message
Rick,
I noticed you mention that you use CFINSERT. From your earlier postings I know you
are on CF 4.5x, as I am.
You're likely to discover that CFINSERT and/or CFUPDATE sometimes blow sky-high on CF
4.5x (at least) when working with mySQL (3.23 for sure, and maybe 4.0x). In threads
on the
Hi,
Something weird is happening. Before I switched my databases from Access to MySQL my
app was working OK.
Now when I insert data into my SQL database one of the fields is getting mucked up and
I don't know why? Here is an example of a entry how is *should* appear in the
database:
Should
: Thursday, October 31, 2002 11:46 AM
Subject: OT: MySQL CF
Hi,
Something weird is happening. Before I switched my databases from Access
to MySQL my app was working OK.
Now when I insert data into my SQL database one of the fields is getting
mucked up and I don't know why? Here is an example
escape all the correct characters.
Hope this helps.
Paul Giesenhagen
QuillDesign
- Original Message -
From: FlashGuy [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, October 31, 2002 11:46 AM
Subject: OT: MySQL CF
Hi,
Something weird is happening. Before I
Subject: OT: MySQL CF
Hi,
Something weird is happening. Before I switched my databases from Access to
MySQL my app was working OK.
Now when I insert data into my SQL database one of the fields is getting
mucked up and I don't know why? Here is an example of a entry how is
*should* appear
Cheers,
--Matt Robertson--
MSB Designs, Inc.
http://mysecretbase.com
-Original Message-
From: FlashGuy [mailto:flashmx;rogers.com]
Sent: Thursday, October 31, 2002 10:01 AM
To: CF-Talk
Subject: Re: MySQL CF
I see...OK...trying the cfqueryparam now. Getting ? inserted into my
database
AM
To: CF-Talk
Subject: Re: MySQL CF
I see...OK...trying the cfqueryparam now. Getting ? inserted into my
database. Must be wrong syntax.
I'll keep trying.
On Thu, 31 Oct 2002 11:53:38 -0600, Paul Giesenhagen wrote:
\ is an escape character .. .Matt Robertson gave me a good tip
Just remember MySQL does not support cftransaction and subselects. You
have to use inner joins.
-Original Message-
From: W Luke [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 3:47 PM
To: CF-Talk
Subject:MySql CF?
Hi,
I've been asked to do some modifications
Hi,
I've been asked to do some modifications for a site which is using MySql as
it's Database, and running CF for Linux. I, locally, am running CF for
Windows and have always used Access - can anyone tell me whether my Windows
CF will be able to connect to the Windows version of MySql?
Rgds
yes it will
"W Luke" [EMAIL PROTECTED] wrote:
Hi,
I've been asked to do some modifications for a site which is using MySql as
it's Database, and running CF for Linux. I, locally, am running CF for
Windows and have always used Access - can anyone tell me whether my Windows
CF will be able to
At 15:46 2/6/01 -, you wrote:
Hi,
I've been asked to do some modifications for a site which is using MySql as
it's Database, and running CF for Linux. I, locally, am running CF for
Windows and have always used Access - can anyone tell me whether my Windows
CF will be able to connect to the
yes, just download the mysql odbc drivers from www.mysql.com (myodbc)
-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 10:47 AM
To: CF-Talk
Subject: MySql CF?
Hi,
I've been asked to do some modifications for a site which is using MySql
I'm trying to use mySQL instead of MSAcccess on my W2K laptop for CF
development. Is this possible? I've got everything up and running, but I
can't seem to define the datasource in the CF app server. Is it possible?
Any help much appreciated.
Mark
[EMAIL PROTECTED]
yes. you need MyODBC.
"Mark Davies" [EMAIL PROTECTED] wrote:
I'm trying to use mySQL instead of MSAcccess on my W2K laptop for CF
development. Is this possible? I've got everything up and running, but I
can't seem to define the datasource in the CF app server. Is it possible?
Any help much
, inc.
895 E. 13th Ave
Eugene, OR 97401
(541) 346-4331
http://www.uobookstore.com
-Original Message-
From: Mark Davies [mailto:[EMAIL PROTECTED]]
Sent: Sunday, August 13, 2000 8:58 PM
To: [EMAIL PROTECTED]
Subject: RE: [mySQL,cf,W2K: possible?]
thanks, I've got myodbc installed but can you
Anyone using CF and mySQL and accessing BLOB data? I converted an Access2K
db to Mysql and all memo fields were converted to BLOB datatypes. Now when I
pull the information and display it I get ASCII garbage and not the text.
Someone in mySQL support told me to change it to a longvarchar datatype
Anyone using CF and mySQL and accessing BLOB data? I converted an Access2K
db to Mysql and all memo fields were converted to BLOB datatypes. Now when
I
pull the information and display it I get ASCII garbage and not the text.
Someone in mySQL support told me to change it to a longvarchar
65 matches
Mail list logo
