I love this script, but twice now I have had the script fail when the web hosting company changed their server software.

The problem manifests itself in the following way.

Before the change everything works perfectly. Once the change is made (in the most recent case to Apache/1.3.9 (Unix) PHP/3.0.12) the script starts to generate a 500 error. I can get around this error by changing the permissions of the db.cgi file to:

-rwxr-xr-x

This allows people to view record and search for records, but when you try to modify a record you get an error. It is reported by the script in the following way:

Error Message: error in modify_records. unable to open db file: ./vpress.db.
Reason: Operation not permitted

I am trying to convince my client to go with this script, but I don't feel that I can do so if it stops working every time the web hosting company upgrades.

Please help!

You also need to change the permission of your other files.

For the database file, you need to change the permission to 666 (rw-rw-rw-).

Regards.

------------------
Eliot Lee
Anthro TECH,L.L.C
www.anthrotech.com
----------------------

All of the other file permissions are set properly. That is the first thing I checked. I need another solution.

 
This means that the permission of your db file is NOT correct and the server cannot open or acces it.

The solution is CHANGING THE PERMISSIONS OF THE DIRECTORY AND FILE!

Regards.

------------------
Eliot Lee
Anthro TECH,L.L.C
www.anthrotech.com
----------------------

I am not trying to be a pest here, but the permission are set properly. I have had this script working before the server move and I have reset the permission after the move. Here they are:

drwxrwxrwx 4 vehicule users 1024 Dec 10 10:33 .
drwxr-xr-x 4 vehicule users 1024 Dec 10 10:21 ..
drwxrwxrwx 2 vehicule users 1024 Dec 14 11:08 auth
-rw-r--r-- 1 vehicule users 6606 Nov 29 18:41 auth.pl
-rwxr-xr-x 1 vehicule users 46901 Nov 29 18:41 db.cgi
-rw-r--r-- 1 vehicule users 8362 Nov 29 18:41 default.cfg
-rw-rw-rw- 1 vehicule users 3 Nov 29 18:41 default.count
-rw-rw-rw- 1 vehicule users 1135 Nov 29 18:41 default.log
-rw-rw-rw- 1 vehicule users 141 Dec 10 15:30 default.pass
-rw-r--r-- 1 vehicule users 594 Nov 29 18:42 generalnew.css
-rw-r--r-- 1 vehicule users 70086 Dec 11 14:00 html.pl
drwxr-xr-x 2 vehicule users 1024 Nov 29 18:42 images
-rw-r--r-- 1 vehicule users 8368 Nov 29 18:42 vpress.cfg
-rw-rw-rw- 1 vehicule users 170637 Dec 10 16:34 vpress.db
-rw-rw-rw- 1 vehicule users 37989 Dec 14 11:08 vpress.log
-rw-r--r-- 1 vehicule users 46934 Nov 29 18:42 vpress_html.pl

As you can see, the only permission that does not conform to your instructions is the db.cgi. As I said, when I change db.cgi's permissions to -rwxr--r-- I get a Internal Server error.

It would seem that both of these problems are related.

Thank you for your patients.

The db.cgi file must be 755 (rwx-r-xr-x).

Good luck.

Regards.

------------------
Eliot Lee
Anthro TECH,L.L.C
www.anthrotech.com
----------------------

Thanks for the permissions setting for db.cgi. I will correct the misprint in the instructions. As you can see I already have the dg.cgi permissions set to rwxr-xr-x.

However, the original problem still exists. I cannot modify the database. All of my permissions are set properly and I am still getting this message:

Error Message: error in modify_records. unable to open db file: ./vpress.db.
Reason: Operation not permitted

Again that error message means that your database file is not set to be read or written for everyone and groups. Make sure that it is set to 666 (rw-rw-rw-).

Regards.

------------------
Eliot Lee
Anthro TECH,L.L.C
www.anthrotech.com
----------------------