Results 1 to 15 of 15
  1. #1
    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
    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
    DemoDemo.com - Flash tutorials since 2002
    DemoWolf.com - 5,300+ Flash tutorials for hosting companies, incl. Voice tutorials

  2. #2
    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
    Geez, I really have to learn how to get around with Unix commands...


    Vito
    DemoDemo.com - Flash tutorials since 2002
    DemoWolf.com - 5,300+ Flash tutorials for hosting companies, incl. Voice tutorials

  3. #3
    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.

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

    As always, thanks for your help.
    Vito
    DemoDemo.com - Flash tutorials since 2002
    DemoWolf.com - 5,300+ Flash tutorials for hosting companies, incl. Voice tutorials

  5. #5
    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.

  6. #6
    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.

    Vito
    DemoDemo.com - Flash tutorials since 2002
    DemoWolf.com - 5,300+ Flash tutorials for hosting companies, incl. Voice tutorials

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

  8. #8
    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.

    Vito
    DemoDemo.com - Flash tutorials since 2002
    DemoWolf.com - 5,300+ Flash tutorials for hosting companies, incl. Voice tutorials

  9. #9
    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.

  10. #10
    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?

    Vito
    DemoDemo.com - Flash tutorials since 2002
    DemoWolf.com - 5,300+ Flash tutorials for hosting companies, incl. Voice tutorials

  11. #11
    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?
    The developer has stated here that the forums would be back with the release of version 1.6. No ETA was given, though.
    Jim
    RotoHOST.com
    webhosting solutions for e-Business

  12. #12
    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.



    Vito
    DemoDemo.com - Flash tutorials since 2002
    DemoWolf.com - 5,300+ Flash tutorials for hosting companies, incl. Voice tutorials

  13. #13
    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

  14. #14
    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.

    Vito
    DemoDemo.com - Flash tutorials since 2002
    DemoWolf.com - 5,300+ Flash tutorials for hosting companies, incl. Voice tutorials

  15. #15
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •