[rt-users] Problem with creating a ticket (rt1.0.7; AIX)

[H. Wriedt]

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 <RTUSER> -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 at rrz.uni-hamburg.de