Bug 6920

Summary:	Request Trackerâs Installation Instructions Are Out-of-Date: MariaDB is not supported and it errors out.
Product:	Mageia	Reporter:	Shlomi Fish <shlomif>
Component:	RPM Packages	Assignee:	AL13N <alien>
Status:	RESOLVED FIXED	QA Contact:
Severity:	normal
Priority:	Normal	CC:	alien, bgmilne
Version:	Cauldron
Target Milestone:	---
Hardware:	x86_64
OS:	Linux
Whiteboard:
Source RPM:	rt-4.0.6-1.mga3.src.rpm	CVE:
Status comment:

Description Shlomi Fish 2012-07-31 18:30:59 CEST

Description of problem:

Request Tracker's Installation Instructions are out-of-date as MariaDB is not supported:

[Q]
--- Topic for #rt set by warewolf!warewolf@warewolf.org at Wed Jun 27 06:37:08 2012
<shadowpaste> "rindolf" at 217.168.150.38 pasted "/usr/sbin/rt-setup-database --action init gives me this in Mageia Linux 3/Cauldron with rt-4.0.6-1.mga3" (13 lines) at http://paste.scsys.co.uk/204388
<rindolf> Hi all. Can anyone help me with http://paste.scsys.co.uk/204388 ?
<trs> rindolf: MariaDB isn't supported.
<rindolf> trs: oh.
<trs> The README that ships with RT lists supported databases.  https://github.com/bestpractical/rt/blob/stable/README#L26
<trs> there's an open ticket about MariaDB support: http://issues.bestpractical.com/Ticket/Display.html?id=17380
[Q]

Furthermore, I previously had problems running rt-setup-database due to missing CPAN modules.

Now I don't know how to set up rt on Mageia Cauldron.

For the record, currently the instructions read:

----------------------------------------------------------------------
More information on package rt-4.0.6-1.mga3.noarch
Finalizing the installation
===========================

1. Install and start a mysql server:
# urpmi mysql && /sbin/service mysqld start

2. Set up the mysql server.
If not already done, at minimum, you will want to set up a mysql root 
password:
# mysqladmin -u root password <mysql-root-password>

3. Edit /etc/rt/RT_SiteConfig.pm to meet your demands.
Consult 'perldoc /etc/rt/RT_Config.pm'
(Never modify RT_Config.pm, or retain it when upgrading)

4. Initialize rt's mysql database:
# /usr/sbin/rt-setup-database --action init \
  --dba-password <mysql-root-password>

5. Start/reload apache/httpd:
# /sbin/service httpd start
or:
# /sbin/service httpd reload

6. Try to log in:
At this point, you should be able to login into rt on your rt-host via
its web interface as (RT user) root, at http://<rt-host>/rt

You should be greeted with a login window. Login with 
Username: root, Password: password.

The next step should be to change your rt's "root" account's password,
otherwise anybody with web access to your site will be able to abuse 
your site.

Afterwards, you should be ready to create user accounts, configure 
the mail-interface etc.

----------------------------------------------------------------------
root@telaviv1:~$

Manuel Hiebel 2012-08-03 00:42:31 CEST

CC: (none) => alien
Assignee: bugsquad => bgmilne

Comment 1 Buchan Milne 2012-08-03 10:03:32 CEST

RT can work fine against a remote database server running MySQL.

I note that my RT installation done on Mageia 1, upgraded to Mageia 2, works fine with MariaDB.

BTW, this looks like a MariaDB bug, fixed in 5.5.25. From: http://kb.askmonty.org/en/mariadb-5525-release-notes/ :

"Via is not a reserved word anymore."

https://bugs.launchpad.net/maria/+bug/1010351

Buchan Milne 2012-08-03 10:04:23 CEST

Assignee: bgmilne => alien

Comment 2 Buchan Milne 2012-08-03 10:05:14 CEST

BTW, bugfix update for Mageia 2 may be in order.

CC: (none) => bgmilne

Comment 3 AL13N 2012-08-03 13:11:56 CEST

mageia 2 has 5.5.25. so this should be fixed...

Comment 4 Buchan Milne 2012-08-03 13:19:40 CEST

But cauldron has 5.5.23:

[13:17:32] <blingme> :v mariadb 
[13:17:33] <Sophie> blingme: 5.5.23-4.mga2 // core-release (Mga, 2, i586), core-release (Mga, cauldron, i586)

 So not fixed in cauldron.

Comment 5 AL13N 2012-08-03 13:49:38 CEST

yes, that is true...

i'm busy with redesigning the mariadb packages and config files for cauldron.

(i don't use cauldron, i only see it as an advancement for next release)

so, if this is wanted i can backport the mga2 package to cauldron

Comment 6 Shlomi Fish 2012-08-06 11:24:03 CEST

Hi AL13N,

(In reply to comment #5)
> yes, that is true...
> 
> i'm busy with redesigning the mariadb packages and config files for cauldron.
> 
> (i don't use cauldron, i only see it as an advancement for next release)
> 
> so, if this is wanted i can backport the mga2 package to cauldron

Please do, as it is ridiculous that the Mga2 version is higher than the Cauldron version (and as a result, the instructions for RT don't work).

Regards,

-- Shlomi Fish

Comment 7 AL13N 2012-08-06 13:47:22 CEST

submitted

Comment 8 Shlomi Fish 2012-08-06 15:25:18 CEST

(In reply to comment #7)
> submitted

Thanks!

Comment 9 AL13N 2012-09-05 08:32:24 CEST

closing

Status: NEW => RESOLVED
Resolution: (none) => FIXED