Gossamer Forum
Home : Products : DBMan : Customization :

Upgrade Database (upgrade.cgi)

Quote Reply
Upgrade Database (upgrade.cgi)
Trying to implement Eliot's subj mod, but keep getting 500 errors. I updated my default.cfg first, based on the new field #17 (LastModified), then uploaded my upgrade.cgi, but get the 500 errors. I've posted .txt files as follows http://home.flash.net/~murgnam/default.txt
http://home.flash.net/~murgnam/upgrade.txt
What am I missing?
JR


------------------
Joebagodonuts, JR or Anita
http://home.flash.net/~murgnam/
Quote Reply
Re: Upgrade Database (upgrade.cgi) In reply to
When are you getting the errors? When you run the upgrade script or when you run DBMan that has been upgraded?


------------------
JPD





Quote Reply
Re: Upgrade Database (upgrade.cgi) In reply to
When I run the script
Quote Reply
Re: Upgrade Database (upgrade.cgi) In reply to
I don't find any syntax errors in the script. The only thing I can think of is that your path to Perl might be wrong or you uploaded in ASCII mode.

If neither one of those are the case, check your path to the files.

If that's correct, I'll need to defer to Eliot, since he's the one who wrote the script. Smile


------------------
JPD





Quote Reply
Re: Upgrade Database (upgrade.cgi) In reply to
D'oh. Do I need to upload the upgrade in binary NOT ASCII?
Quote Reply
Re: Upgrade Database (upgrade.cgi) In reply to
Uh...no..you need to upload the file in ASCII.

Change the permission to 755.

And make changes in the paths as instructed in the file.

Haven't we been through this before???

Regards,

------------------
Eliot Lee....
Former Handle: Eliot
* Check Resource Center
* Search Forums
Quote Reply
Re: Upgrade Database (upgrade.cgi) In reply to
Eliot,

Yes, we've been thru this before!

Yes, I did the default.cfg changes first, yes I put the correct paths in the script, yes I uploaded in ASCII and chmod 755.

With the above, when I execute from my browser it doesn't work (500 error), so I posted this question. I was "hoping" that perhaps someone could see what I might be doing wrong, guess yr not the one to ask! Sorry!
Quote Reply
Re: Upgrade Database (upgrade.cgi) In reply to
...found the problem. The updgrade.txt link I provided above was missing an essential element ...
Quote:
# Database path...same as in db.cgi file

$db_script_path = '/path/to/cgi-bin/dbman';
, which must've been added to the original mod in the Resource Center since I initially d/l this mod -- if memory serves, Eliot said something 'bout someone not so politely pointing that out to him a while back.

I apologize for my above comments, as I prob shoulda "re"checked the Resource Center for the "latest" codes.

Above said, question's: The output states,
Quote:
Database saved it as /home/m/u/murgnam/www/cgi-bin/Directory/default2.db.
Change permissions back to 755 on the data directory.
This means
chmod 755 "Directory" on the Remote Site"?

Also,
Quote:
You must rename '/home/m/u/murgnam/www/cgi-bin/Directory/default.db' to '/home/m/u/murgnam/www/cgi-bin/Directory/default2.db' to '/home/m/u/murgnam/www/cgi-bin/Directory/default.db' before using with DBMAN.
This means rename on the remote site, right? not on the local system?

Finally,
Quote:
Make sure that your new database is changed to 666.
... means the new default.db should be chmod 666, right?

Realize the above may seem like more stupid question's, but now that I've got the "correct" script, I want to make sure I configure it right, <g>

JR

Quote Reply
Re: Upgrade Database (upgrade.cgi) In reply to
I would recommend that you do the following:

1) Check your Perl Error Log File. If you do not have access to this Log File, then do the following:

2) Check the syntax of the script, with the following commands in telnet:

a) Connect to the directory where this script is located:

Code:
cd /cgi-bin/dbman/

b) Check the syntax of the file:

Code:
perl -c upgrade.cgi

Then paste the syntax errors you are receiving.

Also, try executing this script via telnet, with the following commands:

a) Connect to the directory where this script is located:

Code:
cd /cgi-bin/dbman/

b) Execute the script:

Code:
perl upgrade.cgi

Regards,

------------------
Eliot Lee....
Former Handle: Eliot
* Check Resource Center
* Search Forums