Install RT4, error free!

[a-ml]

Hello All,

Please need you support, I’m at the very beginning… I’m running the command

./configure

at RT5 folder and, it returns the error

checking for perl… not found
configure: erro: cannot use RT without perl

---

perl -v

This is perl 5, version 34, subversion 0 (v5.34.0) built for x86_64-linux

OS: RedHat 8

[knation]

Hmm that’s strange, whats the output of which perl?

[a-ml]

which perl

returns: /usr/local/bin/perl

[a-ml]

I’ve fixed the perl issue.

Now I’m running the make fixdeps and its returning

MYSQL dependencies:

DBD::mysql >= 2.1018, != 4.042… MISSING

Trying to install manually, I’m receiving the error bellow.

Test Summary Report

t/rt118977-zerofill.t (Wstat: 256 Tests: 8 Failed: 1)
Failed test: 8
Non-zero exit status: 1
Files=73, Tests=2315, 37 wallclock secs ( 0.35 usr 0.09 sys + 5.76 cusr 0.90 csys = 7.10 CPU)
Result: FAIL
Failed 1/73 test programs. 1/2315 subtests failed.
make: *** [Makefile:1216: test_dynamic] Error 255
DVEEDEN/DBD-mysql-4.050.tar.gz
/bin/make test – NOT OK
//hint// to see the cpan-testers results for installing this module, try:
reports DVEEDEN/DBD-mysql-4.050.tar.gz
Failed during this command:
DVEEDEN/DBD-mysql-4.050.tar.gz : make_test NO

cpan[6]> reports DVEEDEN/DBD-mysql-4.050.tar.gz
Distribution: D/DV/DVEEDEN/DBD-mysql-4.050.tar.gz
Fetching ‘http://www.cpantesters.org/show/DBD-mysql.yaml’…DONE

Catching error: “CPAN::Exception::yaml_process_error=HASH(0x55f8996c33c0)” at /usr/share/perl5/vendor_perl/CPAN.pm line 392.
CPAN::shell() called at -e line 1

Any help please

[knation]

Did you install MySQL via the RedHat package manager?

[a-ml]

Yes!
I’ve installed the mysql and mysql-server via yum install

[a-ml]

fixed the DBD::mysql

[a-ml]

Hello Guys,

Coming again to you guys to ask for Help in this journey of installing trying to get RT running for my team…

I’ve finished the installation… now I’m trying to configure it… with make initialize-database and it raises the error bellow, any hint?

[540388] [Tue Aug 10 12:27:38 2021] [critical]: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘Groups (
id INTEGER NOT NULL AUTO_INCREMENT,
Name varchar(200) NULL ,
De’ at line 1 at /home/sagisc/rt-5.0.1/sbin/…/lib/RT/Handle.pm line 551. (/home/sagisc/rt-5.0.1/sbin/…/lib/RT.pm:409)
DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘Groups (
id INTEGER NOT NULL AUTO_INCREMENT,
Name varchar(200) NULL ,
De’ at line 1 at /home/sagisc/rt-5.0.1/sbin/…/lib/RT/Handle.pm line 551.
make: *** [Makefile:390: initialize-database] Error 11

[knation]

Are you using MySQL 8? RT doesn’t support that version of MySQL yet as there are some breaking changes

[a-ml]

Hi @knation

Thanks for your reply. My mistake
On README It says MySQL 5.7 and I haven’t seen that.
I’ll remove the MySQL installation and you know any progress.

[Jeff_Voskamp]

If you’re comfortable with version control there is a Mysql 8 branch that should be mergeable into the 5.0.1 branch.
If you don’t know what I’m ta\king about or where to go from here this solution may not be for you.

[a-ml]

Hi All,

I’ve installed the MySQL 5.7 and the initialize-database worked as expected.

Its normally to be stuck after running the command sudo /opt/rt5/sbin/rt-server ? because in the README it says to run the command and follow the instructions, but I don’t receive any instructions after running the command.

[knation]

Can you hit the web server from the browser?

[a-ml]

Tried with Lynx and it open a login screen

[knation]

Sounds like it works!

[a-ml]

It seems that its working but… can you point me out to a guide for post installation process? Because in README its a little confused at least for me.

[knation]

It says to look at step seven which points to this page:
https://docs.bestpractical.com/rt/5.0.1/web_deployment.html

[tan33]

a-ml, congrats. Unfortunately, RT does not hold your hand through the post-install process. It’s going to be it’s own separate, trial-by-error journey. I ran into the same problem you did; there was absolutely no information about how to set up RT. I just had to Google it. Good luck!

[GreenJimll]

Don’t forget folks that if you do get stuck you can always pay the nice folk at Best Practical for some consultancy to help you with RT. Still be cheaper than lots of other ticketing/helpdesk systems.

[certified-c0mp-geek]

@knation

My notes for an Ubuntu 16 install:

sudo apt-get install libgd-dev libgraphviz-dev graphviz autoconf apache2 libapache2-mod-fcgid slapd ldap-utils expat openssl libssl-dev

Install standalone Perl for RT:

   $ wget http://www.cpan.org/src/5.0/perl-5.26.3.tar.gz
   $ tar -xzf perl-5.26.3.tar.gz
   $ cd perl-5.26.3
   $ sudo ./Configure -des -Dprefix=/opt/perl5
   $ sudo make
   $ sudo make test
   $ sudo make install

Use new Perl install:

 $ export PATH=/opt/perl5/bin:$PATH
 $ which Perl

Install meta cpan:

  $ wget https://cpan.metacpan.org/authors/id/M/MI/MIYAGAWA/App-cpanminus-1.7044.tar.gz
   $ /opt/perl5/bin/perl Makefile.PL
   $ make
   $ make test
   $ sudo make install

Tell RT to use metacpan:

   $ export RT_FIX_DEPS_CMD='/opt/perl5/bin/cpanm --sudo --notest'

Configure RT:

./configure --enable-gd --enable-graphviz 

Then you can run make fixdeps

Hope this helps!

@knation

so I used “/opt/perl5/bin/perl Makefile.PL”

There is a typo in my notes, perl5 is correct for the directory name

I get “Can’t open perl script ‘Makefile.pl’: No such file or directory.”

This means you are not in the correct directory containing the Makefile you want to use: cd App-cpanminus-1.7044 I left that step out in the instructions.

The reason for installing this Perl is to have a standalone Perl from the system Perl so that nothing breaks. Before running any Perl commands it is good to run which perl to ensure you are using the one you are installing now.

My person… bless you for all eternity for this. I have been trying to get an instance of RT5 up and running for a week now. Every single time I ran perl Makefile.PL I’d get the “Can’t open perl script ‘Makefile.pl’: No such file or directory.” bs. I know this thread is almost 5 years old, but this is literally the only thing I’ve come across that makes perl Makefile.PL work without throwing an error.

I have followed every single guide and walkthrough down to the exact letter and have still ran into this specific “Can’t open perl script ‘Makefile.pl’: No such file or directory.” issue. It didn’t matter which version of RT I was trying to install, or which version of Linux I was working with, or which release either for that matter. I’ve googled, I’ve posted on Reddit (which is usually where 95% of my Linux related help comes from), I’ve asked some of the guru’s around my office… nada. This is my saving grace. If I had money to spare, I’d send a ridiculous amount your way.

Again, bless you and may whatever god or person or spiritual being or spaghetti monster religion or cult or social gathering you follow and believe in bless you for your remaining days.