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. --------------------------------------------------------------- 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@nlc.state.ne.us http://nlc.state.ne.us/ http://www.travelinlibrarian.info/ --------------------------------------------------------------- From: Matt Burkhardt [mailto:mlb@imparisystems.com] Sent: Thursday, June 19, 2008 4:44 PM To: Michael Sauers Subject: Re: [Koha] MySQL problem Hey Michael, It just means to run some commands within the mysql shell. There are several different ways to do this. Perhaps the easiest is to get to the command line - just open a terminal window (in Linux) or a DOS command window (in Windows) and type: mysql -u username -p and it should ask you for the mysql password associated with the username. Enter that, and it will say mysql> just enter that line show variables where variable_name LIKE "character_set%" OR variable_name LIKE "collation%"; and you'll get the list. On Thu, 2008-06-19 at 13:38 -0500, Michael Sauers wrote: Ok, next question RE: http://wiki.koha.org/doku.php?id=encodingscratchpad MySQL – Server Configuration – I’ve added the four lines listed to the my.cnf file. It now says to “connect to mysql ad the (non-root) user and type:” I have no idea how to do this. --------------------------------------------------------------- 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@nlc.state.ne.us http://nlc.state.ne.us/ http://www.travelinlibrarian.info/ --------------------------------------------------------------- _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha Matt Burkhardt, MSTM President Impari Systems, Inc. 401 Rosemont Avenue Frederick, MD 21701 mlb@imparisystems.com www.imparisystems.com (301) 644-3911
Hey Michael, I just did a google search on 'create new user in mysql' and found the answer in the first hit, which took me to the MySQL manual. Cheers, Josh On Fri, Jun 20, 2008 at 8:08 AM, Michael Sauers <msauers@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.
---------------------------------------------------------------
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@nlc.state.ne.us
http://www.travelinlibrarian.info/ ---------------------------------------------------------------
From: Matt Burkhardt [mailto:mlb@imparisystems.com] Sent: Thursday, June 19, 2008 4:44 PM To: Michael Sauers Subject: Re: [Koha] MySQL problem
Hey Michael,
It just means to run some commands within the mysql shell. There are several different ways to do this. Perhaps the easiest is to get to the command line - just open a terminal window (in Linux) or a DOS command window (in Windows) and type:
mysql -u username -p
and it should ask you for the mysql password associated with the username. Enter that, and it will say
mysql>
just enter that line
show variables where variable_name LIKE "character_set%" OR variable_name LIKE "collation%";
and you'll get the list.
On Thu, 2008-06-19 at 13:38 -0500, Michael Sauers wrote:
Ok, next question RE: http://wiki.koha.org/doku.php?id=encodingscratchpad
MySQL – Server Configuration – I've added the four lines listed to the my.cnf file. It now says to "connect to mysql ad the (non-root) user and type:" I have no idea how to do this.
---------------------------------------------------------------
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@nlc.state.ne.us
http://www.travelinlibrarian.info/ ---------------------------------------------------------------
_______________________________________________
Koha mailing list
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
Matt Burkhardt, MSTM President Impari Systems, Inc. 401 Rosemont Avenue Frederick, MD 21701 mlb@imparisystems.com www.imparisystems.com (301) 644-3911
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Joshua Ferraro SUPPORT FOR OPEN-SOURCE SOFTWARE CEO migration, training, maintenance, support LibLime Featuring Koha Open-Source ILS jmf@liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS
Hi Michael, On Fri, Jun 20, 2008 at 1:08 PM, Michael Sauers <msauers@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
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
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@nlc.state.ne.us http://nlc.state.ne.us/ http://www.travelinlibrarian.info/ --------------------------------------------------------------- -----Original Message----- From: newsgroup.posts@gmail.com [mailto:newsgroup.posts@gmail.com] On Behalf Of Ricardo Dias Marques Sent: Friday, June 20, 2008 8:04 AM To: Michael Sauers Cc: mlb@imparisystems.com; koha@lists.katipo.co.nz Subject: Re: [Koha] MySQL problem Hi Michael, On Fri, Jun 20, 2008 at 1:08 PM, Michael Sauers <msauers@nlc.state.ne.us> wrote: 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
Hey Michael, On Fri, Jun 20, 2008 at 10:01 AM, Michael Sauers <msauers@nlc.state.ne.us> wrote:
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? Good points ... we'll probably end up with two versions of the installation documentation at some point:
1. INSTALL.debian (basic install procedures for Debian) 2. Koha Noobie guide (Installing from scratch if you haven't used Linux before) I've gotten several comments from experienced debian users who found that the INSTALL.debian file was too verbose, and needed a summary for those who already know the basics. However, one of our goals is low barrier to entry, so your feedback is useful, thanks! Cheers, -- Joshua Ferraro SUPPORT FOR OPEN-SOURCE SOFTWARE CEO migration, training, maintenance, support LibLime Featuring Koha Open-Source ILS jmf@liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS
Joshua, From my experience, the documentation for installation is pretty good - it's kind of dated with the current Ubuntu version, but overall easy to follow. The big problem comes when you start working with yaz and zebra. The versions Koha requires are not in the current Ubuntu distro, and it kind of goes downhill from there. Is there anything I can do to help? I offered to write up a better installation guide for Michael - but would be happy to post it for everyone. I probably need to get in touch with the yaz and zebra folks. Any other suggestions? On Fri, 2008-06-20 at 10:19 -0400, Joshua Ferraro wrote:
Hey Michael,
On Fri, Jun 20, 2008 at 10:01 AM, Michael Sauers <msauers@nlc.state.ne.us> wrote:
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? Good points ... we'll probably end up with two versions of the installation documentation at some point:
1. INSTALL.debian (basic install procedures for Debian) 2. Koha Noobie guide (Installing from scratch if you haven't used Linux before)
I've gotten several comments from experienced debian users who found that the INSTALL.debian file was too verbose, and needed a summary for those who already know the basics.
However, one of our goals is low barrier to entry, so your feedback is useful, thanks!
Cheers,
Matt Burkhardt, MSTM President Impari Systems, Inc. 401 Rosemont Avenue Frederick, MD 21701 mlb@imparisystems.com www.imparisystems.com (301) 644-3911
Is it not possible to make a universal install? Matt Burkhardt wrote:
Joshua,
From my experience, the documentation for installation is pretty good - it's kind of dated with the current Ubuntu version, but overall easy to follow. The big problem comes when you start working with yaz and zebra. The versions Koha requires are not in the current Ubuntu distro, and it kind of goes downhill from there. [SCHNIPPE]
On Fri, 2008-06-20 at 10:19 -0400, Joshua Ferraro wrote:
Hey Michael,
On Fri, Jun 20, 2008 at 10:01 AM, Michael Sauers <msauers@nlc.state.ne.us <mailto:msauers@nlc.state.ne.us>> wrote:
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:
-- ________________________________________________________________ Rick Welykochy || Praxis Services || Internet Driving Instructor A lie can travel halfway around the world while the truth is putting on its shoes. -- Mark Twain
It says later on that it works with root, so give the root a try. Are you installing this on a Linux server or a Windows server? Are you working on the server or from a client machine? If it's Linux, what flavor? On Fri, 2008-06-20 at 07:08 -0500, Michael Sauers 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.
---------------------------------------------------------------
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@nlc.state.ne.us
http://www.travelinlibrarian.info/ ---------------------------------------------------------------
From: Matt Burkhardt [mailto:mlb@imparisystems.com] Sent: Thursday, June 19, 2008 4:44 PM To: Michael Sauers Subject: Re: [Koha] MySQL problem
Hey Michael,
It just means to run some commands within the mysql shell. There are several different ways to do this. Perhaps the easiest is to get to the command line - just open a terminal window (in Linux) or a DOS command window (in Windows) and type:
mysql -u username -p
and it should ask you for the mysql password associated with the username. Enter that, and it will say
mysql>
just enter that line
show variables where variable_name LIKE "character_set%" OR variable_name LIKE "collation%";
and you'll get the list.
On Thu, 2008-06-19 at 13:38 -0500, Michael Sauers wrote:
Ok, next question RE: http://wiki.koha.org/doku.php?id=encodingscratchpad
MySQL – Server Configuration – I’ve added the four lines listed to the my.cnf file. It now says to “connect to mysql ad the (non-root) user and type:” I have no idea how to do this.
---------------------------------------------------------------
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@nlc.state.ne.us
http://www.travelinlibrarian.info/ ---------------------------------------------------------------
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Matt Burkhardt, MSTM President Impari Systems, Inc. 401 Rosemont Avenue Frederick, MD 21701 mlb@imparisystems.com www.imparisystems.com (301) 644-3911
Matt Burkhardt, MSTM President Impari Systems, Inc. 401 Rosemont Avenue Frederick, MD 21701 mlb@imparisystems.com www.imparisystems.com (301) 644-3911
participants (5)
-
Joshua Ferraro -
Matt Burkhardt -
Michael Sauers -
Ricardo Dias Marques -
Rick Welykochy