CFCs stop working after call to WebLogic [access denied (java.io.FilePermission]
Our app makes a call to a WebLogic server. Then whether the connection is made or not, all our CFCs stop working. Apps using CFM pages are okay. In 5-10 minutes the servers grinds to a halt as error messages flood in. Immediately following the T3 (WebLogic RMI) call to the WebLogic server, these errors for ColdFusion CFC components come in. There are no errors in CFM files. Error Type=coldfusion.runtime.CfErrorWrapper ERROR TEMPLATE:[directories]/pmn.cfm ERROR DIAGNOSTICS:access denied (java.io.FilePermission [directories]\sqlprev.cfc execute) null brThe error occurred on line -1. error.message = access denied (java.io.FilePermission[directories]\sqlprev.cfc execute) error.rootCause = java.security.AccessControlException: access denied (java.io.FilePermission [directories]\sqlprev.cfc execute) The errors continue until we restart ColdFusion/JRun, then all is okay ... until the next call to WebLogic. Any ideas? thanks, Chris ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352663 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: FCKEditor.. XML Request error: Access denied (403)
This is disabled by default, you need to enable it via a Java System Property, see details here: http://www.petefreitag.com/item/718.cfm -- Pete Freitag - Adobe Community Professional http://foundeo.com/ - ColdFusion Consulting Products http://petefreitag.com/ - My Blog http://hackmycf.com - Is your ColdFusion Server Secure? On Wed, Nov 2, 2011 at 7:40 PM, Terry Troxel terry.tro...@gmail.com wrote: Coldfusion 9, just started has been working fine on all the websites until today when using FCKEditor to browse server for an image. Any Ideas? Java recently Updated. Terry ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348521 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
FCKEditor.. XML Request error: Access denied (403)
Coldfusion 9, just started has been working fine on all the websites until today when using FCKEditor to browse server for an image. Any Ideas? Java recently Updated. Terry ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348423 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ajaxCFC Access Denied
Hello Brad, I donât think SQL injection could happen here because any thing entered will be save on the value field, just like this note that I am typing here. But I will check for any malicious SQL to clear them out. Also this is for an intranet site and not for the world. I did forget to check for quotes on that, thank you for the reminder. Here is the stack trace. I am sure this is happening before the SP is called. In the mean time until I find the reason why this is happening, I will try to move the functionality of the SP to the function of my CFC. Thanks, Brad Stack trace: The system has attempted to use an undefined value, which usually indicates a programming error, either in your code or some system code. Null Pointers are another name for undefined values. The error occurred in C:\Websites\166021ya4\components\baseupdatepkg.cfc: line 35 33:cfprocparam type = IN cfsqltype=cf_sql_varchar value=#arguments.in_column# 34:cfprocparam type = IN cfsqltype=cf_sql_varchar value='#arguments.in_new_value#' 35:cfprocparam type = IN cfsqltype=cf_sql_varchar value=#arguments.in_where# 36:!---cfprocparam type = OUT cfsqltype=cf_sql_varchar variable=results--- 37: Resources: 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/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; GTB6; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729) Remote Address 12.53.250.98 Referrer http://americanforestmanagement.com/admin/intranet/addedit.cfm?ID=6 Date/Time 18-Jun-09 04:11 PM Stack Trace (click to expand) at cfbaseupdatepkg2ecfc150998341$funcUPDATEPKG.runFunction(C:\Websites\166021ya4\components\baseupdatepkg.cfc:35) at cflinkPopUp2ecfm992009946.runPage(C:\Websites\166021ya4\admin\intranet\linkPopUp.cfm:24) java.lang.NullPointerException at org.gjt.mm.mysql.Connection.execSQL(Unknown Source) at org.gjt.mm.mysql.Connection.execSQL(Unknown Source) at org.gjt.mm.mysql.Connection.setTransactionIsolation(Unknown Source) at coldfusion.server.j2ee.sql.JRunConnection.setTransactionIsolation(JRunConnection.java:502) at coldfusion.server.j2ee.sql.JRunConnection.clean(JRunConnection.java:230) at coldfusion.server.j2ee.sql.pool.JDBCPool.returnConnection(JDBCPool.java:816) at coldfusion.server.j2ee.sql.pool.JDBCPool.connectionErrorOccurred(JDBCPool.java:329) at coldfusion.server.j2ee.sql.JRunConnection.sendErrorEvent(JRunConnection.java:320) at coldfusion.server.j2ee.sql.JRunConnection.prepareCall(JRunConnection.java:379) at coldfusion.server.j2ee.sql.JRunConnectionHandle.prepareCall(JRunConnectionHandle.java:80) at coldfusion.sql.Executive.executeCall(Executive.java:797) at coldfusion.sql.Executive.executeCall(Executive.java:775) at coldfusion.sql.Executive.executeCall(Executive.java:726) at coldfusion.sql.SqlImpl.executeCall(SqlImpl.java:445) at coldfusion.tagext.sql.StoredProcTag.executeQuery(StoredProcTag.java:276) at coldfusion.tagext.sql.StoredProcTag.doEndTag(StoredProcTag.java:225) at cfbaseupdatepkg2ecfc150998341$funcUPDATEPKG.runFunction(C:\Websites\166021ya4\components\baseupdatepkg.cfc:35) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:59) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:448) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:308) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2272) at cflinkPopUp2ecfm992009946.runPage(C:\Websites\166021ya4\admin\intranet\linkPopUp.cfm:24) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:273) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:74) at
Re: ajaxCFC Access Denied
Sorry for that!
Hey, I don't know why I didn't see about the mapping thing, that the dots means
the level of the folder.
Still funny, but I was able to make some pages to work after deleting and
uploading the ajax.cfc from the root to the components folder. Still a mistery,
but it's working so far.
I have been looking into my code for another page that is partially working.
The parts that are working are making ajax calls to a function and the function
has a query that executes a SQL command. No big deal. Now, other sections of
the page don't work because I am using a function that calls a SP called
sp_updateBasePKG.
Locally this work, but at the server it gives me the following error:
The system has attempted to use an undefined value, which usually indicates a
programming error, either in your code or some system code.
Null Pointers are another name for undefined values.
You might have seen this error before, and I believe this is what is making my
ajax calls to crash. I notice this error because I have one button that it used
to upload files to the server, well, this button calls the same function that
calls that SP.
Here is the function:
cffunction name=updatePKG returntype=any hint=Generic update
cfargument name=in_table type=any required=false default=
cfargument name=in_column type=any required=false default=
cfargument name=in_new_value type=any required=false default=
cfargument name=in_where type=any required=false default=
cfset var loc = structnew() /
cfstoredproc procedure = sp_updateBasePKG
datasource=#Application.Global.dsn# username=#Application.Global.dsnUN#
password=#Application.Global.dsnPW#
cfprocparam type = IN cfsqltype=cf_sql_varchar
value=#arguments.in_table#
cfprocparam type = IN cfsqltype=cf_sql_varchar
value=#arguments.in_column#
cfprocparam type = IN cfsqltype=cf_sql_varchar
value='#arguments.in_new_value#'
cfprocparam type = IN cfsqltype=cf_sql_varchar
value=#arguments.in_where#
!---cfprocparam type = OUT cfsqltype=cf_sql_varchar variable=results---
/cfstoredproc
!---cfset loc = {
r2 = #results#
} /---
cfreturn 1
/cffunction
I commented out the OUT parameter because that is where I was having the
problem, but now is the one above in_where that is causing the error.
Any thoughts on that?
Thanks again
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323664
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ajaxCFC Access Denied
Did you check to make sure that the stored procedure in your production environment is identical to the one on your dev environment? If I had to guess, I would say that the 5th parameter to your proc (results) is not an OUTPUT parameter. Are you using SQL Server? If so, your procedure should look something like this (Notice the OUTPUT keyword): CREATE PROCEDURE [dbo].[sp_updateBasePKG] @in_table varchar(200), @in_column varchar(200), @in_new_value varchar(200), @in_where varchar(200), @in_results varchar(200) OUTPUT AS BEGIN ... SELECT @in_results = 'Yeah, Success!' END Also, two other thoughts on this: 1) If this proc call is in a webservice which may be called by more than one person simultaneously, it is NOT thread safe. The variable name results is going to be in the variables scope by default. The fact that you are setting it into a locally scoped variable later only slightly mitigates the problem (That block is currently commented out-- for testing I assume). To eliminate concurrency issues, you need to specify a LOCALLY scoped variable for the output of the proc to be placed in like so: cfprocparam type = OUT cfsqltype=cf_sql_varchar variable=loc.results 2) I really, really, really, really, really, really, really, really hope this Generic Update proc does some scrubbing of its inputs and does NOT simply concatenate a SQL string with the table, column, value, and where clause passed in and execute it or you would have just make life really easy for some SQLi hackers. :) ~Brad Original Message Subject: Re: ajaxCFC Access Denied From: David Torres djt...@yahoo.com Date: Thu, June 18, 2009 3:35 pm To: cf-talk cf-talk@houseoffusion.com Locally this work, but at the server it gives me the following error: The system has attempted to use an undefined value, which usually indicates a programming error, either in your code or some system code. Null Pointers are another name for undefined values. I commented out the OUT parameter because that is where I was having the problem, but now is the one above in_where that is causing the error. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323678 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ajaxCFC Access Denied
Hello Brad,
To your questions:
The server uses MySQL. I wish I can use SQL Server. Here is the PROC.
DELIMITER $$
DROP PROCEDURE IF EXISTS `afmcorporate`.`sp_updateBasePKG` $$
CREATE definer=`afmcorpora...@`%` PROCEDURE `sp_updateBasePKG`(
IN in_table VARCHAR(128),
IN in_columnVARCHAR(128),
IN in_new_value VARCHAR(1000),
IN in_where VARCHAR(4000))
OUT results VARCHAR(3000))
BEGIN
DECLARE l_sql VARCHAR(4000);
SET l_sql=CONCAT_ws(' ',
'UPDATE',in_table,
'SET',in_column,'=',in_new_value,
'WHERE',in_where);
select l_sql as results;
set results = l_sql;
SET @sql=l_sql;
PREPARE s1 FROM @sql;
EXECUTE s1;
DEALLOCATE PREPARE s1;
END $$
DELIMITER ;
This is not a webservice, and even if it is, I donât need to have the output
result. I was using it as a way to check my SQL.
There will no be a way for hackers to do any SQL injections because the way
this work is that users type something on a text box and that will be used as
the value to be inserted on the DB e.g.
âUpdate â + âfrom table that they can not typeâ +
âSET â + âthis field that they can not type neitherâ +
â = â + âvalue entered by userâ +
âWHERE â + âfrom this field that they can not type neitherâ + â=â +
âfrom this field that they can not type neitherâ
I am sending all the necessary values for the table, fields, except for the
value that will be updated.
So, I donât see any harm there, but if you see something let me know.
Finally I did fail to mention last time; the CFfunction is the one crashing..
It doesnât get to SP yet.
I commented the OUT cfprocparam because it was complaining there, after I
commented out that parameter, it started complaining about the one above.
Any thoughts?
Thanks
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323681
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ajaxCFC Access Denied
Hmmm, can you confirm for certain if the error is happening before or after the proc gets called? Can you provide us with a stack trace of where the error happened? Also, is this the null pointer error or are you still having that permissions denied one you started the thread with? As far as the SQLi, you know your app best so we'll let you decide what is safe. I guess I would ask myself two main questions: 1) Where are the table, column, and where clause inputs originating from? The client, or the server? Also, is there any way that cookie, form, url, or cgi variables could affect them? 2) What happens when you user enters a string with a single quote in it or an escaped quote? SQL concatenation can be dangerous if not cleaned properly. Since you are on MySQL, here some semi-random articles you might find interesting: http://www.codersrevolution.com/index.cfm/2008/7/13/Just-when-you-felt-safe-SQL-Injection-and-MySQL http://www.codersrevolution.com/index.cfm/2008/8/17/Disabling-MySQLs-Backslash-Escaping-Per-Data-Source ~Brad Original Message Subject: Re: ajaxCFC Access Denied From: David Torres djt...@yahoo.com Date: Thu, June 18, 2009 5:03 pm To: cf-talk cf-talk@houseoffusion.com Hello Brad, To your questions: The server uses MySQL. I wish I can use SQL Server. Here is the PROC. DELIMITER $$ This is not a webservice, and even if it is, I donât need to have the output result. I was using it as a way to check my SQL. There will no be a way for hackers to do any SQL injections because the way this work is that users type something on a text box and that will be used as the value to be inserted on the DB e.g. Finally I did fail to mention last time; the CFfunction is the one crashing.. It doesnât get to SP yet. I commented the OUT cfprocparam because it was complaining there, after I commented out that parameter, it started complaining about the one above. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323684 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ajaxCFC Access Denied
I had created some new CFCs for this enhancement. Do you know if this new CFCs need to be some how register in order to work on the server? By the way this is not my production server. It is host by hostmysite. Thanks, David What Charlie pointed out was simply a syntax issue separate from what appears to be a permissions problem. Your error seems to be that ColdFusion does not have read access to the web-inf directory. What user is ColdFusion running under? If CF starts with Windows as a service, a user can be specified for that service. The default with windows is System. If this is your production server, I would recommend creating a special user for CF to run as which is NOT an administrator for security's sake. That user will need access to the web-inf directory among other things. BTW: component.cfc is the base object that all components inherit from. Here is a knowledge base article on the subject: http://kb2.adobe.com/cps/172/tn_17279.html ~Brad Thank you for replying, I made the change: cffunction name=setPermUser returntype=any hint=Set User Permission access=remote Still the same error. David ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323575 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: ajaxCFC Access Denied
In order to be invoked, your CFC's need to be in the same directory of the calling page, or in a folder specified in ColdFusion Administrator as a mapping, the web root, or a custom tag path. (http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=buildingComponents_27.html Specifying the CFC location) For instance, if you created a mapping in the Admin called /hereBeDragons and it pointed to c:\someDirectory and in someDirectory you had a file called Elliot.cfc then you could create an instance of that CFC anywhere in your app as petesDragon = createObject(component,hereBeDragons.Elliot) You're skipping aroud a lot, so it's hard to help you. Are you using shared hosting? A VPS? Do you have access to the CF administrator web interface? Are you still getting your Access denied(java.io.filepermission C:\coldfusion8\wwwroot\web-inf\cftags\componet.cfc read) error?? Did you copy that error message exactly, because the actual file name is component.cfc? The code you posted earlier looked like so: createObject(component, components.site_user) Do you have a folder called components in your web root, or a folder called components in one of your custom tag paths, or a ColdFusion mapping called components? That will be a good start. Take things one step at a time and tell us what errors you are getting. If all of this code worked on your development environment, chances are you just are missing some mapping on your production server. ~Brad Original Message Subject: Re: ajaxCFC Access Denied From: David Torres djt...@yahoo.com Date: Wed, June 17, 2009 9:51 am To: cf-talk cf-talk@houseoffusion.com I had created some new CFCs for this enhancement. Do you know if this new CFCs need to be some how register in order to work on the server? By the way this is not my production server. It is host by hostmysite. Thanks, David What Charlie pointed out was simply a syntax issue separate from what appears to be a permissions problem. Your error seems to be that ColdFusion does not have read access to the web-inf directory. What user is ColdFusion running under? If CF starts with Windows as a service, a user can be specified for that service. The default with windows is System. If this is your production server, I would recommend creating a special user for CF to run as which is NOT an administrator for security's sake. That user will need access to the web-inf directory among other things. BTW: component.cfc is the base object that all components inherit from. Here is a knowledge base article on the subject: http://kb2.adobe.com/cps/172/tn_17279.html ~Brad Thank you for replying, I made the change: cffunction name=setPermUser returntype=any hint=Set User Permission access=remote Still the same error. David ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323586 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ajaxCFC Access Denied
OK, something weird is happing here. I did not reply to your question earlier
because things seemed to start working. I made some changes to some of my logic
in one my CFC and CFC file, and now that page is giving me the same error again.
To answer your questions:
Are you using shared hosting? Yes
A VPS? No
Do you have access to the CF administrator web interface? Yes
Are you still getting your Access deniedâ¦â? Yes
Do you have a folder called components in your web root? Yes
Here is the summary of the scenario:
There is a page called â/admin/permmanage/list.cfmâ that list users.
Some code from this page:
form action=ManagePerm.cfm name=frmList
!--- get Permissions ---
CFOBJECT COMPONENT=components.permissions NAME=oPermissions
cfinvoke component = #oPermissions# method = getSiteUsers
returnVariable = qrySiteUsers
cfset variables.qryAll = qrySiteUsers
â¦.more codeâ¦.
/form
This page is creating the CFC object and grabs the component to return the
result that fills the page.
You select one or many users, and after you click âManage Permissionsâ it
take you to a page called â/admin/permmanage/ManagePerm.cfmâ
Some code from this page:
!---Retrieve Information---
cfif IsDefined(Cookie.userIDs) is True
cfset variables.user = Cookie.userIDs
cfset variables.userName = Cookie.userName
!---The Cookie.userIDs if it has more than one ID selected will be like this
52,23,66---
!---If that is the case the system will try to update all the users selected
with the same value perm ---
cfif find(,,variables.user) GT 0
cfset variables.qryPerm = permissions.getPermission()
cfelse
cfset variables.qryPerm = permissions.getPermUser(userID=user)
/cfif---
CFOBJECT COMPONENT=components.permissions NAME=oPermissions
cfif find(,,variables.user) GT 0
cfinvoke component = #oPermissions# method = getPermUser
returnVariable = qryPermission
cfelse
cfinvoke component = #oPermissions# method = getPermUser
returnVariable = qryPermission
CFINVOKEARGUMENT NAME=userID VALUE=#user#
/CFINVOKE
/cfif
cfset variables.qryPerm = qryPermission
/cfif
script type=text/javascript
function setPerm(val,pos) {
// send data to CF
var sUserID=getCookie('userIDs');
if (val == '') val='0';
DWRUtil.useLoadingMessage();
DWREngine._execute('/components/permissions.cfc', null, 'setPermUser',
sUserID, pos, val, results);
}
// call back function
function results (r) {
var loadingMessage = 'Permission updated!';
$('divMessage').innerHTML = loadingMessage;
}
/script
â¦.some html code here
tbody
cfoutput query=variables.qryPerm
tr cfif variables.qryPerm.CurrentRow MOD 2class=odd/cfif
tdselect id=opt#variables.qryPerm.Position# style=font-family:
Arial; font-size: 7pt; changed=0
onchange=setPerm(this.value,#variables.qryPerm.Position#); FlagChange(this);
onclick=javascript:if(getElementById('msgResult')){getElementById('msgResult').innerHTML='';}
option value=Select/option
option value=0 cfif 0 IS
variables.qryPerm.permvalselected/cfifNone/option
option value=1 cfif 1 IS
variables.qryPerm.permvalselected/cfifView/option
option value=2 cfif 2 IS
variables.qryPerm.permvalselected/cfifFull/option
/select
/td
td align=left valign=top#variables.qryPerm.ItemName#/td
td align=center valign=top#variables.qryPerm.Position#/td
td align=center valign=top#variables.qryPerm.Description#/td
td align=center valign=top#variables.qryPerm.pagename#/td
td align=centera href=../permItems/add.cfm?permID=#variables.qryPerm.ID#
img src=../images/structure/edit-icon.gif alt=Edit border=0 width=15
height=16 //a/td
/tr
/cfoutput
/tbody
I know is a mess displaying code this way, thatâs why I didnât want to put
code here yet.
Anyway, as I was saying once that you select the user it will take to the page
âManagePerm.cfmâ. On this page you will see all the permissions available.
Each row has a drop-down with the values âselect, none, view, and fullâ On
the onChange event of the drop-down and event is fired, âsetPermâ. This
function makes an ajax call, that will send the value, the id, and the position
of the permission to be updated on the server. There is when I get that error.
Like I said, earlier this morning I modified the CFC and move the ajax.cfc to
the root and it started working. The authors of AjaxCFC say the following about
extending the ajax.cfc:
Extending ajax.cfc
To create ajax listeners you will need to extend ajax.cfc.
For example:
cfcomponent extends=ajax
cffunction name=echo output=no access=private
cfargument name=str required=Yes type=string cfreturn arguments.str /
/cffunction
/cfcomponent
If you decide to store ajax.cfc in a different
RE: ajaxCFC Access Denied
Wow, I'm not sure where to start. I guess I'll start by saying the whole cf.mapping.to.ajax string is NOT what you should actually be typing into your code unless you have an ajax folder in a to folder in a mapping folder in a cf folder in your webroot. (not likely) When the AjaxCFC documentation said that, they intended for you to replace the text cf.mapping.to.ajax with the actual honest-go-goodness path on your specific server. The path to a CFC is simply a period delimited list of directories starting in your web root, a mapping, or a custom tag path. If the ajax.cfc file is in the same directory as the CFC's that are extending it, then you don't need the dot delimited path. If the ajax.cfc file is anywhere else, you need to create the period delimited path to the file based on WHERE IT IS ON YOUR SERVER. From your posts, I'm not sure where you have the ajax.cfc file, but if it was off the web root in a folder called geeILikeIceCream then you would do this in your webservice: cfcomponent name=myMagicalAjaxWebService extends=geeILikeIceCream.ajax As far as your permission denied error, I don't think that has anything to do with your cfm files, what your objects do, the flow of your application, or the weather outside. Like I said in my initial reply, you need to do two things: 1) Confirm the windows user your ColdFusion service is running as 2) Grant Read rights for that user to the web-inf directory that was referenced by the error message. Until you do that, it is mostly a waste of time to talk about how the app works. If you are saying that some of your ajax calls work, but others produce that permission error, then I don't know what to tell you without knowing more information. If you can't create an instance of your component and call a method with cfinvoke (which is what AjaxCFC does) without getting that permissions denied on component.cfc then you definitely need to fix permissions. I have a suspicion that there are some other errors at play, but we will need more info than knowing that your server barked at you to help. Have you looked into AjaxCFC's logging feature to catch what errors are happening on the server side. Also, use Fiddler or FireBug to get the actual HTTP request of your Ajax calls and run them by themselves in a new browser window. If a bunch of Javasciprt is output it is probably working, otherwise you should see the error. Good Look. ~Brad Original Message Subject: Re: ajaxCFC Access Denied From: David Torres djt...@yahoo.com Date: Wed, June 17, 2009 4:15 pm To: cf-talk cf-talk@houseoffusion.com OK, something weird is happing here. I did not reply to your question earlier because things seemed to start working. I made some changes to some of my logic in one my CFC and CFC file, and now that page is giving me the same error again. To answer your questions: Are you using shared hosting? Yes A VPS? No Do you have access to the CF administrator web interface? Yes Are you still getting your Access deniedâ¦â? Yes Do you have a folder called components in your web root? Yes ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323614 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
ajaxCFC Access Denied
Hello, I have worked on a web app on my computer using AjaxCFC. All is working as desired and now is time to move it to production. When I started going over my changes in production, I have the following error: Access denied(java.io.filepermission C:\coldfusion8\wwwroot\web-inf\cftags\componet.cfc read) I moved the ajax.cfc from the root folder to the component folder where all my other components are, and it worked for a moment. Then I continued testing other parts of my project, and I've got the same error again. My components start with something like this: cfcomponent displayname=Intranet Section extends=ajax access=remote Does anybody has had this error before? Thanks, David ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323559 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Access Denied AjaxCFC
Hello, I have worked on a web app on my computer using AjaxCFC. All is working as desired and now is time to move it to production. When I started going over my changes in production, I have the following error: Access denied(java.io.filepermission C:\coldfusion8\wwwroot\web-inf\cftags\componet.cfc read) I moved the ajax.cfc from the root folder to the component folder where all my other components are, and it worked for a moment. Then I continued testing other parts of my project, and I've got the same error again. My components start with something like this: cfcomponent displayname=Intranet Section extends=ajax access=remote Does anybody has had this error before? Thanks, David ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323560 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ajaxCFC Access Denied
Please disregard this duplicate message. I was having an error posting this message many times. David Hello, I have worked on a web app on my computer using AjaxCFC. All is working as desired and now is time to move it to production. When I started going over my changes in production, I have the following error: Access denied(java.io.filepermission C:\coldfusion8\wwwroot\web-inf\cftags\componet.cfc read) I moved the ajax.cfc from the root folder to the component folder where all my other components are, and it worked for a moment. Then I continued testing other parts of my project, and I've got the same error again. My components start with something like this: cfcomponent displayname=Intranet Section extends=ajax access=remote Does anybody has had this error before? Thanks, David ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323561 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ajaxCFC Access Denied
On Tue, Jun 16, 2009 at 3:11 PM, David Torres djt...@yahoo.com wrote: Hello, I have worked on a web app on my computer using AjaxCFC. All is working as desired and now is time to move it to production. When I started going over my changes in production, I have the following error: Access denied(java.io.filepermission C:\coldfusion8\wwwroot\web-inf\cftags\componet.cfc read) I moved the ajax.cfc from the root folder to the component folder where all my other components are, and it worked for a moment. Then I continued testing other parts of my project, and I've got the same error again. My components start with something like this: cfcomponent displayname=Intranet Section extends=ajax access=remote The access=remote should be in the cffunction tag, not the cfcomponent tag? -- I have failed as much as I have succeeded. But I love my life. I love my wife. And I wish you my kind of success. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323562 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ajaxCFC Access Denied
Thank you for replying, I made the change: cffunction name=setPermUser returntype=any hint=Set User Permission access=remote Still the same error. David The access=remote should be in the cffunction tag, not the cfcomponent tag? -- I have failed as much as I have succeeded. But I love my life. I love my wife. And I wish you my kind of success. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323563 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ajaxCFC Access Denied
What Charlie pointed out was simply a syntax issue separate from what appears to be a permissions problem. Your error seems to be that ColdFusion does not have read access to the web-inf directory. What user is ColdFusion running under? If CF starts with Windows as a service, a user can be specified for that service. The default with windows is System. If this is your production server, I would recommend creating a special user for CF to run as which is NOT an administrator for security's sake. That user will need access to the web-inf directory among other things. BTW: component.cfc is the base object that all components inherit from. Here is a knowledge base article on the subject: http://kb2.adobe.com/cps/172/tn_17279.html ~Brad Original Message Subject: Re: ajaxCFC Access Denied From: David Torres djt...@yahoo.com Date: Tue, June 16, 2009 5:21 pm To: cf-talk cf-talk@houseoffusion.com Thank you for replying, I made the change: cffunction name=setPermUser returntype=any hint=Set User Permission access=remote Still the same error. David ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323564 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ajaxCFC Access Denied
Hi Brad, My app have five tabs, all my tabs are running OK except when it needs to make an ajax call. My application.cfc was instantiating my new components, but I took that section out of there because ajaxcfc don't like that e.g: cfset application.site_user = createObject(component, components.site_user).init(Application.Global.dsn,Application.Global.dsnUN,Application.Global.dsnPW,Application.Global.file_path) !---cfset application.permissions = createObject component, components.permissions)--- Now I created the object on the cfm page that needs that component. Now, the things that you mentioned I donât know if relate to this as well. Two of the original tabs are still working, but my new other tabs work too until I made an ajax call. I will look into the things that you say. David What Charlie pointed out was simply a syntax issue separate from what appears to be a permissions problem. Your error seems to be that ColdFusion does not have read access to the web-inf directory. What user is ColdFusion running under? If CF starts with Windows as a service, a user can be specified for that service. The default with windows is System. If this is your production server, I would recommend creating a special user for CF to run as which is NOT an administrator for security's sake. That user will need access to the web-inf directory among other things. BTW: component.cfc is the base object that all components inherit from. Here is a knowledge base article on the subject: http://kb2.adobe.com/cps/172/tn_17279.html ~Brad Thank you for replying, I made the change: cffunction name=setPermUser returntype=any hint=Set User Permission access=remote Still the same error. David ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323565 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: HTTP401.2 - Access denied by ACL on resource
While it is a bit extreme, I would give Everyone full control on the folder where the docs resides. Short of that try giving the account that the CF services run under full control. I remember that there are a couple of wierdnesses when you run IIS 5 on XP. You might want to put the docs on a 2003 Server machine. Nick Stein ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313427 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
HTTP401.2 - Access denied by ACL on resource
Unfortunately I have to maintain a couple of archaic ColdFusion 4.5 servers for the next couple of years. Luckily all our new development is going on bright and shiny new ColdFusion 8 Enterprise servers. But it will be quite some time before many older programs are migrated. That being said. I got tired of searching the internet every time I need to check if something I wanted to do was available on version 4.5. Thus, I went out and got a copy of the 4.5 documentation from the Adobe nee Macromedia nee Allaire archives. I can access this content from my local hard drive. But since it is expected to be running on a web site the formatting and linking is just a bit off. This is just annoying enough that I figured I'd drop it into my development web server. This is where this error comes in. Whenever I try to access the ColdFusion 4.5 documentation through a browser with my http://localhost/cfdocs/ url, I get this 401.3 Access denied error. My attempts at Googling information on this issue has not turned up anything that seems to apply to my situation. I have no strange or missing file permissions as best as I can tell. The website in my IIS management console is configured with anonymous access. Can anybody point me to something useful. Is it just not possible to run the 4.5 cfdocs 'web app' on a developer CF 8/IIS 5.1/Windows XP configuration. That would be weird to me! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313408 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Access Denied trying to build coldfusion archive (CAR)
Of course not, and why should it? Shoot, I misspoke in my original email. The path I gave for the archive was C:\temp\archive.car And CF *DOES* have permission to write to C:\temp What I don't understand is why it is trying to write to E:\dsns_and_stuff.car and then C:\dsns_and_stuff.car since those aren't the paths nor the file names I've requested it to use. I suppose I could give CF permission to the C:\ drive in order to get this to work but that's pretty retarded if that's what I *HAVE* to do. Rick On Tue, Apr 29, 2008 at 4:11 PM, Chris Norloff [EMAIL PROTECTED] wrote: I don't know about the name itself, but does CF have rights to write in the root of C:\ ? Chris -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 29, 2008 3:45 PM To: CF-Talk Subject: Access Denied trying to build coldfusion archive (CAR) so I'm stumped. My server will not build a CAR archive. I've created an archive definition called dsns_and_stuff to it, I've added DSNs (duh) and mappings. When I try to build it, I give a path like C:\archive.car The build process errors, giving access denied errors on the following: E:\dsns_and_stuff.car C:\dsns_and_stuff.car Why is it doing that? I didn't tell it to save it as that, I said C:\archive.car Anyone know what's going on here? coldfusion 8, Windows. CF8 is running as a local user account (coldfusion) rather than SYSTEM. -- Rick Root New Brian Vander Ark Album, songs in the music player and cool behind the scenes video at www.myspace.com/brianvanderark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304473 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Access Denied trying to build coldfusion archive (CAR)
As long as CF has rights to write where you specify, you're okay. I usually put the .car files in the logs directory. I don't know why the archiving function would be throwing errors like you got. It can be pretty tempermental; it works on some of my systems and doesn't work on others. Internet Exploder works better than Firefox sometimes, you can try that. If that doesn't work, I get the admin settings by copying all the neo*.xml config files. Chris -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 30, 2008 8:55 AM To: CF-Talk Subject: Re: Access Denied trying to build coldfusion archive (CAR) Of course not, and why should it? Shoot, I misspoke in my original email. The path I gave for the archive was C:\temp\archive.car And CF *DOES* have permission to write to C:\temp What I don't understand is why it is trying to write to E:\dsns_and_stuff.car and then C:\dsns_and_stuff.car since those aren't the paths nor the file names I've requested it to use. I suppose I could give CF permission to the C:\ drive in order to get this to work but that's pretty retarded if that's what I *HAVE* to do. Rick On Tue, Apr 29, 2008 at 4:11 PM, Chris Norloff [EMAIL PROTECTED] wrote: I don't know about the name itself, but does CF have rights to write in the root of C:\ ? Chris -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 29, 2008 3:45 PM To: CF-Talk Subject: Access Denied trying to build coldfusion archive (CAR) so I'm stumped. My server will not build a CAR archive. I've created an archive definition called dsns_and_stuff to it, I've added DSNs (duh) and mappings. When I try to build it, I give a path like C:\archive.car The build process errors, giving access denied errors on the following: E:\dsns_and_stuff.car C:\dsns_and_stuff.car Why is it doing that? I didn't tell it to save it as that, I said C:\archive.car Anyone know what's going on here? coldfusion 8, Windows. CF8 is running as a local user account (coldfusion) rather than SYSTEM. -- Rick Root New Brian Vander Ark Album, songs in the music player and cool behind the scenes video at www.myspace.com/brianvanderark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304490 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Access Denied trying to build coldfusion archive (CAR)
so I'm stumped. My server will not build a CAR archive. I've created an archive definition called dsns_and_stuff to it, I've added DSNs (duh) and mappings. When I try to build it, I give a path like C:\archive.car The build process errors, giving access denied errors on the following: E:\dsns_and_stuff.car C:\dsns_and_stuff.car Why is it doing that? I didn't tell it to save it as that, I said C:\archive.car Anyone know what's going on here? coldfusion 8, Windows. CF8 is running as a local user account (coldfusion) rather than SYSTEM. -- Rick Root New Brian Vander Ark Album, songs in the music player and cool behind the scenes video at www.myspace.com/brianvanderark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304424 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Access Denied trying to build coldfusion archive (CAR)
I don't know about the name itself, but does CF have rights to write in the root of C:\ ? Chris -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 29, 2008 3:45 PM To: CF-Talk Subject: Access Denied trying to build coldfusion archive (CAR) so I'm stumped. My server will not build a CAR archive. I've created an archive definition called dsns_and_stuff to it, I've added DSNs (duh) and mappings. When I try to build it, I give a path like C:\archive.car The build process errors, giving access denied errors on the following: E:\dsns_and_stuff.car C:\dsns_and_stuff.car Why is it doing that? I didn't tell it to save it as that, I said C:\archive.car Anyone know what's going on here? coldfusion 8, Windows. CF8 is running as a local user account (coldfusion) rather than SYSTEM. -- Rick Root New Brian Vander Ark Album, songs in the music player and cool behind the scenes video at www.myspace.com/brianvanderark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304425 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Error: access denied (java.net.SocketPermission localhost:1024- listen,resolve)
I am trying to use the com.sun.jndi.dns.DnsContextFactory to check whether a DNS MX record exists, but I get this error when I run the code in a CF sandbox: Error: access denied (java.net.SocketPermission localhost:1024- listen,resolve) Even if I set up a sandbox with no special restrictions, it still fails. The code works fine outside of a sandbox. Any ideas? Thank you, Mike Chabot Mike - I'm getting an identical error message trying to use cfftp to send a txt file to a client. I didn't see any responses to your post. Were you ever able to resolve the problem? Thanks. Michael ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283755 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Error: access denied (java.net.SocketPermission localhost:1024- listen,resolve)
I don't remember if I found the answer to the question. It turned out that the firewall was set up to block every outbound request for security reasons and I had to abandon the code. You might want to see if the problem is with a firewall instead of with ColdFusion. -Mike Chabot On 7/16/07, Michael Falk [EMAIL PROTECTED] wrote: I am trying to use the com.sun.jndi.dns.DnsContextFactory to check whether a DNS MX record exists, but I get this error when I run the code in a CF sandbox: Error: access denied (java.net.SocketPermission localhost:1024- listen,resolve) Even if I set up a sandbox with no special restrictions, it still fails. The code works fine outside of a sandbox. Any ideas? Thank you, Mike Chabot Mike - I'm getting an identical error message trying to use cfftp to send a txt file to a client. I didn't see any responses to your post. Were you ever able to resolve the problem? Thanks. Michael ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283806 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Access denied
On one of our CFMx7 enterprise servers, we have in the last 6 months or so started getting access denied Coldfusion errors. This is caused by the fact that we use sandboxing, and if the client enables session variables in their application.cfm, then the entire site is denied access to itself. The solution is to create a sandbox for the site, and the problem goes away. But I am at a loss as to why a sandbox is required just to use session variables. This never used to be the case on any other server or on this one, and a sandbox was only required to use disabled tags. Can anyone shed any light on this ? It is rather anoying having to create a sandbox for every site that doesn't really need one. Russ ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265186 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Error: access denied (java.net.SocketPermission localhost:1024- listen,resolve)
I am trying to use the com.sun.jndi.dns.DnsContextFactory to check whether a DNS MX record exists, but I get this error when I run the code in a CF sandbox: Error: access denied (java.net.SocketPermission localhost:1024- listen,resolve) Even if I set up a sandbox with no special restrictions, it still fails. The code works fine outside of a sandbox. Any ideas? Thank you, Mike Chabot ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260345 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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 authentication mechanism so username/passwords don't flyjust use without the user/pass. Actually, it's a 3.23.x series driver. And you're fine if you're using MySQL 4.1.0 -- the auth mechanism changed in 4.1.1. Running without a password is really a poor choice, especially when there are a number of more sensible options: 1) Use the oldpassword option in your my.ini or pass as a command line parameter at startup 2) Use the OLD_PASSWORD() function on the password for the user defined in the CFMX datasource, which will generate a hash that the MySQL 3.23.x driver that ships with ColdFusion understands 3) Use the MySQL 4.1.x series driver as an Other datasource in CFMX, which you'll *have* to do to get access to the 4.1 and 5.0 branch-specific functionality. You can also dload the newer JDBC driver for 4.x and up at mysql.orghttp://mysql.orgor .com or wherever the home of that miserable excuse for a database is (no I'm not jaded at all...hehe) ;-) How's this significantly different from the whole Windows vs SQL Server login difference with MS-SQL? Other than the fact that you've had to know the difference between those two types of logins for so long to get CF-MSSQL datasources to work that it's second nature by now :) HTH Cheers 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 http://www.electricedgesystems.com - Original 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 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 reason that is what's throwing it off. I have a bunch of apps running remotely on CF/MySQL, and I am trying to move from MS Access to MySQL locally, so I'd like to be able to do that without rewriting all the code, or dealing with the commenting workaround you suggested. Is there some rule against a localhost user other than root connecting to MySQL? I am no expert so I might be missing something really obvious, but this also stumped my trusty web host who is something of a CF guru. I emailed him my MySQL user and db tables and he couldn't find anything wrong that would be causing the error. - Original Message - From: dave [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 and password it doesn't have and getting the warning. Not sure how others do it but in my Application.cfm or cfc (shut it will) I set 2 sets of connection variable, 1 live and 1 local and just comment out the one i dont need at the time. like !--- comment out cause we are in local setting !--- set live connection --- cfset application.dsn = myconnection cfset username = jack cfset password = smack --- !--- set local connection -- cfset application.dsn = myconnection cfset username = cfset password = ~Dave the disruptor~ Some people just don't appreciate how difficult it is to dispense wisdom and abuse at the same time. From: Josh Nathanson [EMAIL PROTECTED] Sent: Saturday, August 27, 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 able to create the datasource fine if I don't use a password, so I know the issue is not caused by incorrect privileges in the mysql.user or mysql.db tables. Also if I do set up the datasource without a password, and try to use a password in a cfquery, I get the same error. My platform: Windows XP SP2/CFMX 6.1/MySQL 4.1 Thanks for any assistance! ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216754 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http
SOLVED Re: MySQL - CF: Access Denied when using password
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. - Original Message - From: John Paul 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 authentication mechanism so username/passwords don't flyjust use without the user/pass. Actually, it's a 3.23.x series driver. And you're fine if you're using MySQL 4.1.0 -- the auth mechanism changed in 4.1.1. Running without a password is really a poor choice, especially when there are a number of more sensible options: 1) Use the oldpassword option in your my.ini or pass as a command line parameter at startup 2) Use the OLD_PASSWORD() function on the password for the user defined in the CFMX datasource, which will generate a hash that the MySQL 3.23.x driver that ships with ColdFusion understands 3) Use the MySQL 4.1.x series driver as an Other datasource in CFMX, which you'll *have* to do to get access to the 4.1 and 5.0 branch-specific functionality. You can also dload the newer JDBC driver for 4.x and up at mysql.orghttp://mysql.orgor .com or wherever the home of that miserable excuse for a database is (no I'm not jaded at all...hehe) ;-) How's this significantly different from the whole Windows vs SQL Server login difference with MS-SQL? Other than the fact that you've had to know the difference between those two types of logins for so long to get CF-MSSQL datasources to work that it's second nature by now :) HTH Cheers 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 http://www.electricedgesystems.com - Original 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 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 reason that is what's throwing it off. I have a bunch of apps running remotely on CF/MySQL, and I am trying to move from MS Access to MySQL locally, so I'd like to be able to do that without rewriting all the code, or dealing with the commenting workaround you suggested. Is there some rule against a localhost user other than root connecting to MySQL? I am no expert so I might be missing something really obvious, but this also stumped my trusty web host who is something of a CF guru. I emailed him my MySQL user and db tables and he couldn't find anything wrong that would be causing the error. - Original Message - From: dave [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 and password it doesn't have and getting the warning. Not sure how others do it but in my Application.cfm or cfc (shut it will) I set 2 sets of connection variable, 1 live and 1 local and just comment out the one i dont need at the time. like !--- comment out cause we are in local setting !--- set live connection --- cfset application.dsn = myconnection cfset username = jack cfset password = smack --- !--- set local connection -- cfset application.dsn = myconnection cfset username = cfset password = ~Dave the disruptor~ Some people just don't appreciate how difficult it is to dispense wisdom and abuse at the same time. From: Josh Nathanson [EMAIL PROTECTED] Sent: Saturday, August 27, 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 able to create the datasource fine if I don't use a password, so I know the issue is not caused by incorrect privileges in the mysql.user or mysql.db tables. Also if I do set up the datasource without a password, and try to use a password in a cfquery, I get the same error. My
Re: SOLVED Re: MySQL - CF: Access Denied when using password
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 the datasource, but then all queries using CFQUERYPARAM then fail to retrieve any data.remove the CFQUERYPARAM and then data is retrievednot exactly a great solution on my end. Anybody run into that one? Thankfully this project will end up on MS SQL Server ;-) 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 ~| 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 Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216793 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SOLVED Re: MySQL - CF: Access Denied when using password
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 (that we can depend on) and if everyone would stop using ms junk for a few weeks maybe it would force them to build a decent os to run it on. I'd rather leave the worms for fishing, thanx.. Rock on MySQL ;-) ~Dave the disruptor~ Some people just don't appreciate how difficult 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 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 the datasource, but then all queries using CFQUERYPARAM then fail to retrieve any data.remove the CFQUERYPARAM and then data is retrievednot exactly a great solution on my end. Anybody run into that one? Thankfully this project will end up on MS SQL Server ;-) 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 ~| 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 Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216803 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SOLVED Re: MySQL - CF: Access Denied when using password
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 (that we can depend on) and if everyone would stop using ms junk for a few weeks maybe it would force them to build a decent os to run it on. I'd rather leave the worms for fishing, thanx.. Rock on MySQL ;-) ~Dave the disruptor~ Check the archives for my very valid issues with MySQL (*ahem* allowing NULLs in NOT NULL fields for starters).as for MS SQL Server...it has never let me down...always worked as advertised (not that I like M$ in the least) That's it from me on the subject... Cheers 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 ~| 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 Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216810 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SOLVED Re: MySQL - CF: Access Denied when using password
i was just messin with ya man ;) you were askin 4 it on another thread but i didnt have time to get ya!!! haha ok so lets be neutral and change the line too: hopefully it will be on postgresql soon.. ~Dave the disruptor~ Some people just don't appreciate how difficult 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 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 (that we can depend on) and if everyone would stop using ms junk for a few weeks maybe it would force them to build a decent os to run it on. I'd rather leave the worms for fishing, thanx.. Rock on MySQL ;-) ~Dave the disruptor~ Check the archives for my very valid issues with MySQL (*ahem* allowing NULLs in NOT NULL fields for starters).as for MS SQL Server...it has never let me down...always worked as advertised (not that I like M$ in the least) That's it from me on the subject... Cheers 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 ~| 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 Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216812 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SOLVED Re: MySQL - CF: Access Denied when using password
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 ~| 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 Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216827 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SOLVED Re: MySQL - CF: Access Denied when using password
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. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216933 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
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 and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216940 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SOLVED Re: MySQL - CF: Access Denied when using password
well i see the Blue Bus has arrived! ~Dave the disruptor~ Some people just don't appreciate how difficult it is to dispense wisdom and abuse at the same time. From: Will Tomlinson [EMAIL PROTECTED] Sent: Tuesday, August 30, 2005 9:54 PM To: CF-Talk cf-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 and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216942 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL - CF: Access Denied when using password
CF 7 comes with a MySQL 3.1 driverif you're using 4.1, there is a different authentication mechanism so username/passwords don't flyjust use without the user/pass. You can also dload the newer JDBC driver for 4.x and up at mysql.org or .com or wherever the home of that miserable excuse for a database is (no I'm not jaded at all...hehe) ;-) HTH Cheers 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 - Original 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 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 reason that is what's throwing it off. I have a bunch of apps running remotely on CF/MySQL, and I am trying to move from MS Access to MySQL locally, so I'd like to be able to do that without rewriting all the code, or dealing with the commenting workaround you suggested. Is there some rule against a localhost user other than root connecting to MySQL? I am no expert so I might be missing something really obvious, but this also stumped my trusty web host who is something of a CF guru. I emailed him my MySQL user and db tables and he couldn't find anything wrong that would be causing the error. - Original Message - From: dave [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 and password it doesn't have and getting the warning. Not sure how others do it but in my Application.cfm or cfc (shut it will) I set 2 sets of connection variable, 1 live and 1 local and just comment out the one i dont need at the time. like !--- comment out cause we are in local setting !--- set live connection --- cfset application.dsn = myconnection cfset username = jack cfset password = smack --- !--- set local connection -- cfset application.dsn = myconnection cfset username = cfset password = ~Dave the disruptor~ Some people just don't appreciate how difficult it is to dispense wisdom and abuse at the same time. From: Josh Nathanson [EMAIL PROTECTED] Sent: Saturday, August 27, 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 able to create the datasource fine if I don't use a password, so I know the issue is not caused by incorrect privileges in the mysql.user or mysql.db tables. Also if I do set up the datasource without a password, and try to use a password in a cfquery, I get the same error. My platform: Windows XP SP2/CFMX 6.1/MySQL 4.1 Thanks for any assistance! ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216670 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: MySQL - CF: Access Denied when using password
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 using 4.1, there is a different authentication mechanism so username/passwords don't flyjust use without the user/pass. You can also dload the newer JDBC driver for 4.x and up at mysql.org or .com or wherever the home of that miserable excuse for a database is (no I'm not jaded at all...hehe) ;-) HTH Cheers 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 - Original 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 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 reason that is what's throwing it off. I have a bunch of apps running remotely on CF/MySQL, and I am trying to move from MS Access to MySQL locally, so I'd like to be able to do that without rewriting all the code, or dealing with the commenting workaround you suggested. Is there some rule against a localhost user other than root connecting to MySQL? I am no expert so I might be missing something really obvious, but this also stumped my trusty web host who is something of a CF guru. I emailed him my MySQL user and db tables and he couldn't find anything wrong that would be causing the error. - Original Message - From: dave [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 and password it doesn't have and getting the warning. Not sure how others do it but in my Application.cfm or cfc (shut it will) I set 2 sets of connection variable, 1 live and 1 local and just comment out the one i dont need at the time. like !--- comment out cause we are in local setting !--- set live connection --- cfset application.dsn = myconnection cfset username = jack cfset password = smack --- !--- set local connection -- cfset application.dsn = myconnection cfset username = cfset password = ~Dave the disruptor~ Some people just don't appreciate how difficult it is to dispense wisdom and abuse at the same time. From: Josh Nathanson [EMAIL PROTECTED] Sent: Saturday, August 27, 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 able to create the datasource fine if I don't use a password, so I know the issue is not caused by incorrect privileges in the mysql.user or mysql.db tables. Also if I do set up the datasource without a password, and try to use a password in a cfquery, I get the same error. My platform: Windows XP SP2/CFMX 6.1/MySQL 4.1 Thanks for any assistance! ~| 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 Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216671 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL - CF: Access Denied when using password
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 Sources Click the system DSN tab. Mine is showing the MySQL driver as being ODBC MySQL 3.51 ODBC. Maybe you can try it like that? Then go thru CF admin afterwards. Will ~| 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 Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216614 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL - CF: Access Denied when using password
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. http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=6ef0253pss=rss_coldfusion_6ef0253 On 8/27/05, Josh Nathanson [EMAIL PROTECTED] wrote: 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 incorrect privileges in the mysql.user or mysql.db tables. Also if I do set up the datasource without a password, and try to use a password in a cfquery, I get the same error. My platform: Windows XP SP2/CFMX 6.1/MySQL 4.1 Thanks for any assistance! ~| 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 Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216618 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
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 time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216620 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL - CF: Access Denied when using password
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 ~| 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 Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216628 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL - CF: Access Denied when using password SOLVED
Thanks all, I downloaded the MySQL Connector/J 3.0 and it worked. First I downloaded the newer version 3.1 and that did not work, perhaps because I am on CFMX 6.1 rather than 7. Thanks again!! - Original Message - From: Jeff Fleitz [EMAIL PROTECTED] To: CF-Talk cf-talk@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 time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216631 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
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 able to create the datasource fine if I don't use a password, so I know the issue is not caused by incorrect privileges in the mysql.user or mysql.db tables. Also if I do set up the datasource without a password, and try to use a password in a cfquery, I get the same error. My platform: Windows XP SP2/CFMX 6.1/MySQL 4.1 Thanks for any assistance! ~| 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 Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216593 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
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 and password it doesn't have and getting the warning. Not sure how others do it but in my Application.cfm or cfc (shut it will) I set 2 sets of connection variable, 1 live and 1 local and just comment out the one i dont need at the time. like !--- comment out cause we are in local setting !--- set live connection --- cfset application.dsn = myconnection cfset username = jack cfset password = smack --- !--- set local connection -- cfset application.dsn = myconnection cfset username = cfset password = ~Dave the disruptor~ Some people just don't appreciate how difficult it is to dispense wisdom and abuse at the same time. From: Josh Nathanson [EMAIL PROTECTED] Sent: Saturday, August 27, 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 able to create the datasource fine if I don't use a password, so I know the issue is not caused by incorrect privileges in the mysql.user or mysql.db tables. Also if I do set up the datasource without a password, and try to use a password in a cfquery, I get the same error. My platform: Windows XP SP2/CFMX 6.1/MySQL 4.1 Thanks for any assistance! ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216594 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
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 reason that is what's throwing it off. I have a bunch of apps running remotely on CF/MySQL, and I am trying to move from MS Access to MySQL locally, so I'd like to be able to do that without rewriting all the code, or dealing with the commenting workaround you suggested. Is there some rule against a localhost user other than root connecting to MySQL? I am no expert so I might be missing something really obvious, but this also stumped my trusty web host who is something of a CF guru. I emailed him my MySQL user and db tables and he couldn't find anything wrong that would be causing the error. - Original Message - From: dave [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 and password it doesn't have and getting the warning. Not sure how others do it but in my Application.cfm or cfc (shut it will) I set 2 sets of connection variable, 1 live and 1 local and just comment out the one i dont need at the time. like !--- comment out cause we are in local setting !--- set live connection --- cfset application.dsn = myconnection cfset username = jack cfset password = smack --- !--- set local connection -- cfset application.dsn = myconnection cfset username = cfset password = ~Dave the disruptor~ Some people just don't appreciate how difficult it is to dispense wisdom and abuse at the same time. From: Josh Nathanson [EMAIL PROTECTED] Sent: Saturday, August 27, 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 able to create the datasource fine if I don't use a password, so I know the issue is not caused by incorrect privileges in the mysql.user or mysql.db tables. Also if I do set up the datasource without a password, and try to use a password in a cfquery, I get the same error. My platform: Windows XP SP2/CFMX 6.1/MySQL 4.1 Thanks for any assistance! ~| 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 Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216599 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL - CF: Access Denied when using password
i dunno if there is a better work around, i have never really bothered to look, the way i do it takes about 17.4 seconds to do so it's easy enough. Seems as tho there was someting about a local mysql system that just didnt let you use it but it sure looks like thats your fix and as long as you set it in the Application scope its there and only needs changed on one page. Technically, you can do quite a few things with this like in the application.cfm or CFC you can do some logic, like determine if its being called from localhost or from the live server and have it feed it the correct settings. ~Dave the disruptor~ Some people just don't appreciate how difficult it is to dispense wisdom and abuse at the same time. From: Josh Nathanson [EMAIL PROTECTED] Sent: Saturday, August 27, 2005 5:24 PM To: CF-Talk cf-talk@houseoffusion.com 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 reason that is what's throwing it off. I have a bunch of apps running remotely on CF/MySQL, and I am trying to move from MS Access to MySQL locally, so I'd like to be able to do that without rewriting all the code, or dealing with the commenting workaround you suggested. Is there some rule against a localhost user other than root connecting to MySQL? I am no expert so I might be missing something really obvious, but this also stumped my trusty web host who is something of a CF guru. I emailed him my MySQL user and db tables and he couldn't find anything wrong that would be causing the error. - Original Message - From: dave To: CF-Talk 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 and password it doesn't have and getting the warning. Not sure how others do it but in my Application.cfm or cfc (shut it will) I set 2 sets of connection variable, 1 live and 1 local and just comment out the one i dont need at the time. like --- ~Dave the disruptor~ Some people just don't appreciate how difficult it is to dispense wisdom and abuse at the same time. From: Josh Nathanson Sent: Saturday, August 27, 2005 1:49 PM To: CF-Talk 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 able to create the datasource fine if I don't use a password, so I know the issue is not caused by incorrect privileges in the mysql.user or mysql.db tables. Also if I do set up the datasource without a password, and try to use a password in a cfquery, I get the same error. My platform: Windows XP SP2/CFMX 6.1/MySQL 4.1 Thanks for any assistance! ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216601 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: 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 able to create the datasource fine if I don't use a password, so I know the issue is not caused by incorrect privileges in the mysql.user or mysql.db tables. Also if I do set up the datasource without a password, and try to use a password in a cfquery, I get the same error. My platform: Windows XP SP2/CFMX 6.1/MySQL 4.1 Thanks for any assistance! I use SQL server (not sure how similar this is to MySQL) and there were two options when setting it up either use windows authentication or combined windows and sql authentication I chose windows authentication which means I don't have to pass the username and password as windows does that. Maybe that is what is happening in your case? I just modify my application template (on my PC) to reflect no username and password (as on the hosted server they are required). cfscript request.login=; request.password=; /cfscript Incidently I found the whole process of setting up SQL Server locally a total nightmare but eventually I figured it out! Andrew. ~| 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 Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216612 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cfhttp w/ssl and access denied
Hi All, When I use cfhttp (https://abc.cfm https://abc.cfm ) from a non-ssl box to a ssl box, I am getting an 'Access Denied. I am using port#443. If I 'run' the page on the ssl box (in the browser) I get the typical 'security alert' message and it works (NO Access denied). What could be giving me the access denied and how can I solve it. TIA, Pat _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFMX/IIS installation problem: access denied
I'm doing my first ever install of ColdFusion on an IIS server. My .cfm text page (http://de.uh.edu/index.cfm) generates the following error: = ERROR MESSAGE = You are not authorized to view this page You do not have permission to view this directory or page using the credentials you supplied. HTTP 401.3 - Access denied by ACL on resource Internet Information Services = END ERROR MESSAGE = On p.31 of the Installing ColdFusion MX booklet, they detail how to change the CFMX user account in Windows if the user account under which CFMX runs has an inappropriate level of access... I followed the procedures outlined, but my problem still isn't fixed. One thing I wasn't sure of is what account information I was supposed to use. The screenshot shows This Account set to LocalSystem. Is LocalSystem just default filler text, or is it the actual name of the correct account? I was hoping this was a fairly common problem, but time on Google, Macromedia, and Microsoft have yielded only a few obscure references to NTFS permissions and resetting them. But what that means is beyond me. Many thanks, -- Austin ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: CFMX/IIS installation problem: access denied
when setting permissions for that dir...use IUSERWAM or some thing like thatlook for that user in the user list. tony -Original Message- From: Austin Govella [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 9:33 PM To: CF-Talk Subject: CFMX/IIS installation problem: access denied I'm doing my first ever install of ColdFusion on an IIS server. My .cfm text page (http://de.uh.edu/index.cfm) generates the following error: = ERROR MESSAGE = You are not authorized to view this page You do not have permission to view this directory or page using the credentials you supplied. HTTP 401.3 - Access denied by ACL on resource Internet Information Services = END ERROR MESSAGE = On p.31 of the Installing ColdFusion MX booklet, they detail how to change the CFMX user account in Windows if the user account under which CFMX runs has an inappropriate level of access... I followed the procedures outlined, but my problem still isn't fixed. One thing I wasn't sure of is what account information I was supposed to use. The screenshot shows This Account set to LocalSystem. Is LocalSystem just default filler text, or is it the actual name of the correct account? I was hoping this was a fairly common problem, but time on Google, Macromedia, and Microsoft have yielded only a few obscure references to NTFS permissions and resetting them. But what that means is beyond me. Many thanks, -- Austin ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: CFMX/IIS installation problem: access denied
What account did you end up running CFMX under? If you run it under the local system account it's easier to set up, but not as secure. When you do run it under the local sys account, it's not actually a user account that you can select from the User Manager, its an option when you configure the service. 1. Open the services window (via computer management) 2. Right click on the CFMX Service(s) and select properties. Then look at the log on tab. BY default this is the local system account. You can change it if you want. 3. If your IIS website is set to allow anonymous access, and you have not specifically configured the anonymous account, then the account IIS will use is named Iusr_yourmachinename. a) Check the permissions on the CFusionMX/runtime/lib/wsconfig/1/jrun.dll file. It should have Read and Read execute for the Iusr_machinename account. b) Then check your website or web root, and ensure that this folder and files also have the read/read execute permissions. You will also want to click the advanced button and then force the propagation of the permission settings to the sub directories and files. Also, if you have any external dependencies outside the webroot, you may need to assign permissions on those objects aswell. Let me know how it goes - I've been there Brook At 08:32 PM 12/5/2002 -0600, you wrote: I'm doing my first ever install of ColdFusion on an IIS server. My .cfm text page (http://de.uh.edu/index.cfm) generates the following error: = ERROR MESSAGE = You are not authorized to view this page You do not have permission to view this directory or page using the credentials you supplied. HTTP 401.3 - Access denied by ACL on resource Internet Information Services = END ERROR MESSAGE = On p.31 of the Installing ColdFusion MX booklet, they detail how to change the CFMX user account in Windows if the user account under which CFMX runs has an inappropriate level of access... I followed the procedures outlined, but my problem still isn't fixed. One thing I wasn't sure of is what account information I was supposed to use. The screenshot shows This Account set to LocalSystem. Is LocalSystem just default filler text, or is it the actual name of the correct account? I was hoping this was a fairly common problem, but time on Google, Macromedia, and Microsoft have yielded only a few obscure references to NTFS permissions and resetting them. But what that means is beyond me. Many thanks, -- Austin ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: CFMX/IIS installation problem: access denied
The directory where the .CFM files must have anonymous access with read-only permissions, e-mail me off-list of you need additional assistance. = Douglas White group Manager mailto:[EMAIL PROTECTED] http://www.samcfug.org = - Original Message - From: Austin Govella [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 8:32 PM Subject: CFMX/IIS installation problem: access denied | I'm doing my first ever install of ColdFusion on an IIS server. | | My .cfm text page (http://de.uh.edu/index.cfm) generates the following | error: | | = ERROR MESSAGE = | | You are not authorized to view this page | | You do not have permission to view this directory or page using the | credentials you supplied. | | HTTP 401.3 - Access denied by ACL on resource | Internet Information Services | | = END ERROR MESSAGE = | | On p.31 of the Installing ColdFusion MX booklet, they detail how to | change the CFMX user account in Windows if the user account under which | CFMX runs has an inappropriate level of access... | | I followed the procedures outlined, but my problem still isn't fixed. | | One thing I wasn't sure of is what account information I was supposed to | use. The screenshot shows This Account set to LocalSystem. Is | LocalSystem just default filler text, or is it the actual name of the | correct account? | | I was hoping this was a fairly common problem, but time on Google, | Macromedia, and Microsoft have yielded only a few obscure references to | NTFS permissions and resetting them. But what that means is beyond me. | | Many thanks, | -- | Austin | | ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: CFMX/IIS installation problem: access denied
It works! I must've adjusted every permission in every location I could. I forwarded your emails to the server admin, so he can check my changes and also know what the problem was. Thank you guys for your help. I'm new here, but I hope I can reciprocate the help soon. Many thanks, -- Austin ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: CFMX/IIS installation problem: access denied
its all good austin, we all were at one time or another ;) tony -Original Message- From: Austin Govella [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 10:21 PM To: CF-Talk Subject: Re: CFMX/IIS installation problem: access denied It works! I must've adjusted every permission in every location I could. I forwarded your emails to the server admin, so he can check my changes and also know what the problem was. Thank you guys for your help. I'm new here, but I hope I can reciprocate the help soon. Many thanks, -- Austin ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
IIS Caching Files and Access Denied
I hope someone can help me. I am getting Access Denied when trying to delete or overwrite files using CFFILE. I know the path is correct and the user has read/write access. Also, when going directly to the shared drive of the site in Windows Explorer and trying to manually delete or overwrite the file, I get a system file error of Cannot delete filename: Access is denied. The source file may be in use. Once the web admin bounces the site, it releases the files for a while, but then we lose access again. Has anyone seen this before and know of a fix? Thanks, Issac Rosa [EMAIL PROTECTED] __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: IIS Caching Files and Access Denied
Rosa, Issac wrote: I hope someone can help me. I am getting Access Denied when trying to delete or overwrite files using CFFILE. I know the path is correct and the user has read/write access. Also, when going directly to the shared drive of the site in Windows Explorer and trying to manually delete or overwrite the file, I get a system file error of Cannot delete filename: Access is denied. The source file may be in use. Once the web admin bounces the site, it releases the files for a while, but then we lose access again. Has anyone seen this before and know of a fix? always rename a file *then* deleting it gets around this problem zac __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Scheduled Tasks, Access Denied
The Encryption key for SiteMinder was moved and the service wouldn't start. Problem was solved by moving it back (also might edit registry to move it later). But, now when I run any scheduled tasks, they return "Access Denied" (when output is saved to file). I can URL request the CF template from the server, no problem. Permisions are set to "Everyone" can do everything on the Win2K server. What gives? Paul ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Access Denied using Scheduled Task
I'm using the CF Scheduler to call a template I wrote to update and optimize a verity collection once a week. I set it to run over on a Sunday at 3 AM so it wouldn't interfere with anything else.I came back and looked at the logs to see if it worked, and all the log says is access denied. Is this a problem with the Scheduler executing the template (its in a Web Directory on our staging server), or something else? Thanks, Chris Martin ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Access Denied using Scheduled Task
Chris, I've seen this happen when some of the CF admin functions are disabled (CFREGISTRY, CFCONTENT, etc.) in the Basic Security area of the CF Administrator. I don't think this is what's happening in your case as the Application Error Log would specifically mention the tag which caused the problem. Have you checked the CF error logs? John www.cornells.com -Original Message- From: Chris Martin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 4:55 PM To: CF-Talk Subject: Access Denied using Scheduled Task I'm using the CF Scheduler to call a template I wrote to update and optimize a verity collection once a week. I set it to run over on a Sunday at 3 AM so it wouldn't interfere with anything else.I came back and looked at the logs to see if it worked, and all the log says is access denied. Is this a problem with the Scheduler executing the template (its in a Web Directory on our staging server), or something else? Thanks, Chris Martin ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Access Denied using Scheduled Task
CFScheduler uses an HTTP connection to call your template. So, you need to make sure that you supply a user name and password in the scheduler settings for template security. HTH, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - the World's most configurable mail server Get your free copy of iMS POST-SE Server from CoolFusion! - Original Message - From: "Chris Martin" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, March 13, 2001 4:54 PM Subject: Access Denied using Scheduled Task I'm using the CF Scheduler to call a template I wrote to update and optimize a verity collection once a week. I set it to run over on a Sunday at 3 AM so it wouldn't interfere with anything else.I came back and looked at the logs to see if it worked, and all the log says is access denied. Is this a problem with the Scheduler executing the template (its in a Web Directory on our staging server), or something else? Thanks, Chris Martin ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFFILE .. access denied.
I am uploading a file using CFFILE that can then be immediately viewed on a web page. The steps I am taking are: 1. Check for occurances of an old file with the same name 2. If found, delete it 3. Upload the new file to a temp directory 4. Move the file from the temp directory to the production directory and rename it at the same time (while keeping its original extension). At step 4, I sometimes get this error: Unable to move file 'C:\web\server\path\images\temp\abcdefg.jpg' to path 'C:\web\server\path\images\picture.jpg'. Access is denied. (error 5) The error is intermittent. Anyone know why this would happen? I know it's not complaining about overwriting the old file, since it has already been deleted but this point .. I'm lost. .Todd -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFFILE .. access denied.
Todd, I had the same problem. Have the Network Admin make sure the Anonymous user has access to read and write files in those directories. -Original Message- From: Todd Ashworth [mailto:[EMAIL PROTECTED]] Sent: Friday, May 05, 2000 1:05 PM To: [EMAIL PROTECTED] Subject: CFFILE .. access denied. I am uploading a file using CFFILE that can then be immediately viewed on a web page. The steps I am taking are: 1. Check for occurances of an old file with the same name 2. If found, delete it 3. Upload the new file to a temp directory 4. Move the file from the temp directory to the production directory and rename it at the same time (while keeping its original extension). At step 4, I sometimes get this error: Unable to move file 'C:\web\server\path\images\temp\abcdefg.jpg' to path 'C:\web\server\path\images\picture.jpg'. Access is denied. (error 5) The error is intermittent. Anyone know why this would happen? I know it's not complaining about overwriting the old file, since it has already been deleted but this point .. I'm lost. .Todd -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFFILE .. access denied.
If you are using IIS then the reason is because IIS caches static files. When the file is cached it is locked for 60 seconds, I think. So, you would need to disable the IIS caching (there are articles on how to do this) but that would degrade overall server performance... HTH, Howie Hamlin -- inFusion Project Manager; On-Line Data Solutions, Inc. (631)737-4668 === Please vote for iMS in the Most Innovative category here: *** http://www.sys-con.com/ColdFusion/readerschoice2000/ *** === Check out inFusion Mail Server - the world's most configurable email server *** inFusion Authenticator for IIS is now released! (download from CoolFusion.com) *** http://www.teletrends.com and http://www.coolfusion.com Software and utilities for ColdFusion, iHTML, Website, NTMail Latest versions available from our web site (inFusion Authenticator version 2.0 for WebSite and NTMail is now released) - Original Message - From: Todd Ashworth [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, May 05, 2000 2:04 PM Subject: CFFILE .. access denied. I am uploading a file using CFFILE that can then be immediately viewed on a web page. The steps I am taking are: 1. Check for occurances of an old file with the same name 2. If found, delete it 3. Upload the new file to a temp directory 4. Move the file from the temp directory to the production directory and rename it at the same time (while keeping its original extension). At step 4, I sometimes get this error: Unable to move file 'C:\web\server\path\images\temp\abcdefg.jpg' to path 'C:\web\server\path\images\picture.jpg'. Access is denied. (error 5) The error is intermittent. Anyone know why this would happen? I know it's not complaining about overwriting the old file, since it has already been deleted but this point .. I'm lost. .Todd -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFFILE .. access denied.
At 02:04 PM 5/5/00 -0400, you wrote: I am uploading a file using CFFILE that can then be immediately viewed on a web page. The steps I am taking are: 1. Check for occurances of an old file with the same name 2. If found, delete it 3. Upload the new file to a temp directory 4. Move the file from the temp directory to the production directory and rename it at the same time (while keeping its original extension). At step 4, I sometimes get this error: Unable to move file 'C:\web\server\path\images\temp\abcdefg.jpg' to path 'C:\web\server\path\images\picture.jpg'. Access is denied. (error 5) The error is intermittent. Anyone know why this would happen? I know it's not complaining about overwriting the old file, since it has already been deleted but this point .. I'm lost. It sounds like the server doesn't have permission to save to that folder or that it doesn't have permission to delete the new file from the temp directory. Does the intermittent error happen or not happen depending on the file names? -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFFILE .. access denied.
Yeah I get this sometimes too. I think it has something to do with IIS having a hold on the image and not letting anything else touch it. It only happens when I do and upload, look at the result on the website then try and upload again. -- Ric Smith I am uploading a file using CFFILE that can then be immediately viewed on a web page. The steps I am taking are: 1. Check for occurances of an old file with the same name 2. If found, delete it 3. Upload the new file to a temp directory 4. Move the file from the temp directory to the production directory and rename it at the same time (while keeping its original extension). At step 4, I sometimes get this error: Unable to move file 'C:\web\server\path\images\temp\abcdefg.jpg' to path 'C:\web\server\path\images\picture.jpg'. Access is denied. (error 5) The error is intermittent. Anyone know why this would happen? I know it's not complaining about overwriting the old file, since it has already been deleted but this point .. I'm lost. .Todd -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
HTTPRequest - Log File Access Denied - SSL
I'm having difficultings getting the scheduled tasks to work now that we've gone to SSL (Windows 2000, ColdFusion4.5.1 rc 1). The error log only writes "access denied". I'm on the correct port (443) and have tried various user names and passwords. We are also using Certificate Server, and I think that maybe the HTTPRequest is getting blocked. Is there a way around this? Thank you __ Get Your Private, Free Email at http://www.hotmail.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: HTTPRequest - Log File Access Denied - SSL
i know that you cannot schedule a task with an HTTPS url in CF4.01. i don't know if this was changed in 4.5. however, i'm curious as to why you need SSL for a scheduled task. the information isn't going over any outside pipes. that means that the request and reply are merely between the DB and the CF machine. therefore, unless you have someone INSIDE your network that is listening, you'll be fine. and if that's the case, you have worse issues than just needing SSL. Chris Olive DOHRS Website Administrator [EMAIL PROTECTED] -Original Message- From: David Berger [mailto:[EMAIL PROTECTED]] Sent: Friday, March 31, 2000 2:15 PM To: [EMAIL PROTECTED] Subject: HTTPRequest - Log File "Access Denied" - SSL I'm having difficultings getting the scheduled tasks to work now that we've gone to SSL (Windows 2000, ColdFusion4.5.1 rc 1). The error log only writes "access denied". I'm on the correct port (443) and have tried various user names and passwords. We are also using Certificate Server, and I think that maybe the HTTPRequest is getting blocked. Is there a way around this? Thank you __ Get Your Private, Free Email at http://www.hotmail.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: HTTP Request - Log File Access Denied - SSL
I'm having difficultings getting the scheduled tasks to work now that we've gone to SSL (Windows 2000, ColdFusion4.5.1 rc 1). The error log only writes "access denied". I'm on the correct port (443) and have tried various user names and passwords. We are also using Certificate Server, and I think that maybe the HTTPRequest is getting blocked. Is there a way around this? If you're using Certificate Server to issue client certificates to your browsers, CFHTTP doesn't work with client certificates in CF 4.5. If all the scheduled tasks are executing HTTP requests on the same CF server that is scheduling the tasks, you could run them through the Task Scheduler service instead. Write a batch file which might look like this: SET QUERY_STRING=id=5name=Bob SET CF_TEMPLATE_PATH=c:\inetpub\wwwroot\myfile.cfm C:\CFUSION\BIN\CFML.EXE Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
