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

So I went into SSH and entered locate mysql.pm . It gave me this:

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

Huh? I thought I already created the database in cpanel.
So in SSH, I entered updatedb. It gave me:

fatal error: updatedb: you are not authorized to create a default slocate database!

I even tried uploading the install.cgi file to the new server. When I tried to run it, I got a 500 Internal Server Error.

What am I missing? I'd rather not delete everything and have to re-install the whole thing.

Any help would be appreciated.

Vito

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

Geez, I really have to learn how to get around with Unix commands...


Vito

"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.

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.
Sorry. I don't know what you mean.
Sometimes, I just feel dumber than a bag of hammers... :dunce:

As always, thanks for your help.
Vito

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.

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. :)

Vito

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.

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.

Vito

It should not overwrite the DB files but backup to make sure and yeah you can just FTP your tpl files after the install.

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?

Vito

Originally posted by vito

BTW, what happened to Perldesk's forum? Do they no longer have one?

The developer has stated here that the forums would be back with the release of version 1.6. No ETA was given, though.

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.

:angry: :angry: :angry: :angry:

Vito

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'

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.

Vito

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.