Questions

The local account used as the login account for CF application service doesn't allow access via UNC to other servers in in the same subnet  (behind a firewall with private ip addresses in use) for security reasons. It would be easier if we used a domain account -- but all the installation instructions and hardening pdf - recommend a local account which I am using.I can't seem to find details on how using a domain account is creating a security issue.  Is this a major or minor security issue is another question...TIAJay Bietz

I've been authenticating users of my web app against Active Directory using the cfntauthenticate tag which works pretty well and was simple to implement.  We have one or two European users who cannot log in because they are getting an invalid password error.  There username and password was checked as being valid by using other non-CFapplications that also authenticate against the domain .  The common thread seems to be that they use umlauted or other European accented characters.  These characters can be multi-byte in a unicode environment so I've tried a number of methods to altering the encoding of the page so that the password is recognized as valid but have had no luck so far.  Has anyone encountered this or have any information on the encoding of the form field when passing it through this tag?  Brian

The last 2 days - my [removed link] CF site has suffered from high CPU usage (on and off) that stops functionality.This will last several minutes then suddenly the high usage stops a few minute later the high cpu usage starts again.I don't have any scheduled processes allowed to run.Restarting the coldfusion service  during a high CPS incident - the cpu usage just picks up where it left off when restarted.I have assigned 4 CPUs (normal) or 8CPUs  (as a test) to the VM and I get the same high CPU then low usage. This is a fresh install several months ago on a new VM.I'd like some Adobe support on this issue but can't seem to find the contact phone number.This series of high and low cpu usage first started Monday AM about midnight until 7:00 AM  Tuesday was quiet and Wednesday this AM I'm having the same issues.Ideas?Update:  While waiting for this to post - the high CPU usage started again and this time I stopped and restarted the Jetty service ... and the CPU usage

I am running a JSP application on CF10 and trying to connect to an Oracle 11g data source. I cannot find any information or examples on how this might be done. Any info on how I can do this would be greatly appreciated. I have tried the the following but receive an error.Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","username","password");root causejavax.servlet.ServletException: java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@localhost:1521:orclThanks

I have images pulling into site but it seems to be pulling them based on most recent added, is there any way to pull by file name alphabetically?I'm not too experienced with CF but I am good with HTML/CSS trying to fix some things on a friends site due to a runaway backend developer.sorry if this doesn't make too much sense.this is what it currently looks like<div><img width="920" height="300" src="data/images/<cfoutput>#ListGetAt(pic, 1)#</cfoutput>" /></div><div><img width="920" height="300" src="data/images/<cfoutput>#ListGetAt(pic, 2)#</cfoutput>" /></div>...

We have an internal page that we use to control things on our website.  It's sort of like a home-brewed CMS, but it doesn't hold actual content.  It just stores details about the pages (page title, contact person, date created, etc) and allows us to show newly added items on a "what's new" page.To get into the thing, I have a list of authorized users in a database.  I compare this list to a function that the server gives us called GetAuthUser()I basically do a query to find that username in the database and pull out the associated rights, then assign them to session variables.  This worked perfectly in CF8, but not in CF10.Here's the code that worked before: <cffunction name="onSessionStart">     <cfquery name="session.userdata" datasource="mydsn">     SELECT usernm, user_email, admin     FROM users     WHERE usernm = '#listlast(GetAuthUser(),"\")#'     </cfquery>  &nbs

I have made an encryption of "auth" using AES as follows:<cfset skey = generateSecretKey("AES")><cfset regkey = encrypt("auth", skey, "AES", "hex")>I attached the result for example to an URLhttp://www.mydomain.com/authorization.htm?auth=34D3795AA3696B7F81AEFE414DCA7392FDCC50AFE9D0312B2B2530A985386B83(auth is assign regkey   i.e. ,,,,,,htm?auth=#regkey#)This works perfectly under perfect condition.  However, if I go ahead and try to "hack" the code and make it shorter and change some characters like this:http://www.mydomain.com/authorization.htm?auth=453424AEFE414DCA7392FDCC50AFE9D0312B2B2530A985386B83The Decrypt function:<cfset theword=decrypt(url.auth, skey, "AES", "hex")>just crash! It throws an exception. Isn't it supposed to just return bad string rather than crashing?  This is pretty bad. Is there way to check for the URL.auth before passing to Decrypt?  Thanks in advance.

HII'm doing   returnAsBinary = "objectGUID"in a <cfldap> query.I was thinking of storing this value returned by objectGUID in a ms sql databse in a varchar(100) column as a primary key. Can you see any pitfalls with this method?

Hello, I am looking at having to work on a project that the customer is currently on CF 6 MX.  They obviously need to upgrade and so I am looking to experiences, thoughts, advice, anything at all about doing an upgrade over this many versions.  The major question I have is should we go major version to major version and not skip, like 6-7, etc. or is it do-able to go from 6 direct to 11?  Thanks in advance for any info.

CFB3 Question: How can I add an existing cfm page to a project? I created a project and copied a file into the project folder but I can't seem to find a way to add the cfm file into the project.

Hi Folks,I'm running ColdFusion 9 Trial Version (no hotfixes), SQL Express 2005, Windows XP SP3, IIS.Using ColdFusion Administrator, when I try to create a datasource to SQLExpress 2005 (SQL Server Express), using the SQL Server driver, I get the following error:Connection verification failed for data source: AMTjava.sql.SQLException: [Macromedia][SQLServer JDBC Driver]The requested instance is either invalid or not running.The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]The requested instance is either invalid or not running.The "instance", which I take to mean the database instance, is "machinename\SQLExpress"  (This is a so-called "named instance".)  This is what I enter into the "Server" field of the form (Data & Services -> Datasources -> Microsoft SQL Server).On the other hand, I am able to create an ODBC datasource name in Windows using the Microsoft SQL Server Native Client Version 09.00.3042 driver and using the same insta

Hello,We have just installed the APSB14-23 hotfix for ColdFusion 10. After the installation, we get the following error when we try to reach ColdFusion administrator. Has anybody experienced this error before? How did you resolve it? Thanks.Best regards,Chung Leetype Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception javax.servlet.ServletException: coldfusion.server.ServiceFactory$ServiceNotAvailableException: The Runtime service is not available. coldfusion.bootstrap.ClassloaderHelper.initServletClass(ClassloaderHelper.java:129) coldfusion.bootstrap.BootstrapServlet.init(BootstrapServlet.java:59) org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:928) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:

I have a simple table with an NVARCHAR column and some random Korean and Chinese characters.  I can successfully query the database and output this column to the my browser in addition to passing an UTF-8 NVARCHAR variable out from the Stored Procedure regardless of whether the option that is suppose to enable it is checked.-- Enable High ASCII characters and Unicode for data sources configured for non-Latin charactersI verified multiple times that it's unchecked yet the output is as expected in UTF-8 characters (not gibberish or question marks).

Hello , I am making migration from CF 8 to CF 11. Using MS SQL server. Raised an issue when check the result from cfquery tag.In CF8 all fields which are defined in DB as uniquieidentifier, when I receive the result there are in lowercase , something like this ''4eert4erte4tert4ert4545 .... The same request to the same DB and MS SQL server, but using CF 11 returning the result in capital letters , something like ''4EF56DSE76534SFJSF ....... Do you have an in idea how I could fix this. I assumptions are that this is comming maybe from some settings of the connector of CF to MSSQL , I am not sureis this connector actually is using the JDBC driver . I really stuck in this so any ideas will be welcome.

See the following code: spreadsheetObj = SpreadsheetNew('Metrics',false);SpreadSheetSetColumnWidth(spreadsheetObj, 3, 10);SpreadSheetAddRow(spreadsheetObj,'Merchant ID,Merchant Name,Return Customer#chr(13)##chr(10)#Conversion Rate');SpreadSheetSetRowHeight(spreadsheetObj, 1, 50);SpreadsheetFormatCell(spreadsheetObj, {textwrap=true}, 1, 3);SpreadsheetFormatRow(spreadsheetObj, {textwrap=1}, 1);Even using both Cell and Row formatting I can not get the text to wrap. This is what the resulting file looks like: If I click on C1 and click the "Wrap Text" option in Excel, it formats correctly.. so the line breaks are there. This is CF10 by the way and I believe we run CF11 in production which I think I read solves this problem. Just wondering if anyone else has seen this or documented a fix. I've also tried XLSX and XLS.

I have developed a CRM that is based on sales leads that post to a database.  The CRM index page performs a select query and displays a filtered recordset based on the SQL.  This index page refreshes every 30 seconds via a Meta Tag refresh.  But I am thinking that there must be a more robust/efficient method.  Ideally I would have a popup appear each time that new record posts that when clicked would bring up the detail for the record.  And if such a robust method exists, what might better the overall refresh of the data other than a Meta refresh?  Any direction you can advise would be appreciated,.

So an application I have inheritted has been running for some years with CF8 and Flex. It assigns tasks, appointmnts, rest days, holidays of our operators. The operators open the application on their laptop or available PC. But we think that this system is somehow old and slow and we think we needs more interaction with the operators. One xample of what we need. It would be nice if the operator can inform the app about realtime changes so that another operator can be despatched for backup. Also the operators want to have their own space and communication channels.We want to make the system easier to use. If possible using Coldfusion only. With Ajax? I don't know if this is possible. Any ideas?

We recently upgraded from CF9 to CF11.  I am having an issue where CF is throwing Element undefined in URL when the variable is clearly defined in the URL. Here's the flow...The user clicks an icon to update an item.  A new window is opened and variables are passed in the URL.  User makes the changes, presses submit, CF makes the updates then the Window closes.  This worked fine in CF9.  Since the update when the user presses submit the window never closes and CF throws the error.  Nothing changed in the code.Thanks in advance for any help!Gary 

CF11 will give the above error even the self-signed root certificate is added... how to fix??

While try to setup a CF11 and use cfldap to a LDAP server with SSL (self signed cert), the self-signed root cert is added into the default "cacerts" file, but still failed to bind.  It works from version CF7 to CF9.  I even tried in CF10, also not work.  Any body can help???  Million thanks!!!!!

I have lately upgraded to CF10 from CF9.Just lately I have noticed that I cannot get gmail smtp mail server verification within CFAdmin.I am using the same settings as before.  In fact, on an old machine using CF9 I still get mail server verification.MAIL SERVER: smtp.gmail.comUSERNAME: name@gmail.comPASSWORD: xxxxxxxxxxSERVER PORT 25x  Enable SSL socket connections to mail serverAny insight would be greatly appreciated!  wayne

Hello, I am in the process to deploy .car file from ColdFusion 9 into ColdFusion 11.When I open ColdFusion 11 Administrator -> Package & Deployment -> ColdFusion Archives -> It shows Internal Server Error 500.Application Log file shows the error below:Element CAR.ARCHIVES is undefined in REQUEST. The specific sequence of files included or processed is: E:\ColdFusion11\cfusion\wwwroot\CFIDE\administrator\archives\index.cfm, line: 247Any help on this would be highly appriciated.Thank you in advance !!

Hi, How can i catch different SMPP error type return by SMSC server ?I want to catch result like 0x45,0x01,0x0B,0x58,0x15.... in my code. I can see eventgateway.log logging the error message but how do i get error type in my code ? Thanks

coldfusion10 - just installed it.  could get in before i loaded the updatesserver is running fine otherwise

Am converting from Verity to Solr search. Anyone have any luck increasing the length of the summary generated by Coldfusion under Solr? I noticed that with Solr, the summary will list the first few words of whatever you enter for the "body" of the CFINDEX whereas Verity's summary is longer and goes to a paragraph/sentences where it finds the search word criteria (or close to it). Under the Solr, the summary doesn't seem that useful. I want to increase the summary text so it display more...hopefully, useful information.