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

[Andrew Ruthven]

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 |