OTRS server randomly uses two databases

[elitt]

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 ?

[fcasal]

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

[wurzel]

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

[jojo]

are the 2 instances on the same server?