[Koha] Installing Koha 3.22 with remote MySQL

Sat Mar 19 01:17:23 NZDT 2016

That is true,

The following elements in koha-conf.xml need to be checked and/or updated:
<database>
<hostname>
<port>
<user>
<pass>

Glad your problem is now solved,

Pedro Amorim

2016-03-18 10:37 GMT-01:00 Hugo Agud <hagud at orex.es>:

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