<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
Hi Andrew,<br>
<br>
when asked (during rt4 installation) if "database for
request-tracker4 should be configured with dbconfig-common?" I
answered <b>Yes</b> (as suggested).<br>
Does this answer your question?<br>
<br>
Best regards,<br>
Peter
<p><br>
</p>
<div class="moz-cite-prefix">On 10.04.21 13:28, Andrew Ruthven
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:eeffb10982f46b3ee882dd632442678f030f5fdc.camel@etc.gen.nz">
<pre class="moz-quote-pre" wrap="">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:
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap=""> 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
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">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.
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap=""> and the following error message (because user 'postgres' is not
existing):
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">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
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">
A work around is to manually add user 'postgres' to mariaDB with:
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">CREATE USER 'postgres'@'localhost' IDENTIFIED BY 'postgres-rt4';
GRANT ALL PRIVILEGES ON rtdb.* TO 'postgres'@'localhost';
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap=""> 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
<a class="moz-txt-link-abbreviated" href="mailto:pkg-request-tracker-maintainers@alioth-lists.debian.net">pkg-request-tracker-maintainers@alioth-lists.debian.net</a>
<a class="moz-txt-link-freetext" href="https://alioth-lists.debian.net/cgi-bin/mailman/listinfo/pkg-request-tracker-maintainers">https://alioth-lists.debian.net/cgi-bin/mailman/listinfo/pkg-request-tracker-maintainers</a>
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">
</pre>
</blockquote>
</body>
</html>