<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
Dear maintainers of request-tracker,<br>
<br>
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:<br>
<br>
<u><b>SQLite</b><b>:</b></u><br>
I <u>successfully</u> installed and tested reqest-tracker4 (RT4)
with SQLite including the Plugins PriorityAsString, RepeatTicket and
MandatoryFields. <br>
<br>
Within the 'System Configuration' of RT4 I see the following
configuration:
<table width="657" height="247" cellspacing="2" cellpadding="2"
border="1">
<tbody>
<tr>
<td valign="top">DatabaseAdmin</td>
<td valign="top">'postgres'</td>
</tr>
<tr>
<td valign="top">DatabaseExtraDSN</td>
<td valign="top">{}</td>
</tr>
<tr>
<td valign="top">DatabaseHost</td>
<td valign="top">'localhost'</td>
</tr>
<tr>
<td valign="top">DatabaseName</td>
<td valign="top">'/var/lib/dbconfig-common/sqlite3/request-tracker4/rtdb'</td>
</tr>
<tr>
<td valign="top">DatabasePassword</td>
<td valign="top"><em>Password not printed</em></td>
</tr>
<tr>
<td valign="top">DatabasePort</td>
<td valign="top">''</td>
</tr>
<tr>
<td valign="top">DatabaseRTHost</td>
<td valign="top">'localhost'</td>
</tr>
<tr>
<td valign="top">DatabaseType</td>
<td valign="top">'SQLite'</td>
</tr>
<tr>
<td valign="top">DatabaseUser</td>
<td valign="top">''</td>
</tr>
</tbody>
</table>
In this setup only DatabaseAdmin (but no DatabaseUser) is defined.<br>
<br>
<br>
<u><b>MariaDB</b><b>:</b></u><br>
For using MySQL (instead of SQLite) I first installed the packages <b>mariadb-server</b>
and <b>rt4-db-mysql</b>.<br>
Than I continued the installation the same way as with SQLite.<br>
<br>
Within the 'System Configuration' of RT4 I see the following
configuration:
<table width="373" height="247" cellspacing="2" cellpadding="2"
border="1">
<tbody>
<tr>
<td valign="top">DatabaseAdmin</td>
<td valign="top">'postgres'</td>
</tr>
<tr>
<td valign="top">DatabaseExtraDSN</td>
<td valign="top">{}</td>
</tr>
<tr>
<td valign="top">DatabaseHost</td>
<td valign="top">'localhost'</td>
</tr>
<tr>
<td valign="top">DatabaseName</td>
<td valign="top">'rtdb'</td>
</tr>
<tr>
<td valign="top">DatabasePassword</td>
<td valign="top"><em>Password not printed</em></td>
</tr>
<tr>
<td valign="top">DatabasePort</td>
<td valign="top">'3306'</td>
</tr>
<tr>
<td valign="top">DatabaseRTHost</td>
<td valign="top">'localhost'</td>
</tr>
<tr>
<td valign="top">DatabaseType</td>
<td valign="top">'mysql'</td>
</tr>
<tr>
<td valign="top">DatabaseUser</td>
<td valign="top">'rtuser'</td>
</tr>
</tbody>
</table>
In this setup both DatabaseAdmin and DatabaseUser are defined.
However, within MariaDB only user 'rtuser'@'localhost' is defined
(but <u>no</u> DatabaseAdmin e.g. 'postgres'@'localhost').<br>
<br>
<br>
My <b>problem</b> is:<br>
When installing the Plugin RT-Extension-RepeatTicket I see the
following prompt<br>
<blockquote>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.<br>
</blockquote>
and the following error message (because user 'postgres' is not
existing):<br>
<blockquote>Password: <br>
Working with: <br>
Type: mysql <br>
Host: localhost <br>
Port: 3306 <br>
Name: rtdb <br>
User: rtuser <br>
DBA: postgres <br>
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<br>
</blockquote>
<br>
A <b>work around</b> is to manually add user 'postgres' to mariaDB
with:<br>
<blockquote>CREATE USER 'postgres'@'localhost' IDENTIFIED BY
'postgres-rt4';<br>
GRANT ALL PRIVILEGES ON rtdb.* TO 'postgres'@'localhost';<br>
</blockquote>
and than try the installation again.<br>
<br>
However, this situation is unexpected.<br>
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. <br>
<br>
<br>
My <b>question</b> is:<br>
Why is it (for the MySQL-setup) necessary to have both DatabaseAdmin
and DatabaseUser and why is only one user define within MariaDB.<br>
<br>
Best regards,<br>
Peter<br>
<br>
<p><br>
</p>
</body>
</html>