Live Data / Problem with file permissions

[nigelssuk]

Just trying out an old version of Dreamweaver MX 2004. I am using my webhosting service for remote server/testing server duties. It is running PHP 4.3.10 and MySQL 3.23.58. I was able to set up the database connection and test-retrieve a recordset with no problems. In following the tutorial I found that Livedata wouldn't work, it just giving me a warning about file permissions being wrong. It turns out that when Dreamweaver creates a temporary file of the work-in-progress to upload to the remote server the file is created on the server with owner=rw, group=rw, world=r which explains why it won't run - group has to be set to group=r. The file is created on the fly and then immediately deleted by Dreamweaver so it is impossible to manually set the permission on the server and probably fairly pointless too.

I tried just saving the file and previewing in the browser which again causes it to be uploaded to the remote server. The first time this resulted in the browser offering a file download box instead of running the page. The reason is - again - that Dreamweaver is setting the uploaded file permissions to include group=rw. If I manually set the permission for group to group=r it runs fine.

It turns out that Dreamweaver is always setting the file permissions on file uploads (checked php and html) to the remote/testing server to include group=rw. Once I set it manually on the remote/testing server to group=r for a php file everything is fine and subsequent uploads of the same file do not change it again.

I checked with the webhosting company and their second-line have reported back to me that the default file permission they set on uploaded files includes group=r so it must be DW that is causing the problem by setting group=rw the first time. I confirmed this by using WS-FTP to upload the same file (renamed) to the same target directory and the permissions set were owner=rw, group=r, world=r.

So

Can anyone please tell me how to change the permissions DW sets on files written to a remote server because I have spent countless hours on it without success. From looking at other posts in this forum it could be that other users are hitting the same kind of problem with DW8

[Newsgroup_User]

Stop using Live Data with a hosting account. Set up PHP and MySQL locally on
your machine. That is how it's supposed to work. You shouldn't test files on
the fly on a host as you write them. Change your test account in DW to use
the local server. Upload your files to your remote server after they are
fully tested.

Tom Muck
http://www.tom-muck.com/

"nigelssuk" <webforumsuser@macromedia.com> wrote in message
news:ep3rqe$8mf$1@forums.macromedia.com...
> Just trying out an old version of Dreamweaver MX 2004. I am using my
> webhosting
> service for remote server/testing server duties. It is running PHP 4.3.10
> and
> MySQL 3.23.58. I was able to set up the database connection and
> test-retrieve a
> recordset with no problems. In following the tutorial I found that
> Livedata
> wouldn't work, it just giving me a warning about file permissions being
> wrong.
> It turns out that when Dreamweaver creates a temporary file of the
> work-in-progress to upload to the remote server the file is created on the
> server with owner=rw, group=rw, world=r which explains why it won't run -
> group
> has to be set to group=r. The file is created on the fly and then
> immediately
> deleted by Dreamweaver so it is impossible to manually set the permission
> on
> the server and probably fairly pointless too.
>
> I tried just saving the file and previewing in the browser which again
> causes
> it to be uploaded to the remote server. The first time this resulted in
> the
> browser offering a file download box instead of running the page. The
> reason is
> - again - that Dreamweaver is setting the uploaded file permissions to
> include
> group=rw. If I manually set the permission for group to group=r it runs
> fine.
>
> It turns out that Dreamweaver is always setting the file permissions on
> file
> uploads (checked php and html) to the remote/testing server to include
> group=rw. Once I set it manually on the remote/testing server to group=r
> for a
> php file everything is fine and subsequent uploads of the same file do not
> change it again.
>
> I checked with the webhosting company and their second-line have reported
> back
> to me that the default file permission they set on uploaded files includes
> group=r so it must be DW that is causing the problem by setting group=rw
> the
> first time. I confirmed this by using WS-FTP to upload the same file
> (renamed)
> to the same target directory and the permissions set were owner=rw,
> group=r,
> world=r.
>
> So
>
> Can anyone please tell me how to change the permissions DW sets on files
> written to a remote server because I have spent countless hours on it
> without
> success. From looking at other posts in this forum it could be that other
> users
> are hitting the same kind of problem with DW8
>

[nigelssuk · Accepted solution]

Dreamweaver specifically supports the option to use a remote server for testing purposes. It seems reasonable to test the site locally using the actual remote environment in which it is to operate if the site is not already live.

It turns out that the problem for me is related to having the remote server and testing server connections set to use SFTP. This caused the files created on the remote server to have RW set for group which was what caused all the problems. When set to use standard FTP everything is fine - file permissions get set correctly on upload and live data works as expected.

Another SFTP side-effect was that the site FTP log only contained blank lines - lots of them got added every time the remote server was accessed but no text. On setting the connection to standard FTP the log fills up with messages as expected.

[Newsgroup_User]

nigelssuk wrote:
> Anyway, it turns out that the problem for me is related to having the remote
> server and testing server connections set to use SFTP. This caused the files
> created on the remote server to have RW set for group which was what caused all
> the problems. When set to use standard FTP everything is fine - file
> permissions get set correctly on upload and live data works as expected.
>
> Another SFTP side-effect was that the site FTP log only contained blank lines
> - lots of them got added every time the remote server was accessed but no text
> was output to the log. On setting the connection to standard FTP the log fills
> up with messages as expected.

Even though you're working with MX 2004, I suggest that you report those
findings to the Dreamweaver team. Your scenario is relatively uncommon,
so it's quite possible that no one has come across this in testing. Even
if it can't be fixed easily, your solution should be added as a
Technote. You can report issues like this here:

http://www.adobe.com/cfusion/mmform/index.cfm?name=wishform

--
David Powers, Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/