
Hello, I'm looking to directly connect to the OTRS database (with Aquadata Studio), so I can run some reports not in the system. Before I do that, I have to allow my host to connect to MySQL. Before I do that, I have to be able to login to the OTRS database (with MySQL Administrator) to set the permissions. So -- where do I find the username/password info? I've been looking at the OTRS 2.0 Administrator manual, but I haven't found where this is documented. Thanks, *************** * Adam Getchell, M.S. * Director of Information Technology * College of Agricultural & Environmental Sciences * acgetchell@ucdavis.edu (530)752-8008 *************** "Invincibility is in oneself, vulnerability in the opponent." -- Sun Tzu

You provided them on install, I think. The defaults are included in the
basic documentation as I recall (it's the ROOT account listed in the docs.)
On 3/13/07 18:03, "Getchell, Adam"
Hello,
I'm looking to directly connect to the OTRS database (with Aquadata Studio), so I can run some reports not in the system.
Before I do that, I have to allow my host to connect to MySQL.
Before I do that, I have to be able to login to the OTRS database (with MySQL Administrator) to set the permissions.
So -- where do I find the username/password info?
I've been looking at the OTRS 2.0 Administrator manual, but I haven't found where this is documented.
Thanks,
*************** * Adam Getchell, M.S. * Director of Information Technology * College of Agricultural & Environmental Sciences * acgetchell@ucdavis.edu (530)752-8008 *************** "Invincibility is in oneself, vulnerability in the opponent." -- Sun Tzu
----- Salvador Manzo [ 620 W. 35th St Los Angeles, CA 90089 e. manzo@usc.edu ] Auxiliary Services IT, Datacenter University of Southern California 818-612-5112 Discourage self-help, and loyal subjects become the slaves of ruffians. Over-stimulate self-assertion, and for the arbitrament of the Courts you substitute the decision of the sword or the revolver. - The Law of the Constitution, by A.V. Dicey (MacMillan, London 1885).

Just read the mysql documentation on user management and that should be all
you need. I wouldn't use the otrs account, rather create a select only user
for querying the database as it sounds like you don't have all that much
experience in this realm - it will keep you from doing anything rash to the
database other than causing performance issues stemming from bad queries.
http://www.google.com/search?q=mysql+user+management
HTH,
Andy Lubel
On 3/13/07 9:33 PM, "Salvador Manzo"
You provided them on install, I think. The defaults are included in the basic documentation as I recall (it's the ROOT account listed in the docs.)
On 3/13/07 18:03, "Getchell, Adam"
wrote: Hello,
I'm looking to directly connect to the OTRS database (with Aquadata Studio), so I can run some reports not in the system.
Before I do that, I have to allow my host to connect to MySQL.
Before I do that, I have to be able to login to the OTRS database (with MySQL Administrator) to set the permissions.
So -- where do I find the username/password info?
I've been looking at the OTRS 2.0 Administrator manual, but I haven't found where this is documented.
Thanks,
*************** * Adam Getchell, M.S. * Director of Information Technology * College of Agricultural & Environmental Sciences * acgetchell@ucdavis.edu (530)752-8008 *************** "Invincibility is in oneself, vulnerability in the opponent." -- Sun Tzu
----- Salvador Manzo [ 620 W. 35th St Los Angeles, CA 90089 e. manzo@usc.edu ] Auxiliary Services IT, Datacenter University of Southern California 818-612-5112 Discourage self-help, and loyal subjects become the slaves of ruffians. Over-stimulate self-assertion, and for the arbitrament of the Courts you substitute the decision of the sword or the revolver. - The Law of the Constitution, by A.V. Dicey (MacMillan, London 1885).
_______________________________________________ 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 orr consulting for your OTRS system? => http://www.otrs.com/
--

Adam Getchell het volgende geschreven:
I'm looking to directly connect to the OTRS database (with Aquadata Studio), so I can run some reports not in the system.
Before I do that, I have to allow my host to connect to MySQL.
Before I do that, I have to be able to login to the OTRS database (with MySQL Administrator) to set the permissions.
So -- where do I find the username/password info?
Take a look at $Self->{DatabaseUser} and $Self->{DatabasePw} in ~otrs/ Kernel/Config.pm. You could also probably use the MySQL root/admin account to change the permissions on your OTRS database. Nils Breunese.
participants (4)
-
Andy Lubel
-
Getchell, Adam
-
Nils Breunese (Lemonbit)
-
Salvador Manzo