External access to OTRS Appliance

[elitt]

Hi,

I just installed a new OTRS appliance on a Microsoft Windows 7 machine.
I use Virtual Box, as described in the installation manual and OTRS is working well.

But I wonder if it is possible to have an external access to the database (using ODBC) or the files (using FTP).

Thanks !

Egareg JAOUEN

[elitt]

No one has encountered the same issue ?

For example, I am trying to modify the templates files but it is a little bit 'ugly' using only vi...
Is it possible to install a FTP server like proftpd ? Did someone succeed in ?

The ODBC access is to manage some exports in .mdb format for archiving purpose.

[Rooobaaat]

You must edit the file /etc/apt/sources.list and insert the standard debian repos.
after this run apt-get update and apt-get install proftpd-basic

[elitt]

Thanks for your answer.

Before I saw your post, I tried to install proftpd on my OTRS appliance without adding repos in sources.list (using wget and dpkg -i). After tries and manuel readings, I noticed that SSH access is open and SFTP is allowed with some FTP clients such as Filezilla.

I can now edit my files to add custom templates, improve translation into french without . 1 point solved !

2nd point remains : how to access with ODBC driver to the posgreSQL database ? Did someone pass this step ?

[Rooobaaat]

Why you want to access the PostgreSQL database over ODBC? o_O

[elitt]

Strange issue, isn't it ?

We are leaving away an old software and starting to use OTRS.
My agents have to (weekly and monthly) send reports based upon the tickets created, modified or closed... The reports layouts are based on Access Database : in order to preserve the original database, they duplicate the database (from SQL Server) to an Access one. Then, they juste have to click on one button in one form to have their reports printed.
Some tables are also send to customers into .mdb file format.

On the one hand and in order to preserve their process, I wonder if it is possible to duplicate the PosgreSQL database (or some tables) to an Access one with an ODBC link.

On the other hand, I am trying to customize PDF printings for stats but it may last a while...

[netjess]

is possible to have an external access to the database (using ODBC)

I have basically the same question.
viewtopic.php?f=62&t=29199&p=118018&hil ... se#p118018

Did you ever get an answer?

Thank you.

[elitt]

No answer to this issue...

I by-passed this by creating statistics, exporting it into .csv or .xsl files and linking these files to an Access database. Pretty ugly but still working...

[crythias]

You could start with this search.

[netjess]

You could start with this search.

Thanks, that is good info.
As far as the appliance VM goes there is still the issue of the error:
FEHLER: keine Berechtigung, um Rolle zu erzeugen (ERROR : No authorization to create role).

You end up have to give the otrs username/password to the outside resource, or move OTRS to an installed application rather than using the appliance version.

I guess I could try to work my issue from the other direction and push (or pull) to the outside application rather than connecting to OTRS from the outside application.