[Koha] MySQL problem

[Michael Sauers]

Ricardo, thanks for your assistance as this makes perfect sense.
However, my frustration level has just gone through the roof and I think
I need the weekend to relax before coming back to this project. Here's
why:

I'm following the instructions in the document you're referring to
(INSTALL.debian) as I've just installed the current Debian release on
the respective computer. (The plan is to install Koha 3.) I'm at step
1.2, Set up your locale, which says that I "_MUST_" follow all the steps
outlined there [http://wiki.koha.org/doku.php?id=encodingscratchpad]...
BEFORE you install Koha." Ok, that's what I'm trying to do. Those
instructions then tell me to log into MySQL using an account that
INSTALL.debian doesn't tell me to create until step 2.2!

So, basically the instructions are telling me to do something based on
the results of something I haven't been told to do yet. I'll admit I'm a
n00b to this but I do consider myself ready, willing and able to follow
most technical instructions. Having those instructions in the correct
order generally helps.

Josh, I see you're the author of INSTALL.debian. Might this be something
that can be correct for future users?

---------------------------------------------------------------
Michael Sauers, Technology Innovation Librarian
Nebraska Library Commission
The Atrium, 1200 N Street, Suite 120
Lincoln, NE 68508-2023
402-471-2045
800-307-2665 (NE only) 
Fax: 402-471-2083
msauers at nlc.state.ne.us
http://nlc.state.ne.us/
http://www.travelinlibrarian.info/
---------------------------------------------------------------


-----Original Message-----
From: newsgroup.posts at gmail.com [mailto:newsgroup.posts at gmail.com] On
Behalf Of Ricardo Dias Marques
Sent: Friday, June 20, 2008 8:04 AM
To: Michael Sauers
Cc: mlb at imparisystems.com; koha at lists.katipo.co.nz
Subject: Re: [Koha] MySQL problem

Hi Michael,

On Fri, Jun 20, 2008 at 1:08 PM, Michael Sauers
<msauers at nlc.state.ne.us> wrote:

> Ok, next question. I recall creating a root password for MySQL after
> installing it but these instructions say to not log in as root. So, as
far
> as I know I've not yet created any MySQL users/passwords. I'm assuming
I
> need to do this first...?
>
> Sorry for the noob questions but this is a giant experiment to see how
easy
> (or not) this is for someone of extensive Windows experience and
> beginner-level Linux experience (i.e. Me) so we can tell our
librarians
> across the state how "easy" it is to install.

Given that you mention "beginner-level Linux experience", I'm assuming
that you're trying to install Koha in a Linux distribution. What
version of Koha are you trying to install? What Linux distribution are
you using?

Your assumption is correct: you should create a non-root MySQL user
for Koha. The way of doing that is described, for example, in the
INSTALL.debian file of the Koha distribution, that is also available
online (for the current Koha 3 snapshot version) at:

http://git.koha.org/cgi-bin/gitweb.cgi?p=Koha;a=blob;f=INSTALL.debian


The relevant section of that INSTALL.debian file, for this problem, is
section "2.2 Create the Koha database":

____________________

2.2 Create the Koha database

Create the database and user with associated privileges:

$ mysqladmin -uroot -p<password> create <kohadatabasename>

$ mysql -uroot -p<password>

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 22

Server version: 5.0.32-Debian_7etch3-log Debian etch distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> grant all on <kohadatabasename>.* to
'<kohadatabaseuser>'@'localhost' identified by
'<kohadatabaseuserpassword>';
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> quit
____________________


You should replace <kohadatabasename> above by the name of your koha
database (usually "koha", without the quotes), <kohadataseuser> by the
name of the MySQL user that you want to create (usually "kohaadmin",
also without the quotes) and <kohadatabaseuserpassword> by the
password that you want to assign to that user. The "grant all" command
above creates the specified MySQL user.

I hope this helps you.


Best wishes,
Ricardo Dias Marques
lists AT ricmarques DOT net