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:~$
CC: (none) => alienAssignee: bugsquad => bgmilne
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
Assignee: bgmilne => alien
BTW, bugfix update for Mageia 2 may be in order.
CC: (none) => bgmilne
mageia 2 has 5.5.25. so this should be fixed...
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.
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
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
submitted
(In reply to comment #7) > submitted Thanks!
closing
Status: NEW => RESOLVEDResolution: (none) => FIXED