External access to OTRS Appliance
Moderator: crythias
-
- Znuny newbie
- Posts: 70
- Joined: 08 Jan 2015, 17:01
- Znuny Version: 5.0.10
- Real Name: Egareg JAOUEN
- Company: Elitt
External access to OTRS Appliance
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
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
OTRS v5.0.10 on Fedora25 with posgreSQL 9.4.9 database
-
- Znuny newbie
- Posts: 70
- Joined: 08 Jan 2015, 17:01
- Znuny Version: 5.0.10
- Real Name: Egareg JAOUEN
- Company: Elitt
Re: External access to OTRS Appliance
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.
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.
OTRS v5.0.10 on Fedora25 with posgreSQL 9.4.9 database
Re: External access to OTRS Appliance
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
after this run apt-get update and apt-get install proftpd-basic
My english is better than your german
"Produktiv": OTRS: 5.0.x, OTRS::ITSM 5.0.x
"Testing": OTRS 6 git
OS: Debian 8.0 (Jessie)
Apache2.4.10/MySQL 5.5.41
"Produktiv": OTRS: 5.0.x, OTRS::ITSM 5.0.x
"Testing": OTRS 6 git
OS: Debian 8.0 (Jessie)
Apache2.4.10/MySQL 5.5.41
-
- Znuny newbie
- Posts: 70
- Joined: 08 Jan 2015, 17:01
- Znuny Version: 5.0.10
- Real Name: Egareg JAOUEN
- Company: Elitt
Re: External access to OTRS Appliance
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 ?
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 ?
OTRS v5.0.10 on Fedora25 with posgreSQL 9.4.9 database
Re: External access to OTRS Appliance
Why you want to access the PostgreSQL database over ODBC? o_O
My english is better than your german
"Produktiv": OTRS: 5.0.x, OTRS::ITSM 5.0.x
"Testing": OTRS 6 git
OS: Debian 8.0 (Jessie)
Apache2.4.10/MySQL 5.5.41
"Produktiv": OTRS: 5.0.x, OTRS::ITSM 5.0.x
"Testing": OTRS 6 git
OS: Debian 8.0 (Jessie)
Apache2.4.10/MySQL 5.5.41
-
- Znuny newbie
- Posts: 70
- Joined: 08 Jan 2015, 17:01
- Znuny Version: 5.0.10
- Real Name: Egareg JAOUEN
- Company: Elitt
Re: External access to OTRS Appliance
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...
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...
OTRS v5.0.10 on Fedora25 with posgreSQL 9.4.9 database
-
- Znuny expert
- Posts: 172
- Joined: 16 Nov 2011, 23:35
- Znuny Version: 6.0.16
- Real Name: Jesse
- Company: Mercer Valve Company
- Location: Oklahoma USA
- Contact:
Re: External access to OTRS Appliance
I have basically the same question.elitt wrote:is possible to have an external access to the database (using ODBC)
viewtopic.php?f=62&t=29199&p=118018&hil ... se#p118018
Did you ever get an answer?
Thank you.
Powered by OTRS 6
Active Directory LDAP Integration.
Ubuntu 18 LTS, Apache2, PostgreSQL.
Active Directory LDAP Integration.
Ubuntu 18 LTS, Apache2, PostgreSQL.
-
- Znuny newbie
- Posts: 70
- Joined: 08 Jan 2015, 17:01
- Znuny Version: 5.0.10
- Real Name: Egareg JAOUEN
- Company: Elitt
Re: External access to OTRS Appliance
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...
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...
OTRS v5.0.10 on Fedora25 with posgreSQL 9.4.9 database
-
- Moderator
- Posts: 10169
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: External access to OTRS Appliance
You could start with this search.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
-
- Znuny expert
- Posts: 172
- Joined: 16 Nov 2011, 23:35
- Znuny Version: 6.0.16
- Real Name: Jesse
- Company: Mercer Valve Company
- Location: Oklahoma USA
- Contact:
Re: External access to OTRS Appliance
Thanks, that is good info.crythias wrote:You could start with this search.
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.
Powered by OTRS 6
Active Directory LDAP Integration.
Ubuntu 18 LTS, Apache2, PostgreSQL.
Active Directory LDAP Integration.
Ubuntu 18 LTS, Apache2, PostgreSQL.