[Koha] Installing Koha 3.22 with remote MySQL

[Hugo Agud]

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.