<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Glen wrote:
<blockquote cite="midloom.20070518T145743-179@post.gmane.org"
type="cite">
<pre wrap="">Kevin O'Rourke <a class="moz-txt-link-rfc2396E" href="mailto:lists@..."><lists@...></a> writes:
</pre>
<blockquote type="cite">
<pre wrap="">Was that a fresh install of Koha, a fresh install of MySQL, or both?
</pre>
</blockquote>
<pre wrap=""><!---->
It was a completely fresh install of Koha and all its pre-requisites on Windows
XP SP2; followed the directions in the Koha for Windows install guide.
Everything seemed to install OK with the end result being that I could access
both the OPAC and the Intranet but on the Intranet I have to re-authenticate
every time I try to access a new screen. Also after entering a patron and
assigning them a username/password with superlibrarian privileges I'm unable to
to login with those credentials to the Intranet. From your initial description
it sounds like the same/similar problem. Just don't know how to try and fix it?
Any thoughts/ideas would be appreciated.
</pre>
</blockquote>
Try using the MySQL command line client (open a command prompt, change
to the MySQL bin directory [probably "C:\Program Files\MySQL\MySQL
Server 5.0\bin\"])":<br>
<blockquote>
<pre>mysql -u <Koha admin user> -p</pre>
</blockquote>
Enter your Koha admin password. Then type:<br>
<blockquote>
<pre>\u <Koha database name></pre>
<pre>describe sessions;</pre>
</blockquote>
<br>
You should see something like:<br>
<blockquote>
<pre>+-----------+--------------+------+-----+---------+-------+</pre>
<pre>| Field | Type | Null | Key | Default | Extra |</pre>
<pre>+-----------+--------------+------+-----+---------+-------+</pre>
<pre>| sessionID | varchar(255) | | PRI | | |</pre>
<pre>| userid | varchar(255) | YES | | NULL | |</pre>
<pre>| ip | varchar(16) | YES | | NULL | |</pre>
<pre>| lasttime | int(11) | YES | | NULL | |</pre>
<pre>+-----------+--------------+------+-----+---------+-------+</pre>
<pre>4 rows in set (0.00 sec)</pre>
</blockquote>
<br>
The important thing is that the numbers after each field type are the
same as shown here. My problem was caused by the MySQL upgrade
changing the IP field to length 5, too short for an IP address so the
session information couldn't be stored and I had to keep logging in.<br>
<br>
It sounds like your problem isn't quite the same as mine, more that
your Koha install went wrong at some point. Maybe someone with
experience of Koha on Windows can help?<br>
<br>
Kevin<br>
<br>
<pre class="moz-signature" cols="72">--
Kevin O'Rourke
ICT Coordinator, National Teachers' Institute, Kaduna, Nigeria
062 316972</pre>
</body>
</html>