ticket smith

[carperman]

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 [email protected]

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

with

[email protected]: |/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

 

[alchiba]

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?

 

[carperman]

hello, i only have the 1st alias option editied

/etc/valiases/domain
[email protected]: |/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?

 

[carperman]

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 [email protected]
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 [email protected] ------

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

 

[Mat]

You need to install the perl modules for mysql, DBI::mysql and prolly DBI....

 

[Mat]

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

 

[Domenico]

[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?

 

[carperman]

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

 

[alchiba]

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.

 

[carperman]

according to perldiver dbi is installed

 

[alchiba]

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

 

[carperman]

thanks for help, may try re-install DBD::MySQL

be my first install of this type so wish me luck