Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

ticket smith

Discussion in 'General Discussion' started by carperman, Feb 21, 2002.

  1. carperman

    carperman Well-Known Member

    Joined:
    Feb 7, 2002
    Messages:
    150
    Likes Received:
    0
    Trophy Points:
    316
    Has anyone setup ticketsmith with cpanel?

    I have it installed but have not been able to get support mail delivered to it.

    I have setup a subdomain called support and the support email account is settings is set as support@domain.com

    i have created this account and edited
    /etc/valiases/domain

    with

    support@domain.com: |/home/domain/public_html/support/cgi-bin/gateway.pl


    the install file says this:

    You can also set Ticketsmith up directly with sendmail in
    /etc/aliases:

    support: &|/path/to/gateway.pl&

    Keep in mind that with sendmail you need to either put gateway.pl
    in /etc/smrsh or at least symlink to it from that directory so that
    sendmail will execute it. If you do this, you'll have to point
    the /etc/aliases entry to the copy in /etc/smrsh.



    but i cannnot locate the dir smrsh


    Is there a setting i need to change that is relevent to cpanel setup?


    many thanks
     
    #1 carperman, Feb 21, 2002
  2. alchiba

    alchiba Member

    Joined:
    Aug 19, 2001
    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    301
    It's an either/or situation -- you edit one alias file or the other, but not both. Depends upon which mail program you use.

    Also, you didn't mention that you edited the settings in gateway.pl itself. Did you do that?
     
    #2 alchiba, Feb 21, 2002
  3. carperman

    carperman Well-Known Member

    Joined:
    Feb 7, 2002
    Messages:
    150
    Likes Received:
    0
    Trophy Points:
    316
    hello, i only have the 1st alias option editied

    /etc/valiases/domain
    support@domain.com: |/home/domain/public_html/support/cgi-bin/gateway.pl

    and yes i have edited the gateway.pl, but do i need to change the entry:

    # location of sendmail
    $mailprog = &/usr/sbin/sendmail&;

    to something else if using exim?
     
    #3 carperman, Feb 21, 2002
  4. carperman

    carperman Well-Known Member

    Joined:
    Feb 7, 2002
    Messages:
    150
    Likes Received:
    0
    Trophy Points:
    316
    Hello. ok i got this error message from server which should help to solve issue.


    This message was created automatically by mail delivery software (Exim).

    A message that you sent could not be delivered to one or more of its
    recipients. This is a permanent error. The following address(es) failed:

    pipe to |/home/domain/public_html/support/cgi-bin/gateway.pl
    generated by support@carpemail.com
    Child process of virtual_address_pipe transport returned 2 from command:
    /home/domain/public_html/support/cgi-bin/gateway.pl

    The following text was generated during the delivery attempt:

    ------ pipe to |/home/domain/public_html/support/cgi-bin/gateway.pl
    generated by support@carpemail.com ------

    install_driver(mysql) failed: Can't load '/usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBD/mysql/mysql.so' for module DBD::mysql:
    /usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBD/mysql/mysql.so: undefined symbol: uncompress at
    /usr/lib/perl5/5.00503/i386-linux/DynaLoader.pm line 169, &STDIN& chunk 25.

    at (eval 1) line 3
    Perhaps a required shared library or dll isn't installed where expected
    at /home/domain/public_html/support/cgi-bin/gateway.pl line 142
     
    #4 carperman, Feb 21, 2002
  5. Mat

    Mat Well-Known Member

    Joined:
    Sep 26, 2001
    Messages:
    55
    Likes Received:
    0
    Trophy Points:
    306
    You need to install the perl modules for mysql, DBI::mysql and prolly DBI....
     
    #5 Mat, Feb 21, 2002
  6. Mat

    Mat Well-Known Member

    Joined:
    Sep 26, 2001
    Messages:
    55
    Likes Received:
    0
    Trophy Points:
    306
    And to make sure people won't be abusing your gateway.pl form the web, I suggest you place it bellow the web root, /home/yourusernmae/gateway.pl....
     
    #6 Mat, Feb 21, 2002
  7. Domenico

    Domenico Well-Known Member

    Joined:
    Aug 14, 2001
    Messages:
    363
    Likes Received:
    0
    Trophy Points:
    316
    [quote:cc8f9b2934][i:cc8f9b2934]Originally posted by Mat[/i:cc8f9b2934]

    And to make sure people won't be abusing your gateway.pl form the web, I suggest you place it bellow the web root, /home/yourusernmae/gateway.pl....[/quote:cc8f9b2934]


    In what way can it be abused then?
     
    #7 Domenico, Feb 21, 2002
  8. carperman

    carperman Well-Known Member

    Joined:
    Feb 7, 2002
    Messages:
    150
    Likes Received:
    0
    Trophy Points:
    316
    Thanks for reply,

    i had placed following in .htaccess for domain to protect gateway.pl

    &Files &gateway.pl&&
    order deny,allow
    deny from all
    &/Files&

    i have done a locate for DBI and got the following, because i thought perl modules for mysql, DBI::mysql and prolly DBI were installed.

    does this show them installed? if not how do i checked?



    /home/burst/install/modules/Msql-Mysql-modules-1.2214/lib/DBD
    /home/burst/install/modules/Msql-Mysql-modules-1.2214/lib/DBD/mSQL
    /home/burst/install/modules/Msql-Mysql-modules-1.2214/lib/DBD/mSQL/Install.pm
    /home/burst/install/modules/Msql-Mysql-modules-1.2214/lib/DBD/mSQL1
    /home/burst/install/modules/Msql-Mysql-modules-1.2214/lib/DBD/mSQL1/Install.pm
    /home/burst/install/modules/Msql-Mysql-modules-1.2214/lib/DBD/mysql
    /home/burst/install/modules/Msql-Mysql-modules-1.2214/lib/DBD/mysql/Install.pm
    /home/burst/install/modules/Msql-Mysql-modules-1.2214/lib/DBD/mysql/Install
    /home/burst/install/modules/Msql-Mysql-modules-1.2214/lib/DBD/mysql/Install/Config.pm
    /home/burst/install/modules/Msql-Mysql-modules-1.2214/mSQL/lib/Bundle/DBD
    /home/burst/install/modules/Msql-Mysql-modules-1.2214/mSQL/lib/Bundle/DBD/mSQL.pm
    /home/burst/install/modules/Msql-Mysql-modules-1.2214/mSQL/lib/DBD
    /home/burst/install/modules/Msql-Mysql-modules-1.2214/mSQL/lib/DBD/mSQL.pm
    /home/burst/install/modules/Msql-Mysql-modules-1.2214/mysql/lib/DBD
    /home/burst/install/modules/Msql-Mysql-modules-1.2214/mysql/lib/DBD/mysql.pm
    /home/burst/install/modules/Msql-Mysql-modules-1.2214/mysql/lib/Bundle/DBD
    /home/burst/install/modules/Msql-Mysql-modules-1.2214/mysql/lib/Bundle/DBD/mysql.pm
    /home/burst/install/modules/Msql-Mysql-modules-1.2214/blib/lib/auto/DBD
    /home/burst/install/modules/Msql-Mysql-modules-1.2214/blib/lib/auto/DBD/mysql
    /home/burst/install/modules/Msql-Mysql-modules-1.2214/blib/lib/auto/DBD/mysql/.exists
    /home/burst/install/modules/Msql-Mysql-modules-1.2214/blib/lib/DBD
    /home/burst/install/modules/Msql-Mysql-modules-1.2214/blib/lib/DBD/.exists
    /home/burst/install/modules/Msql-Mysql-modules-1.2214/blib/lib/DBD/mysql.pm
    /home/burst/install/modules/Msql-Mysql-modules-1.2214/blib/lib/Bundle/DBD
    /home/burst/install/modules/Msql-Mysql-modules-1.2214/blib/lib/Bundle/DBD/mysql.pm
    /home/burst/install/modules/Msql-Mysql-modules-1.2214/blib/arch/auto/DBD
    /home/burst/install/modules/Msql-Mysql-modules-1.2214/blib/arch/auto/DBD/mysql
    /home/burst/install/modules/Msql-Mysql-modules-1.2214/blib/arch/auto/DBD/mysql/.exists
    /home/burst/install/modules/Msql-Mysql-modules-1.2214/blib/arch/auto/DBD/mysql/mysql.so
    /home/burst/install/modules/Msql-Mysql-modules-1.2214/blib/arch/auto/DBD/mysql/mysql.bs
    /home/burst/install/modules/Msql-Mysql-modules-1.2214/blib/man3/DBD::mysql.3
    /home/burst/install/modules/Msql-Mysql-modules-1.2214/blib/man3/Bundle::DBD::mysql.3
    /home/burst/install/modules/DBI-1.13/lib/DBD
    /home/burst/install/modules/DBI-1.13/lib/DBD/ExampleP.pm
    /home/burst/install/modules/DBI-1.13/lib/DBD/Proxy.pm
    /home/burst/install/modules/DBI-1.13/lib/DBD/NullP.pm
    /home/burst/install/modules/DBI-1.13/lib/DBD/Sponge.pm
    /home/burst/install/modules/DBI-1.13/lib/DBD/ADO.pm
    /home/burst/install/modules/DBI-1.13/lib/DBI/DBD.pm
    /home/burst/install/modules/DBI-1.13/blib/lib/DBI/DBD.pm
    /home/burst/install/modules/DBI-1.13/blib/lib/DBD
    /home/burst/install/modules/DBI-1.13/blib/lib/DBD/ExampleP.pm
    /home/burst/install/modules/DBI-1.13/blib/lib/DBD/Proxy.pm
    /home/burst/install/modules/DBI-1.13/blib/lib/DBD/NullP.pm
    /home/burst/install/modules/DBI-1.13/blib/lib/DBD/Sponge.pm
    /home/burst/install/modules/DBI-1.13/blib/lib/DBD/ADO.pm
    /home/burst/install/modules/DBI-1.13/blib/man3/DBI::DBD.3
    /home/burst/install/modules/DBI-1.13/blib/man3/DBD::Proxy.3
    /home/burst/install/modules/DBI-1.13/blib/man3/DBD::ADO.3
    /usr/lib/perl5/man/man3/DBD::Proxy.3
    /usr/lib/perl5/man/man3/DBI::DBD.3
    /usr/lib/perl5/man/man3/DBD::ADO.3
    /usr/lib/perl5/man/man3/DBD::mysql.3
    /usr/lib/perl5/man/man3/Bundle::DBD::mysql.3
    /usr/lib/perl5/man/man3/DBD::Multiplex.3
    /usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBD
    /usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBD/mysql
    /usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBD/mysql/mysql.so
    /usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBD/mysql/mysql.bs
    /usr/lib/perl5/site_perl/5.005/i386-linux/Bundle/DBD
    /usr/lib/perl5/site_perl/5.005/i386-linux/Bundle/DBD/mysql.pm
    /usr/lib/perl5/site_perl/5.005/i386-linux/DBD
    /usr/lib/perl5/site_perl/5.005/i386-linux/DBD/ADO.pm
    /usr/lib/perl5/site_perl/5.005/i386-linux/DBD/ExampleP.pm
    /usr/lib/perl5/site_perl/5.005/i386-linux/DBD/NullP.pm
    /usr/lib/perl5/site_perl/5.005/i386-linux/DBD/Proxy.pm
    /usr/lib/perl5/site_perl/5.005/i386-linux/DBD/Sponge.pm
    /usr/lib/perl5/site_perl/5.005/i386-linux/DBD/mysql.pm
    /usr/lib/perl5/site_perl/5.005/i386-linux/DBD/Multiplex.pm
    /usr/lib/perl5/site_perl/5.005/i386-linux/DBI/DBD.pm
     
    #8 carperman, Feb 21, 2002
  9. alchiba

    alchiba Member

    Joined:
    Aug 19, 2001
    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    301
    According to the readme, DBI is the only extra Perl lib you'll need to make this work. Not to send you off on a tangent, but a handy way to check installed modules is with the PerlDiver script which you can get for free at http://www.scriptsolutions.com

    Then you can just install the module via WHM if it doesn't show up in PerlDiver.
     
    #9 alchiba, Feb 21, 2002
  10. carperman

    carperman Well-Known Member

    Joined:
    Feb 7, 2002
    Messages:
    150
    Likes Received:
    0
    Trophy Points:
    316
    according to perldiver dbi is installed :(
     
    #10 carperman, Feb 21, 2002
  11. alchiba

    alchiba Member

    Joined:
    Aug 19, 2001
    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    301
    [quote:b6630a7208][i:b6630a7208]Originally posted by carperman[/i:b6630a7208]
    install_driver(mysql) failed: Can't load '/usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBD/mysql/mysql.so' for module DBD::mysql:
    /usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBD/mysql/mysql.so: undefined symbol: uncompress at
    /usr/lib/perl5/5.00503/i386-linux/DynaLoader.pm line 169, &STDIN& chunk 25.
    [/quote:b6630a7208]

    Probably grabbing at straws, but maybe it's a server config issue. The error above tells me it can't find mysql.so and then it can't understand a symbol it's looking for in that file. The problem may be outside of your Perl implementation.

    Also, check PerlDiver again and make sure you've got DBD::MySQL installed

    That's about the best I can do. Sorry.
     
    #11 alchiba, Feb 21, 2002
  12. carperman

    carperman Well-Known Member

    Joined:
    Feb 7, 2002
    Messages:
    150
    Likes Received:
    0
    Trophy Points:
    316
    thanks for help, may try re-install DBD::MySQL

    be my first install of this type so wish me luck :)
     
    #12 carperman, Feb 21, 2002
(You must log in or sign up to post here.)
Loading...
Similar Threads - ticket smith
  1. Terry Robertson

    AutoSSL Support Ticket

    Terry Robertson, Jan 17, 2017, in forum: General Discussion
    Replies:
    2
    Views:
    335
    cPanelJesse
    Jan 19, 2017
  2. jazee

    Having to Re-Enter Contact/Server Info On Every Cpanel Support Ticket

    jazee, Aug 11, 2016, in forum: General Discussion
    Replies:
    5
    Views:
    471
    ruzbehraja
    Aug 22, 2016

Share This Page