A

Anonymous

Question

Coldfusion2018 Datasource

Forum|Forum|6 years ago
December 23, 2019
4 replies
1857 views

#

This topic has been closed for replies.

Charlie Arehart

Community Expert

For future readers, while the original question here from OrokColdSpring has been somehow changed by them to merely "#", the gist was a problem getting a CF request to run, and it seemed to them that it was a DSN problem. In the end, martyi3150533 (who may or may not be the same person, but was replying as if they were) did indicate that we finally got his problem resolved. See his reply below, at https://community.adobe.com/t5/coldfusion/coldfusion2018-datasource/m-p/10839091#M184188.

And Marty, very good to hear. Thanks for updating us.

That said, your response there could be missed by readers, since the threaded UI here makes your reply be buried in the middle of the email thread. So I am offering this response as a "reply" to the original post, so that it this reply stands out more clearly at the bottom, to help readers trying to follow along. 🙂

Finally, if you want to pick any of the many messages to mark as the "correct answer", it may help future readers. But I suspect most will be thrown off the trail by Orok's removal of the original question. I've simply never seen that done in any CF forum before.

/Charlie (troubleshooter, carehart. org)

M

martyi3150533

Participating Frequently

The source code is not picking up the info from the database

The code:

<cfquery name="getScientists" datasource="rhce" username="root" password="*****">
SELECT sno, firstname, lastname, city, country, age
FROM scientists
</cfquery>

<html>
<head>
<title>Using cfoutput</title>
</head>
<body>
<table border="1">
<tr>
<th>Sno</th>
    <th>FirstName</th>
<th>LastName</th>
    <th>City</th>
    <th>Country</th>
    <th>Age</th>
</tr>
<cfoutput query="getScientists">
<tr>
  <td>#sno#</td>
        <td>#firstname#</td>
  <td>#lastname#</td>
        <td>#city#</td>
        <td>#country#</td>
        <td>#age#</td>
</tr>
</cfoutput>
</table>
</body>
</html>

D

Dave Watts

Community Expert

OK, thanks for the larger screen shot! It looks like your CFML isn't executing, and that probably means your web server isn't configured to execute CFML properly. You can confirm that by creating a single CFML one-liner that looks like this:

Dave Watts, Eidolon LLC

M

martyi3150533

Participating Frequently

The problem was the port number. I have to open the firewall.

Sorry, I get so excited I can pull the data from the database :-D. But, that's only one part of the problem - fixed.

I'm not 100% sure if my configuration is working/integrated with the installed and running Apache2.4. If you check the URL, it uses default CF directory. I want to to use Apache2.4 integrated to CF2018. I might have to explore Charlie's suggestion below.

https://helpx.adobe.com/coldfusion/installing/installing-the-server-configuration.html#Configuringotherwebservers

Everything's working now. Charlie's suggestion sealed the problem 🙂 I just run this command:

./wsconfig -ws apache -dir <apache_conf_directory>

Charlie Arehart

Community Expert

I'm noticing that the OP here (orokcoldspring) had opened a question about the same problem on the CF portal last week, specifically https://coldfusion.adobe.com/2019/12/problem-picking-datasource/. I suspect they asked here because no one replied there.

But I did reply there today, as I saw it for the first time. Folks interested in helping here may want to see what I said there.

Bottom line, the problem seems to be that their CFML code is simply not running at all. That's why they are seeing the output they do. (And as I'd said if they do a "view source" in their browser, they can confirm for us if they see CFML in the browser. which would confirm it's not "running" in CF.)

It's interesting to note that in that other post, they had not offered the UR they were using, and I had asked to know that, to help direct them to a solution. I see now that they did provide it in their post here, saying that it was: http://10.20.249.42/index02.cfm

So this suggests they are not CF's built in web server (which would listen on a non-standard port like 8500), but instead some external web server like IIS or Apache. And as I said in answer to the other post, it would seem then to be about some misconfiguration of their IIS setup.

Whether you answer here or there, had you run the CF "web server configuration tool", which is how one connects such a web server to CF? Either way, tell us more (and in either place, though if the conversation will take off here, you ought to add a link to this post on that other one, so folks seeing it there can follow the discussion here).

/Charlie (troubleshooter, carehart. org)

A

Anonymous

#

Charlie Arehart

Community Expert

Sorry, but rather than an answer, I only have more questions (some which you did not answer).

First, it seems you're confirming this may be your first cf page running on cf2018, is that right? (If you tried a simpler one without a cfquery, you'd see if this problem had nothing to do with that.)

And did you do the view source in the browser, to see if it shows your cfml underlying the page output? That would confirm cf is not processing the page.

And are you confirming you're using iis, perhaps? We need to know, to guide you to a solution.

More important, did you actually install cf2018? You don't say, and since you say you are "not a CF expert", we shouldn't presume you have done that.

And where is cf? On your own machine or elsewhere? We can't tell, with the ip address you show.

(If cf is on some OTHER machine, you will need to enlist the help of whoever installed cf there to resolve this.)

Finally, assuming cf. 2018 is installed and you are using iis, the cf web server configuration tool needs to be run. Something to note is that the cf2018 installer NO LONGER OFFERS TO INTEGRATE ITSELF WITH ANY EXTERNAL WEB SERVER, like iis or apache, though it always did before. Never saw any explanation for that.

If it's simply that you didn't do that last step, then assuming you are on Windows and installed cf yourself, you would look to the windows start menu, for the Adobe menu, where you would see first a link for then cf admin. The last link in that Adobe menu is for the cf web server config tool. (If you still have cf11 installed, watch to choose the correct one.)

As for how to use that tool, including screenshots, see the cf docs, found easily via Google. Let us know how it goes.

/Charlie (troubleshooter, carehart. org)

D

Dave Watts

Community Expert

I don't think you're providing enough information to answer your question. I can't see the URL you're mentioning.

Dave Watts, Eidolon LLC

A

Anonymous

#

D

Dave Watts

Community Expert

That's still not enough information. That URL doesn't have anything useful in it. I suggest you show the actual CFML code in that page.

Dave Watts, Eidolon LLC

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded