RegEx in search window

I was looking for some spam mails that made their way into RT. I tried
using the search window on the main page (RT At A Glance) but couldn’t
find the mails in question. I tried the same search in the query
builder, and the mails were found. The phrase that I was searching was
"dr@gs". I tried escaping and not escaping the @ in both places.
Escaping it worked in the query builder but not in the main search
window. Is there some documentation of the differences between these two
search methods? I am using RT 3.4.1 btw.

Thanks,

Vicki

I am creating a new RT 3.2.3 database on a remote mysql4 server. I am
wondering what the Global Privileges should be for the new RT user of
the new db. I am using phpmyadmin to administrate the remote mysql
server.

Also, do I need to run the make-initialize database command if I am
going to be importing from an existing RT2 db using the rt2todump and
dumptort3 scripts?

Any help would be appreciated.

Thanks,
Tim

I am creating a new RT 3.2.3 database on a remote mysql4 server. I am
wondering what the Global Privileges should be for the new RT user of
the new db. I am using phpmyadmin to administrate the remote mysql
server.

Also, do I need to run the make-initialize database command if I am
going to be importing from an existing RT2 db using the rt2todump and
dumptort3 scripts?

Any help would be appreciated.

Thanks,
Tim

Tim Suter wrote:

I am creating a new RT 3.2.3 database on a remote mysql4 server. I am
wondering what the Global Privileges should be for the new RT user of
the new db. I am using phpmyadmin to administrate the remote mysql
server.

make initialize-database should take care of this provided you ran
./configure with the right options.

Also, do I need to run the make-initialize database command if I am
going to be importing from an existing RT2 db using the rt2todump and
dumptort3 scripts?

Yes.

Cheers,
Tom

This is nice. The guy working on the web server part deleted the source
folder. Therefore, no make initialize-database. What about
rt-setup-database? Will this create the db?

TimOn Fri, 2005-08-05 at 13:39 -0400, Thomas Sibley wrote:

Tim Suter wrote:

I am creating a new RT 3.2.3 database on a remote mysql4 server. I am
wondering what the Global Privileges should be for the new RT user of
the new db. I am using phpmyadmin to administrate the remote mysql
server.

make initialize-database should take care of this provided you ran
./configure with the right options.

Also, do I need to run the make-initialize database command if I am
going to be importing from an existing RT2 db using the rt2todump and
dumptort3 scripts?

Yes.

Cheers,
Tom

All “make initialize-database” does is run:

rt-setup-database --action init --dba root --prompt-for-dba-password

Substitute “root” with the user name of the db administrator account.

Cheers,

  • TrevinOn Fri, 2005-08-05 at 15:18 -0500, Tim Suter wrote:

This is nice. The guy working on the web server part deleted the source
folder. Therefore, no make initialize-database. What about
rt-setup-database? Will this create the db?

Tim