[Koha] Installing Koha 3.22 with remote MySQL

Sat Mar 19 00:37:45 NZDT 2016

yes, the instance was disabled by defaul....

It works now... the only issue is that it doens't populate propertly the
host info... but modifying koha-conf.xml works fine

thanks!

2016-03-16 21:40 GMT+01:00 Hugo Agud <hagud at orex.es>:

> oh! I will check it asap! thanks
>
> 2016-03-16 21:37 GMT+01:00 Pedro Amorim <pjamorim91 at gmail.com>:
>
>> Hello,
>>
>> Try running:
>> koha-enable <instance_name>
>>
>> For some reason, the remote installation doesn't enable your instance,
>> despite this "Enable a Koha instance. New instances are enabled by
>> default. You only need this command if you have previously disabled a site
>> with koha-disable." in the documentation.
>>
>> Hope it helps,
>>
>> Pedro Amorim
>>
>> 2016-03-15 10:53 GMT-01:00 Hugo Agud <hagud at orex.es>:
>>
>>> 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.
>>> _______________________________________________
>>> Koha mailing list  http://koha-community.org
>>> Koha at lists.katipo.co.nz
>>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>>
>>
>>
>
>
> --
>
> *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.
>
>

-- 

*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.