[SOLVED] 2 otrs, 1 database
Moderator: crythias
[SOLVED] 2 otrs, 1 database
Hello,
its possible to use two otrs systems (on two different server) with one database (which is on another server)?
Thanks
its possible to use two otrs systems (on two different server) with one database (which is on another server)?
Thanks
Last edited by zip on 30 Jul 2014, 15:23, edited 3 times in total.
OTRS 5.0.9 - CentOS 7 - MariaDB 5.5
Re: 2 otrs, 1 database
you can use the same database server but can not share the same database without any issues
"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: 2 otrs, 1 database
ok. my goal is to install otrs on a new server and use the old database without any interuption of the service. Can i install otrs on a new server with a new database and connect it to the old database after the configuration?
OTRS 5.0.9 - CentOS 7 - MariaDB 5.5
-
- Moderator
- Posts: 10169
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: 2 otrs, 1 database
Seems legit. In practical terms, your proposition makes sense, as long as you terminate connection on old otrs (for instance, changing the DB password in Config.pm) prior to enabling the new one.zip wrote:install otrs on a new server with a new database and connect it to the old database after the configuration?
Note that the versions of otrs need to be the same major.minor version but can be different/upgraded releases within the minor (as long as the docs say so.)
That means if you're on 3.3.2, you can (should be able to) install new on 3.3.8 with the same DB structure.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
-
- Moderator
- Posts: 10169
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: 2 otrs, 1 database
sorry for the double-post but also be aware that your old OTRS may still fetch email so you definitely want to turn that cron off.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Re: 2 otrs, 1 database
i have otrs 3.3.8 on my old server (windows server 2008 r2) and i will install 3.3.8 on the new server (windows server 2012 r2).
ok thanks help.
since i want a exact copy of my old otrs on the new server i will export the sysconfig from my old otrs and import it to the new otrs.
and i will copy these files:
- OTRS\Kernel\Config.pm
- OTRS\Kernel\Config\GenericAgent.pm
- OTRS\Kernel\Config\Files\ZZZAuto.pm
and some modified
which files i have to copy if i want to transfer my agents, notifications and postmaster filters?
any other files i should copy/replace?
ok thanks help.
since i want a exact copy of my old otrs on the new server i will export the sysconfig from my old otrs and import it to the new otrs.
and i will copy these files:
- OTRS\Kernel\Config.pm
- OTRS\Kernel\Config\GenericAgent.pm
- OTRS\Kernel\Config\Files\ZZZAuto.pm
and some modified
which files i have to copy if i want to transfer my agents, notifications and postmaster filters?
any other files i should copy/replace?
OTRS 5.0.9 - CentOS 7 - MariaDB 5.5
-
- Moderator
- Posts: 10169
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: 2 otrs, 1 database
custom files, too.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Re: 2 otrs, 1 database
i did it, but i have a problem with th customer ldap connection.
it throws me this error:
and
the authentification and connections to the ldap with the agent is working fine.
it throws me this error:
Code: Select all
[Mon Jul 28 10:41:24 2014][Error][Kernel::System::Type::TypeLookup][383] No TypeID for 2 found!
[Mon Jul 28 10:41:24 2014][Error][Kernel::System::CustomerUser::LDAP::CustomerName][248] Search failed! Can't contact LDAP server
[Mon Jul 28 10:41:24 2014][Error][Kernel::System::Type::TypeLookup][383] No TypeID for 2 found!
[Mon Jul 28 10:41:24 2014][Error][Kernel::System::CustomerUser::LDAP::CustomerName][248] Search failed! Can't contact LDAP server
Code: Select all
[Mon Jul 28 11:28:18 2014][Error][Kernel::System::CustomerAuth::LDAP::Auth][132] Need User!
[Mon Jul 28 11:28:18 2014][Notice][Kernel::System::CustomerAuth::HTTPBasicAuth::Auth] User: customer1 Authentication ok (REMOTE_ADDR: 193.228.40.177).
[Mon Jul 28 11:28:18 2014][Error][Kernel::System::CustomerUser::LDAP::_Connect][197] First bind failed! Bad file descriptor
[Mon Jul 28 11:28:18 2014][Error][Kernel::System::CustomerUser::SetPreferences][587] No such user 'customer1'!
[Mon Jul 28 11:28:18 2014][Error][Kernel::System::CustomerUser::LDAP::CustomerUserDataGet][758] Can't contact LDAP server
[Mon Jul 28 11:28:18 2014][Error][Kernel::System::CustomerUser::LDAP::_Connect][197] First bind failed! Bad file descriptor
OTRS 5.0.9 - CentOS 7 - MariaDB 5.5
Re: 2 otrs, 1 database
Hi,
first bind failed = username/password wrong
Flo
first bind failed = username/password wrong
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.
-
- Moderator
- Posts: 10169
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: 2 otrs, 1 database
except bad file descriptor and can't find server ... add inet=>4
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Re: 2 otrs, 1 database
added inet=>4 but nothing happend. i hoped i added it in the right place, ldap customer backend:
i copied the config.pm from my other otrs where its working fine (windows server 2008 r2). maybe because i'm now on a 2012 r2 and i need to change something in the config.pm?
Code: Select all
Params => {
port => 389,
timeout => 120,
async => 0,
version => 3,
inet => 4,
},
You do not have the required permissions to view the files attached to this post.
OTRS 5.0.9 - CentOS 7 - MariaDB 5.5
-
- Moderator
- Posts: 10169
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: 2 otrs, 1 database
"nothing happened" ... so, you get the same error messages?
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Re: 2 otrs, 1 database
here my config
You do not have the required permissions to view the files attached to this post.
OTRS 5.0.9 - CentOS 7 - MariaDB 5.5
Re: 2 otrs, 1 database
its maybe making problems because now i have 2 otrs systems online (with the same config)?
OTRS 5.0.9 - CentOS 7 - MariaDB 5.5
-
- Moderator
- Posts: 10169
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: 2 otrs, 1 database
can't connect LDAP server is ... can't connect
firewall, routing, port, IP address, etc. troubleshoot first. Not OTRS issue.
No TypeID for 2 means something else - issue with Types. Misspelling or something else
First bind failed! Bad file descriptor means bad communication with ldap server.
https://www.google.com/search?q=First+b ... descriptor
firewall, routing, port, IP address, etc. troubleshoot first. Not OTRS issue.
No TypeID for 2 means something else - issue with Types. Misspelling or something else
First bind failed! Bad file descriptor means bad communication with ldap server.
https://www.google.com/search?q=First+b ... descriptor
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Re: 2 otrs, 1 database
OTRS 5.0.9 - CentOS 7 - MariaDB 5.5
Re: 2 otrs, 1 database
ldap is working fine, but there are problems with the queues. in otrs i have the standart queues:
in sql i have this:
could this cause the error?:
do i have to change something in sysconfig or maybe run a file in otrs/bin?
in sql i have this:
could this cause the error?:
Code: Select all
[Tue Jul 29 16:28:01 2014][Error][Kernel::System::Type::TypeLookup][383] No TypeID for 2 found!
[Tue Jul 29 16:28:01 2014][Error][Kernel::System::Type::TypeLookup][383] No TypeID for 2 found!
[Tue Jul 29 16:28:01 2014][Error][Kernel::System::Type::TypeLookup][383] No TypeID for 2 found!
[Tue Jul 29 16:28:01 2014][Error][Kernel::System::Type::TypeLookup][383] No TypeID for 2 found!
[Tue Jul 29 16:28:01 2014][Error][Kernel::System::Type::TypeLookup][383] No TypeID for 2 found!
You do not have the required permissions to view the files attached to this post.
OTRS 5.0.9 - CentOS 7 - MariaDB 5.5
-
- Moderator
- Posts: 10169
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: 2 otrs, 1 database
Type is not queue.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Re: 2 otrs, 1 database
ok, but why are in my database my queues but in otrs there are the standar queues? how do i fix that?
OTRS 5.0.9 - CentOS 7 - MariaDB 5.5
-
- Moderator
- Posts: 10169
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: 2 otrs, 1 database
wrong database.zip wrote:ok, but why are in my database my queues but in otrs there are the standar queues? how do i fix that?
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Re: 2 otrs, 1 database
i added a new queue and then my queues appeared. same with the ticket types, which caused the typelookup error. maybe a server restart could avoid this problems.
Thanks for help, now everything is working fine.
Thanks for help, now everything is working fine.
OTRS 5.0.9 - CentOS 7 - MariaDB 5.5