[Bug 444046] [NEW] rt-setup-database-3.8 does not seem to work

[Raubvogel]

Public bug reported:

Binary package hint: request-tracker3.8

OS is the beta version of 9.10. Here is the behaviour I would expect
(i.e. it works in 3.6):

root at tickets:~# sudo /usr/sbin/rt-setup-database-3.6 --action init --dba rtuser --dba-password mssw
Now creating a database for RT.
Creating mysql database rt3.
Now populating database schema.
Creating database schema.
Done setting up database schema.
Now inserting database ACLs
Done setting up database ACLs.
Now inserting RT core system objects
Checking for existing system user...not found.  This appears to be a new installation.
Creating system user...done.
Now inserting RT data
Creating Superuser  ACL...done.
Creating groups...3.4.5.6.7.8.9.done.
Creating users...10.12.done.
Creating queues...1.2.done.
Creating ACL...2.3.done.
Creating ScripActions...1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.done.
Creating ScripConditions...1.2.3.4.5.6.7.8.9.10.done.
Creating templates...1.2.3.4.5.6.7.8.9.10.11.12.done.
Creating scrips...1.2.3.4.5.6.7.8.9.10.11.12.13.14.done.
Creating predefined searches...1.2.3.done.
Done setting up database content.
root at tickets:~# 

And here is how rt-setup-database-3.8 is behaving (and yes, the database
was deleted between runs):

root at tickets:~# sudo /usr/sbin/rt-setup-database-3.8 --action init --dba rtuser --dba-password mssw
Working with:
Type:   mysql
Host:   localhost
Name:   
User:   rtuser
DBA:    rtuser
Now creating a mysql database  for RT.
Couldn't finish 'create' step.

ERROR: 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 '' at line 1

root at tickets:~#

The database used in both tests was

root at tickets:~# mysql --version
mysql  Ver 14.14 Distrib 5.1.37, for debian-linux-gnu (x86_64) using  EditLine wrapper
root at tickets:~# 

And, both versions of request-tracker were as ubuntu packages.

** Affects: request-tracker3.8 (Ubuntu)
     Importance: Undecided
         Status: New

-- 
rt-setup-database-3.8 does not seem to work
https://bugs.launchpad.net/bugs/444046
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.

-- 
ubuntu-bugs mailing list
ubuntu-bugs at lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs