Migrating from ColdFusion 2016 to Lucee

[Roberto_Marzialetti]

Try to post some code.

[aspirenet]

This works
<CFSET somevalue =“1”>
<CFOUTPUT>#somevalue#</CFOUTPUT>

This does not
<CFQUERY name=“TestGet” datasource =“TheDataSourceIsInHere”>
SELECT top 1
from aff
</CFQUERY>

I am trying to figure out how to get it to give me more than just 500- Internal Server error.

I do have all logs switched on in Lucee, but don’t see any log file generated

(After posting I see that it removed all of the CF tags in the post)

I just tried it with a simple CFFILE to write a log, same issue.

[aspirenet]

If I could figure out how to get more feedback on the error I might stand a chance.

I notice on my ACF local developer version on Windows 10, I have the debug output settings set to display and I get lots of info on errors, however on the Windows Server I don’t I just get what I guess is the standard IIS 500 error message. I checked the same boxes for debugging on the CF admin, and I even added my external IP number to the debugging IP addresses, but it still doesn’t give me all of the exception information.

I am guessing this is a setting somewhere in IIS that differs from my local Win 10 IIS to the Win Server IIS.

Does anybody know how to fix this so that I could then hopefully get more info from Lucee?

I thought it was fixed, but it was not, I can get debug output, but not if I have a code issue, like a page that just has <CFFILE with nothing else

Thanks

[Roberto_Marzialetti]

@aspirenet

This does not

SELECT top 1
from aff

I am trying to figure out how to get it to give me more than just 500- Internal Server error.

Write to us what error message you receive exactly.
You can also take a screenshot.

[Julian_Halliwell]

@aspirenet

I am guessing this is a setting somewhere in IIS

Check the Error Pages section in the IIS Manager and then “Edit feature settings”…". See if changing to “Detailed errors” makes any difference.

[aspirenet]

@Julian_Halliwell Bingo, you got it!! I have never seen/touched that. It looks like the default must be different on Win10 IIS vs Server. Every day’s a school day

My quest for info on Lucee will now continue. THANKS!

Edit: DAMN, I just tested it through a VPN so I could change my IP and it’s not IP restricted, so everybody will get it

[aspirenet]

I have detailed error messages now (albeit everybody can see them, but I’m on a clone server with an used domain so I can live with it in the short term)

the CFQUERY was my fault, wrong table name!

the CFFILE issue, appears to be that Lucee is unable to access the drive. I am thinking it’s likely needed to be change to run under a user account

[aspirenet]

I did indeed need to change the Lucee service to a user account to perform the CFFILE write.

Once I did that I was very excited to see that the site started working, until I tried an account log in and I end up with it taking me to a page that just says OBJECT MOVED

Disappointing I thought this might have been an issue of full compatibility. I will investigate in the morning to see if this is a config issue or the actual code.

[Julian_Halliwell]

@aspirenet

I just tested it through a VPN so I could change my IP and it’s not IP restricted, so everybody will get it

There’s another error mode you can set: “Detailed errors for local requests and custom error pages for remote requests”. You can also control it in your web.config file (in your web root) as

<httpErrors errorMode="DetailedLocalOnly" defaultResponseMode="File"></httpErrors>

[aspirenet]

@Julian_Halliwell I think that is the one I selected. I’ll need to go check.

With regards to my code hitting a brick wall. I found that it was CFLOCATION that was the issue.

Any use of CFLOCATION is failing displaying “Object Moved”

It was using a relative path …/games/index.cfm so I changed it to use the root /games/index.cfm and also tried a full HTTP URL, they all give the same result.

a search of the forum did find this

Cflocation just shows Object Moved page

Hi Guys, migrating a site here from Railo v4 up to latest stable Lucee 5.3.8.201 (using installer, so tomcat 9 and java bundled) - all working well apart from an index.cfm page we have at the root of our site that does this: <cflocation url="/home/view" addtoken="false"> Instead of redirecting as it did in Lucee, it now shows a page saying: ‘Object Moved’ and does nothing? - the same is true for any other pages we have that use CFLOCATION Is there an obvious config change here or has this f…

I located the boncodejp13.settings file but it did not have a reference to <EnableHTTPStatusCodes>False</EnableHTTPStatusCodes> so I added it with the value TRUE, and restarted Lucee. It didn’t fix it

[andreas]

@aspirenet

boncodejp13.settings

Have you changed the right boncodejp13.settings file? You may have changed the wrong file. Please see this post were I’ve changed the settings in the wrong file:

TOMCAT CVE-2020-1938: Ghostcat (AJP)

This is totally embarrassing to post, but I got to do this: I was adding the settings in the BonCodeAJP13.settings of the installation files all the time, AND NOT in C:\windows\BonCodeAJP13.settings. Changed it, restarted IIS and Lucee and all worked. Sigh… frustrating… Really, sorry for bothering you with my stupidity. Zillions of apologies ( @martin , @Zackster, @Julian_Halliwell and every one else here)

[aspirenet]

Thanks @andreas I had a read of that post and got a little lost

I was changing the file in the Lucee folder and not in the Windows directory.

The question I have is what should I be changing in that file?

Thanks

[andreas]

@aspirenet

I located the boncodejp13.settings file but it did not have a reference to False so I added it with the value TRUE, and restarted Lucee. It didn’t fix it

This maybe . Sorry for the confusion. Just wanted to show you how easy it is to change settings in the wrong boncode settings file, cause it happened to me once.

[aspirenet]

ohhhhhhh got it. Looks like I’m a little stuck

[andreas]

Did it work?

[aspirenet]

I am not actually sure what to put in there after reading that other link that you posted.

I haven’t tried this yet
<EnableHTTPStatusCodes>False</EnableHTTPStatusCodes>

[aspirenet]

I added the EnableHTTPStatusCodes above to the settings file in the windows folder. It’s still not working but is now giving a little more information apart from Object moved

Object moved to [here]

Generic Connector Communication Error:

Please check and adjust your setup:
Ensure that Tomcat is running on given host and port.
If this is a timeout error consider adjusting IIS timeout by changing executionTimeout attribute in web.config (see manual). [2023-09-08 14:52:29 ]Generic Connector Communication Error:

[andreas]

Hmmm, this looks more like your setting is breaking the connection. Can you change the setting back to the initial setting and show the server response headers of that “Object Moved” you had?

[aspirenet]

Previously there was no entry at all there, I set it to TRUE, and it gives the same result as if it was not there, as in just displaying OBJECT MOVED and nothing else.

Can I pull more info from Chrome?

[andreas]

Yes, you should get the server response headers from the chrome dev tool. Or you can get them also with curl.