[request-tracker-maintainers] RT4-Installation with MariaDB

[Andrew Ruthven]

Hi Peter,

Yes it does answer my question, and the solution I have implemented
should work in this situation. This hasn't been uploaded to Debian yet,
but should be soon.

Cheers,
Andrew

On Sun, 2021-04-11 at 13:36 +0200, Nagel, Peter (IFP) wrote:
>  Hi Andrew,
>  
>  when asked (during rt4 installation) if "database for request-
> tracker4 should be configured with dbconfig-common?" I answered  Yes 
> (as suggested).
>  Does this answer your question?
>  
>  Best regards,
>  Peter 
> 
> On 10.04.21 13:28, Andrew Ruthven wrote:
> Hi Peter,
> 
> Thank you for bringing this to our attention, and for raising the bug
> report - #985141. I've developed a fix for this today. For MySQL or
> MariaDB the expected DBA user is 'root'. As such, you may want to
> use:
> 
>   Set($DatabaseAdmin , 'root');
> 
> I just wanted to check, are you using dbconfig to manage your RT
> database?
> 
> Cheers,
> Andrew
> 
> On Fri, 2021-03-12 at 09:58 +0100, Nagel, Peter (IFP) wrote:
>  
> >  Dear maintainers of request-tracker,
> >  
> >  I observed the following problem (see below) but was not able to
> > track down where exactly (package?) the problem is located and
> > therefore (not writing a bug-report but) this email:
> >  
> >  SQLite:
> >  I successfully installed and tested reqest-tracker4 (RT4) with
> > SQLite including the Plugins PriorityAsString, RepeatTicket and
> > MandatoryFields. 
> >  
> >  Within the 'System Configuration' of RT4 I see the following
> > configuration:    DatabaseAdmin 'postgres'  DatabaseExtraDSN {} 
> > DatabaseHost 'localhost'  DatabaseName '/var/lib/dbconfig-
> > common/sqlite3/request-tracker4/rtdb'  DatabasePassword Password
> > not
> > printed  DatabasePort ''  DatabaseRTHost 'localhost'  DatabaseType
> > 'SQLite'  DatabaseUser '' In this setup only DatabaseAdmin (but no
> > DatabaseUser) is defined.
> >  
> >  
> >  MariaDB:
> >  For using MySQL (instead of SQLite) I first installed the packages
> > mariadb-server and rt4-db-mysql.
> >  Than I continued the installation the same way as with SQLite.
> >  
> >  Within the 'System Configuration' of RT4 I see the following
> > configuration:    DatabaseAdmin 'postgres'  DatabaseExtraDSN {} 
> > DatabaseHost 'localhost'  DatabaseName 'rtdb'  DatabasePassword
> > Password not printed  DatabasePort '3306'  DatabaseRTHost
> > 'localhost'
> > DatabaseType 'mysql'  DatabaseUser 'rtuser' In this setup both
> > DatabaseAdmin and DatabaseUser are defined. However, within MariaDB
> > only user 'rtuser'@'localhost' is defined (but no DatabaseAdmin
> > e.g.
> > 'postgres'@'localhost').
> >  
> >  
> >  My problem is:
> >  When installing the Plugin RT-Extension-RepeatTicket I see the
> > following prompt
> >  
> >  
> > > In order to create or update your RT database, this script needs
> > > to
> > > connect to your mysql instance on localhost (port '3306') as
> > > postgres Please specify that user's database password below. If
> > > the
> > > user has no database password, just press return.
> >  and  the following error message (because user 'postgres' is not
> > existing):
> >  
> >  
> > > Password: 
> > >  Working with: 
> > >  Type: mysql 
> > >  Host: localhost 
> > >  Port: 3306 
> > >  Name: rtdb 
> > >  User: rtuser 
> > >  DBA: postgres 
> > >  Failed to connect to
> > > dbi:mysql:dbname=rtdb;host=localhost;port=3306 as user
> > > 'postgres':
> > > Access denied for user 'postgres'@'localhost' (using password:
> > > YES)...returned with error: 65280 make: *** [Makefile:825:
> > > initdb]
> > > Error 2
> >  
> >  A work around is to manually add user 'postgres' to mariaDB with:
> >  
> >  
> > > CREATE USER 'postgres'@'localhost' IDENTIFIED BY 'postgres-rt4';
> > >  GRANT ALL PRIVILEGES ON rtdb.* TO 'postgres'@'localhost';
> >  and than try the installation again.
> >  
> >  However, this situation is unexpected.
> >  In addition the existing user 'rtuser' has already   ALL
> > PRIVILEGES
> > ON rtdb.*   - so there is no need to have two users (with identical
> > privileges) here. 
> >  
> >  
> >  My question is:
> >  Why is it (for the MySQL-setup) necessary to have both
> > DatabaseAdmin
> > and DatabaseUser and why is only one user define within MariaDB.
> >  
> >  Best regards,
> >  Peter
> >  
> > 
> > _______________________________________________
> > pkg-request-tracker-maintainers mailing list
> > pkg-request-tracker-maintainers at alioth-lists.debian.net
> > https://alioth-lists.debian.net/cgi-bin/mailman/listinfo/pkg-request-tracker-maintainers
>    

-- 
Andrew Ruthven, Wellington, New Zealand
andrew at etc.gen.nz         |
Catalyst Cloud:           | This space intentionally left blank
 https://catalystcloud.nz |