-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:
-
- 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> create database test;
- Query OK, 1 row affected (0.00 sec)
-
- mysql> grant all on test.* to 'test'@'localhost' identified by 'test';
- Query OK, 0 rows affected (0.00 sec)
- (test database, user, and password can be different if need be)
-
- mysql> flush privileges;
- Query OK, 0 rows affected (0.00 sec)
-
- mysql> quit
-
-Next install DBD::mysql:
-
- $ sudo cpan
-
- cpan> o conf makepl_arg
- (get current value of this CPAN parameter)
-
- cpan> o conf makepl_arg "--testdb=test --testuser=test --testpass=test"
-
- cpan> install DBD::mysql
-
- cpan> o conf makepl_arg ''
-
- OR
-
- cpan> o conf makepl_arg '<old setting>'
-
- (restore this setting so as to not interfere with future CPAN installs).
-
-
-Finally, remove the test database:
-
- $ mysql -uroot -p<password>
-
- mysql> drop database test;
- Query OK, 1 row affected (0.00 sec)
-
- mysql> exit
- Bye