
Hi All , has anyone used OTRS-Manager http://otrs-manager.sourceforge.net/index.php?page=homepage_en ?? Trying to update my otrs db settings but it does not save the settings? Any help would be appreciated.

Didn't knew this software, but seems to be interresting. I'll probably test it soon. But I don't think you'll find any help here. Maybe on OTRS-Manager web site. Just a quick idea: Edit file /etc/mysql/my.cnf and comment the line : #bind-address = 127.0.0.1 Restart mysql : # /etc/nit.d/mysql stop # /etc/nit.d/mysql start Allow external connections : # mysql -p mysql> use mysql ; mysql> GRANT ALL PRIVILEGES ON *.* TO 'user'@'hostname' IDENTIFIED BY 'password' WITH GRANT OPTION; Replacing 'hostname' with '%', you allow the user to connect from every host. Reference : http://dev.mysql.com/doc/refman/5.0/en/adding-users.html Regards, Regis -----Message d'origine----- De : otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] De la part de djtzar Envoyé : mardi 27 mai 2008 17:44 À : otrs@otrs.org Objet : [otrs] OTRS-Manager Hi All , has anyone used OTRS-Manager http://otrs-manager.sourceforge.net/index.php?page=homepage_en ?? Trying to update my otrs db settings but it does not save the settings? Any help would be appreciated. _______________________________________________ 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 Support or consulting for your OTRS system? => http://www.otrs.com/

I've just tested OTRS-Manager. Mysql DB connection is OK with correct rights. Regis -----Message d'origine----- De : otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] De la part de Régis OBERLE Envoyé : mardi 27 mai 2008 17:57 À : User questions and discussions about OTRS.org Objet : Re: [otrs] OTRS-Manager Didn't knew this software, but seems to be interresting. I'll probably test it soon. But I don't think you'll find any help here. Maybe on OTRS-Manager web site. Just a quick idea: Edit file /etc/mysql/my.cnf and comment the line : #bind-address =27.0.0.1 Restart mysql : # /etc/nit.d/mysql stop # /etc/nit.d/mysql start Allow external connections : # mysql -p mysql> use mysql ; mysql> GRANT ALL PRIVILEGES ON *.* TO 'user'@'hostname' IDENTIFIED BY mysql> 'password' WITH GRANT OPTION; Replacing 'hostname' with '%', you allow the user to connect from every host. Reference : http://dev.mysql.com/doc/refman/5.0/en/adding-users.html Regards, Regis -----Message d'origine----- De : otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] De la part de djtzar Envoyé : mardi 27 mai 2008 17:44 À : otrs@otrs.org Objet : [otrs] OTRS-Manager Hi All , has anyone used OTRS-Manager http://otrs-manager.sourceforge.net/index.php?page=mepage_en ?? Trying to update my otrs db settings but it does not save the settings? Any help would be appreciated. _______________________________________________ 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 Support or consulting for your OTRS system? =http://www.otrs.com/ _______________________________________________ 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 Support or consulting for your OTRS system? =http://www.otrs.com/

thx for the feedback but it seems this application only pertains to
the Windows ver of OTRS , I run on Fedora so no joy for me :(
On Tue, May 27, 2008 at 6:02 PM, Régis OBERLE
I've just tested OTRS-Manager. Mysql DB connection is OK with correct rights.
Regis
-----Message d'origine----- De : otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] De la part de Régis OBERLE Envoyé : mardi 27 mai 2008 17:57 À : User questions and discussions about OTRS.org Objet : Re: [otrs] OTRS-Manager
Didn't knew this software, but seems to be interresting. I'll probably test it soon. But I don't think you'll find any help here. Maybe on OTRS-Manager web site.
Just a quick idea:
Edit file /etc/mysql/my.cnf and comment the line :
#bind-address '.0.0.1
Restart mysql :
# /etc/nit.d/mysql stop # /etc/nit.d/mysql start
Allow external connections :
# mysql -p mysql> use mysql ; mysql> GRANT ALL PRIVILEGES ON *.* TO 'user'@'hostname' IDENTIFIED BY mysql> 'password' WITH GRANT OPTION;
Replacing 'hostname' with '%', you allow the user to connect from every host.
Reference : http://dev.mysql.com/doc/refman/5.0/en/adding-users.html
Regards, Regis
-----Message d'origine----- De : otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] De la part de djtzar Envoyé : mardi 27 mai 2008 17:44 À : otrs@otrs.org Objet : [otrs] OTRS-Manager
Hi All , has anyone used OTRS-Manager http://otrs-manager.sourceforge.net/index.php?pagemepage_en ??
Trying to update my otrs db settings but it does not save the settings?
Any help would be appreciated. _______________________________________________ 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 Support or consulting for your OTRS system? http://www.otrs.com/ _______________________________________________ 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 Support or consulting for your OTRS system? http://www.otrs.com/ _______________________________________________ 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 Support or consulting for your OTRS system?

Wrong, I'm running OTRS on debian and it works fine.
Try to modify the privileges on your MySQL database and it'll work.
Regis
-----Message d'origine-----
De : otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] De la part de djtzar
Envoyé : mercredi 28 mai 2008 09:56
À : User questions and discussions about OTRS.org
Objet : Re: [otrs] OTRS-Manager
thx for the feedback but it seems this application only pertains to the Windows ver of OTRS , I run on Fedora so no joy for me :(
On Tue, May 27, 2008 at 6:02 PM, Régis OBERLE
I've just tested OTRS-Manager. Mysql DB connection is OK with correct rights.
Regis
-----Message d'origine----- De : otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] De la part de Régis OBERLE Envoyé : mardi 27 mai 2008 17:57 À : User questions and discussions about OTRS.org Objet : Re: [otrs] OTRS-Manager
Didn't knew this software, but seems to be interresting. I'll probably test it soon. But I don't think you'll find any help here. Maybe on OTRS-Manager web site.
Just a quick idea:
Edit file /etc/mysql/my.cnf and comment the line :
#bind-address '.0.0.1
Restart mysql :
# /etc/nit.d/mysql stop # /etc/nit.d/mysql start
Allow external connections :
# mysql -p mysql> use mysql ; mysql> GRANT ALL PRIVILEGES ON *.* TO 'user'@'hostname' IDENTIFIED BY mysql> 'password' WITH GRANT OPTION;
Replacing 'hostname' with '%', you allow the user to connect from every host.
Reference : http://dev.mysql.com/doc/refman/5.0/en/adding-users.html
Regards, Regis
-----Message d'origine----- De : otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] De la part de djtzar Envoyé : mardi 27 mai 2008 17:44 À : otrs@otrs.org Objet : [otrs] OTRS-Manager
Hi All , has anyone used OTRS-Manager http://otrs-manager.sourceforge.net/index.php?pagemepage_en ??
Trying to update my otrs db settings but it does not save the settings?
Any help would be appreciated. _______________________________________________ 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 Support or consulting for your OTRS system? http://www.otrs.com/ _______________________________________________ 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 Support or consulting for your OTRS system? http://www.otrs.com/ _______________________________________________ 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 Support or consulting for your OTRS system?
-- http://tinyurl.com/2j6lzt _______________________________________________ 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 Support or consulting for your OTRS system? =http://www.otrs.com/

Régis OBERLE wrote:
Wrong, I'm running OTRS on debian and it works fine. Try to modify the privileges on your MySQL database and it'll work.
Regis
-----Message d'origine----- De : otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] De la part de djtzar Envoyé : mercredi 28 mai 2008 09:56 À : User questions and discussions about OTRS.org Objet : Re: [otrs] OTRS-Manager
thx for the feedback but it seems this application only pertains to the Windows ver of OTRS , I run on Fedora so no joy for me :(
On Tue, May 27, 2008 at 6:02 PM, Régis OBERLE
wrote: I've just tested OTRS-Manager. Mysql DB connection is OK with correct rights.
Regis
-----Message d'origine----- De : otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] De la part de Régis OBERLE Envoyé : mardi 27 mai 2008 17:57 À : User questions and discussions about OTRS.org Objet : Re: [otrs] OTRS-Manager
Didn't knew this software, but seems to be interresting. I'll probably test it soon. But I don't think you'll find any help here. Maybe on OTRS-Manager web site.
Just a quick idea:
Edit file /etc/mysql/my.cnf and comment the line :
#bind-address '.0.0.1
Restart mysql :
# /etc/nit.d/mysql stop # /etc/nit.d/mysql start
Allow external connections :
# mysql -p mysql> use mysql ; mysql> GRANT ALL PRIVILEGES ON *.* TO 'user'@'hostname' IDENTIFIED BY mysql> 'password' WITH GRANT OPTION;
Replacing 'hostname' with '%', you allow the user to connect from every host.
Reference : http://dev.mysql.com/doc/refman/5.0/en/adding-users.html
Regards, Regis
-----Message d'origine----- De : otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] De la part de djtzar Envoyé : mardi 27 mai 2008 17:44 À : otrs@otrs.org Objet : [otrs] OTRS-Manager
Hi All , has anyone used OTRS-Manager http://otrs-manager.sourceforge.net/index.php?pagemepage_en ??
Trying to update my otrs db settings but it does not save the settings?
Any help would be appreciated. _______________________________________________ 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 Support or consulting for your OTRS system? http://www.otrs.com/ _______________________________________________ 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 Support or consulting for your OTRS system? http://www.otrs.com/ _______________________________________________ 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 Support or consulting for your OTRS system?
-- http://tinyurl.com/2j6lzt _______________________________________________ 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 Support or consulting for your OTRS system? =tp://www.otrs.com/ _______________________________________________ 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 Support or consulting for your OTRS system? =http://www.otrs.com/
I've tried to use OTRS-Manager with otrs 2.2.X on Ubuntu & PosgreSQL and unfortunately I also can't established connect to DB :( -- MoiKrug - ??????? ???? http://bg8s.moikrug.ru/?from=userlink??????? ???? http://bg8s.moikrug.ru/?from=userlink

Ok I ran the below mysql statement for the user 'root' , the
application seems to be doing something then just hangs for a while
and throws out error msg. Can it be that it doesn't like blank
passwords? (yes I know blank root pass not good but luckily this
system is not live :P )
Any other ideas? P.S I can connect to the database with MySQLFront
with 'space' as the blank password , tried that with OTRS-Manager but
no joy.
Any other suggestions?
On Wed, May 28, 2008 at 10:09 AM, Régis OBERLE
Wrong, I'm running OTRS on debian and it works fine. Try to modify the privileges on your MySQL database and it'll work.
Regis
-----Message d'origine----- De : otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] De la part de djtzar Envoyé : mercredi 28 mai 2008 09:56 À : User questions and discussions about OTRS.org Objet : Re: [otrs] OTRS-Manager
thx for the feedback but it seems this application only pertains to the Windows ver of OTRS , I run on Fedora so no joy for me :(
On Tue, May 27, 2008 at 6:02 PM, Régis OBERLE
wrote: I've just tested OTRS-Manager. Mysql DB connection is OK with correct rights.
Regis
-----Message d'origine----- De : otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] De la part de Régis OBERLE Envoyé : mardi 27 mai 2008 17:57 À : User questions and discussions about OTRS.org Objet : Re: [otrs] OTRS-Manager
Didn't knew this software, but seems to be interresting. I'll probably test it soon. But I don't think you'll find any help here. Maybe on OTRS-Manager web site.
Just a quick idea:
Edit file /etc/mysql/my.cnf and comment the line :
#bind-address '.0.0.1
Restart mysql :
# /etc/nit.d/mysql stop # /etc/nit.d/mysql start
Allow external connections :
# mysql -p mysql> use mysql ; mysql> GRANT ALL PRIVILEGES ON *.* TO 'user'@'hostname' IDENTIFIED BY mysql> 'password' WITH GRANT OPTION;
Replacing 'hostname' with '%', you allow the user to connect from every host.
Reference : http://dev.mysql.com/doc/refman/5.0/en/adding-users.html
Regards, Regis
-----Message d'origine----- De : otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] De la part de djtzar Envoyé : mardi 27 mai 2008 17:44 À : otrs@otrs.org Objet : [otrs] OTRS-Manager
Hi All , has anyone used OTRS-Manager http://otrs-manager.sourceforge.net/index.php?pagemepage_en ??
Trying to update my otrs db settings but it does not save the settings?
Any help would be appreciated. _______________________________________________ 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 Support or consulting for your OTRS system? http://www.otrs.com/ _______________________________________________ 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 Support or consulting for your OTRS system? http://www.otrs.com/ _______________________________________________ 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 Support or consulting for your OTRS system?
-- http://tinyurl.com/2j6lzt _______________________________________________ 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 Support or consulting for your OTRS system? http://www.otrs.com/ _______________________________________________ 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 Support or consulting for your OTRS system?

I have an OTRS sandbox system on my laptop with blank root password too: anyway, OTRS-Manager works fine here. I know may sound obvious, but to those who can't connect their OTRS servers to OTRS Manager, I suggest to check if MySQL communication port (usually TCP 3306) is open on the server. Sometimes iptables doesn't contain an appropriate rule so the incoming packets are rejected. Daniele. -----Messaggio originale----- Da: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] Per conto di djtzar Inviato: mercoledì 28 maggio 2008 11.42 A: User questions and discussions about OTRS.org Oggetto: Re: [otrs] OTRS-Manager Ok I ran the below mysql statement for the user 'root' , the application seems to be doing something then just hangs for a while and throws out error msg. Can it be that it doesn't like blank passwords? (yes I know blank root pass not good but luckily this system is not live :P ) Any other ideas? P.S I can connect to the database with MySQLFront with 'space' as the blank password , tried that with OTRS-Manager but no joy. Any other suggestions?

That's just the thing , I can connect to my database through
MysqlFront on port 3306 , but for some reason through OTRS-Manager I
cannot. Where can I actually locate the config file for OTRS_Manager
or even a verbose error log file maybe to better understand what error
it is giving ?
On Wed, May 28, 2008 at 12:14 PM, CARNINO Daniele
I have an OTRS sandbox system on my laptop with blank root password too: anyway, OTRS-Manager works fine here.
I know may sound obvious, but to those who can't connect their OTRS servers to OTRS Manager, I suggest to check if MySQL communication port (usually TCP 3306) is open on the server. Sometimes iptables doesn't contain an appropriate rule so the incoming packets are rejected.
Daniele.
-----Messaggio originale----- Da: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] Per conto di djtzar Inviato: mercoledì 28 maggio 2008 11.42 A: User questions and discussions about OTRS.org Oggetto: Re: [otrs] OTRS-Manager
Ok I ran the below mysql statement for the user 'root' , the application seems to be doing something then just hangs for a while and throws out error msg. Can it be that it doesn't like blank passwords? (yes I know blank root pass not good but luckily this system is not live :P )
Any other ideas? P.S I can connect to the database with MySQLFront with 'space' as the blank password , tried that with OTRS-Manager but no joy.
Any other suggestions?
_______________________________________________ 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 Support or consulting for your OTRS system?

I may be barking up the wrong tree with this, but if the manager isn't running on the same machine as the mysql server, check that the mysql.ini/config files are set up to listen on other network addresses, and not just 127.0.0.1
________________________________
From: otrs-bounces@otrs.org on behalf of djtzar
Sent: Wed 28/05/2008 11:31
To: User questions and discussions about OTRS.org
Subject: Re: [otrs] OTRS-Manager
That's just the thing , I can connect to my database through
MysqlFront on port 3306 , but for some reason through OTRS-Manager I
cannot. Where can I actually locate the config file for OTRS_Manager
or even a verbose error log file maybe to better understand what error
it is giving ?
On Wed, May 28, 2008 at 12:14 PM, CARNINO Daniele
I have an OTRS sandbox system on my laptop with blank root password too: anyway, OTRS-Manager works fine here.
I know may sound obvious, but to those who can't connect their OTRS servers to OTRS Manager, I suggest to check if MySQL communication port (usually TCP 3306) is open on the server. Sometimes iptables doesn't contain an appropriate rule so the incoming packets are rejected.
Daniele.
-----Messaggio originale----- Da: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] Per conto di djtzar Inviato: mercoledì 28 maggio 2008 11.42 A: User questions and discussions about OTRS.org Oggetto: Re: [otrs] OTRS-Manager
Ok I ran the below mysql statement for the user 'root' , the application seems to be doing something then just hangs for a while and throws out error msg. Can it be that it doesn't like blank passwords? (yes I know blank root pass not good but luckily this system is not live :P )
Any other ideas? P.S I can connect to the database with MySQLFront with 'space' as the blank password , tried that with OTRS-Manager but no joy.
Any other suggestions?
_______________________________________________ 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 Support or consulting for your OTRS system?
-- http://tinyurl.com/2j6lzt _______________________________________________ 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 Support or consulting for your OTRS system? =http://www.otrs.com/
participants (5)
-
Ali, Mustaqil M
-
CARNINO Daniele
-
djtzar
-
Egor Tsilenko
-
Régis OBERLE