I am trying to install rt-1.0.7 on our public cgi-server (IBM-AIX).
The Makefile finished with
Congratulations. RT has been installed. (Now, create a queue, :admin-webrt.cgi works well add some users and :admin-webrt.cgi works well start resolving requests) :I'm sorry, I've a problem! (webrt.cgi)
When I am trying to create a request in my queue, I get an internal server
error when I use the ‘Create request’ botton.
(After fill in the ‘Subject’ and the ‘Content’)
In the apache error_log I found:
DBD::mysql::st execute failed: You have an error in your SQL syntax near ’ 0, ‘wriedt’, ‘create’, ‘’, 988220619)’ at line 1 at /net/softsrv.uni-hamburg.de/sw/perl/5.5P2aix/lib/site_perl/5.005/aix/Mysql.pm line 172.
[add_transaction] Query had some problem: You have an error in your SQL syntax near ’ 0, ‘wriedt’, ‘create’, ‘’, 988220619)’ at line 1
Query: INSERT INTO transactions (id, effective_sn, serial_num, actor, type, trans_data, trans_date) VALUES (NULL, , 0, ‘wriedt’, ‘create’, ‘’, 988220619)
Can’t call method “insert_id” on an undefined value at /cgi/rz1a012/cgi-bin/rt//lib/rt/database.pm line 118.
[Wed Apr 25 19:43:39 2001] access to /cgi/rz1a012/cgi-bin/rt/bin/cgi/webrt.cgi failed for rzaix25.rrz.uni-hamburg.de, reason: Premature end of script headers
Our configuration is:
Request Tracker version 1.0.7.
Checking for DBI…found
Checking for Digest::MD5…found
Checking for CGI 2.71 …found
Checking for CGI::Cookie 1.16 …found
Summary of my perl5 (5.0 patchlevel 5 subversion 2) configuration:
osname=aix, osvers=184.108.40.206, archname=aix
uname='aix www 1 4 00093a7aa700 ’
mysql Ver 9.32 Distrib 3.22.23b, for ibm-aix220.127.116.11 (powerpc)
The command (RT-FAQ Q3.1)
mysql -u <MYSQL_DBADMIN> -p -h localhost rt
does not work with the RT_MYSQL_PASS
mysql -u -p -h localhost rt
work very well with the RT_MYSQL_PASS
The CGI-program admin-webrt.cgi works very well.
(Create users and queues)
My problem looks like
I look forward to any help.
Computercenter of the University of Hamburg (Germany)