Re: [Koha] Software error: Koha Web Installer-MARC21

[Pablo Bianchi]

2017-09-20 8:09 GMT-03:00 Dimitris Antonakis :

> You were right Chris.
> Everything works like a charm using mariadb.
>

​I had some problems installing Koha on Ubuntu 16.04. One was solved
with wizzyrea
advice  of
installing mariadb-server before koha-common. I though that was unimportant.

Other problem was: If you get a timeout, or accidentally clic a second time
on submit button you'll probably get something like
  DBIx::Class::Storage::DBI::_dbh_execute(): Duplicate entry '14-16' for
key 'PRIMARY' at /usr/share/koha/lib/Koha/SearchField.pm line 38
In those cases a I solve it with koha-remove and start again (this work
if plugin='unix_socket' beside this 
).
The timeout of course could be solved with apache2.conf directive.
The later, maybe web installer could disable submit button
(onsubmit="this.submit_button.disabled=true;") and give some feedback of
the status of the process, particularly when creating tables and filling
them with data (in my case 4 and 6 minutes each).

Also, if you use --use-memcached You'll get
  DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: Access
denied for user 'koha_library'@'localhost' (using password: YES)
Was hard to find the solution since koha-shell library was working fine.
The solution: Flush cache: echo flush_all > /dev/tcp/localhost/11211

Best regards,
Pablo
​
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Difficulties getting 17.05.01 to talk with MariaDB under Mint 18.1

[Pablo Bianchi]

2017-06-29 14:56 GMT-03:00 Tim Young :

>
> This page: https://askubuntu.com/questions/766334/cant-login-as-mysql-u
> ser-root-from-normal-user-account-in-ubuntu-16-04


If I  plugin='mysql_native_password'  (Todor answer
) I could get rid of those
[Warning] 'user' entry 'root@localhost' has both a password and an
authentication plugin specified. The password will be ignored.
when `sudo systemctl status mysql.service`. But have a side-effect:
  $ sudo koha-remove library
  Removing Koha instance library
  ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)
So I move back to plugin='unix_socket' and koha-remove now works fine.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha