[Koha] Unable to login

Peter Lorimer peter at oslo.ie
Fri Apr 22 03:08:59 NZST 2011


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 at lists.katipo.co.nz
Reply-to: koha at lists.katipo.co.nz
To: koha at 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 at 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 at lists.katipo.co.nz

You can reach the person managing the list at
	koha-owner at 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 at 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 at maxenna.com
Subject: Re: [Koha] Unable to login
To: "Doug Dearden" <dearden at sarsf.org>
Cc: "koha at lists.katipo.co.nz" <koha at lists.katipo.co.nz>
Message-ID:
	<143376377656b911186361cae2c9a9b0.squirrel at 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 at 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 at 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 at 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

> Ajesh,
> This looks like a DNS issue to me.  Can you ping mykoha.org?  If not
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 at lists.katipo.co.nz
> [mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of ajesh at maxenna.com
Sent: Wednesday, April 20, 2011 2:25 AM
> To: koha at 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 at 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 at enger.priv.no>
Subject: Re: [Koha] Unable to login
To: "koha at lists.katipo.co.nz" <koha at lists.katipo.co.nz>
Message-ID: <BANLkTim6-qeSc5D==GZtviynvZPdsn9jQg at mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1

On 21 April 2011 06:50,  <ajesh at 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 at 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 at thepipingcentre.co.uk>
Subject: [Koha] Records not being found
To: <koha at 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

 





-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20110421/ee0047db/attachment-0001.htm 

------------------------------

Message: 4
Date: Thu, 21 Apr 2011 08:22:00 -0400
From: "Church, Beverly" <bchurch at liblime.com>
Subject: Re: [Koha] SQL statement for generating current checkouts
To: "nabonita at jncasr.ac.in" <nabonita at jncasr.ac.in>
Cc: "koha at lists.katipo.co.nz" <koha at lists.katipo.co.nz>
Message-ID: <BANLkTimpgZWNzfcUXaweBHd6o8skRKinyA at mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

Hi Nabonita,

Try this query. It looks for any items that are current checked out where
the checkout date was on or before 2011-03-29, or the last renewal date was
or before 2011-03-29.

SELECT issues.issuedate, items.barcode, biblio.title,
borrowers.firstname,borrowers.surname, borrowers.cardnumber,
borrowers.categorycode FROM issues LEFT JOIN borrowers ON
borrowers.borrowernumber = issues.borrowernumber LEFT JOIN items ON
issues.itemnumber = items.itemnumber LEFT JOIN biblio ON
items.biblionumber=biblio.biblionumber WHERE issues.issuedate <= '2011-03-29'
or issues.lastreneweddate <= '2011-03-29'


Bev


* * * *
Beverly Church
LibLime Project Manager

phone: 1-888-564-2457 ext. 717
            1-301-654-8088 ext. 292
email: bchurch at liblime.com
skype: beverlychurch


On Thu, Apr 21, 2011 at 12:35 AM, nabonita at jncasr.ac.in <
nabonita at jncasr.ac.in> wrote:

> Thanks Beverly for send me the SQL query. But this is retrieving only those
> titles which are issued on the given date. Where as I need to know that the
> titles which were on loan AS OF 2011-03-29. This may contain overdue books,
> and books which were issued/renewed on or before the given date. I'm not
> sure if this sort of result can be generated in Koha.
>
>
> Regards
>
> Nabonita
>
> --
> Nabonita Guha
> Library-cum-Information Officer
> Library, Jawaharlal Nehru Centre
> for Advanced Scientific Research,
> Jakkur Post, Bangalore 560064
> Karnataka, India
> Phone: +91-80-22082930
> Email: nabonita at jncasr.ac.in
> Web: http://lib.jncasr.ac.in
>
>
>
> At Wednesday, 20-04-2011 on 5:46 pm Church, Beverly wrote:
>
> Nabonita,
>
> You can use this query if you want to see the title:
>
> SELECT issues.issuedate, items.barcode, biblio.title,
> borrowers.firstname,borrowers.surname, borrowers.cardnumber,
> borrowers.categorycode FROM issues LEFT JOIN borrowers ON
> borrowers.borrowernumber = issues.borrowernumber LEFT JOIN items ON
> issues.itemnumber = items.itemnumber LEFT JOIN biblio ON
> items.biblionumber=biblio.biblionumber WHERE issues.issuedate = 'yyyy-mm-dd'
>
> If you don't need the title, use this query:
>
> SELECT issues.issuedate, items.barcode, borrowers.firstname,
> borrowers.surname, borrowers.cardnumber, borrowers.categorycode FROM issues
> LEFT JOIN borrowers ON borrowers.borrowernumber = issues.borrowernumber LEFT
> JOIN items ON issues.itemnumber = items.itemnumber WHERE issues.issuedate =
> 'yyyy-mm-dd'
>
>
>
> * * * *
> Beverly Church
> LibLime Project Manager
>
> phone: 1-888-564-2457 ext. 717
>             1-301-654-8088 ext. 292
> email: bchurch at liblime.com
> skype: beverlychurch
>
>
> 2011/4/20 nabonita Guha <nabonita at jncasr.ac.in>
>
>> Dear Koha users/Developers,
>>
>> Can you please help me in building SQL statement to generate current
>> checkouts on a given date (not for a date range). For example, I need to
>> generate a report to get list of (barcodes with borrowers card number,
>> surname and firstname and borrower's category with date of issue) were on
>> Loan as on 2011-03-29.
>>
>> Looking forward to hearing from you.
>>
>> With best regards
>>
>> Nabonita
>>
>> --
>> Nabonita Guha
>> Library-cum-Information Officer
>> Library, Jawaharlal Nehru Centre
>> for Advanced Scientific Research,
>> Jakkur Post, Bangalore 560064
>> Karnataka, India
>> Phone: +91-80-22082930
>> Email: nabonita at jncasr.ac.in
>> Web: http://lib.jncasr.ac.in
>>
>> _______________________________________________
>> Koha mailing list  http://koha-community.org
>> Koha at lists.katipo.co.nz
>> http://lists.katipo.co.nz/mailman/listinfo/koha
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20110421/f9d3eb9e/attachment.htm 

------------------------------

_______________________________________________
Koha mailing list
Koha at lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha


End of Koha Digest, Vol 66, Issue 52
************************************



More information about the Koha mailing list