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

[Raubvogel]

On Fri, Nov 6, 2009 at 12:52 PM, zikus <rsiripan at itsolution-uk.com> wrote:
> i'm too get actually the same error, do you find a solution?
>
      The only two solutions I have found so far are

o Stick with 3.6.
o Download RT from the website (i.e. from source) and manually install it.

> --
> 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 direct subscriber
> of the bug.
>
> Status in “request-tracker3.8” package in Ubuntu: New
>
> Bug description:
> 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.
>

-- 
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