Create Logon Dialog

[JimiJonJarniganJunior]

I am trying to create a logon dialog for a Dreamweaver (DW) website that incorporates SSL on GoDaddy. The website is created with some content but I want to control access to the site with a typical logon dialog that gathers userID and passWord. I understand that this will necessitate a connection to a database on the website. The idea would be to intercept any attempt to access content on the website and redirect to the logon dialog until such time as the user has logged on successfully. This would also require a means of authenticating new user requests. I'm guessing that this will require either substantial code developed with DW on the website or implementation of an application extension of some sort. Using Dreamweaver CS 19.2.1 build 11281. I also have the Adobe Creative Cloud applications in case any of those might help.  Thanks in advance for assistance.

[BenPleysier]

Have a look at

[JimiJonJarniganJunior]

Hi Ben,

Thanks very much for your suggestion and the link to the video. I watched the video and have been looking at reviews, although they are quite sparse. Have you tried making this work with the latest version of DW (subscription).

[JimiJonJarniganJunior]

Hi Ben,
Sadly, since I've been using DW for many years, I'm about to give up on DW and try Wordpress or something else. I have a Synology NAS and am running MariaDB for a few things. The DW local site from which I publish is on Win 10 machines. I added a database and tried to connect from the Win 10 machine with DMX database connection through DW. The port for MariaDB is not visible so I tried installing Docker and connecting it to MariaDB with a different port. This let the port pass-thru be seen with the NAS so I set the router to see it as well. Now I can get a connection with a browser using the host ID and its port but the data being returned is not good. When I try connecting to that database using DMX database connect in DW with host ID, port, database name, user ID, and password, I get the same error I've been getting all along.
I have no problem coding (https://www.mechtol.com) but there does not seem to be a succinct, clear solution. This is getting way too complicated. If and when I get the connection to the NAS, what do I ask GoDaddy to do so I can connect there?
While I hate to burn all the content on the existing two DW-maintained websites I also need to be able to control access to parts of the websites. What's your take on Wordpress?

[Nancy OShea]

There's nothing inside Dreamweaver that can do this for you out of the box.   If you're not up to coding manually with  PHP & MySQL, I would highly recommend using the DMX Zone Extension that Ben mentioned .  They have been making DW extensions for many years and have a very good reputation in this community.

Another option is to use WordPress with a membership plugin.

https://www.wpkube.com/best-wordpress-membership-plugins-match-budget/

[JimiJonJarniganJunior]

Thanks, Nancy. I purchased the modules for DMXZone and have been going through the tutorial. I cannot get the database connection made. The website is on GoDaddy and I have built a new MySQL database that is now one of three on the site. I've tried using the URL to the site and the IP address for the server address. The DMXZone database connection module tells me that there is a 404 file not found error. I called GoDaddy and they don't know what to do.

Any assistance you can provide to get me so I can connect to the database would be awesome. Thanks in advance.

[Nancy OShea]

I don't know if you can connect directly to GoDaddy's databases for security reasons.  I always develop my apps on my local testing server.  See related links below.

WAMP for Windows - http://www.wampserver.com/en/
XAMPP for Windows - http://www.apachefriends.org/en/xampp-windows.html
XAMPP for Mac - http://www.apachefriends.org/en/xampp-macosx.html
MAMP for Mac - http://www.mamp.info/en/downloads/index.html

Setting up a PHP environment in Dreamweaver
http://www.adobe.com/devnet/dreamweaver/articles/setup_php.html

When the app is finished and working locally, I use my local phpMyAdmin to export local SQL data.  Similarly, I log-in to the remote server's phpMyAdmin to import SQL data. 

[BenPleysier]

Yes, I use the extensions all the time, albeit not in Dreamweaver. Fot information on connecting to a database, go to https://www.dmxzone.com/go/32302/connect-to-a-database-and-display-data/

Which extensions have you purchased?

PS: This may also help you https://au.godaddy.com/help/connect-remotely-to-a-mysql-database-in-my-linux-hosting-account-16103

[JimiJonJarniganJunior]

Thanks again for providing good info. Nancy's help has been good as well.

I purchased Database Connector PHP and Security Provided PHP. The other module I installed was Server Connect, which was free.

I'm going to pack it in for the day and pick it back up tomorrow at about 3:00 PM Pacific (after my day job)