[otrs] MySQL Admin Problems
Hi, I'm running OTRS 2.1.7, and I've been having a problem with Apache failing. So I want to upgrade to 2.2 hoping this might fix it. What this entails is backing up the MySQL database, uninstalling the current version of OTRS, and then reinstalling the new one, making sure to copy over my config files. Now, I'm not knowledgeable of MySQL at all, so I want to use a user-friendly application to work with the database in order to avoid errors. I downloaded and installed MySQL tools from the MySQL website, and the Administrator tool is picking up the MySQL database using the default OTRS Username and Password. The Administrator isn't connecting to the database correctly however, when I so into User Administration, I get the following error: 'A MySQL error was encountered. The message is: Could not fetch user names. The following error occurred: SELECT command denied to user 'otrs'@'localhost' for table 'user' (1142). As far as I can find out, this means that the proper user privileges have not been set for the database, but I don't know how to fix this, or how to adjust and save the correct config files. If someone could point me in the right direction, I'd really appreciate it. Thanks! Emily ___ 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/
Re: [otrs] MySQL Admin Problems
Hi, Your problem seems to be only related with bad/insufficient privileges accorded to your otrs user. phpMyAdmin is a web-based tool to easily manage MySQL servers, it could help on your case : http://www.phpmyadmin.net/ You will probably also need to read some documentations about MySQL Administration, you will find many howtos on Google, this one can be a beginning : http://www.linuxhomenetworking.com/wiki/index.php/Quick_HOWTO_:_Ch34_:_Basic_MySQL_Configuration Basic steps of the OTRS installation procedure can also be useful since it seems all is not properly configure on your current installation : http://doc.otrs.org/2.2/en/html/c267.html Best regards, Laurent MINOST Emily Flynn a écrit : Hi, I’m running OTRS 2.1.7, and I’ve been having a problem with Apache failing. So I want to upgrade to 2.2 hoping this might fix it. What this entails is backing up the MySQL database, uninstalling the current version of OTRS, and then reinstalling the new one, making sure to copy over my config files. Now, I’m not knowledgeable of MySQL at all, so I want to use a user-friendly application to work with the database in order to avoid errors. I downloaded and installed MySQL tools from the MySQL website, and the Administrator tool is picking up the MySQL database using the default OTRS Username and Password. The Administrator isn’t connecting to the database correctly however, when I so into User Administration, I get the following error: ‘A MySQL error was encountered. The message is: Could not fetch user names. The following error occurred: SELECT command denied to user [EMAIL PROTECTED] for table ‘user’ (1142). As far as I can find out, this means that the proper user privileges have not been set for the database, but I don’t know how to fix this, or how to adjust and save the correct config files. If someone could point me in the right direction, I’d really appreciate it. Thanks! Emily ___ 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/
RE: [otrs] MySQL Admin Problems
Thanks for your answer Laurent. It turns out I was logging into the database with the default MySQL 'user' as opposed to 'root'. So when I logged in as root admin, all was fine, I changed passwords, created a user, and I can go about managing the database. I'm actually running otrs on an XPSP2 machine, and I tried PHPMyAdmin already, but I had difficulties installing the PHP. During the installation of PHP, a list of available extensions are given and It's recommended to install only the necessary extensions as problems can arise if you install everything (I did try that - and problems did indeed arise..). I couldn't find out which were the correct extensions to install (this was my first encounter with PHP) and when someone suggested the desktop GUI MySQL Administrator, I thought I'd try that. I still would have like to get PHP installed, as it could be something I'd look into working with. If anyone knows what extensions I should install, I'd gladly take any advice! Thanks again -Emily -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Laurent Minost Sent: 06 November 2007 11:03 To: User questions and discussions about OTRS.org Subject: Re: [otrs] MySQL Admin Problems Hi, Your problem seems to be only related with bad/insufficient privileges accorded to your otrs user. phpMyAdmin is a web-based tool to easily manage MySQL servers, it could help on your case : http://www.phpmyadmin.net/ You will probably also need to read some documentations about MySQL Administration, you will find many howtos on Google, this one can be a beginning : http://www.linuxhomenetworking.com/wiki/index.php/Quick_HOWTO_:_Ch34_:_Basic _MySQL_Configuration Basic steps of the OTRS installation procedure can also be useful since it seems all is not properly configure on your current installation : http://doc.otrs.org/2.2/en/html/c267.html Best regards, Laurent MINOST Emily Flynn a écrit : Hi, Im running OTRS 2.1.7, and Ive been having a problem with Apache failing. So I want to upgrade to 2.2 hoping this might fix it. What this entails is backing up the MySQL database, uninstalling the current version of OTRS, and then reinstalling the new one, making sure to copy over my config files. Now, Im not knowledgeable of MySQL at all, so I want to use a user-friendly application to work with the database in order to avoid errors. I downloaded and installed MySQL tools from the MySQL website, and the Administrator tool is picking up the MySQL database using the default OTRS Username and Password. The Administrator isnt connecting to the database correctly however, when I so into User Administration, I get the following error: A MySQL error was encountered. The message is: Could not fetch user names. The following error occurred: SELECT command denied to user [EMAIL PROTECTED] for table user (1142). As far as I can find out, this means that the proper user privileges have not been set for the database, but I dont know how to fix this, or how to adjust and save the correct config files. If someone could point me in the right direction, Id really appreciate it. Thanks! Emily ___ 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/