Problem with creating a ticket (rt1.0.7; AIX)


#1

Hi,

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.

./testdeps.pl
Checking for DBI…found
Checking for Digest::MD5…found
Checking for CGI 2.71 …found
Checking for CGI::Cookie 1.16 …found

Perl -V
Summary of my perl5 (5.0 patchlevel 5 subversion 2) configuration:
Platform:
osname=aix, osvers=4.1.5.0, archname=aix
uname='aix www 1 4 00093a7aa700 ’

mysql -V
mysql Ver 9.32 Distrib 3.22.23b, for ibm-aix4.1.5.0 (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
http://lists.fsck.com/pipermail/rt-users/2000-March/000106.html

I look forward to any help.

Regards
Hartmut Wriedt
Computercenter of the University of Hamburg (Germany)
wriedt@rrz.uni-hamburg.de