Search results
Jump to navigation
Jump to search
- ===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