Search results
Jump to navigation
Jump to search
Page title matches
- #REDIRECT [[Attaching common files without storing in RT database]]67 bytes (9 words) - 16:03, 6 April 2016
- ...tickets, but sending the same file over and over takes up space in the RT database. The easiest and recommend solution to this problem is to send a link to th ...ustomization that saves space by storing each attachment only once in RT's database. This customization involves creating 3 callbacks, replacing one RT compone6 KB (725 words) - 16:03, 6 April 2016
Page text matches
- ...he [[SQLite]] database file to "./configure" as the argument to "--with-db-database". ...ace. It should be read/writable by that user. The directory containing the database file should also be read/writable by that user so that [[SQLite]] temporary646 bytes (103 words) - 16:36, 6 April 2016
- This page is intended to capture notes about possible additional database indexes, which could be used to influence future updates to the official sc * Database: [[PostgreSQL]]2 KB (207 words) - 16:08, 6 April 2016
- The [[PostgreSQL]] database is available from http://www.postgresql.org == Database Authentication ==884 bytes (130 words) - 16:20, 6 April 2016
- #REDIRECT [[Attaching common files without storing in RT database]]67 bytes (9 words) - 16:03, 6 April 2016
- Use [[SQLite]] as a database, again under your current directory. Set up the [[SQLite]] database864 bytes (116 words) - 16:08, 6 April 2016
- [[MySQL]] is Relational Database Management System(RDBMS) that can be used by RT to store data.134 bytes (23 words) - 16:15, 6 April 2016
- It's never recommended to work directly on your RT database, but in this instance that is the only way to recover from this mistake. If You may wish to take a backup of your database, just in case.1 KB (180 words) - 16:39, 6 April 2016
- Then we should upgrade database with: /usr/sbin/rt-setup-database-3.8 --action upgrade --dba rtuser --dba-password2 KB (232 words) - 16:39, 6 April 2016
- = Adding new records into RT's database = = rt-setup-database and initialdata =2 KB (334 words) - 12:58, 16 November 2016
- Set or change the root password for MySQL and remove the test database and anonymous user. === Creating the RT database ===2 KB (310 words) - 16:03, 6 April 2016
- ==== [[Database Settings]] ====2 KB (202 words) - 09:09, 24 June 2016
- ...r />create database rt4<br />select database rt4<br />import backup of old database<br />'''RT should be sucessfully updated and working.'''2 KB (417 words) - 16:14, 6 April 2016
- rt-setup-database --action init251 bytes (39 words) - 16:09, 6 April 2016
- This is plugin which connect to [[MySQL]] database. It uses user-friendly wizards, where you can select particular tables and404 bytes (64 words) - 16:15, 6 April 2016
- * Mysqld 5.0.22-- Database to Store the RT information. === Create the Database ===4 KB (578 words) - 16:39, 6 April 2016
- '''Created a new folder''' /opt/rt38 and new mysql database rt38, granting permissions to the appropriate user. '''Restored RT 3.4.4 mysql backup''' into mysql database rt38.3 KB (433 words) - 16:39, 6 April 2016
- * Mysqld 5.0.22-- Database to Store the RT information. === Create the Database ===4 KB (590 words) - 16:39, 6 April 2016
- ==<span style="font-size:large;">Updating the Database</span>== ...ake use of the new recipient groups from a Scrip you need to update the RT database.3 KB (407 words) - 16:37, 6 April 2016
- === Why a real database? === ...t these, so the test suite selects and runs the tests appropriate for your database.5 KB (843 words) - 18:05, 17 December 2021
- These commands merely build an SQL query to retrieve data from your database and are inherited from the API of DBIx::SearchBuilder.407 bytes (60 words) - 16:27, 6 April 2016
- ...[[PostgreSQL]] database that has been prepared with <code> make initialize-database</code>. It's probably a bit rough but worked reasonably for me. I'd appreci # give the database a chance to use its defaults3 KB (353 words) - 16:36, 6 April 2016
- ...es or mysql) is not made into a dependency. You need to make sure that the database you want to use is installed. This makes one more /apt-get install/ . The default database in the configuration files is postgresql. I have changed this to mysqld bec2 KB (272 words) - 16:39, 6 April 2016
- * Mysql - Database to Store the RT information. ...mysql),if don't install it,create the mysql Database will create sqlite3's database,don't create mysql's.)*5 KB (672 words) - 16:11, 6 April 2016
- ...y to apply - apt-get update/upgrade). For the database we use Postgres (RT database password is auto-generated during boot - so its unique and secure), Email i Especially for server applications like RT with a lot of database connections and small files, disk access time is one of the key factors for2 KB (327 words) - 16:20, 6 April 2016
- | The database host (default: localhost) | The database port5 KB (797 words) - 16:09, 6 April 2016
- * Mysqld - Database to Store the RT information. === Create the Database ===4 KB (622 words) - 16:39, 6 April 2016
- This action does not require any Perl code, just a database edit. It uses code already in RT. # /path/to/rt3/sbin/rt-setup-database --action insert \3 KB (443 words) - 13:08, 19 July 2016
- $ sudo rt-setup-database --action init --dba root --prompt-for-dba-password ...not to make the permissions on this file too liberal, because it contains database1 KB (232 words) - 16:14, 6 April 2016
- == Database backend == RT stores its data in a database. You can choose from the following database management systems (DBMS):3 KB (553 words) - 14:49, 2 April 2019
- Transaction support within the database is pretty much required since RT 3.0.0 and up. updating from earlier versio514 bytes (73 words) - 16:11, 6 April 2016
- ...sert the datafile just saved. This will create the ScripConditions in RT's database. /path/to/rt3/sbin/rt-setup-database --action insert --datafile /path/to/AnyReminderTransaction.insert3 KB (332 words) - 14:21, 13 August 2016
- ===== • Initialize the RT Database ===== $ /usr/sbin/rt-setup-database --action init2 KB (283 words) - 16:03, 6 April 2016
- ...examining the database. Also, very occasionally you may wish to modify the database directly (e.g. delete bogus information). ...OTE:''' Nobody guarantee that this document describes all relations in the database.4 KB (621 words) - 16:08, 6 April 2016
- ...en to provide a quick way to run a backup of the Request Tracker ''mysql'' database. This is a good tool for routine daily backups and can be run as part of th ...ver account the cron job will run as) will have DB access rights to the RT Database. </nowiki>3 KB (429 words) - 16:03, 6 April 2016
- * MySql - Database to Store the RT information. * Configuration for using a MySQL database on another local server.8 KB (1,197 words) - 16:11, 6 April 2016
- * [[ConfigEximFromRTDB]] - configure Exim to use [[Queue]] info from RT database.596 bytes (96 words) - 23:17, 22 August 2023
- ...up with cross-links so that the CRM record in VTiger goes to the RT ticket database and vice versa. (Also, we use Asterisk, so if things could hook into that t701 bytes (120 words) - 16:37, 6 April 2016
- rt4-db-mysql - MySQL database backend for request-tracker4 rt4-db-postgresql - PostgreSQL database backend for request-tracker46 KB (863 words) - 16:08, 6 April 2016
- You will need to modify each script to insert your RT3 database name, userid and password. my $dsn = "DBI:Pg:database=$database;host=$hostname;port=$port";3 KB (443 words) - 16:23, 6 April 2016
- Grox specialises in developing scalable, cost-effective, and robust database-driven applications for internet businesses.721 bytes (110 words) - 16:37, 6 April 2016
- ...worry about - all of the customisation was in Scrips and therefore in the database. Filesystem-based changes need scrutinising closely to see if they still ma ...nd AT 1.2.3 etc. and tested it worked. The task was then to migrate the RT database from the old server to the new server. This is the interesting bit and shou8 KB (1,400 words) - 16:14, 6 April 2016
- ...ges are described bellow. You can use my script [[rt-mysql2pg]] to prepare database for full text without a tedious work. * To prepare already converted [[PostgreSQL]] database run:3 KB (320 words) - 09:05, 13 July 2018
- ...sert the datafile just saved. This will create the ScripConditions in RT's database. /path/to/rt3/sbin/rt-setup-database --action insert --datafile /path/to/AnyTransactionSource.insert4 KB (527 words) - 14:15, 13 August 2016
- This condition appears to be missing a database row as part of the example799 bytes (101 words) - 16:39, 6 April 2016
- ...have to do. You have to insert description of the new scrip condition into database of the RT.876 bytes (127 words) - 14:17, 13 August 2016
- /path/to/rt3/sbin/rt-setup-database --action insert \ ...a.domain.com user@tla.domain.com]". So if the email address in the RT user database uses capital letters, you never get a match, even if the email is sent with3 KB (435 words) - 16:15, 6 April 2016
- * THE DATABASE: ##These are the settings we used above when creating the RT database,11 KB (1,509 words) - 16:08, 6 April 2016
- 2) Go into the "SQL Database Server" group and select the "mysql-server" package (not selected by defaul 11) Install RT3 and initialize the database:4 KB (500 words) - 16:09, 6 April 2016
- postgres-# grant all privileges on database rt4 to rt_user <u>'''CAUTION: do NOT initialize the database as the script may ask (do NOT run "make initdb")'''</u>9 KB (1,281 words) - 13:41, 4 January 2023
- == Database Setup == ...t''' create a database ''user'' for you. If you have not already created a database user for RT, please consult the appropriate documentation, such as [[Config9 KB (1,424 words) - 16:11, 6 April 2016
- ===First pick a database=== ...l one of the three database choices. The first package installs the actual database, the second installs the client dependencies for RT.8 KB (1,292 words) - 16:08, 6 April 2016
- ...port altering of the current value. Let's see how to alter id in different database servers:4 KB (675 words) - 16:37, 6 April 2016
- ...n the distribution for the main installation. In particular, the --with-db-database option should be set to a known SID in your local tns listener config. If there is problem with accents on the web pages for text from the database, it might be needed to add the following environnement variables to apache7 KB (1,127 words) - 16:15, 6 April 2016
- This script connects to the RT database and exports all of the mail into mbox format. An mbox file is created for e * I've tested this with my [[PostgreSQL]] database and added code so that it should also work with [[MySQL]], but all other da7 KB (840 words) - 16:36, 6 April 2016
- '--with-db-database=rt_upgrade' '--with-db-dba=root' '--mandir=/usr/local/man' '--infodir=/usr/ [/]# /usr/local/rt3/sbin/rt-setup-database --dba root --prompt-for-dba-password --action upgrade6 KB (834 words) - 16:09, 6 April 2016
- ...'apt-get install mysql-server(or)pgsql''' You can choose either of the two database packages or if you already have one installed, you can ignore this step. DATABASE CREATION AND SCHEMA INSTALLATION11 KB (1,758 words) - 16:11, 6 April 2016
- The problem is in the database, so we have to fix it there. Backup your database BEFORE CONTINUING!7 KB (973 words) - 16:36, 6 April 2016
- ## Initialize the database: ...e to complete this step by editing the RT files directly, and creating the database. Refer to the RT documentation for manual steps.7 KB (1,095 words) - 17:34, 22 October 2018
- == Database Enhancements == * Split the attachments database into an actual binary attachments, and correspondences/comments databases4 KB (710 words) - 16:23, 6 April 2016
- ...tickets, but sending the same file over and over takes up space in the RT database. The easiest and recommend solution to this problem is to send a link to th ...ustomization that saves space by storing each attachment only once in RT's database. This customization involves creating 3 callbacks, replacing one RT compone6 KB (725 words) - 16:03, 6 April 2016
- ...and columns; there are no enforced relational integrity constraints at the database levels.1 KB (201 words) - 19:40, 3 October 2016
- == RT database == * [[Debug]] - How to enable debug output in RT, Apache, and your database server.6 KB (768 words) - 16:08, 6 April 2016
- This will configure the RT4 database, best to run after installing 'request-tracker4', it does not install mysql ...llation of all necessary apache2 packages follow the configuration for the database setup and rt root password4 KB (542 words) - 15:57, 19 December 2016
- # Connect to the database. set up loggign1 KB (185 words) - 16:03, 6 April 2016
- #''You have a username and password for the RT Database (or root)'' #'''''Configure the RTDB database manually '''''20 KB (3,268 words) - 16:39, 6 April 2016
- Initialize mysql database: <nowiki>* /usr/sbin/rt-setup-database --action init --dba root --dba-password <mysql-root-password>5 KB (731 words) - 16:09, 6 April 2016
- ...robably sending autoreplies) for a ticket that will never make it into the database. The patch replaces the RT::Attachement object with the $id of the attachme1 KB (183 words) - 16:39, 6 April 2016
- ...ous. Note that you do not have to manually add a database user or set up a database for RT. These actions will be taken care of in the next step.) After that, you need to initialize RT's database by running7 KB (734 words) - 16:08, 6 April 2016
- WARNING: IF YOU DON'T KNOW YOUR WAY AROUND A DATABASE, STOP HERE. It may sound harsh, but you can bugger your RT database with a5 KB (764 words) - 16:03, 6 April 2016
- Enter the MYSQL root password you used earlier in order to set up the new RT database when prompted. Set the RT database access password (this password is for RT to connect to MYSQL & is store6 KB (861 words) - 16:39, 6 April 2016
- ...cookies in your browser won't have an expiry date and the sessions in the database will remain there, unless cleaned up by a cronjob.1 KB (210 words) - 10:07, 14 February 2020
- (You will definitely need to set RT's database password before continuing. After that, you need to initialize RT's database by running9 KB (1,484 words) - 16:23, 6 April 2016
- ...priate for all sites. I expect it could be modified to search in RT's user database...1 KB (217 words) - 16:03, 6 April 2016
- = Database Specific Notes =2 KB (247 words) - 17:26, 4 October 2021
- *MySQL for our database1 KB (162 words) - 16:11, 6 April 2016
- ...e a chance to review and select specific objects then remove them from the database while a backup SQL dump is created. ...RT instance and duplicate it onto a development box but not have the huge database full of tickets and ticket-related data.5 KB (770 words) - 06:33, 9 February 2024
- 2) Go into the "SQL Database Server" group and select the "mysql-server" package (not selected by defaul 14) Install RT3 and initialize the database:5 KB (691 words) - 16:09, 6 April 2016
- ...nfigured) the socket path DBI is expecting, RT will fail to connect to the database. Neither the my.cnf change or setting the database port worked for me. The $ENV was the solution that worked.4 KB (685 words) - 16:15, 6 April 2016
- * The database was taking a long time to process the query. More about the query later. * This setup has a database of about 5.6Gig (the size of the dump file)8 KB (1,241 words) - 16:39, 6 April 2016
- After that you can install RT and move on to setting up the database. make initialize-database8 KB (1,376 words) - 16:37, 6 April 2016
- Enter the MYSQL root password you used earlier in order to set up the new RT database when prompted. Set the RT database access password (this password is for RT to connect to MYSQL & is store6 KB (937 words) - 16:39, 6 April 2016
- ...database with the mysql command, but trying to view the RT page gets you a database error in error_log, [[SELinux]] may be the problem, see messages or audit.l 2.4. Database configuration11 KB (1,762 words) - 16:09, 6 April 2016
- ...not to make the permissions on this file too liberal, because it contains database passwords. You may need to put the webserver user in the appropriate group ...wly, one at a time, but the server doesn't appear to be overloaded and the database is not large.4 KB (622 words) - 16:09, 6 April 2016
- * Whenever RT tries -- and fails -- to load a user from the RT user database, it queries an Ldap server for the account information and creates it on th2 KB (307 words) - 16:03, 6 April 2016
- ...ded-insert --default-character-set=binary --databases rtdb_name --add-drop-database | gzip > /datos/dump.sql.gz] [./rt-setup-database --prompt-for-dba-password --action upgrade]15 KB (1,712 words) - 16:11, 6 April 2016
- Note: Create/Initialize RT's database make initialize-database4 KB (599 words) - 16:15, 6 April 2016
- ...te a "select one from many" custom field from a text file generated from a database query.2 KB (294 words) - 12:15, 6 August 2016
- ...on of the wiki is an attempt to guide you through small changes in system, database and RT installation that can make a big impact on performance. * A properly installed database application12 KB (1,979 words) - 16:20, 6 April 2016
- make initialize-database and re-run 'make initialize-database'.6 KB (1,022 words) - 16:15, 6 April 2016
- ...eans that the users' information can also be looked up against an external database, and it can even be a different one to the one providing authentication. * DBI support means support for any type of database service for which a Perl DBI driver exists and can be installed into your s8 KB (1,302 words) - 16:08, 6 April 2016
- ...l with this option, as it can only be undone using direct access to the RT database and not from the user interface, to fix the problem, on MySQL execute the f2 KB (330 words) - 16:36, 6 April 2016
- Virtual data in SQL database following this idea: Remeber to do a 'newaliases' command to make the new alias database.8 KB (1,168 words) - 16:20, 6 April 2016
- == Database backend == RT stores its data in a database. You can choose from the following database management systems (DBMS):15 KB (1,502 words) - 16:14, 6 April 2016
- > mysql drop database test; sudo make initialize-database4 KB (677 words) - 16:14, 6 April 2016
- Load a user from the database2 KB (311 words) - 16:38, 13 January 2017
- Set up database (this is where you need the MySQL root password you set earlier) sudo make initialize-database5 KB (686 words) - 16:34, 6 April 2016
- --with-db-type=TYPE sort of database RT will use (default: mysql; others are --with-db-host=HOSTNAME FQDN of database server (default: localhost)18 KB (2,551 words) - 16:14, 6 April 2016
- ...changes to tickets (be careful!), etc. It can both query and update the RT database. '''bin/rt''' has its limitations; it cannot deal with custom fields yet (a '''bin/rt''' talks to your RT web site (not directly to the database) and it needs to know how to connect as if it were a user using a web brows5 KB (818 words) - 16:39, 6 April 2016
- ...of Perl, may segfault at the "Creating system user..." stage of initialize-database instead of reporting the above error./2 KB (301 words) - 16:15, 6 April 2016
- ...recent RT versions. Before you set the password you must switch to the RT Database.2 KB (327 words) - 18:24, 26 June 2023