<html>
<head>
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div style="padding-bottom: 0.4em"> First, there is an at-users
group available at Google Group, link below. It's doesn't see as
much traffic as the RT list but it's another resource.<br>
<br>
<a class="moz-txt-link-freetext" href="http://groups.google.com/group/at-users">http://groups.google.com/group/at-users</a><br>
<a href="mailto:at-users@googlegroups.com"></a> </div>
<br>
On 01/11/2012 05:21 PM, Susan McClure wrote:
<blockquote cite="mid:4F0E0B7C.3000700@rice.edu" type="cite">
<pre wrap="">I have a similar question as Kevin Squire on 12/08/2011 till today.
I tried to install AT 1.2.4b1 on my old system without much success, but
now I have some AT
tables, groups etc in my DB (Postgresql)
I am trying to install AT 2.0.0b from github onto RT 3.8.11 upgraded
system.
I do not have any AT files/scrips in the RT installation.
If I try to do a "make initdb" it fails with the same error:
</pre>
<blockquote type="cite">
<pre wrap="">Now populating database schema.
DBD::Pg::st execute failed: ERROR: relation "at_types" already exists
...returned with error: 65280
make: *** [initdb] Error 255
</pre>
</blockquote>
</blockquote>
I got a similar error when trying to initialize Rt+AT with Postgres.
To work around this I needed to remove AT from RT_SiteConfig.pm,
uninstalled AT, init RT under Pg, install AT and init the AT tables,
which I did with the below commands. After this I did a mysql to
postgres migration but I wouldn't think that should matter as my Pg
instance was new. I'm using an RPM package for AT,
perl-RTx-AssetTracker, so install/removal is a trivial matter. I
can't comment on removing AT if installed from source but you might
want to check if there's an 'make uninstall'. For those who are
daring you could probably do "find /path/to/rt" -name
\*AssetTracker\*" to find all the AT files and then remove manually.<br>
<br>
<blockquote cite="mid:4F0E0B7C.3000700@rice.edu" type="cite">
<pre wrap="">
If I try to do a "make dropdb" to drop the old tables etc, it does not give
any error, or any output, but neither does it drop any AT tables (like
at_assets, at_types, at_ips, at_ports).
I tried a "make realclean" and then tried to install again WITHOUT doing
an initdb. I ran the upgrade :
</pre>
<blockquote type="cite">
<pre wrap=""> /usr/site/rt/sbin/rt-setup-database --dba postgres --prompt-for-dba-password --action schema --datadir etc/upgrade/1.2.4
and yes, there is NO schema.Pg file (only mysql and SQLite )</pre>
</blockquote>
</blockquote>
I'm running perl-RTx-AssetTracker 2.0.0b2 and the acl.Pg and
schema.Pg files do exist. You need to specify the full path to the
schema files when running rt-setup-database.<br>
<br>
<div class="container" title="Hint: double-click to select code">
<div class="line number1 index0 alt2"><code class="java plain">rt-setup-database
--action schema --dba rt_user --prompt-</code><code
class="java keyword">for</code><code class="java plain">-dba-password
--datadir \</code></div>
<div class="line number2 index1 alt1"><code class="java spaces"> </code><code
class="java plain">/usr/share/request-tracker/local/plugins/RTx-AssetTracker/etc/</code></div>
<div class="line number3 index2 alt2"><code class="java plain">rt-setup-database
--action acl --dba rt_user --prompt-</code><code class="java
keyword">for</code><code class="java plain">-dba-password
--datadir \</code></div>
<div class="line number4 index3 alt1"><code class="java spaces"> </code><code
class="java plain">/usr/share/request-tracker/local/plugins/RTx-AssetTracker/etc/</code></div>
</div>
<br>
<blockquote cite="mid:4F0E0B7C.3000700@rice.edu" type="cite">
<pre wrap="">
How can I do a complete "uninstall" of Asset Tracker, AND remove the
existing Asset Tracker items from the DB and start over with a fresh
install??
If you tell me all the tables, templates, AT global group and user
rights etc, I could
try to manually drop all the AT parts from the current DB.
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Darin Perusich
Email: <a class="moz-txt-link-abbreviated" href="mailto:Darin.Perusich@ctg.com">Darin.Perusich@ctg.com</a>
Office: 716-888-3690
</pre>
<font face="monospace">The information transmitted is intended only for the person or entity to which<br>
it is addressed and may contain confidential and/or privileged material. Any<br>
review, retransmission, dissemination or other use of, or taking of any action<br>
in reliance upon, this information by persons or entities other than the<br>
intended recipient is prohibited. If you are not the intended recipient of this <br>
message, please contact the sender and delete this material from this computer.</font></body>
</html>