WARNING: InstallApacheCGI could not delete (panorama.cgi)

Moving forward thanks to Jeff Kozuch, but still not there.

In a Finder window, while viewing the contents of my primary hard disk, I did a Command-Shift-. which revealed my hidden files and directories. I then navigated to /etc/apache2/httpd.conf and opened it with BBEdit. I uncommented the following line by removing the # at the beginning of the line…

LoadModule cgi_module libexec/apache2/mod_cgi.so

Further down in the httpd.conf file, I found the section that started with…

<Directory "/Library/WebServer/CGI-Executables">

I changed the contents of that section to…

Allow Override None
Options ExecCGI
AddHandler cgi-script .cgi .pl .tcl .py
Require all granted

I saved the altered .conf file and restarted my server.

Now on the client machine running Panorama, when I used the Available Servers dialog, and entered the remote IP address of the server, up popped the Server name and its IP address. Cool. Onward.

I created a small database and opened Wizards/Sharing/Database Sharing Options. The file name displayed in the ‘Choose your database…’. I selected the remote server from the popdown. I checked the Local Database Sharing option, the Internet Database Sharing Option, & the Web Publishing. (If I unselected the Local Database Sharing checkbox, I then lost the Internet Database Sharing box from being checked.) When I pressed the Apply Changes button, a dialog presented asking that I confirm the settings. I pressed apply options and then I got another dialog:

Database: Transactions
Config updated.
Closed on server
Opened for sharing on server.
Complete.

All seemed good to go. But alas…

I got errors on the server with a dialog stating something to the effect of ‘No window can be found.’ I also had errors when attempting to edit a record on the shared database.

My last paragraph is vague because as I tried to document what I did, by repeating the sequence a few times, omg, the thing started working. I’m not sure what I did but I repeatedly set about sharing the file with the Database Sharing Options:Expert window and somehow it started working. Woo Hoo. Enough for tonight.

Thanks again Jeff to push me in the right direction.