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.
2、After adding dynamic field in AgentTicketphone page, we can see the ticket_type, but without any info.
3、Same action on DynamicFieldOTRSDBTable, ticket_type have data, as showed below.
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.
DynamicFieldRemoteDB can not connect database.
Moderator: crythias
DynamicFieldRemoteDB can not connect database.
You do not have the required permissions to view the files attached to this post.
-
- Znuny superhero
- Posts: 621
- 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.
Code: Select all
Suffix => *
MinQueryLength => 1
Re: DynamicFieldRemoteDB can not connect database.
Thank you for your reply, but I still don’t understand.Could you tell me in detail?skullz wrote: ↑10 Apr 2021, 02:02Afterwards, delete otrs cache first via otrs.Console.plCode: Select all
Suffix => * MinQueryLength => 1
-
- Znuny superhero
- Posts: 621
- 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.
Check back the dynamic field setting value.tune6688 wrote: ↑10 Apr 2021, 17:16Thank you for your reply, but I still don’t understand.Could you tell me in detail?skullz wrote: ↑10 Apr 2021, 02:02Afterwards, delete otrs cache first via otrs.Console.plCode: Select all
Suffix => * MinQueryLength => 1
Set
SearchSuffix = *
MinQueryLength = 1
Re: DynamicFieldRemoteDB can not connect database.
Hi skull,skullz wrote: ↑11 Apr 2021, 12:54Check back the dynamic field setting value.tune6688 wrote: ↑10 Apr 2021, 17:16Thank you for your reply, but I still don’t understand.Could you tell me in detail?skullz wrote: ↑10 Apr 2021, 02:02Afterwards, delete otrs cache first via otrs.Console.plCode: Select all
Suffix => * MinQueryLength => 1
Set
SearchSuffix = *
MinQueryLength = 1
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
You do not have the required permissions to view the files attached to this post.
-
- Znuny superhero
- Posts: 621
- 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.
its working fine in my setup
You do not have the required permissions to view the files attached to this post.