Results 1 to 15 of 15
Thread: PerlDesk assistance, please...
-
08-11-2002, 06:58 PM #1Eternal Member
- Join Date
- Jan 2002
- Location
- Toronto, Canada
- Posts
- 11,052
PerlDesk assistance, please...
I moved a site to a new server that had PerlDesk installed. On the new server, I did not do a fresh install. This is what I did:
1. On the new server I created a new database.
2. I downloaded all the files from the PerlDesk directory of the old server
3. I made the necessary db and username changes to conf.pl and email.pl
4. I did a dbdump off the db on my old server and loaded it into my new db
5. I uploaded all the files to the PerlDesk directory on the new server
When I try to point to pdesk.cgi on the new server, I get this:
PerlDesk: Script Error
Perldesk was unable to launch due to the following errors:
install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: /usr/lib/perl5/5.6.1/i686-linux /usr/lib/perl5/5.6.1 /usr/lib/perl5/site_perl/5.6.1/i686-linux /usr/lib/perl5/site_perl/5.6.1 /usr/lib/perl5/site_perl/5.6.0 /usr/lib/perl5/site_perl .) at (eval 1) line 3. Perhaps the DBD::mysql perl module hasn't been fully installed, or perhaps the capitalisation of 'mysql' isn't right. Available drivers: ExampleP, Multiplex, Proxy. at pdesk.cgi line 38
warning: locate: could not open database: /var/lib/slocate/slocate.db: permission denied
warning: you need to run the 'updatedb' command (as root) to create the database
So in SSH, I entered updatedb. It gave me:
fatal error: updatedb: you are not authorized to create a default slocate database!
What am I missing? I'd rather not delete everything and have to re-install the whole thing.
Any help would be appreciated.
VitoDemoDemo.com - Flash tutorials since 2002
DemoWolf.com - 5,300+ Flash tutorials for hosting companies, incl. Voice tutorials
-
08-11-2002, 07:09 PM #2Eternal Member
- Join Date
- Jan 2002
- Location
- Toronto, Canada
- Posts
- 11,052
Hmm. I don't know if this helps:
In SSH I entered whereis mysql.pm and got:
mysql: usr/bin/mysql usr/lib/mysql usr/include/mysql usr/share/mysql usr/man/man1/mysql.1.gz
VitoDemoDemo.com - Flash tutorials since 2002
DemoWolf.com - 5,300+ Flash tutorials for hosting companies, incl. Voice tutorials
-
08-11-2002, 07:15 PM #3Web Hosting Master
- Join Date
- Apr 2002
- Location
- USA
- Posts
- 5,783
"Perhaps the DBD::mysql perl module hasn't been fully installed"
Make sure this module is installed on the server. If you are root from cpanel do a repair on the MYSQL database if not get your host to.
Can you see the database and all the tables from your cpanel Admin console? If so make sure the data is intact and check to insure the user and password files transfered properly.
-
08-11-2002, 07:28 PM #4Eternal Member
- Join Date
- Jan 2002
- Location
- Toronto, Canada
- Posts
- 11,052
Thanks Monte.
I believe all the Perl modules are installed. I ran scheck.pl and it said everything was OK. I even double-checked with my host and he confirmed it (wow, nice to finally have a host that actually replies to support tickets!)
In phpmyadmin I can see that the db is set up and all the tables are there (and populated with my data from the old server).
If you are root from cpanel do a repair on the MYSQL database if not get your host to.
Sometimes, I just feel dumber than a bag of hammers...
As always, thanks for your help.
VitoDemoDemo.com - Flash tutorials since 2002
DemoWolf.com - 5,300+ Flash tutorials for hosting companies, incl. Voice tutorials
-
08-11-2002, 07:33 PM #5Web Hosting Master
- Join Date
- Apr 2002
- Location
- USA
- Posts
- 5,783
From your cpanel front page you can view installed perl modules double check to make sure the module is installed.
Your host from root WHM has a repair tool for MySql databases get him to run it on your database.
-
08-11-2002, 07:37 PM #6Eternal Member
- Join Date
- Jan 2002
- Location
- Toronto, Canada
- Posts
- 11,052
Hmm. I'll take a look in cpanel, but I'm sure the modules are installed. When I ran scheck.pl, I got:
Required Modules [ OK ]
Your server has all the required modules to run PerlDesk.
But I'll check anyways. I'll also ask my host to run the repair.
Thanks, Monte. You always seem to be there to give me a hand. I appreciate it.
VitoDemoDemo.com - Flash tutorials since 2002
DemoWolf.com - 5,300+ Flash tutorials for hosting companies, incl. Voice tutorials
-
08-11-2002, 07:46 PM #7Web Hosting Master
- Join Date
- Apr 2002
- Location
- USA
- Posts
- 5,783
IF that does not work make sure you have a backup on your local drive and run Install.cgi again as the paths may be differnet coming from a Plesk to a Cpanel server.
-
08-11-2002, 07:51 PM #8Eternal Member
- Join Date
- Jan 2002
- Location
- Toronto, Canada
- Posts
- 11,052
Yup, if all else fails, I guess a fresh install is in order. If I do that, after the install, would I just have to upload the tpl files to the new server to keep all my customizations? And I guess also put in the dbdump to re-populate the db with all my old data?
BTW, the paths are in fact different from Plesk to cpanel. But I triple-checked them and they are correct in my config files.
I've put in a request to my host. I'll just wait and go from there.
VitoDemoDemo.com - Flash tutorials since 2002
DemoWolf.com - 5,300+ Flash tutorials for hosting companies, incl. Voice tutorials
-
08-11-2002, 07:53 PM #9Web Hosting Master
- Join Date
- Apr 2002
- Location
- USA
- Posts
- 5,783
It should not overwrite the DB files but backup to make sure and yeah you can just FTP your tpl files after the install.
-
08-12-2002, 09:15 AM #10Eternal Member
- Join Date
- Jan 2002
- Location
- Toronto, Canada
- Posts
- 11,052
Well, I guess I'll have to just do a fresh install. The repair didn't work.
BTW, what happened to Perldesk's forum? Do they no longer have one?
VitoDemoDemo.com - Flash tutorials since 2002
DemoWolf.com - 5,300+ Flash tutorials for hosting companies, incl. Voice tutorials
-
08-12-2002, 11:26 AM #11Aspiring Evangelist
- Join Date
- Sep 2000
- Location
- New Jersey, U.S.A.
- Posts
- 354
Originally posted by vito
BTW, what happened to Perldesk's forum? Do they no longer have one?Jim
RotoHOST.com
webhosting solutions for e-Business
-
08-12-2002, 11:29 AM #12Eternal Member
- Join Date
- Jan 2002
- Location
- Toronto, Canada
- Posts
- 11,052
Thanks, Rotohost.
Well, I guess then I'll have to try to figure this out with the help of my host. I tried doing a fresh install, and I keep getting the dreaded 500 Internal Server Error when trying to run install.cgi.
VitoDemoDemo.com - Flash tutorials since 2002
DemoWolf.com - 5,300+ Flash tutorials for hosting companies, incl. Voice tutorials
-
08-12-2002, 11:47 AM #13Aspiring Evangelist
- Join Date
- Sep 2000
- Location
- New Jersey, U.S.A.
- Posts
- 354
Also, be sure to set the permissions correctly on all the .cgi files.
From the installation readme:
INSTALLATION
-------------------------------------------------------
[*] Untar the compressed file 'tar zxvf filename.tar.gz'
Or use a utility such as WinRAR/WinZip
By default, there are two directories in the file
cgi-bin
images
The files inside the 'cgi-bin' can be placed anywhere
where you have .cgi files enabled on your server, but
if you put them in the actual cgi-bin you will likely
need to store the images outside of the cgi-bin due to
permissions.
[*] Upload files in ASCII, and images in BINARY
[*] Chmod all .cgi files to 755, if you plan to edit
the templates via the admin section, you will also
need to make the template files writable. 777.
(include/tpl)
cd /path/to/perldesk
chmod -R 755 *.cgi
[*] Set the mysql connection settings in the conf.pl file
[*] You will then need to run install.cgi to setup
the sql structure
[*] Log in to the /admin.cgi file, 'admin/demo'Jim
RotoHOST.com
webhosting solutions for e-Business
-
08-12-2002, 11:51 AM #14Eternal Member
- Join Date
- Jan 2002
- Location
- Toronto, Canada
- Posts
- 11,052
Yes, thanks. I've triple checked all the permissions, all the paths, checked to make sure all required Perl modules are installed, etc. I've actually installed Perldesk a few times on a few different servers, so I'm getting pretty used to the procedure. But for some reason, I can't get it to work on this server.
VitoDemoDemo.com - Flash tutorials since 2002
DemoWolf.com - 5,300+ Flash tutorials for hosting companies, incl. Voice tutorials
-
08-12-2002, 11:58 AM #15Web Hosting Master
- Join Date
- Apr 2002
- Location
- USA
- Posts
- 5,783
Vito
add -wt to the sha bang line of install.cgi /usr/bin/perl -wt
Then check your error log from cpanel that should cause perl to spit out the reason it is giving you a 500 error.