DynamicFieldRemoteDB can not connect database.

Moderator: crythias

Post Reply
tune6688
Znuny newbie
Posts: 61
Joined: 19 Nov 2020, 14:33
Znuny Version: 6.030
Real Name: wei

DynamicFieldRemoteDB can not connect database.

Post by tune6688 »

Title: DynamicFieldRemoteDB can not connect database.

Environment: OTRS community version 6.030
DynamicFieldRemoteDB:6.03
DynamicFieldOTRSDBTable:6.0.6

Description:
1、We have download the OPM package from https://opar.perl-services.de/dist/DynamicFieldRemoteDB, and can find the remoteDB in adding dynamic field, as that in the diagram below, we added the DSN, users and PW of the database, and the data of data table we plan to mapping.
1.png
2、After adding dynamic field in AgentTicketphone page, we can see the ticket_type, but without any info.
2.png
3、Same action on DynamicFieldOTRSDBTable, ticket_type have data, as showed below.
3.png
4、We have ever tried to replace the DSN of DB with DBI:mysql:database=otrs;host=localhost;
DBI:mysql:otrs:localhost , but with the same result. We cannot find the reason for this problem.
You do not have the required permissions to view the files attached to this post.
skullz
Znuny superhero
Posts: 618
Joined: 24 Feb 2012, 03:58
Znuny Version: LTS and Features
Real Name: Mo Azfar
Location: Kuala Lumpur, MY
Contact:

Re: DynamicFieldRemoteDB can not connect database.

Post by skullz »

Code: Select all

Suffix => *
MinQueryLength => 1
Afterwards, delete otrs cache first via otrs.Console.pl
tune6688
Znuny newbie
Posts: 61
Joined: 19 Nov 2020, 14:33
Znuny Version: 6.030
Real Name: wei

Re: DynamicFieldRemoteDB can not connect database.

Post by tune6688 »

skullz wrote: 10 Apr 2021, 02:02

Code: Select all

Suffix => *
MinQueryLength => 1
Afterwards, delete otrs cache first via otrs.Console.pl
Thank you for your reply, but I still don’t understand.Could you tell me in detail?
skullz
Znuny superhero
Posts: 618
Joined: 24 Feb 2012, 03:58
Znuny Version: LTS and Features
Real Name: Mo Azfar
Location: Kuala Lumpur, MY
Contact:

Re: DynamicFieldRemoteDB can not connect database.

Post by skullz »

tune6688 wrote: 10 Apr 2021, 17:16
skullz wrote: 10 Apr 2021, 02:02

Code: Select all

Suffix => *
MinQueryLength => 1
Afterwards, delete otrs cache first via otrs.Console.pl
Thank you for your reply, but I still don’t understand.Could you tell me in detail?
Check back the dynamic field setting value.

Set

SearchSuffix = *
MinQueryLength = 1
tune6688
Znuny newbie
Posts: 61
Joined: 19 Nov 2020, 14:33
Znuny Version: 6.030
Real Name: wei

Re: DynamicFieldRemoteDB can not connect database.

Post by tune6688 »

skullz wrote: 11 Apr 2021, 12:54
tune6688 wrote: 10 Apr 2021, 17:16
skullz wrote: 10 Apr 2021, 02:02

Code: Select all

Suffix => *
MinQueryLength => 1
Afterwards, delete otrs cache first via otrs.Console.pl
Thank you for your reply, but I still don’t understand.Could you tell me in detail?
Check back the dynamic field setting value.

Set

SearchSuffix = *
MinQueryLength = 1
Hi skull,

Here's my complete picture. I set it up and cleared the OTRs cache, but nothing changed,Do you have any better suggestions?

Why doesn't DBtable need to be set like this, because it looks similar
Dynamic Fields RemoteDB Backend GUI - OTRS__ITSM 6.png
You do not have the required permissions to view the files attached to this post.
skullz
Znuny superhero
Posts: 618
Joined: 24 Feb 2012, 03:58
Znuny Version: LTS and Features
Real Name: Mo Azfar
Location: Kuala Lumpur, MY
Contact:

Re: DynamicFieldRemoteDB can not connect database.

Post by skullz »

its working fine in my setup
3.png
2.PNG
1.PNG
You do not have the required permissions to view the files attached to this post.
Post Reply