Hi Quentin,
I try to recover categories or groups dynamically with provider "mail" but I can't find the good syntax for it.
It works with provider "Footprints"... I suppose it's due to the syntax HTML but i don't find where is the pb.
Can you help me?

Here is the body of providers "Footprints":
`{$user.alias} open ticket at {$smarty.now|date_format:"%d/%m/%y %H:%M:%S"}

{$custom_message}
Catégorie=Disque

{include file="file:$centreon_open_tickets_path/providers/Abstract/templates/display_selected_lists.ihtml" separator=""}

{if $host_selected|@count gt 0}
{foreach from=$host_selected item=host}
Host: {$host.name}
State: {$host.state_str}
Duration: {$host.last_hard_state_change_duration}
Output: {$host.output|substr:0:1024}

{/foreach}
{/if}

{if $service_selected|@count gt 0}
{foreach from=$service_selected item=service}
Host: {$service.host_name}
Service: {$service.description}
Service_id={$service.service_id}
State: {$service.state_str}
Duration: {$service.last_hard_state_change_duration}
Output: {$service.output|substr:0:1024}
{/foreach}
{/if}

{service_get_servicegroups host_id=$service.host_id service_id=$service.service_id}
service groups linked:
{foreach from=$service_get_servicegroups_result key=sg_id item=i}
id: {$sg_id} name = {$i.name}, alias = {$i.alias}
{/foreach}

{host_get_hostgroups host_id=$service.host_id}
host groups linked:
{foreach from=$host_get_hostgroups_result key=hg_id item=i}
id: {$hg_id} name = {$i.name}
{/foreach}

{service_get_servicecategories service_id=$service.service_id}
service categories linked:
{foreach from=$service_get_servicecategories_result key=sc_id item=i}
{if $i.description|substr:0:5 neq 'Type_'}

Catégorie={$i.name}

Catégorie=Autre

Here is the body of provider "Mail":
`

{$user.alias} open ticket at {$smarty.now|date_format:"%d/%m/%y %H:%M:%S"}

{$custom_message}

Catégorie=Disque

{include file="file:$centreon_open_tickets_path/providers/Abstract/templates/display_selected_lists.ihtml" separator=""}

{if $host_selected|@count gt 0}
{foreach from=$host_selected item=host}

Host: {$host.name} State: {$host.state_str} Duration: {$host.last_hard_state_change_duration} Output: {$host.output|substr:0:1024}

{/foreach}
{/if}

{if $service_selected|@count gt 0}
{foreach from=$service_selected item=service}

Host: {$service.host_name} Service: {$service.description} Service_id={$service.service_id} State: {$service.state_str} Duration: {$service.last_hard_state_change_duration} Output: {$service.output|substr:0:1024}

{service_get_servicegroups host_id=$service.host_id service_id=$service.service_id}

service groups linked:

id: {$sg_id} name = {$i.name}, alias = {$i.alias}

{host_get_hostgroups host_id=$service.host_id}

host groups linked:

id: {$hg_id} name = {$i.name}

{service_get_servicecategories service_id=$service.service_id}

service categories linked:

Catégorie={$i.name}

Catégorie=Autre

Create a provider which creates a ticket ID. No mail or API.

Hello,

With the version Centreon 2.8.18.
I manage to create tickets without problem via the widget.

But in the tab of the opened tickets widget nothing appears. It remains empty.

It's a bug or my fault ?

We have latest Centreon 2.8.1 in use and I installed centreon-open-ticket 1.2.0. Installation was successfull without any error, we can install the plugin and the widget, but we are not able to configure any rule because the menu is missing (Configuration > Notifications > Open Tickets > Rules).

Thanks

Jochen

see title

In the widget, the ticket id can reference a url.

Can add list of types:

• severity
• hostgroup
• host category
• custom (could set default)

Lists will be used before open the ticket (in a popup). You could choose in listings and help to open the ticket.

An DB error appear when, user try to duplicate rule

Could create ticket id like that for example: XXXY-1234-999

Hello, can one also automatically create a ticket in the OTRS via the notification? Manual per surface it is wonderful also close the ticket. Only it should also be automatic.

OS: CentOs 6.8
Centreon: 2.8.2

If we open a new ticket the popup "Please wait" (see screenshot) will be not closed automatically and is there for ever. In our case the notification rule is configured to send a mail and this works correctly.

Fix the link (20202 instead 20102).

Hello,

When we open a ticket, alerts are acknowledged in sticky mode.
So if an alert appears in warning, we create a ticket, the alert is acknowledged and go to the opened ticket widget.
If it goes critical, the alerts disappears from the opened tickets widget but it is not unacknowledged.

We use centreon-open-tickets in version 1.2.0.

The problem seems to be in the file /usr/share/centreon/www/modules/centreon-open-tickets/views/rules/ajax/actions/submitTicket.php :

if ($centreon_provider->doAck()) {
$command = "ACKNOWLEDGE_SVC_PROBLEM;%s;%s;%s;%s;%s;%s;%s";
$external_cmd->set_process_command(sprintf($command, $value['host_name'], $value['description'], 2, 0, 1, $contact_infos['alias'], 'open ticket: ' . $resultat['result']['ticket_id']), $value['instance_id']);
}

With the value 2,0,1 the service is acknowledged in sticky mode.
We change 2 to 1 and acknowledgement go away when it changing state.

Hi,
Really good projet.
Can you add OTRS Provider ?
OTRS have a REST API.

Regards

Can save in json format the data selected.
Add a purge script to delete history

Change theme to use Centreon UI 2.7.x CSS

Hello,

Can you add a provider for Redmine ?

Regards

Add a perl script to open a ticket from command line. The perl script will do:

• connect the user
• call the 'submitTicket' ajax

Hello,

Can you add a provider for Kayako ?

Regards

For GLPI 9.1 the webservice plugin which is necessary to work with centreon-open-tickets is not more available probably because GLPI brings how own build in API. It would be great if you can provide compatibility with them?

Hello,

Can you add a provider for BMC Remedy ?

Regards

Hi,

Is it possible to use existing macros from centreon like those present on notification form?

If not, some of smarty variables are same on database like "$service.host_name" but others like "$host.state_str" are not present on database.
How can we know variables available with smarty?

regards.

Hi, can you add this provider please?
It's a little bit different to BMC Remedy.

If you need more informations, you can read these articles:
https://itsm-fp.northwestern.edu/help/FootPrintsHelp/content/web_services_api.htm
and
https://itsm-fp.northwestern.edu/help/FootPrintsHelp/content/perl_sample.htm

regards,

Currently on 2.7.8, all upgrades seems to have gone fine until it reached 2.8.0-beta1
For some reason the first ALTER in the file appears to contain a duplicate key and had to comment out to continue. That now worked fine for that file.
2.7.8 to 2.8.0-beta1 Update-CSTG-2.7.8_to_2.8.0-beta1.sql Line 2:DB Error: already exists

I then fail at upgrading between 2.8.3 to 2.8.4. The problem here is that the error doesn't indicate what files are causing problems.

Currently upgrading database... please do not interrupt this process.

Step Status
2.8.3 to 2.8.4 DB Error: already exists
You seem to be having trouble with your upgrade.
You may refer to the line that causes problem in order to find out more about the issue.
The SQL files are located in /usr/local/centreon/www/install/sql/
But do not edit the SQL files unless you know what you are doing.Refresh this page when the problem is fixed.

The only files found with 2.8.3 shown below.
root@neper:/usr/local/centreon/www/install/step_upgrade# find ../sql/|grep 2.8.3
../sql/centreon/._Update-DB-2.8.2_to_2.8.3.sql
../sql/centreon/._Update-DB-2.8.3_to_2.8.4.sql
../sql/centreon/Update-DB-2.8.2_to_2.8.3.sql
../sql/centreon/Update-DB-2.8.3_to_2.8.4.sql
root@neper:/usr/local/centreon/www/install/step_upgrade#

the centreon information.version contains 2.8.4 so I assume the query below must have worked. So I have no idea what SQL file is now causing problems

UPDATE informations SET value = '2.8.4' WHERE CONVERT( informations.key USING utf8 ) = 'version' AND CONVERT ( informations.value USING utf8 ) = '2.8.3' LIMIT 1;

Hi,
I have installed centreon open tickets on centreon 2.8.11 and 2.8.12. The installation is OK, i can install the module and the widget but i don't have the menu Configuration --> Notifications --> Open Tickets --> Rules. I saw issue #34 and check the install.sql file, it seems OK.
Does anyone have the same problem ? Did i miss something ?

Thanks,
Claire

Add a method for providers to test the connection on API.

Hi,

If I don't specify headers in rule on Mail provider, an error was catch in apache error_log:

PHP Notice: Undefined variable: headers in /usr/share/centreon/www/modules/centreon-open-tickets/providers/Mail/MailProvider.class.php on line 182, referer: http://192.168.0.5/centreon/main.php?p=103

but the mail already contains headers "MIME-Version" and "Content-type" sets by default by postfix I suppose...

If I specify some values like this:

same error appear in error_log but the mail contains two definition of this headers variables like this:

regards

Hello,

Could you please add ServiceNow?

Thanks in advance

New provider.

Can use email for mail from. Can also use smarty for subject

Add a script to purge open tickets history

Tickets for Business Activities (top-level only or any BA).

see titles

Hi,

Why not adding support for generic SQL Insert? In fact, my customer's provider is actually not supported by centreon-open-ticket (it's Landesk Service Desk Management).
The only supported way my customer allow to create a ticket through this product is by doing Insert in its MSSQL database. I know Landesk ServiceDesk is able to do otherwise (mail, API, etc...) but it's need some additional developpment that my customer don't want.

So why not adding a generic functionality like this instead of developping a custom provider module?

Regards.

Hi,

configure the webservice provider mapping (you need to do it for all operations!!). For example:
'CustomerUser::CustomerUserGet' set '/CustomerUserGet/'

I dont understand this part.
You're talking about Configure Network transport > Route mapping for Operation 'CustomerUser': ?
Or, Inbound / outbound mapping for operations ?

Better, can you export Rest Webservice from OTRS in yml format ?

Thank you for your work

Regards

Hi,

We are on centreon web 2.8.11. Non admin users can not get service groups dashboard report since the update. Otherwise they can view hosts and host groups dashboard report.

I checked ACL without finding any issue.

Can you please help ?

Regards

When we open a ticket, we have a confirim popup. We can add a option to autoclose the popup.

Hi,
I would like to know which fields are provided by methods and articles.

Some standard fields are available and can be guessed as service.description or host.name but others are not ... like longoutput, notes_url, etc...

Where is the request who build and convert this values (integer in string such as "state_str")

thanks for your help.

Hi,

Can you add the possibility to get groups or categories template of host or service.
Actually, the method can only get direct group or category of hosts and services.

thanks,

Hello,
in centreonExternalCommand.class.php is define setProcessCommand.
and not define set_process_command!

This is issue for Bug!

vi /usr/share/centreon/www/class/centreonExternalCommand.class.php

public function set_process_command($command, $poller)
{
if ($this->debug) {
print "POLLER: $poller
";
print "COMMAND: $command
";
}

    $this->cmdTab[] = $command;
    $this->pollerTab[] = $poller;
}

Can display ticket history (with search filters)

Bonjour,

Serait il possible d'ajouter le choix d'un observateur et d'associer le ticket à un équipement vers GLPI?

Merci d'avance

Matthieu Le Roy

Bonjour,

Y a t-il la possibilité d'avoir l'extension centreon-open-ticket en français ? Nous utilisons ce plugin pour nos clients et lorsqu'ils veulent ouvrir un ticket l'ensemble des champs sont en anglais et cela leur pose problème. Je pourrais tout traduire dans le code en dur mais hélas le jour où je ferai une mise à jour de l'extension il sera de nouveau en anglais je suppose.
J'ai bien vérifié et mon serveur OTRS est en français de son côté, Centreon aussi mais le plugin lui même ne l'est pas.

Hello,
Is it possible to have this plugin in french ? We use this plugin for all clients we have and when they want to open ticket, all is in english, it's a big problem for them. I could translate file code but if there is an update i think all return in english.
I verify my OTRS and Centreon server and all is configure in French, except the plugin.

Merci
Thanks

Cordialement
Regards

Create the provider for GLPI.

• config: can extend list types for entities, group and itil categories
• config: mapping values for createTicket API
• get unit value for entities, group and itil categories
• save and create ticket

Hi,

I try to recover the hostgroup value but the name is truncate at the only first character

The smartycode for example

{host_get_hostgroups host_id=$service.host_id}
host groups linked:
{foreach from=$host_get_hostgroups_result key=hg_id item=i}
 id: {$hg_id} name = {$i.name}
{/foreach}

The groups linked

And the result:

host groups linked:
 id: 53 name = L
 id: 62 name = P

The result of query directly in database:

MariaDB [centreon_storage]> SELECT hostgroups.* FROM hosts_hostgroups, hostgroups WHERE hosts_hostgroups.host_id = 205 AND hosts_hostgroups.hostgroup_id = hostgroups.hostgroup_id;
+--------------+-----------------+
| hostgroup_id | name            |
+--------------+-----------------+
|           53 | Linux-Servers   |
|           62 | POC-DATACONTENT |
+--------------+-----------------+

regards

Hi,
How can I get host_address if I select a service?
Which function do I must use for it?

Thanks,

Buenos días,
cómo escapar en centreon web "", p.e. al definir el command:
ha$a como hacer que no lo interprete como ha\$a

Gracias

Hello,

I use these product's version :

• centreon-open-ticket 1.2.0
• centreon 2.8.7
• GLPi 9.1.3

When i create a ticket through widget, the popup windows is well populated for Entity and GLPi Group but not for Itil Category.

Here is the error message shown in the popup window :
webservice 'glpi.listObjects' error (16): Command not allowed

This method is allowed in the web service configuration of glpi.

I presume it comes from line 491 on this file :
/usr/share/centreon/www/modules/centreon-open-tickets/providers/Glpi/GlpiProvider.class.php :

    $this->glpi_call_response = $this->requestRpc('glpi.listObjects', array('start' => 0, 'limit' => 100, 'name' => $filter,
                                                  'itemtype' => 'itilcategory', 'show_label' => 1));

Is that method have been tested with the itemtype filter ?

How can i debug what's going wrong ?

Thanks.

Need to check if the host is enabled.

When I create a service ticket I can not see it in the widget, you only see host tickets.

I also built a command which creates and closes the tickets via notification.

I use OTRS and have fully automated it.

What would be nice is a TopTen overview of the tickets