-
- 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
-
-2.3 Test your SAX Parser and correct where necessary
-
- You must be sure you're using the XML::LibXML SAX parser, not Expat or PurePerl, both of which have outstanding bugs with pre-composed characters. You can test your SAX parser by running:
-
- $ cd koha
- $ misc/sax_parser_print.pl
-
- You should see something like::
-
- XML::LibXML::SAX::Parser=HASH(0x81fe220)
-
- If you're using PurePerl or Expat, you'll need to edit your
- ini file, typically located at:
-
- /etc/perl/XML/SAX/ParserDetails.ini
-
-2.4 Install DBD::mysql Perl module
-
-In order to handle UTF-8 correctly, Koha requires at least version 4.004
-of the DBD::mysql Perl module. However, Debian Etch has a stable package
-only for version 3.0008, so it is necessary to install the module from CPAN.
-DBD::mysql's test suite needs to use a MySQL 'test' DB which doesn't exist
-anymore. So there are two options to install DBD::mysql:
-
- (1) install without test suite,
- (2) install with test suite requiring a test MySQL DB creation.
-
-2.4.1 Install without test suite
-
-Force install DBD::mysql:
-
- $ sudo cpan
- cpan> force install DBD::mysql
-
-2.4.2 Create test database in order to install DBD::mysql
-
-Because of DBD::mysql's test suite, it is necessary to temporarily create a
-test database and user:
-
- $ mysql -uroot -p<password>
-
- Create the database and user with associated privileges: