[rt-users] Lost Root Password
Another one of these threads. * Root password for Linux known * RT 3.8.4 * http://requesttracker.wikia.com/wiki/RecoverRootPassword didn't work * we have httpd restrictions on the website taht require login that authenticates against an ldap server * other users can login... but we can't get in as root and root doesn't seem to have an account on the ldap server Anyone have ideas? It looks like RT takes the userid and auth from ldap as well. Can I just make a different account admin level? I need to just move some users around from one queue to another. I know its the ldap auth. -- il n'y a pas de liberté s'il y a dépendance --Theobalt
[rt-users] Help with shredder in 3.8.10
I know we should be upgrading, but you know how that goes. So I am stuck on 3.8.10 and I am trying to take some old restores and integrate that data into one big new server which can handle the load. So, I have restored the data I want to a new server. I am now trying to get that data OUT of the server with the shredder command (/opt/rt3/sbin/rt-shredder). What do I need to change to get it to see the plugin? **[root@rtarchives sbin]# ./rt-shredder --plugin list Plugins list: Objects Users Attachments Summary Tickets SQLDump [root@rtarchives sbin]# ./rt-shredder --plugin help-Tickets Couldn't find plugin 'Tickets' Plugins list: Objects Users Attachments Summary Tickets SQLDump [root@rtarchives sbin]# -- *Deo Vindice* RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] Help with shredder in 3.8.10
Ah HA! Use rtx-shredder 0.07, downloadable from cpan. [root@rtrestore090327 sbin]# pwd /root/RTx-Shredder-0.07/sbin [root@rtrestore090327 sbin]# ./rtx-shredder --plugin help-Tickets USAGE masks If any argument is marked with keyword `mask' then it means that this argument support two special characters: 1) `*' matches any non empty sequence of the characters. For example `*@example.com' will match any email address in `example.com' domain. 2) `?' matches exactly one character. For example `' will match any string four characters long. ARGUMENTS Arguments which all plugins support. limit - unsigned integer Allow you to limit search results. Default value is `10'. NAME RTx::Shredder::Plugin::Tickets - search plugin for wiping tickets. ARGUMENTS queue - queue name Search tickets only in particular queue. status - ticket status Search tickets with specified status only. 'deleted' status is also supported. updated_before - date Search tickets that were updated before some date. Example: '2003-12-31 23:59:59' [root@rtrestore090327 sbin]# On Tue, Dec 27, 2011 at 2:07 PM, Dennis Comeaux dennis.come...@gmail.comwrote: I know we should be upgrading, but you know how that goes. So I am stuck on 3.8.10 and I am trying to take some old restores and integrate that data into one big new server which can handle the load. So, I have restored the data I want to a new server. I am now trying to get that data OUT of the server with the shredder command (/opt/rt3/sbin/rt-shredder). What do I need to change to get it to see the plugin? **[root@rtarchives sbin]# ./rt-shredder --plugin list Plugins list: Objects Users Attachments Summary Tickets SQLDump [root@rtarchives sbin]# ./rt-shredder --plugin help-Tickets Couldn't find plugin 'Tickets' Plugins list: Objects Users Attachments Summary Tickets SQLDump [root@rtarchives sbin]# -- *Deo Vindice* -- il n'y a pas de liberté s'il y a dépendance --Theobalt RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
[rt-users] Trying to backup and restore but comments are not restoring.
Hello all! I have searched through the archives and sadly the only references I am finding are that sometimes the attachments table does not backup properly without setting a binary switch. I am running a backup of mysql (everything in it as the server only runs RT 3.4.6) with: mysqldump -u root -p p...@55w0rd -A | gzip ./rt346.dbdump.gz Then, on my restore system, I run: zcat rt346.dbdump.gz | mysql -u root -p p...@55w0rd The restore runs just fine. However after the restore all comments on all tickets are not visible. I checked on my account rights and I am in **AdminGroup, AdminGroupMembership, EditSavedSearches, ModifyOwnMembership, SeeGroup, and ShowSavedSearches. But still I see no comments. I would like to use mysql to query the comments field, but I am not sure which table that field is in. I also suspect that comments may be stored in non-clear text format as grepping the dump file for strings that should be in the comments field is not working. I have tried using the -T switch to export, exporting attachments table separately, etc, but all to no avail. This worked last time I tried it about 7 months ago. And now we want to upgrade to lastest and greatest RT, but we need to be sure to preserve our existing data. The 1st step in that process is to restore the data to a new server. Any ideas guys? Anything I could tell you that would help diagnose? -- il n'y a pas de liberté s'il y a dépendance --Theobalt RT Training in Washington DC, USA on Oct 25 26 2010 Last one this year -- Learn how to get the most out of RT!