Hi Marco, I have the Host, Port, User, Password, however I still cannot connect. We are running OTRS on Linux, did you have any issues connecting with port 3306? openSUSE 10.2 (i586 Kernel Version Linux 2.6.18.2-34-bigsmp Perl 5.8.8 (linux) is used. O OTRS 2.2.5 -----Ursprüngliche Nachricht----- Von: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] Im Auftrag von Marco Vannini Gesendet: Mittwoch, 4. Februar 2009 15:29 An: User questions and discussions about OTRS. Betreff: Re: [otrs] OTRS Manager App I found it awesome. there is nothing hard to do if you know all about your db (host, port, user, password) 2009/2/4 James, Michael :

Hello,

A general question, has anyone used the OTRS Manager tool from tokaware?

If so, are there any issues to be aware of prior to use?

Thanks in advance

Mike

Mike James Netzbetrieb - Broadband

Unitymedia Group Michael Schumacher-Str. 1 50170 Kerpen

Tel. +49 (0) 2273 - 605 - 7168 Fax. +49 (0) 2273 - 605 - 7121 PC Fax. +49 (0) 2273 - 5947 - 2668 Mobil. +49 (0) 175 727 1034 e-mail michael.james@unitymedia.de

www.unitymedia.de

Unitymedia NRW GmbH Handelsregister: Amtsgericht Köln HRB 55984 Geschäftsführer: Parm Sandhu, Dr. Herbert Leifker, Christopher Winfrey

_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

Hi Steve, Thanks for the info. I guess you know the question i have now, how and where can I configure that? Thanks Mike -----Ursprüngliche Nachricht----- Von: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] Im Auftrag von Steven Carr Gesendet: Mittwoch, 4. Februar 2009 16:04 An: User questions and discussions about OTRS. Betreff: Re: [otrs] OTRS Manager App James, Michael wrote:

I have the Host, Port, User, Password, however I still cannot connect. We are running OTRS on Linux, did you have any issues connecting with port 3306?

You will need to ensure that your MySQL database can be accessed from other IP addresses, and that the OTRS user to connect to the database with has the ability to logon from any host. Steve -- Steven Carr Senior Network Security Engineer - Khipu Networks Ltd. support@khipu-networks.com - www.khipu-networks.com Secure - Compliant - Infrastructure Registered Office: Fairfax House, 15 Fulwood Place, London WC1V 6AY Registered in England. Company Number 5218573

Thanks Steve, i'll take a look. -----Ursprüngliche Nachricht----- Von: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] Im Auftrag von Steven Carr Gesendet: Mittwoch, 4. Februar 2009 16:20 An: User questions and discussions about OTRS. Betreff: Re: [otrs] OTRS Manager App James, Michael wrote:

Thanks for the info. I guess you know the question i have now, how and where can I configure that?

MySQL: check the my.cnf file to see if "skip-networking" is not hashed out, if it is there hash it out and restart MySQL. OTRS user: you will need to delve into the MySQL server itself and either reconfigure the existing user, or create a new one that has access to the OTRS database. http://dev.mysql.com/doc/ Steve -- Steven Carr Senior Network Security Engineer - Khipu Networks Ltd. support@khipu-networks.com - www.khipu-networks.com Secure - Compliant - Infrastructure Registered Office: Fairfax House, 15 Fulwood Place, London WC1V 6AY Registered in England. Company Number 5218573

Hi, Many thanks for the advice from everyone. After granting the privileges, hashing out "skip-networking" and restarting mysql it all worked fine. Regards Mike ________________________________ Von: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] Im Auftrag von Leonardo Certuche Gesendet: Mittwoch, 4. Februar 2009 20:59 An: User questions and discussions about OTRS. Betreff: Re: [otrs] OTRS Manager App I ran the following command on the mysql console to make it work having OTRS-Manager installed in a machine with IP A.B.C.D: GRANT ALL PRIVILEGES ON otrs.* TO some_user@A.B.C.D mailto:otrs@201.232.18.15 identified by 'some_password'; On Wed, Feb 4, 2009 at 10:21 AM, James, Michael wrote: Thanks Steve, i'll take a look. -----Ursprüngliche Nachricht----- Von: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] Im Auftrag von Steven Carr Gesendet: Mittwoch, 4. Februar 2009 16:20 An: User questions and discussions about OTRS. Betreff: Re: [otrs] OTRS Manager App James, Michael wrote:

Thanks for the info. I guess you know the question i have now, how and where can I configure that?

MySQL: check the my.cnf file to see if "skip-networking" is not hashed out, if it is there hash it out and restart MySQL. OTRS user: you will need to delve into the MySQL server itself and either reconfigure the existing user, or create a new one that has access to the OTRS database. http://dev.mysql.com/doc/ Steve -- Steven Carr Senior Network Security Engineer - Khipu Networks Ltd. support@khipu-networks.com - www.khipu-networks.com Secure - Compliant - Infrastructure Registered Office: Fairfax House, 15 Fulwood Place, London WC1V 6AY Registered in England. Company Number 5218573 _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs -- Leonardo Certuche 301 284 6250 leonardo.certuche@itcon-ltda.com www.itcon-ltda.com Medellín, Colombia