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.
http://groups.google.com/group/at-users <mailto:[email protected]> On 01/11/2012 05:21 PM, Susan McClure wrote: 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: Now populating database schema. DBD::Pg::st execute failed: ERROR: relation "at_types" already exists ...returned with error: 65280 make: *** [initdb] Error 255 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. 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 : /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 ) 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. rt-setup-database --action schema --dba rt_user --prompt-for-dba-password --datadir \ /usr/share/request-tracker/local/plugins/RTx-AssetTracker/etc/ rt-setup-database --action acl --dba rt_user --prompt-for-dba-password --datadir \ /usr/share/request-tracker/local/plugins/RTx-AssetTracker/etc/ 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. -- Darin Perusich Email: [email protected] Office: 716-888-3690 The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you are not the intended recipient of this message, please contact the sender and delete this material from this computer.
-------- RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
