Today | Next day → | Search | Index
All times shown according to UTC.
| Time | Nick | Message |
|---|---|---|
| 22:41 | alohalog` joined #koha | |
| 22:41 | Topic for #koha is now Welcome to the #koha IRC chat | Code of conduct - https://koha-community.org/abo[…]/code-of-conduct/ | Please use http://paste.koha-community.org for pastes | Installation guide for Koha is https://wiki.koha-community.org/wiki/Debian | |
| 22:41 | stplibrary | ran the command to install form the link |
| 22:42 | sudo apt-get install mariadb-server | |
| 22:42 | The following packages have unmet dependencies: | |
| 22:42 | koha-deps : Depends: mysql-server or virtual-mysql-server | |
| 22:43 | ariadb-server : Depends: mariadb-server-10.0 (>= 10.0.29-0ubuntu0.16.10.1) but it is not going to be installed | |
| 22:43 | E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution). | |
| 22:43 | kathryn joined #koha | |
| 22:44 | Joubu | then try the -f install |
| 22:44 | stplibrary | Just ran it waiting for it to complete :) |
| 22:45 | should I reboot after it installs or try browsing the web to the apache site? | |
| 22:45 | Joubu | wait it to finish before anything :) |
| 22:46 | stplibrary | k lol |
| 22:46 | K its done and browsed the web and now have a db connection software error | |
| 22:46 | DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: Access denied for user 'koha_library'@'localhost' (using password: YES) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1520. at /usr/share/koha/lib/Koha/Database.pm line 90 | |
| 22:48 | Joubu | stplibrary: sorry it's late here and I have to run. The easiest way is to follow the wiki page to install a new Koha install from scratch |
| 22:48 | using the deb package | |
| 22:49 | wizzyrea | yeah you'll do better if you koha-remove library |
| 22:49 | stplibrary | ok no worries thank you for all of your help |
| 22:49 | Joubu | it's very well explained and straightforward |
| 22:49 | stplibrary | really appreciate it :) |
| 22:49 | wizzyrea | then koha-create --create-db library |
| 22:49 | Joubu | then copy your DB |
| 22:49 | wizzyrea | then copy it, and import it |
| 22:50 | stplibrary | do I ahve to copy it then delete it, create a new one then import? |
| 22:50 | wizzyrea | do you still have the original export? |
| 22:50 | stplibrary | yeah I do :) |
| 22:50 | wizzyrea | if you do, then just use that |
| 22:50 | * Joubu | closes the door silently |
| 22:50 | wizzyrea | by Joubu :) |
| 22:50 | bye& | |
| 22:50 | stplibrary | bye thank you |
| 22:51 | K ill try that then when I run it, it says that it already exists. so guessing I need to delete it then? | |
| 22:51 | wizzyrea | did you koha-remove? |
| 22:52 | stplibrary | no i did not |
| 22:52 | wizzyrea | do that first :) |
| 22:53 | stplibrary | ERROR 1133 (42000) at line 1: Can't find any matching row in the user table |
| 22:55 | that is the error I get when I try to remove "library" | |
| 22:56 | TGoat joined #koha | |
| 22:56 | wizzyrea | heh |
| 22:56 | stplibrary | I looked in mysql and the koha_Library is gone. Probably moved to mariaDB? |
| 22:56 | seems to be one thing after another lol | |
| 23:11 | any ideas on getting this to work it wont let me remove the library to re-create it? | |
| 23:17 | wizzyrea | you want to look at creating users and granting permissions in mariadb |
| 23:17 | you kinda did it back to front | |
| 23:17 | before you installed mariadb, you should have koha-remove | |
| 23:17 | but | |
| 23:17 | that's in the past | |
| 23:17 | so now to get you out of it | |
| 23:18 | stplibrary | I do have checkpoints I can revert back to |
| 23:18 | wizzyrea | what you need to do is create a user for koha_library |
| 23:18 | and grant it permissions on the koha_library database | |
| 23:18 | stplibrary | okay whats the best way to do that? :) |
| 23:18 | wizzyrea | the username and password it is expecting are in /etc/koha/sites/library/koha-conf.xmlo |
| 23:18 | xml* towards the bottom | |
| 23:19 | https://www.digitalocean.com/c[…]missions-in-mysql | |
| 23:20 | sorry I have to go away now | |
| 23:20 | stplibrary | thats okay thank you for your help |
| 23:20 | really appreciate it | |
| 23:20 | wizzyrea | but you should be able to get somewhere by making sure the db in koha-conf.xml matches up with a database + user combination that exists in mariadb |
| 23:21 | stplibrary | K I will work on that :) |
| 23:21 | wizzyrea | once you can get sudo koha-mysql library to work |
| 23:21 | you'll know it's time to import your database | |
| 23:21 | stplibrary | are the commands differnet since I am using mariaDB now? |
| 23:21 | for importing? | |
| 23:21 | wizzyrea | nope |
| 23:22 | stplibrary | k sweet have a nice rest of your day or night :) |
| 23:22 | wizzyrea | zcat name-of-your-dump.sql.gz | sudo koha-mysql library |
| 23:22 | or just cat dump.sql | sudo koha-mysql library | |
| 23:22 | if it's not gzipped. | |
| 23:23 | stplibrary | awesome thank you |
| 23:23 | wizzyrea | good luck |
| 23:23 | stplibrary | thanks lol |
| 23:33 | irma joined #koha | |
| 23:50 | Francesca joined #koha |
Today | Next day → | Search | Index