Doubts about database management

Moderator: crythias

Locked
rschirin
Znuny newbie
Posts: 35
Joined: 16 Apr 2012, 18:25
Znuny Version: 3.1.2

Doubts about database management

Post by rschirin »

hi, someone can explain me two things about the use of database into otrs?
1- when I install otrs on my pc, in which database´s file are saved the informations about the user ¨root¨?
2- if I create a new user, where is it saved? I need exacly the file.
3- if I want to replace the classic database called ¨otrs¨ with a different database ¨mydb¨, how can I do that? otrs recognizes automatically the fields of ¨mydb¨ tables?

I readed the manual of otrs 3.1 but these doubts still remain.
OTRS 3.1.6 on ubuntu with MySQL
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Doubts about database management

Post by jojo »

OTRS uses a SQL based database engine, so you can not work directly with the database files. You also can not have your onw database with own tables, OTRS brings its own database layout.
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
rschirin
Znuny newbie
Posts: 35
Joined: 16 Apr 2012, 18:25
Znuny Version: 3.1.2

Re: Doubts about database management

Post by rschirin »

so, if I want to use an external db? how can I import those data?
OTRS 3.1.6 on ubuntu with MySQL
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Doubts about database management

Post by jojo »

via some SQL Tools. Ask your database admin to do so
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
rschirin
Znuny newbie
Posts: 35
Joined: 16 Apr 2012, 18:25
Znuny Version: 3.1.2

Re: Doubts about database management

Post by rschirin »

unfortunately, I am database admin; this is an universitary project, so I'm doing some tests.
OTRS 3.1.6 on ubuntu with MySQL
adupre01
Znuny newbie
Posts: 73
Joined: 09 Jun 2011, 18:22
Znuny Version: 3.0
Real Name: Andre
Company: Hamline University

Re: Doubts about database management

Post by adupre01 »

You will either need to setup OTRS to connect to your database

http://doc.otrs.org/3.1/en/html/external-backends.html

Or, like Jojo said, import it using some tools.
OTRS 3.1.3 + ITSM 3.1.1 + FAQ 2.1.2 + Survey 2.1.3, Redhat
Locked