Hi all,
I had to put a new OTRS server into life for a new support activity.
In order to make it quicker, I backup and restore a virtual machine with an already existing OTRS server. Most of the agents are the same and so is the configuration.
But, I wanted to delete old agents, queues, dynamic fields and other old stuff. So I dump the MySQL database 'otrs', managed a new installation of OTRS server, cleared the stuff in the database and imported the new SQL dump into the new database nammed 'otrsSupport'.
I have created new queues and customers and fine tuned the configuration.
BUT... it seems that the server is randomly using both databases : 'otrs' and 'otrsSupport'. For example, I can't use the new dynamic field created in 'otrsSupport', but it is still visible in the admin panel.
Should I delete the 'otrs' database and rename the 'otrsSupport' one into 'otrs' only ?
It seems that tickets have been created in both databases ; how to merge them into one database ?
OTRS server randomly uses two databases
Moderator: crythias
-
- Znuny newbie
- Posts: 70
- Joined: 08 Jan 2015, 17:01
- Znuny Version: 5.0.10
- Real Name: Egareg JAOUEN
- Company: Elitt
OTRS server randomly uses two databases
OTRS v5.0.10 on Fedora25 with posgreSQL 9.4.9 database
Re: OTRS server randomly uses two databases
I think it is imposible, because you set the configuration of database connection.
Perhaps are you connecting by name instead of ip, and the name resolves two ips?
Regards
Perhaps are you connecting by name instead of ip, and the name resolves two ips?
Regards
Re: OTRS server randomly uses two databases
Hi,
I think you damaged your database. Espacially if you say that tickets are created in both.
My recommendation would be: Restore it to a valid point
In many cases tickets can be created randomly
- two OTRS Application servers running
- Mails (wrong routing) creates tickets
- agents work with old/wrong application servers
I think, you are on your own. Merging two databases is not possible.
Flo
I think you damaged your database. Espacially if you say that tickets are created in both.
My recommendation would be: Restore it to a valid point
In many cases tickets can be created randomly
- two OTRS Application servers running
- Mails (wrong routing) creates tickets
- agents work with old/wrong application servers
I think, you are on your own. Merging two databases is not possible.
Flo
OTRS 8 SILVER (Prod)
OTRS 8 auf Debian 11 (Test)
Znuny 7.x latest version testing auf Debian 11
-- Ich beantworte keine Forums-Fragen PN - No PN please
I won't answer to unfriendly users any more. A greeting and regards are just polite.
OTRS 8 auf Debian 11 (Test)
Znuny 7.x latest version testing auf Debian 11
-- Ich beantworte keine Forums-Fragen PN - No PN please
I won't answer to unfriendly users any more. A greeting and regards are just polite.
Re: OTRS server randomly uses two databases
are the 2 instances on the same server?
"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