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.
Doubts about database management
Moderator: crythias
Doubts about database management
OTRS 3.1.6 on ubuntu with MySQL
Re: Doubts about database management
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
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
Re: Doubts about database management
so, if I want to use an external db? how can I import those data?
OTRS 3.1.6 on ubuntu with MySQL
Re: Doubts about database management
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
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
Re: Doubts about database management
unfortunately, I am database admin; this is an universitary project, so I'm doing some tests.
OTRS 3.1.6 on ubuntu with MySQL
-
- 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
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.
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