[SOLVED] 2 otrs, 1 database

[zip]

Hello,

its possible to use two otrs systems (on two different server) with one database (which is on another server)?

Thanks

[jojo]

you can use the same database server but can not share the same database without any issues

[zip]

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?

[crythias]

install otrs on a new server with a new database and connect it to the old database after the configuration?

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.
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.

[crythias]

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.

[zip]

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?

[crythias]

custom files, too.

[zip]

i did it, but i have a problem with th customer ldap connection.
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

and

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

the authentification and connections to the ldap with the agent is working fine.

[wurzel]

Hi,

first bind failed = username/password wrong

Flo

[crythias]

except bad file descriptor and can't find server ... add inet=>4

[zip]

added inet=>4 but nothing happend. i hoped i added it in the right place, ldap customer backend:

Code: Select all

Params => {
port => 389,
timeout => 120,
async => 0,
version => 3,
inet => 4,
},

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?

Capture.PNG

Capture2.PNG

[crythias]

"nothing happened" ... so, you get the same error messages?

[zip]

yes

[zip]

here my config

Config13.txt

[zip]

its maybe making problems because now i have 2 otrs systems online (with the same config)?

[crythias]

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

[zip]

http://bugs.otrs.org/show_bug.cgi?id=10004

had to delete inet6.pm in my perl.

now its working fine.

[zip]

ldap is working fine, but there are problems with the queues. in otrs i have the standart queues:

Queues.PNG

in sql i have this:

queue_sql.PNG

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!

do i have to change something in sysconfig or maybe run a file in otrs/bin?

[crythias]

Type is not queue.

[zip]

ok, but why are in my database my queues but in otrs there are the standar queues? how do i fix that?

[crythias]

ok, but why are in my database my queues but in otrs there are the standar queues? how do i fix that?

wrong database.

[zip]

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.