close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

.htaccess forcing https breaks WA mySQLi functions

Thread began 5/12/2017 7:26 pm by LionsMane | Last modified 5/17/2017 9:26 pm by Ray Borduin | 163 views | 10 replies |

LionsMane

.htaccess forcing https breaks WA mySQLi functions

I commonly use .htaccess to force a site to use it's SSL cert so the entire site shows as https in the browser. When this is in play, I can't pull any data into the mySQLi behaviors in DW. They all fail to connect to the database. If I delete or blank out the .htaccess upon the server, then the Behaviors operate as one would expect. Any suggestions on how to manage this??

Sign in to reply to this post

Ray BorduinWebAssist

Make sure you use https:// in your testing server url in your Dreamweaver site definition.

Sign in to reply to this post

LionsMane

Testing server address?

Where in DW do I find a field to designate the testing server URL?? I can't find that as a configurable field anywhere.

Sign in to reply to this post

Ray BorduinWebAssist

Open up your site definition and click the Servers tab. Then go to the one you have selected as the testing server and the last field in the form is the url. That will need to start with https:// if you are forcing https with your .htaccess file.

Sign in to reply to this post

LionsMane

Not quite..

Yes, I see where you were going with that, but doing so breaks my mySQLi connection. I now get that generic error saying that there is no testing server setup - though, clearly there is. I remove the https in favor of just http in that URL field, and i can connect again.

Sign in to reply to this post

Ray BorduinWebAssist

I'd have to debug it. I thought it wasn't working? I'm a bit confused at this point. If you have an SSL certificate installed it should work with or without https. However if you have an .htaccess file forcing https then the url would have to start with https.

If you attach your site definition privately I can test with it and see what is going on.

Sign in to reply to this post

LionsMane

It's worse

It's even worse now.. completely deleted the connection .php file, removed the .htaccess file from the root completely, set PHP version to 5.6 for this site, and I can't even get a database connection. Trying to build a connection file, I get:
1. There is no testing server running on the server machine.
2. The testing server specified for htis site does not map to....
Attaching .ste file...
..theoretically, SSL has been removed from the equation completely, and I still can't get connected.

Sign in to reply to this post

Ray BorduinWebAssist

I can't browse to the site you have listed as the web url. Perhaps your site is down or you have a typo.

Sign in to reply to this post

LionsMane

HMMM

Well that wouldn't help the problem. It WAS live as of yesterday, but it's failing to connect for me too. I'm see a 500 error - not 404, so something's hinky server side. I'll clean everything out there and try again.

Sign in to reply to this post

LionsMane

removed www

Changed the URL to just http://fgmilive.com/ and now it appears I can retrieve the database tables. So weird.. I have no idea why.

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...