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:
    16
    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
     
  2. alchiba

    alchiba Member

    Joined:
    Aug 19, 2001
    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    1
    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?
     
  3. carperman

    carperman Well-Known Member

    Joined:
    Feb 7, 2002
    Messages:
    150
    Likes Received:
    0
    Trophy Points:
    16
    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?
     
  4. carperman

    carperman Well-Known Member

    Joined:
    Feb 7, 2002
    Messages:
    150
    Likes Received:
    0
    Trophy Points:
    16
    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
     
  5. Mat

    Mat Well-Known Member

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

    Mat Well-Known Member

    Joined:
    Sep 26, 2001
    Messages:
    55
    Likes Received:
    0
    Trophy Points:
    6
    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....
     
  7. Domenico

    Domenico Well-Known Member

    Joined:
    Aug 14, 2001
    Messages:
    362
    Likes Received:
    0
    Trophy Points:
    16
    [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?
     
  8. carperman

    carperman Well-Known Member

    Joined:
    Feb 7, 2002
    Messages:
    150
    Likes Received:
    0
    Trophy Points:
    16
    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
     
  9. alchiba

    alchiba Member

    Joined:
    Aug 19, 2001
    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    1
    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.
     
  10. carperman

    carperman Well-Known Member

    Joined:
    Feb 7, 2002
    Messages:
    150
    Likes Received:
    0
    Trophy Points:
    16
    according to perldiver dbi is installed :(
     
  11. alchiba

    alchiba Member

    Joined:
    Aug 19, 2001
    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    1
    [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.
     
  12. carperman

    carperman Well-Known Member

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

    be my first install of this type so wish me luck :)
     
Loading...

Share This Page