[Koha] Installing Koha 3.22 with remote MySQL

[Hugo Agud]

Hi Galen

Thanks for your feed back, and yes mysql remote server is accesible via
'mysql --defaults-extra-file=/etc/mysql/koha-common.cnf' we also checked
this before send to the list.

We have been able to link koha to remote mysql server, but by force ;) .. I
thinnk something is missing with populate-db or something in koha is
expecting mysql local , perhaps the socket?

1. We have installed a local MySQL server and create a local instance
2. We have modified koha-conf.xml to target remote database server
3. We have gone to the installer and success now it is working , we have
upload records, create biblio... and koha search all working fine

The error we face with install request-db and populate-db I think that koha
really doesn't know that Mysql remot exist, becasue it shows the
unavailable.html

On the other hand once we have pointed the local to remote database we have
seen a decrease of koha searches even with fasterd ssd discs of 900 iops,
we're going to make some other checks and I will share with you

thanks!!

~

2016-03-14 18:28 GMT+01:00 Galen Charlton <gmc at esilibrary.com>:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA256
>
> Hi,
>
> On Mon, Mar 14, 2016 at 12:57 PM, Hugo Agud  wrote:
> > Yes, this is how we have created the file, but it doesn't
> > work... I suspect that some of the config value are not
> > properly populated...
>
> Does the command
>
> mysql --defaults-extra-file=/etc/mysql/koha-common.cnf
>
> work for you on the Koha application server? (By work, I
> mean successfully open a mysql session to the remote
> server.)
>
> Regards,
>
> Galen
> - --
> Galen Charlton
> Infrastructure and Added Services Manager
> Equinox Software, Inc. / Open Your Library
> email:  gmc at esilibrary.com
> direct: +1 770-709-5581
> cell:   +1 404-984-4366
> skype:  gmcharlt
> web:    http://www.esilibrary.com/
> Supporting Koha and Evergreen: http://koha-community.org & http://evergreen-ils.org
> -----BEGIN PGP SIGNATURE-----
> Version: Mailvelope v1.3.6
> Comment: https://www.mailvelope.com
>
> wsFcBAEBCAAQBQJW5vSOCRATSna3Q9mGMAAAHesQAMd2E0zFW8AOrJFBTlY6
> UQMhrKLT5N6oQE1fNKzdxYOJGWv+bj40DhsIwJTJkmAlnpClsISzDl4CfDI4
> rgM/HeT1hFG4u52S1OPCRQkYTt3s/681+Wny0gscafGB0GOShUsvQGxXcU3g
> MVNzI6MigwKZK4TWU4rIMkcBYjz6G+HT/1izonYHLmHwvfiNxq7+q4qx8spA
> wj+XK4E+gDtsdwg+ifW3B3ArNWZAh0uSe8dimJg1jChd5SVwofCDKBEX6CHb
> xH3gqDEsdFZQxBb2lUkhezq9NvHGFKPq+hfJBRPe/FQZXBfLRg+k6Sj8jZdD
> Y0q1kQtX3ymDiw33At1NQvYun60QZ+K5ZXHcdnkgSzpmOpdWHu01Gx7eMxsT
> UhpyDL2FwNpmW49PvUo6baCnWdU9jSvSdNo50aVgZN+ncGIjwp6PBeAfSaX1
> 9om+zE7SivT5zYf8EiPTvAq9cPWgmjM0SR4yRIDzXi/nLzkG4BO3VxoyI3uM
> h55Czue+SkEOU8kixPwF5EXJU3ynlFCAStyChk0l0HuULbAtGTAwQfrZVXmF
> VpDoCyF8p2Qg9xRNKdv3VI9iC+m2VYu1K8CJo2d4ShHh88ZCv7UE6uSoL5aA
> G7jB3M253wuT/rot9PaWfuSPsD8BRhAteVKPiTo2C8w/pun2osAXiTvf/dqE
> ZzxA
> =zpen
> -----END PGP SIGNATURE-----
>
>


-- 

*Hugo Agud - Orex Digital *

*www.orex.es <http://www.orex.es>*


<http://www.orex.es/>  [image: http://orex.es] <http://orex.es>
<http://www.orex.es>


Director

Passatge de la Llançadera, 3 · 08338 Premià de Dalt - Tel: 93 539 40 70
hagud at orex.es · http://www.orex.es/



No imprima este mensaje a no ser que sea necesario. Una tonelada de papel
implica la tala de 15 árboles y el consumo de 250.000 litros de agua.



Aviso de confidencialidad
Este mensaje contiene información que puede ser CONFIDENCIAL y/o de USO
RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni
está autorizado a recibirlo por el remitente), no está autorizado a copiar,
reenviar o divulgar el mensaje o su contenido. Si ha recibido este mensaje
por error, por favor, notifíquenoslo inmediatamente y bórrelo de su sistema.