Ajesh, This looks like a DNS issue to me. Can you ping mykoha.org? If not
Hi Ajesh This is a mysql problem. Your mysql root password is incorrect or not set. If you don't know what it is then do the following from a console: (I'm assuming here mysql is in its default place /var/lib/mysql) $ sudo /etc/init.d/mysql stop # then just to be safe $ sudo kill `cat /var/lib/mysql/*.pid` Now create a text file called /root/mysql_credentials.txt We now modify it, in this example the password is reset to 'mysecret' This file should contain only the following lines UPDATE mysql.user SET Password=PASSWORD('mysecret') WHERE User='root'; FLUSH PRIVILEGES; Now start mysql in safe mode with the above file with the command below mysqld_safe --init-file=/root/mysql_credentials.txt & Your root password will now be re-set - you should delete the /root/mysql_credentials.txt file and restart mysql with /etc/init.d/mysql restart Job done :-) -- Kind Regards Peter Lorimer Software Engineer OSLO (Open Source ILS Systems) -----Original Message----- From: koha-request@lists.katipo.co.nz Reply-to: koha@lists.katipo.co.nz To: koha@lists.katipo.co.nz Subject: Koha Digest, Vol 66, Issue 52 Date: Fri, 22 Apr 2011 00:22:40 +1200 Send Koha mailing list submissions to koha@lists.katipo.co.nz To subscribe or unsubscribe via the World Wide Web, visit http://lists.katipo.co.nz/mailman/listinfo/koha or, via email, send a message with subject or body 'help' to koha-request@lists.katipo.co.nz You can reach the person managing the list at koha-owner@lists.katipo.co.nz When replying, please edit your Subject line so it is more specific than "Re: Contents of Koha digest..." Today's Topics: 1. Re: Unable to login (ajesh@maxenna.com) 2. Re: Unable to login (Magnus Enger) 3. Records not being found (James Beaton) 4. Re: SQL statement for generating current checkouts (Church, Beverly) ---------------------------------------------------------------------- Message: 1 Date: Thu, 21 Apr 2011 10:20:43 +0530 From: ajesh@maxenna.com Subject: Re: [Koha] Unable to login To: "Doug Dearden" <dearden@sarsf.org> Cc: "koha@lists.katipo.co.nz" <koha@lists.katipo.co.nz> Message-ID: <143376377656b911186361cae2c9a9b0.squirrel@www.maxenna.com> Content-Type: text/plain;charset=iso-8859-1 Hi, Thanks for the advice. I have dropped the idea of using koha2.2.9 on windows. I am currently trying to install koha3.2.6(which I got on unzipping koha-latest.tar.gz - a few days back). I am installing it on Ubuntu OS and hence following the installation steps mentioned at http://wiki.koha-community.org/wiki/Koha_on_Ubuntu But I am facing issue at the below mySql step 7 ************************************************************************* maxenna@maxenna-rfid:~$ mysqladmin -uroot -ppassword create kohadata mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: YES)' maxenna@maxenna-rfid:~$ mysql -uroot -ppassword ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) ************************************************************************* Searched on web and saw that quite many people has this error, but I could not find a solution for the same. I also tried to give root privileges using "sudo -i", but still getting the same error. *********************************************************************** root@maxenna-rfid:~# mysql -uroot -ppassword ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) *********************************************************************** Could somebody suggest a way to get past this error. Regards Ajesh then
you probably don't have this name pointing to the IP address of the server. However, I would encourage you to abandon the idea of using Koha 2.2.9 on Windows, and install the latest stable release on Linux (or wait a few days and install version 3.4 when it is released). I don't believe the 2.2.x branch is being updated in any way. To keep up with bug fixes and enhancements, you really want to be on the version the Koha community is contributing to. If this is a test box you are setting up then you could download the latest stable release now - version 3.2.7 available at http://download.koha-community.org/ , then update to the 3.4 release later after you are comfortable with Koha on Linux. Best, Doug -----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of ajesh@maxenna.com Sent: Wednesday, April 20, 2011 2:25 AM To: koha@lists.katipo.co.nz Subject: [Koha] Unable to login Hi, I have installed Koha 2.2.9 on Windows XP. Now, I am trying to login to Koha as admin using the below link http://www.mykoha.org:8080 or http://www.mykoha.org:8080/cgi-bin/koha/mainpage.pl But I am getting the below error message: ************************************************************************* The connection has timed out The server at www.mykoha.org is taking too long to respond. The site could be temporarily unavailable or too busy. Try again in a few moments. If you are unable to load any pages, check your computer's network connection. If your computer or network is protected by a firewall or proxy, make sure that Firefox is permitted to access the Web. ************************************************************************* Firewall is not turned on and the computer's network connection is ok. However I see that I am able to login successfully as a user at http://localhost or http://localhost/cgi-bin/koha/opac-user.pl Please let me know how to solve this issue. OS: Windows XP Mozilla ActivePerl 5.8.9 Build 829 Apache 2.0.64 MySql Server 5.1 Thanks & Regards Ajesh _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
------------------------------ Message: 2 Date: Thu, 21 Apr 2011 12:24:19 +0200 From: Magnus Enger <magnus@enger.priv.no> Subject: Re: [Koha] Unable to login To: "koha@lists.katipo.co.nz" <koha@lists.katipo.co.nz> Message-ID: <BANLkTim6-qeSc5D==GZtviynvZPdsn9jQg@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 On 21 April 2011 06:50, <ajesh@maxenna.com> wrote:
I am installing it on Ubuntu OS and hence following the installation steps mentioned at ? ?http://wiki.koha-community.org/wiki/Koha_on_Ubuntu
You will find the official guides to installing on Ubuntu in the source code or here: http://git.koha-community.org/gitweb/?p=koha.git;a=tree Look for the files called INSTALL.ubuntu and INSTALL.ubuntu.lucid See the top of this page: http://wiki.koha-community.org/wiki/Category:Installation for an explanation of why it is a good idea to stick with the official INSTALL.* files.
But I am facing issue at the below mySql step 7
************************************************************************* maxenna@maxenna-rfid:~$ mysqladmin -uroot -ppassword create kohadata
You need to replace password with the actual password for the root mysql user. So if the password is XYZ it would be: $ mysqladmin -uroot -pXYZ create kohadata Even better is to just use $ mysqladmin -uroot -p create kohadata This will prompt you for the password interactively, and it will not be left visible in the history of your shellcommands. Best regards, Magnus Enger libriotech.no ------------------------------ Message: 3 Date: Thu, 21 Apr 2011 13:18:16 +0100 From: "James Beaton" <jbeaton@thepipingcentre.co.uk> Subject: [Koha] Records not being found To: <koha@lists.katipo.co.nz> Message-ID: <!&!AAAAAAAAAAAuAAAAAAAAAJXYs5J7gxZCvxccbse+fbsBAEaxvCxak/9DuV1A6jZbbe0AN0hC4AYAABAAAAB86vRKG2xlSI2bTr7hyD3oAQAAAAA=@thepipingcentre.co.uk> Content-Type: text/plain; charset="us-ascii" Good Afternoon I suspect that the question I am posing relates to an indexing function within Koha. We have recently installed the programme, and I have created and saved a number of records which I cannot then retrieve via the catalogue search. They also do not appear in the reservoir. I will be discussing this with the systems person here (who performed the installation), but having looked at threads on this list, it seems that the most likely cause of this is that there is an issue with zebra. Is this the case, so that I don't send this guy off on a wild goose chase? Thanks James Beaton The Library The National Piping Centre 30-34 McPhater Street Glasgow G4 0HW t. +44 (0) 141 353 0220 f. +44 (0) 141 353 1570 www.thepipingcentre.co.uk www.pipingfestival.co.uk The National Piping Centre Ltd. Registered in Scotland no. 139271, Charity no. 020391 The Piping Centre Trading Ltd. Registered in Scotland no. 162342 Glasgow International Piping Festival. Registered in Scotland no. 256248, Charity no. 34875